我写了这个小代码。如何在excel中删除“小时”计时?请看下面的截图。
import os
import yfinance
import pandas as pd
from openpyxl import Workbook
from openpyxl import load_workbook
a=yfinance.download('CS.PA', interval='1mo')
print(a)
save_name="C:\\Users\\Lex02\\Desktop\\Python2\\Bourse essai_3.xlsx"
a.to_excel(save_name)
a_excel=load_workbook(filename=save_name)
ws=a_excel.active
os.system('pause')

谢谢!
发布于 2021-10-01 22:07:30
设置索引格式:
a = yfinance.download('CS.PA', interval='1mo')
a.index = a.index.strftime('%Y-%m-%d') # Enter whatever format herehttps://stackoverflow.com/questions/69412117
复制相似问题