Intentional Walk 2023 Survey Analysis.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# IWalk 2023 Survey Analysis"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "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>Start Date</th>\n",
       "      <th>End Date</th>\n",
       "      <th>IP Address</th>\n",
       "      <th>Respondent ID</th>\n",
       "      <th>Did you use the Where to Walk feature in the app to find a local park, open space, or trail?</th>\n",
       "      <th>Why not? (Select all that apply)</th>\n",
       "      <th></th>\n",
       "      <th>.1</th>\n",
       "      <th>.2</th>\n",
       "      <th>.3</th>\n",
       "      <th>...</th>\n",
       "      <th>What healthy lifestyle changes did you make?</th>\n",
       "      <th>How did you find out about the Intentional Walk program? (select all that apply)</th>\n",
       "      <th>.19</th>\n",
       "      <th>.20</th>\n",
       "      <th>.21</th>\n",
       "      <th>.22</th>\n",
       "      <th>.23</th>\n",
       "      <th>Would you participate in this program again?</th>\n",
       "      <th>Why not?.2</th>\n",
       "      <th>Is there anything you would change about the Intentional Walk app?</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>Response</td>\n",
       "      <td>I already have walking routes</td>\n",
       "      <td>I am already familiar with local parks, open s...</td>\n",
       "      <td>I did not see this feature in the app</td>\n",
       "      <td>I use another method to find local parks, open...</td>\n",
       "      <td>Other (please explain)</td>\n",
       "      <td>...</td>\n",
       "      <td>Open-Ended Response</td>\n",
       "      <td>WIC</td>\n",
       "      <td>Rec and Park flyer or newsletter</td>\n",
       "      <td>Info table at Heart of the City Farmers' Market</td>\n",
       "      <td>Info table at Rec and Park Zumba class</td>\n",
       "      <td>A friend, family member, or colleague</td>\n",
       "      <td>Other (please explain)</td>\n",
       "      <td>Response</td>\n",
       "      <td>Open-Ended Response</td>\n",
       "      <td>Open-Ended Response</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2023-09-15 10:07:39</td>\n",
       "      <td>2023-09-15 10:13:07</td>\n",
       "      <td>172.58.88.154</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>I already have walking routes</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>WIC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>More Reminders to walk</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2023-09-14 20:49:36</td>\n",
       "      <td>2023-09-14 21:24:52</td>\n",
       "      <td>174.160.120.204</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</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>WIC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2023-09-14 16:17:11</td>\n",
       "      <td>2023-09-14 16:22:09</td>\n",
       "      <td>76.210.5.151</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</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>Usar menos el car</td>\n",
       "      <td>WIC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Info table at Heart of the City Farmers' Market</td>\n",
       "      <td>Info table at Rec and Park Zumba class</td>\n",
       "      <td>A friend, family member, or colleague</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Todo muy bien</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2023-09-14 15:35:56</td>\n",
       "      <td>2023-09-14 15:47:23</td>\n",
       "      <td>98.234.89.140</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>I am already familiar with local parks, open s...</td>\n",
       "      <td>I did not see this feature in the app</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Eating more veggies</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>A friend, family member, or colleague</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No, I think it’s perfect just the way it is an...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2023-09-14 14:28:01</td>\n",
       "      <td>2023-09-14 14:30:41</td>\n",
       "      <td>12.33.185.244</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</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>Life</td>\n",
       "      <td>WIC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2023-09-14 14:11:01</td>\n",
       "      <td>2023-09-14 14:17:19</td>\n",
       "      <td>71.198.118.39</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>I already have walking routes</td>\n",
       "      <td>I am already familiar with local parks, open s...</td>\n",
       "      <td>I did not see this feature in the app</td>\n",
       "      <td>I use another method to find local parks, open...</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>A friend, family member, or colleague</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes. On the Top Walkers leaderboard, I wanted ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2023-09-14 11:18:55</td>\n",
       "      <td>2023-09-14 11:24:23</td>\n",
       "      <td>98.234.242.211</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>I use another method to find local parks, open...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Make more friends</td>\n",
       "      <td>WIC</td>\n",
       "      <td>Rec and Park flyer or newsletter</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8 rows × 52 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Start Date             End Date       IP Address  Respondent ID  \\\n",
       "0                                                                       NaN   \n",
       "1  2023-09-15 10:07:39  2023-09-15 10:13:07    172.58.88.154            NaN   \n",
       "2  2023-09-14 20:49:36  2023-09-14 21:24:52  174.160.120.204            NaN   \n",
       "3  2023-09-14 16:17:11  2023-09-14 16:22:09     76.210.5.151            NaN   \n",
       "4  2023-09-14 15:35:56  2023-09-14 15:47:23    98.234.89.140            NaN   \n",
       "5  2023-09-14 14:28:01  2023-09-14 14:30:41    12.33.185.244            NaN   \n",
       "6  2023-09-14 14:11:01  2023-09-14 14:17:19    71.198.118.39            NaN   \n",
       "7  2023-09-14 11:18:55  2023-09-14 11:24:23   98.234.242.211            NaN   \n",
       "\n",
       "  Did you use the Where to Walk feature in the app to find a local park, open space, or trail?  \\\n",
       "0                                           Response                                             \n",
       "1                                                 No                                             \n",
       "2                                                Yes                                             \n",
       "3                                                Yes                                             \n",
       "4                                                 No                                             \n",
       "5                                                Yes                                             \n",
       "6                                                 No                                             \n",
       "7                                                 No                                             \n",
       "\n",
       "  Why not? (Select all that apply)  \\\n",
       "0    I already have walking routes   \n",
       "1    I already have walking routes   \n",
       "2                              NaN   \n",
       "3                              NaN   \n",
       "4                              NaN   \n",
       "5                              NaN   \n",
       "6    I already have walking routes   \n",
       "7                              NaN   \n",
       "\n",
       "                                                      \\\n",
       "0  I am already familiar with local parks, open s...   \n",
       "1                                                NaN   \n",
       "2                                                NaN   \n",
       "3                                                NaN   \n",
       "4  I am already familiar with local parks, open s...   \n",
       "5                                                NaN   \n",
       "6  I am already familiar with local parks, open s...   \n",
       "7                                                NaN   \n",
       "\n",
       "                                      .1  \\\n",
       "0  I did not see this feature in the app   \n",
       "1                                    NaN   \n",
       "2                                    NaN   \n",
       "3                                    NaN   \n",
       "4  I did not see this feature in the app   \n",
       "5                                    NaN   \n",
       "6  I did not see this feature in the app   \n",
       "7                                    NaN   \n",
       "\n",
       "                                                  .2                      .3  \\\n",
       "0  I use another method to find local parks, open...  Other (please explain)   \n",
       "1                                                NaN                     NaN   \n",
       "2                                                NaN                     NaN   \n",
       "3                                                NaN                     NaN   \n",
       "4                                                NaN                     NaN   \n",
       "5                                                NaN                     NaN   \n",
       "6  I use another method to find local parks, open...                     NaN   \n",
       "7  I use another method to find local parks, open...                     NaN   \n",
       "\n",
       "   ... What healthy lifestyle changes did you make?  \\\n",
       "0  ...                          Open-Ended Response   \n",
       "1  ...                                          NaN   \n",
       "2  ...                                          NaN   \n",
       "3  ...                            Usar menos el car   \n",
       "4  ...                         Eating more veggies    \n",
       "5  ...                                         Life   \n",
       "6  ...                                          NaN   \n",
       "7  ...                           Make more friends    \n",
       "\n",
       "  How did you find out about the Intentional Walk program? (select all that apply)  \\\n",
       "0                                                WIC                                 \n",
       "1                                                WIC                                 \n",
       "2                                                WIC                                 \n",
       "3                                                WIC                                 \n",
       "4                                                NaN                                 \n",
       "5                                                WIC                                 \n",
       "6                                                NaN                                 \n",
       "7                                                WIC                                 \n",
       "\n",
       "                                .19  \\\n",
       "0  Rec and Park flyer or newsletter   \n",
       "1                               NaN   \n",
       "2                               NaN   \n",
       "3                               NaN   \n",
       "4                               NaN   \n",
       "5                               NaN   \n",
       "6                               NaN   \n",
       "7  Rec and Park flyer or newsletter   \n",
       "\n",
       "                                               .20  \\\n",
       "0  Info table at Heart of the City Farmers' Market   \n",
       "1                                              NaN   \n",
       "2                                              NaN   \n",
       "3  Info table at Heart of the City Farmers' Market   \n",
       "4                                              NaN   \n",
       "5                                              NaN   \n",
       "6                                              NaN   \n",
       "7                                              NaN   \n",
       "\n",
       "                                      .21  \\\n",
       "0  Info table at Rec and Park Zumba class   \n",
       "1                                     NaN   \n",
       "2                                     NaN   \n",
       "3  Info table at Rec and Park Zumba class   \n",
       "4                                     NaN   \n",
       "5                                     NaN   \n",
       "6                                     NaN   \n",
       "7                                     NaN   \n",
       "\n",
       "                                     .22                     .23  \\\n",
       "0  A friend, family member, or colleague  Other (please explain)   \n",
       "1                                    NaN                     NaN   \n",
       "2                                    NaN                     NaN   \n",
       "3  A friend, family member, or colleague                     NaN   \n",
       "4  A friend, family member, or colleague                     NaN   \n",
       "5                                    NaN                     NaN   \n",
       "6  A friend, family member, or colleague                     NaN   \n",
       "7                                    NaN                     NaN   \n",
       "\n",
       "  Would you participate in this program again?           Why not?.2  \\\n",
       "0                                     Response  Open-Ended Response   \n",
       "1                                          Yes                  NaN   \n",
       "2                                          Yes                  NaN   \n",
       "3                                          Yes                  NaN   \n",
       "4                                          Yes                  NaN   \n",
       "5                                          Yes                  NaN   \n",
       "6                                          Yes                  NaN   \n",
       "7                                          Yes                  NaN   \n",
       "\n",
       "  Is there anything you would change about the Intentional Walk app?  \n",
       "0                                Open-Ended Response                  \n",
       "1                             More Reminders to walk                  \n",
       "2                                                 no                  \n",
       "3                                     Todo muy bien                   \n",
       "4  No, I think it’s perfect just the way it is an...                  \n",
       "5                                                 No                  \n",
       "6  Yes. On the Top Walkers leaderboard, I wanted ...                  \n",
       "7                                                 No                  \n",
       "\n",
       "[8 rows x 52 columns]"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import math\n",
    "from scipy import stats\n",
    "\n",
    "#Separately copy the worksheet with survey data into a new workbook \n",
    "file_path = (\"/Users/tanvitilloo/Desktop/SF Civic Tech/2023 Survey Data for SFCT - deidentified.xlsx\")\n",
    "\n",
    "iwalk_survey_raw = pd.read_excel(file_path)\n",
    "iwalk_survey_raw.info\n",
    "iwalk_survey_raw.head(8) #View the first 8 responses in the dataset \n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "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>Start Date</th>\n",
       "      <th>End Date</th>\n",
       "      <th>Name</th>\n",
       "      <th>Email used to register for the Intentional Walk app</th>\n",
       "      <th>Did you use the Where to Walk feature in the app to find a local park, open space, or trail?</th>\n",
       "      <th>Why not? (Select all that apply)</th>\n",
       "      <th></th>\n",
       "      <th>.1</th>\n",
       "      <th>.2</th>\n",
       "      <th>.3</th>\n",
       "      <th>...</th>\n",
       "      <th>What healthy lifestyle changes did you make?</th>\n",
       "      <th>How did you find out about the Intentional Walk program? (select all that apply)</th>\n",
       "      <th>.19</th>\n",
       "      <th>.20</th>\n",
       "      <th>.21</th>\n",
       "      <th>.22</th>\n",
       "      <th>.23</th>\n",
       "      <th>Would you participate in this program again?</th>\n",
       "      <th>Why not?.2</th>\n",
       "      <th>Is there anything you would change about the Intentional Walk app?</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>2023-09-01 10:29:42</td>\n",
       "      <td>2023-09-01 10:31:25</td>\n",
       "      <td>amy wu</td>\n",
       "      <td>melody168huang@gmail.com</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>...</td>\n",
       "      <td>早睡</td>\n",
       "      <td>WIC</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>2023-09-14 20:22:49</td>\n",
       "      <td>2023-09-14 20:28:06</td>\n",
       "      <td>Rosa Marroquín</td>\n",
       "      <td>rosa.isella1@icloud.com.mx</td>\n",
       "      <td>Sí</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>Comer más saludable</td>\n",
       "      <td>WIC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sí</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>2023-09-14 10:36:36</td>\n",
       "      <td>2023-09-14 10:41:29</td>\n",
       "      <td>Michelle</td>\n",
       "      <td>Michell.260517@hotmail.com</td>\n",
       "      <td>Sí</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>Levantarme más temprano, tomar mas agua</td>\n",
       "      <td>WIC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sí</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Más lugares para ganar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>2023-09-14 08:26:59</td>\n",
       "      <td>2023-09-14 08:30:58</td>\n",
       "      <td>Juan</td>\n",
       "      <td>jhonystar8954@gmail.com</td>\n",
       "      <td>Sí</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>Todos</td>\n",
       "      <td>WIC</td>\n",
       "      <td>Folleto o boletín de recreación y parque</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mesa de información en la clase Rec y Park Zumba</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sí</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sigue cumplir caminata y correr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>2023-09-08 21:51:03</td>\n",
       "      <td>2023-09-08 21:51:53</td>\n",
       "      <td>Mariela perez lopez</td>\n",
       "      <td>Perezlopezmariela845@gmail.com</td>\n",
       "      <td>Sí</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>124</th>\n",
       "      <td>2023-09-08 14:07:43</td>\n",
       "      <td>2023-09-08 14:19:21</td>\n",
       "      <td>Aracely Guevara</td>\n",
       "      <td>aracelygvr@yahoo.com</td>\n",
       "      <td>No</td>\n",
       "      <td>Ya tengo rutas para caminar</td>\n",
       "      <td>Ya estoy familiarizado con los parques, espaci...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Beber más agua y comer menos dulces.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mesa de información en la clase Rec y Park Zumba</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sí</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Hacerla más sencilla para personas que no mane...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>2023-09-08 11:03:12</td>\n",
       "      <td>2023-09-08 11:09:00</td>\n",
       "      <td>Estela</td>\n",
       "      <td>ramosestela117@gmail.om</td>\n",
       "      <td>Sí</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>Súper bien</td>\n",
       "      <td>WIC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sí</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Todo bien</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>2023-09-08 10:49:12</td>\n",
       "      <td>2023-09-08 10:55:41</td>\n",
       "      <td>Maritza Ocampo</td>\n",
       "      <td>Chiquis17.mo@gmail.com</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Utilizo otro método para encontrar parques loc...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Comer mas frutas y verduras y menos comida rapida</td>\n",
       "      <td>WIC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sí</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Seleccionar las mujeres embarazadas a otro gru...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>2023-09-01 13:01:17</td>\n",
       "      <td>2023-09-01 13:06:09</td>\n",
       "      <td>Yessica</td>\n",
       "      <td>Jessica94valle@icloud.com</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Utilizo otro método para encontrar parques loc...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Tener una rutina más</td>\n",
       "      <td>WIC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sí</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>2023-09-01 12:44:18</td>\n",
       "      <td>2023-09-01 12:48:11</td>\n",
       "      <td>Iris Sanchez</td>\n",
       "      <td>Sancheziris433@gmail.com</td>\n",
       "      <td>Sí</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>129</th>\n",
       "      <td>2023-09-01 10:55:34</td>\n",
       "      <td>2023-09-01 11:34:01</td>\n",
       "      <td>Gabriela</td>\n",
       "      <td>girongaby91@icloud.com</td>\n",
       "      <td>Sí</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>Seguir con mis metas</td>\n",
       "      <td>WIC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sí</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>2023-09-01 11:22:10</td>\n",
       "      <td>2023-09-01 11:25:18</td>\n",
       "      <td>Erika</td>\n",
       "      <td>Erikaexin2001@gmail.com</td>\n",
       "      <td>Sí</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>131</th>\n",
       "      <td>2023-09-01 10:41:25</td>\n",
       "      <td>2023-09-01 10:46:01</td>\n",
       "      <td>Jennys</td>\n",
       "      <td>jamadorvall@gmail.com</td>\n",
       "      <td>Sí</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>Tomas más agua</td>\n",
       "      <td>WIC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sí</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>2023-09-01 10:37:01</td>\n",
       "      <td>2023-09-01 10:41:29</td>\n",
       "      <td>Dairin Estrada</td>\n",
       "      <td>Ortizdairin147@gmail.com</td>\n",
       "      <td>Sí</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>Una rutina de caminar diario ,</td>\n",
       "      <td>WIC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sí</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>2023-09-01 10:37:01</td>\n",
       "      <td>2023-09-01 10:39:18</td>\n",
       "      <td>Marlene Barron</td>\n",
       "      <td>marjonny28@icloud.com</td>\n",
       "      <td>Sí</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>Comer saludable</td>\n",
       "      <td>WIC</td>\n",
       "      <td>Folleto o boletín de recreación y parque</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sí</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No nada</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>15 rows × 52 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              Start Date             End Date                 Name  \\\n",
       "119  2023-09-01 10:29:42  2023-09-01 10:31:25               amy wu   \n",
       "120  2023-09-14 20:22:49  2023-09-14 20:28:06      Rosa Marroquín    \n",
       "121  2023-09-14 10:36:36  2023-09-14 10:41:29             Michelle   \n",
       "122  2023-09-14 08:26:59  2023-09-14 08:30:58                Juan    \n",
       "123  2023-09-08 21:51:03  2023-09-08 21:51:53  Mariela perez lopez   \n",
       "124  2023-09-08 14:07:43  2023-09-08 14:19:21     Aracely Guevara    \n",
       "125  2023-09-08 11:03:12  2023-09-08 11:09:00              Estela    \n",
       "126  2023-09-08 10:49:12  2023-09-08 10:55:41      Maritza Ocampo    \n",
       "127  2023-09-01 13:01:17  2023-09-01 13:06:09              Yessica   \n",
       "128  2023-09-01 12:44:18  2023-09-01 12:48:11        Iris Sanchez    \n",
       "129  2023-09-01 10:55:34  2023-09-01 11:34:01             Gabriela   \n",
       "130  2023-09-01 11:22:10  2023-09-01 11:25:18                Erika   \n",
       "131  2023-09-01 10:41:25  2023-09-01 10:46:01               Jennys   \n",
       "132  2023-09-01 10:37:01  2023-09-01 10:41:29      Dairin Estrada    \n",
       "133  2023-09-01 10:37:01  2023-09-01 10:39:18      Marlene Barron    \n",
       "\n",
       "    Email used to register for the Intentional Walk app  \\\n",
       "119                           melody168huang@gmail.com    \n",
       "120                         rosa.isella1@icloud.com.mx    \n",
       "121                         Michell.260517@hotmail.com    \n",
       "122                            jhonystar8954@gmail.com    \n",
       "123                    Perezlopezmariela845@gmail.com     \n",
       "124                              aracelygvr@yahoo.com     \n",
       "125                            ramosestela117@gmail.om    \n",
       "126                             Chiquis17.mo@gmail.com    \n",
       "127                          Jessica94valle@icloud.com    \n",
       "128                           Sancheziris433@gmail.com    \n",
       "129                             girongaby91@icloud.com    \n",
       "130                            Erikaexin2001@gmail.com    \n",
       "131                              jamadorvall@gmail.com    \n",
       "132                           Ortizdairin147@gmail.com    \n",
       "133                              marjonny28@icloud.com    \n",
       "\n",
       "    Did you use the Where to Walk feature in the app to find a local park, open space, or trail?  \\\n",
       "119                                                  是                                             \n",
       "120                                                 Sí                                             \n",
       "121                                                 Sí                                             \n",
       "122                                                 Sí                                             \n",
       "123                                                 Sí                                             \n",
       "124                                                 No                                             \n",
       "125                                                 Sí                                             \n",
       "126                                                 No                                             \n",
       "127                                                 No                                             \n",
       "128                                                 Sí                                             \n",
       "129                                                 Sí                                             \n",
       "130                                                 Sí                                             \n",
       "131                                                 Sí                                             \n",
       "132                                                 Sí                                             \n",
       "133                                                 Sí                                             \n",
       "\n",
       "    Why not? (Select all that apply)  \\\n",
       "119                              NaN   \n",
       "120                              NaN   \n",
       "121                              NaN   \n",
       "122                              NaN   \n",
       "123                              NaN   \n",
       "124      Ya tengo rutas para caminar   \n",
       "125                              NaN   \n",
       "126                              NaN   \n",
       "127                              NaN   \n",
       "128                              NaN   \n",
       "129                              NaN   \n",
       "130                              NaN   \n",
       "131                              NaN   \n",
       "132                              NaN   \n",
       "133                              NaN   \n",
       "\n",
       "                                                         .1  \\\n",
       "119                                                NaN  NaN   \n",
       "120                                                NaN  NaN   \n",
       "121                                                NaN  NaN   \n",
       "122                                                NaN  NaN   \n",
       "123                                                NaN  NaN   \n",
       "124  Ya estoy familiarizado con los parques, espaci...  NaN   \n",
       "125                                                NaN  NaN   \n",
       "126                                                NaN  NaN   \n",
       "127                                                NaN  NaN   \n",
       "128                                                NaN  NaN   \n",
       "129                                                NaN  NaN   \n",
       "130                                                NaN  NaN   \n",
       "131                                                NaN  NaN   \n",
       "132                                                NaN  NaN   \n",
       "133                                                NaN  NaN   \n",
       "\n",
       "                                                    .2   .3  ...  \\\n",
       "119                                                NaN  NaN  ...   \n",
       "120                                                NaN  NaN  ...   \n",
       "121                                                NaN  NaN  ...   \n",
       "122                                                NaN  NaN  ...   \n",
       "123                                                NaN  NaN  ...   \n",
       "124                                                NaN  NaN  ...   \n",
       "125                                                NaN  NaN  ...   \n",
       "126  Utilizo otro método para encontrar parques loc...  NaN  ...   \n",
       "127  Utilizo otro método para encontrar parques loc...  NaN  ...   \n",
       "128                                                NaN  NaN  ...   \n",
       "129                                                NaN  NaN  ...   \n",
       "130                                                NaN  NaN  ...   \n",
       "131                                                NaN  NaN  ...   \n",
       "132                                                NaN  NaN  ...   \n",
       "133                                                NaN  NaN  ...   \n",
       "\n",
       "          What healthy lifestyle changes did you make?  \\\n",
       "119                                                 早睡   \n",
       "120                                Comer más saludable   \n",
       "121           Levantarme más temprano, tomar mas agua    \n",
       "122                                             Todos    \n",
       "123                                                NaN   \n",
       "124              Beber más agua y comer menos dulces.    \n",
       "125                                        Súper bien    \n",
       "126  Comer mas frutas y verduras y menos comida rapida   \n",
       "127                              Tener una rutina más    \n",
       "128                                                NaN   \n",
       "129                              Seguir con mis metas    \n",
       "130                                                NaN   \n",
       "131                                    Tomas más agua    \n",
       "132                    Una rutina de caminar diario ,    \n",
       "133                                   Comer saludable    \n",
       "\n",
       "    How did you find out about the Intentional Walk program? (select all that apply)  \\\n",
       "119                                                WIC                                 \n",
       "120                                                WIC                                 \n",
       "121                                                WIC                                 \n",
       "122                                                WIC                                 \n",
       "123                                                NaN                                 \n",
       "124                                                NaN                                 \n",
       "125                                                WIC                                 \n",
       "126                                                WIC                                 \n",
       "127                                                WIC                                 \n",
       "128                                                NaN                                 \n",
       "129                                                WIC                                 \n",
       "130                                                NaN                                 \n",
       "131                                                WIC                                 \n",
       "132                                                WIC                                 \n",
       "133                                                WIC                                 \n",
       "\n",
       "                                          .19  .20  \\\n",
       "119                                       NaN  NaN   \n",
       "120                                       NaN  NaN   \n",
       "121                                       NaN  NaN   \n",
       "122  Folleto o boletín de recreación y parque  NaN   \n",
       "123                                       NaN  NaN   \n",
       "124                                       NaN  NaN   \n",
       "125                                       NaN  NaN   \n",
       "126                                       NaN  NaN   \n",
       "127                                       NaN  NaN   \n",
       "128                                       NaN  NaN   \n",
       "129                                       NaN  NaN   \n",
       "130                                       NaN  NaN   \n",
       "131                                       NaN  NaN   \n",
       "132                                       NaN  NaN   \n",
       "133  Folleto o boletín de recreación y parque  NaN   \n",
       "\n",
       "                                                  .21  .22  .23  \\\n",
       "119                                               NaN  NaN  NaN   \n",
       "120                                               NaN  NaN  NaN   \n",
       "121                                               NaN  NaN  NaN   \n",
       "122  Mesa de información en la clase Rec y Park Zumba  NaN  NaN   \n",
       "123                                               NaN  NaN  NaN   \n",
       "124  Mesa de información en la clase Rec y Park Zumba  NaN  NaN   \n",
       "125                                               NaN  NaN  NaN   \n",
       "126                                               NaN  NaN  NaN   \n",
       "127                                               NaN  NaN  NaN   \n",
       "128                                               NaN  NaN  NaN   \n",
       "129                                               NaN  NaN  NaN   \n",
       "130                                               NaN  NaN  NaN   \n",
       "131                                               NaN  NaN  NaN   \n",
       "132                                               NaN  NaN  NaN   \n",
       "133                                               NaN  NaN  NaN   \n",
       "\n",
       "    Would you participate in this program again? Why not?.2  \\\n",
       "119                                            是        NaN   \n",
       "120                                           Sí        NaN   \n",
       "121                                           Sí        NaN   \n",
       "122                                           Sí        NaN   \n",
       "123                                          NaN        NaN   \n",
       "124                                           Sí        NaN   \n",
       "125                                           Sí        NaN   \n",
       "126                                           Sí        NaN   \n",
       "127                                           Sí        NaN   \n",
       "128                                          NaN        NaN   \n",
       "129                                           Sí        NaN   \n",
       "130                                          NaN        NaN   \n",
       "131                                           Sí        NaN   \n",
       "132                                           Sí        NaN   \n",
       "133                                           Sí        NaN   \n",
       "\n",
       "    Is there anything you would change about the Intentional Walk app?  \n",
       "119                                                NaN                  \n",
       "120                                                No                   \n",
       "121                            Más lugares para ganar                   \n",
       "122                   Sigue cumplir caminata y correr                   \n",
       "123                                                NaN                  \n",
       "124  Hacerla más sencilla para personas que no mane...                  \n",
       "125                                          Todo bien                  \n",
       "126  Seleccionar las mujeres embarazadas a otro gru...                  \n",
       "127                                                No                   \n",
       "128                                                NaN                  \n",
       "129                                                NaN                  \n",
       "130                                                NaN                  \n",
       "131                                                 No                  \n",
       "132                                                No                   \n",
       "133                                           No nada                   \n",
       "\n",
       "[15 rows x 52 columns]"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "iwalk_survey_raw.tail(15) #View the last 15 observations in the dataset"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Data Cleaning"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [],
   "source": [
    "headers = iwalk_survey_raw.loc(0) #saving the values in the first row of the dataset\n",
    "iwalk_survey_raw= iwalk_survey_raw.drop(0) #drop first row \n",
    "\n",
    "#Drop irrelevant columns  \n",
    "to_drop = ['Respondent ID',\n",
    "            'Collector ID',\n",
    "            'IP Address',\n",
    "            'Email Address', #is empty\n",
    "            'First Name',#is empty\n",
    "            'Last Name', #is empty\n",
    "            'Custom Data 1'] #is empty   ]\n",
    "iwalk_survey_raw.drop(to_drop, inplace=True, axis = 1)\n",
    "\n",
    "#Collect respondent info in a separate df\n",
    "respondent_df = iwalk_survey_raw.iloc[:,0:4] \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [],
   "source": [
    "# subset the dataset to start from Q3 of the survey\n",
    "survey_df = iwalk_survey_raw.iloc[:, 4:]\n",
    "colnames = survey_df.columns.tolist() #stores column names in string form"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [],
   "source": [
    "#collect open-ended questions in a separate df \n",
    "open_ended_q = ['Why not?', \n",
    "                'Why not?.1',\n",
    "                'Besides SF Giants tickets, what other prizes would motivate you to keep walking during the program? (e.g. grocery gift card, a pair of walking shoes, exercise equipment, etc.)',\n",
    "                'What healthy lifestyle changes did you make?',\n",
    "                'Why not?.2', \n",
    "                'Is there anything you would change about the Intentional Walk app?']\n",
    "\n",
    "open_ended_df = survey_df.reindex(columns = open_ended_q)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Did you use the Where to Walk feature in the app to find a local park, open space, or trail?             0\n",
       "Why not? (Select all that apply)                                                                       106\n",
       "                                                                                                       103\n",
       " .1                                                                                                    129\n",
       " .2                                                                                                    123\n",
       " .3                                                                                                    130\n",
       "Did you walk at a local park, open space, or trail during the Intentional Walk program?                  2\n",
       "Before the program, how many days a week did you walk for exercise?                                      3\n",
       "On average, how many days a week during the program did friends and/or family walk with you?             3\n",
       "During the last week of the program, how many days a week did you walk for exercise?                     3\n",
       "Now that the program is over, how many days a week do you plan to continue walking for exercise?         3\n",
       "How often did you look at the Top Walkers feature in the app?                                            5\n",
       "The Top Walkers feature was easy to use                                                                  5\n",
       "I liked being able to see my place among all walkers on the Top Walkers feature                          5\n",
       "Throughout the program, what were your top motivators to keep walking? (Select all that apply)          40\n",
       " .4                                                                                                     73\n",
       " .5                                                                                                     85\n",
       " .6                                                                                                    100\n",
       " .7                                                                                                     87\n",
       " .8                                                                                                     96\n",
       " .9                                                                                                    128\n",
       "Which of the following options would make you walk more during the program? (Select all that apply)     90\n",
       " .10                                                                                                    64\n",
       " .11                                                                                                    94\n",
       " .12                                                                                                    84\n",
       " .13                                                                                                    80\n",
       " .14                                                                                                   126\n",
       "How would you rate your health before starting the Intentional Walk Program on 6/1?                     11\n",
       "How would you rate your health now?                                                                     11\n",
       "Did you experience any of these while participating in the program? (Select all that apply)             68\n",
       " .15                                                                                                    77\n",
       " .16                                                                                                    75\n",
       " .17                                                                                                    82\n",
       " .18                                                                                                   123\n",
       "Did participating in the program lead to you making any other healthy lifestyle changes?                11\n",
       "How did you find out about the Intentional Walk program? (select all that apply)                        27\n",
       " .19                                                                                                   122\n",
       " .20                                                                                                   128\n",
       " .21                                                                                                   126\n",
       " .22                                                                                                   121\n",
       " .23                                                                                                   132\n",
       "Would you participate in this program again?                                                            12\n",
       "dtype: int64"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#only keep the questions with categorical answers \n",
    "survey_df.drop(open_ended_q, inplace = True, axis = 1)\n",
    "survey_df.isnull().sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Data Analysis for Q1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "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>Survey Options</th>\n",
       "      <th>Counts</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Yes</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>No</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>是</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sí</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>否</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Total</td>\n",
       "      <td>133</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Survey Options  Counts\n",
       "0            Yes      56\n",
       "1             No      42\n",
       "2              是      15\n",
       "3             Sí      11\n",
       "4              否       9\n",
       "5          Total     133"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "survey_df.columns.get_loc('Did you use the Where to Walk feature in the app to find a local park, open space, or trail?')\n",
    "q1_df = survey_df.iloc[:,0]\n",
    "q1_df.head(9)\n",
    "q1_df.isnull().sum()\n",
    "summary_df1 = q1_df.value_counts().rename_axis('Survey Options').reset_index(name = 'Counts')\n",
    "total_counts = summary_df1['Counts'].sum()\n",
    "summary_df1.loc[len(summary_df1)] = ['Total', total_counts]\n",
    "display(summary_df1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Text(0.5, 1.0, 'Did you use the Where to Walk feature in the app to find a local park, open space, or trail?')"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Applications/anaconda3/lib/python3.8/site-packages/matplotlib/backends/backend_agg.py:238: RuntimeWarning: Glyph 26159 missing from current font.\n",
      "  font.set_text(s, 0.0, flags=flags)\n",
      "/Applications/anaconda3/lib/python3.8/site-packages/matplotlib/backends/backend_agg.py:238: RuntimeWarning: Glyph 21542 missing from current font.\n",
      "  font.set_text(s, 0.0, flags=flags)\n",
      "/Applications/anaconda3/lib/python3.8/site-packages/matplotlib/backends/backend_agg.py:201: RuntimeWarning: Glyph 26159 missing from current font.\n",
      "  font.set_text(s, 0, flags=flags)\n",
      "/Applications/anaconda3/lib/python3.8/site-packages/matplotlib/backends/backend_agg.py:201: RuntimeWarning: Glyph 21542 missing from current font.\n",
      "  font.set_text(s, 0, flags=flags)\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAjEAAAEjCAYAAADDmVD5AAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8vihELAAAACXBIWXMAAAsTAAALEwEAmpwYAAAntklEQVR4nO3debhkVXnv8e8PmklmpCXMDYIDEERtp0QRg15RUEgUxOmCmhASo5gQFSVRNOGGG70Go1GDKJMyaRxwigOCiMrQCKKIKIFmlm4QZFK04b1/7H2guqg6Qw+nzj79/TzPeU7ttad3T6veWmvvqlQVkiRJXbPaqAOQJElaFiYxkiSpk0xiJElSJ5nESJKkTjKJkSRJnWQSI0mSOmmFJDFJPpbkH8cZX0l2WBHr6pokC5M8fwTrndfu9znTve6ZJMmJSf65fb1HkhunMO8/J7ktyS9XXoQrR5IrkuyxgpY1pf02WyR5fJJLk9yd5M0T1XMTLOvgJOevoLjOTfLnK2JZQ5Y/rXXHyt4ezTxJ7kmyffv6oTp6WUyYxLRvwr9pL+Q7k3w/yaFJHpq3qg6tqn9a1iBmi+U9GBMs+z+TfKRneI0k9w4pe+bKiGGylrcSTHJVkgN6hv+4XV5/2T0rq6JNsjVwOLBTVf3Bci5r2pOAqtq5qs5dlnlny4eOFfDm+Dbg3Kpav6r+3XpOq7oVVZdV1XpVdc2Q5X8vya+T/CLJiyda1mRbYl5SVesD2wLHAG8HPjGlqLW8zgOe2zM8H7ge2L2vDOCSFbniEbTm9G/r7sDPBpR9v6qWrKQYtgVur6pFK2n5k7aqt6aN0LbAFaMOYrZKw1saZqjl+BC6PPXVNsA/AI9u/5820fKmdAJV1a+r6izgFcBBSXaBR7ZAJHlrkluS3Jzk9cOWl2T/JJf0lR2e5Avt6w2TnJxkcZLrkvzD2Emf5Kgkn+qZb9xP//2fLvu6GTZN8uW2pelXSb7bs54tkvxXG8O1Sd48ZPmHAK8G3ta2EHypZ/RuSS5vs8szkqzdM98+SS7raeXadcju+g7wxCSbtsPPAU4H1u0r+0FV/b5nvlcnuT5Nt8iRPetdLckRSf4nye1JzkyySd++fEOS64Fvt+WvT3JlkjuSfD3JtkNiPa/9f2e7L57Vru8f2uO4qD2uG44zf29y9hzg/w4oO6+N6zNJftnu3/OS7DxkuUtJ00Xw0yRb9ZU/H/gmsEUb/4lt+TPbY3Rnkh+lp7smyevafXN3kmuS/GVbvi7wtZ5l3dOeU/3XzFKfcNK0gL49yeXAvUnmjLf+Adv2UDdme62c2e7zu9N0Nc0fMt/YsftRG+sresYd3h67W5K8rqd8rSTvb8+zW9N0u6wzZPmPTfLt9py7Lcmnk2zUF/c72uNyR5ITxq6XsX2U5J3tvAuTvHrIeo6mOUc+3G7Hh9vyP0pycXuuXJzkj4bM/23geT3zPy4DuibH2SePTnJWkruSXAQ8dtB6eqZf1nN43OsqybN7zpkbkhzclu+dpqvsrrb8qMmsr513vGO0cZq6dHE77svpub7StI4dneR7wH3A9n3L3jxNXfn3k4zlpe35fGe77CdOJs52/NC6t5337zOk3u6LYYck32mnuy3JGT3jKk09c0077n15+L1lomth6ySfa/fl7WPncDtusnVxf6xDz5cMqfd75h1Wlx2V5LNJPpXkLuDgJE9P8oN2396S5MNJ1uzbL49o7a2qk6vqnPbD6XnA+sCjxt2oqhr3D1gIPH9A+fXAX7WvTwT+uX29F3ArsAuwLnAqUMAOA5axFvAr4Ik9ZZcCL2tfnwx8sd2QecDPgTe0444CPtUz37x2PXOGbMdSMfTF/C/Ax4A12r/nAKFJ8i4B3gWsSXPBXQO8cMg6Hlpm3/67CNgC2AS4Eji0HfcUYBHwDGB14KB2+rWGLP9a4E/b118G/gT4dF/Zu/r2x8eBdYAnAfeP7WvgLcAFwFbtcfhP4LS+eU9uj+E6wH7A1cATgTk0WfL3h8T5iGMBvL6df3tgPeBzwClD5t8GeLDdX6u1+2gd4IaesjuB3XuWvX67HccClw05znsAN7av/xH4ITB3SAwPTdsObwncDry4Xf8L2uG57fi9ad6oQtNidB/wlEHLGnSuDFjfQuAyYOt228dd/3jXLc218tt23tVpzvcLxrnm+6+VPYAlwHtpro8Xt9u3cTv+WOCs9tisD3wJ+Jchy96hjX0tYC5NRXVsX9w/abd7E+B7fcdvCfCBdv7nAvcCjx+yrnOBP+8Z3gS4A3gtzTn8ynb40ZOc/8QBsQzbJ6cDZ9JcP7sANwHnj7PPh57D48XFONcVzXV0d7uda9B8ut2tJ/4/bM+lXWnq7P0mWZeOd4weDbyM5o1nfeAzwBf6Yr8e2Lk9BmuMbQ8P1/GHDNv2vjge1x7/F7TLeVu7L9acRJzj1r2MU28PiOM04Mh2X64NPLvvWjqnXcY27faNHbuh10Ib04+Af2vPoYeWyxTq4iHn2bDzZey4P1TvT1Qv9tQvv2/jWo2mvnoq8Mw2vnnt/nvLoDqGwe+bqwOfB/5rwm2axEYvZHAScwFw5ICL+5PAMX0n2sAkph3/UeDo9vXONJXKWu1G3E9zT8LYtH9J00c9tuNWVBLzXppkaYe+eZ4BXN9X9g7ghCHrGHQwFgKv6Rn+V+BjPdv+T33TXwU8d5zl/xsPv7E/Cji0p+yOsXl79sdWPfNfBBzYvr4S2LNn3ObtiTinZ97te8Z/jTaBbIdXo6m0tx0Q5yOOBXA28Nc9w48fW984592+wJOB77Vlp/eU/ZYByR6wUbvuDQcc5z1o3kw+AJw/Ns2Q9e/B0knF2+lLuoCvAwcNmf8LwGGDljXoXBmwvoXA65dj/QtZOon5Vs+4nYDfjLPtg5KY3/Qdz0U0lVRo3kge2zPuWcC1w5bft679gEv74j60Z/jFwP/0xLEEWLdn/JnAPw5Z9rksnYS8Friob5ofAAdPcv7+c2nYPlmd5tx+Qs+4/8M4Scx45/B4cTHOdUVTV31+kus8Fvi39vU8Jk5iBh6jAdPuBtzRF/t7B2zPB9rlvnIy8bbz/SNwZs/wajTX9x6TOJfGrXsZp94eEMfJwHH01LV919JePcN/DZw90bVAcw0tHnQMmEJdPGDe8c6XseO+/Tjz78HgJOa8Cdb7lt5zkYmTmI/QJJ3rTbRNy9MfuSVNK0q/LWg+MY+5boLlnAS8KkloKpkzq+p+YFOa1o/e+a9r17uivY8mO/1G2+x3RFu+LU3T2Z1jf8A7gc2muPzep1vuo8mAx5Z/eN/yt6bZh4OMdbP8IXBNVd1H82Y8VrYOcOEU1v35nvVeCTzQt229x3Fb4IM90/+K5g1sssdjCx55LOcwfF+ObevuwHfbsvN7yi6sqvuTrJ7kmDTdYnfRVD7QnD+DbAQcQtNS8OtJxg7N9u/fd6yeTZP8keRFSS5I0x15J02FOSyGyerf/0PXPwn958HamVrf9e219P1HY+fSXJpk+pKeuP67LX+EJI9JcnqSm9rj9SkeuZ/664/e6+GOqrp3nPHj6T8Hx+Zf1jplvH0yh0nWg8twDvca77raGvifIet8RpJz2q6KX9N8GJrK+TrwGCV5VJqHEK5rt+U8YKMkqw+Zd8yraRKQz04hhqW2vaoebJfdezyHnUuTqXuH1Z393kZTF16Upmur/xaKYftqvGtha+C6GnzP3/LUxZOphwcdn4ksNU+a7tcvp+kivYsmiZ/U+ZWmK/ovaRLaeyaafpmSmCRPo9lhgx4ZvIXmAIzZZrxlVdUFwO9ounBeBZzSjrqNJkPctm9ZN7Wv72XpvrKJniC5b9j0VXV3VR1eVdsDLwH+LsmeNAfm2qraqOdv/aoadsd0TRBDvxtoWqF6l/+oqjptyPTn0XQL7c3Db+xX0OzvvYGLq+q3U1j3i/rWvXZV3dQzTfVN/5d9069TVd8fsOxB++FmHnksl9A0Yw8ylsQ8h4e39bs9ZWP3bryKpnXm+cCGNJ8moLmoB7kD2Ac4IckfD5lmkBtoWkJ6t3/dqjomyVrAfwHvBzarqo2Ar/bEMGh/TOb87d//A9c/hW1YGW6jaZHYuSeuDatqWIX/LzTbtWtVbQC8hkceq/764+ae4Y3bvvlh43v17/f+c3Bs/ptYsRbTnNuTrQeneg73Gu+6uoHh9+KcStMFuHVVbUjTnT6Z9Y0ZdowOp/l0/4z2+I7dx9a77EHXw1E059KpfQnPeJba9vaD8NYsfTyHxTnVuneoqvplVf1FVW1B8+b7kb77PYbFMN61cAOwzZAPGlOpi/tNph4e731s2Lj+8o/SPIyxY7tt72Ty59djaHKTYdf1UqaUxCTZIMk+NM36n6qqHw+Y7EyaG3t2SvIo4N2TWPTJwIeBJVV1PkBVPdAu6+gk67c3Lv0dTbYKzf0CuyfZpr0x6R0TrOMymhaf1ZPsRc+TLmlu8NqhvQjuommReICm++WuNDdYrtPOu0ubxA1yK303qk3g48Ch7aeiJFk3zQ136w+auKqubtdxGO0bezVtbxe2ZecNmm+Ij9Hs220BksxNsu8E078j7Q2HaW663n/ItItp7mnp3RenAX+bZLsk69Fk5mcM+aRBuy1PpjlO32vLfgxsR3PD5di2rk/T7Xg7TVLwf8bZBgCqefT41TQtUc+YaPrWp4CXJHlhex6snebmzq1oWgzXon3zSvIi4H/1zHsr8OgsfSPzZcCLk2yS5A9omluXdf0r2qTP4/bT78eBf0vyGIAkWyZ54ZBZ1gfuobnpe0vgrQOmeWOSrdLcaP5O4Iy+8e9JsmaS59AkpJ+Z5HZ8FXhckleluVH6FTRda1+eeEsnr627Pgcc1bZM7ERzz8UwUz6He4x3XX0aeH6SA9rtfXSS3XrW+auq+m2Sp9MkUlMx7BitT5PU3tmOm0z9D80H1v1p7sU4JUs/wHHukHnOBPZOsmeSNWgSqPuB3jfzYXFOqe4dT5oHVMauwzto3tAf6JnkrWlueN6app7u3VfDroWLaBoEjmljW7vnQ9e4dXGaG5yPGhLuVOvhfoPqskHWp3kvvSfJE4C/muTyAW4ENp9sTJNNYr6U5G6aDPBImv7L1w2asKq+RtO/+m2aLppvD5quzyk0N7+d0lf+JppPrNfQtPqcSnPPDVX1TZqT4XKam28nqogOo2lluZPmDewLPeN2BL5Fc0L9APhIVZ3bVkYvoenXvZbmk8LxNJ+WBvkEsFOaZr4vDJnmIVW1APgLmgTuDpr9dfAEs51H01z9vZ6y79Jkr1NJYj5I80nsG+2xvYDmHqBhsX6e5gmh09M0D/4EeNGQae8Djga+1+6LZ9Ict1PaGK+luaflTeOs7+c09xjcUlV3tmUP0lzcG/BwRXUyTZPoTcBP2+2YUHv+vA44K8lTJzH9DTSflt9Jk6zcQFPprFZVdwNvpqlU76B5QzirZ96f0VQe17T7YwuaffEjmq6Db/DIN+pJr38y2ztFRwEntbEeMNHENPfrXA1c0J4b36L5ND7Ie2huqvw18BWaN/t+p9Lsk2vav97vXvolzT6+meZN+tB2/w7yQeDlaZ7g+Pequp0m6TmcJmF4G7BPVd02iW2cqr+h6X74JU2f/wnjTLtM53Br6HVVVdfTdGseTtPlcBlNSy4092a8t73230Vz7k7FsGN0LE239m3tdvz3ZBdYVb8D/oymLvtkm8hszdJ1Xe/0V9G0XnyoXd9LaL4O5HcTxbmMde8wTwMuTHIPzXV/WFVd2zP+izTvUZfRnPNjX08y9Froee/ZgeZG6BtpngqeTF08dJ8xxXq435C6bJC/p6kH76ZJGMet3/psCVydSbbIpb2JZqTS9IEtonma4xejjkfSaCRZSHPT6rcGjNuDpgV4ZbQ+aZLGO0YrYV2X0TyAcPsyzLuQaYpznBiKpkvl6mla31bAZ6rqWdOxvplgpnyJ1l/R3M9hAiNJAqCqdht1DF1SVTfSPNm0yhh5EtNmy6F5vEySJGlSZkR3kiRJ0lStjJsCJUmSVrqRdydp+W266aY1b968UYchSZ1yySWX3FZVA7+YUd1gEjMLzJs3jwULFow6DEnqlCQTfaO8Zji7kyRJUieZxEiSpE4yiZEkSZ1kEiNJkjrJJEaSJHWSSYwkSeokkxhJktRJJjGSJKmTTGIkSVIn+Y29kqQVat4RX5nW9S08Zu9pXZ9mDltiJElSJ5nESJKkTjKJkSRJnWQSI0mSOskkRpIkdZJJjCRJ6iSTGEmS1EkmMZIkqZNMYiRJUieZxEiSpE4yiZEkSZ1kEiNJkjrJJEaSJHWSSYwkSeokkxhJktRJJjGSJKmTTGJWsiSfTLIoyU96yt6X5GdJLk/y+SQb9Yx7R5Krk1yV5IUjCVqSpA4wiVn5TgT26iv7JrBLVe0K/Bx4B0CSnYADgZ3beT6SZPXpC1WSpO4wiVnJquo84Fd9Zd+oqiXt4AXAVu3rfYHTq+r+qroWuBp4+rQFK0lSh5jEjN7rga+1r7cEbugZd2Nb9ghJDkmyIMmCxYsXr+QQJUmaeUxiRijJkcAS4NNjRQMmq0HzVtVxVTW/qubPnTt3ZYUoSdKMNWfUAayqkhwE7APsWVVjicqNwNY9k20F3DzdsUmS1AW2xIxAkr2AtwMvrar7ekadBRyYZK0k2wE7AheNIkZJkmY6W2JWsiSnAXsAmya5EXg3zdNIawHfTAJwQVUdWlVXJDkT+ClNN9Mbq+qB0UQuSdLMZhKzklXVKwcUf2Kc6Y8Gjl55EUmSNDvYnSRJkjrJJEaSJHWSSYwkSeokkxhJktRJJjGSJKmTTGIkSVInmcRIkqROMomRJEmdZBIjSZI6ySRGkiR1kkmMJEnqJJMYSZLUSSYxkiSpk0xiJElSJ5nESJKkTjKJkSRJnWQSI0mSOskkRpIkdZJJjCRJ6iSTGEmS1EkmMZIkqZNMYiRJUieZxKxkST6ZZFGSn/SUbZLkm0l+0f7fuGfcO5JcneSqJC8cTdSSJM18JjEr34nAXn1lRwBnV9WOwNntMEl2Ag4Edm7n+UiS1acvVEmSusMkZiWrqvOAX/UV7wuc1L4+Cdivp/z0qrq/qq4FrgaePh1xSpLUNSYxo7FZVd0C0P5/TFu+JXBDz3Q3tmWPkOSQJAuSLFi8ePFKDVaSpJnIJGZmyYCyGjRhVR1XVfOrav7cuXNXcliSJM08JjGjcWuSzQHa/4va8huBrXum2wq4eZpjkySpE0xiRuMs4KD29UHAF3vKD0yyVpLtgB2Bi0YQnyRJM96cUQcw2yU5DdgD2DTJjcC7gWOAM5O8Abge2B+gqq5IcibwU2AJ8MaqemAkgUuSNMOZxKxkVfXKIaP2HDL90cDRKy8iSZJmB7uTJElSJ5nESJKkTjKJkSRJnWQSI0mSOskkRpIkdZJJjCRJ6iSTGEmS1EkmMZIkqZNMYiRJUieZxEiSpE4yiZEkSZ1kEiNJkjrJJEaSJHWSSYwkSeokkxhJktRJJjGSJKmTTGIkSVInmcRIkqROMomRJEmdZBIjSZI6ySRGkiR1kkmMJEnqJJOYEUryt0muSPKTJKclWTvJJkm+meQX7f+NRx2nJEkzkUnMiCTZEngzML+qdgFWBw4EjgDOrqodgbPbYUmS1MckZrTmAOskmQM8CrgZ2Bc4qR1/ErDfaEKTJGlmM4kZkaq6CXg/cD1wC/DrqvoGsFlV3dJOcwvwmEHzJzkkyYIkCxYvXjxdYUuSNGOYxCyjJBsn2XV55qdpddkO2AJYN8lrJjt/VR1XVfOrav7cuXOXNQxJkjrLJGYKkpybZIMkmwA/Ak5I8oFlXNzzgWuranFV/R74HPBHwK1JNm/XtzmwaEXELknSbGMSMzUbVtVdwJ8BJ1TVU2mSkWVxPfDMJI9KEmBP4ErgLOCgdpqDgC8uZ8ySJM1Kc0YdQMfMaVtHDgCOXJ4FVdWFST4L/BBYAlwKHAesB5yZ5A00ic7+yxeyJEmzk0nM1LwH+DpwflVdnGR74BfLurCqejfw7r7i+2laZSRJ0jhMYqbmlqp66GbeqrpmOe6JkSRJy8F7YqbmQ5MskyRJK5ktMZOQ5Fk0Tw7NTfJ3PaM2oPmmXUmSNM1MYiZnTZobbucA6/eU3wW8fCQRSZK0ijOJmYSq+g7wnSQnVtV1o45HkiSZxEzVWkmOA+bRs++q6k9GFpEkSasok5ip+QzwMeB44IERxyJJ0irNJGZqllTVR0cdhCRJ8hHrqfpSkr9OsnmSTcb+Rh2UJEmrIltipmbsN43e2lNWwPYjiEWSpFWaScwUVNV2o45BkiQ1TGKmIMn/HlReVSdPdyySJK3qTGKm5mk9r9em+aHGHwImMZIkTTOTmCmoqjf1DifZEDhlROFIkrRK8+mk5XMfsOOog5AkaVVkS8wUJPkSzdNI0Pzw4xOBM0cXkSRJqy6TmKl5f8/rJcB1VXXjqIKRJGlVZnfSFLQ/BPkzml+y3hj43WgjkiRp1WUSMwVJDgAuAvYHDgAuTPLy0UYlSdKqye6kqTkSeFpVLQJIMhf4FvDZkUYlSdIqyJaYqVltLIFp3Y77UJKkkbAlZmr+O8nXgdPa4VcAXx1hPJIkrbJMYiYhyQ7AZlX11iR/BjwbCPAD4NPLsdyNgOOBXWge3X49cBVwBjAPWAgcUFV3LEf4kiTNSnaFTM6xwN0AVfW5qvq7qvpbmlaYY5djuR8E/ruqngA8CbgSOAI4u6p2BM5uhyVJUh+TmMmZV1WX9xdW1QKaFpMpS7IBsDvwiXZZv6uqO4F9gZPayU4C9luW5UuSNNuZxEzO2uOMW2cZl7k9sBg4IcmlSY5Psi5Nt9UtAO3/xwyaOckhSRYkWbB48eJlDEGSpO4yiZmci5P8RX9hkjcAlyzjMucATwE+WlVPBu5lCl1HVXVcVc2vqvlz585dxhAkSeoub+ydnLcAn0/yah5OWuYDawJ/uozLvBG4saoubIc/S5PE3Jpk86q6JcnmwKKhS5AkaRVmEjMJVXUr8EdJnkfzJBHAV6rq28uxzF8muSHJ46vqKmBP4Kft30HAMe3/Ly5f9JIkzU4mMVNQVecA56zARb4J+HSSNYFrgNfRdPGd2XZVXU/zEweSJKmPScwIVdVlNN1S/fac5lAkSeock5hV2LwjvjKt61t4zN7Tuj5J0uzm00mSJKmTTGIkSVInmcRIkqROMomRJEmdZBIjSZI6ySRGkiR1kkmMJEnqJJMYSZLUSSYxkiSpk0xiJElSJ5nESJKkTjKJkSRJnWQSI0mSOskkRpIkdZJJjCRJ6iSTGEmS1EkmMZIkqZNMYiRJUieZxEiSpE4yiZEkSZ1kEiNJkjppzqgDWNUlWR1YANxUVfsk2QQ4A5gHLAQOqKo7Rhdhd8074ivTur6Fx+w9reuTpFWdLTGjdxhwZc/wEcDZVbUjcHY7LEmS+pjEjFCSrYC9geN7ivcFTmpfnwTsN81hSZLUCSYxo3Us8DbgwZ6yzarqFoD2/2MGzZjkkCQLkixYvHjxSg9UkqSZxiRmRJLsAyyqqkuWZf6qOq6q5lfV/Llz567g6CRJmvm8sXd0/hh4aZIXA2sDGyT5FHBrks2r6pYkmwOLRhqlJEkzlC0xI1JV76iqrapqHnAg8O2qeg1wFnBQO9lBwBdHFKIkSTOaSczMcwzwgiS/AF7QDkuSpD52J80AVXUucG77+nZgz1HGI0lSF9gSI0mSOskkRpIkdZJJjCRJ6iSTGEmS1EkmMZIkqZNMYiRJUieZxEiSpE4yiZEkSZ1kEiNJkjrJJEaSJHWSSYwkSeokkxhJktRJJjGSJKmTTGIkSVInmcRIkqROMomRJEmdZBIjSZI6ySRGkiR1kkmMJEnqJJMYSZLUSSYxkiSpk0xiJElSJ5nEjEiSrZOck+TKJFckOawt3yTJN5P8ov2/8ahjlSRpJjKJGZ0lwOFV9UTgmcAbk+wEHAGcXVU7Ame3w5IkqY9JzIhU1S1V9cP29d3AlcCWwL7ASe1kJwH7jSRASZJmOJOYGSDJPODJwIXAZlV1CzSJDvCYEYYmSdKMZRIzYknWA/4LeEtV3TWF+Q5JsiDJgsWLF6+8ACVJmqFMYkYoyRo0Ccynq+pzbfGtSTZvx28OLBo0b1UdV1Xzq2r+3LlzpydgSZJmEJOYEUkS4BPAlVX1gZ5RZwEHta8PAr443bFJktQFc0YdwCrsj4HXAj9Ocllb9k7gGODMJG8Argf2H014kiTNbCYxI1JV5wMZMnrP6YxFkqQusjtJkiR1kkmMJEnqJLuTpI6ad8RXpnV9C4/Ze1rXJ0kTsSVGkiR1kkmMJEnqJJMYSZLUSSYxkiSpk0xiJElSJ5nESJKkTvIRa0kzko+QS5qILTGSJKmTTGIkSVIn2Z0kSdPMrjJpxbAlRpIkdZJJjCRJ6iSTGEmS1EkmMZIkqZNMYiRJUieZxEiSpE4yiZEkSZ1kEiNJkjrJJEaSJHWSSYwkSeokk5gZKsleSa5KcnWSI0YdjyRJM41JzAyUZHXgP4AXATsBr0yy02ijkiRpZjGJmZmeDlxdVddU1e+A04F9RxyTJEkzSqpq1DGoT5KXA3tV1Z+3w68FnlFVf9MzzSHAIe3g44GrpjHETYHbpnF9083t67bZvH2zedtg+rdv26qaO43r0wo2Z9QBaKAMKFsq26yq44DjpiecpSVZUFXzR7Hu6eD2ddts3r7ZvG0w+7dPK57dSTPTjcDWPcNbATePKBZJkmYkk5iZ6WJgxyTbJVkTOBA4a8QxSZI0o9idNANV1ZIkfwN8HVgd+GRVXTHisHqNpBtrGrl93Tabt282bxvM/u3TCuaNvZIkqZPsTpIkSZ1kEiNJkjrJJEaSJHWSN/ZqQkkeC9xYVfcn2QPYFTi5qu4cZVyanCTvmmCSRVX1sWkJZgVJ8gdV9ctRxzEdZunxe8p446vqh9MVi7rNG3s1oSSXAfOBeTRPTJ0FPL6qXjzCsFaoJFsBHwKeDTwInA8cVlU3jjSwFSDJV2ke0x/0JYoAJ1XVftMX0fJLchDwNOAw4EmDppktb4Sz9PidM87oqqo/mbZg1Gm2xGgyHmwf+/5T4Niq+lCSS0cd1Ap2AnAqsH87/Jq27AUji2jFeaCq7ho2MknnPslU1UlJbqU5TgePFfdNNlveCGfj8XveqGPQ7GASo8n4fZJXAgcBL2nL1hhhPCvD3Ko6oWf4xCRvGVUwK9hEb3KdexNs3Q78qKpOgodaZ14GLASOGl1YK9xsPX4AJNkF2AlYe6ysqk4eXUTqEm/s1WS8DngWcHRVXZtkO+BTI45pRbstyWuSrN7+vYbmTXI2WCPJBkP+NqT5QsUu+k/gfoAkuwP/ApwE/JrZ9aVps/X4keTdNN24HwKeB/wr8NKRBqVO8Z4YTUqSdYBtqmo6fy172iTZBvgwTbJWwPdp7om5bqSBrQDtG0Ux/J6KRVX10WkMaYVI8qOqelL7+j+AxVV1VDt8WVXtNsLwVpjZevwAkvyY5p6mS6vqSUk2A46vqpdMMKsE2J2kSUjyEuD9wJrAdkl2A95bVbPmE1NVXc8s/QRYVe8ZdQwryepJ5lTVEmBP4JCecbOmbpvFxw/gN1X1YJIlSTYAFgHbjzoodcesudC1Uh0FPB04F6CqLmu7lDpvgsdXq6r+adqC0VSdBnwnyW3Ab4DvAiTZgaZLSTPfgiQbAR8HLgHuAS4aaUTqFLuTNKEkF1bVM5JcWlVPbssur6pdRx3b8kpy+IDidYE3AI+uqvWmOSRNQZJnApsD36iqe9uyxwHrzZZHrFcVSeYBG1TV5aOORd1hS4yGar+f4o3AT5K8iqb5fkfgzTT3jHReVf2/sddJ1qf53pHXAacD/2/YfJoZquqCAWU/H0UsmrokZ1fVngBVtbC/TJqITydpPCfSfLndQmAXmidBTqVpqj9sZFGtYEk2SfLPwOU0if1TqurtVbVoxKFJs1KStZNsAmyaZOP2GtykbY3ZYsThqUPsTtK4kqwLvAvYCziFh7+ToqrqAyMLbAVJ8j7gz2geyf2PqrpnxCFJs16Sw4C30CQsN/eMugv4eFV9eBRxqXtMYjSuJGsCRwCvoulieeiEmQ1PTSR5kKaFaQlLf2lYaBK1DUYSmLQKSPKmqvrQqONQd5nEaKgkewEfoPmtpPdW1X0jDknSLNJ+SDoU2L0tOhf4z6r6/ciCUqeYxGioJN8FDq2qK0Ydi6TZJ8nxND9hclJb9Fqa34r689FFpS4xiZEkTauxLyns/dblnnGPKJOG8ekkSdJ0G/tCuweSPHasMMn2wAOjCUld5PfESJKm29jvQP09cE6Sa9rheTTf0yRNit1JkqRpleRGmocGANah+SXue4G1aX5PqfNf36DpYUuMJGm6rQ6sx9K/zD32Ex/rT3846ipbYiRJ0yrJD6vqKaOOQ93njb2SpOmWiSeRJmZLjCRpWiXZpKp+Neo41H0mMZIkqZPsTpIkSZ1kEiNJkjrJJEaaRZIcmeSKJJcnuSzJM0YdE0CSZye5KMnP2r9DJjHPbkle3DP80iRHrNxIJXWJ3xMjzRJJngXsAzylqu5Psimw5hTmn1NVS1ZCXH8AnArsV1U/bOP6epKbquor48y6GzAf+CpAVZ1F84vqkgTYEiPNJpsDt1XV/QBVdVtV3QyQZGGbPJBkfpJz29dHJTkuyTeAk5NcmGTnsQUmOTfJU5Osm+STSS5OcmmSfdvx302yW8/030uya19cbwROrKofjsUFvA04op3nxCQfa5f18yT7JFkTeC/wirZF6RVJDk7y4XaebZOc3bY4nZ1km55l/XuS7ye5JsnL2/LNk5zXLusnSZ6zIne8pNEwiZFmj28AW7eJwEeSPHeS8z0V2LeqXgWcDhwAzRs/sEVVXQIcCXy7qp4GPA94X5J1geOBg9vpHwesVVWX9y1/Z+CSvrIFbfmYecBzgb2Bj9HUTe8Czqiq3arqjL75PwycXFW7Ap8G/r1n3ObAs2lapY5py14FfL2qdgOeBFw20U6RNPOZxEizRFXdQ5OQHAIsBs5IcvAkZj2rqn7Tvj4T2L99fQDwmfb1/wKOSHIZcC7Nb9xs047fJ8kawOuBEwcsP8Cg73LoLTuzqh6sql8A1wBPmCDmZ9F0UQGcQpO0jPlCu6yfApu1ZRcDr0tyFPCHVXX3BMuX1AEmMdIsUlUPVNW5VfVu4G+Al7WjlvDw9b5232z39sx/E3B72yX0CpqWGWgSkZe1rSK7VdU2VXVlVd0HfBPYlybpOZVHuoLm3pZeTwV+2ht6/6ZMsKn9eqe/v+d1AKrqPGB34CbglCT/e4rLlzQDmcRIs0SSxyfZsadoN+C69vVCmsQBHk5shjmd5p6VDavqx23Z14E3JUm7rif3TH88TXfOxUO+hfU/gIPH7p1J8mjg/wL/2jPN/klWS/JYYHvgKuBuhv8Y4PeBA9vXrwbOH2+DkmwLLKqqjwOfAPzdHmkWMImRZo/1gJOS/DTJ5cBOwFHtuPcAH0zyXeCBCZbzWZoE4cyesn8C1gAuT/KTdhiA9p6Zu4ATBi2sqm4BXgN8PMnPaBKQT1bVl3omuwr4DvA14NCq+i1wDrDT2I29fYt9M0330OXAa4HDJtimPYDLklxKk8R9cILpJXWAPzsgabkk2YLmPpknVNWDyzD/icCXq+qzKzg0SbOcLTGSlll7b8mFwJHLksBI0vKwJUaSJHWSLTGSJKmTTGIkSVInmcRIkqROMomRJEmdZBIjSZI66f8DvQrlNWh+DMcAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "summary_df1.plot(kind = 'bar', x = 'Survey Options', y ='Counts', legend = False)\n",
    "plt.ylabel('Counts')\n",
    "plt.title('Did you use the Where to Walk feature in the app to find a local park, open space, or trail?')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Data Analysis for Q2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "survey_df.columns.get_loc('Did you walk at a local park, open space, or trail during the Intentional Walk program?')\n",
    "q2_df = survey_df.iloc[:,6]\n",
    "q2_df.head(9)\n",
    "q2_df.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "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>Survey Options</th>\n",
       "      <th>Counts</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Yes</td>\n",
       "      <td>85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>是</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Sí</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>No</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>否</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Total</td>\n",
       "      <td>131</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Survey Options  Counts\n",
       "0            Yes      85\n",
       "1              是      23\n",
       "2             Sí      11\n",
       "3             No      11\n",
       "4              否       1\n",
       "5          Total     131"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "summary_df2 = q2_df.value_counts().rename_axis('Survey Options').reset_index(name = 'Counts')\n",
    "total_counts = summary_df2['Counts'].sum()\n",
    "summary_df2.loc[len(summary_df2)] = ['Total', total_counts]\n",
    "display(summary_df2)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Text(0.5, 1.0, 'Did you walk at a local park, open space, or trail during the Intentional Walk program?')"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAhgAAAEjCAYAAABw0XjjAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8vihELAAAACXBIWXMAAAsTAAALEwEAmpwYAAAnCElEQVR4nO3debwcVZn/8c+XBAj7GjBAICC4AAMRI4qyOajDT4GgCCLihMXJMOMozIAsohIXfjKj4+CIigGBhD0yKsENMJAgKkuAGFlEGAgkEMgF2cFo4Jk/zumk0um+t29u3a6b7u/79bqvW32q6tRT1adPP32qqlsRgZmZmVmZVqs6ADMzM+s8TjDMzMysdE4wzMzMrHROMMzMzKx0TjDMzMysdE4wzMzMrHSlJBiSzpX0+V7mh6Tty9hWlSRNknRJnh6T92t41XHVkzRT0icGsf627vtg748NPZJelLRdnr5I0ldaXG9AbVPS1nnbw1Zm/ZXY3jxJ72nHttpJ0sckXdeG7bTcNga4naV9kKSjJN082NvsBH0mGPkF8IqkFyQ9K+k3ko6TtHTdiDguIr48uKF2Lr+BWqeQtK+kBQOtJyLWjYiHyoipn9t9NG/71bLrHuw3w/58kCszsWmU1EXEpRHxvjLqX8mYhudEcfdC2cdynPVlf6gmylWLpG0k/UhSj6RFkk7ra51WRzAOjIj1gG2As4BTgO8PIFazPinxabwhagCjBENu1A+GblzWfxGxBPgtsE+heG/gDw3KbmpjaE2V3f4GoT2PAq4GxgB7AqcUk7VG+tV5R8RzETEd+AgwQdLOsGJmLukzkhZKelzSMc3qk3SopDvqyk6U9OM8vYGkqTljekTS52pvOMXTFflx06FRSUdLuqbw+EFJ0wqP50sam6e/mR8/L+kOSXu1cmwkHZI/FezcYN5Gkn6S9+OZPL1VnncmsBdwTs64z2lS/w8kPSHpOUk3SdqpxbhWy8ftkZx1TpW0QWH+nnlU6tm830fl8g9Iuisfh/mSJrWyvbzuPEmnSbo37++Fkkb0dSzy/JmSzpT0a+BlYLu6ukdJmivppBZjOUjSPXn/Zkp6cytx5vkHSJqjZSN3u9Ste1KO5TlJVxbXrYthe0mz8nJPSbqyMC8kfVrSQ3ne1wpt/PWSbpD0dJ53qaQNC+uOlvTDfCyfLrYdScdIui/v17WStmnxeDVtL1r2GjtW0qPADXXrrgP8HNgit+UXJW2h9Fq9StIlkp4HjpK0u6Tf5mO7UNI5ktaoOy59fhqXNEzS1/PxeQj4QN385T6pq/FpzqX7o7p+JLeZL0v6tdIo7nWSNi3U9/f5WD0t6fP12yssNxH4GHByPi7XFGaPbdaOemuDfRyXSZKm5efvhfwaGJfnXQxsDVyTYzk5l79Dy/qC30nat1Bfb8eh9gb9bK5vD9WdRpD0Tkm35328XdI7W6x7pfu+HNfehcd7Af/eoOwm9dEv9UbpNXuzCv1qYV6t7V+Z9+1OSbsW5s+TdIqkucBLSiMvvfVZuyn1yy/k43Kl8nuv8uhhru8J4MK+9ivX/5X8vL8o6RpJmyj1Nc/n52oMQETcEhEXRcRLEfFH4Elg814PTkT0+gfMA97ToPxR4J/y9EXAV/L0/nnDOwPrAJcBAWzfoI41gT8Bby6U3QUckqenkjKm9UhZ0x+BY/O8ScAlhfXG5O0Mb7Cd7YBnSQnVKOAR4LHCvGeA1fLjI4FNgOHAicATwIj6bRa3BxwNPNhoH/OymwCHAGvnffkB8OPC/JnAJ/p4Ho7J664JnA3M6WXZpfXl9R7M+7ku8EPg4jxva+AF4KPA6jnOsXnevsDf5GO2S35OD+7rWBfazN3AaGBj4NeF9tHKsXgU2Ckf29Vr+1NoAxP7are5rjcALwHvzfWcnI/FGi3EuRuwCHg7MAyYkJdfs7DubcAWed37gOOaxHE5cHo+liOAPQvzArgx17F13r/ac7d9jn1NYCSpwzw7zxsG/A74L9LrbGm9wMF5P9+cj+HngN+0eMx6ay+1531q3uZaDdbfF1hQVzYJ+GuOazVgLeCtwDtyfGPy8Tuh7rhsX9+/NNjecaRPpbXn8EYKbZO6/ovGr+Gl+0Nd2ya1vf8ltaW18uOz8rwdgRdJn+bWAL6e93OF/rLZftBLO6KPNtig/uIxmwT8GXh/XverwC3N+nVgS+DpvPxqpHb3NDCyheOw3DHLZUcBN+fpjUl97Mfz8/3R/HiTvuruq+9rdEwL8/Yhvb+sBmxK6vfXJvVltbLXSK+7lvvo2r7lOs4DrgXWbhLDpNwmPkzqg04CHgZWLzwPc0jtdy166bPy3yPA8Xneh4C/sKzP2hdYQkqi1sz1tbJfDwKvBzYA7iX1Qe/Jz9VU4MIG+3Vijn3dXvuTFjqceTROMG4BTq9/koEL6hrHG2iSYOT53wXOzNM7kRremqQXxWJgx8Ky/wjMrO8omjXyuu3MJ71gDwcmk17UbyIlB9N72f9ngF176ZxOyk/KVn0dy0KdY4FnGjXeFtffMG97gybzl9YHzAD+uTDvjaQGPxw4DfhRi9s8G/ivFo/1PApvtqRO63/7cSy+1GB/vpHr/Wg/jtPngWmFx6sBjwH79hVnbpdfrqvvfmCfwrpHFub9B3Bukzim5ja3QhvJx3H/wuN/BmY0qedg4K48vQfQ0+g5II0iHFu33y8D27RwzHprL7Xnfbte1t+XxgnGTX1s94RiW6T1BOOGuufwffQ/wdiuMH8MKyYYn6t7fn6Rp78AXF6Ytzapw+9vgtGwHfXVBpu0pWKC8cvCvB2BV+q2Wzwup5ATyULZtcCEFo7Dcscslx3FsgTj48BtdXX/Fjiqr7ob7OOGFPq+PtrGCFKStSvwQeDSXH5LoezhJuuOpUkfnfftVuBK4H/IH1ia1DOJ5RO71YCFwF6F5+GYwvymfRZp5OUxQIX5N7N8gvEX8gfifuzX6YXH/wn8vPD4QOo+zJLOYDwBvKnZdmp/Azm/vSUpO6y3BenNvOaRPuqZAhwhSaSGOC0iFpOyy1rGVqxry5WMdxbLnqRZpAO7T/6bVVtI6RTNfXk47llSVrdpfWUFnwG+HRFNL2yTtLak7+Wh1OdJn0Q3VItXqisNA58l6X/z+vPyrN7iqtmCFY/hcNLQ1mjSJ4dG23y7pBvz0NpzpE+KrWyvpr4NbJHrbeVYFNet+RjpxXVVP2JYbt8j4rVcd7ENNYyTdL3RiXmY8tncFkYX5kN6kdW8TPrE38jJgIDb8tBn/WnDZsdqM0lXSHosH6tLWPYcjAYeiXSuud42wDcLcf8pb7+V105v7aVRvK1abh1Jb8jDtU/kffv/9K991fS3v+kztgaaPc/LbTsiXiZ96u+vZvW30gb7U+8INT8vvw1waN229iSN+PYVZ1/q2xSs2Jc3rHsgfV9E/Jn0QXLv/PerPOvmQtlNeTv97aO3B8YDX4yIv/QRSrGNvAYsYPnnsNj+euuztiCNvEeTdQF68n7Tj/16sjD9SoPH9c/z8cDJEdHnxbErlWBIehtphxvdqrOQ9CKo2bq3uiLiFlLWtRdwBHBxnvUU6ZPTNnV1PZanXyJ9Yqh5XR9h1xKMvfL0LOoSDKXrLU4BDgM2iogNgedInXMz7wM+J+mQXpY5kfRJ8O0RsT7LzgHW6o2Gay1zBKkxv4eU8IypW783j7PiMVxCakTzSUNjjVwGTAdGR8QGwLktbq+mvg08nqf7OhbQ+HhMIrWJy1pNzKjb95zEjmZZG+otzvmkkbUNC39rR8TlLW57qYh4IiL+ISK2II3CfUfLX1/QLIavko7FLvlYHcmy4zQf2LrJG8Z84B/rYl8rIn7TQri9tZelu9TL+s3m1Zd/l3RqY4e8b5+lf+2rpq/+ppV+oq/XX2/bLp7Prg1JN9Pf7ZTWBluIZT5pBKO4rXUi4qyVqKtefZuC5fvy3gyk74Nl12HsxbIE41eFstr1I630S0X3kUa/fy7pjX3EsLR9Kl1ftRXLXuOw/PHrrc9aCGyZy1aou0Fd0P/9asUolo+/qX4lGJLWl3QAcAVpmPH3DRabRrqIa0dJawNntFD1VOAcYElE3AwQ6TaxacCZktZTukjt30if4iCdt9pb6b71DUjD/b2ZBbybdN54AamR7U/qEO7Ky6xH6kx7gOGSvgCs30e99+R6vi3poCbLrEfKBJ+VtDErHpMnqbuYscH6i0mfjtYmfdpr1eXAv0raVtK6ed0r8yffS4H3SDpM6eKiTZQvds3b/FNE/FnpSuEj+rFNgE9K2irv72dJw4m1ens7Fs38FTiUdK78Yi1/se/MJutMAz4gaT9Jq5NebIuB4httszjPA47LIzmStI7Sha/rtRjvUkoXM9feiJ4hdQLF2yA/o3Qx1mjSp4PisXqRdKy2JI2W1dxG6nDOyrGNkPSuPO9c4DTli+GULpY+tBDPTDW/aLe39tKKJ4FN1OCCtzrrAc8DL0p6E/BPLdZfbxrw6fwcbgScWjd/DnC4pNWVLnL88Epup5GrgAOVLmBcA/givXfcfb3O65XWBluI5RLSvvxdHjUYoXTRYCsXOvaQrmVotm8/A94g6Yjcz3yEdMrmJy3UPZC+D1IC8W7SG/G9uexm0ofNsSxLMPrdL+VE77PALyU1+6AG8FZJH8ofBk4g7c8tTZbtrc/6Lanf+Jd8HMcDvd7FsTL71YLdafHOm1YTjGskvUDKck8nnQ8/utGCEfFz0vn6G0gXj9zQaLk6F5MuCr24rvxTpE8gD5EaxWWkazyIiOtJHfFc4A76aKyRrnp9kZzFRsTzud5fx7J73q8lnb/+I2mY6s+0MBwcEb8DDgDOk/T/GixyNumCm6dIDesXdfO/CXxY6Srf/26w/tQcz2OkF0mzxtnIBaTjehPp4qI/k44rEfEo6bqDE0nD6HNI5yYhnQf9Un7ev0Bq+P1xGXAd6Rg/BNTuMjqb3o9FU3ko8kPAZsAFOckYTbo4s9Hy95M+9X8rb+9A0i3XxSHNhnFGxGzgH0iJ7zOktnxUq7HWeRtwq6QXSaNCx0fEw4X5V5Pa8Bzgpyy7BfyLpOuGnsvlPyzs26t5f7YnXRS7gHRulIj4EelCryvysOjdQLFdNj1m9NJeWpGHTS8HHlIaam82nH8SKWl9gfRGemWT5fpSu8jud8CdFI5R9nnSKN0zpON52UpuZwURcQ/p2FxBSvZeIF2UubjJKt8HdszH5cct1F9mG6z3VdLI67OSToqI+aSRgs+SEob5pIS2z/eIfGroTODXub531M1/mtQ/nkhKFE4GDoiIp1qIcyB9H6Q35g2AW2unFnI8PcCiiHggL3c2K9EvRcQU4EvkO5CaLHY16bX5DOkygA9FxF+b1Ne0zyr0f8eSblo4kvS+16y9rfR+9WEm8M6+FoJ8sUjV8tDiImC3whNuqyhJ80gXRP2yDduaA+yXO43+rjuPNsXZSwxBOk3wYJu2txXwg4jYox3b6yZ5xOdZ0vP5cB+LWxfII4XbR8SRg1T/raSLgi8cjPoHaqh8idE/Abc7ubD+ioixK5NcdKuIWODkojySDlS6kG4d0m2qv2fZhYhmpZK0j6TX5VMkE0hfIVDGqMSgqPyb6/KnSJFuwTMzW5WMJ51SEjAbODyGwrCwdao3kk5Xr0u6A/DDEbGw2pCaGxKnSMzMzKyzDJVTJGZmZtZBKj9FYivadNNNY8yYMVWHYWa2SrnjjjueioiRVcdhiROMIWjMmDHMnj276jDMzFYpklbmm1xtkPgUiZmZmZXOCYaZmZmVzgmGmZmZlc4JhpmZmZXOCYaZmZmVzgmGmZmZlc4JhpmZmZXOCYaZmZmVzgmGmZmZlc7f5GlmZr2b1eZvFt5nXHu3Z4PCIxhmZmZWOicYZmZmVjonGGZmZlY6JxhmZmZWOicYZmZmVjonGGZmZlY6JxhmZmZWOicYZmZmVjonGGZmZlY6JxhmZmZWOicYZmZmVjonGGZmZlY6JxhmZmZWOicY/STpAkmLJN1dKPuapD9ImivpR5I2LMw7TdKDku6X9HeVBG1mZtZmTjD67yJg/7qy64GdI2IX4I/AaQCSdgQOB3bK63xH0rD2hWpmZlYNJxj9FBE3AX+qK7suIpbkh7cAW+Xp8cAVEbE4Ih4GHgR2b1uwZmZmFXGCUb5jgJ/n6S2B+YV5C3LZCiRNlDRb0uyenp5BDtHMzGxwOcEokaTTgSXApbWiBotFo3UjYnJEjIuIcSNHjhysEM3MzNpieNUBdApJE4ADgP0iopZELABGFxbbCni83bGZmZm1m0cwSiBpf+AU4KCIeLkwazpwuKQ1JW0L7ADcVkWMZmZm7eQRjH6SdDmwL7CppAXAGaS7RtYErpcEcEtEHBcR90iaBtxLOnXyyYh4tZrIzczM2scJRj9FxEcbFH+/l+XPBM4cvIjMzMyGHp8iMTMzs9I5wTAzM7PSOcEwMzOz0jnBMDMzs9I5wTAzM7PSOcEwMzOz0jnBMDMzs9I5wTAzM7PSOcEwMzOz0jnBMDMzs9I5wTAzM7PSOcEwMzOz0jnBMDMzs9I5wTAzM7PSOcEwMzOz0jnBMDMzs9I5wTAzM7PSOcEwMzOz0jnBMDMzs9I5wTAzM7PSOcEwMzOz0jnBMDMzs9I5wTAzM7PSOcHoJ0kXSFok6e5C2caSrpf0QP6/UWHeaZIelHS/pL+rJmozM7P2coLRfxcB+9eVnQrMiIgdgBn5MZJ2BA4HdsrrfEfSsPaFamZmVg0nGP0UETcBf6orHg9MydNTgIML5VdExOKIeBh4ENi9HXGamZlVyQlGOTaPiIUA+f9muXxLYH5huQW5bAWSJkqaLWl2T0/PoAZrZmY22JxgDC41KItGC0bE5IgYFxHjRo4cOchhmZmZDS4nGOV4UtIogPx/US5fAIwuLLcV8HibYzMzM2s7JxjlmA5MyNMTgKsL5YdLWlPStsAOwG0VxGdmZtZWw6sOYFUj6XJgX2BTSQuAM4CzgGmSjgUeBQ4FiIh7JE0D7gWWAJ+MiFcrCdzMzKyNnGD0U0R8tMms/ZosfyZw5uBFZGZmNvT4FImZmZmVzgmGmZmZlc4JhpmZmZXOCYaZmZmVzgmGmZmZlc4JhpmZmZXOCYaZmZmVzgmGmZmZlc4JhpmZmZXOCYaZmZmVzgmGmZmZlc4JhpmZmZXOCYaZmZmVzgmGmZmZlc4JhpmZmZXOCYaZmZmVzgmGmZmZlW541QFYiWbNbu/29hnX3u2ZmdkqwyMYZmZmVjonGGZmZlY6JxhmZmZWOicYZmZmVjonGCWS9K+S7pF0t6TLJY2QtLGk6yU9kP9vVHWcZmZmg80JRkkkbQl8GhgXETsDw4DDgVOBGRGxAzAjPzYzM+toTjDKNRxYS9JwYG3gcWA8MCXPnwIcXE1oZmZm7eMEoyQR8RjwdeBRYCHwXERcB2weEQvzMguBzRqtL2mipNmSZvf09LQrbDMzs0HhBKMk+dqK8cC2wBbAOpKObHX9iJgcEeMiYtzIkSMHK0wzM7O2cIJRnvcAD0dET0T8Ffgh8E7gSUmjAPL/RRXGaGZm1hZOMEijD5J2GWA1jwLvkLS2JAH7AfcB04EJeZkJwNUD3I6ZmdmQ17W/RSJpJnAQ6RjMAXokzYqIf1uZ+iLiVklXAXcCS4C7gMnAusA0SceSkpBDBx69mZnZ0Na1CQawQUQ8L+kTwIURcYakuQOpMCLOAM6oK15MGs0wMzPrGt18imR4vibiMOAnVQdjZmbWSbo5wfgicC3wYETcLmk74IGKYzIzM+sI3XyKZGFELL2wMyIekvSNKgMyMzPrFN08gvGtFsvMzMysn7puBEPSHqTvpxgpqXjHyPqk3w8xMzOzAeq6BANYg3Tr6HBgvUL588CHK4nIzMysw3RdghERs4BZki6KiEeqjsfMzKwTdV2CUbCmpMnAGArHISL+trKIzMzMOkQ3Jxg/AM4FzgderTgWMzOzjtLNCcaSiPhu1UGYmZl1om6+TfUaSf8saZSkjWt/VQdlZmbWCbp5BKP2C6efKZQFsF0FsZiZmXWUrk0wImLbqmMwMzPrVF2bYEj6+0blETG13bGYmZl1mq5NMIC3FaZHkH5S/U7ACYaZmdkAdW2CERGfKj6WtAFwcUXhmJmZdZRuvouk3svADlUHYWZm1gm6dgRD0jWku0Yg/cjZm4Fp1UVkZmbWObo2wQC+XpheAjwSEQuqCsbMzKyTdO0pkvyjZ38g/aLqRsBfqo3IzMysc3RtgiHpMOA24FDgMOBWSf65djMzsxJ08ymS04G3RcQiAEkjgV8CV1UalZmZWQfo2hEMYLVacpE9TXcfDzMzs9J08wjGLyRdC1yeH38E+NlAKpS0Ienn33cm3aFyDHA/cCUwBpgHHBYRzwxkO2ZmZkNd131il7S9pHdFxGeA7wG7ALsCvwUmD7D6bwK/iIg35TrvA04FZkTEDsCM/NjMzKyjdV2CAZwNvAAQET+MiH+LiH8ljV6cvbKVSlof2Bv4fq77LxHxLDAemJIXmwIcvLLbMDMzW1V0Y4IxJiLm1hdGxGzSaYyVtR3QA1wo6S5J50taB9g8IhbmbSwENmu0sqSJkmZLmt3T0zOAMMzMzKrXjQnGiF7mrTWAeocDuwHfjYi3AC/Rj9MhETE5IsZFxLiRI0cOIAwzM7PqdWOCcbukf6gvlHQscMcA6l0ALIiIW/Pjq0gJx5OSRuVtjAIWNVnfzMysY3TjXSQnAD+S9DGWJRTjgDWAD65spRHxhKT5kt4YEfeTfv793vw3ATgr/796ALGbmZmtErouwYiIJ4F3Sno36XZSgJ9GxA0lVP8p4FJJawAPAUeTRomm5RGSR0nfHGpmZtbRui7BqImIG4EbS65zDmk0pN5+ZW7HzMxsqOvGazDMzMxskDnBMDMzs9I5wTAzM7PSOcEwMzOz0jnBMDMzs9I5wTAzM7PSOcEwMzOz0jnBMDMzs9I5wTAzM7PSOcEwMzOz0jnBMDMzs9I5wTAzM7PSOcEwMzOz0jnBMDMzs9I5wTAzM7PSOcEwMzOz0jnBMDMzs9I5wTAzM7PSOcEwMzOz0jnBMDMzs9I5wTAzM7PSOcEwMzOz0jnBKJmkYZLukvST/HhjSddLeiD/36jqGM3MzAabE4zyHQ/cV3h8KjAjInYAZuTHZmZmHc0JRokkbQV8ADi/UDwemJKnpwAHtzksMzOztnOCUa6zgZOB1wplm0fEQoD8f7NGK0qaKGm2pNk9PT2DHqiZmdlgcoJREkkHAIsi4o6VWT8iJkfEuIgYN3LkyJKjMzMza6/hVQfQQd4FHCTp/cAIYH1JlwBPShoVEQsljQIWVRqlmZlZG3gEoyQRcVpEbBURY4DDgRsi4khgOjAhLzYBuLqiEM3MzNrGCcbgOwt4r6QHgPfmx2ZmZh3Np0gGQUTMBGbm6aeB/aqMx8zMrN08gmFmZmalc4JhZmZmpXOCYWZmZqVzgmFmZmalc4JhZmZmpXOCYWZmZqVzgmFmZmalc4JhZmZmpXOCYWZmZqVzgmFmZmalc4JhZmZmpXOCYWZmZqVzgmFmZmalc4JhZmZmpXOCYWZmZqVzgmFmZmalc4JhZmZmpXOCYWZmZqVzgmFmZmalc4JhZmZmpXOCYWZmZqUbXnUAZi2bNbu929tnXHu3Z2bWQTyCYWZmZqVzglESSaMl3SjpPkn3SDo+l28s6XpJD+T/G1Udq5mZ2WBzglGeJcCJEfFm4B3AJyXtCJwKzIiIHYAZ+bGZmVlHc4JRkohYGBF35ukXgPuALYHxwJS82BTg4EoCNDMzayMnGINA0hjgLcCtwOYRsRBSEgJs1mSdiZJmS5rd09PTtljNzMwGgxOMkklaF/gf4ISIeL7V9SJickSMi4hxI0eOHLwAzczM2sAJRokkrU5KLi6NiB/m4icljcrzRwGLqorPzMysXZxglESSgO8D90XENwqzpgMT8vQE4Op2x2ZmZtZu/qKt8rwL+Djwe0lzctlngbOAaZKOBR4FDq0mPDMzs/ZxglGSiLgZUJPZ+7UzFjMzs6r5FImZmZmVzgmGmZmZlc4JhpmZmZXOCYaZmZmVzgmGmZmZlc4JhpmZmZXOCYaZmZmVzgmGmZmZlc5ftGU2FMya3d7t7TOuvdvr9P0zsxV4BMPMzMxK5wTDzMzMSucEw8zMzErnBMPMzMxK5wTDzMzMSucEw8zMzErnBMPMzMxK5wTDzMzMSucEw8zMzErnBMPMzMxK5wTDzMzMSucEw8zMzErnBMPMzMxK5wTDzMzMSucEow0k7S/pfkkPSjq16njMzMwG2/CqA+h0koYB3wbeCywAbpc0PSLurTYyMyvNrNnt3d4+49q7PbOV4BGMwbc78GBEPBQRfwGuAMZXHJOZmdmg8gjG4NsSmF94vAB4e/1CkiYCE/PDFyXd34bYajYFnmrj9tqtk/evk/cNvH+runbv3zZt3Jb1wQnG4FODslihIGIyMHnww1mRpNkR0bFjrp28f528b+D9W9V1+v5Z73yKZPAtAEYXHm8FPF5RLGZmZm3hBGPw3Q7sIGlbSWsAhwPTK47JzMxsUPkUySCLiCWS/gW4FhgGXBAR91QcVr1KTs20USfvXyfvG3j/VnWdvn/WC0WscDmAmZmZ2YD4FImZmZmVzgmGmZmZlc4JhpmZmZXOF3l2IUmvBxZExGJJ+wK7AFMj4tkq4yqLpC/0sciiiDi3LcGURNLrIuKJquOwgenEtgkgabfe5kfEne2KxYYOX+TZhSTNAcYBY0h3t0wH3hgR768wrNJI+hnpduBGX3IGMCUiDm5fRAMnaQLwNuB4YNdGy3RKJy5pK+BbwJ7Aa8DNwPERsaDSwErQiW0TQNKNvcyOiPjbtgVjQ4ZHMLrTa/n22Q8CZ0fEtyTdVXVQJXo1Ip5vNlPSKpdVR8QUSU8CRwJH1YrrFuuUTvxC4DLg0Pz4yFz23soiKk/HtU2AiHh31THY0OMEozv9VdJHgQnAgbls9QrjKVtfnfQq2YkDTwO/i4gpsHRU4xBgHjCpurBKNzIiLiw8vkjSCVUFU7JObZtLSdoZ2BEYUSuLiKnVRWRV8UWe3eloYA/gzIh4WNK2wCUVx1Sm1SWt3+RvA9IXnq2KvgcsBpC0N/BVYArwHJ31hUZPSTpS0rD8dyQpueoEndo2AZB0Bun01reAdwP/ARxUaVBWGV+D0aUkrQVsHRHt/NXWtsidXND8PPeiiPhuG0MqhaTfRcSuefrbQE9ETMqP50TE2ArDK42krYFzSElwAL8hXYPxSKWBlaBT22aNpN+TrhG6KyJ2lbQ5cH5EHNjHqtaBfIqkC0k6EPg6sAawraSxwJcioiM+aUTEF6uOYZAMkzQ8IpYA+wETC/M65rUcEY/SoZ96O7ht1rwSEa9JWiJpfWARsF3VQVk1OqZTsn6ZBOwOzASIiDn5NIkNbZcDsyQ9BbwC/ApA0vak0ySrtD5u4YyI+HLbgrGVNVvShsB5wB3Ai8BtlUZklfEpki4k6daIeLukuyLiLblsbkTsUnVs1jtJ7wBGAddFxEu57A3Auqv6baqSTmxQvA5wLLBJRKzb5pBsACSNAdaPiLlVx2LV8AhGF8n34H8SuFvSEaQh9x2AT5POc9sQFxG3NCj7YxWxlC0i/rM2LWk90nd+HA1cAfxns/Vs6JA0IyL2A4iIefVl1l18F0l3uYj0xVrzgJ1JdyRcRhpeP76yqMwySRtL+gowl/QBaLeIOCUiFlUcmvVC0ghJGwObStooP48b51GMLSoOzyriUyRdRtI6wBeA/YGLWXbffUTENyoLzLqepK8BHyLdcvvtiHix4pCsRZKOB04gJROPF2Y9D5wXEedUEZdVywlGl5G0BnAqcARp6HlpA+iCK9xtCJP0GmlUbQnLf+GUSAnw+pUEZi2T9KmI+FbVcdjQ4ASji0jaH/gG6bdHvhQRL1cckpl1kPwB5jhg71w0E/heRPy1sqCsMk4wuoikXwHHRcQ9VcdiZp1H0vmknx2Ykos+Tvr9lU9UF5VVxQmGmZkNSO0L4IrfNluYt0KZdQffRWJmZgNV+zKtVyW9vlYoaTvg1WpCsqr5ezDMzGygar+tchJwo6SH8uMxpO8ysS7kUyRmZjYgkhaQLiAHWIv0q7AvkX6y/RXfAt+dPIJhZmYDNQxYl+V/Jbb21e7rtT8cGwo8gmFmZgMi6c6I2K3qOGxo8UWeZmY2UOp7Ees2HsEwM7MBkbRxRPyp6jhsaHGCYWZmZqXzKRIzMzMrnRMMMzMzK50TDLMhStLpku6RNFfSHElvrzomAEl7SrpN0h/y38QW1hkr6f2FxwdJOnVwIzWzKvl7MMyGIEl7AAcAu0XEYkmbAmv0Y/3hEbFkEOJ6HXAZcHBE3JnjulbSYxHx015WHQuMA34GEBHTSb/qa2YdyiMYZkPTKOCpiFgMEBFPRcTjAJLm5Td2JI2TNDNPT5I0WdJ1wFRJt0raqVahpJmS3ippHUkXSLpd0l2Sxuf5v5I0trD8ryXtUhfXJ4GLIuLOWlzAycCpeZ2LJJ2b6/qjpAPyT3h/CfhIHon5iKSjJJ2T19lG0ow8UjND0taFuv5b0m8kPSTpw7l8lKSbcl13S9qrzANvZuVwgmE2NF0HjM5v0t+RtE+L670VGB8RRwBXAIdBelMGtoiIO4DTgRsi4m3Au4GvSVoHOB84Ki//BmDNiJhbV/9OwB11ZbNzec0YYB/gA8C5pH7mC8CVETE2Iq6sW/8cYGpE7AJcCvx3Yd4oYE/SaM5ZuewI4NqIGAvsCszp66CYWfs5wTAbgiLiRVKyMBHoAa6UdFQLq06PiFfy9DTg0Dx9GPCDPP0+4FRJc4CZpN+L2DrPP0DS6sAxwEUN6hfQ6N72Ytm0iHgtIh4AHgLe1EfMe5BOuwBcTEooan6c67oX2DyX3Q4cLWkS8DcR8UIf9ZtZBZxgmA1REfFqRMyMiDOAfwEOybOWsOy1O6JutZcK6z8GPJ1Pc3yENKIBKUk4JI8mjI2IrSPivoh4GbgeGE9KSC5jRfeQrqUoeitwbzH0+l3pY1frFZdfXJgWQETcBOwNPAZcLOnv+1m/mbWBEwyzIUjSGyXtUCgaCzySp+eR3tRhWdLRzBWkayQ2iIjf57JrgU9JUt7WWwrLn086RXF7k29m/DZwVO1aDUmbAP8O/EdhmUMlrSbp9cB2wP3ACzT/0avfAIfn6Y8BN/e2Q5K2ARZFxHnA9wH/BobZEOQEw2xoWheYIuleSXOBHYFJed4XgW9K+hXwah/1XEV6855WKPsysDowV9Ld+TEA+RqN54ELG1UWEQuBI4HzJP2BlBxcEBHXFBa7H5gF/Bw4LiL+DNwI7Fi7yLOu2k+TTnnMBT4OHN/HPu0LzJF0FynB+mYfy5tZBfxV4Wa2lKQtSNdlvCkiXluJ9S8CfhIRV5UcmpmtYjyCYWYA5GsZbgVOX5nkwsysyCMYZmZmVjqPYJiZmVnpnGCYmZlZ6ZxgmJmZWemcYJiZmVnpnGCYmZlZ6f4PPF7a0gaQ41cAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "summary_df2.plot(kind = 'bar', x = 'Survey Options', y ='Counts', legend = False,color = \"pink\")\n",
    "plt.ylabel('Counts')\n",
    "plt.title('Did you walk at a local park, open space, or trail during the Intentional Walk program?')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Data Analysis for Q17"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "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>index</th>\n",
       "      <th>Counts</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>More ideas for where to walk in the app</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Reminders/prompts to walk</td>\n",
       "      <td>64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Quick tips for easy ways to walk more</td>\n",
       "      <td>94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Quick facts about the health benefits of walking</td>\n",
       "      <td>84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Earning awards/medals in the app</td>\n",
       "      <td>80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Other (please explain):</td>\n",
       "      <td>126</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              index  Counts\n",
       "0           More ideas for where to walk in the app      90\n",
       "1                         Reminders/prompts to walk      64\n",
       "2             Quick tips for easy ways to walk more      94\n",
       "3  Quick facts about the health benefits of walking      84\n",
       "4                  Earning awards/medals in the app      80\n",
       "5                           Other (please explain):     126"
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "original_column_name17 = 'Which of the following options would make you walk more during the program? (Select all that apply)'\n",
    "q17_index = survey_df.columns.get_loc(original_column_name17)\n",
    "\n",
    "q17_df = survey_df.iloc[:, [q17_index + i for i in range(6)]]\n",
    "q17_df.head(9)\n",
    "new_col_names_q17 = ['More ideas for where to walk in the app', 'Reminders/prompts to walk', \n",
    "                     'Quick tips for easy ways to walk more', 'Quick facts about the health benefits of walking',\n",
    "                     'Earning awards/medals in the app', 'Other (please explain):']\n",
    "q17_df.columns = new_col_names_q17\n",
    "q17_df.isnull().sum().reset_index(name= 'Counts')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {},
   "outputs": [],
   "source": [
    "option_counts= {}\n",
    "\n",
    "for col in new_col_names_q17:\n",
    "    option_counts[col] = q17_df[col].count()\n",
    "    \n",
    "    option_counts_df = pd.DataFrame.from_dict(option_counts, orient='index', columns=['Counts'])\n",
    "    \n",
    "    option_counts_df.reset_index(inplace=True)\n",
    "option_counts_df.rename(columns={'index': 'Survey Option'}, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAdQAAAG9CAYAAACs3If+AAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8vihELAAAACXBIWXMAAAsTAAALEwEAmpwYAABw9klEQVR4nO2ddZxd1dWGnzeB4E6A4EWDW3ApXiihuFO8SNFCobh9uBUvBYoViltwp1CgeHCnuEOB4BDe74+1b7hMA2QmlzlzZtaT3/zm3nPOvbN2jqy9l8o2SZIkSZKMHL2qFiBJkiRJugOpUJMkSZKkBaRCTZIkSZIWkAo1SZIkSVpAKtQkSZIkaQGpUJMkSZKkBaRCTZIESZNKukPSEElHd9LfnFaSJY3SGX+vOyFpcUnPVC1H8n1SoSZJB5C0vqQHJH0i6U1J10larBP+riXN8DN89ZbAe8C4tncZzt89S9JXZbyNn0d+Bjl+EElTSrpU0nuSPpL0mKRNOlOGjqBgV0nPSfpc0iuSDpM0Wju+43vn3fadtmf+eSROOkoq1CRpJ5J2Bo4FDgEmBaYGTgZWqVCskWUa4En/eKWXI2yP3fQzV2cJV/g78Coh60TARsDbHfmiTl4VH09MWDYCxgFWBJYGLupEGZLOwHb+5E/+jOAPMB7wCbDWjxwzGqFw3yg/xwKjlX2bAP9qc7yBGcrrs4CTgGuAIcC9wPRl3x3l2E+LDOsAEwNXAx8CHwB3Ar1+QK5FgPuBj8rvRZr+5tfAV+V7lx3OZ88CDvqRMV8MvFW++w5gtqZ9YwBHAy+X/f8q26Yt49kYeIVYIe/1I3/jE2DuH9i3JPBam20vNcYC7A9cApwLfAzsC3wOTNh0/DxFhlHL+82Ap4D/AjcA05TtJwFHt/lbVwE7DUeuGYGhwAJttk8FfAks3fT/ewpwUznv/2z6e8M7798bLzALcHu5Dp4AftPm3A33msqf1v7kCjVJ2sfCwOjA5T9yzF7AQsDcwFzAAsDe7fgb6wEHABMAzwMHA9heouyfy7FCvBDYBXgN6EuslvckHr7fQ9KExAP1eGJ1dwxwjaSJbG8CnMd3K9Cb2yFrg+sI5TEJ8FD5vgZHAfMRCn1CYDfg26b9iwEzA8sA+0qa5Qf+xr+BkyStK2nqDsi4CqFUxweOBO4B1mjavz5wie2vJa1K/F+uTvzf3gmcX447G1hPUi8ASRMX2c/nf1mGUHz3NW+0/WoZz3JNmzcA/o+YJA2m/B/+wHkfhqRRCYV+I/H/vz1wnqRmk/Bwr6mktaRCTZL2MRHwnu1vfuSYDYADbb9j+13iQfbbdvyNy2zfV/7GeYRi/iG+BvoRq5mvHb614ZltVwKes/1329/YPh94Gli5HXL9UdKHTT9nN3bYPsP2ENtfEqvBuSSNV5TOZsCOtl+3PdT23eW4BgfY/tz2I8AjxCRkeKxFKLZ9gP9IGixp/nbIf4/tK2x/a/tz4B+EokGSgHXLNoCtgENtP1XOwyHA3JKmKcrxI0JZUj53u+3hmZ8nBt78AXneLPsbXGP7jvJ/sxewsKSpRmBcCwFjA4fZ/sr2rYTVYr2mY9pzTSUdJBVqkrSP94GJf8IHNzlh3mzwctk2orzV9Poz4mH5QxxJrDhulPSipN1HUKaGXFO0Q66jbI/f9LMxgKTeJcjmBUkfE6ZWCGUxMbGif+FHvneExmv7v7Z3tz0bsRofDFxRlOGI8Gqb95cQSmtyYAliZX9n2TcNcFxj8kCY08V3/19nAxuW1xsS/t3h8R4x4Rke/cr+/5HP9iflb47IdTM58Krt5lV/23Pbnmsq6SCpUJOkfdwDfAGs+iPHvEE8kBtMXbZB+MHGbOyQNNnICFNWhbvYno5Ybe4saZnhHNpWpoZcr4/M3y+sT5hTlyV8zNOW7SIUxhfA9C34O8Ow/R5hSp6cMCO3/X/tTZhqv/exNt/xIWEmXbuM4fym1f2rwFZtJhBj2L677D8XWEXSXIT/8oofEPVWYCpJCzRvLCvPhYBbmjZP1bR/7DKuN/hp3ih/o/l53qpzm7SDVKhJ0g5sf0QEtJwkaVVJY0oaVdKKko4oh50P7C2pb/Gv7Us8gCFMmrNJmlvS6IR5tD28DUzXeCNpoKQZyirtYyIAZuhwPnctMFNJ9xlF0jrArIRpcGQZhwiweZ9Qaoc0dpRV0xnAMZImL6vZhduTMtJA0uGSZi/yjwNsAzxv+33gWWB0SSsVn+LeRHDYT/EPIvp2Db4z90IECO0habbyt8eTtFbTuF4jArv+DlxaTMj/g+1ny3edJ2mhMv7ZgEuBm9v4q38taTFJfQhf6r3F1wptznsb7iUmFLuVa3FJYnJ1wQiMP2khqVCTpJ3YPgbYmXhov0usZrbju1XKQcADwKPAY0SQzkHls88CBwI3A88REa/tYX/g7GKKXJsIBLqZiP68BzjZ9u3Dkfl9YCARxPQ+ERg0sKz0RpTd2uShNj57DmFifB14kgi2aeaPxP/D/YQZ83A69uwZkwgG+xB4kVhx/waGTXR+D5xe5PiUCNb6KQYR/4dvFx8u5fsuL3JeUMzYjxPpLs2cDczBD5t7G2xX5DqXOE/XExG5a7Q57h/AfsT/0XyEL77B/nz/vA/D9lfE/8OKhEXgZGAj20//hFxJi9Hw4xeSJEmSH0PSEoSSnLaN/7Ij33UWEQ3cnmjwpIuRK9QkSZJ2UszKOwKnj6wyTboPqVCTJEnaQcmT/ZCI0j22UmGSLkWafJMkSZKkBeQKNUmSJElaQCrUJEmSJGkB2YewhzLxxBN72mmnrVqMJEmSWvHggw++Z7tt0RAgFWqPZdppp+WBBx6oWowkSZJaIaltCc9hpMk3SYbDhx9+yJprrkn//v2ZZZZZuOeee3jkkUdYeOGFmWOOOVh55ZX5+OOPqxYzSZIuRCrUJBkOO+64IyussAJPP/00jzzyCLPMMgtbbLEFhx12GI899hirrbYaRx55ZNViJknShci0mRpR+hs290KcjqgTe07ZPi3R6WNt2//9se8aMGCA0+Q7fD7++GPmmmsuXnzxRZobmYw77rh89NFHSOLVV1/lV7/6FU8++WSFkiZJ0tlIetD2gOHtyxVqjbD9jO25bc9N1Pr8jKhtujtwi+0Zie4VP9TCKxkBXnzxRfr27cumm27KPPPMwxZbbMGnn37K7LPPzqBBgwC4+OKLefXVtt3AkiTpyaRCrS/LAC/YfplondVo9nw2P95aLPkJvvnmGx566CG22WYbHn74YcYaaywOO+wwzjjjDE466STmm28+hgwZQp8+faoWNUmSLkQq1PqyLtEmDGBS228ClN+TDO8DkraU9ICkB959991OErN+TDnllEw55ZQsuOCCAKy55po89NBD9O/fnxtvvJEHH3yQ9dZbj+mnb2mLzyRJak4q1BpS+iX+Bri4PZ+zfartAbYH9O073DSqBJhsssmYaqqpeOaZZwC45ZZbmHXWWXnnnXcA+PbbbznooIPYeuutqxQzSZIuRirUerIi8JDtt8v7tyX1Ayi/36lMsm7CCSecwAYbbMCcc87J4MGD2XPPPTn//POZaaaZ6N+/P5NPPjmbbrpp1WImSdKFyCjfGiLpAuAG22eW90cC79s+TNLuwIS2d/ux78go3+FzgA7o1L+3n/fr1L+XJMnIkVG+3QhJYwLLAZc1bT4MWE7Sc2XfYVXIliRJ0pPJ0oM1w/ZnwERttr1PRP0mSZIkFZEr1CRJkiRpAalQkyRJkqQFpEJNkiRJkhaQCjVJkiRJWkAq1CRJkiRpAalQkyRJkqQFpEJNkiRJkhaQCjVJkiRJWkAq1CRJkiRpAalQkyRJkqQFpEJNkiRJkhaQCjVJkiRJWkAq1CRJkiRpAalQkyRJkqQFpEJNkiRJkhaQCjVJkiRJWkAq1CRJkiRpAalQkyRJkqQFpEJNkiRJkhaQCjVJkiRJWkAq1CRJkiRpAalQa4ak8SVdIulpSU9JWljShJJukvRc+T1B1XImSZL0NFKh1o/jgOtt9wfmAp4CdgdusT0jcEt5nyRJknQiqVBrhKRxgSWAvwHY/sr2h8AqwNnlsLOBVauQL0mSpCeTCrVeTAe8C5wp6WFJp0saC5jU9psA5fckw/uwpC0lPSDpgXfffbfzpE6SJOkBpEKtF6MA8wJ/sT0P8CntMO/aPtX2ANsD+vbt+3PJmCRJ0iNJhVovXgNes31veX8JoWDfltQPoPx+pyL5kiRJeiypUGuE7beAVyXNXDYtAzwJDAI2Lts2Bq6sQLwkSZIezShVC5C0m+2B8yT1AV4ENiUmRhdJ2hx4BVirQvmSJEl6JKlQa4btwcCA4exappNFSZIkSZpIk2+SJEmStIBUqEmSJEnSAlKhJkmSJEkLSIWaJEmSJC0gFWqSJEmStIBUqEmSJEnSAlKhJkmSJEkLyDzUJEmSmjHttNMyzjjj0Lt3b0YZZRQeeOAB9tlnH6688kp69erFJJNMwllnncXkk09etag9ilyhJkmS1JDbbruNwYMH88ADDwCw66678uijjzJ48GAGDhzIgQceWLGEPY9UqEmSJN2Acccdd9jrTz/9FEkVStMzSZNvkiRJzZDE8ssvjyS22morttxySwD22msvzjnnHMYbbzxuu+22iqXseeQKNUmSpGbcddddPPTQQ1x33XWcdNJJ3HHHHQAcfPDBvPrqq2ywwQaceOKJFUvZ80iFmiRJUjMawUaTTDIJq622Gvfdd9/39q+//vpceumlVYjWo0mFmiRJUiM+/fRThgwZMuz1jTfeyOyzz85zzz037JhBgwbRv3//qkTssaQPNUmSpEa8/fbbrLbaagB88803rL/++qywwgqsscYaPPPMM/Tq1YtpppmGU045pWJJex6yXbUMSQUMGDDAjXD75DsO0AGd+vf2836d+veS+pLXZtdA0oO2h9eTOk2+SZIkSdIKUqEmSZIkSQtIhZokSZIkLSAVapIk3ZKhQ4cyzzzzMHDgQAAeeeQRFl54YeaYYw5WXnllPv7444olTLobqVCTJOmWHHfcccwyyyzD3m+xxRYcdthhPPbYY6y22moceeSRFUqXdEdSodYMSS9JekzSYEkPlG0TSrpJ0nPl9wRVy5kkVfLaa69xzTXXsMUWWwzb9swzz7DEEksAsNxyy2Xhg6TlpEKtJ0vZnrspdHt34BbbMwK3lPdJ0mPZaaedOOKII+jV67tH3Oyzz86gQYMAuPjii3n11VerEi/ppqRC7R6sApxdXp8NrFqdKElSLVdffTWTTDIJ88033/e2n3HGGZx00knMN998DBkyhD59+lQkYdJdyUpJ9cPAjZIM/NX2qcCktt8EsP2mpEmG90FJWwJbAkw99dSdJW+SdCp33XUXgwYN4tprr+WLL77g448/ZsMNN+Tcc8/lxhtvBODZZ5/lmmuuqVjSpLuRK9T6sajteYEVgW0lLTGiH7R9qu0Btgf07dv355MwSSrk0EMP5bXXXuOll17iggsuYOmll+bcc8/lnXfeAeDbb7/loIMOYuutt65Y0qS7kQq1Zth+o/x+B7gcWAB4W1I/gPL7neokTJKuyfnnn89MM81E//79mXzyydl0002rFinpZqTJt0ZIGgvoZXtIeb08cCAwCNgYOKz8vrI6KZOkOoZX73Z+5h+2fQM2iI2Hw4GHHzhSfytr3SZtSYVaLyYFLpcEce7+Yft6SfcDF0naHHgFWKtCGZMkSXokqVBrhO0XgbmGs/19YJnOlyhJkiRpkD7UJEmSJGkBqVCTJEmSpAWkQk2SJEmSFpAKNUmSJElaQCrUJEmSJGkBqVCTJEmSpAWkQk2SJEmSFpAKNekwQ4cOZZ555mHgwIEA7LPPPsw555zMPffcLL/88rzxxhsVS5gkSdJ5pEJNOsxxxx3HLLPMMuz9rrvuyqOPPsrgwYMZOHAgBx44cqXdkiRJ6kQq1KRDvPbaa1xzzTVsscUWw7aNO+64w15/+umnlBKJSZIkPYIsPZh0iJ122okjjjiCIUOGfG/7XnvtxTnnnMN4443HbbfdVpF0SZIknU+uUJN2c/XVVzPJJJMw33zz/c++gw8+mFdffZUNNtiAE088sQLpkiRJqiEVatJu7rrrLgYNGsS0007Luuuuy6233sqGG274vWPWX399Lr300ookTJIk6XxSoSbt5tBDD+W1117jpZde4oILLmDppZfm3HPP5bnnnht2zKBBg+jfv3+FUiZJknQu6UNNWsbuu+/OM888Q69evZhmmmk45ZRTqhYpSZKk00iFmrSLA3TA/2ybn/k5QAcwZ/kHwGNw+pSnj/Tf28/7jfR3JEmSdAZp8k2SJEmSFpAKNUmSJElaQCrUJEmSJGkBqVCTpIfxxRdfsMACCzDXXHMx22yzsd9+4ad+5JFHWHjhhZljjjlYeeWV+fjjjyuWNEnqRSrULoCkCSTNWbUcSc9gtNFG49Zbb+WRRx5h8ODBXH/99fz73/9miy224LDDDuOxxx5jtdVW48gjj6xa1CSpFalQK0LS7ZLGlTQh8AhwpqRjRvCzvSU9LOnq8n5CSTdJeq78nuDnlD2pN5IYe+yxAfj666/5+uuvkcQzzzzDEkssAcByyy2XhTmSpJ2kQq2O8Wx/DKwOnGl7PmDZEfzsjsBTTe93B26xPSNwS3mfJD/I0KFDmXvuuZlkkklYbrnlWHDBBZl99tkZNGgQABdffDGvvvpqxVImSb1IhVodo0jqB6wNXD2iH5I0JbAS0JzkuQpwdnl9NrBqi2RMuim9e/dm8ODBvPbaa9x33308/vjjnHHGGZx00knMN998DBkyhD59+lQtZpLUilSo1XEAcAPwvO37JU0HPPcTnwE4FtgN+LZp26S23wQovycZ3gclbSnpAUkPvPvuuyMlfNI9GH/88VlyySW5/vrr6d+/PzfeeCMPPvgg6623HtNPP33V4iVJrUiFWh1v2p7T9u8BbL8I/KgPVdJA4B3bD3bkD9o+1fYA2wP69u3bka9IugHvvvsuH374IQCff/45N998M/379+edd94B4Ntvv+Wggw5i6623rlDKJKkfqVCr44QR3NbMosBvJL0EXAAsLelc4O1iPqb8fqeVgibdizfffJOlllqKOeeck/nnn5/llluOgQMHcv755zPTTDPRv39/Jp98cjbddNOqRU2SWpG1fDsZSQsDiwB9Je3ctGtcoPePfdb2HsAe5XuWBP5oe0NJRwIbA4eV31e2XvKkO9Coxbxqk5vd+5kD9ovtG7BBbDwcDjz8wJH+e1mLOelJpELtfPoAYxP/9+M0bf8YWLOD33kYcJGkzYFXgLVGSsIkSZKk3aRC7WRs/xP4p6SzbL88Et9zO3B7ef0+sExLBEySJEk6RCrU6hhN0qnAtDSdB9tLVyZRkiRJ0mFSoVbHxcApRD7p0IplSZIkSUaSVKjV8Y3tv1QtRJIkSdIaMm2mOq6S9HtJ/Uot3glLXd8kSZKkhuQKtTo2Lr93bdpmYLoKZEmSJElGklSoFWH7F1XLkCRJkrSOVKgVIWmj4W23fU5ny5IkSZKMPKlQq2P+ptejE3mkDwGpUJMkSWpIKtSKsL1983tJ4wF/r0icJEmSZCTJKN+uw2fAjFULkSRJknSMXKFWhKSriKheiKL4swAXVSdRkiRJMjKkQq2Oo5pefwO8bPu1qoRJkiRJRo40+VZEKZL/NNFxZgLgq2olSpIkSUaGVKgVIWlt4D6i1drawL2SOtq+LUmSJKmYNPlWx17A/LbfAZDUF7gZuKRSqZIkSZIOkSvU6ujVUKaF98nzkSRJUltyhVod10u6ATi/vF8HuLZCeZIkSZKRIBVqJyNpBmBS27tKWh1YDBBwD3BepcIlSZIkHSZNjJ3PscAQANuX2d7Z9h+I1emxFcqVJEmSjASpUDufaW0/2naj7QeAaTtfnCRJkqQVpELtfEb/kX1jdJoUSZIkSUtJhdr53C/pd203StocePDHPihpdEn3SXpE0hOSDijbJ5R0k6Tnyu8JfibZkyRJkh8gg5I6n52AyyVtwHcKdADQB1jtJz77JbC07U8kjQr8S9J1wOrALbYPk7Q7sDvwp59F+iRJkmS4pELtZGy/DSwiaSlg9rL5Gtu3jsBnDXxS3o5afgysAixZtp8N3E4q1CRJkk4lFWpF2L4NuK29n5PUm1jZzgCcZPteSZPafrN875uSJvmBz24JbAkw9dRTd1j2JEmS5H9JH2rNsD3U9tzAlMACkmb/iY80f/ZU2wNsD+jbt+/PJmOSJElPJBVqTbH9IWHaXQF4W1I/gPL7nR/+ZJIkSfJzkAq1RkjqK2n88noMYFmiBdwgYONy2MbAlZUImCRJ0oNJH2q96AecXfyovYCLbF8t6R7gopJ68wrREi5JkiTpRFKh1ohSYWme4Wx/H1im8yVKkiRJGqTJN0mSJElaQCrUJEmSJGkBqVCTJEmSpAWkQk2SJEmSFpAKNUmSJElaQCrUJEmSJGkBqVCTJEmSpAWkQk2SJEmSFpAKNUmSJElaQCrUJEmSJGkBqVCTJEmSpAWkQk2SJEmSFpAKNUmSJElaQCrUJEmSJGkBqVCTJEmSpAWkQk2SJEmSFpAKNUmSJElaQCrUJEmSJGkBqVCTJEmSpAWkQk2SJEmSFpAKNUmSJElaQCrUGiFpKkm3SXpK0hOSdizbJ5R0k6Tnyu8JqpY1SZKkp5EKtV58A+xiexZgIWBbSbMCuwO32J4RuKW8T5IkSTqRVKg1wvabth8qr4cATwFTAKsAZ5fDzgZWrUTAJEmSHkwq1JoiaVpgHuBeYFLbb0IoXWCSH/jMlpIekPTAu+++22myJkmS9ARSodYQSWMDlwI72f54RD9n+1TbA2wP6Nu3788nYJIkSQ8kFWrNkDQqoUzPs31Z2fy2pH5lfz/gnarkS5Ik6amkQq0RkgT8DXjK9jFNuwYBG5fXGwNXdrZsSZIkPZ1RqhYgaReLAr8FHpM0uGzbEzgMuEjS5sArwFrViJckSdJzSYVaI2z/C9AP7F6mM2VJkiRJvk+afJMkSZKkBaRCTZIkSZIWkAo1SZIkSVpAKtQkSZIkaQGpUJMkSZKkBaRCTZIkSZIWkAo1SZIkSVpAKtQkSZIkaQGpUJMkSZKkBaRCTZIkSZIWkAo1SZIkSVpAKtQkSZIkaQGpUJMkSZKkBaRCTZIkSZIWkAo1SZIkSVpAKtQkSZIkaQGpUJMkSZKkBaRCTZIkSZIWkAo1SZIkSVpAKtQkSZIkaQGpUJMkSZKkBaRCrRmSzpD0jqTHm7ZNKOkmSc+V3xNUKWOSJElPJBVq/TgLWKHNtt2BW2zPCNxS3idJkiSdSCrUmmH7DuCDNptXAc4ur88GVu1MmZIkSZJUqN2FSW2/CVB+TzK8gyRtKekBSQ+8++67nSpgkiRJdycVag/C9qm2B9ge0Ldv36rFSZIk6VakQu0evC2pH0D5/U7F8iRJknSIZ555hrnnnnvYz7jjjsuxxx5btVgjxChVC5C0hEHAxsBh5feV1YqTJEnSMWaeeWYGDx4MwNChQ5liiilYbbXVqhVqBMkVas2QdD5wDzCzpNckbU4o0uUkPQcsV94nSZLUmltuuYXpp5+eaaaZpmpRRohcodYM2+v9wK5lOlWQJEmSn5kLLriA9db7oUde1yNXqEmSJEmX46uvvmLQoEGstdZaVYsywqRCTZIkSboc1113HfPOOy+TTjpp1aKMMKlQkyRJki7H+eefXytzL6QPNUmSJOkCHKADhr3+iq8YxCB+ceEvOGCzA37kUx1nP+/X8u9MhZokSZJ0KfrQhz/xp6rFaDdp8k2SJEmSFpAKNUmSJElaQCrUJEmSJGkBqVCTJEmSpAWkQk2SJEmSFpAKNUmSJElaQCrUJEmSJGkBqVCTJEmSpAWkQk2SJEmSFpAKNUmSJElaQCrUJEmSJGkBqVCTJEmSpAWkQk2SJEmSFpAKNUmSJElaQCrUJEmSJGkBqVCTJEmSpAWkQu0mSFpB0jOSnpe0e9XyJEmS9DRSoXYDJPUGTgJWBGYF1pM0a7VSJUmS9CxSoXYPFgCet/2i7a+AC4BVKpYpSZKkRyHbVcuQjCSS1gRWsL1Fef9bYEHb27U5bktgy/J2ZuCZThRzYuC9Tvx7nU2Or9505/F157FB549vGtt9h7djlE4UIvn50HC2/c9MyfapwKk/vzj/i6QHbA+o4m93Bjm+etOdx9edxwZda3xp8u0evAZM1fR+SuCNimRJkiTpkaRC7R7cD8wo6ReS+gDrAoMqlilJkqRHkSbfboDtbyRtB9wA9AbOsP1ExWK1pRJTcyeS46s33Xl83Xls0IXGl0FJSZIkSdIC0uSbJEmSJC0gFWqSJEmStIBUqEmSdHskDS+1LElaSirUJBkBJP1S0oJVy/Fz0QMUzgxVC/Bz0wPOYZcnFWoyUjRuYkl9SspOt0DSVJL2a9r0W2C8quT5uWh6CI9bqSA/A03X5ozAw5KOqFikltI0vjEk9XY3jDCt2yQhFWoyUti2pFWAi4AbJK0oabSq5WoBowCrSTqsvB+1/HQryvlbAThf0l6Sdq1aplZRxjYQ2JNIrdhI0p8rFqtllPGtDPwduFbSkpKGWxKvTkgaXdKYEGMs234vaY5qJftpUqEmI0XparMTcCRwLrAzsGrZV7vrqxTH2Mb2f4A1gIUl7Q08ArwraQJJo0matHHT1xlJCwNHA3sTZtFFJI1RrVStQdI4wO7AJbZ3BuYGVm2aJNUaSXMBfyTO3y2EFWWFsq9WK7sGksYFtgFOlzSvpDGL5etJ249VLN5PkoUdkg4jaWZgX+AV23cBd0l6CzhZ0qO2n6pWwg4xGnCgpNFsHytpc2J1syTwT+C/RPGMiYD1gM+qErSjSFJZ3YxPjGM3YtyzA2va/lzSzLY7s3nCz8FnwHPAywC235K0M/B3SZ/YPqhS6UYCSdMRk9fXbd8D3CNpDWB3SbfZfq1aCTuG7Y8l/QN4h5jk3QvcZvv2xjGSJrT9QUUi/ii1W0Ek1dJm5vsW8bCaQtLikka1fQ1wLVFPuFZI6mX7aeCXwDaSdrH9PLAFUcrxZdur214F2MT2q1XK21GKMl0a2BUYHTiNmDQsb/tlScsDm0kau0o520uTT3EaSaPbHgq8AJxXegYDvA0cD6xSVue1oc299ynwInHvrQxg+1JiAjF350s38jQsWrbftn0ecCjR5GNjSUuWYyYHtpI0aVVy/hi5Qk3aRXkYLw5MBrxv+0+SDgLWBuaS9DCwEnBmlXJ2BNvfluCOJ0tLvEuKkj2yrGwukXRMMR/+p2JxO4ykeYClgOts/6tEL/cDxi1+qqOBPW1/UqWc7aFp1b0C8FfgdknP2T5I0kTAvZJuJq7TVYE+wNDqJG4/TffexMDHwIHA18AyJfDqdmBB4JjKhOwg5fx9K2kS4D3b39q+X9L7wGrALyUNBr4ELrL9dpXy/hBZejAZIZoeWPMD/wCuBJYAHrD9+xIROxD4NzDI9k1FGX1bodgjRNPYFiH8iE+Vm3kW4HLgVNvHSJoBmMj2vZUK3EHKKq0X8C9gHGA1289Imp04d6sRprbTbA9q/L9UJ3H7kDQfsCZwHWGWX4lQmrsT1+pEwBPAJMAJxPi7/MSo6fpcGDiPuP9+S4zhNMLnuC7wKHCW7Vvrcu/B98a3EnAUcDPwgu1jy/55CLfESbb/VZ2kP00q1GSEkbQE8cC6xvYNZdsDhIn3QMJEA3HDP1KXGxpA0orAscCJwD7AXrZPK37iW4Djbdcy7aLpgdXH9lfFd3op8ITtHZqOGxsYWnyoXV6ZSpoGmIV4APchrAbP2l68TB7mA9YCxgT2tf1+mTycCWxu+9GKRG83kgYAGwI32766mD5vBE4nTNh7AGMDN9q+rTpJO4akOQnXyg3E+VoSeNv2gWX/RsD6wLq2P6xIzJ8kfahJe1gQ2ByYrmnbhsAvbH8DHEzkaq5OBLnUAklTEEp0ILGC+RTYUNIOJTBnWSI4onY0KdNlgFMl7Q8MAFYGBkg6qnGs7U9sf15ed2llWpiSWFGPY/szYBlgdkk72R5q+z7CwvAF0PC5vQ6sWBdlqu8i5VcCfkO0aRzT9hvEvbdimbieBXwLLCVprEqEbQeSppY0QFJvRarPfcD4JQbjOuAyYBJJh5Rr+BzgYrq6zrKdP/kz3B++s2CM37RtO+BJYM7yfjmiH+tE5f14wKRVy96OMU5PxBJMRqxoHiBu2tUJf83mbf8/6vYDLE4E52xEmM4uAjYlVjRPAkdXLWMHxtS4NvsQJuwty/s5gPeBnZqOHa9qeUdifBM0bdsJuIqYEPUCFgXuBsYt+/s17sOu/kP4sucGxirv1yEmPkuX92MQKUCnAjOUbfMAo1Ut+4/9ZFBS8oPYwxLHfyvpXeAc2yeWvLCrJF1P3NgHO8xpvWx/BHxUpdwjSjFx/h64y/ZlkhYAXnUERzwP3AY81Dje5a6uIVMDJ9g+p6xeZiNSLi4mgpNmrFK4jlCuzYWAV4HDgR0lfWn77OKaeLgEmB1drslaUcb3a2DrEoxzhyONa3TgJMKSMg5wuCPVRLbfrFDkdmH7ohIsdpWkI2xfWKKYr5C0uu2bJf0TuN/2++UzD1cq9IhQtUbPn677AywNDAZ+QfgR/wmsVfZtBbwCLFPe965a3naObfLyexMi6Ahihn85sYJ7FFiyajk7ODa1eb8h8AwwSXk/WhnngKplbee4JiVSmsYiJnJnAwuWfSsSUa6/Le/nAJarWuaRGOtSwGNEbvC15f7bpOzbHriDSHOqXNaRHOfOhN+08RxZkzBd13JsuUJNhkvx3SwMbAb0J2bDVwE7lJXoX8sK7yxJyznyN2tBid49S9INwAHA2pIOtb2HpD8RD7OT3ZRMXifsYXmmiwNXE8pzKuAvkv5A1O2dkjCx1YnViGCV02zfIukrSjlI29eVQKT9FPnQZwCP1SG4qi3FAjSACMKZnJhInEtcp9g+QdJ4wK6S3nJ9/MENf/7cxPV4pyN6fgiwZ9l9iaT1gVpWekqFmgwXh9nzcEKR7gesZPvdEg27kqTbbR8tycBXlQrbDopZ6W2i4tFWwBAiKnkbSQs4AlmerVDEkaakjxxFmKt3IgKqriGUz4VE7uKhth+vSsb2oEjiX972KUXZrC/pG+AbmnJJHdGvH5btjW21UqYAjkjsE4nzdSARePSOpNWJoKPrHPm13wJdsmLQ8CjKdCBwGHAnYaY/xhFNPxQ4RNI+ti+A7xRwlTK3l1SoyQ9i+xtJXwITAGtIup1QRMe5JFbbrk0SuaJowdJEusFvgT8QwQ/jAwsRFVketv11ZUJ2kKbZ/8TATMB+tq+StDYxNgOHEA+zMW1/WKMH1gBgxbLyPF5RwH8bwqy7pKR7iRXPqERu6fsVytoSHKlLoxF50UsUP+qnwJFN994hFYo4QpSV9FdlPLMCuxCBjPMTUcvrFYvXGcXC8HHjszW5Nr9H5qEmP0i50L9VlKLbHZgQ2Mf2VRWL1iHKym15YFYi3eLfwIeOIhRrAkNc8mvrSAliOZp48L5le2DZvgYRMfkEYcqujUUBoj0Zcd5+TQSpnC5pCyLN6XrgVsLvZtsvVCdp62iaIK1MpKN9RQT/XV6xaCNMCaC6gDg/pxATnumITIDjgFWAHYkUrr0cpRNrTa5QezhNN+6iRBj7YOB5Rz3NbwFs3yjpbmBi2y/VaGXzPWw/KOkxwid1OqFkxpC0qO1LoJ5mJgBJ/YlUmPUJk/Y9ko63vYPtS4tP/Ik6KdPGuSirm5uIVfZvykTvVEW3nwWB52zfUq207afp3luMSAl5nChM8XrZrmJluBfoY/u1Ol2ftr+QdCywF+Fm+JvtxyT9DvhnGc8NRNT5ExWK2jK6dpJs8rNTbtwViRJmIhTN6mpqvVYeYJ/YfqnxmUqEHQn0XXH0rx1F7VciKiO9RlOhipqObSJgW2IcnzqS/ucFVpB0GoDti20/WaGY7aJJ2SxcFM6MtgcBVwALSNrM9vGEEnq3Slk7SpNP8UTiWfx/ROCRmvbL9jsu3WPqcn2qUAL7/o/IO928PFceIJoT/Jlo+3iEaxTU+GPkCrWHo+gZuSqRdjA5Uczg8mLq7WP7K9eohCB872E8O1HG7D3bL8Kwh1Tv4h8+HbjQ9sc/+oVdHEcO8KVE55jVJF1q+3lFbeKHJc1G1CeuzXlsUjYHE0Fjy0g60/b5JRhnA0mj2D66Wkk7Tllhrwj8ikiP2Rg4v4x9dNtf1EWBNtN0/80kaYjtOyRtR0wcINKdNiSeO7u6ptH0wyMVag/H9hBJrxEzxWmA3zj6Rq4CvEFUQaoV5WZegUiAvwVYXpEucrXtr20PbTKd1VqZNvzctm+XNCrxgF5V0iDbz0qazvUMspqBqOq0EmGanxj4naQxmgJYXqpQxFbwRfk5iciBXq3ceysSwX//rlK4jtCkTJcl/KQvSvqAGOPWhFLtbftE4J7mz1QmdAtJk28Poo0Zt5+kqcvb54jiDYfYfkXRUeYIYsVTG/Qd4wN/BDazvSWRPL4tUaoNqI/p7IeQtJCk8YsloWEivIlIj5meMNuPSc1alMEwq8krRCTvNES5y9WJfNq9JW1l+yrbj1UoZrsY3r1XLAZ3EGM8ydGLdlFCEdXy2VyU6SLABsB6wA5EYYr9iHSmfYF1mp49tb8Xm6nlSUvaj6TJiKg6yurtFuDvkg525H3dSISwXw6cAfzR9p2VCdwOJI0haeJyY04NfE40Xx6nmHcvI3xvu0uqpVVG0qRl5dLIpd2LUvC94Wsrr28hFM+Vtj+rk5lXUSh9SsLHNoPtJwi/8BnFf/8O0ej9keqkbD+K4u8bl9fLE8Xfb5S0LbEKvRjYSNL5RCzDzrbvrkrekUGRJ7wNYVl4xtEe7yai6tPStu8BVrH9SoVi/mzU8uGSdIgliZnhhET6wUbAy8D9kr6xvVeZNc4IvOlost3lTTFFkcxK+NReJKoc7UYEqgwgHr6vEkUO5iXSK+rIikQuZm9HAQMBFD/iN0WpNsy/N1Ysa7tous56lcjPk4A9JO1ApItsqSggsgOwoevXj3YJYPFy7y1D9C4dFTiHiFk4gSh3OSXwQV3uvbYoWrB9RliEBhFt8ta3/YGkj4gsAqhJre+OkAq1m9P0wL2gmACXJW7mVx2Vj+YD/i1pEtvbEKY2oB6mmKJIHid8bJsSK+sXJP2FqBZ0oKJE3UJEsYNaKVRJ0xLt8c4qs//VFQn/jxITn2/KcaPbrlspQWDYOVwQuFjSNkRlp95End4Liwl/HGCHOinTpnvvUkVTgnkIN8objoL2mxHdVCa2fRhNPuE63HsNVIIXgYOA22z/ucRgnCPpLuI+/BXhRsJ27dwQI0oWdujGlAfv/MCbQF+ihuvEhG/jXOLif0dRXedhIvijVtGgDSTtSVTLmZAIw39QURBgcSKR/HXbd9dt5i9pJeKhu4mjAMVWxKRoBUKpvkaYuPsSjQs+q0zYkUDSBIRp8E6ictV4RD70bmV/I9ilFuevTH4WJyaooxG5libSR24FLrL9nqR5iV6mqxTzaO2QNJEj0nxdotXjKY3thKtlXGAD248rql3VLkhuREmF2o2RNC4RzLE60evz17YfkbQpYQK+hkiwfrsxm65O2o7RMHOW12MRwUeLEIEs3wC/tH1hhSKONJJWJXL5/mj7hrKK+yXwPKFsRyX6Zj5QnZQdoyiUtRyNCXYlTKBXEX78XwLH2t65Shk7Qrn3liIqAc1EXIcvSNqAmOQ+BVxWrETj2B5SobgdorgdpgZuJoKrZiNKea5NmO+fktSPWJn2tr1+ZcJ2Emny7cYUs9JTwAJ8V54N22cqiouvCfSSdBlNBcW7Os2rlBLl2vAdfirpnHLYZcBEwBaVCToStBnjFYqUmKPL9r+U87ckMLej4EEtKJOez5usIG8Cv5R0MBG4shvRNHttYHNixVo7yr33DjGR/SfRzB3b5zWdu1El/ZUoFVkbGtdmuT5fLsFyoxBNwvcjGjLMJuk/RLT9H4FjJE3uKDrSbckVag+grAKWIqJCb3Q07x2VyAv7p2vS/gm+Z/r7NaFMDmneXl73JnymQ23XOZdvTsJM+L7tNxSF7vcF/lDMv78H/lWX86cojr4j8H8ulX+a9v2JMF2vB7xPNC/4qEyYamHmHR6SBhArt8WAix1lPCcB1gJucc0qBDVdm8sShRkeBx63/a+y/3SiAtkbwKS2nyrbh1mSujO5Qu0B2H5I0dZqI6LizKKEWXQT229WKlw7KTfzKsD+wN7N25teDwXu6nzpWkMZ44rAn4HziC44K9i+qES7nippG9snVyvpiKMolH40kdLzjqRxyyqudzlfRxA+8HGJaN4JbP8X6hWg06DJavKApPeJjk1rluCrOQnz/cvVStl+yrW5AtG1aH/CAjS3pIeIer39gMkdrQE/aPpct1emkHmo3Yri02i7rVeZVb5IlPx6nkgzOaUuylTfT4ofg/AJ/xa4XdKSko6WNEXZX8vGxM0oSgUeQeTyPUEE6TwoaVbbFwN7EOkJtaFEIJ9HNKx/nvC14aaqVbZfsX0QMF+5XmtD2+uurKx7l9f/ISYStwALA+fWUZk2MTthkv8vYfU6qATDjQbcQM2uzVaSJt9uRpk9Lkskx99p+/WikBo+DxqRdnUwpZWVzaxllT0bcdPuRZgHxwWeJiogPWN7s+okbQ2KFJFRiWjlyYBjbM8n6QRgS2AO28+WY7v8+WtG0q+IqM97gYG2P2kTVNZoF1hL82CxKixC5D2f7yjr+b1gP5UUk7qdu2Yk7UGYrL8A1rD9Zhn7xMAVdQywahW5Qu1GFB/VgUTw0cLAXpKmLQ+nYTNol7D1mtzQ/YBFJZ1BRCW/SCiWe4B9HWkVWwCTKhLna4ukXwAHAJ/YfoaIBr2y7L4NuI9I/gfqcf7arNz+TaSSXEnkKM7YUKDwnVmwpsq0YVUYSuSbniZpPEcThmGuNZf2eXU4dz/C+UTVqluLMl2MKJf4Zk9WppAr1FpTVjNfOPoOLgYcQzTqvUnSPESpwUmAo+pmQmtG0aniGOCvRFm2YatrSb8BDgH2rFO0a4OmcYxKTISuAF6wvZOkDYnKOs8CvwG2sP1EXVY3TWNbjqhaNRZxrkYlIkFnJRrWP1udlB2jYUlwpL0sTqRpXWD78uJ+2IWYDG5j+8PqJG09ihzbpYgUtTEIa8p+tq+uVLAuQK5Qa0oxhR5OXMwQD90ZCR8Vth8m/DYfA3uW42tDm5XNP4joz0+AHSRNVR7UkxAl+f5oe1Ad/adlHEsR9VwXJUxpk5WJwpWEeXQyonHBE43PVCVve2ga2zFE0/PpiPStPsRq7kXgCEUt5tqcO0XFsV2IiQFEKb3FiVQYiAjXo4APgUZnnFrROB+SppM0bYldAGKVbfsG278hrEMru6kcZk8mV6g1RpE8PjHRcu1YRQH8h4BzbO9ejpmHMCE+V6GoHUJRJWg5ogzdfsAcRO7sM0RAxCzAcbZr12C6eZVZUisuIXIy7ydMu/1t7/1Dn6kLkg4B/mv7yPL+z8CCxOShHzCm7ecrFLFDKCo7jU2kjpxEpMZcTlTpOrUcMzkwnkvqSN1QFBT5I1Hz+79EIOPjZV8t/dw/N7lCrTGOxtiTEoXht7P9FlEAfi1Jx5VjHq6pMp2dyLm8j7hObyZqnZ5HNELfA3iojsoUhq3eFivmwoeJ/MzDiGCrNYni8Ku3/UznSzrSvEWYegGw/QciaGdi22/UUZkCOFJ6+hMm+a0dreTWBv4gaftyzBs1VqYzAn8AlicKbswLvNpYhaYyHT6Zh1pjyizxnuJjPLS8P748pB9QFIh/tm4Xv6Jg/5+Ay23/A/iHpH2IDhYLEqu4Pxf/Ve1WbU38AlifSDWYglgFHESkyTRq9NadfxMBOk8SaSPTE77TMX70UzWgxCp8C2xa7r0TJW1EFPm/wvarVcs4EoxOBP6tS/jvf2v7I0nzSnrUNSxT2hmkybdGNAV5DOss0rRtISLC90bbR+m7DhC1o0Qr/4WIJNy+rLyRdAERdPVClfK1krISnwNYmXhwXQxs1Th3dZkwNF2Ho9n+ss22ZYBdidXqHMD+tq+qUt6RpY3JflkiL/oR28eoFK2oVsL20XSuBhDVj8YmKh7NDaxp+2lF2tOBwOq2X69M2C5MKtQaoO+qyVAU57LAwcT5+7bpZlgUOBTYyNGQuVaUm/kbIrd0AqILx+1EyshQws/4K9esXNvwaD6n5f0kRKH7yYkekrUxhbZRnEsS1+DnZVsjt7QfUUlnfNvP12WiAN8b34LEyvoOtymJqMj/3hjY3TUt2qDIJf0LsI7teyX9jojOfo+4J/cAdsto3h8mFWoXpzyItgf+YvtVRf3WcWwf3uaGbtz049muXQPfYqY+n/CZvkWkyLwPnEaYQO8hVt/X1+lhDN87N1MTUddD3ZT036R0xgT61XEFrqit/GdidX170/ZRiPHW5nw103Tufk3kWm5k+56m/cMKN6i0MatK1pFB0kyES2U92w+XAMdRCd/prMSK9fZi5q7V/deZZFBSF0aR7/VfSu1PReGC8fmutFfz+WuErNfG1NQIcCjRygOANYgOI08S9VwnJmb9HxJ1QW+A+gXnlAfyCsQD68/AjYqCG9+UlWqjOtBndVGmjXNXXvchTJ4b2b5d0oqSTpW0kKPBdq3OF4CkvjDs3P2CaJ+3aolZmFPSavqucEOjMEXtlGnTeRRwI9BfEZl9DWEh+q/tQ4k805ugfvdfZ5IKtYtSlOe+hDJdi2gg/Xviwp+8mJ8WljSbpBn8XZWZ2lzs5WG1MnACsAkwriN68moi/Wc3ot/iDoR/cTs11fWtC+WBfCRhadiKUKx3SJqiYfatU+BYWUnPVV4vSRQPeYoIHruAyA3+AviLpHEqErPDlGvsghLUB5E2cg+ws6RjiBzajYnrs1bnrkGTIh2v/H6eOGcrE/feooS1aNGyv3ZjrIKM8u26jE7kX65N+J62IPwbyxGRk1sRZhgTpqja+NwaKKJ5tycKVHwL7CvpIdsvSbqWuD6/sf1ciZ78rA4Pr7Ji6237c0X/z8+A+2zfWVaih0qalFjVHVapsO2kjG0UYFtF55vliXquB0p6Hfi3o5rTtEQhh9pRLAbrAVdJOsb2zpIuIs7X1cA+xKRhgSrlHBnKZHZF4E+S/kVU59qtsV/SXMQYdyrHd/n7rktgO3+66A/RzmpvItpuPqLCzN+A44EpyjFjVy1nB8c2BVEB6e9N204lgpD6lvejl9+9q5a3HeMaBfglMJBIiTmSSI8ZTJShaxy3AxGxXLnM7RjbxMDm5fXqRIWg44Zz3GrAI0Q0aOVyd2CcvcvvvkSO8KFt9i9GrOIGVi3rSIxxKeDR8lw5nuhqdFjZNx/R2H2VquWs20/tzGfdnSa/Yi9HHttfiSi7jYiUg+2AaYjC96MCn1Yl60jyBXA3MJ2k9QFsb0kk/Q8qY/uybB/6g9/SxXAEqJjvCjXc7WjftSmwv6SDJW1FlIi8vzpJ20dZca4P3FYikr8mqgTNJGkHRW1bJI1HlMPcx/Zlzb7Wrk6TrBNK6ucoGrI8sJyko8sxMxJWlQNd03J7xcowBZFjOhHRSGMXYAFJ+9l+ENjY9pV1HF+VZJRvF6IponA5IkDnXqJR9lvEimZCYlX3BDCz7cFVydpemsa2EOFz+5QY2wZEV5XbbF9Yjp3DUXmmlpTJwHlElORlwC223ygP49+Ww+62fX1VMrYHRbH3awg/98tETqmI1K1piRXO+URA3GbEyvTTOkWDNl2fqxBmzq+Bq2yfUOIZriHM9js2onnrOL4228YDziRW4PdLOp+IWdjINQmO62rkCrULUW7oFYGjiVJ7axLdOWYlzL6fEsEQo9ZJmcKwsS1HTAjmAc4g/MJ3EsEPvyl+K4jE8lpSHlxfE6u504jJwhpl99uEiXtfl/SfquRsJ7MQ1943xKrmX8Szo1GsYQdilbMZ8Dfbn0I9AuQa56Bcn0sTvXbXIvoJ7yNpD9sfEME6v5Q0s0s0bx3GB9+bLKwk6XRJJ0paxpFe1xsYvwQ59gE2SWXacVKhdgGazLxjEiam1YEhRO/LhwlzzMxE8M5xrlEVljZKYytgV9sHEONciaiFehbwT4oircuDaniUB1cvR7rItYTymUHS6YRlYdzmY6uSsz3YvhkYh7gWHy7jugoYk4g8/5BId1rH9kV1mSgocrwvVqRtQYxnJ2JysCQx4dtU0lFE2tYAR5/aWtE0md2fCGycGNiz7L6OKIB/CnCea1j3uyuRJt8ugqRFCIXyFdGu61xiNQARWfg80Q/zw0oEHAlKasy7RNTgm8BZjh6uCxAr78WJQJDalUpsmv0vDExo+5qyfVg3jrJvNuAV2zdWKG67UanoJOlsYlL3me2ly75FiLZ6/wUOb6xM64SkSwjT/Aa2PymT2lOIa/TW4jtdkKhe9UqVsrYHRR7tXGUyhKRticnd1MDuxHhfKpOf0YjgxvfqZMbuiuQKtWKaZvNrAOfwXYGGr22/RqxoHiMiQj/sfAlHDknzEo2IRyX8b/MRfVshgo4+BkarozKFYbP/VYmZ/2dN278twR/Yvsf26bZvrNHqrSHn1JIms72x7YWAz0qaBbbvBi4C/lE3ZVr83BArtZmA6ySNbfsz4HVgM0VP2pmBXWqmTHsRLoc1iwsJYvV9GrECX7so05WJFCDbfg/qYzXpqqRCrZ55y+//I0Lxl3bU4R1aHlxXAxfV0dRUokEPJqqt3Gn7DEKB/knShYQf9a/lIVZLFCXadiVSKG5TFNrYCKIRc1sFWpcHVlOAzkXA8ZKuUBSiGAh8IOnhctydrmFtZdtfK8oJnkJEY49GVLAaBzibUKp7Ez1A761O0vZTLCMXAi8QEcqLAycSgVav2X5dUXf5SCJv+MvqpO1epMm3QkqU3ZOEb+pvhGnpQ9uHlf2LAB/U6YHVbDIqK7QNiUCP/W3/vWyfh/DJDXHUDa2lmUnS9LZfkHQrYUUQEcG8KDEJ2qVSAUcCRW3Xkwl//hpEGtCyjZWMpBuJcnT3/PC3dG2KX/tR28eX9xcT7paVbH9c92jeMqHdhDDzXkAUuL+UCI6bEjio+MOTFpGVkipCUl9HP8+jgCWI2eMcRC7YN7aPKia12tDkT1yMMJW9QHSI+S+wiaSvbV9g++Hmz9XlYdWMpNGAMyUdRAR1/IlYbd9afKarqk1HmZrxJdHlZ1PCl7968bEtXlaly1crXkt4gXBFNNgceBE4r5jx/wv1uj6b/PljAh/ZPkLSH4F1gHNt/1LS6MAEtt+sVNhuSJp8K6DMHE8tgQLnEvmlXxH+jLeAtYopsRYoOoo0buYlCFPujESN3s0I3+nZwJaS1qlM0BZSzGQXA9PYfogIWrlV0vJExac766RMmyLNe0vqTVRBmpMoKLKJ7RdLWskJkqavUNQO0TS+BSUtpSitdw2wsaRlipL5BXGdHm57qGtUbq/4TRsBcOcRRTfOkrS37aOA/wCbS/q1o5fyW5UJ243JFWo1fEQUvj+NqGF7A5FfuiERNYlLU+2ujqJCzkaSTiSU6DbAH2xfU0xoWwKf2j6tmIBrneNWzNXPliCc+4nVzL9tPyZpSiLFaS+XKjp1Wd2UydDKhIn3PSJF6wyiKtBqkj4j0p7+5BrmKZbxrQAcU35uISxChxBRr28BCxHlIf9Vl3NXJgJflSC4xYgmEpsXf/7EwH2SPiB8xTsRirVWq+46kSvUavjKUQloINHtoS9RBH9V24/brlNhg6mJajnjExG8MwErSRrLUcLsfGCbEuxxoe0HqhJ0ZFDQi5gg3FwCj94lJkZLApSo7HVsD6rLA7mBpFkJC8kdxCTvemLCcABhPZkE2M41LLdXzt1EhB94FUKpPEnEJ1xATGT3AVZzSTOpw7lT5M9uTwRUQUyGtibyTCn+7o2J/NnPgKNtP1WFrD2FXKFWQJktj1J8UkcTymgC4JNqJWs/th+VNBT4P9vbSvqGKA6/LhFo9SaRTjJqHR5SbWlSjBOVB9Q2kn5FTByuJBL+exPmbQjrQy0eyA0UqU1/IiY8Z5ZtBxCWkzVtH9M8QajT2GDY/fYBUTt6IFEJaXXbbyrqSA+2/WSlQnaMIcQk9veEsty53H9/kHSX7TeICft0iq5Hn1coa48go3x/RpqCdBYmzElPAc/bfr7sH5b83/YzFYg7Ukj6G1E9ZxAR3LEGYQH5BjjJpeBBHZE0kCiv9wjROu9aR2u2GYhKT5sAV9g+vDopO46kaQi/74fAtk2RvIcSq555gC/r5hMu914/YiX6paK/6SbAJLaHlInE34Df1c1y0jS+2YhV6Nm2nyj7TiauyyuIjlUX2768MmF7EKlQf2YUidXHA5cTF/d/iUT4f1Uq2EjQdDPPQBSgeLmMc1bbRyuS5tcn0oCesH1S8+cqFL3dKBpoH0colsMJ0+eVwJm2Pyhm4KWBRR0lFbs8TedvISLK9X3gFcI8fx9wsku9WkXz+tr12gWQtBJhObgJeNr2nyXdRFgRXiFamO1v+8oKxRwpJE1OpKU9BlzgUvxF0hFEYNL6th+oecR5bUgf6s9AGx/TcsD2jua9+xL1XJeW1KduvqgG5WH8GyKacPyy+XFgKUlrO4rDn0/k184rad06KtPCDETqyIyEr/gfxOx/c0kTFgvDjMAqksaqwzkt528gkWc6NxGtPDfRGnB+YJfic6RuyrQpmnd8om/pVkTk7jyKQvfLlff/Bn7vmrcoK2bdc4kJ3zplkkt53lxPpHZNksq0c0iF2kIkja2oJmNJ85eV2mhEwBGOwtOPAotQU58igKQBwEHAb20/okgD+piIItxI0pyOUoJnEUEut9VtrOX87WL7dCKAZVMiaOwUooDDLHw3mXibqI36aR3GKWkCwoS9ArFa+wh40fbLRJnIeYlUrtpQAo8aK+9fEtHWUxIr7nuJyN6ZJR1p+yrbF7kUpajDOWtG0nQlyA+I0pZE8NhCRL73VmX7DkSltTErEbQHkgq1tUwLnC5pN0KZ/IIwF34paftyzHuEmW28KgQcWRT5se8BDwJzl7FeSPT9nIYwh85Ygq6+tn227berk3jEabNS+QQYUCYP3wLTAWtL6k8E8x1r+0UA25fVIXqyaXzfErnBawC/I/JM31CUGvwMWMU16jpSrjUXZbog0f7wG6Jgym8I19Zgwvw7maRZqpO2YzStvOcian6P1bzf9l2EUr0VGChpT0lT2d7DUco06QRSobYQR7rLA0T92pNtP0usXq4hLvIbicpBJxZTTa1Q5LndRZRne5GIDH2ZWA1cR/RT/IiowvJNVXJ2lMbqRtLaRJm2x4DGant7InL5DOLcPlqhqO2iSZFOAuDog/kesWrb1PazkhYlHsj9XKParorynX+X1FeRB/xn4ODiz96OUumpKN0HCTNvl5/8tKVcm0sT6T0H236r+O+bj3nJ9q22VyZcE7WYyHYnMm2mRTRF7N4MfAFsJ+kJ27cDVxdlOhXQy/ZzdfMplmjCvYGNbP9b0r3AUSXadT6iItLvbF9XqaAjgaLi0/rEyu1zYsK5jaRHy5iXA8YoD7Muf/5K9O4Stv+uKGpwoKTngJcIi8JQ4GxFC7NNgb1drxxobH8k6XFgAWJcnwHbS7re9lWKlK4DiNSms20PqU7akeYbwlf6DDGB/Z9Av8ZzKFel1ZAKtXU0cvT+CfxT0jvAaZLWIsy7q9vecdjBXfxhPBymJCrLrAHcVWbMKia2vwK7276rDopmeEiallhdn0Q0mJ6O6EE7FXCkpI0dLbzqlGc6JXBwUaz9CUvCGITy2YVYdb9EjGk723fU9Pz9B1jcUZ1rYyL471hJO9q+VlFK8d1qRWw/TT7hGYBPyvlZELhT0uO2z2/2HcOwTjNJRWTaTIuRNGqJckXSlkQVltGJ+qCXVipcO2i6mfsBQ22/o6hTux1wve2Ty3FTA6MXs2EdH8aNIJ0dCUW6KbA8ESG6K2HWXoEocFCriFcAReuuo4H3bP+6mAmnJJTOebZvq1TAFqEoc/mU7X0VnXK2I4ql/M5Ru7aWKKLpdyWCGUcF/kBMiC4G/mj7rOqkS9qSPtQO0hQksICk1SXNI2lMR59FAdg+lSguvobtS9sEvXRpijJdlWj7dLqkQ4iVwIlEeszO5bhXiq+4Lqu2/8H2f4nekBcTQVWjEkEfk9jenShJVztlCtGvFNgDWETSlsUc+AphPpy1Wuk6RtO9N0DS/GXz1sBYigjzZ4k62Z/wXTP72lFWpnsS1Z3+S1TnGr1MgtYCTpY0eVtfalIdeSI6SFE4qwB/IXL4jiTMoY19vcrrl2y/2thekbjtRtIcwM7ASkTawbLAa0QazJmEUp2mOglHHkVaEwCOlJfTiRXp1MCvgSPKvv9UI2FrsH0L4XvbRdIhRQktRORE146myd7JhAkbwnf6FnEvQqQ67eqomV1XxiLut2WI4iGbO/qzLlSU6hS230gzbxfCdv504IfIQTwXGJd4WD1ARFH2IgKPKpexneOZDPh7Q3bCrLQbYQK9G5iubJ+5/J64aplHcrwzAvsTcQSiuD/KvjGJAgfLVi1nO8fUq8373m3eL0sEzN0ELFi1vO0c2zjAhOX1dETh/qnK+2mJ3Nm+RN7pklXLOzLnj8hRh8hhv5aIqJ+mbPsV0ad2cr5z2akz5cyfH/7JoKQOoGjh9S3wKfB/RIHqtR1+xmWJsmbPVihiR/iESHu5qKSNvAEsTija9Rz9MH8N7C1pNdckt/RHmA6Y3iW9p9kc7+jMcX9ju8tTq6siqY/tRguvOYCxgUdsf1bSRb4BsH1ziVT+yva9lQrdDhRFDA4HHi6+0q+J++/XkqYjAq6WJya2exAVgx5xmPK7PJImBMaz/R9FCc8VJH1g+wBJF1Daykn6N/G82dNNaXdd/frsSaTJt52UgIdjiU4PDxOz/gOLwvklESU61g9/Q9ejKI1PiN6QkwNnOFqRXUf0L11S0ZXjSOCQOitTSWMD2L4BmFjSfuX9cB9KXf1hJWlSIk1k6jKZu54w1T8saTzb36g0gIfwqdZJmQI4Ul1uJmpDr+xwoRxPVCC7C1iTKBA/G/AqcE2NlOkYRKDRxsWMfTixyl5T0lFEx59ziEnSAGA3RzpQbeIxehIZ5dsOFPmWFxOJ1X9TVNFZlbjRHyGCB3ZxDTurKJpLb0tMEpYiStGtL2lN4kYeB7jS9o11WLUNjxLksTPwYDl/8xL9MY8kmqDXcUwzEWUgHycqVf3V9n2STiJWbfPZ/rh5pVonVIq6S1qAWJ3NTExgz2g6ZiliIru9w1/c2F6L67RYDZYmTNaP2T5O0W7tCuK87uYS7FiH8fRkUqG2E0l3AePanqO870f44yYA3rB9f90u/LKCuYR4GF+nKIx+PFHc4He23TArVipoB2hK/5kSmIKoUbs3UaJtcsJc+CfXrPuPpD6Ez+2LMrHbhijkf7jta8sxJxDRoDM7qiPVEkUVp1OI1mu/JvKhryIsKOMQ1+7+jZVbHe49SaMTLocnipXhV0Qf4QmBPWw/LWlM4Eai7eOWdRhXTyd9qD9C08N4XmAiYva4qKQ7JF1ne0XbbxJNtIdRwwu/F+GTahTc/ogIUDoVuJTwTdWyW0U5fysTeZe/tX2vpAeJQJbViVXc9pKetP1BhaKOMIpCBYsDvRRdVfoRbogdie4+L9t+wvb2RfHOA9xekbgdoo1inIxoAv4g8KCkDQhf6RjE9TnQ0Sy8LspURJ3vlRWF7OcmLF3PEebrVSR968jtXh6YvQ7jStKH+qOUh/EqRCWg5YFzJC1pewlgVEl3VCthx2jK4+svqW9Zef4NOEzSYsU0+EnZdiiAa9r+SdHc/WBgszLrn5g4tfc5ckw3Ar4kfFRdHkkTl3PxOZGjeAzRtP4xoo7tL4gH8lwAtreyfXudfG5NE9mBks4mgvz6lIktts8jyu8tDYxWJrW1mcgWOZ8jsgK2BO62/YGja8x1wMTAepJmsf2Z7fsqFDdpB6lQf4Ty8N0MWJKoVDI+cSNje9k4ZFhieS1oelgtR9y8f5e0NzCYKEd3kaQ/E8W177B9f3XStoRRicCOGSXtRJgKjyl+Nxz5fBMDK1Ym4QgiaTTggBKs8jCR7D8YGFPSBLafIIJaZidWP8MmCXVRNjBsIjsvsB5RSORBIsd0BUnrlFiG0Yha0rVpMqFou7adojziYoQZ+0hicr4ZRCQ28C8isLE2TQqSIBXqT/MO8EeiUfF6xbS0vKRxbC9eN4VTHlYLE6allYnC4aMTpdruICYPFxOl9mpXlq5p9d2rmEZfKLv2IM7lHkT92lHKceMSE6V/drasHeBrIuJzImAvopD/ycRKbc1yzEuEuX5QidyuHcV3uCrhL/3AUbjgL0TxhjWIUop/tf1AZUK2E0mzEv7QGQkf8D+Ic3YGpUeypDUkzU6c3xNc2gMm9SGDkoaDIu/tS9tfSTqQaNu1ie27myIK13ZNOnMocvVWsH1y8amdB8xve9qyf2Hi4TU2cJrtJysTdiRoWn2vTERc9yYiQl+RNL7tD8sD6x9EG69/lc+NYfvzCkUfYcokYS4iWvl52/uXSOyliPH+CljR9tMVitlu2vo/FbmZfyaKbGzv6PDTp9yTfW2/WyOf6XiEZeRM22eWbVMSyvROwiWxPnHNLgNs6EjrSmpGKlRAUl9gLkfi+0pE+siYwOZEp5j1iBy3u4ENiJJmV1clb3sp45sOeMn224om4VcAT9rerByzGFFm8Czbz1Qm7EhSzt/+RIWnQ4mAjxVtPy5pGeAoYD/bg2r0QG5MFMa1/XHZNiewO/Cc7f2K62EpInCuVi30msb3a2KyMKrtAxVNC/YCJiVSR9780S/qopSI3tOArW1/Kmn0Ep09FfBvYFvbV5Tx9qvrhDZJhYqi5u4ORPrEfURo/q58N1vcimjUuwRhGv2Pa9SmTKU/oiI15hHgRtt/UITqnwG8Znurcuz4tj+sUNyRooxxXyKNYjrCjP0g8Dui2swbwLRFudbl/DWUzUrEqvRx4JlibZiDKA/5lu1d236mIpE7hKSBRJ7ptsDpxERhlbK6O5jwc2/keqZuTUAUoNjVJUe9abW9O9HN6chKhUxaQo/3oRb/zAVEvcyFiBv5Xtv7EJ1H/gL8wvYlts+1fVf5XJd/YJUH67eKlnLfEG3IFpfUqHa0GTCzpDPLR2qXq9gcvVrGeCjwPjEp2sb2nwhFegfwTcNMX4fzB8N83ssSVax2IfyI+0nat0T2Hg1MKal/82eqkbZjlOCptYhWh32JCexEku505M/uS+SZ1k6ZwrBuRscBa0iau2xuRM2b7wr8JzUn81C/42Ii4GEFSQNtX2378OJz/IukpVyz5PimaN4NJN1s+9xiVrtB0lDb+0hal2iiXccHcWP19isistV8VxbyKeKhPAkxMRrkGvbFLKvuvoSPbRoi+X8d4JRyDg+W9LsaByD9ggi22oVYhe5LmK4/Az6RdJPt5YBa5Aj/CJcRXYy2knSJ7VskLUK0ndusWtGSVtHjFWp5YP0NuLf4bXoTrcm+tX2t7f+TdF7dlCmApNmIFds/iFqhUxNpCMsDd0kazfZuREpC7SjKtOEX3YKIohyPyM38iDD1rkC0vapN/dpmk21ZdZ9fzIaHArvbvkPSPUTB9Atsv/Bj39dVUaQB7Qc8YPvEYt59jGjS0J9IKbnlR76iNpQgquOJydDJku4HZgF2cg2j6ZPh06N9qJJmsP28It/0YiKH7y6ijNs0wPWuUTkz+N6qbXpgSqK82RmK8nS/B54nlOrowEyuWcm9BsXU24tYkf6DmBweTaT7vFIsC+MQTcKfqkzQdtImUnlFYgxH2H5M0unA5UQLtvWBw2w/V6G4HaasTF8DpidWb38k7r0TiPzLXwMbuBSlqMv9NyKUoECIZuEvdbfx9WR6pEJVNJaekCgZeFH5+YQoAn8skZe4GXCJa5Z+AFBWbf8gkv7nJkqXvatoO/cnwhx6kGta/agZSdsDcxKz/Y1tvyBpSyLt6exqpesY5fwdQvgU/wJ8bXtFRWGK+crPnravqEzIDlIsQv2IBuA3EdYFEdHzu5R94wF96mRVSBLouQq1EWH3R8KvMQFRBuwj4G+2byjm0NpVKpE0CxENepqj68jRRLPsNR39WucjHtCPVipoi5C0HmEK3bz4peYiGr/vbPumaqXrGEVx3kf4Tncj8hL/U/b1Avo60p9qu7KRtDNxXU5DpI70I1K2Mv8yqS09SqEWM+EviCCVjYn8trkIE+gWhKl3XCLl4qs6reDKg3Y0IppwXmBff9d15HBgOSIfs7a9TGGYX/i/bio5V1IPFiVMhVMR7fUGVSRiu2hEKTcrRkl/IPzcowBbOXrtrkVYG/a3/XUVso4MZZyzEf7tfYjSehMSlayWI3K+xyQi6mvXZi5JoIcp1AaSdiRMhE8TRRtuLBGvMwFj2X64UgHbQZPPbUzbn5XAjgOJSNfzHfVdkXQMcLGjAHetaBrjfMRqdCvb/1HJsS3H9CeiRXs7unR0+dVbG/kXIuoOvwR8StRzvdL2HpKWIBo07Gj7xqrk7Qhtz0NZffclqnLNDlxg+zRFG8Sp08yb1Jkeo1DbmnDLw/kXhK90CcJkeGFV8o0M+q6602vAQ8D5wBFE/uUVth+pULyWoKgEtB7wqO2zmrZ3ecU5PEo6z9W2F9B3dV7vJgKOziSaMFwIvEy4JQ53zRrXN02EliVW1y8RJfgmIIrD/x9hUdiu+ZwmSV3pEYUdJC0NrC+pTzGNYvtB25cQeWC3E9GvtaOsXg4gChl8QJQ3+4hYyU0HrKOmriM1ZgYi6nUWRSk3oH65sw1svwM8J+k5ojrXQKKV3PVEus/MthcnTKHr1U2ZwrC0poFE9PwHhFvlRMKdcgkx7kFE9ackqT3dXqFKmpFIMXjI9lcNE1vZ19v2K8DqjubFXZ6Gciz5shARyTsTDbN/SXTpgDD57gb8o25J/yqU19MqatieT5SBXAhYtkRq15KmSd0GRE3lHQlT9RfArcQqbjtJvy1Wldq0KGumrMLXJhq5f0R0UTFwoqKv673A71yjrjFJ8mN0W5NvUTiTEtGSdxJBSEOHF2hUF7Nh8ROeBPyHMAUeR3QXOQJ4HVjJ9keK6kirA7vY/qwqeTtCG7/iisTq+zkiH3MXwvy5B/H/cHUdA3Tgf8Z5ChGYM5ftT0qe4jLA43U215fCDZMTwUZ/JyqRTUK0oHuc6OI0tHmSmyR1ptutUJuiJoeWSNCdgQWBJX4oarcmynRWomj4+YSvbVJgMdsXEybr0YBvS0GA4whlUzdlOhOwqaTRJE1DFGrYiVhpX07kCz9JdO7YiVid14qm67PRsADbWxM+1PvKavwtIoCszspUtr8s6T5jAv8qr/sAVwP/Z/vrVKZJd6JbrVD1XWeVRYlAo+eAm4mUiuOBzWzXoZH091BU/XkKeML2b8pDeRei0spB5f3BwExEOsIJtq+ty8obhrWYu5EoZvAssbI51Pb6TcccCrxs+xRJU9p+rRpp209TgE4fNxV5VzQu+Lq8PpNo8D4DMc+rnbIZXv62oh/vDeVndaJrzM1VyJckPyfdYoUqaTxJYxdluiKxghmXMJs1zEs7AxdJWrIyQTtIeQCvCywk6fdFSY5BrOauIMZ7PlG+bbW6KdNCH+J6HAicTOSUzibp4KZjPqQU8qdmfsWiTJcHjpK0naQFyvavm3yqmwIrF+tKbZRpk797ZmBHfVdarzHJfZEIKLuaiFdIZZp0S2pfHF9RGajR2uoTIhx/N9tXl1XPasCfbP++BEnUEtv3KzrF3FTSECYlgq0mI8Z8DNGo+ItyfG2UaVH+r0u6niiWfpTttyT9BrhC0bv1ZqI83R9gWNu92lAmcscRka6nANNJerhh9iwBckOBJyoUs0OUycLSQKMM5FBJFxYLgotSfZ6aRtInyYhS6xVqCTzalTCHvlf8bpNTIl1tvws8AEwqaSzbp7kU265K5pGhREMuTbS3uqFESQ5yNJdez/azlQrYQZqU/6tEgNVASWvYfpmoGPQZYc7e3Xatuo+UgOVewMJErvAXxOr7mLI6HR/C519+12Yi1KDkdJ9M5JWeQOR3rytpMge1mvwkSUep9QrV9lBJJxPt17YEZiYiQP8qaXfbhwHfEpGFExEVaGr50Gpg++GyQr1O0hDbfy673q9SrpGhYZ62fWJ5/ziwv6KF3uWSdmycs7qYshv+/CKrJb1MRCyPCfymrMjXBPpKOqUOY/oRZgIetP0Q8FCxLOwBIOnvrnm5yyQZUWq9Qi0MJfxqzwIzlgjJQ4A1JV1O+BaPdOSbdgscObMrAwdKmrouSqaZZitBMRk2v7+EqPd6tKTVmsfW1cdZAsgaUbxzSlpU0phEa7LPiMnfW4rOP/sBL3X1MbWlyWfayIV+kGjmvhyAo47yE8CMRIWk753vJOmudIsoX0lzEF0rfg8cb/t6ReL/jMAXjuLitVM6P0VJsfi4ajnaS1PE67LAfLYP/4Hj1gDesX1n50rYMYqv97dEb90ZgbOJFKc5iNaAiwK/IZTMUOBo21fW8dpUtJhbGHje9gWSdiOK3f+HULBHAA8DE9nepDJBk6QTqbXJtxHI4Wi+/CpxQ29T/KWXEjmLQNdf2XSQIVAfM2iDokxXAQ4igsmG0RScQzmHdRrfOERLsrEIq8lqjhZ6JwL3Aws4WgP+gujX+kaNxjbs3CjS0k4iVtvHSRqXqDu8EJH2tDoRPDYxsImk0RvBcknSnamVybfJ1DRd84MXwPaHRBm3K4HfSerb3c1MjQdxXR7IDRTlE9cHVgFul7SEpGPKRGhoI42kQVcfn6JG9BglkvVwQpnOSPjusb0d0Uz7eUkT2f6PS/u5rj42AEmTNSnTmYlawwfYPhJYligJOdDRXGIVIrJ+CiLy/KhUpklPoVYKtaxsBhKz41kb2xu+nGL+vJToHPNuHR5WPYU2k5vPCOvIX4k84dWJ1c25UK+UmOJaWARYXNLaREGRYwmf/jySZgewvQNwCZFWUhuKT3hTotgERM3oKYl6ypPafowo67mDpD3Kufuc6DO8rmtc7SlJ2kutfKiSBhA1Qdex/WhZ6Xxh+xtJozgbE3dpJC1C5M++QvjXtgXuLWbR6YkOOZvbHlKhmO2m+IL/BPQHtnHkQPcnCm28RJSBHNx0fJ3MvCKKiExApKjtDCxOFL1/HLjE9rtl4jC+7X9VJmySVEwtfKhND6DZgHuA9yXtQhSGn0zS/G5T7izpGui7cpDzE30+7yByhV+2/ftyzFrA3sB+dVOmhXuI5uYPAGNKmtD205IOIXIze0l6oTG2OinTIutnxe87KWHS3o1Qsr8GNpR0ru1swZb0eLq0ybfJTNin/L6M8E1dRpiVtgYGE5WCki6ESs/SokyXJarobGr7d0TFo76SDi3+0uWBvW1fUUe/t+1PiU4qfyeuxTXLrtcJk/bldZsoNEViTyZpPNtPAHsR+dxHE3V5byRyv8esUNQk6TJ0WYXadEP/CjhC0u+BUQkf1dK2TwbGJtIR3qlQ1KQNkiYCDpM0Ttk0DRH9OVN5/zHRaHrc4nPb2vZVdTCFlgCkMcvrcRsTANuf276MWKXOJumvwDPAK8XPWCvKvbcy0cnodElHOGryHkxEM58EXENMhF6uTtIk6Tp0WYVabujliUjBy4EdiJnxIsAXkhYnonr/VMcHVnfG9vtEd5+JJS1o+2/AdsDJkuYoSnQsYF5JEzR9rqsr01GI3MtlJG1AFGYYq+xrKNZziOv1KWKi8FRF4o4UkmYgGjJsTZh4F5J0ou0XCLPvWEB/2+9VKGaSdCm6pA+1mAHHAdYC1iEKwH9J+Km2JJLinwPWtv1AHVY2PYES8dq7pEm8BmxDVKza2fbJJWL0EUVDbQGH2/5vhSK3ixL8ZqIX64zA9o6G4A1rSqPc4O3Eyq5WAUgNJM1JRCq/C9xv+1NJqwOXSPqb7c0lbW3780oFTZIuRpdSqI2HT1nBfCTpD0R04UlEk3ADLxI3+kGOYvFdfmXTEyipS78BPpQ0IbCB7VVLJPYBkva3faykz4iH9dolGnZYP9CuTJNivJdIifkMGLekjrwNw0/3qdu1qegaswil1RqwqKTbbb9XgseukjRb8akmSdJEl1GoTbP8JYgSbYMJs9kXwHhEFaTRgIeAvzsKOSRdhJL0/yyRBzw6kRKD7YMl7Q3sLelQ26cWC8QgSXPWJTq0XJuzAbsTK+85iDKD4wMnSJoSGMv2M9VJOXIoWiGuCZxu+yFJnxCpMpb0z5Ies3gdJkBJUgVdxodaHlgrEcEqHxDF0dd3FLu/nPCXXgv8JZPFux5lQvQYMAh4Dxi14R+1fRBR3/X/SsToKYRSqtuDeQjRvegYopTgpUB/SacTqTNjVyhbh5HUu1gSjgfmIyau2D4VuIDokrNUOcd1O2dJ0mlUWtih5Ot9UF6PQUQQHgNMD/yZKGf2hqTxiHJujYd20oWRtCARuHKu7dPLyud1IvG/dl1/JPWz/WZ5PRWwJ6F0tiAil5cA/mP7puqkbD9NVqHG7xmI++5u4JSGf1vS1sBDtu+rUt4k6epUplBLAMttwD2OBtlIOhiYlzDxrmv7FUm/Jqoh3VqJoMkP0lS0YUzbn5VtjYfzUkQU7D1EhPavbf+z+ZjqJB8xil94fMLNsL/tM0s079TAKcBbRCTvl+X4WowLvneelgFWIJTorYRr5RTgZuCMErGdJMkIUInJt8l0tArwK0m7ll23Esr09KJMFyYCWIYO/5uSKpDUMAl+K2k+4EhJvYqCbRTsv43oOPIo8KuGMi37urTSaUqBGVoUyibA7pJ+W4LmXiaU7BREYQPK8V16XM0UZboCYeZ9lEiNOYSIvt6SuDe3LKlCSZKMAFXfLJMAjwAHF7PuwUQbqDUU7b2mB3Zufhgn1SKpL7CdpJscdVunBoYU5fq9Kke2HyZq9jY+2+VXcG2C41Yi0rNuImrXXqIo6vA2YUnZwfbT1UnbPiRNR9ThPY+oeLQGoTinISayXxFBSAcThTgmcdbHTpIRplMValNajCUtBJxFREqeS3Qe+cz2IZL+AfwC+ND2s3V4EPcgviJq8a4maQhhIvyw7OtFsSY0zMHNH6zDOSzX5vLACUTt4VmAVYnAnDUJ83U/4NSaKdOZicnqQUVJvl2ir8cm6g0vSsQpXAl8QxRMeakicZOklnSaQpU0KbCVpIPKg3YC4C7b95f9iwGPSxrf9m5ErilQjwdxT0DRE/MjSTsTUdgDCR/jFIrKVeNKeoeYGNU5T3FuYF/bF5ZI5aWB3xN9QH9PxB58UZeJnqRZgZOBE2xfUsy4A4ic2imBXrb/W6wPDwEnNXziSZKMOJ3pQx0NOB+YXFHj9VWgn6SJy4PpNaKAw28lTduJciUjQDlHQ0sQy+LEqqahbPoSJtH1CIUzSWWCdgC1aWgOjAtsBlAiXR8mxjqR7S9dGmbXRJmOSqQyDbH9txJodQOwQDEWPUgUUfk3UczhjDqtvJOkK9FpK9QSZNQHOIowE25EBEOcA/y5+KamIQJYXuosuZIRo5hCBxKKdA/bQyQdQORlGrjU0de0t+1aBJFJGsv2p8X/uwjhD36GCITbV9JxtnckuqlMSphH365M4A5g+2tJ6wHXSNqWqII02PbxTcf8StKiwCfOHO8k6TCdnjZTchK3JsxM20vansjlmx042vbVnSpQ8oM0FE7jNXA2cY7uUSkZKGl8IojFwJ62P65O4hGnFDK4jkjteZ0o0vAoMUH4EvgLEaAzEbEC38/2FZUI2wIkDSCCq562vXDT9gWI1eqJlQmXJN2ETlOozf4mSTMRwR1DieCHLySNU1Y9tfBLdXeKWf48YBPbHxQLwnWEQh3UWIkqWrV9AkzrmpXdk7QJ0QXnXWAfR6OFGQlf6Tu2jyruh69tv173a1PSXETR/t1sn1ZW5X8F/mD75kqFS5JuQKf5UIvJsHd5/SxwHDAGcErZ/lnjuM6SKflhHA2xf0c0Ah9YglQuAAYoWrANLQ/kiwjfYq2UKYDts4jcy18CC5XNLxPBOjOVY16y/Xp5Xetrs5hzlyPS1E4CDgN2T2WaJK3hZ1mhNuXy/ZIwmfW2ffFwjpu57Huy5UIkHaY55UXSmsQqZm3gP0SRg6WA+4gcxh1tX1ORqO2m6drsA3zraMm2BbAHsJ3t60rg1YFE95wP6q5I2yJpfqKIym/rbMZOkq7Gz2byLVVYjgL2Iorbb277zLKv1qaznoCkeYB+tq9V9MI8EtiUKFG3IJGL+XIj7akONCnTVYiiBmMDe9t+UtEw/CQiDxPg4u7sz5c0tpt6uVYtT5J0B36WKN8Sqv87okH45ERu2w2N/XkD14JFgVUlfWv7spJachqwq+1BFcvWIYoyXZHIoV2DyM28StImts9TlFTclVi5dffG9Z9WLUCSdDdarlAVRdG/JpToGsDyRLPpNyRtCLxi+45W/92kNUia3PYbtk+UNBTYppiALykTpRMl3QO8V1NlMzfROm5uIh3mXOAiSRvYPkPS1bbfge498WuMrTuPMUk6m5aafCXNTbRf2xZYh2jGPIPt14oJ8WxgK9v3tOyPJi1DUj8iBebfjl6YSNqOUEB72b5C0qS2a5WL2UypEjQhEWC1pe3nJd0F9AGWtf1RpQImSVJbWqZQFb0UdwO+tL192XYhkcP3DOF3O8D2lT/8LUlnoiiWPpAw/71b0mE2I5pM31+iYJF0PVHDdzPb71Ulb0cYntm2rLRPJfIyXyJ8w3+z/e/OlzBJku5CK02+IlJf5pS0pO3bba9TfFafEi3ZHuzmfqnaUOq7XgVcQyjLg4qF4SLCZL9YKX5wJ/AxkX9aG2XadJ1NCLTt6dkLeBBYhohY3jaVaZIkI0uHV6hNEZPzEuayT4AXiKjeXsC1jvZeSRdD0SrvKuDMpsjrKYnuKv8iUkZWIgLLpiIKxdcm4rXp2vw1sDewOvB22dbYNwYxCZzc9vOVCpwkSbegQwq1qUrOr4g2V1cD6wJ/BG4hfKjjEKkHd7dQ3qQFSBqdiNjd2vankkYv1aqmIlak2zZySyVN6WhcUCtKcNwpwBa275Q0hu3Pq5YrSZLuS7sqJUmaEKAo0wkJBbqj7Z2BlYGDiOLbJwCf87+mtqRrMAbhJ10SoCjTPrZfJXyLfRsH1kWZShpFigbnZfU5A1Gn9+VSYvAuSXsW/2mSJEnLGWGFWmqaPijpUADbHxAm3k9LWsWDwI7ARrbfBQ6pYzm6noCjJdlxwBrFbwqlMThRGH5KSQs1SkV2dUrVo0WAeYrVZB1iQrcPcAYwHnA4kcI1U1VyJknSvWnPCvWbcvySko4p294kOseMUd5/CnxbUhMycbxrcxlx/raStExTbd69gF8B67smbdgKkwKHAqcDL9g+F1gfWNf2ccBdwFh8N3FIkiRpKe3yoUr6I9CbMAl+Y3t3SX8jIilfIxpP71vXSjo9DUmTEqu5bYH7idXbwXVKbWrUHZY0BRGx/AJwIvDPNvWI9ybSti6vTtokSbozP6pQJf2C6JV4YXm/HOEn3YOogvS+7X0VzYn7AW/YvjtTY+qFpMnKyzFs/6cpErZLn8cmOVcgVqjXEwX7ZwXutH1pSf35NRHl+8+uPqYkSerLDyrU4pd6FpiaaPN0H9FLcSAwPhENuiPwie0dOkHWJPkfJK1EVHfax/ZViobnmwNTEM3ClwZWs/1ydVImSdIT+EEfqu2viNn+y0ShdBHpMQsD8zl6Kx4LjFOKBCRJp1IidtcHdijKdFTbHwJ/IyZ8fYD9U5kmSdIZ/GhQUlGaqwCzE3mlvy27+kmaCXiMeJhlP9OkCnoThScaJuuGuWUc25fb3qGUU1Q14iVJ0pP4yShf248CKxC5pQvb3pYo4vCigyE/s4xJAoTPtPwev/Tz/IJofr6CpIUczcIXBQZJmq5xfPpMkyTpDEaolq/t+yUtC1wjaWLbx//MciXJ92gKQFqV8JH2knQS0SZwPOAMSTcCKwI7236xOmmTJOmJtDdtZkHgZmA24LVGWkKS/FyULkYTlEnd8kSU+UDgCCJNa2+iLvEMwETAh6XISJIkSafSrm4ztu+VNIXtj38ugZKkQcktvYMobg9RmGEnYCFgRkKp/h8wMXCG7cGdL2WSJEnQrlq+hSHwnT8rSX5GxiCKNcwt6cxSlOFpYGPg97b/CjwArEoEzSVJklRGuxVqI8AjAz2STuBVYGzCzPsIDKsh/QGwoaRfAqMBe9p+qzIpkyRJ6NgKNUk6BdtfEivSq4GxJC1Zdv2dKC5yAtG4/t4q5EuSJGmmww3Gk6SzKKURtyUKNVxi+/6yfXLbb2Q5wSRJugK5Qk26DJJ6ld9jNm8v5tyzgc+ADZpWqm+W/alMkySpnFSoSeVIGg2gdI2ZDzhSUq+Ggi37ngfOBz4hFWmSJF2QVKhJpUjqC+wpabGyaWpgSMlx/p7CtP0s2bg+SZIuSrvyUJPkZ+ArYHJgNUlDiN66H5Z9vSgNwRt9T21/VomUSZIkP0EGJSWVIam37aGSxgH2AT4ionenAP4CjAu8A3xm+4nKBE2SJBkBUqEmldBUm3cZIpf0TmA/YCkiz/RpYALga+Ac27dVJmySJMkIkCbfpBKKMh1IlA7cw/YQSQcQTcENXGr7vsYqtlJhkyRJRoAMSko6DUljtXm9CVFC8PrSHHwIcAhRHWkjSeOmMk2SpC6kQk06heInPV/ShGWTgb7lB2JlCtE0fGfghGzCkCRJnUiFmnQKZfX5O6CvpIElWvcCYICkOUpw0iLARcBEmRqTJEndSIWa/Ow0CjTYfhuYAzi7BCPdUA45WdLRwDnAMbbfqEbSJEmSjpNRvkmnIGkeoJ/tayWtDhwJbArcDSwI9ANebtTpTZIkqRsZ5Zt0FosCq0r61vZlZdV6GrCr7UEVy5YkSTLSpEJNflYaHWFsnyhpKLBNqXp0iaRRgRMl3QO8l7V5kySpM6lQk58NSf2AgyT92/aptv8iqTdR/L6P7fMl3Wr73aplTZIkGVnSh5q0DEnTAQOBT4F3bQ+StBkwH3C/7bPKcdcTNXw3s/1eVfImSZK0klyhJi1B0qzAVcA1hLI8SNLcRBrM18BiksYmSgx+DBydyjRJku5ErlCTkUbSeIQyPdP2mWXblMCZwL+AA4GViDzUqYB9bV9dkbhJkiQ/C6lQk5FG0uhExO7Wtj+VNLrtLyRNRaxIt7V9TTl2StuvVSlvkiTJz0EWdkhawRiEn3RJgKJM+9h+FTiV78oLkso0SZLuSirUZKSx/V/gOGCN4jeF0hgc+BKYUtJCJcI3SZKkW5IKNWkVlwFvAltJWqapNu9ewK+A9bNzTJIk3Zn0oSYtQ9KkwDrAtsD9wEzAwbavrFSwJEmSTiAVatJyJE1WXo5h+z+SVBqKK6shJUnSXUmFmiRJkiQtIH2oSZIkSdICUqEmSZIkSQtIhZokSZIkLSAVapIkSZK0gFSoSZIkSdICUqEmSQ9H0l6SnpD0qKTBkhasWiYASYtJuk/S0+VnyxH4zNySft30/jeSdv95JU2SINu3JUkPRtLCRA/beW1/KWlioE87Pj+K7W9+BrkmA/4BrGr7oSLXDZJebzRa+AHmBgYA1wLYHgQMarV8STI8coWaJD2bfsB7tr8EsP2e7TcAJL1UFBmSBki6vbzeX9Kpkm4EzpF0r6TZGl8o6XZJ80kaS9IZku6X9LCkVcr+O5tqPiPpLklztpFrW+As2w815AJ2A3YvnzlL0inlu56VNFBSH6JV4Dplpb2OpE0knVg+M42kW8pK/BZJUzd91/GS7pb0oqQ1y/Z+ku4o3/W4pMVb+R+fdD9SoSZJz+ZGYKqilE6W9MsR/Nx8wCq21wcuANaGUELA5LYfJOo432p7fmAp4EhJYwGnA5uU42cCRrP9aJvvnw14sM22B8r2BtMCvyR67Z5CPM/2BS60PbftC9t8/kTgHNtzAucBxzft6wcsRqzWDyvb1gdusD03MBcw+Kf+U5KeTSrUJOnB2P6EUI5bAu8CF0raZAQ+Osj25+X1RcBa5fXawMXl9fLA7pIGA7cDowNTl/0DJY0KbAacNZzvFzC8Mm7N2y6y/a3t54AXgf4/IfPChBkZ4O+EAm1wRfmuJ4FJy7b7gU0l7Q/MYXvIT3x/0sNJhZokPRzbQ23fbns/YDtgjbLrG757Roze5mOfNn3+deD9YrZdh1ixQijFNcpqcW7bU9t+yvZnwE3AKoQC/gf/yxOEL7SZ+YAnm0VvO5SfGGpbmo//sum1AGzfASwBvA78XdJG7fz+pIeRCjVJejCSZpY0Y9OmuYGXy+uXCCUG3ynZH+ICwsc5nu3HyrYbgO0lqfyteZqOP50wud5v+4PhfN9JwCYNX6ukiYDDgSOajllLUi9J0wPTAc8AQ4BxfkDGu4F1y+sNgH/92IAkTQO8Y/s04G/AvD92fJKkQk2Sns3YwNmSnpT0KDArsH/ZdwBwnKQ7+a5h/A9xCaGsLmra9n/AqMCjkh4v7wEoPtaPgTOH92W23wQ2BE6T9DShDM+wfVXTYc8A/wSuA7a2/QVwGzBrIyipzdfuQJhwHwV+C+z4E2NaEhgs6WFiQnHcTxyf9HCy20ySJJ2OpMkJv2p/29924PNnAVfbvqTFoiVJh8kVapIknUrxRd4L7NURZZokXZVcoSZJkiRJC8gVapIkSZK0gFSoSZIkSdICUqEmSZIkSQtIhZokSZIkLSAVapIkSZK0gFSoSZIkSdIC/h83kf+Ba8ofOgAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                                      Survey Option  Counts\n",
      "0           More ideas for where to walk in the app      43\n",
      "1                         Reminders/prompts to walk      69\n",
      "2             Quick tips for easy ways to walk more      39\n",
      "3  Quick facts about the health benefits of walking      49\n",
      "4                  Earning awards/medals in the app      53\n",
      "5                           Other (please explain):       7\n"
     ]
    }
   ],
   "source": [
    "ax = option_counts_df.plot(kind='bar', x='Survey Option', y='Counts', legend=False, color='purple')\n",
    "\n",
    "for p in ax.patches:\n",
    "    ax.annotate(str(p.get_height()), (p.get_x() * 1.005, p.get_height() * 1.005))\n",
    "\n",
    "# Set x-axis labels to the text in the \"Survey Option\" column\n",
    "ax.set_xticklabels(option_counts_df['Survey Option'], rotation=45, ha='right')\n",
    "\n",
    "# Add labels and title\n",
    "plt.xlabel('Survey Options')\n",
    "plt.ylabel('Counts')\n",
    "plt.title('Counts of Each Survey Option')\n",
    "\n",
    "# Show the plot\n",
    "#plt.tight_layout()  # Adjust layout to prevent clipping of tick-labels\n",
    "plt.show()\n",
    "\n",
    "# Print the option counts DataFrame\n",
    "print(option_counts_df)\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Data Analysis for Q21"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "34"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "survey_df.columns.get_loc('Did participating in the program lead to you making any other healthy lifestyle changes?')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1     No\n",
       "2     No\n",
       "3    Yes\n",
       "4    Yes\n",
       "5    Yes\n",
       "6     No\n",
       "7    Yes\n",
       "8    Yes\n",
       "Name: Did participating in the program lead to you making any other healthy lifestyle changes?, dtype: object"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "q21_df = survey_df.iloc[:, 34]\n",
    "q21_df.head(8)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "96       是\n",
       "97     NaN\n",
       "98       是\n",
       "99       是\n",
       "100    NaN\n",
       "101      否\n",
       "102      是\n",
       "103      是\n",
       "104      是\n",
       "105      是\n",
       "106      是\n",
       "107      是\n",
       "108      是\n",
       "109      是\n",
       "110      是\n",
       "111      是\n",
       "112      是\n",
       "113      是\n",
       "114      是\n",
       "115      是\n",
       "116      是\n",
       "117      是\n",
       "118      是\n",
       "119      是\n",
       "120     Sí\n",
       "121     Sí\n",
       "122     Sí\n",
       "123    NaN\n",
       "124     Sí\n",
       "125     Sí\n",
       "126     Sí\n",
       "127     Sí\n",
       "128    NaN\n",
       "129     Sí\n",
       "130    NaN\n",
       "131     Sí\n",
       "132     Sí\n",
       "133     Sí\n",
       "Name: Did participating in the program lead to you making any other healthy lifestyle changes?, dtype: object"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "q21_df.tail(38)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "11"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "q21_df.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "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>Survey Options</th>\n",
       "      <th>Counts</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Yes</td>\n",
       "      <td>63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>No</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>是</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sí</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>否</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Total</td>\n",
       "      <td>122</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Survey Options  Counts\n",
       "0            Yes      63\n",
       "1             No      26\n",
       "2              是      21\n",
       "3             Sí      11\n",
       "4              否       1\n",
       "5          Total     122"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "q21_df.dropna() #we will drop missing values\n",
    "summary_df21 = q21_df.value_counts().rename_axis('Survey Options').reset_index(name = 'Counts')\n",
    "total_counts = summary_df21['Counts'].sum()\n",
    "summary_df21.loc[len(summary_df21)] = ['Total', total_counts]\n",
    "display(summary_df21)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAigAAAEYCAYAAAB2nw21AAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8vihELAAAACXBIWXMAAAsTAAALEwEAmpwYAAAn9UlEQVR4nO3deZwcVbn/8c+XhD1sMRETtgAiEBAQAwoiRtErIhhc2MGwaEQFwRUQryDLvXiv8AMVQWRJ2ImobIKAgQhchRAWUTZBtgQCCXtAiASe3x/nDKl0uqd7JjNTNT3f9+s1r6n11FNVp6qeOlXdrYjAzMzMrEqWKDsAMzMzs1pOUMzMzKxynKCYmZlZ5ThBMTMzs8pxgmJmZmaV4wTFzMzMKqdHEhRJp0v6z07Gh6R398SyukPSvZLGtjDdK5LW6aUYrpE0vhfK/bCkB3uwvImSjuup8tqVpH0l3dJLZT8m6eO9UXZ/1FmdbHbuaUe9eT6VNCqXP7gXyu703CLpaEnn99Cy3j6GJH1f0pmFcZ+VNCOf79/XE8trIZ6xkmb2cJm9tq+qommCknf0a5LmSnpR0p8lHSjp7Xkj4sCIOLZ3Q21NvYMgIjaKiKnN5o2IIRHxSA/EsMiBFhGfiohJi1t2rYi4OSLW7868vXmRtd7hBHJhVTr39AZJUyV9qew4elpvXLAbiYj/iojiNvwJcFA+39/VnTIHQnLQ0yStJel3kuZImi3piGbztNqCslNErACsBZwAHAactRix9gpJg8qOwbqnpw90nzjMOjeAj5G1gHvLDmIAGgFcDowCtgEOk7Rlp3NERKd/wGPAx2uGbQm8BWyc+ycCxxXGfxeYBTwF7A8E8O4G5U8F/huYBryUV2BoYfyvgafzuJuAjQrjJgKnAVcDrwITgDeAfwOvAFfWrgMwCPg+8E9gLnAHsEYe93acuezTgevzdH8C1ios+xRgBvByLuPDefj2eflv5Bj+WljPL+XufYFbSJn8C8CjwKcKZa+d13Uu8EfgVOD8BttvLDCzZn99B7gnb7NLgGXqzLch8DrwZo7zxcJ6nwr8Pi//NmDdwnwb5G3yPPAgsGsndafhviVV0gAOAJ7I67sE8APgcWA2cC6wUqG8L+ZxzwH/WbNfjwYuBc7P++RLpHr6F+BFUn38ObBUobwAvgY8lNf1WGDdPM/LwOTi9DXrti9wSyvbBfg0cFcucwZwdE1Z+xTW60jqHHN5ukb1e8O8rV8knXg/0yDmXYA7aoZ9G7gsd6+Ut/mcHM8PgCUK2/f8wnwd+29wJ+eN75Lq4aukG5pVgWtYUK9X6cJxflzuXgG4EfgpoJpxY4GZeZ1m532+X6GcdwBX5v1wO3BccR/WWYdmMdU9TvLwE2vKuhI4tMFyts7xvJT/b52HH086Pl/P+/vnhXp7IKnevpCXp0J5+wP353HXsvB5K4Cv53kfrRNLx34dTzounwWOLIxfAjicdP58jnSMdOV8fRywPPAa6RrySv4bSapjk0l1cC6pLo8pXFN+UxPrz4CTO6l/xXPD+cDSeVlBqpP/zONHAr8h1ftHgW8UytkSmJ7rzDPASXn4E7mcjvg/Qjr231uY9515PYez6Hm64TLrrMuywImkY/Il0rVj2Rb2VSvnv7r1iHSdPDGX+ShwEIXjnXSuOCuX+2Ter4PyuHeTrpcv5fkvabBeD5IaPxrnH52NrN3RNcOfAL5a5wSyfd6RG5Mq4oU0T1CeLEz/GxY+Ee5POiktDZwM3F1T4V8CPkQ6cJahJlmqU1m/C/wNWJ90gtsUeEdhhxUTlLnAtnnZp7DwBWlv0glvMOmE+DQ5EaDmZF5Yz2KC8gbw5VwRvkpK5joqx19IyctSpEzz5dryCuWOZdEEZRrpABhKOlEd2GDefak5Qef1fp5UuQcDFwAX53HLky6w++Vxm5Mq4EYNym+4b1lwcJ2bxy2b9/XDwDrAEOC3wHl5+tGkE8E2ebv8JG/D4knoDWDnXBeWBd4PfDDHOipvi0ML8QVwBbAisBEwD5iSl78ScB8wvtm2a7Zd8j56b45rE9LxsXPNenXUs5OA+dQ55mqPtdy/ZN5m38/b5WOkert+nXmXzvt2w8Kwu4DP5+5zSUnkCnl7/QM4oF6dprUE5VZSUrIaKWG4E3hfjuMG4KguHOfHkY63aTXr//b2yNt5PnBM3i47AP8iJ0LAxflvubzdZ9B5gtIspkbHyZak47kjuRuW41i1zjKGki4O++Ry9sj9HeekqeTzRk29vQpYGViTdJHbPo/bOdeHDXN5PwD+XDPv9Xm5y9aJp2O//op0DG1KOi42zOMPzft19bxdfglc1JX9WO+8Vahjr+f9Noh0c3NrHjeClFSsnPsHk+rU+zupfwslKDXboOM8vwTpBvOHpONnHeAR4JOFc/E+uXsI8MFG9R/4BfDjQv8hLLiJeHt9my2zzrqcmuvBanm7bJ23b7N91cr5r1E9OpB0/lsdWIV0Q1FMUC7L+355UiI2DfhKHncR6Uar45q8TZ11+nbeR0MaHX8Ri5eg3ErO1li44p0NnFCY7j00T1CK048m3SEOqjPtyrmslQrLPbdmmrdjaVBZHwTGNYilNkG5uDBuCOluZo0G874AbFrvgKg90ZAubg8Xxi2Xl/2uXFHmA8sVxp9fW15h3FgWTVD2LvT/D3B6g3n3pX6Ccmahfwfggdy9G3BzzfS/pHChaXXfsuDgWqcwfgrwtUL/+qSkYzDpYC6eCJfLZRVPQjc1qcuHAr+r2d8fKvTfARxW6D+Rxndob2+7bmyXk4H/l7t/WFPPli+uV515J7LwBfrDpOR4icKwi6hppSmMOw04PndvRKq3S+d9Mg8YXZj2K8DUenWa1hKUvQr9vwFOK/QfTG65qTPvyix6nJ8N/B34bqPtQToWXmPhi8Zs0kl6UK5L6xfGddqC0kJMdY+T3H8/8IncfRBwdYNy9wGm1Qz7C7Bv4Riql6BsU+ifDByeu68hJ5W5fwlScrRWYd6PdbKeHft19cKwacDuhfXarjBuRN6ui9SDBtusWYLyx0L/aOC1Qv81wJdz947AfZ2sx2O0lqB8AHiiZt4jgHNy903Aj4BhDbZTsa59gJT0diSm08ktqSycoHS6zJrhS5Dq9KZd3Vd1pj+URc9/jerRDeSEI/d/vGN9STcd8ygkuKTE+sbcfS5wRjGumjh2I52zNmh23C3Op3hWI91B1BpJ2kkdHm+hrNrplwSGSRok6QRJ/5T0MqnSQbojqTdvK9YgNU+24u2yI+IV0vqOBJD0bUn3S3pJ0oukO+5hdUup7+lC2f/KnUNy+c8Xhi0UR1fLJp2chvTQ/GsBH8gvS7+Y13svUmLVSN1922D8SBauL4+z4IBYqF7l7fNcJ8tC0nskXSXp6Vx//otF99Ezhe7X6vS3su063S6SPiDpxvxy2Euku5OOOGrX69U669WZkcCMiHirMOxx0vFZzyRgT0kiXRwnR8S8HM9SLLr9G5XTipa2bYvH+adJd4mnN1nmcxExv9DfUX+Hk+pSsY40PK5ajKmz42wSqZWV/P+8BouqrfPQ2nbv7Bg9pVAPnye1FBfLa+V80ln5vyuUfz/pxm3VFrdZV5e7TOFdmVa3aVesBYysOXa/TzrnQHoE/R7gAUm3S9qxUUERcRuplecjkjYgPeq4ohvLLBpGaoXo7JpVd1+1eP5rtJ9rr+PF7rVI5/FZhfh/SWpJAfgeqc5NU/oE7f41yzwE+F5EPNDJOgHd/JixpC1IFb7eJ0BmkZKADmu2UGTt9G+Qmsj3BMaRsreVSBkjpJXvEDVl1fbXmkF6z6AVb8claQipWfQpSR8mvSi8K6n5eGXSo6aOuJrF0JlZwFBJy9WLo4d1Nc4ZwJ8iYuXC35CI+Gon8zTat/VieIpU+YvTzydd2GaRmhsBkLQsqcm/qHZ9TgMeANaLiBVJJwHR85ptlwtJJ6o1ImIl0kW2I46Fjpe832vXq6h2HZ8C1ih+qo603Z6sO3PEraQWmg+Tjq+Ok/yzpH1Tu/07ynmV1GrVobOktKtaOc5/BfwBuFrS8t1YxhxSXVq9MKyz46qVmDpzPjBO0qakxy2XNZiuts7Dwtu9O8foV2rq4rIR8efCNItzfppBel+uWP4yEfEkXdtm3YnhMmATSRuTWlAu6EYZtWaQ3sUprs8KEbEDQEQ8FBF7kC6+PwYuzfWvUfwdSdQ+wKUR8XpXl1njWdJjr1avWUWLc/5b6HzLwsfKDFILyrBC/CtGxEYAEfF0RHw5IkaSWmF/UfOx+BGket9UlxIUSSvmDPJiUpPZ3+pMNhnYV9LofLI9qoWi9y5Mfwxpx75JepY5j3RHuRwpA2zmGdIzvUbOBI6VtJ6STSQ1uiDsIGkbSUuRXqC8LSJm5Ljmk056gyX9kPQeQzGGUTUXjZZExOOkpsGjJS0laStgp66W06JngNXz+rXiKuA9kvaRtGT+20LShp3M02jf1nMR8E1Ja+eE8L9IL1jNJ70Au5OkrXO8P6L5wbYC6f2dV/IdTWeJ1OJotl1WILWKvZ7fWt+zMO+lwI6FenYMnR+XtfW7467te3m5Y0n15eJOyjiX9MLc/Ii4BSDvk8nA8ZJWkLQW8C3ShRbgbmBbSWtKWonUJN1TWj3ODyI9or0qJ6gty+v3W9JxtVyuD1/sgZgaLW8m6YXX80gvd77WYNKrSXVnT0mDJe1GerRxVR7f7HxW63TgCEkbAUhaSdIuXYm9hfKPz/UDScMljcvjurLNngHeketSS/LF/lJSwj8tIp7oRvy1pgEvSzpM0rK5FWjjfBOOpL0lDc8tlC/med4knfvfYtF9cx7wWVKScm53llmUl3s2cJKkkXnarSQt3cK6Lc75bzJwiKTVJK1MuiHviGkWcB1wYs4JlpC0rqSPAEjaRVJHcvMCKZkrnvO3JD06a6rVC+iVkuaSMqcjSS/y7Vdvwoi4hvSM/QbSy1o3tFD+eaTnk0+TmrO+kYefS2rufJL0ws6tLZR1FjA6Nz1dVmf8SaSNfx1p551Fajqu50JSgvU86YWjvfLwa0nPQ/+R43udhZvAfp3/PyfpzhZirrUXsBXpQD+O9Emced0op5kbSG/KPy3p2WYTR8Rc4D+A3UkZ8NOku4rODpZG+7aes/P0N5HeHH+d9K4CEXFv7r6YlN3PJb1f0Nl2+Q4pGZhLugO/pJNpu62F7fI14Jh8DP2QVP865r2X9KmKC0nr9QLpkyiNLFS/I+LfwGeAT5Hutn4BfLFJ8+l5pBeXa5vIDyYlO4+QWkcvJO0TIuJ60va7h/SuzlX0nJaO80gPsCeQjrXLJS3TxeUcRLqzf5q07hfRuP5059xTaxLp5eiGjyIi4jlSa8C3Scf794AdI6LjeDwF+IKkFyT9tNkCI+J3pLp3cW7W/zupbvSUU0itgdfl+nwr6Z0K6MI2y/XzIuCRXJdHtrj8ptu0K3LiuhOwGemc8yzpJrYjcdoeuFfSK6R13z0iXs+PmI8H/i/H/8Fc3kzSy+AB3NzNZdb6DumDHbeTrkU/prVr9+Kc/35FukbeQ3qR/mrSTXlHovFF0iPh+0jnrEtJLSMAWwC35W12BXBIRDxaKHsq6UXfpjo+NVIaSVNJrTFnNpu2L0maSHqp6QcViOUS0gt4rbRGVUZv7tvcwvIiqfny0SaTW0FufZgNbB4RD5UdT1kk/Rh4V0SM76XytyW1QI2qeUfIuknSmqTHFu+KiJfLjqceSWcDT1Xh2tFTJH2K9GGL2seRvcq/xVNB+fHAurnpbHvSc93LSg6rdJJ2ys3zy5M+Zvw3FryIZ637KnD7QEtOJG2QH+kqP2o7APhdLy1rSdLLgGc6OekZ+ZH5t0ifeqtqcjIK+BwV/CLTrsiPnnbIjx1XIz1J6JVjpTMD9ZsEq+5dpOfl7yA19381uvmVzG1mHKlpV6T3dHaPspsA+xlJj5G2387lRlKKFUiPFUaSWpBOJH3vS4/K7x5NB/5Kg0fh1jX5puQZ0iOk7UsOpy5JxwLfBP67DVp1RXrP7xLSJ+5+T3o83bdB+PxuZmZmVeNHPGZmZlY5fsTTh4YNGxajRo0qOwwzM+umO+6449mIGF52HAOBE5Q+NGrUKKZPn152GGZm1k2SWvl2dOsBfsRjZmZmleMExczMzCrHCYqZmZlVjhMUMzMzqxwnKGZmZlY5TlDMzMyscpygmJmZWeU4QTEzM7PK8Re1ZfknsncEZkfExnnY/wI7Af8G/gnsFxEv5nFHkH4N9U3gGxFxbRlxm5n1SxeqvGXv6d+g6w/cgrLARBb9lczrgY0jYhPgH8ARAJJGA7sDG+V5fiFpUN+FamZm1t6coGQRcRPwfM2w6yJifu69FVg9d48DLo6IeflntR8GtuyzYM3MzNqcE5TW7Q9ck7tXA2YUxs3MwxYhaYKk6ZKmz5kzp5dDNDMzaw9OUFog6UhgPnBBx6A6k9V9qBkRZ0TEmIgYM3y4fwDTzMysFX5JtglJ40kvz24XER1JyExgjcJkqwNP9XVsZmZm7cotKJ2QtD1wGPCZiPhXYdQVwO6Slpa0NrAeMK2MGM3MzNqRW1AySRcBY4FhkmYCR5E+tbM0cL0kgFsj4sCIuFfSZOA+0qOfr0fEm+VEbmZm1n6coGQRsUedwWd1Mv3xwPG9F5GZmdnA5Uc8ZmZmVjlOUMzMzKxynKCYmZlZ5ThBMTMzs8pxgmJmZmaV4wTFzMzMKscJipmZmVWOExQzMzOrHCcoZmZmVjlOUMzMzKxynKCYmZlZ5ThBMTMzs8pxgmJmZmaV4wTFzMzMKscJipmZmVWOExQzMzOrHCcoZmZmVjlOUMzMzKxynKCYmZlZ5ThBMTMzs8pxgmJmZmaV4wTFzMzMKscJipmZmVWOE5RM0tmSZkv6e2HYUEnXS3oo/1+lMO4ISQ9LelDSJ8uJ2szMrD05QVlgIrB9zbDDgSkRsR4wJfcjaTSwO7BRnucXkgb1XahmZmbtzQlKFhE3Ac/XDB4HTMrdk4CdC8Mvjoh5EfEo8DCwZV/EaWZmNhA4QencqhExCyD/f2cevhowozDdzDzMzMzMeoATlO5RnWFRd0JpgqTpkqbPmTOnl8MyMzNrD05QOveMpBEA+f/sPHwmsEZhutWBp+oVEBFnRMSYiBgzfPjwXg3WzMysXThB6dwVwPjcPR64vDB8d0lLS1obWA+YVkJ8ZmZmbWlw2QFUhaSLgLHAMEkzgaOAE4DJkg4AngB2AYiIeyVNBu4D5gNfj4g3SwnczMysDTlBySJijwajtmsw/fHA8b0XkZmZ2cDlRzxmZmZWOU5QzMzMrHKcoJiZmVnlOEExMzOzynGCYmZmZpXjBMXMzMwqxwmKmZmZVY4TFDMzM6scJyhmZmZWOU5QzMzMrHKcoJiZmVnlOEExMzOzynGCYmZmZpXjBMXMzMwqxwmKmZmZVY4TFDMzM6scJyhmZmZWOU5QzMzMrHKcoJiZmVnlOEExMzOzynGCYmZmZpXjBMXMzMwqxwmKmZmZVY4TFDMzM6scJygtkPRNSfdK+rukiyQtI2mopOslPZT/r1J2nGZmZu3CCUoTklYDvgGMiYiNgUHA7sDhwJSIWA+YkvvNzMysBzhBac1gYFlJg4HlgKeAccCkPH4SsHM5oZmZmbUfJyhNRMSTwE+AJ4BZwEsRcR2wakTMytPMAt5Zb35JEyRNlzR9zpw5fRW2mZlZv+YEpYn8bsk4YG1gJLC8pL1bnT8izoiIMRExZvjw4b0VppmZWVtxgtLcx4FHI2JORLwB/BbYGnhG0giA/H92iTGamZm1FScozT0BfFDScpIEbAfcD1wBjM/TjAcuLyk+MzOztjO47ACqLiJuk3QpcCcwH7gLOAMYAkyWdAApidmlvCjNzMzaixOUFkTEUcBRNYPnkVpTzMzMrIf5EY+ZmZlVjhMUMzMzqxwnKGZmZlY5TlDMzMyscpygmJmZWeW0fYIiaRVJm5Qdh5mZmbWuLRMUSVMlrShpKPBX4BxJJ5Udl5mZmbWmLRMUYKWIeBn4HHBORLyf9JX1ZmZm1g+0a4IyOP8+zq7AVWUHY2ZmZl3TrgnKj4BrgYcj4nZJ6wAPlRyTmZmZtahdv+p+VkS8/WJsRDzid1DMzMz6j3ZtQflZi8PMzMysgtqqBUXSVsDWwHBJ3yqMWhEYVE5UZmZm1lVtlaAASwFDSOu1QmH4y8AXSonIzMzMuqytEpSI+BPwJ0kTI+LxsuMxMzOz7mmrBKVgaUlnAKMorGNEfKy0iMzMzKxl7Zqg/Bo4HTgTeLPkWMzMzKyL2jVBmR8Rp5UdhJmZmXVPu37M+EpJX5M0QtLQjr+ygzIzM7PWtGsLyvj8/7uFYQGsU0IsZmZm1kVtmaBExNplx2BmZmbd15YJiqQv1hseEef2dSw96kKVs9w9o5zlmpnZgNWWCQqwRaF7GWA74E6gfycoZmZmA0RbJigRcXCxX9JKwHndLU/SyqSPLG9Mepdlf+BB4BLSd608BuwaES90dxlmZma2QLt+iqfWv4D1FmP+U4A/RMQGwKbA/cDhwJSIWA+YkvvNzMysB7RlC4qkK0ktHZB+JHBDYHI3y1oR2BbYFyAi/g38W9I4YGyebBIwFTisuzGbmZnZAm2ZoAA/KXTPBx6PiJndLGsdYA5wjqRNgTuAQ4BVI2IWQETMkvTOejNLmgBMAFhzzTW7GYKZmdnA0paPePKPBj5A+kXjVYB/L0Zxg4HNgdMi4n3Aq3ThcU5EnBERYyJizPDhwxcjDDMzs4GjLRMUSbsC04BdgF2B2yR9oZvFzQRmRsRtuf9SUsLyjKQReXkjgNmLF7WZmZl1aNdHPEcCW0TEbABJw4E/kpKLLomIpyXNkLR+RDxI+sjyfflvPHBC/n95TwVvZmY20LVrgrJER3KSPcfitRYdDFwgaSngEWC/XN5kSQcAT5Baa8zMzKwHtGuC8gdJ1wIX5f7dgKu7W1hE3A2MqTNqu+6WaWZmZo21VYIi6d2kT9d8V9LngG0AAX8BLig1ODMzM2tZu70kezIwFyAifhsR34qIb5JaT04uMS4zMzPrgnZLUEZFxD21AyNiOukr6c3MzKwfaLcEZZlOxi3bZ1GYmZnZYmm3BOV2SV+uHZg/aXNHCfGYmZlZN7TVS7LAocDvJO3FgoRkDLAU8NmygjIzM7OuaasEJSKeAbaW9FFg4zz49xFxQ4lhmZmZWRe1VYLSISJuBG4sOw4zMzPrnnZ7B8XMzMzagBMUMzMzqxwnKGZmZlY5TlDMzMyscpygmJmZWeU4QTEzM7PKcYJiZmZmleMExczMzCrHCYqZmZlVjhMUMzMzqxwnKGZmZlY5TlDMzMyscpygmJmZWeU4QTEzM7PKcYJiZmZmleMEpUWSBkm6S9JVuX+opOslPZT/r1J2jGZmZu3CCUrrDgHuL/QfDkyJiPWAKbnfzMzMeoATlBZIWh34NHBmYfA4YFLungTs3MdhmZmZtS0nKK05Gfge8FZh2KoRMQsg/39nvRklTZA0XdL0OXPm9HqgZmZm7cAJShOSdgRmR8Qd3Zk/Is6IiDERMWb48OE9HJ2ZmVl7Glx2AP3Ah4DPSNoBWAZYUdL5wDOSRkTELEkjgNmlRmlmZtZG3ILSREQcERGrR8QoYHfghojYG7gCGJ8nGw9cXlKIZmZmbccJSvedAHxC0kPAJ3K/mZmZ9QA/4umCiJgKTM3dzwHblRmPmZlZu3ILipmZmVWOExQzMzOrHCcoZmZmVjlOUMzMzKxynKCYmZlZ5ThBMTMzs8pxgmJmZmaV4wTFzMzMKscJipmZmVWOExQzMzOrHCcoZmZmVjlOUMzMzKxynKCYmZlZ5ThBMTMzs8pxgmJmZmaV4wTFzMzMKscJipmZmVXO4LIDMOvUhSpv2XtGecs2Mxvg3IJiZmZmleMExczMzCrHCYqZmZlVjhMUMzMzqxwnKGZmZlY5TlCakLSGpBsl3S/pXkmH5OFDJV0v6aH8f5WyYzUzM2sXTlCamw98OyI2BD4IfF3SaOBwYEpErAdMyf1mZmbWA/w9KE1ExCxgVu6eK+l+YDVgHDA2TzYJmAocVkKI1o78/S9mNsC5BaULJI0C3gfcBqyak5eOJOadDeaZIGm6pOlz5szps1jNzMz6MycoLZI0BPgNcGhEvNzqfBFxRkSMiYgxw4cP770AzczM2ogTlBZIWpKUnFwQEb/Ng5+RNCKPHwHMLis+MzOzduMEpQlJAs4C7o+IkwqjrgDG5+7xwOV9HZuZmVm78kuyzX0I2Af4m6S787DvAycAkyUdADwB7FJOeGZmZu3HCUoTEXEL0OgjFdv1ZSxmZmYDhR/xmJmZWeU4QTEzM7PKcYJiZmZmleMExczMzCrHCYqZmZlVjhMUMzMzqxwnKGZmZlY5TlDMzMyscpygmJmZWeX4m2TNrDoubPSlzX1gzyhv2Wa2CLegmJmZWeU4QTEzM7PKcYJiZmZmleMExczMzCrHCYqZmZlVjhMUMzMzqxwnKGZmZlY5TlDMzMyscpygmJmZWeU4QTEzM7PKcYJiZmZmleMExczMzCrHCYqZmZlVjhOUxSBpe0kPSnpY0uFlx2NmZtYunKB0k6RBwKnAp4DRwB6SRpcblZmZWXsYXHYA/diWwMMR8QiApIuBccB9pUZlZv3LhSpv2XtGecs2a8ItKN23GjCj0D8zDzMzM7PF5BaU7qt327PI7YikCcCE3PuKpAd7NarGhgHPdmvOvUq8w1t8A3G9u7/O4PXufwZiHYfy1nutxZnZWucEpftmAmsU+lcHnqqdKCLOAM7oq6AakTQ9IsaUHUdfG4jrPRDXGbzeZcfR1wbqeg8kfsTTfbcD60laW9JSwO7AFSXHZGZm1hbcgtJNETFf0kHAtcAg4OyIuLfksMzMzNqCE5TFEBFXA1eXHUeLSn/MVJKBuN4DcZ3B6z3QDNT1HjAU4Y+ZmZmZWbX4HRQzMzOrHCcoZmZmVjl+B6VNSVoXmBkR8ySNBTYBzo2IF8uMy3qHpB82mWR2RJzeJ8FYr/K+toHC76C0KUl3A2OAUaRPGl0BrB8RO5QYlvUSSVeTPure6BuoJkXEzn0XUe+R9K6IeLrsOMoykPY1gKTNOxsfEXf2VSzWt9yC0r7eyh+F/ixwckT8TNJdZQfVFyStDvwM2AZ4C7gFOCQiZpYaWO96MyJebjRSUjvdiXxS0hbAIcCm9SZo84vWQNrXACd2Mi6Aj/VVINa3nKC0rzck7QGMB3bKw5YsMZ6+dA5wIbBL7t87D/tEaRH1vmYXpba5aEXEJEnPkPbrvh2DayZr54vWgNnXABHx0bJjsHI4QWlf+wEHAsdHxKOS1gbOLzmmvjI8Is4p9E+UdGhZwfSRJSWt2GCcSF8m2E6eA/4aEZMAJI0HPg88BhxdXlh9YqDt67dJ2hgYDSzTMSwizi0vIutNfgeljUlaFlgzIsr6gcJSSPojMBG4KA/aA9gvIrYrLaheJuko0p1zo/cSZkfEaX0YUq+SdCfw8Yh4XtK2wMXAwcBmwIYR8YUy4+tNA21fd8jrPZaUoFwNfAq4pZ339UDnBKVNSdoJ+AmwVESsLWkz4JiI+Ey5kfU+SWsCPwe2Ip3I/0x6B+XxUgOzHiPprxGxae4+FZgTEUfn/rsjYrMSw7NeIOlvpHeO7oqITSWtCpwZETs1mdX6KT/iaV9HA1sCUwEi4u78mKftRcQTQNsnYgPcIEmDI2I+sB0woTDO57X29FpEvCVpfn7ENRtYp+ygrPf4QG5f8yPiJWmhVuC2bi5r8v0QERHH9lkw1tsuAv4k6VngNeBmAEnvBl4qMzDrNdMlrQz8CrgDeAWYVmpE1qv8iKfN5O9I+DrwA2AKcDjp5cFvAEtGxIElhterJH27zuDlgQOAd0TEkD4OyXqRpA8CI4DrIuLVPOw9wJA2/5jxgCdpFLBiRNxTdizWe5ygtBlJuwLHAecBy7Lgo7XXAsdGxLyyYutLklYgfU/GAcBk4MSImF1uVGbWXZKm1L7oXm+YtQ//Fk+biYjJwPuAIcCngUtIn3B4gdSy0tYkDZV0HHAP6RHm5hFxmJMTs/5J0jKShgLDJK2Sj/GhuRVlZMnhWS/yOyjt6Q3gVWBpUqIyIJrJJP0v8DngDOC9EfFKySGZ2eL7CnAoKRkpPrp7GTi1jICsb/gRT5uRtD1wEum3d46JiH+VHFKfkfQWMA+Yz8JJmUgvyTb6ciszqzhJB0fEz8qOw/qOE5Q2I+lm4MCIuLfsWMzMeoqkpUjfjr1tHjQV+GVEvFFaUNarnKCYmVnlSTqT9Htik/KgfUg/nPil8qKy3uQExczMKqvjC/mK3x5cGLfIMGsf/hSPmZlVWceXsb0pad2OgZLWAd4sJyTrC/4Uj5mZVVnH12F/B7hR0iO5fxTpV9utTfkRj5mZVZakmaRPJkL68slBpK9RWIb0+zwnNZrX+je3oJiZWZUNIn2fU/GHxTp+tmKFvg/H+opbUMzMrLIk3RkRm5cdh/U9vyRrZmZVpuaTWDtyC4qZmVWWpKER8XzZcVjfc4JiZmZmleNHPGZmZlY5TlDMzMyscpygmPVTko6UdK+keyTdLekDZccEIGkbSdMkPZD/JrQwz2aSdij0f0bS4b0bqZlVmb8HxawfkrQVsCOweUTMkzQMWKoL8w+OiPm9ENe7gAuBnSPizhzXtZKejIjfdzLrZsAY4GqAiLgCuKKn4zOz/sMtKGb90wjg2YiYBxARz0bEUwCSHsuJAZLGSJqau4+WdIak64BzJd0maaOOAiVNlfR+SctLOlvS7ZLukjQuj79Z0maF6f9P0iY1cX0dmBgRd3bEBXwPODzPM1HS6bmsf0jaUdJSwDHAbrklaDdJ+0r6eZ5nLUlTckvRFElrFsr6qaQ/S3pE0hfy8BGSbspl/V3Sh3tyw5tZ33CCYtY/XQeskS/yv5D0kRbnez8wLiL2BC4GdoV0UQdGRsQdwJHADRGxBfBR4H8lLQ+cCeybp38PsHRE3FNT/kbAHTXDpufhHUYBHwE+DZxOOg/9ELgkIjaLiEtq5v85cG5EbAJcAPy0MG4EsA2pNemEPGxP4NqI2AzYFLi72UYxs+pxgmLWD0XEK6RkYwIwB7hE0r4tzHpFRLyWuycDu+TuXYFf5+7/AA6XdDcwlfSbJ2vm8TtKWhLYH5hYp3wB9b67oDhsckS8FREPAY8AGzSJeSvSYyOA80gJSYfLcln3AavmYbcD+0k6GnhvRMxtUr6ZVZATFLN+KiLejIipEXEUcBDw+TxqPguO7WVqZnu1MP+TwHP5Mc1upBYVSEnG53NrxmYRsWZE3B8R/wKuB8aREpoLWdS9pHdJit4P3FcMvXZVmqxqreL08wrdAoiIm4BtgSeB8yR9sYvlm1kFOEEx64ckrS9pvcKgzYDHc/djpKQAFiQtjVxMekdkpYj4Wx52LXCwJOVlva8w/ZmkRyy3N/h2z1OBfTveVZH0DuDHwP8UptlF0hKS1gXWAR4E5tL4h9/+DOyeu/cCbulshSStBcyOiF8BZwH+HRezfsgJiln/NASYJOk+SfcAo4Gj87gfAadIuhl4s0k5l5Iu/pMLw44FlgTukfT33A9AfkflZeCceoVFxCxgb+BXkh4gJRdnR8SVhckeBP4EXAMcGBGvAzcCoztekq0p9hukRzb3APsAhzRZp7HA3ZLuIiVopzSZ3swqyF91b2YtkzSS9F7KBhHxVjfmnwhcFRGX9nBoZtZm3IJiZi3J73LcBhzZneTEzKwr3IJiZmZmleMWFDMzM6scJyhmZmZWOU5QzMzMrHKcoJiZmVnlOEExMzOzyvn/he5WvJhZPasAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "summary_df21.plot(kind = 'bar', x = 'Survey Options', y ='Counts', legend = False, color = 'orange', xlabel = None)\n",
    "plt.ylabel('Counts')\n",
    "plt.title('Did participating in the program lead to you making any other healthy lifestyle changes?')\n",
    "plt.tight_layout()\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.20"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}