/Python/Pandas replace values from another dataframe

Pandas replace values from another dataframe

In [36]:
df['Group'] = df['Group'].map(df1.set_index('Group')['Hotel'])
df

Out[36]:
         Date  Group  Family  Bonus
0  2011-06-09  Jamel  Laavin    456
1  2011-07-09  Frank  Grendy    679
2  2011-09-10   Luxy  Fantol    431
3  2011-11-02  Frank  Gondow    569

Source: stackoverflow.com

Similar codes

106 votes238 views6 answers
How to install opencv
Python
3 votes200 views1 answer
Input array of string in python
Python
1 vote204 views1 answer
Read csv python without id
Python
9 votes258 views2 answers
How to fill nan values with mean in pandas
Python
0 vote211 views1 answer
Python how to make boxplots with jitter
Python
0 vote193 views1 answer
Ping with python
Python
1 vote217 views1 answer
Prevent list index out of range python
Python
0 vote211 views1 answer
Copy any files from one folder to another folder in python
Python
0 vote225 views1 answer
Check object attributes python
Python
0 vote236 views1 answer
No pattern
Python