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
tt0018526	Le notti di Chicago	Underworld	1927	Sat Oct 29 1927 00:00:00 GMT+0000 (Coordinated Universal Time)	Crime, Drama, Film-Noir	80	USA	English	Josef von Sternberg, Arthur Rosson	Charles Furthman, Ben Hecht	Paramount Pictures	George Bancroft, Evelyn Brent, Clive Brook, Fred Kohler, Helen Lynch, Larry Semon, Jerry Mandy	Boisterous gangster kingpin Bull Weed rehabilitates his former lawyer from his alcoholic haze, but complications arise when he falls for Weed's girlfriend.	7.6	2545	nan	$ 1642194	nan	31	50	22	underworld
tt0018839	I dannati dell'oceano	The Docks of New York	1928	Sat Sep 29 1928 00:00:00 GMT+0000 (Coordinated Universal Time)	Crime, Drama, Film-Noir	76	USA	English	Josef von Sternberg	Jules Furthman, John Monk Saunders	Paramount Pictures	George Bancroft, Betty Compson, Olga Baclanova, Clyde Cook, Mitchell Lewis, Gustav von Seyffertitz	A blue-collar worker on New York's depressed waterfront finds his life changed after he saves a woman attempting suicide.	7.5	3860	nan	nan	nan	34	51	19	the docks of new york
tt0019304	The Racket	The Racket	1928	Thu Nov 01 1928 00:00:00 GMT+0000 (Coordinated Universal Time)	Crime, Drama, Film-Noir	84	USA	English	Lewis Milestone	Bartlett Cormack, Bartlett Cormack	The Caddo Company	Thomas Meighan, Louis Wolheim, Marie Prevost, G. Pat Collins, Henry Sedley, George E. Stone, Sam De Grasse, Richard 'Skeets' Gallagher, Lee Moran, John Darrow, Lucien Prival, Dan Wolheim	An honest police captain vows to bring down a powerful bootlegger who is protected by corrupt politicians and judges.	6.7	1099	nan	nan	nan	28	14	19	the racket
tt0020499	La mazzata	Thunderbolt	1929	Thu Jun 20 1929 00:00:00 GMT+0000 (Coordinated Universal Time)	Crime, Drama, Film-Noir	85	USA	English	Josef von Sternberg	Charles Furthman, Jules Furthman	Paramount Pictures	George Bancroft, Fay Wray, Richard Arlen, Tully Marshall, Eugenie Besserer, James Spottswood, Robert Elliott, Fred Kohler, E.H. Calvert, George Irving, Mike Donlin, S.S. Stewart, William L. Thorne	A criminal known as Thunderbolt is imprisoned and facing execution. Into the next cell is placed Bob Moran, an innocent man who has been framed and who is in love with Thunderbolt's girl. ...	6.6	501	nan	nan	nan	8	13	34	thunderbolt
tt0021228	Debito d'odio	Paid	1930	Tue Dec 30 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Film-Noir	86	USA	English	Sam Wood	Bayard Veiller, Lucien Hubbard	Metro-Goldwyn-Mayer (MGM)	Joan Crawford, Robert Armstrong, Marie Prevost, Douglass Montgomery, John Miljan, Purnell Pratt, Hale Hamilton, Robert Emmett O'Connor, Tyrell Davis, William Bakewell, George Cooper, Gwen Lee, Isabel Withers	Mary Turner goes up for three years on a crime she didn't commit. Once out she and former prison mates plan a scam in which old men can be sued for breach of promise - the "heart balm" ...	6.2	606	$ 355000	nan	nan	27	8	39	paid
tt0022111	Il falcone maltese	The Maltese Falcon	1931	Sat Jun 13 1931 00:00:00 GMT+0000 (Coordinated Universal Time)	Crime, Drama, Film-Noir	80	USA	English, Chinese	Roy Del Ruth	Dashiell Hammett, Maude Fulton	Warner Bros.	Bebe Daniels, Ricardo Cortez, Dudley Digges, Una Merkel, Robert Elliott, Thelma Todd, Otto Matieson, Walter Long, Dwight Frye, J. Farrell MacDonald	A lovely dame with dangerous lies employs the services of a private detective, who is quickly caught up in the mystery and intrigue of a statuette known as the Maltese Falcon.	6.9	2692	nan	nan	nan	42	23	31	the maltese falcon
tt0022660	Il pericolo pubblico n. 1	The Beast of the City	1932	Sat Feb 13 1932 00:00:00 GMT+0000 (Coordinated Universal Time)	Crime, Drama, Film-Noir	86	USA	English	Charles Brabin	W.R. Burnett	Metro-Goldwyn-Mayer (MGM)	Walter Huston, Jean Harlow, Wallace Ford, Jean Hersholt, Dorothy Peterson, Tully Marshall, John Miljan, Emmett Corrigan, Warner Richmond, Sandy Roth, J. Carrol Naish	Police Chief Jim Fitzpatrick ruthlessly goes after organized crime and is prepared to use brutal and violent methods to fight it.	6.8	1070	$ 230000	nan	nan	29	10	21	the beast of the city
tt0023042	Io sono un evaso	I Am a Fugitive from a Chain Gang	1932	Thu Nov 23 1933 00:00:00 GMT+0000 (Coordinated Universal Time)	Crime, Drama, Film-Noir	92	USA	English	Mervyn LeRoy	Robert E. Burns, Howard J. Green	Warner Bros.	Paul Muni, Glenda Farrell, Helen Vinson, Noel Francis, Preston Foster, Allen Jenkins, Berton Churchill, Edward Ellis, David Landau, Hale Hamilton, Sally Blane, Louise Carter, Willard Robertson, Robert McWade, Robert Warwick	Wrongly convicted James Allen serves in the intolerable conditions of a southern chain gang, which later comes back to haunt him.	8.2	11390	$ 195845	nan	nan	402	47	21	i am a fugitive from a chain gang
tt0023731	20.000 anni a Sing Sing	20,000 Years in Sing Sing	1932	Sat Dec 24 1932 00:00:00 GMT+0000 (Coordinated Universal Time)	Crime, Drama, Film-Noir	78	USA	English	Michael Curtiz	Lewis E. Lawes, Wilson Mizner	First National Pictures	Spencer Tracy, Bette Davis, Arthur Byron, Lyle Talbot, Warren Hymer, Louis Calhern	Brash hoodlum Tom Connors enters Sing Sing cocksure of himself and disrespectful toward authority, but his tough but compassionate warden changes him.	6.9	2345	nan	nan	nan	37	16	22	20,000 years in sing sing
tt0023818	Blood Money	Blood Money	1933	Fri Nov 17 1933 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Film-Noir, Romance	65	USA	English	Rowland Brown	Rowland Brown	20th Century Pictures	George Bancroft, Judith Anderson, Frances Dee, Chick Chandler, Blossom Seeley, Etienne Girardot, George Regas	Bill Bailey (George Bancroft) is a Los Angeles, California bail bondsman who lives in a world of complete, casual corruption, where all he has to do is pick up the phone to get the charges ...	6.9	298	$ 238591	nan	nan	16	6	36	blood money


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