导出为 .xlsx 文件

  1. import pandas as pd
  3. df1 = pd.read_excel(r"test_11_01.xlsx")
  5. # 定义导出路径
  6. df1.to_excel(excel_writer = r"test_12.xlsx", # 设置导出路径
  7.              sheet_name="test_12_02",  # 设置表名
  8.              index=False,  # 设置默认索引
  9.              columns = ['A1', 'A2'],  # 设定导出列
  10.              encoding = 'utf-8', # 设置解码器
  11.             na_rep = 0, # 缺失值的替换值
  12.             inf_rep = 1) # 无穷值的替换值
  14. df2 = pd.read_excel(r"test_12.xlsx")
  15. df2
  1. # 导出到同一工作簿中的多个表
  2. writer = pd.ExcelWriter(r"test_12_01.xlsx", engine= 'xlsxwriter')
  4. df1.to_excel(writer, sheet_name="table_1")
  5. df2.to_excel(writer, sheet_name="table_2")
  6. df3.to_excel(writer, sheet_name="table_3")
  8. writer.save()
  10. df4 = pd.read_excel(r"test_12_01.xlsx", sheet_name='table_3')
  11. df4

导出为 .csv 文件

  1. df1.to_csv(path_or_buf = r"test_12.csv",
  2.           index = False,
  3.           columns = ['A1', 'A2'],
  4.           sep = ',',
  5.           na_rep = 0,
  6.           encoding = 'utf-8-sig')
  7. df3 = pd.read_csv(r"test_12.csv")
  8. df3