Combining two Series into a DataFrame in pandas
I have two Series
s2 with the same (non-consecutive) indices. How do I combine
s2 to being two columns in a DataFrame and keep one of the indices as a third column?
concat is a nice way to do this. If they are present it uses the name attributes of the Series as the columns (otherwise it simply numbers them):
In : s1 = pd.Series([1, 2], index=['A', 'B'], name='s1') In : s2 = pd.Series([3, 4], index=['A', 'B'], name='s2') In : pd.concat([s1, s2], axis=1) Out: s1 s2 A 1 3 B 2 4 In : pd.concat([s1, s2], axis=1).reset_index() Out: index s1 s2 0 A 1 3 1 B 2 4
Note: This extends to more than 2 Series.