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
tt0002130	L'Inferno	L'Inferno	1911	Mon Mar 06 1911 00:00:00 GMT+0000 (Coordinated Universal Time)	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
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
tt0003772	Cinderella	Cinderella	1914	Mon Dec 28 1914 00:00:00 GMT+0000 (Coordinated Universal Time)	Fantasy, Drama	52	USA	English	James Kirkwood	Charles Perrault	Famous Players Film Company	Mary Pickford, Owen Moore, Isabel Vernon, Georgia Wilson, Lucille Carney, W.N. Cone, Inez Ranous	Though mistreated by her cruel stepmother and stepsisters, Cinderella is able to attend the royal ball through the help of a fairy godmother.	6	929	nan	nan	nan	10	3	23	cinderella
tt0004099	His Majesty, the Scarecrow of Oz	His Majesty, the Scarecrow of Oz	1914	Wed Oct 14 1914 00:00:00 GMT+0000 (Coordinated Universal Time)	Family, Fantasy, Adventure	59	USA	English	J. Farrell MacDonald	L. Frank Baum, L. Frank Baum	The Oz Film Manufacturing Company	Violet MacMillan, Frank Moore, Pierre Couderc, Fred Woodward, Raymond Russell, Arthur Smollet, J. Charles Haydon, Todd Wright, Vivian Reed, Mai Wells, Mildred Harris, Louise Emmons, Jacqueline Lovell	A wicked king has taken over the Emerald City, and wants his daughter, Princess Gloria, to marry the horrid courtier Googly-Goo, though she loves Pon, the Gardener's Boy. The camera now ...	5.2	415	$ 23500	nan	nan	11	7	32	his majesty, the scarecrow of oz
tt0004457	The Patchwork Girl of Oz	The Patchwork Girl of Oz	1914	Mon Sep 28 1914 00:00:00 GMT+0000 (Coordinated Universal Time)	Adventure, Family, Fantasy	81	USA	English	J. Farrell MacDonald	L. Frank Baum, L. Frank Baum	The Oz Film Manufacturing Company	Violet MacMillan, Frank Moore, Raymond Russell, Leontine Dranet, Bobbie Gould, Marie Wayne, Richard Rosson, Frank Bristol, Fred Woodward, Todd Wright, Bert Glennon, Hal Roach, Dave Anderson, Jessie May Walsh, William Cook	Ojo and Unc Nunkie are out of food, so they decide to journey to the Emerald City where they will never starve. Along the way, they meet Mewel, a waif and stray (mule) who leads them to Dr....	5.5	382	nan	nan	nan	16	5	38	the patchwork girl of oz
tt0004873	Alice in Wonderland	Alice in Wonderland	1915	Tue Jan 19 1915 00:00:00 GMT+0000 (Coordinated Universal Time)	Adventure, Family, Fantasy	52	USA	English	W.W. Young	Lewis Carroll, W.W. Young	Nonpareil Feature Film Corp.	Viola Savoy, Herbert Rice, Harry Marks, Louis Merkle, William Tilden	Alice goes with her sister to a picnic and then she falls asleep and starts dreaming about a wonderland full of talking animals and walking playing cards.	6.2	394	$ 50000	nan	nan	11	8	27	alice in wonderland
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
tt0007361	Snow White	Snow White	1916	Mon Dec 25 1916 00:00:00 GMT+0000 (Coordinated Universal Time)	Fantasy, Romance	63	USA	English	J. Searle Dawley	Winthrop Ames, Winthrop Ames	Famous Players Film Company	Dorothy Cumming, Creighton Hale, Lionel Braham, Alice Washburn, Marguerite Clark	Snow White is a motherless princess, who arouses the jealousy and hatred of Mary Jane, her mother's former lady-in-waiting, who is the ugliest woman in the kingdom, but aspires to the ...	6.2	349	nan	nan	nan	13	5	32	snow white
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


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