/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 votes288 views2 answers
Python custom exception
Python
212 votes412 views6 answers
Generate random number python
Python
0 vote307 views1 answer
Grouped bar chart with labels
Python
2 votes320 views2 answers
Pandas divide one column by another
Python
8 votes328 views2 answers
Django create empty migration
Python Django
7 votes321 views3 answers
Discord.py level system
Python
6 votes332 views3 answers
Flask get ip of user
Python Flask
2 votes275 views1 answer
When did guido van rossum create python
Python
1 vote309 views1 answer
Installing wxpython on windows 10
Python
0 vote341 views1 answer
Login views django template passing
Python Django