/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 vote352 views1 answer
Reading the data
Python
0 vote359 views1 answer
Trends in yearly data python
Python
0 vote363 views1 answer
Python mouse listener
Python
0 vote366 views1 answer
Sqlalchemy date beween
Python
0 vote372 views1 answer
Django auto increment field
Python Django
1 vote374 views1 answer
Polynomial features random forest classifier
Python
9 votes356 views1 answer
Make tkinter btn disable
Python
0 vote354 views1 answer
Quote_from_bytes() expected bytes
Python
2 votes340 views1 answer
Dataframe shift python
Python
2 votes360 views2 answers
Python save image to pdf
Python