/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 vote107 views1 answer
How to set the location on a pygame window
Python
2 votes111 views2 answers
Python curses for windows
Python
0 vote132 views1 answer
How to use put method in django
Python Django
1 vote102 views2 answers
Subtract from dataframe column
Python
0 vote100 views1 answer
Anagrams python
Python
0 vote121 views1 answer
Turtle meaning
Python
1 vote106 views1 answer
Time date in pandas to csv file
Python
0 vote93 views1 answer
Boto3 upload to digital digitalocean folder
Python
0 vote90 views1 answer
Conversion un type image en array python
Python
0 vote113 views2 answers
Welcome system
Python