/Python/Update dataframe based on value from another dataframe

Update dataframe based on value from another dataframe

In [27]:

df.loc[df.Name.isin(df1.Name), ['Nonprofit', 'Education']] = df1[['Nonprofit', 'Education']]
df
Out[27]:
  Name  Nonprofit  Business  Education
0    X          1         1          0
1    Y          1         1          1
2    Z          1         0          1
3    Y          1         1          1

[4 rows x 4 columns]

Source: stackoverflow.com

Similar codes

1 vote297 views1 answer
How to remove plotly toolbar
Python
12 votes216 views4 answers
Python algorithm generator
Python
0 vote257 views1 answer
How to redirect in django rest framework
Python Django
16 votes218 views2 answers
Python delete contents of file
Python
0 vote255 views2 answers
Split a list based on a condition
Python
0 vote218 views1 answer
How to import date python
Python
1 vote225 views1 answer
What is Python's dynamic type system
Python
0 vote276 views1 answer
Extends template django file system
Python Django
2 votes229 views1 answer
Plot histogram in seaborn
Python
0 vote228 views1 answer
Python min date from dictionary
Python