Convert Series to pandas DataFrame in Python (2 Examples)
In this tutorial, I’ll illustrate how to convert a pandas Series to a DataFrame in the Python programming language.
Table of contents:
If you want to learn more about these topics, keep reading…
Example Data & Software Libraries
First, we need to import the pandas library:
import pandas as pd # Load pandas
The pandas Series below is used as a basis for this Python tutorial:
my_ser = pd.Series([1, 3, 5, 7, 9]) # Create example Series print(my_ser) # Print example Series # 0 1 # 1 3 # 2 5 # 3 7 # 4 9 # dtype: int64
As you can see, our pandas Series consists of five integer elements.
Example 1: Create pandas DataFrame from Series Using to_frame() Function
Example 1 illustrates how to convert a pandas Series to a pandas DataFrame in Python.
For this task, we can use the to_frame function as shown in the following Python syntax:
my_data1 = my_ser.to_frame('x') # Convert Series to DataFrame print(my_data1) # Print pandas DataFrame
As you can see based on Table 1, we have created a new pandas DataFrame from our Series object composed of five rows and one column. The values in this data set correspond to the values in our Series.
Example 2: Create pandas DataFrame from Series Using DataFrame() Function
Alternatively to the to_frame function that we have used in Example 1, we can also apply the DataFrame function of the pandas library to transform a Series object to a DataFrame.
To accomplish this, we can use the Python code that you can see below:
my_data2 = pd.DataFrame({'x': my_ser}) # Convert Series to DataFrame print(my_data2) # Print pandas DataFrame
By running the previous Python code, we have created Table 2, i.e. another pandas DataFrame containing our input series as pandas DataFrame variable.
Video & Further Resources
Do you want to know more about the conversion of a pandas Series to a DataFrame column? Then you may want to watch the following video which I have published on my YouTube channel. In the video, I’m explaining the contents of this article:
Please accept YouTube cookies to play this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
If you accept this notice, your choice will be saved and the page will refresh.
Besides that, you may want to have a look at the related tutorials which I have published on this website.
- Convert List to pandas DataFrame in Python
- Convert NumPy Array to pandas DataFrame in Python
- Convert pandas DataFrame to NumPy Array in Python
- Convert Index to Column of pandas DataFrame in Python
- Convert pandas DataFrame Index to List & NumPy Array in Python
- Convert pandas DataFrame Column to datetime in Python
- Handling DataFrames Using the pandas Library in Python
- Python Programming Examples
Summary: This page has shown how to change and transform a pandas Series to a DataFrame column in Python. Let me know in the comments, in case you have additional questions.