根据时间戳列过滤数据帧

pip install pandas

import pandas as pd

# 创建一个示例数据帧
data = {
    'timestamp': [
        '2021-01-01 00:00:00',
        '2021-01-02 00:00:00',
        '2021-01-03 00:00:00',
        '2021-01-04 00:00:00',
        '2021-01-05 00:00:00'
    ],
    'value': [1, 2, 3, 4, 5]
}

df = pd.DataFrame(data)

# 将时间戳列转换为datetime类型
df['timestamp'] = pd.to_datetime(df['timestamp'])

# 定义过滤的时间范围
start_date = '2021-01-02 00:00:00'
end_date = '2021-01-04 00:00:00'

# 根据时间戳列过滤数据帧
filtered_df = df[(df['timestamp'] >= start_date) & (df['timestamp'] <= end_date)]

print(filtered_df)

            timestamp  value
1 2021-01-02 00:00:00      2
2 2021-01-03 00:00:00      3
3 2021-01-04 00:00:00      4