I have two Series **s1** and **s2** with the same (non-consecutive) indices. How do I combine **s1** and **s2** to being two columns in a DataFrame and keep one of the indices as a third column?

0 votes

You can simply use **concat **and it will give you the desired result:

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