/Python/Pandas concat series into dataframe

Pandas concat series into dataframe

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

Source: stackoverflow.com

Pandas concat series into dataframe

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

Source: stackoverflow.com

Similar codes

8 votes141 views5 answers
No module psycopg2
Python
4 votes133 views2 answers
Python read entire file
Python
7 votes118 views2 answers
Shorthand python if
Python
0 vote126 views1 answer
How to make minecraft using python
Python
2 votes123 views2 answers
What is a print statement
Python
0 vote145 views1 answer
How to stop a program after 1 second in python
Python
1 vote128 views1 answer
Python how to copy a 2d array leaving out last column
Python
2 votes128 views1 answer
How i install jupyter notebook in a new conda virtual environment
Python
23 votes117 views5 answers
Change string list to int list python
Python
1 vote141 views1 answer
Get adjacent cells in grid
Python