pandas to excel
填充颜色
excel = dataframe.style.background_gradient(cmap=‘RdBu’,low=0.5,high=0.5,axis=0)
excel.to_excel(name+’.xlsx’)
样式cmap:https://matplotlib.org/examples/color/colormaps_reference.html
axis=0 按列填充
或用pd.excelWriter()
excel = dataframe.style.background_gradient(cmap=‘RdBu’,low=0.5,high=0.5,axis=0)
excel.to_excel(name+’.xlsx’)
样式cmap:https://matplotlib.org/examples/color/colormaps_reference.html
axis=0 按列填充
或用pd.excelWriter()