/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

2 votes149 views4 answers
How to create s3 bucket in aws cli
Python
0 vote149 views1 answer
Plt add y gridlines
Python
1 vote152 views5 answers
Networkx draw labels
Python
0 vote163 views1 answer
Selenium python class contains
Python
0 vote179 views1 answer
How to fix invalid salt in python flask
Python Flask
0 vote137 views1 answer
Webdriver python get total number of tabs
Python
5 votes192 views1 answer
Pandas version check in python
Python
92 votes153 views6 answers
How to reverse a list in python
Python
3 votes162 views2 answers
Pygame bg color
Python
0 vote148 views1 answer
Python http handler iis
Python