利用mplfinance库画K线图

import pandas as pd
import mplfinance as mpf

#df.set_index('trade_date',inplace=True)
#df_idx = df.index.values
#print(df_idx)

io = r'000625.xlsx'
df1 = pd.read_excel(io)

#data.head()
#df['trade_date'] = pd.to_datetime(df['trade_date'])


#df.index.name='trade_date'
#df.set_index('trade_date')
cols=['trade_date','open','high','low','close','volume']
df2=df1[cols]
df3=df2[-100:]
df=df3.set_index('trade_date')
df.sort_index()
#print(df)

df.index.name='date'

#print(df)
mpf.plot(df,type='candle',mav=(3,6,9),volume=True)
#df.plot()

结果：