Mission201Solution.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 82,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "star_wars = pd.read_csv(\"star_wars.csv\", encoding=\"ISO-8859-1\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "star_wars = star_wars[pd.notnull(star_wars[\"RespondentID\"])]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\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>3292879998</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Star Wars: Episode I  The Phantom Menace</td>\n",
       "      <td>Star Wars: Episode II  Attack of the Clones</td>\n",
       "      <td>Star Wars: Episode III  Revenge of the Sith</td>\n",
       "      <td>Star Wars: Episode IV  A New Hope</td>\n",
       "      <td>Star Wars: Episode V The Empire Strikes Back</td>\n",
       "      <td>Star Wars: Episode VI Return of the Jedi</td>\n",
       "      <td>3</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>3292879538</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Male</td>\n",
       "      <td>18-29</td>\n",
       "      <td>$0 - $24,999</td>\n",
       "      <td>Bachelor degree</td>\n",
       "      <td>West South Central</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3292765271</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Star Wars: Episode I  The Phantom Menace</td>\n",
       "      <td>Star Wars: Episode II  Attack of the Clones</td>\n",
       "      <td>Star Wars: Episode III  Revenge of the Sith</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</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>3292763116</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Star Wars: Episode I  The Phantom Menace</td>\n",
       "      <td>Star Wars: Episode II  Attack of the Clones</td>\n",
       "      <td>Star Wars: Episode III  Revenge of the Sith</td>\n",
       "      <td>Star Wars: Episode IV  A New Hope</td>\n",
       "      <td>Star Wars: Episode V The Empire Strikes Back</td>\n",
       "      <td>Star Wars: Episode VI Return of the Jedi</td>\n",
       "      <td>5</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>3292731220</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Star Wars: Episode I  The Phantom Menace</td>\n",
       "      <td>Star Wars: Episode II  Attack of the Clones</td>\n",
       "      <td>Star Wars: Episode III  Revenge of the Sith</td>\n",
       "      <td>Star Wars: Episode IV  A New Hope</td>\n",
       "      <td>Star Wars: Episode V The Empire Strikes Back</td>\n",
       "      <td>Star Wars: Episode VI Return of the Jedi</td>\n",
       "      <td>5</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    3292879998                                                Yes             \n",
       "2    3292879538                                                 No             \n",
       "3    3292765271                                                Yes             \n",
       "4    3292763116                                                Yes             \n",
       "5    3292731220                                                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": 84,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "star_wars.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "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",
       "       'Which of the following Star Wars films have you seen? Please select all that apply.',\n",
       "       'Unnamed: 4', 'Unnamed: 5', 'Unnamed: 6', 'Unnamed: 7', 'Unnamed: 8',\n",
       "       'Please rank the Star Wars films in order of preference with 1 being your favorite film in the franchise and 6 being your least favorite film.',\n",
       "       'Unnamed: 10', 'Unnamed: 11', 'Unnamed: 12', 'Unnamed: 13',\n",
       "       'Unnamed: 14',\n",
       "       'Please state whether you view the following characters favorably, unfavorably, or are unfamiliar with him/her.',\n",
       "       'Unnamed: 16', 'Unnamed: 17', 'Unnamed: 18', 'Unnamed: 19',\n",
       "       'Unnamed: 20', 'Unnamed: 21', 'Unnamed: 22', 'Unnamed: 23',\n",
       "       'Unnamed: 24', 'Unnamed: 25', 'Unnamed: 26', 'Unnamed: 27',\n",
       "       'Unnamed: 28', 'Which character shot first?',\n",
       "       'Are you familiar with the Expanded Universe?',\n",
       "       'Do you consider yourself to be a fan of the Expanded Universe?ÂÃ¦',\n",
       "       'Do you consider yourself to be a fan of the Star Trek franchise?',\n",
       "       'Gender', 'Age', 'Household Income', 'Education',\n",
       "       'Location (Census Region)'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 85,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "star_wars.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\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>3292879998</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>Star Wars: Episode I  The Phantom Menace</td>\n",
       "      <td>Star Wars: Episode II  Attack of the Clones</td>\n",
       "      <td>Star Wars: Episode III  Revenge of the Sith</td>\n",
       "      <td>Star Wars: Episode IV  A New Hope</td>\n",
       "      <td>Star Wars: Episode V The Empire Strikes Back</td>\n",
       "      <td>Star Wars: Episode VI Return of the Jedi</td>\n",
       "      <td>3</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>3292879538</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Male</td>\n",
       "      <td>18-29</td>\n",
       "      <td>$0 - $24,999</td>\n",
       "      <td>Bachelor degree</td>\n",
       "      <td>West South Central</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3292765271</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>Star Wars: Episode I  The Phantom Menace</td>\n",
       "      <td>Star Wars: Episode II  Attack of the Clones</td>\n",
       "      <td>Star Wars: Episode III  Revenge of the Sith</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</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>3292763116</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>Star Wars: Episode I  The Phantom Menace</td>\n",
       "      <td>Star Wars: Episode II  Attack of the Clones</td>\n",
       "      <td>Star Wars: Episode III  Revenge of the Sith</td>\n",
       "      <td>Star Wars: Episode IV  A New Hope</td>\n",
       "      <td>Star Wars: Episode V The Empire Strikes Back</td>\n",
       "      <td>Star Wars: Episode VI Return of the Jedi</td>\n",
       "      <td>5</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>3292731220</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>Star Wars: Episode I  The Phantom Menace</td>\n",
       "      <td>Star Wars: Episode II  Attack of the Clones</td>\n",
       "      <td>Star Wars: Episode III  Revenge of the Sith</td>\n",
       "      <td>Star Wars: Episode IV  A New Hope</td>\n",
       "      <td>Star Wars: Episode V The Empire Strikes Back</td>\n",
       "      <td>Star Wars: Episode VI Return of the Jedi</td>\n",
       "      <td>5</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    3292879998                                               True             \n",
       "2    3292879538                                              False             \n",
       "3    3292765271                                               True             \n",
       "4    3292763116                                               True             \n",
       "5    3292731220                                               True             \n",
       "\n",
       "  Do you consider yourself to be a fan of the Star Wars film franchise?  \\\n",
       "1                                               True                      \n",
       "2                                                NaN                      \n",
       "3                                              False                      \n",
       "4                                               True                      \n",
       "5                                               True                      \n",
       "\n",
       "  Which of the following Star Wars films have you seen? Please select all that apply.  \\\n",
       "1           Star Wars: Episode I  The Phantom Menace                                    \n",
       "2                                                NaN                                    \n",
       "3           Star Wars: Episode I  The Phantom Menace                                    \n",
       "4           Star Wars: Episode I  The Phantom Menace                                    \n",
       "5           Star Wars: Episode I  The Phantom Menace                                    \n",
       "\n",
       "                                    Unnamed: 4  \\\n",
       "1  Star Wars: Episode II  Attack of the Clones   \n",
       "2                                          NaN   \n",
       "3  Star Wars: Episode II  Attack of the Clones   \n",
       "4  Star Wars: Episode II  Attack of the Clones   \n",
       "5  Star Wars: Episode II  Attack of the Clones   \n",
       "\n",
       "                                    Unnamed: 5  \\\n",
       "1  Star Wars: Episode III  Revenge of the Sith   \n",
       "2                                          NaN   \n",
       "3  Star Wars: Episode III  Revenge of the Sith   \n",
       "4  Star Wars: Episode III  Revenge of the Sith   \n",
       "5  Star Wars: Episode III  Revenge of the Sith   \n",
       "\n",
       "                          Unnamed: 6  \\\n",
       "1  Star Wars: Episode IV  A New Hope   \n",
       "2                                NaN   \n",
       "3                                NaN   \n",
       "4  Star Wars: Episode IV  A New Hope   \n",
       "5  Star Wars: Episode IV  A New Hope   \n",
       "\n",
       "                                     Unnamed: 7  \\\n",
       "1  Star Wars: Episode V The Empire Strikes Back   \n",
       "2                                           NaN   \n",
       "3                                           NaN   \n",
       "4  Star Wars: Episode V The Empire Strikes Back   \n",
       "5  Star Wars: Episode V The Empire Strikes Back   \n",
       "\n",
       "                                 Unnamed: 8  \\\n",
       "1  Star Wars: Episode VI Return of the Jedi   \n",
       "2                                       NaN   \n",
       "3                                       NaN   \n",
       "4  Star Wars: Episode VI Return of the Jedi   \n",
       "5  Star Wars: Episode VI Return of the Jedi   \n",
       "\n",
       "  Please rank the Star Wars films in order of preference with 1 being your favorite film in the franchise and 6 being your least favorite film.  \\\n",
       "1                                                  3                                                                                              \n",
       "2                                                NaN                                                                                              \n",
       "3                                                  1                                                                                              \n",
       "4                                                  5                                                                                              \n",
       "5                                                  5                                                                                              \n",
       "\n",
       "            ...                    Unnamed: 28  \\\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": 86,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "yes_no = {\"Yes\": True, \"No\": False}\n",
    "\n",
    "for col in [\n",
    "    \"Have you seen any of the 6 films in the Star Wars franchise?\",\n",
    "    \"Do you consider yourself to be a fan of the Star Wars film franchise?\"\n",
    "    ]:\n",
    "    star_wars[col] = star_wars[col].map(yes_no)\n",
    "\n",
    "star_wars.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "\n",
    "movie_mapping = {\n",
    "    \"Star Wars: Episode I  The Phantom Menace\": True,\n",
    "    np.nan: False,\n",
    "    \"Star Wars: Episode II  Attack of the Clones\": True,\n",
    "    \"Star Wars: Episode III  Revenge of the Sith\": True,\n",
    "    \"Star Wars: Episode IV  A New Hope\": True,\n",
    "    \"Star Wars: Episode V The Empire Strikes Back\": True,\n",
    "    \"Star Wars: Episode VI Return of the Jedi\": True\n",
    "}\n",
    "\n",
    "for col in star_wars.columns[3:9]:\n",
    "    star_wars[col] = star_wars[col].map(movie_mapping)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>RespondentID</th>\n",
       "      <th>Have you seen any of the 6 films in the Star Wars franchise?</th>\n",
       "      <th>Do you consider yourself to be a fan of the Star Wars film franchise?</th>\n",
       "      <th>seen_1</th>\n",
       "      <th>seen_2</th>\n",
       "      <th>seen_3</th>\n",
       "      <th>seen_4</th>\n",
       "      <th>seen_5</th>\n",
       "      <th>seen_6</th>\n",
       "      <th>Please rank the Star Wars films in order of preference with 1 being your favorite film in the franchise and 6 being your least favorite film.</th>\n",
       "      <th>...</th>\n",
       "      <th>Unnamed: 28</th>\n",
       "      <th>Which character shot first?</th>\n",
       "      <th>Are you familiar with the Expanded Universe?</th>\n",
       "      <th>Do you consider yourself to be a fan of the Expanded Universe?ÂÃ¦</th>\n",
       "      <th>Do you consider yourself to be a fan of the Star Trek franchise?</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Age</th>\n",
       "      <th>Household Income</th>\n",
       "      <th>Education</th>\n",
       "      <th>Location (Census Region)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3292879998</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>3</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>3292879538</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Male</td>\n",
       "      <td>18-29</td>\n",
       "      <td>$0 - $24,999</td>\n",
       "      <td>Bachelor degree</td>\n",
       "      <td>West South Central</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3292765271</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>1</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>3292763116</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>5</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>3292731220</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>5</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    3292879998                                               True             \n",
       "2    3292879538                                              False             \n",
       "3    3292765271                                               True             \n",
       "4    3292763116                                               True             \n",
       "5    3292731220                                               True             \n",
       "\n",
       "  Do you consider yourself to be a fan of the Star Wars film franchise?  \\\n",
       "1                                               True                      \n",
       "2                                                NaN                      \n",
       "3                                              False                      \n",
       "4                                               True                      \n",
       "5                                               True                      \n",
       "\n",
       "  seen_1 seen_2 seen_3 seen_4 seen_5 seen_6  \\\n",
       "1   True   True   True   True   True   True   \n",
       "2  False  False  False  False  False  False   \n",
       "3   True   True   True  False  False  False   \n",
       "4   True   True   True   True   True   True   \n",
       "5   True   True   True   True   True   True   \n",
       "\n",
       "  Please rank the Star Wars films in order of preference with 1 being your favorite film in the franchise and 6 being your least favorite film.  \\\n",
       "1                                                  3                                                                                              \n",
       "2                                                NaN                                                                                              \n",
       "3                                                  1                                                                                              \n",
       "4                                                  5                                                                                              \n",
       "5                                                  5                                                                                              \n",
       "\n",
       "            ...                    Unnamed: 28  \\\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": 88,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "star_wars = star_wars.rename(columns={\n",
    "        \"Which of the following Star Wars films have you seen? Please select all that apply.\": \"seen_1\",\n",
    "        \"Unnamed: 4\": \"seen_2\",\n",
    "        \"Unnamed: 5\": \"seen_3\",\n",
    "        \"Unnamed: 6\": \"seen_4\",\n",
    "        \"Unnamed: 7\": \"seen_5\",\n",
    "        \"Unnamed: 8\": \"seen_6\"\n",
    "        })\n",
    "\n",
    "star_wars.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>RespondentID</th>\n",
       "      <th>Have you seen any of the 6 films in the Star Wars franchise?</th>\n",
       "      <th>Do you consider yourself to be a fan of the Star Wars film franchise?</th>\n",
       "      <th>seen_1</th>\n",
       "      <th>seen_2</th>\n",
       "      <th>seen_3</th>\n",
       "      <th>seen_4</th>\n",
       "      <th>seen_5</th>\n",
       "      <th>seen_6</th>\n",
       "      <th>ranking_1</th>\n",
       "      <th>...</th>\n",
       "      <th>Unnamed: 28</th>\n",
       "      <th>Which character shot first?</th>\n",
       "      <th>Are you familiar with the Expanded Universe?</th>\n",
       "      <th>Do you consider yourself to be a fan of the Expanded Universe?ÂÃ¦</th>\n",
       "      <th>Do you consider yourself to be a fan of the Star Trek franchise?</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Age</th>\n",
       "      <th>Household Income</th>\n",
       "      <th>Education</th>\n",
       "      <th>Location (Census Region)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3292879998</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>3</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>3292879538</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Male</td>\n",
       "      <td>18-29</td>\n",
       "      <td>$0 - $24,999</td>\n",
       "      <td>Bachelor degree</td>\n",
       "      <td>West South Central</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3292765271</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>1</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>3292763116</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>5</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>3292731220</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>5</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    3292879998                                               True             \n",
       "2    3292879538                                              False             \n",
       "3    3292765271                                               True             \n",
       "4    3292763116                                               True             \n",
       "5    3292731220                                               True             \n",
       "\n",
       "  Do you consider yourself to be a fan of the Star Wars film franchise?  \\\n",
       "1                                               True                      \n",
       "2                                                NaN                      \n",
       "3                                              False                      \n",
       "4                                               True                      \n",
       "5                                               True                      \n",
       "\n",
       "  seen_1 seen_2 seen_3 seen_4 seen_5 seen_6 ranking_1  \\\n",
       "1   True   True   True   True   True   True         3   \n",
       "2  False  False  False  False  False  False       NaN   \n",
       "3   True   True   True  False  False  False         1   \n",
       "4   True   True   True   True   True   True         5   \n",
       "5   True   True   True   True   True   True         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": 89,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "star_wars = star_wars.rename(columns={\n",
    "        \"Please rank the Star Wars films in order of preference with 1 being your favorite film in the franchise and 6 being your least favorite film.\": \"ranking_1\",\n",
    "        \"Unnamed: 10\": \"ranking_2\",\n",
    "        \"Unnamed: 11\": \"ranking_3\",\n",
    "        \"Unnamed: 12\": \"ranking_4\",\n",
    "        \"Unnamed: 13\": \"ranking_5\",\n",
    "        \"Unnamed: 14\": \"ranking_6\"\n",
    "        })\n",
    "\n",
    "star_wars.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "star_wars[star_wars.columns[9:15]] = star_wars[star_wars.columns[9:15]].astype(float)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ranking_1    3.732934\n",
       "ranking_2    4.087321\n",
       "ranking_3    4.341317\n",
       "ranking_4    3.272727\n",
       "ranking_5    2.513158\n",
       "ranking_6    3.047847\n",
       "dtype: float64"
      ]
     },
     "execution_count": 91,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "star_wars[star_wars.columns[9:15]].mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Container object of 6 artists>"
      ]
     },
     "execution_count": 93,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": [
       "iVBORw0KGgoAAAANSUhEUgAAAXIAAAEACAYAAACuzv3DAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\n",
       "AAALEgAACxIB0t1+/AAAEdNJREFUeJzt3X+s3XV9x/HnixaCP9BmI6lKazABkpGYiSzYgI7rogs0\n",
       "ru4PEjFRMv6YhIxJWDROgrN/aZaYaPAHNlNI/RGIgdhg1o05pUT+6UTaorQssGDSulGMFTKoJjS8\n",
       "98f9lh0O997zvfR7evq59/lITvh+z/d9z/f9yS2v872fe773k6pCktSu02bdgCTpxBjkktQ4g1yS\n",
       "GmeQS1LjDHJJapxBLkmN6xXkSdYk2ZPkBwscm0vybHd8T5Jbhm9TkrSYtT3rbgT2A2ctcvyBqtoy\n",
       "TEuSpOWYeEWeZAOwGfgGkMXKhmxKktRfn6mVLwKfBF5c5HgBlybZl2RnkgsH606SNNGSQZ7kA8DT\n",
       "VbWHxa+6HwY2VtUfA18GdgzboiRpKVnqb60k+RzwUeAYcCbwBuCeqrpmia95Eri4qo6MPe8fdZGk\n",
       "V6Gqlpy+XjLIX1aYXA58oqr+Yuz59cxftVeSS4DvVdW5C3x9TWqmZUm2VtXWWfcxLSt5fCt5bOD4\n",
       "WtcnO/t+auW46l74OoCq2gZcBVyf5BhwFLj6VfQqSXqVegd5VT0APNBtbxt5/qvAV4dvTZLUh3d2\n",
       "DmfXrBuYsl2zbmCKds26gSnbNesGpmzXrBuYtd5z5Cd8ohU+Ry5J09AnO70il6TGLfeXnVqlWvz4\n",
       "qD8BarUwyLUMLWW5Ga7Vw6kVSWqcQS5JjTPIJalxBrkkNc4gl6TGGeSS1DiDXJIaZ5BLUuMMcklq\n",
       "nEEuSY0zyCWpcb3+1kqSNcBDwKHxpd6647cCVzK/QtBfdYs1ryr+USlJs9L3j2bdCOwHzho/kGQz\n",
       "cF5VnZ/kXcBtwKbhWmxJS1luhksrxcSplSQbgM3AN1j4//4twHaAqtoNrOsWZJYknQR95si/CHwS\n",
       "eHGR4+cAB0f2DwEbTrAvSVJPS06tJPkA8HRV7Ukyt1Tp2P6CcwxJto7s7qqqXT16lKRVo8vauWV9\n",
       "zVJrdib5HPBR4BhwJvAG4J6qumak5uvMh/Jd3f5jwOVVdXjstVb0mp3zv+xsa458Od+PlT4+6VR1\n",
       "wmt2VtXNVbWxqt4GXA38eDTEO/cC13Qn3AQ8Mx7ikqTpWe5SbwWQ5DqAqtpWVTuTbE7yBPA8cO3A\n",
       "PUqSlrDk1MqgJ3Jq5RTj1IrUghOeWpEknfoMcklqnEEuSY0zyCWpcQa5JDXOIJekxhnkktQ4g1yS\n",
       "GmeQS1LjlnuL/glxFR1JGt5JDfK2bvEGV9GR1AKnViSpcQa5JDXOIJekxhnkktQ4g1ySGjcxyJOc\n",
       "mWR3kr1J9if5/AI1c0meTbKne9wynXYlSeMmfvywqn6f5L1VdTTJWuDBJO+uqgfHSh+oqi3TaVOS\n",
       "tJheUytVdbTbPANYAxxZoMwPXUvSDPQK8iSnJdkLHAbur6r9YyUFXJpkX5KdSS4culFJ0sJ63dlZ\n",
       "VS8C70jyRuC+JHNVtWuk5GFgYzf9ciWwA7jgla+0dWR7rntIko5LMscywzFVy7ttPslngN9V1ReW\n",
       "qHkSuLiqjow819gq7LCcldjbG9/yVplf6eOTTlVJatK/5T6fWjk7ybpu+zXA+4E9YzXrk6TbvoT5\n",
       "N4iF5tElSQPrM7XyZmB7ktOYD/5vV9WPklwHUFXbgKuA65McA44CV0+rYUnSyy17auVVn6i5H83B\n",
       "qZWR6hU+PulUNcjUiiTp1GaQS1LjDHJJapxBLkmNM8glqXEGuSQ17iQvviydeuY/WtkeP16p4wxy\n",
       "CWjrM/LgHxvVKKdWJKlxBrkkNc4gl6TGGeSS1DiDXJIaZ5BLUuMMcklqnEEuSY1bMsiTnJlkd5K9\n",
       "SfYn+fwidbcmeTzJviQXTadVSdJClryzs6p+n+S9VXU0yVrgwSTvrqoHj9ck2QycV1XnJ3kXcBuw\n",
       "abptS5KOm3iLflUd7TbPANYA44sqbwG2d7W7k6xLsr6qDg/aqSQtwL+V02OOPMlpSfYCh4H7q2r/\n",
       "WMk5wMGR/UPAhqEalKTJqrHHsPpckb8IvCPJG4H7ksxV1a6xsvF3lkU63TqyPdc9JEnHJZljmeGY\n",
       "qv7vDkk+A/yuqr4w8tzXgV1VdVe3/xhw+fjUSnursMNyVmJvb3zLW2V+JY+vvbHBcr9/K9lK//4l\n",
       "qUm1kz61cnaSdd32a4D3A3vGyu4FrulqNgHPOD8uSSfPpKmVNwPbk5zGfOh/u6p+lOQ6gKraVlU7\n",
       "k2xO8gTwPHDtdFuWJI1a1tTKCZ1oFfz409b4nFp5qbK5sYFTK/9vpX//TnhqRZJ06jPIJalxBrkk\n",
       "Nc4gl6TGGeSS1DiDXJIaZ5BLUuMMcklqnEEuSY0zyCWpcQa5JDXOIJekxhnkktQ4g1ySGmeQS1Lj\n",
       "+iy+vDHJ/UkeTfKLJB9foGYuybNJ9nSPW6bTriRp3MTFl4EXgJuqam+S1wM/S/LDqjowVvdAVW0Z\n",
       "vkVJ0lImXpFX1VNVtbfbfg44ALxlgVJXK5GkGVjWHHmSc4GLgN1jhwq4NMm+JDuTXDhMe5KkSfpM\n",
       "rQDQTavcDdzYXZmPehjYWFVHk1wJ7AAuGK5NSa/W/JqW7XFN0v56BXmS04F7gO9U1Y7x41X1vyPb\n",
       "/5Lka0n+oKqOvLxy68j2XPeQNH2tZfnqzfAkcywzHFO19Dc4SYDtwG+q6qZFatYDT1dVJbkE+F5V\n",
       "nTtWs+JXum5rfMtbhX0lj6+9sYHjG6lcBeObVNvnivwy4CPAI0n2dM/dDLwVoKq2AVcB1yc5BhwF\n",
       "ru7ToCTpxE28Ih/sRKvgXbOt8XlF/lJlc2MDxzdSuQrGN6nWOzslqXEGuSQ1ziCXpMYZ5JLUOINc\n",
       "khpnkEtS4wxySWqcQS5JjTPIJalxBrkkNc4gl6TGGeSS1DiDXJIaZ5BLUuMMcklqnEEuSY2bGORJ\n",
       "Nia5P8mjSX6R5OOL1N2a5PEk+5JcNHyrkqSF9Fnq7QXgpqram+T1wM+S/LCqDhwvSLIZOK+qzk/y\n",
       "LuA2YNN0WpYkjZp4RV5VT1XV3m77OeAA8Jaxsi3ML9BMVe0G1nULMkuSpmxZc+RJzgUuAnaPHToH\n",
       "ODiyfwjYcCKNSZL66R3k3bTK3cCN3ZX5K0rG9ltbDVWSmtRnjpwkpwP3AN+pqh0LlPwK2Diyv6F7\n",
       "bszWke257iFJOi7JHMsMx1QtfeGcJMzPf/+mqm5apGYzcENVbU6yCfhSVW0aq6n2LtJDVY3/pLFw\n",
       "ZXPj6z82WNnja29s4PhGKlfB+CbV9rkivwz4CPBIkj3dczcDbwWoqm1VtTPJ5iRPAM8D1/ZpUJJ0\n",
       "4iZekQ92olXwrtnW+Lwif6myubGB4xupXAXjm1TrnZ2S1DiDXJIaZ5BLUuMMcklqnEEuSY0zyCWp\n",
       "cQa5JDXOIJekxhnkktQ4g1ySGmeQS1LjDHJJapxBLkmNM8glqXEGuSQ1ziCXpMZNDPIktyc5nOTn\n",
       "ixyfS/Jskj3d45bh25QkLabPUm93AF8GvrVEzQNVtWWYliRJyzHxiryqfgL8dkJZ7yXDJEnDGmKO\n",
       "vIBLk+xLsjPJhQO8piSppz5TK5M8DGysqqNJrgR2ABcsXLp1ZHuue0iSjksyxzLDMVWTV59Oci7w\n",
       "g6p6e4/aJ4GLq+rI2PMrfqXrtsbXf2ywssfX3tjA8Y1UroLxTao94amVJOuTpNu+hPk3hyMTvkyS\n",
       "NJCJUytJ7gQuB85OchD4LHA6QFVtA64Crk9yDDgKXD29diVJ43pNrQxyolXw409b43Nq5aXK5sYG\n",
       "jm+kchWMb+pTK5Kk2TLIJalxBrkkNc4gl6TGGeSS1DiDXJIaZ5BLUuMMcklqnEEuSY0zyCWpcQa5\n",
       "JDXOIJekxhnkktQ4g1ySGmeQS1LjDHJJatzEIE9ye5LDSX6+RM2tSR5Psi/JRcO2KElaSp8r8juA\n",
       "KxY7mGQzcF5VnQ98DLhtoN4kST1MDPKq+gnw2yVKtgDbu9rdwLok64dpT5I0yRBz5OcAB0f2DwEb\n",
       "BnhdSVIPawd6nfGFQRdZCXXryPZc95AkHZdkjmWG4xBB/itg48j+hu65BWwd4HSStHJV1S5g1/H9\n",
       "JJ+d9DVDTK3cC1zTnXAT8ExVHR7gdSVJPUy8Ik9yJ3A5cHaSg8BngdMBqmpbVe1MsjnJE8DzwLXT\n",
       "bFiS9HKpWmQ6e+gTJbXo1PkpK1TV+Pz/wpXNja//2GBlj6+9sYHjG6lcBeObVOudnZLUOINckhpn\n",
       "kEtS4wxySWqcQS5JjTPIJalxBrkkNc4gl6TGGeSS1DiDXJIaZ5BLUuMMcklqnEEuSY0zyCWpcQa5\n",
       "JDXOIJekxvUK8iRXJHksyeNJPrXA8bkkzybZ0z1uGb5VSdJC+iz1tgb4CvA+5hdV/mmSe6vqwFjp\n",
       "A1W1ZQo9SpKW0OeK/BLgiar6ZVW9ANwFfHCBut7LhkmShtMnyM8BDo7sH+qeG1XApUn2JdmZ5MKh\n",
       "GpQkLW3i1Ar9VjV9GNhYVUeTXAnsAC54ZdnWke257iFJOi7JHMsMx1QtndNJNgFbq+qKbv/TwItV\n",
       "9Y9LfM2TwMVVdWTkuRW/0nVb4+s/NljZ42tvbOD4RipXwfgm1faZWnkIOD/JuUnOAD4E3Dt2ovVJ\n",
       "0m1fwvwbxJFXvpQkaWgTp1aq6liSG4D7gDXAN6vqQJLruuPbgKuA65McA44CV0+xZ0nSiIlTK4Od\n",
       "aBX8+NPW+JxaeamyubGB4xupXAXjG2JqRZJ0CjPIJalxBrkkNc4gl6TGGeSS1DiDXJIaZ5BLUuMM\n",
       "cklqnEEuSY0zyCWpcQa5JDXOIJekxhnkktQ4g1ySGmeQS1LjJgZ5kiuSPJbk8SSfWqTm1u74viQX\n",
       "Dd+mJGkxSwZ5kjXAV4ArgAuBDyf5o7GazcB5VXU+8DHgtin1KklawKQr8kuAJ6rql1X1AnAX8MGx\n",
       "mi3AdoCq2g2sS7J+8E4lSQuaFOTnAAdH9g91z02q2XDirUmS+pgU5H0XwhtfT661BfQkqVlrJxz/\n",
       "FbBxZH8j81fcS9Vs6J5bQO+1fk8Z8wu79q6eXiNTsLyxwcoeX1tjA8c3Vj29RqZk+f//LW5SkD8E\n",
       "nJ/kXOC/gQ8BHx6ruRe4AbgrySbgmao6PP5Cy1mxXZLU35JBXlXHktwA3AesAb5ZVQeSXNcd31ZV\n",
       "O5NsTvIE8Dxw7dS7liS9JFVOZ0tSy07KnZ19bipqVZLbkxxO8vNZ9zK0JBuT3J/k0SS/SPLxWfc0\n",
       "pCRnJtmdZG+S/Uk+P+uepiHJmiR7kvxg1r0MLckvkzzSje8/Zt3PkJKsS3J3kgPdv89Ni9ZO+4q8\n",
       "u6noP4H3Mf9L0J8CH66qA1M98UmS5D3Ac8C3qurts+5nSEneBLypqvYmeT3wM+AvV8r3DiDJa6vq\n",
       "aJK1wIPAJ6rqwVn3NaQkfwdcDJxVVVtm3c+QkjwJXFxVR2bdy9CSbAceqKrbu3+fr6uqZxeqPRlX\n",
       "5H1uKmpWVf0E+O2s+5iGqnqqqvZ2288BB4C3zLarYVXV0W7zDOZ/D7SiAiHJBmAz8A1a/GhHPytu\n",
       "XEneCLynqm6H+d9XLhbicHKCvM9NRTrFdZ9cugjYPdtOhpXktCR7gcPA/VW1f9Y9DeyLwCeBF2fd\n",
       "yJQU8O9JHkry17NuZkBvA36d5I4kDyf5pySvXaz4ZAS5v01tXDetcjdwY3dlvmJU1YtV9Q7m73/4\n",
       "0yRzM25pMEk+ADxdVXtYgVetncuq6iLgSuBvuqnOlWAt8E7ga1X1TuY/Efj3ixWfjCDvc1ORTlFJ\n",
       "TgfuAb5TVTtm3c+0dD+2/jPwJ7PuZUCXAlu6eeQ7gT9L8q0Z9zSoqvqf7r+/Br7P/FTuSnAIOFRV\n",
       "P+3272Y+2Bd0MoL8pZuKkpzB/E1F956E8+oEJQnwTWB/VX1p1v0MLcnZSdZ1268B3g/smW1Xw6mq\n",
       "m6tqY1W9Dbga+HFVXTPrvoaS5LVJzuq2Xwf8ObAiPj1WVU8BB5Nc0D31PuDRxeon3dk5REML3lQ0\n",
       "7fOeLEnuBC4H/jDJQeAfquqOGbc1lMuAjwCPJDkecJ+uqn+dYU9DejOwPclpzF/UfLuqfjTjnqZp\n",
       "pU1zrge+P3+9wVrgu1X1b7NtaVB/C3y3uwD+L5a42dIbgiSpcS71JkmNM8glqXEGuSQ1ziCXpMYZ\n",
       "5JLUOINckhpnkEtS4wxySWrc/wG/YmB1GqmO3AAAAABJRU5ErkJggg==\n"
      ],
      "text/plain": [
       "<matplotlib.figure.Figure at 0x10a05a748>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "%matplotlib inline\n",
    "import matplotlib.pyplot as plt\n",
    "\n",
    "plt.bar(range(6), star_wars[star_wars.columns[9:15]].mean())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Rankings\n",
    "\n",
    "So far, we've cleaned up the data, renamed several columns, and computed the average ranking of each movie.  As I suspected, it looks like the \"original\" movies are rated much more highly than the newer ones."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "seen_1    673\n",
       "seen_2    571\n",
       "seen_3    550\n",
       "seen_4    607\n",
       "seen_5    758\n",
       "seen_6    738\n",
       "dtype: int64"
      ]
     },
     "execution_count": 97,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "star_wars[star_wars.columns[3:9]].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 96,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Container object of 6 artists>"
      ]
     },
     "execution_count": 96,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": [
       "iVBORw0KGgoAAAANSUhEUgAAAXUAAAEACAYAAABMEua6AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\n",
       "AAALEgAACxIB0t1+/AAAExpJREFUeJzt3W2MXNd93/HvT2IYW7JrmnWxfAzENmJiFgn8ELNtnNTr\n",
       "ViEUI6X0SlKApIQj5I0a20XRwKSBRnyVxALauEChF01sY+1aTFmlFmjkwaRkb5OgqGnZVO1oxYgM\n",
       "uq2WMZfyY+MYKUjw3xd7VxqvyJ1ZamaHc/b7AQY899xzZ86xqR/PnHvv3FQVkqQ23DLuDkiShsdQ\n",
       "l6SGGOqS1BBDXZIaYqhLUkMMdUlqSN9QT3IkybNJvprksSQ/mGRrklNJnk9yMsmWFe3PJTmb5MBo\n",
       "uy9J6pXVrlNPcgfwOeDNVfX/kvxn4A+Avw98vaoeSfJB4I1VdTjJPuAx4B3ATuBJYG9VXR3tMCRJ\n",
       "0H+m/n+By8BtSTYBtwF/CRwEZro2M8C9Xfke4FhVXa6qeeA8sH/YnZYkXduqoV5V3wT+LfB/WArz\n",
       "b1fVKWCqqha7ZovAVFfeASz0vMUCSzN2SdI6WDXUk/w94F8Cd7AU2K9L8gu9bWpp/Wa13xrwdwgk\n",
       "aZ1s6rP/J4D/XlXfAEjyX4F/BFxMsq2qLibZDlzq2l8Advccv6ur+z5JDHpJugFVldX29wv1s8C/\n",
       "SfJa4G+Au4DTwF8Dh4APd38+0bU/ATyW5N+xtOxyZ9d+zR2bZEmOVtXRcfdjVBzf5Gp5bLAhxtd3\n",
       "QrxqqFfV/0zyCeBp4CrwZeA/Aq8Hjid5EJgH7uvazyU5DswBV4CHyp+BlKR102+mTlU9Ajyyovqb\n",
       "LM3ar9X+14Fff/VdkyStlXeUjsbsuDswYrPj7sCIzY67AyM0O+4OjNjsuDswbqvefDSyD02q5TV1\n",
       "SRqFQbLTmbokNcRQl6SGGOqS1BBDXZIaYqhLUkP6XqcuqR2T+hMdXi03OENd2nAmLdfN87Vw+UWS\n",
       "GmKoS1JDDHVJaoihLkkN8USppGZ4dY+hLqk5k5brw726x+UXSWqIoS5JDTHUJakhhrokNaRvqCf5\n",
       "kSRnel7fSfL+JFuTnEryfJKTSbb0HHMkybkkZ5McGO0QJEnL1vQ4uyS3ABeA/cD7gK9X1SNJPgi8\n",
       "saoOJ9kHPAa8A9gJPAnsraqrPe/j4+ykMVi65G/yrg4ZNC82wviG/Ti7u4DzVfUCcBCY6epngHu7\n",
       "8j3Asaq6XFXzwHmW/hGQJI3YWkP9AeBYV56qqsWuvAhMdeUdwELPMQsszdglSSM2cKgn2Qz8M+C/\n",
       "rNxXS2s4q33nmbTvQ5I0kdZyR+nPAl+qqhe77cUk26rqYpLtwKWu/gKwu+e4XV3d90lytGdztqpm\n",
       "19AXSWpekmlgek3HDHqiNMnvAn9YVTPd9iPAN6rqw0kOA1tWnCjdz8snSn+4ej7IE6XSeGyEE4mt\n",
       "j69f24FCPcntwP8G9lTVX3V1W4HjwA8B88B9VfXtbt+HgF8CrgAfqKrPrrVjkoZvI4Re6+MbSqgP\n",
       "m6EujcdGCL3WxzfsSxolSTcxQ12SGmKoS1JDxvaQjEl8QonnASTd7Mb45KNJy3TzXNLNz+UXSWqI\n",
       "oS5JDTHUJakhhrokNcRQl6SGGOqS1BBDXZIaYqhLUkMMdUlqiKEuSQ0x1CWpIYa6JDXEUJekhhjq\n",
       "ktSQgUI9yZYkjyd5Lslckn+QZGuSU0meT3IyyZae9keSnEtyNsmB0XVfktRr0Jn6vwf+oKreDPw4\n",
       "cBY4DJyqqr3AU902SfYB9wP7gLuBR5P4jUCS1kGqVn9YRZI3AGeq6u+uqD8LvKuqFpNsA2ar6keT\n",
       "HAGuVtWHu3Z/BBytqv/Rc2zTT/zWZGv5qVyt/7e3EcbXr+0gM+g9wItJPp7ky0l+O8ntwFRVLXZt\n",
       "FoGprrwDWOg5fgHYOUiHpZtHTdBLetkgj7PbBLwN+JWq+mKSj9AttSyrquozu7nGvqM95enuJUla\n",
       "lmSaNYbjIKG+ACxU1Re77ceBI8DFJNuq6mKS7cClbv8FYHfP8bu6uhWOrqWfkrThVNUsMLu8neTh\n",
       "fsf0XX6pqovAC0n2dlV3Ac8CnwEOdXWHgCe68gnggSSbk+wB7gRODzYESdKrMchMHeB9wKeSbAb+\n",
       "AngvcCtwPMmDwDxwH0BVzSU5DswBV4CHqt/ZWEnSUPS9+mUkH9r4GWpNtsn7++nVIS+13ADjG8bV\n",
       "L5KkCWGoS1JDDHVJasigJ0q1BpN4RyIMfleipJuXoT4yk5br5rnUApdfJKkhhrokNcRQl6SGGOqS\n",
       "1BBPlGrNJvHqHq/s0UZhqOsGTVKum+faOFx+kaSGGOqS1BBDXZIaYqhLUkMMdUlqiKEuSQ0x1CWp\n",
       "IYa6JDVkoFBPMp/kK0nOJDnd1W1NcirJ80lOJtnS0/5IknNJziY5MKrOS5K+36Az9QKmq+qtVbW/\n",
       "qzsMnKqqvcBT3TZJ9gH3A/uAu4FHk/iNQJLWwVrCduW91geBma48A9zble8BjlXV5aqaB84D+5Ek\n",
       "jdxaZupPJnk6yS93dVNVtdiVF4GprrwDWOg5dgHY+ap7Kknqa9Af9HpnVX0tyd8BTiU527uzqqrP\n",
       "L/ddY9/RnvJ095IkLUsyzRrDcaBQr6qvdX++mOTTLC2nLCbZVlUXk2wHLnXNLwC7ew7f1dWtcHQt\n",
       "/ZSkDaeqZoHZ5e0kD/c7pu/yS5Lbkry+K98OHAC+CpwADnXNDgFPdOUTwANJNifZA9wJnB54FJKk\n",
       "GzbITH0K+HSS5fafqqqTSZ4Gjid5EJgH7gOoqrkkx4E54ArwUFVN0o9vS9LEyjjydmn9fdJyPgM/\n",
       "Pcfx3WwGHxu0Pb7JGxs4vp6WSfVr6/XjktQQQ12SGmKoS1JDDHVJaoihLkkNMdQlqSGGuiQ1xFCX\n",
       "pIYY6pLUEENdkhpiqEtSQwx1SWqIoS5JDTHUJakhhrokNcRQl6SGGOqS1BBDXZIaYqhLUkMGCvUk\n",
       "tyY5k+Qz3fbWJKeSPJ/kZJItPW2PJDmX5GySA6PquCTplQadqX8AmOPlJ7oeBk5V1V7gqW6bJPuA\n",
       "+4F9wN3Ao0n8NiBJ66Rv4CbZBbwH+B1g+SnWB4GZrjwD3NuV7wGOVdXlqpoHzgP7h9lhSdL1DTKL\n",
       "/i3gV4GrPXVTVbXYlReBqa68A1joabcA7Hy1nZQkDWbTajuT/BxwqarOJJm+VpuqqiR1rX3LTa5d\n",
       "fbSnPN29JEnLutydXssxq4Y68JPAwSTvAV4D/K0knwQWk2yrqotJtgOXuvYXgN09x+/q6q7h6Fr6\n",
       "KUkbTlXNArPL20ke7nfMqssvVfWhqtpdVXuAB4DPVdUvAieAQ12zQ8ATXfkE8ECSzUn2AHcCp9c4\n",
       "DknSDeo3U19peSnlN4HjSR4E5oH7AKpqLslxlq6UuQI8VFWrLc1IkoYo48jcpTX4Scv6UFXp387x\n",
       "3XwGHxu0Pb7JGxs4vp6WSfVr6zXkktQQQ12SGmKoS1JDDHVJaoihLkkNMdQlqSGGuiQ1xFCXpIYY\n",
       "6pLUEENdkhpiqEtSQwx1SWqIoS5JDTHUJakhhrokNcRQl6SGGOqS1BBDXZIaYqhLUkNWDfUkr0ny\n",
       "hSTPJJlL8htd/dYkp5I8n+Rkki09xxxJci7J2SQHRj0ASdLLVg31qvob4N1V9Rbgx4F3J/kp4DBw\n",
       "qqr2Ak912yTZB9wP7APuBh5N4rcBSVonfQO3qr7XFTcDtwLfAg4CM139DHBvV74HOFZVl6tqHjgP\n",
       "7B9mhyVJ19c31JPckuQZYBH4fFU9C0xV1WLXZBGY6so7gIWewxeAnUPsryRpFZv6Naiqq8BbkrwB\n",
       "+GySd6/YX0lqtbe4dvXRnvJ095IkLUsyzRrDsW+oL6uq7yT5feDtwGKSbVV1Mcl24FLX7AKwu+ew\n",
       "XV3dNRxdSz8lacOpqllgdnk7ycP9jul39cublq9sSfJa4GeAM8AJ4FDX7BDwRFc+ATyQZHOSPcCd\n",
       "wOk1jUKSdMP6zdS3AzPdFSy3AJ+sqqeSnAGOJ3kQmAfuA6iquSTHgTngCvBQVa22NCNJGqKMI3OX\n",
       "1uAnLetDVWWglo7vJjP42KDt8U3e2MDx9bRMql9bryGXpIYY6pLUEENdkhpiqEtSQwx1SWqIoS5J\n",
       "DTHUJakhhrokNcRQl6SGGOqS1BBDXZIaYqhLUkMMdUlqiKEuSQ0x1CWpIYa6JDXEUJekhhjqktQQ\n",
       "Q12SGtI31JPsTvL5JM8m+bMk7+/qtyY5leT5JCeTbOk55kiSc0nOJjkwygFIkl7W98HTSbYB26rq\n",
       "mSSvA74E3Au8F/h6VT2S5IPAG6vqcJJ9wGPAO4CdwJPA3qq62vOezT8c1vHdTHzw9EstJ25s4Ph6\n",
       "Wg7jwdNVdbGqnunK3wWeYymsDwIzXbMZloIe4B7gWFVdrqp54Dywf5AOS5JenTWtqSe5A3gr8AVg\n",
       "qqoWu12LwFRX3gEs9By2wNI/ApKkEds0aMNu6eX3gA9U1V8lL38DqKpa+tpzXdfYd7SnPN29JEnL\n",
       "kkyzxnAcKNST/ABLgf7Jqnqiq15Msq2qLibZDlzq6i8Au3sO39XVrXB0Lf2UpA2nqmaB2eXtJA/3\n",
       "O2aQq18CfBSYq6qP9Ow6ARzqyoeAJ3rqH0iyOcke4E7g9AD9lyS9SoNc/fJTwB8DX+HlZZQjLAX1\n",
       "ceCHgHngvqr6dnfMh4BfAq6wtFzz2RXv2fwZasd3M/Hql5daTtzYwPH1tBzg6pe+oT4KG+F/eMd3\n",
       "MzHUX2o5cWMDx9fTchiXNEqSJoehLkkNMdQlqSGGuiQ1xFCXpIYY6pLUEENdkhpiqEtSQwx1SWqI\n",
       "oS5JDTHUJakhhrokNcRQl6SGGOqS1BBDXZIaYqhLUkMMdUlqiKEuSQ0Z5MHTH0uymOSrPXVbk5xK\n",
       "8nySk0m29Ow7kuRckrNJDoyq45KkVxpkpv5x4O4VdYeBU1W1F3iq2ybJPuB+YF93zKNJ/DYgSeuk\n",
       "b+BW1Z8A31pRfRCY6cozwL1d+R7gWFVdrqp54DywfzhdlST1c6Oz6KmqWuzKi8BUV94BLPS0WwB2\n",
       "3uBnSJLW6FUvjVRVAbVak1f7GZKkwWy6weMWk2yrqotJtgOXuvoLwO6edru6ums42lOe7l6SpGVJ\n",
       "plljOGZpot33je8APlNVP9ZtPwJ8o6o+nOQwsKWqDncnSh9jaR19J/Ak8MO14kOS1ORN4ENVZaCW\n",
       "ju8mM/jYoO3xTd7YwPH1tEyqX9u+M/Ukx4B3AW9K8gLwa8BvAseTPAjMA/cBVNVckuPAHHAFeGhl\n",
       "oEuSRmegmfrQP3QD/Gvq+G4mztRfajlxYwPH19NygJm615BLUkMMdUlqiKEuSQ0x1CWpIYa6JDXE\n",
       "UJekhhjqktQQQ12SGmKoS1JDDHVJaoihLkkNMdQlqSGGuiQ1xFCXpIYY6pLUEENdkhpiqEtSQwx1\n",
       "SWqIoS5JDRlJqCe5O8nZJOeSfHAUnyFJeqWhh3qSW4H/ANwN7AN+Psmbh/05kqRXGsVMfT9wvqrm\n",
       "q+oy8LvAPSP4HEnSCqMI9Z3ACz3bC12dJGnERhHqNYL3lCQNYNMI3vMCsLtnezdLs/UVMoKPHq0k\n",
       "a/gHy/HdTNY2Nmh7fJM1NnB8a3qvquFOrJNsAv4c+KfAXwKngZ+vqueG+kGSpFcY+ky9qq4k+RXg\n",
       "s8CtwEcNdElaH0OfqUuSxmfd7yht+cakJB9Lspjkq+Puy7Al2Z3k80meTfJnSd4/7j4NU5LXJPlC\n",
       "kmeSzCX5jXH3aRSS3JrkTJLPjLsvw5ZkPslXuvGdHnd/hinJliSPJ3mu+/v5D6/bdj1n6t2NSX8O\n",
       "3MXSCdUv0tB6e5KfBr4LfKKqfmzc/RmmJNuAbVX1TJLXAV8C7m3l/zuAJLdV1fe680J/CvzrqvrT\n",
       "cfdrmJL8K+DtwOur6uC4+zNMSf4X8Paq+ua4+zJsSWaA/1ZVH+v+ft5eVd+5Vtv1nqk3fWNSVf0J\n",
       "8K1x92MUqupiVT3Tlb8LPAfsGG+vhquqvtcVN7N0PqipcEiyC3gP8DtM4iUig2luXEneAPx0VX0M\n",
       "ls5bXi/QYf1D3RuTGpDkDuCtwBfG25PhSnJLkmeAReDzVTU37j4N2W8BvwpcHXdHRqSAJ5M8neSX\n",
       "x92ZIdoDvJjk40m+nOS3k9x2vcbrHeqelZ1w3dLL48AHuhl7M6rqalW9BdgF/OMk02Pu0tAk+Tng\n",
       "UlWdocHZbOedVfVW4GeBf9Eth7ZgE/A24NGqehvw18Dh6zVe71Af8MYk3YyS/ADwe8B/qqonxt2f\n",
       "Uem+2v4+8BPj7ssQ/SRwsFt3Pgb8kySfGHOfhqqqvtb9+SLwaZaWe1uwACxU1Re77cdZCvlrWu9Q\n",
       "fxq4M8kdSTYD9wMn1rkPugFJAnwUmKuqj4y7P8OW5E1JtnTl1wI/A5wZb6+Gp6o+VFW7q2oP8ADw\n",
       "uar65+Pu17AkuS3J67vy7cABoImr0KrqIvBCkr1d1V3As9drP4qfCbiu1m9MSnIMeBfwt5O8APxa\n",
       "VX18zN0alncCvwB8Jcly2B2pqj8aY5+GaTswk+QWliY7n6yqp8bcp1FqbSl0Cvj00tyDTcCnqurk\n",
       "eLs0VO8DPtVNhv8CeO/1GnrzkSQ1xMfZSVJDDHVJaoihLkkNMdQlqSGGuiQ1xFCXpIYY6pLUEENd\n",
       "khry/wE2oLoOw7T5WwAAAABJRU5ErkJggg==\n"
      ],
      "text/plain": [
       "<matplotlib.figure.Figure at 0x10a140cf8>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "plt.bar(range(6), star_wars[star_wars.columns[3:9]].sum())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# View counts\n",
    "\n",
    "It appears that the original movies were seen by more respondents than the newer movies.  This reinforces what we saw in the rankings, where the earlier movies seem to be more popular."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 98,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "males = star_wars[star_wars[\"Gender\"] == \"Male\"]\n",
    "females = star_wars[star_wars[\"Gender\"] == \"Female\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 99,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "image/png": [
       "iVBORw0KGgoAAAANSUhEUgAAAXIAAAEACAYAAACuzv3DAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\n",
       "AAALEgAACxIB0t1+/AAAEbdJREFUeJzt3X+s3XV9x/HnixaCv5uNpCqtwQRIRmJmZcEGdFwXXaBx\n",
       "3f4gERMl4Y9JyJiEReMkOPqXZomJBn9gM4XUH4EYiASzbswpbeSfTuW2KC0LLJi0bhRjhQyqCQ3v\n",
       "/XG/ZYfDveecS7+np5/T5yM58fs9533OeX+85XU/93PP935SVUiS2nXGrBuQJJ0Yg1ySGmeQS1Lj\n",
       "DHJJapxBLkmNM8glqXETBXmSNUkWk3x/mccWkjzbPb6Y5Jb+25QkrWTthHU3AvuBN6zw+O6q2tpP\n",
       "S5Kk1Rg7I0+yAdgCfB3ISmV9NiVJmtwkSytfAD4JvLjC4wVcmmRfkp1JLuqtO0nSWCODPMkHgaer\n",
       "apGVZ90PAxur6o+BLwH39duiJGmUjPpbK0k+C3wUOAacDbwRuLeqrhnxnCeBi6vqyND9/lEXSXoV\n",
       "qmrk8vXIIH9ZYXI58Imq+ouh+9ezNGuvJJcA362q85Z5fo1rpmVJtlXVtln3MS3zPL55Hhs4vtZN\n",
       "kp2TfmrluOpe+DqAqtoOXAVcn+QYcBS4+lX0Kkl6lSYO8qraDezujrcP3P8V4Cv9tyZJmoRXdvZn\n",
       "16wbmLJds25ginbNuoEp2zXrBqZs16wbmLWJ18hP+I3mfI1ckqZhkux0Ri5JjTPIJalxBrkkNc4g\n",
       "l6TGGeSS1LjVXhCk01SLf2LBT0npdGGQaxVaynIzXKcPg7wnzlglzYpB3quWstwMl+aFv+yUpMYZ\n",
       "5JLUOINckhpnkEtS4wxySWrcREGeZE2SxSTfX+Hx25I8nmRfkk39tihJGmXSGfmNwH6W+Xxdki3A\n",
       "+VV1AfAx4Pb+2pMkjTM2yJNsALYAX2f5Dx9vBXYAVNUeYF23IbMk6SSY5IKgLwCfBN64wuPnAgcH\n",
       "zg8BG4DDw4Ve/ShJ/RsZ5Ek+CDxdVYtJFkaVDp2vENi3DhwvdLdTmRku6eTqsnZhVc8ZtWdnks8C\n",
       "HwWOAWezNCu/t6quGaj5GrCrqu7uzh8DLq+qw0OvVW1dwg6QiWfk7Y1v8rHB/I9POlWd8J6dVXVz\n",
       "VW2sqrcDVwM/Ggzxzv3ANd0bbgaeGQ5xSdL0rPaPZhVAkusAqmp7Ve1MsiXJE8DzwLU99yhJGmHk\n",
       "0kqvb9Tcj+bg0spA9ZyPTzpVnfDSiiTp1GeQS1LjDHJJapxBLkmNM8glqXEGuSQ1ziCXpMYZ5JLU\n",
       "OINckhpnkEtS4wxySWqcQS5JjTPIJalxBrkkNc4gl6TGGeSS1LixQZ7k7CR7kuxNsj/J55apWUjy\n",
       "bJLF7nbLdNqVJA0bu9VbVf0+yfuq6miStcBDSd5TVQ8Nle6uqq3TaVOStJKJllaq6mh3eBawBjiy\n",
       "TJnbaknSDEwU5EnOSLIXOAw8WFX7h0oKuDTJviQ7k1zUd6OSpOWNXVoBqKoXgXcmeRPwQJKFqto1\n",
       "UPIwsLFbfrkSuA+48JWvtG3geKG7SZKOS7LAKsMxVavbGT3JZ4DfVdXnR9Q8CVxcVUcG7mtsF3ZY\n",
       "zU7s7Y1vdbvMz/v4pFNVkhr3b3mST62ck2Rdd/wa4APA4lDN+iTpji9h6RvEcuvokqSeTbK08hZg\n",
       "R5IzWAr+b1XVD5NcB1BV24GrgOuTHAOOAldPq2FJ0sutemnlVb9Rcz+ag0srA9VzPj7pVNXL0ook\n",
       "6dRmkEtS4wxySWqcQS5JjTPIJalxBrkkNc4gl6TGGeSS1DiDXJIaZ5BLUuMMcklqnEEuSY0zyCWp\n",
       "cQa5JDXOIJekxhnkktS4kUGe5Owke5LsTbI/yedWqLstyeNJ9iXZNJ1WJUnLGbnVW1X9Psn7qupo\n",
       "krXAQ0neU1UPHa9JsgU4v6ouSPJu4HZg83TbliQdN3ZppaqOdodnAWuA4U2VtwI7uto9wLok6/ts\n",
       "UpK0srFBnuSMJHuBw8CDVbV/qORc4ODA+SFgQ38tSpJGGbm0AlBVLwLvTPIm4IEkC1W1a6hseGPQ\n",
       "FXbp3TZwvNDdpNla2li6PW4uvWTevn5JFlhlOKZq8v8PknwG+F1VfX7gvq8Bu6rq7u78MeDyqjo8\n",
       "9NzGdmGH1ezE3t74VrfL/DyPr72xwWq/fvNs3r9+SWpc7bhPrZyTZF13/BrgA8DiUNn9wDVdzWbg\n",
       "meEQlyRNz7illbcAO5KcwVLof6uqfpjkOoCq2l5VO5NsSfIE8Dxw7XRbliQNWtXSygm90Wnw409b\n",
       "43Np5aXK5sYGLq38v3n/+p3w0ook6dRnkEtS4wxySWqcQS5JjTPIJalxBrkkNc4gl6TGGeSS1DiD\n",
       "XJIaZ5BLUuMMcklqnEEuSY0zyCWpcQa5JDXOIJekxk2y+fLGJA8meTTJL5J8fJmahSTPJlnsbrdM\n",
       "p11J0rCxmy8DLwA3VdXeJK8HfpbkB1V1YKhud1Vt7b9FSdIoY2fkVfVUVe3tjp8DDgBvXabU3Uok\n",
       "aQZWtUae5DxgE7Bn6KECLk2yL8nOJBf1054kaZxJllYA6JZV7gFu7Gbmgx4GNlbV0SRXAvcBF/bX\n",
       "piRpJRMFeZIzgXuBb1fVfcOPV9X/Dhz/S5KvJvmDqjry8sptA8cL3U2SdFySBVYZjqkavft0kgA7\n",
       "gN9U1U0r1KwHnq6qSnIJ8N2qOm+oZu53um5rfKvbhX2ex9fe2GC1X795Nu9fvyQ1rnaSGfllwEeA\n",
       "R5IsdvfdDLwNoKq2A1cB1yc5BhwFrp6kQUnTtxR07fEb1eTGzsh7e6PT4LtmW+NzRv5SZXNjA8c3\n",
       "UHkajG9crVd2SlLjDHJJapxBLkmNM8glqXEGuSQ1ziCXpMYZ5JLUOINckhpnkEtS4wxySWqcQS5J\n",
       "jTPIJalxBrkkNc4gl6TGGeSS1DiDXJIaNzbIk2xM8mCSR5P8IsnHV6i7LcnjSfYl2dR/q5Kk5Uyy\n",
       "1dsLwE1VtTfJ64GfJflBVR04XpBkC3B+VV2Q5N3A7cDm6bQsSRo0dkZeVU9V1d7u+DngAPDWobKt\n",
       "LG3QTFXtAdZ1GzJLkqZsVWvkSc4DNgF7hh46Fzg4cH4I2HAijUmSJjNxkHfLKvcAN3Yz81eUDJ23\n",
       "thuqJDVpkjVykpwJ3At8u6ruW6bkV8DGgfMN3X1Dtg0cL3Q3SdJxSRZYZTimavTEOUlYWv/+TVXd\n",
       "tELNFuCGqtqSZDPwxaraPFRT7U3SQ1UN/6SxfGVz45t8bDDf42tvbOD4BipPg/GNq51kRn4Z8BHg\n",
       "kSSL3X03A28DqKrtVbUzyZYkTwDPA9dO0qAk6cSNnZH39kanwXfNtsbnjPylyubGBo5voPI0GN+4\n",
       "Wq/slKTGGeSS1DiDXJIaZ5BLUuMMcklqnEEuSY0zyCWpcQa5JDXOIJekxhnkktQ4g1ySGmeQS1Lj\n",
       "DHJJapxBLkmNM8glqXEGuSQ1bmyQJ7kjyeEkP1/h8YUkzyZZ7G639N+mJGklk2z1difwJeCbI2p2\n",
       "V9XWflqSJK3G2Bl5Vf0Y+O2Ysom3DJMk9auPNfICLk2yL8nOJBf18JqSpAlNsrQyzsPAxqo6muRK\n",
       "4D7gwuVLtw0cL3Q3SdJxSRZYZTimavzu00nOA75fVe+YoPZJ4OKqOjJ0/9zvdN3W+CYfG8z3+Nob\n",
       "Gzi+gcrTYHzjak94aSXJ+iTpji9h6ZvDkTFPkyT1ZOzSSpK7gMuBc5IcBG4FzgSoqu3AVcD1SY4B\n",
       "R4Grp9euJGnYREsrvbzRafDjT1vjc2nlpcrmxgaOb6DyNBjf1JdWJEmzZZBLUuMMcklqnEEuSY0z\n",
       "yCWpcQa5JDXOIJekxhnkktQ4g1ySGmeQS1LjDHJJapxBLkmNM8glqXEGuSQ1ziCXpMYZ5JLUuLFB\n",
       "nuSOJIeT/HxEzW1JHk+yL8mmfluUJI0yyYz8TuCKlR5MsgU4v6ouAD4G3N5Tb5KkCYwN8qr6MfDb\n",
       "ESVbgR1d7R5gXZL1/bQnSRqnjzXyc4GDA+eHgA09vK4kaQJre3qd4Y1BV9gJddvA8UJ3kyQdl2SB\n",
       "VYZjH0H+K2DjwPmG7r5lbOvh7SRpflXVLmDX8fMkt457Th9LK/cD13RvuBl4pqoO9/C6kqQJjJ2R\n",
       "J7kLuBw4J8lB4FbgTICq2l5VO5NsSfIE8Dxw7TQbliS9XKpWWM7u+42SWnHp/JQVqmp4/X/5yubG\n",
       "N/nYYL7H197YwPENVJ4G4xtX65WdktQ4g1ySGmeQS1LjDHJJapxBLkmNM8glqXEGuSQ1ziCXpMYZ\n",
       "5JLUOINckhpnkEtS4wxySWqcQS5JjTPIJalxBrkkNc4gl6TGTRTkSa5I8liSx5N8apnHF5I8m2Sx\n",
       "u93Sf6uSpOVMstXbGuDLwPtZ2lT5J0nur6oDQ6W7q2rrFHqUJI0wyYz8EuCJqvplVb0A3A385TJ1\n",
       "E28bJknqzyRBfi5wcOD8UHffoAIuTbIvyc4kF/XVoCRptLFLK0y2q+nDwMaqOprkSuA+4MJXlm0b\n",
       "OF7obpKk45IssMpwTNXonE6yGdhWVVd0558GXqyqfxzxnCeBi6vqyMB9c7/TdVvjm3xsMN/ja29s\n",
       "4PgGKk+D8Y2rnWRp5afABUnOS3IW8CHg/qE3Wp8k3fElLH2DOPLKl5Ik9W3s0kpVHUtyA/AAsAb4\n",
       "RlUdSHJd9/h24Crg+iTHgKPA1VPsWZI0YOzSSm9vdBr8+NPW+FxaeamyubGB4xuoPA3G18fSiiTp\n",
       "FGaQS1LjDHJJapxBLkmNM8glqXEGuSQ1ziCXpMYZ5JLUOINckhpnkEtS4wxySWqcQS5JjTPIJalx\n",
       "BrkkNc4gl6TGjQ3yJFckeSzJ40k+tULNbd3j+5Js6r9NSdJKRgZ5kjXAl4ErgIuADyf5o6GaLcD5\n",
       "VXUB8DHg9in1KklaxrgZ+SXAE1X1y6p6Abgb+Muhmq3ADoCq2gOsS7K+904lScsaF+TnAgcHzg91\n",
       "942r2XDirUmSJjEuyCfdCG94P7nWNtCTpGatHfP4r4CNA+cbWZpxj6rZ0N23jIn3+j1lLG3sOnH1\n",
       "9BqZgtWNDeZ7fG2NDRzfUPX0GpmS1f/3t7JxQf5T4IIk5wH/DXwI+PBQzf3ADcDdSTYDz1TV4eEX\n",
       "Ws2O7ZKkyY0M8qo6luQG4AFgDfCNqjqQ5Lru8e1VtTPJliRPAM8D1069a0nSS1LlcrYkteykXNk5\n",
       "yUVFrUpyR5LDSX4+6176lmRjkgeTPJrkF0k+Puue+pTk7CR7kuxNsj/J52bd0zQkWZNkMcn3Z91L\n",
       "35L8Mskj3fj+Y9b99CnJuiT3JDnQ/fvcvGLttGfk3UVF/wm8n6Vfgv4E+HBVHZjqG58kSd4LPAd8\n",
       "s6reMet++pTkzcCbq2pvktcDPwP+al6+dgBJXltVR5OsBR4CPlFVD826rz4l+TvgYuANVbV11v30\n",
       "KcmTwMVVdWTWvfQtyQ5gd1Xd0f37fF1VPbtc7cmYkU9yUVGzqurHwG9n3cc0VNVTVbW3O34OOAC8\n",
       "dbZd9auqjnaHZ7H0e6C5CoQkG4AtwNdp8aMdk5m7cSV5E/DeqroDln5fuVKIw8kJ8kkuKtIprvvk\n",
       "0iZgz2w76VeSM5LsBQ4DD1bV/ln31LMvAJ8EXpx1I1NSwL8n+WmSv551Mz16O/DrJHcmeTjJPyV5\n",
       "7UrFJyPI/W1q47pllXuAG7uZ+dyoqher6p0sXf/wp0kWZtxSb5J8EHi6qhaZw1lr57Kq2gRcCfxN\n",
       "t9Q5D9YC7wK+WlXvYukTgX+/UvHJCPJJLirSKSrJmcC9wLer6r5Z9zMt3Y+t/wz8yax76dGlwNZu\n",
       "Hfku4M+SfHPGPfWqqv6n+99fA99jaSl3HhwCDlXVT7rze1gK9mWdjCB/6aKiJGexdFHR/SfhfXWC\n",
       "kgT4BrC/qr446376luScJOu649cAHwAWZ9tVf6rq5qraWFVvB64GflRV18y6r74keW2SN3THrwP+\n",
       "HJiLT49V1VPAwSQXdne9H3h0pfpxV3b20dCyFxVN+31PliR3AZcDf5jkIPAPVXXnjNvqy2XAR4BH\n",
       "khwPuE9X1b/OsKc+vQXYkeQMliY136qqH864p2mat2XO9cD3luYbrAW+U1X/NtuWevW3wHe6CfB/\n",
       "MeJiSy8IkqTGudWbJDXOIJekxhnkktQ4g1ySGmeQS1LjDHJJapxBLkmNM8glqXH/BzmDIJh+RKL+\n",
       "AAAAAElFTkSuQmCC\n"
      ],
      "text/plain": [
       "<matplotlib.figure.Figure at 0x10a218828>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "image/png": [
       "iVBORw0KGgoAAAANSUhEUgAAAXIAAAEACAYAAACuzv3DAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\n",
       "AAALEgAACxIB0t1+/AAAEctJREFUeJzt3X+s3XV9x/HnixaGv2azkVSlNZgAyUjMRBZsQMd10QUa\n",
       "V/cHiZgoGX9MQuYkLhqnwdG/NEtMNPgDmymm/ojEQGSQdWNOaSP/dCptUakLLJi0bhRjhQyqiQ3v\n",
       "/XG/rYfjvfd8L/2enn7OfT6SE77f832f831/uPC63/O593s/qSokSe06a9YNSJJOjUEuSY0zyCWp\n",
       "cQa5JDXOIJekxhnkktS4XkGeZF2SfUnuW+LYQpKnu+P7ktwyfJuSpOWs71l3M/AI8LJlju+pqm3D\n",
       "tCRJWo2JV+RJNgFbgS8AWa5syKYkSf31mVr5JPBB4LlljhdwRZIDSXYluWSw7iRJE60Y5EneBjxZ\n",
       "VftY/qr7IWBzVf0x8GngnmFblCStJCv9rZUkHwPeDRwHzgV+H7i7qq5f4TWPA5dV1dGx5/2jLpL0\n",
       "AlTVitPXKwb58wqTq4APVNVfjD2/kcWr9kpyOfCNqrpgidfXpGZalmR7VW2fdR/TMs/jm+exgeNr\n",
       "XZ/s7PtbKydU98Y3AlTVDuBa4KYkx4FjwHUvoFdJ0gvUO8irag+wp9veMfL8Z4HPDt+aJKmP1V6R\n",
       "a3m7Z93AlN2a5NZZN7Eaq5jK2z3NPs4Au2fdwJTtnnUDs9Z7jvyUTzTnc+TzbvGH1S39vDqrCXLp\n",
       "jNUnO/1bK5LUOINckhpnkEtS4wxySWqcQS5JjTPIJalxBrkkNc4gl6TGGeSS1DiDXJIaZ5BLUuMM\n",
       "cklqnEEuSY0zyCWpcb2CPMm6JPuS3LfM8duSPJrkQJJLh21RkrSSvlfkNwOPsMQfpE6yFbiwqi4C\n",
       "3gPcPlx7kqRJJgZ5kk3AVuALwFJ/3HwbsBOgqvYCG7oFmSVJp0GfK/JPAh8Enlvm+PnAoZH9w8Cm\n",
       "U+xLktTTimt2Jnkb8GRV7UuysFLp2P6Sa4Il2T6yu7uqdvfoUZLWjC5rF1b1mpXW7EzyMeDdwHHg\n",
       "XOD3gbur6vqRms+zGMp3dvs/Aa6qqiNj7+WanQ1zzU5pNk55zc6q+khVba6q1wDXAd8ZDfHOvcD1\n",
       "3Qm3AE+Nh7gkaXpWnFpZQgEkuRGgqnZU1a4kW5M8BjwL3DBwj01YvGJti1es0nxYcWpl0BPN+dTK\n",
       "vE89zPv4pDPVKU+tSJLOfAa5JDXOIJekxhnkktQ4g1ySGmeQS1LjDHJJapxBLkmNM8glqXEGuSQ1\n",
       "ziCXpMYZ5JLUOINckhpnkEtS4wxySWqcQS5JjZsY5EnOTbI3yf4kjyT5+BI1C0meTrKve9wynXYl\n",
       "SeMmLvVWVb9O8uaqOpZkPfBgkjdW1YNjpXuqatt02pQkLafXmp1VdazbPAdYBxxdosxltdSkFtdb\n",
       "Bddc1W/1miNPclaS/cAR4IGqemSspIArkhxIsivJJUM3Kk1XNfaQfqvvFflzwOuSvBy4P8lCVe0e\n",
       "KXkI2NxNv1wD3ANcPP4+SbaP7O4eew9JWvOSLAALq3pN1eq+uyf5KPCrqvrECjWPA5dV1dGR5yau\n",
       "BN2yeV9lfp7H197YYLVfP7WrT3b2+a2V85Js6LZfBLwV2DdWszFJuu3LWfwGsdQ8uiRpYH2mVl4J\n",
       "7ExyFovB/5Wq+naSGwGqagdwLXBTkuPAMeC6aTUsSXq+VU+tvOATzflvBrT38dyplZOVzY0NnFpZ\n",
       "O/pMrfT6Yedw2vufRZLOdN6iL0mNM8glqXEGuSQ1ziCXpMYZ5JLUOINckhpnkEtS4wxySWqcQS5J\n",
       "jTPIJalxBrkkNc4gl6TGGeSS1DiDXJIaZ5BLUuNW/HvkSc4F9gC/B5wD/HNVfXiJutuAa1hcHeiv\n",
       "qmrfeI0kTcO8L1rTx4pBXlW/TvLmqjqWZD3wYJI3VtWDJ2qSbAUurKqLkrwBuB3YMlSDkjRZa1k+\n",
       "7KI1E6dWqupYt3kOsA4YX1R5G7Czq90LbEiyccgmJUnLmxjkSc5Ksh84AjxQVY+MlZwPHBrZPwxs\n",
       "Gq5FSdJKJq7ZWVXPAa9L8nLg/iQLVbV7rGz8c8Iyn3O2j2wvdA9J0glJFlhlOKaq/9xSko8Cv6qq\n",
       "T4w893lgd1Xd2e3/BLiqqo6MvXauVypvb3yrW4V9nsfX3thgtV+/eTbvX78kNal2xamVJOcl2dBt\n",
       "vwh4KzD+Gyn3Atd3NVuAp8ZDXJI0PZOmVl4J7ExyFouh/5Wq+naSGwGqakdV7UqyNcljwLPADdNt\n",
       "WZI0alVTK6d0ojXw8aet8Tm1crKyubGBUyu/Ne9fv1OeWpEknfkMcklqnEEuSY0zyCWpcQa5JDXO\n",
       "IJekxhnkktQ4g1ySGmeQS1LjDHJJapxBLkmNM8glqXEGuSQ1ziCXpMYZ5JLUuD6LL29O8kCSHyf5\n",
       "UZL3LVGzkOTpJPu6xy3TaVeSNG7i4svAb4D3V9X+JC8FfpDkW1V1cKxuT1VtG75FSadiceGF9rhw\n",
       "Rn8Tg7yqngCe6LafSXIQeBUwHuT+S5fOWK1luXGyGquaI09yAXApsHfsUAFXJDmQZFeSS4ZpT5I0\n",
       "SZ+pFQC6aZW7gJur6pmxww8Bm6vqWJJrgHuAi4drU5K0nF5BnuRs4G7gq1V1z/jxqvq/ke1/TfK5\n",
       "JH9QVUefX7l9ZHuhe0iSTkiywCrDMVUrz50lCbAT+EVVvX+Zmo3Ak1VVSS4HvlFVF4zVzP1K122N\n",
       "b3WrsM/z+NobGzi+kco1ML5JtX2uyK8E3gU8nGRf99xHgFcDVNUO4FrgpiTHgWPAdX0alCSduolX\n",
       "5IOdaA1812xrfF6Rn6xsbmzg+EYq18D4JtV6Z6ckNc4gl6TGGeSS1DiDXJIaZ5BLUuMMcklqnEEu\n",
       "SY0zyCWpcQa5JDXOIJekxhnkktQ4g1ySGmeQS1LjDHJJapxBLkmNM8glqXETgzzJ5iQPJPlxkh8l\n",
       "ed8ydbcleTTJgSSXDt+qJGkpfZZ6+w3w/qran+SlwA+SfKuqDp4oSLIVuLCqLkryBuB2YMt0WpYk\n",
       "jZp4RV5VT1TV/m77GeAg8Kqxsm0sLtBMVe0FNnQLMkuSpmxVc+RJLgAuBfaOHTofODSyfxjYdCqN\n",
       "SZL66R3k3bTKXcDN3ZX575SM7be2GqokNanPHDlJzgbuBr5aVfcsUfIzYPPI/qbuuTHbR7YXuock\n",
       "6YQkC6wyHFO18oVzkrA4//2Lqnr/MjVbgfdW1dYkW4BPVdWWsZpq7yI9VNX4J42lK5sbX/+xwXyP\n",
       "r72xgeMbqVwD45tU2+eK/ErgXcDDSfZ1z30EeDVAVe2oql1JtiZ5DHgWuKFPg5KkUzfxinywE62B\n",
       "75ptjc8r8pOVzY0NHN9I5RoY36Ra7+yUpMYZ5JLUOINckhpnkEtS4wxySWqcQS5JjTPIJalxBrkk\n",
       "Nc4gl6TGGeSS1DiDXJIaZ5BLUuMMcklqnEEuSY0zyCWpcQa5JDVuYpAnuSPJkSQ/XOb4QpKnk+zr\n",
       "HrcM36YkaTl9lnr7EvBp4Msr1Oypqm3DtCRJWo2JV+RV9V3glxPKei8ZJkka1hBz5AVckeRAkl1J\n",
       "LhngPSVJPfWZWpnkIWBzVR1Lcg1wD3Dx0qXbR7YXuock6YQkC6wyHFM1efXpJBcA91XVa3vUPg5c\n",
       "VlVHx56f+5Wu2xpf/7HBfI+vvbGB4xupXAPjm1R7ylMrSTYmSbd9OYvfHI5OeJkkaSATp1aSfB24\n",
       "CjgvySHgVuBsgKraAVwL3JTkOHAMuG567UqSxvWaWhnkRGvg409b43Nq5WRlc2MDxzdSuQbGN/Wp\n",
       "FUnSbBnkktQ4g1ySGmeQS1LjDHJJapxBLkmNM8glqXEGuSQ1ziCXpMYZ5JLUOINckhpnkEtS4wxy\n",
       "SWqcQS5JjTPIJalxBrkkNW5ikCe5I8mRJD9coea2JI8mOZDk0mFblCStpM8V+ZeAq5c7mGQrcGFV\n",
       "XQS8B7h9oN4kST1MDPKq+i7wyxVKtgE7u9q9wIYkG4dpT5I0yRBz5OcDh0b2DwObBnhfSVIP6wd6\n",
       "n/GFQZdZCXX7yPZC95AknZBkgVWG4xBB/jNg88j+pu65JWwf4HSSNL+qajew+8R+klsnvWaIqZV7\n",
       "geu7E24BnqqqIwO8rySph4lX5Em+DlwFnJfkEHArcDZAVe2oql1JtiZ5DHgWuGGaDUuSni9Vy0xn\n",
       "D32ipJadOj9jhaoan/9furK58fUfG8z3+NobGzi+kco1ML5Jtd7ZKUmNM8glqXEGuSQ1ziCXpMYZ\n",
       "5JLUOINckhpnkEtS4wxySWqcQS5JjTPIJalxBrkkNc4gl6TGGeSS1DiDXJIaZ5BLUuMMcklqXK8g\n",
       "T3J1kp8keTTJh5Y4vpDk6ST7usctw7cqSVpKn6Xe1gGfAd7C4qLK30tyb1UdHCvdU1XbptCjJGkF\n",
       "fa7ILwceq6qfVtVvgDuBty9R13vZMEnScPoE+fnAoZH9w91zowq4IsmBJLuSXDJUg5KklU2cWqHf\n",
       "qqYPAZur6liSa4B7gIt/t2z7yPZC95AknZBkgVWGY6pWzukkW4DtVXV1t/9h4Lmq+scVXvM4cFlV\n",
       "HR15bu5Xum5rfP3HBvM9vvbGBo5vpHINjG9SbZ+ple8DFyW5IMk5wDuAe8dOtDFJuu3LWfwGcfR3\n",
       "30qSNLSJUytVdTzJe4H7gXXAF6vqYJIbu+M7gGuBm5IcB44B102xZ0nSiIlTK4OdaA18/GlrfE6t\n",
       "nKxsbmzg+EYq18D4hphakSSdwQxySWqcQS5JjTPIJalxBrkkNc4gl6TGGeSS1DiDXJIaZ5BLUuMM\n",
       "cklqnEEuSY0zyCWpcQa5JDXOIJekxhnkktS4iUGe5OokP0nyaJIPLVNzW3f8QJJLh29TkrScFYM8\n",
       "yTrgM8DVwCXAO5P80VjNVuDCqroIeA9w+5R6lSQtYdIV+eXAY1X106r6DXAn8Paxmm3AToCq2gts\n",
       "SLJx8E4lSUuaFOTnA4dG9g93z02q2XTqrUmS+pgU5H0XwhtfT661BfQkqVnrJxz/GbB5ZH8zi1fc\n",
       "K9Vs6p5bQu+1fs8Yiwu79q6eXiNTsLqxwXyPr62xgeMbq55eI1Oy+v//ljcpyL8PXJTkAuB/gHcA\n",
       "7xyruRd4L3Bnki3AU1V1ZPyNVrNiuySpvxWDvKqOJ3kvcD+wDvhiVR1McmN3fEdV7UqyNcljwLPA\n",
       "DVPvWpJ0Uqqczpaklp2WOzv73FTUqiR3JDmS5Iez7mVoSTYneSDJj5P8KMn7Zt3TkJKcm2Rvkv1J\n",
       "Hkny8Vn3NA1J1iXZl+S+WfcytCQ/TfJwN77/nHU/Q0qyIcldSQ52/31uWbZ22lfk3U1F/wW8hcUf\n",
       "gn4PeGdVHZzqiU+TJG8CngG+XFWvnXU/Q0ryCuAVVbU/yUuBHwB/OS9fO4AkL66qY0nWAw8CH6iq\n",
       "B2fd15CS/B1wGfCyqto2636GlORx4LKqOjrrXoaWZCewp6ru6P77fElVPb1U7em4Iu9zU1Gzquq7\n",
       "wC9n3cc0VNUTVbW/234GOAi8arZdDauqjnWb57D4c6C5CoQkm4CtwBdo8Vc7+pm7cSV5OfCmqroD\n",
       "Fn9euVyIw+kJ8j43FekM1/3m0qXA3tl2MqwkZyXZDxwBHqiqR2bd08A+CXwQeG7WjUxJAf+R5PtJ\n",
       "/nrWzQzoNcDPk3wpyUNJ/inJi5crPh1B7k9TG9dNq9wF3Nxdmc+Nqnquql7H4v0Pf5pkYcYtDSbJ\n",
       "24Anq2ofc3jV2rmyqi4FrgH+ppvqnAfrgdcDn6uq17P4G4F/v1zx6QjyPjcV6QyV5GzgbuCrVXXP\n",
       "rPuZlu5j678AfzLrXgZ0BbCtm0f+OvBnSb48454GVVX/2/3z58A3WZzKnQeHgcNV9b1u/y4Wg31J\n",
       "pyPIT95UlOQcFm8quvc0nFenKEmALwKPVNWnZt3P0JKcl2RDt/0i4K3Avtl2NZyq+khVba6q1wDX\n",
       "Ad+pqutn3ddQkrw4ycu67ZcAfw7MxW+PVdUTwKEkF3dPvQX48XL1k+7sHKKhJW8qmvZ5T5ckXweu\n",
       "Av4wySHgH6rqSzNuayhXAu8CHk5yIuA+XFX/NsOehvRKYGeSs1i8qPlKVX17xj1N07xNc24Evrl4\n",
       "vcF64GtV9e+zbWlQfwt8rbsA/m9WuNnSG4IkqXEu9SZJjTPIJalxBrkkNc4gl6TGGeSS1DiDXJIa\n",
       "Z5BLUuMMcklq3P8DnlhfH3IJKQcAAAAASUVORK5CYII=\n"
      ],
      "text/plain": [
       "<matplotlib.figure.Figure at 0x10a3b6c50>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "plt.bar(range(6), males[males.columns[9:15]].mean())\n",
    "plt.show()\n",
    "\n",
    "plt.bar(range(6), females[females.columns[9:15]].mean())\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "image/png": [
       "iVBORw0KGgoAAAANSUhEUgAAAXUAAAEACAYAAABMEua6AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\n",
       "AAALEgAACxIB0t1+/AAAEn1JREFUeJzt3W+MXFd9xvHvkxgr/GvdNJXt2G6x1ESqpVYJtFbFn2Zp\n",
       "IQqoTcIbEirUiEYVUlpAVKDavGi2IEGLROBFFV40CTIpuLVAiRKhljhpTOFFE6A2hGzcJBWWsile\n",
       "0zbQphGS3fz6Yu/G0/WuZ3Z3xrNz/P1II5977rlzz7HXz545c+9MqgpJUhsuGHcHJEnDY6hLUkMM\n",
       "dUlqiKEuSQ0x1CWpIYa6JDVkoFBPcmGSw0nu77YvTnIwyZNJHkiyqaft3iRPJTma5OpRdVySdKZB\n",
       "Z+ofAGaAhYva9wAHq+py4KFumyS7gBuAXcA1wO1JfDUgSedI38BNsh14O3AHkK76WmBfV94HXN+V\n",
       "rwP2V9XJqjoGPA3sHmaHJUnLG2QW/Wngw8CLPXWbq2quK88Bm7vypcBsT7tZYNtaOylJGsxZQz3J\n",
       "bwMnquowp2fp/0/Nf87A2T5rwM8hkKRzZEOf/a8Hrk3yduAi4KeS3A3MJdlSVceTbAVOdO2fBXb0\n",
       "HL+9q/t/khj0krQKVbXkBHtBBv1AryRXAR+qqt9J8kngP6rqL5LsATZV1Z7ujdIvMr+Ovg14EPjF\n",
       "WnSSJNWvY5MsyXRVTY+7H6Pi+CZXy2OD82J8fbOz30x9sYVw/nPgQJKbgWPAOwGqaibJAeavlDkF\n",
       "3LI40CVJozNwqFfV14CvdeX/BN6yTLuPAx8fSu8kSSuy0pm6BnNo3B0YsUPj7sCIHRp3B0bo1iS3\n",
       "jrsTK7WC5dpDo+zHJBh4TX2oJ218TV1ar+YvUpi0FdGsJNSbNkh2erenJDXE5RdJzZjUy6WH+UrE\n",
       "UJfUmEnL9eGuLLn8IkkNMdQlqSGGuiQ1xFCXpIYY6pLUEENdkhpiqEtSQwx1SWqIoS5JDTHUJakh\n",
       "hrokNcRQl6SGjO0DvSbx09T8TGdJ690YP6Vx0jLdPJe0/p11+SXJRUkeSXIkyUyST3T100lmkxzu\n",
       "Hm/rOWZvkqeSHE1y9agHIEk67awz9ar6SZI3V9ULSTYA30jyRuan2bdV1W297ZPsAm4AdgHbgAeT\n",
       "XF5VL46o/5KkHn3fKK2qF7riRuBC4Llue6n1iOuA/VV1sqqOAU8Du4fQT0nSAPqGepILkhwB5oCH\n",
       "q+rxbtf7knwnyZ1JNnV1lwKzPYfPMj9jlySdA4PM1F+sqiuA7cBvJJkCPgvsBK4AfgB86mxPMYR+\n",
       "SpIGMPDVL1X14yRfAX61qg4t1Ce5A7i/23wW2NFz2PaubgnTPeWp7iFJWtBNoqdWdEzV8hPpJJcA\n",
       "p6rqR0leDnwV+DPg8ao63rX5IPBrVfW73RulX2R+HX0b8CDwi7XoJPPXqE/aBD5ep66J1/r/vfNh\n",
       "fP3a9pupbwX2JbmA+aWau6vqoSSfT3IF83973wfeC1BVM0kOADPAKeCWxYEuSRqds87UR3bSxn+b\n",
       "SutV6//3zofxrXWmLp13/AgLTTJDXVrSJOW6ea7T/JRGSWqIoS5JDTHUJakhhrokNcRQl6SGGOqS\n",
       "1BBDXZIaYqhLUkMMdUlqiHeUjsAk3mYO3moutcBQH5lJy3XzXGqByy+S1BBn6lqxSVxecmlJ5wtD\n",
       "Xas0Sblunuv84fKLJDXEUJekhhjqktSQs4Z6kouSPJLkSJKZJJ/o6i9OcjDJk0keSLKp55i9SZ5K\n",
       "cjTJ1aMegCTptLOGelX9BHhzVV0B/Arw5iRvBPYAB6vqcuChbpsku4AbgF3ANcDtSXw1IEnnSN/A\n",
       "raoXuuJG4ELgOeBaYF9Xvw+4vitfB+yvqpNVdQx4Gtg9zA5LkpbXN9STXJDkCDAHPFxVjwObq2qu\n",
       "azIHbO7KlwKzPYfPAtuG2F9J0ln0vU69ql4Erkjy08BXk7x50f7qczPKMvume8pT3UOStCDJFCsM\n",
       "x4FvPqqqHyf5CvA6YC7Jlqo6nmQrcKJr9iywo+ew7V3dEqZX0k9JOu9U1SHg0MJ2klv7HdPv6pdL\n",
       "Fq5sSfJy4K3AYeA+4Kau2U3AvV35PuDGJBuT7AQuAx5d0SgkSavWb6a+FdjXXcFyAXB3VT2U5DBw\n",
       "IMnNwDHgnQBVNZPkADADnAJuqapJup9ckiZaxpG582vwk5b1GfhDoRzfejP42KDt8U3e2MDx9bRM\n",
       "ql9bryGXpIYY6pLUEENdkhpiqEtSQwx1SWqIoS5JDTHUJakhhrokNcRQl6SGGOqS1BBDXZIaYqhL\n",
       "UkMMdUlqiKEuSQ0x1CWpIYa6JDXEUJekhhjqktQQQ12SGtI31JPsSPJwkseTfC/J+7v66SSzSQ53\n",
       "j7f1HLM3yVNJjia5epQDkCSdtmGANieBD1bVkSSvAr6d5CDz3+56W1Xd1ts4yS7gBmAXsA14MMnl\n",
       "VfXikPsuSVqk70y9qo5X1ZGu/DzwBPNhDbDUt1pfB+yvqpNVdQx4Gtg9nO5Kks5mRWvqSV4DXAn8\n",
       "U1f1viTfSXJnkk1d3aXAbM9hs5z+JSBJGqFBll8A6JZevgR8oKqeT/JZ4KPd7o8BnwJuXubwOrNq\n",
       "uqc81T0kSQuSTLHCcBwo1JO8DPgy8NdVdS9AVZ3o2X8HcH+3+Sywo+fw7V3dItMr6acknXeq6hBw\n",
       "aGE7ya39jhnk6pcAdwIzVfWZnvqtPc3eATzWle8DbkyyMclO4DLg0QH6L0lao0Fm6m8A3g18N8nh\n",
       "ru4jwLuSXMH80sr3gfcCVNVMkgPADHAKuKWqllh+kSQNW8aRt0lqyWX2dS1U1VJX+5zZ0vGtM4OP\n",
       "Ddoe3+SNDRxfT8uk+rX1jlJJaoihLkkNMdQlqSGGuiQ1xFCXpIYY6pLUEENdkhpiqEtSQwx1SWqI\n",
       "oS5JDTHUJakhhrokNcRQl6SGGOqS1BBDXZIaYqhLUkMMdUlqiKEuSQ0x1CWpIX1DPcmOJA8neTzJ\n",
       "95K8v6u/OMnBJE8meSDJpp5j9iZ5KsnRJFePcgCSpNP6fvF0ki3Alqo6kuRVwLeB64H3AP9eVZ9M\n",
       "8ifAz1TVniS7gC8CvwZsAx4ELq+qF3ues/kvh3V864lfPP1Sy4kbGzi+npbD+OLpqjpeVUe68vPA\n",
       "E8yH9bXAvq7ZPuaDHuA6YH9VnayqY8DTwO5BOixJWpsVrakneQ1wJfAIsLmq5rpdc8DmrnwpMNtz\n",
       "2CzzvwQkSSO2YdCG3dLLl4EPVNV/J6dfAVRVzb/sWdYS+6Z7ylPdQ5K0IMkUKwzHgUI9ycuYD/S7\n",
       "q+rernouyZaqOp5kK3Ciq38W2NFz+PaubpHplfRTks47VXUIOLSwneTWfscMcvVLgDuBmar6TM+u\n",
       "+4CbuvJNwL099Tcm2ZhkJ3AZ8OgA/ZckrdEgV7+8EfhH4LucXkbZy3xQHwB+HjgGvLOqftQd8xHg\n",
       "94FTzC/XfHXRczb/DrXjW0+8+uWllhM3NnB8PS0HuPqlb6iPwvnwF+/41hND/aWWEzc2cHw9LYdx\n",
       "SaMkaXIY6pLUEENdkhpiqEtSQwx1SWqIoS5JDTHUJakhhrokNcRQl6SGGOqS1BBDXZIaYqhLUkMM\n",
       "dUlqiKEuSQ0x1CWpIYa6JDXEUJekhhjqktQQQ12SGtI31JPclWQuyWM9ddNJZpMc7h5v69m3N8lT\n",
       "SY4muXpUHZcknWmQmfrngGsW1RVwW1Vd2T3+DiDJLuAGYFd3zO1JfDUgSedI38Ctqq8Dzy2xa6lv\n",
       "tL4O2F9VJ6vqGPA0sHtNPZQkDWwts+j3JflOkjuTbOrqLgVme9rMAtvWcA5J0gpsWOVxnwU+2pU/\n",
       "BnwKuHmZtrV09XRPeap7SJIWJJliheG4qlCvqhM9J70DuL/bfBbY0dN0e1e3hOnVnFqSzhtVdQg4\n",
       "tLCd5NZ+x6xq+SXJ1p7NdwALV8bcB9yYZGOSncBlwKOrOYckaeX6ztST7AeuAi5J8gxwKzCV5Arm\n",
       "l1a+D7wXoKpmkhwAZoBTwC1VtczyiyRp2DKOzE1Syy61r1uhqpa64ufMlo5vnRl8bND2+CZvbOD4\n",
       "elom1a+t15BLUkMMdUlqiKEuSQ0x1CWpIYa6JDXEUJekhhjqktQQQ12SGmKoS1JDDHVJaoihLkkN\n",
       "MdQlqSGGuiQ1xFCXpIYY6pLUEENdkhpiqEtSQwx1SWqIoS5JDekb6knuSjKX5LGeuouTHEzyZJIH\n",
       "kmzq2bc3yVNJjia5elQdlySdaZCZ+ueAaxbV7QEOVtXlwEPdNkl2ATcAu7pjbk/iqwFJOkf6Bm5V\n",
       "fR14blH1tcC+rrwPuL4rXwfsr6qTVXUMeBrYPZyuSpL6We0senNVzXXlOWBzV74UmO1pNwtsW+U5\n",
       "JEkrtGGtT1BVlaTO1mTp6ume8lT3kCQtSDLFCsNxtaE+l2RLVR1PshU40dU/C+zoabe9q1vC9CpP\n",
       "LUnnh6o6BBxa2E5ya79jVrv8ch9wU1e+Cbi3p/7GJBuT7AQuAx5d5TkkSSvUd6aeZD9wFXBJkmeA\n",
       "PwX+HDiQ5GbgGPBOgKqaSXIAmAFOAbdU1dmWZiRJQ5RxZO78GvykZX2oqgzU0vGtM4OPDdoe3+SN\n",
       "DRxfT8uk+rX1GnJJaoihLkkNMdQlqSGGuiQ1xFCXpIYY6pLUEENdkhpiqEtSQwx1SWqIoS5JDTHU\n",
       "JakhhrokNcRQl6SGGOqS1BBDXZIaYqhLUkMMdUlqiKEuSQ3p+x2lZ5PkGPBfwP8CJ6tqd5KLgb8F\n",
       "foHu+0ur6kdr7KckaQBrnakXMFVVV1bV7q5uD3Cwqi4HHuq2JUnnwDCWXxZ/Ceq1wL6uvA+4fgjn\n",
       "kCQNYBgz9QeTfCvJH3R1m6tqrivPAZvXeA5J0oDWtKYOvKGqfpDk54CDSY727qyqSlJrPIckaUBr\n",
       "CvWq+kH35w+T3APsBuaSbKmq40m2AieWPnq6pzzVPSRJC5JMscJwTNXqJtJJXgFcWFX/neSVwAPA\n",
       "nwFvAf6jqv4iyR5gU1XtWXRsza/cTJJQVYvfP1i6peNbZwYfG7Q9vskbGzi+npZJ9Wu7lpn6ZuCe\n",
       "JAvP84WqeiDJt4ADSW6mu6RxDeeQJK3AqmfqazrpefDb1PGtJ87UX2o5cWMDx9fTcoCZuneUSlJD\n",
       "DHVJaoihLkkNMdQlqSGGuiQ1xFCXpIYY6pLUEENdkhpiqEtSQwx1SWqIoS5JDTHUJakhhrokNcRQ\n",
       "l6SGGOqS1BBDXZIaYqhLUkMMdUlqiKEuSQ0ZSagnuSbJ0SRPJfmTUZxDknSmoYd6kguBvwSuAXYB\n",
       "70ryS8M+jyTpTKOYqe8Gnq6qY1V1Evgb4LoRnEeStMgoQn0b8EzP9mxXJ0kasVGEeo3gOSVJA9gw\n",
       "gud8FtjRs72D+dn6IhnBqUcryQp+YTm+9WRlY4O2xzdZYwPHt6LnqhruxDrJBuBfgN8C/g14FHhX\n",
       "VT0x1BNJks4w9Jl6VZ1K8kfAV4ELgTsNdEk6N4Y+U5ckjc85v6O05RuTktyVZC7JY+Puy7Al2ZHk\n",
       "4SSPJ/lekvePu0/DlOSiJI8kOZJkJsknxt2nUUhyYZLDSe4fd1+GLcmxJN/txvfouPszTEk2JflS\n",
       "kie6n89fX7btuZypdzcm/QvwFubfUP0mDa23J3kT8Dzw+ar65XH3Z5iSbAG2VNWRJK8Cvg1c38q/\n",
       "HUCSV1TVC937Qt8APlRV3xh3v4YpyR8DrwNeXVXXjrs/w5Tk+8Drquo/x92XYUuyD/haVd3V/Xy+\n",
       "sqp+vFTbcz1Tb/rGpKr6OvDcuPsxClV1vKqOdOXngSeAS8fbq+Gqqhe64kbm3w9qKhySbAfeDtzB\n",
       "JF4iMpjmxpXkp4E3VdVdMP++5XKBDuc+1L0xqQFJXgNcCTwy3p4MV5ILkhwB5oCHq2pm3H0ask8D\n",
       "HwZeHHdHRqSAB5N8K8kfjLszQ7QT+GGSzyX55yR/leQVyzU+16Huu7ITrlt6+RLwgW7G3oyqerGq\n",
       "rgC2A7+RZGrMXRqaJL8NnKiqwzQ4m+28oaquBN4G/GG3HNqCDcBrgdur6rXA/wB7lmt8rkN9wBuT\n",
       "tB4leRnwZeCvq+recfdnVLqXtl8BfnXcfRmi1wPXduvO+4HfTPL5MfdpqKrqB92fPwTuYX65twWz\n",
       "wGxVfbPb/hLzIb+kcx3q3wIuS/KaJBuBG4D7znEftApJAtwJzFTVZ8bdn2FLckmSTV355cBbgcPj\n",
       "7dXwVNVHqmpHVe0EbgT+oap+b9z9GpYkr0jy6q78SuBqoImr0KrqOPBMksu7qrcAjy/XfhQfE7Cs\n",
       "1m9MSrIfuAr42STPAH9aVZ8bc7eG5Q3Au4HvJlkIu71V9fdj7NMwbQX2JbmA+cnO3VX10Jj7NEqt\n",
       "LYVuBu6Zn3uwAfhCVT0w3i4N1fuAL3ST4X8F3rNcQ28+kqSG+HV2ktQQQ12SGmKoS1JDDHVJaoih\n",
       "LkkNMdQlqSGGuiQ1xFCXpIb8H+0JIa+WhR/9AAAAAElFTkSuQmCC\n"
      ],
      "text/plain": [
       "<matplotlib.figure.Figure at 0x10a483e80>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "image/png": [
       "iVBORw0KGgoAAAANSUhEUgAAAXUAAAEACAYAAABMEua6AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\n",
       "AAALEgAACxIB0t1+/AAAEmpJREFUeJzt3V2MnFd9x/HvLzEWBGhNmsp2bLdYIpFqqVICxKqgkG2B\n",
       "KCCahJsQKtSIRggpbUCtQNhckAUk3iReLqpw0STIBOLWCiJKhFry0iwlF00ItXnJxiSpsJRN8ZqX\n",
       "QENzYzf/Xuyz8bBee2a9Mx7P8fcjjXyeM+eZ5xx7/duzZ87sk6pCktSGs8bdAUnS8BjqktQQQ12S\n",
       "GmKoS1JDDHVJaoihLkkNGSjUk5ydZG+Su7vjc5Pcm+TxJPckWdfTdmeSJ5LsT3LZqDouSTrWoDP1\n",
       "DwCzwOKm9h3AvVV1IXB/d0ySbcA7gW3A5cBNSfxpQJJOkb6Bm2Qz8DbgZiBd9RXArq68C7iqK18J\n",
       "7K6qw1V1AHgS2D7MDkuSjm+QWfQXgA8Bz/fUra+q+a48D6zvyucDcz3t5oBNq+2kJGkwJwz1JG8H\n",
       "DlXVXo7O0n9LLfyegRP9rgF/D4EknSJr+jz/OuCKJG8DXgz8TpLbgPkkG6rqYJKNwKGu/dPAlp7z\n",
       "N3d1vyWJQS9JJ6Gqlp1gL8qgv9AryaXAB6vqL5J8FvhFVX0myQ5gXVXt6N4ovZ2FdfRNwH3Aq2rJ\n",
       "RZJUv45NsiTTVTU97n6MiuObXC2PDc6I8fXNzn4z9aUWw/nTwJ4k1wEHgKsBqmo2yR4WdsocAa5f\n",
       "GuiSpNEZONSr6tvAt7vyL4E3H6fdJ4FPDqV3kqQVcQ/5aMyMuwMjNjPuDozYzLg7MEIz4+7AiM2M\n",
       "uwPjNvCa+lAv2viauiSNwiDZ6UxdkhpiqEtSQwx1SWqIoS5JDTHUJakhhrokNcRQl6SGGOqS1BBD\n",
       "XZIaYqhLUkMMdUlqiKEuSQ0x1CWpIYa6JDXEUJekhhjqktQQQ12SGnLCUE/y4iQPJdmXZDbJp7r6\n",
       "6SRzSfZ2j7f2nLMzyRNJ9ie5bNQDkCQd1fd2dknOqarnkqwBHgQ+CLwJeLaqPr+k7TbgduASYBNw\n",
       "H3BhVT2/pJ23s5OkFRrK7eyq6rmuuBY4G3hm8fWXaX4lsLuqDlfVAeBJYPvAPZYkrUrfUE9yVpJ9\n",
       "wDzwQFU92j11Q5LvJ7klybqu7nxgruf0ORZm7JJOA0lqEh/j/nubJIPM1J+vqouAzcAbk0wBXwK2\n",
       "AhcBPwU+d6KXGEI/JQ1NTdhDK7Fm0IZV9esk3wReW1Uzi/VJbgbu7g6fBrb0nLa5qztGkumew5ne\n",
       "15QkQTeJnlrROSd6ozTJecCRqvpVkpcA3wI+BjxaVQe7Nn8HXFJVf9nzRul2jr5R+qpachHfKJXG\n",
       "Y2EpY9Jmv8G8WDBIdvabqW8EdiU5i4Wlmtuq6v4kX0lyEQtfHT8B3gdQVbNJ9gCzwBHg+qWBLkka\n",
       "nb5bGkdyUWfq0lg4U59sQ9nSKEmaHIa6JDVk4N0vknS6m9Q97cNcXjLUJTVm0nJ9uG8XuPwiSQ0x\n",
       "1CWpIYa6JDXEUJekhhjqktQQQ12SGmKoS1JDDHVJaoihLkkNMdQlqSGGuiQ1xFCXpIYY6pLUEENd\n",
       "khpiqEtSQ04Y6klenOShJPuSzCb5VFd/bpJ7kzye5J4k63rO2ZnkiST7k1w26gFIko7qe+PpJOdU\n",
       "1XNJ1gAPAh8ErgB+XlWfTfJh4BVVtSPJNuB24BJgE3AfcGFVPb/kNb3xtDQGrd94+kwY36pvPF1V\n",
       "z3XFtcDZwDMshPqurn4XcFVXvhLYXVWHq+oA8CSwfZDOSpJWr2+oJzkryT5gHnigqh4F1lfVfNdk\n",
       "Hljflc8H5npOn2Nhxi5JOgX63qO0Wzq5KMnvAt9K8mdLnq8+N3td9rkk0z2HM1U107+7knTmSDIF\n",
       "TK3knIFvPF1Vv07yTeA1wHySDVV1MMlG4FDX7GlgS89pm7u65V5veiUdlaQzTTfZnVk8TnJjv3P6\n",
       "7X45b3FnS5KXAG8B9gJ3Add2za4F7uzKdwHXJFmbZCtwAfDwcV67Ju3R7y9Tksat30x9I7AryVks\n",
       "fAO4raruT7IX2JPkOuAAcDVAVc0m2QPMAkeA6+u422smLSPdrCPp9Nd3S+NILtr4tiPpdNX6/70z\n",
       "YXyr3tIoSZochrokNcRQl6SGGOqS1BBDXZIaYqhLUkMMdUlqiKEuSQ0x1CWpIYa6JDXEUJekhhjq\n",
       "ktQQQ12SGmKoS1JDDHVJaoihLkkNMdQlqSGGuiQ1xFCXpIb0DfUkW5I8kOTRJD9K8v6ufjrJXJK9\n",
       "3eOtPefsTPJEkv1JLhvlACRJR/W98XSSDcCGqtqX5GXA94CrgKuBZ6vq80vabwNuBy4BNgH3ARdW\n",
       "1fM9bZq+Oax0umr9/96ZML5+bdf0e5GqOggc7Mq/SfIYC2G90JtjXQnsrqrDwIEkTwLbgf8YpNPS\n",
       "uC0Ew2RxwqFFK1pTT/JK4GKOBvQNSb6f5JYk67q684G5ntPmOPpNQJoQNUEP6ai+M/VF3dLLHcAH\n",
       "uhn7l4CPd09/AvgccN1xTl/mK2+6pzzVPSRJi5JMscJwHCjUk7wI+Drw1aq6E6CqDvU8fzNwd3f4\n",
       "NLCl5/TNXd0S0yvppySdcapqBphZPE5yY79zBtn9EuAWYLaqvthTv7Gn2TuAH3blu4BrkqxNshW4\n",
       "AHh4gP5LklZpkJn664F3Az9Isrer+wjwriQXsbC08hPgfQBVNZtkDzALHAGur35bbCRJQ9F3S+NI\n",
       "Ltr4tiNNtsn7+nTL3wstz4Dx9WvrJ0olqSGGuiQ1xFCXpIYMvE9dg5vETySCn0qUWmCoj8yk5bp5\n",
       "LrXA5RdJaoihLkkNMdQlqSGGuiQ1xFCXpIYY6pLUELc0asUmcR++e/B1pjDUdZImKdfNc505XH6R\n",
       "pIYY6pLUEENdkhpiqEtSQwx1SWqIoS5JDekb6km2JHkgyaNJfpTk/V39uUnuTfJ4knuSrOs5Z2eS\n",
       "J5LsT3LZKAcgSTqq742nk2wANlTVviQvA74HXAW8B/h5VX02yYeBV1TVjiTbgNuBS4BNwH3AhVX1\n",
       "fM9rNn9zWMd3OlnZTcNbHt/kjQ0cX0/LYdx4uqoOVtW+rvwb4DEWwvoKYFfXbBcLQQ9wJbC7qg5X\n",
       "1QHgSWD7IB2WJK3OitbUk7wSuBh4CFhfVfPdU/PA+q58PjDXc9ocC98EJEkjNvCvCeiWXr4OfKCq\n",
       "nk2O/gRQVdXn94Es89x0T3mqe0iSFiWZYoXhOFCoJ3kRC4F+W1Xd2VXPJ9lQVQeTbAQOdfVPA1t6\n",
       "Tt/c1S0xvZJ+StIZp6pmgJnF4yQ39jtnkN0vAW4BZqvqiz1P3QVc25WvBe7sqb8mydokW4ELgIcH\n",
       "6L8kaZUG2f3yp8C/Az/g6DLKThaCeg/wB8AB4Oqq+lV3zkeAvwaOsLBc860lr9n8O9SO73Ti7pcX\n",
       "Wk7c2MDx9bQcYPdL31AfhTPhL97xnU4M9RdaTtzYwPH1tBzGlkZJ0uQw1CWpIYa6JDXEUJekhhjq\n",
       "ktQQQ12SGmKoS1JDDHVJaoihLkkNMdQlqSGGuiQ1xFCXpIYY6pLUEENdkhpiqEtSQwx1SWqIoS5J\n",
       "DTHUJakhhrokNaRvqCe5Ncl8kh/21E0nmUuyt3u8tee5nUmeSLI/yWWj6rgk6ViDzNS/DFy+pK6A\n",
       "z1fVxd3jXwCSbAPeCWzrzrkpiT8NSNIp0jdwq+o7wDPLPLXcHa2vBHZX1eGqOgA8CWxfVQ8lSQNb\n",
       "zSz6hiTfT3JLknVd3fnAXE+bOWDTKq4hSVqBNSd53peAj3flTwCfA647Tttavnq6pzzVPSRJi5JM\n",
       "scJwPKlQr6pDPRe9Gbi7O3wa2NLTdHNXt4zpk7m0JJ0xqmoGmFk8TnJjv3NOavklycaew3cAiztj\n",
       "7gKuSbI2yVbgAuDhk7mGJGnl+s7Uk+wGLgXOS/IUcCMwleQiFpZWfgK8D6CqZpPsAWaBI8D1VXWc\n",
       "5RdJ0rBlHJmbpI671H7aClW13I6fY1s6vtPM4GODtsc3eWMDx9fTMql+bd1DLkkNMdQlqSGGuiQ1\n",
       "xFCXpIYY6pLUEENdkhpiqEtSQwx1SWqIoS5JDTHUJakhhrokNcRQl6SGGOqS1BBDXZIaYqhLUkMM\n",
       "dUlqiKEuSQ0x1CWpIYa6JDWkb6gnuTXJfJIf9tSdm+TeJI8nuSfJup7ndiZ5Isn+JJeNquOSpGMN\n",
       "MlP/MnD5krodwL1VdSFwf3dMkm3AO4Ft3Tk3JfGnAUk6RfoGblV9B3hmSfUVwK6uvAu4qitfCeyu\n",
       "qsNVdQB4Etg+nK5Kkvo52Vn0+qqa78rzwPqufD4w19NuDth0kteQJK3QmtW+QFVVkjpRk+Wrp3vK\n",
       "U91DkrQoyRQrDMeTDfX5JBuq6mCSjcChrv5pYEtPu81d3TKmT/LSknRmqKoZYGbxOMmN/c452eWX\n",
       "u4Bru/K1wJ099dckWZtkK3AB8PBJXkOStEJ9Z+pJdgOXAucleQr4KPBpYE+S64ADwNUAVTWbZA8w\n",
       "CxwBrq+qEy3NSJKGKOPI3IU1+EnL+lBVGail4zvNDD42aHt8kzc2cHw9LZPq19Y95JLUEENdkhpi\n",
       "qEtSQwx1SWqIoS5JDTHUJakhhrokNcRQl6SGGOqS1BBDXZIaYqhLUkMMdUlqiKEuSQ0x1CWpIYa6\n",
       "JDXEUJekhhjqktQQQ12SGtL3HqUnkuQA8D/A/wGHq2p7knOBfwb+kO7+pVX1q1X2U5I0gNXO1AuY\n",
       "qqqLq2p7V7cDuLeqLgTu744lSafAMJZflt4E9QpgV1feBVw1hGtIkgYwjJn6fUkeSfLerm59Vc13\n",
       "5Xlg/SqvIUka0KrW1IHXV9VPk/w+cG+S/b1PVlUlqVVeQ5I0oFWFelX9tPvzZ0m+AWwH5pNsqKqD\n",
       "STYCh5Y/e7qnPNU9JEmLkkyxwnBM1clNpJOcA5xdVc8meSlwD/Ax4M3AL6rqM0l2AOuqaseSc2th\n",
       "5WaShKpa+v7B8i0d32lm8LFB2+ObvLGB4+tpmVS/tquZqa8HvpFk8XW+VlX3JHkE2JPkOrotjau4\n",
       "hiRpBU56pr6qi54B300d3+nEmfoLLSdubOD4eloOMFP3E6WS1BBDXZIaYqhLUkMMdUlqiKEuSQ0x\n",
       "1CWpIYa6JDXEUJekhhjqktQQQ12SGmKoS1JDDHVJaoihLkkNMdQlqSGGuiQ1xFCXpIYY6pLUEENd\n",
       "khpiqEtSQ0YS6kkuT7I/yRNJPjyKa0iSjjX0UE9yNvAPwOXANuBdSf5o2NeRJB1rFDP17cCTVXWg\n",
       "qg4D/wRcOYLrSJKWGEWobwKe6jme6+okSSM2ilCvEbymJGkAa0bwmk8DW3qOt7AwW18iI7j0aCVZ\n",
       "wTcsx3c6WdnYoO3xTdbYwPGt6LWqhjuxTrIG+DHwJuC/gYeBd1XVY0O9kCTpGEOfqVfVkSR/C3wL\n",
       "OBu4xUCXpFNj6DN1SdL4nPJPlLb8waQktyaZT/LDcfdl2JJsSfJAkkeT/CjJ+8fdp2FK8uIkDyXZ\n",
       "l2Q2yafG3adRSHJ2kr1J7h53X4YtyYEkP+jG9/C4+zNMSdYluSPJY93X558ct+2pnKl3H0z6MfBm\n",
       "Ft5Q/S4NrbcneQPwG+ArVfXH4+7PMCXZAGyoqn1JXgZ8D7iqlX87gCTnVNVz3ftCDwIfrKoHx92v\n",
       "YUry98BrgJdX1RXj7s8wJfkJ8Jqq+uW4+zJsSXYB366qW7uvz5dW1a+Xa3uqZ+pNfzCpqr4DPDPu\n",
       "foxCVR2sqn1d+TfAY8D54+3VcFXVc11xLQvvBzUVDkk2A28DbmYSt4gMprlxJfld4A1VdSssvG95\n",
       "vECHUx/qfjCpAUleCVwMPDTengxXkrOS7APmgQeqanbcfRqyLwAfAp4fd0dGpID7kjyS5L3j7swQ\n",
       "bQV+luTLSf4zyT8mOed4jU91qPuu7ITrll7uAD7QzdibUVXPV9VFwGbgjUmmxtyloUnyduBQVe2l\n",
       "wdls5/VVdTHwVuBvuuXQFqwBXg3cVFWvBv4X2HG8xqc61Af8YJJOR0leBHwd+GpV3Tnu/oxK96Pt\n",
       "N4HXjrsvQ/Q64Ipu3Xk38OdJvjLmPg1VVf20+/NnwDdYWO5twRwwV1Xf7Y7vYCHkl3WqQ/0R4IIk\n",
       "r0yyFngncNcp7oNOQpIAtwCzVfXFcfdn2JKcl2RdV34J8BZg73h7NTxV9ZGq2lJVW4FrgH+rqr8a\n",
       "d7+GJck5SV7elV8KXAY0sQutqg4CTyW5sKt6M/Do8dqP4tcEHFfrH0xKshu4FPi9JE8BH62qL4+5\n",
       "W8PyeuDdwA+SLIbdzqr61zH2aZg2AruSnMXCZOe2qrp/zH0apdaWQtcD31iYe7AG+FpV3TPeLg3V\n",
       "DcDXusnwfwHvOV5DP3wkSQ3xdnaS1BBDXZIaYqhLUkMMdUlqiKEuSQ0x1CWpIYa6JDXEUJekhvw/\n",
       "lUnc6MP1LyoAAAAASUVORK5CYII=\n"
      ],
      "text/plain": [
       "<matplotlib.figure.Figure at 0x10a669da0>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "plt.bar(range(6), males[males.columns[3:9]].sum())\n",
    "plt.show()\n",
    "\n",
    "plt.bar(range(6), females[females.columns[3:9]].sum())\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Male/Female differences in favorite Star Wars movie and most seen movie\n",
    "\n",
    "Interestingly, more males watches episodes 1-3, but males liked them far less than females did."
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.4.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}