People_on_Air.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## People Etiquettes on Air\n",
    "\n",
    "#### \"It is impossible to overlook the extent to which civilization is built upon a renunciation of instinct,” Sigmund Freud said.\n",
    "\n",
    "There is always a tension between how much we need to follow our instrincts and how much we need to yeild to the social conventions. The people of different age behave differently in Airplane travel. I have been over the plane quiet a few time so far. I have seen people go \"Errrrr !! I see a baby on next seat.\" on plane travels. This made me to search for data to analyse how people behave on airplanes. \n",
    "\n",
    "The quick survey from fivethirthyeight.com will help us to find out the good-natured people on that we meet on flight travels.\n",
    "\n",
    "I have used pandas, numpy and mathplot for this data analysis. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "url = 'https://raw.githubusercontent.com/rajasekarsr/data/master/flying-etiquette-survey/flying-etiquette.csv'\n",
    "flying = pd.read_csv(url)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>RespondentID</th>\n",
       "      <th>How often do you travel by plane?</th>\n",
       "      <th>Do you ever recline your seat when you fly?</th>\n",
       "      <th>How tall are you?</th>\n",
       "      <th>Do you have any children under 18?</th>\n",
       "      <th>In a row of three seats, who should get to use the two arm rests?</th>\n",
       "      <th>In a row of two seats, who should get to use the middle arm rest?</th>\n",
       "      <th>Who should have control over the window shade?</th>\n",
       "      <th>Is itrude to move to an unsold seat on a plane?</th>\n",
       "      <th>Generally speaking, is it rude to say more than a few words tothe stranger sitting next to you on a plane?</th>\n",
       "      <th>...</th>\n",
       "      <th>Is itrude to wake a passenger up if you are trying to walk around?</th>\n",
       "      <th>In general, is itrude to bring a baby on a plane?</th>\n",
       "      <th>In general, is it rude to knowingly bring unruly children on a plane?</th>\n",
       "      <th>Have you ever used personal electronics during take off or landing in violation of a flight attendant's direction?</th>\n",
       "      <th>Have you ever smoked a cigarette in an airplane bathroom when it was against the rules?</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Age</th>\n",
       "      <th>Household Income</th>\n",
       "      <th>Education</th>\n",
       "      <th>Location (Census Region)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3436139758</td>\n",
       "      <td>Once a year or less</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3434278696</td>\n",
       "      <td>Once a year or less</td>\n",
       "      <td>About half the time</td>\n",
       "      <td>6'3\"</td>\n",
       "      <td>Yes</td>\n",
       "      <td>The arm rests should be shared</td>\n",
       "      <td>The arm rests should be shared</td>\n",
       "      <td>Everyone in the row should have some say</td>\n",
       "      <td>No, not rude at all</td>\n",
       "      <td>No, not at all rude</td>\n",
       "      <td>...</td>\n",
       "      <td>No, not at all rude</td>\n",
       "      <td>No, not at all rude</td>\n",
       "      <td>No, not at all rude</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>30-44</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Graduate degree</td>\n",
       "      <td>Pacific</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3434275578</td>\n",
       "      <td>Once a year or less</td>\n",
       "      <td>Usually</td>\n",
       "      <td>5'8\"</td>\n",
       "      <td>No</td>\n",
       "      <td>Whoever puts their arm on the arm rest first</td>\n",
       "      <td>The arm rests should be shared</td>\n",
       "      <td>The person in the window seat should have excl...</td>\n",
       "      <td>No, not rude at all</td>\n",
       "      <td>No, not at all rude</td>\n",
       "      <td>...</td>\n",
       "      <td>Yes, somewhat rude</td>\n",
       "      <td>Yes, somewhat rude</td>\n",
       "      <td>Yes, very rude</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>30-44</td>\n",
       "      <td>$100,000 - $149,999</td>\n",
       "      <td>Bachelor degree</td>\n",
       "      <td>Pacific</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3434268208</td>\n",
       "      <td>Once a year or less</td>\n",
       "      <td>Always</td>\n",
       "      <td>5'11\"</td>\n",
       "      <td>No</td>\n",
       "      <td>The arm rests should be shared</td>\n",
       "      <td>The arm rests should be shared</td>\n",
       "      <td>Everyone in the row should have some say</td>\n",
       "      <td>No, not rude at all</td>\n",
       "      <td>No, not at all rude</td>\n",
       "      <td>...</td>\n",
       "      <td>Yes, somewhat rude</td>\n",
       "      <td>Yes, somewhat rude</td>\n",
       "      <td>Yes, very rude</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>30-44</td>\n",
       "      <td>$0 - $24,999</td>\n",
       "      <td>Bachelor degree</td>\n",
       "      <td>Pacific</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3434250245</td>\n",
       "      <td>Once a month or less</td>\n",
       "      <td>About half the time</td>\n",
       "      <td>5'7\"</td>\n",
       "      <td>No</td>\n",
       "      <td>The person in the middle seat gets both arm rests</td>\n",
       "      <td>The person in aisle</td>\n",
       "      <td>Everyone in the row should have some say</td>\n",
       "      <td>No, not rude at all</td>\n",
       "      <td>No, not at all rude</td>\n",
       "      <td>...</td>\n",
       "      <td>Yes, somewhat rude</td>\n",
       "      <td>Yes, somewhat rude</td>\n",
       "      <td>Yes, very rude</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>30-44</td>\n",
       "      <td>$50,000 - $99,999</td>\n",
       "      <td>Bachelor degree</td>\n",
       "      <td>Pacific</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   RespondentID How often do you travel by plane?  \\\n",
       "0    3436139758               Once a year or less   \n",
       "1    3434278696               Once a year or less   \n",
       "2    3434275578               Once a year or less   \n",
       "3    3434268208               Once a year or less   \n",
       "4    3434250245              Once a month or less   \n",
       "\n",
       "  Do you ever recline your seat when you fly? How tall are you?  \\\n",
       "0                                         NaN               NaN   \n",
       "1                         About half the time              6'3\"   \n",
       "2                                     Usually              5'8\"   \n",
       "3                                      Always             5'11\"   \n",
       "4                         About half the time              5'7\"   \n",
       "\n",
       "  Do you have any children under 18?  \\\n",
       "0                                NaN   \n",
       "1                                Yes   \n",
       "2                                 No   \n",
       "3                                 No   \n",
       "4                                 No   \n",
       "\n",
       "  In a row of three seats, who should get to use the two arm rests?  \\\n",
       "0                                                NaN                  \n",
       "1                     The arm rests should be shared                  \n",
       "2       Whoever puts their arm on the arm rest first                  \n",
       "3                     The arm rests should be shared                  \n",
       "4  The person in the middle seat gets both arm rests                  \n",
       "\n",
       "  In a row of two seats, who should get to use the middle arm rest?  \\\n",
       "0                                                NaN                  \n",
       "1                     The arm rests should be shared                  \n",
       "2                     The arm rests should be shared                  \n",
       "3                     The arm rests should be shared                  \n",
       "4                                The person in aisle                  \n",
       "\n",
       "      Who should have control over the window shade?  \\\n",
       "0                                                NaN   \n",
       "1           Everyone in the row should have some say   \n",
       "2  The person in the window seat should have excl...   \n",
       "3           Everyone in the row should have some say   \n",
       "4           Everyone in the row should have some say   \n",
       "\n",
       "  Is itrude to move to an unsold seat on a plane?  \\\n",
       "0                                             NaN   \n",
       "1                             No, not rude at all   \n",
       "2                             No, not rude at all   \n",
       "3                             No, not rude at all   \n",
       "4                             No, not rude at all   \n",
       "\n",
       "  Generally speaking, is it rude to say more than a few words tothe stranger sitting next to you on a plane?  \\\n",
       "0                                                NaN                                                           \n",
       "1                                No, not at all rude                                                           \n",
       "2                                No, not at all rude                                                           \n",
       "3                                No, not at all rude                                                           \n",
       "4                                No, not at all rude                                                           \n",
       "\n",
       "            ...             \\\n",
       "0           ...              \n",
       "1           ...              \n",
       "2           ...              \n",
       "3           ...              \n",
       "4           ...              \n",
       "\n",
       "  Is itrude to wake a passenger up if you are trying to walk around?  \\\n",
       "0                                                NaN                   \n",
       "1                                No, not at all rude                   \n",
       "2                                 Yes, somewhat rude                   \n",
       "3                                 Yes, somewhat rude                   \n",
       "4                                 Yes, somewhat rude                   \n",
       "\n",
       "  In general, is itrude to bring a baby on a plane?  \\\n",
       "0                                               NaN   \n",
       "1                               No, not at all rude   \n",
       "2                                Yes, somewhat rude   \n",
       "3                                Yes, somewhat rude   \n",
       "4                                Yes, somewhat rude   \n",
       "\n",
       "  In general, is it rude to knowingly bring unruly children on a plane?  \\\n",
       "0                                                NaN                      \n",
       "1                                No, not at all rude                      \n",
       "2                                     Yes, very rude                      \n",
       "3                                     Yes, very rude                      \n",
       "4                                     Yes, very rude                      \n",
       "\n",
       "  Have you ever used personal electronics during take off or landing in violation of a flight attendant's direction?  \\\n",
       "0                                                NaN                                                                   \n",
       "1                                                 No                                                                   \n",
       "2                                                 No                                                                   \n",
       "3                                                 No                                                                   \n",
       "4                                                Yes                                                                   \n",
       "\n",
       "  Have you ever smoked a cigarette in an airplane bathroom when it was against the rules?  \\\n",
       "0                                                NaN                                        \n",
       "1                                                 No                                        \n",
       "2                                                 No                                        \n",
       "3                                                 No                                        \n",
       "4                                                 No                                        \n",
       "\n",
       "  Gender    Age     Household Income        Education Location (Census Region)  \n",
       "0    NaN    NaN                  NaN              NaN                      NaN  \n",
       "1   Male  30-44                  NaN  Graduate degree                  Pacific  \n",
       "2   Male  30-44  $100,000 - $149,999  Bachelor degree                  Pacific  \n",
       "3   Male  30-44         $0 - $24,999  Bachelor degree                  Pacific  \n",
       "4   Male  30-44    $50,000 - $99,999  Bachelor degree                  Pacific  \n",
       "\n",
       "[5 rows x 27 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "flying.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Flying-etiquette columns\n",
      "------------------------\n",
      "Index([u'RespondentID', u'How often do you travel by plane?',\n",
      "       u'Do you ever recline your seat when you fly?', u'How tall are you?',\n",
      "       u'Do you have any children under 18?',\n",
      "       u'In a row of three seats, who should get to use the two arm rests?',\n",
      "       u'In a row of two seats, who should get to use the middle arm rest?',\n",
      "       u'Who should have control over the window shade?',\n",
      "       u'Is itrude to move to an unsold seat on a plane?',\n",
      "       u'Generally speaking, is it rude to say more than a few words tothe stranger sitting next to you on a plane?',\n",
      "       u'On a 6 hour flight from NYC to LA, how many times is it acceptable to get up if you're not in an aisle seat?',\n",
      "       u'Under normal circumstances, does a person who reclines their seat during a flight have any obligation to the person sitting behind them?',\n",
      "       u'Is itrude to recline your seat on a plane?',\n",
      "       u'Given the opportunity, would you eliminate the possibility of reclining seats on planes entirely?',\n",
      "       u'Is it rude to ask someone to switch seats with you in order to be closer to friends?',\n",
      "       u'Is itrude to ask someone to switch seats with you in order to be closer to family?',\n",
      "       u'Is it rude to wake a passenger up if you are trying to go to the bathroom?',\n",
      "       u'Is itrude to wake a passenger up if you are trying to walk around?',\n",
      "       u'In general, is itrude to bring a baby on a plane?',\n",
      "       u'In general, is it rude to knowingly bring unruly children on a plane?',\n",
      "       u'Have you ever used personal electronics during take off or landing in violation of a flight attendant's direction?',\n",
      "       u'Have you ever smoked a cigarette in an airplane bathroom when it was against the rules?',\n",
      "       u'Gender', u'Age', u'Household Income', u'Education',\n",
      "       u'Location (Census Region)'],\n",
      "      dtype='object')\n"
     ]
    }
   ],
   "source": [
    "print('Flying-etiquette columns\\n' + '-'*24)\n",
    "print(flying.columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Sample of Flying-etiquette\n",
      "--------------------\n",
      "     RespondentID How often do you travel by plane?  \\\n",
      "719    3432361003               Once a year or less   \n",
      "831    3432163496               Once a year or less   \n",
      "893    3431953153              Once a month or less   \n",
      "231    3433203355                             Never   \n",
      "882    3432026203               Once a year or less   \n",
      "185    3433259149               Once a year or less   \n",
      "367    3432985270               Once a year or less   \n",
      "642    3432482201                             Never   \n",
      "605    3432546954               Once a year or less   \n",
      "530    3432654546               Once a year or less   \n",
      "\n",
      "    Do you ever recline your seat when you fly? How tall are you?  \\\n",
      "719                             Once in a while             5'10\"   \n",
      "831                             Once in a while              5'9\"   \n",
      "893                                      Always              6'0\"   \n",
      "231                                         NaN               NaN   \n",
      "882                             Once in a while              6'0\"   \n",
      "185                         About half the time       Under 5 ft.   \n",
      "367                                      Always              5'4\"   \n",
      "642                                         NaN               NaN   \n",
      "605                                      Always              5'2\"   \n",
      "530                                     Usually             5'10\"   \n",
      "\n",
      "    Do you have any children under 18?  \\\n",
      "719                                 No   \n",
      "831                                Yes   \n",
      "893                                Yes   \n",
      "231                                NaN   \n",
      "882                                Yes   \n",
      "185                                Yes   \n",
      "367                                 No   \n",
      "642                                NaN   \n",
      "605                                Yes   \n",
      "530                                 No   \n",
      "\n",
      "    In a row of three seats, who should get to use the two arm rests?  \\\n",
      "719                     The arm rests should be shared                  \n",
      "831                     The arm rests should be shared                  \n",
      "893                     The arm rests should be shared                  \n",
      "231                                                NaN                  \n",
      "882                     The arm rests should be shared                  \n",
      "185                     The arm rests should be shared                  \n",
      "367                     The arm rests should be shared                  \n",
      "642                                                NaN                  \n",
      "605  The person in the middle seat gets both arm rests                  \n",
      "530                     The arm rests should be shared                  \n",
      "\n",
      "    In a row of two seats, who should get to use the middle arm rest?  \\\n",
      "719                     The arm rests should be shared                  \n",
      "831                     The arm rests should be shared                  \n",
      "893                     The arm rests should be shared                  \n",
      "231                                                NaN                  \n",
      "882                     The arm rests should be shared                  \n",
      "185                     The arm rests should be shared                  \n",
      "367                     The arm rests should be shared                  \n",
      "642                                                NaN                  \n",
      "605                           The person by the window                  \n",
      "530                     The arm rests should be shared                  \n",
      "\n",
      "        Who should have control over the window shade?  \\\n",
      "719           Everyone in the row should have some say   \n",
      "831           Everyone in the row should have some say   \n",
      "893           Everyone in the row should have some say   \n",
      "231                                                NaN   \n",
      "882           Everyone in the row should have some say   \n",
      "185  The person in the window seat should have excl...   \n",
      "367  The person in the window seat should have excl...   \n",
      "642                                                NaN   \n",
      "605  The person in the window seat should have excl...   \n",
      "530           Everyone in the row should have some say   \n",
      "\n",
      "    Is itrude to move to an unsold seat on a plane?  \\\n",
      "719                              Yes, somewhat rude   \n",
      "831                              Yes, somewhat rude   \n",
      "893                             No, not rude at all   \n",
      "231                                             NaN   \n",
      "882                             No, not rude at all   \n",
      "185                              Yes, somewhat rude   \n",
      "367                             No, not rude at all   \n",
      "642                                             NaN   \n",
      "605                              Yes, somewhat rude   \n",
      "530                             No, not rude at all   \n",
      "\n",
      "    Generally speaking, is it rude to say more than a few words tothe stranger sitting next to you on a plane?  \\\n",
      "719                                No, not at all rude                                                           \n",
      "831                                No, not at all rude                                                           \n",
      "893                                No, not at all rude                                                           \n",
      "231                                                NaN                                                           \n",
      "882                                No, not at all rude                                                           \n",
      "185                                 Yes, somewhat rude                                                           \n",
      "367                                No, not at all rude                                                           \n",
      "642                                                NaN                                                           \n",
      "605                                 Yes, somewhat rude                                                           \n",
      "530                                No, not at all rude                                                           \n",
      "\n",
      "              ...             \\\n",
      "719           ...              \n",
      "831           ...              \n",
      "893           ...              \n",
      "231           ...              \n",
      "882           ...              \n",
      "185           ...              \n",
      "367           ...              \n",
      "642           ...              \n",
      "605           ...              \n",
      "530           ...              \n",
      "\n",
      "    Is itrude to wake a passenger up if you are trying to walk around?  \\\n",
      "719                                No, not at all rude                   \n",
      "831                                 Yes, somewhat rude                   \n",
      "893                                     Yes, very rude                   \n",
      "231                                                NaN                   \n",
      "882                                No, not at all rude                   \n",
      "185                                 Yes, somewhat rude                   \n",
      "367                                 Yes, somewhat rude                   \n",
      "642                                                NaN                   \n",
      "605                                No, not at all rude                   \n",
      "530                                No, not at all rude                   \n",
      "\n",
      "    In general, is itrude to bring a baby on a plane?  \\\n",
      "719                               No, not at all rude   \n",
      "831                                Yes, somewhat rude   \n",
      "893                               No, not at all rude   \n",
      "231                                               NaN   \n",
      "882                               No, not at all rude   \n",
      "185                               No, not at all rude   \n",
      "367                               No, not at all rude   \n",
      "642                                               NaN   \n",
      "605                               No, not at all rude   \n",
      "530                                Yes, somewhat rude   \n",
      "\n",
      "    In general, is it rude to knowingly bring unruly children on a plane?  \\\n",
      "719                                     Yes, very rude                      \n",
      "831                                     Yes, very rude                      \n",
      "893                                     Yes, very rude                      \n",
      "231                                                NaN                      \n",
      "882                                 Yes, somewhat rude                      \n",
      "185                                No, not at all rude                      \n",
      "367                                 Yes, somewhat rude                      \n",
      "642                                                NaN                      \n",
      "605                                 Yes, somewhat rude                      \n",
      "530                                     Yes, very rude                      \n",
      "\n",
      "    Have you ever used personal electronics during take off or landing in violation of a flight attendant's direction?  \\\n",
      "719                                                 No                                                                   \n",
      "831                                                 No                                                                   \n",
      "893                                                 No                                                                   \n",
      "231                                                NaN                                                                   \n",
      "882                                                Yes                                                                   \n",
      "185                                                 No                                                                   \n",
      "367                                                 No                                                                   \n",
      "642                                                NaN                                                                   \n",
      "605                                                 No                                                                   \n",
      "530                                                 No                                                                   \n",
      "\n",
      "    Have you ever smoked a cigarette in an airplane bathroom when it was against the rules?  \\\n",
      "719                                                 No                                        \n",
      "831                                                 No                                        \n",
      "893                                                 No                                        \n",
      "231                                                NaN                                        \n",
      "882                                                 No                                        \n",
      "185                                                 No                                        \n",
      "367                                                 No                                        \n",
      "642                                                NaN                                        \n",
      "605                                                 No                                        \n",
      "530                                                 No                                        \n",
      "\n",
      "     Gender    Age     Household Income                         Education  \\\n",
      "719    Male   > 60  $100,000 - $149,999                   Bachelor degree   \n",
      "831  Female  30-44    $50,000 - $99,999  Some college or Associate degree   \n",
      "893  Female  45-60    $50,000 - $99,999  Some college or Associate degree   \n",
      "231    Male   > 60    $50,000 - $99,999                   Bachelor degree   \n",
      "882    Male  30-44    $50,000 - $99,999                   Bachelor degree   \n",
      "185  Female  30-44         $0 - $24,999                   Graduate degree   \n",
      "367  Female  30-44    $50,000 - $99,999                   Bachelor degree   \n",
      "642  Female  18-29         $0 - $24,999                High school degree   \n",
      "605  Female  30-44                  NaN  Some college or Associate degree   \n",
      "530    Male  45-60    $50,000 - $99,999                   Graduate degree   \n",
      "\n",
      "    Location (Census Region)  \n",
      "719          Middle Atlantic  \n",
      "831       West South Central  \n",
      "893       West South Central  \n",
      "231                 Mountain  \n",
      "882       West South Central  \n",
      "185           South Atlantic  \n",
      "367       East South Central  \n",
      "642              New England  \n",
      "605                  Pacific  \n",
      "530                  Pacific  \n",
      "\n",
      "[10 rows x 27 columns]\n"
     ]
    }
   ],
   "source": [
    "#To sample of data\n",
    "print('Sample of Flying-etiquette\\n' + '-'*20)\n",
    "print(flying.sample(10))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Do you ever recline your seat when you fly?                                                                                                 182\n",
       "How tall are you?                                                                                                                           182\n",
       "Do you have any children under 18?                                                                                                          189\n",
       "In a row of three seats, who should get to use the two arm rests?                                                                           184\n",
       "In a row of two seats, who should get to use the middle arm rest?                                                                           184\n",
       "Who should have control over the window shade?                                                                                              184\n",
       "Is itrude to move to an unsold seat on a plane?                                                                                             185\n",
       "Generally speaking, is it rude to say more than a few words tothe stranger sitting next to you on a plane?                                  185\n",
       "On a 6 hour flight from NYC to LA, how many times is it acceptable to get up if you're not in an aisle seat?                                185\n",
       "Under normal circumstances, does a person who reclines their seat during a flight have any obligation to the person sitting behind them?    186\n",
       "Is itrude to recline your seat on a plane?                                                                                                  186\n",
       "Given the opportunity, would you eliminate the possibility of reclining seats on planes entirely?                                           186\n",
       "Is it rude to ask someone to switch seats with you in order to be closer to friends?                                                        190\n",
       "Is itrude to ask someone to switch seats with you in order to be closer to family?                                                          190\n",
       "Is it rude to wake a passenger up if you are trying to go to the bathroom?                                                                  190\n",
       "Is itrude to wake a passenger up if you are trying to walk around?                                                                          190\n",
       "In general, is itrude to bring a baby on a plane?                                                                                           191\n",
       "In general, is it rude to knowingly bring unruly children on a plane?                                                                       191\n",
       "Have you ever used personal electronics during take off or landing in violation of a flight attendant's direction?                          191\n",
       "Have you ever smoked a cigarette in an airplane bathroom when it was against the rules?                                                     191\n",
       "Gender                                                                                                                                       33\n",
       "Age                                                                                                                                          33\n",
       "Household Income                                                                                                                            214\n",
       "Education                                                                                                                                    39\n",
       "Location (Census Region)                                                                                                                     42\n",
       "dtype: int64"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#to findout how many values are missing\n",
    "flying_missing = flying.isnull().sum()\n",
    "flying_missing[flying_missing>0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "28080.0\n",
      "The percentage of values missing in the dataset : 14.611823361823362\n"
     ]
    }
   ],
   "source": [
    "#precentage of missing values\n",
    "total_cells = np.product(flying.shape)\n",
    "total_cells = float(total_cells)\n",
    "print (total_cells)\n",
    "total_missing = flying_missing.sum()\n",
    "percnt_missing = (total_missing/total_cells) * 100\n",
    "print('The percentage of values missing in the dataset : ' + str(percnt_missing))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "RespondentID                                                                                                    0\n",
       "How often do you travel by plane?                                                                               0\n",
       "Do you ever recline your seat when you fly?                                                                   182\n",
       "How tall are you?                                                                                             182\n",
       "Do you have any children under 18?                                                                            189\n",
       "In a row of three seats, who should get to use the two arm rests?                                             184\n",
       "In a row of two seats, who should get to use the middle arm rest?                                             184\n",
       "Who should have control over the window shade?                                                                184\n",
       "Is itrude to move to an unsold seat on a plane?                                                               185\n",
       "Generally speaking, is it rude to say more than a few words tothe stranger sitting next to you on a plane?    185\n",
       "dtype: int64"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "flying_missing[0:10]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>RespondentID</th>\n",
       "      <th>How often do you travel by plane?</th>\n",
       "      <th>Do you ever recline your seat when you fly?</th>\n",
       "      <th>How tall are you?</th>\n",
       "      <th>Do you have any children under 18?</th>\n",
       "      <th>In a row of three seats, who should get to use the two arm rests?</th>\n",
       "      <th>In a row of two seats, who should get to use the middle arm rest?</th>\n",
       "      <th>Who should have control over the window shade?</th>\n",
       "      <th>Is itrude to move to an unsold seat on a plane?</th>\n",
       "      <th>Generally speaking, is it rude to say more than a few words tothe stranger sitting next to you on a plane?</th>\n",
       "      <th>...</th>\n",
       "      <th>Is itrude to wake a passenger up if you are trying to walk around?</th>\n",
       "      <th>In general, is itrude to bring a baby on a plane?</th>\n",
       "      <th>In general, is it rude to knowingly bring unruly children on a plane?</th>\n",
       "      <th>Have you ever used personal electronics during take off or landing in violation of a flight attendant's direction?</th>\n",
       "      <th>Have you ever smoked a cigarette in an airplane bathroom when it was against the rules?</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>2</th>\n",
       "      <td>3434275578</td>\n",
       "      <td>Once a year or less</td>\n",
       "      <td>Usually</td>\n",
       "      <td>5'8\"</td>\n",
       "      <td>No</td>\n",
       "      <td>Whoever puts their arm on the arm rest first</td>\n",
       "      <td>The arm rests should be shared</td>\n",
       "      <td>The person in the window seat should have excl...</td>\n",
       "      <td>No, not rude at all</td>\n",
       "      <td>No, not at all rude</td>\n",
       "      <td>...</td>\n",
       "      <td>Yes, somewhat rude</td>\n",
       "      <td>Yes, somewhat rude</td>\n",
       "      <td>Yes, very rude</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>30-44</td>\n",
       "      <td>$100,000 - $149,999</td>\n",
       "      <td>Bachelor degree</td>\n",
       "      <td>Pacific</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3434268208</td>\n",
       "      <td>Once a year or less</td>\n",
       "      <td>Always</td>\n",
       "      <td>5'11\"</td>\n",
       "      <td>No</td>\n",
       "      <td>The arm rests should be shared</td>\n",
       "      <td>The arm rests should be shared</td>\n",
       "      <td>Everyone in the row should have some say</td>\n",
       "      <td>No, not rude at all</td>\n",
       "      <td>No, not at all rude</td>\n",
       "      <td>...</td>\n",
       "      <td>Yes, somewhat rude</td>\n",
       "      <td>Yes, somewhat rude</td>\n",
       "      <td>Yes, very rude</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>30-44</td>\n",
       "      <td>$0 - $24,999</td>\n",
       "      <td>Bachelor degree</td>\n",
       "      <td>Pacific</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3434250245</td>\n",
       "      <td>Once a month or less</td>\n",
       "      <td>About half the time</td>\n",
       "      <td>5'7\"</td>\n",
       "      <td>No</td>\n",
       "      <td>The person in the middle seat gets both arm rests</td>\n",
       "      <td>The person in aisle</td>\n",
       "      <td>Everyone in the row should have some say</td>\n",
       "      <td>No, not rude at all</td>\n",
       "      <td>No, not at all rude</td>\n",
       "      <td>...</td>\n",
       "      <td>Yes, somewhat rude</td>\n",
       "      <td>Yes, somewhat rude</td>\n",
       "      <td>Yes, very rude</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>30-44</td>\n",
       "      <td>$50,000 - $99,999</td>\n",
       "      <td>Bachelor degree</td>\n",
       "      <td>Pacific</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>3434245875</td>\n",
       "      <td>Once a year or less</td>\n",
       "      <td>Usually</td>\n",
       "      <td>5'9\"</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Whoever puts their arm on the arm rest first</td>\n",
       "      <td>Whoever puts their arm on the arm rest first</td>\n",
       "      <td>The person in the window seat should have excl...</td>\n",
       "      <td>Yes, somewhat rude</td>\n",
       "      <td>No, not at all rude</td>\n",
       "      <td>...</td>\n",
       "      <td>Yes, very rude</td>\n",
       "      <td>Yes, very rude</td>\n",
       "      <td>Yes, very rude</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>30-44</td>\n",
       "      <td>$25,000 - $49,999</td>\n",
       "      <td>Graduate degree</td>\n",
       "      <td>East North Central</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>3434235351</td>\n",
       "      <td>Once a month or less</td>\n",
       "      <td>Once in a while</td>\n",
       "      <td>6'2\"</td>\n",
       "      <td>Yes</td>\n",
       "      <td>The person in the middle seat gets both arm rests</td>\n",
       "      <td>Whoever puts their arm on the arm rest first</td>\n",
       "      <td>Everyone in the row should have some say</td>\n",
       "      <td>No, not rude at all</td>\n",
       "      <td>Yes, somewhat rude</td>\n",
       "      <td>...</td>\n",
       "      <td>No, not at all rude</td>\n",
       "      <td>No, not at all rude</td>\n",
       "      <td>Yes, somewhat rude</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>30-44</td>\n",
       "      <td>150000</td>\n",
       "      <td>Some college or Associate degree</td>\n",
       "      <td>Pacific</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   RespondentID How often do you travel by plane?  \\\n",
       "2    3434275578               Once a year or less   \n",
       "3    3434268208               Once a year or less   \n",
       "4    3434250245              Once a month or less   \n",
       "5    3434245875               Once a year or less   \n",
       "6    3434235351              Once a month or less   \n",
       "\n",
       "  Do you ever recline your seat when you fly? How tall are you?  \\\n",
       "2                                     Usually              5'8\"   \n",
       "3                                      Always             5'11\"   \n",
       "4                         About half the time              5'7\"   \n",
       "5                                     Usually              5'9\"   \n",
       "6                             Once in a while              6'2\"   \n",
       "\n",
       "  Do you have any children under 18?  \\\n",
       "2                                 No   \n",
       "3                                 No   \n",
       "4                                 No   \n",
       "5                                Yes   \n",
       "6                                Yes   \n",
       "\n",
       "  In a row of three seats, who should get to use the two arm rests?  \\\n",
       "2       Whoever puts their arm on the arm rest first                  \n",
       "3                     The arm rests should be shared                  \n",
       "4  The person in the middle seat gets both arm rests                  \n",
       "5       Whoever puts their arm on the arm rest first                  \n",
       "6  The person in the middle seat gets both arm rests                  \n",
       "\n",
       "  In a row of two seats, who should get to use the middle arm rest?  \\\n",
       "2                     The arm rests should be shared                  \n",
       "3                     The arm rests should be shared                  \n",
       "4                                The person in aisle                  \n",
       "5       Whoever puts their arm on the arm rest first                  \n",
       "6       Whoever puts their arm on the arm rest first                  \n",
       "\n",
       "      Who should have control over the window shade?  \\\n",
       "2  The person in the window seat should have excl...   \n",
       "3           Everyone in the row should have some say   \n",
       "4           Everyone in the row should have some say   \n",
       "5  The person in the window seat should have excl...   \n",
       "6           Everyone in the row should have some say   \n",
       "\n",
       "  Is itrude to move to an unsold seat on a plane?  \\\n",
       "2                             No, not rude at all   \n",
       "3                             No, not rude at all   \n",
       "4                             No, not rude at all   \n",
       "5                              Yes, somewhat rude   \n",
       "6                             No, not rude at all   \n",
       "\n",
       "  Generally speaking, is it rude to say more than a few words tothe stranger sitting next to you on a plane?  \\\n",
       "2                                No, not at all rude                                                           \n",
       "3                                No, not at all rude                                                           \n",
       "4                                No, not at all rude                                                           \n",
       "5                                No, not at all rude                                                           \n",
       "6                                 Yes, somewhat rude                                                           \n",
       "\n",
       "            ...             \\\n",
       "2           ...              \n",
       "3           ...              \n",
       "4           ...              \n",
       "5           ...              \n",
       "6           ...              \n",
       "\n",
       "  Is itrude to wake a passenger up if you are trying to walk around?  \\\n",
       "2                                 Yes, somewhat rude                   \n",
       "3                                 Yes, somewhat rude                   \n",
       "4                                 Yes, somewhat rude                   \n",
       "5                                     Yes, very rude                   \n",
       "6                                No, not at all rude                   \n",
       "\n",
       "  In general, is itrude to bring a baby on a plane?  \\\n",
       "2                                Yes, somewhat rude   \n",
       "3                                Yes, somewhat rude   \n",
       "4                                Yes, somewhat rude   \n",
       "5                                    Yes, very rude   \n",
       "6                               No, not at all rude   \n",
       "\n",
       "  In general, is it rude to knowingly bring unruly children on a plane?  \\\n",
       "2                                     Yes, very rude                      \n",
       "3                                     Yes, very rude                      \n",
       "4                                     Yes, very rude                      \n",
       "5                                     Yes, very rude                      \n",
       "6                                 Yes, somewhat rude                      \n",
       "\n",
       "  Have you ever used personal electronics during take off or landing in violation of a flight attendant's direction?  \\\n",
       "2                                                 No                                                                   \n",
       "3                                                 No                                                                   \n",
       "4                                                Yes                                                                   \n",
       "5                                                 No                                                                   \n",
       "6                                                 No                                                                   \n",
       "\n",
       "  Have you ever smoked a cigarette in an airplane bathroom when it was against the rules?  \\\n",
       "2                                                 No                                        \n",
       "3                                                 No                                        \n",
       "4                                                 No                                        \n",
       "5                                                 No                                        \n",
       "6                                                 No                                        \n",
       "\n",
       "  Gender    Age     Household Income                         Education  \\\n",
       "2   Male  30-44  $100,000 - $149,999                   Bachelor degree   \n",
       "3   Male  30-44         $0 - $24,999                   Bachelor degree   \n",
       "4   Male  30-44    $50,000 - $99,999                   Bachelor degree   \n",
       "5   Male  30-44    $25,000 - $49,999                   Graduate degree   \n",
       "6   Male  30-44               150000  Some college or Associate degree   \n",
       "\n",
       "  Location (Census Region)  \n",
       "2                  Pacific  \n",
       "3                  Pacific  \n",
       "4                  Pacific  \n",
       "5       East North Central  \n",
       "6                  Pacific  \n",
       "\n",
       "[5 rows x 27 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dropped_na_values = flying.dropna(axis=0)\n",
    "dropped_na_values.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Total number of rows after dropping records : 18549.0\n"
     ]
    }
   ],
   "source": [
    "#Total number of records after dropping\n",
    "total_cells_of_dropped = np.product(dropped_na_values.shape)\n",
    "total_cells_of_dropped = float(total_cells_of_dropped)\n",
    "print ('Total number of rows after dropping records : ' + str (total_cells_of_dropped))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>RespondentID</th>\n",
       "      <th>How often do you travel by plane?</th>\n",
       "      <th>Do you ever recline your seat when you fly?</th>\n",
       "      <th>How tall are you?</th>\n",
       "      <th>Do you have any children under 18?</th>\n",
       "      <th>In a row of three seats, who should get to use the two arm rests?</th>\n",
       "      <th>In a row of two seats, who should get to use the middle arm rest?</th>\n",
       "      <th>Who should have control over the window shade?</th>\n",
       "      <th>Is itrude to move to an unsold seat on a plane?</th>\n",
       "      <th>Generally speaking, is it rude to say more than a few words tothe stranger sitting next to you on a plane?</th>\n",
       "      <th>...</th>\n",
       "      <th>Is itrude to wake a passenger up if you are trying to walk around?</th>\n",
       "      <th>In general, is itrude to bring a baby on a plane?</th>\n",
       "      <th>In general, is it rude to knowingly bring unruly children on a plane?</th>\n",
       "      <th>Have you ever used personal electronics during take off or landing in violation of a flight attendant's direction?</th>\n",
       "      <th>Have you ever smoked a cigarette in an airplane bathroom when it was against the rules?</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Age</th>\n",
       "      <th>Household Income</th>\n",
       "      <th>Education</th>\n",
       "      <th>Location (Census Region)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3436139758</td>\n",
       "      <td>Once a year or less</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>NaN</td>\n",
       "      <td>unknown</td>\n",
       "      <td>unknown</td>\n",
       "      <td>unknown</td>\n",
       "      <td>unknown</td>\n",
       "      <td>unknown</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3434278696</td>\n",
       "      <td>Once a year or less</td>\n",
       "      <td>About half the time</td>\n",
       "      <td>6'3\"</td>\n",
       "      <td>Yes</td>\n",
       "      <td>The arm rests should be shared</td>\n",
       "      <td>The arm rests should be shared</td>\n",
       "      <td>Everyone in the row should have some say</td>\n",
       "      <td>No, not rude at all</td>\n",
       "      <td>No, not at all rude</td>\n",
       "      <td>...</td>\n",
       "      <td>No, not at all rude</td>\n",
       "      <td>No, not at all rude</td>\n",
       "      <td>No, not at all rude</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>30-44</td>\n",
       "      <td>unknown</td>\n",
       "      <td>Graduate degree</td>\n",
       "      <td>Pacific</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3434275578</td>\n",
       "      <td>Once a year or less</td>\n",
       "      <td>Usually</td>\n",
       "      <td>5'8\"</td>\n",
       "      <td>No</td>\n",
       "      <td>Whoever puts their arm on the arm rest first</td>\n",
       "      <td>The arm rests should be shared</td>\n",
       "      <td>The person in the window seat should have excl...</td>\n",
       "      <td>No, not rude at all</td>\n",
       "      <td>No, not at all rude</td>\n",
       "      <td>...</td>\n",
       "      <td>Yes, somewhat rude</td>\n",
       "      <td>Yes, somewhat rude</td>\n",
       "      <td>Yes, very rude</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>30-44</td>\n",
       "      <td>$100,000 - $149,999</td>\n",
       "      <td>Bachelor degree</td>\n",
       "      <td>Pacific</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3434268208</td>\n",
       "      <td>Once a year or less</td>\n",
       "      <td>Always</td>\n",
       "      <td>5'11\"</td>\n",
       "      <td>No</td>\n",
       "      <td>The arm rests should be shared</td>\n",
       "      <td>The arm rests should be shared</td>\n",
       "      <td>Everyone in the row should have some say</td>\n",
       "      <td>No, not rude at all</td>\n",
       "      <td>No, not at all rude</td>\n",
       "      <td>...</td>\n",
       "      <td>Yes, somewhat rude</td>\n",
       "      <td>Yes, somewhat rude</td>\n",
       "      <td>Yes, very rude</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>30-44</td>\n",
       "      <td>$0 - $24,999</td>\n",
       "      <td>Bachelor degree</td>\n",
       "      <td>Pacific</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3434250245</td>\n",
       "      <td>Once a month or less</td>\n",
       "      <td>About half the time</td>\n",
       "      <td>5'7\"</td>\n",
       "      <td>No</td>\n",
       "      <td>The person in the middle seat gets both arm rests</td>\n",
       "      <td>The person in aisle</td>\n",
       "      <td>Everyone in the row should have some say</td>\n",
       "      <td>No, not rude at all</td>\n",
       "      <td>No, not at all rude</td>\n",
       "      <td>...</td>\n",
       "      <td>Yes, somewhat rude</td>\n",
       "      <td>Yes, somewhat rude</td>\n",
       "      <td>Yes, very rude</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>30-44</td>\n",
       "      <td>$50,000 - $99,999</td>\n",
       "      <td>Bachelor degree</td>\n",
       "      <td>Pacific</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   RespondentID How often do you travel by plane?  \\\n",
       "0    3436139758               Once a year or less   \n",
       "1    3434278696               Once a year or less   \n",
       "2    3434275578               Once a year or less   \n",
       "3    3434268208               Once a year or less   \n",
       "4    3434250245              Once a month or less   \n",
       "\n",
       "  Do you ever recline your seat when you fly? How tall are you?  \\\n",
       "0                                         NaN               NaN   \n",
       "1                         About half the time              6'3\"   \n",
       "2                                     Usually              5'8\"   \n",
       "3                                      Always             5'11\"   \n",
       "4                         About half the time              5'7\"   \n",
       "\n",
       "  Do you have any children under 18?  \\\n",
       "0                                NaN   \n",
       "1                                Yes   \n",
       "2                                 No   \n",
       "3                                 No   \n",
       "4                                 No   \n",
       "\n",
       "  In a row of three seats, who should get to use the two arm rests?  \\\n",
       "0                                                NaN                  \n",
       "1                     The arm rests should be shared                  \n",
       "2       Whoever puts their arm on the arm rest first                  \n",
       "3                     The arm rests should be shared                  \n",
       "4  The person in the middle seat gets both arm rests                  \n",
       "\n",
       "  In a row of two seats, who should get to use the middle arm rest?  \\\n",
       "0                                                NaN                  \n",
       "1                     The arm rests should be shared                  \n",
       "2                     The arm rests should be shared                  \n",
       "3                     The arm rests should be shared                  \n",
       "4                                The person in aisle                  \n",
       "\n",
       "      Who should have control over the window shade?  \\\n",
       "0                                                NaN   \n",
       "1           Everyone in the row should have some say   \n",
       "2  The person in the window seat should have excl...   \n",
       "3           Everyone in the row should have some say   \n",
       "4           Everyone in the row should have some say   \n",
       "\n",
       "  Is itrude to move to an unsold seat on a plane?  \\\n",
       "0                                             NaN   \n",
       "1                             No, not rude at all   \n",
       "2                             No, not rude at all   \n",
       "3                             No, not rude at all   \n",
       "4                             No, not rude at all   \n",
       "\n",
       "  Generally speaking, is it rude to say more than a few words tothe stranger sitting next to you on a plane?  \\\n",
       "0                                                NaN                                                           \n",
       "1                                No, not at all rude                                                           \n",
       "2                                No, not at all rude                                                           \n",
       "3                                No, not at all rude                                                           \n",
       "4                                No, not at all rude                                                           \n",
       "\n",
       "            ...             \\\n",
       "0           ...              \n",
       "1           ...              \n",
       "2           ...              \n",
       "3           ...              \n",
       "4           ...              \n",
       "\n",
       "  Is itrude to wake a passenger up if you are trying to walk around?  \\\n",
       "0                                                NaN                   \n",
       "1                                No, not at all rude                   \n",
       "2                                 Yes, somewhat rude                   \n",
       "3                                 Yes, somewhat rude                   \n",
       "4                                 Yes, somewhat rude                   \n",
       "\n",
       "  In general, is itrude to bring a baby on a plane?  \\\n",
       "0                                               NaN   \n",
       "1                               No, not at all rude   \n",
       "2                                Yes, somewhat rude   \n",
       "3                                Yes, somewhat rude   \n",
       "4                                Yes, somewhat rude   \n",
       "\n",
       "  In general, is it rude to knowingly bring unruly children on a plane?  \\\n",
       "0                                                NaN                      \n",
       "1                                No, not at all rude                      \n",
       "2                                     Yes, very rude                      \n",
       "3                                     Yes, very rude                      \n",
       "4                                     Yes, very rude                      \n",
       "\n",
       "  Have you ever used personal electronics during take off or landing in violation of a flight attendant's direction?  \\\n",
       "0                                                NaN                                                                   \n",
       "1                                                 No                                                                   \n",
       "2                                                 No                                                                   \n",
       "3                                                 No                                                                   \n",
       "4                                                Yes                                                                   \n",
       "\n",
       "  Have you ever smoked a cigarette in an airplane bathroom when it was against the rules?  \\\n",
       "0                                                NaN                                        \n",
       "1                                                 No                                        \n",
       "2                                                 No                                        \n",
       "3                                                 No                                        \n",
       "4                                                 No                                        \n",
       "\n",
       "    Gender      Age     Household Income        Education  \\\n",
       "0  unknown  unknown              unknown          unknown   \n",
       "1     Male    30-44              unknown  Graduate degree   \n",
       "2     Male    30-44  $100,000 - $149,999  Bachelor degree   \n",
       "3     Male    30-44         $0 - $24,999  Bachelor degree   \n",
       "4     Male    30-44    $50,000 - $99,999  Bachelor degree   \n",
       "\n",
       "  Location (Census Region)  \n",
       "0                  unknown  \n",
       "1                  Pacific  \n",
       "2                  Pacific  \n",
       "3                  Pacific  \n",
       "4                  Pacific  \n",
       "\n",
       "[5 rows x 27 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filled_flying = flying.fillna({\n",
    "    'Gender': 'unknown',\n",
    "    'Age' : 'unknown',\n",
    "    'Household Income' : 'unknown',\n",
    "    'Education' : 'unknown',\n",
    "    'Location (Census Region)' : 'unknown'\n",
    "    })\n",
    "filled_flying.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>RespondentID</th>\n",
       "      <th>How often do you travel by plane?</th>\n",
       "      <th>Do you ever recline your seat when you fly?</th>\n",
       "      <th>How tall are you?</th>\n",
       "      <th>Do you have any children under 18?</th>\n",
       "      <th>In a row of three seats, who should get to use the two arm rests?</th>\n",
       "      <th>In a row of two seats, who should get to use the middle arm rest?</th>\n",
       "      <th>Who should have control over the window shade?</th>\n",
       "      <th>Is itrude to move to an unsold seat on a plane?</th>\n",
       "      <th>Generally speaking, is it rude to say more than a few words tothe stranger sitting next to you on a plane?</th>\n",
       "      <th>...</th>\n",
       "      <th>Is itrude to wake a passenger up if you are trying to walk around?</th>\n",
       "      <th>In general, is itrude to bring a baby on a plane?</th>\n",
       "      <th>In general, is it rude to knowingly bring unruly children on a plane?</th>\n",
       "      <th>Have you ever used personal electronics during take off or landing in violation of a flight attendant's direction?</th>\n",
       "      <th>Have you ever smoked a cigarette in an airplane bathroom when it was against the rules?</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>3434278696</td>\n",
       "      <td>Once a year or less</td>\n",
       "      <td>About half the time</td>\n",
       "      <td>6'3\"</td>\n",
       "      <td>Yes</td>\n",
       "      <td>The arm rests should be shared</td>\n",
       "      <td>The arm rests should be shared</td>\n",
       "      <td>Everyone in the row should have some say</td>\n",
       "      <td>No, not rude at all</td>\n",
       "      <td>No, not at all rude</td>\n",
       "      <td>...</td>\n",
       "      <td>No, not at all rude</td>\n",
       "      <td>No, not at all rude</td>\n",
       "      <td>No, not at all rude</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>30-44</td>\n",
       "      <td>unknown</td>\n",
       "      <td>Graduate degree</td>\n",
       "      <td>Pacific</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3434275578</td>\n",
       "      <td>Once a year or less</td>\n",
       "      <td>Usually</td>\n",
       "      <td>5'8\"</td>\n",
       "      <td>No</td>\n",
       "      <td>Whoever puts their arm on the arm rest first</td>\n",
       "      <td>The arm rests should be shared</td>\n",
       "      <td>The person in the window seat should have excl...</td>\n",
       "      <td>No, not rude at all</td>\n",
       "      <td>No, not at all rude</td>\n",
       "      <td>...</td>\n",
       "      <td>Yes, somewhat rude</td>\n",
       "      <td>Yes, somewhat rude</td>\n",
       "      <td>Yes, very rude</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>30-44</td>\n",
       "      <td>$100,000 - $149,999</td>\n",
       "      <td>Bachelor degree</td>\n",
       "      <td>Pacific</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3434268208</td>\n",
       "      <td>Once a year or less</td>\n",
       "      <td>Always</td>\n",
       "      <td>5'11\"</td>\n",
       "      <td>No</td>\n",
       "      <td>The arm rests should be shared</td>\n",
       "      <td>The arm rests should be shared</td>\n",
       "      <td>Everyone in the row should have some say</td>\n",
       "      <td>No, not rude at all</td>\n",
       "      <td>No, not at all rude</td>\n",
       "      <td>...</td>\n",
       "      <td>Yes, somewhat rude</td>\n",
       "      <td>Yes, somewhat rude</td>\n",
       "      <td>Yes, very rude</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>30-44</td>\n",
       "      <td>$0 - $24,999</td>\n",
       "      <td>Bachelor degree</td>\n",
       "      <td>Pacific</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3434250245</td>\n",
       "      <td>Once a month or less</td>\n",
       "      <td>About half the time</td>\n",
       "      <td>5'7\"</td>\n",
       "      <td>No</td>\n",
       "      <td>The person in the middle seat gets both arm rests</td>\n",
       "      <td>The person in aisle</td>\n",
       "      <td>Everyone in the row should have some say</td>\n",
       "      <td>No, not rude at all</td>\n",
       "      <td>No, not at all rude</td>\n",
       "      <td>...</td>\n",
       "      <td>Yes, somewhat rude</td>\n",
       "      <td>Yes, somewhat rude</td>\n",
       "      <td>Yes, very rude</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>30-44</td>\n",
       "      <td>$50,000 - $99,999</td>\n",
       "      <td>Bachelor degree</td>\n",
       "      <td>Pacific</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>3434245875</td>\n",
       "      <td>Once a year or less</td>\n",
       "      <td>Usually</td>\n",
       "      <td>5'9\"</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Whoever puts their arm on the arm rest first</td>\n",
       "      <td>Whoever puts their arm on the arm rest first</td>\n",
       "      <td>The person in the window seat should have excl...</td>\n",
       "      <td>Yes, somewhat rude</td>\n",
       "      <td>No, not at all rude</td>\n",
       "      <td>...</td>\n",
       "      <td>Yes, very rude</td>\n",
       "      <td>Yes, very rude</td>\n",
       "      <td>Yes, very rude</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>30-44</td>\n",
       "      <td>$25,000 - $49,999</td>\n",
       "      <td>Graduate degree</td>\n",
       "      <td>East North Central</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   RespondentID How often do you travel by plane?  \\\n",
       "1    3434278696               Once a year or less   \n",
       "2    3434275578               Once a year or less   \n",
       "3    3434268208               Once a year or less   \n",
       "4    3434250245              Once a month or less   \n",
       "5    3434245875               Once a year or less   \n",
       "\n",
       "  Do you ever recline your seat when you fly? How tall are you?  \\\n",
       "1                         About half the time              6'3\"   \n",
       "2                                     Usually              5'8\"   \n",
       "3                                      Always             5'11\"   \n",
       "4                         About half the time              5'7\"   \n",
       "5                                     Usually              5'9\"   \n",
       "\n",
       "  Do you have any children under 18?  \\\n",
       "1                                Yes   \n",
       "2                                 No   \n",
       "3                                 No   \n",
       "4                                 No   \n",
       "5                                Yes   \n",
       "\n",
       "  In a row of three seats, who should get to use the two arm rests?  \\\n",
       "1                     The arm rests should be shared                  \n",
       "2       Whoever puts their arm on the arm rest first                  \n",
       "3                     The arm rests should be shared                  \n",
       "4  The person in the middle seat gets both arm rests                  \n",
       "5       Whoever puts their arm on the arm rest first                  \n",
       "\n",
       "  In a row of two seats, who should get to use the middle arm rest?  \\\n",
       "1                     The arm rests should be shared                  \n",
       "2                     The arm rests should be shared                  \n",
       "3                     The arm rests should be shared                  \n",
       "4                                The person in aisle                  \n",
       "5       Whoever puts their arm on the arm rest first                  \n",
       "\n",
       "      Who should have control over the window shade?  \\\n",
       "1           Everyone in the row should have some say   \n",
       "2  The person in the window seat should have excl...   \n",
       "3           Everyone in the row should have some say   \n",
       "4           Everyone in the row should have some say   \n",
       "5  The person in the window seat should have excl...   \n",
       "\n",
       "  Is itrude to move to an unsold seat on a plane?  \\\n",
       "1                             No, not rude at all   \n",
       "2                             No, not rude at all   \n",
       "3                             No, not rude at all   \n",
       "4                             No, not rude at all   \n",
       "5                              Yes, somewhat rude   \n",
       "\n",
       "  Generally speaking, is it rude to say more than a few words tothe stranger sitting next to you on a plane?  \\\n",
       "1                                No, not at all rude                                                           \n",
       "2                                No, not at all rude                                                           \n",
       "3                                No, not at all rude                                                           \n",
       "4                                No, not at all rude                                                           \n",
       "5                                No, not at all rude                                                           \n",
       "\n",
       "            ...             \\\n",
       "1           ...              \n",
       "2           ...              \n",
       "3           ...              \n",
       "4           ...              \n",
       "5           ...              \n",
       "\n",
       "  Is itrude to wake a passenger up if you are trying to walk around?  \\\n",
       "1                                No, not at all rude                   \n",
       "2                                 Yes, somewhat rude                   \n",
       "3                                 Yes, somewhat rude                   \n",
       "4                                 Yes, somewhat rude                   \n",
       "5                                     Yes, very rude                   \n",
       "\n",
       "  In general, is itrude to bring a baby on a plane?  \\\n",
       "1                               No, not at all rude   \n",
       "2                                Yes, somewhat rude   \n",
       "3                                Yes, somewhat rude   \n",
       "4                                Yes, somewhat rude   \n",
       "5                                    Yes, very rude   \n",
       "\n",
       "  In general, is it rude to knowingly bring unruly children on a plane?  \\\n",
       "1                                No, not at all rude                      \n",
       "2                                     Yes, very rude                      \n",
       "3                                     Yes, very rude                      \n",
       "4                                     Yes, very rude                      \n",
       "5                                     Yes, very rude                      \n",
       "\n",
       "  Have you ever used personal electronics during take off or landing in violation of a flight attendant's direction?  \\\n",
       "1                                                 No                                                                   \n",
       "2                                                 No                                                                   \n",
       "3                                                 No                                                                   \n",
       "4                                                Yes                                                                   \n",
       "5                                                 No                                                                   \n",
       "\n",
       "  Have you ever smoked a cigarette in an airplane bathroom when it was against the rules?  \\\n",
       "1                                                 No                                        \n",
       "2                                                 No                                        \n",
       "3                                                 No                                        \n",
       "4                                                 No                                        \n",
       "5                                                 No                                        \n",
       "\n",
       "  Gender    Age     Household Income        Education Location (Census Region)  \n",
       "1   Male  30-44              unknown  Graduate degree                  Pacific  \n",
       "2   Male  30-44  $100,000 - $149,999  Bachelor degree                  Pacific  \n",
       "3   Male  30-44         $0 - $24,999  Bachelor degree                  Pacific  \n",
       "4   Male  30-44    $50,000 - $99,999  Bachelor degree                  Pacific  \n",
       "5   Male  30-44    $25,000 - $49,999  Graduate degree       East North Central  \n",
       "\n",
       "[5 rows x 27 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dropped_na_values = filled_flying.dropna(axis=0)\n",
    "dropped_na_values.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Total number of rows after dropping records : 22815.0\n"
     ]
    }
   ],
   "source": [
    "#Total number of records after dropping\n",
    "total_cells_of_dropped = np.product(dropped_na_values.shape)\n",
    "total_cells_of_dropped = float(total_cells_of_dropped)\n",
    "print ('Total number of rows after dropping records : ' + str (total_cells_of_dropped))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Female     528\n",
       "Male       479\n",
       "unknown     33\n",
       "Name: Gender, dtype: int64"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filled_flying['Gender'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "No, not at all rude    592\n",
       "Yes, somewhat rude     182\n",
       "Yes, very rude          75\n",
       "Name: In general, is itrude to bring a baby on a plane?, dtype: int64"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filled_flying['In general, is itrude to bring a baby on a plane?'].value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "##### Let us consider both these categorical variables,\n",
    "\n",
    "We are not interested to know if there is a relationship between the person gender and their tendency to accept a baby on a plane. In order to do so, we would have to use the Chi-Square test. But First, let's state our null and alternate hypothesis. \n",
    "\n",
    "Ho : There is no staistically significant relationship between these two variables.\n",
    "H1 : There is a staistically significant relationship between these two variables.\n",
    "\n",
    "In order to perfrom this test, we need to construct the contigency table for these two variables."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>In general, is itrude to bring a baby on a plane?</th>\n",
       "      <th>No, not at all rude</th>\n",
       "      <th>Yes, somewhat rude</th>\n",
       "      <th>Yes, very rude</th>\n",
       "      <th>All</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gender</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Female</th>\n",
       "      <td>338</td>\n",
       "      <td>76</td>\n",
       "      <td>28</td>\n",
       "      <td>442</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Male</th>\n",
       "      <td>249</td>\n",
       "      <td>105</td>\n",
       "      <td>47</td>\n",
       "      <td>401</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unknown</th>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>All</th>\n",
       "      <td>592</td>\n",
       "      <td>182</td>\n",
       "      <td>75</td>\n",
       "      <td>849</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "In general, is itrude to bring a baby on a plane?  No, not at all rude  \\\n",
       "Gender                                                                   \n",
       "Female                                                             338   \n",
       "Male                                                               249   \n",
       "unknown                                                              5   \n",
       "All                                                                592   \n",
       "\n",
       "In general, is itrude to bring a baby on a plane?  Yes, somewhat rude  \\\n",
       "Gender                                                                  \n",
       "Female                                                             76   \n",
       "Male                                                              105   \n",
       "unknown                                                             1   \n",
       "All                                                               182   \n",
       "\n",
       "In general, is itrude to bring a baby on a plane?  Yes, very rude  All  \n",
       "Gender                                                                  \n",
       "Female                                                         28  442  \n",
       "Male                                                           47  401  \n",
       "unknown                                                         0    6  \n",
       "All                                                            75  849  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "contigency_table_flying = pd.crosstab(\n",
    "filled_flying['Gender'],\n",
    "filled_flying['In general, is itrude to bring a baby on a plane?'],\n",
    "margins = True)\n",
    "contigency_table_flying"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Now we can see the counts of the people who are very rude towards bringing baby on a flight. Each row in the above table will represents the count. The intersection of Male and No, not at all rude represent that there are 249 Male who think bring a baby on plane is not rude. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(array([249, 105,  47]), array([338,  76,  28]), array([5, 1, 0]))\n"
     ]
    }
   ],
   "source": [
    "#assign the gender counts to variables\n",
    "male_count = contigency_table_flying.iloc[1][0:3].values\n",
    "female_count = contigency_table_flying.iloc[0][0:3].values\n",
    "unknown_count = contigency_table_flying.iloc[2][0:3].values\n",
    "\n",
    "print (male_count, female_count, unknown_count)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAngAAAFOCAYAAAAVXGAXAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvNQv5yAAAIABJREFUeJzs3XlcVPX+P/AXDA6boKIjLrgrZmCA4lgYgqiohBczwYxUIMxUbuZGWF4zK1ErLbW0BDUNl0spZnhdcStUNMvCBRUtcWFR9kWG5fz+4Mf5Os2AM7IMnl7Px6PHvXzO+5zznnEO8+KsRoIgCCAiIiIiyTA2dANEREREVL8Y8IiIiIgkhgGPiIiISGIY8IiIiIgkhgGPiIiISGIY8IiIiIgkxsTQDQBAdnY2VqxYgYSEBDx48AAODg6YM2cOnJ2dxZq0tDQsW7YMSUlJAABPT09ERETAxsZGbVm61mmTlVVQj6/qn6dVKwvk5BQbug2iJofbBpF23DbqRqGwqnGakaHvg1dYWAh/f39kZmYiKCgI1tbWiImJQUZGBmJjY2Fvb4+cnBy89NJLUKlUmDRpEioqKhAdHY2OHTsiNjYWcrkcAHSuqwkDXt0oFFZ8D4m04LZBpB23jbqpLeAZfA/e+vXrcePGDWzZsgUDBgwAAPj4+GDYsGGIiorC8uXLsWnTJqSnp2PPnj3o0aMHAMDJyQnBwcGIi4tDQEAAAOhcR0RERCRlBj0HTxAE7Nq1C56enmK4AwCFQoHw8HC4uroCAOLj46FUKsXQBgBubm7o1q0b4uPjxTFd64iIiIikzKAB79atW8jIyICbmxuAqsBXVFQEAAgMDERAQADy8vKQlpYGBwcHjfkdHByQnJwMADrXEREREUmdQQPeX3/9BQBo3bo1li1bBldXV/Tr1w/Dhw9HQkICACAjIwMAYGtrqzG/QqFAYWEhCgoKdK4jIiIikjqDnoOXn58PAPj8889hYmKCd999F8bGxoiOjsaMGTMQHR0Nc3NzABD/92GmpqYAgOLiYnHP36PqrKxqPiGRiIiISAoMGvBUKhWAqqC3f/9+tGjRAgDg5eWF4cOH49NPP8U777zzyOUYGxujsrJSp7ratGplARMTmQ6dU01qu6KH6J+M2waRdtw2GoZBA56FhQUAwNvbWwx3AGBtbQ0vLy/s2rULlpaWAIDS0lKN+avHLC0tda6rDe/FUze83J1IO24bRNpx26ib2sKxQc/Bqz5fTttNiG1sbCAIAlq3bg0AyMrK0qjJzMyEtbU1LCws0KFDB53qiIiIiKTOoAGvV69ekMvluHbtmsa0W7duwdTUFDY2NrCzs8OFCxc0ai5evAhHR0cAVXv9dKkjIiIikjqDBjwLCwt4eXnh6NGjuHr1qjielpaGhIQEDB06FDKZDN7e3jh58iRSU1PFmsTERNy4cQM+Pj7imK51RERERFJm8EeV3bp1C/7+/gCASZMmoVmzZti8eTNKSkqwc+dOdOrUCdnZ2fD19YVMJkNISAhKS0sRFRWFzp07Y/v27eIjyHStqwnPA6gbnktBpB23DSLtuG3UTZN+Fi1Qtcfu448/RmJiIgRBgKurK8LDw9WeSHH9+nVERkbi7NmzMDMzg4eHB8LDwzXO39O1TpvG+pCFLE1olPVQ/dkQ4WXoFugJxi8xIu24bdRNkw94TQUDHtWEAY/qgl9iRNpx26ibJnsVLRERERHVP4PeB4+IiIjo76Kjv8LGjetrrdm4MQa9evVupI4e7fnnXTFqlC/efXeRoVsBwIBHRERETdTEicHo2rWb1mm2tu0buZsnCwMeERHRE66pndtdX+ctDxgwEP36udbLsv5peA4eERERkcRwDx4RERE9sZKTf0dU1DpcuJAMAHB07IspU6bh6af/7wlW48aNhpvb8+jVqzdiYjYjMzMD3bv3wOzZ4bC1bYfPPvsEp04lwtLSEqNG+WLKlGkwNq7aB1ZeXo5t27bg0KEDuH07DZWVAjp16gx//5fh6+tXa28//3wCW7ZsxNWrKWjWTI7+/V0xdWoYOnfu0nBvyP/HPXhERETUJBUVFSI3N1fjv/LycgDAmTOnEBb2OoqKCjFlyhuYPDkEGRnpCAt7HefP/6q2rJ9+Oo6oqHUYPdoPwcFT8Ndff2LBgrfx1lvTYWxshLCwt9C9ew9s2bIR+/fvFedbsuR9REWtg4tLP8ycORfBwVNQUlKMpUs/wK+//lJj73v37kFExGyYmZlh+vQ38fLLgUhO/gOvvx6Emzf/apg37CHcg0dERERN0vz5c7WOr1q1Ds7O/fDxx5Ho08cBa9Z8DZlMBgB46aXxCA5+BZ999jE2btwqzpOVlYlNm7ahR4+eAICCgjxs3boFQ4cOx/vvRwIAvL1HwcfHC0lJpzBqlC/u37+Hgwf3ITBwMt54I0xcloeHJ155ZRyOHUuAi0t/jf6Kigrx+eefwMtrON5/f4k4Pnr0GLz6agDWrl2NyMhP6v4G1YIBj4iIiJqkGTPeQs+evTTGe/a0x5UrKbhz5zbGjBmHggL1myUPGuSOHTu2IjMzA23b2gIAOna0E8MdAHTqVHWYdPDgIeKYubk5WrWywf379wAArVu3wf79x8TDtQAgCIK4B7G4uFhr32fOnEZRUREGD/ZEbm6uOC6TmaB/f1ecPPkzysvLYWLScDGMAY+IiIiapN69n6rxKtozZ04DAL788nN8+eXnWmseDnitWqk/srR6j9/fx42NjVFZWSn+LJfLsX//XiQlnURa2k3cunULxcVFAKrCnja3b98CALz33js1vrbc3Fy0adOmxul1xYBHRERET5zKygoAQGjoG3Bw6Ku1pnPnruL/rw50+igrK8OsWTPwxx/n4eLSH66uSowfHwhn53546SXfWnqrCojh4e+iffsOWmusrGp+zFh9YMAjIiKiJ051cLKwsMCAAQPVpl26dAH5+fkwNTWt0zoOHdqP3347h4iI/6hdMXvvXlat87VrV3UT5pYtW2n0du7cWVRWVkIul9ept0fhVbRERET0xHnqqafRunUbxMbuUDsXrqioEAsXzseSJe8/1l67h+Xn5wEAunbtrjb+3/9uAwBUVFRonW/AgGchl5ti27bN4vl6QNWFHvPnz8G6dWtgZGRUp94ehXvwiIiI6IljYmKCWbPmYeHC+QgJeRWjR/tBLjfFnj27kJ5+FwsXflDnixgGDBgImUyGDz9ciLFjA2BiYoKffz6BpKSTaNasmXgu3t+1bNkSU6dOx+rVKzF1ajBGjBiF8vJy7NwZC5VKhRkzZtapL10w4BEREdETydNzKFasWIPNmzdg06ZoGBsboXv3Hli6dAUGDXKv8/K7d++Jjz5ajg0bvsZXX62BhYUlunfvgZUrv8CuXbH49ddzNV4NO358IBQKW2zf/i2++uoLmJqaoXfvp7Bw4Qd45hnnOvf2KEZCTZeA/ANlZRU8uqgeNLVnBtKj1ddzFemfSaGwarTfL0RPEm4bdaNQ1HyhBs/BIyIiIpIYBjwiIiIiiWHAIyIiIpIYBjwiIiIiiWHAIyIiIpIYBjwiIiIiiWHAIyIiIpIYBjwiIiIiiWHAIyIiIpIYBjwiIiIiiWHAIyIiIpIYBjwiIiIiiWHAIyIioibjo48W4fnnXTF4sBI5OTk11k2ePAHPP++Kjz5apNfyx40bjbCw1+vYZdPHgEdERERNTmVlJRITT2iddufObaSmXm3kjp4sJoZuAADGjRuHP/74Q2N8xIgRWLVqFQAgLS0Ny5YtQ1JSEgDA09MTERERsLGxUZtH1zoiIiKpuOeuNHQLatqcSKrzMtq374iffjqGF174l8a048ePoGXLVsjNrXkP3z+dwQOeIAhITU3FsGHD4O3trTatY8eOAICcnBxMnjwZKpUKoaGhqKioQHR0NFJSUhAbGwu5XK5XHRERETVt7u6D8cMPu1Ba+gCmpmZq044fP4rnnx+MH3/cbaDumj6DB7xbt26huLgYQ4cOhZ+fn9aaTZs2IT09HXv27EGPHj0AAE5OTggODkZcXBwCAgL0qiMiIqKmzd3dE//97zacOZOE558fLI7n5GQjOfl3TJwYpBbwBEHA7t3fIz7+B/z555+oqChHu3bt4eMzGoGBk2FkZFTjupKTf0dU1DpcuJAMAHB07IspU6bh6acdG+4FNjCDn4N37do1ABADmTbx8fFQKpVqNW5ubujWrRvi4+P1riMiIqKm7ZlnnNGyZUv89NMxtfETJ47BzMwc/furH5Zev34tPvlkKbp27Y5//3sWXn99OuRyU6xbtwb79tWcAc6cOYWwsNdRVFSIKVPewOTJIcjISEdY2Os4f/7XBnltjcHgAe/q1aqTJKtDWXFxsdr0vLw8pKWlwcHBQWNeBwcHJCcn61VHRERETZ9MJoObmzt+/vkEKisrxfHjx4/guecGqZ12VV5eju+/34GhQ73x7ruL8K9/vYiXX34VX3zxNeRyOY4ePax1HZWVlfj440j06eOAdes2IiDgFbz6ahCio79F27a2+Oyzjxv8dTaUJhHwLC0tERkZCRcXF7i4uGDYsGHiHreMjAwAgK2trca8CoUChYWFKCgo0LmOiIiIngzu7h7IycnGhQtVF2IWFRXil1/OYPDgIWp1JiYm+OGHA3j77XfVxnNzc2FhYYmSkhKty79yJQV37tyGu7snCgoKkJubi9zcXJSWlmLQIHdcvXoFmZkZDfPiGpjBz8G7du0aioqKUFBQgOXLlyM/Px+bN2/G7NmzUVZWhi5dugAAzM3NNeY1NTUFULXXr6ioSKc6KyurGntp1coCJiayOr8mkh6FoubPDZEu+BmihnTP0A38jT6f97/Xmpk1E8d9fIZj8WJznDt3Cl5ezyMp6TiMjY0xevQIWFpaivUKhRUqKy1x8OBBHD58GDdu3MBff/2FvLw8AICJibG4HpnMGHK5CRQKK5w5U/XOffnl5/jyy8+19qdSFUCh6KnfG9AEGDzgBQQEoLKyEoGBgeLYCy+8AF9fX3z88cfibVJqY2xsrLb7tra62uTkFNc6nf65srK495cen0Jhxc8Q/aPo+nnXtm08eFCmtgxXVyUOHDiIyZOn4scf/wdXVyWKiytRXFwg1mdm5uP99xfg0KH9eOYZZzz1lAN8fPzg7NwPb775BlSqcnF5FRWV4s+5uVU7h0JD34CDQ1+tPVpbt22y229tQdrgAW/ChAkaY2ZmZvDz88OaNWvEhF5aWqpRVz1maWmpcx0RERE9OdzdPbFkyfu4fv0aTp1KxMyZczRqzp//FYcO7UdQUChCQ98Qx8vLy5Gfn4cOHTpqXXb79h0AABYWFhgwYKDatEuXLiA/P188CvikMfg5eDWpvjFx9XHzrKwsjZrMzExYW1vDwsICHTp00KmOiIiInhyDBrlDJpNhzZrPUVr6QO2WKdWqD8V27dpNbXzPnjg8ePAAFRUVWpf91FNPo3XrNoiN3aF2kWdRUSEWLpyPJUveh0z2ZJ66ZdA9eBkZGQgJCcGoUaMQFhamNu3GjRsAADs7O9jZ2eHChQsa81+8eBGOjlX3qLG2ttapjoiIiJ4cLVq0RN++TkhKOol+/VzRokVLjZq+fZ+BpaUlVq9egYyMdDRvboVz584iIeEg5HJTjTt0VDMxMcGsWfOwcOF8hIS8itGj/SCXm2LPnl1IT7+LhQs/gImJwQ92PhaD7sGztbVFQUEBYmNjUVhYKI7fvXsXO3fuxMCBA6FQKODt7Y2TJ08iNTVVrElMTMSNGzfg4+MjjulaR0RERE+OwYM9AQAeHkO0TrexaY2PP/4cHTrYYdOmaHz99RfIyEjHokVL8OKL4/Dnn9eRnX1f67yenkOxYsUatG3bFps2RSMqai0sLS2xdOkKDB8+sqFeUoMzEgRBMGQDhw4dwowZM9CrVy/4+/ujqKgIMTExKCsrw7Zt29CjRw9kZ2fD19cXMpkMISEhKC0tRVRUFDp37ozt27eL98LRta4mjXUSZcjShEZZD9WfDRFehm6BnmC8yIJIO24bdVPbRRYGD3hAVcj76quvcPnyZZiZmUGpVGL27NlqT6S4fv06IiMjcfbsWZiZmcHDwwPh4eHiuXr61mnDgEc1YcCjuuCXGJF23DbqpskHvKaCAY9qwoBHdcEvMSLtuG3UTW0Br8leRUtEREREj4cBj4iIiEhiGPCIiIiIJIYBj4iIiEhiGPCIiIiIJIYBj4iIiEhiGPCIiIiIJIYBj4iIiEhiGPCIiIiIJIYBj4iIiEhiGPCIiIiIJIYBj4iIiEhiGPCIiIiIJIYBj4iIiEhiGPCIiIiIJIYBj4iIiEhiGPCIiIiIJIYBj4iIiEhiGPCIiIiIJIYBj4iIiEhiGPCIiIiIJIYBj4iIiEhiGPCIiIiIJIYBj4iIiEhiGPCIiIiIJIYBj4iIiEhiGPCIiIiIJIYBj4iIiEhiGPCIiIiIJKZJBbzLly/D0dERq1evVhtPS0tDWFgYlEollEolwsPDkZ2drTG/rnVEREREUmZi6AaqlZeXY/78+SgrK1Mbz8nJweTJk6FSqRAaGoqKigpER0cjJSUFsbGxkMvletURERERSV2TCXhfffUVrl69qjG+adMmpKenY8+ePejRowcAwMnJCcHBwYiLi0NAQIBedURERERS1yQO0aakpGDt2rWYPn26xrT4+HgolUoxtAGAm5sbunXrhvj4eL3riIiIiKTO4AGv+tCsm5sb/vWvf6lNy8vLQ1paGhwcHDTmc3BwQHJysl51RERERP8EBj9Eu379evz111/48ssvUV5erjYtIyMDAGBra6sxn0KhQGFhIQoKCnSus7KyaoBXQERERNS0GDTgXb16FV988QUWLlyIdu3a4datW2rTi4qKAADm5uYa85qamgIAiouLda57VMBr1coCJiYy/V8ISZ5CwT8OqG74GSLSjttGwzBYwKuoqMD8+fPRv3//Gi+AqKysfORyjI2Nda57lJyc4kfW0D9TVlaBoVugJ5hCYcXPEJEW3DbqprZwbLCAFx0djcuXL2Pr1q3ivery8/MBACUlJcjOzoalpSUAoLS0VGP+6jFLS0ud64iIiIj+CQwW8E6cOIGysjL4+/trTIuOjkZ0dDTi4uIAAFlZWRo1mZmZsLa2hoWFBTp06KBTHREREdE/gcEC3ttvvy3usat27949zJs3D35+fhgzZgy6d+8OOzs7XLhwQWP+ixcvwtHREQBgbW2tUx0RERHRP4HBAp620FV9kUWnTp3g5uYGAPD29sbmzZuRmpoq3uMuMTERN27cwGuvvSbOq2sdERERkdQZ/DYpjzJlyhTs3r0bQUFBCAkJQWlpKaKiouDg4AA/Pz+964iIiIikzuA3On4UGxsbfPvtt3jqqaewatUqfPPNNxg2bBiioqLUni+rax0RERGR1BkJgiAYuommorEu1Q5ZmtAo66H6syHCy9At0BOMt4Ig0o7bRt3UdpuUJr8Hj4iIiIj0w4BHREREJDEMeEREREQSw4BHREREJDEMeEREREQSw4BHREREJDEMeEREREQSo1fAi4uLw+XLl2utOXfuHL788ss6NUVEREREj0+vgBcREYHDhw/XWnPw4EF89dVXdWqKiIiIiB5frc+i3bVrF44ePao29r///Q9XrlzRWl9eXo7ExES0bNmy3hokIiIiIv3UGvAGDRqEDz/8EEVFRQAAIyMjXLt2DdeuXatxHrlcjjfffLN+uyQiIiIindUa8Nq2bYuDBw+ipKQEgiBg2LBhmDx5MiZNmqRRa2RkBJlMBhsbGzRr1qzBGiYiIiKi2tUa8ADAxsZG/P+RkZHo06cPOnbs2KBNEREREdHje2TAe9iLL77YUH0QERERUT3RK+ABQEJCAnbs2IGbN2+irKwMgiBo1BgZGeHQoUP10iARERER6UevgLdr1y688847EAQBZmZmsLS0hJGRUUP1RkRERESPQa+At3HjRlhaWmLNmjV49tlnG6onIiIiIqoDvW50/Oeff2L06NEMd0RERERNmF4B7+EraomIiIioadIr4Pn4+ODgwYPIz89vqH6IiIiIqI70OgcvICAAp06dwrhx4+Dv74+uXbtCLpdrrfXw8KiXBomIiIhIP3oFvJEjR8LIyAiCIGDFihVaawRBgJGRES5dulQvDRIRERGRfvQKeDNmzOBtUYiIiIiaOL0C3r///e+G6oOIiIiI6oleF1kQERERUdOn1x68oUOH6lTHR5URERERGY5eAe/Bgwdaz8ErLi5GcXExAKBnz55o165d/XRHRERERHrTK+D9/PPPNU67d+8e1qxZg/379+OLL76oc2NERERE9Hjq7Ry8Nm3aYNGiRejSpQuWL19eX4slIiIiIj3V+0UWrq6uOH36tF7znDx5EhMmTICLiwvc3d3x0UcfoaioSK0mLS0NYWFhUCqVUCqVCA8PR3Z2tsaydK0jIiIikiq9DtHq4sqVK3rVnzp1CiEhIXBwcMDcuXNx9+5dbN68GcnJyYiJiYGxsTFycnIwefJkqFQqhIaGoqKiAtHR0UhJSUFsbKz4NA1d64iIiIikTK+Ad+zYMa3jgiCguLgYR48exYkTJ3S+2hYAli9fjvbt2+Pbb7+FmZkZAKB9+/ZYvHgxTpw4AQ8PD2zatAnp6enYs2cPevToAQBwcnJCcHAw4uLiEBAQAAA61xERERFJmV4Bb+rUqbU+yUIQBLRt2xbz5s3TaXmlpaVo1aoVvL29xXAHAEqlEgCQkpICDw8PxMfHQ6lUiqENANzc3NCtWzfEx8eLwU3XOiIiIiIpq7dHlcnlcnTv3h0eHh5o1qyZTsszNTVFdHS0xnj1c2w7dOiAvLw8pKWlYcSIERp1Dg4OOHr0KADoXEdEREQkdU3qUWW3b9/G6dOnsWzZMtjb22P48OH466+/AAC2trYa9QqFAoWFhSgoKEBGRoZOdVZWVg36GoiIiIgM7bEushAEAWfOnEFKSgpKSkrQsmVL9OzZE/369XvsRnJzc+Hl5QUAMDc3x4IFC2BqaipeTWtubq4xj6mpKYCqGy3rWseAR0RERFKnd8A7f/48wsPDcfPmTQiCII4bGRmhU6dOWL58OZydnfVuxMjICCtXroRKpcKWLVsQHByMFStWQKFQPHJeY2NjVFZW6lRXm1atLGBiItO5Z/rnUCj4hwHVDT9DRNpx22gYegW869evIzg4GA8ePMDo0aPRv39/tG3bFnl5eThz5gx++OEHTJkyBd999x26dOmiVyMtWrSAj48PAGDkyJHw9fXF0qVLsW7dOgBVF2T8XfWYpaUlLC0tdaqrTU5OsV490z9HVlaBoVugJ5hCYcXPEJEW3DbqprZwrFfAW7NmDVQqFTZs2IBnn31WbdqYMWPg6+uL0NBQrFu3DpGRkY/XLQAzMzN4enpiy5YtaNu2LQAgKytLoy4zMxPW1tawsLBAhw4ddKojIiIikjq9nmRx6tQpeHl5aYS7as899xyGDh1a6zNrH5aamgovLy/ExMRoTCsqKoKRkRHkcjns7Oxw4cIFjZqLFy/C0dERAGBtba1THREREZHU6RXwCgoKxD1lNWnfvj1yc3N1Wl6XLl1QUFCA7du3Q6VSieO3b9/GgQMHMGDAADRv3hze3t44efIkUlNTxZrExETcuHFDPKwLQOc6IiIiIinT6xBtx44dkZSUBEEQtN4Pr7KyEmfOnEH79u11W7mJCRYsWIDw8HBMnDgR//rXv5CTk4OYmBgYGRnhP//5DwBgypQp2L17N4KCghASEoLS0lJERUXBwcEBfn5+4vJ0rSMiIiKSMr324Pn6+uLixYtYvHixxsUM+fn5WLhwIS5dugRfX1+dl+nn54eVK1eirKwMkZGR2Lx5MwYMGIDY2FjY29sDAGxsbPDtt9/iqaeewqpVq/DNN99g2LBhiIqKUnu+rK51RERERFJmJDx8r5NHUKlUmDRpEn777Tc0b94cDg4OaN68OTIzM5Gamori4mI888wz2LJli3jvuSdJY13JE7I0oVHWQ/VnQ4SXoVugJxivFCTSjttG3dTbVbRyuRzffPMN1q9fj7i4OJw+fVqcZmdnh5CQELz++uvcW0ZERERkQHrf6NjU1BRhYWEICwtDUVERCgsLYWlpiebNmzdEf0RERESkJ53PwVOpVGpXugJVNw62tbXFL7/8gsLCwnpvjoiIiIj0p1PA27hxI7y8vHD8+HGNaYWFhZgxYwY8PT2xfv36em+QiIiIiPTzyIC3aNEiLFu2DLm5ucjJydGYXlRUhCFDhqCsrAwrVqwQb21CRERERIZRa8Dbt28ftm/fjr59++LgwYPw9/fXqLG1tcXq1auxZ88e9OzZE9999x2OHDnSYA0TERERUe1qDXg7duyAtbU1oqOjH3nz4s6dO2Pt2rWQy+XYtm1bvTZJRERERLqrNeBdvHgRXl5esLa21mlhdnZ28PDwwPnz5+ulOSIiIiLSX60B78GDB1AoFHotsHPnzigpKalTU0RERET0+GoNeO3atcPdu3f1WmBmZibatm1bp6aIiIiI6PHVGvCcnZ1x/Phxne9xV1RUhCNHjqBnz5710hwRERER6a/WgDdhwgTk5+fjnXfeQUVFRa0LEgQB8+fPR2FhIcaPH1+vTRIRERGR7h65By8oKAgHDhzAuHHjsHfvXmRnZ6vVZGdn48cff8SYMWNw4MAB+Pj4YMiQIQ3aNBERERHV7JHPop03bx7kcjmio6MxZ84cAICVlRUsLCyQn58vXlAhk8kwadIkhIeHN2zHRERERFQrI0EQBF0KU1NTsWvXLiQmJiI9PR0FBQVo2bIl7OzsMGjQIPj6+qJr164N3G7DysoqaJT13HNXNsp6qP60OZFk6BboCaZQWDXa7xeiJwm3jbpRKKxqnPbIPXjVevTogblz59ZLQ0RERETUcB75LFoiIiIierIw4BERERFJDAMeERERkcQw4BERERFJDAMeERERkcQw4BERERFJDAMeERERkcQw4BERERFJDAMeERERkcQw4BERERFJDAMeERERkcQw4BERERFJDAMeERERkcQ0iYB34sQJvPLKK3BycoKLiwuCgoLw22+/qdWkpaUhLCwMSqUSSqUS4eHhyM7O1liWrnUmIQPBAAAgAElEQVREREREUmVi6AaSkpIwZcoU9OrVC7NmzUJ5eTm2bt2KV199FVu3bsUzzzyDnJwcTJ48GSqVCqGhoaioqEB0dDRSUlIQGxsLuVwOADrXEREREUmZwQPekiVL0L59e/z3v/+Fubk5AGDMmDHw8fHBypUrsXHjRmzatAnp6enYs2cPevToAQBwcnJCcHAw4uLiEBAQAAA61xERERFJmUEP0ebl5eHy5csYOXKkGO4AoE2bNhgwYAB+/fVXAEB8fDyUSqUY2gDAzc0N3bp1Q3x8vDimax0RERGRlBk04DVv3hz79u1DUFCQxrScnBzIZDLk5eUhLS0NDg4OGjUODg5ITk4GAJ3riIiIiKTOoAFPJpOha9eusLW1VRu/fPkyzp07BxcXF2RkZACARg0AKBQKFBYWoqCgQOc6IiIiIqlrElfRPqyoqAhvv/02AOD1119HUVERAKgdwq1mamoKACguLta5joiIiEjqDH6RxcNKSkowbdo0XL58GVOnToVSqcQvv/zyyPmMjY1RWVmpU11tWrWygImJTOd+H9e9Bl8D1TeFwsrQLdATjp8hIu24bTSMJhPw8vPzMXXqVJw7dw4vvfQSZs2aBQCwtLQEAJSWlmrMUz1maWmpc11tcnK4h4+0y8ri4X16fAqFFT9DRFpw26ib2sJxkzhEe//+fUyaNAnnzp3D+PHj8dFHH8HIyAgA0KFDBwBAVlaWxnyZmZmwtraGhYWFznVEREREUmfwPXiFhYV47bXXcOnSJQQFBWH+/Plq062trWFnZ4cLFy5ozHvx4kU4OjrqVUdEREQkdQbfg7d48WJcunQJkyZN0gh31by9vXHy5EmkpqaKY4mJibhx4wZ8fHz0riMiIiKSMiNBEARDrTw1NRU+Pj6wsrLCO++8A5lM8wIHPz8/ZGdnw9fXFzKZDCEhISgtLUVUVBQ6d+6M7du3i48g07WuJo11HsA9d2WjrIfqT5sTSYZugZ5gPM+ISDtuG3VT2zl4Bg1427Ztw6JFi2qtSUlJAQBcv34dkZGROHv2LMzMzODh4YHw8HDY2Nio1etapw0DHtWEAY/qgl9iRNpx26ibJhvwmhoGPKoJAx7VBb/EiLTjtlE3tQU8g19kQUQEACFLEwzdAj2GDRFehm6BiLQw+EUWRERERFS/GPCIiIiIJIYBj4iIiEhiGPCIiIiIJIYBj4iIiEhiGPCIiIiIJIYBj4iIiEhiGPCIiIiIJIYBj4iIiEhiGPCIiIiIJIYBj4iIiEhiGPCIiIiIJIYBj4iIiEhiGPCIiIiIJIYBj4iIiEhiGPCIiIiIJIYBj4iIiEhiGPCIiIiIJIYBj4iIiEhiGPCIiIiIJIYBj4iIiEhiGPCIiIiIJIYBj4iIiEhiGPCIiIiIJIYBj4iIiEhiGPCIiIiIJIYBj4iIiEhiGPCIiIiIJKbJBbwFCxZg4sSJGuNpaWkICwuDUqmEUqlEeHg4srOzH7uOiIiISKpMDN3Aw2JjYxEbGwulUqk2npOTg8mTJ0OlUiE0NBQVFRWIjo5GSkoKYmNjIZfL9aojIiIikrImEfAqKiqwdu1arFmzRuv0TZs2IT09HXv27EGPHj0AAE5OTggODkZcXBwCAgL0qiMiIiKSMoMfoi0tLcWLL76I1atXw8/PD7a2tho18fHxUCqVYmgDADc3N3Tr1g3x8fF61xERERFJmcH34JWWlqKwsBArV66Ej48PvLy81Kbn5eUhLS0NI0aM0JjXwcEBR48e1auOiJqm5fERhm6BHkdEkqE7ICItDB7wmjdvjgMHDsDERHsrGRkZAKB1z55CoUBhYSEKCgp0rrOysqrH7omIiIiaHoMfojU2Nq4x3AFAUVERAMDc3FxjmqmpKQCguLhY5zoiIiIiqTP4HrxHqaysfGSNsbGxznW1adXKAiYmMp17e1z3GnwNVN8UCu75bWjcLp5M3DaorvgZahhNPuBZWloCqDpX7++qxywtLXWuq01ODvfwkXZZWQWGboGoSeK2QXWhUFjxM1QHtYVjgx+ifZQOHToAALKysjSmZWZmwtraGhYWFjrXEREREUldkw941tbWsLOzw4ULFzSmXbx4EY6OjnrVEREREUldkw94AODt7Y2TJ08iNTVVHEtMTMSNGzfg4+Ojdx0RERGRlDX5c/AAYMqUKdi9ezeCgoIQEhKC0tJSREVFwcHBAX5+fnrXEREREUnZE7EHz8bGBt9++y2eeuoprFq1Ct988w2GDRuGqKgotefL6lpHREREJGVGgiAIhm6iqWisK3nuuSsbZT1Uf9qc4N36Gxq3iycTtw2qC15FWzdP9FW0RERERKQfBjwiIiIiiWHAIyIiIpKYJ+IqWiIion+qkKUJhm6BHsOGCC+Drp978IiIiIgkhgGPiIiISGIY8IiIiIgkhgGPiIiISGIY8IiIiIgkhgGPiIiISGIY8IiIiIgkhgGPiIiISGIY8IiIiIgkhgGPiIiISGIY8IiIiIgkhs+iJSIiasKWx0cYugV6HBFJBl099+ARERERSQwDHhEREZHEMOARERERSQwDHhEREZHEMOARERERSQwDHhEREZHEMOARERERSQwDHhEREZHEMOARERERSQwDHhEREZHEMOARERERSQwDHhEREZHEMOARERERSYwkA15aWhrCwsKgVCqhVCoRHh6O7OxsQ7dFRERE1ChMDN1AfcvJycHkyZOhUqkQGhqKiooKREdHIyUlBbGxsZDL5YZukYiIiKhBSS7gbdq0Cenp6dizZw969OgBAHByckJwcDDi4uIQEBBg4A6JiIiIGpbkDtHGx8dDqVSK4Q4A3Nzc0K1bN8THxxuwMyIiIqLGIamAl5eXh7S0NDg4OGhMc3BwQHJysgG6IiIiImpckgp4GRkZAABbW1uNaQqFAoWFhSgoKGjstoiIiIgalaQCXlFREQDA3NxcY5qpqSkAoLi4uFF7IiIiImpskrrIorKy8pE1xsY1Z1qFwqo+26l5PZcvNcp6iJ4k3C6ItOO2QY9DUnvwLC0tAQClpaUa06rHqmuIiIiIpEpSAa9Dhw4AgKysLI1pmZmZsLa2hoWFRWO3RURERNSoJBXwrK2tYWdnhwsXLmhMu3jxIhwdHQ3QFREREVHjklTAAwBvb2+cPHkSqamp4lhiYiJu3LgBHx8fA3ZGRERE1DiMBEEQDN1EfcrOzoavry9kMhlCQkJQWlqKqKgodO7cGdu3b+ejyoiIiEjyJBfwAOD69euIjIzE2bNnYWZmBg8PD4SHh8PGxsbQrRERERE1OEkGPCIioifZzJkzsW/fPixatAgTJkzQWrN9+3a89957mDhxIhYsWNDIHf5zTZgwAffu3cPBgwcN3UqtJHcOXmOIiIhA7969ERMTo3X6rVu30Lt3b6xevbqRO6ub+/fv1+uNoAsLC5GdnV0vy6p+z2v6uTEZct2NaebMmejduze2bdtWY8327dvRu3dvfPjhh43YmaaKigrExMTA398fLi4ucHZ2hq+vLz777DMUFhYatLf6NmHCBAwfPrxel1mf26q+5s6di6efftog627K3nnnHTRv3hwrV67U+m+TnZ2NlStXon379pg1a5YBOqSmjgGvDlauXIl79+4Zuo16cezYMYwcObLefsknJydj1KhRuHr1ar0sjxrfk/QFM3fuXHz00Ufo0qULZs+ejXnz5qFv375Yv349xo0bh7y8PIP215T9/vvvGDlyJK5fv27oVughtra2mDlzJvLy8vDxxx9rTF++fDlyc3Px3nvv8f6upBUDXh0UFBQgMjLS0G3Ui99//x35+fn1trwrV64gMzOz3pZHje9J+YI5c+YM9u7di4iICHzyySeYOHEiAgMDERkZiWXLluHGjRvYsGGDwfpr6lJSUrTeO5QMLzAwEA4ODti1axd++eUXcfzs2bPYtWsXfHx8MGTIEAN2SE0ZA14deHl54ccff8TJkycN3QpRg3gSvmB+/fVXAMCgQYM0pvn6+qJNmzZiDdGTRCaT4f3334eRkRE++OADVFZWoqKiAu+//z5atGiBd999V2Oes2fPYvLkyXBxcYGLiwtee+01/PHHH2o1OTk5ePvtt+Hh4QFHR0cMHz4cK1euhEql0qu/tWvXonfv3rh8+bLauCAI8PT0REhIiDh25coVTJ8+Ha6urnBycsKECRPw888/q803YcIETJ06FZ988gmcnZ3h5uaGmJgY9O7dGz/99JPG+seOHYuXX365xv60Le/atWs1nuagbfynn37C+PHj4ezsjOHDh2Pfvn1a16XL62tsDHh1sGDBApibm2PRokU6bRhnz55FUFCQuOFNmjQJZ86ceax1e3l5YeHChdi9ezdeeOEF9O3bF97e3lrPC3zUeiMiIrBmzRoAwNChQzFx4sRa171v3z68+uqr6N+/PxwdHeHl5YXly5eL78Hq1asxf/58AMCkSZPg5eVV6/JOnjyJ0NBQDBw4EA4ODnB3d8fChQvrvEcxIiICI0eORExMDAYMGIABAwbg+PHjNZ5Dp208OTkZISEhcHFxgbu7OzZv3qx1Xenp6QgPD8ezzz6Lvn37YsyYMfjhhx/q1H9T0NS/YID/e/xgbGys1udRHzlyROPfLS0tDXPmzBH/vfz8/PDdd9+p1cydOxd+fn44c+YMAgIC8Mwzz2D48OHYvXs3VCoVli9fDjc3NyiVSsyePRu5ublq8z/qF/7UqVPx7LPP4uHr3A4ePIjevXtrHBmYOnUqRo8erTZ2/PhxjB07Fn379sWQIUOwbt06jde/d+9eBAYGitvq0KFD8emnn4rv88qVK8WT8wMDA2s9t2/u3Lnw9fXFli1b4OrqCqVSiZ9//rnGc+i0jf/+++/i76LBgwfXeB7znTt3MHfuXPHf58UXX0R8fHyNvUlZ37598fLLL+PSpUuIi4vD9u3bceXKFbz99tto06aNWu3x48cRFBSE4uJizJw5E9OmTcOtW7cQGBio9kfOm2++iePHj2P8+PF477334OrqinXr1mHJkiV69ebr6wsA+N///qc2fu7cOdy9e1f8zF66dAnjx4/HjRs38MYbb2DWrFkoLS1FaGioRmBKSkrC/v37ER4ejhdffBEjRoyAiYmJxjr++usvXLhwAS+88EKtPf59ed27d9f59Z04cQKvv/46iouL8dZbb2HEiBGYP38+UlJS1Or0eX2NycRga5aAjh07Yvr06fj000/x9ddfIywsrMbaw4cPIywsDJ07d8a0adMAVH0hBQUFYdWqVRg6dKje6z9x4oQYttq0aYMdO3Zg8eLFsLOzg4eHh87rHT9+PAoLC3Hw4EHMnz8fvXr1qnGdsbGxWLBgAby8vDB37lyUlZXh4MGDiI6OhoWFBcLCwjB8+HBkZWVhx44deOONN9C3b98al/fTTz9hypQp6NevH958800YGRnh559/xo4dO1BWVlbnQ+B3797FF198gbCwMGRmZsLJyQl79+7Vad6rV69i4sSJsLa2xvTp01FWVoYvvvgCFRUVanUZGRnw9/eHIAiYOHEiWrRogcOHD2PevHnIzMxEaGhonV6DoVV/wWzduhVxcXEoKSnBlStXsGTJEq1fMNOnT0efPn0wc+ZMqFQqfP/99wgMDMQ333wDFxcXAFVfMNeuXcPEiROhUChw7tw5rFu3Dnl5eVi0aJFe/Xl7e2PlypXYuHEjDh06BG9vbzz33HPo378/LCwsNO59efPmTQQEBKCsrEzcdvbv3493330XN2/exOzZs8Xa9PR0TJ8+HePHj4efnx82bdqEiIgIxMXFobi4GDNmzMDVq1exbds2WFhYiBebXLp0Ca+88gratWuHN954AyYmJvjhhx8QGhqKlStXYuTIkRg8eDCOHj2KlJQUPPXUUwCA06dPA6gKydVUKhWSkpLw6quvqvX11ltvYcKECfD398fu3buxcuVKNG/eXKzbtm0bFi1ahGHDhmHevHlQqVTYv38/vv76a1hYWGDatGkYNWoU7t27h++++w7Tp0+Hg4NDre/1rVu3sG7dOrz55pvIyMiAk5MTdu3apdO/0+XLlzFp0iS0bNkSM2bMQGlpKVatWqWxPaWnpyMgIADGxsaYNGkSrKyscOjQIcyePRtZWVkICgrSaX1SMnv2bBw8eBCfffYZysvLMXDgQLz00ktqNRUVFVi0aBGcnZ2xefNmGBtX7b8JDAyEn58fPvzwQ3z//ffIyMhAUlIS5s+fL76X/v7+qKioQFpaml59derUCS4uLti3b5/aebj/+9//YGZmJv7BsHjxYrRt2xY7d+6Eubm52NfEiRPx4YcfYujQoWjWrBkAoLi4GJGRkXB1dRWX5+bmhkOHDuH999+HiUlVbPnxxx8hk8kwatSoWnvUtjxdffLJJ2jXrh22bduG5s2bi70EBwejdevWYp0+r69RCaS3t99+W7C3txcEQRBUKpXwwgsvCH379hX+/PNPQRAEIS0tTbC3txdWrVolCIIglJWVCYMHDxY8PDyEgoICcTl5eXmCu7u74O7uLqhUKr16GDJkiNC7d2/h0qVL4lhmZqbQu3dvYfbs2Xqvd9WqVYK9vb2QlpZW63pHjhwpjB8/XqisrBTHqtfj6+srjn3//feCvb29cOrUqVqX99prrwlDhgwRSktL1cYDAgIEFxcX8eeH33NtP2tTXfP9999rHa+pvtq///1vwdnZWbhz5444du3aNcHR0VGjF6VSKWRkZKgtb/bs2YKjo6Nw7969Wvt8EuTn5wuDBg0S3N3dheeee06YOHGiRk15ebkwZMgQITAwUKioqBDHCwsLhaFDhwpjx44VBEEQ0tPTBXt7e2Hjxo1q88+bN08ICQl5rP7OnTsnDBkyRLC3txf/c3R0FN544w3hjz/+UKv997//LfTp00dt2ykvLxdCQ0OF3r17C6mpqYIgCMKcOXMEe3t7YevWrWLdoUOHBHt7e8HLy0vtM+vv7y94enqKP7/88suCt7e3UFxcLI6pVCph/PjxwqBBgwSVSiXcvHlT433w9fUV3N3dhT59+ojbbGJiomBvby+cOXNGXLa9vb1w+PBhcb78/HzB2dlZ7d9l+PDhwiuvvKL22lUqlTBo0CBhzJgx4th///tfteXXpPr9iIuL0xjv06eP1vqHx6dNmyb069dPSE9PF8euXLkiODg4qNXNmTNHGDhwoJCVlSWOVVZWCjNnzhT69u0r3L9/v9Y+pWrPnj2Cvb292nfNw3777Tfx83T//n21/z744APB3t5eyMzMFEpKSgQnJydh2LBhwoEDB9Q+o4/j22+/Fezt7cXtqaKiQhg0aJAwc+ZMQRAEISsrS7C3txeWLFmi0VdUVJRgb28v/Pbbb4IgVH22nZ2d1b5fBEEQ4uLiBHt7e+HYsWPi2AsvvCAEBwfX2ltNy3v55ZeFYcOGaa2vHq/+PbVixQqNOh8fH7FOn9fX2HiIto6aNWsmHqJdvHix1pqLFy8iPT0dgYGB4l8BQNWzc1999VVkZGQgOTlZ73V369ZN/MsfABQKBdq0aSNe2dsQ6/3hhx/w9ddfw8jISBy7f/8+rK2tH+sWK1999RW+//57tb0sOTk5aN68eb3dsuX555/Xe57KykqcOHECHh4eaN++vTjeo0cPteVVVlbi0KFDcHV1hYmJCbKzs8X/vL29oVKpDH4eRn2wsrJCREQEMjIyUFhYiA8++ECjJjk5Gbdv38awYcOQm5srvg+lpaXw9PREcnIysrKy0KJFC5ibmyMmJgYHDx5ESUkJgKqLNqKjox+rPxcXF+zfvx/r1q1DQEAAOnbsCJVKhYSEBAQEBIh7bcvLy3H8+HEMHjxYbduRyWSYOnUqBEFAQkKC2rIfPmzZtWtXAICnp6faZ9bOzk68UOHevXs4d+4cPD09UVJSIr4PBQUF4t7tixcvolOnTujWrRtOnToFoOqq5KtXr2Ly5MmoqKjAb7/9BqBqT32LFi3EvZ9A1WHph899tLKyQrdu3dSu6v/xxx+xdu1atdeSnZ2NFi1a1Gnbcnd313ue8vJyJCYmwtPTE7a2tuJ4r1694ObmJv5cUVGBw4cPQ6lUwtjYWHzvcnJy4O3tjdLSUvH9+qepPhzq5OSELl26aEy/efMmACAyMhLPPfec2n9btmwBUHVEw8zMDIsWLUJmZibCwsIwcOBAvPbaa4iNjX2sUyRGjRqldgg1KSkJWVlZ4uHZ6r42bdqk0dfy5csBVB2Sr9aqVSu17xcAGDZsGMzNzcXDnSkpKbh69ar4ntRG2/J0Ud1Tp06dNKY9fJhX39fXmHiIth64urrixRdfxM6dOxEfHw8nJye16bdu3QJQFcj+rvqDcufOHbVf4LrQ9mQOuVwunofTEOtt1qwZzpw5gx9//BHXr1/HzZs3cf/+fQBVh6z1JZPJkJaWhs8//xzXrl3DzZs3kZGRofdyavPwrnRd5ebmori4GJ07d9aY1r17dzEE5OTkoKCgAIcOHcKhQ4e0Luvu3bt6r78p8vX1xZw5c3T6gqnp0Prdu3ehUCiwaNEivPfeewgLC4OpqSkGDBiAkSNHws/P77EfJ9isWTMMGTJEDD6pqamIiYlBTEwMFi9ejGHDhiEnJwclJSVat4kePXoAUP9lbGRkpLadVR8e+vu2Z2xsLG53D//C37Rpk9Ze79y5AycnJwwePBg7d+5ERUUFkpKSYGJigvHjx+PLL7/EmTNn8Pzzz+Onn36Cu7s7ZDKZOL+2Ly1TU1MUFBSIP8vlciQlJWHv3r0a26q2z7UujIyM0KpVK73ny87ORklJSY3bU/UJ9Pfu3UNxcTH279+P/fv3a12Wob4sm7rqQ92zZ8+u8bSY6s/9mDFj4OHhgUOHDuHYsWM4efIkfvrpJ2zduhU7duzQaxu0sbHBoEGDxMO0e/fuRYsWLcQ/BKq3i4kTJ9Z4PvbDpwU9/DmvZmlpCS8vLxw+fBhlZWXYu3cv5HK5TveD1La8mjx8Dmv19lVaWlprnb6vrzEx4NWTefPmISEhAZGRkYiKilKbJtTysJDqaY9zfL76HItHLbs+11t9vuHTTz8NZ2dn+Pn5wcXFBR988MFjBZnqO7F369YNrq6u8Pb2hpOTE7Zs2YI9e/bovTxtdN3A/34uEPDojbt6nhEjRtR4NZe2vwClyFBfMKtXr0aHDh00zknq0aMHFi5cCJVKhdjYWFy/fh0tW7ascTnatgljY2Ot21ltewT0+YU/ePBgfPPNN7hw4QJOnz4NR0dHNG/eHP3798cvv/yCrKwspKSk4LXXXlOb/1HbPgAsW7YMGzZsgIODA5ydnTFmzBi4uLjgvffeE4OevoyNjXXeG1KXL0sfHx/4+/trXe7jhlOps7OzA1AVhh7eKwpUXdySl5cHU1NTFBYW4vLly7C3t4e/vz/8/f2hUqmwbNkyfPvttzh58qR4DreuRo8ejblz5yIlJQUHDx7EyJEjxW24+g//Zs2aafR19epV3L59WzxvrTa+vr6Ij4/HL7/8goSEBHh6esLKykqvPqvJZDKteyuzsrLE7ws7OzsYGRnhzz//1Kh7+FzF+np9DYEBr57Y2Nhg7ty5WLBgAT777DO1adUfAG03Er1x4wYAoF27dvXeU32v9/bt2/j666/h5+cn7nqu9jg3fC4tLcXSpUsxcOBAbNiwQdw7AgCff/653svTVfWXo0qlUgsSD7+GVq1aoXnz5lo37uo9o0DVv7u5uTnKy8s1Nu47d+7g4sWLBtu4G5uhvmB27twJuVyOsWPHag0f1WHKzMwMrVu3hqmpqfj5f1j1dvLwIfnHoc8vfKVSCQsLC5w6dQpnz56Fp6cnAGDAgAFYvXo1EhISYGxsrPdh0bS0NGzYsAFjx47V2JualZWlU0DUlUwmQ0VFBSoqKtT+mHr43no2NjawsLB45JdlmzZtYGpqioqKCo337vbt27h06dI/ZnvS1zPPPIPWrVtj8+bNGDt2LCwsLABU3a915syZqKysREJCAi5fvozAwEC1iyzkcrl4yoI+e7yqDR06FBYWFuJN0R++4rt9+/bo06cPvv/+e4SEhEChUACo+v0bERGBa9eu4fjx449ch7u7O1q2bIkdO3bgypUrmDFjht59Vqu+ddK9e/fEC8XOnz+P27dvi39AtGnTBi4uLti9ezemTZsm7rU/e/YsUlJSxLr6en0Ngefg1aNx48ahX79+OHLkiNq4g4MDFAoFtm3bpvbYpMLCQmzduhUKhQKOjo713o8+663+hV/bXr/qpwH07NlTbfzYsWP4888/UV5eLo5VL0/bbSuqPXjwACUlJejatatauLt06RKSkpIAQG2Z9aV6A7x06ZI4lp6ernYbASMjIwwfPhwnTpzAlStXxPFbt27h6NGj4s8mJiYYPHgwjh07pnEvqKVLl2LGjBnIycmp99fQFD38BfPwOV7VXzALFiyATCYTv2B27twp1tTlC2b06NH4888/sX79eo1pDx48wO7du9GzZ0906dIFzZo1g7u7O44fP6727yUIAqKiomBkZKT33ou/e/gX/sMhp/oX/syZM8W9nXK5HAMHDsS+fftw9epVDBgwAEBV8CstLcX69evh5OSk9XSM2lR/5v6+rSYkJODWrVtqe6t12fZrU/0F+fD2dPv2bZw/f178WSaTYejQoTh27BhSU1PF8Zs3b+LEiRPiz9X/PgkJCWrbHQB89NFHmDFjhsbtaKiKXC7HggULkJaWhrFjx2L9+vX45ptvMGHCBNy9exdvv/02ZDIZ+vXrBxcXF3z66af48MMPERsbi88//xzLli1Dr1698OyzzwKoCui7d+/W+HfQxsLCAkOHDsWRI0fQvn17jStWFyxYgJKSEowdOxZffvklYmJiMGnSJCQnJ+PNN99EixYtHrmOZs2aYcSIEdi7d6/GOaj68vX1RXl5OUJDQ7Ft2zasXr0ar7/+usapJ/Pnz8eDBw8QEBCADRs2YPXq1U8LeWEAABVwSURBVJg6darGaQr18foaAvfg1SMjIyMsWrQIY8eOVQsmzZo1w3/+8x+89dZbeOmllzBu3DgAwHfffYfMzEysWrVK/CWblpaGc+fOoV+/fnU+tKfPequ/QKKiojB48GCtt23p2bMnOnTogHXr1qG0tBTt2rXD77//jl27dsHU1BRFRUVibfXytm3bhnv37mncwwsAWrRoAScnJ+zcuRPNmzdHt27dcPXqVcTGxop9FRUV1fvGMWrUKHz11VeYNWsWgoKCUFpaipiYGNja2qrtYZg5cyaOHj2KiRMnIigoCDKZDFu2bIGlpaXa7v25c+fi9OnTCAwMRGBgIDp06ICjR4/iyJEjGD9+vMHOv2hs1V8wc+bMwdixY/HSSy9BLpcjNjYWd+/exYoVKzS+YKqf23znzh1s2bJF4wsmMTERffr0gb29fY3rnTZtGpKSkvDpp5/iyJEj8PLygo2NDe7evYvdu3cjKysLmzZtEvfuzZ07V7ztSGBgIBQKBQ4cOIDTp08jNDRU6/l5+lqwYAGCg4MxduxYTJgwAS1atMCePXuQnJyM8PBwtc+0u7s7Fi9eLL43QNUfZxYWFkhLS9M49KyL3r17o127dli7di1KSkpga2uL8+fP17qtxsTEICMjQ6cT1x/2/9q797CoyjyA41/xVmhQlhqarmFBCCgCgqkbq45m4qi4Pd7AG6HpkyTarsm2/rEqXlqtRMWyHFk0Cdy8JCoo0rKMlLALrGGii1wqu4p3BIfLu3/wzIlxhotla+Lv8zz8wTvvnPOed848/HgvvxMYGMjWrVuJiIhgxowZVFRU8P777+Pk5GQxOhcREUFGRgYhISHMmDEDOzs74uLi6Nixo0XOS/PnM3XqVIKDg3FyciItLY309HSCg4O1tZLC2ujRo3F0dOTtt98mJiaG1q1b4+LiwjvvvKP942JnZ0dMTAybNm0iLS2NhIQEHB0dee6554iIiND+2f7vf//L4sWLWbBgQaPfPzO9Xs/+/fsJDAy0Gkn39fVl586dbNy4EYPBQE1NDY8//jivv/4648aNa/b1jR07loSEBEaMGEH79u1voWcs6XQ6li5dSlxcHFFRUTz++OMsX74co9Fo8eCCvn37sn37dtauXUt0dDQPPvggERER5OTkWGxQvF3Xd9vdkb27d7mmUnSsXr3aIk2KWWZmpgoJCVH9+vVTPj4+KjQ01Co1gTm9yM2pPW42dOhQFRIS0qzy5pz38uXLaubMmcrDw0ONGjWqwfOeOXNGhYaGKl9fX+Xj46OCgoLU+++/r/72t78pFxcXLSWFyWRSCxYsUH379lUDBgxQlZWVNo/39ddfq/DwcOXn56e8vLxUYGCgiomJUSkpKcrFxUUlJycrpX5emhRbDh06pMaMGaPc3d2VTqdTO3bs0La011dUVKTmzp2rvL291cCBA9W6devUunXrrOqVlJSoRYsWKX9/f+Xp6alGjx6ttm3bpqqrqxtt493GxcXF5n1Xn9FoVCEhIcrLy0v5+PioKVOmqH/84x8WdcrKytSyZcvU0KFDlYeHhxo8eLD685//bJFS5tixY8rFxUVt2rSpyXaZTCYVGxurJk2apPz8/JS7u7t65pln1JIlS2ymlCguLlYvv/yy8vPzU3379lVBQUFW3zlb6T9KSkpstslW3RMnTqg5c+YoHx8f5eXlpYKCgqxSjCiltHQp5jQyZqGhocrFxUWdPHnSorw5KR6UUqqgoEDNmjVL+fj4aN/V+Ph4ZTAYLNJa3LhxQ4WHhytPT0/l5+dnlbKosWs0O3DggPZ9GjFihIqPj1fvvPOOVf3CwkL14osvKm9vb/X000+rN998U61Zs8aqXnFxsYqIiNA+n8DAQBUbG9vivk+/du+99556991373QzNP/617+Ui4uLMhqNd7opd4VWSv3EcXnxi4mKiqJfv363/J+0EC3N1q1bUUrd9cmihbjbXLt2jenTpxMZGaktHbjT/vjHP5Kdna2tTRWNkx76lTl//jwff/zxL7ImT4i7ybVr12ymHRJC/PLKy8uZOnXqryK4i4yMZNq0aXz00UeEhoZKcNdMMoL3K3PmzBlKS0ubld9HiJbsu+++IyMjQ1s7KoS4N82ZM4fs7GzGjx+vbdYSTZMATwghhBCihZFxTiGEEEKIFkYCPCGEEEKIFkYCPCGEEEKIFkYCPCHuAbt378bV1ZUNGzY0WMecdHjatGn/l7bs2LHjFz1PQ44fP46rq6vVT79+/Rg5ciSrVq3Sntryc46/Zs2a29jqu8ud/oyFEPIkCyHE/5mbmxvz58+nb9++d7QdTz31FDqdDqh7TFdFRQUFBQXExsaSkZHBrl276NChwx1toxBC/FQS4Akh/q/c3Nxwc3O7083Azc2N8PBwq/KYmBjWr19PQkICoaGhd6BlQgjx88kUrRBC1GN+9mt2dvYdbokQQvx0EuAJIRp17do1NmzYgF6vp3///vTt25dRo0bx1ltvYTKZAMjPz8fV1ZXFixdbvb+mpobBgwdr06G21me5urry2muvkZ2dTXBwMF5eXvj7+/OHP/yB7777zuqYGRkZTJkyhf79+zNkyBBef/11MjMzcXV1Zffu3T/res0PW2/btq1FuclkIjY2lueffx5vb288PDwYNmwYK1as4MqVKzaPtWPHDnQ6HZ6enowfP549e/Zor5WXl+Pl5cXIkSNtvnfu3Ll4eno2eGyzs2fPsnDhQgYOHIiHhwejRo1i48aNVFZWWtQbNmwYM2fO5PTp04SFheHt7Y23tzdz587l7NmzTfaL+XP75JNPiI6OZsiQIfTv35/g4GCLB7Q3JjU1ldDQUPz9/XF3d2fQoEG8/PLLVue/1fuhqKhI6wNPT0/0ej1xcXHU1tY2q11CtEQyRSuEaFBVVRUzZszg5MmTBAQEEBAQwJUrV0hNTWXz5s2UlZWxfPlyPDw8cHZ2Ji0tDZPJRLt27bRjZGVlcf78eebNm9fouU6cOMG+ffsYMGAAwcHB5OTksH//fgoLC9m7d69W7+DBg7zyyis4ODig1+sBiI+PJyUl5bZc84cffgjAs88+a1EeERHB0aNH8fPzY/LkyVRWVpKens727dspKirCYDBY1N+/fz8XL14kMDCQDh06cOTIEZYsWUJZWRlhYWF06NABnU7H/v37OXHihMWaxMuXL2M0Ghk6dCgODg4NtjU3N5dZs2ZhMpkYPnw4Tk5OZGVlsWHDBoxGI3FxcRafxddff83UqVN54oknmDRpEoWFhXz88cfk5+eTlpZmUbchf/3rXykqKkKv11NbW0tKSgovvPAC69evb/QJPLGxsaxatYpevXoxduxY2rRpQ25uLikpKWRlZXHkyBEeeOABrX5z74fPPvuMmTNnUlVVxciRI+natSuffPIJUVFRnDx58p7e7CLubRLgCXEPMf/xt8XWSFFycjL5+fmEh4czf/58rTwiIoIRI0aQlJTE8uXLARgzZgzR0dFkZGQwfPhwre7BgwcBtGCsIWfOnCEyMpKZM2cCUFtby4wZM8jKytICoOvXr7N8+XIcHR35+9//zmOPPQbA1KlTb/mRZqdOnbLoi8rKSgoKCjAajUyaNInAwEDttZycHI4ePcqECRNYtWqVVn7jxg1Gjx7NsWPHuHDhAp06ddJe++GHH9iyZQsBAQEAzJs3jylTprB+/XrGjRtH586dGT9+PPv37+fAgQMWAV5ycjJVVVWMHTu2wfbX1NTw6quvUl1djcFgYODAgVr50qVL+fDDD9myZYvF51ZaWsr06dN57bXXtLLFixezb98+UlNTGT16dJP9dvr0aT744AM8PT0BCA0NZdKkSSxbtoyAgACbQaLJZCI6OponnniC3bt30759e+21V155haSkJDIzMy2C6ubcD0oplixZQk1NDbt27cLV1RWo2zTz6quvsnfvXkaOHGlxPwpxr5ApWiHuIVlZWWzcuNHmT1xcnFV9d3d3VqxYYZU6pVOnTjz55JNcv36dGzduAD8GcMnJyVq96upqDh8+TJ8+fejdu3ejbbO3tyc4OFj73c7Ojt/+9rcAfPHFF0Dd1OyFCxeYNm2aFtxB3Y7YCRMm3EpXUFBQYHH97733HkajkTZt2tCuXTvKy8u1uk5OTqxevZqXXnrJ4hjt27fHy8sLgIsXL1q8NmjQIC24A+jSpQthYWGYTCZttPHpp5+mS5cuHDx40GI6MSkpCUdHR4v33ywnJ4fS0lLGjRunBXcArVu3ZsmSJXTo0EEbjaxv9uzZFr+bz/Hll182eK769Hq9FtwB9O7dm8mTJ/P9999z/Phxm++prq5mxYoVLFu2zCK4A/Dz8wPgwoULFuXNuR/y8vIoLCxk4sSJWnAH0KpVKxYtWgRgMdonxL1ERvCEuIfMnz/f5s5RqMuDd/NIh7OzM87OzlRWVpKXl0dJSQnFxcXk5+eTn58P1I0YAfTs2RMvLy+LadrMzEwuXbrEnDlzmmzbY489ZrXurWPHjkDdVDGgndNWihVvb28SEhKaPI9ZUFAQq1ev1n6vrKzk3LlzGAwGtm/fzunTp4mLi6NVq1Y4OTkRFBREVVUV+fn5FBcXU1payueff66tP7t5vZe3t7fVOc3tLigoAOqCsTFjxmAwGMjOzsbf359vv/2W7OxsJk6c2OiUqfkYvr6+Vq85ODjw5JNPkpeXx9WrV7WpT3t7e7p06WJR9+Y+bsqAAQOsyvr166e1yRyE1Wdvb6+NDhYVFXH27Fm++OILTp8+TWZmJmDdf825Hz7//HMASkpKbI5Mt2vXjlOnTjXruoRoaSTAE0I0qLa2ls2bN7Nt2zauXr0KQOfOnfH19aVr16589dVXKKW0+nq9nuXLl/PPf/4TnU7HoUOHsLOzs5jubMjNf8yhbiQG0M5hHiV75JFHrOp27tz51i+wnvvuu4/evXsTFRVFYWEhWVlZHDt2jCFDhgCwc+dOYmJi+OGHHwB46KGH8PLy4je/+Q2nTp2y6AeAhx9+2Ooc5rx6FRUVWtn48eMxGAwcOHAAf39/kpKSUEo1Oj0LdZtf4Meg52bmQO769etagGcrYLy5j5vStWtXqzLzdZnbZMvx48dZuXKlFpjef//99OnThz59+pCenm51/ubcD+ZlBenp6aSnp9s8r/m+FeJeI1O0QogGGQwGoqOj8fT0xGAwkJmZidFo5K233rIZZI0ePZo2bdqQnJyMyWQiNTUVX19fHn300dvSHnMgUX/61MxW2U9lHhUzByOHDh3iL3/5C126dGHz5s2kp6fz6aef8vbbb+Ps7GzzGLYCi++//x7AYuOEq6srTz31FIcPH6a2tpbk5GS6d++Oj49Po20094X5mDczP43joYceavQ4t+rm3bn1z/Xggw/afM+5c+eYM2cO3377LStXruTQoUPk5OSwc+dOhg0b9pPbYm9vD8CaNWs4ffq0zZ+Gpo2FaOkkwBNCNCgpKYm2bduyceNGBg8erI1K1dTUUFJSAliO/HTq1IlBgwaRkZGB0WjkypUrTY5E3Yo+ffoAdTssb/af//zntp3HHLCYR8eSkpIAWLt2LcOGDbMIWM0pPm4egTp58qTVcfPy8oC6tY31jRs3josXL3LkyBHy8/PR6/XaaFVDzMmic3JyrF6rqKggPz+fnj17Nmtn7K0wT5PXZ76u+mvz6ktNTaWyspKFCxfy+9//HmdnZ+zs6v78NNR/zWFed2erTVevXiUqKkrW4Il7lgR4QogGtW/fnurqaosNBEop1q5dy6VLl4C6BfT16fV6Ll26xPr162nbtq1VupGfY/jw4Tg4OBAXF8c333yjlZ89e5bExMTbco4vv/yS5ORk2rRpo60nM28MKCsrs6gbFxenjfLd3A9paWkWgcdXX31FbGwsHTt2tOoTvV5P69atWbNmTbOmZ6FujV+PHj04ePCgRR66mpoaVq1aRXl5eZM7l3+KDz74gNLSUu33goICEhMT6dWrl811h/Bj/50/f96iPC8vj127dgHW/dccAwYMoHv37iQmJvLZZ59ZvPbmm28SFxen/SMixL1G1uAJIRo0duxY8vLymDx5Ms899xx2dnZkZmZy5swZOnXqxIULF7h06ZLF1JxOp8Pe3p6CggJ0Ol2jedxuVceOHYmMjCQyMpIJEyYwYsQIqqqqSElJ0UaqzCNDTbk5TUptbS3nzp3jyJEjXL9+nfDwcLp37671w4EDB5g3bx6BgYHY29uTm5tLbm4uDz/8MGVlZVrAa+bk5MS0adMYM2YMrVq14vDhw1y+fJl169ZZ5HuDuvWD5pFPd3f3JnccQ90GjdWrVxMWFsYLL7yATqfj0UcfJSsri1OnTtG/f3/mzp3brL64FUopnn/+eZ599llqampITk5GKUVUVFSDfT906FDWrVtHTEwMhYWF9OjRg7Nnz5Keno6joyMVFRVW/dcc5j6YPXs2U6ZMQafT0a1bN3JycsjNzcXNzY2wsLCfe8lC3JUkwBNCNGjq1KnU1tYSHx9PQkICjo6OODs7s2nTJi5fvsyf/vQnjEYjvXr10t5jb2/PsGHDSEpKYsyYMbe9TRMmTMDe3p4tW7awZ88eHB0dCQkJ4ZFHHiEqKor777+/WccpKCjQRt+g7gkWDg4OeHt7M3HiRItRtt/97ne88cYbvPvuu+zbtw97e3t69uxJVFQU3bt3Z+bMmRiNRgYPHqy9Z/r06ZSXl7Nz504uXryIu7s74eHhFnXqGzVqFBkZGbc0pe3r60tiYiIbN27k+PHjVFRU0KNHDxYtWsSsWbNu+/QswEsvvURZWRkJCQlUV1fj7+/PggULGn2+cNeuXTEYDLzxxhtkZmZSW1tLt27dmD17NtOnTycgIICMjAwWLlx4y+3x8/MjMTGRmJgYPv30U8rLy+nWrRsvvvgiYWFhDW5CEaKla6V+ysIHIYS4A65du0Z5eTldunSxWqMWHR3Npk2bSEhI0HLT3U1WrFhBfHw86enpNjew3Gm7d+8mMjKSpUuXEhIScqebI4RogqzBE0LcNYqKinjmmWdYtmyZRfnFixfZs2cPDzzwQKMjSb9W586d46OPPiIgIOBXGdwJIe4+MkUrhLhreHh44OHhwc6dOyktLaVPnz5cvXqVo0ePcv78eVauXGn1pIRfs7179xIbG0txcTEmk6nJ5/UKIURzSYAnhLhr2NnZsW3bNrZu3UpKSgr//ve/ue+++3B3d2f16tVaUuK7hZOTE9988w2Ojo4sWrSowTQjQghxq2QNnhBCCCFECyNr8IQQQgghWhgJ8IQQQgghWhgJ8IQQQgghWhgJ8IQQQgghWhgJ8IQQQgghWhgJ8IQQQgghWpj/Ab4OFLz1QddRAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x1a1403e510>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "#Plots the bar chart\n",
    "fig = plt.figure(figsize=(10, 5))\n",
    "sns.set(font_scale=1.8)\n",
    "categories = [\"No, not at all rude\",\"Yes, Somewhat rude\",\"Yes, very rude\"]\n",
    "p1 = plt.bar(categories, male_count, 0.55, color='#d62728')\n",
    "p2 = plt.bar(categories, female_count, 0.55, bottom= male_count)\n",
    "plt.legend((p2[0], p1[0]), ('Female', 'Male'))\n",
    "plt.xlabel('Having Baby on plane')\n",
    "plt.ylabel('Count')\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[249, 105,  47],\n",
       "       [338,  76,  28]])"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "f_obs = np.array ([contigency_table_flying.iloc[1][0:3].values,\n",
    "                  contigency_table_flying.iloc[0][0:3].values])\n",
    "f_obs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Chi-square value =  21.009407414417225 \n",
      " P-value =  0.000030\n"
     ]
    }
   ],
   "source": [
    "from scipy import stats\n",
    "chisq = stats.chi2_contingency(f_obs)[0:3]\n",
    "print 'Chi-square value = ', chisq[0],'\\n P-value = ', '{:.6f}'.format (round (float (chisq[1]), 5))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### As we can see, the p-value = 0.000030, (i.e) (p < 0.05) we can reject the null hypothesis. \n",
    "\n",
    "There is definietly some sort of relationship between sex and being rude towards having baby on the plane."
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.15"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}