Day 6.ipynb

{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"name":"Day 6.ipynb","provenance":[{"file_id":"1loJ6Cjayt2E7y-SuJMolAKeAyBGDZQKp","timestamp":1628371890633},{"file_id":"1nJoC055wXOjAUz-guePOPPs4lPkZUVk4","timestamp":1628134807561},{"file_id":"1UgO6MxFiVKHTX6oq2QF1IYNOYOh5sVu-","timestamp":1627684542073}],"collapsed_sections":[]},"kernelspec":{"name":"python3","display_name":"Python 3"},"language_info":{"name":"python"}},"cells":[{"cell_type":"markdown","metadata":{"id":"FEz3UU8YY0qP"},"source":["# Day 6\n"]},{"cell_type":"markdown","metadata":{"id":"oFVQ4ZuYcCv9"},"source":["### HW: Analyze the US Movie Durations (down below)\n","\n","1. Create a copy of the file\n","\n","2. Solve the problems - having Day 4 & 5 notes should help!"]},{"cell_type":"code","metadata":{"id":"czxEyNW-RNiX","executionInfo":{"status":"ok","timestamp":1628445961035,"user_tz":420,"elapsed":241,"user":{"displayName":"Adelina C","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgKKnSMUjVup_IM_RppfxP-qmWHpkS2Ml89QXaL=s64","userId":"14916151407532375031"}}},"source":["import pandas as pd\n","pd.set_option('precision', 2)\n","pd.set_option('display.max_columns', None)"],"execution_count":2,"outputs":[]},{"cell_type":"code","metadata":{"id":"yyO9uzpqjdjf","executionInfo":{"status":"ok","timestamp":1628445961285,"user_tz":420,"elapsed":35,"user":{"displayName":"Adelina C","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgKKnSMUjVup_IM_RppfxP-qmWHpkS2Ml89QXaL=s64","userId":"14916151407532375031"}}},"source":["netflix = pd.read_csv('netflix.csv')"],"execution_count":3,"outputs":[]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":0},"id":"UlCDRW9GjekI","executionInfo":{"status":"ok","timestamp":1628445961287,"user_tz":420,"elapsed":35,"user":{"displayName":"Adelina C","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgKKnSMUjVup_IM_RppfxP-qmWHpkS2Ml89QXaL=s64","userId":"14916151407532375031"}},"outputId":"7d6a10ff-f3a9-4f8a-a685-d2be9f73d294"},"source":["netflix.head()"],"execution_count":4,"outputs":[{"output_type":"execute_result","data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>show_id</th>\n","      <th>type</th>\n","      <th>title</th>\n","      <th>director</th>\n","      <th>cast</th>\n","      <th>country</th>\n","      <th>date_added</th>\n","      <th>release_year</th>\n","      <th>rating</th>\n","      <th>duration</th>\n","      <th>listed_in</th>\n","      <th>description</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>s1</td>\n","      <td>TV Show</td>\n","      <td>3%</td>\n","      <td>NaN</td>\n","      <td>João Miguel, Bianca Comparato, Michel Gomes, R...</td>\n","      <td>Brazil</td>\n","      <td>August 14, 2020</td>\n","      <td>2020</td>\n","      <td>TV-MA</td>\n","      <td>4 Seasons</td>\n","      <td>International TV Shows, TV Dramas, TV Sci-Fi &amp;...</td>\n","      <td>In a future where the elite inhabit an island ...</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>s2</td>\n","      <td>Movie</td>\n","      <td>7:19</td>\n","      <td>Jorge Michel Grau</td>\n","      <td>Demián Bichir, Héctor Bonilla, Oscar Serrano, ...</td>\n","      <td>Mexico</td>\n","      <td>December 23, 2016</td>\n","      <td>2016</td>\n","      <td>TV-MA</td>\n","      <td>93 min</td>\n","      <td>Dramas, International Movies</td>\n","      <td>After a devastating earthquake hits Mexico Cit...</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>s3</td>\n","      <td>Movie</td>\n","      <td>23:59</td>\n","      <td>Gilbert Chan</td>\n","      <td>Tedd Chan, Stella Chung, Henley Hii, Lawrence ...</td>\n","      <td>Singapore</td>\n","      <td>December 20, 2018</td>\n","      <td>2011</td>\n","      <td>R</td>\n","      <td>78 min</td>\n","      <td>Horror Movies, International Movies</td>\n","      <td>When an army recruit is found dead, his fellow...</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>s4</td>\n","      <td>Movie</td>\n","      <td>9</td>\n","      <td>Shane Acker</td>\n","      <td>Elijah Wood, John C. Reilly, Jennifer Connelly...</td>\n","      <td>United States</td>\n","      <td>November 16, 2017</td>\n","      <td>2009</td>\n","      <td>PG-13</td>\n","      <td>80 min</td>\n","      <td>Action &amp; Adventure, Independent Movies, Sci-Fi...</td>\n","      <td>In a postapocalyptic world, rag-doll robots hi...</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>s5</td>\n","      <td>Movie</td>\n","      <td>21</td>\n","      <td>Robert Luketic</td>\n","      <td>Jim Sturgess, Kevin Spacey, Kate Bosworth, Aar...</td>\n","      <td>United States</td>\n","      <td>January 1, 2020</td>\n","      <td>2008</td>\n","      <td>PG-13</td>\n","      <td>123 min</td>\n","      <td>Dramas</td>\n","      <td>A brilliant group of students become card-coun...</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["  show_id     type  title           director  \\\n","0      s1  TV Show     3%                NaN   \n","1      s2    Movie   7:19  Jorge Michel Grau   \n","2      s3    Movie  23:59       Gilbert Chan   \n","3      s4    Movie      9        Shane Acker   \n","4      s5    Movie     21     Robert Luketic   \n","\n","                                                cast        country  \\\n","0  João Miguel, Bianca Comparato, Michel Gomes, R...         Brazil   \n","1  Demián Bichir, Héctor Bonilla, Oscar Serrano, ...         Mexico   \n","2  Tedd Chan, Stella Chung, Henley Hii, Lawrence ...      Singapore   \n","3  Elijah Wood, John C. Reilly, Jennifer Connelly...  United States   \n","4  Jim Sturgess, Kevin Spacey, Kate Bosworth, Aar...  United States   \n","\n","          date_added  release_year rating   duration  \\\n","0    August 14, 2020          2020  TV-MA  4 Seasons   \n","1  December 23, 2016          2016  TV-MA     93 min   \n","2  December 20, 2018          2011      R     78 min   \n","3  November 16, 2017          2009  PG-13     80 min   \n","4    January 1, 2020          2008  PG-13    123 min   \n","\n","                                           listed_in  \\\n","0  International TV Shows, TV Dramas, TV Sci-Fi &...   \n","1                       Dramas, International Movies   \n","2                Horror Movies, International Movies   \n","3  Action & Adventure, Independent Movies, Sci-Fi...   \n","4                                             Dramas   \n","\n","                                         description  \n","0  In a future where the elite inhabit an island ...  \n","1  After a devastating earthquake hits Mexico Cit...  \n","2  When an army recruit is found dead, his fellow...  \n","3  In a postapocalyptic world, rag-doll robots hi...  \n","4  A brilliant group of students become card-coun...  "]},"metadata":{"tags":[]},"execution_count":4}]},{"cell_type":"markdown","metadata":{"id":"04YdPQztjhHa"},"source":["### How Many Rows in the Dataset?"]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"L6AxqeZPjlrX","executionInfo":{"status":"ok","timestamp":1628445961288,"user_tz":420,"elapsed":30,"user":{"displayName":"Adelina C","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgKKnSMUjVup_IM_RppfxP-qmWHpkS2Ml89QXaL=s64","userId":"14916151407532375031"}},"outputId":"230f8349-45b0-42c6-9483-ec58bc7707d6"},"source":["len(netflix)"],"execution_count":5,"outputs":[{"output_type":"execute_result","data":{"text/plain":["7787"]},"metadata":{"tags":[]},"execution_count":5}]},{"cell_type":"markdown","metadata":{"id":"wZr0vc1PjxUx"},"source":["### What are the Different Types of Content?"]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"7LNkXq9njtip","executionInfo":{"status":"ok","timestamp":1628445961288,"user_tz":420,"elapsed":25,"user":{"displayName":"Adelina C","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgKKnSMUjVup_IM_RppfxP-qmWHpkS2Ml89QXaL=s64","userId":"14916151407532375031"}},"outputId":"bf13ddd7-66a5-4171-f4ed-1f40334d2cf7"},"source":["netflix['type'].unique()"],"execution_count":6,"outputs":[{"output_type":"execute_result","data":{"text/plain":["array(['TV Show', 'Movie'], dtype=object)"]},"metadata":{"tags":[]},"execution_count":6}]},{"cell_type":"markdown","metadata":{"id":"8_leYUWGkCS5"},"source":["### Where is Netflix's Content Available?"]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"4OE0f2kRj46c","executionInfo":{"status":"ok","timestamp":1628445961289,"user_tz":420,"elapsed":24,"user":{"displayName":"Adelina C","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgKKnSMUjVup_IM_RppfxP-qmWHpkS2Ml89QXaL=s64","userId":"14916151407532375031"}},"outputId":"f7c81487-bc40-4d7a-ff70-aea3cb6a15e9"},"source":["len(netflix['country'].unique())"],"execution_count":7,"outputs":[{"output_type":"execute_result","data":{"text/plain":["682"]},"metadata":{"tags":[]},"execution_count":7}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"jFV1fL4tcLzz","executionInfo":{"status":"ok","timestamp":1628445961290,"user_tz":420,"elapsed":24,"user":{"displayName":"Adelina C","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgKKnSMUjVup_IM_RppfxP-qmWHpkS2Ml89QXaL=s64","userId":"14916151407532375031"}},"outputId":"78377b57-0826-457b-8c25-8054658231f2"},"source":["netflix['country'].dtype"],"execution_count":8,"outputs":[{"output_type":"execute_result","data":{"text/plain":["dtype('O')"]},"metadata":{"tags":[]},"execution_count":8}]},{"cell_type":"code","metadata":{"id":"hB8uStszj_cd","executionInfo":{"status":"ok","timestamp":1628445961291,"user_tz":420,"elapsed":21,"user":{"displayName":"Adelina C","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgKKnSMUjVup_IM_RppfxP-qmWHpkS2Ml89QXaL=s64","userId":"14916151407532375031"}}},"source":["# key is gonna be a name of a country\n","# value is gonna be how many shows/movies are available in that country\n","countries = {}\n","\n","for item in list(netflix['country']):\n","\n","  # if there is a , -> we have multiple countries where that show is available\n","  if type(item) == type(''):\n","    if ',' in item:\n","      # turn it into a list\n","      countries_list = item.split(', ')\n","\n","      #iterate through each country in the list\n","      for country in countries_list:\n","        # if country is in the keys add 1\n","        if country in countries.keys():\n","          countries[country] += 1\n","        # create the key and make it equal to one\n","        else:\n","          countries[country] = 1\n","    \n","    else:\n","      if item in countries.keys():\n","        countries[item] += 1\n","      else:\n","        countries[item] = 1"],"execution_count":9,"outputs":[]},{"cell_type":"code","metadata":{"id":"wMoFEb8-mQfJ","executionInfo":{"status":"ok","timestamp":1628445961292,"user_tz":420,"elapsed":21,"user":{"displayName":"Adelina C","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgKKnSMUjVup_IM_RppfxP-qmWHpkS2Ml89QXaL=s64","userId":"14916151407532375031"}}},"source":["top_country = ''\n","top_count = 0\n","\n","for country, count in countries.items():\n","\n","  if count > top_count:\n","    top_count = count\n","    top_country = country"],"execution_count":10,"outputs":[]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"edI70NzsnU9k","executionInfo":{"status":"ok","timestamp":1628445961521,"user_tz":420,"elapsed":249,"user":{"displayName":"Adelina C","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgKKnSMUjVup_IM_RppfxP-qmWHpkS2Ml89QXaL=s64","userId":"14916151407532375031"}},"outputId":"a7b48e0c-2bbd-488f-dd58-41843726fd73"},"source":["print(top_country)\n","print(top_count)"],"execution_count":11,"outputs":[{"output_type":"stream","text":["United States\n","3296\n"],"name":"stdout"}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"vWoA8VaJkcMg","executionInfo":{"status":"ok","timestamp":1628445961522,"user_tz":420,"elapsed":39,"user":{"displayName":"Adelina C","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgKKnSMUjVup_IM_RppfxP-qmWHpkS2Ml89QXaL=s64","userId":"14916151407532375031"}},"outputId":"dc07fda8-abe5-4e1b-8370-b99f0f9efc13"},"source":["'a, b, c'.split(',')"],"execution_count":12,"outputs":[{"output_type":"execute_result","data":{"text/plain":["['a', ' b', ' c']"]},"metadata":{"tags":[]},"execution_count":12}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"P0TO5msrkhxs","executionInfo":{"status":"ok","timestamp":1628445961523,"user_tz":420,"elapsed":37,"user":{"displayName":"Adelina C","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgKKnSMUjVup_IM_RppfxP-qmWHpkS2Ml89QXaL=s64","userId":"14916151407532375031"}},"outputId":"83aa748e-d91b-4976-f7f2-33e57476394a"},"source":["'Japan, United States'.split(',')"],"execution_count":13,"outputs":[{"output_type":"execute_result","data":{"text/plain":["['Japan', ' United States']"]},"metadata":{"tags":[]},"execution_count":13}]},{"cell_type":"markdown","metadata":{"id":"UuVjoMqynjLr"},"source":["### Analyzing Release Years"]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":0},"id":"cK-1iALWnm-t","executionInfo":{"status":"ok","timestamp":1628445961524,"user_tz":420,"elapsed":35,"user":{"displayName":"Adelina C","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgKKnSMUjVup_IM_RppfxP-qmWHpkS2Ml89QXaL=s64","userId":"14916151407532375031"}},"outputId":"d11ab93c-3ddb-421e-e0df-876fbc03d8e2"},"source":["netflix.head()"],"execution_count":14,"outputs":[{"output_type":"execute_result","data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>show_id</th>\n","      <th>type</th>\n","      <th>title</th>\n","      <th>director</th>\n","      <th>cast</th>\n","      <th>country</th>\n","      <th>date_added</th>\n","      <th>release_year</th>\n","      <th>rating</th>\n","      <th>duration</th>\n","      <th>listed_in</th>\n","      <th>description</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>s1</td>\n","      <td>TV Show</td>\n","      <td>3%</td>\n","      <td>NaN</td>\n","      <td>João Miguel, Bianca Comparato, Michel Gomes, R...</td>\n","      <td>Brazil</td>\n","      <td>August 14, 2020</td>\n","      <td>2020</td>\n","      <td>TV-MA</td>\n","      <td>4 Seasons</td>\n","      <td>International TV Shows, TV Dramas, TV Sci-Fi &amp;...</td>\n","      <td>In a future where the elite inhabit an island ...</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>s2</td>\n","      <td>Movie</td>\n","      <td>7:19</td>\n","      <td>Jorge Michel Grau</td>\n","      <td>Demián Bichir, Héctor Bonilla, Oscar Serrano, ...</td>\n","      <td>Mexico</td>\n","      <td>December 23, 2016</td>\n","      <td>2016</td>\n","      <td>TV-MA</td>\n","      <td>93 min</td>\n","      <td>Dramas, International Movies</td>\n","      <td>After a devastating earthquake hits Mexico Cit...</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>s3</td>\n","      <td>Movie</td>\n","      <td>23:59</td>\n","      <td>Gilbert Chan</td>\n","      <td>Tedd Chan, Stella Chung, Henley Hii, Lawrence ...</td>\n","      <td>Singapore</td>\n","      <td>December 20, 2018</td>\n","      <td>2011</td>\n","      <td>R</td>\n","      <td>78 min</td>\n","      <td>Horror Movies, International Movies</td>\n","      <td>When an army recruit is found dead, his fellow...</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>s4</td>\n","      <td>Movie</td>\n","      <td>9</td>\n","      <td>Shane Acker</td>\n","      <td>Elijah Wood, John C. Reilly, Jennifer Connelly...</td>\n","      <td>United States</td>\n","      <td>November 16, 2017</td>\n","      <td>2009</td>\n","      <td>PG-13</td>\n","      <td>80 min</td>\n","      <td>Action &amp; Adventure, Independent Movies, Sci-Fi...</td>\n","      <td>In a postapocalyptic world, rag-doll robots hi...</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>s5</td>\n","      <td>Movie</td>\n","      <td>21</td>\n","      <td>Robert Luketic</td>\n","      <td>Jim Sturgess, Kevin Spacey, Kate Bosworth, Aar...</td>\n","      <td>United States</td>\n","      <td>January 1, 2020</td>\n","      <td>2008</td>\n","      <td>PG-13</td>\n","      <td>123 min</td>\n","      <td>Dramas</td>\n","      <td>A brilliant group of students become card-coun...</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["  show_id     type  title           director  \\\n","0      s1  TV Show     3%                NaN   \n","1      s2    Movie   7:19  Jorge Michel Grau   \n","2      s3    Movie  23:59       Gilbert Chan   \n","3      s4    Movie      9        Shane Acker   \n","4      s5    Movie     21     Robert Luketic   \n","\n","                                                cast        country  \\\n","0  João Miguel, Bianca Comparato, Michel Gomes, R...         Brazil   \n","1  Demián Bichir, Héctor Bonilla, Oscar Serrano, ...         Mexico   \n","2  Tedd Chan, Stella Chung, Henley Hii, Lawrence ...      Singapore   \n","3  Elijah Wood, John C. Reilly, Jennifer Connelly...  United States   \n","4  Jim Sturgess, Kevin Spacey, Kate Bosworth, Aar...  United States   \n","\n","          date_added  release_year rating   duration  \\\n","0    August 14, 2020          2020  TV-MA  4 Seasons   \n","1  December 23, 2016          2016  TV-MA     93 min   \n","2  December 20, 2018          2011      R     78 min   \n","3  November 16, 2017          2009  PG-13     80 min   \n","4    January 1, 2020          2008  PG-13    123 min   \n","\n","                                           listed_in  \\\n","0  International TV Shows, TV Dramas, TV Sci-Fi &...   \n","1                       Dramas, International Movies   \n","2                Horror Movies, International Movies   \n","3  Action & Adventure, Independent Movies, Sci-Fi...   \n","4                                             Dramas   \n","\n","                                         description  \n","0  In a future where the elite inhabit an island ...  \n","1  After a devastating earthquake hits Mexico Cit...  \n","2  When an army recruit is found dead, his fellow...  \n","3  In a postapocalyptic world, rag-doll robots hi...  \n","4  A brilliant group of students become card-coun...  "]},"metadata":{"tags":[]},"execution_count":14}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"hni4m87unpYY","executionInfo":{"status":"ok","timestamp":1628445961525,"user_tz":420,"elapsed":32,"user":{"displayName":"Adelina C","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgKKnSMUjVup_IM_RppfxP-qmWHpkS2Ml89QXaL=s64","userId":"14916151407532375031"}},"outputId":"b7885136-ade0-4baf-a54a-3a1e0307d0d0"},"source":["netflix['release_year'].unique()"],"execution_count":15,"outputs":[{"output_type":"execute_result","data":{"text/plain":["array([2020, 2016, 2011, 2009, 2008, 2019, 1997, 2017, 2018, 2014, 2015,\n","       2010, 2005, 2013, 2012, 2006, 2000, 2003, 1989, 2004, 1977, 1971,\n","       1993, 2007, 1998, 1988, 1996, 2002, 1986, 1990, 1979, 1980, 1974,\n","       2001, 1999, 1966, 1991, 1982, 1994, 1995, 1978, 1992, 1972, 1975,\n","       2021, 1973, 1967, 1960, 1981, 1958, 1976, 1968, 1956, 1985, 1965,\n","       1984, 1983, 1987, 1945, 1946, 1962, 1925, 1942, 1969, 1955, 1963,\n","       1964, 1954, 1970, 1944, 1947, 1959, 1943])"]},"metadata":{"tags":[]},"execution_count":15}]},{"cell_type":"code","metadata":{"id":"P3yLNzkGnvo8","executionInfo":{"status":"ok","timestamp":1628445961526,"user_tz":420,"elapsed":30,"user":{"displayName":"Adelina C","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgKKnSMUjVup_IM_RppfxP-qmWHpkS2Ml89QXaL=s64","userId":"14916151407532375031"}}},"source":["year_dist = netflix.groupby(['release_year'])['release_year'].agg('count')"],"execution_count":16,"outputs":[]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"YO5LjTuXGsUb","executionInfo":{"status":"ok","timestamp":1628445961527,"user_tz":420,"elapsed":29,"user":{"displayName":"Adelina C","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgKKnSMUjVup_IM_RppfxP-qmWHpkS2Ml89QXaL=s64","userId":"14916151407532375031"}},"outputId":"257735f3-40e1-4c58-f29f-21b64acc0a74"},"source":["year_dist"],"execution_count":17,"outputs":[{"output_type":"execute_result","data":{"text/plain":["release_year\n","1925       1\n","1942       2\n","1943       3\n","1944       3\n","1945       3\n","        ... \n","2017    1012\n","2018    1121\n","2019     996\n","2020     868\n","2021      31\n","Name: release_year, Length: 73, dtype: int64"]},"metadata":{"tags":[]},"execution_count":17}]},{"cell_type":"code","metadata":{"id":"gAJS2OT9oAcN","executionInfo":{"status":"ok","timestamp":1628445961527,"user_tz":420,"elapsed":28,"user":{"displayName":"Adelina C","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgKKnSMUjVup_IM_RppfxP-qmWHpkS2Ml89QXaL=s64","userId":"14916151407532375031"}}},"source":["year_df = pd.DataFrame(year_dist)"],"execution_count":18,"outputs":[]},{"cell_type":"code","metadata":{"id":"PgVkSSXjoINo","executionInfo":{"status":"ok","timestamp":1628445961528,"user_tz":420,"elapsed":27,"user":{"displayName":"Adelina C","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgKKnSMUjVup_IM_RppfxP-qmWHpkS2Ml89QXaL=s64","userId":"14916151407532375031"}}},"source":["year_df = year_df.rename(columns={'release_year' : 'count'})"],"execution_count":19,"outputs":[]},{"cell_type":"code","metadata":{"id":"hG3p79KKHAb_","executionInfo":{"status":"ok","timestamp":1628445961529,"user_tz":420,"elapsed":27,"user":{"displayName":"Adelina C","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgKKnSMUjVup_IM_RppfxP-qmWHpkS2Ml89QXaL=s64","userId":"14916151407532375031"}}},"source":["year_df = year_df.reset_index()"],"execution_count":20,"outputs":[]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":0},"id":"D_5x5WzmKGbH","executionInfo":{"status":"ok","timestamp":1628445961530,"user_tz":420,"elapsed":27,"user":{"displayName":"Adelina C","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgKKnSMUjVup_IM_RppfxP-qmWHpkS2Ml89QXaL=s64","userId":"14916151407532375031"}},"outputId":"92f7992b-84d1-4fdc-888a-4ab23f7c7930"},"source":["year_df"],"execution_count":21,"outputs":[{"output_type":"execute_result","data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>release_year</th>\n","      <th>count</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1925</td>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>1942</td>\n","      <td>2</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>1943</td>\n","      <td>3</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>1944</td>\n","      <td>3</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>1945</td>\n","      <td>3</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>68</th>\n","      <td>2017</td>\n","      <td>1012</td>\n","    </tr>\n","    <tr>\n","      <th>69</th>\n","      <td>2018</td>\n","      <td>1121</td>\n","    </tr>\n","    <tr>\n","      <th>70</th>\n","      <td>2019</td>\n","      <td>996</td>\n","    </tr>\n","    <tr>\n","      <th>71</th>\n","      <td>2020</td>\n","      <td>868</td>\n","    </tr>\n","    <tr>\n","      <th>72</th>\n","      <td>2021</td>\n","      <td>31</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>73 rows × 2 columns</p>\n","</div>"],"text/plain":["    release_year  count\n","0           1925      1\n","1           1942      2\n","2           1943      3\n","3           1944      3\n","4           1945      3\n","..           ...    ...\n","68          2017   1012\n","69          2018   1121\n","70          2019    996\n","71          2020    868\n","72          2021     31\n","\n","[73 rows x 2 columns]"]},"metadata":{"tags":[]},"execution_count":21}]},{"cell_type":"code","metadata":{"id":"ppPn-E1ZHPVi","executionInfo":{"status":"ok","timestamp":1628445962698,"user_tz":420,"elapsed":1192,"user":{"displayName":"Adelina C","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgKKnSMUjVup_IM_RppfxP-qmWHpkS2Ml89QXaL=s64","userId":"14916151407532375031"}}},"source":["import plotly.express as px"],"execution_count":22,"outputs":[]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":0},"id":"ER263cZIHRBS","executionInfo":{"status":"ok","timestamp":1628445964041,"user_tz":420,"elapsed":1346,"user":{"displayName":"Adelina C","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgKKnSMUjVup_IM_RppfxP-qmWHpkS2Ml89QXaL=s64","userId":"14916151407532375031"}},"outputId":"44e8eda3-4ea8-4b8d-afd9-5786f7211b7d"},"source":["fig = px.bar(year_df, x = 'release_year', y = 'count', labels = {'release_year' : 'Release Year', 'count' : 'Count'},\n","             title = 'Distribution of Movie Release Dates on Netflix')\n","fig.show()"],"execution_count":23,"outputs":[{"output_type":"display_data","data":{"text/html":["<html>\n","<head><meta charset=\"utf-8\" /></head>\n","<body>\n","    <div>\n","            <script src=\"https://cdnjs.cloudflare.com/ajax/libs/mathjax/2.7.5/MathJax.js?config=TeX-AMS-MML_SVG\"></script><script type=\"text/javascript\">if (window.MathJax) {MathJax.Hub.Config({SVG: {font: \"STIX-Web\"}});}</script>\n","                <script type=\"text/javascript\">window.PlotlyConfig = {MathJaxConfig: 'local'};</script>\n","        <script src=\"https://cdn.plot.ly/plotly-latest.min.js\"></script>    \n","            <div id=\"adea9307-fca9-4ea7-b3c7-e2eab7ca1483\" class=\"plotly-graph-div\" style=\"height:525px; width:100%;\"></div>\n","            <script type=\"text/javascript\">\n","                \n","                    window.PLOTLYENV=window.PLOTLYENV || {};\n","                    \n","                if (document.getElementById(\"adea9307-fca9-4ea7-b3c7-e2eab7ca1483\")) {\n","                    Plotly.newPlot(\n","                        'adea9307-fca9-4ea7-b3c7-e2eab7ca1483',\n","                        [{\"alignmentgroup\": \"True\", \"hoverlabel\": {\"namelength\": 0}, \"hovertemplate\": \"Release Year=%{x}<br>Count=%{y}\", \"legendgroup\": \"\", \"marker\": {\"color\": \"#636efa\"}, \"name\": \"\", \"offsetgroup\": \"\", \"orientation\": \"v\", \"showlegend\": false, \"textposition\": \"auto\", \"type\": \"bar\", \"x\": [1925, 1942, 1943, 1944, 1945, 1946, 1947, 1954, 1955, 1956, 1958, 1959, 1960, 1962, 1963, 1964, 1965, 1966, 1967, 1968, 1969, 1970, 1971, 1972, 1973, 1974, 1975, 1976, 1977, 1978, 1979, 1980, 1981, 1982, 1983, 1984, 1985, 1986, 1987, 1988, 1989, 1990, 1991, 1992, 1993, 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021], \"xaxis\": \"x\", \"y\": [1, 2, 3, 3, 3, 2, 1, 2, 3, 2, 3, 1, 4, 3, 2, 1, 2, 1, 5, 5, 2, 2, 5, 4, 10, 7, 6, 9, 7, 6, 11, 9, 9, 15, 9, 9, 9, 10, 7, 16, 13, 20, 17, 18, 22, 16, 19, 19, 30, 31, 33, 34, 36, 45, 49, 59, 73, 85, 85, 125, 137, 173, 166, 219, 267, 334, 541, 882, 1012, 1121, 996, 868, 31], \"yaxis\": \"y\"}],\n","                        {\"barmode\": \"relative\", \"legend\": {\"tracegroupgap\": 0}, \"template\": {\"data\": {\"bar\": [{\"error_x\": {\"color\": \"#2a3f5f\"}, \"error_y\": {\"color\": \"#2a3f5f\"}, \"marker\": {\"line\": {\"color\": \"#E5ECF6\", \"width\": 0.5}}, \"type\": \"bar\"}], \"barpolar\": [{\"marker\": {\"line\": {\"color\": \"#E5ECF6\", \"width\": 0.5}}, \"type\": \"barpolar\"}], \"carpet\": [{\"aaxis\": {\"endlinecolor\": \"#2a3f5f\", \"gridcolor\": \"white\", \"linecolor\": \"white\", \"minorgridcolor\": \"white\", \"startlinecolor\": \"#2a3f5f\"}, \"baxis\": {\"endlinecolor\": \"#2a3f5f\", \"gridcolor\": \"white\", \"linecolor\": \"white\", \"minorgridcolor\": \"white\", \"startlinecolor\": \"#2a3f5f\"}, \"type\": \"carpet\"}], \"choropleth\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"type\": \"choropleth\"}], \"contour\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"contour\"}], \"contourcarpet\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"type\": \"contourcarpet\"}], \"heatmap\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"heatmap\"}], \"heatmapgl\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"heatmapgl\"}], \"histogram\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"histogram\"}], \"histogram2d\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"histogram2d\"}], \"histogram2dcontour\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"histogram2dcontour\"}], \"mesh3d\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"type\": \"mesh3d\"}], \"parcoords\": [{\"line\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"parcoords\"}], \"pie\": [{\"automargin\": true, \"type\": \"pie\"}], \"scatter\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatter\"}], \"scatter3d\": [{\"line\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatter3d\"}], \"scattercarpet\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scattercarpet\"}], \"scattergeo\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scattergeo\"}], \"scattergl\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scattergl\"}], \"scattermapbox\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scattermapbox\"}], \"scatterpolar\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatterpolar\"}], \"scatterpolargl\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatterpolargl\"}], \"scatterternary\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatterternary\"}], \"surface\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"surface\"}], \"table\": [{\"cells\": {\"fill\": {\"color\": \"#EBF0F8\"}, \"line\": {\"color\": \"white\"}}, \"header\": {\"fill\": {\"color\": \"#C8D4E3\"}, \"line\": {\"color\": \"white\"}}, \"type\": \"table\"}]}, \"layout\": {\"annotationdefaults\": {\"arrowcolor\": \"#2a3f5f\", \"arrowhead\": 0, \"arrowwidth\": 1}, \"coloraxis\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"colorscale\": {\"diverging\": [[0, \"#8e0152\"], [0.1, \"#c51b7d\"], [0.2, \"#de77ae\"], [0.3, \"#f1b6da\"], [0.4, \"#fde0ef\"], [0.5, \"#f7f7f7\"], [0.6, \"#e6f5d0\"], [0.7, \"#b8e186\"], [0.8, \"#7fbc41\"], [0.9, \"#4d9221\"], [1, \"#276419\"]], \"sequential\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"sequentialminus\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]]}, \"colorway\": [\"#636efa\", \"#EF553B\", \"#00cc96\", \"#ab63fa\", \"#FFA15A\", \"#19d3f3\", \"#FF6692\", \"#B6E880\", \"#FF97FF\", \"#FECB52\"], \"font\": {\"color\": \"#2a3f5f\"}, \"geo\": {\"bgcolor\": \"white\", \"lakecolor\": \"white\", \"landcolor\": \"#E5ECF6\", \"showlakes\": true, \"showland\": true, \"subunitcolor\": \"white\"}, \"hoverlabel\": {\"align\": \"left\"}, \"hovermode\": \"closest\", \"mapbox\": {\"style\": \"light\"}, \"paper_bgcolor\": \"white\", \"plot_bgcolor\": \"#E5ECF6\", \"polar\": {\"angularaxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}, \"bgcolor\": \"#E5ECF6\", \"radialaxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}}, \"scene\": {\"xaxis\": {\"backgroundcolor\": \"#E5ECF6\", \"gridcolor\": \"white\", \"gridwidth\": 2, \"linecolor\": \"white\", \"showbackground\": true, \"ticks\": \"\", \"zerolinecolor\": \"white\"}, \"yaxis\": {\"backgroundcolor\": \"#E5ECF6\", \"gridcolor\": \"white\", \"gridwidth\": 2, \"linecolor\": \"white\", \"showbackground\": true, \"ticks\": \"\", \"zerolinecolor\": \"white\"}, \"zaxis\": {\"backgroundcolor\": \"#E5ECF6\", \"gridcolor\": \"white\", \"gridwidth\": 2, \"linecolor\": \"white\", \"showbackground\": true, \"ticks\": \"\", \"zerolinecolor\": \"white\"}}, \"shapedefaults\": {\"line\": {\"color\": \"#2a3f5f\"}}, \"ternary\": {\"aaxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}, \"baxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}, \"bgcolor\": \"#E5ECF6\", \"caxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}}, \"title\": {\"x\": 0.05}, \"xaxis\": {\"automargin\": true, \"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\", \"title\": {\"standoff\": 15}, \"zerolinecolor\": \"white\", \"zerolinewidth\": 2}, \"yaxis\": {\"automargin\": true, \"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\", \"title\": {\"standoff\": 15}, \"zerolinecolor\": \"white\", \"zerolinewidth\": 2}}}, \"title\": {\"text\": \"Distribution of Movie Release Dates on Netflix\"}, \"xaxis\": {\"anchor\": \"y\", \"domain\": [0.0, 1.0], \"title\": {\"text\": \"Release Year\"}}, \"yaxis\": {\"anchor\": \"x\", \"domain\": [0.0, 1.0], \"title\": {\"text\": \"Count\"}}},\n","                        {\"responsive\": true}\n","                    ).then(function(){\n","                            \n","var gd = document.getElementById('adea9307-fca9-4ea7-b3c7-e2eab7ca1483');\n","var x = new MutationObserver(function (mutations, observer) {{\n","        var display = window.getComputedStyle(gd).display;\n","        if (!display || display === 'none') {{\n","            console.log([gd, 'removed!']);\n","            Plotly.purge(gd);\n","            observer.disconnect();\n","        }}\n","}});\n","\n","// Listen for the removal of the full notebook cells\n","var notebookContainer = gd.closest('#notebook-container');\n","if (notebookContainer) {{\n","    x.observe(notebookContainer, {childList: true});\n","}}\n","\n","// Listen for the clearing of the current output cell\n","var outputEl = gd.closest('.output');\n","if (outputEl) {{\n","    x.observe(outputEl, {childList: true});\n","}}\n","\n","                        })\n","                };\n","                \n","            </script>\n","        </div>\n","</body>\n","</html>"]},"metadata":{"tags":[]}}]},{"cell_type":"markdown","metadata":{"id":"xJxRcz2Xcpm_"},"source":["## HW: Analyze the US Movie Durations using the Netflix Dataframe"]},{"cell_type":"markdown","metadata":{"id":"I3T5JoiBctvu"},"source":["1. Narrow down the dataframe to only include movies that were released in only USA"]},{"cell_type":"code","metadata":{"id":"tLO-D8mxcwUu"},"source":["# Hint: Try using boolean indexing\n","usa_movies = pd.DataFrame(netflix[netflix['country'] == 'United States'])\n","usa_movies"],"execution_count":null,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"gQCUdc9FcyRq"},"source":["2. Remove any row that doesn't have its duration in minutes"]},{"cell_type":"code","metadata":{"id":"3uhPlUbIc0lw","executionInfo":{"status":"ok","timestamp":1628446529115,"user_tz":420,"elapsed":180,"user":{"displayName":"Adelina C","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgKKnSMUjVup_IM_RppfxP-qmWHpkS2Ml89QXaL=s64","userId":"14916151407532375031"}}},"source":["# Hint: try checking if \"mins\" is in the row\n","# Turn the duration column into a list\n","# create a new list\n","# if \"mins\" in the value than append 1 to new_list\n","# otherwise append 0\n","# netflix[\"valid\"] = new_list\n","# use boolean indexing \n","\n","duration_list = usa_movies.duration\n","new_list = []\n","\n","for duration in duration_list:\n","  if \"min\" in duration:\n","    new_list.append(1)\n","  else:\n","    new_list.append(0)\n","\n","usa_movies[\"valid\"] = new_list\n","usa_movies = usa_movies[usa_movies[\"valid\"] == 1]"],"execution_count":42,"outputs":[]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":1000},"id":"d9N5rCO-8p6C","executionInfo":{"status":"ok","timestamp":1628447114809,"user_tz":420,"elapsed":193,"user":{"displayName":"Adelina C","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgKKnSMUjVup_IM_RppfxP-qmWHpkS2Ml89QXaL=s64","userId":"14916151407532375031"}},"outputId":"7409e086-31ab-4897-a346-662ba1024c02"},"source":["usa_movies"],"execution_count":69,"outputs":[{"output_type":"execute_result","data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>show_id</th>\n","      <th>type</th>\n","      <th>title</th>\n","      <th>director</th>\n","      <th>cast</th>\n","      <th>country</th>\n","      <th>date_added</th>\n","      <th>release_year</th>\n","      <th>rating</th>\n","      <th>duration</th>\n","      <th>listed_in</th>\n","      <th>description</th>\n","      <th>valid</th>\n","      <th>mins</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>3</th>\n","      <td>s4</td>\n","      <td>Movie</td>\n","      <td>9</td>\n","      <td>Shane Acker</td>\n","      <td>Elijah Wood, John C. Reilly, Jennifer Connelly...</td>\n","      <td>United States</td>\n","      <td>November 16, 2017</td>\n","      <td>2009</td>\n","      <td>PG-13</td>\n","      <td>80 min</td>\n","      <td>Action &amp; Adventure, Independent Movies, Sci-Fi...</td>\n","      <td>In a postapocalyptic world, rag-doll robots hi...</td>\n","      <td>1</td>\n","      <td>80</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>s5</td>\n","      <td>Movie</td>\n","      <td>21</td>\n","      <td>Robert Luketic</td>\n","      <td>Jim Sturgess, Kevin Spacey, Kate Bosworth, Aar...</td>\n","      <td>United States</td>\n","      <td>January 1, 2020</td>\n","      <td>2008</td>\n","      <td>PG-13</td>\n","      <td>123 min</td>\n","      <td>Dramas</td>\n","      <td>A brilliant group of students become card-coun...</td>\n","      <td>1</td>\n","      <td>123</td>\n","    </tr>\n","    <tr>\n","      <th>7</th>\n","      <td>s8</td>\n","      <td>Movie</td>\n","      <td>187</td>\n","      <td>Kevin Reynolds</td>\n","      <td>Samuel L. Jackson, John Heard, Kelly Rowan, Cl...</td>\n","      <td>United States</td>\n","      <td>November 1, 2019</td>\n","      <td>1997</td>\n","      <td>R</td>\n","      <td>119 min</td>\n","      <td>Dramas</td>\n","      <td>After one of his high school students attacks ...</td>\n","      <td>1</td>\n","      <td>119</td>\n","    </tr>\n","    <tr>\n","      <th>10</th>\n","      <td>s11</td>\n","      <td>Movie</td>\n","      <td>1922</td>\n","      <td>Zak Hilditch</td>\n","      <td>Thomas Jane, Molly Parker, Dylan Schmid, Kaitl...</td>\n","      <td>United States</td>\n","      <td>October 20, 2017</td>\n","      <td>2017</td>\n","      <td>TV-MA</td>\n","      <td>103 min</td>\n","      <td>Dramas, Thrillers</td>\n","      <td>A farmer pens a confession admitting to his wi...</td>\n","      <td>1</td>\n","      <td>103</td>\n","    </tr>\n","    <tr>\n","      <th>14</th>\n","      <td>s15</td>\n","      <td>Movie</td>\n","      <td>3022</td>\n","      <td>John Suits</td>\n","      <td>Omar Epps, Kate Walsh, Miranda Cosgrove, Angus...</td>\n","      <td>United States</td>\n","      <td>March 19, 2020</td>\n","      <td>2019</td>\n","      <td>R</td>\n","      <td>91 min</td>\n","      <td>Independent Movies, Sci-Fi &amp; Fantasy, Thrillers</td>\n","      <td>Stranded when the Earth is suddenly destroyed ...</td>\n","      <td>1</td>\n","      <td>91</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>7758</th>\n","      <td>s7759</td>\n","      <td>Movie</td>\n","      <td>Zack and Miri Make a Porno</td>\n","      <td>Kevin Smith</td>\n","      <td>Seth Rogen, Elizabeth Banks, Craig Robinson, J...</td>\n","      <td>United States</td>\n","      <td>October 1, 2018</td>\n","      <td>2008</td>\n","      <td>R</td>\n","      <td>101 min</td>\n","      <td>Comedies, Independent Movies, Romantic Movies</td>\n","      <td>Zack and Miri make and star in an adult film t...</td>\n","      <td>1</td>\n","      <td>101</td>\n","    </tr>\n","    <tr>\n","      <th>7771</th>\n","      <td>s7772</td>\n","      <td>Movie</td>\n","      <td>Zion</td>\n","      <td>Floyd Russ</td>\n","      <td>Zion Clark</td>\n","      <td>United States</td>\n","      <td>August 10, 2018</td>\n","      <td>2018</td>\n","      <td>TV-PG</td>\n","      <td>12 min</td>\n","      <td>Documentaries, Sports Movies</td>\n","      <td>Born without legs and stuck in foster care for...</td>\n","      <td>1</td>\n","      <td>12</td>\n","    </tr>\n","    <tr>\n","      <th>7774</th>\n","      <td>s7775</td>\n","      <td>Movie</td>\n","      <td>Zodiac</td>\n","      <td>David Fincher</td>\n","      <td>Mark Ruffalo, Jake Gyllenhaal, Robert Downey J...</td>\n","      <td>United States</td>\n","      <td>November 20, 2019</td>\n","      <td>2007</td>\n","      <td>R</td>\n","      <td>158 min</td>\n","      <td>Cult Movies, Dramas, Thrillers</td>\n","      <td>A political cartoonist, a crime reporter and a...</td>\n","      <td>1</td>\n","      <td>158</td>\n","    </tr>\n","    <tr>\n","      <th>7778</th>\n","      <td>s7779</td>\n","      <td>Movie</td>\n","      <td>Zombieland</td>\n","      <td>Ruben Fleischer</td>\n","      <td>Jesse Eisenberg, Woody Harrelson, Emma Stone, ...</td>\n","      <td>United States</td>\n","      <td>November 1, 2019</td>\n","      <td>2009</td>\n","      <td>R</td>\n","      <td>88 min</td>\n","      <td>Comedies, Horror Movies</td>\n","      <td>Looking to survive in a world taken over by zo...</td>\n","      <td>1</td>\n","      <td>88</td>\n","    </tr>\n","    <tr>\n","      <th>7781</th>\n","      <td>s7782</td>\n","      <td>Movie</td>\n","      <td>Zoom</td>\n","      <td>Peter Hewitt</td>\n","      <td>Tim Allen, Courteney Cox, Chevy Chase, Kate Ma...</td>\n","      <td>United States</td>\n","      <td>January 11, 2020</td>\n","      <td>2006</td>\n","      <td>PG</td>\n","      <td>88 min</td>\n","      <td>Children &amp; Family Movies, Comedies</td>\n","      <td>Dragged from civilian life, a former superhero...</td>\n","      <td>1</td>\n","      <td>88</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>1850 rows × 14 columns</p>\n","</div>"],"text/plain":["     show_id   type                       title         director  \\\n","3         s4  Movie                           9      Shane Acker   \n","4         s5  Movie                          21   Robert Luketic   \n","7         s8  Movie                         187   Kevin Reynolds   \n","10       s11  Movie                        1922     Zak Hilditch   \n","14       s15  Movie                        3022       John Suits   \n","...      ...    ...                         ...              ...   \n","7758   s7759  Movie  Zack and Miri Make a Porno      Kevin Smith   \n","7771   s7772  Movie                        Zion       Floyd Russ   \n","7774   s7775  Movie                      Zodiac    David Fincher   \n","7778   s7779  Movie                  Zombieland  Ruben Fleischer   \n","7781   s7782  Movie                        Zoom     Peter Hewitt   \n","\n","                                                   cast        country  \\\n","3     Elijah Wood, John C. Reilly, Jennifer Connelly...  United States   \n","4     Jim Sturgess, Kevin Spacey, Kate Bosworth, Aar...  United States   \n","7     Samuel L. Jackson, John Heard, Kelly Rowan, Cl...  United States   \n","10    Thomas Jane, Molly Parker, Dylan Schmid, Kaitl...  United States   \n","14    Omar Epps, Kate Walsh, Miranda Cosgrove, Angus...  United States   \n","...                                                 ...            ...   \n","7758  Seth Rogen, Elizabeth Banks, Craig Robinson, J...  United States   \n","7771                                         Zion Clark  United States   \n","7774  Mark Ruffalo, Jake Gyllenhaal, Robert Downey J...  United States   \n","7778  Jesse Eisenberg, Woody Harrelson, Emma Stone, ...  United States   \n","7781  Tim Allen, Courteney Cox, Chevy Chase, Kate Ma...  United States   \n","\n","             date_added  release_year rating duration  \\\n","3     November 16, 2017          2009  PG-13   80 min   \n","4       January 1, 2020          2008  PG-13  123 min   \n","7      November 1, 2019          1997      R  119 min   \n","10     October 20, 2017          2017  TV-MA  103 min   \n","14       March 19, 2020          2019      R   91 min   \n","...                 ...           ...    ...      ...   \n","7758    October 1, 2018          2008      R  101 min   \n","7771    August 10, 2018          2018  TV-PG   12 min   \n","7774  November 20, 2019          2007      R  158 min   \n","7778   November 1, 2019          2009      R   88 min   \n","7781   January 11, 2020          2006     PG   88 min   \n","\n","                                              listed_in  \\\n","3     Action & Adventure, Independent Movies, Sci-Fi...   \n","4                                                Dramas   \n","7                                                Dramas   \n","10                                    Dramas, Thrillers   \n","14      Independent Movies, Sci-Fi & Fantasy, Thrillers   \n","...                                                 ...   \n","7758      Comedies, Independent Movies, Romantic Movies   \n","7771                       Documentaries, Sports Movies   \n","7774                     Cult Movies, Dramas, Thrillers   \n","7778                            Comedies, Horror Movies   \n","7781                 Children & Family Movies, Comedies   \n","\n","                                            description  valid  mins  \n","3     In a postapocalyptic world, rag-doll robots hi...      1    80  \n","4     A brilliant group of students become card-coun...      1   123  \n","7     After one of his high school students attacks ...      1   119  \n","10    A farmer pens a confession admitting to his wi...      1   103  \n","14    Stranded when the Earth is suddenly destroyed ...      1    91  \n","...                                                 ...    ...   ...  \n","7758  Zack and Miri make and star in an adult film t...      1   101  \n","7771  Born without legs and stuck in foster care for...      1    12  \n","7774  A political cartoonist, a crime reporter and a...      1   158  \n","7778  Looking to survive in a world taken over by zo...      1    88  \n","7781  Dragged from civilian life, a former superhero...      1    88  \n","\n","[1850 rows x 14 columns]"]},"metadata":{"tags":[]},"execution_count":69}]},{"cell_type":"markdown","metadata":{"id":"8vDlNIjwc2lv"},"source":["3. Cast the type of the duration column into an integer"]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"LasiBwtCc4Gq","executionInfo":{"status":"ok","timestamp":1628447104346,"user_tz":420,"elapsed":191,"user":{"displayName":"Adelina C","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgKKnSMUjVup_IM_RppfxP-qmWHpkS2Ml89QXaL=s64","userId":"14916151407532375031"}},"outputId":"5bd10b41-4653-4444-bdb5-42da65ec8c55"},"source":["# Hint: remove the 'mins' with replace and try using .strip()\n","# turn duration column into a list\n","# use .replace(\"mins\", \"\")  and .strip()\n","# The cast type the value into an integer\n","# create a column in the dataframe like netflix[\"mins\"] = list\n","\n","duration_list = list(usa_movies.duration)\n","\n","for i in range(len(duration_list)):\n","  duration_list[i] = int(duration_list[i].replace(\"min\", \"\").strip())\n","  \n","usa_movies[\"mins\"] = duration_list"],"execution_count":67,"outputs":[{"output_type":"stream","text":["/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.py:12: SettingWithCopyWarning:\n","\n","\n","A value is trying to be set on a copy of a slice from a DataFrame.\n","Try using .loc[row_indexer,col_indexer] = value instead\n","\n","See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n","\n"],"name":"stderr"}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":1000},"id":"21708aYlAuLq","executionInfo":{"status":"ok","timestamp":1628447109836,"user_tz":420,"elapsed":197,"user":{"displayName":"Adelina C","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgKKnSMUjVup_IM_RppfxP-qmWHpkS2Ml89QXaL=s64","userId":"14916151407532375031"}},"outputId":"340015d5-2148-47fa-fe01-9166e3d29f20"},"source":["usa_movies"],"execution_count":68,"outputs":[{"output_type":"execute_result","data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>show_id</th>\n","      <th>type</th>\n","      <th>title</th>\n","      <th>director</th>\n","      <th>cast</th>\n","      <th>country</th>\n","      <th>date_added</th>\n","      <th>release_year</th>\n","      <th>rating</th>\n","      <th>duration</th>\n","      <th>listed_in</th>\n","      <th>description</th>\n","      <th>valid</th>\n","      <th>mins</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>3</th>\n","      <td>s4</td>\n","      <td>Movie</td>\n","      <td>9</td>\n","      <td>Shane Acker</td>\n","      <td>Elijah Wood, John C. Reilly, Jennifer Connelly...</td>\n","      <td>United States</td>\n","      <td>November 16, 2017</td>\n","      <td>2009</td>\n","      <td>PG-13</td>\n","      <td>80 min</td>\n","      <td>Action &amp; Adventure, Independent Movies, Sci-Fi...</td>\n","      <td>In a postapocalyptic world, rag-doll robots hi...</td>\n","      <td>1</td>\n","      <td>80</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>s5</td>\n","      <td>Movie</td>\n","      <td>21</td>\n","      <td>Robert Luketic</td>\n","      <td>Jim Sturgess, Kevin Spacey, Kate Bosworth, Aar...</td>\n","      <td>United States</td>\n","      <td>January 1, 2020</td>\n","      <td>2008</td>\n","      <td>PG-13</td>\n","      <td>123 min</td>\n","      <td>Dramas</td>\n","      <td>A brilliant group of students become card-coun...</td>\n","      <td>1</td>\n","      <td>123</td>\n","    </tr>\n","    <tr>\n","      <th>7</th>\n","      <td>s8</td>\n","      <td>Movie</td>\n","      <td>187</td>\n","      <td>Kevin Reynolds</td>\n","      <td>Samuel L. Jackson, John Heard, Kelly Rowan, Cl...</td>\n","      <td>United States</td>\n","      <td>November 1, 2019</td>\n","      <td>1997</td>\n","      <td>R</td>\n","      <td>119 min</td>\n","      <td>Dramas</td>\n","      <td>After one of his high school students attacks ...</td>\n","      <td>1</td>\n","      <td>119</td>\n","    </tr>\n","    <tr>\n","      <th>10</th>\n","      <td>s11</td>\n","      <td>Movie</td>\n","      <td>1922</td>\n","      <td>Zak Hilditch</td>\n","      <td>Thomas Jane, Molly Parker, Dylan Schmid, Kaitl...</td>\n","      <td>United States</td>\n","      <td>October 20, 2017</td>\n","      <td>2017</td>\n","      <td>TV-MA</td>\n","      <td>103 min</td>\n","      <td>Dramas, Thrillers</td>\n","      <td>A farmer pens a confession admitting to his wi...</td>\n","      <td>1</td>\n","      <td>103</td>\n","    </tr>\n","    <tr>\n","      <th>14</th>\n","      <td>s15</td>\n","      <td>Movie</td>\n","      <td>3022</td>\n","      <td>John Suits</td>\n","      <td>Omar Epps, Kate Walsh, Miranda Cosgrove, Angus...</td>\n","      <td>United States</td>\n","      <td>March 19, 2020</td>\n","      <td>2019</td>\n","      <td>R</td>\n","      <td>91 min</td>\n","      <td>Independent Movies, Sci-Fi &amp; Fantasy, Thrillers</td>\n","      <td>Stranded when the Earth is suddenly destroyed ...</td>\n","      <td>1</td>\n","      <td>91</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>7758</th>\n","      <td>s7759</td>\n","      <td>Movie</td>\n","      <td>Zack and Miri Make a Porno</td>\n","      <td>Kevin Smith</td>\n","      <td>Seth Rogen, Elizabeth Banks, Craig Robinson, J...</td>\n","      <td>United States</td>\n","      <td>October 1, 2018</td>\n","      <td>2008</td>\n","      <td>R</td>\n","      <td>101 min</td>\n","      <td>Comedies, Independent Movies, Romantic Movies</td>\n","      <td>Zack and Miri make and star in an adult film t...</td>\n","      <td>1</td>\n","      <td>101</td>\n","    </tr>\n","    <tr>\n","      <th>7771</th>\n","      <td>s7772</td>\n","      <td>Movie</td>\n","      <td>Zion</td>\n","      <td>Floyd Russ</td>\n","      <td>Zion Clark</td>\n","      <td>United States</td>\n","      <td>August 10, 2018</td>\n","      <td>2018</td>\n","      <td>TV-PG</td>\n","      <td>12 min</td>\n","      <td>Documentaries, Sports Movies</td>\n","      <td>Born without legs and stuck in foster care for...</td>\n","      <td>1</td>\n","      <td>12</td>\n","    </tr>\n","    <tr>\n","      <th>7774</th>\n","      <td>s7775</td>\n","      <td>Movie</td>\n","      <td>Zodiac</td>\n","      <td>David Fincher</td>\n","      <td>Mark Ruffalo, Jake Gyllenhaal, Robert Downey J...</td>\n","      <td>United States</td>\n","      <td>November 20, 2019</td>\n","      <td>2007</td>\n","      <td>R</td>\n","      <td>158 min</td>\n","      <td>Cult Movies, Dramas, Thrillers</td>\n","      <td>A political cartoonist, a crime reporter and a...</td>\n","      <td>1</td>\n","      <td>158</td>\n","    </tr>\n","    <tr>\n","      <th>7778</th>\n","      <td>s7779</td>\n","      <td>Movie</td>\n","      <td>Zombieland</td>\n","      <td>Ruben Fleischer</td>\n","      <td>Jesse Eisenberg, Woody Harrelson, Emma Stone, ...</td>\n","      <td>United States</td>\n","      <td>November 1, 2019</td>\n","      <td>2009</td>\n","      <td>R</td>\n","      <td>88 min</td>\n","      <td>Comedies, Horror Movies</td>\n","      <td>Looking to survive in a world taken over by zo...</td>\n","      <td>1</td>\n","      <td>88</td>\n","    </tr>\n","    <tr>\n","      <th>7781</th>\n","      <td>s7782</td>\n","      <td>Movie</td>\n","      <td>Zoom</td>\n","      <td>Peter Hewitt</td>\n","      <td>Tim Allen, Courteney Cox, Chevy Chase, Kate Ma...</td>\n","      <td>United States</td>\n","      <td>January 11, 2020</td>\n","      <td>2006</td>\n","      <td>PG</td>\n","      <td>88 min</td>\n","      <td>Children &amp; Family Movies, Comedies</td>\n","      <td>Dragged from civilian life, a former superhero...</td>\n","      <td>1</td>\n","      <td>88</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>1850 rows × 14 columns</p>\n","</div>"],"text/plain":["     show_id   type                       title         director  \\\n","3         s4  Movie                           9      Shane Acker   \n","4         s5  Movie                          21   Robert Luketic   \n","7         s8  Movie                         187   Kevin Reynolds   \n","10       s11  Movie                        1922     Zak Hilditch   \n","14       s15  Movie                        3022       John Suits   \n","...      ...    ...                         ...              ...   \n","7758   s7759  Movie  Zack and Miri Make a Porno      Kevin Smith   \n","7771   s7772  Movie                        Zion       Floyd Russ   \n","7774   s7775  Movie                      Zodiac    David Fincher   \n","7778   s7779  Movie                  Zombieland  Ruben Fleischer   \n","7781   s7782  Movie                        Zoom     Peter Hewitt   \n","\n","                                                   cast        country  \\\n","3     Elijah Wood, John C. Reilly, Jennifer Connelly...  United States   \n","4     Jim Sturgess, Kevin Spacey, Kate Bosworth, Aar...  United States   \n","7     Samuel L. Jackson, John Heard, Kelly Rowan, Cl...  United States   \n","10    Thomas Jane, Molly Parker, Dylan Schmid, Kaitl...  United States   \n","14    Omar Epps, Kate Walsh, Miranda Cosgrove, Angus...  United States   \n","...                                                 ...            ...   \n","7758  Seth Rogen, Elizabeth Banks, Craig Robinson, J...  United States   \n","7771                                         Zion Clark  United States   \n","7774  Mark Ruffalo, Jake Gyllenhaal, Robert Downey J...  United States   \n","7778  Jesse Eisenberg, Woody Harrelson, Emma Stone, ...  United States   \n","7781  Tim Allen, Courteney Cox, Chevy Chase, Kate Ma...  United States   \n","\n","             date_added  release_year rating duration  \\\n","3     November 16, 2017          2009  PG-13   80 min   \n","4       January 1, 2020          2008  PG-13  123 min   \n","7      November 1, 2019          1997      R  119 min   \n","10     October 20, 2017          2017  TV-MA  103 min   \n","14       March 19, 2020          2019      R   91 min   \n","...                 ...           ...    ...      ...   \n","7758    October 1, 2018          2008      R  101 min   \n","7771    August 10, 2018          2018  TV-PG   12 min   \n","7774  November 20, 2019          2007      R  158 min   \n","7778   November 1, 2019          2009      R   88 min   \n","7781   January 11, 2020          2006     PG   88 min   \n","\n","                                              listed_in  \\\n","3     Action & Adventure, Independent Movies, Sci-Fi...   \n","4                                                Dramas   \n","7                                                Dramas   \n","10                                    Dramas, Thrillers   \n","14      Independent Movies, Sci-Fi & Fantasy, Thrillers   \n","...                                                 ...   \n","7758      Comedies, Independent Movies, Romantic Movies   \n","7771                       Documentaries, Sports Movies   \n","7774                     Cult Movies, Dramas, Thrillers   \n","7778                            Comedies, Horror Movies   \n","7781                 Children & Family Movies, Comedies   \n","\n","                                            description  valid  mins  \n","3     In a postapocalyptic world, rag-doll robots hi...      1    80  \n","4     A brilliant group of students become card-coun...      1   123  \n","7     After one of his high school students attacks ...      1   119  \n","10    A farmer pens a confession admitting to his wi...      1   103  \n","14    Stranded when the Earth is suddenly destroyed ...      1    91  \n","...                                                 ...    ...   ...  \n","7758  Zack and Miri make and star in an adult film t...      1   101  \n","7771  Born without legs and stuck in foster care for...      1    12  \n","7774  A political cartoonist, a crime reporter and a...      1   158  \n","7778  Looking to survive in a world taken over by zo...      1    88  \n","7781  Dragged from civilian life, a former superhero...      1    88  \n","\n","[1850 rows x 14 columns]"]},"metadata":{"tags":[]},"execution_count":68}]},{"cell_type":"markdown","metadata":{"id":"xirAAKKlc6lQ"},"source":["4. Find the average run time of the movie"]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"bHCIQrKTc7-A","executionInfo":{"status":"ok","timestamp":1628448065468,"user_tz":420,"elapsed":186,"user":{"displayName":"Adelina C","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgKKnSMUjVup_IM_RppfxP-qmWHpkS2Ml89QXaL=s64","userId":"14916151407532375031"}},"outputId":"f8c6ad70-51fa-404b-f434-e8e893b9ffa1"},"source":["# Hint: .describe() should do the trick\n","# Use it on the new column in the \"mins\" column created in question 3\n","\n","usa_movies.mins.mean()"],"execution_count":73,"outputs":[{"output_type":"execute_result","data":{"text/plain":["89.39351351351351"]},"metadata":{"tags":[]},"execution_count":73}]},{"cell_type":"markdown","metadata":{"id":"KUTfLBxSKtbN"},"source":["### Graphing Exercise"]},{"cell_type":"code","metadata":{"id":"s4bhz2GGcX4D","executionInfo":{"status":"ok","timestamp":1628387263303,"user_tz":420,"elapsed":6,"user":{"displayName":"Adelina C","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgKKnSMUjVup_IM_RppfxP-qmWHpkS2Ml89QXaL=s64","userId":"14916151407532375031"}}},"source":["import plotly.express as px\n","import pandas as pd"],"execution_count":42,"outputs":[]},{"cell_type":"code","metadata":{"id":"S_L8S9WIKxwJ"},"source":["df = pd.DataFrame({'House' : ['Gryffindor', 'Ravenclaw', 'Hufflepuff', 'Slytherin'],\n","                   'Points' : [482, 425, 352, 472], \n","                   'Details' : ['Brave', 'Wit', 'Loyal', 'Ambitious']})"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":173},"id":"M8-tS0D-LSHL","executionInfo":{"status":"ok","timestamp":1628382768777,"user_tz":420,"elapsed":992,"user":{"displayName":"Adelina C","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgKKnSMUjVup_IM_RppfxP-qmWHpkS2Ml89QXaL=s64","userId":"14916151407532375031"}},"outputId":"00a5e721-8221-49d6-946c-1789ad23164b"},"source":["df"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>House</th>\n","      <th>Points</th>\n","      <th>Details</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>Gryffindor</td>\n","      <td>482</td>\n","      <td>Brave</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>Ravenclaw</td>\n","      <td>425</td>\n","      <td>Wit</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>Hufflepuff</td>\n","      <td>352</td>\n","      <td>Loyal</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>Slytherin</td>\n","      <td>472</td>\n","      <td>Ambitious</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["        House  Points    Details\n","0  Gryffindor     482      Brave\n","1   Ravenclaw     425        Wit\n","2  Hufflepuff     352      Loyal\n","3   Slytherin     472  Ambitious"]},"metadata":{"tags":[]},"execution_count":33}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":610},"id":"lapOGF-ZLWYE","executionInfo":{"status":"ok","timestamp":1628386995630,"user_tz":420,"elapsed":337,"user":{"displayName":"Adelina C","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgKKnSMUjVup_IM_RppfxP-qmWHpkS2Ml89QXaL=s64","userId":"14916151407532375031"}},"outputId":"f1aa4b23-7d05-4fdc-a467-3bf09558f2a3"},"source":["fig = px.bar(df, x = 'House', y = 'Points', color = 'Points', labels = {'House' : 'Hogwarts House', 'Points' : 'House Points'},\n","             title = 'House Cup Competition', hover_name = 'House', hover_data = ['Details'])\n","fig.update_traces(marker_color = ['#8b0000', '#FFD700', '#00316e', '#013220'])\n","fig.show()"],"execution_count":null,"outputs":[{"output_type":"stream","text":["/usr/local/lib/python3.7/dist-packages/numpy/core/numeric.py:2378: FutureWarning:\n","\n","elementwise comparison failed; returning scalar instead, but in the future will perform elementwise comparison\n","\n"],"name":"stderr"},{"output_type":"display_data","data":{"text/html":["<html>\n","<head><meta charset=\"utf-8\" /></head>\n","<body>\n","    <div>\n","            <script src=\"https://cdnjs.cloudflare.com/ajax/libs/mathjax/2.7.5/MathJax.js?config=TeX-AMS-MML_SVG\"></script><script type=\"text/javascript\">if (window.MathJax) {MathJax.Hub.Config({SVG: {font: \"STIX-Web\"}});}</script>\n","                <script type=\"text/javascript\">window.PlotlyConfig = {MathJaxConfig: 'local'};</script>\n","        <script src=\"https://cdn.plot.ly/plotly-latest.min.js\"></script>    \n","            <div id=\"c7955883-c644-413e-8ca4-f19cd1b19240\" class=\"plotly-graph-div\" style=\"height:525px; width:100%;\"></div>\n","            <script type=\"text/javascript\">\n","                \n","                    window.PLOTLYENV=window.PLOTLYENV || {};\n","                    \n","                if (document.getElementById(\"c7955883-c644-413e-8ca4-f19cd1b19240\")) {\n","                    Plotly.newPlot(\n","                        'c7955883-c644-413e-8ca4-f19cd1b19240',\n","                        [{\"alignmentgroup\": \"True\", \"customdata\": [[\"Brave\"], [\"Wit\"], [\"Loyal\"], [\"Ambitious\"]], \"hoverlabel\": {\"namelength\": 0}, \"hovertemplate\": \"<b>%{hovertext}</b><br><br>Hogwarts House=%{x}<br>House Points=%{marker.color}<br>Details=%{customdata[0]}\", \"hovertext\": [\"Gryffindor\", \"Ravenclaw\", \"Hufflepuff\", \"Slytherin\"], \"legendgroup\": \"\", \"marker\": {\"color\": [\"#8b0000\", \"#FFD700\", \"#00316e\", \"#013220\"], \"coloraxis\": \"coloraxis\"}, \"name\": \"\", \"offsetgroup\": \"\", \"orientation\": \"v\", \"showlegend\": false, \"textposition\": \"auto\", \"type\": \"bar\", \"x\": [\"Gryffindor\", \"Ravenclaw\", \"Hufflepuff\", \"Slytherin\"], \"xaxis\": \"x\", \"y\": [482, 425, 352, 472], \"yaxis\": \"y\"}],\n","                        {\"barmode\": \"relative\", \"coloraxis\": {\"colorbar\": {\"title\": {\"text\": \"House Points\"}}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]]}, \"legend\": {\"tracegroupgap\": 0}, \"template\": {\"data\": {\"bar\": [{\"error_x\": {\"color\": \"#2a3f5f\"}, \"error_y\": {\"color\": \"#2a3f5f\"}, \"marker\": {\"line\": {\"color\": \"#E5ECF6\", \"width\": 0.5}}, \"type\": \"bar\"}], \"barpolar\": [{\"marker\": {\"line\": {\"color\": \"#E5ECF6\", \"width\": 0.5}}, \"type\": \"barpolar\"}], \"carpet\": [{\"aaxis\": {\"endlinecolor\": \"#2a3f5f\", \"gridcolor\": \"white\", \"linecolor\": \"white\", \"minorgridcolor\": \"white\", \"startlinecolor\": \"#2a3f5f\"}, \"baxis\": {\"endlinecolor\": \"#2a3f5f\", \"gridcolor\": \"white\", \"linecolor\": \"white\", \"minorgridcolor\": \"white\", \"startlinecolor\": \"#2a3f5f\"}, \"type\": \"carpet\"}], \"choropleth\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"type\": \"choropleth\"}], \"contour\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"contour\"}], \"contourcarpet\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"type\": \"contourcarpet\"}], \"heatmap\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"heatmap\"}], \"heatmapgl\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"heatmapgl\"}], \"histogram\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"histogram\"}], \"histogram2d\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"histogram2d\"}], \"histogram2dcontour\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"histogram2dcontour\"}], \"mesh3d\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"type\": \"mesh3d\"}], \"parcoords\": [{\"line\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"parcoords\"}], \"pie\": [{\"automargin\": true, \"type\": \"pie\"}], \"scatter\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatter\"}], \"scatter3d\": [{\"line\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatter3d\"}], \"scattercarpet\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scattercarpet\"}], \"scattergeo\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scattergeo\"}], \"scattergl\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scattergl\"}], \"scattermapbox\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scattermapbox\"}], \"scatterpolar\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatterpolar\"}], \"scatterpolargl\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatterpolargl\"}], \"scatterternary\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatterternary\"}], \"surface\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"surface\"}], \"table\": [{\"cells\": {\"fill\": {\"color\": \"#EBF0F8\"}, \"line\": {\"color\": \"white\"}}, \"header\": {\"fill\": {\"color\": \"#C8D4E3\"}, \"line\": {\"color\": \"white\"}}, \"type\": \"table\"}]}, \"layout\": {\"annotationdefaults\": {\"arrowcolor\": \"#2a3f5f\", \"arrowhead\": 0, \"arrowwidth\": 1}, \"coloraxis\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"colorscale\": {\"diverging\": [[0, \"#8e0152\"], [0.1, \"#c51b7d\"], [0.2, \"#de77ae\"], [0.3, \"#f1b6da\"], [0.4, \"#fde0ef\"], [0.5, \"#f7f7f7\"], [0.6, \"#e6f5d0\"], [0.7, \"#b8e186\"], [0.8, \"#7fbc41\"], [0.9, \"#4d9221\"], [1, \"#276419\"]], \"sequential\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"sequentialminus\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]]}, \"colorway\": [\"#636efa\", \"#EF553B\", \"#00cc96\", \"#ab63fa\", \"#FFA15A\", \"#19d3f3\", \"#FF6692\", \"#B6E880\", \"#FF97FF\", \"#FECB52\"], \"font\": {\"color\": \"#2a3f5f\"}, \"geo\": {\"bgcolor\": \"white\", \"lakecolor\": \"white\", \"landcolor\": \"#E5ECF6\", \"showlakes\": true, \"showland\": true, \"subunitcolor\": \"white\"}, \"hoverlabel\": {\"align\": \"left\"}, \"hovermode\": \"closest\", \"mapbox\": {\"style\": \"light\"}, \"paper_bgcolor\": \"white\", \"plot_bgcolor\": \"#E5ECF6\", \"polar\": {\"angularaxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}, \"bgcolor\": \"#E5ECF6\", \"radialaxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}}, \"scene\": {\"xaxis\": {\"backgroundcolor\": \"#E5ECF6\", \"gridcolor\": \"white\", \"gridwidth\": 2, \"linecolor\": \"white\", \"showbackground\": true, \"ticks\": \"\", \"zerolinecolor\": \"white\"}, \"yaxis\": {\"backgroundcolor\": \"#E5ECF6\", \"gridcolor\": \"white\", \"gridwidth\": 2, \"linecolor\": \"white\", \"showbackground\": true, \"ticks\": \"\", \"zerolinecolor\": \"white\"}, \"zaxis\": {\"backgroundcolor\": \"#E5ECF6\", \"gridcolor\": \"white\", \"gridwidth\": 2, \"linecolor\": \"white\", \"showbackground\": true, \"ticks\": \"\", \"zerolinecolor\": \"white\"}}, \"shapedefaults\": {\"line\": {\"color\": \"#2a3f5f\"}}, \"ternary\": {\"aaxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}, \"baxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}, \"bgcolor\": \"#E5ECF6\", \"caxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}}, \"title\": {\"x\": 0.05}, \"xaxis\": {\"automargin\": true, \"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\", \"title\": {\"standoff\": 15}, \"zerolinecolor\": \"white\", \"zerolinewidth\": 2}, \"yaxis\": {\"automargin\": true, \"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\", \"title\": {\"standoff\": 15}, \"zerolinecolor\": \"white\", \"zerolinewidth\": 2}}}, \"title\": {\"text\": \"House Cup Competition\"}, \"xaxis\": {\"anchor\": \"y\", \"domain\": [0.0, 1.0], \"title\": {\"text\": \"Hogwarts House\"}}, \"yaxis\": {\"anchor\": \"x\", \"domain\": [0.0, 1.0], \"title\": {\"text\": \"House Points\"}}},\n","                        {\"responsive\": true}\n","                    ).then(function(){\n","                            \n","var gd = document.getElementById('c7955883-c644-413e-8ca4-f19cd1b19240');\n","var x = new MutationObserver(function (mutations, observer) {{\n","        var display = window.getComputedStyle(gd).display;\n","        if (!display || display === 'none') {{\n","            console.log([gd, 'removed!']);\n","            Plotly.purge(gd);\n","            observer.disconnect();\n","        }}\n","}});\n","\n","// Listen for the removal of the full notebook cells\n","var notebookContainer = gd.closest('#notebook-container');\n","if (notebookContainer) {{\n","    x.observe(notebookContainer, {childList: true});\n","}}\n","\n","// Listen for the clearing of the current output cell\n","var outputEl = gd.closest('.output');\n","if (outputEl) {{\n","    x.observe(outputEl, {childList: true});\n","}}\n","\n","                        })\n","                };\n","                \n","            </script>\n","        </div>\n","</body>\n","</html>"]},"metadata":{"tags":[]}}]}]}