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!
Deze oefening maakt deel uit van de cursus
Python for Spreadsheet Users
Oefeninstructies
- Use the
.merge()method ontheater_salesto jointheater_infoon the correct key columns. - Use the
.drop()method to remove the redundanttheatercolumn fromsales_join.
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
# Join the tables
sales_join = ____
# Drop the redundant theater column
sales_complete = ____
# Print the table
print(sales_complete)