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
tt0003419	Lo studente di Praga	Der Student von Prag	1913	Fri Aug 22 1913 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Fantasy, Horror	85	Germany	German, English	Paul Wegener, Stellan Rye	Hanns Heinz Ewers, Hanns Heinz Ewers	Deutsche Bioscop GmbH	Paul Wegener, Grete Berger, Lyda Salmonova, John Gottowt, Lothar Körner, Fritz Weidemann	Balduin, a student of Prague, leaves his roystering companions in the beer garden, when he finds he has reached the end of his resources. He is scarcely seated in a quiet corner when a ...	6.5	1768	nan	nan	nan	20	26	35	der student von prag
tt0003643	The Avenging Conscience: or 'Thou Shalt Not Kill'	The Avenging Conscience: or 'Thou Shalt Not Kill'	1914	Mon Aug 24 1914 00:00:00 GMT+0000 (Coordinated Universal Time)	Crime, Drama, Horror	78	USA	English	D.W. Griffith	Edgar Allan Poe, D.W. Griffith	Majestic Motion Picture Company	Henry B. Walthall, Spottiswoode Aitken, Blanche Sweet, George Siegmann, Ralph Lewis, Mae Marsh, Robert Harron, George Beranger	Prevented from dating his sweetheart by his uncle, a young man turns his thoughts to murder.	6.4	1105	nan	nan	nan	14	11	16	the avenging conscience: or 'thou shalt not kill'
tt0004026	Der Golem	Der Golem	1915	Thu Apr 08 1915 00:00:00 GMT+0000 (Coordinated Universal Time)	Horror	60	Germany	German	Henrik Galeen, Paul Wegener	Henrik Galeen, Paul Wegener	Deutsche Bioscop GmbH	Paul Wegener, Henrik Galeen, Lyda Salmonova, Rudolf Blümner, Robert A. Dietrich, Carl Ebert, Jakob Tiedtke	In this version of the golem legend, the golem, a clay statue brought to life by Rabbi Loew in 16th century Prague to save the Jews from the ongoing brutal persecution by the city's rulers,...	6.8	1040	nan	nan	nan	5		35	der golem
tt0005951	Rapsodia satanica	Rapsodia satanica	1917	Sun Jul 01 1917 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Fantasy, Horror	55	Italy	nan	Nino Oxilia	Alberto Fassini, Alberto Fassini	Società Italiana Cines	Lyda Borelli, Andrea Habay, Ugo Bazzini, Giovanni Cini	A Faustian tale about an old woman who makes a pact with Mephisto to regain her youth, in return she must stay away from love. After the deal she meets two brothers who fall in love with her.	6.9	597	nan	nan	nan	5	5	38	rapsodia satanica
tt0007183	Pikovaya dama	Pikovaya dama	1916	Sat Apr 01 1916 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Fantasy, Horror	63	Russia	Russian	Yakov Protazanov	Alexander Pushkin, Fyodor Otsep	nan	Tamara Duvan, Ivan Mozzhukhin, Vera Orlova, Nikolai Panov, Polycarpe Pavloff, Yelizaveta Shebueva	While hosting a game of cards one night, Narumov tells his friends a story about his grandmother, a Countess. As a young woman, she had once incurred an enormous gambling debt, which she ...	7	610	nan	nan	$ 144968	7	5	34	pikovaya dama
tt0007983	Furcht	Furcht	1917	Mon Nov 12 1917 00:00:00 GMT+0000 (Coordinated Universal Time)	Horror	72	Germany	nan	Robert Wiene	Robert Wiene	nan	Bruno Decarli, Bernhard Goetzke, Mechthildis Thein, Conrad Veidt	After years travelling the world, Count Greven returns home with the art treasures he has collected. But his disposition has altered dramatically and he is a troubled man. Will he suffer ...	6.1	129	nan	nan	nan	3		32	furcht
tt0008854	Gli occhi della mummia	Die Augen der Mumie Ma	1918	Thu Oct 03 1918 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Horror	63	Germany	German	Ernst Lubitsch	Hanns Kräly, Emil Rameau	Projektions-AG Union (PAGU)	Pola Negri, Emil Jannings, Harry Liedtke, Max Laurence, Margarete Kupfer	A girl is kidnapped and held captive in an ancient Egyptian temple. She is rescued and flees to England, but soon finds that her mysterious captor is still haunting her.	5.5	554	nan	nan	nan	18	15	30	die augen der mumie ma
tt0010307	Per la patria	J'accuse	1919	Fri Apr 25 1919 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Horror, War	166	France	French	Abel Gance	Abel Gance	Pathé Frères	Romuald Joubé, Maxime Desjardins, Séverin-Mars, Angèle Guys, Maryse Dauvray, Mancini, Elizabeth Nizan, Pierre Danis, Blaise Cendrars, Paul Duc	The story of two men, one married, the other the lover of the other's wife, who meet in the trenches of the First World War, and how their tale becomes a microcosm for the horrors of war.	7.7	1417	nan	nan	nan	15	25	37	j'accuse
tt0010559	Die Pest in Florenz	Die Pest in Florenz	1919	Thu Oct 23 1919 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, History, Horror	92	Germany	nan	Otto Rippert	Fritz Lang, Edgar Allan Poe	Decla-Bioscop AG	Theodor Becker, Karl Bernhard, Julietta Brandt, Erner Huebsch, Franz Knaak, Otto Mannstaedt, Auguste Prasch-Grevenberg, Marga von Kierska, Hans Walter, Anders Wikman	Suddenly appearing in Florence, an evil seductress causes Cesare, the city's ruler, and his son to both fall madly in love with her. The son, killing his father before an order to torture ...	6.3	137	nan	nan	nan	2	3	34	die pest in florenz
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


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