遍历多个 CSV 并创建所有 CSV 组合的数据帧

Question

我正在尝试使用多个CSV文件创建数据帧。为此，我创建了一个for循环，但它只运行一次。

所有数据已以CSV格式下载。

csvs = [
"2014-2015.csv",
"2015-2016.csv",
"2016-2017.csv",
"2017-2018.csv",
"2018-2019.csv",
"2019-2020.csv",
"2020-2021.csv",
"2021-2022.csv"
]

for csv in csvs: 
data = pd.read_csv(csv)
data_final = pd.DataFrame()
data_final = data_final.append(data)

Answer 1

你可以这样做:

import pandas as pd
csv_files = [
'2014-2015.csv',
'2015-2016.csv',
'2016-2017.csv',
'2017-2018.csv',
'2018-2019.csv',
'2019-2020.csv',
'2020-2021.csv',
'2021-2022.csv'
]
combined_df = pd.concat([pd.read_csv(_) for _ in csv_files])

Answer 2

您必须将csv文件附加为数据帧，然后合并它们

csvs = [ "2014-2015.csv", "2015-2016.csv", "2016-2017.csv", "2017-2018.csv", "2018-2019.csv", "2019-2020.csv", "2020-2021.csv", "2021-2022.csv" ]
list_of_dataframes = []
for filename in csvs :
list_of_dataframes.append(pd.read_csv(filename))
merged_df = pd.concat(list_of_dataframes)
print(merged_df)