Star_Wars_Survey_Data_Cleaning_Investigations.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# In this project we explore data from the Star Wars Survey from FiveThirtyEight"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# read in the data\n",
    "import pandas as pd\n",
    "star_wars = pd.read_csv(\"star_wars.csv\",encoding=\"ISO-8859-1\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false
   },
   "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>NaN</td>\n",
       "      <td>Response</td>\n",
       "      <td>Response</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>Star Wars: Episode I  The Phantom Menace</td>\n",
       "      <td>...</td>\n",
       "      <td>Yoda</td>\n",
       "      <td>Response</td>\n",
       "      <td>Response</td>\n",
       "      <td>Response</td>\n",
       "      <td>Response</td>\n",
       "      <td>Response</td>\n",
       "      <td>Response</td>\n",
       "      <td>Response</td>\n",
       "      <td>Response</td>\n",
       "      <td>Response</td>\n",
       "    </tr>\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",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>3.292719e+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>1</td>\n",
       "      <td>...</td>\n",
       "      <td>Very favorably</td>\n",
       "      <td>Han</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Male</td>\n",
       "      <td>18-29</td>\n",
       "      <td>$25,000 - $49,999</td>\n",
       "      <td>Bachelor degree</td>\n",
       "      <td>Middle Atlantic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>3.292685e+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>6</td>\n",
       "      <td>...</td>\n",
       "      <td>Very favorably</td>\n",
       "      <td>Han</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>East North Central</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>3.292664e+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>4</td>\n",
       "      <td>...</td>\n",
       "      <td>Very favorably</td>\n",
       "      <td>Han</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</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>9</th>\n",
       "      <td>3.292654e+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>Han</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>Some college or Associate degree</td>\n",
       "      <td>South Atlantic</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 38 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   RespondentID Have you seen any of the 6 films in the Star Wars franchise?  \\\n",
       "0           NaN                                           Response             \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",
       "6  3.292719e+09                                                Yes             \n",
       "7  3.292685e+09                                                Yes             \n",
       "8  3.292664e+09                                                Yes             \n",
       "9  3.292654e+09                                                Yes             \n",
       "\n",
       "  Do you consider yourself to be a fan of the Star Wars film franchise?  \\\n",
       "0                                           Response                      \n",
       "1                                                Yes                      \n",
       "2                                                NaN                      \n",
       "3                                                 No                      \n",
       "4                                                Yes                      \n",
       "5                                                Yes                      \n",
       "6                                                Yes                      \n",
       "7                                                Yes                      \n",
       "8                                                Yes                      \n",
       "9                                                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           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",
       "6           Star Wars: Episode I  The Phantom Menace                                    \n",
       "7           Star Wars: Episode I  The Phantom Menace                                    \n",
       "8           Star Wars: Episode I  The Phantom Menace                                    \n",
       "9           Star Wars: Episode I  The Phantom Menace                                    \n",
       "\n",
       "                                    Unnamed: 4  \\\n",
       "0  Star Wars: Episode II  Attack of the Clones   \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",
       "6  Star Wars: Episode II  Attack of the Clones   \n",
       "7  Star Wars: Episode II  Attack of the Clones   \n",
       "8  Star Wars: Episode II  Attack of the Clones   \n",
       "9  Star Wars: Episode II  Attack of the Clones   \n",
       "\n",
       "                                    Unnamed: 5  \\\n",
       "0  Star Wars: Episode III  Revenge of the Sith   \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",
       "6  Star Wars: Episode III  Revenge of the Sith   \n",
       "7  Star Wars: Episode III  Revenge of the Sith   \n",
       "8  Star Wars: Episode III  Revenge of the Sith   \n",
       "9  Star Wars: Episode III  Revenge of the Sith   \n",
       "\n",
       "                          Unnamed: 6  \\\n",
       "0  Star Wars: Episode IV  A New Hope   \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",
       "6  Star Wars: Episode IV  A New Hope   \n",
       "7  Star Wars: Episode IV  A New Hope   \n",
       "8  Star Wars: Episode IV  A New Hope   \n",
       "9  Star Wars: Episode IV  A New Hope   \n",
       "\n",
       "                                     Unnamed: 7  \\\n",
       "0  Star Wars: Episode V The Empire Strikes Back   \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",
       "6  Star Wars: Episode V The Empire Strikes Back   \n",
       "7  Star Wars: Episode V The Empire Strikes Back   \n",
       "8  Star Wars: Episode V The Empire Strikes Back   \n",
       "9  Star Wars: Episode V The Empire Strikes Back   \n",
       "\n",
       "                                 Unnamed: 8  \\\n",
       "0  Star Wars: Episode VI Return of the Jedi   \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",
       "6  Star Wars: Episode VI Return of the Jedi   \n",
       "7  Star Wars: Episode VI Return of the Jedi   \n",
       "8  Star Wars: Episode VI Return of the Jedi   \n",
       "9  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           Star Wars: Episode I  The Phantom Menace                                                                                              \n",
       "1                                                  3                                                                                              \n",
       "2                                                NaN                                                                                              \n",
       "3                                                  1                                                                                              \n",
       "4                                                  5                                                                                              \n",
       "5                                                  5                                                                                              \n",
       "6                                                  1                                                                                              \n",
       "7                                                  6                                                                                              \n",
       "8                                                  4                                                                                              \n",
       "9                                                  5                                                                                              \n",
       "\n",
       "            ...                    Unnamed: 28  \\\n",
       "0           ...                           Yoda   \n",
       "1           ...                 Very favorably   \n",
       "2           ...                            NaN   \n",
       "3           ...               Unfamiliar (N/A)   \n",
       "4           ...                 Very favorably   \n",
       "5           ...             Somewhat favorably   \n",
       "6           ...                 Very favorably   \n",
       "7           ...                 Very favorably   \n",
       "8           ...                 Very favorably   \n",
       "9           ...             Somewhat favorably   \n",
       "\n",
       "        Which character shot first?  \\\n",
       "0                          Response   \n",
       "1  I don't understand this question   \n",
       "2                               NaN   \n",
       "3  I don't understand this question   \n",
       "4  I don't understand this question   \n",
       "5                            Greedo   \n",
       "6                               Han   \n",
       "7                               Han   \n",
       "8                               Han   \n",
       "9                               Han   \n",
       "\n",
       "  Are you familiar with the Expanded Universe?  \\\n",
       "0                                     Response   \n",
       "1                                          Yes   \n",
       "2                                          NaN   \n",
       "3                                           No   \n",
       "4                                           No   \n",
       "5                                          Yes   \n",
       "6                                          Yes   \n",
       "7                                          Yes   \n",
       "8                                           No   \n",
       "9                                           No   \n",
       "\n",
       "  Do you consider yourself to be a fan of the Expanded Universe?ÂÃ¦  \\\n",
       "0                                           Response                   \n",
       "1                                                 No                   \n",
       "2                                                NaN                   \n",
       "3                                                NaN                   \n",
       "4                                                NaN                   \n",
       "5                                                 No                   \n",
       "6                                                 No                   \n",
       "7                                                 No                   \n",
       "8                                                NaN                   \n",
       "9                                                NaN                   \n",
       "\n",
       "  Do you consider yourself to be a fan of the Star Trek franchise?    Gender  \\\n",
       "0                                           Response                Response   \n",
       "1                                                 No                    Male   \n",
       "2                                                Yes                    Male   \n",
       "3                                                 No                    Male   \n",
       "4                                                Yes                    Male   \n",
       "5                                                 No                    Male   \n",
       "6                                                Yes                    Male   \n",
       "7                                                 No                    Male   \n",
       "8                                                Yes                    Male   \n",
       "9                                                 No                    Male   \n",
       "\n",
       "        Age     Household Income                         Education  \\\n",
       "0  Response             Response                          Response   \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",
       "6     18-29    $25,000 - $49,999                   Bachelor degree   \n",
       "7     18-29                  NaN                High school degree   \n",
       "8     18-29                  NaN                High school degree   \n",
       "9     18-29         $0 - $24,999  Some college or Associate degree   \n",
       "\n",
       "  Location (Census Region)  \n",
       "0                 Response  \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",
       "6          Middle Atlantic  \n",
       "7       East North Central  \n",
       "8           South Atlantic  \n",
       "9           South Atlantic  \n",
       "\n",
       "[10 rows x 38 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# take a brief look at the data (first ten rows)\n",
    "star_wars.head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### It looks like there are some strange values when the respondent's ID is missing or when the survey respondent did not see any of the Star Wars movies."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false
   },
   "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  \\\n",
       "1           ...                 Very favorably   \n",
       "2           ...                            NaN   \n",
       "3           ...               Unfamiliar (N/A)   \n",
       "4           ...                 Very favorably   \n",
       "5           ...             Somewhat favorably   \n",
       "\n",
       "        Which character shot first?  \\\n",
       "1  I don't understand this question   \n",
       "2                               NaN   \n",
       "3  I don't understand this question   \n",
       "4  I don't understand this question   \n",
       "5                            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": [
    "# remove rows where RespondentID is NaN\n",
    "star_wars = star_wars[pd.notnull(star_wars[\"RespondentID\"])]\n",
    "star_wars.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Yes    936\n",
      "No     250\n",
      "Name: Have you seen any of the 6 films in the Star Wars franchise?, dtype: int64\n",
      "Yes    552\n",
      "No     284\n",
      "Name: Do you consider yourself to be a fan of the Star Wars film franchise?, dtype: int64\n",
      "True     936\n",
      "False    250\n",
      "Name: Have you seen any of the 6 films in the Star Wars franchise?, dtype: int64\n",
      "True     552\n",
      "False    284\n",
      "Name: Do you consider yourself to be a fan of the Star Wars film franchise?, dtype: int64\n"
     ]
    }
   ],
   "source": [
    "# convert the \"Have you seen any of the 6 films in the Star Wars \n",
    "# franchise?\" and \"Do you consider yourself to be a fan of the Star\n",
    "# Wars film franchise?\" columns to Boolean types\n",
    "\n",
    "# get unique values\n",
    "print(star_wars[\"Have you seen any of the 6 films in the Star Wars franchise?\"].value_counts())\n",
    "print(star_wars[\"Do you consider yourself to be a fan of the Star Wars film franchise?\"].value_counts())\n",
    "\n",
    "# convert using a dictionary:\n",
    "yes_no = {\"Yes\":True,\n",
    "          \"No\":False}\n",
    "\n",
    "star_wars[\"Have you seen any of the 6 films in the Star Wars franchise?\"] = star_wars[\"Have you seen any of the 6 films in the Star Wars franchise?\"].map(yes_no)\n",
    "star_wars[\"Do you consider yourself to be a fan of the Star Wars film franchise?\"] = star_wars[\"Do you consider yourself to be a fan of the Star Wars film franchise?\"].map(yes_no)\n",
    "\n",
    "# check\n",
    "print(star_wars[\"Have you seen any of the 6 films in the Star Wars franchise?\"].value_counts())\n",
    "print(star_wars[\"Do you consider yourself to be a fan of the Star Wars film franchise?\"].value_counts())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Clean up some of the survey question data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Star Wars: Episode I  The Phantom Menace    673\n",
      "Name: Which of the following Star Wars films have you seen? Please select all that apply., dtype: int64\n",
      "Star Wars: Episode II  Attack of the Clones    571\n",
      "Name: Unnamed: 4, dtype: int64\n",
      "Star Wars: Episode III  Revenge of the Sith    550\n",
      "Name: Unnamed: 5, dtype: int64\n",
      "Star Wars: Episode IV  A New Hope    607\n",
      "Name: Unnamed: 6, dtype: int64\n",
      "Star Wars: Episode V The Empire Strikes Back    758\n",
      "Name: Unnamed: 7, dtype: int64\n",
      "Star Wars: Episode VI Return of the Jedi    738\n",
      "Name: Unnamed: 8, dtype: int64\n",
      "True     673\n",
      "False    513\n",
      "Name: Which of the following Star Wars films have you seen? Please select all that apply., dtype: int64\n",
      "False    615\n",
      "True     571\n",
      "Name: Unnamed: 4, dtype: int64\n",
      "False    636\n",
      "True     550\n",
      "Name: Unnamed: 5, dtype: int64\n",
      "True     607\n",
      "False    579\n",
      "Name: Unnamed: 6, dtype: int64\n",
      "True     758\n",
      "False    428\n",
      "Name: Unnamed: 7, dtype: int64\n",
      "True     738\n",
      "False    448\n",
      "Name: Unnamed: 8, dtype: int64\n"
     ]
    },
    {
     "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>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",
       "   Which of the following Star Wars films have you seen? Please select all that apply.  \\\n",
       "1                                               True                                     \n",
       "2                                              False                                     \n",
       "3                                               True                                     \n",
       "4                                               True                                     \n",
       "5                                               True                                     \n",
       "\n",
       "   Unnamed: 4  Unnamed: 5  Unnamed: 6  Unnamed: 7  Unnamed: 8  \\\n",
       "1        True        True        True        True        True   \n",
       "2       False       False       False       False       False   \n",
       "3        True        True       False       False       False   \n",
       "4        True        True        True        True        True   \n",
       "5        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  \\\n",
       "1           ...                 Very favorably   \n",
       "2           ...                            NaN   \n",
       "3           ...               Unfamiliar (N/A)   \n",
       "4           ...                 Very favorably   \n",
       "5           ...             Somewhat favorably   \n",
       "\n",
       "        Which character shot first?  \\\n",
       "1  I don't understand this question   \n",
       "2                               NaN   \n",
       "3  I don't understand this question   \n",
       "4  I don't understand this question   \n",
       "5                            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": [
    "# convert the \"Which of the following Star Wars films have you seen? \n",
    "# Please select all that apply.\" and \"Unnamed: 4\" - \"Unnamed: 8\"\n",
    "# columns so that they contain Boolean values\n",
    "import numpy as np\n",
    "for i in range(3,9):\n",
    "    print(star_wars.iloc[:,i].value_counts())\n",
    "dict = {\"Star Wars: Episode I  The Phantom Menace\":True,\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",
    "        np.nan:False}\n",
    "for i in range(3,9):\n",
    "    star_wars.iloc[:,i] = star_wars.iloc[:,i].map(dict)\n",
    "for i in range(3,9):\n",
    "    print(star_wars.iloc[:,i].value_counts())\n",
    "star_wars.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "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",
       "       'seen_1', 'seen_2', 'seen_3', 'seen_4', 'seen_5', 'seen_6',\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": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# rename these columns to have more intuitive names\n",
    "col_dict = {}\n",
    "num = 0\n",
    "for i in range(3,9):\n",
    "    num += 1\n",
    "    col_dict[star_wars.columns[i]]=\"seen_\"+str(num)\n",
    "star_wars = star_wars.rename(columns=col_dict)\n",
    "\n",
    "# check\n",
    "star_wars.columns"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Clean up the next set of columns which represent rankings of the 6 Star Wars movies"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": false
   },
   "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>ranking_1</th>\n",
       "      <th>ranking_2</th>\n",
       "      <th>ranking_3</th>\n",
       "      <th>ranking_4</th>\n",
       "      <th>ranking_5</th>\n",
       "      <th>ranking_6</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   ranking_1  ranking_2  ranking_3  ranking_4  ranking_5  ranking_6\n",
       "1        3.0        2.0        1.0        4.0        5.0        6.0\n",
       "2        NaN        NaN        NaN        NaN        NaN        NaN\n",
       "3        1.0        2.0        3.0        4.0        5.0        6.0\n",
       "4        5.0        6.0        1.0        2.0        4.0        3.0\n",
       "5        5.0        4.0        6.0        2.0        1.0        3.0"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# convert columns 9 - 14 to float type\n",
    "star_wars[star_wars.columns[9:15]] = star_wars[star_wars.columns[9:15]].astype(float)\n",
    "\n",
    "# rename columns\n",
    "col_dict = {}\n",
    "num = 0\n",
    "for i in range(9,15):\n",
    "    num += 1\n",
    "    col_dict[star_wars.columns[i]]=\"ranking_\"+str(num)\n",
    "star_wars = star_wars.rename(columns=col_dict)\n",
    "\n",
    "# check\n",
    "star_wars.iloc[:,9:15].head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Find the highest-ranked Star Wars movie"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# find the mean value of the ranking columns\n",
    "means = star_wars.iloc[:,9:15].mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x7f76ce01f5f8>"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXEAAAEnCAYAAABfUHNOAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAGwdJREFUeJzt3X9sVfX9x/HXKa2uP2ZKN73VSwtk1JRC6+3tsDoMXurW\nRKqVOcycCXUKaxpxELYl2/jH24yxGDcSDIY0MyFrpoOEmJTNFjTA7bKmpcFRdetMEddfN9hNca2d\nHYze8/1jX24st+Ve2tN77+f2+UhM7r3n03ve71VffPbhnPOxbNu2BQAwUlqiCwAAzB4hDgAGI8QB\nwGCEOAAYjBAHAIMR4gBgsJhDPBQKyev1qra2NuJYe3u7cnNz5fV65fV6tXv3bkeLBABMLz3Wgfv2\n7VNJSYnGxsamPb5u3TodPXrUscIAANHFNBMfHh5Wa2urtm7dOuMY7hkCgPiLKcR37typF154QZZl\nzTims7NTHo9HNTU16u3tdaxAAMDMoi6nvP7663K5XPJ4PAoEAtPOuCsqKjQ4OKisrCy1tbVp48aN\n6uvrixh3vT8EAAAzm3G1w47ipz/9qV1QUGAvX77czs/Pt7Ozs+3Nmzdf92eWLVtmf/zxxxGfx3A6\nRz333HNxPV+80Z+5Urk326Y/p10vO6Mup+zZs0eDg4P64IMPdOjQIVVVVam5uXnKmJGRkfDr7u5u\n2batvLy8ufyhAwCIQcxXp1yrqalJlmWpvr5eR44c0YEDB5SRkaHMzEwdPnzYyRoBADOw/n+qHp+T\nWVZcr2IJBALy+XxxO1+80Z+5Urk3if6cdr3sTOkQB4BUcL3s5LZ7ADAYIQ4ABiPEMe+W5efLsqy4\n/bMsPz/RLQNxw5o45p1lWYrnb90Sj4FAamFNHABSFCEOAAYjxAHAYIQ4ABiMEAcAgxHiAGAwQhwA\nDEaIA4DBCHEAMBghDgAGI8QBwGAxh3goFJLX61Vtbe20x7dv366ioiJ5PB719PQ4VuBCkL8kvg+I\nyl/CA6KAVBHz9mz79u1TSUmJxsbGIo61tbXp/PnzOnfunE6fPq2GhgZ1dXU5WmgqGwmOSP44ns8/\nEn0QACPENBMfHh5Wa2urtm7dOu3xlpYW1dXVSZIqKys1Ojo6ZfNkAMD8iCnEd+7cqRdeeEGWZU17\nPBgMqqCgIPze7XYrGAw6UyEAYEZRl1Nef/11uVwueTweBQKBOT+n2e/3h1/7fL6U3kwVAGYjEAgo\nEAjENDbqphC7du3Sb3/7W6Wnp2tiYkKffvqpHn30UTU3N4fHNDQ0aP369fr2t78tSSouLlZ7e7tc\nLtfUk7EpxLQsy4rrmrj88d00gU0hgLmZ06YQe/bs0eDgoD744AMdOnRIVVVVUwJckmpra8OfdXV1\nKTc3NyLAAQDOi/nqlGs1NTXJsizV19drw4YNam1t1YoVK5Sdna2DBw86WSMAYAbssZkEWE5x+Hxi\nOQWphT02ASBFEeIAYDBCHAAMRogDgMEIcQAwGCEOAAYjxAHAYIQ4ABjMiBDPz18W300T8pclumUA\niMmsb7uPp5GRASmO9/yNjEz/yF0ASDZGzMQBANMjxAHAYIQ4ABiMEAcAgxHiAGAwQhwADBY1xC9d\nuqTKykqVl5dr1apV2rVrV8SY9vZ25ebmyuv1yuv1avfu3fNSLABgqqjXid988806deqUsrKyNDk5\nqbVr16qjo0Nr166dMm7dunU6evTovBUKAIgU03JKVlaWpP/NykOhkBYvXhwxhu2wACD+YgrxUCik\n8vJy5efny+fzqaSkJGJMZ2enPB6Pampq1Nvb63ihAIBIMd12n5aWprNnz2psbEzV1dVqb2/X/fff\nHz5eUVGhwcFBZWVlqa2tTRs3blRfX9+03+X3+8OvfT6ffD7fnBoAgFQTCAQUCARiGnvDu93/7Gc/\nU1ZWln74wx/OOGb58uV66623lJeXN/Vks9zt3rIsxfPZKdLs6pz12djt3tnzieU9pJY57Xb/0Ucf\naXR0VJI0MTGhN998Ux6PZ8qYkZGR8Ovu7m7Zth0R4AAA50VdTrlw4YKefPJJ2batUCikzZs364EH\nHlBTU5Msy1J9fb2OHDmiAwcOKCMjQ5mZmTp8+HA8ageABe+Gl1PmdDKWU6Y/G8spzp5PLKcgtcxp\nOQUAkLwIcQAwGCEOAAYjxAHAYIQ4ABiMEAcAgxHiwBzlFxbKsqy4/JNfWJjodpFkYnp2CoCZjQwN\nSadOxedc69fH5TwwBzNxADAYIQ4ABiPEAcBghDgAGIwQBwCDEeIAYDBCHAAMRogDgMGihvilS5dU\nWVmp8vJyrVq1Srt27Zp23Pbt21VUVCSPx6Oenh7HCwUARIoa4jfffLNOnTqls2fP6p133tHJkyfV\n0dExZUxbW5vOnz+vc+fOqampSQ0NDfNWMAA4pbAwP26PTLAsS4WF+Y73ENNt91lZWZL+NysPhUJa\nvHjxlOMtLS2qq6uTJFVWVmp0dFQjIyNyuVwOlwsAzhkaGonXExMkSevXj0QfdINiWhMPhUIqLy9X\nfn6+fD6fSkpKphwPBoMqKCgIv3e73QoGg85WCgCIENNMPC0tTWfPntXY2Jiqq6vV3t6u+++/f1Yn\n9Pv94dc+n08+n29W3wMAqSoQCCgQCMQ09oaeYnjLLbeopqZGZ86cmRLibrdbQ0ND4ffDw8Nyu93T\nfsfnQxwAEOnaCW5jY+OMY6Mup3z00UcaHR2VJE1MTOjNN9+Ux+OZMqa2tlbNzc2SpK6uLuXm5rIe\nDgBxEHUmfuHCBT355JOybVuhUEibN2/WAw88oKamJlmWpfr6em3YsEGtra1asWKFsrOzdfDgwXjU\nDgALnmXbth23k1mWZnM6y7Ikxa1MSbOrc9ZnsyzJH7fTSX7Fvb/4/vbi31/cLnFYvz6uvaU6y7Li\nfHXK7P7dvF52cscmABiMEAcAgxHiAGAwQhwADEaIA4DBCHEAMBghDgAGI8QBwGCEOAAYjBAHAIMR\n4gBgMEIcAAxGiAOAwQhxADAYIQ4ABosa4sPDw6qqqtKqVatUWlqqF198MWJMe3u7cnNz5fV65fV6\ntXv37nkpFgAwVdSdfdLT07V37155PB6Nj4+roqJC1dXVKi4unjJu3bp1Onr06LwVCgCIFHUmnp+f\nH95TMycnRytXrlQwGIwYx24jABB/N7Qm3t/fr56eHlVWVkYc6+zslMfjUU1NjXp7ex0rEAAws6jL\nKVeNj49r06ZN2rdvn3JycqYcq6io0ODgoLKystTW1qaNGzeqr69v2u/x+/3h1z6fTz6fb1aFA5h/\nhfmFGhoZitv5ClwFGvxwMG7nS1aBQECBQCCmsTFtlHzlyhU99NBDevDBB7Vjx46oX7p8+XK99dZb\nysvLm3oyNkqe/mxslOzs+cRGyU6xLEunFL+dhNcrAf0thI2Sn376aZWUlMwY4CMjI+HX3d3dsm07\nIsABAM6LupzS0dGhV155RaWlpSovL5dlWdqzZ48GBgZkWZbq6+t15MgRHThwQBkZGcrMzNThw4fj\nUTsALHhRQ3zt2rWanJy87pht27Zp27ZtjhUFAIgNd2wCgMEIcQAwGCEOAAYjxAHAYIQ4ABiMEAcA\ngxHiAGAwQhwADEaIA4DBCHEAMBghDgAGI8QBwGCEOAAYjBAHAIMR4gBgMEIcAAwWNcSHh4dVVVWl\nVatWqbS0VC+++OK047Zv366ioiJ5PB719PQ4XigAIFLUnX3S09O1d+9eeTwejY+Pq6KiQtXV1Sou\nLg6PaWtr0/nz53Xu3DmdPn1aDQ0N6urqmtfCAQAxzMTz8/Pl8XgkSTk5OVq5cqWCweCUMS0tLaqr\nq5MkVVZWanR0dMrmyQCA+XFDa+L9/f3q6elRZWXllM+DwaAKCgrC791ud0TQAwCcF3U55arx8XFt\n2rRJ+/btU05OzqxP6Pf7w699Pp98Pt+svwsAUlEgEFAgEIhpbEwhfuXKFW3atEmbN2/WI488EnHc\n7XZraGgo/H54eFhut3va7/p8iAMAIl07wW1sbJxxbEzLKU8//bRKSkq0Y8eOaY/X1taqublZktTV\n1aXc3Fy5XK4bKBkAMBtRZ+IdHR165ZVXVFpaqvLyclmWpT179mhgYECWZam+vl4bNmxQa2urVqxY\noezsbB08eDAetQPAghc1xNeuXavJycmoX7R//35HCgIAxI47NgHAYIQ4ABiMEAcAgxHiAGAwQhwA\nDEaIA4DBCHEAMBghDgAGI8QBwGCEOAAYjBAHAIMR4gBgMEIcAAxGiAOAwQhxADAYIQ4ABosa4lu2\nbJHL5VJZWdm0x9vb25Wbmyuv1yuv16vdu3c7XiQAYHpRd/Z56qmn9P3vf191dXUzjlm3bp2OHj3q\naGEAgOiizsTvu+8+LV68+LpjbNt2rCAAQOwcWRPv7OyUx+NRTU2Nent7nfhKAEAMoi6nRFNRUaHB\nwUFlZWWpra1NGzduVF9f34zj/X5/+LXP55PP55trCQCQUgKBgAKBQExj5xziOTk54dcPPvignnnm\nGV28eFF5eXnTjv98iAMAIl07wW1sbJxxbEzLKbZtz7juPTIyEn7d3d0t27ZnDHAAgLOizsSfeOIJ\nBQIBffzxxyosLFRjY6MuX74sy7JUX1+vI0eO6MCBA8rIyFBmZqYOHz4cj7oBAIohxF999dXrHt+2\nbZu2bdvmWEEAgNhxxyYAGIwQBwCDEeIAYDBCHAAMRogDgMEIcQAwGCEOAAYjxAHAYIQ4ABiMEAcA\ngxHiAGAwQhwADEaIA4DBCHEAMBghDgAGI8QBwGBRQ3zLli1yuVwqKyubccz27dtVVFQkj8ejnp4e\nRwsEAMwsaog/9dRTOn78+IzH29radP78eZ07d05NTU1qaGhwtEAAwMyihvh9992nxYsXz3i8paVF\ndXV1kqTKykqNjo5O2TwZADB/5rwmHgwGVVBQEH7vdrsVDAbn+rUAgBhE3SjZaX6/P/za5/PJ5/PF\nuwQASGqBQECBQCCmsXMOcbfbraGhofD74eFhud3uGcd/PsQBAJGuneA2NjbOODam5RTbtmXb9rTH\namtr1dzcLEnq6upSbm6uXC7XDZQLAJitqDPxJ554QoFAQB9//LEKCwvV2Nioy5cvy7Is1dfXa8OG\nDWptbdWKFSuUnZ2tgwcPxqNuAIBiCPFXX3016pfs37/fkWIAADeGOzYBwGCEOAAYjBAHAIMR4gBg\nMEIcAAxGiAOAwQhxADAYIQ4ABiPEAcBghDgAGIwQBwCDEeIAYDBCHAAMRogDgMEIcQAwGCEOAAaL\nKcSPHTum4uJi3XnnnXr++ecjjre3tys3N1der1der1e7d+92vFAAQKSoO/uEQiE9++yzOnHihO64\n4w6tWbNGjzzyiIqLi6eMW7dunY4ePTpvhQIAIkWdiXd3d6uoqEhLly5VRkaGHn/8cbW0tESMm2kj\nZQDA/Ika4sFgUAUFBeH3S5YsUTAYjBjX2dkpj8ejmpoa9fb2OlslAGBaUZdTYlFRUaHBwUFlZWWp\nra1NGzduVF9f37Rj/X5/+LXP55PP53OiBABIGYFAQIFAIKaxUUPc7XZrcHAw/H54eFhut3vKmJyc\nnPDrBx98UM8884wuXryovLy8iO/7fIgDACJdO8FtbGyccWzU5ZQ1a9bo/fff18DAgC5fvqxDhw6p\ntrZ2ypiRkZHw6+7ubtm2PW2AAwCcFXUmvmjRIu3fv1/V1dUKhULasmWLVq5cqaamJlmWpfr6eh05\nckQHDhxQRkaGMjMzdfjw4XjUDgALnmXH8bISy7JmdRWLZVmS4nn1y+zqnPXZLEvyx+10kj++VxNZ\nlhXn3178+9OpU/E52fr1ce/tlOLUm6T1SkB/8WtP69fP7t/N62Und2wCgMEIcQAwGCEOAAYjxAHA\nYIQ4ABiMEAcAgxHiAGAwQhwADEaIA4DBCHEAMBghDgAGI8QBwGCEOAAYjBAHAIMR4gBgsJhC/Nix\nYyouLtadd96p559/ftox27dvV1FRkTwej3p6ehwtcvYCiS5gfv090QXMr0CiC5hPSfPfyPzoUYr3\nl0TtRQ3xUCikZ599VsePH9df//pX/e53v9N77703ZUxbW5vOnz+vc+fOqampSQ0NDfNW8I0JJLqA\n+dWf6ALmVyDRBcynZEqBeUCIx0/UEO/u7lZRUZGWLl2qjIwMPf7442ppaZkypqWlRXV1dZKkyspK\njY6OTtl3EwAwP6KGeDAYVEFBQfj9kiVLFAwGrzvG7XZHjAEAOC/qRslO+99+mbP6yVn+XOPszjbr\nOmfJP8ufa5/dj8W7v/j+9hLw+1u//sZ/5je/mdWp4t3bes2iN0m/kSH9za692f76HO8vaoi73W4N\nDg6G3w8PD8vtdkeMGRoauu4YKb6b1wLAQhB1OWXNmjV6//33NTAwoMuXL+vQoUOqra2dMqa2tlbN\nzc2SpK6uLuXm5srlcs1PxQCAsKgz8UWLFmn//v2qrq5WKBTSli1btHLlSjU1NcmyLNXX12vDhg1q\nbW3VihUrlJ2drYMHD8ajdgBY8CybNQ4AMBZ3bAKAwQhxADAYIQ4ABlsQIZ4qf9H63nvv6cSJExof\nH5/y+bFjxxJUkbM6OjrU29srSWpvb9evfvUrnThxIsFVzZ+rdzmnoj/96U/au3ev3njjjUSXMmen\nT5/W2NiYJGliYkLPPfecHn74Yf34xz/W6OhogqtbIH+xWVhYOOVadxO9+OKLeumll7Ry5Ur19PRo\n3759euSRRyRJXq9Xf/7znxNc4dzs2rVLJ0+eVCgUks/n0x//+EfV1NTozTffVG1trX70ox8lusQ5\nufayXNu2derUKVVVVUmSjh49moiyHHP33Xeru7tbkvTrX/9aL730kr75zW/qjTfe0MMPP6yf/OQn\nCa5w9latWqW3335b6enpqq+vV1ZWljZt2qQTJ07o7bff1muvvZbQ+lImxMvKyqb93LZt9fX16dKl\nS3GuyFmlpaXq7OxUTk6O+vv7tWnTJm3evFk7duxQeXm5zp49m+gS52TVqlV65513dOnSJeXn52t4\neFi33HKLJiYmdM899+jtt99OdIlz4vV6VVJSoq1bt8qyLNm2re985zs6dOiQJOn+++9PcIVz8/l/\nB9esWaPW1lbdeuut+ve//6177rlH7777boIrnL2VK1fqb3/7m6TICVMyPLU17rfdz5eRkREdP35c\nixcvnvK5bdv62te+lqCqnBMKhZSTkyNJWrZsmQKBgDZt2qSBgYGUuBP2pptu0qJFi5SVlaWvfOUr\nuuWWWyRJmZmZSkszf9XvzJkz2rdvn37+85/rhRdekMfjUWZmpvHhfVUoFNInn3yiUCikyclJ3Xrr\nrZKk7OxspaebHTOrV6/WwYMH9dRTT+muu+7SmTNn9NWvflV9fX3KyMhIdHmpE+IPPfSQxsfH5fF4\nIo75fL74F+Qwl8ulnp6ecH85OTn6wx/+oKefftroWc5VN910kz777DNlZWXprbfeCn8+Ojoa/+eg\nzIO0tDTt3LlTjz32mHbu3CmXy6UrV64kuizHjI6OqqKiQrZty7IsXbhwQbfffrvGx8eNn2S8/PLL\n2rFjh3bv3q0vf/nLuvfee1VQUKCCggK9/PLLiS4vdZZTYvXJJ59EzNZNMDw8rPT0dOXn50cc6+jo\n0Nq1ayWZ29+lS5d08803R3z+0Ucf6cKFCyotLZVkbn/Xev3119XR0aE9e/ZM+TxV+rvqs88+08jI\niJYvXy7J7P7Gxsb097//XVeuXNGSJUsiHi2SqN4WXIinwl8CXg/9mY3+zJWo3sxfbLxBqf5nFv2Z\njf7MlajeFlyIp8L66vXQn9noz1yJ6m3BhTgApJIFF+Kp/H/nJPozHf2ZK1G9pdxfbF68eDHisy9+\n8Yvh6zkvXryovLy8eJflGPqjv2SWyv0lbW92ilm6dKmdlpZmf+lLX7Lz8vLstLQ0+4477rDLy8vt\nM2fOJLq8OaM/s9GfuZK1t5QL8a1bt9rHjh0Lvz9+/LhdX19vd3Z22nfffXcCK3MG/ZmN/syVrL2l\nXIivXr064rPS0lLbtm37rrvuinc5jqM/s9GfuZK1t5S57f6q22+/Xc8//7wef/xxSdLhw4flcrk0\nOTmZEs/goD+z0Z+5kra3hP3xMU/++c9/2s8++6zt8Xhsj8djb9u2zf7HP/5hX7p0yT537lyiy5sz\n+jMb/ZkrWXtLuatTAGAhSbnllL6+Pv3yl79Uf3//lKfEnTx5MoFVOYf+zEZ/5krW3lJuJn7XXXep\noaFBFRUVWrRoUfjzioqKBFblHPozG/2ZK1l7S7kQr6iomPI86lRDf2ajP3Mla2+L/H6/P9FFOOnC\nhQvq7e3VkiVL9N///lcTExOamJhQZmZmoktzBP2Zjf7Mlay9pdxM/OrD5z/Psix98MEHCajGefRn\nNvozV7L2lnIhDgALScpcnXLy5ElVVVXptddem/b4o48+GueKnEV/9JfMUrm/ZO8tZUK8vb1dVVVV\n+v3vfx9xzLKshP8PPVf0R3/JLJX7S/beUm45ZboNd01+/OW16M9s9GeuZO3N7IcZTOPRRx+dciH+\nhx9+qG984xsJrMhZ9Gc2+jNXsvaWciG+ceNGPfbYY5qcnFR/f7+qq6v1i1/8ItFlOYb+zEZ/5kra\n3hLzyJb5tX//fvuhhx6yV69ebXd0dCS6HMfRn9noz1zJ2FvKrInv3bs3/Nq2bTU3N6usrEzl5eWS\npB/84AeJKs0R9Ed/ySyV+0v23lLm6pRPP/10yvurf2N87eemoj+z0Z+5kr23lJmJA8BClDIz8auS\n9XGRTqE/s9GfuZK1t5SbiSfr4yKdQn9moz9zJWtvKRfiyfq4SKfQn9noz1zJ2huPojUM/ZmN/syV\nrL2l3Ew8WR8X6RT6Mxv9mStZe0u5EAeAhSTlrk6RpL/85S/q7e3Vf/7zn/BndXV1CazIWfRnNvoz\nV1L2Fu9bROeb3++3fT6ffdttt9nf/e53bZfLZX/rW99KdFmOoT+z0Z+5krW3lAvx1atX25OTk3ZZ\nWZlt27b94Ycf2l//+tcTXJVz6M9s9GeuZO0t5Z5i+IUvfEFpaWlKT0/X2NiYbrvtNg0NDSW6LMfQ\nn9noz1zJ2ltKrYnbtq2ysjL961//0ve+9z1VVFQoJydH9957b6JLcwT9mY3+zJXMvaXc1SmlpaV6\n9913JUn9/f0aGxtTWVlZgqtyDv2Zjf7Mlay9pdzNPqdPn9aSJUvkdruVm5srl8uV6JIcRX9moz9z\nJWtvKTcTLy4u1vvvv6+lS5cqOztbtm3Lsiy98847iS7NEfRnNvozV7L2lnIhPjAwMO3nS5cujXMl\n84P+zEZ/5krW3lIuxAFgIUm5SwwBYCEhxAHAYIQ4ABiMEAcAg/0fv5GjmhksaH0AAAAASUVORK5C\nYII=\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x7f76cfb12eb8>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# make a bar chart\n",
    "%matplotlib inline\n",
    "means.plot.bar()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Looks like the Star Wars movie with the highest ranking is Star Wars: Episode V The Empire Strikes Back (the one with the iconic light saber battle between Luke and Darth Vader)."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Also get the number of respondents who saw each movie:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(1186, 38)\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXQAAAEZCAYAAACHCd7XAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAHLFJREFUeJzt3X9MXfX9x/HnaaFm1ZZ067i33vLD6RW5tVq0Mn9s80IZ\nLHW7tJveMbt659yPpNmmZsnqTJZBsnhp9o0/msmSzSFEjXizOWBTKmq5iWlVtNa6CbYDWQs3cpkO\nqdoqpdzvH9W7/kIu9N5z4cPrkTSB23Pueb96m9f9cO65XCsWi8UQEZFZb166BxARkeRQoYuIGEKF\nLiJiCBW6iIghVOgiIoZQoYuIGCKhQg8Gg6xYsYJLLrmEDRs2MDo6yvDwMOXl5RQUFFBRUcHIyMgJ\n27vdbgoLC2lvb0/Z8CIi8j/WZNeh79+/n5KSEt544w0WLFjAt7/9bdauXUtXVxef+9zn+MUvfsGW\nLVsYHh6mtraWrq4uNmzYwEsvvcTAwABlZWX861//wrIsuzKJiMxJk67QFy9ezIIFC/jggw8YGxvj\n8OHDuFwuWlpaCAQCAAQCAZqbmwFobW2lqqqKjIwM8vPzcbvddHZ2pjaFiIhMXuhLlizh5z//Obm5\nubhcLrKysigrKyMajeJwOABwOp0MDQ0BEIlEyMnJie/vcrmIRCIpGl9ERD6RMdkGb775Jvfccw/7\n9+8nKyuLG264gUceeeSUUyhTPaWiUzAiItMz0ZnySVfoL7/8Mtdccw2f/exnmT9/PuvXr2fnzp04\nHA6i0SgAg4ODZGdnA8dW5P39/fH9BwYGcLlcEw5l159f//rXth7P7j/KN7v/mJzP5GzpyPdpJi30\ngoICXnjhBT788ENisRjPPvssHo8Hn89HQ0MDAI2NjVRWVgLg8/loampidHSUvr4+enp6KC4unuww\nIiJyhiY95XLppZdy0003cfnllzN//nyKior40Y9+xHvvvYff76e+vp68vDxCoRAAHo8Hv9+Px+Mh\nMzOTuro6nV4REbHBpJctpuzAljXpjw/JFA6H8Xq9th3Pbso3u5mcz+RsYH++T+vOOVPoIiIm+LTu\n1Fv/RUQMoUIXETGECl1ExBAqdBERQ6jQRUQMoUIXETGECl1EEpLrzMWyLNv+5Dpz0x151tF16CKS\nEMuy6KDDtuOVUKKOOA1dhy4iMgeo0EVEDKFCFxExhApdRMQQKnQRESA312nvVTy5zqRnmPT3oYuI\nzAX9/VE67LuIh5KSaNLvUyt0ERFDqNBFRAyhQhcRMYQKXUTEEJMW+r59+ygqKuKyyy6jqKiIrKws\ntm7dyvDwMOXl5RQUFFBRUcHIyEh8n2AwiNvtprCwkPb29pQGEBGRYyYt9AsvvJDdu3fzyiuvsGvX\nLs4++2zWr19PbW0tZWVl7N27l9LSUoLBIABdXV2EQiG6u7tpa2tj06ZN+n0MIiI2mNIpl2eeeYbz\nzz+fnJwcWlpaCAQCAAQCAZqbmwFobW2lqqqKjIwM8vPzcbvddHZ2Jn9yERE5wZQK/bHHHuPGG28E\nIBqN4nA4AHA6nQwNDQEQiUTIycmJ7+NyuYhEIsmaV0REJpDwG4uOHDlCa2srW7ZsAY79Csfjnfx9\nIqqrq+Nfe71evF7vlO9DRMRk4XCYcDic0LYJF3pbWxuXX345S5cuBcDhcMRX6YODg2RnZwPHVuT9\n/f3x/QYGBnC5XKe9z+MLXURETnXyYrempmbCbRM+5fLoo4/yne98J/69z+ejoaEBgMbGRiorK+O3\nNzU1MTo6Sl9fHz09PRQXF08xgoiITFVCK/RDhw7xzDPP8Ic//CF+2+bNm/H7/dTX15OXl0coFALA\n4/Hg9/vxeDxkZmZSV1c3rdMxIiIyNfoIOhFJiOkfQWdZls2/nItp5dNH0ImIzAEqdBERQ6jQRUQM\nMesK3enMt/VTRZzO/HRHFhFJyKz7xKJodD9g3wsl0aiu0BGR2WHWrdBFROT0VOgiIoZQoYuIGEKF\nLiJiCBW6iIghVOgiIoZQoYuIGEKFLiJiCBW6iIghVOgiIoZQoYuIGEKFLiJiCBW6iIghVOgiIoZI\nqNBHRka44YYbKCwsZMWKFbz44osMDw9TXl5OQUEBFRUVjIyMxLcPBoO43W4KCwtpb29P2fAiIvI/\nCRX6rbfeytq1a+nu7mbPnj1cdNFF1NbWUlZWxt69eyktLSUYDALQ1dVFKBSiu7ubtrY2Nm3apA+D\nFhGxwaSFfvDgQZ577jluvvlmADIyMsjKyqKlpYVAIABAIBCgubkZgNbWVqqqqsjIyCA/Px+3201n\nZ2cKI4jMHM7cXHs/USs3N92RZQaZ9BOL+vr6WLp0KTfffDN79uxh9erV3HvvvUSjURwOBwBOp5Oh\noSEAIpEIV111VXx/l8tFJBJJ0fgiM0u0vx86Ouw7XkmJbceSmW/SQh8bG+OVV17h/vvvZ/Xq1dx+\n++3U1tZiWSd+NNvJ3yeiuro6/rXX68Xr9U75PkRETBYOhwmHwwltO2mhL1++nJycHFavXg3At771\nLWpra3E4HPFV+uDgINnZ2cCxFXl/f398/4GBAVwu12nv+/hCFxGRU5282K2pqZlw20nPoTscDnJy\ncti3bx8Azz77LCtWrMDn89HQ0ABAY2MjlZWVAPh8PpqamhgdHaWvr4+enh6Ki4vPII6IiCRi0hU6\nwNatW9mwYQNHjhzhC1/4Ag8++CBHjx7F7/dTX19PXl4eoVAIAI/Hg9/vx+PxkJmZSV1d3bROx4iI\nyNRYsTRdU2hZ1rQuZzz25GDnyNObU+Ymy7JsfVGUkhLb/n9alkUH9mUrwb5s8HE+ex+6aXfgRPvp\nnaIiIoZQoYuIGEKFLiJiCBX6DONc7rT3nYbLnemOLCJJktBVLmKfaCQK1TYerzpq38FEJKW0QhcR\nMYQKXUTEECp0ERFDqNBFRAyhQhdb5TvtvYon36mreGTu0FUuYqv90ai9v7ghqqt4ZO7QCl1ExBAq\ndBERQ6jQRUQMoUIXETGECl1ExBAqdBERQ6jQRUQMoUIXETFEQoWen5/PpZdeSlFREcXFxQAMDw9T\nXl5OQUEBFRUVjIyMxLcPBoO43W4KCwtpb29PzeQiInKChAp93rx5hMNhdu/eTWdnJwC1tbWUlZWx\nd+9eSktLCQaDAHR1dREKheju7qatrY1NmzbpQ5ZFRGyQUKHHYjHGx8dPuK2lpYVAIABAIBCgubkZ\ngNbWVqqqqsjIyCA/Px+32x1/EhARkdRJqNAty+KrX/0qV1xxBQ888AAA0WgUh8MBgNPpZGhoCIBI\nJEJOTk58X5fLRSQSSfbcIiJykoR+OdeOHTtYtmwZ//nPf+LnzS3LOmGbk79PRHV1dfxrr9eL1+ud\n8n2IiJgsHA4TDocT2jahQl+2bBkAn//851m3bh2dnZ04HI74Kn1wcJDs7Gzg2Iq8v78/vu/AwAAu\nl+u093t8oYuIyKlOXuzW1NRMuO2kp1wOHTrE+++/D8AHH3xAe3s7K1euxOfz0dDQAEBjYyOVlZUA\n+Hw+mpqaGB0dpa+vj56enviVMSIikjqTrtCj0Sjr16/HsizGxsbYsGED5eXlrF69Gr/fT319PXl5\neYRCIQA8Hg9+vx+Px0NmZiZ1dXXTOh0jIiJTY8XSdE2hZVnTupzx2JODrR+RYOtll5ZlQbVth4Nq\nbM9n76Nnfz46Omw7HiUltuWzLIsO7MtWgn3Z4ON89j500+7AifbTO0VFRAyhQhcRMYQKXUTEECp0\nERFDqNBFRAyhQhcRMYQKXUTEECp0ERFDqNBFRAyhQhcRMYQKXUTEECp0ERFDqNBFRAyhQhcRMYQK\nXUTEECp0ERFDqNBFRAyhQhcRMYQKXUTEEAkX+vj4OJdddhk+nw+A4eFhysvLKSgooKKigpGRkfi2\nwWAQt9tNYWEh7e3tyZ9aREROkXCh33fffXg8nvj3tbW1lJWVsXfvXkpLSwkGgwB0dXURCoXo7u6m\nra2NTZs22fpBryIic1VChT4wMMCTTz7JD37wg/htLS0tBAIBAAKBAM3NzQC0trZSVVVFRkYG+fn5\nuN1uOjs7UzC6iIgcL6FCv/322/ntb3+LZVnx26LRKA6HAwCn08nQ0BAAkUiEnJyc+HYul4tIJJLM\nmUVE5DQyJtvgiSeewOFwsGrVKsLh8ITbHV/2iaquro5/7fV68Xq9U74PERGThcPhT+3e401a6Dt2\n7KC1tZUnn3ySw4cP895777Fx40acTmd8lT44OEh2djZwbEXe398f339gYACXy3Xa+z6+0EVE5FQn\nL3Zramom3HbSUy533XUXBw4c4M0336SpqYnS0lIeeughvvGNb9DQ0ABAY2MjlZWVAPh8Ppqamhgd\nHaWvr4+enh6Ki4vPLJGIiExq0hX6RO644w78fj/19fXk5eURCoUA8Hg8+P1+PB4PmZmZ1NXVTet0\njIiITI0VS9M1hZZlTetyxmNPDnaOPL05p300y4Jq2w4H1diez95Hz/58dHTYdjxKSmzLZ1kWHdiX\nrQT7ssHH+ex96KbdgRPtp3eKiogYQoUuImIIFbqIiCFU6CIihlChi4gYQoUuImIIFbqIiCFU6CIi\nhlChi4gYQoUuImIIFbqIiCFU6CIihlChi4gYQoUuImIIFbqIiCFU6CIihlChi4gYQoUuImIIFbqI\niCEmLfSPPvqIL37xixQVFbFixQruvPNOAIaHhykvL6egoICKigpGRkbi+wSDQdxuN4WFhbS3t6du\nehERiZu00M866yw6OjrYvXs3r732Gtu3b2fHjh3U1tZSVlbG3r17KS0tJRgMAtDV1UUoFKK7u5u2\ntjY2bdpk6we9iojMVQmdclm4cCFwbLU+Pj7OkiVLaGlpIRAIABAIBGhubgagtbWVqqoqMjIyyM/P\nx+1209nZmaLxRUTkEwkV+vj4OEVFRTidTrxeLx6Ph2g0isPhAMDpdDI0NARAJBIhJycnvq/L5SIS\niaRgdBEROV5GIhvNmzeP3bt3c/DgQSoqKgiHw1iWdcI2J3+fiOrq6vjXXq8Xr9c75fsQETFZOBwm\nHA4ntG1Chf6JxYsXs3btWl5++WUcDkd8lT44OEh2djZwbEXe398f32dgYACXy3Xa+zu+0EVE5FQn\nL3Zramom3HbSUy5vv/12/AqWw4cP8/TTT1NUVITP56OhoQGAxsZGKisrAfD5fDQ1NTE6OkpfXx89\nPT0UFxefQRwREUnEpCv0t956i0AgQCwWY3x8nI0bN7JmzRqKiorw+/3U19eTl5dHKBQCwOPx4Pf7\n8Xg8ZGZmUldXN63TMSIiMjVWLE3XFFqWNa3LGY89Odg58vTmnPbRLAuqbTscVGN7PnsfPfvz0dFh\n2/EoKbEtn2VZdGBfthLsywYf57P3oZt2B060n94pKiJiCBW6iIghVOgiIoZQoYuIGEKFLiJiCBW6\niIghVOgiIoZQoYuIGEKFLiJiCBW6iIghVOgiIoZQoYuIGEKFLiJiCBW6iIghVOgiIoZQoYuIGEKF\nLiJiCBW6iIghVOgiIoaYtNAHBgYoLS1lxYoVrFy5kq1btwIwPDxMeXk5BQUFVFRUMDIyEt8nGAzi\ndrspLCykvb09ddOLiEjcpIWekZHB3Xffzeuvv87zzz/P/fffzxtvvEFtbS1lZWXs3buX0tJSgsEg\nAF1dXYRCIbq7u2lra2PTpk22ftCriMhcNWmhO51OVq1aBcA555xDYWEhAwMDtLS0EAgEAAgEAjQ3\nNwPQ2tpKVVUVGRkZ5Ofn43a76ezsTGEEERGBKZ5D//e//82rr77KlVdeSTQaxeFwAMdKf2hoCIBI\nJEJOTk58H5fLRSQSSeLIIiJyOhmJbvj+++9z/fXXc99993HOOedgWdYJf3/y94morq6Of+31evF6\nvVO+DxERk4XDYcLhcELbJlToY2NjXH/99WzcuJHKykoAHA5HfJU+ODhIdnY2cGxF3t/fH993YGAA\nl8t12vs9vtBFRORUJy92a2pqJtw2oVMu3//+9/F4PNx6663x23w+Hw0NDQA0NjbGi97n89HU1MTo\n6Ch9fX309PRQXFw8jRgiIjIVk67Qd+zYwSOPPMLKlSspKirCsizuuusuNm/ejN/vp76+nry8PEKh\nEAAejwe/34/H4yEzM5O6urppnY4REZGpsWJpuqbQsqxpXc547MnBzpGnN+e0j2ZZUG3b4aAa2/PZ\n++jZn4+ODtuOR0mJbfksy6ID+7KVYF82+DifvQ/dtDtwov30TlEREUOo0EVEDKFCFxExhApdRMQQ\nKnQREUOo0EVEDKFCFxExhApdRMQQKnQREUOo0EVEDKFCFxExhApdRMQQKnQREUOo0EVEDKFCFxEx\nhApdRMQQKnQREUOo0EVEDKFCFxExxKSFfsstt+BwOLjkkkvitw0PD1NeXk5BQQEVFRWMjIzE/y4Y\nDOJ2uyksLKS9vT01U4uIyCkmLfSbb76Zp5566oTbamtrKSsrY+/evZSWlhIMBgHo6uoiFArR3d1N\nW1sbmzZtsvVDXkVE5rJJC/1LX/oSS5YsOeG2lpYWAoEAAIFAgObmZgBaW1upqqoiIyOD/Px83G43\nnZ2dKRhbRERONq1z6ENDQzgcDgCcTidDQ0MARCIRcnJy4tu5XC4ikUgSxhQRkclkJONOLMua1n7V\n1dXxr71eL16vNxnjiIgYIxwOEw6HE9p2WoXucDiIRqM4HA4GBwfJzs4Gjq3I+/v749sNDAzgcrkm\nvJ/jC11ERE518mK3pqZmwm0TOuUSi8VOeHHT5/PR0NAAQGNjI5WVlfHbm5qaGB0dpa+vj56eHoqL\ni6cRQUREpmrSFfqNN95IOBzmnXfeITc3l5qaGu644w5uuOEG6uvrycvLIxQKAeDxePD7/Xg8HjIz\nM6mrq5v26RgREZkaK5am6woty5rWJY3HniDsHHl6c077aJYF1bYdDqqxPZ+9j579+ejosO14lJTY\nls+yLDqwL1sJ9mWDj/PZ+9BNuwMn2k/vFBURMYQKXUTEECp0ERFDqNBFRAyhQhcRMYQKXUTEECp0\nERFDqNBFRAyhQhcRMYQKXUTEECp0ERFDqNBFRAyhQhcRMYQKXUTEECp0ERFDqNBFRAyhQhcRMYQK\nXUTEECkr9G3btnHRRRdx4YUXsmXLllQdRkREPpaSQh8fH+cnP/kJTz31FK+//jqPPvoob7zxRioO\nNQXhNB8/xfrSPUBqhdM9QKq9+mq6J0iZVzE3G8yshy4lhd7Z2Ynb7SYvL4/MzEyqqqpoaWlJxaGm\nIJzm46fYv9M9QGqF0z1Aqs2kVkgyFbp9UlLokUiEnJyc+PfLly8nEomk4lAiIvIxvSgqImIIKxaL\nxZJ9py+88ALV1dVs27YNgNraWizLYvPmzf87sGUl+7AiInPCRLWdkkI/evQoBQUFPPvssyxbtozi\n4mIeffRRCgsLk30oERH5WEYq7nT+/Pn87ne/o7y8nPHxcW655RaVuYhIiqVkhS4iIvbTi6IiIoZQ\noYuIGEKFLiJiiDlX6E8//XS6R0iKgwcP0tvbe8rtr732WhqmSb6BgQH++9//AtDb28tf/vIX9u3b\nl+apUufOO+9M9wgp0dfXx+OPPz4DfvVHchw4cIAPP/wQOHbp4IMPPshPf/pTfv/73zM2Npbm6ebg\ni6K5ubkcOHAg3WOckVAoxG233UZ2djZHjhyhoaGBK664AoDLLruMV155Jc0Tnpn77ruPe+65hwUL\nFnDbbbdx77338uUvf5mdO3dy5513snHjxnSPeEZ+9rOfnfB9LBbjoYce4qabbgJg69at6RgrKdat\nW0dzczMALS0t3HbbbXi9Xnbu3Mkvf/lLvve976V3wDN08cUX09nZycKFC9m8eTO9vb2sW7eO7du3\nA1BfX5/W+VJy2WK6+Xy+094ei8V45513bJ4m+e666y527drFsmXL6OzsZOPGjQSDQdavXz/hGw5m\nkz/+8Y90dXVx+PBhcnNz6e3txel0Mjw8zJo1a2Z9of/1r3/l2muvpby8PP54NTU1cfnll6d5sjO3\nf//++Ndbtmxh+/btnHfeebz99tusWbNm1hf6+Pg4CxcuBOCZZ57hpZdeYt68eXz3u9/l0ksvTfN0\nhhb6c889x8MPP8w555xzwu2xWIzOzs40TZU8R48eZdmyZQAUFxfT0dHB17/+dfr7+414B+6CBQtY\nuHAhCxcu5IILLsDpdAKwZMkSI56wurq6+NWvfsW2bdv4v//7P84991xqamoIBALpHu2MHf//b3R0\nlPPOOw+ApUuXMm/e7D/Dm5OTw/bt2yktLSU/P5/+/n7y8vJmzELRyEK/8sorWbhwIddee+0pf1dQ\nUJCGiZJr0aJF9Pb2cv755wOwbNkywuEw69at4/XXX0/zdGfOsiyOHDlCZmYmTzzxRPz2Dz/8kPHx\n8TROlhyLFi3i3nvvZdeuXWzYsIHrrrvOiFwAe/bsYfHixcRiMT766CPeeustli1bxujoKEePHk33\neGfsgQce4KabbqK6upqsrCxWrVrFqlWrePfdd7n77rvTPd7cO4dugj179nD22WdzwQUXnHD7kSNH\nCIVCbNiwIU2TJceBAwc499xzycg4cb0RiUTo7u6mrKwsTZMlXywWo66ujueff56HH3443eOkzLvv\nvkt3dzdXXXVVukdJiu7ubvbt28fY2BjLly/niiuumBE/gczpQr/qqqt4/vnn0z1Gyijf7GZyPpOz\nQfrypf8pJY0+ufzIVMo3u5mcz+RskL58c7rQTXgB8dMo3+xmcj6Ts0H68s3pQhcRMcmcLnTTXz5Q\nvtnN5HwmZ4P05ZvTL4r+85//5OKLL073GCmjfLObyflMzgbpy2f0Cv3xxx/H7XaTlZXF4sWLWbRo\nEYsXL47//Wz/D6V8yjdTmZwNZm4+o1foF1xwAX/729+M/bQk5ZvdTM5ncjaYufmMXqE7HI4Z9w+e\nTMo3u5mcz+RsMHPzGb1Cv/XWWxkcHGTdunWcddZZ8du/+c1vpnGq5FG+2c3kfCZng5mbz8jf5fKJ\ngwcPsnDhQtrb2+O3WZaV9n/0ZFG+2c3kfCZng5mbz+gVuojIXGL0OfR9+/axZs2a+CvOr732Gr/5\nzW/SPFXyKN/sZnI+k7PBDM4XM9hXvvKV2IsvvhhbtWpV/LYVK1akcaLkUr7ZzeR8JmeLxWZuPqNX\n6IcOHaK4uPiE207+layzmfLNbibnMzkbzNx8Rhf60qVL6e3tjf+inD//+c/xT/oxgfLNbibnMzkb\nzOB86f4RIZV6e3tja9asiX3mM5+JnXvuubFrrrkm1tfXl+6xkkb5ZjeT85mcLRabufnmxFUuH3zw\nAePj4yxatCjdo6SE8s1uJuczORvMvHxGn3KJRqPccsstXH/99SxatIiuri7+9Kc/pXuspFG+2c3k\nfCZngxmcL90/IqTS1772tdhjjz0Wu+SSS2KxWCx25MiR2MUXX5zmqZJH+WY3k/OZnC0Wm7n5jF6h\nv/322/j9/viHt2ZkZDB//vw0T5U8yje7mZzP5Gwwc/MZXehnn30277zzTvyV6BdeeIGsrKw0T5U8\nyje7mZzP5Gwwg/Ol+0eEVNq1a1fs6quvji1evDh29dVXx9xud2zPnj3pHitplG92MzmfydlisZmb\nz+gVem9vL21tbezcuZOKigrcbjdjY2PpHitplG92MzmfydlgBudL9zNKKq1cuTIWi8Vizz33XMzr\n9cb+/ve/x4qLi9M8VfIo3+xmcj6Ts8ViMzef0Sv0T16keOKJJ/jhD3/Iddddx+joaJqnSh7lm91M\nzmdyNpi5+YwudJfLxY9//GMee+wx1q5dy0cffcT4+Hi6x0oa5ZvdTM5ncjaYufmMfqfooUOH2LZt\nGytXrsTtdvPWW2/xj3/8g/Ly8nSPlhTKN7uZnM/kbDBz8xld6CIic4nRp1xEROYSFbqIiCFU6CIi\nhlChi4gY4v8BygZUg9VvsxMAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x7f76cbf1f358>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "num_saw_movie = star_wars.iloc[:,3:9].sum()\n",
    "num_saw_movie.plot.bar()\n",
    "print(star_wars.shape)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### I looks like the favorite movie (Episode 5) had the most views (note the total number of possible views in this dataset is 1186).  Also the original trilogy had more views, with the views of each subsequent prequel falling off (probably because of Jar Jar Binks--ugh)."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Re-examine the movie rankings and views after splitting on gender"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "              males   females\n",
      "ranking_1  4.037825  3.429293\n",
      "ranking_2  4.224586  3.954660\n",
      "ranking_3  4.274882  4.418136\n",
      "ranking_4  2.997636  3.544081\n",
      "ranking_5  2.458629  2.569270\n",
      "ranking_6  3.002364  3.078086\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXEAAAEnCAYAAABfUHNOAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAIABJREFUeJzt3X9Q1HX+B/Dnhx8aCxGQutiC6CQOoNCym2FRtkd3zImF\n1tGddQNl6kZienbdZN5MLZ1Zplk6lMfYjHNMP3TGaQ5K0Bph6Y4BOUvsB1cgBsgeooKCGAfBfr5/\n9HUv3MVdlg/svpfnY4aZ3f289/N5vUCffHjv54cky7IMIiISkp+nCyAiIvcxxImIBMYQJyISGEOc\niEhgDHEiIoExxImIBOZyiFutVuh0OmRmZtotq6ysRFhYGHQ6HXQ6HbZs2aJokURE5FiAqwN37dqF\nhIQE9PT0OFy+ePFilJSUKFYYERE559KeeFtbG0pLS7F69eoRx/CcISKiiedSiG/cuBHbt2+HJEkj\njqmuroZWq8XSpUtRX1+vWIFERDQyp9Mphw4dglqthlarhdlsdrjHrdfr0draCpVKhbKyMixfvhwN\nDQ124673S4CIiEY24myH7MTzzz8vR0dHy3PmzJEjIyPl4OBgOTs7+7rvmT17ttzZ2Wn3ugubU9SL\nL744odubaOxPXL7cmyyzP6VdLzudTqds3boVra2tOH36NPbv34+0tDQUFRUNG9PR0WF7XFtbC1mW\nERERMZZfOkRE5AKXj065VmFhISRJgtFoxMGDB7Fnzx4EBgYiKCgIBw4cULJGIiIagfT/u+oTszFJ\nmtCjWMxmMwwGw4Rtb6L5en8R0yNw8cLFUb9PrVHjbNvZcahIOb7+s2N/yrpedvp0iJPYJEkCTG68\n0cRDXsm3XC873Z5OIaLJYfbs2WhpafF0GZNCTEwMmpubR/UehjgRXVdLSwv/spkg7hyGzQtgEREJ\njCFORCQwhjgRkcAY4jTuIiNnQ5KkUX8RkXMMcRp3HR0tAGQ3vogmxsqVK/HCCy94ugy3MMSJaNTc\n/evK1a/IyNmeblEYDHEv4O5/CP5DJ09x/68r175+Wj+5giHuBdz9D8F/6DTZzZkzBzt27EBSUhJC\nQ0OxevVqnDt3DhkZGbjpppuQnp6O7u5uAMBvf/tbzJw5E+Hh4TAYDNe978HHH3+M5ORkhIeH4+67\n78ZXX31lW7Zt2zZERUUhNDQU8fHxqKioGPc+r4chTkRC+/DDD1FeXo7vvvsOH330EZYsWYJXX30V\n58+fx9DQEHbv3g0AyMjIQFNTE86dOwedToff//73Dtd34sQJrFq1Cnv37kVXVxeefPJJZGZm4scf\nf0RDQwPeeustfP755+jp6cGRI0cwe/bsCezWHkOciIT29NNPY9q0aZg5cybuueceLFq0CElJSZgy\nZQoefPBBnDhxAgDw+OOPQ6VSITAwEC+88AJOnjyJy5cv261v7969yM3Nxe233w5JkpCdnY2pU6ei\npqYG/v7+GBgYwNdff43BwUHMmjULc+bMmeiWh2GIE5HQ1Gq17XFQUJDd897eXlitVmzatAlz585F\nWFgY5syZA0mScOHCBbv1tbS04PXXX0dERAQiIiIQHh6OtrY2/Oc//8Gtt96KN998EyaTCWq1Go8+\n+ija29snpM+RMMSJyOe9//77KCkpQXl5OS5duoTm5mbIsuzwmjDR0dH485//jK6uLnR1deHixYvo\n7e3F7373OwDAihUr8I9//MN2UbBNmzZNaC/XYogTkc/r7e3FDTfcgPDwcFy5cgXPP//8iCeUrVmz\nBn/9619RW1sLALhy5QpKS0tx5coVNDQ0oKKiAgMDA5gyZQqCgoLg5+fZGHV561arFTqdDpmZmQ6X\nr1+/HrGxsdBqtairq1OsQCLyPmp1DABp3L5+Wr9z1wbxSMGck5ODWbNmQaPRYMGCBbjrrrtGXKde\nr8fevXuxbt06REREYN68efjb3/4GAOjv78emTZswffp03HLLLTh//jxeeeUVl2odLy7fFOKNN96w\nfSJbUlIybFlZWRkKCgpw6NAhHDt2DBs2bEBNTY39xnhTCId++ofnzvdFjO/nWPrjTSE8j/9vJ85I\n3+vr/Qxc2hNva2tDaWkpVq9e7XB5cXExcnJyAAApKSno7u4edvPkseLJMEREjrkU4hs3bsT27dtH\n/FPFYrEgOjra9lyj0cBisShTIXgyDBHRSJze2efQoUNQq9XQarUwm81j/rPKZDLZHhsMBp++mSoR\nkTvMZjPMZrNLY53OiW/evBnvvvsuAgIC0NfXh8uXL+Ohhx5CUVGRbUxubi5+8Ytf2A7BiYuLQ2Vl\n5bDjNQH359Y4ZzziO32+P86Jex7nxCfOuMyJb926Fa2trTh9+jT279+PtLS0YQEOAJmZmbbXampq\nEBYWZhfgNA784d5nBVGRnq6ciBTi9o2SCwsLIUkSjEYjMjIyUFpairlz5yI4OBj79u1TskYayRDc\n2lPtMCn3oTMReZbLhxgqsjFOpzjk69MNvt6fr+N0ysQZt0MMiYjIOzHEiUhYDQ0NSE5Oxk033YSC\ngoIJ266fnx9Onz49Ydu7HrfnxIlo8oqMikSHZfw+W1Fr1DjbdtbpuNdeew1paWm2y81OFG+6kTdD\nnIhGrcPS4d7nFa6u38UP31taWvDII4+MXyEj8KbPCDidQkRCuu+++1BRUYG8vDyEhoaisbERzz77\nLGJiYjBz5kysXbsW/f39AIDKykpER0dj+/btmDFjBjQaDf7+97+jrKwM8+bNw7Rp0/Dqq6/a1v2v\nf/0Ld911F8LDw6HRaPD0009jcHDQYR0DAwMjbrezsxMPPPAAwsPDcfPNN+Pee+9V/PvAECciIR09\nehT33HMP3n77bfT09ODtt9/GqVOn8OWXX+LUqVOwWCx46aWXbOPPnj2LgYEBtLe3Iz8/H2vWrMG7\n776Luro6fPbZZ3jppZds1wj39/fHm2++ia6uLlRXV6O8vBxvv/22wzqee+65Ebf7+uuvIzo6Gp2d\nnTh37hy2bt2q+PeBIU5EQrs6tbF371688cYbuOmmmxAcHIxNmzbhgw8+sI2bMmUKNm/eDH9/f6xY\nsQKdnZ3YuHEjVCoVEhISkJCQgJMnTwIAdDod7rjjDkiShFmzZsFoNKKystLh9q+33cDAQLS3t+P7\n77+Hv78/UlNTFe+fc+JEJLzz58/jhx9+gF6vt71mtVqHzV3ffPPNtg8kg4KCAAAzZsywLb96KzcA\naGxsxDPPPIPjx4+jr68Pg4ODw9bt6nb/9Kc/wWQyIT09HZIkYc2aNXjuuecU7Jx74kTkA6ZNmwaV\nSoVvvvnGdlu1S5cuobu72631PfXUU4iPj0dTUxMuXbqEl19+2eGHmc62GxISgh07dqCpqQklJSXY\nuXMnKioqxtTrtRjiRCS8q3u5f/jDH3D+/HkAP10i+5NPPnFrfZcvX0ZoaChUKhW+/fZb7Nmzx63t\nHjp0CE1NTQCAG2+8EQEBAYrfzo3TKUQ0amqNelyvwaPWuHYBvZ8fr/3qq6/ipZdewqJFi9DZ2QmN\nRoOnnnoK6enpTt977fMdO3bAaDTitddeQ3JyMlasWIHy8nKHY7dt24b8/HyH221sbMS6detw4cIF\nhIeHIy8vT/EjVHjtFC/g69cW8fX+fB2vnTJxeO0UIqJJhiFORCQwhjgRkcAY4kREAnMa4v39/UhJ\nSUFycjLmz5+PzZs3242prKxEWFgYdDoddDodtmzZMi7FEhHRcE4PMZw6dSoqKiqgUqkwNDSE1NRU\nVFVV2Z0+unjxYpSUlIxboUREZM+l48RVKhWAn/bKrVYrwsPD7cbwECQi17l7PW5Xr7OtpJiYGK+6\nfrYvi4mJGfV7XApxq9UKvV6PpqYm5ObmIiEhwW5MdXU1tFotNBoNtm/f7nAMEf3E3etxe+Im183N\nzRO+TXKdSyHu5+eHEydOoKenB+np6aisrBx21pFer0draytUKhXKysqwfPlyNDQ0OFyXyWSyPTYY\nDDAYDGNqgIjI15jNZpjNZpfGjvqMzb/85S9QqVT44x//OOKYOXPm4PPPP0dERMTwjfGMTYd8/YxG\nX+/PHZLku72R8sZ0xuaFCxdsV+Tq6+vDp59+Cq1WO2xMR8f//sSrra2FLMt2AU5ERMpzOp3S3t6O\nxx57DLIsw2q1Ijs7G/fddx8KCwshSRKMRiMOHjyIPXv2IDAwEEFBQThw4MBE1O6cv3s3NPXEh0dE\nRO7w+QtgifAnK/sb8Z1C9OcOTqfQaPACWEREPoohTkQkMIY4EZHAGOJERAJjiBMRCYwhTkQkMIY4\nEZHAGOJERAJjiBMRCYwhTkQkMIY4EZHAGOJERAJjiBMRCYwhTkQkMIY4EZHAGOJERAJzGuL9/f1I\nSUlBcnIy5s+fj82bNzsct379esTGxkKr1aKurk7xQomIvEVkVCQkSRr1V2RUpOK1OL0929SpU1FR\nUQGVSoWhoSGkpqaiqqoKqamptjFlZWVoampCY2Mjjh07htzcXNTU1CheLBGRN+iwdLh1Z6YOU4fz\nQaPk0nSKSqUC8NNeudVqRXh4+LDlxcXFyMnJAQCkpKSgu7t72M2TiYhofLgU4larFcnJyYiMjITB\nYEBCQsKw5RaLBdHR0bbnGo0GFotF2UqJiMiO0+kUAPDz88OJEyfQ09OD9PR0VFZW4t5773VrgyaT\nyfbYYDDAYDC4tR4ibxEZORsdHS2eLoPc4K0/O7PZDLPZ7NJYl0L8qtDQUCxduhTHjx8fFuIajQZn\nzpyxPW9ra4NGo3G4jp+HOJEv+CkERnsHemk8SqFRcu9nB4z3z+/aHdz8/PwRxzqdTrlw4QK6u7sB\nAH19ffj000+h1WqHjcnMzERRUREAoKamBmFhYVCr1e7UTkREo+B0T7y9vR2PPfYYZFmG1WpFdnY2\n7rvvPhQWFkKSJBiNRmRkZKC0tBRz585FcHAw9u3bNxG1ExFNek5DPDExEV988YXd608++eSw5wUF\nBcpVRURELuEZm0REAmOIExEJjCFORCQwhjgRkcAY4kREAmOIExEJjCFORCQwhjgRkcAY4kREAmOI\nExEJjCFORCQwhjgRkcAY4kREAmOIExEJjCFORCQwpyHe1taGtLQ0zJ8/H4mJidi9e7fdmMrKSoSF\nhUGn00Gn02HLli3jUiwREQ3n9KYQAQEB2LlzJ7RaLXp7e6HX65Geno64uLhh4xYvXoySkpJxK5SI\nxBEZFYkOS8eo36fWqHG27ew4VOS7nIZ4ZGQkIiMjAQAhISGIj4+HxWKxC3FZdudmo0TkizosHYDJ\njfeZRh/8k92o5sSbm5tRV1eHlJQUu2XV1dXQarVYunQp6uvrFSuQiIhG5nRP/Kre3l5kZWVh165d\nCAkJGbZMr9ejtbUVKpUKZWVlWL58ORoaGhyux2Qy2R4bDAYYDAa3Cici8lVmsxlms9mlsS6F+ODg\nILKyspCdnY1ly5bZLf95qC9ZsgRr165FV1cXIiIi7Mb+PMSJiMjetTu4+fn5I451aTrliSeeQEJC\nAjZs2OBweUfH/+axamtrIcuywwAnIrFERs6GJEmj/qKJ43RPvKqqCu+99x4SExORnJwMSZKwdetW\ntLS0QJIkGI1GHDx4EHv27EFgYCCCgoJw4MCBiaidiMZZR0cLAHcOWmCQTxSnIZ6amoqhoaHrjsnL\ny0NeXp5iRRERkWt4xiYRkcAY4kREAmOIExEJjCFORCQwhjgRkcAY4kREAmOIExEJjCFORCQwhjgR\nkcAY4kREAmOIExEJjCFORCQwhjgRkcAY4kREAmOIExEJjCFORCQwpyHe1taGtLQ0zJ8/H4mJidi9\ne7fDcevXr0dsbCy0Wi3q6uoUL5SIiOw5vbNPQEAAdu7cCa1Wi97eXuj1eqSnpyMuLs42pqysDE1N\nTWhsbMSxY8eQm5uLmpqacS2ciIhc2BOPjIyEVqsF8NNd7ePj42GxWIaNKS4uRk5ODgAgJSUF3d3d\nw26eTERE42NUc+LNzc2oq6tDSkrKsNctFguio6NtzzUajV3QExGR8pxOp1zV29uLrKws7Nq1CyEh\nIW5v0GQy2R4bDAYYDAa310VE5IvMZjPMZrNLY10K8cHBQWRlZSE7OxvLli2zW67RaHDmzBnb87a2\nNmg0Gofr+nmIExGRvWt3cPPz80cc69J0yhNPPIGEhARs2LDB4fLMzEwUFRUBAGpqahAWFga1Wj2K\nkomIyB1O98Srqqrw3nvvITExEcnJyZAkCVu3bkVLSwskSYLRaERGRgZKS0sxd+5cBAcHY9++fRNR\nOxHRpOc0xFNTUzE0NOR0RQUFBYoUREREruMZm0REAmOIExEJjCFORCQwhjgRkcAY4kREAmOIExEJ\njCFORCQwhjgRkcAY4kREAmOIExEJjCFORCQwhjgRkcAY4kREAmOIExEJjCFORCQwhjgRkcCchviq\nVaugVquRlJTkcHllZSXCwsKg0+mg0+mwZcsWxYskIiLHnN7ZZ+XKlXj66aeRk5Mz4pjFixejpKRE\n0cKIiMg5p3vid999N8LDw687RpZlxQoiIiLXKTInXl1dDa1Wi6VLl6K+vl6JVRIRkQucTqc4o9fr\n0draCpVKhbKyMixfvhwNDQ0jjjeZTLbHBoMBBoNhrCUQEfkUs9kMs9ns0tgxh3hISIjt8ZIlS7B2\n7Vp0dXUhIiLC4fifhzgREdm7dgc3Pz9/xLEuTafIsjzivHdHR4ftcW1tLWRZHjHAiYhIWU73xB99\n9FGYzWZ0dnZi1qxZyM/Px8DAACRJgtFoxMGDB7Fnzx4EBgYiKCgIBw4cmIi6iYgILoT4+++/f93l\neXl5yMvLU6wgIiJyHc/YJCISGEOciEhgDHEiIoExxImIBMYQJyISGEOciEhgDHEiIoExxImIBMYQ\nJyISGEOciEhgDHEiIoExxImIBMYQJyISGEOciEhgDHEiIoExxImIBOY0xFetWgW1Wo2kpKQRx6xf\nvx6xsbHQarWoq6tTtEAiIhqZ0xBfuXIljhw5MuLysrIyNDU1obGxEYWFhcjNzVW0QCIiGpnTEL/7\n7rsRHh4+4vLi4mLk5OQAAFJSUtDd3T3s5slERDR+xjwnbrFYEB0dbXuu0WhgsVjGuloiInKB0xsl\nK81kMtkeGwwGGAyGiS6BiMirmc1mmM1ml8aOOcQ1Gg3OnDlje97W1gaNRjPi+J+HOBER2bt2Bzc/\nP3/EsS5Np8iyDFmWHS7LzMxEUVERAKCmpgZhYWFQq9WjKJeIiNzldE/80UcfhdlsRmdnJ2bNmoX8\n/HwMDAxAkiQYjUZkZGSgtLQUc+fORXBwMPbt2zcRdRMREVwI8ffff9/pSgoKChQphoiIRodnbBIR\nCYwhTkQkMIY4EZHAGOJERAJjiBMRCYwhTkQkMIY4EZHAGOJERAJjiBMRCYwhTkQkMIY4EZHAGOJE\nRAJjiBMRCYwhTkQkMIY4EZHAGOJERAJzKcQPHz6MuLg4zJs3D9u2bbNbXllZibCwMOh0Ouh0OmzZ\nskXxQomIyJ7TO/tYrVasW7cOR48exS233IKFCxdi2bJliIuLGzZu8eLFKCkpGbdCiYjIntM98dra\nWsTGxiImJgaBgYFYsWIFiouL7caNdCNlIiIaP05D3GKxIDo62vY8KioKFovFblx1dTW0Wi2WLl2K\n+vp6ZaskIiKHnE6nuEKv16O1tRUqlQplZWVYvnw5GhoaHI41mUy2xwaDAQaDQYkSiIh8htlshtls\ndmms0xDXaDRobW21PW9ra4NGoxk2JiQkxPZ4yZIlWLt2Lbq6uhAREWG3vp+HOBER2bt2Bzc/P3/E\nsU6nUxYuXIhTp06hpaUFAwMD2L9/PzIzM4eN6ejosD2ura2FLMsOA5yIiJTldE/c398fBQUFSE9P\nh9VqxapVqxAfH4/CwkJIkgSj0YiDBw9iz549CAwMRFBQEA4cODARtRMRTXouzYn/+te/xnfffTfs\ntSeffNL2OC8vD3l5ecpWRkRETvGMTSIigTHEiYgExhAnIhIYQ5yISGAMcSIigTHEiYgExhAnIhIY\nQ5yISGAMcSIigTHEiYgExhAnIhIYQ5yISGAMcSIigTHEiYgExhAnIhKYSyF++PBhxMXFYd68edi2\nbZvDMevXr0dsbCy0Wi3q6uoULZKIiBxzGuJWqxXr1q3DkSNH8M033+CDDz7At99+O2xMWVkZmpqa\n0NjYiMLCQuTm5o5bwURE9D9OQ7y2thaxsbGIiYlBYGAgVqxYgeLi4mFjiouLkZOTAwBISUlBd3f3\nsPtuEhHR+HAa4haLBdHR0bbnUVFRsFgs1x2j0WjsxhARkfJcusemkiRJcved7r3N5ObW3K7TXezP\nIZObWxOhP5ObWxKhN4D9jbQ1hftzGuIajQatra22521tbdBoNHZjzpw5c90xACDL8lhqJSKiazid\nTlm4cCFOnTqFlpYWDAwMYP/+/cjMzBw2JjMzE0VFRQCAmpoahIWFQa1Wj0/FRERk43RP3N/fHwUF\nBUhPT4fVasWqVasQHx+PwsJCSJIEo9GIjIwMlJaWYu7cuQgODsa+ffsmonYioklPkjnHQUQkLJ6x\nSUQkMIY4EZHAGOJERAKbFCHuKx+0fvvttzh69Ch6e3uHvX748GEPVaSsqqoq1NfXAwAqKyvx+uuv\n4+jRox6uavxcPcvZF/3zn//Ezp078cknn3i6lDE7duwYenp6AAB9fX148cUX8cADD+C5555Dd3e3\nh6ubJB9szpo1a9ix7iLavXs33nrrLcTHx6Ourg67du3CsmXLAAA6nQ5ffPGFhyscm82bN6O8vBxW\nqxUGgwGfffYZli5dik8//RSZmZl49tlnPV3imFx7WK4sy6ioqEBaWhoAoKSkxBNlKeaOO+5AbW0t\nAGDv3r1466238OCDD+KTTz7BAw88gE2bNnm4QvfNnz8fJ0+eREBAAIxGI1QqFbKysnD06FGcPHkS\nH374oUfr85kQT0pKcvi6LMtoaGhAf3//BFekrMTERFRXVyMkJATNzc3IyspCdnY2NmzYgOTkZJw4\nccLTJY7J/Pnz8eWXX6K/vx+RkZFoa2tDaGgo+vr6sGjRIpw8edLTJY6JTqdDQkICVq9eDUmSIMsy\nHnnkEezfvx8AcO+993q4wrH5+b/BhQsXorS0FNOnT8eVK1ewaNEifPXVVx6u0H3x8fH497//DcB+\nh8kbrto64afdj5eOjg4cOXIE4eHhw16XZRl33XWXh6pSjtVqRUhICABg9uzZMJvNyMrKQktLi0+c\nCTtlyhT4+/tDpVLh1ltvRWhoKAAgKCgIfn7iz/odP34cu3btwssvv4zt27dDq9UiKChI+PC+ymq1\n4uLFi7BarRgaGsL06dMBAMHBwQgIEDtmFixYgH379mHlypW47bbbcPz4cdx+++1oaGhAYGCgp8vz\nnRC///770dvbC61Wa7fMYDBMfEEKU6vVqKurs/UXEhKCjz/+GE888YTQezlXTZkyBT/88ANUKhU+\n//xz2+vd3d0euJaG8vz8/LBx40Y8/PDD2LhxI9RqNQYHBz1dlmK6u7uh1+shyzIkSUJ7eztmzpyJ\n3t5e4Xcy3nnnHWzYsAFbtmzBtGnTcOeddyI6OhrR0dF45513PF2e70ynuOrixYt2e+siaGtrQ0BA\nACIjI+2WVVVVITU1FYC4/fX392Pq1Kl2r1+4cAHt7e1ITEwEIG5/1zp06BCqqqqwdevWYa/7Sn9X\n/fDDD+jo6MCcOXMAiN1fT08Pvv/+ewwODiIqKsru0iKe6m3ShbgvfAh4PexPbOxPXJ7qTfzJxlHy\n9d9Z7E9s7E9cnupt0oW4L8yvXg/7Exv7E5enept0IU5E5EsmXYj78p9zAPsTHfsTl6d687kPNru6\nuuxeu/HGG23Hc3Z1dSEiImKiy1IM+2N/3syX+/Pa3mQfExMTI/v5+ck333yzHBERIfv5+cm33HKL\nnJycLB8/ftzT5Y0Z+xMb+xOXt/bmcyG+evVq+fDhw7bnR44ckY1Go1xdXS3fcccdHqxMGexPbOxP\nXN7am8+F+IIFC+xeS0xMlGVZlm+77baJLkdx7E9s7E9c3tqbz5x2f9XMmTOxbds2rFixAgBw4MAB\nqNVqDA0N+cQ1ONif2NifuLy2N4/9+hgn58+fl9etWydrtVpZq9XKeXl58rlz5+T+/n65sbHR0+WN\nGfsTG/sTl7f25nNHpxARTSY+N53S0NCAHTt2oLm5edhV4srLyz1YlXLYn9jYn7i8tTef2xO/7bbb\nkJubC71eD39/f9vrer3eg1Uph/2Jjf2Jy1t787kQ1+v1w65H7WvYn9jYn7i8tTd/k8lk8nQRSmpv\nb0d9fT2ioqLw448/oq+vD319fQgKCvJ0aYpgf2Jjf+Ly1t58bk/86sXnf06SJJw+fdoD1SiP/YmN\n/YnLW3vzuRAnIppMfObolPLycqSlpeHDDz90uPyhhx6a4IqUxf7Ynzfz5f68vTefCfHKykqkpaXh\no48+slsmSZLHv9Fjxf7Ynzfz5f68vTefm05xdMNdkS9/eS32Jzb2Jy5v7U3sixk48NBDDw07EP/s\n2bP41a9+5cGKlMX+xMb+xOWtvflciC9fvhwPP/wwhoaG0NzcjPT0dLzyyiueLksx7E9s7E9cXtub\nZy7ZMr4KCgrk+++/X16wYIFcVVXl6XIUx/7Exv7E5Y29+cyc+M6dO22PZVlGUVERkpKSkJycDAB4\n5plnPFWaItgf+/Nmvtyft/fmM0enXL58edjzq58YX/u6qNif2NifuLy9N5/ZEycimox8Zk/8Km+9\nXKRS2J/Y2J+4vLU3n9sT99bLRSqF/YmN/YnLW3vzuRD31stFKoX9iY39ictbe+OlaAXD/sTG/sTl\nrb353J64t14uUinsT2zsT1ze2pvPhTgR0WTic0enAMDXX3+N+vp6/Pe//7W9lpOT48GKlMX+xMb+\nxOWVvU30KaLjzWQyyQaDQZ4xY4b8+OOPy2q1Wv7Nb37j6bIUw/7Exv7E5a29+VyIL1iwQB4aGpKT\nkpJkWZbls2fPyr/85S89XJVy2J/Y2J+4vLU3n7uK4Q033AA/Pz8EBASgp6cHM2bMwJkzZzxdlmLY\nn9jYn7hBgH6fAAAA0klEQVS8tTefmhOXZRlJSUm4dOkS1qxZA71ej5CQENx5552eLk0R7E9s7E9c\n3tybzx2dkpiYiK+++goA0NzcjJ6eHiQlJXm4KuWwP7GxP3F5a28+d7LPsWPHEBUVBY1Gg7CwMKjV\nak+XpCj2Jzb2Jy5v7c3n9sTj4uJw6tQpxMTEIDg4GLIsQ5IkfPnll54uTRHsT2zsT1ze2pvPhXhL\nS4vD12NiYia4kvHB/sTG/sTlrb35XIgTEU0mPneIIRHRZMIQJyISGEOciEhgDHEiIoH9HzKVV+sP\nO48eAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x7f76cbd99780>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "males = star_wars[star_wars[\"Gender\"] == \"Male\"]\n",
    "females = star_wars[star_wars[\"Gender\"] == \"Female\"]\n",
    "df = pd.DataFrame()\n",
    "df[\"males\"] = males.iloc[:,9:15].mean()\n",
    "df[\"females\"] = females.iloc[:,9:15].mean()\n",
    "df.plot.bar()\n",
    "print(df)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Looks like the general ranking trend is pretty similar and Episode V is still the favorite, but the overall rankings are slightly different.  From lowest to highest for males the ranking is 5, 4, 6, 1, 2, 3; while for females it is 5, 6, 1, 4, 2, 3."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x7f76cbe4ecf8>"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXQAAAEZCAYAAACHCd7XAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAIABJREFUeJzt3XtU1HX+x/HnINhGCkuZMzQiYzW5jJcFKrr/moOGba1o\ne1yiXKNSa6O77R4v27rQ2cS2y1ZbtB1dV0834+y6YhfNDKftWC1d1C6SCqExswLeTS0Rmd8f1qwX\nCBhmHObD63EO58B3vpf3G/HFh898Lxa/3+9HRESiXkykCxARkdBQoIuIGEKBLiJiCAW6iIghFOgi\nIoZQoIuIGKLDgd7S0kJmZia5ubkA7Ny5k5ycHAYPHsyoUaPYvXt3YN2SkhKcTidpaWksX7489FWL\niMhxOhzoTzzxBC6XK/D17NmzGTlyJOvXryc7O5uSkhIA1q1bR1lZGVVVVSxdupTCwkJ0qruISPh1\nKNC9Xi+vv/46kyZNCiwrLy+noKAAgIKCAhYvXgzAkiVLyM/PJzY2FofDgdPppLKyMgyli4jIkToU\n6Pfeey8PP/wwFoslsKyhoQGr1QqAzWajsbERAJ/PR0pKSmA9u92Oz+cLZc0iItKK2PZWeO2117Ba\nraSnp+PxeNpc78iw74jOri8iIoe1NY3d7gh91apVLFmyhDPPPJPrrruOiooKJkyYgM1mo6GhAYD6\n+nr69+8PHB6R19XVBbb3er3Y7fY2izpRH3/4wx9O6PFO9If6i+4Pk/szubdI9PdD2g30WbNm8dVX\nX/Hll1+ycOFCsrOzee655xg9ejTz588HYMGCBYwZMwaA3NxcFi5cSFNTE7W1tVRXV5OVldXeYURE\npIvanXJpy7Rp08jLy2PevHmkpqZSVlYGgMvlIi8vD5fLRVxcHKWlpZpeERE5ASz+9sbw4TqwxdLu\nnw+h5PF4cLvdJ+x4J5r6i24m92dyb3Di+/uh7OwxgS4iXWOzOWho2Nzp7azWVOrrN4W+oB4qqgLd\n4XCweXPnf2gkOKmpqWzatCnSZUgUODx1GkxcaPAWSlEV6Bq5n1j6fktHKdC7hx/6P6ubc4mIcHhK\nyWKxdPrDZnNEuvQAjdB7OH2/paNMH6FHS38aoYuI9AAKdBERQyjQI+Smm25i5syZkS5DRAwSFYEe\n7JsV0fimhohIsIK+9P9EOnwxQ/jedGho0K0JRCT6RcUIvTsZNGgQjzzyCMOHDychIYFJkybR2NjI\nVVddRWJiIjk5OYHH8eXl5ZGcnExSUhJut5t169a1ud9XX32VjIwMkpKSuPTSS/n0008Drz300EMM\nGDCAhIQE0tLSWLlyZdj7FJHoo0APwqJFi6ioqGD9+vW88sor/OxnP2P27Nls3bqVQ4cO8eSTTwJw\n1VVXUVNTQ2NjI5mZmYwfP77V/a1evZqJEycyZ84cduzYwa233kpubi4HDx5kw4YNPP3003z00Ufs\n2bOHN954A4fDcQK7FZFooUAPwp133km/fv1ITk7msssu48ILL2T48OH07t2ba665htWrVwNw4403\nEh8fT1xcHDNnzmTt2rV8/fXXx+1vzpw5/PrXv+a8887DYrEwYcIETjrpJN5//3169epFU1MTn332\nGc3NzQwcOJBBgwad6JZFJAoo0IPw/aP3AE4++eTjvt67dy8tLS1MmzaNs88+mx//+McMGjQIi8XC\ntm3bjtvf5s2befTRRzn11FM59dRTSUpKwuv18t///pezzjqLxx9/nKKiIqxWK9dffz1btmw5IX2K\nSHRRoIfJiy++yJIlS6ioqGDXrl1s2rSpzSeOpKSk8Lvf/Y4dO3awY8cOdu7cyd69e7n22msByM/P\n55133gnctGzatGkntBcRiQ4K9DDZu3cvP/rRj0hKSmLfvn1Mnz69zQd9TJ48mb/+9a9UVlYCsG/f\nPl5//XX27dvHhg0bWLlyJU1NTfTu3ZuTTz6ZmBj9s4nI8aIiGazWVMASto/D+++YY0O5rZC+4YYb\nGDhwIHa7naFDh3LxxRe3uc9zzz2XOXPmcMcdd3DqqadyzjnnsGDBAgAOHDjAtGnTOP300znjjDPY\nunUrJSUlHa5XRHoO3Zyrh9P3WzoqWm5eFaxo6U835xIR6QHaDfQDBw5wwQUXkJGRwZAhQ5gxYwYA\nxcXFDBgwgMzMTDIzM1m2bFlgm5KSEpxOJ2lpaSxfvjx81YuISECHplz2799PfHw8hw4d4pJLLuHR\nRx9lxYoV9O3blylTphy1blVVFddffz0ffPABXq+XkSNHsnHjxlbnnjXlEnn6fktHRcuURLCipb8u\nT7nEx8cDh0frLS0tJCUlAbS60/LycvLz84mNjcXhcOB0OgNnb4iISPh0KNBbWlrIyMjAZrPhdrtx\nuVwAPPXUU6SnpzNp0qTA/Ut8Ph8pKSmBbe12Oz6fLwyli0hU6EVwd0EdYIt05VGnQ3dbjImJYfXq\n1ezZs4ecnBzefvttCgsLmTlzJhaLhfvvv5/77ruPuXPndurgRUVFgc/dbjdut7tT24tIFDgEFHV+\ns4aihlBXEpU8Hg8ej6dD63bq9rkJCQlcffXVfPjhh1x++eWB5ZMnT2b06NHA4RF5XV1d4DWv14vd\nbm91f0cGuoiIHO/YwW5xcXGb67Y75bJt27bAdMo333zDm2++SXp6OvX19YF1Fi1axNChQwHIzc1l\n4cKFNDU1UVtbS3V1NVlZWcH2IiIiHdTuCH3Lli0UFBTg9/tpaWlhwoQJjBgxghtuuIE1a9YQExOD\nw+Hg2WefBcDlcpGXl4fL5SIuLo7S0tI2r6aMRhs2bODaa6/lyy+/5MEHH+SOO+44IceNiYmhurqa\nM88884QcT0SiT1RcKWobYKPBF775NKvdSr23vv0VgUmTJpGYmMijjz4atnpa06tXLzZu3BjyQNdp\ni9JRXTmtL5g5dIpaP5MuXEw4bTE6HkHnawjuB6Kj++/Emy+bN2/muuuuC18xbVDoRgebzfHdIxM7\nx2pNpb5+U+gLkh5Fl/53wogRI1i5ciW33347CQkJbNy4kd/85jekpqaSnJxMYWEhBw4cAODtt98m\nJSWFhx9+mP79+2O321m8eDFLly7lnHPOoV+/fsyePTuw7w8++ICLL76YpKQk7HY7d955J83Nza3W\n0dTU1OZxt2/fzujRo0lKSuK000476s1rCb//Pf+2cx/B/BIQOZYCvRPeeustLrvsMkpLS9mzZw+l\npaVUV1fzySefUF1djc/n44EHHgisX19fT1NTE1u2bKG4uJjJkyfz/PPPs2bNGv7973/zwAMPBO5x\n3qtXLx5//HF27NjBe++9R0VFBaWlpa3WMXXq1DaP++ijj5KSksL27dtpbGxk1qxZ4f/GiPRk3eg8\n+6iYculuvp/+mDNnDp9++imJiYnA4QdPjB8/ngcffBCA3r17M2PGDCwWC/n5+dxyyy3ce++9xMfH\n43K5cLlcrF27ltTUVDIzMwP7HzhwILfccgtvv/02d91113HH/6HjxsXFsWXLFmpraznrrLO45JJL\nwv3tEOnZutF59gr0IG3dupX9+/dz7rnnBpa1tLQcNdd92mmnBc7wOfnkkwHo379/4PXvH1cHsHHj\nRqZMmcKHH37IN998Q3Nz81H77uhxf/vb31JUVEROTg4Wi4XJkyczderUEHYuIt2VplyC1K9fP+Lj\n4/n8888Dj47btWtX4Jz9zrrttttIS0ujpqaGXbt28eCDD7b6Rmh7x+3Tpw+PPPIINTU1LFmyhMce\ne4yVK1d2qVcRiQ4K9CB9P/q955572Lp1K3D4PjbB3i7466+/JiEhgfj4eL744gueeeaZoI772muv\nUVNTA0Dfvn2JjY3VI+tEeoiomHKx2q1hva+D1W7t8LpHXiQ1e/ZsHnjgAS688EK2b9+O3W7ntttu\nIycnp91tj/36kUce4ZZbbuFPf/oTGRkZ5OfnU1FR0eq6Dz30EMXFxa0ed+PGjdxxxx1s27aNpKQk\nbr/9dp3pItJDRMWFRRI++n6HVrRcnBIMXVjU5pYntD89gk5EpAdQoIuIGEKBLiJiCAW6iIghFOgi\nIoZQoMsJZbM5grvvhc0R6dJFur1udx56amqqUQ/E6O5SU1NP6PH+dzfCzm6nnwmR9nS7QN+0adMP\nvm7yeb5gfn8iEj6achERMYQCXUTEEO0G+oEDB7jgggvIyMhgyJAhzJgxA4CdO3eSk5PD4MGDGTVq\n1FF3GSwpKcHpdJKWlhb0zapERKRz2g30k046iZUrV7J69Wo++eQTKioqWLVqFbNnz2bkyJGsX7+e\n7OxsSkpKAFi3bh1lZWVUVVWxdOlSCgsLNbcrInICdGjKJT4+Hjg8Wm9paSEpKYny8nIKCgoAKCgo\nYPHixQAsWbKE/Px8YmNjcTgcOJ1OKisrw1S+iIh8r0OB3tLSQkZGBjabDbfbjcvloqGhAav18G1n\nbTYbjY2NwOF7c6ekpAS2tdvt+Hy+MJQuIiJH6tBpizExMaxevZo9e/YwatQoPB7PD97bu6OKiooC\nn7vdbtxud6f3ISJiMo/Hg8fj6dC6nToPPSEhgauuuooPP/wQq9UaGKXX19cHnpVpt9upq6sLbOP1\nerHb7a3u78hAD7tewf3Ssdqt1Hvrw1CQiEj7jh3sFhcXt7luu4G+bds24uLiSExM5JtvvuHNN9/k\nD3/4A7m5ucyfP5+pU6eyYMECxowZA0Bubi7jx4/n3nvvxefzUV1dTVZWVte76qpu9GRuEZFwaDfQ\nt2zZQkFBAX6/n5aWFiZMmMCIESPIyMggLy+PefPmkZqaSllZGQAul4u8vDxcLhdxcXGUlpbqUn4R\nkROg2z2CriPbRcNjooJl+qX/6q/NLbt9f/q/1+aWegSdiIiElgJdRMQQCnQREUMo0EVEDKFAFxEx\nhAJdRMQQCnQREUMo0EVEDKFAFxExhAJdRMQQCnQREUMo0EVEDKFAFxExhAJdRMQQCnQREUMo0EVE\nDKFAFxExhAJdRMQQCnQREUO0G+her5fs7GyGDBnCsGHD+Mtf/gJAcXExAwYMIDMzk8zMTJYtWxbY\npqSkBKfTSVpaGsuXLw9f9SIiEhDb7gqxsTz22GOkp6ezd+9ezj33XK644goApkyZwpQpU45av6qq\nirKyMqqqqvB6vYwcOZKNGzd+9wBWEWlVL4L6P2K1W6n31oehIIlG7Qa6zWbDZrMB0KdPH9LS0vD5\nfEDrT6wuLy8nPz+f2NhYHA4HTqeTyspKLrjgghCXLmKQQwT15PiGooZQVyJRrFNz6Js2bWLNmjWB\ncH7qqadIT09n0qRJ7N69GwCfz0dKSkpgG7vdHvgFICIi4dPuCP17e/fuZdy4cTzxxBP06dOHwsJC\nZs6cicVi4f777+e+++5j7ty5nTp4UVFR4HO3243b7e7U9iIipvN4PHg8ng6t26FAb25uZty4cUyY\nMIExY8YAcPrppwdenzx5MqNHjwYOj8jr6uoCr3m9Xux2e6v7PTLQRUTkeMcOdouLi9tct0NTLjff\nfDMul4u77747sKy+/n9vxCxatIihQ4cCkJuby8KFC2lqaqK2tpbq6mqysrI624OIiHRSuyP0VatW\n8cILLzBs2DAyMjKwWCzMmjWLF198kTVr1hATE4PD4eDZZ58FwOVykZeXh8vlIi4ujtLSUp3hIiJy\nAlj8rZ2qciIObLG0epZMR7aDYEq2BHUWAUWtn80TLl3pL0L/lJ2i/trcstv/fJrcG0RPfz+UnbpS\nVETEEAp0ERFDKNBN8d2Vhp39sA2wRbpyEQmRDp+HLt2crjQU6fE0QhcRMYQCXUTEEAp0ERFDKNBF\nRAyhQBcRMYQCXUTEEAp0ERFDKNAlOujCKZF26cIiiQ66cEqkXRqhi4gYQoEuImIIBbqIiCEU6CIi\nhlCgi4gYQoEuImKIdgPd6/WSnZ3NkCFDGDZsGE8++SQAO3fuJCcnh8GDBzNq1Ch2794d2KakpASn\n00laWhrLly8PX/UiIhLQbqDHxsby2GOP8fnnn/Pee+/x9NNP88UXXzB79mxGjhzJ+vXryc7OpqSk\nBIB169ZRVlZGVVUVS5cupbCwMCoe7isiEu3aDXSbzUZ6ejoAffr0IS0tDa/XS3l5OQUFBQAUFBSw\nePFiAJYsWUJ+fj6xsbE4HA6cTieVlZVhbEFERKCTc+ibNm1izZo1XHjhhTQ0NGC1WoHDod/Y2AiA\nz+cjJSUlsI3dbsfn84WwZBERaU2HL/3fu3cv48aN44knnqBPnz5YLJajXj/2644oKioKfO52u3G7\n3Z3eh4iIyTweDx6Pp0PrdijQm5ubGTduHBMmTGDMmDEAWK3WwCi9vr6e/v37A4dH5HV1dYFtvV4v\ndru91f0eGegiInK8Ywe7xcXFba7boSmXm2++GZfLxd133x1Ylpuby/z58wFYsGBBIOhzc3NZuHAh\nTU1N1NbWUl1dTVZWVhBtiIhIZ7Q7Ql+1ahUvvPACw4YNIyMjA4vFwqxZs5g6dSp5eXnMmzeP1NRU\nysrKAHC5XOTl5eFyuYiLi6O0tDSo6RgREemcdgP9kksu4dChQ62+tmLFilaXT58+nenTp3etMhER\n6RRdKSoiYggFuoiIIRToIiKGUKCLiBhCgS4iYggFuoiIIRToIiKGUKCLiBhCgS4iYggFuoiIIRTo\nIiKGUKCLiBhCgS4iYggFuoiIIRToIiKGUKCLiBhCgS4iYggFuoiIIRToIiKGaDfQJ06ciNVqZfjw\n4YFlxcXFDBgwgMzMTDIzM1m2bFngtZKSEpxOJ2lpaSxfvjw8VYuIyHHaDfSbbrqJN95447jlU6ZM\n4eOPP+bjjz/myiuvBKCqqoqysjKqqqpYunQphYWF+P3+0FctIiLHaTfQL730UpKSko5b3lpQl5eX\nk5+fT2xsLA6HA6fTSWVlZWgqFRGRHxT0HPpTTz1Feno6kyZNYvfu3QD4fD5SUlIC69jtdnw+X9er\nFBGRdsUGs1FhYSEzZ87EYrFw//33c9999zF37txO76eoqCjwudvtxu12B1OOiIixPB4PHo+nQ+sG\nFeinn3564PPJkyczevRo4PCIvK6uLvCa1+vFbre3uZ8jA11ERI537GC3uLi4zXU7NOXi9/uPmjOv\nr68PfL5o0SKGDh0KQG5uLgsXLqSpqYna2lqqq6vJysrqbP0iIhKEdkfo119/PR6Ph+3btzNw4ECK\ni4tZuXIla9asISYmBofDwbPPPguAy+UiLy8Pl8tFXFwcpaWlWCyWsDchIiIdCPQXX3zxuGU33XRT\nm+tPnz6d6dOnd60qERHpNF0pKiJiCAW6iIghFOgiIoZQoIuIGEKBLiJiCAW6iIghFOgiIoZQoIuI\nGEKBLiJiCAW6iIghFOgiIoZQoIuIGEKBLiJiCAW6iIghFOgiIoZQoIuIGEKBLiJiCAW6iIghFOgi\nIoZoN9AnTpyI1Wpl+PDhgWU7d+4kJyeHwYMHM2rUKHbv3h14raSkBKfTSVpaGsuXLw9P1SIicpx2\nA/2mm27ijTfeOGrZ7NmzGTlyJOvXryc7O5uSkhIA1q1bR1lZGVVVVSxdupTCwkL8fn94KhcRkaO0\nG+iXXnopSUlJRy0rLy+noKAAgIKCAhYvXgzAkiVLyM/PJzY2FofDgdPppLKyMgxli4jIsYKaQ29s\nbMRqtQJgs9lobGwEwOfzkZKSEljPbrfj8/lCUKaIiLQnNhQ7sVgsQW1XVFQU+NztduN2u0NRjoiI\nMTweDx6Pp0PrBhXoVquVhoYGrFYr9fX19O/fHzg8Iq+rqwus5/V6sdvtbe7nyEAXEZHjHTvYLS4u\nbnPdDk25+P3+o97czM3NZf78+QAsWLCAMWPGBJYvXLiQpqYmamtrqa6uJisrK4gWRESks9odoV9/\n/fV4PB62b9/OwIEDKS4uZtq0afzyl79k3rx5pKamUlZWBoDL5SIvLw+Xy0VcXBylpaVBT8eIiEjn\ntBvoL774YqvLV6xY0ery6dOnM3369K5VJSIinaYrRUVEDKFAFxExhAJdRMQQCnQREUMo0EVEDKFA\nFxExhAJdRMQQCnQREUMo0EVEDKFAFxExhAJdRMQQCnQREUMo0EVEDKFAFxExhAJdRMQQCnQREUMo\n0EVEDKFAFxExhAJdRMQQ7T5T9Ic4HA4SExOJiYkhLi6OyspKdu7cybXXXsvmzZtxOByUlZWRmJgY\nqnpFRKQNXRqhx8TE4PF4WL16NZWVlQDMnj2bkSNHsn79erKzsykpKQlJoSIi8sO6FOh+v5+Wlpaj\nlpWXl1NQUABAQUEBixcv7sohRESkg7oU6BaLhSuuuILzzz+fuXPnAtDQ0IDVagXAZrPR2NjY9SpF\nRKRdXZpDX7VqFcnJyWzdupWcnBwGDx6MxWI5ap1jvz5SUVFR4HO3243b7e5KOSIixvF4PHg8ng6t\n26VAT05OBuD0009n7NixVFZWYrVaA6P0+vp6+vfv3+b2Rwa6iIgc79jBbnFxcZvrBj3lsn//fvbu\n3QvAvn37WL58OcOGDSM3N5f58+cDsGDBAsaMGRPsIUREpBOCHqE3NDRwzTXXYLFYaG5uZvz48eTk\n5HDeeeeRl5fHvHnzSE1NpaysLJT1iohIG4IO9EGDBrFmzZrjlp966qmsWLGiS0WJiEjn6UpRERFD\nKNBFRAyhQBcRMYQCXUTEEAp0ERFDKNBFRAyhQBcRMYQCXUTEEAp0ERFDKNBFRAyhQBcRMYQCXUTE\nEAp0ERFDKNBFRAyhQBcRMYQCXUTEEAp0ERFDKNBFRAwRtkBftmwZP/nJTzjnnHN46KGHwnUYERH5\nTlgCvaWlhTvuuIM33niDzz//nJdeeokvvvgiHIcSEZHvhCXQKysrcTqdpKamEhcXR35+PuXl5eE4\nlIiIfCcsge7z+UhJSQl8PWDAAHw+XzgOJSIi39GboiIihogNx07tdjtfffVV4Guv14vdbj9uPYvF\nEuQRgtyuKMijBV1nsNRfq4qCPJr6CyGTe4No78/i9/v9Id0jcOjQIQYPHsxbb71FcnIyWVlZvPTS\nS6SlpYX6UCIi8p2wjNB79erFU089RU5ODi0tLUycOFFhLiISZmEZoYuIyImnN0VFRAyhQBcRMYQC\nXUTEED0u0N98881IlxASe/bsoaam5rjln3zySQSqCT2v18uOHTsAqKmp4Z///CcbNmyIcFXhM2PG\njEiXEBa1tbUsWrTImFt/fPXVV3z77bcA+P1+/v73v3PnnXfyzDPP0NzcHOHqeuCbogMHDjzqHPlo\nVFZWxj333EP//v05ePAg8+fP5/zzzwcgMzOTjz/+OMIVds0TTzzBn//8Z3r37s0999zD448/zmWX\nXca7777LjBkzmDBhQqRL7JK77rrrqK/9fj/PPfccN9xwAwBPPvlkJMoKibFjx7J48WIAysvLueee\ne3C73bz77rtMnz6dG2+8MbIFdtHQoUOprKwkPj6eqVOnUlNTw9ixY6moqABg3rx5Ea0vLKctRlpu\nbm6ry/1+P9u3bz/B1YTerFmz+Oijj0hOTqayspIJEyZQUlLCNddcgwm/n+fMmcO6dev45ptvGDhw\nIDU1NdhsNnbu3MmIESOiPtD/9a9/cfnll5OTkxP491q4cCHnnntuhCvrus2bNwc+f+ihh6ioqGDQ\noEFs27aNESNGRH2gt7S0EB8fD8CKFSv44IMPiImJ4Ve/+hU//elPI1ydoYH+zjvv8Pzzz9OnT5+j\nlvv9fiorKyNUVegcOnSI5ORkALKysli5ciU///nPqauri8CVdaHXu3dv4uPjiY+P5+yzz8ZmswGQ\nlJRkxC+sdevW8fvf/55ly5bxyCOPcMYZZ1BcXExBQUGkS+uyI3/+mpqaGDRoEAD9+vUjJib6Z3hT\nUlKoqKggOzsbh8NBXV0dqamp3WagaGSgX3jhhcTHx3P55Zcf99rgwYMjUFFo9e3bl5qaGs466ywA\nkpOT8Xg8jB07ls8//zzC1XWdxWLh4MGDxMXF8dprrwWWf/vtt7S0tESwstDo27cvjz/+OB999BHj\nx4/n6quvNqIvgLVr15KQkIDf7+fAgQNs2bKF5ORkmpqaOHToUKTL67K5c+dyww03UFRURGJiIunp\n6aSnp7Nr1y4ee+yxSJfX8+bQTbB27VpOOeUUzj777KOWHzx4kLKyMsaPHx+hykLjq6++4owzziA2\n9ujxhs/no6qqipEjR0aostDz+/2Ulpby3nvv8fzzz0e6nLDZtWsXVVVVXHTRRZEuJSSqqqrYsGED\nzc3NDBgwgPPPP79b/AXSowP9oosu4r333ot0GWGj/qKbyf2Z3BtErr/I/0qJoO9PPzKV+otuJvdn\ncm8Quf56dKCb8AbiD1F/0c3k/kzuDSLXX48OdBERk/ToQDf97QP1F91M7s/k3iBy/fXoN0U/++wz\nhg4dGukywkb9RTeT+zO5N4hcf0aP0BctWoTT6SQxMZGEhAT69u1LQkJC4PVo/4FSf+qvuzK5N+i+\n/Rk9Qj/77LN55ZVXjH1akvqLbib3Z3Jv0H37M3qEbrVau903PJTUX3QzuT+Te4Pu25/RI/S7776b\n+vp6xo4dy0knnRRY/otf/CKCVYWO+otuJvdncm/Qffsz8l4u39uzZw/x8fEsX748sMxisUT8mx4q\n6i+6mdyfyb1B9+3P6BG6iEhPYvQc+oYNGxgxYkTgHedPPvmEP/7xjxGuKnTUX3QzuT+Te4Nu3J/f\nYP/3f//n/89//uNPT08PLBsyZEgEKwot9RfdTO7P5N78/u7bn9Ej9P3795OVlXXUsmNvyRrN1F90\nM7k/k3uD7tuf0YHer18/ampqAjfK+cc//hF40o8J1F90M7k/k3uDbtxfpP9ECKeamhr/iBEj/Cef\nfLL/jDPO8F9yySX+2traSJcVMuovupncn8m9+f3dt78ecZbLvn37aGlpoW/fvpEuJSzUX3QzuT+T\ne4Pu15/RUy4NDQ1MnDiRcePG0bdvX9atW8ff/va3SJcVMuovupncn8m9QTfuL9J/IoTTlVde6X/5\n5Zf9w4cP9/v9fv/Bgwf9Q4cOjXBVoaP+opvJ/Zncm9/fffszeoS+bds28vLyAg9vjY2NpVevXhGu\nKnTUX3Tw0KISAAABTElEQVQzuT+Te4Pu25/RgX7KKaewffv2wDvR77//PomJiRGuKnTUX3QzuT+T\ne4Nu3F+k/0QIp48++sh/8cUX+xMSEvwXX3yx3+l0+teuXRvpskJG/UU3k/szuTe/v/v2Z/QIvaam\nhqVLl/Luu+8yatQonE4nzc3NkS4rZNRfdDO5P5N7g27cX6R/o4TTsGHD/H6/3//OO+/43W63/9VX\nX/VnZWVFuKrQUX/RzeT+TO7N7+++/Rk9Qv/+TYrXXnuNyZMnc/XVV9PU1BThqkJH/UU3k/szuTfo\nvv0ZHeh2u51bb72Vl19+mauuuooDBw7Q0tIS6bJCRv1FN5P7M7k36L79GX2l6P79+1m2bBnDhg3D\n6XSyZcsWPv30U3JyciJdWkiov+hmcn8m9wbdtz+jA11EpCcxespFRKQnUaCLiBhCgS4iYggFuoiI\nIf4frgZn6Kjh5VYAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x7f76cbc882e8>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "num_saw_movie = pd.DataFrame()\n",
    "num_saw_movie[\"males\"] = males.iloc[:,3:9].sum()\n",
    "num_saw_movie[\"females\"] = females.iloc[:,3:9].sum()\n",
    "num_saw_movie.plot.bar()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Again the overall pattern in the number of respondents who viewed the different Star Wars movies is very similar.  However, there are less views from female respondents."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "497\n",
      "549\n"
     ]
    }
   ],
   "source": [
    "# check overall numbers of male and female respondents\n",
    "print(males.shape[0])\n",
    "print(females.shape[0])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Actually, even though there were low female turnouts for the Star Wars movies compared to males, there are more female respondents in the survey!  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "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.4.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}