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 False`	Optional, default False. If True, the original indexes are ignored and will be replaced by 0, 1, 2 etc
verify_itegrity	`True False`	Optional, default False. If True, you will get an error if you have two or more rows with the same index
sort	`True False`	Optional, default False. If True, sorts columns