1In [36]:
2df['Group'] = df['Group'].map(df1.set_index('Group')['Hotel'])
3df
4
5Out[36]:
6 Date Group Family Bonus
70 2011-06-09 Jamel Laavin 456
81 2011-07-09 Frank Grendy 679
92 2011-09-10 Luxy Fantol 431
103 2011-11-02 Frank Gondow 569
11