IMDb Genre-wise Movies Dataset And Sparse Matrices

imdb_title_id Imdb Title Id	title Title	original_title Original Title	year Year	date_published Date Published	genre Genre	duration Duration	country Country	language Language	director Director	writer Writer	production_company Production Company	actors Actors	description Description	avg_vote Avg Vote	votes Votes	budget Budget	usa_gross_income Usa Gross Income	worlwide_gross_income Worlwide Gross Income	metascore Metascore	reviews_from_users Reviews From Users	reviews_from_critics Reviews From Critics	description_words Description #words	movie_title Movie Title
tt0008100	L'astronave	Himmelskibet	1918	Fri Feb 22 1918 00:00:00 GMT+0000 (Coordinated Universal Time)	Adventure, Fantasy, Sci-Fi	97	Denmark	nan	Holger-Madsen	Sophus Michaëlis, Sophus Michaëlis	Nordisk Film	Gunnar Tolnæs, Zanny Petersen, Nicolai Neiiendam, Alf Blütecher, Svend Kornbeck, Philip Bech, Lilly Jacobson, Frederik Jacobsen, Birger von Cotta-Schønberg, Albert Paul	A group of researchers from Earth travel in a spaceship to Mars, where, to big surprise, they find a peaceful vegetarian and pacifist civilization.	6.5	585	nan	nan	nan		14	13	24	himmelskibet
tt0011130	Dr. Jekyll e Mr. Hyde	Dr. Jekyll and Mr. Hyde	1920	Tue Sep 28 1920 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Horror, Sci-Fi	69	USA	English	John S. Robertson	Robert Louis Stevenson, Clara Beranger	Paramount Pictures	John Barrymore, Brandon Hurst, Martha Mansfield, Charles Lane, Cecil Clovelly, Nita Naldi, Louis Wolheim	Dr. Henry Jekyll experiments with scientific means of revealing the hidden, dark side of man and releases a murderer from within himself.	7	4753	nan	nan	nan		73	67	22	dr. jekyll and mr. hyde
tt0014721	Black Oxen	Black Oxen	1923	Tue Jan 01 1924 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Romance, Sci-Fi	80	USA	English	Frank Lloyd	Gertrude Atherton, Frank Lloyd	Frank Lloyd Productions	Corinne Griffith, Conway Tearle, Tom Ricketts, Tom Guise, Clara Bow, Kate Lester, Harry Mestayer, Lincoln Stedman, Claire McDowell, Alan Hale, Clarissa Selwynne, Fred Gamble, Percy Williams, Otto Nelson, Eric Mayne	A Manhattan playboy falls in love with a mysterious European woman, whom he notices as an exact double for a famous socialite who disappeared at the turn of the century. At first, he thinks...	5.9	131	nan	nan	nan		8	3	34	black oxen
tt0017136	Metropolis	Metropolis	1927	Mon Oct 01 1928 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Sci-Fi	153	Germany	German	Fritz Lang	Thea von Harbou, Thea von Harbou	Universum Film (UFA)	Alfred Abel, Gustav Fröhlich, Rudolf Klein-Rogge, Fritz Rasp, Theodor Loos, Erwin Biswanger, Heinrich George, Brigitte Helm	In a futuristic city sharply divided between the working class and the city planners, the son of the city's mastermind falls in love with a working class prophet who predicts the coming of a savior to mediate their differences.	8.3	156076	DEM 6000000	$ 1236166	$ 1349711	98	495	208	39	metropolis
tt0020198	L'isola misteriosa	The Mysterious Island	1929	Sat Oct 05 1929 00:00:00 GMT+0000 (Coordinated Universal Time)	Adventure, Romance, Sci-Fi	95	USA	English	Lucien Hubbard, Benjamin Christensen	Jules Verne, Lucien Hubbard	Metro-Goldwyn-Mayer (MGM)	Lionel Barrymore, Jacqueline Gadsdon, Lloyd Hughes, Montagu Love, Harry Gribbon, Snitz Edwards, Gibson Gowland, Dolores Brinkman, Karl Dane	On a volcanic island near the kingdom of Hetvia rules Count Dakkar, a benevolent leader and scientist who has eliminated class distinction among the island's inhabitants. Dakkar, his ...	6.1	562	$ 1130000	nan	nan		21	19	29	the mysterious island
tt0021864	La fine del mondo	La fin du monde	1931	Tue Oct 27 1931 00:00:00 GMT+0000 (Coordinated Universal Time)	Sci-Fi	105	France	French	Abel Gance	Jean Boyer, Camille Flammarion	L'Écran d'Art	Abel Gance, Colette Darfeuil, Sylvie Gance, Jeanne Brindeau, Samson Fainsilber, Georges Colin, Jean d'Yd, Victor Francen, Albert Bras, Vanda Gréville, Major Heitner, Philippe Hersent, L. Laumon, Monique Rolland, Saint-Allier	The two Novalic brothers, Jean and Martial, are in love with the same woman, Genevieve. Jean is an impoverished actor and an idealistic dreamer, who does not want Genevieve to share in his ...	6.1	221	nan	nan	nan		4	7	34	la fin du monde
tt0022835	Il dottor Jekyll	Dr. Jekyll and Mr. Hyde	1931	Sun Jan 03 1932 00:00:00 GMT+0000 (Coordinated Universal Time)	Horror, Sci-Fi	98	USA	English	Rouben Mamoulian	Samuel Hoffenstein, Percy Heath	Paramount Pictures	Fredric March, Miriam Hopkins, Rose Hobart, Holmes Herbert, Halliwell Hobbes, Edgar Norton, Tempe Pigott	Dr. Jekyll faces horrible consequences when he lets his dark side run wild with a potion that transforms him into the animalistic Mr. Hyde.	7.6	12225	$ 535000	nan	$ 16615		127	62	24	dr. jekyll and mr. hyde
tt0022869	FP 1 non risponde	F.P.1 antwortet nicht	1932	Thu Dec 22 1932 00:00:00 GMT+0000 (Coordinated Universal Time)	Sci-Fi	114	Germany	German	Karl Hartl	Walter Reisch, Curt Siodmak	Universum Film (UFA)	Hans Albers, Sybille Schmitz, Paul Hartmann, Peter Lorre, Hermann Speelmans, Paul Westermeier, Friedrich Gnaß, Georg John, Georg August Koch, Philipp Manning, Erik Ode, Arthur Peiser, Rudolf Platte, Gustav Püttjer, Hans Schneider	Urged by famous airman Ellissen the Lennartz Company puts into reality the project proposed by his friend Droste: F.P.1, a huge floating platform in the Atlantic that makes long-distance ...	6.3	201	nan	nan	nan		6	4	30	f.p.1 antwortet nicht
tt0023002	Atlantide	Die Herrin von Atlantis	1932	Tue Jun 28 1932 00:00:00 GMT+0000 (Coordinated Universal Time)	Fantasy, Sci-Fi	87	Germany, France	German	Georg Wilhelm Pabst	Pierre Benoît, Alexandre Arnoux	Nero-Film AG	Brigitte Helm, Heinz Klingenberg, Tela Tchaï, Gustav Diessl, Georges Tourreil, Vladimir Sokoloff, Mathias Wieman, Florelle, Gertrude Pabst, Rositta Severus-Liedernit, Martha von Konssatzki	Two French Foreign Legionnaires are lost amid the shifting sands of the Sahara Desert when they stumble across the entrance to an underground world. Searching this new found subterranean ...	6.1	503	nan	nan	nan			4	30	die herrin von atlantis
tt0023480	Ancora sei ore di vita	6 Hours to Live	1932	Sun Oct 16 1932 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Mystery, Sci-Fi	72	USA	English	William Dieterle	Morton Barteaux, Bradley King	Fox Film Corporation	Warner Baxter, Miriam Jordan, John Boles, George F. Marion, Halliwell Hobbes, Irene Ware, Beryl Mercer, Edward McWade, John Davidson, Edwin Maxwell, Dewey Robinson	A murder victim is brought back to life by a scientific experiment. However, the effects only last for six hours, and he must find his killer in that time.	6.3	117	nan	nan	nan		9	4	29	6 hours to live


CREATE TABLE sci_fi_df (
  "imdb_title_id" VARCHAR,
  "title" VARCHAR,
  "original_title" VARCHAR,
  "year" BIGINT,
  "date_published" TIMESTAMP,
  "genre" VARCHAR,
  "duration" BIGINT,
  "country" VARCHAR,
  "language" VARCHAR,
  "director" VARCHAR,
  "writer" VARCHAR,
  "production_company" VARCHAR,
  "actors" VARCHAR,
  "description" VARCHAR,
  "avg_vote" DOUBLE,
  "votes" BIGINT,
  "budget" VARCHAR,
  "usa_gross_income" VARCHAR,
  "worlwide_gross_income" VARCHAR,
  "metascore" DOUBLE,
  "reviews_from_users" DOUBLE,
  "reviews_from_critics" DOUBLE,
  "description_words" BIGINT,
  "movie_title" VARCHAR
);