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
tt0011833	Von morgens bis mitternachts	Von morgens bis mitternachts	1920	Thu Jan 01 1920 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Thriller	65	Germany	German	Karl Heinz Martin	Herbert Juttke, Georg Kaiser	Ilag-Film	Ernst Deutsch, Erna Morena, Roma Bahn, Adolf E. Licho, Hans Heinrich von Twardowski, Elsa Wagner, Frida Richard, Eberhard Wrede, Lo Heym, Hugo Döblin, Lotte Stein	A Cashier in a bank in a small German town is alerted to the power of money by the visit of a rich Italian lady. He embezzles 60, 000 Marks and leaves for the capital city, where he ...	6.9	425	nan	nan	nan	6	10	39	von morgens bis mitternachts
tt0012494	Destino	Der müde Tod	1921	Thu Jan 01 1925 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Fantasy, Thriller	97	Germany	German	Fritz Lang	Fritz Lang, Thea von Harbou	Decla-Bioscop AG	Bernhard Goetzke, Lil Dagover, Walter Janssen, Hans Sternberg, Karl Rückert, Max Adalbert, Wilhelm Diegelmann, Erich Pabst, Karl Platen, Hermann Picha, Paul Rehkopf, Max Pfeiffer, Georg John, Lydia Potechina, Grete Berger	When a woman's fiancé disappears, Death gives her three chances to save him from his fate.	7.7	5136	nan	$ 12156	$ 12156	34	43	16	der müde tod
tt0012538	Outside the Law	Outside the Law	1920	Thu Jan 06 1921 00:00:00 GMT+0000 (Coordinated Universal Time)	Crime, Romance, Thriller	75	USA	English	Tod Browning	Gardner Bradford, Tod Browning	Universal Film Manufacturing Company	Priscilla Dean, Wheeler Oakman, Lon Chaney, Ralph Lewis, E. Alyn Warren, Stanley Goethals, Melbourne MacDowell, Wilton Taylor	In this early collaboration with director Tod Browning (Dracula, Freaks), Chaney delivers a dual performance of dramatic intensity, starring as Ah Wing, a kind-hearted student of Confucian ...	6.5	469	nan	nan	nan	17	9	28	outside the law
tt0013140	Femmine folli	Foolish Wives	1922	Wed Jan 11 1922 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Thriller	117	USA	Latin, French, English	Erich von Stroheim	Erich von Stroheim, Marian Ainslee	Universal Film Manufacturing Company	Rudolph Christians, Miss DuPont, Maude George, Mae Busch, Erich von Stroheim, Dale Fuller, Albert Edmondson, Cesare Gravina, Malvina Polo, C.J. Allen	A con artist masquerades a Russian nobility and attempts to seduce the wife of an American diplomat.	7	3072	$ 1100000	nan	nan	26	31	17	foolish wives
tt0014341	Accidenti che ospitalità!	Our Hospitality	1923	Fri Nov 27 1925 00:00:00 GMT+0000 (Coordinated Universal Time)	Comedy, Romance, Thriller	65	USA	English	John G. Blystone, Buster Keaton	Jean C. Havez, Clyde Bruckman	Joseph M. Schenck Productions	Buster Keaton, Natalie Talmadge, Joe Roberts, Francis X. Bushman Jr., Monte Collins, Craig Ward, Joe Keaton, Kitty Bradbury, Buster Keaton Jr.	A man returns to his Appalachian homestead. On the trip, he falls for a young woman. The only problem is her family has vowed to kill every member of his family.	7.8	9902	nan	nan	nan	54	47	31	our hospitality
tt0014429	Preferisco l'ascensore	Safety Last!	1923	Mon Dec 08 1924 00:00:00 GMT+0000 (Coordinated Universal Time)	Action, Comedy, Thriller	74	USA	English	Fred C. Newmeyer, Sam Taylor	Hal Roach, Sam Taylor	Hal Roach Studios	Harold Lloyd, Mildred Davis, Bill Strother, Noah Young, Westcott Clarke	A boy leaves his small country town and heads to the big city to get a job. As soon as he makes it big his sweetheart will join him and marry him. His enthusiasm to get ahead leads to some interesting adventures.	8.1	17795	$ 121000	nan	nan	91	93	42	safety last!
tt0014972	Quello che prende gli schiaffi	He Who Gets Slapped	1924	Thu Feb 04 1926 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Romance, Thriller	95	USA	English	Victor Sjöström	Leonid Andreyev, Carey Wilson	Metro-Goldwyn-Mayer (MGM)	Lon Chaney, Norma Shearer, John Gilbert, Ruth King, Marc McDermott, Ford Sterling, Tully Marshall, Pierre Watkin	A bitter clown endeavors to rescue the young woman he loves from the lecherous count who once betrayed him.	7.8	3044	$ 172000	nan	nan	48	22	19	he who gets slapped
tt0015648	La corazzata Potemkin	Bronenosets Potemkin	1925	Thu Apr 07 1960 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, History, Thriller	75	Soviet Union	Russian	Sergei M. Eisenstein	Nina Agadzhanova	Goskino	Aleksandr Antonov, Vladimir Barskiy, Grigoriy Aleksandrov, Ivan Bobrov, Mikhail Gomorov, Aleksandr Levshin, N. Poltavtseva, Konstantin Feldman, Prokhorenko, A. Glauberman, Beatrice Vitoldi, Daniil Antonovich, Iona Biy-Brodskiy, Julia Eisenstein, Sergei M. Eisenstein	In the midst of the Russian Revolution of 1905, the crew of the battleship Potemkin mutiny against the brutal, tyrannical regime of the vessel's officers. The resulting street demonstration in Odessa brings on a police massacre.	8	51775	nan	$ 51198	$ 61389	210	85	36	bronenosets potemkin
tt0015881	Rapacità	Greed	1924	Mon Jan 26 1925 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Thriller, Western	140	USA	English	Erich von Stroheim	June Mathis, Erich von Stroheim	Metro-Goldwyn Pictures Corporation	Zasu Pitts, Gibson Gowland, Jean Hersholt, Dale Fuller, Tempe Pigott, Sylvia Ashton, Chester Conklin, Joan Standing	The sudden fortune won from a lottery fans such destructive greed that it ruins the lives of the three people involved.	8.1	8898	$ 546883	nan	nan	88	50	21	greed
tt0016039	Un mondo perduto	The Lost World	1925	Mon Jun 22 1925 00:00:00 GMT+0000 (Coordinated Universal Time)	Adventure, Fantasy, Thriller	110	USA	nan	Harry O. Hoyt	Arthur Conan Doyle, Marion Fairfax	First National Pictures	Bessie Love, Lewis Stone, Wallace Beery, Lloyd Hughes, Alma Bennett, Arthur Hoyt, Margaret McWade, Bull Montana, Frank Finch Smiles, Jules Cowles, George Bunny, Charles Wellesley, Jocko the Monkey, Arthur Conan Doyle	The first film adaptation of Sir Arthur Conan Doyle's classic novel about a land where prehistoric creatures still roam.	7	4513	nan	$ 1194450	$ 2834000	84	64	19	the lost world


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