/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

2 votes277 views2 answers
Area of trapezium
Python
0 vote267 views1 answer
Codes for infrntial statistics in python
Python
16 votes281 views6 answers
Show all columns in pandas
Python
0 vote351 views1 answer
Flask minimal install
Python Flask
0 vote258 views1 answer
Alpaca examples
Python
25 votes261 views6 answers
Pandas select row by index
Python
13 votes270 views2 answers
Get start time and end time in python
Python
0 vote257 views1 answer
Django template datetime-local
Python
2 votes260 views2 answers
Gpu training tensorflow
Python
1 vote264 views2 answers
How to convert datetime to integer in python
Python