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 vote137 views1 answer
RemoveStopWords
Python
119 votes162 views6 answers
Read json file python
Python
1 vote136 views1 answer
String to tuple python
Python
0 vote135 views1 answer
Python add columns to dataframe without changing the original
Python
0 vote152 views1 answer
How to change the height of an input in python tkinter
Python
0 vote172 views1 answer
Python django model range validation
Python Django
0 vote162 views2 answers
.size pandas
Python
15 votes92 views4 answers
Find average in python
Python
0 vote151 views1 answer
Dividing counter object in python
Python
0 vote133 views1 answer
Python int to scientific string
Python