Merge on index pandas

Pandas merge python

import pandas as pd
df1 = pd.DataFrame({'lkey': ['foo', 'bar', 'baz', 'foo'],
                    'value': [1, 2, 3, 5]})
df2 = pd.DataFrame({'rkey': ['foo', 'bar', 'baz', 'foo'],
                    'value': [5, 6, 7, 8]})
df1.merge(df2, left_on='lkey', right_on='rkey')

Merge on index pandas

pd.merge(df1, df2, left_index=True, right_index=True)

Source: stackoverflow.com

Similar codes

0 vote208 views1 answer
Append to an array in 1st place python
Python
5 votes181 views2 answers
Random boolean python
Python
0 vote193 views1 answer
Get one from dataloader
Python
4 votes182 views2 answers
Python selenium implicit wait
Python
34 votes206 views6 answers
Simple flask app
Python
481 votes357 views10 answers
December global holidays
Python
10 votes197 views3 answers
Pandas show all dataframe method
Python
0 vote200 views1 answer
Swap case hackerrank solution
Python
0 vote193 views1 answer
Confusion matrix seaborn
Python
0 vote199 views1 answer
Download csv file from jupyter notebook
Python