/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

0 vote287 views1 answer
Extract text from span python
Python
2 votes272 views3 answers
List inside a list in python
Python
0 vote280 views1 answer
List exaple in python
Python
0 vote273 views1 answer
Sort first element reverse sort second python
Python
0 vote273 views1 answer
Rdflib check if graph is empty
Python
0 vote276 views1 answer
Fastapi-sqlalchemy
Python
0 vote303 views2 answers
Url namespaces for django rest router urls
Python Django
0 vote263 views1 answer
Django template datetime-local
Python
13 votes269 views5 answers
Prime number program in python using function
Python
15 votes281 views3 answers
Python get lan ip
Python