Course Content
Data Manipulation using pandas
Data Manipulation using pandas
2. Preprocessing Data: Part II
Right Join
Another type of join is the right one. This join is literally the same as the left join, but with swapped tables (i.e., to perform a right join of table1 to table2 is literally the same as left join of table2 to table1). To perform a right join, set the how = 'right'
parameter.
So both data1.merge(data2, on = 'id', how = 'right')
and data2.merge(data1, on = 'id', how = 'left')
will return the same result (with changed order of columns).
Everything was clear?