在两个日期之间添加行

import pandas as pd
from datetime import timedelta

# 初始数据集
data = {
    'Date': ['2023-01-01', '2023-01-10'],
    'Value': [100, 200]
}
df = pd.DataFrame(data)
df['Date'] = pd.to_datetime(df['Date'])

# 定义日期范围
start_date = df['Date'].min()
end_date = df['Date'].max()

# 在两个日期之间按天插入行
new_rows = []
current_date = start_date
while current_date <= end_date:
    if not df[df['Date'] == current_date].empty:
        new_rows.append(df[df['Date'] == current_date])
    else:
        new_rows.append({'Date': current_date, 'Value': None})
    current_date += timedelta(days=1)

result_df = pd.DataFrame(new_rows)
print(result_df)