使用索引日期时间从pandas dataframe创建json

import pandas as pd

data = {'Date': ['2022-01-01', '2022-01-02', '2022-01-03'],
        'Value': [10, 20, 30]}
df = pd.DataFrame(data)
df['Date'] = pd.to_datetime(df['Date'])  # 将日期列转换为日期时间类型
df.set_index('Date', inplace=True)  # 将日期列设置为索引

json_data = df.to_json(orient='index')

with open('data.json', 'w') as file:
    file.write(json_data)