/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 vote184 views1 answer
How call module in the same directory
Python
13 votes192 views5 answers
How to check if an input is a number in python
Python
13 votes217 views2 answers
How to flip a list backwards in python
Python
0 vote285 views1 answer
Django import settings variables
Python Django
12 votes180 views4 answers
Age calculator in python
Python
32 votes246 views6 answers
Merge pandas
Python
0 vote206 views1 answer
Matplotlib inside Jupyter | Jupyter generate graphs.
Python
0 vote295 views1 answer
|safe django
Python Django
5 votes230 views2 answers
Copy directory from one location to another python
Python
3 votes173 views1 answer
Module 'datetime' has no attribute 'strptime'
Python