/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 vote282 views1 answer
Get website content with beautifulsoup
Python
0 vote239 views1 answer
Python how to move multiple values from one list to another at once
Python
0 vote247 views3 answers
A program that asks for the user's input of a list of numbers and sort it in reverse in python
Python
3 votes287 views6 answers
Concatenate List
Python
0 vote316 views1 answer
Setting up a django prostgress project
Python Django
0 vote270 views1 answer
Pandas to latex table width pylatex
Python
5 votes261 views3 answers
Correlation matrix python
Python
3 votes266 views2 answers
Otp generation in python
Python
1 vote254 views2 answers
Get required packages from python project
Python
-1 vote252 views2 answers
How to do date time formatting with strftime in python
Python