Matplotlib绘制表格

df1 = pd.read_sql(sql,task)   #
plt.figure(figsize=(12,5))
tab = plt.table(cellText=df1.values, 
              colLabels=df1.columns, 
              colWidths=[0.1,0.5,0.1,0.1,0.1],#设置每列的宽度
              colColours = plt.cm.Reds([0.35]*df1.shape[1]), 
              loc='center', 
              cellLoc='center',
              rowLoc='center')
tab.scale(1,2) 
tab.auto_set_font_size(True)
plt.subplots_adjust(wspace=0.1, hspace = 0.1)
plt.title("近7天使用次数Top10 SQL模板统计",fontsize = 14)
plt.axis('off')
plt.savefig('rank.png',dpi = 144,bbox_inches = 'tight')

table函数只有美化标题的方法，美化单元格参考https://matplotlib.org/api/table_api.html