Pandas: Concatenating two Series to Pandas DataFrame

Question

How can I concatenate two Series and create one DataFrame ? For example, I have series like:

a=pd.Series([1,2,3])
b=pd.Series([4,5,6])

And, I want to get a data frame like:

pd.DataFrame([[1,4], [2,5], [3,6]])

anky · Accepted Answer · 2019-03-18 05:13:02Z

4

Shortest would be:

pd.DataFrame([a,b]).T

Or:

pd.DataFrame(zip(a,b))

   0  1
0  1  4
1  2  5
2  3  6

answered Mar 18, 2019 at 5:13

anky

75.3k11 gold badges46 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

U13-Forward · Accepted Answer · 2019-03-18 05:21:24Z

3

Or use concat:

>>> pd.concat([a,b],axis=1)
   0  1
0  1  4
1  2  5
2  3  6
>>>

Or join:

>>> a.to_frame().join(b.to_frame(name=1))
   0  1
0  1  4
1  2  5
2  3  6
>>>

answered Mar 18, 2019 at 5:14

U13-Forward

71.8k15 gold badges100 silver badges125 bronze badges

Loochie · Accepted Answer · 2019-03-18 07:14:10Z

1

Another possible faster solution could be,

pd.DataFrame(np.vstack((a,b)).T)

answered Mar 18, 2019 at 6:58

Loochie

2,47215 silver badges20 bronze badges