Answers for "pandas merge series on index"

7

merge on index pandas

pd.merge(df1, df2, left_index=True, right_index=True)
Posted by: Guest on January-10-2021
0

pandas join two series on index

# credit to Stack Overflow user in the source link

s1 = pd.Series([1, 2], index=['A', 'B'], name='s1')
s2 = pd.Series([3, 4], index=['A', 'B'], name='s2')

pd.concat([s1, s2], axis=1)
Out:
   s1  s2
A   1   3
B   2   4

pd.concat([s1, s2], axis=1).reset_index()
Out:
  index  s1  s2
0     A   1   3
1     B   2   4
Posted by: Guest on July-30-2021

Python Answers by Framework

Browse Popular Code Answers by Language