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
tt0004099	His Majesty, the Scarecrow of Oz	His Majesty, the Scarecrow of Oz	1914	Wed Oct 14 1914 00:00:00 GMT+0000 (Coordinated Universal Time)	Family, Fantasy, Adventure	59	USA	English	J. Farrell MacDonald	L. Frank Baum, L. Frank Baum	The Oz Film Manufacturing Company	Violet MacMillan, Frank Moore, Pierre Couderc, Fred Woodward, Raymond Russell, Arthur Smollet, J. Charles Haydon, Todd Wright, Vivian Reed, Mai Wells, Mildred Harris, Louise Emmons, Jacqueline Lovell	A wicked king has taken over the Emerald City, and wants his daughter, Princess Gloria, to marry the horrid courtier Googly-Goo, though she loves Pon, the Gardener's Boy. The camera now ...	5.2	415	$ 23500	nan	nan	11	7	32	his majesty, the scarecrow of oz
tt0004457	The Patchwork Girl of Oz	The Patchwork Girl of Oz	1914	Mon Sep 28 1914 00:00:00 GMT+0000 (Coordinated Universal Time)	Adventure, Family, Fantasy	81	USA	English	J. Farrell MacDonald	L. Frank Baum, L. Frank Baum	The Oz Film Manufacturing Company	Violet MacMillan, Frank Moore, Raymond Russell, Leontine Dranet, Bobbie Gould, Marie Wayne, Richard Rosson, Frank Bristol, Fred Woodward, Todd Wright, Bert Glennon, Hal Roach, Dave Anderson, Jessie May Walsh, William Cook	Ojo and Unc Nunkie are out of food, so they decide to journey to the Emerald City where they will never starve. Along the way, they meet Mewel, a waif and stray (mule) who leads them to Dr....	5.5	382	nan	nan	nan	16	5	38	the patchwork girl of oz
tt0004873	Alice in Wonderland	Alice in Wonderland	1915	Tue Jan 19 1915 00:00:00 GMT+0000 (Coordinated Universal Time)	Adventure, Family, Fantasy	52	USA	English	W.W. Young	Lewis Carroll, W.W. Young	Nonpareil Feature Film Corp.	Viola Savoy, Herbert Rice, Harry Marks, Louis Merkle, William Tilden	Alice goes with her sister to a picnic and then she falls asleep and starts dreaming about a wonderland full of talking animals and walking playing cards.	6.2	394	$ 50000	nan	nan	11	8	27	alice in wonderland
tt0008443	The Poor Little Rich Girl	The Poor Little Rich Girl	1917	Mon Mar 05 1917 00:00:00 GMT+0000 (Coordinated Universal Time)	Comedy, Drama, Family	65	USA	English	Maurice Tourneur	Eleanor Gates, Frances Marion	Artcraft Pictures Corporation	Mary Pickford, Madlaine Traverse, Charles Wellesley, Gladys Fairbanks, Frank McGlynn Sr., Emile La Croix, Marcia Harris, Charles Craig, Frank Andrews, Herbert Prior, George Gernon, Maxine Elliott Hicks	The wealthy but selfish parents of a lonely young girl begin to rethink what is important to them after a servant's irresponsibility results in a crisis.	6.7	1266	nan	nan	nan	16	13	26	the poor little rich girl
tt0008891	L'uccello blu	The Blue Bird	1918	Sun Mar 31 1918 00:00:00 GMT+0000 (Coordinated Universal Time)	Family, Fantasy	75	USA	English	Maurice Tourneur	Maurice Maeterlinck, Charles Maigne	Paramount Pictures	Tula Belle, Robin Macdougall, Edwin E. Reed, Emma Lowry, William J. Gross, Florence Anderson, Edward Elkas, Katherine Bianchi, Lillian Cook, Gertrude McCoy, Lyn Donelson, Charles Ascot, Tom Corless, Mary Kennedy, Eleanor Masters	Two peasant children, Mytyl and Tyltyl, are led by Berylune, a fairy, to search for the Blue Bird of Happiness. Berylune gives Tyltyl a cap with a diamond setting, and when Tyltyl turns the...	7	782	nan	nan	nan	20	10	34	the blue bird
tt0011588	Pollyanna	Pollyanna	1920	Sun Jan 18 1920 00:00:00 GMT+0000 (Coordinated Universal Time)	Family, Comedy, Drama	58	USA	English	Paul Powell	Eleanor H. Porter, Catherine Chisholm Cushing	Mary Pickford Company	Mary Pickford, Wharton James, Katherine Griffith, Helen Jerome Eddy, George Berrell, Howard Ralston, William Courtleigh, Herbert Prior	An orphan's optimistic outlook brings a change to the ill-tempered town in which she resides to her aunt.	6.4	355	$ 300000	nan	nan	15	2	18	pollyanna
tt0013059	Der var engang	Der var engang	1922	Tue Oct 03 1922 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Family, Fantasy	75	Denmark	nan	Carl Theodor Dreyer	Holger Drachmann, Carl Theodor Dreyer	Sophus Madsen Film	Clara Pontoppidan, Svend Methling, Peter Jerndorff, Hakon Ahnfelt-Rønne, Mohamed Archer, Bodil Faber, Wilhelmine Henriksen, Lili Lani, Henry Larsen, Frederik Leth, Schiøler Linck, Gerda Madsen, Lars Madsen, Torben Meyer, Karen Poulsen	A beautiful but imperious princess refuses all offers of marriage, often condemning her suitors to death. The prince of Denmark comes seeking her hand and, aided by magic objects given to him by a mysterious spirit, seeks to win her love.	6.3	343	nan	nan	nan	4	1	41	der var engang
tt0013201	Il talismano della nonna	Grandma's Boy	1922	Sun Sep 03 1922 00:00:00 GMT+0000 (Coordinated Universal Time)	Comedy, Family	60	USA	English	Fred C. Newmeyer	Hal Roach, Sam Taylor	Hal Roach Studios	Harold Lloyd, Mildred Davis, Anna Townsend, Charles Stevenson, Dick Sutherland, Noah Young, Jack Morgan	A meek young man must find the courage within when a rogue tramp menaces his home town.	7	1618	$ 94412	nan	nan	24	16	17	grandma's boy
tt0013556	Robin Hood	Robin Hood	1922	Wed Oct 18 1922 00:00:00 GMT+0000 (Coordinated Universal Time)	Adventure, Family, Romance	143	USA	English	Allan Dwan	Douglas Fairbanks	Douglas Fairbanks Pictures	Wallace Beery, Sam De Grasse, Enid Bennett, Paul Dickey, William Lowery, Roy Coulson, Billie Bennett, Merrill McCormick, Wilson Benge, Willard Louis, Alan Hale, Bud Geary, Lloyd Talman, Douglas Fairbanks	A nobleman becomes the vigilante Robin Hood who protects the oppressed English people from the tyrannical Prince John.	7.2	1971	$ 1500000	nan	nan	25	19	18	robin hood
tt0013688	The Toll of the Sea	The Toll of the Sea	1922	Mon Jan 22 1923 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Family, Fantasy	54	USA	nan	Chester M. Franklin	Frances Marion	Technicolor	Anna May Wong, Kenneth Harlan, Beatrice Bentley, Priscilla Moran, Etta Lee, Ming Young	While visiting China, an American man falls in love with a young Chinese woman, but he then has second thoughts about the relationship.	6.6	642	nan	nan	nan	25	12	23	the toll of the sea


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