Projects/step_2/Course_6/Guided Project_Star Wars Survey.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Overview"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "While waiting for [Star Wars: The Force Awakens to come out](https://en.wikipedia.org/wiki/Star_Wars:_The_Force_Awakens), 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 bunch?\n",
    "\n",
    "The team needed to collect data addressing this question. To do this, they surveyed Star Wars fans using the online tool SurveyMonkey. They received 835 total responses, which you download from their [GitHub repository](https://github.com/fivethirtyeight/data/tree/master/star-wars-survey)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "star_wars = pd.read_csv(\"star_wars.csv\", encoding=\"utf-8\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "star_wars = star_wars[pd.notnull(star_wars[\"RespondentID\"])]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>1</th>\n",
       "      <td>3.292880e+09</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</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>2</th>\n",
       "      <td>3.292880e+09</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>3</th>\n",
       "      <td>3.292765e+09</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</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>4</th>\n",
       "      <td>3.292763e+09</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</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>5</th>\n",
       "      <td>3.292731e+09</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</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",
       "1  3.292880e+09                                                Yes             \n",
       "2  3.292880e+09                                                 No             \n",
       "3  3.292765e+09                                                Yes             \n",
       "4  3.292763e+09                                                Yes             \n",
       "5  3.292731e+09                                                Yes             \n",
       "\n",
       "  Do you consider yourself to be a fan of the Star Wars film franchise?  \\\n",
       "1                                                Yes                      \n",
       "2                                                NaN                      \n",
       "3                                                 No                      \n",
       "4                                                Yes                      \n",
       "5                                                Yes                      \n",
       "\n",
       "  Which of the following Star Wars films have you seen? Please select all that apply.  \\\n",
       "1           Star Wars: Episode I  The Phantom Menace                                    \n",
       "2                                                NaN                                    \n",
       "3           Star Wars: Episode I  The Phantom Menace                                    \n",
       "4           Star Wars: Episode I  The Phantom Menace                                    \n",
       "5           Star Wars: Episode I  The Phantom Menace                                    \n",
       "\n",
       "                                    Unnamed: 4  \\\n",
       "1  Star Wars: Episode II  Attack of the Clones   \n",
       "2                                          NaN   \n",
       "3  Star Wars: Episode II  Attack of the Clones   \n",
       "4  Star Wars: Episode II  Attack of the Clones   \n",
       "5  Star Wars: Episode II  Attack of the Clones   \n",
       "\n",
       "                                    Unnamed: 5  \\\n",
       "1  Star Wars: Episode III  Revenge of the Sith   \n",
       "2                                          NaN   \n",
       "3  Star Wars: Episode III  Revenge of the Sith   \n",
       "4  Star Wars: Episode III  Revenge of the Sith   \n",
       "5  Star Wars: Episode III  Revenge of the Sith   \n",
       "\n",
       "                          Unnamed: 6  \\\n",
       "1  Star Wars: Episode IV  A New Hope   \n",
       "2                                NaN   \n",
       "3                                NaN   \n",
       "4  Star Wars: Episode IV  A New Hope   \n",
       "5  Star Wars: Episode IV  A New Hope   \n",
       "\n",
       "                                     Unnamed: 7  \\\n",
       "1  Star Wars: Episode V The Empire Strikes Back   \n",
       "2                                           NaN   \n",
       "3                                           NaN   \n",
       "4  Star Wars: Episode V The Empire Strikes Back   \n",
       "5  Star Wars: Episode V The Empire Strikes Back   \n",
       "\n",
       "                                 Unnamed: 8  \\\n",
       "1  Star Wars: Episode VI Return of the Jedi   \n",
       "2                                       NaN   \n",
       "3                                       NaN   \n",
       "4  Star Wars: Episode VI Return of the Jedi   \n",
       "5  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",
       "1                                                  3                                                                                              \n",
       "2                                                NaN                                                                                              \n",
       "3                                                  1                                                                                              \n",
       "4                                                  5                                                                                              \n",
       "5                                                  5                                                                                              \n",
       "\n",
       "   ...         Unnamed: 28       Which character shot first?  \\\n",
       "1  ...      Very favorably  I don't understand this question   \n",
       "2  ...                 NaN                               NaN   \n",
       "3  ...    Unfamiliar (N/A)  I don't understand this question   \n",
       "4  ...      Very favorably  I don't understand this question   \n",
       "5  ...  Somewhat favorably                            Greedo   \n",
       "\n",
       "  Are you familiar with the Expanded Universe?  \\\n",
       "1                                          Yes   \n",
       "2                                          NaN   \n",
       "3                                           No   \n",
       "4                                           No   \n",
       "5                                          Yes   \n",
       "\n",
       "  Do you consider yourself to be a fan of the Expanded Universe?Œæ  \\\n",
       "1                                                 No                 \n",
       "2                                                NaN                 \n",
       "3                                                NaN                 \n",
       "4                                                NaN                 \n",
       "5                                                 No                 \n",
       "\n",
       "  Do you consider yourself to be a fan of the Star Trek franchise? Gender  \\\n",
       "1                                                 No                 Male   \n",
       "2                                                Yes                 Male   \n",
       "3                                                 No                 Male   \n",
       "4                                                Yes                 Male   \n",
       "5                                                 No                 Male   \n",
       "\n",
       "     Age     Household Income                         Education  \\\n",
       "1  18-29                  NaN                High school degree   \n",
       "2  18-29         $0 - $24,999                   Bachelor degree   \n",
       "3  18-29         $0 - $24,999                High school degree   \n",
       "4  18-29  $100,000 - $149,999  Some college or Associate degree   \n",
       "5  18-29  $100,000 - $149,999  Some college or Associate degree   \n",
       "\n",
       "  Location (Census Region)  \n",
       "1           South Atlantic  \n",
       "2       West South Central  \n",
       "3       West North Central  \n",
       "4       West North Central  \n",
       "5       West North Central  \n",
       "\n",
       "[5 rows x 38 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "star_wars.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "star_wars.columns"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Cleaning and Mapping Yes/No Columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>1</th>\n",
       "      <td>3.292880e+09</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</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>2</th>\n",
       "      <td>3.292880e+09</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>3</th>\n",
       "      <td>3.292765e+09</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</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>4</th>\n",
       "      <td>3.292763e+09</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</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>5</th>\n",
       "      <td>3.292731e+09</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</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",
       "1  3.292880e+09                                               True              \n",
       "2  3.292880e+09                                              False              \n",
       "3  3.292765e+09                                               True              \n",
       "4  3.292763e+09                                               True              \n",
       "5  3.292731e+09                                               True              \n",
       "\n",
       "  Do you consider yourself to be a fan of the Star Wars film franchise?  \\\n",
       "1                                               True                      \n",
       "2                                                NaN                      \n",
       "3                                              False                      \n",
       "4                                               True                      \n",
       "5                                               True                      \n",
       "\n",
       "  Which of the following Star Wars films have you seen? Please select all that apply.  \\\n",
       "1           Star Wars: Episode I  The Phantom Menace                                    \n",
       "2                                                NaN                                    \n",
       "3           Star Wars: Episode I  The Phantom Menace                                    \n",
       "4           Star Wars: Episode I  The Phantom Menace                                    \n",
       "5           Star Wars: Episode I  The Phantom Menace                                    \n",
       "\n",
       "                                    Unnamed: 4  \\\n",
       "1  Star Wars: Episode II  Attack of the Clones   \n",
       "2                                          NaN   \n",
       "3  Star Wars: Episode II  Attack of the Clones   \n",
       "4  Star Wars: Episode II  Attack of the Clones   \n",
       "5  Star Wars: Episode II  Attack of the Clones   \n",
       "\n",
       "                                    Unnamed: 5  \\\n",
       "1  Star Wars: Episode III  Revenge of the Sith   \n",
       "2                                          NaN   \n",
       "3  Star Wars: Episode III  Revenge of the Sith   \n",
       "4  Star Wars: Episode III  Revenge of the Sith   \n",
       "5  Star Wars: Episode III  Revenge of the Sith   \n",
       "\n",
       "                          Unnamed: 6  \\\n",
       "1  Star Wars: Episode IV  A New Hope   \n",
       "2                                NaN   \n",
       "3                                NaN   \n",
       "4  Star Wars: Episode IV  A New Hope   \n",
       "5  Star Wars: Episode IV  A New Hope   \n",
       "\n",
       "                                     Unnamed: 7  \\\n",
       "1  Star Wars: Episode V The Empire Strikes Back   \n",
       "2                                           NaN   \n",
       "3                                           NaN   \n",
       "4  Star Wars: Episode V The Empire Strikes Back   \n",
       "5  Star Wars: Episode V The Empire Strikes Back   \n",
       "\n",
       "                                 Unnamed: 8  \\\n",
       "1  Star Wars: Episode VI Return of the Jedi   \n",
       "2                                       NaN   \n",
       "3                                       NaN   \n",
       "4  Star Wars: Episode VI Return of the Jedi   \n",
       "5  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",
       "1                                                  3                                                                                              \n",
       "2                                                NaN                                                                                              \n",
       "3                                                  1                                                                                              \n",
       "4                                                  5                                                                                              \n",
       "5                                                  5                                                                                              \n",
       "\n",
       "   ...         Unnamed: 28       Which character shot first?  \\\n",
       "1  ...      Very favorably  I don't understand this question   \n",
       "2  ...                 NaN                               NaN   \n",
       "3  ...    Unfamiliar (N/A)  I don't understand this question   \n",
       "4  ...      Very favorably  I don't understand this question   \n",
       "5  ...  Somewhat favorably                            Greedo   \n",
       "\n",
       "  Are you familiar with the Expanded Universe?  \\\n",
       "1                                          Yes   \n",
       "2                                          NaN   \n",
       "3                                           No   \n",
       "4                                           No   \n",
       "5                                          Yes   \n",
       "\n",
       "  Do you consider yourself to be a fan of the Expanded Universe?Œæ  \\\n",
       "1                                                 No                 \n",
       "2                                                NaN                 \n",
       "3                                                NaN                 \n",
       "4                                                NaN                 \n",
       "5                                                 No                 \n",
       "\n",
       "  Do you consider yourself to be a fan of the Star Trek franchise? Gender  \\\n",
       "1                                                 No                 Male   \n",
       "2                                                Yes                 Male   \n",
       "3                                                 No                 Male   \n",
       "4                                                Yes                 Male   \n",
       "5                                                 No                 Male   \n",
       "\n",
       "     Age     Household Income                         Education  \\\n",
       "1  18-29                  NaN                High school degree   \n",
       "2  18-29         $0 - $24,999                   Bachelor degree   \n",
       "3  18-29         $0 - $24,999                High school degree   \n",
       "4  18-29  $100,000 - $149,999  Some college or Associate degree   \n",
       "5  18-29  $100,000 - $149,999  Some college or Associate degree   \n",
       "\n",
       "  Location (Census Region)  \n",
       "1           South Atlantic  \n",
       "2       West South Central  \n",
       "3       West North Central  \n",
       "4       West North Central  \n",
       "5       West North Central  \n",
       "\n",
       "[5 rows x 38 columns]"
      ]
     },
     "execution_count": 5,
     "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": [
    "# Cleaning and Mapping Checkbox Columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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": "markdown",
   "metadata": {},
   "source": [
    "# Cleaning the Ranking Columns"
   ]
  },
  {
   "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>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>1</th>\n",
       "      <td>3.292880e+09</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</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>2</th>\n",
       "      <td>3.292880e+09</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>3</th>\n",
       "      <td>3.292765e+09</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</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>4</th>\n",
       "      <td>3.292763e+09</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</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>5</th>\n",
       "      <td>3.292731e+09</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</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",
       "1  3.292880e+09                                               True              \n",
       "2  3.292880e+09                                              False              \n",
       "3  3.292765e+09                                               True              \n",
       "4  3.292763e+09                                               True              \n",
       "5  3.292731e+09                                               True              \n",
       "\n",
       "  Do you consider yourself to be a fan of the Star Wars film franchise?  \\\n",
       "1                                               True                      \n",
       "2                                                NaN                      \n",
       "3                                              False                      \n",
       "4                                               True                      \n",
       "5                                               True                      \n",
       "\n",
       "   seen_1  seen_2  seen_3  seen_4  seen_5  seen_6  \\\n",
       "1    True    True    True    True    True    True   \n",
       "2   False   False   False   False   False   False   \n",
       "3    True    True    True   False   False   False   \n",
       "4    True    True    True    True    True    True   \n",
       "5    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",
       "1                                                  3                                                                                              \n",
       "2                                                NaN                                                                                              \n",
       "3                                                  1                                                                                              \n",
       "4                                                  5                                                                                              \n",
       "5                                                  5                                                                                              \n",
       "\n",
       "   ...         Unnamed: 28       Which character shot first?  \\\n",
       "1  ...      Very favorably  I don't understand this question   \n",
       "2  ...                 NaN                               NaN   \n",
       "3  ...    Unfamiliar (N/A)  I don't understand this question   \n",
       "4  ...      Very favorably  I don't understand this question   \n",
       "5  ...  Somewhat favorably                            Greedo   \n",
       "\n",
       "  Are you familiar with the Expanded Universe?  \\\n",
       "1                                          Yes   \n",
       "2                                          NaN   \n",
       "3                                           No   \n",
       "4                                           No   \n",
       "5                                          Yes   \n",
       "\n",
       "  Do you consider yourself to be a fan of the Expanded Universe?Œæ  \\\n",
       "1                                                 No                 \n",
       "2                                                NaN                 \n",
       "3                                                NaN                 \n",
       "4                                                NaN                 \n",
       "5                                                 No                 \n",
       "\n",
       "  Do you consider yourself to be a fan of the Star Trek franchise? Gender  \\\n",
       "1                                                 No                 Male   \n",
       "2                                                Yes                 Male   \n",
       "3                                                 No                 Male   \n",
       "4                                                Yes                 Male   \n",
       "5                                                 No                 Male   \n",
       "\n",
       "     Age     Household Income                         Education  \\\n",
       "1  18-29                  NaN                High school degree   \n",
       "2  18-29         $0 - $24,999                   Bachelor degree   \n",
       "3  18-29         $0 - $24,999                High school degree   \n",
       "4  18-29  $100,000 - $149,999  Some college or Associate degree   \n",
       "5  18-29  $100,000 - $149,999  Some college or Associate degree   \n",
       "\n",
       "  Location (Census Region)  \n",
       "1           South Atlantic  \n",
       "2       West South Central  \n",
       "3       West North Central  \n",
       "4       West North Central  \n",
       "5       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",
    "        \"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": 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": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "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.    3.732934\n",
       "Unnamed: 10                                                                                                                                      4.087321\n",
       "Unnamed: 11                                                                                                                                      4.341317\n",
       "Unnamed: 12                                                                                                                                      3.272727\n",
       "Unnamed: 13                                                                                                                                      2.513158\n",
       "Unnamed: 14                                                                                                                                      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": "iVBORw0KGgoAAAANSUhEUgAAAWoAAAD4CAYAAADFAawfAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAAJ20lEQVR4nO3dT6jld3nH8c/TybRKtLjIpYRM6O2iBMSFkUu6CHQRbElNsF10YcCsLLOpEGlB4qp050rcuBk0tEUxSGOhJPRPwIQQ0OidGK1xtEhJaVCYKyI6m5bo4+KeqUm8yT3jPWfOc8+8XnDJOXN+c3h+DHnz5Xd/33OquwPAXL+x6QEAeHNCDTCcUAMMJ9QAwwk1wHA3reNNb7nllt7d3V3HWwNspYsXL/6wu3eOem0tod7d3c3+/v463hpgK1XVf7/Ray59AAwn1ADDCTXAcEINMJxQAwwn1ADDCTXAcEINMJxQAwy3lp2JbLfdh5/Y9AhLeenj9216BFgJK2qA4YQaYDihBhhOqAGGE2qA4YQaYDihBhhOqAGGE2qA4YQaYDihBhjOZ32smc/FAE5q6RV1VZ2pqq9X1ePrHAiA17qWSx8PJbm0rkEAONpSoa6qc0nuS/Lp9Y4DwOstu6L+ZJKPJvn5Gx1QVeerar+q9g8ODlYyHABLhLqq7k9yubsvvtlx3X2hu/e6e29nZ2dlAwLc6JZZUd+d5P1V9VKSR5PcU1WfXetUAPy/Y0Pd3R/r7nPdvZvkA0m+1N0fXPtkACSx4QVgvGva8NLdTyd5ei2TAHAkK2qA4YQaYDihBhhOqAGGE2qA4YQaYDihBhhu3BcH+KB9gNeyogYYTqgBhhNqgOGEGmA4oQYYTqgBhhNqgOGEGmA4oQYYTqgBhhNqgOGEGmA4oQYYTqgBhhNqgOGEGmA4oQYYTqgBhhNqgOGEGmA4oQYYbty3kMP15pvvmc6KGmA4oQYYTqgBhhNqgOGEGmA4oQYYTqgBhhNqgOGEGmC4Y3cmVtVbkjyT5LcWx/9jd//NugcDuOpG3z26zBby/01yT3dfqaqzSZ6tqn/p7q+sZSIAXuPYUHd3J7myeHp28dPrHAqAX1rqGnVVnamqF5JcTvJkdz93xDHnq2q/qvYPDg5WPSfADWupUHf3z7r73UnOJbmrqt51xDEXunuvu/d2dnZWPSfADeua7vro7h8neTrJvWuZBoBfcWyoq2qnqt6xePzWJO9N8p11DwbAoWXu+rg1yd9X1Zkchv0L3f34escC4Kpl7vr4ZpI7r8MsABzBzkSA4YQaYDihBhhOqAGGE2qA4YQaYDihBhhOqAGGE2qA4YQaYDihBhhOqAGGE2qA4YQaYDihBhhOqAGGE2qA4Zb5Ki7glNl9+IlNj7CUlz5+36ZHOBWsqAGGE2qA4YQaYDihBhhOqAGGE2qA4YQaYDihBhhOqAGGE2qA4YQaYDihBhhOqAGGE2qA4YQaYDihBhhOqAGGE2qA4YQaYDihBhju2FBX1e1V9VRVXaqqF6vqoesxGACHlvkW8leS/HV3P19Vb09ysaqe7O5vr3k2ALLEirq7f9Ddzy8e/zTJpSS3rXswAA5d0zXqqtpNcmeS54547XxV7VfV/sHBwWqmA2D5UFfV25I8luQj3f2T17/e3Re6e6+793Z2dlY5I8ANbalQV9XZHEb6c939xfWOBMCrLXPXRyX5TJJL3f2J9Y8EwKsts6K+O8mDSe6pqhcWP+9b81wALBx7e153P5ukrsMsABzBzkSA4YQaYDihBhhOqAGGE2qA4YQaYDihBhhOqAGGE2qA4YQaYDihBhhOqAGGE2qA4YQaYDihBhhOqAGGE2qA4YQaYDihBhhOqAGGE2qA4YQaYDihBhhOqAGGE2qA4YQaYDihBhhOqAGGE2qA4YQaYDihBhhOqAGGE2qA4YQaYDihBhhOqAGGE2qA4YQaYDihBhju2FBX1SNVdbmqvnU9BgLgtZZZUf9dknvXPAcAb+DYUHf3M0l+dB1mAeAIK7tGXVXnq2q/qvYPDg5W9bYAN7yVhbq7L3T3Xnfv7ezsrOptAW547voAGE6oAYZb5va8zyf5cpI7qurlqvrQ+scC4Kqbjjugux+4HoMAcDSXPgCGE2qA4YQaYDihBhhOqAGGE2qA4YQaYDihBhhOqAGGE2qA4YQaYDihBhhOqAGGE2qA4YQaYDihBhhOqAGGE2qA4YQaYDihBhhOqAGGE2qA4YQaYDihBhhOqAGGE2qA4YQaYDihBhhOqAGGE2qA4YQaYDihBhhOqAGGE2qA4YQaYDihBhhOqAGGE2qA4YQaYLilQl1V91bVd6vqe1X18LqHAuCXjg11VZ1J8qkkf5LknUkeqKp3rnswAA4ts6K+K8n3uvu/uvv/kjya5E/XOxYAV1V3v/kBVX+e5N7u/ovF8weT/EF3f/h1x51Pcn7x9I4k3139uL+2W5L8cNNDrNC2nU+yfee0beeTbN85TTuf3+3unaNeuGmJv1xH/Nmv1L27LyS5cI2DXRdVtd/de5ueY1W27XyS7TunbTufZPvO6TSdzzKXPl5Ocvurnp9L8v31jAPA6y0T6q8l+f2q+r2q+s0kH0jyz+sdC4Crjr300d2vVNWHk/xbkjNJHunuF9c+2WqNvCRzAtt2Psn2ndO2nU+yfed0as7n2F8mArBZdiYCDCfUAMNtdai3bet7VT1SVZer6lubnmUVqur2qnqqqi5V1YtV9dCmZzqpqnpLVX21qr6xOKe/3fRMq1BVZ6rq61X1+KZnWYWqeqmq/qOqXqiq/U3Pc5ytvUa92Pr+n0n+KIe3GH4tyQPd/e2NDnYCVfWHSa4k+Yfuftem5zmpqro1ya3d/XxVvT3JxSR/dsr/jSrJzd19parOJnk2yUPd/ZUNj3YiVfVXSfaS/HZ337/peU6qql5Kstfdkza8vKFtXlFv3db37n4myY82PceqdPcPuvv5xeOfJrmU5LbNTnUyfejK4unZxc+pXg1V1bkk9yX59KZnuVFtc6hvS/I/r3r+ck55BLZZVe0muTPJc5ud5OQWlwleSHI5yZPdfdrP6ZNJPprk55seZIU6yb9X1cXFx1+Mts2hXmrrO5tXVW9L8liSj3T3TzY9z0l198+6+9053MV7V1Wd2stUVXV/ksvdfXHTs6zY3d39nhx+KuhfLi4rjrXNobb1/RRYXMd9LMnnuvuLm55nlbr7x0meTnLvhkc5ibuTvH9xTffRJPdU1Wc3O9LJdff3F/+9nOSfcnipdKxtDrWt78MtfvH2mSSXuvsTm55nFapqp6resXj81iTvTfKdzU716+vuj3X3ue7ezeH/Q1/q7g9ueKwTqaqbF7+8TlXdnOSPk4y+k2prQ93dryS5uvX9UpIvnMKt769RVZ9P8uUkd1TVy1X1oU3PdEJ3J3kwh6u0FxY/79v0UCd0a5KnquqbOVwsPNndW3FL2xb5nSTPVtU3knw1yRPd/a8bnulNbe3teQDbYmtX1ADbQqgBhhNqgOGEGmA4oQYYTqgBhhNqgOF+AeNYG5raNfHFAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "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",
    "So far, we've cleaned up the data, renamed several columns, and computed the average ranking of each movie. As I suspected, it looks like the \"original\" movies are rated much more highly than the newer ones."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Finding the Most Viewed 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": "iVBORw0KGgoAAAANSUhEUgAAAXcAAAD4CAYAAAAXUaZHAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAAQWElEQVR4nO3df6jdd33H8edraa1aFdv1JmRJWDLIylLB1l0yR0E2ozZOMfnDwi0oYWRkf8RR2cAl/jP8I9C/xP2xDoK6ZegMd2ppUHBm0SKCa7yp8UeSZr2ztbkky71WRDshkvjeH/dbdpLc23uSc25P8unzAeH7/b7P53vO+0vp6375nO/3e1JVSJLa8lujbkCSNHyGuyQ1yHCXpAYZ7pLUIMNdkhp0y6gbALjrrrtq/fr1o25Dkm4qx44d+2lVjS302g0R7uvXr2dqamrUbUjSTSXJTxZ7zWkZSWqQ4S5JDTLcJalBhrskNchwl6QGGe6S1CDDXZIaZLhLUoMMd0lq0A1xh6qk0Vq/56ujbqEvzz3yvlG3cNPwzF2SGmS4S1KDDHdJapDhLkkN8gtVSU16tX9J7Jm7JDXIcJekBhnuktQgw12SGmS4S1KDDHdJatCS4Z7k7iTHe/79IslHk9yZ5HCSZ7rlHT377E0yneR0kgeW9xAkSVdaMtyr6nRV3VtV9wJ/CPwKeAzYAxypqo3AkW6bJJuACeAeYCvwaJIVy9S/JGkB1zotswX476r6CbANONDVDwDbu/VtwMGqulBVzwLTwOZhNCtJ6s+1hvsE8IVufVVVnQPoliu7+hrgTM8+M11NkvQK6Tvck7wG+ADwb0sNXaBWC7zfriRTSabm5ub6bUOS1IdrOXN/L/BUVZ3vts8nWQ3QLWe7+gywrme/tcDZK9+sqvZX1XhVjY+NjV1755KkRV1LuD/E/0/JABwCdnTrO4DHe+oTSW5LsgHYCBwdtFFJUv/6eipkktcD7wb+sqf8CDCZZCfwPPAgQFWdSDIJnAQuArur6tJQu5Ykvay+wr2qfgX89hW1F5i/emah8fuAfQN3J0m6Lt6hKkkNMtwlqUFN/BLTq/0XVyTpSp65S1KDDHdJapDhLkkNMtwlqUGGuyQ1yHCXpAYZ7pLUIMNdkhpkuEtSgwx3SWqQ4S5JDTLcJalBhrskNchwl6QGGe6S1CDDXZIa1Fe4J3lzki8meTrJqSR/nOTOJIeTPNMt7+gZvzfJdJLTSR5YvvYlSQvp95eY/h74WlV9MMlrgNcDHweOVNUjSfYAe4C/TbIJmADuAX4H+I8kv19Vl5ahf2kk/PUv3eiWPHNP8ibgHcBnAKrq11X1c2AbcKAbdgDY3q1vAw5W1YWqehaYBjYPu3FJ0uL6mZb5PWAO+Kck30vy6SS3A6uq6hxAt1zZjV8DnOnZf6arXSbJriRTSabm5uYGOghJ0uX6CfdbgLcB/1hV9wH/y/wUzGKyQK2uKlTtr6rxqhofGxvrq1lJUn/6CfcZYKaqnuy2v8h82J9PshqgW872jF/Xs/9a4Oxw2pUk9WPJcK+q/wHOJLm7K20BTgKHgB1dbQfweLd+CJhIcluSDcBG4OhQu5Ykvax+r5b5K+Dz3ZUyPwb+nPk/DJNJdgLPAw8CVNWJJJPM/wG4COz2ShlJemX1Fe5VdRwYX+ClLYuM3wfsG6AvSdIAvENVkhpkuEtSg/qdc9cryLsfJQ3KM3dJapDhLkkNMtwlqUGGuyQ1yHCXpAZ5tYyWnVf/SK88z9wlqUGGuyQ1yHCXpAYZ7pLUIMNdkhpkuEtSgwx3SWqQ4S5JDTLcJalBfYV7kueS/DDJ8SRTXe3OJIeTPNMt7+gZvzfJdJLTSR5YruYlSQu7ljP3P62qe6vqpd9S3QMcqaqNwJFumySbgAngHmAr8GiSFUPsWZK0hEGmZbYBB7r1A8D2nvrBqrpQVc8C08DmAT5HknSN+g33Ar6e5FiSXV1tVVWdA+iWK7v6GuBMz74zXe0ySXYlmUoyNTc3d33dS5IW1O9TIe+vqrNJVgKHkzz9MmOzQK2uKlTtB/YDjI+PX/W6JOn69XXmXlVnu+Us8Bjz0yznk6wG6Jaz3fAZYF3P7muBs8NqWJK0tCXDPcntSd740jrwHuBHwCFgRzdsB/B4t34ImEhyW5INwEbg6LAblyQtrp9pmVXAY0leGv+vVfW1JN8FJpPsBJ4HHgSoqhNJJoGTwEVgd1VdWpbuJUkLWjLcq+rHwFsXqL8AbFlkn33AvoG7kyRdF+9QlaQGGe6S1CDDXZIaZLhLUoMMd0lqkOEuSQ0y3CWpQYa7JDXIcJekBhnuktQgw12SGmS4S1KDDHdJapDhLkkNMtwlqUGGuyQ1yHCXpAYZ7pLUoL7DPcmKJN9L8pVu+84kh5M80y3v6Bm7N8l0ktNJHliOxiVJi7uWM/eHgVM923uAI1W1ETjSbZNkEzAB3ANsBR5NsmI47UqS+tFXuCdZC7wP+HRPeRtwoFs/AGzvqR+sqgtV9SwwDWweTruSpH70e+b+KeBjwG96aquq6hxAt1zZ1dcAZ3rGzXQ1SdIrZMlwT/J+YLaqjvX5nlmgVgu8764kU0mm5ubm+nxrSVI/+jlzvx/4QJLngIPAO5N8DjifZDVAt5ztxs8A63r2XwucvfJNq2p/VY1X1fjY2NgAhyBJutKS4V5Ve6tqbVWtZ/6L0m9U1YeAQ8CObtgO4PFu/RAwkeS2JBuAjcDRoXcuSVrULQPs+wgwmWQn8DzwIEBVnUgyCZwELgK7q+rSwJ1Kkvp2TeFeVU8AT3TrLwBbFhm3D9g3YG+SpOvkHaqS1CDDXZIaZLhLUoMMd0lqkOEuSQ0y3CWpQYa7JDXIcJekBhnuktQgw12SGmS4S1KDDHdJapDhLkkNMtwlqUGGuyQ1yHCXpAYZ7pLUIMNdkhpkuEtSg5YM9ySvTXI0yfeTnEjyia5+Z5LDSZ7plnf07LM3yXSS00keWM4DkCRdrZ8z9wvAO6vqrcC9wNYkbwf2AEeqaiNwpNsmySZgArgH2Ao8mmTFcjQvSVrYkuFe817sNm/t/hWwDTjQ1Q8A27v1bcDBqrpQVc8C08DmoXYtSXpZfc25J1mR5DgwCxyuqieBVVV1DqBbruyGrwHO9Ow+09WufM9dSaaSTM3NzQ1yDJKkK/QV7lV1qaruBdYCm5O85WWGZ6G3WOA991fVeFWNj42N9detJKkv13S1TFX9HHiC+bn080lWA3TL2W7YDLCuZ7e1wNmBO5Uk9a2fq2XGkry5W38d8C7gaeAQsKMbtgN4vFs/BEwkuS3JBmAjcHTYjUuSFndLH2NWAwe6K15+C5isqq8k+Q4wmWQn8DzwIEBVnUgyCZwELgK7q+rS8rQvSVrIkuFeVT8A7lug/gKwZZF99gH7Bu5OknRdvENVkhpkuEtSgwx3SWqQ4S5JDTLcJalBhrskNchwl6QGGe6S1CDDXZIaZLhLUoMMd0lqkOEuSQ0y3CWpQYa7JDXIcJekBhnuktQgw12SGmS4S1KD+vmB7HVJvpnkVJITSR7u6ncmOZzkmW55R88+e5NMJzmd5IHlPABJ0tX6OXO/CPxNVf0B8HZgd5JNwB7gSFVtBI5023SvTQD3AFuBR7sf15YkvUKWDPeqOldVT3XrvwROAWuAbcCBbtgBYHu3vg04WFUXqupZYBrYPOzGJUmLu6Y59yTrgfuAJ4FVVXUO5v8AACu7YWuAMz27zXS1K99rV5KpJFNzc3PX3rkkaVF9h3uSNwBfAj5aVb94uaEL1OqqQtX+qhqvqvGxsbF+25Ak9aGvcE9yK/PB/vmq+nJXPp9kdff6amC2q88A63p2XwucHU67kqR+9HO1TIDPAKeq6pM9Lx0CdnTrO4DHe+oTSW5LsgHYCBwdXsuSpKXc0seY+4EPAz9McryrfRx4BJhMshN4HngQoKpOJJkETjJ/pc3uqro09M4lSYtaMtyr6tssPI8OsGWRffYB+wboS5I0AO9QlaQGGe6S1CDDXZIaZLhLUoMMd0lqkOEuSQ0y3CWpQYa7JDXIcJekBhnuktQgw12SGmS4S1KDDHdJapDhLkkNMtwlqUGGuyQ1yHCXpAYZ7pLUoH5+IPuzSWaT/KindmeSw0me6ZZ39Ly2N8l0ktNJHliuxiVJi+vnzP2fga1X1PYAR6pqI3Ck2ybJJmACuKfb59EkK4bWrSSpL0uGe1V9C/jZFeVtwIFu/QCwvad+sKouVNWzwDSweUi9SpL6dL1z7quq6hxAt1zZ1dcAZ3rGzXS1qyTZlWQqydTc3Nx1tiFJWsiwv1DNArVaaGBV7a+q8aoaHxsbG3IbkvTqdr3hfj7JaoBuOdvVZ4B1PePWAmevvz1J0vW43nA/BOzo1ncAj/fUJ5LclmQDsBE4OliLkqRrdctSA5J8AfgT4K4kM8DfAY8Ak0l2As8DDwJU1Ykkk8BJ4CKwu6ouLVPvkqRFLBnuVfXQIi9tWWT8PmDfIE1JkgbjHaqS1CDDXZIaZLhLUoMMd0lqkOEuSQ0y3CWpQYa7JDXIcJekBhnuktQgw12SGmS4S1KDDHdJapDhLkkNMtwlqUGGuyQ1yHCXpAYZ7pLUIMNdkhpkuEtSg5Yt3JNsTXI6yXSSPcv1OZKkqy1LuCdZAfwD8F5gE/BQkk3L8VmSpKst15n7ZmC6qn5cVb8GDgLblumzJElXSFUN/02TDwJbq+ovuu0PA39UVR/pGbML2NVt3g2cHnojg7kL+Omomxgij+fG19oxtXY8cOMd0+9W1dhCL9yyTB+YBWqX/RWpqv3A/mX6/IElmaqq8VH3MSwez42vtWNq7Xjg5jqm5ZqWmQHW9WyvBc4u02dJkq6wXOH+XWBjkg1JXgNMAIeW6bMkSVdYlmmZqrqY5CPAvwMrgM9W1Ynl+KxldMNOGV0nj+fG19oxtXY8cBMd07J8oSpJGi3vUJWkBhnuktQgw/0KrT02Iclnk8wm+dGoexmGJOuSfDPJqSQnkjw86p4GleS1SY4m+X53TJ8YdU/DkGRFku8l+cqoexmGJM8l+WGS40mmRt3PUpxz79E9NuG/gHczfznnd4GHqurkSBsbQJJ3AC8C/1JVbxl1P4NKshpYXVVPJXkjcAzYfpP/Nwpwe1W9mORW4NvAw1X1nyNubSBJ/hoYB95UVe8fdT+DSvIcMF5VN9JNTIvyzP1yzT02oaq+Bfxs1H0MS1Wdq6qnuvVfAqeANaPtajA178Vu89bu30191pVkLfA+4NOj7uXVynC/3BrgTM/2DDd5cLQsyXrgPuDJ0XYyuG4K4zgwCxyuqpv9mD4FfAz4zagbGaICvp7kWPf4lBua4X65JR+boBtDkjcAXwI+WlW/GHU/g6qqS1V1L/N3c29OctNOoSV5PzBbVcdG3cuQ3V9Vb2P+abe7uynPG5bhfjkfm3AT6OalvwR8vqq+POp+hqmqfg48AWwdcSuDuB/4QDdHfRB4Z5LPjbalwVXV2W45CzzG/DTuDctwv5yPTbjBdV8+fgY4VVWfHHU/w5BkLMmbu/XXAe8Cnh5tV9evqvZW1dqqWs/8/0PfqKoPjbitgSS5vfsCnyS3A+8Bbugr0Az3HlV1EXjpsQmngMmb8LEJl0nyBeA7wN1JZpLsHHVPA7of+DDzZ4PHu39/NuqmBrQa+GaSHzB/gnG4qpq4fLAhq4BvJ/k+cBT4alV9bcQ9vSwvhZSkBnnmLkkNMtwlqUGGuyQ1yHCXpAYZ7pLUIMNdkhpkuEtSg/4PwZpshl0vO9cAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "plt.bar(range(6), star_wars[star_wars.columns[3:9]].sum())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "\n",
    "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": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXQAAAD4CAYAAAD8Zh1EAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAAPgUlEQVR4nO3dX4he9Z3H8fenaZaW/iEXGdaQP6awYaEWWmWIirCItIv/qHvhhUIryEJQLFi2UGwvLL3r3pRi0zWEVlppqRRsJWjcrlClCuufSRpTY9olFBeHBDK1NDYoLWm/ezFHmH0yM8+ZzBmfzM/3Cx5y/vxyns9B/HD45ZznpKqQJK1/75t0AEnSMCx0SWqEhS5JjbDQJakRFrokNeL9k/rizZs3186dOyf19ZK0Lh06dOj3VTW12L6JFfrOnTuZmZmZ1NdL0rqU5H+X2ueUiyQ1wkKXpEZY6JLUCAtdkhphoUtSIyx0SWqEhS5JjbDQJakRFrokNWJiT4qqbTvve2LSEXp57Rs3TTqCNBiv0CWpEV6hXyS8opW0Wl6hS1IjLHRJaoSFLkmNsNAlqREWuiQ1wkKXpEZY6JLUiN6FnmRDkl8leXyRfUnyQJITSY4muWLYmJKkcVbyYNG9wHHgo4vsuwHY1X2uBB7s/lwTPoQjSefrdYWeZBtwE/DdJYbcAjxc854HNiXZMlBGSVIPfadcvgV8GfjbEvu3Aq8vWJ/ttv0/SfYkmUkyMzc3t6KgkqTljS30JDcDp6vq0HLDFtlW522o2l9V01U1PTU1tYKYkqRx+lyhXwN8NslrwCPAdUl+ODJmFti+YH0bcHKQhJKkXsYWelV9paq2VdVO4DbgF1X1uZFhB4A7urtdrgLOVNWp4eNKkpZywT+fm+QugKraBxwEbgROAG8Bdw6STpLU24oKvaqeAZ7plvct2F7APUMGkyStjE+KSlIjLHRJaoSFLkmNsNAlqREWuiQ1wkKXpEZY6JLUCAtdkhphoUtSIyx0SWqEhS5JjbDQJakRFrokNcJCl6RGWOiS1Ig+7xT9QJIXk7yc5FiSry8y5tokZ5Ic6T73r01cSdJS+rzg4s/AdVV1NslG4LkkT1bV8yPjnq2qm4ePKEnqY2yhd28jOtutbuw+tZahJEkr12sOPcmGJEeA08BTVfXCIsOu7qZlnkxy2RLH2ZNkJsnM3NzcKmJLkkb1KvSq+mtVfQrYBuxO8omRIYeBS6vqk8C3gceWOM7+qpququmpqanV5JYkjVjRXS5V9UfmXxJ9/cj2N6vqbLd8ENiYZPNQISVJ4/W5y2UqyaZu+YPAp4HfjIy5JEm65d3dcd8YPq4kaSl97nLZAvwgyQbmi/onVfV4krsAqmofcCtwd5JzwNvAbd0/pkqS3iV97nI5Cly+yPZ9C5b3AnuHjSZJWgmfFJWkRljoktQIC12SGmGhS1IjLHRJaoSFLkmNsNAlqREWuiQ1wkKXpEZY6JLUCAtdkhphoUtSIyx0SWqEhS5JjbDQJakRfd5Y9IEkL3YvgD6W5OuLjEmSB5KcSHI0yRVrE1eStJQ+byz6M3BdVZ1NshF4LsmTVfX8gjE3ALu6z5XAg92fkqR3ydgr9Jp3tlvd2H1GXy93C/BwN/Z5YFOSLcNGlSQtp88VOt37RA8B/wB8p6peGBmyFXh9wfpst+3UyHH2AHsAduzYcYGRJWlxO+97YtIRenntGzetyXF7FXpV/RX4VJJNwM+SfKKqXlkwJIv9tUWOsx/YDzA9Pe1LpLWuvNfLQhe/Fd3lUlV/BJ4Brh/ZNQtsX7C+DTi5qmSSpBXpc5fLVHdlTpIPAp8GfjMy7ABwR3e3y1XAmao6hSTpXdNnymUL8INuHv19wE+q6vEkdwFU1T7gIHAjcAJ4C7hzjfJKkpYwttCr6ihw+SLb9y1YLuCeYaNJklbCJ0UlqREWuiQ1wkKXpEZY6JLUCAtdkhphoUtSIyx0SWqEhS5JjbDQJakRFrokNcJCl6RGWOiS1AgLXZIaYaFLUiMsdElqhIUuSY3o8wq67UmeTnI8ybEk9y4y5tokZ5Ic6T73r01cSdJS+ryC7hzwpao6nOQjwKEkT1XVqyPjnq2qm4ePKEnqY+wVelWdqqrD3fKfgOPA1rUOJklamRXNoSfZyfz7RV9YZPfVSV5O8mSSy5b4+3uSzCSZmZubW3FYSdLSehd6kg8DjwJfrKo3R3YfBi6tqk8C3wYeW+wYVbW/qqaranpqaupCM0uSFtFnDp0kG5kv8x9V1U9H9y8s+Ko6mOQ/kmyuqt8PF1XSkHbe98SkI/Ty2jdumnSEdaPPXS4Bvgccr6pvLjHmkm4cSXZ3x31jyKCSpOX1uUK/Bvg88OskR7ptXwV2AFTVPuBW4O4k54C3gduqqtYgryRpCWMLvaqeAzJmzF5g71ChJEkr55OiktQIC12SGmGhS1IjLHRJaoSFLkmNsNAlqREWuiQ1wkKXpEZY6JLUCAtdkhphoUtSIyx0SWqEhS5JjbDQJakRFrokNaLPG4u2J3k6yfEkx5Lcu8iYJHkgyYkkR5NcsTZxJUlL6fPGonPAl6rqcJKPAIeSPFVVry4YcwOwq/tcCTzY/SlJepeMvUKvqlNVdbhb/hNwHNg6MuwW4OGa9zywKcmWwdNKkpa0ojn0JDuBy4EXRnZtBV5fsD7L+aVPkj1JZpLMzM3NrSypJGlZvQs9yYeBR4EvVtWbo7sX+SvnvSS6qvZX1XRVTU9NTa0sqSRpWb0KPclG5sv8R1X100WGzALbF6xvA06uPp4kqa8+d7kE+B5wvKq+ucSwA8Ad3d0uVwFnqurUgDklSWP0ucvlGuDzwK+THOm2fRXYAVBV+4CDwI3ACeAt4M7ho0qSljO20KvqORafI184poB7hgolSVo5nxSVpEZY6JLUCAtdkhphoUtSIyx0SWqEhS5JjbDQJakRFrokNcJCl6RGWOiS1AgLXZIaYaFLUiMsdElqhIUuSY2w0CWpEX3eWPRQktNJXlli/7VJziQ50n3uHz6mJGmcPm8s+j6wF3h4mTHPVtXNgySSJF2QsVfoVfVL4A/vQhZJ0ioMNYd+dZKXkzyZ5LKlBiXZk2Qmyczc3NxAXy1JgmEK/TBwaVV9Evg28NhSA6tqf1VNV9X01NTUAF8tSXrHqgu9qt6sqrPd8kFgY5LNq04mSVqRVRd6kkuSpFve3R3zjdUeV5K0MmPvcknyY+BaYHOSWeBrwEaAqtoH3ArcneQc8DZwW1XVmiWWJC1qbKFX1e1j9u9l/rZGSdIE+aSoJDXCQpekRljoktQIC12SGmGhS1IjLHRJaoSFLkmNsNAlqREWuiQ1wkKXpEZY6JLUCAtdkhphoUtSIyx0SWqEhS5JjRhb6EkeSnI6yStL7E+SB5KcSHI0yRXDx5QkjdPnCv37wPXL7L8B2NV99gAPrj6WJGmlxhZ6Vf0S+MMyQ24BHq55zwObkmwZKqAkqZ8h5tC3Aq8vWJ/ttp0nyZ4kM0lm5ubmBvhqSdI7hij0LLJt0ZdEV9X+qpququmpqakBvlqS9I4hCn0W2L5gfRtwcoDjSpJWYIhCPwDc0d3tchVwpqpODXBcSdIKvH/cgCQ/Bq4FNieZBb4GbASoqn3AQeBG4ATwFnDnWoWVJC1tbKFX1e1j9hdwz2CJJEkXxCdFJakRFrokNcJCl6RGWOiS1AgLXZIaYaFLUiMsdElqhIUuSY2w0CWpERa6JDXCQpekRljoktQIC12SGmGhS1IjLHRJakSvQk9yfZLfJjmR5L5F9l+b5EySI93n/uGjSpKW0+eNRRuA7wCfYf79oS8lOVBVr44Mfbaqbl6DjJKkHvpcoe8GTlTV76rqL8AjwC1rG0uStFJ9Cn0r8PqC9dlu26irk7yc5Mkklw2STpLU29gpFyCLbKuR9cPApVV1NsmNwGPArvMOlOwB9gDs2LFjhVElScvpc4U+C2xfsL4NOLlwQFW9WVVnu+WDwMYkm0cPVFX7q2q6qqanpqZWEVuSNKpPob8E7ErysSR/B9wGHFg4IMklSdIt7+6O+8bQYSVJSxs75VJV55J8Afg5sAF4qKqOJbmr278PuBW4O8k54G3gtqoanZaRJK2hPnPo70yjHBzZtm/B8l5g77DRJEkr4ZOiktQIC12SGmGhS1IjLHRJaoSFLkmNsNAlqREWuiQ1wkKXpEZY6JLUCAtdkhphoUtSIyx0SWqEhS5JjbDQJakRFrokNcJCl6RG9Cr0JNcn+W2SE0nuW2R/kjzQ7T+a5Irho0qSljO20JNsAL4D3AB8HLg9ycdHht0A7Oo+e4AHB84pSRqjzxX6buBEVf2uqv4CPALcMjLmFuDhmvc8sCnJloGzSpKW0eedoluB1xeszwJX9hizFTi1cFCSPcxfwQOcTfLbFaVdW5uB3w95wPz7kEe7IK2dU2vnA+2dU2vnAxffOV261I4+hZ5FttUFjKGq9gP7e3znuy7JTFVNTzrHkFo7p9bOB9o7p9bOB9bXOfWZcpkFti9Y3wacvIAxkqQ11KfQXwJ2JflYkr8DbgMOjIw5ANzR3e1yFXCmqk6NHkiStHbGTrlU1bkkXwB+DmwAHqqqY0nu6vbvAw4CNwIngLeAO9cu8pq5KKeCVqm1c2rtfKC9c2rtfGAdnVOqzpvqliStQz4pKkmNsNAlqREWOuN/2mC9SfJQktNJXpl0liEk2Z7k6STHkxxLcu+kM61Gkg8keTHJy935fH3SmYaSZEOSXyV5fNJZVivJa0l+neRIkplJ5+njPT+H3v20wf8An2H+9suXgNur6tWJBluFJP8EnGX+6d1PTDrPanVPHW+pqsNJPgIcAv5lvf43ShLgQ1V1NslG4Dng3u4p63Utyb8B08BHq+rmSedZjSSvAdNVNehDRWvJK/R+P22wrlTVL4E/TDrHUKrqVFUd7pb/BBxn/knkdan7iYyz3erG7rPur6ySbANuAr476SzvVRb60j9boItQkp3A5cALk02yOt3UxBHgNPBUVa3r8+l8C/gy8LdJBxlIAf+V5FD3syUXPQu9588WaPKSfBh4FPhiVb056TyrUVV/rapPMf9U9e4k63pqLMnNwOmqOjTpLAO6pqquYP7XZO/ppjIvaha6P1uwLnRzzY8CP6qqn046z1Cq6o/AM8D1E46yWtcAn+3mnR8Brkvyw8lGWp2qOtn9eRr4GfPTsxc1C73fTxtogrp/RPwecLyqvjnpPKuVZCrJpm75g8Cngd9MNtXqVNVXqmpbVe1k/v+hX1TV5yYc64Il+VD3D/Ak+RDwz8BFf9fYe77Qq+oc8M5PGxwHflJVxyabanWS/Bj4b+Afk8wm+ddJZ1qla4DPM3/Vd6T73DjpUKuwBXg6yVHmLyieqqp1f5tfY/4eeC7Jy8CLwBNV9Z8TzjTWe/62RUlqxXv+Cl2SWmGhS1IjLHRJaoSFLkmNsNAlqREWuiQ1wkKXpEb8H2FAR4gKyj18AAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAWoAAAD4CAYAAADFAawfAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAAJ20lEQVR4nO3dT6jld3nH8c/TybSRqLjIpYRM6O2iBMSFKZd0MdBFsCVNgu2iCwNmZZlNhUgLElelO1fipptBQ1sURRoLJaF/AiaEgEbvxGiNo0VKSoPCXBHRbFqiTxf3TE3iTe4Z7zlznnvm9YJLzpnzm8PzZcibL7/z+91T3R0A5vq1TQ8AwFsTaoDhhBpgOKEGGE6oAYa7aR1veuutt/bu7u463hpgK126dOmH3b1z1GtrCfXu7m729/fX8dYAW6mq/uvNXnPqA2A4oQYYTqgBhhNqgOGEGmA4oQYYTqgBhhNqgOGEGmC4tdyZyHbbfeSJTY+wlJc+fv+mR4CVsKMGGE6oAYYTaoDhhBpgOKEGGE6oAYYTaoDhhBpgOKEGGE6oAYYTaoDhhBpgOKEGGE6oAYYTaoDhlg51VZ2pqq9X1ePrHAiA17uWHfXDSS6vaxAAjrZUqKvqXJL7k3xqveMA8EbL7qg/meSjSX7+ZgdU1YWq2q+q/YODg5UMB8ASoa6qB5Jc6e5Lb3Vcd1/s7r3u3tvZ2VnZgAA3umW+3PZ8kvdX1X1Jbk7yzqr6THd/cL2jbQdfBAuc1LE76u7+WHef6+7dJB9I8iWRBrh+XEcNMNwypz7+X3c/neTptUwCwJHsqAGGE2qA4YQaYDihBhhOqAGGE2qA4YQaYDihBhhOqAGGE2qA4YQaYDihBhhOqAGGE2qA4YQaYDihBhjumr44ALaR77VkOjtqgOGEGmA4oQYYTqgBhhv3YaIPdgBez44aYDihBhhOqAGGE2qA4YQaYDihBhhOqAGGE2qA4YQaYDihBhhOqAGGE2qA4YQaYDihBhhOqAGGE2qA4Y794oCqujnJM0l+Y3H8P3T3X617MICrbvQvFFnmG17+J8k93f1KVZ1N8mxV/XN3f2UtEwHwOseGurs7ySuLp2cXP73OoQD4haXOUVfVmap6IcmVJE9293NHHHOhqvarav/g4GDVcwLcsJYKdXf/rLvfm+Rckrur6j1HHHOxu/e6e29nZ2fVcwLcsK7pqo/u/nGSp5Pcu5ZpAPglx4a6qnaq6l2Lx29L8r4k31n3YAAcWuaqj9uS/F1Vnclh2L/Q3Y+vdywArlrmqo9vJrnrOswCwBHcmQgwnFADDCfUAMMJNcBwQg0wnFADDCfUAMMJNcBwQg0wnFADDCfUAMMJNcBwQg0wnFADDLfM76MGTpndR57Y9AhLeenj9296hFPBjhpgOKEGGE6oAYYTaoDhhBpgOKEGGE6oAYYTaoDhhBpgOKEGGE6oAYYTaoDhhBpgOKEGGE6oAYYTaoDhhBpgOKEGGE6oAYYTaoDhhBpgOKEGGE6oAYY7NtRVdUdVPVVVl6vqxap6+HoMBsChm5Y45tUkf9ndz1fVO5Jcqqonu/vba54NgCyxo+7uH3T384vHP01yOcnt6x4MgEPXdI66qnaT3JXkuSNeu1BV+1W1f3BwsJrpAFg+1FX19iSPJflId//kja9398Xu3uvuvZ2dnVXOCHBDWyrUVXU2h5H+bHd/cb0jAfBay1z1UUk+neRyd39i/SMB8FrL7KjPJ3koyT1V9cLi5741zwXAwrGX53X3s0nqOswCwBHcmQgwnFADDCfUAMMJNcBwQg0wnFADDCfUAMMJNcBwQg0wnFADDCfUAMMJNcBwQg0wnFADDCfUAMMJNcBwQg0wnFADDCfUAMMJNcBwQg0wnFADDCfUAMMJNcBwQg0wnFADDCfUAMMJNcBwQg0wnFADDCfUAMMJNcBwQg0wnFADDCfUAMMJNcBwQg0wnFADDHdsqKvq0aq6UlXfuh4DAfB6y+yo/zbJvWueA4A3cWyou/uZJD+6DrMAcISVnaOuqgtVtV9V+wcHB6t6W4Ab3spC3d0Xu3uvu/d2dnZW9bYANzxXfQAMJ9QAwy1zed7nknw5yZ1V9XJVfWj9YwFw1U3HHdDdD16PQQA4mlMfAMMJNcBwQg0wnFADDCfUAMMJNcBwQg0wnFADDCfUAMMJNcBwQg0wnFADDCfUAMMJNcBwQg0wnFADDCfUAMMJNcBwQg0wnFADDCfUAMMJNcBwQg0wnFADDCfUAMMJNcBwQg0wnFADDCfUAMMJNcBwQg0wnFADDCfUAMMJNcBwQg0wnFADDCfUAMMJNcBwS4W6qu6tqu9W1feq6pF1DwXALxwb6qo6k+RvkvxRkncnebCq3r3uwQA4tMyO+u4k3+vu/+zu/03y+SR/vN6xALiquvutD6j60yT3dvefLZ4/lOT3uvvDbzjuQpILi6d3Jvnu6sf9ld2a5IebHmKFtm09yfatadvWk2zfmqat57e6e+eoF25a4i/XEX/2S3Xv7otJLl7jYNdFVe13996m51iVbVtPsn1r2rb1JNu3ptO0nmVOfbyc5I7XPD+X5PvrGQeAN1om1F9L8jtV9dtV9etJPpDkn9Y7FgBXHXvqo7tfraoPJ/nXJGeSPNrdL659stUaeUrmBLZtPcn2rWnb1pNs35pOzXqO/TARgM1yZyLAcEINMNxWh3rbbn2vqker6kpVfWvTs6xCVd1RVU9V1eWqerGqHt70TCdVVTdX1Ver6huLNf31pmdahao6U1Vfr6rHNz3LKlTVS1X171X1QlXtb3qe42ztOerFre//keQPcniJ4deSPNjd397oYCdQVb+f5JUkf9/d79n0PCdVVbclua27n6+qdyS5lORPTvm/USW5pbtfqaqzSZ5N8nB3f2XDo51IVf1Fkr0k7+zuBzY9z0lV1UtJ9rp70g0vb2qbd9Rbd+t7dz+T5EebnmNVuvsH3f384vFPk1xOcvtmpzqZPvTK4unZxc+p3g1V1bkk9yf51KZnuVFtc6hvT/Lfr3n+ck55BLZZVe0muSvJc5ud5OQWpwleSHIlyZPdfdrX9MkkH03y800PskKd5N+q6tLi11+Mts2hXurWdzavqt6e5LEkH+nun2x6npPq7p9193tzeBfv3VV1ak9TVdUDSa5096VNz7Ji57v7d3P4W0H/fHFacaxtDrVb30+BxXncx5J8tru/uOl5Vqm7f5zk6ST3bniUkzif5P2Lc7qfT3JPVX1msyOdXHd/f/HfK0n+MYenSsfa5lC79X24xQdvn05yubs/sel5VqGqdqrqXYvHb0vyviTf2exUv7ru/lh3n+vu3Rz+P/Sl7v7ghsc6kaq6ZfHhdarqliR/mGT0lVRbG+rufjXJ1VvfLyf5wim89f11qupzSb6c5M6qermqPrTpmU7ofJKHcrhLe2Hxc9+mhzqh25I8VVXfzOFm4cnu3opL2rbIbyZ5tqq+keSrSZ7o7n/Z8ExvaWsvzwPYFlu7owbYFkINMJxQAwwn1ADDCTXAcEINMJxQAwz3f7ojHYkoKOLhAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "males = star_wars[star_wars[\"Gender\"] == \"Male\"]\n",
    "females = star_wars[star_wars[\"Gender\"] == \"Female\"]\n",
    "\n",
    "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": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXcAAAD4CAYAAAAXUaZHAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAARFElEQVR4nO3dX6hdZ53G8e9j2mmlKrb0tMQkTIJEmVQwHQ4ZoTA41rGZKqbCdEjBkosO8SKFygjSeKNeBHrhv5upEG0xMzpmAlUa1HGMsSIFp/GkprVJmmmwmeaYkBx1xPYmQ9LfXJxV3EnOydk5e5/uk7ffD2zWWu9619q/RelzVt69/qSqkCS15U2jLkCSNHyGuyQ1yHCXpAYZ7pLUIMNdkhp01agLALjxxhtr5cqVoy5Dkq4o+/fv/21Vjc20blGE+8qVK5mYmBh1GZJ0RUnyP7Otc1hGkhrUd7gnWZLkl0m+1y3fkGRPkhe66fU9fbcmOZrkSJI7FqJwSdLsLufM/QHgcM/yg8DeqloN7O2WSbIG2AjcAqwHHk6yZDjlSpL60Ve4J1kOfBj4ek/zBmBHN78DuKunfWdVnamqF4GjwLrhlCtJ6ke/Z+5fAT4NvNrTdnNVnQTopjd17cuA4z39Jru28yTZnGQiycTU1NRlFy5Jmt2c4Z7kI8Dpqtrf5z4zQ9tFTyerqu1VNV5V42NjM17JI0map34uhbwN+GiSO4Frgbcl+SZwKsnSqjqZZClwuus/Cazo2X45cGKYRUuSLm3OM/eq2lpVy6tqJdM/lP6kqj4O7AY2dd02AY9387uBjUmuSbIKWA3sG3rlkqRZDXIT00PAriT3AS8BdwNU1cEku4BDwFlgS1WdG7hSSVLfshhe1jE+Pl7eoSqNzsoHvz/qEvpy7KEPj7qERSXJ/qoan2mdd6hKUoMWxbNlJGnY3uj/GvHMXZIaZLhLUoMMd0lqkOEuSQ0y3CWpQYa7JDXIcJekBhnuktQgw12SGmS4S1KDDHdJapDhLkkNMtwlqUFNPBXyjf70N0m6kGfuktQgw12SGjRnuCe5Nsm+JM8kOZjk813755L8JsmB7nNnzzZbkxxNciTJHQt5AJKki/Uz5n4G+EBVvZLkauDJJP/RrftyVX2ht3OSNcBG4BbgHcCPk7zLl2RL0utnzjP3mvZKt3h197nUW7U3ADur6kxVvQgcBdYNXKkkqW99jbknWZLkAHAa2FNVT3Wr7k/ybJJHk1zftS0DjvdsPtm1XbjPzUkmkkxMTU0NcAiSpAv1Fe5Vda6q1gLLgXVJ3gN8FXgnsBY4CXyx656ZdjHDPrdX1XhVjY+Njc2reEnSzC7rapmq+gPwU2B9VZ3qQv9V4Gv8aehlEljRs9ly4MQQapUk9amfq2XGkry9m38z8EHg+SRLe7p9DHium98NbExyTZJVwGpg33DLliRdSj9XyywFdiRZwvQfg11V9b0k/5pkLdNDLseATwBU1cEku4BDwFlgi1fKqDXeFa3Fbs5wr6pngVtnaL/3EttsA7YNVpokab68Q1WSGmS4S1KDDHdJapDhLkkNMtwlqUGGuyQ1yHCXpAYZ7pLUoCbeodoa736UNCjP3CWpQYa7JDXIYRktOIeZpNefZ+6S1CDDXZIaZLhLUoMMd0lqkOEuSQ3q5x2q1ybZl+SZJAeTfL5rvyHJniQvdNPre7bZmuRokiNJ7ljIA5AkXayfM/czwAeq6r3AWmB9kvcBDwJ7q2o1sLdbJskaYCNwC7AeeLh7/6ok6XUyZ7jXtFe6xau7TwEbgB1d+w7grm5+A7Czqs5U1YvAUWDdUKuWJF1SX2PuSZYkOQCcBvZU1VPAzVV1EqCb3tR1XwYc79l8smu7cJ+bk0wkmZiamhrkGCRJF+gr3KvqXFWtBZYD65K85xLdM9MuZtjn9qoar6rxsbGx/qqVJPXlsq6Wqao/AD9leiz9VJKlAN30dNdtEljRs9ly4MTAlUqS+tbP1TJjSd7ezb8Z+CDwPLAb2NR12wQ83s3vBjYmuSbJKmA1sG/YhUuSZtfPg8OWAju6K17eBOyqqu8l+TmwK8l9wEvA3QBVdTDJLuAQcBbYUlXnFqZ8SdJM5gz3qnoWuHWG9t8Bt8+yzTZg28DVSZLmxTtUJalBhrskNchwl6QGGe6S1CDDXZIaZLhLUoMMd0lqkOEuSQ0y3CWpQYa7JDXIcJekBhnuktQgw12SGmS4S1KDDHdJapDhLkkNMtwlqUGGuyQ1qJ8XZK9I8kSSw0kOJnmga/9ckt8kOdB97uzZZmuSo0mOJLljIQ9AknSxfl6QfRb4VFU9neStwP4ke7p1X66qL/R2TrIG2AjcArwD+HGSd/mSbEl6/cx55l5VJ6vq6W7+ZeAwsOwSm2wAdlbVmap6ETgKrBtGsZKk/lzWmHuSlcCtwFNd0/1Jnk3yaJLru7ZlwPGezSaZ4Y9Bks1JJpJMTE1NXXbhkqTZ9R3uSd4CPAZ8sqr+CHwVeCewFjgJfPG1rjNsXhc1VG2vqvGqGh8bG7vswiVJs+sr3JNczXSwf6uqvgNQVaeq6lxVvQp8jT8NvUwCK3o2Xw6cGF7JkqS59HO1TIBHgMNV9aWe9qU93T4GPNfN7wY2JrkmySpgNbBveCVLkubSz9UytwH3Ar9KcqBr+wxwT5K1TA+5HAM+AVBVB5PsAg4xfaXNFq+UkaTX15zhXlVPMvM4+g8usc02YNsAdUmSBuAdqpLUIMNdkhpkuEtSgwx3SWqQ4S5JDTLcJalBhrskNchwl6QGGe6S1CDDXZIaZLhLUoMMd0lqkOEuSQ0y3CWpQYa7JDXIcJekBhnuktSgft6huiLJE0kOJzmY5IGu/YYke5K80E2v79lma5KjSY4kuWMhD0CSdLF+ztzPAp+qqr8A3gdsSbIGeBDYW1Wrgb3dMt26jcAtwHrg4SRLFqJ4SdLM5gz3qjpZVU938y8Dh4FlwAZgR9dtB3BXN78B2FlVZ6rqReAosG7YhUuSZndZY+5JVgK3Ak8BN1fVSZj+AwDc1HVbBhzv2Wyya7twX5uTTCSZmJqauvzKJUmz6jvck7wFeAz4ZFX98VJdZ2irixqqtlfVeFWNj42N9VuGJKkPfYV7kquZDvZvVdV3uuZTSZZ265cCp7v2SWBFz+bLgRPDKVeS1I9+rpYJ8AhwuKq+1LNqN7Cpm98EPN7TvjHJNUlWAauBfcMrWZI0l6v66HMbcC/wqyQHurbPAA8Bu5LcB7wE3A1QVQeT7AIOMX2lzZaqOjf0yiVJs5oz3KvqSWYeRwe4fZZttgHbBqhLkjQA71CVpAYZ7pLUIMNdkhpkuEtSgwx3SWqQ4S5JDTLcJalBhrskNchwl6QGGe6S1CDDXZIaZLhLUoMMd0lqkOEuSQ0y3CWpQYa7JDXIcJekBvXzDtVHk5xO8lxP2+eS/CbJge5zZ8+6rUmOJjmS5I6FKlySNLt+zty/Aayfof3LVbW2+/wAIMkaYCNwS7fNw0mWDKtYSVJ/5gz3qvoZ8Ps+97cB2FlVZ6rqReAosG6A+iRJ8zDImPv9SZ7thm2u79qWAcd7+kx2bZKk19F8w/2rwDuBtcBJ4Itde2boWzPtIMnmJBNJJqampuZZhiRpJvMK96o6VVXnqupV4Gv8aehlEljR03U5cGKWfWyvqvGqGh8bG5tPGZKkWcwr3JMs7Vn8GPDalTS7gY1JrkmyClgN7BusREnS5bpqrg5Jvg28H7gxySTwWeD9SdYyPeRyDPgEQFUdTLILOAScBbZU1bmFKV2SNJs5w72q7pmh+ZFL9N8GbBukKEnSYLxDVZIaZLhLUoMMd0lqkOEuSQ0y3CWpQYa7JDXIcJekBhnuktQgw12SGmS4S1KDDHdJapDhLkkNMtwlqUGGuyQ1yHCXpAYZ7pLUIMNdkhpkuEtSg+YM9ySPJjmd5LmethuS7EnyQje9vmfd1iRHkxxJcsdCFS5Jml0/Z+7fANZf0PYgsLeqVgN7u2WSrAE2Ard02zycZMnQqpUk9WXOcK+qnwG/v6B5A7Cjm98B3NXTvrOqzlTVi8BRYN2QapUk9Wm+Y+43V9VJgG56U9e+DDje02+ya7tIks1JJpJMTE1NzbMMSdJMhv2DamZoq5k6VtX2qhqvqvGxsbEhlyFJb2zzDfdTSZYCdNPTXfsksKKn33LgxPzLkyTNx3zDfTewqZvfBDze074xyTVJVgGrgX2DlShJulxXzdUhybeB9wM3JpkEPgs8BOxKch/wEnA3QFUdTLILOAScBbZU1bkFql2SNIs5w72q7pll1e2z9N8GbBukKEnSYLxDVZIaZLhLUoMMd0lqkOEuSQ0y3CWpQYa7JDXIcJekBhnuktQgw12SGmS4S1KDDHdJapDhLkkNMtwlqUGGuyQ1yHCXpAYZ7pLUIMNdkho055uYLiXJMeBl4BxwtqrGk9wA/DuwEjgG/ENV/e9gZUqSLscwztz/pqrWVtV4t/wgsLeqVgN7u2VJ0utoIYZlNgA7uvkdwF0L8B2SpEsYNNwL+FGS/Uk2d203V9VJgG5600wbJtmcZCLJxNTU1IBlSJJ6DTTmDtxWVSeS3ATsSfJ8vxtW1XZgO8D4+HgNWIckqcdAZ+5VdaKbnga+C6wDTiVZCtBNTw9apCTp8sw73JNcl+Str80DHwKeA3YDm7pum4DHBy1SknR5BhmWuRn4bpLX9vNvVfXDJL8AdiW5D3gJuHvwMiVJl2Pe4V5VvwbeO0P774DbBylKkjQY71CVpAYZ7pLUIMNdkhpkuEtSgwx3SWqQ4S5JDTLcJalBhrskNchwl6QGGe6S1CDDXZIaZLhLUoMMd0lqkOEuSQ0y3CWpQYa7JDXIcJekBhnuktSgBQv3JOuTHElyNMmDC/U9kqSLLUi4J1kC/DPwd8Aa4J4kaxbiuyRJF1uoM/d1wNGq+nVV/R+wE9iwQN8lSbpAqmr4O03+HlhfVf/YLd8L/FVV3d/TZzOwuVt8N3Bk6IUM5kbgt6MuYog8nsWvtWNq7Xhg8R3Tn1fV2EwrrlqgL8wMbef9Famq7cD2Bfr+gSWZqKrxUdcxLB7P4tfaMbV2PHBlHdNCDctMAit6lpcDJxbouyRJF1iocP8FsDrJqiR/BmwEdi/Qd0mSLrAgwzJVdTbJ/cB/AkuAR6vq4EJ81wJatENG8+TxLH6tHVNrxwNX0DEtyA+qkqTR8g5VSWqQ4S5JDTLcL9DaYxOSPJrkdJLnRl3LMCRZkeSJJIeTHEzywKhrGlSSa5PsS/JMd0yfH3VNw5BkSZJfJvneqGsZhiTHkvwqyYEkE6OuZy6OuffoHpvw38DfMn055y+Ae6rq0EgLG0CSvwZeAf6lqt4z6noGlWQpsLSqnk7yVmA/cNcV/t8owHVV9UqSq4EngQeq6r9GXNpAkvwTMA68rao+Mup6BpXkGDBeVYvpJqZZeeZ+vuYem1BVPwN+P+o6hqWqTlbV0938y8BhYNloqxpMTXulW7y6+1zRZ11JlgMfBr4+6lreqAz38y0DjvcsT3KFB0fLkqwEbgWeGm0lg+uGMA4Ap4E9VXWlH9NXgE8Dr466kCEq4EdJ9nePT1nUDPfzzfnYBC0OSd4CPAZ8sqr+OOp6BlVV56pqLdN3c69LcsUOoSX5CHC6qvaPupYhu62q/pLpp91u6YY8Fy3D/Xw+NuEK0I1LPwZ8q6q+M+p6hqmq/gD8FFg/4lIGcRvw0W6MeifwgSTfHG1Jg6uqE930NPBdpodxFy3D/Xw+NmGR6358fAQ4XFVfGnU9w5BkLMnbu/k3Ax8Enh9tVfNXVVuranlVrWT6/6GfVNXHR1zWQJJc1/2AT5LrgA8Bi/oKNMO9R1WdBV57bMJhYNcV+NiE8yT5NvBz4N1JJpPcN+qaBnQbcC/TZ4MHus+doy5qQEuBJ5I8y/QJxp6qauLywYbcDDyZ5BlgH/D9qvrhiGu6JC+FlKQGeeYuSQ0y3CWpQYa7JDXIcJekBhnuktQgw12SGmS4S1KD/h97f8+87HcQGAAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXcAAAD4CAYAAAAXUaZHAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAAQGElEQVR4nO3dX4wdZ33G8e9TJw0oUJEom9TYVh0hg+og4VQrFylSRQklLkF1kJrKkRr5Iq25cFRQkSqHG+DCUi740140SKaJMC3FtRSiWIQCxgWhSDRmnTohtuNiETdebNkLFJHcuLLz68VOxLG96z3ec46P/eb7kY5m5p33nfMbWX529O7MbKoKSVJbfmvcBUiShs9wl6QGGe6S1CDDXZIaZLhLUoOuGXcBADfddFOtXLly3GVI0lVl3759P6+qibn2XRHhvnLlSqampsZdhiRdVZL8z3z7nJaRpAYZ7pLUIMNdkhpkuEtSgwx3SWqQ4S5JDTLcJalBC4Z7kjcl2ZvkuSQHknyma/90kp8l2d99PtQz5qEkR5IcTnLXKE9AknShfh5iOg28v6peTXIt8HSSf+/2faGqPtvbOclqYANwG/B24LtJ3llVZ4dZuCRpfguGe83+NY9Xu81ru8/F/sLHemBHVZ0GXkpyBFgL/HDAWiWNyMotT427hL4cffjucZdw1ehrzj3JkiT7gVPA7qp6ptv1YJLnkzyW5IaubRlwrGf4dNd2/jE3JZlKMjUzMzPAKUiSztdXuFfV2apaAywH1iZ5N/BF4B3AGuAE8Lmue+Y6xBzH3FZVk1U1OTEx53tvJEmLdEl3y1TVr4DvA+uq6mQX+q8BX2J26gVmr9RX9AxbDhwfQq2SpD71c7fMRJK3detvBj4AvJhkaU+3jwAvdOu7gA1JrktyK7AK2DvcsiVJF9PP3TJLge1JljD7w2BnVX0jyT8nWcPslMtR4KMAVXUgyU7gIHAG2OydMpJ0efVzt8zzwO1ztN9/kTFbga2DlSZJWiyfUJWkBhnuktSgK+LP7EnSsL3RH8zyyl2SGmS4S1KDDHdJapDhLkkNMtwlqUGGuyQ1yHCXpAYZ7pLUIMNdkhpkuEtSgwx3SWqQ4S5JDTLcJalBhrskNchwl6QGGe6S1CDDXZIaZLhLUoMWDPckb0qyN8lzSQ4k+UzXfmOS3Ul+0i1v6BnzUJIjSQ4nuWuUJyBJulA/V+6ngfdX1XuANcC6JO8FtgB7qmoVsKfbJslqYANwG7AOeCTJklEUL0ma24LhXrNe7Tav7T4FrAe2d+3bgXu69fXAjqo6XVUvAUeAtUOtWpJ0UX3NuSdZkmQ/cArYXVXPALdU1QmAbnlz130ZcKxn+HTXdv4xNyWZSjI1MzMzyDlIks5zTT+dquossCbJ24Ankrz7It0z1yHmOOY2YBvA5OTkBfsvxcotTw0y/LI5+vDd4y5B0hvEJd0tU1W/Ar7P7Fz6ySRLAbrlqa7bNLCiZ9hy4PjAlUqS+tbP3TIT3RU7Sd4MfAB4EdgFbOy6bQSe7NZ3ARuSXJfkVmAVsHfYhUuS5tfPtMxSYHt3x8tvATur6htJfgjsTPIA8DJwL0BVHUiyEzgInAE2d9M6kqTLZMFwr6rngdvnaP8FcOc8Y7YCWweuTpK0KD6hKkkNMtwlqUGGuyQ1yHCXpAYZ7pLUIMNdkhpkuEtSgwx3SWqQ4S5JDTLcJalBhrskNchwl6QGGe6S1CDDXZIaZLhLUoMMd0lqkOEuSQ0y3CWpQYa7JDXIcJekBi34B7KTrAC+Avwu8Bqwrar+Icmngb8GZrqun6yqb3ZjHgIeAM4Cf1NV3x5B7dLYrNzy1LhL6MvRh+8edwkakwXDHTgDfKKqnk3yVmBfkt3dvi9U1Wd7OydZDWwAbgPeDnw3yTur6uwwC5ckzW/BaZmqOlFVz3brrwCHgGUXGbIe2FFVp6vqJeAIsHYYxUqS+nNJc+5JVgK3A890TQ8meT7JY0lu6NqWAcd6hk0zxw+DJJuSTCWZmpmZOX+3JGkAfYd7krcAjwMfr6pfA18E3gGsAU4An3u96xzD64KGqm1VNVlVkxMTE5dcuCRpfn2Fe5JrmQ32r1bV1wGq6mRVna2q14Av8Zupl2lgRc/w5cDx4ZUsSVrIguGeJMCjwKGq+nxP+9Kebh8BXujWdwEbklyX5FZgFbB3eCVLkhbSz90ydwD3Az9Osr9r+yRwX5I1zE65HAU+ClBVB5LsBA4ye6fNZu+UkaTLa8Fwr6qnmXse/ZsXGbMV2DpAXZKkAfiEqiQ1yHCXpAb1M+euy8xH2yUNyit3SWqQ4S5JDTLcJalBhrskNchwl6QGGe6S1CDDXZIaZLhLUoN8iEkj50NZ0uXnlbskNchwl6QGGe6S1CDDXZIaZLhLUoMMd0lqkOEuSQ0y3CWpQQuGe5IVSb6X5FCSA0k+1rXfmGR3kp90yxt6xjyU5EiSw0nuGuUJSJIu1M+V+xngE1X1+8B7gc1JVgNbgD1VtQrY023T7dsA3AasAx5JsmQUxUuS5rZguFfViap6tlt/BTgELAPWA9u7btuBe7r19cCOqjpdVS8BR4C1wy5ckjS/S5pzT7ISuB14Brilqk7A7A8A4Oau2zLgWM+w6a7t/GNtSjKVZGpmZubSK5ckzavvcE/yFuBx4ONV9euLdZ2jrS5oqNpWVZNVNTkxMdFvGZKkPvQV7kmuZTbYv1pVX++aTyZZ2u1fCpzq2qeBFT3DlwPHh1OuJKkf/dwtE+BR4FBVfb5n1y5gY7e+EXiyp31DkuuS3AqsAvYOr2RJ0kL6eZ/7HcD9wI+T7O/aPgk8DOxM8gDwMnAvQFUdSLITOMjsnTabq+rs0CuXJM1rwXCvqqeZex4d4M55xmwFtg5QlyRpAD6hKkkNMtwlqUGGuyQ1yHCXpAYZ7pLUIMNdkhpkuEtSgwx3SWqQ4S5JDTLcJalBhrskNchwl6QGGe6S1CDDXZIaZLhLUoMMd0lqkOEuSQ0y3CWpQYa7JDXIcJekBhnuktSgBcM9yWNJTiV5oaft00l+lmR/9/lQz76HkhxJcjjJXaMqXJI0v36u3L8MrJuj/QtVtab7fBMgyWpgA3BbN+aRJEuGVawkqT8LhntV/QD4ZZ/HWw/sqKrTVfUScARYO0B9kqRFGGTO/cEkz3fTNjd0bcuAYz19pru2CyTZlGQqydTMzMwAZUiSzrfYcP8i8A5gDXAC+FzXnjn61lwHqKptVTVZVZMTExOLLEOSNJdFhXtVnayqs1X1GvAlfjP1Mg2s6Om6HDg+WImSpEu1qHBPsrRn8yPA63fS7AI2JLkuya3AKmDvYCVKki7VNQt1SPI14H3ATUmmgU8B70uyhtkpl6PARwGq6kCSncBB4AywuarOjqZ0SdJ8Fgz3qrpvjuZHL9J/K7B1kKIkSYPxCVVJapDhLkkNMtwlqUGGuyQ1yHCXpAYZ7pLUIMNdkhpkuEtSgwx3SWqQ4S5JDTLcJalBhrskNchwl6QGGe6S1CDDXZIaZLhLUoMMd0lqkOEuSQ0y3CWpQYa7JDVowXBP8liSU0le6Gm7McnuJD/pljf07HsoyZEkh5PcNarCJUnz6+fK/cvAuvPatgB7qmoVsKfbJslqYANwWzfmkSRLhlatJKkvC4Z7Vf0A+OV5zeuB7d36duCenvYdVXW6ql4CjgBrh1SrJKlPi51zv6WqTgB0y5u79mXAsZ5+013bBZJsSjKVZGpmZmaRZUiS5jLsX6hmjraaq2NVbauqyaqanJiYGHIZkvTGtthwP5lkKUC3PNW1TwMrevotB44vvjxJ0mIsNtx3ARu79Y3Akz3tG5Jcl+RWYBWwd7ASJUmX6pqFOiT5GvA+4KYk08CngIeBnUkeAF4G7gWoqgNJdgIHgTPA5qo6O6LaJUnzWDDcq+q+eXbdOU//rcDWQYqSJA3GJ1QlqUGGuyQ1yHCXpAYZ7pLUIMNdkhpkuEtSgwx3SWqQ4S5JDTLcJalBhrskNchwl6QGGe6S1CDDXZIaZLhLUoMMd0lqkOEuSQ0y3CWpQYa7JDXIcJekBhnuktSgBf9A9sUkOQq8ApwFzlTVZJIbgX8DVgJHgb+oqv8drExJ0qUYxpX7H1fVmqqa7La3AHuqahWwp9uWJF1Go5iWWQ9s79a3A/eM4DskSRcxaLgX8J0k+5Js6tpuqaoTAN3y5rkGJtmUZCrJ1MzMzIBlSJJ6DTTnDtxRVceT3AzsTvJivwOrahuwDWBycrIGrEOS1GOgK/eqOt4tTwFPAGuBk0mWAnTLU4MWKUm6NIsO9yTXJ3nr6+vAB4EXgF3Axq7bRuDJQYuUJF2aQaZlbgGeSPL6cf61qr6V5EfAziQPAC8D9w5epiTpUiw63Kvqp8B75mj/BXDnIEVJkgbjE6qS1CDDXZIaZLhLUoMMd0lqkOEuSQ0y3CWpQYa7JDXIcJekBhnuktQgw12SGmS4S1KDDHdJapDhLkkNMtwlqUGGuyQ1yHCXpAYZ7pLUIMNdkhpkuEtSgwx3SWqQ4S5JDRpZuCdZl+RwkiNJtozqeyRJFxpJuCdZAvwj8KfAauC+JKtH8V2SpAuN6sp9LXCkqn5aVf8H7ADWj+i7JEnnSVUN/6DJnwPrquqvuu37gT+sqgd7+mwCNnWb7wIOD72QwdwE/HzcRQyR53Pla+2cWjsfuPLO6feqamKuHdeM6AszR9s5P0WqahuwbUTfP7AkU1U1Oe46hsXzufK1dk6tnQ9cXec0qmmZaWBFz/Zy4PiIvkuSdJ5RhfuPgFVJbk3y28AGYNeIvkuSdJ6RTMtU1ZkkDwLfBpYAj1XVgVF81whdsVNGi+T5XPlaO6fWzgeuonMayS9UJUnj5ROqktQgw12SGmS4n6e11yYkeSzJqSQvjLuWYUiyIsn3khxKciDJx8Zd06CSvCnJ3iTPdef0mXHXNAxJliT5ryTfGHctw5DkaJIfJ9mfZGrc9SzEOfce3WsT/hv4E2Zv5/wRcF9VHRxrYQNI8kfAq8BXqurd465nUEmWAkur6tkkbwX2Afdc5f9GAa6vqleTXAs8DXysqv5zzKUNJMnfApPA71TVh8ddz6CSHAUmq+pKeohpXl65n6u51yZU1Q+AX467jmGpqhNV9Wy3/gpwCFg23qoGU7Ne7Tav7T5X9VVXkuXA3cA/jbuWNyrD/VzLgGM929Nc5cHRsiQrgduBZ8ZbyeC6KYz9wClgd1Vd7ef098DfAa+Nu5AhKuA7SfZ1r0+5ohnu51rwtQm6MiR5C/A48PGq+vW46xlUVZ2tqjXMPs29NslVO4WW5MPAqaraN+5ahuyOqvoDZt92u7mb8rxiGe7n8rUJV4FuXvpx4KtV9fVx1zNMVfUr4PvAujGXMog7gD/r5qh3AO9P8i/jLWlwVXW8W54CnmB2GveKZbify9cmXOG6Xz4+Chyqqs+Pu55hSDKR5G3d+puBDwAvjreqxauqh6pqeVWtZPb/0H9U1V+OuayBJLm++wU+Sa4HPghc0XegGe49quoM8PprEw4BO6/C1yacI8nXgB8C70oyneSBcdc0oDuA+5m9GtzffT407qIGtBT4XpLnmb3A2F1VTdw+2JBbgKeTPAfsBZ6qqm+NuaaL8lZISWqQV+6S1CDDXZIaZLhLUoMMd0lqkOEuSQ0y3CWpQYa7JDXo/wHDLluRgybuAQAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "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": [
    "# Male/Female differences in favorite Star Wars movie and most seen movie\n",
    "Interestingly, 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.7.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}