{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "![Callysto.ca Banner](https://github.com/callysto/curriculum-notebooks/blob/master/callysto-notebook-banner-top.jpg?raw=true)\n",
    "\n",
    "<a href=\"https://hub.callysto.ca/jupyter/hub/user-redirect/git-pull?repo=https%3A%2F%2Fgithub.com%2Fcallysto%2Fcurriculum-notebooks&branch=master&subPath=Mathematics/StatisticsProject/AccessingData/pet-popularity.ipynb&depth=1\" target=\"_parent\"><img src=\"https://raw.githubusercontent.com/callysto/curriculum-notebooks/master/open-in-callysto-button.svg?sanitize=true\" width=\"123\" height=\"24\" alt=\"Open in Callysto\"/></a>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Pet Popularity\n",
    "\n",
    "Using [Pet Licenses data from the City of Edmonton Open Data Portal](https://data.edmonton.ca/Community-Services/Pet-Licenses-by-Neighbourhood/5squ-mg4w) we can see which (licensed) pets are the most popular."
   ]
  },
  {
   "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>year</th>\n",
       "      <th>month</th>\n",
       "      <th>month_number</th>\n",
       "      <th>license_date</th>\n",
       "      <th>neighbourhood</th>\n",
       "      <th>neighbourhood_id</th>\n",
       "      <th>pet_type</th>\n",
       "      <th>breed</th>\n",
       "      <th>gender</th>\n",
       "      <th>spayed_or_neutered</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>location</th>\n",
       "      <th>count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>2020</td>\n",
       "      <td>September</td>\n",
       "      <td>9</td>\n",
       "      <td>2020-09-03T00:00:00.000</td>\n",
       "      <td>Killarney</td>\n",
       "      <td>2420</td>\n",
       "      <td>Cat</td>\n",
       "      <td>RUSSIAN BLUE</td>\n",
       "      <td>Female</td>\n",
       "      <td>Yes</td>\n",
       "      <td>53.588489</td>\n",
       "      <td>-113.479568</td>\n",
       "      <td>\\n,  \\n(53.58848869298595, -113.47956836782039)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>2020</td>\n",
       "      <td>August</td>\n",
       "      <td>8</td>\n",
       "      <td>2020-08-19T00:00:00.000</td>\n",
       "      <td>Satoo</td>\n",
       "      <td>6680</td>\n",
       "      <td>Dog</td>\n",
       "      <td>CHIHUAHUA (LONG HAIR)</td>\n",
       "      <td>Male</td>\n",
       "      <td>Yes</td>\n",
       "      <td>53.446373</td>\n",
       "      <td>-113.458892</td>\n",
       "      <td>\\n,  \\n(53.44637282810994, -113.45889160765203)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>2020</td>\n",
       "      <td>August</td>\n",
       "      <td>8</td>\n",
       "      <td>2020-08-03T00:00:00.000</td>\n",
       "      <td>Allendale</td>\n",
       "      <td>5010</td>\n",
       "      <td>Cat</td>\n",
       "      <td>DOMESTIC (SHORT HAIR)</td>\n",
       "      <td>Female</td>\n",
       "      <td>Yes</td>\n",
       "      <td>53.502277</td>\n",
       "      <td>-113.504821</td>\n",
       "      <td>\\n,  \\n(53.50227700015803, -113.50482111013511)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>2020</td>\n",
       "      <td>September</td>\n",
       "      <td>9</td>\n",
       "      <td>2020-09-03T00:00:00.000</td>\n",
       "      <td>Secord</td>\n",
       "      <td>4487</td>\n",
       "      <td>Cat</td>\n",
       "      <td>DOMESTIC (SHORT HAIR)</td>\n",
       "      <td>Female</td>\n",
       "      <td>Yes</td>\n",
       "      <td>53.533937</td>\n",
       "      <td>-113.701353</td>\n",
       "      <td>\\n,  \\n(53.53393710914364, -113.70135276511442)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>2020</td>\n",
       "      <td>July</td>\n",
       "      <td>7</td>\n",
       "      <td>2020-07-01T00:00:00.000</td>\n",
       "      <td>Secord</td>\n",
       "      <td>4487</td>\n",
       "      <td>Cat</td>\n",
       "      <td>DOMESTIC (SHORT HAIR)</td>\n",
       "      <td>Male</td>\n",
       "      <td>Yes</td>\n",
       "      <td>53.533937</td>\n",
       "      <td>-113.701353</td>\n",
       "      <td>\\n,  \\n(53.53393710914364, -113.70135276511442)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>995</td>\n",
       "      <td>2020</td>\n",
       "      <td>July</td>\n",
       "      <td>7</td>\n",
       "      <td>2020-07-16T00:00:00.000</td>\n",
       "      <td>Weinlos</td>\n",
       "      <td>6770</td>\n",
       "      <td>Dog</td>\n",
       "      <td>AUSTRALIAN CATTLE DOG</td>\n",
       "      <td>Female</td>\n",
       "      <td>Yes</td>\n",
       "      <td>53.459907</td>\n",
       "      <td>-113.413836</td>\n",
       "      <td>\\n,  \\n(53.459906787332415, -113.41383602707519)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>996</td>\n",
       "      <td>2020</td>\n",
       "      <td>September</td>\n",
       "      <td>9</td>\n",
       "      <td>2020-09-03T00:00:00.000</td>\n",
       "      <td>Twin Brooks</td>\n",
       "      <td>5511</td>\n",
       "      <td>Dog</td>\n",
       "      <td>SIBERIAN HUSKY</td>\n",
       "      <td>Female</td>\n",
       "      <td>Yes</td>\n",
       "      <td>53.444689</td>\n",
       "      <td>-113.531497</td>\n",
       "      <td>\\n,  \\n(53.444688598308645, -113.53149747692723)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>997</td>\n",
       "      <td>2020</td>\n",
       "      <td>September</td>\n",
       "      <td>9</td>\n",
       "      <td>2020-09-03T00:00:00.000</td>\n",
       "      <td>Graydon Hill</td>\n",
       "      <td>5468</td>\n",
       "      <td>Dog</td>\n",
       "      <td>GOLDEN RETRIEVER</td>\n",
       "      <td>Male</td>\n",
       "      <td>Yes</td>\n",
       "      <td>53.421257</td>\n",
       "      <td>-113.559297</td>\n",
       "      <td>\\n,  \\n(53.42125726511837, -113.5592969195822)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>998</td>\n",
       "      <td>2020</td>\n",
       "      <td>September</td>\n",
       "      <td>9</td>\n",
       "      <td>2020-09-03T00:00:00.000</td>\n",
       "      <td>Brander Gardens</td>\n",
       "      <td>5080</td>\n",
       "      <td>Dog</td>\n",
       "      <td>LABRADOR RETRIEVER</td>\n",
       "      <td>Female</td>\n",
       "      <td>No</td>\n",
       "      <td>53.495209</td>\n",
       "      <td>-113.579425</td>\n",
       "      <td>\\n,  \\n(53.4952094952786, -113.57942476380458)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>999</td>\n",
       "      <td>2020</td>\n",
       "      <td>August</td>\n",
       "      <td>8</td>\n",
       "      <td>2020-08-19T00:00:00.000</td>\n",
       "      <td>Elmwood</td>\n",
       "      <td>4140</td>\n",
       "      <td>Cat</td>\n",
       "      <td>DOMESTIC (SHORT HAIR)</td>\n",
       "      <td>Female</td>\n",
       "      <td>Yes</td>\n",
       "      <td>53.515738</td>\n",
       "      <td>-113.605993</td>\n",
       "      <td>\\n,  \\n(53.515738255461834, -113.60599332906781)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     year      month  month_number             license_date    neighbourhood  \\\n",
       "0    2020  September             9  2020-09-03T00:00:00.000        Killarney   \n",
       "1    2020     August             8  2020-08-19T00:00:00.000            Satoo   \n",
       "2    2020     August             8  2020-08-03T00:00:00.000        Allendale   \n",
       "3    2020  September             9  2020-09-03T00:00:00.000           Secord   \n",
       "4    2020       July             7  2020-07-01T00:00:00.000           Secord   \n",
       "..    ...        ...           ...                      ...              ...   \n",
       "995  2020       July             7  2020-07-16T00:00:00.000          Weinlos   \n",
       "996  2020  September             9  2020-09-03T00:00:00.000      Twin Brooks   \n",
       "997  2020  September             9  2020-09-03T00:00:00.000     Graydon Hill   \n",
       "998  2020  September             9  2020-09-03T00:00:00.000  Brander Gardens   \n",
       "999  2020     August             8  2020-08-19T00:00:00.000          Elmwood   \n",
       "\n",
       "     neighbourhood_id pet_type                  breed  gender  \\\n",
       "0                2420      Cat           RUSSIAN BLUE  Female   \n",
       "1                6680      Dog  CHIHUAHUA (LONG HAIR)    Male   \n",
       "2                5010      Cat  DOMESTIC (SHORT HAIR)  Female   \n",
       "3                4487      Cat  DOMESTIC (SHORT HAIR)  Female   \n",
       "4                4487      Cat  DOMESTIC (SHORT HAIR)    Male   \n",
       "..                ...      ...                    ...     ...   \n",
       "995              6770      Dog  AUSTRALIAN CATTLE DOG  Female   \n",
       "996              5511      Dog         SIBERIAN HUSKY  Female   \n",
       "997              5468      Dog       GOLDEN RETRIEVER    Male   \n",
       "998              5080      Dog     LABRADOR RETRIEVER  Female   \n",
       "999              4140      Cat  DOMESTIC (SHORT HAIR)  Female   \n",
       "\n",
       "    spayed_or_neutered   latitude   longitude  \\\n",
       "0                  Yes  53.588489 -113.479568   \n",
       "1                  Yes  53.446373 -113.458892   \n",
       "2                  Yes  53.502277 -113.504821   \n",
       "3                  Yes  53.533937 -113.701353   \n",
       "4                  Yes  53.533937 -113.701353   \n",
       "..                 ...        ...         ...   \n",
       "995                Yes  53.459907 -113.413836   \n",
       "996                Yes  53.444689 -113.531497   \n",
       "997                Yes  53.421257 -113.559297   \n",
       "998                 No  53.495209 -113.579425   \n",
       "999                Yes  53.515738 -113.605993   \n",
       "\n",
       "                                             location  count  \n",
       "0     \\n,  \\n(53.58848869298595, -113.47956836782039)      1  \n",
       "1     \\n,  \\n(53.44637282810994, -113.45889160765203)      1  \n",
       "2     \\n,  \\n(53.50227700015803, -113.50482111013511)      1  \n",
       "3     \\n,  \\n(53.53393710914364, -113.70135276511442)      1  \n",
       "4     \\n,  \\n(53.53393710914364, -113.70135276511442)      1  \n",
       "..                                                ...    ...  \n",
       "995  \\n,  \\n(53.459906787332415, -113.41383602707519)      1  \n",
       "996  \\n,  \\n(53.444688598308645, -113.53149747692723)      1  \n",
       "997    \\n,  \\n(53.42125726511837, -113.5592969195822)      1  \n",
       "998    \\n,  \\n(53.4952094952786, -113.57942476380458)      1  \n",
       "999  \\n,  \\n(53.515738255461834, -113.60599332906781)      1  \n",
       "\n",
       "[1000 rows x 14 columns]"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "domain = 'https://data.edmonton.ca/resource/'\n",
    "uuid = '5squ-mg4w'\n",
    "query = 'SELECT *'\n",
    "\n",
    "import requests\n",
    "import io\n",
    "import pandas as pd\n",
    "\n",
    "session = requests.Session()\n",
    "results = session.get(domain + uuid +'.csv?$query=' + query)\n",
    "df =  pd.read_csv(io.StringIO(results.content.decode('utf-8')))\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "[![Callysto.ca License](https://github.com/callysto/curriculum-notebooks/blob/master/callysto-notebook-banner-bottom.jpg?raw=true)](https://github.com/callysto/curriculum-notebooks/blob/master/LICENSE.md)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}