Pandas DataFrame append() Method
Example
Append a DataFrame at the end of another DataFrame:
import pandas as pd
data1 = {
"age": [16, 14, 10],
"qualified": [True, True, True]
}
df1 = pd.DataFrame(data1)
data2 = {
"age": [55, 40],
"qualified": [True, False]
}
df2 = pd.DataFrame(data2)
newdf = df1.append(df2)
Try it Yourself »
Definition and Usage
The append() method appends a DataFrame-like
object at the end of the current DataFrame.
The append() method returns a new DataFrame
object, no changes are done with the original DataFrame.
Syntax
dataframe.append(other, ignore_index, verify_integrity,
sort)
Parameters
The ignore_index,
verify_integrity,
sort parameters are
keyword arguments.
| Parameter | Value | Description |
|---|---|---|
| other | DataFrame Series Dictionary List |
Required. Specifies an object to append |
| ignore_index | True |
Optional, default False. If True, the original indexes are ignored and will be replaced by 0, 1, 2 etc |
| verify_itegrity | True |
Optional, default False. If True, you will get an error if you have two or more rows with the same index |
| sort | True |
Optional, default False. If True, sorts columns |
Return Value
A new DataFrame with the new DataFrame/Series appended.
This method does not change the original DataFrame.
