按date筛选pandas数据帧< date在索引中的另一个日期

import pandas as pd

# 创建一个示例数据帧
data = {'date': ['2022-01-01', '2022-01-02', '2022-01-03', '2022-01-04'],
        'value': [1, 2, 3, 4]}
df = pd.DataFrame(data)

# 将日期列转换为日期时间类型
df['date'] = pd.to_datetime(df['date'])

# 按日期筛选数据帧
filtered_df = df[df['date'] < '2022-01-03']

filtered_df = df[(df['date'] > '2022-01-01') & (df['date'] < '2022-01-03')]