/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

50 votes136 views3 answers
Pandas save without index
Python
0 vote123 views1 answer
Anagram Game
Python
2 votes152 views1 answer
Python turtle background image
Python
0 vote125 views1 answer
Split pd dataframe to excel files based on a column value
Python
0 vote131 views1 answer
Numpy histogram 0 to 100 percent
Python
0 vote140 views1 answer
Np.zeros data type not understood
Python
0 vote123 views1 answer
How to run python code on github
Python
0 vote173 views1 answer
Django get child element
Python Django
0 vote129 views1 answer
Extract all capital words dataframe
Python
0 vote135 views1 answer
Recurrent neural network pytorch
Python