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
tt0009976	The Busher	The Busher	1919	Sun May 18 1919 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Sport	63	USA	English	Jerome Storm	R. Cecil Smith, Earle Snell	Thomas H. Ince Corporation	Charles Ray, Colleen Moore, John Gilbert, Jay Morley, Otto Hoffman	A young baseball pitcher in the bush leagues is discovered by a big-league manager and given his chance in the major leagues. But will he be up to the challenge?	5.7	631	nan	nan	nan	13	4	30	the busher
tt0010635	The Roaring Road	The Roaring Road	1919	Sun Apr 27 1919 00:00:00 GMT+0000 (Coordinated Universal Time)	Comedy, Drama, Sport	58	USA	English	James Cruze	Byron Morgan, Marion Fairfax	Paramount Pictures	Wallace Reid, Ann Little, Theodore Roberts, Guy Oliver, Clarence Geldart	A young man pursues a young lady with the same energy he applies to his other obsession in life, auto racing.	5.2	594	nan	nan	nan	6	2	21	the roaring road
tt0016226	The Plastic Age	The Plastic Age	1925	Tue Dec 15 1925 00:00:00 GMT+0000 (Coordinated Universal Time)	Comedy, Romance, Sport	73	USA	English	Wesley Ruggles	Frederica Sagor Maas, Percy Marks	B.P. Schulberg Productions	Donald Keith, Mary Alden, Henry B. Walthall, Gilbert Roland, Clara Bow, David Butler	Hugh Carver is an athletic star and a freshman at Prescott College. He falls in love with Cynthia Day, a popular girl who loves to go to parties. He finds that it is impossible to please ...	6	269	nan	nan	nan	11	2	37	the plastic age
tt0017534	L'allievo di West Point	West Point	1927	Tue Jan 01 1929 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Romance, Sport	95	USA	nan	Edward Sedgwick	Raymond L. Schrock, Joseph Farnham	Metro-Goldwyn-Mayer (MGM)	William Haines, Joan Crawford, William Bakewell, Neil Neely, Ralph Emerson, Leon Kellar, Raymond G. Moses	Wealthy Brice Wayne enters West Point and, though he does well on the football field, angers fellow cadets with his arrogance. Disciplined by the coach he yells "To hell with the Corps!" ...	6.4	1722	nan	nan	nan	15	5	33	west point
tt0017832	L'atleta innamorato	The Drop Kick	1927	Sun Sep 25 1927 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Sport	62	USA	English	Millard Webb	Katharine Brush, Winifred Dunn	First National Pictures	Richard Barthelmess, Barbara Kent, Dorothy Revier, Eugene Strong, Alberta Vaughn, James Bradbury Jr., Brooks Benedict, Hedda Hopper, Mayme Kelso, George C. Pearce	College football player Jack Hamill finds his reputation on the line when he pays an innocent visit to a woman whose husband kills himself.	4.8	206	nan	nan	nan	7	2	24	the drop kick
tt0018253	Ferro e fuoco	The Patent Leather Kid	1927	Thu Sep 01 1927 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Romance, Sport	150	USA	English	Alfred Santell	Gerald C. Duffy, Winifred Dunn	First National Pictures	Richard Barthelmess, Molly O'Day, Lawford Davidson, Matthew Betz, Arthur Stone, Ray Turner, Hank Mann, Walter James, Lucien Prival, Nigel De Brulier, Fred O'Beck, Clifford Salam, Henry Murdock, Charles Sullivan, John Kolb	A boxer has difficulty balancing his sport with a budding romance; both are further jeopardized when the United States enters the first World War.	5.8	468	nan	nan	nan	4	2	24	the patent leather kid
tt0019400	The Smart Set	The Smart Set	1928	Sat Mar 24 1928 00:00:00 GMT+0000 (Coordinated Universal Time)	Comedy, Romance, Sport	80	USA	English	Jack Conway	Byron Morgan, Ann Price	Metro-Goldwyn-Mayer (MGM)	William Haines, Jack Holt, Alice Day, Hobart Bosworth, Coy Watson, Constance Howard, Paul Nicholson, Julia Swayne Gordon	An American polo player, arrogant and full of himself, must vindicate his actions to win the heart of a girl, Polly, after getting himself booted off the U.S. polo team.	6.2	976	nan	nan	nan	9	1	30	the smart set
tt0020359	Saluto militare	Salute	1929	Sun Sep 01 1929 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Romance, Sport	84	USA	English	David Butler, John Ford	Tristram Tupper, John Stone	Fox Film Corporation	George O'Brien, Helen Chandler, William Janney, Stepin Fetchit, Frank Albertson, Joyce Compton, David Butler, Lumsden Hare, Clifford Dempsey, Ward Bond	West Point Cadet John and Annapolis Midshipman Frank focus their fraternal rivalry on the big Army-Navy football game.	5.5	156	nan	nan	nan	3	2	18	salute
tt0020392	Clem, bizzarro monello	The Shakedown	1929	Wed Jun 15 1932 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Sport	70	USA	English	William Wyler	Charles Logue, Charles Logue	Universal Pictures	James Murray, Barbara Kent, George Kotsonaros, Wheeler Oakman, Jack Hanlon, Harry Gribbon	Dave Roberts is a professional boxer better at losing in fixed matches than in knocking out his opponents. He turns up in towns and is part of a group who sets up corrupt boxing matches. ...	6.3	116	$ 50000	nan	nan	5	7	36	the shakedown
tt0020439	Cuori e motori	Speedway	1929	Sat Sep 07 1929 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Romance, Sport	76	USA	nan	Harry Beaumont	Byron Morgan, Ann Price	Metro-Goldwyn-Mayer (MGM)	William Haines, Anita Page, Ernest Torrence, Karl Dane, John Miljan, Eugenie Besserer, Polly Moran	Bill Whipple is a happy-go-lucky mechanic for MacDonald who thinks that he is the worlds greatest driver and lover. Mac has treated Bill like a son since he took him in. One day at the ...	6.1	602	nan	nan	nan	5	4	36	speedway


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