Convert pandas Series to DataFrame Convert pandas Series to DataFrame python python

Convert pandas Series to DataFrame


python pandas dataframe series

Rather than create 2 temporary dfs you can just pass these as params within a dict using the DataFrame constructor:

pd.DataFrame({'email':sf.index, 'list':sf.values})

There are lots of ways to construct a df, see the docs

python pandas dataframe series

to_frame():

Starting with the following Series, df:

emailemail1@email.com    Aemail2@email.com    Bemail3@email.com    Cdtype: int64

I use to_frame to convert the series to DataFrame:

df = df.to_frame().reset_index()    email               00   email1@email.com    A1   email2@email.com    B2   email3@email.com    C3   email4@email.com    D

Now all you need is to rename the column name and name the index column:

df = df.rename(columns= {0: 'list'})df.index.name = 'index'

Your DataFrame is ready for further analysis.

Update: I just came across this link where the answers are surprisingly similar to mine here.

python pandas dataframe series

One line answer would be

myseries.to_frame(name='my_column_name')

Or

myseries.reset_index(drop=True, inplace=True)  # As needed

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last