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
tt0002423	Madame DuBarry	Madame DuBarry	1919	Wed Nov 26 1919 00:00:00 GMT+0000 (Coordinated Universal Time)	Biography, Drama, Romance	85	Germany	German	Ernst Lubitsch	Norbert Falk, Hanns Kräly	Projektions-AG Union (PAGU)	Pola Negri, Emil Jannings, Harry Liedtke, Eduard von Winterstein, Reinhold Schünzel, Else Berna, Fred Immler, Gustav Czimeg, Karl Platen, Bernhard Goetzke, Magnus Stifter, Paul Biensfeldt, Willy Kaiser-Heyl, Alexander Ekert, Robert Sortsch-Pla	The story of Madame DuBarry, the mistress of Louis XV of France, and her loves in the time of the French revolution.	6.8	753	nan	nan	nan	12	9	22	madame dubarry
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
tt0004838	The Wrath of the Gods	The Wrath of the Gods	1914	Mon Jun 08 1914 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Romance	56	USA	English	Reginald Barker	William H. Clifford, Thomas H. Ince	New York Motion Picture	Sessue Hayakawa, Tsuru Aoki, Frank Borzage, Kisaburô Kurihara, Henry Kotani, Gladys Brockwell, Herschel Mayall	An American sailor falls in love with a fisherman's daughter and convinces her that Jesus is more powerful than the gods who have cursed her.	5.7	138	nan	nan	nan	5	2	25	the wrath of the gods
tt0005078	The Cheat	The Cheat	1915	Mon Dec 13 1915 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Romance	59	USA	English	Cecil B. DeMille	Hector Turnbull, Jeanie Macpherson	Jesse L. Lasky Feature Play Company	Fannie Ward, Sessue Hayakawa, Jack Dean, James Neill, Yutaka Abe, Dana Ong, Hazel Childers, Arthur H. Williams	A venal, spoiled stockbroker's wife impulsively embezzles $10,000 from the charity she chairs and desperately turns to a Burmese ivory trader to replace the stolen money.	6.6	2305	$ 17311	nan	nan	38	19	26	the cheat
tt0006736	The Good Bad-Man	The Good Bad-Man	1916	Fri Apr 21 1916 00:00:00 GMT+0000 (Coordinated Universal Time)	Romance, Western	50	USA	English	Allan Dwan	Douglas Fairbanks	Fine Arts Film Company	Douglas Fairbanks, Sam De Grasse, Pomeroy Cannon, Joseph Singleton, Bessie Love, Mary Alden, George Beranger, Fred Burns	An outlaw calling himself Passin' Through halts his "evil" ways long enough to help out some children in difficulty.	6.6	166	nan	nan	nan	5	2	19	the good bad-man
tt0006780	Hell's Hinges	Hell's Hinges	1916	Sun Mar 05 1916 00:00:00 GMT+0000 (Coordinated Universal Time)	Romance, Western	64	USA	English	Charles Swickard, William S. Hart	C. Gardner Sullivan, C. Gardner Sullivan	Kay-Bee Pictures	William S. Hart, Clara Williams, Jack Standing, Alfred Hollingsworth, Robert McKim, J. Frank Burke, Louise Glaum	In the wayward western town known as Hell's Hinges, a local tough guy is reformed by the faith of a good woman.	6.8	836	nan	nan	nan	21	11	22	hell's hinges
tt0006826	Hoodoo Ann	Hoodoo Ann	1916	Sun Mar 26 1916 00:00:00 GMT+0000 (Coordinated Universal Time)	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	Sat Dec 16 1916 00:00:00 GMT+0000 (Coordinated Universal Time)	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
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
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


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