1. Learn
    2. /
  2. Courses
    3. /
  3. Python for Spreadsheet Users
Connected

Exercise

.parse() method

From our previous exercise, we know the theater_report workbook has 4 tabs: sales, ticket types, theaters, and movies. Let's convert each tab into a DataFrame and look at them.

The theater_report workbook object has already been loaded for you.

Instructions 1/4

undefined XP
  • 1

    Use the .parse() method to convert the sales sheet of theater_report to a DataFrame, assign it to sales.

  • 2

    Now parse the ticket types tab and assign it to ticket_types.

  • 3

    Parse the theaters sheet and assign it to theaters.

  • 4

    Convert the movies sheet of theater_report and assign it to movies.