What happens when there is a mismatch when performing a merge?


#1

Question

In the context of this exercise, what happens when there is a mismatch when performing a merge?

Answer

When there is a mismatch for a merge of two dataframes, the rows that have no match will simply not be included in the result dataframe.

By default the pd.merge() method performs an inner merge, which means that it will only return a row if there is a matching value in both dataframes.