Question

python一次导入多个csv文件后的命名问题

通过os.walk和pandas.read_csv可以打开同一目录下的若干个csv文件。
但现在想在导入文件时，同时让DataFrame在python里面依次这样命名：data1,data2,data3....
怎样实现呢？

Answer 1

#coding=utf-8
import os
import pandas as pd
import glob

def hebing():
csv_list = glob.glob('*.csv')
print(u'共发现%s个CSV文件'% len(csv_list))
print(u'正在处理............')
for i in csv_list:
fr = open(i,'r').read()
with open('haha.csv','a') as f:
f.write(fr)
print(u'合并完毕！')

def quchong(file):
df = pd.read_csv(file,header=0)
datalist = df.drop_duplicates()
datalist.to_csv(file)

if __name__ == '__main__':
hebing()
quchong("haha.csv")