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	metascore Metascore	reviews_from_users Reviews From Users	reviews_from_critics Reviews From Critics	description_words Description #words	movie_title Movie Title
tt0002101	Cleopatra	Cleopatra	1912	Wed Nov 13 1912 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, History	100	USA	English	Charles L. Gaskill	Victorien Sardou	Helen Gardner Picture Players	Helen Gardner, Pearl Sindelar, Miss Fielding, Miss Robson, Helene Costello, Charles Sindelar, Mr. Howard, James R. Waite, Mr. Osborne, Harry Knowles, Mr. Paul, Mr. Brady, Mr. Corker	The fabled queen of Egypt's affair with Roman general Marc Antony is ultimately disastrous for both of them.	5.2	446	$ 45000	nan	nan		25	3	18	cleopatra
tt0003740	Cabiria	Cabiria	1914	Sat Apr 18 1914 00:00:00 GMT+0000 (Coordinated Universal Time)	Adventure, Drama, History	148	Italy	Italian	Giovanni Pastrone	Gabriele D'Annunzio, Titus Livius	Itala Film	Carolina Catena, Lidia Quaranta, Gina Marangoni, Dante Testa, Umberto Mozzato, Bartolomeo Pagano, Raffaele di Napoli, Emilio Vardannes, Edoardo Davesnes, Italia Almirante-Manzini, Alex Bernard, Luigi Chellini, Vitale Di Stefano, Enrico Gemelli, Ignazio Lupi	Cabiria is a Roman child when her home is destroyed by a volcano. Sold in Carthage to be sacrificed in a temple, is saved by Fulvio, a Roman spy. But danger lurks, and hatred between Rome and Carthage can only lead to war.	7.1	3073	$ 210000	nan	nan		31	26	43	cabiria
tt0004150	In the Land of the Head Hunters	In the Land of the Head Hunters	1914	Mon Dec 07 1914 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, History	65	USA, Canada	English	Edward S. Curtis	Edward S. Curtis	Seattle Film Co.	Stanley Hunt, Sarah Constance Smith Hunt, Mrs. George Walkus, Paddy 'Malid, Balutsa, Kwagwanu, Francine Hunt, Bob Wilson, Awidi, Alfred Charlie	In 1911, as part of his massive undertaking, famed Northwest photographer Edward S. Curtis travelled to Vancouver Island, British Columbia, to visit the Kwakwaka'wakw. By the next year, ...	5.8	402	nan	nan	nan		8	11	29	in the land of the head hunters
tt0004972	Nascita di una nazione	The Birth of a Nation	1915	Sun Mar 21 1915 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, History, War	195	USA	nan	D.W. Griffith	Thomas Dixon Jr., Thomas Dixon Jr.	David W. Griffith Corp.	Henry B. Walthall, Lillian Gish, Mae Marsh, Miriam Cooper, Mary Alden, Ralph Lewis, George Siegmann, Walter Long, Robert Harron, Wallace Reid, Joseph Henabery, Elmer Clifton, Josephine Crowell, Spottiswoode Aitken, George Beranger	The Stoneman family finds its friendship with the Camerons affected by the Civil War, both fighting in opposite armies. The development of the war in their lives plays through to Lincoln's assassination and the birth of the Ku Klux Klan.	6.3	22213	$ 100000	nan	nan		368	97	40	the birth of a nation
tt0005149	The Coward	The Coward	1915	Sun Nov 14 1915 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, History, War	77	USA	English	Reginald Barker, Thomas H. Ince	Thomas H. Ince, Thomas H. Ince	Kay-Bee Pictures	Frank Keenan, Charles Ray, Gertrude Claire, Patricia Palmer, Nick Cogley, Charles K. French, Minnie Devereaux	Colonel Winslow, veteran of the Mexican War, hopes for a great future for his only son, Frank. At the outbreak of the Civil War, a recruiting station is opened in the Virginia village where...	6	244	$ 18000	nan	nan		15	3	34	the coward
tt0005719	Martyrs of the Alamo	Martyrs of the Alamo	1915	Sun Nov 21 1915 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, History, War	71	USA	English	Christy Cabanne	Christy Cabanne, Theodosia Harris	Fine Arts Film Company	Sam De Grasse, Allan Sears, Walter Long, Alfred Paget, Fred Burns, John T. Dillon, Juanita Hansen, Ora Carew, Tom Wilson, Augustus Carney	The story of the defense of the mission-turned-fortress by 185 Texans against an overwhelming Mexican army in 1836.	5.6	138	nan	nan	nan		5	1	18	martyrs of the alamo
tt0006864	Intolerance	Intolerance: Love's Struggle Throughout the Ages	1916	Sun Feb 24 1918 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, History	163	USA	English	D.W. Griffith	D.W. Griffith, Anita Loos	Triangle Film Corporation	Lillian Gish, Mae Marsh, Robert Harron, F.A. Turner, Sam De Grasse, Vera Lewis, Mary Alden, Eleanor Washington, Pearl Elmore, Lucille Browne, Julia Mackley, Miriam Cooper, Walter Long, Tom Wilson, Ralph Lewis	The story of a poor young woman, separated by prejudice from her husband and baby, is interwoven with tales of intolerance from throughout history.	7.8	13875	$ 385907	nan	nan	99	111	77	24	intolerance: love's struggle throughout the ages
tt0007801	Cleopatra	Cleopatra	1917	Sun Oct 14 1917 00:00:00 GMT+0000 (Coordinated Universal Time)	Biography, Drama, History	125	USA	English	J. Gordon Edwards	Adrian Johnson, Émile Moreau	Fox Film Corporation	Theda Bara, Fritz Leiber, Thurston Hall, Alan Roscoe, Herschel Mayall, Dorothy Drake, Delle Duncan, Henri De Vries, Art Acord, Hector V. Sarno, Genevieve Blinn	The story of Cleopatra, the fabulous queen of Egypt, and the epic romances between her and the greatest men of Rome, Julius Caesar and Antony.	6.5	298	$ 500000	nan	nan		3	3	25	cleopatra
tt0008150	Joan the Woman	Joan the Woman	1916	Mon Dec 25 1916 00:00:00 GMT+0000 (Coordinated Universal Time)	Adventure, Drama, History	138	USA	English	Cecil B. DeMille	Jeanie Macpherson, William C. de Mille	Paramount Pictures	Geraldine Farrar, Raymond Hatton, Hobart Bosworth, Theodore Roberts, Wallace Reid, Charles Clary, James Neill, Tully Marshall, Lawrence Peyton, Horace B. Carpenter, Cleo Ridgely, Lillian Leighton, Marjorie Daw, Ernest Joy, John Oaker	A WWI English officer is inspired the night before a dangerous mission by a vision of Joan of Arc, whose story he relives.	6.5	501	$ 302976	nan	nan		17	8	23	joan the woman
tt0008395	Otets Sergiy	Otets Sergiy	1918	Wed Jan 01 1919 00:00:00 GMT+0000 (Coordinated Universal Time)	Biography, Drama, History	112	Russia	nan	Yakov Protazanov, Alexandre Volkoff	Leo Tolstoy, Alexandre Volkoff	Yermoliev	Ivan Mozzhukhin, Olga Kondorova, V. Dzheneyeva, Vladimir Gajdarov, Nikolai Panov, Nathalie Lissenko, Iona Talanov, Vera Orlova, Pyotr Baksheyev, Polycarpe Pavloff, Nicolas Rimsky	Prince Kasatsky is a just and proud youth, shock and disappointment with the world bring him to church, he becomes father Sergius. It is a story of his piety and temptation.	7.1	458	nan	nan	nan		6	3	31	otets sergiy


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