且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

Python Pandas添加文件名列CSV

更新时间:2023-12-04 19:52:28

这应该有效:

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.

frame['filename'] creates a new column named filename and os.path.basename() turns a path like /a/d/c.txt into the filename c.txt.