/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

28 votes168 views2 answers
Convert string to double 2 decimal places python
Python
0 vote182 views1 answer
Find an element in Pandas
Python
0 vote165 views1 answer
Python web server oneliner
Python
0 vote191 views1 answer
.lift tkinter
Python
0 vote159 views1 answer
Bot wait_for discord py
Python
0 vote193 views1 answer
Form valid django created by
Python Django
0 vote227 views1 answer
Selenium exception handling python
Python
91 votes177 views6 answers
How to create a virtual environment in python
Python
0 vote149 views1 answer
Flask server not reloading
Python
10 votes172 views2 answers
Convert hex to decimal python
Python