replace column values in one dataframe by values of another dataframe

by

If you set the index to the ‘Group’ column on the other df then you can replace using map on your original df ‘Group’ column:

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

More Related Contents:

  1. Pandas DataFrame search is linear time or constant time?
  2. How to split a dataframe string column into two columns?
  3. Annotate bars with values on Pandas bar plots
  4. Comparing two dataframes and getting the differences [duplicate]
  5. How to make separator in pandas read_csv more flexible wrt whitespace, for irregular separators?
  6. Why isn’t my Pandas ‘apply’ function referencing multiple columns working? [closed]
  7. Convert the string 2.90K to 2900 or 5.2M to 5200000 in pandas dataframe
  8. Accessing Pandas column using squared brackets vs using a dot (like an attribute)
  9. Conditionally fill column values based on another columns value in pandas
  10. Get the name of a pandas DataFrame
  11. pandas concat generates nan values
  12. Combining two Series into a DataFrame in pandas
  13. pandas unique values multiple columns
  14. How to replace negative numbers in Pandas Data Frame by zero
  15. How to find which columns contain any NaN value in Pandas dataframe
  16. Python Pandas Group by date using datetime data
  17. Removing the timestamp from a datetime in pandas dataframe
  18. Convert pandas data frame to series
  19. Pandas – dataframe groupby – how to get sum of multiple columns
  20. vectorize conditional assignment in pandas dataframe
  21. Pandas DataFrame merge summing column
  22. Mapping ranges of values in pandas dataframe [duplicate]
  23. pandas: combine two columns in a DataFrame
  24. Binning a column with pandas
  25. How can I replicate rows of a Pandas DataFrame?
  26. Convert month int to month name in Pandas
  27. How to get/set a pandas index column title or name?
  28. Python pandas integer YYYYMMDD to datetime
  29. Pandas: drop columns with all NaN’s
  30. In Python pandas, start row index from 1 instead of zero without creating additional column

Leave a Comment