/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 vote134 views1 answer
Numpy complex number
Python
6 votes207 views2 answers
Flask form options
Python Flask
3 votes143 views6 answers
Fizz buzz python
Python
0 vote140 views1 answer
No matching distribution found for numpy.core._multiarray_umath
Python
0 vote130 views1 answer
Python combine nested for loops
Python
50 votes141 views4 answers
Python get args
Python
0 vote149 views1 answer
Python inline web server
Python
0 vote149 views1 answer
Python how to automatically restart flask sever
Python
0 vote141 views1 answer
Lag function in pandas
Python
6 votes131 views2 answers
Sys.executable
Python