Python数据分析--结果导出

导出为.xlsx文件

设置文件导出路径

df.to_excel(excel_writer = r'/Users/faye/Desktop/python学习/test导出.xlsx')

设置Sheet名称

df.to_excel(excel_writer = r'/Users/faye/Desktop/python学习/test导出.xlsx', sheet_name = '测试')

设置索引

index = False去掉自然索引

df.to_excel(excel_writer = r'/Users/faye/Desktop/python学习/test导出.xlsx', sheet_name = '测试',index = False)

设置要导出的列

df.to_excel(excel_writer = r'/Users/faye/Desktop/python学习/test导出.xlsx', sheet_name = '测试',index = False, columns = ['年龄','性别')

设置编码格式

df.to_excel(excel_writer = r'/Users/faye/Desktop/python学习/test导出.xlsx', sheet_name = '测试',index = False, columns = ['年龄','性别'],encoding = 'utf-8')

缺失值处理

df.to_excel(excel_writer = r'/Users/faye/Desktop/python学习/test导出.xlsx', sheet_name = '测试',index = False, na_rep = 0)   #缺失值填充为0

无穷值处理

df.to_excel(excel_writer = r'/Users/faye/Desktop/python学习/test导出.xlsx', sheet_name = '测试',index = False, inf_rep = 0)   #无穷值填充为0

导出.csv文件

设置文件导出

df1.to_csv(path_or_buf =r'/Users/faye/Desktop/python学习/test导出.csv')

设置索引

df.to_csv(path_or_buf = r'/Users/faye/Desktop/python学习/test导出.csv',index =False)

设置要导出的列

df.to_csv(path_or_buf = r'/Users/faye/Desktop/python学习/test导出.csv',index =False,columns = ['年龄','性别'])

设置分割符号

df.to_csv(path_or_buf = r'/Users/faye/Desktop/python学习/test导出.csv',index =False,columns = ['年龄','性别'],sep = ',')

缺失值处理

df.to_csv(path_or_buf = r'/Users/faye/Desktop/python学习/test导出.csv',index =False,columns = ['年龄','性别'],sep = ',', na_rep = 0)

设置编码格式

df.to_csv(path_or_buf = r'/Users/faye/Desktop/python学习/test导出.csv',index =False,columns = ['年龄','性别'], I encoding = 'utf-8-sig')

将文件导出到多个Sheet

# 声明一个读写对象
# excelpath为文件要存放的路径
writer = pd.ExcelWriter(excelpath,engine = 'xlsxwriter')
# 分别将表df1、df2、df3写入Excel中的sheet1、sheet2、sheet3
# 命名为表1、表2、表3
df1.to_excel(writer,sheet_name = '表1')
df2.to_excel(writer,sheet_name = '表2')
df3.to_excel(writer,sheet_name = '表3')
# 保存读写的内容
writer.save()