概述
import pandas as pd import glob globbed_files = glob.glob("*.csv") #creates a list of all csv files data = [] # pd.concat takes a list of dataframes as an agrument for csv in globbed_files: frame = pd.read_csv(csv) data.append(frame) bigframe = pd.concat(data,ignore_index=True) #dont want pandas to try an align row indexes bigframe.to_csv("Pandas_output2.csv")
import os for csv in globbed_files: frame = pd.read_csv(csv) frame['filename'] = os.path.basename(csv) data.append(frame)
frame [‘filename’]创建一个名为filename的新列,os.path.basename()将类似/a/d/c.txt的路径转换为文件名c.txt.
总结
以上是编程之家为你收集整理的Python Pandas添加Filename Column CSV全部内容,希望文章能够帮你解决Python Pandas添加Filename Column CSV所遇到的程序开发问题。
如果您也喜欢它,动动您的小指点个赞吧