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
tt0003131	Maudite soit la guerre	Maudite soit la guerre	1914	Fri May 01 1914 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, War	50	Belgium	French	Alfred Machin	Alfred Machin	Belge Cinéma Film	Baert, Suzanne Berni, Fernand Crommelynck, Nadia D'Angely, Henri Goidsen, Albert Hendrickx, Maurice Auzat, Renée Bailly, Georges Etienne, Zizi Festerat, Lucien Mussière, Réginald, Jane Tony	An army pilot is on a visit at the home of another army pilot in the neighboured country. He falls in love with his sister. After the outbreak of a war between the two countries, her ...	6.5	124	nan	nan	nan	2	2	37	maudite soit la guerre
tt0004972	Nascita di una nazione	The Birth of a Nation	1915	Sun Mar 21 1915 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, History, War	195	USA	nan	D.W. Griffith	Thomas Dixon Jr., Thomas Dixon Jr.	David W. Griffith Corp.	Henry B. Walthall, Lillian Gish, Mae Marsh, Miriam Cooper, Mary Alden, Ralph Lewis, George Siegmann, Walter Long, Robert Harron, Wallace Reid, Joseph Henabery, Elmer Clifton, Josephine Crowell, Spottiswoode Aitken, George Beranger	The Stoneman family finds its friendship with the Camerons affected by the Civil War, both fighting in opposite armies. The development of the war in their lives plays through to Lincoln's assassination and the birth of the Ku Klux Klan.	6.3	22213	$ 100000	nan	nan	368	97	40	the birth of a nation
tt0005149	The Coward	The Coward	1915	Sun Nov 14 1915 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, History, War	77	USA	English	Reginald Barker, Thomas H. Ince	Thomas H. Ince, Thomas H. Ince	Kay-Bee Pictures	Frank Keenan, Charles Ray, Gertrude Claire, Patricia Palmer, Nick Cogley, Charles K. French, Minnie Devereaux	Colonel Winslow, veteran of the Mexican War, hopes for a great future for his only son, Frank. At the outbreak of the Civil War, a recruiting station is opened in the Virginia village where...	6	244	$ 18000	nan	nan	15	3	34	the coward
tt0005719	Martyrs of the Alamo	Martyrs of the Alamo	1915	Sun Nov 21 1915 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, History, War	71	USA	English	Christy Cabanne	Christy Cabanne, Theodosia Harris	Fine Arts Film Company	Sam De Grasse, Allan Sears, Walter Long, Alfred Paget, Fred Burns, John T. Dillon, Juanita Hansen, Ora Carew, Tom Wilson, Augustus Carney	The story of the defense of the mission-turned-fortress by 185 Texans against an overwhelming Mexican army in 1836.	5.6	138	nan	nan	nan	5	1	18	martyrs of the alamo
tt0008188	The Little American	The Little American	1917	Thu Jul 12 1917 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Romance, War	80	USA	English	Cecil B. DeMille, Joseph Levering	Jeanie Macpherson	Mary Pickford Company	Mary Pickford, Jack Holt, Raymond Hatton, Hobart Bosworth, Walter Long, James Neill, Ben Alexander, Guy Oliver, Edythe Chapman, Lillian Leighton, DeWitt Jennings	A young American has her ship torpedoed by a German U-boat but makes it back to ancestral home in France, where she witnesses German brutality firsthand.	5.9	608	$ 166949	nan	nan	12	5	26	the little american
tt0008663	Terje Vigen	Terje Vigen	1917	Mon Jan 29 1917 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, War	48	Sweden	nan	Victor Sjöström	Henrik Ibsen	Svenska Biografteatern AB	Victor Sjöström, August Falck, Edith Erastoff, Bergliot Husberg	Terje Vigen, a sailor, suffers the loss of his family through the cruelty of another man. Years later, when his enemy's family finds itself dependent on Terje's beneficence, Terje must ...	7.4	1508	SEK 60000	nan	nan	12	9	31	terje vigen
tt0009150	Cuori del mondo	Hearts of the World	1918	Sat Jun 01 1918 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, War	117	USA	English	D.W. Griffith	D.W. Griffith, D.W. Griffith	D.W. Griffith Productions	Lillian Gish, Robert Harron, Dorothy Gish, Adolph Lestina, Josephine Crowell, Jack Cosgrave, Kate Bruce, Ben Alexander, Marion Emmons, Francis Marion, Robert Anderson, George Fawcett, George Siegmann, Fay Holderness, L. Lowry	Young lovers in a French village are torn apart with the coming of the Great War.	6.4	906	nan	nan	nan	16	12	16	hearts of the world
tt0009611	Charlot soldato	Shoulder Arms	1918	Sun Oct 27 1918 00:00:00 GMT+0000 (Coordinated Universal Time)	Comedy, War	45	USA	None, English	Charles Chaplin	Charles Chaplin	Charles Chaplin Productions	Edna Purviance, Charles Chaplin, Syd Chaplin, Loyal Underwood, Henry Bergman, Tom Wilson, Albert Austin, Jack Wilson	Charlie is a boot camp private who has a dream of being a hero who goes on a daring mission behind enemy lines.	7.3	5895	nan	nan	nan	38	21	23	shoulder arms
tt0009737	The Unbeliever	The Unbeliever	1918	Mon Feb 11 1918 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, War	80	USA	English	Alan Crosland	Mary Raymond Shipman Andrews	Perfection Pictures	Marguerite Courtot, Raymond McKee, Erich von Stroheim, Kate Lester, Frank DeVernon, Mortimer Martine, Blanche Davenport, Harold Hollacher, Darwin Karr, Earl Schenck, Gertrude Norman, Lew Hart, Thomas Holcomb, J.F. Rorke, Moss Gill	A wealthy young American, bred to class distinction and racial intolerance, enters the Marines during the First World War. In the course of his training and his experiences in the trenches ...	5.9	109	nan	nan	nan	5	1	32	the unbeliever
tt0010307	Per la patria	J'accuse	1919	Fri Apr 25 1919 00:00:00 GMT+0000 (Coordinated Universal Time)	Drama, Horror, War	166	France	French	Abel Gance	Abel Gance	Pathé Frères	Romuald Joubé, Maxime Desjardins, Séverin-Mars, Angèle Guys, Maryse Dauvray, Mancini, Elizabeth Nizan, Pierre Danis, Blaise Cendrars, Paul Duc	The story of two men, one married, the other the lover of the other's wife, who meet in the trenches of the First World War, and how their tale becomes a microcosm for the horrors of war.	7.7	1417	nan	nan	nan	15	25	37	j'accuse


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