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
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
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
tt0003471	Traffic in Souls	Traffic in Souls	1913	1913-11-24	Crime, Drama	88	USA	English	George Loane Tucker	nan	Independent Moving Pictures Co. of America (IMP)	Jane Gail, Ethel Grandin, William H. Turner, Matt Moore, William Welsh, Millie Liston, Irene Wallace, William Cavanaugh, Arthur Hunter, Howard Crampton, W.H. Bainbridge, Luray Huntley, William Powers, Jack Poulton, Edward Boring	A woman, with the aid of her police officer sweetheart, endeavors to uncover the prostitution ring that has kidnapped her sister, and the philanthropist who secretly runs it.	6	552	$ 5700	nan	nan	14	11	28	traffic in souls
tt0003643	The Avenging Conscience: or 'Thou Shalt Not Kill'	The Avenging Conscience: or 'Thou Shalt Not Kill'	1914	1914-08-24	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'
tt0003883	L'enfant de Paris	L'enfant de Paris	1913	1913-09-17	Crime, Drama	124	France	French	Léonce Perret	Léonce Perret	Société des Etablissements L. Gaumont	Léonce Perret, Louis Leubas, Maurice Lagrenée, Émile Keppens, Marc Gérard, Henri Duval, Marie Dorly, Suzanne Le Bret, Jeanne Marie-Laurent, Adrien Petit, Suzanne Privat	The young daughter of an army captain missing in action runs away from school and is kidnapped by Parisian lowlifes. When the kidnapper flees to Nice with the child, the kind-hearted employee of one of his accomplices sets off in pursuit.	7.5	303	nan	nan	nan	7	4	41	l'enfant de paris
tt0003930	Fantômas contre Fantômas	Fantômas contre Fantômas	1914	1914-01-10	Crime, Drama	59	France	French	Louis Feuillade	Marcel Allain, Louis Feuillade	Société des Etablissements L. Gaumont	René Navarre, Georges Melchior, Laurent Morléas, Renée Carl, Jane Faber, Yvette Andréyor, Edmund Breon, Naudier	The mystery of the drama is the appearance of the finger-print of a dead artist upon the neck of Princess Sonia Danidoff, whom Fantomas, as Nanteuil, relieves of her pearl necklace, and ...	6.9	1161	nan	nan	nan	5	18	33	fantômas contre fantômas
tt0006206	I vampiri	Les vampires	1915	1915-11-13	Action, Adventure, Crime	421	France	French	Louis Feuillade	Louis Feuillade	Société des Etablissements L. Gaumont	Musidora, Édouard Mathé, Marcel Lévesque, Jean Aymé, Fernand Herrmann, Stacia Napierkowska, Renée Carl, Suzanne Delvé, Georgette Faraboni, Jacques Feyder, Fridolin, Rita Herlor, Émile Keppens, Louise Lagrange, Suzanne Le Bret	An intrepid reporter and his loyal friend battle a bizarre secret society of criminals known as The Vampires.	7.3	4166	nan	nan	nan	25	53	18	les vampires
tt0006617	Dödskyssen	Dödskyssen	1916	1916-08-25	Comedy, Crime, Drama	60	Sweden	nan	Victor Sjöström	A.V. Samsjö, Sam Ask	Svenska Biografteatern AB	Victor Sjöström, Albin Lavén, Mathias Taube, Wanda Rothgardt, Jenny Tschernichin-Larsson	Dr Monro is found dead in his home. Three people are testifying before the police about what happened.	6.1	199	nan	nan	nan		1	18	dödskyssen
tt0006731	Going Straight	Going Straight	1916	1916-06-04	Crime, Drama	60	USA	English	Chester M. Franklin, Sidney Franklin	Bernard McConville	Fine Arts Film Company	Norma Talmadge, Ralph Lewis, Ninon Fovieri, Francis Carpenter, Fern Collier, Ruth Handforth, Eugene Pallette, Georgie Stone, Kate Toncray, 'Baby' Carmen De Rue, Violet Radcliffe	A man and his wife both have criminal pasts, but have quit crime and are now respectable citizens. One day a member of their old gang shows up and threatens to expose them if they don't ...	5.3	609	nan	nan	nan	7		37	going straight
tt0006886	Judex	Judex	1916	1917-01-19	Adventure, Crime	300	France	French	Louis Feuillade	Arthur Bernède, Louis Feuillade	Société des Etablissements L. Gaumont	René Cresté, Musidora, René Poyen, Édouard Mathé, Gaston Michel, Yvonne Dario, Yvette Andréyor, Juliette Clarens, Jean Devalde, Georges Flateau, Louis Leubas, Marcel Lévesque, Olinda Mano	A twelve part serial following the adventures of the masked vigilante Judex as he fights against criminals led by the corrupt banker Favrauxom.	7.4	867	nan	nan	nan	11	15	23	judex


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