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
tt0003165	Le mort qui tue	Le mort qui tue	1913	Thu Nov 06 1913 00:00:00 GMT+0000 (Coordinated Universal Time)	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
tt0004066	Det hemmelighedsfulde X	Det hemmelighedsfulde X	1914	Mon Mar 23 1914 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Mystery	84	Denmark	Danish	Benjamin Christensen	Benjamin Christensen, Laurids Skands	Dansk Biograf Compagni	Benjamin Christensen, Karen Caspersen, Otto Reinwald, Fritz Lamprecht, Amanda Lund, Hermann Spiro, Bjørn Spiro, Holger Bjerre, Otto Lagoni, Charles Løwaas, Holger Rasmussen, Svend Rindom, Robert Schmidt, Finn Wennerwald	On the brink of war, Lt. van Hauen is summoned to take command of the cruiser, but due to unforeseen events, he is wrongfully convicted as a traitor.	7	503	nan	nan	nan	7	4	28	det hemmelighedsfulde x
tt0007338	Sherlock Holmes	Sherlock Holmes	1916	Mon May 15 1916 00:00:00 GMT+0000 (Coordinated Universal Time)	Mystery	116	USA	English	Arthur Berthelet	H.S. Sheldon, William Gillette	The Essanay Film Manufacturing Company	William Gillette, Marjorie Kay, Ernest Maupain, Edward Fielding, Mario Majeroni, Grace Reals, William Postance, Stewart Robbins, Burford Hampden, Chester Beery, Frank Hamilton, Fred Malatesta, Leona Ball, Hugh Thompson, Ludwig Kreiss	When a couple of swindlers hold young Alice Faulkner against her will in order to discover the whereabouts of letters which could spell scandal for the royal family, Sherlock Holmes is on the case.	6.4	313	nan	nan	nan	10	16	34	sherlock holmes
tt0009701	Tih Minh	Tih Minh	1918	Fri Feb 07 1919 00:00:00 GMT+0000 (Coordinated Universal Time)	Adventure, Mystery	418	France	French	Louis Feuillade	Louis Feuillade	Société des Etablissements L. Gaumont	Mary Harald, René Cresté, Georges Biscot, Édouard Mathé, Louis Leubas, Gaston Michel, Marcel Marquet, Émile André, Georgette Faraboni, Jeanne Rollette, Lugane, Adeline de La Croix, Manuel Caméré	Jacques d'Athys, a French adventurer, returns to his home in Nice after an expedition to Indochina where he has picked up a Eurasian fiancée and a book that, unbeknownst to him, contains a ...	7	309	nan	nan	nan	1	7	34	tih minh
tt0010821	Un affare misterioso	Unheimliche Geschichten	1919	Wed Nov 05 1919 00:00:00 GMT+0000 (Coordinated Universal Time)	Fantasy, Horror, Mystery	112	Germany	nan	Richard Oswald	Anselma Heine, Robert Liebmann	Richard-Oswald-Produktion	Anita Berber, Conrad Veidt, Reinhold Schünzel, Hugo Döblin, Paul Morgan, Georg John	A demon, a reaper, and the ghost of a prostitute read gothic short stories and act them out.	6.5	447	nan	nan	nan	7	10	18	unheimliche geschichten
tt0011753	Terror Island	Terror Island	1920	Thu Apr 01 1920 00:00:00 GMT+0000 (Coordinated Universal Time)	Mystery	55	USA	English	James Cruze	Arthur B. Reeve, John Grey	Paramount Pictures	Harry Houdini, Jack Brammall, Lila Lee, Wilton Taylor, Eugene Pallette, Ed Brady, Frank Bonner, Taylor N. Duncan, F.A. Turner, Rosemary Theby	An inventor travels to the South Seas, where there is buried treasure belonging to a girl. The girl's father is being held captive by cannibals until she returns a pearl that belongs to one of their idols.	5.5	168	nan	nan	nan	5	2	37	terror island
tt0011904	The Ace of Hearts	The Ace of Hearts	1921	Sat Apr 14 1923 00:00:00 GMT+0000 (Coordinated Universal Time)	Crime, Drama, Mystery	75	USA	nan	Wallace Worsley	Gouverneur Morris, Ruth Wightman	Goldwyn Pictures Corporation	Lon Chaney, Leatrice Joy, John Bowers, Hardee Kirkland, Raymond Hatton, Edwin Wallock, Roy Laidlaw	A romantic rivalry among members of a secret society becomes even tenser when one of the men is assigned to carry out an assassination.	6.8	1037	nan	nan	nan	31	7	24	the ace of hearts
tt0013367	The Man from Beyond	The Man from Beyond	1922	Sun Apr 02 1922 00:00:00 GMT+0000 (Coordinated Universal Time)	Mystery	74	USA	English	Burton L. King	Harry Houdini, Coolidge Streeter	Houdini Picture Corporation	Harry Houdini, Arthur Maude, Albert Tavernier, Erwin Connelly, Frank Montgomery, Luis Alberni, Yale Benner, Jane Connelly, Nita Naldi	A man who has been frozen in the Arctic ice for 100 years returns to civilization to find his lost love.	5.4	226	nan	nan	nan	12	9	21	the man from beyond
tt0013597	Sherlock Holmes	Sherlock Holmes	1922	Tue Mar 07 1922 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Mystery	85	USA	English	Albert Parker	Earle Browne, Arthur Conan Doyle	Goldwyn Pictures Corporation	John Barrymore, Roland Young, Carol Dempster, Gustav von Seyffertitz, Louis Wolheim, Percy Knight, William Powell, Hedda Hopper, Peggy Bayfield, Margaret Kemp, Anders Randolf, Robert Schable, Reginald Denny, David Torrence, Robert Fischer	A young Sherlock Holmes seeks to bring down the criminal mastermind Moriarty as he solves a crime involving a blackmailed prince.	5.8	551	nan	$ 384770	nan	18	15	21	sherlock holmes
tt0014606	White Tiger	White Tiger	1923	Mon Dec 17 1923 00:00:00 GMT+0000 (Coordinated Universal Time)	Crime, Drama, Mystery	86	USA	English	Tod Browning	Tod Browning, Tod Browning	Universal Pictures	Priscilla Dean, Matt Moore, Raymond Griffith, Wallace Beery, Alfred Allen	Three crooks pull off a magnificent crime. As they're forced to hide out together they slowly begin to distrust each other.	6.2	117	nan	nan	nan	9	6	21	white tiger


CREATE TABLE mystery_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
);