0109-【课程实战】-Python数据分析炒菜-第12章——盛菜装盘——结果导出

---

12.1 导出为.xlsx文件

另存为

导出

12.1.1 设置文件导出路径

12.1.2 设置Sheet名称

df.to_excel(excel_writer = r"C:\Users\leadi\Python\01.python\input\train-pivot3.xlsx",sheet_name = "test1")

输出

12.1.3 设置索引

df.to_excel(excel_writer = r"C:\Users\leadi\Python\01.python\input\train-pivot3.xlsx",sheet_name = "test1",index = False)

12.1.4 设置要导出的列

df.to_excel(excel_writer = r"C:\Users\leadi\Python\01.python\input\train-pivot3.xlsx",sheet_name = "test1",index = False,columns = ["用户ID","区域"])

12.1.5 设置编码格式

df.to_excel(excel_writer = r"C:\Users\leadi\Python\01.python\input\train-pivot3.xlsx",sheet_name = "test1",index = False,columns = ["用户ID","区域"],encoding = "utf-8")

12.1.6 缺失值处理

缺失值填充为0

df.to_excel(excel_writer = r"C:\Users\leadi\Python\01.python\input\train-pivot3.xlsx",sheet_name = "test1",index = False,columns = ["用户ID","区域"],encoding = "utf-8",na_rep = 0)

12.1.7 无穷值处理

# 生成正无穷
float("inf")
# 生成负无穷
float("-inf")

df.to_excel(excel_writer = r"C:\Users\leadi\Python\01.python\input\train-pivot3.xlsx",sheet_name = "test1",index = False,columns = ["用户ID","区域"],encoding = "utf-8",na_rep = 0,inf_rep = 0)

---

12.2 导出为.cvs文件

12.2.1 设置文件路径

12.2.2 设置索引

12.2.3 设置导出的列

12.2.4 设置分隔符号

12.2.5 缺失值处理

12.2.6 设置编码格式

df.to_csv(path_or_buf = r"C:\Users\leadi\Python\01.python\input\train-pivot3.xlsx",sheet_name = "test1",index = False,columns = ["用户ID","区域"],sep =",",encoding = "utf-8",na_rep = 0)

utf-8格式乱码

encoding = "utf-8-sig"中文显示正确

df.to_csv(path_or_buf = r"C:\Users\leadi\Python\01.python\input\train-pivot5.csv",index = False,columns = ["用户ID","区域"],sep =",",encoding = "utf-8-sig",na_rep = 0)

12.3 将文件导出到多个Sheet

df1 = df
df2 = df
df3 = df
writer = pd.ExcelWriter(r"C:\Users\leadi\Python\01.python\input\train-pivot5.xlsx",engine = "xlsxwriter")
df1.to_excel(writer,sheet_name = "表1",index =False)
df2.to_excel(writer,sheet_name = "表2",index =False)
df3.to_excel(writer,sheet_name = "表3",index =False)
writer.save()