Data Manipulation using pandas
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.
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).