Real World Movie Dataset

Walt Disney Movie Dataset

@kaggle.sonukumari47_disney_movie_dataset

Table List

1 table(140.44 KB)

Walt Disney Movie Dataset

@kaggle.sonukumari47_disney_movie_dataset.walt_disney_movie_dataset

140.44 KB
452 rows
35 columns

unnamed_0 Unnamed: 0	title Title	production_company Production Company	release_date Release Date	running_time Running Time	country Country	language Language	box_office Box Office	running_time_int Running Time (int)	budget_float Budget (float)	box_office_float Box Office (float)	release_date_datetime Release Date (datetime)	directed_by Directed By	written_by Written By	based_on Based On	produced_by Produced By	starring Starring	music_by Music By	distributed_by Distributed By	budget Budget	story_by Story By	narrated_by Narrated By	cinematography Cinematography	edited_by Edited By	languages Languages	screenplay_by Screenplay By	countries Countries	production_companies Production Companies	color_process Color Process	hepburn Hepburn	adaptation_by Adaptation By	animation_by Animation By
	Academy Award Review of	Walt Disney Productions	['May 19, 1937']	41 minutes (74 minutes 1966 release)	United States	English	$45.472	41		45.472	Wed May 19 1937 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
1	Snow White and the Seven Dwarfs	Walt Disney Productions	['December 21, 1937 ( Carthay Circle Theatre )']	83 minutes	United States	English	$418 million	83	1490000	418000000	Tue Dec 21 1937 00:00:00 GMT+0000 (Coordinated Universal Time)	['David Hand', 'William Cottrell', 'Wilfred Jackson', 'Larry Morey', 'Perce Pearce', 'Ben Sharpsteen']	['Ted Sears', 'Richard Creedon', 'Otto Englander', 'Dick Rickard', 'Earl Hurd', 'Merrill De Maris', 'Dorothy Ann Blank', 'Webb Smith']	['Snow White', 'by The', 'Brothers Grimm']	Walt Disney	['Adriana Caselotti', 'Lucille La Verne', 'Harry Stockwell', 'Roy Atwell', 'Pinto Colvig', 'Otis Harlan', 'Scotty Mattraw', 'Billy Gilbert', 'Eddie Collins', 'Moroni Olsen', 'Stuart Buchanan']	['Frank Churchill', 'Paul Smith', 'Leigh Harline']	RKO Radio Pictures	$1.49 million	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
2	Pinocchio	Walt Disney Productions	['February 7, 1940 ( Center Theatre )', 'February 23, 1940 (United States)']	88 minutes	United States	English	$164 million	88	2600000	164000000	Wed Feb 07 1940 00:00:00 GMT+0000 (Coordinated Universal Time)	['Ben Sharpsteen', 'Hamilton Luske', 'Bill Roberts', 'Norman Ferguson', 'Jack Kinney', 'Wilfred Jackson', 'T. Hee']	nan	['The Adventures of Pinocchio', 'by', 'Carlo Collodi']	Walt Disney	['Cliff Edwards', 'Dickie Jones', 'Christian Rub', 'Walter Catlett', 'Charles Judels', 'Evelyn Venable', 'Frankie Darro']	['Leigh Harline', 'Paul J. Smith']	RKO Radio Pictures	$2.6 million	['Ted Sears', 'Otto Englander', 'Webb Smith', 'William Cottrell', 'Joseph Sabo', 'Erdman Penner', 'Aurelius Battaglia']	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
3	Fantasia	Walt Disney Productions	['November 13, 1940']	126 minutes	United States	English	$76.4–$83.3 million (United States and Canada)	126	2280000	83300000	Wed Nov 13 1940 00:00:00 GMT+0000 (Coordinated Universal Time)	['Samuel Armstrong', 'James Algar', 'Bill Roberts', 'Paul Satterfield', 'Ben Sharpsteen', 'David D. Hand', 'Hamilton Luske', 'Jim Handley', 'Ford Beebe', 'T. Hee', 'Norman Ferguson', 'Wilfred Jackson']	nan	nan	['Walt Disney', 'Ben Sharpsteen']	['Leopold Stokowski', 'Deems Taylor']	See program	RKO Radio Pictures	$2.28 million	['Joe Grant', 'Dick Huemer']	Deems Taylor	James Wong Howe	nan	nan	nan	nan	nan	nan	nan	nan	nan
4	The Reluctant Dragon	Walt Disney Productions	['June 27, 1941']	74 minutes	United States	English	$960,000 (worldwide rentals)	74	600000	960000	Fri Jun 27 1941 00:00:00 GMT+0000 (Coordinated Universal Time)	['Alfred Werker', '(live action)', 'Hamilton Luske', '(animation)', 'Jack Cutting', ',', 'Ub Iwerks', ',', 'Jack Kinney', '(sequence directors)']	['Live-action:', 'Ted Sears', 'Al Perkins', 'Larry Clemmons', 'Bill Cottrell', 'Harry Clork', 'Robert Benchley', 'The Reluctant Dragon', 'segment:', 'Kenneth Grahame', '(original book)', 'Erdman Penner', 'T. Hee', 'Baby Weems', 'segment:', 'Joe Grant', 'Dick Huemer', 'John Miller']	nan	Walt Disney	['Robert Benchley', 'Frances Gifford', 'Buddy Pepper', 'Nana Bryant']	['Frank Churchill', 'Larry Morey']	RKO Radio Pictures	$600,000	nan	nan	Bert Glennon	Paul Weatherwax	nan	nan	nan	nan	nan	nan	nan	nan
5	Dumbo	Walt Disney Productions	['October 23, 1941 (New York City)', 'October 31, 1941 (U.S.)']	64 minutes	United States	English	>$1.3 million (est. United States/Canada rentals, 1941)	64	950000	1300000	Thu Oct 23 1941 00:00:00 GMT+0000 (Coordinated Universal Time)	['Ben Sharpsteen', 'Norman Ferguson', 'Wilfred Jackson', 'Bill Roberts', 'Jack Kinney', 'Samuel Armstrong']	nan	['Dumbo, the Flying Elephant', 'by', 'Helen Aberson', 'Harold Pearl']	Walt Disney	['Edward Brophy', 'Verna Felton', 'Cliff Edwards', 'Herman Bing', 'Sterling Holloway', 'Margaret Wright', 'Hall Johnson Choir']	['Frank Churchill', 'Oliver Wallace']	RKO Radio Pictures	$950,000	['Otto Englander', 'Joe Grant', 'Dick Huemer']	John McLeish	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
6	Bambi	Walt Disney Productions	['August 9, 1942 (World Premiere – London)', 'August 13, 1942 (Premiere – New York City)', 'August 21, 1942 (U.S.)']	70 minutes	United States	English	$267.4 million	70	858000	267400000	Sun Aug 09 1942 00:00:00 GMT+0000 (Coordinated Universal Time)	['Supervising director', 'David Hand', 'Sequence directors', 'James Algar', 'Samuel Armstrong', 'Graham Heid', 'Bill Roberts', 'Paul Satterfield', 'Norman Wright']	nan	['Bambi, a Life in the Woods', 'by', 'Felix Salten']	Walt Disney	see below	['Frank Churchill', 'Edward H. Plumb']	RKO Radio Pictures	$858,000	['Story direction', 'Perce Pearce', 'Story adaptation', 'Larry Morey', 'Story development', 'Vernon Stallings', 'Melvin Shaw', 'Carl Fallberg', 'Chuck Couch', 'Ralph Wright']	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
7	Saludos Amigos	Walt Disney Productions	['August 24, 1942 (World Premiere – Rio de Janeiro)', 'February 6, 1943 (U.S. Premiere – Boston)', 'February 19, 1943 (U.S.)']	42 minutes	United States	nan	$1.135 million (worldwide rentals)	42		1135000	Mon Aug 24 1942 00:00:00 GMT+0000 (Coordinated Universal Time)	['Norman Ferguson', 'Wilfred Jackson', 'Jack Kinney', 'Hamilton Luske', 'Bill Roberts']	nan	nan	Walt Disney	['Lee Blair', 'Mary Blair', 'Pinto Colvig', 'Walt Disney', 'Norman Ferguson', 'Frank Graham', 'Clarence Nash', 'José Oliveira', 'Frank Thomas']	['Paul Smith', 'Edward H. Plumb']	RKO Radio Pictures	nan	['Homer Brightman', 'William Cottrell', 'Richard Huemer', 'Joe Grant', 'Harold Reeves', 'Ted Sears', 'Webb Smith', 'Roy Williams', 'Ralph Wright']	Fred Shields	nan	nan	['English', 'Portuguese', 'Spanish']	nan	nan	nan	nan	nan	nan	nan
8	Victory Through Air Power	Walt Disney Productions	['July 17, 1943']	70 min	United States	English	$799,000	70	788000	799000	Sat Jul 17 1943 00:00:00 GMT+0000 (Coordinated Universal Time)	['Animated sequences:', 'James Algar', 'Clyde Geronimi', 'Jack Kinney', 'de Seversky scenes:', 'H.C. Potter']	['Story direction:', 'Perce Pearce', 'Story adaptation:', 'T. Hee', 'Erdman Penner', 'Bill Cottrell', 'James Brodero', 'George Stallings', 'Jose Rodriguez']	Victory Through Air Power by Maj. Alexander P. Seversky	Walt Disney	Alexander de Seversky	['Edward H. Plumb', 'Paul J. Smith', 'Oliver Wallace']	United Artists	$788,000	nan	Art Baker	Ray Rennahan	Jack Dennis	nan	nan	nan	nan	nan	nan	nan	nan
9	The Three Caballeros	Walt Disney Productions	['December 21, 1944 (Mexico City)', 'February 3, 1945 (US)']	71 minutes	United States	nan	$3.355 million (worldwide rentals)	71		3355000	Thu Dec 21 1944 00:00:00 GMT+0000 (Coordinated Universal Time)	['Norman Ferguson', 'Clyde Geronimi', 'Jack Kinney', 'Bill Roberts', 'Harold Young']	nan	nan	Walt Disney	['Clarence Nash', 'José Oliveira', 'Joaquin Garay']	['Edward H. Plumb', 'Paul J. Smith', 'Charles Wolcott']	RKO Radio Pictures	nan	['Homer Brightmen', 'Ernest Terrazas', 'Ted Sears', 'Bill Peet', 'Ralph Wright', 'Elmer Plummer', 'Roy Williams', 'William Cottrell', 'Del Connell', 'James Bodrero']	nan	nan	nan	['English', 'Spanish', 'Portuguese']	nan	nan	nan	nan	nan	nan	nan


CREATE TABLE walt_disney_movie_dataset (
  "unnamed_0" BIGINT,
  "title" VARCHAR,
  "production_company" VARCHAR,
  "release_date" VARCHAR,
  "running_time" VARCHAR,
  "country" VARCHAR,
  "language" VARCHAR,
  "box_office" VARCHAR,
  "running_time_int" DOUBLE,
  "budget_float" DOUBLE,
  "box_office_float" DOUBLE,
  "release_date_datetime" TIMESTAMP,
  "directed_by" VARCHAR,
  "written_by" VARCHAR,
  "based_on" VARCHAR,
  "produced_by" VARCHAR,
  "starring" VARCHAR,
  "music_by" VARCHAR,
  "distributed_by" VARCHAR,
  "budget" VARCHAR,
  "story_by" VARCHAR,
  "narrated_by" VARCHAR,
  "cinematography" VARCHAR,
  "edited_by" VARCHAR,
  "languages" VARCHAR,
  "screenplay_by" VARCHAR,
  "countries" VARCHAR,
  "production_companies" VARCHAR,
  "color_process" VARCHAR,
  "japanese" VARCHAR,
  "hepburn" VARCHAR,
  "adaptation_by" VARCHAR,
  "animation_by" VARCHAR,
  "traditional" VARCHAR,
  "simplified" VARCHAR
);