Pedro9
Pedro9

Reputation: 196

Concatenating dataframes by index/columns elements

import pandas as pd
import numpy as np

df = pd.DataFrame(data = np.random.random(36).reshape((9,4)), index = np.arange(1, np.random.random(36).reshape((9,4)).shape[0]+1), columns=['A', 'B', 'C', 'D'])

te = pd.DataFrame(data = np.random.randint(low=1, high=10, size=1000), columns=['Number_test'])

I want to concatenate two dataframes by index of df to each corresponding element in column Number_test

Upvotes: 1

Views: 122

Answers (1)

roman
roman

Reputation: 117636

Use pandas.DataFrame.merge:

pd.merge(df, te, left_index=True, right_on='Number_test')

or

pd.merge(df.reset_index(), te, left_on='index', right_on='Number_test')

Upvotes: 2

Related Questions