Skip to main content
 首页 » 编程设计

python之使用追加创建数据框

2025年01月19日9dyllove98

我正在尝试创建一个带有 append 项的 DataFrame:

col_stats= ['Attribute', 'Mean', 'Var', 'Std'] 
stats = pd.DataFrame(columns=[col_stats]) 
 
for i in train: 
    new_row = [ 
        i, 
        train[i].mean(), 
        np.var(train[i]), 
        np.nanstd(train[i]) 
    ] 
    new_row = pd.Series(new_row) 
    stats = stats.append(new_row, ignore_index=True) 
 
stats 

当我删除这一行时它起作用了:

    stats = stats.append(new_row, ignore_index=True) 

如果没有,它会给我这个错误:

ValueError: Buffer dtype mismatch, expected 'Python object' but got 'long' 

“属性”列是一个字符串(变量的名称)。其他列(Mean、Var、Std)是数字(整数、 float )

为什么我不能在这里使用 pd.df.append?

请您参考如下方法:

for循环解决方案 append rows to list and use DataFrame constructor:

L = [] 
for i in train: 
    new_row = [ 
        i, 
        train[i].mean(), 
        np.var(train[i]), 
        np.nanstd(train[i]) 
    ] 
    L.append(new_row) 
 
col_stats= ['Attribute', 'Mean', 'Var', 'Std'] 
stats = pd.DataFrame(L, columns=col_stats) 

示例:

train = pd.DataFrame({'B':[4,5,4,5,5,4], 
                   'C':[7,8,9,4,2,3], 
                   'D':[1,3,5,7,1,0]}) 
 
L = [] 
for i in train: 
    new_row = [ 
        i, 
        train[i].mean(), 
        np.var(train[i]), 
        np.nanstd(train[i]) 
    ] 
    L.append(new_row) 
 
col_stats= ['Attribute', 'Mean', 'Var', 'Std'] 
stats = pd.DataFrame(L, columns=col_stats) 
 
print (stats) 
  Attribute      Mean       Var       Std 
0         B  4.500000  0.250000  0.500000 
1         C  5.500000  6.916667  2.629956 
2         D  2.833333  6.138889  2.477678 

f1 = lambda x: x.var(ddof=0) 
f2 = lambda x: x.std(ddof=0) 
stats = train.agg(['mean',f1, f2]).T.reset_index() 
stats.columns = ['Attribute', 'Mean', 'Var', 'Std'] 
print (stats) 
  Attribute      Mean       Var       Std 
0         B  4.500000  0.250000  0.500000 
1         C  5.500000  6.916667  2.629956 
2         D  2.833333  6.138889  2.477678