Python Pandas: Merging Dataframes Using Inner, Outer, Left and Right Joins

Include only rows from Left & Right dataframes which have same values in key columns. So, during inner join only those rows are picked in merged dataframe for which values of ‘ID’ & ‘Experience’ columns are same in 2 dataframes. Therefore for that row values of unique Columns from right dataframe (Salary and Bonus) are NaN in merged dataframe.

Source: thispointer.com