Pandas – How to Merge Series into DataFrame

Let’s say you already have a pandas DataFrame with few columns and you would like to add/merge Series as columns into existing DataFrame, this is certainly possible using pandas.Dataframe.merge() method.

I will explain with the examples in this article. first create a sample DataFrame and a few Series. You can also try by combining Multiple Series to create DataFrame.

import pandas as pd

technologies = ({
    'Courses':["Spark","PySpark","Hadoop"],
    'Fee' :[22000,25000,23000]
               })
df = pd.DataFrame(technologies)
print(df)

# Create Series
discount  = pd.Series([1000,2300,1000], name='Discount')

1. Merge Series into pandas DataFrame

Now let’s say you wanted to merge by adding Series object discount to DataFrame df.

# Merge Series into DataFrame
df2=df.merge(discount,left_index=True, right_index=True)
print(df2)

Yields below output. It merges the Series with DataFrame on index.

# Output:
   Courses    Fee  Discount
0    Spark  22000      1000
1  PySpark  25000      2300
2   Hadoop  23000      1000

This also works if your rows are in different order, but in this case you should have custom indexes. I will leave this to you to explore.

# Rename Series before Merge
df2=df.merge(discount.rename('Course_Discount'),
             left_index=True, right_index=True)
print(df2)

Yields below output

# Output:
   Courses    Fee  Course_Discount
0    Spark  22000             1000
1  PySpark  25000             2300
2   Hadoop  23000             1000

2. Using Series.to_frame() & DataFrame.merge() Methods

You can also create a DataFrame from Series using Series.to_frame() and use it with DataFrame to merge.

# Merge by creating DataFrame from Series
df2=df.merge(discount.to_frame(), left_index=True, right_index=True)
print(df2)

Yields same output as in first example.

Conclusion

In this article I have explained how to merge/add series objects to existing pandas DataFrame as columns by using merge() method. also covered by creating a DataFrame from series using to_frame() and using on merge() method.

Happy Learning

Related Articles

• How to Add an Empty Column to a Pandas DataFrame
• How to Combine Two Series into pandas DataFrame
• Install pandas on Windows Step-by-Step
• Convert Index to Column in Pandas DataFrame
• Replace NaN Values with Zeroes in a Column of a Pandas DataFrame
• Pandas Merge Two DataFrames
• Pandas Merge DataFrames Explained Examples
• Pandas Merge DataFrames on Index

Reference

• https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.merge.html