/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 vote114 views1 answer
Python sqlite dict
Python
1 vote108 views1 answer
Euclidean distance python 3 variables
Python
0 vote126 views1 answer
How to comment a para in python
Python
1 vote102 views1 answer
Get int value of char python
Python
0 vote108 views1 answer
Sns countplot show only largest
Python
0 vote104 views1 answer
Print pattern a shape in python
Python
0 vote110 views1 answer
Soup.find_all attr
Python
0 vote163 views2 answers
How to create template folder in django
Python Django
186 votes135 views6 answers
How to read file in python
Python
0 vote118 views1 answer
How to show webcam in opencv
Python