Answers for "how to join two dataframes in pandas based on column based on index"

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
-1

how to join two dataframe in pandas based on two column

merged_df = left_df.merge(right_df, how='inner', left_on=["A", "B"], right_on=["A2","B2"])
Posted by: Guest on January-29-2021

Code answers related to "how to join two dataframes in pandas based on column based on index"

Python Answers by Framework

Browse Popular Code Answers by Language