Exercise

How many rows with a left join?

Select the true statement about left joins.

Try running the following code statements in the IPython shell.

left_table.merge(one_to_one, on='id', how='left').shape
left_table.merge(one_to_many, on='id', how='left').shape

Note that the left_table starts out with 4 rows.

Instructions

50 XP

Possible Answers

The output of a one-to-one merge with a left join will have more rows than the left table.
The output of a one-to-one merge with a left join will have fewer rows than the left table.
The output of a one-to-many merge with a left join will have greater than or equal rows than the left table.