/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

0 vote180 views1 answer
Matmul shorthand numpy
Python
0 vote183 views1 answer
Cv2.namedwindow
Python
5 votes203 views2 answers
Create python package
Python
0 vote164 views1 answer
Python proxy scraper
Python
230 votes307 views6 answers
Random number generator in python
Python
0 vote187 views1 answer
Create endpoint in python
Python
1 vote138 views1 answer
Conver all dict keys to str python
Python
1 vote191 views1 answer
Delete a record by id in flask sqlalchemy
Python
0 vote172 views1 answer
Python check if array is sorted
Python
2 votes179 views3 answers
Making a virtual environment python
Python