Pandas Merge Using Dfa Column == Dfb Index

How to merge (left join) using column value from dataframe A and index of dataframe B? For example: >>> A >>> B lkey value rkey value 0

Solution 1:

try using left_on and right_index to do the merging, like:

m = pd.merge(dfA, dfB, right_index = True, left_on='value')