how to merge pandas dataframes

Asked May 16 '22 at 05:09

Active May 16 '22 at 05:15

Viewed 17 times

I have a df as df1

                       Userid         Price  
Time                                                        
2022-04-02 14:24:21  91127426  46697.000000 
2022-04-02 13:36:46  38041849  46901.500000  
2022-04-02 13:18:03  23796917  46770.000000

and other df as df2

            price_diff_bps  pnl_of_fills  
Userid                                  
38041849            -0.0       -1333.0  
91127426            -0.0       -5687.5

im trying to merge these two dataframes upon user id.

final_df=df2.merge(df1, left_index=True, right_on='Userid')
            

       Userid         Price  price_diff_bps  pnl_of_fills  
Time                                                        
2022-04-02 14:24:21  91127426  46697.000000  -0.0  -1333.0   
2022-04-02 13:36:46  38041849  46901.500000  -0.0  -5687.5

im missing the user id in final df, i need all the userid from the df1.

edited May 16 '22 at 05:12

asked May 16 '22 at 05:09

Madan

1

Seems need `final_df=df2.merge(df1, left_index=True, right_on='Userid', how='right')` – jezrael May 16 '22 at 05:28
1

yes, this only.. – Madan May 16 '22 at 05:29
It is correct closed dupe, so removed answer. – jezrael May 16 '22 at 05:29
but your answer is not mentioned there in the dupe.. how to understand these.. – Madan May 16 '22 at 05:33
1

My first answer was wrong :) So if edit by `final_df=df2.merge(df1, left_index=True, right_on='Userid', how='right')` then dupe. – jezrael May 16 '22 at 05:36
1

Okay, thanks for your time anyway.. you are helping me alot.. thank you so much.. @jezrael in many problems.. – Madan May 16 '22 at 05:39

how to merge pandas dataframes

0 Answers0