Tutorials References Exercises Videos Menu
Website Get Certified Pro NEW

Pandas DataFrame append() Method

❮ DataFrame Reference


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

Return Value

A new DataFrame with the new DataFrame/Series appended.

This method does not change the original DataFrame.


❮ DataFrame Reference