Pandas Merge Quiz

Which of the following is the default join type used in pandas.merge()?

• Left join

• Right join

• Inner join

• Outer join

What parameter should you set in pandas.merge() to perform a left join?

• on='left'

• how='left'

• how='inner'

• method='left'

Which argument is used in pandas.merge() to specify the key columns in both DataFrames that should be matched?

• key

• on

• match

• columns

If you want to merge two DataFrames on columns with different names, which parameter is used to specify the respective columns?

• on

• index

• key_left and key_right

• left_on and right_on

Which type of join includes all rows from both DataFrames, with NaN in places where data is missing?

• Left join

• Right join

• Inner join

• Outer join

How do you specify merging on both index and columns in pandas.merge()?

• on_index=True

• left_index=True, right_index=True

• how='index'

• join_index=True

What happens if there are overlapping column names in the DataFrames being merged, and no suffixes are provided?

• The merge fails.

• Duplicate column names are overwritten.

• Column names are suffixed with x and y.

• Only one of the overlapping columns is kept.

To merge DataFrames based on multiple columns, you should pass a list of column names to which parameter?

• on

• columns

• key

• multi_on

Which of the following will perform a merge using the index of both DataFrames?

• pd.merge(df1, df2, left_index=True, right_index=True)

• pd.merge(df1, df2, how='outer', on_index=True)

• pd.merge(df1, df2, on_index=True)

• pd.merge(df1, df2, index=True)

Which option in pandas.merge() specifies the column suffixes when there are overlapping column names?

• suffix

• suffixes

• overlap

• append_suffix