Exercise

Merging for theater locations

Hey! We don't have theater locations now, we have theater names. But what if we want both?

Currently loaded are two DataFrames:

  • theater_sales - A summary of tickets sold in each theater, based on the theater name.
  • theater_info - A table of theater names and the location of each theater.

Feel free to check them out in the console to get a better understanding of them.

They have key columns, but the names don't match. Let's handle this join in the exercise!

Instructions

100 XP
  • Use the .merge() method on theater_sales to join theater_info on the correct key columns.
  • Use the .drop() method to remove the redundant theater column from sales_join.