import akshare as ak

import pandas as pd
import datetime
import numpy
import os, sys
import nodejs
# 调用akshare库的API接口获取数据
df = stock_zh_index_daily_df = ak.stock_zh_index_daily(symbol="1A0001")
print(stock_zh_index_daily_df)
df = df.reset_index()
        # 修改名字
df.columns = [x.upper() for x in df.columns]
df.rename(columns={"DATE": "index"}, inplace=True)
df = df[df['OPEN'].notnull()]
with pd.ExcelWriter('D:\jiangtingrui1\股票交易信息'+'XY'+'.xlsx') as writer:
    df.to_excel(writer, index=False, sheet_name='Sheet1')