python编程问题，怎样运用python画图和做表格
请以湖北省高院 2009 年至 2014 年六年期间再审改判、发回重审的 175件案件，创建表格，并将所创建的表格存储的文件名为：2009-2014年度改判发回案件总体情况.xlsx”，存放于 F:\python 文件夹中。
表格建立的不好，而且图也画不出来
使用pandas创建表格，绘出柱状图并保存到excel中：
import pandas as pd
import matplotlib.pyplot as plt
data = [
[30,31,34,26,32,22],
[17,21,18,10,15,13],
[2,3,5,3,8,2],
[5,4,3,4,2,2],
[5,6,6,7,8,4],
[1,0,1,2,0,1]
]
df=pd.DataFrame(data,index=["总案件数","减轻","加重","宣告无罪","发回重审","其他"],columns=["2009","2010","2011","2012","2013","2014"],)
#print(df)
writer = pd.ExcelWriter('2009-2014年度改判发回案件总体情况.xlsx', engine='xlsxwriter')
df.to_excel(writer,'Sheet1')
wb = writer.book
ws = writer.sheets['Sheet1']
chart = wb.add_chart({'type': 'column'})
colors = ['#E41A1C', '#377EB8' , '#4DAF4A', '#984EA3', '#FF7F00','#d2ff1d']
for col_num in range(1, len(df.columns) + 1):
chart.add_series({
'name': ['Sheet1', 0, col_num],
'categories': ['Sheet1', 1, 0, 6, 0],
'values': ['Sheet1', 1, col_num, 6, col_num],
'fill': {'color': colors[col_num - 1]},
'overlap': -10,
})
chart.set_x_axis({'name': '类别'})
chart.set_y_axis(
{'name': 'data', 'major_gridlines': {'visible': False}})
chart.set_size({'width': 900, 'height': 400})
ws.insert_chart('I2', chart)
writer.save()
运行结果：
如有帮助，请点采纳。
import openpyxl
data = [
["","2009","2010","2011","2012","2013","2014"],
["总案件数",30,31,34,26,32,22],
["减轻",17,21,18,10,15,13],
["加重",2,3,5,3,8,2],
["宣告无罪",5,4,3,4,2,2],
["发回重审",5,6,6,7,8,4],
["其他",1,0,1,2,0,1]
]
wb = openpyxl.Workbook()
ws=wb.active
ws.title = "2009-2014年度改判发回案件总体情况"
for each in data:
ws.append(each)
wb.save(r"F:/python/2009-2014年度改判发回案件总体情况.xlsx")
注意F:/python文件夹需要你自己创建好
你好！
参考代码如下，题主可以参考改需要保存的数据及保存文件的路径
如有帮助，请采纳！
import pandas as pd
# 创建DataFrame对象
data = pd.DataFrame({ 'k1':['one','two'] * 3 + ['two'],'k2':[1, 1, 2, 3, 1, 4, 4] ,'k3':[1,1,5,2,1, 4, 4] })
print(data)
# 导出文件
path = r'D:\大三\大三下\test\测试文件.xlsx'
data.to_excel(path)
运行的结果如下：
PS：问答VIP年卡 【限时加赠：IT技术图书免费领】，了解详情>>> https://vip.csdn.net/askvip?utm_source=1146287632