1. Learn
  2. /
  3. Courses
  4. /
  5. Python for Spreadsheet Users

Exercise

Merging for ticket prices

So it turns out our tickets for adults, children, and seniors cost different dollar amounts!

Currently loaded are two DataFrames:

  • ticket_type_sales - A summary of tickets sold to adults, children, and seniors
  • ticket_prices - A table of how much tickets cost for each ticket type

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

Let's merge ticket_type_sales with ticket_prices to calculate revenue by ticket type!

Instructions

100 XP
  • Use the .merge() method on ticket_type_sales to join the ticket_prices DataFrame on the ticket_type column.
  • Create a revenue column in sales_complete that equals tickets_sold multiplied by ticket_price.