Skip to main content
 首页 » 编程设计

python之比较来自多个数据帧的数据帧以过滤数据并提取相关特征

2024年11月01日9zhoujg

我尝试使用 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 读取必须分开。