/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

11 votes386 views3 answers
Send message to specific channel discord.py
Python
0 vote360 views1 answer
Run for loop inside pdb
Python
0 vote332 views1 answer
How to use + with strings
Python
6 votes324 views3 answers
Argparse type
Python
0 vote352 views1 answer
Write a python program to find the most frequent word in text file
Python
18 votes321 views6 answers
Gui in python
Python
17 votes339 views1 answer
Sudo apt-get install python3-tk not working
Python
0 vote368 views1 answer
Get list of all document in django-elasticsearch-dsl
Python Django
0 vote314 views1 answer
Input lstm
Python
0 vote352 views1 answer
Django change foreign key
Python Django