比较DataFrame中的范围和连接匹配项之间的日期

import pandas as pd

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

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

# 打印DataFrame
print(df)

        date  value
0 2022-01-01      1
1 2022-01-02      2
2 2022-01-03      3
3 2022-01-04      4

# 筛选出日期在2022-01-02和2022-01-03之间的行
filtered_df = df[(df['date'] >= '2022-01-02') & (df['date'] <= '2022-01-03')]

# 打印筛选结果
print(filtered_df)

        date  value
1 2022-01-02      2
2 2022-01-03      3

# 创建第二个示例DataFrame
data2 = {'date': ['2022-01-02', '2022-01-04'],
         'value2': ['A', 'B']}
df2 = pd.DataFrame(data2)

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

# 使用连接匹配项连接两个DataFrame
merged_df = pd.merge(df, df2, on='date')

# 打印连接匹配项结果
print(merged_df)

        date  value value2
0 2022-01-02      2      A
1 2022-01-04      4      B