/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

3 votes292 views1 answer
Display flask across network
Python Flask
0 vote345 views1 answer
How to get data from multiple tables in django
Python Django
7 votes266 views1 answer
Emoji In Python
Python
11 votes275 views6 answers
Pandas distinct
Python
1 vote265 views1 answer
Django sessions for beginners
Python
0 vote295 views1 answer
How to create superuser in django heroku
Python
0 vote264 views1 answer
Distance of a point from a line python
Python
2 votes285 views1 answer
Flask import jsonify
Python Flask
0 vote252 views1 answer
Pandas iloc include header
Python
0 vote262 views1 answer
Foreignkey as users from a user group django
Python