如题,最近工作关係,需要将结果汇出作为报告,因此上网查了下如何将pandas的table变成图档储存
# 汇入库import matplotlib.pyplot as pltimport pandas as pdimport numpy as np# 用Numpy建立样本table = np.random.rand(10, 5)table = np.round(table, 2)# 用Pandas将样本转成DataFrametable_pd = pd.DataFrame(table)table_pd.columns=['A', 'B', 'C', 'D', 'E']table_pd.index=['a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j']# DataFrame=>pngplt.figure('123') # 视窗名称ax = plt.axes(frame_on=False)# 不要额外框线ax.xaxis.set_visible(False) # 隐藏X轴刻度线ax.yaxis.set_visible(False) # 隐藏Y轴刻度线pd.plotting.table(ax, table_pd, loc='center') #将mytable投射到ax上,且放置于ax的中间plt.savefig('table.png') # 存档
参考文献:
How to save a pandas DataFrame table as a png