Tutorials References Exercises Videos Menu
Create Website Get Certified Upgrade

Pandas DataFrame update() Method

❮ DataFrame Reference


Example

Update the DataFrame with the data from another DataFrame, Emil is 17 not 16:

import pandas as pd

df1 = pd.DataFrame([["Emil", "Tobias", "Linus"], [16, 14, 10]])
df2 = pd.DataFrame([["Emil"], [17]])

df1.update(df2)
Try it Yourself »

Definition and Usage

The update() method updates a DataFrame with elements from another similar object (like another DataFrame).

:}

Note: this method does NOT return a new DataFrame.

The updating is done to the original DataFrame.


Syntax

dataframe.update(other, join, overwrite, filter_func, errors)

Parameters

The join, overwrite, filter_func, errors parameters are keyword arguments.

Parameter Value Description
other   Required. A DataFrame.
join 'left' Optional. Default 'left'. Specifies which of the two objects to update. Note: only 'left' is allowed (for now)
overwrite True
False
Optional. Default True. Specifies whether to overwrite NULL values or not
filter_func Function Optional. Specifies a function to execute for each replaced element. The function should return True for elements that should be updated
errors 'raise'
'ignore'
Optional. Default 'ignore'. If 'raise': an error will be raised both DataFrames has a NULL value for the same element

Return Value

This method returns None. The updating is done to the original DataFrame.


❮ DataFrame Reference