关于DataFrame 添加行的总结

loc()

df_test = pd.DataFrame([['Snow','M',22],['Tyrion','M',32],['Sansa','F',18],['Arya','F',14]], columns=['name','gender','age'])
df_test

请添加图片描述

df_test.loc[4] = ['tom','M',9]
df_test.loc[5] = {'name':'jerry'}
df_test

请添加图片描述

append()

import warnings
warnings.filterwarnings('ignore')
df_test = pd.DataFrame([['Snow','M',22],['Tyrion','M',32],['Sansa','F',18],['Arya','F',14]], columns=['name','gender','age'])
df_test

请添加图片描述

temp_df = pd.DataFrame()
test_list = [2,3]
for x in test_list:
    for index,row in df_test.iterrows():
        if x==index:
            temp_df = temp_df.append(row)
temp_df

请添加图片描述

temp_df = pd.DataFrame()
test_list = [2,3]
for x in test_list:
    for index,row in df_test.iterrows():
        if x==index:
            temp_df = temp_df.append(pd.DataFrame(row).T)
temp_df

请添加图片描述

concat() (*重要)

pd.concat(objs, axis=0, join='outer', join_axes=None, ignore_index=False,
          keys=None, levels=None, names=None, verify_integrity=False,
          copy=True)

接上

df_test2 = pd.DataFrame([['Snow','M',22],['Tyrion','M',32],['Sansa','F',18],['Arya','F',14]], columns=['name','gender','age'])
df_test2
frames = [df_test,df_test2]
result = pd.concat(frames,ignore_index = True)
result

请添加图片描述


版权声明:本文为qq_33489955原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。