合并最近的回溯时间戳并向前填充pandas

import pandas as pd

# 假设有两个时间戳记录的DataFrame
df1 = pd.DataFrame({'timestamp': ['2022-01-01 10:00:00', '2022-01-01 11:00:00', '2022-01-01 12:00:00'],
                    'value1': [1, 2, 3]})
df2 = pd.DataFrame({'timestamp': ['2022-01-01 11:00:00', '2022-01-01 13:00:00'],
                    'value2': [4, 5]})

# 将时间戳记录按照时间顺序进行排序
df1['timestamp'] = pd.to_datetime(df1['timestamp'])
df2['timestamp'] = pd.to_datetime(df2['timestamp'])
df1 = df1.sort_values('timestamp')
df2 = df2.sort_values('timestamp')

# 合并时间戳记录
merged_df = pd.merge(df1, df2, on='timestamp', how='outer')

# 向前填充缺失的时间戳
merged_df = merged_df.fillna(method='ffill')

print(merged_df)