建议用pandas来做,数据可以从xlsx文件来读取,调用 pd.read_excel import pandas as pd
def data():
rows = [
["商品名称1", "2023/4/1 11:11:46", "2023/4/1 15:11:46"],
["商品名称2", "2023/4/2 11:11:46", "2023/4/2 15:11:46"],
["商品名称3", "2023/4/3 11:11:46", "2023/4/3 15:11:46"],
["商品名称31", "2023/4/3 12:05:01", "2023/4/3 14:10:06"],
["商品名称4", "2023/4/4 11:11:46", "2023/4/4 15:11:46"]
]
for row in rows:
row[1] = pd.to_datetime(row[1])
row[2] = pd.to_datetime(row[2])
return pd.DataFrame(rows, columns=["名称", "开始日期", "结束日期"])
# df = pd.read_excel(r"aaaa_s.xlsx")
df = data()
for t in df.itertuples():
index, name, start_time, end_time = t
print(t)
# and index!=@index
search = df.query("@start_time>=开始日期 and 结束日期 |