如何在pandas数据帧中的日期时间范围之间进行过滤

import pandas as pd

# 创建一个示例数据帧
df = pd.DataFrame({
    'date': pd.date_range(start='2022-01-01', end='2022-01-10'),
    'value': [1, 2, 3, 4, 5, 6, 7, 8, 9, 10]
})

# 使用query方法进行过滤
start_date = '2022-01-03'
end_date = '2022-01-07'
filtered_df = df.query('date >= @start_date and date <= @end_date')

print(filtered_df)

        date  value
2 2022-01-03      3
3 2022-01-04      4
4 2022-01-05      5
5 2022-01-06      6
6 2022-01-07      7

import pandas as pd

# 创建一个示例数据帧
df = pd.DataFrame({
    'date': pd.date_range(start='2022-01-01', end='2022-01-10'),
    'value': [1, 2, 3, 4, 5, 6, 7, 8, 9, 10]
})

# 使用布尔索引进行过滤
start_date = '2022-01-03'
end_date = '2022-01-07'
filtered_df = df[(df['date'] >= start_date) & (df['date'] <= end_date)]

print(filtered_df)

        date  value
2 2022-01-03      3
3 2022-01-04      4
4 2022-01-05      5
5 2022-01-06      6
6 2022-01-07      7