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	metascore Metascore	reviews_from_users Reviews From Users	reviews_from_critics Reviews From Critics	description_words Description #words	movie_title Movie Title
tt0016029	Il piccolo colonnello	The Little Colonel	1935	Fri Feb 22 1935 00:00:00 GMT+0000 (Coordinated Universal Time)	Comedy, Family, Musical	81	USA	English	David Butler	William M. Conselman, William M. Conselman	Fox Film Corporation	Shirley Temple, Lionel Barrymore, Evelyn Venable, John Lodge, Bill Robinson, Sidney Blackmer, Stephen Chase, William Burgess, Frank Darien, Robert Warwick, Hattie McDaniel, Geneva Williams, Avonne Jackson, Nyanza Potts	After Southern belle Elizabeth Lloyd runs off to marry Yankee Jack Sherman, her father, a former Confederate colonel during the Civil War, vows to never speak to her again. Several years ...	7.1	1420	nan	nan	nan		21	5	32	the little colonel
tt0018037	Il cantante di jazz	The Jazz Singer	1927	Sat Feb 04 1928 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Music, Musical	88	USA	English	Alan Crosland	Samson Raphaelson, Alfred A. Cohn	Warner Bros.	Al Jolson, May McAvoy, Warner Oland, Eugenie Besserer, Otto Lederer, Robert Gordon, Richard Tucker, Yossele Rosenblatt	The son of a Jewish Cantor must defy the traditions of his religious father in order to pursue his dream of becoming a jazz singer.	6.5	8866	$ 422000	nan	nan	66	104	63	25	the jazz singer
tt0019388	Il cantante pazzo	The Singing Fool	1928	Fri Apr 19 1929 00:00:00 GMT+0000 (Coordinated Universal Time)	Musical, Drama	105	USA	English	Lloyd Bacon	C. Graham Baker, C. Graham Baker	Warner Bros.	Al Jolson, Betty Bronson, Josephine Dunn, Arthur Housman, Reed Howes, Davey Lee, Edward Martindel, Robert Emmett O'Connor, Helen Lynch, Agnes Franey, The Yacht Club Boys	A singing waiter and composer (Al Jolson) loves two women (Betty Bronson, Josephine Dunn), conquers Broadway and holds his dying son, singing "Sonny Boy."	6.2	206	nan	$ 10900000	$ 12862000		13	6	24	the singing fool
tt0019644	Applause	Applause	1929	Sat Jan 04 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Musical	80	USA	English	Rouben Mamoulian	Beth Brown, Garrett Fort	Paramount Pictures	Helen Morgan, Joan Peers, Fuller Mellish Jr., Jack Cameron, Henry Wadsworth, Billie Bernard, Phyliss Bolce, Lotta Burnell, Alice Clayton, Florence Dickerson, Viola Gallo, E. Graniss, Mary Gertrude Haines, David Holt, Madge McLaughlin	A burlesque star seeks to keep her convent-raised daughter away from her low-down life and abusive lover/stage manager.	7	1266	nan	nan	nan		25	20	18	applause
tt0019726	Ragazze d'America	Broadway Babies	1929	Mon Jan 20 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Musical	86	USA	English	Mervyn LeRoy	Jay Gelzer, Monte M. Katterjohn	First National Pictures	Alice White, Marion Byron, Sally Eilers, Charles Delaney, Tom Dugan, Bodil Rosing, Maurice Black, Fred Kohler, Louis Natheaux, Jocelyn Lee	A Chorus girl who is in love with her stage manager is led to believe that he is in love with another young woman, so, she agrees to marry a bootlegger instead.	6.4	119	nan	nan	nan		6	2	32	broadway babies
tt0019729	La canzone di Broadway	The Broadway Melody	1929	Thu Jun 06 1929 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Musical, Romance	100	USA	English	Harry Beaumont	Edmund Goulding, Norman Houston	Metro-Goldwyn-Mayer (MGM)	Charles King, Anita Page, Bessie Love	A pair of sisters from the vaudeville circuit try to make it big time on Broadway, but matters of the heart complicate the attempt.	5.7	6327	$ 379000	nan	nan		85	35	24	the broadway melody
tt0019798	La danza della vita	The Dance of Life	1929	Fri Aug 16 1929 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Musical, Romance	115	USA	English	John Cromwell, A. Edward Sutherland	Benjamin Glazer, Arthur Hopkins	Paramount Pictures	Hal Skelly, Nancy Carroll, Dorothy Revier, Ralph Theodore, Charles D. Brown, Al St. John, May Boley, Oscar Levant, Gladys DuBois, James Quinn, Jim Farley, George Irving, Gordona Bennet, Miss La Reno, Corra Beach	A vaudeville comic and a pretty young dancer aren't having much luck in their separate careers, so they decide to combine their acts and in order to save money on the road, they get married.	6.5	261	nan	nan	nan		9	3	35	the dance of life
tt0019933	Glorifying the American Girl	Glorifying the American Girl	1929	Sat Dec 07 1929 00:00:00 GMT+0000 (Coordinated Universal Time)	Comedy, Drama, Musical	95	USA	English	Millard Webb	J.P. McEvoy, Millard Webb	Paramount Pictures	Mary Eaton, Eddie Cantor, Helen Morgan, Rudy Vallee, Dan Healy, Kaye Renard, Edward Crandall, Gloria Shea, Sarah Edwards, Singing and Dancing Chorus of Seventy-Five Glorified Beauties	The rise of a showgirl, Gloria Hughes, culminating in a Ziegfeld extravaganza "Glorifying the American Girl".	5.8	621	nan	nan	nan		28	5	16	glorifying the american girl
tt0019946	Il gran Gabbo	The Great Gabbo	1929	Thu Sep 12 1929 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Musical, Romance	92	USA	German, English	James Cruze, Erich von Stroheim	Ben Hecht, Hugh Herbert	James Cruze Productions	Erich von Stroheim, Betty Compson, Donald Douglas, Marjorie Kane	An insanely, egocentric ventriloquist, even though he is possessed by his wooden dummy, is in love with a dancer who is in love with another. The dummy gives advice to the ventriloquist.	6.1	694	nan	nan	nan		28	17	32	the great gabbo
tt0020034	La romanza dell'amore	It's a Great Life	1929	Fri Dec 06 1929 00:00:00 GMT+0000 (Coordinated Universal Time)	Comedy, Musical, Romance	93	USA	English	Sam Wood	Byron Morgan, Leonard Praskins	Metro-Goldwyn-Mayer (MGM)	Rosetta Duncan, Vivian Duncan, Lawrence Gray, Jed Prouty, Benny Rubin	Casey and Babe are sisters who work in a department store and each year the store puts on a show. As expected, things are going wrong with every act until Casey comes out to help Babe with ...	6.1	269	nan	nan	nan		9	1	38	it's a great life


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