DataFrame.append

DataFrame.append(other, ignore_index=False, verify_integrity=False, sort=False)
将其他的行追加到原DataFrame的末尾，返回一个新对象。
不在原DataFrame中的列将作为新列添加。

Parameters

参数 可选类型 默认值
other
1. DataFrame or Series
1. dict-like object
1. list of these
 -
ignore_index True：重置索引为0,1…,n-1 False
verify_integrity True：在创建具有重复项的索引时引发ValueError False
sort True：对列按照列名进行排序 False

举例：追加一个相同结构的DataFrame

  1. import pandas as pd
  2. df1 = pd.DataFrame({'site':['google', 'baidu'],
  3.                     'age':[18, 39]})
  5. df2 = pd.DataFrame({'site':['wiki', 'pandas'],
  6.                      'age':[44, 55]})
  7. df1.append(df2)
  8. -------------------------
  9.     site    age
  10. 0    google    18
  11. 1    baidu    39
  12. 0    wiki    44
  13. 1    pandas    55

举例：追加时设置ignore_index=True

  1. import pandas as pd
  2. df1 = pd.DataFrame({'site':['google', 'baidu'],
  3.                     'age':[18, 39]})
  5. df2 = pd.DataFrame({'site':['wiki', 'pandas'],
  6.                      'age':[44, 55]})
  7. df1.append(df2, ignore_index=True)
  8. --------------------
  9.     site    age
  10. 0    google    18
  11. 1    baidu    39
  12. 2    wiki    44
  13. 3    pandas    55

举例：追加时设置verify_integrity=True

verifyintegrity=_True时，两个DataFrame的index不能相同，否则会引发ValueError

  1. import pandas as pd
  2. df1 = pd.DataFrame({'site':['google', 'baidu'],
  3.                     'age':[18, 39]})
  5. df2 = pd.DataFrame({'site':['wiki', 'pandas'],
  6.                      'age':[44, 55]},index=[2,3])
  7. df1.append(df2, verify_integrity=True)
  8. -----------------------
  9.     site    age
  10. 0    google    18
  11. 1    baidu    39
  12. 2    wiki    44
  13. 3    pandas    55

举例：追加时排序

  1. import pandas as pd
  2. df1 = pd.DataFrame({'site':['google', 'baidu'],
  3.                     'age':[18, 39]})
  5. df2 = pd.DataFrame({'site':['wiki', 'pandas'],
  6.                      'age':[44, 55],
  7.                     'color':['red', 'blue']})
  8. df1.append(df2, sort=True)
  9. ---------------------------------
  10.     age    color    site
  11. 0    18    NaN        google
  12. 1    39    NaN        baidu
  13. 0    44    red        wiki
  14. 1    55    blue    pandas