由直接导出变成日K标准快照数据

import pandas as pd
import os
import datetime
#增加当天的交易时间
today = datetime.date.today()
print(today)
folder_path = 'D:\\tmp_financial\DailyK\increment_data\HS20240125.xlsx'
folder_path2 = 'D:\\tmp_financial\DailyK\standard'
df = pd.read_excel(folder_path)
col_names = df.columns.tolist()
print(col_names)
df.drop('名称', axis=1, inplace=True)
df.drop('主力净流入量占比', axis=1, inplace=True)
df.drop('大单流入量', axis=1, inplace=True)
df.drop('融券余额', axis=1, inplace=True)
df.drop('融资余额', axis=1, inplace=True)
df.drop('资产回报率', axis=1, inplace=True)
df.drop('市销率(TTM)', axis=1, inplace=True)
df.drop('资产负债率', axis=1, inplace=True)
df.drop('年初至今', axis=1, inplace=True)
df.drop('成交笔数', axis=1, inplace=True)
df = df.rename(columns={'代码': '证券代码'})
df['交易时间'] = today
df = df.rename(columns={'现价': '收盘价'})
df = df.rename(columns={'前收': '前收盘价'})
df = df.rename(columns={'今开': '开盘价'})
df = df.rename(columns={'最高': '最高价'})
df = df.rename(columns={'最低': '最低价'})
df = df.rename(columns={'成交量': '成交量(手)'})
df = df.rename(columns={'换手率': '换手率（%）'})
df = df.rename(columns={'市盈率(TTM)': '市盈率（TTM，亏损的PE为空）'})
df = df.rename(columns={'流通市值': '流通市值（万元）'})
col_names = df.columns.tolist()
print(col_names)
col_names = [col_names[0], col_names[17], col_names[3], col_names[4], col_names[5], col_names[1], col_names[2],
             col_names[6], col_names[7], col_names[8], col_names[9], col_names[10], col_names[14],
             col_names[12], col_names[13], col_names[16], col_names[15], col_names[11]]
print(col_names)
df['成交量(手)'] = df['成交量(手)']/100
df['流通市值（万元）'] = df['流通市值（万元）']/10000
df['换手率（%）'] = df['换手率（%）']*100
df = df.reindex(columns=col_names)
with pd.ExcelWriter('D:\\tmp_financial\DailyK\standard_camera\HS20240125.xlsx', mode='a', engine='openpyxl') as writer:
    df.to_excel(writer, index=False)