Top 1000 IMDB Dataset

1000 movies dataset to be cleaned

@kaggle.fernandogarciah24_top_1000_imdb_dataset

Table List

2 tables(358.27 KB)

Movies Data

@kaggle.fernandogarciah24_top_1000_imdb_dataset.movies_data

103.55 KB
1000 rows
16 columns

series_title Series Title	released_year Released Year	certificate Certificate	runtime Runtime	genre Genre	subgenre Subgenre	subgenre_1 Subgenre 1	imdb_rating IMDB Rating	meta_score Meta Score	director Director	star1 Star1	star2 Star2	star3 Star3	star4 Star4	no_of_votes No Of Votes	gross Gross
The Shawshank Redemption	1994	A	142	Drama	nan	nan	9.3	80	Frank Darabont	Tim Robbins	Morgan Freeman	Bob Gunton	William Sadler	2343110	28341469
The Godfather	1972	A	175	Crime	Drama	nan	9.2	100	Francis Ford Coppola	Marlon Brando	Al Pacino	James Caan	Diane Keaton	1620367	134966411
The Dark Knight	2008	UA	152	Action	Crime	Drama	9	84	Christopher Nolan	Christian Bale	Heath Ledger	Aaron Eckhart	Michael Caine	2303232	534858444
The Godfather: Part II	1974	A	202	Crime	Drama	nan	9	90	Francis Ford Coppola	Al Pacino	Robert De Niro	Robert Duvall	Diane Keaton	1129952	57300000
12 Angry Men	1957	U	96	Crime	Drama	nan	9	96	Sidney Lumet	Henry Fonda	Lee J. Cobb	Martin Balsam	John Fiedler	689845	4360000
The Lord of the Rings: The Return of the King	2003	U	201	Action	Adventure	Drama	8.9	94	Peter Jackson	Elijah Wood	Viggo Mortensen	Ian McKellen	Orlando Bloom	1642758	377845905
Pulp Fiction	1994	A	154	Crime	Drama	nan	8.9	94	Quentin Tarantino	John Travolta	Uma Thurman	Samuel L. Jackson	Bruce Willis	1826188	107928762
Schindler's List	1993	A	195	Biography	Drama	History	8.9	94	Steven Spielberg	Liam Neeson	Ralph Fiennes	Ben Kingsley	Caroline Goodall	1213505	96898818
Inception	2010	UA	148	Action	Adventure	Sci-Fi	8.8	74	Christopher Nolan	Leonardo DiCaprio	Joseph Gordon-Levitt	Elliot Page	Ken Watanabe	2067042	292576195
Fight Club	1999	A	139	Drama	nan	nan	8.8	66	David Fincher	Brad Pitt	Edward Norton	Meat Loaf	Zach Grenier	1854740	37030102


CREATE TABLE movies_data (
  "series_title" VARCHAR,
  "released_year" VARCHAR,
  "certificate" VARCHAR,
  "runtime" BIGINT,
  "genre" VARCHAR,
  "subgenre" VARCHAR,
  "subgenre_1" VARCHAR,
  "imdb_rating" DOUBLE,
  "meta_score" DOUBLE,
  "director" VARCHAR,
  "star1" VARCHAR,
  "star2" VARCHAR,
  "star3" VARCHAR,
  "star4" VARCHAR,
  "no_of_votes" BIGINT,
  "gross" DOUBLE
);