查找两个时间点中间的行DataFrame
比如要寻找DataFrame中"2004/4/2 15:00:00"到"2004/4/2 16:00:00"中的所有行
import datetime
import pandas as pd
from pandas import DataFrame
time = "2004/4/2 16:00:00"
time = pd.to_datetime(time)
t = time+datetime.timedelta(hours=-1) # 减去一个小时
# print(time)
# print(t)
df = {'TIME': ["2004/4/2 14:00:00", "2004/4/2 15:00:00", "2004/4/2 15:30:00", "2004/4/2 16:00:00"],
'age': [3, 4, 5, 6]}
df = DataFrame(df)
print(df)
# print("type(time):", type(time))
# print("type(t):", type(t))
df['TIME'] = pd.to_datetime(df['TIME'])
# print("type(df['TIME']):", type(df['TIME']))
f = df[(t <= df['TIME']) & (df['TIME'] < time)]
print(f)
d = df[df['TIME'].between(t, time, inclusive='left')]
print(d)