search

JiaxiangBU / tutoring2

The collection of Python and R code scripts to tutor others.
https://jiaxiangbu.github.io/tutoring2/
Other
8 stars 7 forks source link

python 批量导出和导入 #48

Closed slsongge closed 4 years ago

slsongge commented 4 years ago

问题

如何在python中，批量导出n个数据框为csv或者xlsx格式？

数据框格式

每个数据框的列名完全相同

目前实现方法

image

JiaxiangBU commented 4 years ago

参考

  1. jinxiaosong/concatenate-csv.ipynb

这是假设的三个表格

  1. jinxiaosong/data/df1.csv
  2. jinxiaosong/data/df2.csv
  3. jinxiaosong/data/df3.csv

批量导入，主要就是 for 循环加上 append 完成就好了。 批量导出，主要就是 pd.DataFrame.groupby 加上 for 循环

导出文件如

  1. jinxiaosong/data/outputdf1.csv.csv
  2. jinxiaosong/data/outputdf2.csv.csv
  3. jinxiaosong/data/outputdf3.csv.csv
for idx, i in df.groupby('groups'):
    file_name = 'output' + str(idx) + '.csv'
    i.to_csv(os.path.join('data',file_name))

@slsongge