/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

4 votes332 views3 answers
Python create new pandas dataframe with specific columns
Python
1 vote326 views1 answer
Python tkinter go to another window on button click
Python
0 vote374 views1 answer
Flask python use specified port
Python Flask
1 vote325 views2 answers
Format number in python
Python
0 vote325 views1 answer
Renpy hide textbox
Python
7 votes330 views3 answers
Subtract list from list python
Python
0 vote340 views1 answer
Hide verbose in pip install
Python
6 votes302 views1 answer
Python check if number
Python
0 vote360 views1 answer
Python create empty dictionary with keys
Python
0 vote373 views1 answer
Mobile number regex python
Python