/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

11 votes334 views6 answers
Pandas join dataframe
Python
0 vote346 views1 answer
Django validate_comma_separated_integer_list
Python Django
0 vote289 views2 answers
Py search and get objects from array
Python
1 vote296 views1 answer
Python read entire file as string
Python
3 votes284 views2 answers
Priting matrix using np truncating the output
Python
11 votes324 views3 answers
Pd.set_option
Python
16 votes328 views3 answers
How to change the column order in pandas dataframe
Python
0 vote337 views1 answer
How to sum certain columns row wise in python
Python
0 vote324 views1 answer
Pathlib path forward or back slahses
Python
0 vote275 views1 answer
Pytest installation windows
Python