Combine or merge two pandas Dataframes using a index Reading a json file is very easy. merged_df = df_1.merge(df_2,left_on='id', right_on='df1_id', how='outer') More info here.