Star Wars Surveys.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "# Star Wars Survey Analysis"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**What the project is about:**: While waiting for [*Star Wars: The Force Awakens*](https://en.wikipedia.org/wiki/Star_Wars:_The_Force_Awakens) to come out, the team at [FiveThirtyEight](http://fivethirtyeight.com/) became interested in answering some questions about *Star Wars* fans. In particular, they wondered: **does the rest of America realize that *The Empire Strikes Back* is clearly the best of the entire series?**\n",
    "\n",
    "The team needed to collect data addressing this question. To do this, they surveyed *Star Wars* fans using the online tool SurveyMonkey. In total, they received 835 responses, which can be downloaded from [their GitHub repository](https://github.com/fivethirtyeight/data/tree/master/star-wars-survey).\n",
    "\n",
    "**Goal of the project:** For this project, I'll simply be cleaning and exploring the dataset in Jupyter notebook for fun!"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Initial Investigation"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Let's start by reading the dataset into a DataFrame and checking for any strange values in the columns and rows."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "star_wars = pd.read_csv(\"star_wars.csv\", encoding=\"ISO-8859-1\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "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>RespondentID</th>\n",
       "      <th>Have you seen any of the 6 films in the Star Wars franchise?</th>\n",
       "      <th>Do you consider yourself to be a fan of the Star Wars film franchise?</th>\n",
       "      <th>Which of the following Star Wars films have you seen? Please select all that apply.</th>\n",
       "      <th>Unnamed: 4</th>\n",
       "      <th>Unnamed: 5</th>\n",
       "      <th>Unnamed: 6</th>\n",
       "      <th>Unnamed: 7</th>\n",
       "      <th>Unnamed: 8</th>\n",
       "      <th>Please rank the Star Wars films in order of preference with 1 being your favorite film in the franchise and 6 being your least favorite film.</th>\n",
       "      <th>...</th>\n",
       "      <th>Unnamed: 28</th>\n",
       "      <th>Which character shot first?</th>\n",
       "      <th>Are you familiar with the Expanded Universe?</th>\n",
       "      <th>Do you consider yourself to be a fan of the Expanded Universe?</th>\n",
       "      <th>Do you consider yourself to be a fan of the Star Trek franchise?</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Age</th>\n",
       "      <th>Household Income</th>\n",
       "      <th>Education</th>\n",
       "      <th>Location (Census Region)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3292879998</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Star Wars: Episode I  The Phantom Menace</td>\n",
       "      <td>Star Wars: Episode II  Attack of the Clones</td>\n",
       "      <td>Star Wars: Episode III  Revenge of the Sith</td>\n",
       "      <td>Star Wars: Episode IV  A New Hope</td>\n",
       "      <td>Star Wars: Episode V The Empire Strikes Back</td>\n",
       "      <td>Star Wars: Episode VI Return of the Jedi</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Very favorably</td>\n",
       "      <td>I don't understand this question</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>18-29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>High school degree</td>\n",
       "      <td>South Atlantic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3292879538</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Male</td>\n",
       "      <td>18-29</td>\n",
       "      <td>$0 - $24,999</td>\n",
       "      <td>Bachelor degree</td>\n",
       "      <td>West South Central</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3292765271</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Star Wars: Episode I  The Phantom Menace</td>\n",
       "      <td>Star Wars: Episode II  Attack of the Clones</td>\n",
       "      <td>Star Wars: Episode III  Revenge of the Sith</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Unfamiliar (N/A)</td>\n",
       "      <td>I don't understand this question</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>18-29</td>\n",
       "      <td>$0 - $24,999</td>\n",
       "      <td>High school degree</td>\n",
       "      <td>West North Central</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3292763116</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Star Wars: Episode I  The Phantom Menace</td>\n",
       "      <td>Star Wars: Episode II  Attack of the Clones</td>\n",
       "      <td>Star Wars: Episode III  Revenge of the Sith</td>\n",
       "      <td>Star Wars: Episode IV  A New Hope</td>\n",
       "      <td>Star Wars: Episode V The Empire Strikes Back</td>\n",
       "      <td>Star Wars: Episode VI Return of the Jedi</td>\n",
       "      <td>5.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Very favorably</td>\n",
       "      <td>I don't understand this question</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Male</td>\n",
       "      <td>18-29</td>\n",
       "      <td>$100,000 - $149,999</td>\n",
       "      <td>Some college or Associate degree</td>\n",
       "      <td>West North Central</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3292731220</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Star Wars: Episode I  The Phantom Menace</td>\n",
       "      <td>Star Wars: Episode II  Attack of the Clones</td>\n",
       "      <td>Star Wars: Episode III  Revenge of the Sith</td>\n",
       "      <td>Star Wars: Episode IV  A New Hope</td>\n",
       "      <td>Star Wars: Episode V The Empire Strikes Back</td>\n",
       "      <td>Star Wars: Episode VI Return of the Jedi</td>\n",
       "      <td>5.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Somewhat favorably</td>\n",
       "      <td>Greedo</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>18-29</td>\n",
       "      <td>$100,000 - $149,999</td>\n",
       "      <td>Some college or Associate degree</td>\n",
       "      <td>West North Central</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 38 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   RespondentID Have you seen any of the 6 films in the Star Wars franchise?  \\\n",
       "0    3292879998                                                Yes             \n",
       "1    3292879538                                                 No             \n",
       "2    3292765271                                                Yes             \n",
       "3    3292763116                                                Yes             \n",
       "4    3292731220                                                Yes             \n",
       "\n",
       "  Do you consider yourself to be a fan of the Star Wars film franchise?  \\\n",
       "0                                                Yes                      \n",
       "1                                                NaN                      \n",
       "2                                                 No                      \n",
       "3                                                Yes                      \n",
       "4                                                Yes                      \n",
       "\n",
       "  Which of the following Star Wars films have you seen? Please select all that apply.  \\\n",
       "0           Star Wars: Episode I  The Phantom Menace                                    \n",
       "1                                                NaN                                    \n",
       "2           Star Wars: Episode I  The Phantom Menace                                    \n",
       "3           Star Wars: Episode I  The Phantom Menace                                    \n",
       "4           Star Wars: Episode I  The Phantom Menace                                    \n",
       "\n",
       "                                    Unnamed: 4  \\\n",
       "0  Star Wars: Episode II  Attack of the Clones   \n",
       "1                                          NaN   \n",
       "2  Star Wars: Episode II  Attack of the Clones   \n",
       "3  Star Wars: Episode II  Attack of the Clones   \n",
       "4  Star Wars: Episode II  Attack of the Clones   \n",
       "\n",
       "                                    Unnamed: 5  \\\n",
       "0  Star Wars: Episode III  Revenge of the Sith   \n",
       "1                                          NaN   \n",
       "2  Star Wars: Episode III  Revenge of the Sith   \n",
       "3  Star Wars: Episode III  Revenge of the Sith   \n",
       "4  Star Wars: Episode III  Revenge of the Sith   \n",
       "\n",
       "                          Unnamed: 6  \\\n",
       "0  Star Wars: Episode IV  A New Hope   \n",
       "1                                NaN   \n",
       "2                                NaN   \n",
       "3  Star Wars: Episode IV  A New Hope   \n",
       "4  Star Wars: Episode IV  A New Hope   \n",
       "\n",
       "                                     Unnamed: 7  \\\n",
       "0  Star Wars: Episode V The Empire Strikes Back   \n",
       "1                                           NaN   \n",
       "2                                           NaN   \n",
       "3  Star Wars: Episode V The Empire Strikes Back   \n",
       "4  Star Wars: Episode V The Empire Strikes Back   \n",
       "\n",
       "                                 Unnamed: 8  \\\n",
       "0  Star Wars: Episode VI Return of the Jedi   \n",
       "1                                       NaN   \n",
       "2                                       NaN   \n",
       "3  Star Wars: Episode VI Return of the Jedi   \n",
       "4  Star Wars: Episode VI Return of the Jedi   \n",
       "\n",
       "   Please rank the Star Wars films in order of preference with 1 being your favorite film in the franchise and 6 being your least favorite film.  \\\n",
       "0                                                3.0                                                                                               \n",
       "1                                                NaN                                                                                               \n",
       "2                                                1.0                                                                                               \n",
       "3                                                5.0                                                                                               \n",
       "4                                                5.0                                                                                               \n",
       "\n",
       "   ...         Unnamed: 28       Which character shot first?  \\\n",
       "0  ...      Very favorably  I don't understand this question   \n",
       "1  ...                 NaN                               NaN   \n",
       "2  ...    Unfamiliar (N/A)  I don't understand this question   \n",
       "3  ...      Very favorably  I don't understand this question   \n",
       "4  ...  Somewhat favorably                            Greedo   \n",
       "\n",
       "   Are you familiar with the Expanded Universe?  \\\n",
       "0                                           Yes   \n",
       "1                                           NaN   \n",
       "2                                            No   \n",
       "3                                            No   \n",
       "4                                           Yes   \n",
       "\n",
       "   Do you consider yourself to be a fan of the Expanded Universe?  \\\n",
       "0                                                 No                \n",
       "1                                                NaN                \n",
       "2                                                NaN                \n",
       "3                                                NaN                \n",
       "4                                                 No                \n",
       "\n",
       "   Do you consider yourself to be a fan of the Star Trek franchise? Gender  \\\n",
       "0                                                 No                  Male   \n",
       "1                                                Yes                  Male   \n",
       "2                                                 No                  Male   \n",
       "3                                                Yes                  Male   \n",
       "4                                                 No                  Male   \n",
       "\n",
       "     Age     Household Income                         Education  \\\n",
       "0  18-29                  NaN                High school degree   \n",
       "1  18-29         $0 - $24,999                   Bachelor degree   \n",
       "2  18-29         $0 - $24,999                High school degree   \n",
       "3  18-29  $100,000 - $149,999  Some college or Associate degree   \n",
       "4  18-29  $100,000 - $149,999  Some college or Associate degree   \n",
       "\n",
       "  Location (Census Region)  \n",
       "0           South Atlantic  \n",
       "1       West South Central  \n",
       "2       West North Central  \n",
       "3       West North Central  \n",
       "4       West North Central  \n",
       "\n",
       "[5 rows x 38 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "star_wars.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['RespondentID',\n",
       "       'Have you seen any of the 6 films in the Star Wars franchise?',\n",
       "       'Do you consider yourself to be a fan of the Star Wars film franchise?',\n",
       "       'Which of the following Star Wars films have you seen? Please select all that apply.',\n",
       "       'Unnamed: 4', 'Unnamed: 5', 'Unnamed: 6', 'Unnamed: 7', 'Unnamed: 8',\n",
       "       'Please rank the Star Wars films in order of preference with 1 being your favorite film in the franchise and 6 being your least favorite film.',\n",
       "       'Unnamed: 10', 'Unnamed: 11', 'Unnamed: 12', 'Unnamed: 13',\n",
       "       'Unnamed: 14',\n",
       "       'Please state whether you view the following characters favorably, unfavorably, or are unfamiliar with him/her.',\n",
       "       'Unnamed: 16', 'Unnamed: 17', 'Unnamed: 18', 'Unnamed: 19',\n",
       "       'Unnamed: 20', 'Unnamed: 21', 'Unnamed: 22', 'Unnamed: 23',\n",
       "       'Unnamed: 24', 'Unnamed: 25', 'Unnamed: 26', 'Unnamed: 27',\n",
       "       'Unnamed: 28', 'Which character shot first?',\n",
       "       'Are you familiar with the Expanded Universe?',\n",
       "       'Do you consider yourself to be a fan of the Expanded Universe?',\n",
       "       'Do you consider yourself to be a fan of the Star Trek franchise?',\n",
       "       'Gender', 'Age', 'Household Income', 'Education',\n",
       "       'Location (Census Region)'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "star_wars.columns"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Cleaning Up the Data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The first two columns represent `Yes/No` questions:\n",
    "\n",
    "- `Have you seen any of the 6 films in the Star Wars franchise?`\n",
    "- `Do you consider yourself to be a fan of the Star Wars film franchise?`\n",
    "\n",
    "There can also be `NaN` values where a respondent has chosen not to answer. \n",
    "\n",
    "To make the data a bit easier to analyze later, I'll go ahead and convert each column to a Boolean with only the values `True`, `False`, and `NaN`. Booleans are easier to work with because I can select the rows that are `True` or `False` without having to do a string comparison.\n",
    "\n",
    "I'll use the `pandas.Series.map()` method on series objects to perform the conversion."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "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>RespondentID</th>\n",
       "      <th>Have you seen any of the 6 films in the Star Wars franchise?</th>\n",
       "      <th>Do you consider yourself to be a fan of the Star Wars film franchise?</th>\n",
       "      <th>Which of the following Star Wars films have you seen? Please select all that apply.</th>\n",
       "      <th>Unnamed: 4</th>\n",
       "      <th>Unnamed: 5</th>\n",
       "      <th>Unnamed: 6</th>\n",
       "      <th>Unnamed: 7</th>\n",
       "      <th>Unnamed: 8</th>\n",
       "      <th>Please rank the Star Wars films in order of preference with 1 being your favorite film in the franchise and 6 being your least favorite film.</th>\n",
       "      <th>...</th>\n",
       "      <th>Unnamed: 28</th>\n",
       "      <th>Which character shot first?</th>\n",
       "      <th>Are you familiar with the Expanded Universe?</th>\n",
       "      <th>Do you consider yourself to be a fan of the Expanded Universe?</th>\n",
       "      <th>Do you consider yourself to be a fan of the Star Trek franchise?</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Age</th>\n",
       "      <th>Household Income</th>\n",
       "      <th>Education</th>\n",
       "      <th>Location (Census Region)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3292879998</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>Star Wars: Episode I  The Phantom Menace</td>\n",
       "      <td>Star Wars: Episode II  Attack of the Clones</td>\n",
       "      <td>Star Wars: Episode III  Revenge of the Sith</td>\n",
       "      <td>Star Wars: Episode IV  A New Hope</td>\n",
       "      <td>Star Wars: Episode V The Empire Strikes Back</td>\n",
       "      <td>Star Wars: Episode VI Return of the Jedi</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Very favorably</td>\n",
       "      <td>I don't understand this question</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>18-29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>High school degree</td>\n",
       "      <td>South Atlantic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3292879538</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Male</td>\n",
       "      <td>18-29</td>\n",
       "      <td>$0 - $24,999</td>\n",
       "      <td>Bachelor degree</td>\n",
       "      <td>West South Central</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3292765271</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>Star Wars: Episode I  The Phantom Menace</td>\n",
       "      <td>Star Wars: Episode II  Attack of the Clones</td>\n",
       "      <td>Star Wars: Episode III  Revenge of the Sith</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Unfamiliar (N/A)</td>\n",
       "      <td>I don't understand this question</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>18-29</td>\n",
       "      <td>$0 - $24,999</td>\n",
       "      <td>High school degree</td>\n",
       "      <td>West North Central</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3292763116</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>Star Wars: Episode I  The Phantom Menace</td>\n",
       "      <td>Star Wars: Episode II  Attack of the Clones</td>\n",
       "      <td>Star Wars: Episode III  Revenge of the Sith</td>\n",
       "      <td>Star Wars: Episode IV  A New Hope</td>\n",
       "      <td>Star Wars: Episode V The Empire Strikes Back</td>\n",
       "      <td>Star Wars: Episode VI Return of the Jedi</td>\n",
       "      <td>5.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Very favorably</td>\n",
       "      <td>I don't understand this question</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Male</td>\n",
       "      <td>18-29</td>\n",
       "      <td>$100,000 - $149,999</td>\n",
       "      <td>Some college or Associate degree</td>\n",
       "      <td>West North Central</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3292731220</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>Star Wars: Episode I  The Phantom Menace</td>\n",
       "      <td>Star Wars: Episode II  Attack of the Clones</td>\n",
       "      <td>Star Wars: Episode III  Revenge of the Sith</td>\n",
       "      <td>Star Wars: Episode IV  A New Hope</td>\n",
       "      <td>Star Wars: Episode V The Empire Strikes Back</td>\n",
       "      <td>Star Wars: Episode VI Return of the Jedi</td>\n",
       "      <td>5.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Somewhat favorably</td>\n",
       "      <td>Greedo</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>18-29</td>\n",
       "      <td>$100,000 - $149,999</td>\n",
       "      <td>Some college or Associate degree</td>\n",
       "      <td>West North Central</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 38 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   RespondentID  Have you seen any of the 6 films in the Star Wars franchise?  \\\n",
       "0    3292879998                                               True              \n",
       "1    3292879538                                              False              \n",
       "2    3292765271                                               True              \n",
       "3    3292763116                                               True              \n",
       "4    3292731220                                               True              \n",
       "\n",
       "  Do you consider yourself to be a fan of the Star Wars film franchise?  \\\n",
       "0                                               True                      \n",
       "1                                                NaN                      \n",
       "2                                              False                      \n",
       "3                                               True                      \n",
       "4                                               True                      \n",
       "\n",
       "  Which of the following Star Wars films have you seen? Please select all that apply.  \\\n",
       "0           Star Wars: Episode I  The Phantom Menace                                    \n",
       "1                                                NaN                                    \n",
       "2           Star Wars: Episode I  The Phantom Menace                                    \n",
       "3           Star Wars: Episode I  The Phantom Menace                                    \n",
       "4           Star Wars: Episode I  The Phantom Menace                                    \n",
       "\n",
       "                                    Unnamed: 4  \\\n",
       "0  Star Wars: Episode II  Attack of the Clones   \n",
       "1                                          NaN   \n",
       "2  Star Wars: Episode II  Attack of the Clones   \n",
       "3  Star Wars: Episode II  Attack of the Clones   \n",
       "4  Star Wars: Episode II  Attack of the Clones   \n",
       "\n",
       "                                    Unnamed: 5  \\\n",
       "0  Star Wars: Episode III  Revenge of the Sith   \n",
       "1                                          NaN   \n",
       "2  Star Wars: Episode III  Revenge of the Sith   \n",
       "3  Star Wars: Episode III  Revenge of the Sith   \n",
       "4  Star Wars: Episode III  Revenge of the Sith   \n",
       "\n",
       "                          Unnamed: 6  \\\n",
       "0  Star Wars: Episode IV  A New Hope   \n",
       "1                                NaN   \n",
       "2                                NaN   \n",
       "3  Star Wars: Episode IV  A New Hope   \n",
       "4  Star Wars: Episode IV  A New Hope   \n",
       "\n",
       "                                     Unnamed: 7  \\\n",
       "0  Star Wars: Episode V The Empire Strikes Back   \n",
       "1                                           NaN   \n",
       "2                                           NaN   \n",
       "3  Star Wars: Episode V The Empire Strikes Back   \n",
       "4  Star Wars: Episode V The Empire Strikes Back   \n",
       "\n",
       "                                 Unnamed: 8  \\\n",
       "0  Star Wars: Episode VI Return of the Jedi   \n",
       "1                                       NaN   \n",
       "2                                       NaN   \n",
       "3  Star Wars: Episode VI Return of the Jedi   \n",
       "4  Star Wars: Episode VI Return of the Jedi   \n",
       "\n",
       "   Please rank the Star Wars films in order of preference with 1 being your favorite film in the franchise and 6 being your least favorite film.  \\\n",
       "0                                                3.0                                                                                               \n",
       "1                                                NaN                                                                                               \n",
       "2                                                1.0                                                                                               \n",
       "3                                                5.0                                                                                               \n",
       "4                                                5.0                                                                                               \n",
       "\n",
       "   ...         Unnamed: 28       Which character shot first?  \\\n",
       "0  ...      Very favorably  I don't understand this question   \n",
       "1  ...                 NaN                               NaN   \n",
       "2  ...    Unfamiliar (N/A)  I don't understand this question   \n",
       "3  ...      Very favorably  I don't understand this question   \n",
       "4  ...  Somewhat favorably                            Greedo   \n",
       "\n",
       "   Are you familiar with the Expanded Universe?  \\\n",
       "0                                           Yes   \n",
       "1                                           NaN   \n",
       "2                                            No   \n",
       "3                                            No   \n",
       "4                                           Yes   \n",
       "\n",
       "   Do you consider yourself to be a fan of the Expanded Universe?  \\\n",
       "0                                                 No                \n",
       "1                                                NaN                \n",
       "2                                                NaN                \n",
       "3                                                NaN                \n",
       "4                                                 No                \n",
       "\n",
       "   Do you consider yourself to be a fan of the Star Trek franchise? Gender  \\\n",
       "0                                                 No                  Male   \n",
       "1                                                Yes                  Male   \n",
       "2                                                 No                  Male   \n",
       "3                                                Yes                  Male   \n",
       "4                                                 No                  Male   \n",
       "\n",
       "     Age     Household Income                         Education  \\\n",
       "0  18-29                  NaN                High school degree   \n",
       "1  18-29         $0 - $24,999                   Bachelor degree   \n",
       "2  18-29         $0 - $24,999                High school degree   \n",
       "3  18-29  $100,000 - $149,999  Some college or Associate degree   \n",
       "4  18-29  $100,000 - $149,999  Some college or Associate degree   \n",
       "\n",
       "  Location (Census Region)  \n",
       "0           South Atlantic  \n",
       "1       West South Central  \n",
       "2       West North Central  \n",
       "3       West North Central  \n",
       "4       West North Central  \n",
       "\n",
       "[5 rows x 38 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "yes_no = {\"Yes\": True, \"No\": False}\n",
    "\n",
    "for col in [\n",
    "    \"Have you seen any of the 6 films in the Star Wars franchise?\",\n",
    "    \"Do you consider yourself to be a fan of the Star Wars film franchise?\"\n",
    "    ]:\n",
    "    star_wars[col] = star_wars[col].map(yes_no)\n",
    "\n",
    "star_wars.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The next six columns represent a single checkbox question. The respondent checked off a series of boxes in response to the question, `Which of the following Star Wars films have you seen? Please select all that apply.`\n",
    "\n",
    "The columns for this question are:\n",
    "\n",
    "- `Which of the following Star Wars films have you seen? Please select all that apply.` — whether or not the respondent saw *Star Wars: Episode I The Phantom Menace.*\n",
    "- `Unnamed: 4` — whether or not the respondent saw *Star Wars: Episode II Attack of the Clones.*\n",
    "- `Unnamed: 5` — whether or not the respondent saw *Star Wars: Episode III Revenge of the Sith.*\n",
    "- `Unnamed: 6` — whether or not the respondent saw *Star Wars: Episode IV A New Hope.*\n",
    "- `Unnamed: 7` — whether or not the respondent saw *Star Wars: Episode V The Empire Strikes Back.*\n",
    "- `Unnamed: 8` — whether or not the respondent saw *Star Wars: Episode VI Return of the Jedi.*\n",
    "\n",
    "For each of these columns, if the value in a cell is the name of the movie, that means the respondent saw the movie. If the value is `NaN`, the respondent either didn't answer or didn't see the movie. I'll assume that they didn't see the movie.\n",
    "\n",
    "I'll need to convert each of these columns to a Boolean, then rename the column something more intuitive - as seen below."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "\n",
    "movie_mapping = {\n",
    "    \"Star Wars: Episode I  The Phantom Menace\": True,\n",
    "    np.nan: False,\n",
    "    \"Star Wars: Episode II  Attack of the Clones\": True,\n",
    "    \"Star Wars: Episode III  Revenge of the Sith\": True,\n",
    "    \"Star Wars: Episode IV  A New Hope\": True,\n",
    "    \"Star Wars: Episode V The Empire Strikes Back\": True,\n",
    "    \"Star Wars: Episode VI Return of the Jedi\": True\n",
    "}\n",
    "\n",
    "for col in star_wars.columns[3:9]:\n",
    "    star_wars[col] = star_wars[col].map(movie_mapping)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "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>RespondentID</th>\n",
       "      <th>Have you seen any of the 6 films in the Star Wars franchise?</th>\n",
       "      <th>Do you consider yourself to be a fan of the Star Wars film franchise?</th>\n",
       "      <th>seen_1</th>\n",
       "      <th>seen_2</th>\n",
       "      <th>seen_3</th>\n",
       "      <th>seen_4</th>\n",
       "      <th>seen_5</th>\n",
       "      <th>seen_6</th>\n",
       "      <th>Please rank the Star Wars films in order of preference with 1 being your favorite film in the franchise and 6 being your least favorite film.</th>\n",
       "      <th>...</th>\n",
       "      <th>Unnamed: 28</th>\n",
       "      <th>Which character shot first?</th>\n",
       "      <th>Are you familiar with the Expanded Universe?</th>\n",
       "      <th>Do you consider yourself to be a fan of the Expanded Universe?</th>\n",
       "      <th>Do you consider yourself to be a fan of the Star Trek franchise?</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Age</th>\n",
       "      <th>Household Income</th>\n",
       "      <th>Education</th>\n",
       "      <th>Location (Census Region)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3292879998</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Very favorably</td>\n",
       "      <td>I don't understand this question</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>18-29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>High school degree</td>\n",
       "      <td>South Atlantic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3292879538</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Male</td>\n",
       "      <td>18-29</td>\n",
       "      <td>$0 - $24,999</td>\n",
       "      <td>Bachelor degree</td>\n",
       "      <td>West South Central</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3292765271</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Unfamiliar (N/A)</td>\n",
       "      <td>I don't understand this question</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>18-29</td>\n",
       "      <td>$0 - $24,999</td>\n",
       "      <td>High school degree</td>\n",
       "      <td>West North Central</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3292763116</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>5.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Very favorably</td>\n",
       "      <td>I don't understand this question</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Male</td>\n",
       "      <td>18-29</td>\n",
       "      <td>$100,000 - $149,999</td>\n",
       "      <td>Some college or Associate degree</td>\n",
       "      <td>West North Central</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3292731220</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>5.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Somewhat favorably</td>\n",
       "      <td>Greedo</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>18-29</td>\n",
       "      <td>$100,000 - $149,999</td>\n",
       "      <td>Some college or Associate degree</td>\n",
       "      <td>West North Central</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 38 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   RespondentID  Have you seen any of the 6 films in the Star Wars franchise?  \\\n",
       "0    3292879998                                               True              \n",
       "1    3292879538                                              False              \n",
       "2    3292765271                                               True              \n",
       "3    3292763116                                               True              \n",
       "4    3292731220                                               True              \n",
       "\n",
       "  Do you consider yourself to be a fan of the Star Wars film franchise?  \\\n",
       "0                                               True                      \n",
       "1                                                NaN                      \n",
       "2                                              False                      \n",
       "3                                               True                      \n",
       "4                                               True                      \n",
       "\n",
       "   seen_1  seen_2  seen_3  seen_4  seen_5  seen_6  \\\n",
       "0    True    True    True    True    True    True   \n",
       "1   False   False   False   False   False   False   \n",
       "2    True    True    True   False   False   False   \n",
       "3    True    True    True    True    True    True   \n",
       "4    True    True    True    True    True    True   \n",
       "\n",
       "   Please rank the Star Wars films in order of preference with 1 being your favorite film in the franchise and 6 being your least favorite film.  \\\n",
       "0                                                3.0                                                                                               \n",
       "1                                                NaN                                                                                               \n",
       "2                                                1.0                                                                                               \n",
       "3                                                5.0                                                                                               \n",
       "4                                                5.0                                                                                               \n",
       "\n",
       "   ...         Unnamed: 28       Which character shot first?  \\\n",
       "0  ...      Very favorably  I don't understand this question   \n",
       "1  ...                 NaN                               NaN   \n",
       "2  ...    Unfamiliar (N/A)  I don't understand this question   \n",
       "3  ...      Very favorably  I don't understand this question   \n",
       "4  ...  Somewhat favorably                            Greedo   \n",
       "\n",
       "   Are you familiar with the Expanded Universe?  \\\n",
       "0                                           Yes   \n",
       "1                                           NaN   \n",
       "2                                            No   \n",
       "3                                            No   \n",
       "4                                           Yes   \n",
       "\n",
       "   Do you consider yourself to be a fan of the Expanded Universe?  \\\n",
       "0                                                 No                \n",
       "1                                                NaN                \n",
       "2                                                NaN                \n",
       "3                                                NaN                \n",
       "4                                                 No                \n",
       "\n",
       "   Do you consider yourself to be a fan of the Star Trek franchise? Gender  \\\n",
       "0                                                 No                  Male   \n",
       "1                                                Yes                  Male   \n",
       "2                                                 No                  Male   \n",
       "3                                                Yes                  Male   \n",
       "4                                                 No                  Male   \n",
       "\n",
       "     Age     Household Income                         Education  \\\n",
       "0  18-29                  NaN                High school degree   \n",
       "1  18-29         $0 - $24,999                   Bachelor degree   \n",
       "2  18-29         $0 - $24,999                High school degree   \n",
       "3  18-29  $100,000 - $149,999  Some college or Associate degree   \n",
       "4  18-29  $100,000 - $149,999  Some college or Associate degree   \n",
       "\n",
       "  Location (Census Region)  \n",
       "0           South Atlantic  \n",
       "1       West South Central  \n",
       "2       West North Central  \n",
       "3       West North Central  \n",
       "4       West North Central  \n",
       "\n",
       "[5 rows x 38 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "star_wars = star_wars.rename(columns={\n",
    "        \"Which of the following Star Wars films have you seen? Please select all that apply.\": \"seen_1\",\n",
    "        \"Unnamed: 4\": \"seen_2\",\n",
    "        \"Unnamed: 5\": \"seen_3\",\n",
    "        \"Unnamed: 6\": \"seen_4\",\n",
    "        \"Unnamed: 7\": \"seen_5\",\n",
    "        \"Unnamed: 8\": \"seen_6\"\n",
    "        })\n",
    "\n",
    "star_wars.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "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>RespondentID</th>\n",
       "      <th>Have you seen any of the 6 films in the Star Wars franchise?</th>\n",
       "      <th>Do you consider yourself to be a fan of the Star Wars film franchise?</th>\n",
       "      <th>seen_1</th>\n",
       "      <th>seen_2</th>\n",
       "      <th>seen_3</th>\n",
       "      <th>seen_4</th>\n",
       "      <th>seen_5</th>\n",
       "      <th>seen_6</th>\n",
       "      <th>ranking_1</th>\n",
       "      <th>...</th>\n",
       "      <th>Unnamed: 28</th>\n",
       "      <th>Which character shot first?</th>\n",
       "      <th>Are you familiar with the Expanded Universe?</th>\n",
       "      <th>Do you consider yourself to be a fan of the Expanded Universe?</th>\n",
       "      <th>Do you consider yourself to be a fan of the Star Trek franchise?</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Age</th>\n",
       "      <th>Household Income</th>\n",
       "      <th>Education</th>\n",
       "      <th>Location (Census Region)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3292879998</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Very favorably</td>\n",
       "      <td>I don't understand this question</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>18-29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>High school degree</td>\n",
       "      <td>South Atlantic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3292879538</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Male</td>\n",
       "      <td>18-29</td>\n",
       "      <td>$0 - $24,999</td>\n",
       "      <td>Bachelor degree</td>\n",
       "      <td>West South Central</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3292765271</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Unfamiliar (N/A)</td>\n",
       "      <td>I don't understand this question</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>18-29</td>\n",
       "      <td>$0 - $24,999</td>\n",
       "      <td>High school degree</td>\n",
       "      <td>West North Central</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3292763116</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>5.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Very favorably</td>\n",
       "      <td>I don't understand this question</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Male</td>\n",
       "      <td>18-29</td>\n",
       "      <td>$100,000 - $149,999</td>\n",
       "      <td>Some college or Associate degree</td>\n",
       "      <td>West North Central</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3292731220</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>5.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Somewhat favorably</td>\n",
       "      <td>Greedo</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>18-29</td>\n",
       "      <td>$100,000 - $149,999</td>\n",
       "      <td>Some college or Associate degree</td>\n",
       "      <td>West North Central</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 38 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   RespondentID  Have you seen any of the 6 films in the Star Wars franchise?  \\\n",
       "0    3292879998                                               True              \n",
       "1    3292879538                                              False              \n",
       "2    3292765271                                               True              \n",
       "3    3292763116                                               True              \n",
       "4    3292731220                                               True              \n",
       "\n",
       "  Do you consider yourself to be a fan of the Star Wars film franchise?  \\\n",
       "0                                               True                      \n",
       "1                                                NaN                      \n",
       "2                                              False                      \n",
       "3                                               True                      \n",
       "4                                               True                      \n",
       "\n",
       "   seen_1  seen_2  seen_3  seen_4  seen_5  seen_6  ranking_1  ...  \\\n",
       "0    True    True    True    True    True    True        3.0  ...   \n",
       "1   False   False   False   False   False   False        NaN  ...   \n",
       "2    True    True    True   False   False   False        1.0  ...   \n",
       "3    True    True    True    True    True    True        5.0  ...   \n",
       "4    True    True    True    True    True    True        5.0  ...   \n",
       "\n",
       "          Unnamed: 28       Which character shot first?  \\\n",
       "0      Very favorably  I don't understand this question   \n",
       "1                 NaN                               NaN   \n",
       "2    Unfamiliar (N/A)  I don't understand this question   \n",
       "3      Very favorably  I don't understand this question   \n",
       "4  Somewhat favorably                            Greedo   \n",
       "\n",
       "   Are you familiar with the Expanded Universe?  \\\n",
       "0                                           Yes   \n",
       "1                                           NaN   \n",
       "2                                            No   \n",
       "3                                            No   \n",
       "4                                           Yes   \n",
       "\n",
       "   Do you consider yourself to be a fan of the Expanded Universe?  \\\n",
       "0                                                 No                \n",
       "1                                                NaN                \n",
       "2                                                NaN                \n",
       "3                                                NaN                \n",
       "4                                                 No                \n",
       "\n",
       "   Do you consider yourself to be a fan of the Star Trek franchise? Gender  \\\n",
       "0                                                 No                  Male   \n",
       "1                                                Yes                  Male   \n",
       "2                                                 No                  Male   \n",
       "3                                                Yes                  Male   \n",
       "4                                                 No                  Male   \n",
       "\n",
       "     Age     Household Income                         Education  \\\n",
       "0  18-29                  NaN                High school degree   \n",
       "1  18-29         $0 - $24,999                   Bachelor degree   \n",
       "2  18-29         $0 - $24,999                High school degree   \n",
       "3  18-29  $100,000 - $149,999  Some college or Associate degree   \n",
       "4  18-29  $100,000 - $149,999  Some college or Associate degree   \n",
       "\n",
       "  Location (Census Region)  \n",
       "0           South Atlantic  \n",
       "1       West South Central  \n",
       "2       West North Central  \n",
       "3       West North Central  \n",
       "4       West North Central  \n",
       "\n",
       "[5 rows x 38 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "star_wars = star_wars.rename(columns={\n",
    "        \"Please rank the Star Wars films in order of preference with 1 being your favorite film in the franchise and 6 being your least favorite film.\": \"ranking_1\",\n",
    "        \"Unnamed: 10\": \"ranking_2\",\n",
    "        \"Unnamed: 11\": \"ranking_3\",\n",
    "        \"Unnamed: 12\": \"ranking_4\",\n",
    "        \"Unnamed: 13\": \"ranking_5\",\n",
    "        \"Unnamed: 14\": \"ranking_6\"\n",
    "        })\n",
    "\n",
    "star_wars.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "\n",
    "The next six columns ask the respondent to rank the *Star Wars* movies in order from least to most favorite. `1` means the film was the most favorite, and `6` means it was the least favorite.\n",
    "\n",
    "For reference, each of the following columns can contain the value `1`, `2`, `3`, `4`, `5`, `6`, or `NaN`:\n",
    "\n",
    "- `Please rank the Star Wars films in order of preference with 1 being your favorite film in the franchise and 6 being your least favorite film.` - How much the respondent liked *Star Wars: Episode I The Phantom Menace*\n",
    "- `Unnamed: 10` — How much the respondent liked *Star Wars: Episode II Attack of the Clones*\n",
    "- `Unnamed: 11` — How much the respondent liked *Star Wars: Episode III Revenge of the Sith*\n",
    "- `Unnamed: 12` — How much the respondent liked *Star Wars: Episode IV A New Hope*\n",
    "- `Unnamed: 13` — How much the respondent liked *Star Wars: Episode V The Empire Strikes Back*\n",
    "- `Unnamed: 14` — How much the respondent liked *Star Wars: Episode VI Return of the Jedi*\n",
    "\n",
    "Fortunately, these columns don't require much cleaning. I only need to convert each column to a numeric type, then rename the columns so that I can tell what they represent more easily."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "star_wars[star_wars.columns[9:15]] = star_wars[star_wars.columns[9:15]].astype(float)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Finding the Highest-Ranked Movie"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Now that I've cleaned up the ranking columns, I can find the highest-ranked movie more easily. To do this, I'll take the mean of each ranking columns using the `pandas.DataFrame.mean()` method on DataFrames. Then, I'll create a bar chart visual of the results."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ranking_1    3.732934\n",
       "ranking_2    4.087321\n",
       "ranking_3    4.341317\n",
       "ranking_4    3.272727\n",
       "ranking_5    2.513158\n",
       "ranking_6    3.047847\n",
       "dtype: float64"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "star_wars[star_wars.columns[9:15]].mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<BarContainer object of 6 artists>"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAfcAAAFZCAYAAACFY2a5AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAAPYQAAD2EBqD+naQAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAARMklEQVR4nO3df2hV993A8U8a8VpqklZXu4bEtqObpUocta1I98O2tiOIa/8bRdDJGGzEochgzR+t7R8jgcFYh5LJ1s1/JnYb2ELLKtKhYTC3GAlox8o6KstQm/2AJOZhdyW5zx/PnjzL02o8MTf3+vH1ggM9p+d6Pnwpfffce3tPQ6VSqQQAkMZNtR4AAJhf4g4AyYg7ACQj7gCQjLgDQDLiDgDJiDsAJLNooS84NTUV58+fj6ampmhoaFjoywPAdatSqcT4+Hi0trbGTTdd/v58weN+/vz5aG9vX+jLAkAaw8PD0dbWdtm/v+Bxb2pqioj/Gay5uXmhLw8A162xsbFob2+fbunlLHjc//et+ObmZnEHgDmY7WNtX6gDgGTEHQCSEXcASEbcASAZcQeAZMQdAJIRdwBIRtwBIBlxB4BkxB0AkhF3AEhG3AEgmQV/cAzUs7uffaPWIyyIc72baz0CUEXu3AEgGXEHgGTEHQCSEXcASEbcASAZcQeAZMQdAJIRdwBIRtwBIBlxB4BkxB0AkhF3AEhG3AEgGXEHgGTEHQCS8Tz3G4hnlQPcGNy5A0Ay1xT33t7eaGhoiN27d8/XPADANZpz3AcGBuLAgQPR0dExn/MAANdoTnG/dOlSbN26NX74wx/GbbfdNt8zAQDXYE5x7+rqis2bN8emTZtmPbdcLsfY2NiMDQConsLflj98+HCcPn06BgYGrur8np6eePHFFwsPBgDMTaE79+Hh4di1a1f89Kc/jSVLllzVa7q7u2N0dHR6Gx4entOgAMDVKXTnPjg4GCMjI/HAAw9MH5ucnIz+/v7Yt29flMvlaGxsnPGaUqkUpVJpfqYFAGZVKO6PP/54nDlzZsaxHTt2xH333Rff+ta3PhR2AGDhFYp7U1NTrFmzZsaxW265JZYvX/6h4wBAbfiFOgBI5pp/W/748ePzMAYAMF/cuQNAMuIOAMmIOwAkI+4AkIy4A0Ay4g4AyYg7ACQj7gCQjLgDQDLiDgDJiDsAJHPNvy1fL+5+9o1aj7AgzvVurvUIANQ5d+4AkIy4A0Ay4g4AyYg7ACQj7gCQjLgDQDLiDgDJiDsAJCPuAJCMuANAMuIOAMmIOwAkI+4AkIy4A0Ay4g4AyYg7ACQj7gCQjLgDQDLiDgDJiDsAJCPuAJCMuANAMuIOAMmIOwAkI+4AkIy4A0Ay4g4AyYg7ACQj7gCQzKJaDwBcP+5+9o1aj7BgzvVurvUIMGfu3AEgGXEHgGTEHQCSEXcASEbcASAZcQeAZMQdAJIRdwBIRtwBIBlxB4BkxB0AkhF3AEhG3AEgGXEHgGQKPfK1r68v+vr64ty5cxERsXr16nj++eejs7OzGrMBkNCN8ujgWj42uNCde1tbW/T29sbg4GCcOnUqHnvssXjqqafi7bffrtZ8AEBBhe7ct2zZMmP/29/+dvT19cXJkydj9erV8zoYADA3heL+nyYnJ+PnP/95TExMxIYNGy57XrlcjnK5PL0/NjY210sCAFeh8Bfqzpw5E0uXLo1SqRRf+9rX4siRI3H//fdf9vyenp5oaWmZ3trb269pYADgygrHfdWqVTE0NBS//e1v4+tf/3ps3749fv/731/2/O7u7hgdHZ3ehoeHr2lgAODKCr8tv3jx4rj33nsjImLdunUxMDAQL730Uhw4cOAjzy+VSlEqla5tSgDgql3z/+c+NTU14zN1AKC2Ct25d3d3R2dnZ6xcuTLGx8fj0KFDcfz48Th69Gi15gMACioU95GRkdi2bVtcuHAhWlpaoqOjI44ePRpPPPFEteYDAAoqFPeXX365WnMAAPPEb8sDQDLiDgDJiDsAJCPuAJCMuANAMuIOAMmIOwAkI+4AkIy4A0Ay4g4AyYg7ACQj7gCQjLgDQDLiDgDJiDsAJCPuAJCMuANAMuIOAMmIOwAkI+4AkIy4A0Ay4g4AyYg7ACQj7gCQjLgDQDKLaj0AQCZ3P/tGrUdYMOd6N9d6BC7DnTsAJCPuAJCMuANAMuIOAMmIOwAkI+4AkIy4A0Ay4g4AyYg7ACQj7gCQjLgDQDLiDgDJiDsAJCPuAJCMuANAMuIOAMmIOwAkI+4AkIy4A0Ay4g4AyYg7ACQj7gCQjLgDQDLiDgDJiDsAJCPuAJCMuANAMuIOAMmIOwAkUyjuPT098dBDD0VTU1OsWLEinn766XjnnXeqNRsAMAeF4n7ixIno6uqKkydPxrFjx+KDDz6IJ598MiYmJqo1HwBQ0KIiJ7/55psz9g8ePBgrVqyIwcHB+NznPjevgwEAc1Mo7v/f6OhoREQsW7bssueUy+Uol8vT+2NjY9dySQBgFnP+Qt3U1FTs3r07HnnkkVizZs1lz+vp6YmWlpbprb29fa6XBACuwpzj3tXVFWfPno3Dhw9f8bzu7u4YHR2d3oaHh+d6SQDgKszpbfmdO3fG66+/Hv39/dHW1nbFc0ulUpRKpTkNBwAUVyjulUolvvGNb8SRI0fi+PHjcc8991RrLgBgjgrFvaurKw4dOhSvvfZaNDU1xcWLFyMioqWlJW6++eaqDAgAFFPoM/e+vr4YHR2NjRs3xp133jm9vfLKK9WaDwAoqPDb8gBAffPb8gCQjLgDQDLiDgDJiDsAJCPuAJCMuANAMuIOAMmIOwAkI+4AkIy4A0Ay4g4AyYg7ACQj7gCQjLgDQDLiDgDJiDsAJCPuAJCMuANAMuIOAMmIOwAkI+4AkIy4A0Ay4g4AyYg7ACQj7gCQjLgDQDLiDgDJiDsAJCPuAJCMuANAMuIOAMmIOwAkI+4AkIy4A0Ay4g4AyYg7ACQj7gCQjLgDQDLiDgDJiDsAJCPuAJCMuANAMuIOAMmIOwAkI+4AkIy4A0Ay4g4AyYg7ACQj7gCQjLgDQDLiDgDJiDsAJCPuAJCMuANAMuIOAMkUjnt/f39s2bIlWltbo6GhIV599dVqzAUAzFHhuE9MTMTatWtj//791ZgHALhGi4q+oLOzMzo7O6sxCwAwDwrHvahyuRzlcnl6f2xsrNqXBIAbWtW/UNfT0xMtLS3TW3t7e7UvCQA3tKrHvbu7O0ZHR6e34eHhal8SAG5oVX9bvlQqRalUqvZlAIB/8/+5A0Ayhe/cL126FO++++70/nvvvRdDQ0OxbNmyWLly5bwOBwAUVzjup06dikcffXR6f8+ePRERsX379jh48OC8DQYAzE3huG/cuDEqlUo1ZgEA5oHP3AEgGXEHgGTEHQCSEXcASEbcASAZcQeAZMQdAJIRdwBIRtwBIBlxB4BkxB0AkhF3AEhG3AEgGXEHgGTEHQCSEXcASEbcASAZcQeAZMQdAJIRdwBIRtwBIBlxB4BkxB0AkhF3AEhG3AEgGXEHgGTEHQCSEXcASEbcASAZcQeAZMQdAJIRdwBIRtwBIBlxB4BkxB0AkhF3AEhG3AEgGXEHgGTEHQCSEXcASEbcASAZcQeAZMQdAJIRdwBIRtwBIBlxB4BkxB0AkhF3AEhG3AEgGXEHgGTEHQCSEXcASEbcASAZcQeAZMQdAJIRdwBIZk5x379/f9x9992xZMmSWL9+ffzud7+b77kAgDkqHPdXXnkl9uzZE3v37o3Tp0/H2rVr4wtf+EKMjIxUYz4AoKBFRV/w3e9+N7761a/Gjh07IiLiBz/4Qbzxxhvx4x//OJ599tkPnV8ul6NcLk/vj46ORkTE2NjYXGf+SFPl/5rXP69eXcu6WaPZWaMru1HWJ8IaXQ1rdGXz3bn//DMrlcqVT6wUUC6XK42NjZUjR47MOL5t27bKF7/4xY98zd69eysRYbPZbDabbZ624eHhK/a60J373/72t5icnIw77rhjxvE77rgj/vCHP3zka7q7u2PPnj3T+1NTU/GPf/wjli9fHg0NDUUuX1fGxsaivb09hoeHo7m5udbj1CVrNDtrNDtrdGXWZ3aZ1qhSqcT4+Hi0trZe8bzCb8sXVSqVolQqzTh26623VvuyC6a5ufm6/4el2qzR7KzR7KzRlVmf2WVZo5aWllnPKfSFuo997GPR2NgY77///ozj77//fnz84x8vNh0AUBWF4r548eJYt25dvPXWW9PHpqam4q233ooNGzbM+3AAQHGNL7zwwgtFXtDc3BzPPfdctLe3R6lUiueeey6Ghobi5ZdfjqVLl1ZpzPrU2NgYGzdujEWLqv7pxnXLGs3OGs3OGl2Z9ZndjbZGDZVZv0//Yfv27YvvfOc7cfHixfj0pz8d3//+92P9+vXVmA8AKGhOcQcA6pfflgeAZMQdAJIRdwBIRtwBIBlxnwOPvL2y/v7+2LJlS7S2tkZDQ0O8+uqrtR6prvT09MRDDz0UTU1NsWLFinj66afjnXfeqfVYdaWvry86Ojqmf1Fsw4YN8ctf/rLWY9W13t7eaGhoiN27d9d6lLrxwgsvRENDw4ztvvvuq/VYC0LcC/LI29lNTEzE2rVrY//+/bUepS6dOHEiurq64uTJk3Hs2LH44IMP4sknn4yJiYlaj1Y32traore3NwYHB+PUqVPx2GOPxVNPPRVvv/12rUerSwMDA3HgwIHo6Oio9Sh1Z/Xq1XHhwoXp7de//nWtR1oYRZ4KR6Xy8MMPV7q6uqb3JycnK62trZWenp4aTlW/IuJDTxFkppGRkUpEVE6cOFHrUerabbfdVvnRj35U6zHqzvj4eOWTn/xk5dixY5XPf/7zlV27dtV6pLqxd+/eytq1a2s9Rk24cy/gX//6VwwODsamTZumj910002xadOm+M1vflPDybiejY6ORkTEsmXLajxJfZqcnIzDhw/HxMSEn7n+CF1dXbF58+YZ/17i//zxj3+M1tbW+MQnPhFbt26NP//5z7UeaUHcGL/DN0/m8shbuJKpqanYvXt3PPLII7FmzZpaj1NXzpw5Exs2bIh//vOfsXTp0jhy5Ejcf//9tR6rrhw+fDhOnz4dAwMDtR6lLq1fvz4OHjwYq1atigsXLsSLL74Yn/3sZ+Ps2bPR1NRU6/GqStyhhrq6uuLs2bM3zueABaxatSqGhoZidHQ0fvGLX8T27dvjxIkTAv9vw8PDsWvXrjh27FgsWbKk1uPUpc7Ozum/7ujoiPXr18ddd90VP/vZz+IrX/lKDSerPnEvwCNvmU87d+6M119/Pfr7+6Otra3W49SdxYsXx7333hsREevWrYuBgYF46aWX4sCBAzWerD4MDg7GyMhIPPDAA9PHJicno7+/P/bt2xflcjkaGxtrOGH9ufXWW+NTn/pUvPvuu7Uepep85l6AR94yHyqVSuzcuTOOHDkSv/rVr+Kee+6p9UjXhampqSiXy7Ueo248/vjjcebMmRgaGpreHnzwwdi6dWsMDQ0J+0e4dOlS/OlPf4o777yz1qNUnTv3gvbs2RPbt2+PBx98MB5++OH43ve+FxMTE7Fjx45aj1Y3Ll26NOO/jN97770YGhqKZcuWxcqVK2s4WX3o6uqKQ4cOxWuvvRZNTU1x8eLFiIhoaWmJm2++ucbT1Yfu7u7o7OyMlStXxvj4eBw6dCiOHz8eR48erfVodaOpqelD39O45ZZbYvny5b6/8W/f/OY3Y8uWLXHXXXfF+fPnY+/evdHY2BjPPPNMrUerOnEv6Etf+lL89a9/jeeff376kbdvvvnmh75kdyM7depUPProo9P7e/bsiYiI7du3x8GDB2s0Vf3o6+uLiIiNGzfOOP6Tn/wkvvzlLy/8QHVoZGQktm3bFhcuXIiWlpbo6OiIo0ePxhNPPFHr0biO/OUvf4lnnnkm/v73v8ftt98en/nMZ+LkyZNx++2313q0qvPIVwBIxmfuAJCMuANAMuIOAMmIOwAkI+4AkIy4A0Ay4g4AyYg7ACQj7gCQjLgDQDLiDgDJ/DcCVMQx7HHuWAAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 600x400 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "%matplotlib inline\n",
    "import matplotlib.pyplot as plt\n",
    "\n",
    "plt.bar(range(6), star_wars[star_wars.columns[9:15]].mean())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "\n",
    "As I suspected, it looks like the \"original\" movies are rated much higher than the newer ones, with *Star Wars: Episode III Revenge of the Sith* being the crowd favorite."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Finding the Most Viewed Movie"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Now, let's figure out how many people have seen each movie."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "seen_1    673\n",
       "seen_2    571\n",
       "seen_3    550\n",
       "seen_4    607\n",
       "seen_5    758\n",
       "seen_6    738\n",
       "dtype: int64"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "star_wars[star_wars.columns[3:9]].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<BarContainer object of 6 artists>"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAgkAAAFZCAYAAAASBLySAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAAPYQAAD2EBqD+naQAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3dfWyV9f3/8Vdv6Ck3Pae2o+fQ0FacN1AF0aLlTN0QK7VWpqFxajqsSiQjp0xoRG2CwIqzjBlRtODNWIvRhokZOCsCpc4SR4tQQ1LBMXRsrYPTbrL2QL/htLTn98d+XNuRD+JpDz1Fn4/kSjjX9TnnvK8ry3zm3PREBQKBgAAAAL4iOtIDAACAoYlIAAAARkQCAAAwIhIAAIARkQAAAIyIBAAAYEQkAAAAo9hID9AffX19OnLkiBISEhQVFRXpcQAAuGAEAgEdP35cqampio7++tcKLshIOHLkiNLS0iI9BgAAF6zW1laNHTv2a9dckJGQkJAg6T8naLfbIzwNAAAXDp/Pp7S0NOu/pV/ngoyE028x2O12IgEAgH74Jm/X88FFAABgRCQAAAAjIgEAABgRCQAAwIhIAAAARkQCAAAwIhIAAIARkQAAAIyIBAAAYEQkAAAAIyIBAAAYEQkAAMDogvyBJwD4trv4iXcjPcKg+NuK/EiPgK/BKwkAAMCISAAAAEZEAgAAMCISAACAEZEAAACMiAQAAGDEVyABABckviZ6/vFKAgAAMCISAACAEZEAAACMiAQAAGBEJAAAACMiAQAAGBEJAADAiEgAAABGRAIAADAiEgAAgFFIkXDxxRcrKirqjM3j8UiSTp48KY/Ho+TkZI0aNUoFBQVqa2sLeoyWlhbl5+drxIgRSklJ0aJFi3Tq1KnwnREAAAiLkCJhz549Onr0qLXV1tZKku6++25J0sKFC/XOO+9o48aNqq+v15EjRzRr1izr/r29vcrPz1d3d7d27dql9evXq6qqSkuWLAnjKQEAgHAIKRJGjx4tl8tlbTU1Nfr+97+vH/3oR+rs7NS6dev07LPPavr06crKylJlZaV27dqlxsZGSdL27dt14MABvf7665o8ebLy8vK0fPlyVVRUqLu7+7ycIAAA6J9+fyahu7tbr7/+uh566CFFRUWpqalJPT09ysnJsdaMHz9e6enpamhokCQ1NDRo4sSJcjqd1prc3Fz5fD7t37//rM/l9/vl8/mCNgAAcH71OxI2b96sjo4OPfDAA5Ikr9eruLg4JSYmBq1zOp3yer3Wmv8NhNPHTx87m/LycjkcDmtLS0vr79gAAOAb6nckrFu3Tnl5eUpNTQ3nPEalpaXq7Oy0ttbW1vP+nAAAfNfF9udOf//737Vjxw79/ve/t/a5XC51d3ero6Mj6NWEtrY2uVwua81HH30U9Finv/1weo2JzWaTzWbrz6gAAKCf+vVKQmVlpVJSUpSfn2/ty8rK0rBhw1RXV2ftO3jwoFpaWuR2uyVJbrdbzc3Nam9vt9bU1tbKbrcrMzOzv+cAAADOg5BfSejr61NlZaWKiooUG/vfuzscDs2ZM0clJSVKSkqS3W7X/Pnz5Xa7NXXqVEnSjBkzlJmZqdmzZ2vlypXyer1avHixPB4PrxQAADDEhBwJO3bsUEtLix566KEzjq1atUrR0dEqKCiQ3+9Xbm6u1qxZYx2PiYlRTU2N5s2bJ7fbrZEjR6qoqEhlZWUDOwsAABB2IUfCjBkzFAgEjMfi4+NVUVGhioqKs94/IyNDW7ZsCfVpAQDAIOO3GwAAgBGRAAAAjIgEAABg1K+/k/BtdfET70Z6hEHztxX5514EAPhO45UEAABgRCQAAAAjIgEAABgRCQAAwIhIAAAARkQCAAAwIhIAAIARkQAAAIyIBAAAYEQkAAAAIyIBAAAYEQkAAMCISAAAAEZEAgAAMCISAACAEZEAAACMiAQAAGBEJAAAACMiAQAAGBEJAADAiEgAAABGRAIAADAiEgAAgFHIkfCPf/xDP/3pT5WcnKzhw4dr4sSJ2rt3r3U8EAhoyZIlGjNmjIYPH66cnBwdOnQo6DGOHTumwsJC2e12JSYmas6cOTpx4sTAzwYAAIRNbCiL//3vf+uGG27QzTffrPfee0+jR4/WoUOHdNFFF1lrVq5cqdWrV2v9+vUaN26cnnzySeXm5urAgQOKj4+XJBUWFuro0aOqra1VT0+PHnzwQc2dO1fV1dXhPTsAQ9LFT7wb6REGxd9W5Ed6BGBAQoqEX/3qV0pLS1NlZaW1b9y4cda/A4GAnnvuOS1evFh33nmnJOm1116T0+nU5s2bde+99+rTTz/V1q1btWfPHk2ZMkWS9MILL+j222/XM888o9TU1HCcFwAAGKCQ3m74wx/+oClTpujuu+9WSkqKrrnmGr366qvW8cOHD8vr9SonJ8fa53A4lJ2drYaGBklSQ0ODEhMTrUCQpJycHEVHR2v37t3G5/X7/fL5fEEbAAA4v0KKhL/+9a9au3atLrvsMm3btk3z5s3Tz3/+c61fv16S5PV6JUlOpzPofk6n0zrm9XqVkpISdDw2NlZJSUnWmq8qLy+Xw+GwtrS0tFDGBgAA/RBSJPT19enaa6/V008/rWuuuUZz587Vww8/rJdeeul8zSdJKi0tVWdnp7W1trae1+cDAAAhRsKYMWOUmZkZtG/ChAlqaWmRJLlcLklSW1tb0Jq2tjbrmMvlUnt7e9DxU6dO6dixY9aar7LZbLLb7UEbAAA4v0KKhBtuuEEHDx4M2veXv/xFGRkZkv7zIUaXy6W6ujrruM/n0+7du+V2uyVJbrdbHR0dampqsta8//776uvrU3Z2dr9PBAAAhFdI325YuHChfvCDH+jpp5/WT37yE3300Ud65ZVX9Morr0iSoqKitGDBAj311FO67LLLrK9Apqam6q677pL0n1cebrvtNuttip6eHhUXF+vee+/lmw0AAAwhIUXCddddp02bNqm0tFRlZWUaN26cnnvuORUWFlprHnvsMXV1dWnu3Lnq6OjQjTfeqK1bt1p/I0GS3njjDRUXF+uWW25RdHS0CgoKtHr16vCdFQAAGLCQIkGS7rjjDt1xxx1nPR4VFaWysjKVlZWddU1SUhJ/OAkAgCGO324AAABGRAIAADAiEgAAgBGRAAAAjEL+4CK+2/j1PgD47uCVBAAAYEQkAAAAIyIBAAAYEQkAAMCISAAAAEZEAgAAMCISAACAEX8nAQgz/pYEgG8LXkkAAABGRAIAADAiEgAAgBGRAAAAjIgEAABgRCQAAAAjIgEAABgRCQAAwIhIAAAARkQCAAAwIhIAAIARkQAAAIyIBAAAYEQkAAAAo5AiYdmyZYqKigraxo8fbx0/efKkPB6PkpOTNWrUKBUUFKitrS3oMVpaWpSfn68RI0YoJSVFixYt0qlTp8JzNgAAIGxiQ73DlVdeqR07dvz3AWL/+xALFy7Uu+++q40bN8rhcKi4uFizZs3Sn/70J0lSb2+v8vPz5XK5tGvXLh09elT333+/hg0bpqeffjoMpwMAAMIl5EiIjY2Vy+U6Y39nZ6fWrVun6upqTZ8+XZJUWVmpCRMmqLGxUVOnTtX27dt14MAB7dixQ06nU5MnT9by5cv1+OOPa9myZYqLixv4GQEAgLAI+TMJhw4dUmpqqi655BIVFhaqpaVFktTU1KSenh7l5ORYa8ePH6/09HQ1NDRIkhoaGjRx4kQ5nU5rTW5urnw+n/bv33/W5/T7/fL5fEEbAAA4v0KKhOzsbFVVVWnr1q1au3atDh8+rJtuuknHjx+X1+tVXFycEhMTg+7jdDrl9XolSV6vNygQTh8/fexsysvL5XA4rC0tLS2UsQEAQD+E9HZDXl6e9e9JkyYpOztbGRkZevPNNzV8+PCwD3daaWmpSkpKrNs+n49QAADgPBvQVyATExN1+eWX67PPPpPL5VJ3d7c6OjqC1rS1tVmfYXC5XGd82+H0bdPnHE6z2Wyy2+1BGwAAOL8GFAknTpzQ559/rjFjxigrK0vDhg1TXV2ddfzgwYNqaWmR2+2WJLndbjU3N6u9vd1aU1tbK7vdrszMzIGMAgAAwiyktxseffRRzZw5UxkZGTpy5IiWLl2qmJgY3XfffXI4HJozZ45KSkqUlJQku92u+fPny+12a+rUqZKkGTNmKDMzU7Nnz9bKlSvl9Xq1ePFieTwe2Wy283KCAACgf0KKhC+++EL33XefvvzyS40ePVo33nijGhsbNXr0aEnSqlWrFB0drYKCAvn9fuXm5mrNmjXW/WNiYlRTU6N58+bJ7XZr5MiRKioqUllZWXjPCgAADFhIkbBhw4avPR4fH6+KigpVVFScdU1GRoa2bNkSytMCAIAI4LcbAACAEZEAAACMiAQAAGBEJAAAACMiAQAAGBEJAADAiEgAAABGRAIAADAiEgAAgBGRAAAAjIgEAABgRCQAAAAjIgEAABgRCQAAwIhIAAAARkQCAAAwIhIAAIARkQAAAIyIBAAAYEQkAAAAIyIBAAAYEQkAAMCISAAAAEZEAgAAMCISAACAEZEAAACMiAQAAGA0oEhYsWKFoqKitGDBAmvfyZMn5fF4lJycrFGjRqmgoEBtbW1B92tpaVF+fr5GjBihlJQULVq0SKdOnRrIKAAAIMz6HQl79uzRyy+/rEmTJgXtX7hwod555x1t3LhR9fX1OnLkiGbNmmUd7+3tVX5+vrq7u7Vr1y6tX79eVVVVWrJkSf/PAgAAhF2/IuHEiRMqLCzUq6++qosuusja39nZqXXr1unZZ5/V9OnTlZWVpcrKSu3atUuNjY2SpO3bt+vAgQN6/fXXNXnyZOXl5Wn58uWqqKhQd3e38fn8fr98Pl/QBgAAzq9+RYLH41F+fr5ycnKC9jc1Namnpydo//jx45Wenq6GhgZJUkNDgyZOnCin02mtyc3Nlc/n0/79+43PV15eLofDYW1paWn9GRsAAIQg5EjYsGGDPv74Y5WXl59xzOv1Ki4uTomJiUH7nU6nvF6vteZ/A+H08dPHTEpLS9XZ2Wltra2toY4NAABCFBvK4tbWVj3yyCOqra1VfHz8+ZrpDDabTTabbdCeDwAAhPhKQlNTk9rb23XttdcqNjZWsbGxqq+v1+rVqxUbGyun06nu7m51dHQE3a+trU0ul0uS5HK5zvi2w+nbp9cAAIDICykSbrnlFjU3N2vfvn3WNmXKFBUWFlr/HjZsmOrq6qz7HDx4UC0tLXK73ZIkt9ut5uZmtbe3W2tqa2tlt9uVmZkZptMCAAADFdLbDQkJCbrqqquC9o0cOVLJycnW/jlz5qikpERJSUmy2+2aP3++3G63pk6dKkmaMWOGMjMzNXv2bK1cuVJer1eLFy+Wx+PhLQUAAIaQkCLhm1i1apWio6NVUFAgv9+v3NxcrVmzxjoeExOjmpoazZs3T263WyNHjlRRUZHKysrCPQoAABiAAUfCBx98EHQ7Pj5eFRUVqqioOOt9MjIytGXLloE+NQAAOI/47QYAAGBEJAAAACMiAQAAGBEJAADAiEgAAABGRAIAADAiEgAAgBGRAAAAjIgEAABgRCQAAAAjIgEAABgRCQAAwIhIAAAARkQCAAAwIhIAAIARkQAAAIyIBAAAYEQkAAAAIyIBAAAYEQkAAMCISAAAAEZEAgAAMCISAACAEZEAAACMiAQAAGBEJAAAACMiAQAAGIUUCWvXrtWkSZNkt9tlt9vldrv13nvvWcdPnjwpj8ej5ORkjRo1SgUFBWprawt6jJaWFuXn52vEiBFKSUnRokWLdOrUqfCcDQAACJuQImHs2LFasWKFmpqatHfvXk2fPl133nmn9u/fL0lauHCh3nnnHW3cuFH19fU6cuSIZs2aZd2/t7dX+fn56u7u1q5du7R+/XpVVVVpyZIl4T0rAAAwYLGhLJ45c2bQ7V/+8pdau3atGhsbNXbsWK1bt07V1dWaPn26JKmyslITJkxQY2Ojpk6dqu3bt+vAgQPasWOHnE6nJk+erOXLl+vxxx/XsmXLFBcXZ3xev98vv99v3fb5fKGeJwAACFG/P5PQ29urDRs2qKurS263W01NTerp6VFOTo61Zvz48UpPT1dDQ4MkqaGhQRMnTpTT6bTW5ObmyufzWa9GmJSXl8vhcFhbWlpaf8cGAADfUMiR0NzcrFGjRslms+lnP/uZNm3apMzMTHm9XsXFxSkxMTFovdPplNfrlSR5vd6gQDh9/PSxsyktLVVnZ6e1tba2hjo2AAAIUUhvN0jSFVdcoX379qmzs1NvvfWWioqKVF9ffz5ms9hsNtlstvP6HAAAIFjIkRAXF6dLL71UkpSVlaU9e/bo+eef1z333KPu7m51dHQEvZrQ1tYml8slSXK5XProo4+CHu/0tx9OrwEAAEPDgP9OQl9fn/x+v7KysjRs2DDV1dVZxw4ePKiWlha53W5JktvtVnNzs9rb2601tbW1stvtyszMHOgoAAAgjEJ6JaG0tFR5eXlKT0/X8ePHVV1drQ8++EDbtm2Tw+HQnDlzVFJSoqSkJNntds2fP19ut1tTp06VJM2YMUOZmZmaPXu2Vq5cKa/Xq8WLF8vj8fB2AgAAQ0xIkdDe3q77779fR48elcPh0KRJk7Rt2zbdeuutkqRVq1YpOjpaBQUF8vv9ys3N1Zo1a6z7x8TEqKamRvPmzZPb7dbIkSNVVFSksrKy8J4VAAAYsJAiYd26dV97PD4+XhUVFaqoqDjrmoyMDG3ZsiWUpwUAABHAbzcAAAAjIgEAABgRCQAAwIhIAAAARkQCAAAwIhIAAIARkQAAAIyIBAAAYEQkAAAAIyIBAAAYEQkAAMCISAAAAEZEAgAAMCISAACAEZEAAACMiAQAAGBEJAAAACMiAQAAGBEJAADAiEgAAABGRAIAADAiEgAAgBGRAAAAjIgEAABgRCQAAAAjIgEAABgRCQAAwCikSCgvL9d1112nhIQEpaSk6K677tLBgweD1pw8eVIej0fJyckaNWqUCgoK1NbWFrSmpaVF+fn5GjFihFJSUrRo0SKdOnVq4GcDAADCJqRIqK+vl8fjUWNjo2pra9XT06MZM2aoq6vLWrNw4UK988472rhxo+rr63XkyBHNmjXLOt7b26v8/Hx1d3dr165dWr9+vaqqqrRkyZLwnRUAABiw2FAWb926Neh2VVWVUlJS1NTUpB/+8Ifq7OzUunXrVF1drenTp0uSKisrNWHCBDU2Nmrq1Knavn27Dhw4oB07dsjpdGry5Mlavny5Hn/8cS1btkxxcXFnPK/f75ff77du+3y+/pwrAAAIwYA+k9DZ2SlJSkpKkiQ1NTWpp6dHOTk51prx48crPT1dDQ0NkqSGhgZNnDhRTqfTWpObmyufz6f9+/cbn6e8vFwOh8Pa0tLSBjI2AAD4BvodCX19fVqwYIFuuOEGXXXVVZIkr9eruLg4JSYmBq11Op3yer3Wmv8NhNPHTx8zKS0tVWdnp7W1trb2d2wAAPANhfR2w//yeDz65JNP9OGHH4ZzHiObzSabzXbenwcAAPxXv15JKC4uVk1Njf74xz9q7Nix1n6Xy6Xu7m51dHQErW9ra5PL5bLWfPXbDqdvn14DAAAiL6RICAQCKi4u1qZNm/T+++9r3LhxQcezsrI0bNgw1dXVWfsOHjyolpYWud1uSZLb7VZzc7Pa29utNbW1tbLb7crMzBzIuQAAgDAK6e0Gj8ej6upqvf3220pISLA+Q+BwODR8+HA5HA7NmTNHJSUlSkpKkt1u1/z58+V2uzV16lRJ0owZM5SZmanZs2dr5cqV8nq9Wrx4sTweD28pAAAwhIQUCWvXrpUkTZs2LWh/ZWWlHnjgAUnSqlWrFB0drYKCAvn9fuXm5mrNmjXW2piYGNXU1GjevHlyu90aOXKkioqKVFZWNrAzAQAAYRVSJAQCgXOuiY+PV0VFhSoqKs66JiMjQ1u2bAnlqQEAwCDjtxsAAIARkQAAAIyIBAAAYEQkAAAAIyIBAAAYEQkAAMCISAAAAEZEAgAAMCISAACAEZEAAACMiAQAAGBEJAAAACMiAQAAGBEJAADAiEgAAABGRAIAADAiEgAAgBGRAAAAjIgEAABgRCQAAAAjIgEAABgRCQAAwIhIAAAARkQCAAAwIhIAAIARkQAAAIyIBAAAYBRyJOzcuVMzZ85UamqqoqKitHnz5qDjgUBAS5Ys0ZgxYzR8+HDl5OTo0KFDQWuOHTumwsJC2e12JSYmas6cOTpx4sTAzgQAAIRVyJHQ1dWlq6++WhUVFcbjK1eu1OrVq/XSSy9p9+7dGjlypHJzc3Xy5ElrTWFhofbv36/a2lrV1NRo586dmjt3bv/PAgAAhF1sqHfIy8tTXl6e8VggENBzzz2nxYsX684775Qkvfbaa3I6ndq8ebPuvfdeffrpp9q6dav27NmjKVOmSJJeeOEF3X777XrmmWeUmpp6xuP6/X75/X7rts/nC3VsAAAQorB+JuHw4cPyer3Kycmx9jkcDmVnZ6uhoUGS1NDQoMTERCsQJCknJ0fR0dHavXu38XHLy8vlcDisLS0tLZxjAwAAg7BGgtfrlSQ5nc6g/U6n0zrm9XqVkpISdDw2NlZJSUnWmq8qLS1VZ2entbW2toZzbAAAYBDy2w2RYLPZZLPZIj0GAADfKWF9JcHlckmS2tragva3tbVZx1wul9rb24OOnzp1SseOHbPWAACAyAtrJIwbN04ul0t1dXXWPp/Pp927d8vtdkuS3G63Ojo61NTUZK15//331dfXp+zs7HCOAwAABiDktxtOnDihzz77zLp9+PBh7du3T0lJSUpPT9eCBQv01FNP6bLLLtO4ceP05JNPKjU1VXfddZckacKECbrtttv08MMP66WXXlJPT4+Ki4t17733Gr/ZAAAAIiPkSNi7d69uvvlm63ZJSYkkqaioSFVVVXrsscfU1dWluXPnqqOjQzfeeKO2bt2q+Ph46z5vvPGGiouLdcsttyg6OloFBQVavXp1GE4HAACES8iRMG3aNAUCgbMej4qKUllZmcrKys66JikpSdXV1aE+NQAAGET8dgMAADAiEgAAgBGRAAAAjIgEAABgRCQAAAAjIgEAABgRCQAAwIhIAAAARkQCAAAwIhIAAIARkQAAAIyIBAAAYEQkAAAAIyIBAAAYEQkAAMCISAAAAEZEAgAAMCISAACAEZEAAACMiAQAAGBEJAAAACMiAQAAGBEJAADAiEgAAABGRAIAADAiEgAAgBGRAAAAjCIWCRUVFbr44osVHx+v7OxsffTRR5EaBQAAGEQkEn73u9+ppKRES5cu1ccff6yrr75aubm5am9vj8Q4AADAIDYST/rss8/q4Ycf1oMPPihJeumll/Tuu+/qt7/9rZ544okz1vv9fvn9fut2Z2enJMnn84V1rj7//4X18Yay/l6778o1Gsj/trhG58Y1Ojeu0blxjQb2eIFA4NyLA4PM7/cHYmJiAps2bQraf//99wd+/OMfG++zdOnSgCQ2NjY2Nja2MG2tra3n/G/2oL+S8K9//Uu9vb1yOp1B+51Op/785z8b71NaWqqSkhLrdl9fn44dO6bk5GRFRUWd13nPJ5/Pp7S0NLW2tsput0d6nCGJa3RuXKNz4xqdG9fo3L4t1ygQCOj48eNKTU0959qIvN0QKpvNJpvNFrQvMTExQtOEn91uv6D/BzcYuEbnxjU6N67RuXGNzu3bcI0cDsc3WjfoH1z83ve+p5iYGLW1tQXtb2trk8vlGuxxAADAWQx6JMTFxSkrK0t1dXXWvr6+PtXV1cntdg/2OAAA4Cxili1btmywn9Rut+vJJ59UWlqabDabnnzySe3bt0/r1q3TqFGjBnuciIqJidG0adMUG3tBvPMTEVyjc+ManRvX6Ny4Ruf2XbtGUYHAN/kORPi9+OKL+vWvfy2v16vJkydr9erVys7OjsQoAADAIGKRAAAAhjZ+uwEAABgRCQAAwIhIAAAARkQCAAAwIhIiiJ/LPrudO3dq5syZSk1NVVRUlDZv3hzpkYac8vJyXXfddUpISFBKSoruuusuHTx4MNJjDSlr167VpEmTrL+Q53a79d5770V6rCFrxYoVioqK0oIFCyI9ypCxbNkyRUVFBW3jx4+P9FiDhkiIEH4u++t1dXXp6quvVkVFRaRHGbLq6+vl8XjU2Nio2tpa9fT0aMaMGerq6or0aEPG2LFjtWLFCjU1NWnv3r2aPn267rzzTu3fvz/Sow05e/bs0csvv6xJkyZFepQh58orr9TRo0et7cMPP4z0SINnoL/qiP65/vrrAx6Px7rd29sbSE1NDZSXl0dwqqFJ0hm/Gooztbe3ByQF6uvrIz3KkHbRRRcFfvOb30R6jCHl+PHjgcsuuyxQW1sb+NGPfhR45JFHIj3SkLF06dLA1VdfHekxIoZXEiKgu7tbTU1NysnJsfZFR0crJydHDQ0NEZwMF7LOzk5JUlJSUoQnGZp6e3u1YcMGdXV18Sfgv8Lj8Sg/Pz/o/5PwX4cOHVJqaqouueQSFRYWqqWlJdIjDZrvxt+VHGL683PZwNfp6+vTggULdMMNN+iqq66K9DhDSnNzs9xut06ePKlRo0Zp06ZNyszMjPRYQ8aGDRv08ccfa8+ePZEeZUjKzs5WVVWVrrjiCh09elS/+MUvdNNNN+mTTz5RQkJCpMc774gE4FvA4/Hok08++W69V/oNXXHFFdq3b586Ozv11ltvqaioSPX19YSCpNbWVj3yyCOqra1VfHx8pMcZkvLy8qx/T5o0SdnZ2crIyNCbb76pOXPmRHCywUEkRAA/l41wKi4uVk1NjXbu3KmxY8dGepwhJy4uTpdeeqkkKSsrS3v27NHzzz+vl19+OcKTRV5TU5Pa29t17bXXWvt6e3u1c+dOvfjii/L7/YqJiYnghENPYmKiLr/8cn322WeRHmVQ8JmECODnshEOgUBAxcXF2rRpk95//32NGzcu0iNdEPr6+uT3+yM9xpBwyy23qLm5Wfv27bO2KVOmqLCwUPv27SMQDE6cOKHPP/9cY8aMifQog4JXEiKkpKRERUVFmjJliq6//no999xz6urq0oMPPhjp0YaEE8RQUg0AAAFSSURBVCdOBJX64cOHtW/fPiUlJSk9PT2Ckw0dHo9H1dXVevvtt5WQkCCv1ytJcjgcGj58eISnGxpKS0uVl5en9PR0HT9+XNXV1frggw+0bdu2SI82JCQkJJzxGZaRI0cqOTmZz7b8f48++qhmzpypjIwMHTlyREuXLlVMTIzuu+++SI82KIiECLnnnnv0z3/+U0uWLLF+Lnvr1q1nfJjxu2rv3r26+eabrdslJSWSpKKiIlVVVUVoqqFl7dq1kqRp06YF7a+srNQDDzww+AMNQe3t7br//vt19OhRORwOTZo0Sdu2bdOtt94a6dFwgfjiiy9033336csvv9To0aN14403qrGxUaNHj470aIOCn4oGAABGfCYBAAAYEQkAAMCISAAAAEZEAgAAMCISAACAEZEAAACMiAQAAGBEJAAAACMiAQAAGBEJAADAiEgAAABG/w/VhPTXgv3srwAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 600x400 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "plt.bar(range(6), star_wars[star_wars.columns[3:9]].sum())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "It appears that the original movies were seen by more respondents than the newer movies. This reinforces what we saw in the rankings, where the earlier movies seem to be more popular."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Exploring the Data by Binary Segments"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "I now know which movies the survey population as a whole has ranked the highest. Now I want to examine how certain segments of the survey population responded. There are several columns that segment the data into two groups. Here are a few examples:\n",
    "\n",
    "- `Do you consider yourself to be a fan of the Star Wars film franchise?` — `True` or `False`\n",
    "- `Do you consider yourself to be a fan of the Star Trek franchise?` — `Yes` or `No`\n",
    "- `Gender` — `Male` or `Female`\n",
    "\n",
    "I can split a DataFrame into two groups based on a binary column by creating two subsets of that column. The subsets allow me to compute the most viewed movie, the highest-ranked movie, and other statistics separately for each group."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "males = star_wars[star_wars[\"Gender\"] == \"Male\"]\n",
    "females = star_wars[star_wars[\"Gender\"] == \"Female\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAgQAAAFZCAYAAADn+jciAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAAPYQAAD2EBqD+naQAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAdNElEQVR4nO3df0xV9/3H8deV1outQLWV39cfCxZrFVSs9tKt0BaLlDj5xzTG5FKjJl1g0bHZlKXVtq65ZsZSFhzgqmVbR7DagklrZXc0SDpwBfQm4FIzu1aw5UK7tRfhu942cL9/bLvdjfzwXC5crM9HcpLdw+dw3vdm0WcPR47J6/V6BQAAbmozQj0AAAAIPYIAAAAQBAAAgCAAAAAiCAAAgAgCAAAgggAAAEi6JdQDXI/h4WF9+umnioiIkMlkCvU4AADcMLxer65evar4+HjNmDH6dYAbIgg+/fRTWSyWUI8BAMANq7u7W4mJiaN+/YYIgoiICEn/fjORkZEhngYAgBtHf3+/LBaL7+/S0dwQQfDfHxNERkYSBAAABGC8H7lzUyEAACAIAAAAQQAAAEQQAAAAEQQAAEAEAQAAEEEAAABEEAAAABEEAABABAEAABBBAAAARBAAAADdIA83AqazhU+/HeoRpsTH+3NDPQKAScQVAgAAQBAAAAB+ZIBxcDkcAG4OXCEAAAAEAQAAIAgAAIAIAgAAIIIAAACIIAAAACIIAACACAIAACCCAAAAiCAAAACaYBDs379fJpNJu3btGnPd8ePHtWTJEoWHh2v58uU6derURE4LAACCLOAgaG1tVWVlpVJSUsZc19zcrM2bN2vbtm06f/688vLylJeXp87OzkBPDQAAgiyghxsNDAxoy5Yt+s1vfqNf/OIXY64tLS3V+vXrtXv3bknSvn375HA4VFZWpoqKikBOHzQ8uAcAgH8L6ApBQUGBcnNzlZWVNe7alpaWa9ZlZ2erpaVl1GM8Ho/6+/v9NgAAMHkMXyGoqanRuXPn1Nrael3rXS6XYmJi/PbFxMTI5XKNeozdbtfzzz9vdDQAABAgQ1cIuru7tXPnTv3hD39QeHj4ZM2k4uJiud1u39bd3T1p5wIAAAavELS3t6uvr0+rVq3y7RsaGlJTU5PKysrk8XgUFhbmd0xsbKx6e3v99vX29io2NnbU85jNZpnNZiOjAQCACTB0heCRRx5RR0eHnE6nb1u9erW2bNkip9N5TQxIktVqVUNDg98+h8Mhq9U6sckBAEDQGLpCEBERoWXLlvntu/3223XnnXf69ttsNiUkJMhut0uSdu7cqYyMDB08eFC5ubmqqalRW1ubDh8+HKS3AAAAJirov6mwq6tLPT09vtfp6emqrq7W4cOHlZqaqhMnTqiuru6asAAAAKET0O8h+F+NjY1jvpakTZs2adOmTRM9FQAAmCQ8ywAAABAEAACAIAAAACIIAACACAIAACCCAAAAiCAAAAAiCAAAgAgCAAAgggAAAIggAAAAIggAAIAIAgAAIIIAAACIIAAAACIIAACACAIAACCCAAAAiCAAAAAiCAAAgAgCAAAgggAAAIggAAAAMhgE5eXlSklJUWRkpCIjI2W1WvXOO++Mur6qqkomk8lvCw8Pn/DQAAAguG4xsjgxMVH79+/X4sWL5fV69dvf/lYbN27U+fPnde+99454TGRkpC5evOh7bTKZJjYxAAAIOkNBsGHDBr/XL774osrLy3X27NlRg8BkMik2NjbwCQEAwKQL+B6CoaEh1dTUaHBwUFarddR1AwMDWrBggSwWizZu3KgLFy6M+709Ho/6+/v9NgAAMHkMB0FHR4dmz54ts9msJ598UrW1tVq6dOmIa5OTk3X06FGdPHlSr732moaHh5Wenq4rV66MeQ673a6oqCjfZrFYjI4JAAAMMBwEycnJcjqd+stf/qIf/ehHys/P11//+tcR11qtVtlsNq1YsUIZGRl68803NW/ePFVWVo55juLiYrndbt/W3d1tdEwAAGCAoXsIJGnmzJlKSkqSJKWlpam1tVWlpaXj/iUvSbfeeqtWrlypS5cujbnObDbLbDYbHQ0AAARowr+HYHh4WB6P57rWDg0NqaOjQ3FxcRM9LQAACCJDVwiKi4uVk5Oj+fPn6+rVq6qurlZjY6Pq6+slSTabTQkJCbLb7ZKkF154Qffff7+SkpL05Zdf6sCBA7p8+bK2b98e/HcCAAACZigI+vr6ZLPZ1NPTo6ioKKWkpKi+vl7r1q2TJHV1dWnGjG8vOnzxxRfasWOHXC6X5syZo7S0NDU3N496EyIAAAgNQ0Fw5MiRMb/e2Njo97qkpEQlJSWGhwIAAFOLZxkAAACCAAAAEAQAAEAEAQAAEEEAAABEEAAAABEEAABABAEAABBBAAAARBAAAAARBAAAQAQBAAAQQQAAAEQQAAAAEQQAAEAEAQAAEEEAAABEEAAAABEEAABABAEAABBBAAAARBAAAAARBAAAQAaDoLy8XCkpKYqMjFRkZKSsVqveeeedMY85fvy4lixZovDwcC1fvlynTp2a0MAAACD4DAVBYmKi9u/fr/b2drW1tenhhx/Wxo0bdeHChRHXNzc3a/Pmzdq2bZvOnz+vvLw85eXlqbOzMyjDAwCA4DAUBBs2bNBjjz2mxYsX6+6779aLL76o2bNn6+zZsyOuLy0t1fr167V7927dc8892rdvn1atWqWysrIxz+PxeNTf3++3AQCAyXNLoAcODQ3p+PHjGhwclNVqHXFNS0uLioqK/PZlZ2errq5uzO9tt9v1/PPPBzoaAOA7ZuHTb4d6hCnz8f7ckJzXcBB0dHTIarXqq6++0uzZs1VbW6ulS5eOuNblcikmJsZvX0xMjFwu15jnKC4u9guJ/v5+WSwWo6MCmCZulj/MQ/UHORAMhoMgOTlZTqdTbrdbJ06cUH5+vs6cOTNqFATCbDbLbDYH7fsBAICxGQ6CmTNnKikpSZKUlpam1tZWlZaWqrKy8pq1sbGx6u3t9dvX29ur2NjYAMcFAACTYcK/h2B4eFgej2fEr1mtVjU0NPjtczgco95zAAAAQsPQFYLi4mLl5ORo/vz5unr1qqqrq9XY2Kj6+npJks1mU0JCgux2uyRp586dysjI0MGDB5Wbm6uamhq1tbXp8OHDwX8nAAAgYIaCoK+vTzabTT09PYqKilJKSorq6+u1bt06SVJXV5dmzPj2okN6erqqq6v1zDPP6Oc//7kWL16suro6LVu2LLjvAgAATIihIDhy5MiYX29sbLxm36ZNm7Rp0yZDQwEAgKnFswwAAABBAAAACAIAACCCAAAAiCAAAAAiCAAAgAgCAAAgggAAAIggAAAAIggAAIAIAgAAIIIAAACIIAAAACIIAACACAIAACCCAAAAiCAAAAAiCAAAgAgCAAAgggAAAIggAAAAIggAAIAMBoHdbtd9992niIgIRUdHKy8vTxcvXhzzmKqqKplMJr8tPDx8QkMDAIDgMhQEZ86cUUFBgc6ePSuHw6FvvvlGjz76qAYHB8c8LjIyUj09Pb7t8uXLExoaAAAE1y1GFp8+fdrvdVVVlaKjo9Xe3q4HH3xw1ONMJpNiY2MDmxAAAEy6Cd1D4Ha7JUlz584dc93AwIAWLFggi8WijRs36sKFC2Ou93g86u/v99sAAMDkCTgIhoeHtWvXLj3wwANatmzZqOuSk5N19OhRnTx5Uq+99pqGh4eVnp6uK1eujHqM3W5XVFSUb7NYLIGOCQAArkPAQVBQUKDOzk7V1NSMuc5qtcpms2nFihXKyMjQm2++qXnz5qmysnLUY4qLi+V2u31bd3d3oGMCAIDrYOgegv8qLCzUW2+9paamJiUmJho69tZbb9XKlSt16dKlUdeYzWaZzeZARgMAAAEwFARer1c//vGPVVtbq8bGRi1atMjwCYeGhtTR0aHHHnvM8LEA8F208Om3Qz3ClPl4f26oR8AoDAVBQUGBqqurdfLkSUVERMjlckmSoqKiNGvWLEmSzWZTQkKC7Ha7JOmFF17Q/fffr6SkJH355Zc6cOCALl++rO3btwf5rQAAgEAZCoLy8nJJUmZmpt/+V199VU888YQkqaurSzNmfHtrwhdffKEdO3bI5XJpzpw5SktLU3Nzs5YuXTqxyQEAQNAY/pHBeBobG/1el5SUqKSkxNBQAABgavEsAwAAQBAAAACCAAAAiCAAAAAiCAAAgAgCAAAgggAAAIggAAAAIggAAIAIAgAAIIIAAACIIAAAACIIAACACAIAACCCAAAAiCAAAAAiCAAAgAgCAAAgggAAAIggAAAAIggAAIAIAgAAIIIAAADIYBDY7Xbdd999ioiIUHR0tPLy8nTx4sVxjzt+/LiWLFmi8PBwLV++XKdOnQp4YAAAEHyGguDMmTMqKCjQ2bNn5XA49M033+jRRx/V4ODgqMc0Nzdr8+bN2rZtm86fP6+8vDzl5eWps7NzwsMDAIDguMXI4tOnT/u9rqqqUnR0tNrb2/Xggw+OeExpaanWr1+v3bt3S5L27dsnh8OhsrIyVVRUBDg2AAAIpgndQ+B2uyVJc+fOHXVNS0uLsrKy/PZlZ2erpaVl1GM8Ho/6+/v9NgAAMHkCDoLh4WHt2rVLDzzwgJYtWzbqOpfLpZiYGL99MTExcrlcox5jt9sVFRXl2ywWS6BjAgCA6xBwEBQUFKizs1M1NTXBnEeSVFxcLLfb7du6u7uDfg4AAPAtQ/cQ/FdhYaHeeustNTU1KTExccy1sbGx6u3t9dvX29ur2NjYUY8xm80ym82BjAYAAAJg6AqB1+tVYWGhamtr9e6772rRokXjHmO1WtXQ0OC3z+FwyGq1GpsUAABMGkNXCAoKClRdXa2TJ08qIiLCdx9AVFSUZs2aJUmy2WxKSEiQ3W6XJO3cuVMZGRk6ePCgcnNzVVNTo7a2Nh0+fDjIbwUAAATK0BWC8vJyud1uZWZmKi4uzrcdO3bMt6arq0s9PT2+1+np6aqurtbhw4eVmpqqEydOqK6ubswbEQEAwNQydIXA6/WOu6axsfGafZs2bdKmTZuMnAoAAEwhnmUAAAAIAgAAQBAAAAARBAAAQAQBAAAQQQAAAEQQAAAAEQQAAEAEAQAAEEEAAABEEAAAABEEAABABAEAABBBAAAARBAAAAARBAAAQAQBAAAQQQAAAEQQAAAAEQQAAEAEAQAAEEEAAABEEAAAAAUQBE1NTdqwYYPi4+NlMplUV1c35vrGxkaZTKZrNpfLFfDQAAAguAwHweDgoFJTU3Xo0CFDx128eFE9PT2+LTo62uipAQDAJLnF6AE5OTnKyckxfKLo6Gjdcccd17XW4/HI4/H4Xvf39xs+HwAAuH5Tdg/BihUrFBcXp3Xr1unPf/7zmGvtdruioqJ8m8VimaIpAQC4OU16EMTFxamiokJvvPGG3njjDVksFmVmZurcuXOjHlNcXCy32+3buru7J3tMAABuaoZ/ZGBUcnKykpOTfa/T09P14YcfqqSkRL///e9HPMZsNstsNk/2aAAA4D9C8s8O16xZo0uXLoXi1AAAYAQhCQKn06m4uLhQnBoAAIzA8I8MBgYG/P7r/qOPPpLT6dTcuXM1f/58FRcX65NPPtHvfvc7SdLLL7+sRYsW6d5779VXX32lV155Re+++67++Mc/Bu9dAACACTEcBG1tbXrooYd8r4uKiiRJ+fn5qqqqUk9Pj7q6unxf//rrr/XTn/5Un3zyiW677TalpKToT3/6k9/3AAAAoWU4CDIzM+X1ekf9elVVld/rp556Sk899ZThwQAAwNThWQYAAIAgAAAABAEAABBBAAAARBAAAAARBAAAQAQBAAAQQQAAAEQQAAAAEQQAAEAEAQAAEEEAAABEEAAAABEEAABABAEAABBBAAAARBAAAAARBAAAQAQBAAAQQQAAAEQQAAAAEQQAAEABBEFTU5M2bNig+Ph4mUwm1dXVjXtMY2OjVq1aJbPZrKSkJFVVVQUyKwAAmCSGg2BwcFCpqak6dOjQda3/6KOPlJubq4ceekhOp1O7du3S9u3bVV9fb3hYAAAwOW4xekBOTo5ycnKue31FRYUWLVqkgwcPSpLuuecevffeeyopKVF2drbR0wMAgEkw6fcQtLS0KCsry29fdna2WlpaRj3G4/Gov7/fbwMAAJNn0oPA5XIpJibGb19MTIz6+/v1r3/9a8Rj7Ha7oqKifJvFYpnsMQEAuKlNy39lUFxcLLfb7du6u7tDPRIAAN9phu8hMCo2Nla9vb1++3p7exUZGalZs2aNeIzZbJbZbJ7s0QAAwH9M+hUCq9WqhoYGv30Oh0NWq3WyTw0AAK6T4SAYGBiQ0+mU0+mU9O9/Vuh0OtXV1SXp35f7bTabb/2TTz6pv//973rqqaf0wQcf6Ne//rVef/11/eQnPwnSWwAAABNlOAja2tq0cuVKrVy5UpJUVFSklStXas+ePZKknp4eXxxI0qJFi/T222/L4XAoNTVVBw8e1CuvvMI/OQQAYBoxfA9BZmamvF7vqF8f6bcQZmZm6vz580ZPBQAApsi0/FcGAABgahEEAACAIAAAAAQBAAAQQQAAAEQQAAAAEQQAAEAEAQAAEEEAAABEEAAAABEEAABABAEAABBBAAAARBAAAAARBAAAQAQBAAAQQQAAAEQQAAAAEQQAAEAEAQAAEEEAAABEEAAAABEEAABAAQbBoUOHtHDhQoWHh2vt2rV6//33R11bVVUlk8nkt4WHhwc8MAAACD7DQXDs2DEVFRVp7969OnfunFJTU5Wdna2+vr5Rj4mMjFRPT49vu3z58oSGBgAAwWU4CF566SXt2LFDW7du1dKlS1VRUaHbbrtNR48eHfUYk8mk2NhY3xYTEzOhoQEAQHAZCoKvv/5a7e3tysrK+vYbzJihrKwstbS0jHrcwMCAFixYIIvFoo0bN+rChQtjnsfj8ai/v99vAwAAk8dQEHz++ecaGhq65r/wY2Ji5HK5RjwmOTlZR48e1cmTJ/Xaa69peHhY6enpunLlyqjnsdvtioqK8m0Wi8XImAAAwKBJ/1cGVqtVNptNK1asUEZGht58803NmzdPlZWVox5TXFwst9vt27q7uyd7TAAAbmq3GFl81113KSwsTL29vX77e3t7FRsbe13f49Zbb9XKlSt16dKlUdeYzWaZzWYjowEAgAkwdIVg5syZSktLU0NDg2/f8PCwGhoaZLVar+t7DA0NqaOjQ3FxccYmBQAAk8bQFQJJKioqUn5+vlavXq01a9bo5Zdf1uDgoLZu3SpJstlsSkhIkN1ulyS98MILuv/++5WUlKQvv/xSBw4c0OXLl7V9+/bgvhMAABAww0Hw+OOP67PPPtOePXvkcrm0YsUKnT592nejYVdXl2bM+PbCwxdffKEdO3bI5XJpzpw5SktLU3Nzs5YuXRq8dwEAACbEcBBIUmFhoQoLC0f8WmNjo9/rkpISlZSUBHIaAAAwRXiWAQAAIAgAAABBAAAARBAAAAARBAAAQAQBAAAQQQAAAEQQAAAAEQQAAEAEAQAAEEEAAABEEAAAABEEAABABAEAABBBAAAARBAAAAARBAAAQAQBAAAQQQAAAEQQAAAAEQQAAEAEAQAAEEEAAAAUYBAcOnRICxcuVHh4uNauXav3339/zPXHjx/XkiVLFB4eruXLl+vUqVMBDQsAACaH4SA4duyYioqKtHfvXp07d06pqanKzs5WX1/fiOubm5u1efNmbdu2TefPn1deXp7y8vLU2dk54eEBAEBw3GL0gJdeekk7duzQ1q1bJUkVFRV6++23dfToUT399NPXrC8tLdX69eu1e/duSdK+ffvkcDhUVlamioqKEc/h8Xjk8Xh8r91utySpv7/f6LhjGvb8X1C/33Q1kc+Nz2h8fEbj4zMa283y+Uh8Rtcj2H/X/ff7eb3esRd6DfB4PN6wsDBvbW2t336bzeb94Q9/OOIxFovFW1JS4rdvz5493pSUlFHPs3fvXq8kNjY2NjY2tiBt3d3dY/4db+gKweeff66hoSHFxMT47Y+JidEHH3ww4jEul2vE9S6Xa9TzFBcXq6ioyPd6eHhY//znP3XnnXfKZDIZGXla6e/vl8ViUXd3tyIjI0M9zrTEZzQ+PqPx8RmNj89obN+lz8fr9erq1auKj48fc53hHxlMBbPZLLPZ7LfvjjvuCNE0wRcZGXnD/x9ssvEZjY/PaHx8RuPjMxrbd+XziYqKGneNoZsK77rrLoWFham3t9dvf29vr2JjY0c8JjY21tB6AAAw9QwFwcyZM5WWlqaGhgbfvuHhYTU0NMhqtY54jNVq9VsvSQ6HY9T1AABg6oU999xzzxk5IDIyUs8++6wsFovMZrOeffZZOZ1OHTlyRLNnz5bNZtP777+vrKwsSVJCQoKeeeYZ3X777Zo7d67Kysp07NgxHTlyRNHR0ZPxnqa1sLAwZWZm6pZbpuVPa6YFPqPx8RmNj89ofHxGY7vZPh+T1zvev0O4VllZmQ4cOCCXy6UVK1boV7/6ldauXStJyszM1MKFC1VVVeVbf/z4cT3zzDP6+OOPtXjxYv3yl7/UY489FrQ3AQAAJiagIAAAAN8tPMsAAAAQBAAAgCAAAAAiCAAAgAiCKWX0sdE3k6amJm3YsEHx8fEymUyqq6sL9UjTit1u13333aeIiAhFR0crLy9PFy9eDPVY00p5eblSUlJ8v1nOarXqnXfeCfVY09r+/ftlMpm0a9euUI8ybTz33HMymUx+25IlS0I91pQgCKaI0cdG32wGBweVmpqqQ4cOhXqUaenMmTMqKCjQ2bNn5XA49M033+jRRx/V4OBgqEebNhITE7V//361t7erra1NDz/8sDZu3KgLFy6EerRpqbW1VZWVlUpJSQn1KNPOvffeq56eHt/23nvvhXqkqTH+Mw4RDGvWrPEWFBT4Xg8NDXnj4+O9drs9hFNNT5KueaIm/PX19Xklec+cORPqUaa1OXPmeF955ZVQjzHtXL161bt48WKvw+HwZmRkeHfu3BnqkaaNvXv3elNTU0M9RkhwhWAKfP3112pvb/f99kZJmjFjhrKystTS0hLCyXCjcrvdkqS5c+eGeJLpaWhoSDU1NRocHOTXpI+goKBAubm5fn8m4Vt/+9vfFB8fr+9973vasmWLurq6Qj3SlLg5fh9jiAXy2GhgNMPDw9q1a5ceeOABLVu2LNTjTCsdHR2yWq366quvNHv2bNXW1mrp0qWhHmtaqamp0blz59Ta2hrqUaaltWvXqqqqSsnJyerp6dHzzz+vH/zgB+rs7FRERESox5tUBAFwgykoKFBnZ+fN83NNA5KTk+V0OuV2u3XixAnl5+frzJkzRMF/dHd3a+fOnXI4HAoPDw/1ONNSTk6O73+npKRo7dq1WrBggV5//XVt27YthJNNPoJgCgTy2GhgJIWFhXrrrbfU1NSkxMTEUI8z7cycOVNJSUmSpLS0NLW2tqq0tFSVlZUhnmx6aG9vV19fn1atWuXbNzQ0pKamJpWVlcnj8SgsLCyEE04/d9xxh+6++25dunQp1KNMOu4hmAKBPDYa+F9er1eFhYWqra3Vu+++q0WLFoV6pBvC8PCwPB5PqMeYNh555BF1dHTI6XT6ttWrV2vLli1yOp3EwAgGBgb04YcfKi4uLtSjTDquEEyRoqIi5efna/Xq1VqzZo1efvllDQ4OauvWraEebVoYGBjwK/CPPvpITqdTc+fO1fz580M42fRQUFCg6upqnTx5UhEREXK5XJKkqKgozZo1K8TTTQ/FxcXKycnR/PnzdfXqVVVXV6uxsVH19fWhHm3aiIiIuOa+k9tvv1133nkn96P8x89+9jNt2LBBCxYs0Keffqq9e/cqLCxMmzdvDvVok44gmCKPP/64PvvsM+3Zs8f32OjTp09fc6PhzaqtrU0PPfSQ73VRUZEkKT8/3+9R2jer8vJySf9+vPj/evXVV/XEE09M/UDTUF9fn2w2m3p6ehQVFaWUlBTV19dr3bp1oR4NN5ArV65o8+bN+sc//qF58+bp+9//vs6ePat58+aFerRJx+OPAQAA9xAAAACCAAAAiCAAAAAiCAAAgAgCAAAgggAAAIggAAAAIggAAIAIAgAAIIIAAACIIAAAAJL+H+PPlCWlSbgrAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 600x400 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAfcAAAFZCAYAAACFY2a5AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAAPYQAAD2EBqD+naQAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAARNklEQVR4nO3db2hVh93A8V8a8VpqklZXuwZj7ehmaSWO2lZC98e2tiOIa9+NIuhkDDbiUGQw86LTvhgJDMY6lEy2br6Z2G1gC5VWpEPDYG4xEtCOlXW0LENt9gcSzcPuSnKfF8+ePE/WajwxN/f68/OBA57juZ4fB/HruffknoZKpVIJACCNW2o9AAAwt8QdAJIRdwBIRtwBIBlxB4BkxB0AkhF3AEhmwXwfcHJyMs6fPx9NTU3R0NAw34cHgBtWpVKJS5cuRWtra9xyy5Wvz+c97ufPn4+2trb5PiwApDE8PBzLly+/4u/Pe9ybmpoi4n8Ga25unu/DA8ANa2xsLNra2qZaeiXzHvf/fSu+ublZ3AFgFmb6WNsNdQCQjLgDQDLiDgDJiDsAJCPuAJCMuANAMuIOAMmIOwAkI+4AkIy4A0Ay4g4AyYg7ACQz7w+OgXq2cvfRWo8wL97r3VjrEYAqcuUOAMmIOwAkI+4AkIy4A0Ay4g4AyYg7ACQj7gCQjLgDQDLiDgDJiDsAJCPuAJCMuANAMuIOAMmIOwAkI+4AkIy4A0Ay4g4AyYg7ACQj7gCQjLgDQDLiDgDJiDsAJHNdce/t7Y2GhobYuXPnXM0DAFynWcd9YGAgDhw4EO3t7XM5DwBwnWYV98uXL8fmzZvjRz/6Udxxxx1zPRMAcB1mFfeurq7YuHFjbNiwYcZ9y+VyjI2NTVsAgOpZUPQFhw8fjjNnzsTAwMA17d/T0xMvvPBC4cEAgNkpdOU+PDwcO3bsiJ/97GexaNGia3pNd3d3jI6OTi3Dw8OzGhQAuDaFrtwHBwdjZGQkHnrooaltExMT0d/fH/v27YtyuRyNjY3TXlMqlaJUKs3NtADAjArF/cknn4yzZ89O27Zt27a4//7741vf+taHwk59Wbn7aK1HmBfv9W6s9QgANVUo7k1NTbF69epp22677bZYunTph7YDALXhG+oAIJnCd8v/pxMnTszBGADAXHHlDgDJiDsAJCPuAJCMuANAMuIOAMmIOwAkI+4AkIy4A0Ay4g4AyYg7ACQj7gCQjLgDQDLiDgDJiDsAJCPuAJCMuANAMuIOAMmIOwAkI+4AkIy4A0Ay4g4AyYg7ACQj7gCQzIJaDwDcOFbuPlrrEebNe70baz0CzJordwBIRtwBIBlxB4BkxB0AkhF3AEhG3AEgmTQ/Cnez/IiOH88BYCau3AEgGXEHgGTEHQCSEXcASEbcASAZcQeAZMQdAJIRdwBIRtwBIBlxB4BkxB0AkhF3AEhG3AEgGXEHgGTEHQCSEXcASEbcASAZcQeAZMQdAJIRdwBIRtwBIBlxB4BkFtR6AABuLit3H631CPPivd6NNTt2oSv3vr6+aG9vj+bm5mhubo6Ojo54/fXXqzUbADALheK+fPny6O3tjcHBwTh9+nQ88cQT8cwzz8Rbb71VrfkAgIIKvS2/adOmaevf+c53oq+vL06dOhUPPvjgnA4GAMzOrD9zn5iYiF/84hcxPj4eHR0dV9yvXC5HuVyeWh8bG5vtIQGAa1D4bvmzZ8/G4sWLo1Qqxde+9rU4cuRIPPDAA1fcv6enJ1paWqaWtra26xoYALi6wnFftWpVDA0NxW9/+9v4+te/Hlu3bo3f//73V9y/u7s7RkdHp5bh4eHrGhgAuLrCb8svXLgw7rvvvoiIWLt2bQwMDMSLL74YBw4c+Mj9S6VSlEql65sSALhm1/0lNpOTk9M+UwcAaqvQlXt3d3d0dnbGihUr4tKlS3Ho0KE4ceJEHDt2rFrzAQAFFYr7yMhIbNmyJS5cuBAtLS3R3t4ex44di6eeeqpa8wEABRWK+0svvVStOQCAOeLBMQCQjLgDQDLiDgDJiDsAJCPuAJCMuANAMuIOAMmIOwAkI+4AkIy4A0Ay4g4AyYg7ACQj7gCQjLgDQDLiDgDJiDsAJCPuAJCMuANAMuIOAMmIOwAkI+4AkMyCWg8AkMnK3UdrPcK8ea93Y61H4ApcuQNAMuIOAMmIOwAkI+4AkIy4A0Ay4g4AyYg7ACQj7gCQjLgDQDLiDgDJiDsAJCPuAJCMuANAMuIOAMmIOwAkI+4AkIy4A0Ay4g4AyYg7ACQj7gCQjLgDQDLiDgDJiDsAJCPuAJCMuANAMuIOAMmIOwAkI+4AkIy4A0Ay4g4AyYg7ACQj7gCQTKG49/T0xCOPPBJNTU2xbNmyePbZZ+Ptt9+u1mwAwCwUivvJkyejq6srTp06FcePH48PPvggnn766RgfH6/WfABAQQuK7PzGG29MWz948GAsW7YsBgcH43Of+9ycDgYAzE6huP+n0dHRiIhYsmTJFfcpl8tRLpen1sfGxq7nkADADGZ9Q93k5GTs3LkzHnvssVi9evUV9+vp6YmWlpappa2tbbaHBACuwazj3tXVFefOnYvDhw9fdb/u7u4YHR2dWoaHh2d7SADgGszqbfnt27fHa6+9Fv39/bF8+fKr7lsqlaJUKs1qOACguEJxr1Qq8Y1vfCOOHDkSJ06ciHvvvbdacwEAs1Qo7l1dXXHo0KF49dVXo6mpKS5evBgRES0tLXHrrbdWZUAAoJhCn7n39fXF6OhorF+/Pu6+++6p5eWXX67WfABAQYXflgcA6pvvlgeAZMQdAJIRdwBIRtwBIBlxB4BkxB0AkhF3AEhG3AEgGXEHgGTEHQCSEXcASEbcASAZcQeAZMQdAJIRdwBIRtwBIBlxB4BkxB0AkhF3AEhG3AEgGXEHgGTEHQCSEXcASEbcASAZcQeAZMQdAJIRdwBIRtwBIBlxB4BkxB0AkhF3AEhG3AEgGXEHgGTEHQCSEXcASEbcASAZcQeAZMQdAJIRdwBIRtwBIBlxB4BkxB0AkhF3AEhG3AEgGXEHgGTEHQCSEXcASEbcASAZcQeAZMQdAJIRdwBIRtwBIBlxB4BkxB0Akikc9/7+/ti0aVO0trZGQ0NDvPLKK9WYCwCYpcJxHx8fjzVr1sT+/furMQ8AcJ0WFH1BZ2dndHZ2VmMWAGAOFI57UeVyOcrl8tT62NhYtQ8JADe1qt9Q19PTEy0tLVNLW1tbtQ8JADe1qse9u7s7RkdHp5bh4eFqHxIAbmpVf1u+VCpFqVSq9mEAgH/zc+4AkEzhK/fLly/HO++8M7X+7rvvxtDQUCxZsiRWrFgxp8MBAMUVjvvp06fj8ccfn1rftWtXRERs3bo1Dh48OGeDAQCzUzju69evj0qlUo1ZAIA54DN3AEhG3AEgGXEHgGTEHQCSEXcASEbcASAZcQeAZMQdAJIRdwBIRtwBIBlxB4BkxB0AkhF3AEhG3AEgGXEHgGTEHQCSEXcASEbcASAZcQeAZMQdAJIRdwBIRtwBIBlxB4BkxB0AkhF3AEhG3AEgGXEHgGTEHQCSEXcASEbcASAZcQeAZMQdAJIRdwBIRtwBIBlxB4BkxB0AkhF3AEhG3AEgGXEHgGTEHQCSEXcASEbcASAZcQeAZMQdAJIRdwBIRtwBIBlxB4BkxB0AkhF3AEhG3AEgGXEHgGTEHQCSEXcASEbcASAZcQeAZGYV9/3798fKlStj0aJFsW7duvjd734313MBALNUOO4vv/xy7Nq1K/bs2RNnzpyJNWvWxBe+8IUYGRmpxnwAQEELir7ge9/7Xnz1q1+Nbdu2RUTED3/4wzh69Gj85Cc/id27d39o/3K5HOVyeWp9dHQ0IiLGxsZmO/NHmiz/15z+efXqes6bczQz5+jqbpbzE+EcXQvn6OrmunP//8+sVCpX37FSQLlcrjQ2NlaOHDkybfuWLVsqX/ziFz/yNXv27KlEhMVisVgsljlahoeHr9rrQlfuf/vb32JiYiLuuuuuadvvuuuu+MMf/vCRr+nu7o5du3ZNrU9OTsY//vGPWLp0aTQ0NBQ5fF0ZGxuLtra2GB4ejubm5lqPU5eco5k5RzNzjq7O+ZlZpnNUqVTi0qVL0draetX9Cr8tX1SpVIpSqTRt2+23317tw86b5ubmG/4vS7U5RzNzjmbmHF2d8zOzLOeopaVlxn0K3VD3sY99LBobG+P999+ftv3999+Pj3/848WmAwCqolDcFy5cGGvXro0333xzatvk5GS8+eab0dHRMefDAQDFNe7du3dvkRc0NzfH888/H21tbVEqleL555+PoaGheOmll2Lx4sVVGrM+NTY2xvr162PBgqp/unHDco5m5hzNzDm6OudnZjfbOWqozHg//Yft27cvvvvd78bFixfj05/+dPzgBz+IdevWVWM+AKCgWcUdAKhfvlseAJIRdwBIRtwBIBlxB4BkxH0WPPL26vr7+2PTpk3R2toaDQ0N8corr9R6pLrS09MTjzzySDQ1NcWyZcvi2WefjbfffrvWY9WVvr6+aG9vn/pGsY6Ojnj99ddrPVZd6+3tjYaGhti5c2etR6kbe/fujYaGhmnL/fffX+ux5oW4F+SRtzMbHx+PNWvWxP79+2s9Sl06efJkdHV1xalTp+L48ePxwQcfxNNPPx3j4+O1Hq1uLF++PHp7e2NwcDBOnz4dTzzxRDzzzDPx1ltv1Xq0ujQwMBAHDhyI9vb2Wo9Sdx588MG4cOHC1PLrX/+61iPNjyJPhaNSefTRRytdXV1T6xMTE5XW1tZKT09PDaeqXxHxoacIMt3IyEglIionT56s9Sh17Y477qj8+Mc/rvUYdefSpUuVT37yk5Xjx49XPv/5z1d27NhR65Hqxp49eypr1qyp9Rg14cq9gH/9618xODgYGzZsmNp2yy23xIYNG+I3v/lNDSfjRjY6OhoREUuWLKnxJPVpYmIiDh8+HOPj477m+iN0dXXFxo0bp/27xP/54x//GK2trfGJT3wiNm/eHH/+859rPdK8uDm+h2+OzOaRt3A1k5OTsXPnznjsscdi9erVtR6nrpw9ezY6Ojrin//8ZyxevDiOHDkSDzzwQK3HqiuHDx+OM2fOxMDAQK1HqUvr1q2LgwcPxqpVq+LChQvxwgsvxGc/+9k4d+5cNDU11Xq8qhJ3qKGurq44d+7czfM5YAGrVq2KoaGhGB0djV/+8pexdevWOHnypMD/2/DwcOzYsSOOHz8eixYtqvU4damzs3Pq1+3t7bFu3bq455574uc//3l85StfqeFk1SfuBXjkLXNp+/bt8dprr0V/f38sX7681uPUnYULF8Z9990XERFr166NgYGBePHFF+PAgQM1nqw+DA4OxsjISDz00ENT2yYmJqK/vz/27dsX5XI5Ghsbazhh/bn99tvjU5/6VLzzzju1HqXqfOZegEfeMhcqlUps3749jhw5Er/61a/i3nvvrfVIN4TJyckol8u1HqNuPPnkk3H27NkYGhqaWh5++OHYvHlzDA0NCftHuHz5cvzpT3+Ku+++u9ajVJ0r94J27doVW7dujYcffjgeffTR+P73vx/j4+Oxbdu2Wo9WNy5fvjztf8bvvvtuDA0NxZIlS2LFihU1nKw+dHV1xaFDh+LVV1+NpqamuHjxYkREtLS0xK233lrj6epDd3d3dHZ2xooVK+LSpUtx6NChOHHiRBw7dqzWo9WNpqamD92ncdttt8XSpUvdv/Fv3/zmN2PTpk1xzz33xPnz52PPnj3R2NgYzz33XK1HqzpxL+hLX/pS/PWvf41vf/vbU4+8feONNz50k93N7PTp0/H4449Pre/atSsiIrZu3RoHDx6s0VT1o6+vLyIi1q9fP237T3/60/jyl788/wPVoZGRkdiyZUtcuHAhWlpaor29PY4dOxZPPfVUrUfjBvKXv/wlnnvuufj73/8ed955Z3zmM5+JU6dOxZ133lnr0arOI18BIBmfuQNAMuIOAMmIOwAkI+4AkIy4A0Ay4g4AyYg7ACQj7gCQjLgDQDLiDgDJiDsAJPPfoMvAoh3d/jMAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 600x400 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "plt.bar(range(6), males[males.columns[9:15]].mean())\n",
    "plt.show()\n",
    "\n",
    "plt.bar(range(6), females[females.columns[9:15]].mean())\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAgkAAAFZCAYAAAASBLySAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAAPYQAAD2EBqD+naQAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3df0yV5/3/8Rc/5CjKORRazoEIzP5SqaIddnjSrnNKQSS2Tflj7ZjSxWhqDk2V1ToWq1a34fw0s+1Gabc5aTOZXZfZRtaqqBPXCFbpiFQ3Uo2fQCMHtho5SuNB4Xz/+H69vzvtZe2BAwfb5yO5Eu7ruu77ft93mvrK/ePcUYFAICAAAIDPiI50AQAAYHQiJAAAACNCAgAAMCIkAAAAI0ICAAAwIiQAAAAjQgIAADCKjXQBgzEwMKCzZ88qISFBUVFRkS4HAIAbRiAQ0IULF5SWlqbo6C++VnBDhoSzZ88qPT090mUAAHDD6ujo0MSJE79wzg0ZEhISEiT93wO02+0RrgYAgBuHz+dTenq69W/pF7khQ8LVWwx2u52QAADAIHyZ2/U8uAgAAIwICQAAwGhIIWHTpk2KiorSihUrrL5Lly7J4/EoOTlZEyZMUHFxsbq6uoLWa29vV1FRkeLj45WSkqJVq1bpypUrQykFAACE2aBDwtGjR/Xqq68qOzs7qH/lypXatWuX3nzzTTU0NOjs2bN65JFHrPH+/n4VFRWpr69Phw8f1muvvaaamhqtXbt28EcBAADCblAh4eLFiyopKdFvf/tb3XTTTVZ/T0+Ptm7dql/+8peaO3eucnJytG3bNh0+fFhNTU2SpL179+rkyZP6wx/+oJkzZ6qwsFAbN25UVVWV+vr6wnNUAABgyAYVEjwej4qKipSXlxfU39zcrMuXLwf1T5kyRRkZGWpsbJQkNTY2avr06XI6ndacgoIC+Xw+nThxwrg/v98vn88X1AAAwPAK+RXIHTt26IMPPtDRo0c/N+b1ehUXF6fExMSgfqfTKa/Xa83574BwdfzqmEllZaWee+65UEsFAABDENKVhI6ODj311FPavn27xo4dO1w1fU5FRYV6enqs1tHRMWL7BgDg6yqkkNDc3Kzu7m5985vfVGxsrGJjY9XQ0KCXXnpJsbGxcjqd6uvr0/nz54PW6+rqksvlkiS5XK7Pve1wdfnqnM+y2WzWDyfxA0oAAIyMkELCvHnz1NraqpaWFqvNmjVLJSUl1t9jxozR/v37rXXa2trU3t4ut9stSXK73WptbVV3d7c1p76+Xna7XVlZWWE6LAAAMFQhPZOQkJCgadOmBfWNHz9eycnJVv+SJUtUXl6upKQk2e12Pfnkk3K73Zo9e7YkKT8/X1lZWVq0aJE2b94sr9erNWvWyOPxyGazhemwAADAUIX92w1btmxRdHS0iouL5ff7VVBQoJdfftkaj4mJUV1dnZYvXy63263x48ertLRUGzZsCHcpAABgCKICgUAg0kWEyufzyeFwqKenh+cTAHwlfePHf410CSPifzcVRbqEr51Q/g3l2w0AAMCIkAAAAIzC/kwCAAAjgVsyw48rCQAAwIiQAAAAjAgJAADAiJAAAACMCAkAAMCIkAAAAIwICQAAwIiQAAAAjAgJAADAiJAAAACMCAkAAMCIkAAAAIwICQAAwIiQAAAAjAgJAADAiJAAAACMCAkAAMCIkAAAAIxiI13AaPKNH/810iWMmP/dVBTpEgAAoxxXEgAAgBEhAQAAGBESAACAESEBAAAYhRQSqqurlZ2dLbvdLrvdLrfbrXfffdcanzNnjqKiooLaE088EbSN9vZ2FRUVKT4+XikpKVq1apWuXLkSnqMBAABhE9LbDRMnTtSmTZt0xx13KBAI6LXXXtNDDz2kf/zjH7rrrrskSUuXLtWGDRusdeLj462/+/v7VVRUJJfLpcOHD6uzs1OLFy/WmDFj9POf/zxMhwQAAMIhpJCwcOHCoOWf/exnqq6uVlNTkxUS4uPj5XK5jOvv3btXJ0+e1L59++R0OjVz5kxt3LhRq1ev1vr16xUXF2dcz+/3y+/3W8s+ny+UsgEAwCAM+pmE/v5+7dixQ729vXK73Vb/9u3bdfPNN2vatGmqqKjQp59+ao01NjZq+vTpcjqdVl9BQYF8Pp9OnDhxzX1VVlbK4XBYLT09fbBlAwCALynkH1NqbW2V2+3WpUuXNGHCBO3cuVNZWVmSpO9///vKzMxUWlqajh8/rtWrV6utrU1/+ctfJElerzcoIEiylr1e7zX3WVFRofLycmvZ5/MRFAAAGGYhh4TJkyerpaVFPT09+vOf/6zS0lI1NDQoKytLy5Yts+ZNnz5dqampmjdvnk6fPq3bbrtt0EXabDbZbLZBrw8AAEIX8u2GuLg43X777crJyVFlZaVmzJihF1980Tg3NzdXknTq1ClJksvlUldXV9Ccq8vXeo4BAABExpB/J2FgYCDoocL/1tLSIklKTU2VJLndbrW2tqq7u9uaU19fL7vdbt2yAAAAo0NItxsqKipUWFiojIwMXbhwQbW1tTp48KD27Nmj06dPq7a2VgsWLFBycrKOHz+ulStX6v7771d2drYkKT8/X1lZWVq0aJE2b94sr9erNWvWyOPxcDsBAIBRJqSQ0N3drcWLF6uzs1MOh0PZ2dnas2ePHnjgAXV0dGjfvn164YUX1Nvbq/T0dBUXF2vNmjXW+jExMaqrq9Py5cvldrs1fvx4lZaWBv2uAoCvvq/LF1f52ipudCGFhK1bt15zLD09XQ0NDdfdRmZmpt55551QdgsAACKAbzcAAAAjQgIAADAiJAAAACNCAgAAMCIkAAAAI0ICAAAwIiQAAAAjQgIAADAiJAAAACNCAgAAMCIkAAAAI0ICAAAwCukDTwBf7wOArw+uJAAAACNCAgAAMCIkAAAAI0ICAAAw4sFFIMx4uBPAVwVXEgAAgBEhAQAAGBESAACAESEBAAAYERIAAIARIQEAABgREgAAgFFIIaG6ulrZ2dmy2+2y2+1yu9169913rfFLly7J4/EoOTlZEyZMUHFxsbq6uoK20d7erqKiIsXHxyslJUWrVq3SlStXwnM0AAAgbEIKCRMnTtSmTZvU3NysY8eOae7cuXrooYd04sQJSdLKlSu1a9cuvfnmm2poaNDZs2f1yCOPWOv39/erqKhIfX19Onz4sF577TXV1NRo7dq14T0qAAAwZCH94uLChQuDln/2s5+purpaTU1NmjhxorZu3ara2lrNnTtXkrRt2zZNnTpVTU1Nmj17tvbu3auTJ09q3759cjqdmjlzpjZu3KjVq1dr/fr1iouLC9+RAQCAIRn0Mwn9/f3asWOHent75Xa71dzcrMuXLysvL8+aM2XKFGVkZKixsVGS1NjYqOnTp8vpdFpzCgoK5PP5rKsRJn6/Xz6fL6gBAIDhFXJIaG1t1YQJE2Sz2fTEE09o586dysrKktfrVVxcnBITE4PmO51Oeb1eSZLX6w0KCFfHr45dS2VlpRwOh9XS09NDLRsAAIQo5JAwefJktbS06MiRI1q+fLlKS0t18uTJ4ajNUlFRoZ6eHqt1dHQM6/4AAMAgvgIZFxen22+/XZKUk5Ojo0eP6sUXX9T3vvc99fX16fz580FXE7q6uuRyuSRJLpdL77//ftD2rr79cHWOic1mk81mC7VUAAAwBEP+nYSBgQH5/X7l5ORozJgx2r9/vzXW1tam9vZ2ud1uSZLb7VZra6u6u7utOfX19bLb7crKyhpqKQAAIIxCupJQUVGhwsJCZWRk6MKFC6qtrdXBgwe1Z88eORwOLVmyROXl5UpKSpLdbteTTz4pt9ut2bNnS5Ly8/OVlZWlRYsWafPmzfJ6vVqzZo08Hg9XCgAAGGVCCgnd3d1avHixOjs75XA4lJ2drT179uiBBx6QJG3ZskXR0dEqLi6W3+9XQUGBXn75ZWv9mJgY1dXVafny5XK73Ro/frxKS0u1YcOG8B4VAAAYspBCwtatW79wfOzYsaqqqlJVVdU152RmZuqdd94JZbcAACAC+HYDAAAwIiQAAAAjQgIAADAiJAAAACNCAgAAMCIkAAAAI0ICAAAwIiQAAAAjQgIAADAiJAAAACNCAgAAMCIkAAAAI0ICAAAwIiQAAAAjQgIAADAiJAAAACNCAgAAMCIkAAAAI0ICAAAwIiQAAAAjQgIAADAiJAAAACNCAgAAMCIkAAAAI0ICAAAwIiQAAACjkEJCZWWl7rnnHiUkJCglJUUPP/yw2tragubMmTNHUVFRQe2JJ54ImtPe3q6ioiLFx8crJSVFq1at0pUrV4Z+NAAAIGxiQ5nc0NAgj8eje+65R1euXNFPfvIT5efn6+TJkxo/frw1b+nSpdqwYYO1HB8fb/3d39+voqIiuVwuHT58WJ2dnVq8eLHGjBmjn//852E4JAAAEA4hhYTdu3cHLdfU1CglJUXNzc26//77rf74+Hi5XC7jNvbu3auTJ09q3759cjqdmjlzpjZu3KjVq1dr/fr1iouLG8RhAACAcBvSMwk9PT2SpKSkpKD+7du36+abb9a0adNUUVGhTz/91BprbGzU9OnT5XQ6rb6CggL5fD6dOHHCuB+/3y+fzxfUAADA8ArpSsJ/GxgY0IoVK3Tvvfdq2rRpVv/3v/99ZWZmKi0tTcePH9fq1avV1tamv/zlL5Ikr9cbFBAkWcter9e4r8rKSj333HODLRUAAAzCoEOCx+PRhx9+qPfeey+of9myZdbf06dPV2pqqubNm6fTp0/rtttuG9S+KioqVF5ebi37fD6lp6cPrnAAAPClDOp2Q1lZmerq6vS3v/1NEydO/MK5ubm5kqRTp05Jklwul7q6uoLmXF2+1nMMNptNdrs9qAEAgOEVUkgIBAIqKyvTzp07deDAAU2aNOm667S0tEiSUlNTJUlut1utra3q7u625tTX18tutysrKyuUcgAAwDAK6XaDx+NRbW2t3n77bSUkJFjPEDgcDo0bN06nT59WbW2tFixYoOTkZB0/flwrV67U/fffr+zsbElSfn6+srKytGjRIm3evFler1dr1qyRx+ORzWYL/xECAIBBCelKQnV1tXp6ejRnzhylpqZa7Y033pAkxcXFad++fcrPz9eUKVP0ox/9SMXFxdq1a5e1jZiYGNXV1SkmJkZut1s/+MEPtHjx4qDfVQAAAJEX0pWEQCDwhePp6elqaGi47nYyMzP1zjvvhLJrAAAwwvh2AwAAMCIkAAAAI0ICAAAwIiQAAAAjQgIAADAiJAAAACNCAgAAMCIkAAAAI0ICAAAwIiQAAAAjQgIAADAiJAAAACNCAgAAMCIkAAAAI0ICAAAwIiQAAAAjQgIAADAiJAAAACNCAgAAMCIkAAAAI0ICAAAwIiQAAAAjQgIAADAiJAAAACNCAgAAMCIkAAAAo5BCQmVlpe655x4lJCQoJSVFDz/8sNra2oLmXLp0SR6PR8nJyZowYYKKi4vV1dUVNKe9vV1FRUWKj49XSkqKVq1apStXrgz9aAAAQNiEFBIaGhrk8XjU1NSk+vp6Xb58Wfn5+ert7bXmrFy5Urt27dKbb76phoYGnT17Vo888og13t/fr6KiIvX19enw4cN67bXXVFNTo7Vr14bvqAAAwJDFhjJ59+7dQcs1NTVKSUlRc3Oz7r//fvX09Gjr1q2qra3V3LlzJUnbtm3T1KlT1dTUpNmzZ2vv3r06efKk9u3bJ6fTqZkzZ2rjxo1avXq11q9fr7i4uPAdHQAAGLQhPZPQ09MjSUpKSpIkNTc36/Lly8rLy7PmTJkyRRkZGWpsbJQkNTY2avr06XI6ndacgoIC+Xw+nThxwrgfv98vn88X1AAAwPAadEgYGBjQihUrdO+992ratGmSJK/Xq7i4OCUmJgbNdTqd8nq91pz/DghXx6+OmVRWVsrhcFgtPT19sGUDAIAvadAhwePx6MMPP9SOHTvCWY9RRUWFenp6rNbR0THs+wQA4OsupGcSriorK1NdXZ0OHTqkiRMnWv0ul0t9fX06f/580NWErq4uuVwua877778ftL2rbz9cnfNZNptNNpttMKUCAIBBCulKQiAQUFlZmXbu3KkDBw5o0qRJQeM5OTkaM2aM9u/fb/W1tbWpvb1dbrdbkuR2u9Xa2qru7m5rTn19vex2u7KysoZyLAAAIIxCupLg8XhUW1urt99+WwkJCdYzBA6HQ+PGjZPD4dCSJUtUXl6upKQk2e12Pfnkk3K73Zo9e7YkKT8/X1lZWVq0aJE2b94sr9erNWvWyOPxcLUAAIBRJKSQUF1dLUmaM2dOUP+2bdv0+OOPS5K2bNmi6OhoFRcXy+/3q6CgQC+//LI1NyYmRnV1dVq+fLncbrfGjx+v0tJSbdiwYWhHAgAAwiqkkBAIBK47Z+zYsaqqqlJVVdU152RmZuqdd94JZdcAAGCE8e0GAABgREgAAABGhAQAAGBESAAAAEaEBAAAYERIAAAARoQEAABgREgAAABGhAQAAGBESAAAAEaEBAAAYERIAAAARoQEAABgREgAAABGhAQAAGBESAAAAEaEBAAAYERIAAAARoQEAABgREgAAABGhAQAAGBESAAAAEaEBAAAYERIAAAARoQEAABgFHJIOHTokBYuXKi0tDRFRUXprbfeChp//PHHFRUVFdTmz58fNOfcuXMqKSmR3W5XYmKilixZoosXLw7tSAAAQFiFHBJ6e3s1Y8YMVVVVXXPO/Pnz1dnZabU//vGPQeMlJSU6ceKE6uvrVVdXp0OHDmnZsmWhVw8AAIZNbKgrFBYWqrCw8Avn2Gw2uVwu49g///lP7d69W0ePHtWsWbMkSb/61a+0YMECPf/880pLSwu1JAAAMAyG5ZmEgwcPKiUlRZMnT9by5cv1ySefWGONjY1KTEy0AoIk5eXlKTo6WkeOHDFuz+/3y+fzBTUAADC8wh4S5s+fr9dff1379+/XL37xCzU0NKiwsFD9/f2SJK/Xq5SUlKB1YmNjlZSUJK/Xa9xmZWWlHA6H1dLT08NdNgAA+IyQbzdcz6OPPmr9PX36dGVnZ+u2227TwYMHNW/evEFts6KiQuXl5dayz+cjKAAAMMyG/RXIW2+9VTfffLNOnTolSXK5XOru7g6ac+XKFZ07d+6azzHYbDbZ7fagBgAAhtewh4SPP/5Yn3zyiVJTUyVJbrdb58+fV3NzszXnwIEDGhgYUG5u7nCXAwAAvqSQbzdcvHjRuiogSWfOnFFLS4uSkpKUlJSk5557TsXFxXK5XDp9+rSeeeYZ3X777SooKJAkTZ06VfPnz9fSpUv1yiuv6PLlyyorK9Ojjz7Kmw0AAIwiIV9JOHbsmO6++27dfffdkqTy8nLdfffdWrt2rWJiYnT8+HE9+OCDuvPOO7VkyRLl5OTo73//u2w2m7WN7du3a8qUKZo3b54WLFig++67T7/5zW/Cd1QAAGDIQr6SMGfOHAUCgWuO79mz57rbSEpKUm1tbai7BgAAI4hvNwAAACNCAgAAMCIkAAAAI0ICAAAwIiQAAAAjQgIAADAiJAAAACNCAgAAMCIkAAAAI0ICAAAwIiQAAAAjQgIAADAiJAAAACNCAgAAMCIkAAAAI0ICAAAwIiQAAAAjQgIAADAiJAAAACNCAgAAMCIkAAAAI0ICAAAwIiQAAAAjQgIAADAiJAAAACNCAgAAMAo5JBw6dEgLFy5UWlqaoqKi9NZbbwWNBwIBrV27VqmpqRo3bpzy8vL00UcfBc05d+6cSkpKZLfblZiYqCVLlujixYtDOxIAABBWIYeE3t5ezZgxQ1VVVcbxzZs366WXXtIrr7yiI0eOaPz48SooKNClS5esOSUlJTpx4oTq6+tVV1enQ4cOadmyZYM/CgAAEHaxoa5QWFiowsJC41ggENALL7ygNWvW6KGHHpIkvf7663I6nXrrrbf06KOP6p///Kd2796to0ePatasWZKkX/3qV1qwYIGef/55paWlDeFwAABAuIT1mYQzZ87I6/UqLy/P6nM4HMrNzVVjY6MkqbGxUYmJiVZAkKS8vDxFR0fryJEjxu36/X75fL6gBgAAhldYQ4LX65UkOZ3OoH6n02mNeb1epaSkBI3HxsYqKSnJmvNZlZWVcjgcVktPTw9n2QAAwOCGeLuhoqJCPT09Vuvo6Ih0SQAAfOWFNSS4XC5JUldXV1B/V1eXNeZyudTd3R00fuXKFZ07d86a81k2m012uz2oAQCA4RXWkDBp0iS5XC7t37/f6vP5fDpy5Ijcbrckye126/z582pubrbmHDhwQAMDA8rNzQ1nOQAAYAhCfrvh4sWLOnXqlLV85swZtbS0KCkpSRkZGVqxYoV++tOf6o477tCkSZP07LPPKi0tTQ8//LAkaerUqZo/f76WLl2qV155RZcvX1ZZWZkeffRR3mwAAGAUCTkkHDt2TN/97net5fLycklSaWmpampq9Mwzz6i3t1fLli3T+fPndd9992n37t0aO3astc727dtVVlamefPmKTo6WsXFxXrppZfCcDgAACBcQg4Jc+bMUSAQuOZ4VFSUNmzYoA0bNlxzTlJSkmpra0PdNQAAGEE3xNsNAABg5BESAACAESEBAAAYERIAAIARIQEAABgREgAAgBEhAQAAGBESAACAESEBAAAYERIAAIARIQEAABgREgAAgBEhAQAAGBESAACAESEBAAAYERIAAIARIQEAABgREgAAgBEhAQAAGBESAACAESEBAAAYERIAAIARIQEAABgREgAAgBEhAQAAGBESAACAUdhDwvr16xUVFRXUpkyZYo1funRJHo9HycnJmjBhgoqLi9XV1RXuMgAAwBANy5WEu+66S52dnVZ77733rLGVK1dq165devPNN9XQ0KCzZ8/qkUceGY4yAADAEMQOy0ZjY+VyuT7X39PTo61bt6q2tlZz586VJG3btk1Tp05VU1OTZs+ePRzlAACAQRiWKwkfffSR0tLSdOutt6qkpETt7e2SpObmZl2+fFl5eXnW3ClTpigjI0ONjY3X3J7f75fP5wtqAABgeIU9JOTm5qqmpka7d+9WdXW1zpw5o29/+9u6cOGCvF6v4uLilJiYGLSO0+mU1+u95jYrKyvlcDislp6eHu6yAQDAZ4T9dkNhYaH1d3Z2tnJzc5WZmak//elPGjdu3KC2WVFRofLycmvZ5/MRFAAAGGbD/gpkYmKi7rzzTp06dUoul0t9fX06f/580Jyuri7jMwxX2Ww22e32oAYAAIbXsIeEixcv6vTp00pNTVVOTo7GjBmj/fv3W+NtbW1qb2+X2+0e7lIAAEAIwn674emnn9bChQuVmZmps2fPat26dYqJidFjjz0mh8OhJUuWqLy8XElJSbLb7XryySfldrt5swEAgFEm7CHh448/1mOPPaZPPvlEt9xyi+677z41NTXplltukSRt2bJF0dHRKi4ult/vV0FBgV5++eVwlwEAAIYo7CFhx44dXzg+duxYVVVVqaqqKty7BgAAYcS3GwAAgBEhAQAAGBESAACAESEBAAAYERIAAIARIQEAABgREgAAgBEhAQAAGBESAACAESEBAAAYERIAAIARIQEAABgREgAAgBEhAQAAGBESAACAESEBAAAYERIAAIARIQEAABgREgAAgBEhAQAAGBESAACAESEBAAAYERIAAIARIQEAABgREgAAgBEhAQAAGEUsJFRVVekb3/iGxo4dq9zcXL3//vuRKgUAABhEJCS88cYbKi8v17p16/TBBx9oxowZKigoUHd3dyTKAQAABrGR2Okvf/lLLV26VD/84Q8lSa+88or++te/6ve//71+/OMff26+3++X3++3lnt6eiRJPp8vrHUN+D8N6/ZGs8Geu6/LORrKf1uco+vjHF0f5+j6OEdD214gELj+5MAI8/v9gZiYmMDOnTuD+hcvXhx48MEHjeusW7cuIIlGo9FoNFqYWkdHx3X/zR7xKwn/+c9/1N/fL6fTGdTvdDr1r3/9y7hORUWFysvLreWBgQGdO3dOycnJioqKGtZ6h5PP51N6ero6Ojpkt9sjXc6oxDm6Ps7R9XGOro9zdH1flXMUCAR04cIFpaWlXXduRG43hMpms8lmswX1JSYmRqia8LPb7Tf0f3AjgXN0fZyj6+McXR/n6Pq+CufI4XB8qXkj/uDizTffrJiYGHV1dQX1d3V1yeVyjXQ5AADgGkY8JMTFxSknJ0f79++3+gYGBrR//3653e6RLgcAAFxDzPr169eP9E7tdrueffZZpaeny2az6dlnn1VLS4u2bt2qCRMmjHQ5ERUTE6M5c+YoNvaGuPMTEZyj6+McXR/n6Po4R9f3dTtHUYHAl3kHIvx+/etf63/+53/k9Xo1c+ZMvfTSS8rNzY1EKQAAwCBiIQEAAIxufLsBAAAYERIAAIARIQEAABgREgAAgBEhIYL4XPa1HTp0SAsXLlRaWpqioqL01ltvRbqkUaeyslL33HOPEhISlJKSoocfflhtbW2RLmtUqa6uVnZ2tvULeW63W++++26kyxq1Nm3apKioKK1YsSLSpYwa69evV1RUVFCbMmVKpMsaMYSECOFz2V+st7dXM2bMUFVVVaRLGbUaGhrk8XjU1NSk+vp6Xb58Wfn5+ert7Y10aaPGxIkTtWnTJjU3N+vYsWOaO3euHnroIZ04cSLSpY06R48e1auvvqrs7OxIlzLq3HXXXers7LTae++9F+mSRs5Qv+qIwfnWt74V8Hg81nJ/f38gLS0tUFlZGcGqRidJn/tqKD6vu7s7ICnQ0NAQ6VJGtZtuuinwu9/9LtJljCoXLlwI3HHHHYH6+vrAd77zncBTTz0V6ZJGjXXr1gVmzJgR6TIihisJEdDX16fm5mbl5eVZfdHR0crLy1NjY2MEK8ONrKenR5KUlJQU4UpGp/7+fu3YsUO9vb38BPxneDweFRUVBf0/Cf/fRx99pLS0NN16660qKSlRe3t7pEsaMV+P35UcZQbzuWzgiwwMDGjFihW69957NW3atEiXM6q0trbK7Xbr0qVLmjBhgnbu3KmsrKxIlzVq7NixQx988IGOHj0a6VJGpdzcXNXU1Gjy5Mnq7OzUc889p//57BcAAAKVSURBVG9/+9v68MMPlZCQEOnyhh0hAfgK8Hg8+vDDD79e90q/pMmTJ6ulpUU9PT3685//rNLSUjU0NBAUJHV0dOipp55SfX29xo4dG+lyRqXCwkLr7+zsbOXm5iozM1N/+tOftGTJkghWNjIICRHA57IRTmVlZaqrq9OhQ4c0ceLESJcz6sTFxen222+XJOXk5Ojo0aN68cUX9eqrr0a4sshrbm5Wd3e3vvnNb1p9/f39OnTokH7961/L7/crJiYmghWOPomJibrzzjt16tSpSJcyIngmIQL4XDbCIRAIqKysTDt37tSBAwc0adKkSJd0QxgYGJDf7490GaPCvHnz1NraqpaWFqvNmjVLJSUlamlpISAYXLx4UadPn1ZqamqkSxkRXEmIkPLycpWWlmrWrFn61re+pRdeeEG9vb364Q9/GOnSRoWLFy8GJfUzZ86opaVFSUlJysjIiGBlo4fH41Ftba3efvttJSQkyOv1SpIcDofGjRsX4epGh4qKChUWFiojI0MXLlxQbW2tDh48qD179kS6tFEhISHhc8+wjB8/XsnJyTzb8v88/fTTWrhwoTIzM3X27FmtW7dOMTExeuyxxyJd2oggJETI9773Pf373//W2rVrrc9l7969+3MPM35dHTt2TN/97net5fLycklSaWmpampqIlTV6FJdXS1JmjNnTlD/tm3b9Pjjj498QaNQd3e3Fi9erM7OTjkcDmVnZ2vPnj164IEHIl0abhAff/yxHnvsMX3yySe65ZZbdN9996mpqUm33HJLpEsbEXwqGgAAGPFMAgAAMCIkAAAAI0ICAAAwIiQAAAAjQgIAADAiJAAAACNCAgAAMCIkAAAAI0ICAAAwIiQAAAAjQgIAADD6P0KeXLOxJKgDAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 600x400 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAgkAAAFZCAYAAAASBLySAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAAPYQAAD2EBqD+naQAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3de2xUdf7/8Vdb6HDrTLdAO20oFUWBCgW3aJkV3QqVUipirIkgC9U0sJKpEboqdoPc3FhEs+KlgptlQRO6eIlgqAIWkLKEglC3oaASIWyKaad1IXSghgHa+f7x+3G+39EP4rTTTtHnIzlJ55zPzLznxMgzc43w+/1+AQAA/EBkuAcAAADdE5EAAACMiAQAAGBEJAAAACMiAQAAGBEJAADAiEgAAABGPcI9QHu0tbWpvr5eMTExioiICPc4AABcN/x+v86dO6ekpCRFRv70cwXXZSTU19crOTk53GMAAHDdOnXqlAYNGvSTa67LSIiJiZH0/x6g3W4P8zQAAFw/vF6vkpOTrX9Lf8p1GQlXXmKw2+1EAgAA7fBzXq7njYsAAMCISAAAAEZEAgAAMCISAACAEZEAAACMiAQAAGBEJAAAACMiAQAAGBEJAADAiEgAAABGQUXC6tWrlZaWZn0dssvl0tatW63jmZmZioiICNgef/zxgNuoq6tTbm6u+vTpo/j4eD399NO6fPlyaB4NAAAImaB+u2HQoEFasWKFbr75Zvn9fr399tuaNm2a/v3vf+vWW2+VJM2ZM0fLly+3rtOnTx/r79bWVuXm5srpdGrfvn1qaGjQ7Nmz1bNnT73wwgshekgAACAUIvx+v78jNxAXF6eXXnpJBQUFyszM1JgxY7Rq1Srj2q1bt+q+++5TfX29EhISJElr1qzRwoUL9d133yk6Ovpn3afX65XD4VBzczM/8ATgF+mGZz8O9whd4j8rcsM9wq9OMP+Gtvs9Ca2trdq4caNaWlrkcrms/Rs2bNCAAQM0cuRIFRcX6/vvv7eOVVVVadSoUVYgSFJ2dra8Xq+OHj161fvy+Xzyer0BGwAA6FxB/1R0bW2tXC6XLly4oH79+mnTpk1KTU2VJD3yyCNKSUlRUlKSDh8+rIULF+rYsWP68MMPJUkejycgECRZlz0ez1Xvs6SkRMuWLQt2VAAA0AFBR8KwYcNUU1Oj5uZmffDBB8rPz1dlZaVSU1M1d+5ca92oUaOUmJioiRMn6sSJE7rpppvaPWRxcbGKioqsy16vV8nJye2+PQAAcG1Bv9wQHR2toUOHKj09XSUlJRo9erReffVV49qMjAxJ0vHjxyVJTqdTjY2NAWuuXHY6nVe9T5vNZn2i4soGAAA6V4e/J6GtrU0+n894rKamRpKUmJgoSXK5XKqtrVVTU5O1pqKiQna73XrJAgAAdA9BvdxQXFysnJwcDR48WOfOnVNZWZl2796t7du368SJEyorK9OUKVPUv39/HT58WAsWLNDdd9+ttLQ0SdKkSZOUmpqqWbNmaeXKlfJ4PFq0aJHcbrdsNlunPEAAANA+QUVCU1OTZs+erYaGBjkcDqWlpWn79u269957derUKe3YsUOrVq1SS0uLkpOTlZeXp0WLFlnXj4qKUnl5uebNmyeXy6W+ffsqPz8/4HsVAABA99Dh70kIB74nAcAvHd+TgM7SJd+TAAAAftmIBAAAYEQkAAAAo6C/TAkAgO6A9210Pp5JAAAARkQCAAAwIhIAAIARkQAAAIyIBAAAYEQkAAAAIyIBAAAYEQkAAMCISAAAAEZEAgAAMCISAACAEZEAAACMiAQAAGBEJAAAACMiAQAAGBEJAADAiEgAAABGRAIAADAiEgAAgBGRAAAAjIgEAABgRCQAAAAjIgEAABgRCQAAwIhIAAAARkQCAAAwCioSVq9erbS0NNntdtntdrlcLm3dutU6fuHCBbndbvXv31/9+vVTXl6eGhsbA26jrq5Oubm56tOnj+Lj4/X000/r8uXLoXk0AAAgZIKKhEGDBmnFihWqrq7WoUOHNGHCBE2bNk1Hjx6VJC1YsEBbtmzR+++/r8rKStXX1+vBBx+0rt/a2qrc3FxdvHhR+/bt09tvv63169dr8eLFoX1UAACgwyL8fr+/IzcQFxenl156SQ899JAGDhyosrIyPfTQQ5Kkr7/+WiNGjFBVVZXGjRunrVu36r777lN9fb0SEhIkSWvWrNHChQv13XffKTo6+mfdp9frlcPhUHNzs+x2e0fGB4Bu6YZnPw73CF3iPyty231dzlH7BPNvaLvfk9Da2qqNGzeqpaVFLpdL1dXVunTpkrKysqw1w4cP1+DBg1VVVSVJqqqq0qhRo6xAkKTs7Gx5vV7r2QgTn88nr9cbsAEAgM4VdCTU1taqX79+stlsevzxx7Vp0yalpqbK4/EoOjpasbGxAesTEhLk8XgkSR6PJyAQrhy/cuxqSkpK5HA4rC05OTnYsQEAQJB6BHuFYcOGqaamRs3Nzfrggw+Un5+vysrKzpjNUlxcrKKiIuuy1+vtlFD4tTx1JYX+6SsAwC9P0JEQHR2toUOHSpLS09N18OBBvfrqq3r44Yd18eJFnT17NuDZhMbGRjmdTkmS0+nU559/HnB7Vz79cGWNic1mk81mC3ZUAADQAR3+noS2tjb5fD6lp6erZ8+e2rlzp3Xs2LFjqqurk8vlkiS5XC7V1taqqanJWlNRUSG73a7U1NSOjgIAAEIoqGcSiouLlZOTo8GDB+vcuXMqKyvT7t27tX37djkcDhUUFKioqEhxcXGy2+164okn5HK5NG7cOEnSpEmTlJqaqlmzZmnlypXyeDxatGiR3G43zxQAANDNBBUJTU1Nmj17thoaGuRwOJSWlqbt27fr3nvvlSS98sorioyMVF5ennw+n7Kzs/Xmm29a14+KilJ5ebnmzZsnl8ulvn37Kj8/X8uXLw/towIAAB0WVCSsXbv2J4/36tVLpaWlKi0tveqalJQUffLJJ8HcLQAACAN+uwEAABgRCQAAwIhIAAAARkQCAAAwIhIAAIARkQAAAIyIBAAAYEQkAAAAIyIBAAAYEQkAAMCISAAAAEZEAgAAMCISAACAEZEAAACMiAQAAGBEJAAAACMiAQAAGBEJAADAiEgAAABGRAIAADAiEgAAgBGRAAAAjIgEAABgRCQAAAAjIgEAABgRCQAAwIhIAAAARkQCAAAwIhIAAIARkQAAAIx6BLO4pKREH374ob7++mv17t1bv/vd7/Tiiy9q2LBh1prMzExVVlYGXO+Pf/yj1qxZY12uq6vTvHnz9Nlnn6lfv37Kz89XSUmJevQIahwA16kbnv043CN0if+syA33CECHBPWvcmVlpdxut26//XZdvnxZf/7znzVp0iR9+eWX6tu3r7Vuzpw5Wr58uXW5T58+1t+tra3Kzc2V0+nUvn371NDQoNmzZ6tnz5564YUXQvCQAABAKAQVCdu2bQu4vH79esXHx6u6ulp33323tb9Pnz5yOp3G2/j000/15ZdfaseOHUpISNCYMWP0/PPPa+HChVq6dKmio6Pb8TAAAECodeg9Cc3NzZKkuLi4gP0bNmzQgAEDNHLkSBUXF+v777+3jlVVVWnUqFFKSEiw9mVnZ8vr9ero0aPG+/H5fPJ6vQEbAADoXO1+E0BbW5vmz5+vO++8UyNHjrT2P/LII0pJSVFSUpIOHz6shQsX6tixY/rwww8lSR6PJyAQJFmXPR6P8b5KSkq0bNmy9o4KAADaod2R4Ha7deTIEe3duzdg/9y5c62/R40apcTERE2cOFEnTpzQTTfd1K77Ki4uVlFRkXXZ6/UqOTm5fYMDAICfpV0vNxQWFqq8vFyfffaZBg0a9JNrMzIyJEnHjx+XJDmdTjU2NgasuXL5au9jsNlsstvtARsAAOhcQUWC3+9XYWGhNm3apF27dmnIkCHXvE5NTY0kKTExUZLkcrlUW1urpqYma01FRYXsdrtSU1ODGQcAAHSioF5ucLvdKisr00cffaSYmBjrPQQOh0O9e/fWiRMnVFZWpilTpqh///46fPiwFixYoLvvvltpaWmSpEmTJik1NVWzZs3SypUr5fF4tGjRIrndbtlsttA/QgAA0C5BPZOwevVqNTc3KzMzU4mJidb27rvvSpKio6O1Y8cOTZo0ScOHD9ef/vQn5eXlacuWLdZtREVFqby8XFFRUXK5XPrDH/6g2bNnB3yvAgAACL+gnknw+/0/eTw5OflH37ZokpKSok8++SSYuwYAAF2M324AAABGRAIAADAiEgAAgBE/u4ig8Ot9APDrwTMJAADAiEgAAABGRAIAADAiEgAAgBGRAAAAjIgEAABgRCQAAAAjIgEAABgRCQAAwIhIAAAARkQCAAAw4rcbgBDj9y0A/FLwTAIAADAiEgAAgBGRAAAAjIgEAABgRCQAAAAjIgEAABgRCQAAwIhIAAAARkQCAAAwIhIAAIARkQAAAIyIBAAAYEQkAAAAIyIBAAAYBRUJJSUluv322xUTE6P4+Hg98MADOnbsWMCaCxcuyO12q3///urXr5/y8vLU2NgYsKaurk65ubnq06eP4uPj9fTTT+vy5csdfzQAACBkgoqEyspKud1u7d+/XxUVFbp06ZImTZqklpYWa82CBQu0ZcsWvf/++6qsrFR9fb0efPBB63hra6tyc3N18eJF7du3T2+//bbWr1+vxYsXh+5RAQCADusRzOJt27YFXF6/fr3i4+NVXV2tu+++W83NzVq7dq3Kyso0YcIESdK6des0YsQI7d+/X+PGjdOnn36qL7/8Ujt27FBCQoLGjBmj559/XgsXLtTSpUsVHR39o/v1+Xzy+XzWZa/X257HCgAAgtCh9yQ0NzdLkuLi4iRJ1dXVunTpkrKysqw1w4cP1+DBg1VVVSVJqqqq0qhRo5SQkGCtyc7Oltfr1dGjR433U1JSIofDYW3JyckdGRsAAPwM7Y6EtrY2zZ8/X3feeadGjhwpSfJ4PIqOjlZsbGzA2oSEBHk8HmvN/w2EK8evHDMpLi5Wc3OztZ06daq9YwMAgJ8pqJcb/i+3260jR45o7969oZzHyGazyWazdfr9AACA/9WuZxIKCwtVXl6uzz77TIMGDbL2O51OXbx4UWfPng1Y39jYKKfTaa354acdrly+sgYAAIRfUJHg9/tVWFioTZs2adeuXRoyZEjA8fT0dPXs2VM7d+609h07dkx1dXVyuVySJJfLpdraWjU1NVlrKioqZLfblZqa2pHHAgAAQiiolxvcbrfKysr00UcfKSYmxnoPgcPhUO/eveVwOFRQUKCioiLFxcXJbrfriSeekMvl0rhx4yRJkyZNUmpqqmbNmqWVK1fK4/Fo0aJFcrvdvKQAAEA3ElQkrF69WpKUmZkZsH/dunV69NFHJUmvvPKKIiMjlZeXJ5/Pp+zsbL355pvW2qioKJWXl2vevHlyuVzq27ev8vPztXz58o49EgAAEFJBRYLf77/mml69eqm0tFSlpaVXXZOSkqJPPvkkmLsGAABdjN9uAAAARkQCAAAwIhIAAIARkQAAAIyIBAAAYEQkAAAAIyIBAAAYEQkAAMCISAAAAEZEAgAAMCISAACAEZEAAACMiAQAAGBEJAAAACMiAQAAGBEJAADAiEgAAABGRAIAADAiEgAAgBGRAAAAjIgEAABgRCQAAAAjIgEAABgRCQAAwIhIAAAARkQCAAAwIhIAAIARkQAAAIyIBAAAYBR0JOzZs0dTp05VUlKSIiIitHnz5oDjjz76qCIiIgK2yZMnB6w5c+aMZs6cKbvdrtjYWBUUFOj8+fMdeyQAACCkgo6ElpYWjR49WqWlpVddM3nyZDU0NFjbP//5z4DjM2fO1NGjR1VRUaHy8nLt2bNHc+fODX56AADQaXoEe4WcnBzl5OT85BqbzSan02k89tVXX2nbtm06ePCgxo4dK0l6/fXXNWXKFL388stKSkoKdiQAANAJOuU9Cbt371Z8fLyGDRumefPm6fTp09axqqoqxcbGWoEgSVlZWYqMjNSBAweMt+fz+eT1egM2AADQuUIeCZMnT9Y777yjnTt36sUXX1RlZaVycnLU2toqSfJ4PIqPjw+4To8ePRQXFyePx2O8zZKSEjkcDmtLTk4O9dgAAOAHgn654VqmT59u/T1q1CilpaXppptu0u7duzVx4sR23WZxcbGKioqsy16vl1AAAKCTdfpHIG+88UYNGDBAx48flyQ5nU41NTUFrLl8+bLOnDlz1fcx2Gw22e32gA0AAHSuTo+Eb7/9VqdPn1ZiYqIkyeVy6ezZs6qurrbW7Nq1S21tbcrIyOjscQAAwM8U9MsN58+ft54VkKSTJ0+qpqZGcXFxiouL07Jly5SXlyen06kTJ07omWee0dChQ5WdnS1JGjFihCZPnqw5c+ZozZo1unTpkgoLCzV9+nQ+2QAAQDcS9DMJhw4d0m233abbbrtNklRUVKTbbrtNixcvVlRUlA4fPqz7779ft9xyiwoKCpSenq5//etfstls1m1s2LBBw4cP18SJEzVlyhSNHz9ef/vb30L3qAAAQIcF/UxCZmam/H7/VY9v3779mrcRFxensrKyYO8aAAB0IX67AQAAGBEJAADAiEgAAABGRAIAADAiEgAAgBGRAAAAjIgEAABgRCQAAAAjIgEAABgRCQAAwIhIAAAARkQCAAAwIhIAAIARkQAAAIyIBAAAYEQkAAAAIyIBAAAYEQkAAMCISAAAAEZEAgAAMCISAACAEZEAAACMiAQAAGBEJAAAACMiAQAAGBEJAADAiEgAAABGRAIAADAiEgAAgBGRAAAAjIKOhD179mjq1KlKSkpSRESENm/eHHDc7/dr8eLFSkxMVO/evZWVlaVvvvkmYM2ZM2c0c+ZM2e12xcbGqqCgQOfPn+/YIwEAACEVdCS0tLRo9OjRKi0tNR5fuXKlXnvtNa1Zs0YHDhxQ3759lZ2drQsXLlhrZs6cqaNHj6qiokLl5eXas2eP5s6d2/5HAQAAQq5HsFfIyclRTk6O8Zjf79eqVau0aNEiTZs2TZL0zjvvKCEhQZs3b9b06dP11Vdfadu2bTp48KDGjh0rSXr99dc1ZcoUvfzyy0pKSurAwwEAAKES0vcknDx5Uh6PR1lZWdY+h8OhjIwMVVVVSZKqqqoUGxtrBYIkZWVlKTIyUgcOHDDers/nk9frDdgAAEDnCmkkeDweSVJCQkLA/oSEBOuYx+NRfHx8wPEePXooLi7OWvNDJSUlcjgc1pacnBzKsQEAgMF18emG4uJiNTc3W9upU6fCPRIAAL94IY0Ep9MpSWpsbAzY39jYaB1zOp1qamoKOH758mWdOXPGWvNDNptNdrs9YAMAAJ0rpJEwZMgQOZ1O7dy509rn9Xp14MABuVwuSZLL5dLZs2dVXV1trdm1a5fa2tqUkZERynEAAEAHBP3phvPnz+v48ePW5ZMnT6qmpkZxcXEaPHiw5s+fr7/85S+6+eabNWTIED333HNKSkrSAw88IEkaMWKEJk+erDlz5mjNmjW6dOmSCgsLNX36dD7ZAABANxJ0JBw6dEj33HOPdbmoqEiSlJ+fr/Xr1+uZZ55RS0uL5s6dq7Nnz2r8+PHatm2bevXqZV1nw4YNKiws1MSJExUZGam8vDy99tprIXg4AAAgVIKOhMzMTPn9/qsej4iI0PLly7V8+fKrromLi1NZWVmwdw0AALrQdfHpBgAA0PWIBAAAYEQkAAAAIyIBAAAYEQkAAMCISAAAAEZEAgAAMCISAACAEZEAAACMiAQAAGBEJAAAACMiAQAAGBEJAADAiEgAAABGRAIAADAiEgAAgBGRAAAAjIgEAABgRCQAAAAjIgEAABgRCQAAwIhIAAAARkQCAAAwIhIAAIARkQAAAIyIBAAAYEQkAAAAIyIBAAAYEQkAAMCISAAAAEYhj4SlS5cqIiIiYBs+fLh1/MKFC3K73erfv7/69eunvLw8NTY2hnoMAADQQZ3yTMKtt96qhoYGa9u7d691bMGCBdqyZYvef/99VVZWqr6+Xg8++GBnjAEAADqgR6fcaI8ecjqdP9rf3NystWvXqqysTBMmTJAkrVu3TiNGjND+/fs1bty4zhgHAAC0Q6c8k/DNN98oKSlJN954o2bOnKm6ujpJUnV1tS5duqSsrCxr7fDhwzV48GBVVVVd9fZ8Pp+8Xm/ABgAAOlfIIyEjI0Pr16/Xtm3btHr1ap08eVJ33XWXzp07J4/Ho+joaMXGxgZcJyEhQR6P56q3WVJSIofDYW3JycmhHhsAAPxAyF9uyMnJsf5OS0tTRkaGUlJS9N5776l3797tus3i4mIVFRVZl71eL6EAAEAn6/SPQMbGxuqWW27R8ePH5XQ6dfHiRZ09ezZgTWNjo/E9DFfYbDbZ7faADQAAdK5Oj4Tz58/rxIkTSkxMVHp6unr27KmdO3dax48dO6a6ujq5XK7OHgUAAAQh5C83PPXUU5o6dapSUlJUX1+vJUuWKCoqSjNmzJDD4VBBQYGKiooUFxcnu92uJ554Qi6Xi082AADQzYQ8Er799lvNmDFDp0+f1sCBAzV+/Hjt379fAwcOlCS98sorioyMVF5ennw+n7Kzs/Xmm2+GegwAANBBIY+EjRs3/uTxXr16qbS0VKWlpaG+awAAEEL8dgMAADAiEgAAgBGRAAAAjIgEAABgRCQAAAAjIgEAABgRCQAAwIhIAAAARkQCAAAwIhIAAIARkQAAAIyIBAAAYEQkAAAAIyIBAAAYEQkAAMCISAAAAEZEAgAAMCISAACAEZEAAACMiAQAAGBEJAAAACMiAQAAGBEJAADAiEgAAABGRAIAADAiEgAAgBGRAAAAjIgEAABgRCQAAAAjIgEAABiFLRJKS0t1ww03qFevXsrIyNDnn38erlEAAIBBWCLh3XffVVFRkZYsWaIvvvhCo0ePVnZ2tpqamsIxDgAAMOgRjjv961//qjlz5uixxx6TJK1Zs0Yff/yx/vGPf+jZZ5/90Xqfzyefz2ddbm5uliR5vd6QztXm+z6kt9edtffc/VrOUUf+2+IcXRvn6No4R9fGOerY7fn9/msv9ncxn8/nj4qK8m/atClg/+zZs/3333+/8TpLlizxS2JjY2NjY2ML0Xbq1Klr/pvd5c8k/Pe//1Vra6sSEhIC9ickJOjrr782Xqe4uFhFRUXW5ba2Np05c0b9+/dXREREp87bmbxer5KTk3Xq1CnZ7fZwj9MtcY6ujXN0bZyja+McXdsv5Rz5/X6dO3dOSUlJ11wblpcbgmWz2WSz2QL2xcbGhmma0LPb7df1f3BdgXN0bZyja+McXRvn6Np+CefI4XD8rHVd/sbFAQMGKCoqSo2NjQH7Gxsb5XQ6u3ocAABwFV0eCdHR0UpPT9fOnTutfW1tbdq5c6dcLldXjwMAAK4iaunSpUu7+k7tdruee+45JScny2az6bnnnlNNTY3Wrl2rfv36dfU4YRUVFaXMzEz16HFdvPITFpyja+McXRvn6No4R9f2aztHEX7/z/kMROi98cYbeumll+TxeDRmzBi99tprysjICMcoAADAIGyRAAAAujd+uwEAABgRCQAAwIhIAAAARkQCAAAwIhLCiJ/Lvro9e/Zo6tSpSkpKUkREhDZv3hzukbqdkpIS3X777YqJiVF8fLweeOABHTt2LNxjdSurV69WWlqa9Q15LpdLW7duDfdY3daKFSsUERGh+fPnh3uUbmPp0qWKiIgI2IYPHx7usboMkRAm/Fz2T2tpadHo0aNVWloa7lG6rcrKSrndbu3fv18VFRW6dOmSJk2apJaWlnCP1m0MGjRIK1asUHV1tQ4dOqQJEyZo2rRpOnr0aLhH63YOHjyot956S2lpaeEepdu59dZb1dDQYG179+4N90hdp6O/6oj2ueOOO/xut9u63Nra6k9KSvKXlJSEcaruSdKPfjUUP9bU1OSX5K+srAz3KN3ab37zG//f//73cI/RrZw7d85/8803+ysqKvy///3v/U8++WS4R+o2lixZ4h89enS4xwgbnkkIg4sXL6q6ulpZWVnWvsjISGVlZamqqiqMk+F61tzcLEmKi4sL8yTdU2trqzZu3KiWlha+Av4H3G63cnNzA/6fhP/1zTffKCkpSTfeeKNmzpypurq6cI/UZX4d3yvZzbTn57KBn9LW1qb58+frzjvv1MiRI8M9TrdSW1srl8ulCxcuqF+/ftq0aZNSU1PDPVa3sXHjRn3xxRc6ePBguEfpljIyMrR+/XoNGzZMDQ0NWrZsme666y4dOXJEMTEx4R6v0xEJwC+A2+3WkSNHfl2vlf5Mw4YNU01NjZqbm/XBBx8oPz9flZWVhIKkU6dO6cknn1RFRYV69eoV7nG6pZycHOvvtLQ0ZWRkKCUlRe+9954KCgrCOFnXIBLCgJ/LRigVFhaqvLxce/bs0aBBg8I9TrcTHR2toUOHSpLS09N18OBBvfrqq3rrrbfCPFn4VVdXq6mpSb/97W+tfa2trdqzZ4/eeOMN+Xw+RUVFhXHC7ic2Nla33HKLjh8/Hu5RugTvSQgDfi4boeD3+1VYWKhNmzZp165dGjJkSLhHui60tbXJ5/OFe4xuYeLEiaqtrVVNTY21jR07VjNnzlRNTQ2BYHD+/HmdOHFCiYmJ4R6lS/BMQpgUFRUpPz9fY8eO1R133KFVq1appaVFjz32WLhH6xbOnz8fUOonT55UTU2N4uLiNHjw4DBO1n243W6VlZXpo48+UkxMjDwejyTJ4XCod+/eYZ6ueyguLlZOTo4GDx6sc+fOqaysTLt379b27dvDPVq3EBMT86P3sPTt21f9+/fnvS3/31NPPaWpU6cqJSVF9fX1WrJkiaKiojRjxoxwj9YliIQwefjhh/Xdd99p8eLF1s9lb9u27UdvZvy1OnTokO655x7rclFRkSQpPz9f69evD9NU3cvq1aslSZmZmQH7161bp0cffbTrB+qGmpqaNHv2bDU0NMjhcCgtLU3bt2/XvffeG+7RcJ349ttvNWPGDJ0+fVoDBw7U+PHjtX//fg0cODDco3UJfioaAAAY8Z4EAABgRCQAAAAjIgEAABgRCQAAwIhIANKBgs4AAAApSURBVAAARkQCAAAwIhIAAIARkQAAAIyIBAAAYEQkAAAAIyIBAAAY/Q9OjYINNiQB0AAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 600x400 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "plt.bar(range(6), males[males.columns[3:9]].sum())\n",
    "plt.show()\n",
    "\n",
    "plt.bar(range(6), females[females.columns[3:9]].sum())\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Interestingly enough, more males watches episodes 1-3, but males liked them far less than females did."
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}