Tutorials Exercises Get Certified Services Menu
Log in
Sign Up Spaces Bootcamps

Pandas DataFrame append() Method

❮ DataFrame Reference


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.


dataframe.append(other, ignore_index, verify_integrity, sort)


The ignore_index, verify_integrity, sort parameters are keyword arguments.

Parameter Value Description
other DataFrame
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.

❮ DataFrame Reference