/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 vote99 views2 answers
Check all values in dictionary python
Python
0 vote107 views1 answer
Pretty size python
Python
0 vote106 views1 answer
How to do disconnect command on member in discord python
Python
1 vote117 views2 answers
How to print values without space in python
Python
0 vote116 views1 answer
Celery timezone setting django
Python Django
0 vote98 views1 answer
How to play audio in background
Python
2 votes110 views1 answer
Serializers.py include all fields
Python
1 vote107 views1 answer
Python number of elements in multidimensional array
Python
-2 votes104 views1 answer
Ex; jva loop array
Python
4 votes100 views2 answers
Python simplify fraction
Python