liveBook · Manning

Gross box office

As explained in The Well-Grounded Data Analyst

Gross box office is the total ticket revenue generated by films before deductions or distribution of proceeds.

Gross box office measures total ticket revenue before deductions. In genre data, it supports comparisons across films, years, and COVID periods, but its source column may contain threshold values rather than ordinary numbers. section 5.4.3

Use gross box office to:

  • Calculate total revenue by genre by grouping rows and summing the gross box office column. section 5.4.3
  • Compare genre revenue across individual years rather than relying only on an overall total. section 5.4.3
  • Treat values below £100,000 explicitly instead of silently converting them to zero. section 5.4.3

Representing suppressed low revenue

When a row contains “<0.1” million, replace it with 0.05 before converting the column to floating-point values. This preserves a low-revenue signal while making aggregation possible. section 5.4.3

genres.loc[genres["Gross box office (£ million)"] == "<0.1",
 "Gross box office (£ million)"] = 0.05
genres["Gross box office (£ million)"] =
 genres["Gross box office (£ million)"].astype(float)

Inspect the executable transformation that replaces “<0.1” and converts gross box office values to numeric data. section 5.4.3

How The Well-Grounded Data Analyst covers it

How deep it goes
Explains aggregation and a nonnumeric-value workaround, but stops short of financial deductions or distribution splits.
Examples
Uses genre totals, yearly genre bar charts, and a “<0.1” million value.
What it assumes
Assumes tabular genre data and teaches how to handle nonnumeric revenue markers before aggregation.
What you can do after
Evaluate genre performance by cleaning suppressed values and aggregating gross box office by genre and year.
How it connects
Ties gross box office to genre, year, revenue, COVID period, and number of releases.
Cover of The Well-Grounded Data Analyst
liveBookmanning.com
Read The Well-Grounded Data Analyst on liveBook Get the book at manning.com

This explainer was generated by Manning's knowledge graph from the text of The Well-Grounded Data Analyst. The section links point to the parts of the book it draws on.