pandas 如何使用pandas读取目录中所有文件的内容？

How can I read the contents of all the files in a directory with pandas?

提问by newWithPython

I have a folder with lots of .txtfiles. How can I read all the files in the folder and get the content of them with pandas?. I tried the following:

我有一个文件夹，里面有很多.txt文件。如何读取文件夹中的所有文件并使用 Pandas 获取它们的内容？我尝试了以下方法：

import pandas as pd
list_=pd.read_csv("/path/of/the/directory/*.txt",header=None)
print list_

回答by elyase

Something like this:

像这样的东西：

import glob

l = [pd.read_csv(filename) for filename in glob.glob("/path/*.txt")]
df = pd.concat(l, axis=0)

You have to take into account the header, for example if you want to ignore it take a look at the skiprows option in read_csv.

你如果要忽略它看一看在skiprows选项，考虑到头部，例如read_csv。