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
tt0004465	The Perils of Pauline	The Perils of Pauline	1914	Mon Mar 23 1914 00:00:00 GMT+0000 (Coordinated Universal Time)	Action, Adventure, Drama	199	USA	English	Louis J. Gasnier, Donald MacKenzie	Charles W. Goddard, Basil Dickey	Pathé Frères	Pearl White, Crane Wilbur, Paul Panzer, Edward José, Francis Carlyle, Clifford Bruce, Donald MacKenzie, Jack Standing, Eleanor Woodruff, Leroy Baker, Louise Du Pre, Oscar Nye, Sam J. Ryan, Louis J. Gasnier, Joe Cuny	Young Pauline is left a lot of money when her wealthy uncle dies. However, her uncle's secretary has been named as her guardian until she marries, at which time she will officially take ...	6.3	939	$ 25000	nan	nan	5	8	34	the perils of pauline
tt0004635	The Squaw Man	The Squaw Man	1914	Sun Feb 15 1914 00:00:00 GMT+0000 (Coordinated Universal Time)	Action, Drama, Romance	74	USA	English	Oscar Apfel, Cecil B. DeMille	Edwin Milton Royle, Cecil B. DeMille	Jesse L. Lasky Feature Play Company	Dustin Farnum, Monroe Salisbury, Winifred Kingston, Mrs. A.W. Filson, Haidee Fuller, Red Wing, Foster Knox, Fred Montague, 'Baby' Carmen De Rue, Fernando Gálvez, Eugene De Rue, H.R. Macy, H.L. Swisher, Michael J. Kilpatrick, Sydney Deane	A chivalrous British officer takes the blame for his cousin's embezzlement and journeys to the American West to start a new life on a cattle ranch.	5.7	879	$ 20000	nan	nan	8	3	26	the squaw man
tt0006206	I vampiri	Les vampires	1915	Sat Nov 13 1915 00:00:00 GMT+0000 (Coordinated Universal Time)	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
tt0007257	Reggie Mixes In	Reggie Mixes In	1916	Sun Jun 11 1916 00:00:00 GMT+0000 (Coordinated Universal Time)	Action, Comedy, Drama	50	USA	English	Christy Cabanne	Robert M. Baker, Roy Somerville	Fine Arts Film Company	Douglas Fairbanks, Bessie Love, Joseph Singleton, William Lowery, Wilbur Higby, Frank Bennett, Allan Sears, Lillian Langdon, Alma Rubens, Alberta Lee, Tom Wilson	Reggie, a wealthy young man about town, is eager for excitement, so he takes to visiting the rougher sections of the city in search of thrills. He meets and falls for a cabaret singer, but ...	4.7	564	nan	nan	nan	4		36	reggie mixes in
tt0007260	The Return of Draw Egan	The Return of Draw Egan	1916	Sun Oct 15 1916 00:00:00 GMT+0000 (Coordinated Universal Time)	Action, Adventure, Romance	50	USA	English	William S. Hart	C. Gardner Sullivan, C. Gardner Sullivan	Kay-Bee Pictures	William S. Hart, Margery Wilson, Robert McKim, Louise Glaum, J.P. Lockney	Outlaw leader "Draw" Egan, believed dead, turns up in the town of Yellow Dog. The townsfolk believe him to be William Blake, a strong and law-abiding man. They appoint him sheriff to rid ...	6.5	141	nan	nan	nan	6	1	34	the return of draw egan
tt0009682	Tarzan of the Apes	Tarzan of the Apes	1918	Sun Jan 27 1918 00:00:00 GMT+0000 (Coordinated Universal Time)	Action, Adventure	73	USA	nan	Scott Sidney	Edgar Rice Burroughs, Fred Miller	National Film Corporation of America	Elmo Lincoln, Enid Markey, True Boardman, Kathleen Kirkham, George B. French, Gordon Griffith, Colin Kenny, Thomas Jefferson, Bessie Toner, Jack Wilson, Louis Morrison, Eugene Pallette, Fred L. Wilson	Reared by a childless ape, the orphaned heir of the Greystokes becomes one of the apes. Then, Dr Porter organises a rescue expedition, and his beautiful daughter, Jane, catches his attention. Has Tarzan of the Apes found the perfect mate?	5.7	684	nan	$ 3270000	nan	14	21	40	tarzan of the apes
tt0009894	El automóvil gris	El automóvil gris	1919	Thu Dec 11 1919 00:00:00 GMT+0000 (Coordinated Universal Time)	Action, Crime	223	Mexico	Spanish	Enrique Rosas	Juan Manuel Cabrera, Miguel Necoechea	Azteca Films	Joaquín Coss, Juan de Homs, Manuel de los Ríos, María Teresa Montoya, Dora Vila, Valentín Asperó, Juan Manuel Cabrera, Enrique Cantalaúba, Russo Conde, Ángel Esquivel, Francisco Ferriz, María Mercedes Ferriz, Miguel Ángel Ferriz, Ernesto Finance, Antonio Galé	A gang terrorizes Mexico City's high society on 1915. Murder, kidnaping and robbery are their trademarks. One police inspector (Cabrera) follows the gang crimes and eventually send them to ...	7.1	168	nan	nan	nan	1	2	30	el automóvil gris
tt0011387	The Last of the Mohicans	The Last of the Mohicans	1920	Sun Nov 21 1920 00:00:00 GMT+0000 (Coordinated Universal Time)	Action, Adventure, Drama	73	USA	English	Clarence Brown, Maurice Tourneur	James Fenimore Cooper, Robert Dillon	Maurice Tourneur Productions	Wallace Beery, Barbara Bedford, Alan Roscoe, Lillian Hall, Henry Woodward, James Gordon, George Hackathorne, Nelson McDowell, Harry Lorraine, Theodore Lorch, Jack McDonald, Sydney Deane, Joseph Singleton	As Alice and Cora Munro attempt to find their father, a British officer in the French and Indian War, they are set upon by French soldiers and their cohorts, Huron tribesmen led by the evil...	6.7	1102	nan	nan	nan	28	7	35	the last of the mohicans
tt0011908	Adventures of Tarzan	Adventures of Tarzan	1921	Thu Dec 01 1921 00:00:00 GMT+0000 (Coordinated Universal Time)	Action, Adventure	73	USA	English	Robert F. Hill, Scott Sidney	Edgar Rice Burroughs, Robert F. Hill	Great Western Producing Company	Elmo Lincoln, Louise Lorraine, Scott Pembroke, Frank Whitson, Zip Monberg, Lillian Worth, Charles Gay, Charles Inslee, Maceo Bruce Sheffield, Fifi R. Lachoy, Frank Merrill, Joe Martin, George B. French, Gordon Griffith, Thomas Jefferson	Tarzan spurns the love of La, Queen of Opar. When he isn't trying to keep the Bolshevik Rokoff and Clayton (pretender to the Greystoke estate) from reaching Opar, he is attacked ...	6	101	nan	nan	nan	1	3	32	adventures of tarzan
tt0012513	The Nut	The Nut	1921	Sun Mar 06 1921 00:00:00 GMT+0000 (Coordinated Universal Time)	Action, Comedy, Romance	74	USA	English	Theodore Reed	Kenneth Davenport, Douglas Fairbanks	Douglas Fairbanks Pictures	Douglas Fairbanks, Marguerite De La Motte, William Lowery, Gerald Pring, Morris Hughes, Barbara La Marr, Sidney De Gray	Eccentric inventor Charlie Jackson tries to interest wealthy investors in his girlfriend's plan to help children from poor neighborhoods.	6.5	209	nan	nan	nan	9	2	19	the nut


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