- +在此添加单个AI新笔记
pandas append
-df2%E5%8A%A0%E5%88%B0df1%E7%9A%84%E5%B0%BE.png&w=3840&q=85)
数据准备
此处准备2个df，用于合并
import numpy as npimport pandas as pddf1 = pd.DataFrame(data=[{"A":"one", "B":"a"}, {"A":"two", "B":"b"}, {"A":"one", "B":1}])
| A | B | |
|---|---|---|
| 0 | one | a |
| 1 | two | b |
| 2 | one | 1 |
df2 = pd.DataFrame(data=[{"A":"a", "B":"one"}, {"A":"b", "B":"two"}, {"A":"1", "B":"one"}])
| A | B | |
|---|---|---|
| 0 | a | one |
| 1 | b | two |
| 2 | 1 | one |
append()合并数据
此时有2个df，将df2中的行添加到df1的尾部
df= df1.append(df2)
| A | B | |
|---|---|---|
| 0 | one | a |
| 1 | two | b |
| 2 | one | 1 |
| 0 | a | one |
| 1 | b | two |
| 2 | 1 | one |
由于index继承于上两个df，可以重置index索引
df3 = df.reset_index(drop=True)
| A | B | |
|---|---|---|
| 0 | one | a |
| 1 | two | b |
| 2 | one | 1 |
| 3 | a | one |
| 4 | b | two |
| 5 | 1 | one |
新版添加
新版不能用append了，可以用这个办法
df.loc[len(df)] = {"A":1,"B":2}