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