Pandas: Update a DataFrame from another DataFrame

31 July 2020

Code

# Import library
import pandas as pd

# Create two DataFrame
df = pd.DataFrame({
    'fruit':['mango','orange','banana', 'orange','lime'],
    'quantity':[55,22,87,1,1]
})

new_df = pd.DataFrame({
    'fruit':['orange', 'banana','mango'],
    'quantity':[105,999,621],
    'grade':['A','A+','B']
})

# Update df in place
df.update(new_df)

# Output
print(df)

Output

    fruit  quantity
0  orange     105.0
1  banana     999.0
2   mango     621.0
3  orange       1.0
4    lime       1.0






Any errors in code above?
Please send a message.