dataframe to series code example

Example 1: dataframe from two series

In [1]: s1 = pd.Series([1, 2], index=['A', 'B'], name='s1')

In [2]: s2 = pd.Series([3, 4], index=['A', 'B'], name='s2')

In [3]: pd.concat([s1, s2], axis=1)
Out[3]:
   s1  s2
A   1   3
B   2   4

In [4]: pd.concat([s1, s2], axis=1).reset_index()
Out[4]:
  index  s1  s2
0     A   1   3
1     B   2   4

Example 2: series.Series to dataframe

df = pd.DataFrame([s])
print (df)
         product_id_y  count
6159402       1159730      1

Example 3: pandas.core.series.series to dataframe

>>> s = pd.Series(["a", "b", "c"],
...               name="vals")
>>> s.to_frame()
  vals
0    a
1    b
2    c

Example 4: series to dataframe

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