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
tt0003973	A Florida Enchantment	A Florida Enchantment	1914	1916-09-04	Comedy	63	USA	English	Sidney Drew	Marguerite Bertsch, Archibald Clavering Gunter	Vitagraph Company of America	Sidney Drew, Edith Storey, Charles Kent, Mrs. Sidney Drew, Ada Gifford, Ethel Lloyd, Lillian Burns, Grace Stevens, Allan Campbell, Cortland Van Deusen, Frank O'Neil	A young woman discovers a seed that can make women act like men and men act like women. She decides to take one, then slips one to her maid and another to her fiancé. The fun begins.	5.8	202	nan	nan	nan	6	3	37	a florida enchantment
tt0004825	The Wishing Ring: An Idyll of Old England	The Wishing Ring: An Idyll of Old England	1914	1914-11-09	Comedy, Drama	54	USA	English	Maurice Tourneur	Owen Davis, Maurice Tourneur	Shubert Film Corporation	Vivian Martin, Alec B. Francis, Chester Barnett, Gyp Williams, Simeon Wiltsie, Walter Morton, Johnny Hines	After being expelled from college, Giles runs away from home and meets a young lady who he falls for.	6.4	242	nan	nan	nan	6	2	19	the wishing ring: an idyll of old england
tt0006327	Young Romance	Young Romance	1915	1915-01-21	Comedy	59	USA	English	George Melford	William C. de Mille, William C. de Mille	Jesse L. Lasky Feature Play Company	Edith Taliaferro, Florence Dagmar, Tom Forman, Frederick Wilson, Al Ernest Garcia, Marshall Mackaye, Harry De Vere, J. Parks Jones, Violet Drew, Mrs. Lewis McCord, Gertrude Kellar, Charles Wells, Dorothy Abril, Miss White, Raymond Hatton	Young Romance, released in 1915, is a recent rediscovery that forever silences the claim that refined comedy cannot be conveyed via the screen. This disguise plot, worthy of an Elizabethan ...	5.9	151	nan	nan	nan	7	1	31	young romance
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
tt0006688	Flirting with Fate	Flirting with Fate	1916	1916-07-09	Adventure, Comedy	57	USA	English	Christy Cabanne	Robert M. Baker	Fine Arts Film Company	Douglas Fairbanks, Jewel Carmen, Howard Gaye, W.E. Lawrence, George Beranger, Dorothy Haydel, Lillian Langdon, Wilbur Higby, J.P. McCarty	In the midst of an emotional depression, a man hires a murderer to kill him. But the despair soon passes, and the man must now escape the killer he's hired to end his life.	6.4	143	nan	nan	nan	6	3	34	flirting with fate
tt0006809	His Picture in the Papers	His Picture in the Papers	1916	1916-02-13	Comedy	62	USA	English	John Emerson	John Emerson, Anita Loos	Fine Arts Film Company	Douglas Fairbanks, Clarence Handyside, Rene Boucicault, Jean Temple, Charles Butler, Loretta Blake, Homer Hunt, Helena Rupport	A young man can only get the woman he loves if he becomes famous and manages to get his picture in the newspapers. He determines to let nothing stand in the way of his doing exactly that, ...	5.9	127	$ 42600	nan	nan	8	4	38	his picture in the papers
tt0006826	Hoodoo Ann	Hoodoo Ann	1916	1916-03-26	Comedy, Drama, Romance	65	USA	English	Lloyd Ingraham	D.W. Griffith	Fine Arts Film Company	Mae Marsh, Robert Harron, William H. Brown, Wilbur Higby, Loyola O'Connor, Mildred Harris, Pearl Elmore, Anna Dodge, Charles Lee, Elmo Lincoln, Robert Lawler, Carl Stockdale	A little orphan girl believes that her life is falling apart. It seems that everything that could possibly go wrong does go wrong. However, certain things happen that begin to make her ...	5.6	837	nan	nan	nan	12		33	hoodoo ann
tt0007047	The Matrimaniac	The Matrimaniac	1916	1916-12-16	Comedy, Romance	46	USA	English	Paul Powell	Octavus Roy Cohen, John Emerson	Fine Arts Film Company	Douglas Fairbanks, Constance Talmadge, Wilbur Higby, Fred Warren, Clyde E. Hopkins, Winifred Westover	A young couple attempts to elope, with the bride's irate father in hot pursuit. The train stops briefly and the young man dashes off to find a minister, but before he can get himself and ...	6	573	nan	nan	nan	6		36	the matrimaniac
tt0007257	Reggie Mixes In	Reggie Mixes In	1916	1916-06-11	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
tt0007309	Schuhpalast Pinkus	Schuhpalast Pinkus	1916	1916-05-01	Comedy	45	Germany	German	Ernst Lubitsch	Hanns Kräly, Erich Schönfelder	Projektions-AG Union (PAGU)	Ernst Lubitsch, Else Kentner, Guido Herzfeld, Ossi Oswalda, Hanns Kräly, Fritz Rasp, Erich Schönfelder	Sally Pinkus is an German-Jewish boy who takes a job as a shoe store clerk after being expelled from school for goofing around. Soon fired for trying to court the owner's daughter, Pinkus ...	5.6	183	nan	nan	nan	2	1	34	schuhpalast pinkus


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