Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Pandas: Concatenating two Series to Pandas DataFrame

Tags:

python

pandas

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]])
like image 657
Tsuneo Yoshioka Avatar asked Jan 26 '23 14:01

Tsuneo Yoshioka


2 Answers

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
like image 107
anky Avatar answered Jan 29 '23 04:01

anky


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
>>> 
like image 43
U12-Forward Avatar answered Jan 29 '23 04:01

U12-Forward