Python Pandas在加载时按日期过滤

import pandas as pd

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

# 将日期列转换为Datetime类型，并设置为索引
df['date'] = pd.to_datetime(df['date'])
df.set_index('date', inplace=True)

# 按日期过滤数据
filtered_data = df['2022-01-02':'2022-01-03']

import pandas as pd

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

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

# 按条件过滤数据
filtered_data = df[df['date'] >= '2022-01-02']

import pandas as pd

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

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

# 使用日期函数过滤数据
filtered_data = df[df['date'].dt.dayofweek < 5]  # 过滤掉周末的数据