Convert pandas Series to DataFrame

Question

I have a Pandas series sf   email email1 email com     1 0  0 0  0 0  email2 email com     2 0  0 0  0 0  email3 email com     1 0  0 0  0 0  email4 email com     4 0  0 0  0 0  email5 email com     1 0  0 0  3 0  email6 email com     1 0  5 0  0 0    And I would like to transform it to the following DataFrame   index   email               list                                               0       email1 email com     1 0  0 0  0 0  1       email2 email com     2 0  0 0  0 0  2       email3 email com     1 0  0 0  0 0  3       email4 email com     4 0  0 0  0 0  4       email5 email com     1 0  0 0  3 0  5       email6 email com     1 0  5 0  0 0    I found a way to do it  but I doubt it s the more efficient one   df1   pd DataFrame data sf index  columns   email    df2   pd DataFrame data sf values  columns   list    df   pd merge df1  df2  left index True  right index True

User · Answer

Series reset index with name argument  Often the use case comes up where a Series needs to be promoted to a DataFrame  But if the Series has no name  then reset index will result in something like   s   pd Series  1  2  3   index   a    b    c    rename axis  A   s  A a    1 b    2 c    3 dtype  int64     s reset index       A  0 0  a  1 1  b  2 2  c  3   Where you see the column name is  0   We can fix this be specifying a name parameter   s reset index name  B       A  B 0  a  1 1  b  2 2  c  3     s reset index name  list       A  list 0  a     1 1  b     2 2  c     3     Series to frame  If you want to create a DataFrame without promoting the index to a column  use Series to frame  as suggested in this answer  This also supports a name parameter   s to frame name  B       B A    a  1 b  2 c  3     pd DataFrame Constructor  You can also do the same thing as Series to frame by specifying a columns param   pd DataFrame s  columns   B        B A    a  1 b  2 c  3

User · Answer

Super simple way is also df   pd DataFrame series   It will return a DF of 1 column  series values    1 index  0    n

User · Answer

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

User · Answer

One line answer would be myseries to frame name  my column name    Or myseries reset index drop True  inplace True     As needed

User · Answer

Series to frame can be used to convert a Series to DataFrame      The provided name  columnName  will substitute the series name df   series to frame  columnName       For example    s   pd Series   a    b    c    name  vals   df   s to frame  newCol   print df      newCol 0    a 1    b 2    c

User · Answer

to frame      Starting with the following Series  df   email email1 email com    A email2 email com    B email3 email com    C dtype  int64   I use to frame to convert the series to DataFrame   df   df to frame   reset index        email               0 0   email1 email com    A 1   email2 email com    B 2   email3 email com    C 3   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

User · Answer

probably graded as a  non-pythonic way to do this but this ll give the result you want in a line  new df   pd DataFrame zip email list    Result                 email               list 0   email1 email com     1 0  0 0  0 0  1   email2 email com     2 0  0 0  0 0  2   email3 email com     1 0  0 0  0 0  3   email4 email com     4 0  0 0  3 0  4   email5 email com     1 0  5 0  0 0

[python] Convert pandas Series to DataFrame

`Series.reset_index` with `name` argument

`Series.to_frame`

`pd.DataFrame` Constructor

Examples related to python

Examples related to pandas

Examples related to dataframe

Examples related to series