pandas

In pandas, you can use the following command: 

    pd.merge(df1,df2,on='key',how='right')

The following is the output to the preceding commands: 


Output of the right join between the two tables

As expected of a right join, it retrieves all the unique values of the key present in the right-hand table (df2, in this case), as well as the corresponding values in the left-hand table. For the key values in the right-hand table for which it doesn't find a match in the left-hand table, it returns NaN.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset