一、pandas的用法:
导入包:
1)import pandas as pd
读取文件:
1)读取csv文件:pd.read_csv("./submission.csv",dtype ='',usecols= '' )
2)读取excel文件:pd.read_excel("./成绩.xlsx", sheet_name = 'Sheet1' )
3)相关的参数:dtype = str #用字符串的方式读取
usecols = ['problem_id','author','difficulty','type']#读取文件中的指定列
写入文件:
1)格式化:df = {'列名':[]} -> df = pd.DataFrame(df)
2)写入excel:df.to_excel('C:\\Users\\ASUS\\Desktop\\foo.xlsx', sheet_name = 'Sheet1' )
3)批量写入:
with pd.ExcelWriter('待写入文件名.xlsx') as writer:
df1.to_excel(writer, sheet_name='Sheet1') #写入表一
df2.to_excel(writer, sheet_name='Sheet2') #写入表二