/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 vote256 views1 answer
Remove single and double quotes from string python
Python
0 vote255 views1 answer
Rolling window 2d array
Python
1 vote234 views1 answer
Array and list in python
Python
12 votes257 views6 answers
How to make a list python
Python
2 votes240 views1 answer
Django load model by name
Python
1 vote258 views5 answers
Django social auth
Python Django
0 vote251 views1 answer
Print greeting in python explication
Python
0 vote245 views1 answer
Not to display column tree odoo 8
Python
0 vote244 views1 answer
Python diffie hellman
Python
4 votes259 views2 answers
ImportError: No module named django.core.wsgi
Python Django