读取文件夹中多个文件名
# import the library
import glob
# list all the files in the folder
for directory in glob.glob('datasets/multi-directory/*'):
print(directory)
# iterate through each of the files
for directory in glob.glob('datasets/multi-directory/*'):
for files in glob.glob(directory + '/*'):
print(files)
批量合并CSV文档
# list to store data frames
data_frame_list = []
# iterate through each folder
for directory in glob.glob('datasets/multi-directory/*'):
# iterate through each file
for files in glob.glob(directory + '/*'):
# read and append the data frame
data_frame_list.append(pd.read_csv(files))
# concatenate the dataframes
final_data = pd.concat(data_frame_list)