雪一更--data science--python--excel

目的：记录python excel 交互操作

1. pip intall opennpyxl

缺失该依赖则报错：

 

 

项目中添加

 

示例：

 1 import pandas as pd
 2 import openpyxl
 3 
 4 if __name__ == "__main__":
 5 
 6     stuID = [50101, 50102, 50103, 50104, 50105]
 7     name = ['nm1','nm2','nm3','nm4','nm5']
 8     chinese = [75,26,75,34,78]
 9     maths = [67,86,67, 8,56]
10     english = [86,57,56,98,75]
11     data1 = {'grade':stuID,
12              'name':name,
13              'chinese':chinese,
14              'math':maths,
15              'english':english}
16     pd.DataFrame(data1).to_excel(r'D:\tmp\dataFile\result.xlsx',sheet_name='Sheet1',index= False);

 

posted @ 2022-07-13 14:30  君子之行  阅读(8)  评论(0)    收藏  举报