How to merge a Series and DataFrame

by

Update
From v0.24.0 onwards, you can merge on DataFrame and Series as long as the Series is named. 

df.merge(s.rename('new'), left_index=True, right_index=True)
# If series is already named,
# df.merge(s, left_index=True, right_index=True)

Nowadays, you can simply convert the Series to a DataFrame with to_frame(). So (if joining on index):

df.merge(s.to_frame(), left_index=True, right_index=True)

More Related Contents:

  1. How to provide a reproducible copy of your DataFrame with to_clipboard()
  2. Combine two columns of text in pandas dataframe
  3. Convert DataFrame column type from string to datetime
  4. How to apply a function to two columns of Pandas dataframe
  5. How to convert an XML file to nice pandas dataframe?
  6. Dynamically evaluate an expression from a formula in Pandas
  7. df.append() is not appending to the DataFrame
  8. How to get rid of “Unnamed: 0” column in a pandas DataFrame read in from CSV file?
  9. Pandas groupby mean – into a dataframe?
  10. How to reversibly store and load a Pandas dataframe to/from disk
  11. How to select all columns whose names start with X in a pandas DataFrame
  12. pandas groupby without turning grouped by column into index
  13. Pandas finding local max and min
  14. Find the unique values in a column and then sort them
  15. Bin pandas dataframe by every X rows
  16. Redefining the Index in a Pandas DataFrame object
  17. How to filter a pandas dataframe based on the length of a entry
  18. Group dataframe and get sum AND count?
  19. pandas apply function that returns multiple values to rows in pandas dataframe
  20. return max value from pandas dataframe as a whole, not based on column or rows
  21. How is pandas groupby method actually working?
  22. Replace value for a selected cell in pandas DataFrame without using index
  23. How to select rows with NaN in particular column?
  24. Anti-Join Pandas
  25. Remove NaN/NULL columns in a Pandas dataframe?
  26. Group DataFrame in 5-minute intervals
  27. What values are valid in Pandas ‘Freq’ tags?
  28. How to efficiently assign unique ID to individuals with multiple entries based on name in very large df
  29. start index at 1 for Pandas DataFrame
  30. Multi Index Sorting in Pandas

Leave a Comment