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
tt0003657	The Bargain	The Bargain	1914	Thu Dec 03 1914 00:00:00 GMT+0000 (Coordinated Universal Time)	Western	70	USA	English	Reginald Barker	William H. Clifford, Thomas H. Ince	New York Motion Picture	William S. Hart, J. Frank Burke, Clara Williams, J. Barney Sherry, Joseph J. Dowling	After the bandit Jim Stokes robs the stage he is wounded fleeing. Recuperating at a ranch, he falls in love with and marries the daughter. Now wishing to go straight he tries to return the ...	6.5	144	nan	nan	nan	8	3	36	the bargain
tt0004766	The Virginian	The Virginian	1914	Mon Sep 07 1914 00:00:00 GMT+0000 (Coordinated Universal Time)	Western	55	USA	English	Cecil B. DeMille	Owen Wister, Kirk La Shelle	Jesse L. Lasky Feature Play Company	Dustin Farnum, Jack W. Johnston, Sydney Deane, William Elmer, Winifred Kingston, James Griswold, Horace B. Carpenter, Tex Driscoll	A good-natured but chivalrous cowboy romances the local schoolmarm and leads the posse that brings a gang of rustlers, which includes his best friend, to justice.	5.6	174	$ 17022	nan	nan	12		26	the virginian
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
tt0006753	The Half-Breed	The Half-Breed	1916	Sun Jul 30 1916 00:00:00 GMT+0000 (Coordinated Universal Time)	Western	73	USA	English	Allan Dwan	Bret Harte, Anita Loos	Fine Arts Film Company	Douglas Fairbanks, Alma Rubens, Sam De Grasse, Tom Wilson, Frank Brownlee, Jewel Carmen, George Beranger	An outcast named Lo Dorman encounters a young woman lost in the woods. He defends her from danger in the forest and from Sheriff Dunn.	6.6	147	nan	nan	nan	9	6	25	the half-breed
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
tt0008634	Straight Shooting	Straight Shooting	1917	Mon Aug 27 1917 00:00:00 GMT+0000 (Coordinated Universal Time)	Western	57	USA	English	John Ford	George Hively	Universal Film Manufacturing Company	Harry Carey, Duke R. Lee, George Berrell, Molly Malone, Ted Brooks, Hoot Gibson, Milton Brown, Vester Pegg	Cattleman Flint cuts off farmer Sims' water supply. When Sims' son Ted goes for water, one of Flint's men kills him. Cheyenne is sent to finish off Sims, but finding the family at the newly dug grave, he changes sides.	6.2	372	nan	nan	nan	10	17	40	straight shooting
tt0008775	Wild and Woolly	Wild and Woolly	1917	Sun Jun 24 1917 00:00:00 GMT+0000 (Coordinated Universal Time)	Comedy, Western, Romance	72	USA	English	John Emerson	Horace B. Carpenter, Anita Loos	Douglas Fairbanks Pictures	Douglas Fairbanks, Eileen Percy, Calvert Carter, Charles Stevens, Sam De Grasse	A rich young Easterner who has always wanted to live in "the Wild West" plans to move to a Western town. Unknown to him, the town's "wild" days are long gone, and it is an orderly, ...	6.4	557	nan	nan	nan	8	3	37	wild and woolly
tt0009153	Indemoniato	Hell Bent	1918	Sat Jul 06 1918 00:00:00 GMT+0000 (Coordinated Universal Time)	Western	50	USA	nan	John Ford	John Ford, Harry Carey	Universal Film Manufacturing Company	Harry Carey, Duke R. Lee, Neva Gerber, Vester Pegg, Joe Harris, Steve Clemente, Millard K. Wilson, Molly Malone	A cowboy must save his girlfriend from captivity and then cross the desert on foot with a single waterhole on the way.	6.1	112	nan	nan	nan	2	5	22	hell bent
tt0009900	Il ritorno al paradiso terrestre	Back to God's Country	1919	Sun Jan 01 1922 00:00:00 GMT+0000 (Coordinated Universal Time)	Adventure, Romance, Western	73	Canada	nan	David Hartford	James Oliver Curwood, James Oliver Curwood	Canadian Photoplays Ltd.	Nell Shipman, Charles Arling, Wheeler Oakman, Wellington A. Playter	A woman finds herself all alone in a remote harbor with the man responsible for the murder of her father. With seemingly nobody around to protect her, she has to be resourceful.	6.3	857	$ 67000	nan	nan	11	6	32	back to god's country
tt0010662	Scarlet Days	Scarlet Days	1919	Sun Nov 09 1919 00:00:00 GMT+0000 (Coordinated Universal Time)	Adventure, Romance, Western	77	USA	English	D.W. Griffith	Stanner E.V. Taylor	D.W. Griffith Productions	Richard Barthelmess, Eugenie Besserer, Carol Dempster, Clarine Seymour, Ralph Graves, George Fawcett, Walter Long, Kate Bruce, Rhea Haines, Adolph Lestina, Herbert Sutch, J. Wesley Warner	A romantic bandit named Alvarez, wanted for raids on the mining camps of the California gold rush in 1849, is reformed by the love of a good woman.	4.9	420	nan	nan	nan	5		28	scarlet days


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