/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 vote262 views1 answer
Python set timezone of datetime
Python
4 votes287 views1 answer
Django is null
Python Django
0 vote256 views1 answer
Validate string using six library python
Python
1 vote240 views1 answer
Python sum of list axes
Python
0 vote265 views1 answer
Remove whitespace around figure matplotlib
Python
0 vote287 views1 answer
Django route accept params with character
Python Django
0 vote263 views1 answer
How to bold in colorama
Python
0 vote240 views1 answer
Print each item in list python single statemnt
Python
0 vote246 views1 answer
Draw figure larger than plot
Python
78 votes243 views4 answers
Read json
Python