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	reviews_from_users Reviews From Users	reviews_from_critics Reviews From Critics	description_words Description #words	movie_title Movie Title
tt0001892	Den sorte drøm	Den sorte drøm	1911	1911-08-19	Drama	53	Germany, Denmark	nan	Urban Gad	Urban Gad, Gebhard Schätzler-Perasini	Fotorama	Asta Nielsen, Valdemar Psilander, Gunnar Helsengreen, Emil Albes, Hugo Flink, Mary Hagen	Two men of high rank are both wooing the beautiful and famous equestrian acrobat Stella. While Stella ignores the jeweler Hirsch, she accepts Count von Waldberg's offer to follow her home, ...	5.8	188	nan	nan	nan	5	2	32	den sorte drøm
tt0002101	Cleopatra	Cleopatra	1912	1912-11-13	Drama, History	100	USA	English	Charles L. Gaskill	Victorien Sardou	Helen Gardner Picture Players	Helen Gardner, Pearl Sindelar, Miss Fielding, Miss Robson, Helene Costello, Charles Sindelar, Mr. Howard, James R. Waite, Mr. Osborne, Harry Knowles, Mr. Paul, Mr. Brady, Mr. Corker	The fabled queen of Egypt's affair with Roman general Marc Antony is ultimately disastrous for both of them.	5.2	446	$ 45000	nan	nan	25	3	18	cleopatra
tt0002130	L'Inferno	L'Inferno	1911	1911-03-06	Adventure, Drama, Fantasy	68	Italy	Italian	Francesco Bertolini, Adolfo Padovan	Dante Alighieri	Milano Film	Salvatore Papa, Arturo Pirovano, Giuseppe de Liguoro, Pier Delle Vigne, Augusto Milla, Attilio Motta, Emilise Beretta	Loosely adapted from Dante's Divine Comedy and inspired by the illustrations of Gustav Doré the original silent film has been restored and has a new score by Tangerine Dream.	7	2237	nan	nan	nan	31	14	29	l'inferno
tt0002199	From the Manger to the Cross; or, Jesus of Nazareth	From the Manger to the Cross; or, Jesus of Nazareth	1912	1913	Biography, Drama	60	USA	English	Sidney Olcott	Gene Gauntier	Kalem Company	R. Henderson Bland, Percy Dyer, Gene Gauntier, Alice Hollister, Samuel Morgan, James D. Ainsley, Robert G. Vignola, George Kellog, J.P. McGowan	An account of the life of Jesus Christ, based on the books of the New Testament: After Jesus' birth is foretold to his parents, he is born in Bethlehem, and is visited by shepherds and wise...	5.7	484	nan	nan	nan	13	5	36	from the manger to the cross; or, jesus of nazareth
tt0002423	Madame DuBarry	Madame DuBarry	1919	1919-11-26	Biography, Drama, Romance	85	Germany	German	Ernst Lubitsch	Norbert Falk, Hanns Kräly	Projektions-AG Union (PAGU)	Pola Negri, Emil Jannings, Harry Liedtke, Eduard von Winterstein, Reinhold Schünzel, Else Berna, Fred Immler, Gustav Czimeg, Karl Platen, Bernhard Goetzke, Magnus Stifter, Paul Biensfeldt, Willy Kaiser-Heyl, Alexander Ekert, Robert Sortsch-Pla	The story of Madame DuBarry, the mistress of Louis XV of France, and her loves in the time of the French revolution.	6.8	753	nan	nan	nan	12	9	22	madame dubarry
tt0002646	Atlantis	Atlantis	1913	1913-12-26	Drama	121	Denmark	Danish	August Blom	Axel Garde, Gerhart Hauptmann	Nordisk Film	Olaf Fønss, Ida Orloff, Ebba Thomsen, Carl Lauritzen, Frederik Jacobsen, Charles Unthan, Torben Meyer, Svend Bille, Oluf Billesborg, Maja Bjerre-Lind, Cajus Bruun, Michael Curtiz, Marie Dinesen, Vera Esbøll, Lily Frederiksen	After Dr. Friedrich's wife becomes mentally unstable and his research papers are rejected, he leaves the country to respite.	6.6	331	nan	nan	nan	9	9	19	atlantis
tt0003037	Juve contre Fantômas	Juve contre Fantômas	1913	1913-09-08	Crime, Drama	61	France	French	Louis Feuillade	Marcel Allain, Louis Feuillade	Société des Etablissements L. Gaumont	René Navarre, Edmund Breon, Georges Melchior, Renée Carl, Yvette Andréyor, Laurent Morléas	In Part Two of Louis Feuillade's 5 1/2-hour epic follows FantÃ'mas, the criminal lord of Paris, master of disguise, the creeping assassin in black, as he is pursued by the equally resourceful Inspector Juve.	7	1349	nan	nan	nan	8	23	34	juve contre fantômas
tt0003102	Ma l'amor mio non muore...	Ma l'amor mio non muore...	1914	1914-01-01	Drama	90	Italy	Italian	Mario Caserini	Emiliano Bonetti, G. Monleone	Film Artistica Gloria	Lyda Borelli, Mario Bonnard, Gian Paolo Rosmino, Vittorio Rossi Pianelli, Dante Cappelli, Maria Caserini, Camillo De Riso, Emilio Petacci, Antonio Monti, Letizia Quaranta, Felice Metellio, Gentile Miotti	Leslie Swayne, an adventurer, in order to obtain enough money to satisfy the needs of his extravagant life, has been bribed to steal the plans of the fortification from the staff officers ...	6.2	100	nan	nan	nan		4	33	ma l'amor mio non muore...
tt0003131	Maudite soit la guerre	Maudite soit la guerre	1914	1914-05-01	Drama, War	50	Belgium	French	Alfred Machin	Alfred Machin	Belge Cinéma Film	Baert, Suzanne Berni, Fernand Crommelynck, Nadia D'Angely, Henri Goidsen, Albert Hendrickx, Maurice Auzat, Renée Bailly, Georges Etienne, Zizi Festerat, Lucien Mussière, Réginald, Jane Tony	An army pilot is on a visit at the home of another army pilot in the neighboured country. He falls in love with his sister. After the outbreak of a war between the two countries, her ...	6.5	124	nan	nan	nan	2	2	37	maudite soit la guerre
tt0003165	Le mort qui tue	Le mort qui tue	1913	1913-11-06	Crime, Drama, Mystery	90	France	French	Louis Feuillade	Marcel Allain, Louis Feuillade	Société des Etablissements L. Gaumont	René Navarre, Edmund Breon, Georges Melchior, André Luguet, Luitz-Morat, Naudier, Armand Dutertre, Renée Carl, Fabienne Fabrèges, Jane Faber, Marie Dorly, Édouard Mathé	After a body disappears from inside the prison, a series of crimes take place, all seemingly by the dead man. With Juve presumed dead, Fandor must investigate alone. Will Fantomas finally be brought to justice?	7	1050	nan	nan	nan	6	18	35	le mort qui tue


CREATE TABLE all_df (
  "imdb_title_id" VARCHAR,
  "title" VARCHAR,
  "original_title" VARCHAR,
  "year" VARCHAR,
  "date_published" VARCHAR,
  "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
);