Name: Disney Character Success
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

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.27 KB
56 rows
6 columns


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.31 KB
56 rows
3 columns


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

35.85 KB
579 rows
7 columns


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.76 KB
26 rows
8 columns


CREATE TABLE disney_revenue_1991_2016 (
  "index" BIGINT,
  "year" BIGINT,
  "studio_entertainment_ni_1" DOUBLE,
  "disney_consumer_products_ni_2" DOUBLE,
  "disney_interactive_ni_3_rev_1" DOUBLE,
  "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

31.88 KB
935 rows
4 columns


CREATE TABLE disney_voice_actors (
  "index" BIGINT,
  "character" VARCHAR,
  "voice_actor" VARCHAR,
  "movie" VARCHAR
);