KcFnMi KcFnMi - 2 months ago 11
Python Question

Create DataFrame from multiple Series

I have 2

Series
, given by:

import pandas as pd

r = pd.Series()
for i in range(0, 10):
r = r.set_value(i,i*3)
r.name = 'rrr'

s = pd.Series()
for i in range(0, 10):
s = s.set_value(i,i*5)
s.name = 'sss'


How to I create a
DataFrame
from them?

Answer

You can use pd.concat:

pd.concat([r, s], axis=1)
Out: 
   rrr  sss
0    0    0
1    3    5
2    6   10
3    9   15
4   12   20
5   15   25
6   18   30
7   21   35
8   24   40
9   27   45

Or the DataFrame constructor:

pd.DataFrame({'r': r, 's': s})

Out: 
    r   s
0   0   0
1   3   5
2   6  10
3   9  15
4  12  20
5  15  25
6  18  30
7  21  35
8  24  40
9  27  45