File has been downloaded from kaggle. Perform the following steps in a .pynb:
-
1) First cell is for your name/surname etc.
-
2) Add required libraries (numpy, matplotlib and pandas)
-
3) Load IMDB file using appropriate pandas functions (do not change the name of data file)
-
4) List all the Turkish movies with title, year and actors sorted with respect to year
-
5) List first 10 movies with the highest IMDB scores (avg_vote) in a given year interval
-
6) User enters an actor name, then you will find all the movies that actor was in. Print
movie names and their years of production (year).
-
7) Find total number of movies in each year that the csv file is containing and store them in
a distionary.
-
8) Create a proper histogram plot for the data you found in step 7)
28.12.2020 EE393 HW Consider imdb.csv file from week#13 (28.12.2020). File has been downloaded from kaggle. Perform the following steps in a .pynb: 1) First cell is for your name/surname etc. 2) Add required libraries (numpy, matplotlib and pandas) 3) Load IMDB file using appropriate pandas functions (do not change the name of data file) 4) List all the Turkish movies with title, year and actors sorted with respect to year 5) List first 10 movies with the highest IMDB scores (avg_vote) in a given year interval 6) User enters an actor name, then you will find all the movies that actor was in. Print movie names and their years of production (year). 7) Find total number of movies in each year that the csv file is containing and store them in a distionary. 8) Create a proper histogram plot for the data you found in step 7) imdb imdb title id title tt0000009 Miss Jerry tt0000574 The Story of the Kelly Gang tt0001892 Den sorte drom tt0002101 Cleopatra tt0002130 L'Inferno original title Miss Jerry The Story of the Kelly Gang Den sorte drom Cleopatra L'Inferno t10002199 tt0002423 tt0002445 tto002452 tt0002461 tt0002646 tt0002844 tt0003014 tt0003037 Drama tt0003102 tt0003131 tt0003165 tt0003167 tt0003419 tt0003471 tt0003489 tt0003637 tt0003643 tt0003657 tt0003740 tt0003772 MO003883 year date_published genre 1894 1894-10-09 Romance 1906 1906-12-26 Biography, Crime, Drama 1911 1911-08-19 Drama 1912 1912-11-13 Drama, History 1911 1911-03-06 Adventure, Drama, Fantasy 1912 1913 Biography, Drama 1919 1919-11-26 Biography, Drama, Romance 1913 1913-03-01 Drama, History 1912 1912-09-01 History, War 1912 1912-10-15 Drama 1913 1913-12-26 Drama 1913 1913-05-12 Crime. Drama 1913 1915-10-18 Drama 1913 1913-09-08 Crime, Drama 1914 1914-01-01 1914 1914-05-01 Drama, War 1913 1913-11-06 Crime, Drama, Mystery 1914 1914-05-17 Drama 1913 1913-08-22 Drama, Fantasy, Horror 1913 1913-11-24 Crime, Drama 1913 1913-08-24 Adventure, Drama 1915 1916-05-01 Drama 1914 1914-08-24 Crime, Drama, Horror 1914 1914-12-03 Western 1914 1914-04-18 Adventure, Drama, History 1914 1914-12-28 Fantasy, Drama 1913 1913-09-17 Crime, Drama 1914 1914-01-10 Crime, Drama 1914 1916-09-04 Comedy 1915 1915-04-08 Horror 1914 1914-03-23 Drama, Mystery 1914 1914-10-14 Family, Fantasy, Adventure 1915 1915-01-20 Drama 1914 1914-12-07 Drama, History 1914 1914-03-08 Drama 1914 1914-09-28 Adventure, Family, Fantasy 1914 1914-03-23 Action Adventure, Drama 1914 1914-02-15 Action, Drama, Romance 1914 1914-03-30 Drang 1914 1914-12-21 Comedy 1915 1915-03-20 Drama 1914 1914-03-10 Drama 1914 1914-09-07 Western 1914 1914-11-09 Comedy, Drama 1914 1914-06-OB Drama, Romance 1915 1915-02-22 Crime, Drama 1915 1915-01-19 Adventure, Family, Fantasy 1915 1915-03-21 Drama, History, War 1915 1915-10-31 Drama 1915 1915-12-13 Drama, Romance 1915 1915-11-14 Drama, History, War 1915 1915-01-12 Drama 1915 1915-12-30 Drama duration country language director 45 | USA None Alexander Black 70 Australia None Charles Talt 53 Germany, Denmark Urban Gad 100 USA English Charles L. Gaskil 6B Italy Italian Francesco Bertolini, Adolfo Padovan 60 USA English Sidney Olcott 85 Germany German Ernst Lubitsch 120 Italy Italian Enrico Guazzoni 120 Romania Aristide Demetriade, Grigore Brezeanu 55 France, USA English Andr Calmettes, James Keane 121 Denmark Danish August Blom 54 France French Louis Feuillade 96 Sweden Victor Sjstrm 61 France French Louis Feuillade 90 Italy Italian Mario Caserini 50 Belgium French Alfred Machin 90 France French Louis Feuillade 55 USA English D.W. Griffith 85 Germany German, English Paul Wegener, Stellan Rye BB USA English George Loane Tucker BB Italy Italian Mario Caserini, Eleuterio Rodolfi 72 Italy Francesca Bertini, Gustavo Serena 78 USA English D.W. Griffith 70 USA English Reginald Barker 14B Italy Italian Giovanni Pastrone 52 USA English James Kirkwood 124 France French Lonce Perret 59 France French Louis Feuillade 63 USA English Sidney Drew 60 Germany German Henrik Galeen, Paul Wegener 84 Denmark Danish Benjamin Christensen 59 USA English J. Farrell MacDonald 54 USA English Lois Weber 65 USA, Canada English Edward S. Curtis 61 USA English D.W. Griffith 81 USA English J. Farrell MacDonald 199 USA English Louis J. Gasnier, Donald Mackenzie 74 USA English Oscar Apfel, Cecil B. DeMille 80 | USA English Edwin S. Porter 82 USA None, English Mack Sennett, Charles Bennett 67 Hungary Hungarian Michael Curtiz 54 USA William Robert Daly 55 USA English Cecil B. DeMille 54 USA English Maurice Tourneur 56 USA English Reginald Barker 65 USA English Maurice Tourneur 52 USA English W.W. Young 195 USA None D.W. Griffith 59 USA English Cecil B. DeMille 59 USA English Cecil B. DeMille 77 USA English Reginald Barker, Thomas H. Ince 67 USA English 74 USA English Cecil B. DeMille From the Manger to the Cross; or, Jesus of Nazareth From the Manger to the Cross; or, Jesus of Nazareth Madame DuBarry Madame DuBarry Quo Vadis? Quo Vadis? Independenta Romaniei Independenta Romaniei Richard III Richard III Atlantis Atlantis Fantomas - A l'ombre de la guillotine Fantomas - A l'ombre de la guillotine Il calvario di una madre Ingeborg Holm Juve contre Fantomas Juve contre Fantomas Ma l'amor mio non muore. Ma l'amor mio non muore. Maudite soit la guerre Maudite soit la guerre Le mort qui tue Le mort qul tue Amore di madre Home, Sweet Home Lo studente di Praga Der Student von Prag Traffic in Souls Traffic in Souls Gli ultimi giorni di Pompel Gli ultimi giorni di Pompei Assunta Spina Assunta Spina The Avenging Conscience or 'Thou shalt Not Kil The Avenging Conscience or 'Thou shalt Not Kill The Bargain The Bargain Cabiria Cabiria Cinderella Cinderella L'enfant de Paris L'enfant de Paris Fantomas contre Fantomas Fantomas contre Fantomas A Florida Enchantment A Florida Enchantment Der Golem Der Golemn Det hemmelighedsfulde X Det hemmelighedsfulde X His Majesty, the Scarecrow of Oz His Majesty, the Scarecrow of Oz Hypocrites In the Land of the Head Hunters In the Land of the Head Hunters Judith of Bethulia Judith of Bethulia The Patchwork Girl of Oz The Patchwork Girl of Oz The Perils of Pauline The Perils of Pauline The Squaw Man The Squaw Man La madonnina del porto Tess of the Storm Country Tilie's Punctured Romance Tilie's Punctured Romance A tolonc A tolong Uncle Tom's Cabin Uncle Tom's Cabin The Virginian The Virginian The Wishing Ring: An Idyll of Old England The Wishing Ring: An Idyll of Old England The Wrath of the Gods The Wrath of the Gods Alias Jimmy Valentine Alias Jimmy Valentine Alice in Wonderland Alice in Wonderland Nascita di una nazione The Birth of a Nation Carmen Carmen The Cheat The Coward The Coward La vampira A Fool There was The Golden Chance The Golden Chance writer production company actors Alexander Black Alexander Black Photoplays Blanche Bayliss, William Courtenay, Chauncey Depew Charles Tait J. and N. Tait Elizabeth Tait, John Tait, Norman Campbell, Bella Cola, Will Coyne, Sam Crewes, Jack Ennis, John Forde, Vera Linden, Mr. Marshall, Mr. McKenzie, Frank Mills, Ollie Wilson Urban Gad, Gebhard Schiltzler-Perasini Fotorama Asta Nielsen, Valdemar Psilander, Gunnar Helsengreen, Emil Albes, Hugo Flink, Mary Hagen Victorien Sardou Helen Gardner Picture Players Helen Gardner, Pearl Sindelar. Miss Fielding, Miss Robson, Helene Costello, Charles Sindelar. Mr. Howard, James R. Waite, Mr. Osborne, Harry Knowles, Mr. Paul, Mr. Brady, M Dante Alighieri Milano Film Salvatore Papa, Arturo Pirovano, Giuseppe de Liguoro, Pier Delle Vigne, Augusto Milla. Attilio Motta, Emilise Beretta Gene Gauntier Kalern Company R. Henderson Bland, Percy Dyer, Gene Gauntier, Alice Hollister, Samuel Morgan, James D. Ainsley, Robert G. Vignola, George Kellog, J.P. McGowan Norbert Falk, Hanns Krly Projektions-AG Union (PAGU) Pola Negri, Emil Jannings, Harry Liedtke, Eduard von Winterstein, Reinhold Schnzel, Else Berna, Fred Immler, Gustav Czimeg, Karl Platen, Bernhard Goetzke, Magnus Stifter, Henryk Sienkiewicz, Enrico Guazzoni Societ Italiana Cines Amleto Novelli, Gustavo Serena, Carlo Cattaneo, Amelia Cattaneo, Lea Giunchi, Bruto Castellani, Augusto Mastripietri, Cesare Moltini. Olga Brandini, Ignazio Lupi, Giovanni G Aristide Demetriade, Petre Liciu Societatea Filmului de Arta Leon Popescu Aristide Demetriade, Constanta Demetriade, Constantin Nottara, Pepi Machauer, Aurel Athanasescu, Jeny Metaxa-Doro, Nicolae Soreanu, Vasile Toneanu, Aristita Romanescu, James Keane, William Shakespeare Le Film d'Art Robert Gemo. Frederick Warde. Albert Gardner. James Keane. George Moss. Howard Stuart. Virginia Rankin. Violet Stuart. Carey Lee. Carlotta De Felice Axel Garde, Gerhart Hauptmann Nordisk Film Olaf Fonss, Ida Orloff, Ebba Thomsen, Carl Lauritzen, Frederik Jacobsen, Charles Unthan, Torben Meyer, Svend Bille, Oluf Billesborg, Maja Bjerre-Lind, Cajus Bruun, Michael Marcel Allain, Louis Feuillade Socit des Etablissements L. Gaumont Ren Navarre, Edmund Breon, Georges Melchior, Rene Carl, Jane Faber, Andr Volbert, Naudier, Maillard, Yvette Andryor, Andr Luguet Nils Krok Svenska Biografteatern AB Hilda Borgstrm, Aron Lindgren, Erik Lindholm, Georg Grnroos, William Larsson, Richard Lund, Carl Barcklind, Hugo Bjrne, Bertil Malmstedt Marcel Allain, Louis Feuillade Socit des Etablissements L Gaumont Ren Navarre, Edmund Breon, Georges Melchior, Rene Carl, Yvette Andryor, Laurent Morlas Emiliano Bonetti, G. Monleone Film Artistica Gloria Lyda Borelli, Mario Bonnard, Gian Paolo Rosmino, Vittorio Rossi Pianelli, Dante Cappelli, Maria Caserini, Camillo De Riso, Emilio Petacci, Antonio Monti, Letizia Quaranta, Felic Alfred Machin Belge Cinma Film Baert, Suzanne Berni, Fernand Crommelynck, Nadia D'Angely. Henri Goidsen, Albert Hendrickx, Maurice Auzat, Rene Bailly, Georges Etienne, Zizi Festerat, Lucien Mussire, Marcel Allain, Louis Feuillade Socit des Etablissements L Gaumont Ren Navarre, Edmund Breon, Georges Melchior, Andr Luguet, Luitz-Morat, Naudier, Armand Dutertre, Rene Carl, Fabienne Fabrges, Jane Faber, Marie Dorly, douard Mat D.W. Griffith, H.E. Aitken Majestic Motion Picture Company Henry B. Walthall, Josephine Crowell, Lillian Gish, Dorothy Gish, Fay Tincher, Mae Marsh, Spottiswoode Aitken, Robert Harron, Miriam Cooper, Mary Alden, Donald Crisp. Jam Hanns Heinz Ewers, Hanns Heinz Ewers Deutsche Bioscop GmbH Paul Wegener, Grete Berger, Lyda Salmonova, John Gottowt, Lothar Krner, Fritz Weidemann Independent Moving Pictures Co. of America (IMP) Jane Gail, Ethel Grandin, William H. Turner, Matt Moore, William Welsh, Millie Liston, Irene Wallace, Willian Cavanaugh, Arthur Hunter, Howard Crampton, W.H. Bainbridge, Lur Edward George Bulwer-Lytton, Mario Caserini Societ Anonima Ambrosio Fernanda Negri Pouget, Eugenia Tettoni Fior, Ubaldo Stefani, Antonio Grisanti, Cesare Gani Carini, Vitale Di Stefano, Maria Brioschi, Carlo Campogalliani, Ersilia Scalpellini, Erc Salvatore Di Giacomo, Francesca Bertini Caesar Film Francesca Bertini, Gustavo Serena, Carlo Benetti, Luciano Albertini, Amelia Cipriani, Antonio Cruichi, Alberto Collo, Alberto Albertini Edgar Allan Poe, D.W. Griffith Majestic Motion Picture Company Henry B. Walthall, Spottiswoode Aitken, Blanche Sweet, George Siegmann, Ralph Lewis, Mae Marsh, Robert Harron, George Beranger Wiliam H. Clifford, Thomas H. Ince New York Motion Picture William S. Hart, J. Frank Burke, Clara Williams, J. Barney Sherry, Joseph J. Dowling Gabriele D'Annunzio, Titus Livius Itala Film Carolina Catena, Lidia Quaranta, Gina Marangoni, Dante Testa, Umberto Mozzato, Bartolomeo Pagano, Raffaele di Napoli, Emilio Vardannes, Edoardo Davesnes, Italia Almirant Charles Perrault Famous Players Film Company Mary Pickford, Owen Moore, Isabel Vernon, Georgia Wilson, Lucille Carney, W.N. Cone, Inez Ranous Lonce Perret Socit des Etablissements Gaumont Lonce Perret, Louis Leubas, Maurice Lagrenee, mile Keppens, Marc Grard, Henri Duval, Marie Dorty, Suzanne Le Bret, Jeanne Marie-Laurent, Adrien Petit, Suzanne Privat Marcel Allain, Louis Feuillade Socit des Etablissements L Gaumont Ren Navarre, Georges Melchior, Laurent Morlas, Rene Carl, Jane Faber, Yvette Andryor, Edmund Breon, Naudier Marguerite Bertsch, Archibald Clavering Gunter Vitagraph Company of America Sidney Drew, Edith Storey. Charles Kent, Mrs. Sidney Drew, Ada Gifford, Ethel Lloyd, Lilian Burns, Grace Stevens, Allan Campbell, Cortland Van Deusen, Frank O'Neil Henrik Galeen, Paul Wegener Deutsche Bioscop GmbH Paul Wegener, Henrik Galeen, Lyda Salmonova, Rudolf Blmner, Robert A. Dietrich Carl Ebert, Jakob Tiedtke Benjamin Christensen, Laurids Skands Dansk Blograf Compagni Benjamin Christensen, Karen Caspersen, Otto Reinwald, Fritz Lamprecht, Amanda Lund, Hermann Spiro, Bjrn Spiro, Holger Bjerre, Otto Lagoni, Charles Lawas, Holger Rase 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, LoL Lois Weber Hobart Bosworth Productions Courtenay Foote, Myrtle Stedman, Herbert Standing, Adele Farrington Edward S. Curtis Seattle Film Co. Stanley Hunt, Sarah Constance Smith Hunt, Mrs. George Walkus, Paddy Malid, Balutsa, Kwagwanu, Francine Hunt, Bob Wilson, Awidi, Alfred Charlie Thomas Bailey Aldrich, D.W. Griffith Biograph Company Blanche Sweet, Henry B. Walthall, Mae Marsh, Robert Harron, Kate Bruce, Lillian Gish, J. Jiquel Lanoe, Gertrude Bambrick, Dorothy Gish, Harry Carey 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, H Charles W. Goddard, Basil Dickey Path Frres Pearl White, Crane Wilbur, Paul Panzer, Edward Jos, Francis Carlyle, Clifford Bruce, Donald Mackenzie, Jack Standing, Eleanor Woodruff, Leroy Baker, Louise Du Pre, Oscar Edwin Milton Royle, Cecil B. DeMille Jesse L. Lasky Feature Play Company Dustin Farnum, Monroe Salisbury, Winifred Kingston, Mrs. A.W. Fison, Haidee Fuller, Red Wing, Foster Knox, Fred Montague, 'Baby Carmen De Rue, Fernando Glvez, Eugen Grace Miller White, B.P. Schulberg Famous Players Film Company Mary Pickford, Harold Lockwood, Olive Carey, David Hartford, Louise Dunlap, William Walters, Richard Garrick, Eugene Walter, Jack Henry, H.R. Macy, H.L. Griffith Keystone Film Company Marie Dressler, Charles Chaplin, Mabel Normand, Mack Swain, Charles Bennett, Chester Conklin Jens Janovics, Ede Tth ProJa Filmgyar Lili Berky, Victor Varconi, Mari Jszai, Andor Szakcs, Gyula Nagy, Marcsa Simon, Istvn Szentgyrgyi Alajos Mszros, Kat Berky, Elemr Hetnyi, Zoltn Glosi, Endre Kert Harriet Beecher Stowe, George L. Aiken World Film Sam Lucas, Walter Hitchcock Hattie Delaro, Master Abernathy, Teresa Michelena, Irving Cummings, Paul Scardon, Marie Eline, Garfield Thompson, Roy Applegate, Boots Wall Owen Wister, Kirk La Shelle Jesse L. Lasky Feature Play Company Dustin Farnurn, Jack W. Johnston, Sydney Deane, William Elmer, Winifred Kingston, James Griswold, Horace B. Carpenter, Tex Driscoll Owen Davis, Maurice Tourneur Shubert Film Corporation Vivian Martin, Alec B. Francis, Chester Barnett, Gyp Williams, Simeon Wiltsie, Walter Morton, Johnny Hines William H. Clifford, Thomas H. Ince New York Motion Picture Sessue Hayakawa, Tsuru Aoki, Frank Borzage, Kisaburo Kurihara, Henry Kotani, Gladys Brockwell, Herschel Mayall Paul Armstrong, O. Henry Peerless Productions Robert Warwick, Robert Cummings, Alec B. Francis, Frederick Truesdell, Ruth Shepley, Johnny Hines, D.J. Flanagan, Walter Craven, John Boone, George Cummings, Thomas Lewis Carroll, W.W. Young Nonpareil Feature Film Corp. Viola Savoy, Herbert Rice, Harry Marks, Louis Merkle, William Tilden Thomas Dixon Jr., Thomas Dixon Jr. David W. Griffith Corp. Henry B. Walthall, Lillian Gish, Mae Marsh, Mirian Cooper, Mary Alden, Ralph Lewis, George Siegmann, Walter Long, Robert Harron, Wallace Reid, Joseph Henabery, Elmer C Prosper Mrime, William C. de Mille Jesse L. Lasky Feature Play Company Geraldine Farrar, Wallace Reid, Pedro de Cordoba, Horace B. Carpenter, William Elmer, Jeanie Macpherson, Anita King, Milton Brown, Tex Driscoil Hector Turnbull, Jeanie Macpherson Jesse L. Lasky Feature Play Company Fannie Ward, Sessue Hayakawa, Jack Dean, James Neill, Yutaka Abe, Dana Ong, Hazel Childers, Arthur Wiliams Thomas H. Ince, Thomas H. Ince Kay-Bee Pictures Frank Keenan, Charles Ray, Gertrude Claire, Patricia Palmer, Nick Cogley, Charles K. French, Minnie Devereaux Porter Emerson Browne, Roy L. McCardel Fox Film Corporation Runa Hodges, Mabel Frenyear, Edward Jos, May Allison, Clifford Bruce. Theda Bara, Victor Benoit, Frank Powell, Minna Gale, Creighton Hale Cecil B. DeMile, Jeanie Macpherson Jesse L. Lasky Feature Play Company Cleo Ridgely, Wallace Reid, Horace B. Carpenter, Ernest Joy, Edythe Chapman, Raymond Hatton, William Elmer, Mrs. Lewis McCord tt0003930 tt0003973 tt0004026 t10004066 t10004099 tt0004134 tt0004150 Hypocrites tt0004181 tt0004457 tt0004465 tt0004635 tt0004681 tt0004707 t10004712 tt0004743 t10004766 t10004825 t10004838 0004872 tt0004873 tt0004972 tt0005060 10005078 tt0005149 tt0005339 The Cheat Frank Powell tt0005402
