Disney Character Success
How does each character contribute to the success or failure of a movie?
@kaggle.thedevastator_disney_character_success_a_comprehensive_analysi
Loading...
Loading...
Loading...
Loading...
About this Dataset
Disney Character Success
About this dataset
What are the trends in the Walt Disney Studios' box office data? How do certain characters contribute to the success or failure of a movie?
This dataset explores the box office data of Walt Disney Studios from 2000 to 2016. It includes information on the movie title, release date, main character, villain, and songs associated with each film. This dataset provides insights into how different elements contribute to a movie's success or failure
How to use the dataset
When exploring this dataset, there are a few things to keep in mind. Firstly, the data is divided into four different files: disney-characters.csv, disney_movies_total_gross.csv, disney-voice-actors.csv, and disney_revenue_1991-2016.csv. Each of these files contains information on different aspects of Disney's box office data.
In order to get the most out of this dataset, it is important to understand what each file contains and how the data is organized. For example, the file 'disney-characters.csv' includes information on the movie title, release date, main character, villain, and songs associated with each film. This data can be used to answer questions about how different elements contribute to a movie's success or failure
To make things easier, we've created a quick guide that outlines what you can find in each file:
disney-characters.csv: This file contains information on the movie title, release date, main character, villain, and songs associated with each film
disney_movies_total_gross.csv: This file includes data on the total gross of Walt Disney Studios movies from 2000 to 2016
disney-voice-actors.csv: This file contains information on the voice actors for Disney characters
disney_revenue_1991-2016: This file contains data on the revenue of the Walt Disney Company from 1991 to 2016
Research Ideas
- Using the data to create predictive models that can suggest which film concepts are most likely to be successful
- Determining which factors are most important to moviegoers when deciding whether or not to see a particular film
- Finding similarities between films in Disney's back catalogue in order to make better decisions about what new films to produce
Columns
File: disney_revenue_1991-2016.csv
| Column name | Description |
|---|---|
| Year | The year the movie was released. (Numeric) |
| Year | The year the movie was released. (Numeric) |
| Studio Entertainment[NI 1] | The studio entertainment segment of the Walt Disney Company. (String) |
| Studio Entertainment[NI 1] | The studio entertainment segment of the Walt Disney Company. (String) |
| Disney Consumer Products[NI 2] | The consumer products segment of the Walt Disney Company. (String) |
| Disney Consumer Products[NI 2] | The consumer products segment of the Walt Disney Company. (String) |
| Disney Interactive[NI 3][Rev 1] | The interactive segment of the Walt Disney Company. (String) |
| Disney Interactive[NI 3][Rev 1] | The interactive segment of the Walt Disney Company. (String) |
| Walt Disney Parks and Resorts | The parks and resorts segment of the Walt Disney Company. (String) |
| Walt Disney Parks and Resorts | The parks and resorts segment of the Walt Disney Company. (String) |
| Disney Media Networks | The media networks segment of the Walt Disney Company. (String) |
| Disney Media Networks | The media networks segment of the Walt Disney Company. (String) |
| Total | The total box office gross for the movie. (Numeric) |
| Total | The total box office gross for the movie. (Numeric) |
File: disney-director.csv
| Column name | Description |
|---|---|
| name | The name of the movie. (String) |
| name | The name of the movie. (String) |
| director | The name of the movie's director. (String) |
| director | The name of the movie's director. (String) |
File: disney_movies_total_gross.csv
| Column name | Description |
|---|---|
| movie_title | The title of the movie. (String) |
| movie_title | The title of the movie. (String) |
| release_date | The release date of the movie. (Date) |
| release_date | The release date of the movie. (Date) |
| genre | The genre of the movie. (String) |
| genre | The genre of the movie. (String) |
| MPAA_rating | The MPAA rating of the movie. (String) |
| MPAA_rating | The MPAA rating of the movie. (String) |
| total_gross | The total gross of the movie. (Integer) |
| total_gross | The total gross of the movie. (Integer) |
| inflation_adjusted_gross | The inflation-adjusted gross of the movie. (Integer) |
| inflation_adjusted_gross | The inflation-adjusted gross of the movie. (Integer) |
File: disney-voice-actors.csv
| Column name | Description |
|---|---|
| character | The name of the character. (String) |
| character | The name of the character. (String) |
| voice-actor | The name of the voice actor. (String) |
| voice-actor | The name of the voice actor. (String) |
| movie | The name of the movie. (String) |
| movie | The name of the movie. (String) |
File: disney-characters.csv
| Column name | Description |
|---|---|
| movie_title | The title of the movie. (String) |
| movie_title | The title of the movie. (String) |
| release_date | The release date of the movie. (Date) |
| release_date | The release date of the movie. (Date) |
| hero | The main character of the movie. (String) |
| hero | The main character of the movie. (String) |
| villian | The villain of the movie. (String) |
| villian | The villain of the movie. (String) |
| song | A song associated with the movie. (String) |
| song | A song associated with the movie. (String) |
Tables
Disney Characters
@kaggle.thedevastator_disney_character_success_a_comprehensive_analysi.disney_characters
- 8.47 kB
- 56 rows
- 6 columns
Loading...
Loading...
CREATE TABLE disney_characters (
"index" BIGINT,
"movie_title" VARCHAR,
"release_date" VARCHAR,
"hero" VARCHAR,
"villian" VARCHAR,
"song" VARCHAR
);Disney Director
@kaggle.thedevastator_disney_character_success_a_comprehensive_analysi.disney_director
- 4.41 kB
- 56 rows
- 3 columns
Loading...
Loading...
CREATE TABLE disney_director (
"index" BIGINT,
"name" VARCHAR,
"director" VARCHAR
);Disney Movies Total Gross
@kaggle.thedevastator_disney_character_success_a_comprehensive_analysi.disney_movies_total_gross
- 36.71 kB
- 579 rows
- 7 columns
Loading...
Loading...
CREATE TABLE disney_movies_total_gross (
"index" BIGINT,
"movie_title" VARCHAR,
"release_date" TIMESTAMP,
"genre" VARCHAR,
"mpaa_rating" VARCHAR,
"total_gross" VARCHAR,
"inflation_adjusted_gross" VARCHAR
);Disney Revenue 1991–2016
@kaggle.thedevastator_disney_character_success_a_comprehensive_analysi.disney_revenue_1991_2016
- 7.95 kB
- 26 rows
- 8 columns
Loading...
Loading...
CREATE TABLE disney_revenue_1991_2016 (
"index" BIGINT,
"year" BIGINT,
"studio_entertainment_ni_1" DOUBLE -- Studio Entertainment[NI 1],
"disney_consumer_products_ni_2" DOUBLE -- Disney Consumer Products[NI 2],
"disney_interactive_ni_3_rev_1" DOUBLE -- Disney Interactive[NI 3][Rev 1],
"walt_disney_parks_and_resorts" DOUBLE,
"disney_media_networks" DOUBLE,
"total" BIGINT
);Disney Voice Actors
@kaggle.thedevastator_disney_character_success_a_comprehensive_analysi.disney_voice_actors
- 32.64 kB
- 935 rows
- 4 columns
Loading...
Loading...
CREATE TABLE disney_voice_actors (
"index" BIGINT,
"character" VARCHAR,
"voice_actor" VARCHAR,
"movie" VARCHAR
);