{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>Unnamed: 0</th>\n",
       "      <th>Patron Type Code</th>\n",
       "      <th>Patron Type Definition</th>\n",
       "      <th>Total Checkouts</th>\n",
       "      <th>Total Renewals</th>\n",
       "      <th>Age Range</th>\n",
       "      <th>Home Library Code</th>\n",
       "      <th>Home Library Definition</th>\n",
       "      <th>Circulation Active Month</th>\n",
       "      <th>Circulation Active Year</th>\n",
       "      <th>Notice Preference Code</th>\n",
       "      <th>Notice Preference Definition</th>\n",
       "      <th>Provided Email Address</th>\n",
       "      <th>Year Patron Registered</th>\n",
       "      <th>Within San Francisco County</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>123022</td>\n",
       "      <td>2</td>\n",
       "      <td>Teen</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10 to 19 years</td>\n",
       "      <td>x</td>\n",
       "      <td>Main</td>\n",
       "      <td>Oct</td>\n",
       "      <td>2022.0</td>\n",
       "      <td>z</td>\n",
       "      <td>Email</td>\n",
       "      <td>True</td>\n",
       "      <td>2022</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>125054</td>\n",
       "      <td>0</td>\n",
       "      <td>Adult</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>25 to 34 years</td>\n",
       "      <td>x</td>\n",
       "      <td>Main</td>\n",
       "      <td>Jul</td>\n",
       "      <td>2023.0</td>\n",
       "      <td>z</td>\n",
       "      <td>Email</td>\n",
       "      <td>True</td>\n",
       "      <td>2021</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>87884</td>\n",
       "      <td>0</td>\n",
       "      <td>Adult</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>25 to 34 years</td>\n",
       "      <td>x</td>\n",
       "      <td>Main</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>z</td>\n",
       "      <td>Email</td>\n",
       "      <td>True</td>\n",
       "      <td>2023</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>409236</td>\n",
       "      <td>0</td>\n",
       "      <td>Adult</td>\n",
       "      <td>19</td>\n",
       "      <td>40</td>\n",
       "      <td>20 to 24 years</td>\n",
       "      <td>p9</td>\n",
       "      <td>Presidio</td>\n",
       "      <td>Jul</td>\n",
       "      <td>2023.0</td>\n",
       "      <td>z</td>\n",
       "      <td>Email</td>\n",
       "      <td>True</td>\n",
       "      <td>2021</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>47911</td>\n",
       "      <td>3</td>\n",
       "      <td>Senior</td>\n",
       "      <td>1079</td>\n",
       "      <td>197</td>\n",
       "      <td>75 years and over</td>\n",
       "      <td>x</td>\n",
       "      <td>Main</td>\n",
       "      <td>Jul</td>\n",
       "      <td>2023.0</td>\n",
       "      <td>z</td>\n",
       "      <td>Email</td>\n",
       "      <td>True</td>\n",
       "      <td>2003</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>393489</td>\n",
       "      <td>0</td>\n",
       "      <td>Adult</td>\n",
       "      <td>10</td>\n",
       "      <td>5</td>\n",
       "      <td>45 to 54 years</td>\n",
       "      <td>x</td>\n",
       "      <td>Main</td>\n",
       "      <td>Jul</td>\n",
       "      <td>2023.0</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>False</td>\n",
       "      <td>2003</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>5884</td>\n",
       "      <td>0</td>\n",
       "      <td>Adult</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>25 to 34 years</td>\n",
       "      <td>x</td>\n",
       "      <td>Main</td>\n",
       "      <td>Mar</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>z</td>\n",
       "      <td>Email</td>\n",
       "      <td>True</td>\n",
       "      <td>2020</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>329892</td>\n",
       "      <td>2</td>\n",
       "      <td>Teen</td>\n",
       "      <td>137</td>\n",
       "      <td>0</td>\n",
       "      <td>10 to 19 years</td>\n",
       "      <td>yb</td>\n",
       "      <td>Bookmobile</td>\n",
       "      <td>Feb</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>z</td>\n",
       "      <td>Email</td>\n",
       "      <td>True</td>\n",
       "      <td>2009</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>49195</td>\n",
       "      <td>1</td>\n",
       "      <td>Juvenile</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10 to 19 years</td>\n",
       "      <td>x</td>\n",
       "      <td>Main</td>\n",
       "      <td>Apr</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>z</td>\n",
       "      <td>Email</td>\n",
       "      <td>True</td>\n",
       "      <td>2017</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>298115</td>\n",
       "      <td>1</td>\n",
       "      <td>Juvenile</td>\n",
       "      <td>6</td>\n",
       "      <td>23</td>\n",
       "      <td>0 to 9 years</td>\n",
       "      <td>m2</td>\n",
       "      <td>Marina</td>\n",
       "      <td>May</td>\n",
       "      <td>2023.0</td>\n",
       "      <td>z</td>\n",
       "      <td>Email</td>\n",
       "      <td>True</td>\n",
       "      <td>2021</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0  Patron Type Code Patron Type Definition  Total Checkouts  \\\n",
       "0      123022                 2                   Teen                0   \n",
       "1      125054                 0                  Adult                0   \n",
       "2       87884                 0                  Adult                0   \n",
       "3      409236                 0                  Adult               19   \n",
       "4       47911                 3                 Senior             1079   \n",
       "5      393489                 0                  Adult               10   \n",
       "6        5884                 0                  Adult                0   \n",
       "7      329892                 2                   Teen              137   \n",
       "8       49195                 1               Juvenile                0   \n",
       "9      298115                 1               Juvenile                6   \n",
       "\n",
       "   Total Renewals          Age Range Home Library Code  \\\n",
       "0               0     10 to 19 years                 x   \n",
       "1               0     25 to 34 years                 x   \n",
       "2               0     25 to 34 years                 x   \n",
       "3              40     20 to 24 years                p9   \n",
       "4             197  75 years and over                 x   \n",
       "5               5     45 to 54 years                 x   \n",
       "6               0     25 to 34 years                 x   \n",
       "7               0     10 to 19 years                yb   \n",
       "8               0     10 to 19 years                 x   \n",
       "9              23       0 to 9 years                m2   \n",
       "\n",
       "  Home Library Definition Circulation Active Month  Circulation Active Year  \\\n",
       "0                    Main                      Oct                   2022.0   \n",
       "1                    Main                      Jul                   2023.0   \n",
       "2                    Main                     None                      NaN   \n",
       "3                Presidio                      Jul                   2023.0   \n",
       "4                    Main                      Jul                   2023.0   \n",
       "5                    Main                      Jul                   2023.0   \n",
       "6                    Main                      Mar                   2020.0   \n",
       "7              Bookmobile                      Feb                   2021.0   \n",
       "8                    Main                      Apr                   2020.0   \n",
       "9                  Marina                      May                   2023.0   \n",
       "\n",
       "  Notice Preference Code Notice Preference Definition  Provided Email Address  \\\n",
       "0                      z                        Email                    True   \n",
       "1                      z                        Email                    True   \n",
       "2                      z                        Email                    True   \n",
       "3                      z                        Email                    True   \n",
       "4                      z                        Email                    True   \n",
       "5                   None                         None                   False   \n",
       "6                      z                        Email                    True   \n",
       "7                      z                        Email                    True   \n",
       "8                      z                        Email                    True   \n",
       "9                      z                        Email                    True   \n",
       "\n",
       "   Year Patron Registered  Within San Francisco County  \n",
       "0                    2022                        False  \n",
       "1                    2021                        False  \n",
       "2                    2023                        False  \n",
       "3                    2021                        False  \n",
       "4                    2003                        False  \n",
       "5                    2003                        False  \n",
       "6                    2020                        False  \n",
       "7                    2009                        False  \n",
       "8                    2017                        False  \n",
       "9                    2021                        False  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "df = pd.read_csv('../data/Library_Usage_Small.csv',\n",
    "                 low_memory=False\n",
    "                )\n",
    "df.to_json('../data/Library_Usage_Small.json')\n",
    "df = pd.read_json('../data/Library_Usage_Small.json')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>Patron Type Code</th>\n",
       "      <th>Patron Type Definition</th>\n",
       "      <th>Total Checkouts</th>\n",
       "      <th>Total Renewals</th>\n",
       "      <th>Age Range</th>\n",
       "      <th>Home Library Code</th>\n",
       "      <th>Home Library Definition</th>\n",
       "      <th>Circulation Active Month</th>\n",
       "      <th>Circulation Active Year</th>\n",
       "      <th>Notice Preference Code</th>\n",
       "      <th>Notice Preference Definition</th>\n",
       "      <th>Provided Email Address</th>\n",
       "      <th>Year Patron Registered</th>\n",
       "      <th>Within San Francisco County</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>123022</td>\n",
       "      <td>2</td>\n",
       "      <td>Teen</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10 to 19 years</td>\n",
       "      <td>x</td>\n",
       "      <td>Main</td>\n",
       "      <td>Oct</td>\n",
       "      <td>2022.0</td>\n",
       "      <td>z</td>\n",
       "      <td>Email</td>\n",
       "      <td>True</td>\n",
       "      <td>2022</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>125054</td>\n",
       "      <td>0</td>\n",
       "      <td>Adult</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>25 to 34 years</td>\n",
       "      <td>x</td>\n",
       "      <td>Main</td>\n",
       "      <td>Jul</td>\n",
       "      <td>2023.0</td>\n",
       "      <td>z</td>\n",
       "      <td>Email</td>\n",
       "      <td>True</td>\n",
       "      <td>2021</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>87884</td>\n",
       "      <td>0</td>\n",
       "      <td>Adult</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>25 to 34 years</td>\n",
       "      <td>x</td>\n",
       "      <td>Main</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>z</td>\n",
       "      <td>Email</td>\n",
       "      <td>True</td>\n",
       "      <td>2023</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>409236</td>\n",
       "      <td>0</td>\n",
       "      <td>Adult</td>\n",
       "      <td>19</td>\n",
       "      <td>40</td>\n",
       "      <td>20 to 24 years</td>\n",
       "      <td>p9</td>\n",
       "      <td>Presidio</td>\n",
       "      <td>Jul</td>\n",
       "      <td>2023.0</td>\n",
       "      <td>z</td>\n",
       "      <td>Email</td>\n",
       "      <td>True</td>\n",
       "      <td>2021</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>47911</td>\n",
       "      <td>3</td>\n",
       "      <td>Senior</td>\n",
       "      <td>1079</td>\n",
       "      <td>197</td>\n",
       "      <td>75 years and over</td>\n",
       "      <td>x</td>\n",
       "      <td>Main</td>\n",
       "      <td>Jul</td>\n",
       "      <td>2023.0</td>\n",
       "      <td>z</td>\n",
       "      <td>Email</td>\n",
       "      <td>True</td>\n",
       "      <td>2003</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>393489</td>\n",
       "      <td>0</td>\n",
       "      <td>Adult</td>\n",
       "      <td>10</td>\n",
       "      <td>5</td>\n",
       "      <td>45 to 54 years</td>\n",
       "      <td>x</td>\n",
       "      <td>Main</td>\n",
       "      <td>Jul</td>\n",
       "      <td>2023.0</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>False</td>\n",
       "      <td>2003</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>5884</td>\n",
       "      <td>0</td>\n",
       "      <td>Adult</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>25 to 34 years</td>\n",
       "      <td>x</td>\n",
       "      <td>Main</td>\n",
       "      <td>Mar</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>z</td>\n",
       "      <td>Email</td>\n",
       "      <td>True</td>\n",
       "      <td>2020</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>329892</td>\n",
       "      <td>2</td>\n",
       "      <td>Teen</td>\n",
       "      <td>137</td>\n",
       "      <td>0</td>\n",
       "      <td>10 to 19 years</td>\n",
       "      <td>yb</td>\n",
       "      <td>Bookmobile</td>\n",
       "      <td>Feb</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>z</td>\n",
       "      <td>Email</td>\n",
       "      <td>True</td>\n",
       "      <td>2009</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>49195</td>\n",
       "      <td>1</td>\n",
       "      <td>Juvenile</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10 to 19 years</td>\n",
       "      <td>x</td>\n",
       "      <td>Main</td>\n",
       "      <td>Apr</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>z</td>\n",
       "      <td>Email</td>\n",
       "      <td>True</td>\n",
       "      <td>2017</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>298115</td>\n",
       "      <td>1</td>\n",
       "      <td>Juvenile</td>\n",
       "      <td>6</td>\n",
       "      <td>23</td>\n",
       "      <td>0 to 9 years</td>\n",
       "      <td>m2</td>\n",
       "      <td>Marina</td>\n",
       "      <td>May</td>\n",
       "      <td>2023.0</td>\n",
       "      <td>z</td>\n",
       "      <td>Email</td>\n",
       "      <td>True</td>\n",
       "      <td>2021</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0  Patron Type Code Patron Type Definition  Total Checkouts  \\\n",
       "0      123022                 2                   Teen                0   \n",
       "1      125054                 0                  Adult                0   \n",
       "2       87884                 0                  Adult                0   \n",
       "3      409236                 0                  Adult               19   \n",
       "4       47911                 3                 Senior             1079   \n",
       "5      393489                 0                  Adult               10   \n",
       "6        5884                 0                  Adult                0   \n",
       "7      329892                 2                   Teen              137   \n",
       "8       49195                 1               Juvenile                0   \n",
       "9      298115                 1               Juvenile                6   \n",
       "\n",
       "   Total Renewals          Age Range Home Library Code  \\\n",
       "0               0     10 to 19 years                 x   \n",
       "1               0     25 to 34 years                 x   \n",
       "2               0     25 to 34 years                 x   \n",
       "3              40     20 to 24 years                p9   \n",
       "4             197  75 years and over                 x   \n",
       "5               5     45 to 54 years                 x   \n",
       "6               0     25 to 34 years                 x   \n",
       "7               0     10 to 19 years                yb   \n",
       "8               0     10 to 19 years                 x   \n",
       "9              23       0 to 9 years                m2   \n",
       "\n",
       "  Home Library Definition Circulation Active Month  Circulation Active Year  \\\n",
       "0                    Main                      Oct                   2022.0   \n",
       "1                    Main                      Jul                   2023.0   \n",
       "2                    Main                     None                      NaN   \n",
       "3                Presidio                      Jul                   2023.0   \n",
       "4                    Main                      Jul                   2023.0   \n",
       "5                    Main                      Jul                   2023.0   \n",
       "6                    Main                      Mar                   2020.0   \n",
       "7              Bookmobile                      Feb                   2021.0   \n",
       "8                    Main                      Apr                   2020.0   \n",
       "9                  Marina                      May                   2023.0   \n",
       "\n",
       "  Notice Preference Code Notice Preference Definition  Provided Email Address  \\\n",
       "0                      z                        Email                    True   \n",
       "1                      z                        Email                    True   \n",
       "2                      z                        Email                    True   \n",
       "3                      z                        Email                    True   \n",
       "4                      z                        Email                    True   \n",
       "5                   None                         None                   False   \n",
       "6                      z                        Email                    True   \n",
       "7                      z                        Email                    True   \n",
       "8                      z                        Email                    True   \n",
       "9                      z                        Email                    True   \n",
       "\n",
       "   Year Patron Registered  Within San Francisco County  \n",
       "0                    2022                        False  \n",
       "1                    2021                        False  \n",
       "2                    2023                        False  \n",
       "3                    2021                        False  \n",
       "4                    2003                        False  \n",
       "5                    2003                        False  \n",
       "6                    2020                        False  \n",
       "7                    2009                        False  \n",
       "8                    2017                        False  \n",
       "9                    2021                        False  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.to_html('../data/Library_Usage_Small.html', index=False)\n",
    "df = pd.read_html('../data/Library_Usage_Small.html')\n",
    "df = df[0]\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>Unnamed: 0</th>\n",
       "      <th>Patron Type Code</th>\n",
       "      <th>Patron Type Definition</th>\n",
       "      <th>Total Checkouts</th>\n",
       "      <th>Total Renewals</th>\n",
       "      <th>Age Range</th>\n",
       "      <th>Home Library Code</th>\n",
       "      <th>Home Library Definition</th>\n",
       "      <th>Circulation Active Month</th>\n",
       "      <th>Circulation Active Year</th>\n",
       "      <th>Notice Preference Code</th>\n",
       "      <th>Notice Preference Definition</th>\n",
       "      <th>Provided Email Address</th>\n",
       "      <th>Year Patron Registered</th>\n",
       "      <th>Within San Francisco County</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>123022</td>\n",
       "      <td>2</td>\n",
       "      <td>Teen</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10 to 19 years</td>\n",
       "      <td>x</td>\n",
       "      <td>Main</td>\n",
       "      <td>Oct</td>\n",
       "      <td>2022.0</td>\n",
       "      <td>z</td>\n",
       "      <td>Email</td>\n",
       "      <td>True</td>\n",
       "      <td>2022</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>125054</td>\n",
       "      <td>0</td>\n",
       "      <td>Adult</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>25 to 34 years</td>\n",
       "      <td>x</td>\n",
       "      <td>Main</td>\n",
       "      <td>Jul</td>\n",
       "      <td>2023.0</td>\n",
       "      <td>z</td>\n",
       "      <td>Email</td>\n",
       "      <td>True</td>\n",
       "      <td>2021</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>87884</td>\n",
       "      <td>0</td>\n",
       "      <td>Adult</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>25 to 34 years</td>\n",
       "      <td>x</td>\n",
       "      <td>Main</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>z</td>\n",
       "      <td>Email</td>\n",
       "      <td>True</td>\n",
       "      <td>2023</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>409236</td>\n",
       "      <td>0</td>\n",
       "      <td>Adult</td>\n",
       "      <td>19</td>\n",
       "      <td>40</td>\n",
       "      <td>20 to 24 years</td>\n",
       "      <td>p9</td>\n",
       "      <td>Presidio</td>\n",
       "      <td>Jul</td>\n",
       "      <td>2023.0</td>\n",
       "      <td>z</td>\n",
       "      <td>Email</td>\n",
       "      <td>True</td>\n",
       "      <td>2021</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>47911</td>\n",
       "      <td>3</td>\n",
       "      <td>Senior</td>\n",
       "      <td>1079</td>\n",
       "      <td>197</td>\n",
       "      <td>75 years and over</td>\n",
       "      <td>x</td>\n",
       "      <td>Main</td>\n",
       "      <td>Jul</td>\n",
       "      <td>2023.0</td>\n",
       "      <td>z</td>\n",
       "      <td>Email</td>\n",
       "      <td>True</td>\n",
       "      <td>2003</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>393489</td>\n",
       "      <td>0</td>\n",
       "      <td>Adult</td>\n",
       "      <td>10</td>\n",
       "      <td>5</td>\n",
       "      <td>45 to 54 years</td>\n",
       "      <td>x</td>\n",
       "      <td>Main</td>\n",
       "      <td>Jul</td>\n",
       "      <td>2023.0</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>False</td>\n",
       "      <td>2003</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>5884</td>\n",
       "      <td>0</td>\n",
       "      <td>Adult</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>25 to 34 years</td>\n",
       "      <td>x</td>\n",
       "      <td>Main</td>\n",
       "      <td>Mar</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>z</td>\n",
       "      <td>Email</td>\n",
       "      <td>True</td>\n",
       "      <td>2020</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>329892</td>\n",
       "      <td>2</td>\n",
       "      <td>Teen</td>\n",
       "      <td>137</td>\n",
       "      <td>0</td>\n",
       "      <td>10 to 19 years</td>\n",
       "      <td>yb</td>\n",
       "      <td>Bookmobile</td>\n",
       "      <td>Feb</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>z</td>\n",
       "      <td>Email</td>\n",
       "      <td>True</td>\n",
       "      <td>2009</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>49195</td>\n",
       "      <td>1</td>\n",
       "      <td>Juvenile</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10 to 19 years</td>\n",
       "      <td>x</td>\n",
       "      <td>Main</td>\n",
       "      <td>Apr</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>z</td>\n",
       "      <td>Email</td>\n",
       "      <td>True</td>\n",
       "      <td>2017</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>298115</td>\n",
       "      <td>1</td>\n",
       "      <td>Juvenile</td>\n",
       "      <td>6</td>\n",
       "      <td>23</td>\n",
       "      <td>0 to 9 years</td>\n",
       "      <td>m2</td>\n",
       "      <td>Marina</td>\n",
       "      <td>May</td>\n",
       "      <td>2023.0</td>\n",
       "      <td>z</td>\n",
       "      <td>Email</td>\n",
       "      <td>True</td>\n",
       "      <td>2021</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0  Patron Type Code Patron Type Definition  Total Checkouts  \\\n",
       "0      123022                 2                   Teen                0   \n",
       "1      125054                 0                  Adult                0   \n",
       "2       87884                 0                  Adult                0   \n",
       "3      409236                 0                  Adult               19   \n",
       "4       47911                 3                 Senior             1079   \n",
       "5      393489                 0                  Adult               10   \n",
       "6        5884                 0                  Adult                0   \n",
       "7      329892                 2                   Teen              137   \n",
       "8       49195                 1               Juvenile                0   \n",
       "9      298115                 1               Juvenile                6   \n",
       "\n",
       "   Total Renewals          Age Range Home Library Code  \\\n",
       "0               0     10 to 19 years                 x   \n",
       "1               0     25 to 34 years                 x   \n",
       "2               0     25 to 34 years                 x   \n",
       "3              40     20 to 24 years                p9   \n",
       "4             197  75 years and over                 x   \n",
       "5               5     45 to 54 years                 x   \n",
       "6               0     25 to 34 years                 x   \n",
       "7               0     10 to 19 years                yb   \n",
       "8               0     10 to 19 years                 x   \n",
       "9              23       0 to 9 years                m2   \n",
       "\n",
       "  Home Library Definition Circulation Active Month  Circulation Active Year  \\\n",
       "0                    Main                      Oct                   2022.0   \n",
       "1                    Main                      Jul                   2023.0   \n",
       "2                    Main                     None                      NaN   \n",
       "3                Presidio                      Jul                   2023.0   \n",
       "4                    Main                      Jul                   2023.0   \n",
       "5                    Main                      Jul                   2023.0   \n",
       "6                    Main                      Mar                   2020.0   \n",
       "7              Bookmobile                      Feb                   2021.0   \n",
       "8                    Main                      Apr                   2020.0   \n",
       "9                  Marina                      May                   2023.0   \n",
       "\n",
       "  Notice Preference Code Notice Preference Definition  Provided Email Address  \\\n",
       "0                      z                        Email                    True   \n",
       "1                      z                        Email                    True   \n",
       "2                      z                        Email                    True   \n",
       "3                      z                        Email                    True   \n",
       "4                      z                        Email                    True   \n",
       "5                   None                         None                   False   \n",
       "6                      z                        Email                    True   \n",
       "7                      z                        Email                    True   \n",
       "8                      z                        Email                    True   \n",
       "9                      z                        Email                    True   \n",
       "\n",
       "   Year Patron Registered  Within San Francisco County  \n",
       "0                    2022                        False  \n",
       "1                    2021                        False  \n",
       "2                    2023                        False  \n",
       "3                    2021                        False  \n",
       "4                    2003                        False  \n",
       "5                    2003                        False  \n",
       "6                    2020                        False  \n",
       "7                    2009                        False  \n",
       "8                    2017                        False  \n",
       "9                    2021                        False  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.to_excel('../data/Library_Usage_Small.xlsx', index=False)\n",
    "df = pd.read_excel('../data/Library_Usage_Small.xlsx')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('../data/Library_Usage_Small_Copy.csv')\n",
    "#df.to_csv('../data/Library_Usage_Small_Copy.csv', index=False) \n",
    "#Vergleiche die resultierenden Dateien!"
   ]
  },
  {
   "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.9.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}