在pandas中从dataframe中选择datetime

import pandas as pd

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

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

# 选择特定日期的行
selected_rows = df[df['date'] == pd.to_datetime('2022-01-02')]
print(selected_rows)

import pandas as pd

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

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

# 使用.loc[]方法选择特定日期的行
selected_rows = df.loc[df['date'] == pd.to_datetime('2022-01-02')]
print(selected_rows)

import pandas as pd

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

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

# 使用.between()方法选择特定日期范围内的行
selected_rows = df[df['date'].between('2022-01-01', '2022-01-02')]
print(selected_rows)