panda中如何把append()换成pd.concat()

Question

问题遇到的现象和发生背景

刷到一个题是把 append 换成 concat 来去掉警告，不太清楚怎么处理，想请教一下！ 非常感谢！

问题相关代码，请勿粘贴截图

import pandas as pd
import random

df_norms = pd.DataFrame()
df = pd.DataFrame({'Individual_Scale' : ['Scale A','Scale B','Scale C','Scale D','Scale E','Scale F'],
'Score' : [random.random()*100 for _ in range(6)]})

for scale in ['Scale A','Scale B','Scale C','Scale D','Scale E','Scale F']:
df_norms[scale] = sorted([random.random()*100 for _ in range(100)])
df = df.append(pd.Series([scale,random.random()*100], index = df.columns), ignore_index=True)

Answer 1

append相当于追加数据，这个函数在新版本中弃用了，concat是把两个相似的df组合起来，你直接新建一个列相同的df就行：

for scale in ['Scale A','Scale B','Scale C','Scale D','Scale E','Scale F']:
    df_norms[scale] = sorted([random.random()*100 for _ in range(100)])
    data = pd.DataFrame({'Individual_Scale' : [scale],'Score':random.random()*100})
    df = pd.concat([df, data], ignore_index = True)