/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 vote107 views1 answer
Command prompt pause in python
Python
0 vote131 views1 answer
Remove occurence of character from string python
Python
3 votes116 views1 answer
Get list file endswith python
Python
5 votes130 views3 answers
Learn python the hard way
Python
0 vote120 views1 answer
Why wont my python input accept string inputs
Python
0 vote123 views1 answer
Stop a subprocess python
Python
0 vote117 views1 answer
Get first element of ordereddict
Python
0 vote78 views1 answer
Glob.iglob sort path
Python
134 votes138 views6 answers
Rename columns pandas
Python
0 vote129 views1 answer
Pandas loc index not in
Python