我尝试使用 pandas 在 python 中加载我的所有数据集文件,但未显示结果。
import os
print(os.listdir("C:/Users/Smile/.spyder-py3/datasets"))
# Any results you write to the current directory are saved as output.
data = ["name","version","tool_name","wmc","dit","noc","cbo","rfc","lcom","ca","ce","npm","lcom3","loc","dam","moa","mfa","cam","ic","cbm","amc","max_cc","avg_cc","bug"]
data = pd.DataFrame()
for file in os.listdir():
if file.endswith('.csv'):
data = pd.read_csv(file)
data.set_index('name',inplace = True)
data = data.append(data, ignore_index=True
)
print(data.head(5))
************************************************************************
My output is given below:
Empty DataFrame
Columns: []
Index: []
请您参考如下方法:
每次读取新的 CSV 时都会覆盖数据
将 data 变量替换为临时变量,如下所示:
data = pd.DataFrame()
for file in os.listdir():
if file.endswith('.csv'):
csv_data = pd.read_csv(file)
csv_data.set_index('name',inplace = True)
data = data.append(csv_data, ignore_index=True)
print(data.head(5))
通过每次使用数据读取新的 csv 数据 'data = pd.read_csv(file)',您将覆盖上次迭代中已附加的数据,您需要保持它的完整性以便继续附加到它, 因此每个 CSV 读取必须分开。
