Weekly.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import requests\n",
    "from bs4 import BeautifulSoup"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Import list of spreadsheet links"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Get spreadsheet links for 2022 through July 24, 2023\n",
    "r = requests.get('https://www.maricopa.gov/Archive.aspx?AMID=128')\n",
    "soup = BeautifulSoup(r.content)\n",
    "urls = soup.find('div', {'id':'modulecontent'}).find_all('a', href=True)[1:83]\n",
    "urls = ['https://www.maricopa.gov/'+x['href'] for x in urls]\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Import spreadsheet data into DataFrame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "https://www.maricopa.gov/Archive.aspx?ADID=5662\n",
      "WARNING *** file size (139200) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5660\n",
      "WARNING *** file size (147392) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5654\n",
      "WARNING *** file size (139200) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5649\n",
      "WARNING *** file size (180160) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5645\n",
      "WARNING *** file size (171968) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5639\n",
      "WARNING *** file size (163776) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5635\n",
      "WARNING *** file size (171968) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5624\n",
      "WARNING *** file size (155584) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5620\n",
      "WARNING *** file size (212928) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5619\n",
      "WARNING *** file size (155584) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5597\n",
      "WARNING *** file size (171968) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5596\n",
      "WARNING *** file size (221120) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5593\n",
      "WARNING *** file size (180160) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5590\n",
      "WARNING *** file size (180160) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5584\n",
      "WARNING *** file size (171968) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5575\n",
      "WARNING *** file size (204736) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5574\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5573\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5572\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5563\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5562\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5559\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5558\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5556\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5553\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5550\n",
      "WARNING *** file size (171968) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5547\n",
      "WARNING *** file size (106432) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5546\n",
      "WARNING *** file size (131008) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5541\n",
      "WARNING *** file size (114624) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5540\n",
      "WARNING *** file size (139200) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5539\n",
      "WARNING *** file size (163776) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5533\n",
      "WARNING *** file size (180160) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5530\n",
      "WARNING *** file size (180160) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5526\n",
      "WARNING *** file size (196544) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5521\n",
      "WARNING *** file size (98240) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5520\n",
      "WARNING *** file size (163776) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5517\n",
      "WARNING *** file size (327616) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5514\n",
      "WARNING *** file size (196544) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5510\n",
      "WARNING *** file size (155584) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5506\n",
      "WARNING *** file size (171968) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5503\n",
      "WARNING *** file size (155584) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5498\n",
      "WARNING *** file size (188352) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5491\n",
      "WARNING *** file size (212928) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5487\n",
      "WARNING *** file size (204736) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5485\n",
      "WARNING *** file size (171968) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5480\n",
      "WARNING *** file size (163776) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5476\n",
      "WARNING *** file size (221120) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5474\n",
      "WARNING *** file size (237504) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5472\n",
      "WARNING *** file size (253888) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5468\n",
      "WARNING *** file size (311232) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5462\n",
      "WARNING *** file size (262080) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5457\n",
      "WARNING *** file size (196544) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5453\n",
      "WARNING *** file size (221120) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5449\n",
      "WARNING *** file size (212928) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5445\n",
      "WARNING *** file size (171968) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5443\n",
      "WARNING *** file size (171968) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5436\n",
      "WARNING *** file size (188352) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5434\n",
      "WARNING *** file size (253888) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5428\n",
      "WARNING *** file size (229312) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5426\n",
      "WARNING *** file size (180160) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5422\n",
      "WARNING *** file size (196544) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5418\n",
      "WARNING *** file size (229312) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5414\n",
      "WARNING *** file size (253888) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5409\n",
      "WARNING *** file size (212928) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5408\n",
      "WARNING *** file size (221120) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5405\n",
      "WARNING *** file size (245696) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5401\n",
      "WARNING *** file size (229312) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5396\n",
      "WARNING *** file size (245696) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5395\n",
      "WARNING *** file size (270272) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5390\n",
      "WARNING *** file size (163776) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5389\n",
      "WARNING *** file size (196544) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5385\n",
      "WARNING *** file size (204736) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5382\n",
      "WARNING *** file size (303040) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5379\n",
      "WARNING *** file size (155584) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5376\n",
      "WARNING *** file size (221120) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5371\n",
      "WARNING *** file size (212928) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5368\n",
      "WARNING *** file size (212928) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5363\n",
      "WARNING *** file size (262080) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5362\n",
      "WARNING *** file size (131008) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5361\n",
      "WARNING *** file size (212928) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5360\n",
      "WARNING *** file size (155584) not 512 + multiple of sector size (512)\n",
      "https://www.maricopa.gov/Archive.aspx?ADID=5359\n",
      "WARNING *** file size (180160) not 512 + multiple of sector size (512)\n"
     ]
    }
   ],
   "source": [
    "df = pd.DataFrame()\n",
    "\n",
    "for url in urls:\n",
    "    print(url)\n",
    "    r = requests.get(url)\n",
    "    df = pd.concat([df, pd.read_excel(r.content)], ignore_index=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### FIlter to new residential construction"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 4573 entries, 0 to 4572\n",
      "Data columns (total 19 columns):\n",
      " #   Column                             Non-Null Count  Dtype         \n",
      "---  ------                             --------------  -----         \n",
      " 0   DESCRIPTION                        4573 non-null   object        \n",
      " 1   CATEGORY                           4573 non-null   object        \n",
      " 2   TRACKING NUMBER                    4573 non-null   object        \n",
      " 3   ISSUE DATE                         4573 non-null   datetime64[ns]\n",
      " 4   THIS PERMIT IS FOR                 4573 non-null   object        \n",
      " 5   VALUATION                          4573 non-null   float64       \n",
      " 6   BUILDING FOOTPRINT SQUARE FOOTAGE  4518 non-null   float64       \n",
      " 7   PARCEL NO                          4568 non-null   object        \n",
      " 8   NO UNITS                           4573 non-null   int64         \n",
      " 9   JOB ADDRESS                        4568 non-null   object        \n",
      " 10  SUBDIVISION                        2161 non-null   object        \n",
      " 11  LOT                                2481 non-null   object        \n",
      " 12  JOB CITY                           4559 non-null   object        \n",
      " 13  JOB STATE                          4558 non-null   object        \n",
      " 14  JOB ZIP                            4565 non-null   object        \n",
      " 15  OWNER NAME                         4573 non-null   object        \n",
      " 16  CONTRACTOR NAME                    2790 non-null   object        \n",
      " 17  CONTACTOR PHONE NUMBER             2230 non-null   object        \n",
      " 18  CONTRACTOR EMAIL                   1728 non-null   object        \n",
      "dtypes: datetime64[ns](1), float64(2), int64(1), object(15)\n",
      "memory usage: 678.9+ KB\n"
     ]
    }
   ],
   "source": [
    "newHousing = df.loc[(df.DESCRIPTION=='Residential')&(df.CATEGORY.isin(['New', 'New with Basement', 'Production']))].reset_index(drop=True)\n",
    "newHousing.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Data exploration"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "CONTRACTOR NAME\n",
       "La Casa Dulce                           305\n",
       "SHALC GC INC                            176\n",
       "RICHMOND AMERICAN CONSTRUCTION, INC.    129\n",
       "KM Development Corp                     102\n",
       "MATTAMY ARIZONA CONSTRUCTION LLC         94\n",
       "                                       ... \n",
       "Mattamy Arizona Construction LLC          1\n",
       "Monument Homes LLC                        1\n",
       "Kim Heng Hour                             1\n",
       "ADAIR HOMES OF ARIZONA, INC.              1\n",
       "Impact Homes                              1\n",
       "Name: count, Length: 439, dtype: int64"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "newHousing['CONTRACTOR NAME'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "OWNER NAME\n",
       "BUNGALOWS ON COTTON LANE LLC                   304\n",
       "LENNAR ARIZONA INC                             248\n",
       "MERITAGE HOMES OF ARIZONA INC                  247\n",
       "MATTAMY ARIZONA LLC                            198\n",
       "AG EHC II LEN MULTI STATE 2 LLC                196\n",
       "                                              ... \n",
       "GERHARDT SANDRA L/WILLIAM H JR                   1\n",
       "INMAN CHARLES E/JERI L                           1\n",
       "FRUIT CHARLES                                    1\n",
       "BLAKENSHIP WALTER S                              1\n",
       "SCOTT COMMUNITIES AT RANCHO CABRILLO H, LLC      1\n",
       "Name: count, Length: 1339, dtype: int64"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "newHousing['OWNER NAME'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>DESCRIPTION</th>\n",
       "      <th>CATEGORY</th>\n",
       "      <th>TRACKING NUMBER</th>\n",
       "      <th>ISSUE DATE</th>\n",
       "      <th>THIS PERMIT IS FOR</th>\n",
       "      <th>VALUATION</th>\n",
       "      <th>BUILDING FOOTPRINT SQUARE FOOTAGE</th>\n",
       "      <th>PARCEL NO</th>\n",
       "      <th>NO UNITS</th>\n",
       "      <th>JOB ADDRESS</th>\n",
       "      <th>SUBDIVISION</th>\n",
       "      <th>LOT</th>\n",
       "      <th>JOB CITY</th>\n",
       "      <th>JOB STATE</th>\n",
       "      <th>JOB ZIP</th>\n",
       "      <th>OWNER NAME</th>\n",
       "      <th>CONTRACTOR NAME</th>\n",
       "      <th>CONTACTOR PHONE NUMBER</th>\n",
       "      <th>CONTRACTOR EMAIL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Residential</td>\n",
       "      <td>New</td>\n",
       "      <td>B202200165</td>\n",
       "      <td>2023-07-20</td>\n",
       "      <td>CUSTOM SINGLE FAMILY RESIDENCE                ...</td>\n",
       "      <td>299465.31</td>\n",
       "      <td>4134.0</td>\n",
       "      <td>300-79-009B</td>\n",
       "      <td>1</td>\n",
       "      <td>9724 S 28TH Dr\\nLAVEEN, AZ 85339</td>\n",
       "      <td>LAS LOMAS</td>\n",
       "      <td>9.0</td>\n",
       "      <td>LAVEEN</td>\n",
       "      <td>AZ</td>\n",
       "      <td>85339.0</td>\n",
       "      <td>ENRIQUEZ ALEJANDRO LUNA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Residential</td>\n",
       "      <td>Production</td>\n",
       "      <td>B202200618</td>\n",
       "      <td>2023-07-19</td>\n",
       "      <td>LOT 82 SP20210096 SFR PLAN 2012 ELEV A MIRROR ...</td>\n",
       "      <td>187691.00</td>\n",
       "      <td>2591.0</td>\n",
       "      <td>502-40-584</td>\n",
       "      <td>1</td>\n",
       "      <td>19463 W ANNIKA Dr\\nLITCHFIELD PARK, AZ 85340</td>\n",
       "      <td>ZANJERO TRAILS PARCEL 34A</td>\n",
       "      <td>82.0</td>\n",
       "      <td>LITCHFIELD PARK</td>\n",
       "      <td>AZ</td>\n",
       "      <td>85340.0</td>\n",
       "      <td>GEHAN HOMES OF ARIZONA LLC</td>\n",
       "      <td>Gehan Homes Construction Company, LLC.</td>\n",
       "      <td>4806465950.0</td>\n",
       "      <td>mmoskal@gehanhomes.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Residential</td>\n",
       "      <td>New</td>\n",
       "      <td>B202202558</td>\n",
       "      <td>2023-07-18</td>\n",
       "      <td>CUSTOM SINGLE FAMILY RESIDENCE / MIRROR IMAGE ...</td>\n",
       "      <td>268533.60</td>\n",
       "      <td>3707.0</td>\n",
       "      <td>503-35-101</td>\n",
       "      <td>1</td>\n",
       "      <td>28228 N 213TH Dr\\nWITTMANN, AZ 85361</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>WITTMANN</td>\n",
       "      <td>AZ</td>\n",
       "      <td>85361.0</td>\n",
       "      <td>KBBS DEVELOPMENT LLC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Residential</td>\n",
       "      <td>Production</td>\n",
       "      <td>B202203745</td>\n",
       "      <td>2023-07-21</td>\n",
       "      <td>SP20210189 SINGLE FAMILY RESIDENCE / ELEVATION...</td>\n",
       "      <td>168784.27</td>\n",
       "      <td>2330.0</td>\n",
       "      <td>502-40-707</td>\n",
       "      <td>1</td>\n",
       "      <td>5538 N 194TH Ln\\nLITCHFIELD PARK, AZ 85340</td>\n",
       "      <td>ZANJERO TRAILS PARCEL 34B</td>\n",
       "      <td>75.0</td>\n",
       "      <td>LITCHFIELD PARK</td>\n",
       "      <td>AZ</td>\n",
       "      <td>85340.0</td>\n",
       "      <td>WEEKLEY HOMES LLC</td>\n",
       "      <td>Weekley Homes, LLC</td>\n",
       "      <td>4807684987.0</td>\n",
       "      <td>TBRAY@DWHOMES.COM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Residential</td>\n",
       "      <td>New</td>\n",
       "      <td>B202212920</td>\n",
       "      <td>2023-07-20</td>\n",
       "      <td>SP20210188 SINGLE FAMILY RESIDENCE // PLAN 112...</td>\n",
       "      <td>118221.43</td>\n",
       "      <td>1632.0</td>\n",
       "      <td>220-29-011F</td>\n",
       "      <td>1</td>\n",
       "      <td>9636 E BOISE St\\nMESA, AZ 85207</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MESA</td>\n",
       "      <td>AZ</td>\n",
       "      <td>85207.0</td>\n",
       "      <td>RAMOS ELIJIO P</td>\n",
       "      <td>Copper Sky Homes, LLC</td>\n",
       "      <td>4802651455.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   DESCRIPTION    CATEGORY TRACKING NUMBER ISSUE DATE  \\\n",
       "0  Residential         New      B202200165 2023-07-20   \n",
       "1  Residential  Production      B202200618 2023-07-19   \n",
       "2  Residential         New      B202202558 2023-07-18   \n",
       "3  Residential  Production      B202203745 2023-07-21   \n",
       "4  Residential         New      B202212920 2023-07-20   \n",
       "\n",
       "                                  THIS PERMIT IS FOR  VALUATION  \\\n",
       "0  CUSTOM SINGLE FAMILY RESIDENCE                ...  299465.31   \n",
       "1  LOT 82 SP20210096 SFR PLAN 2012 ELEV A MIRROR ...  187691.00   \n",
       "2  CUSTOM SINGLE FAMILY RESIDENCE / MIRROR IMAGE ...  268533.60   \n",
       "3  SP20210189 SINGLE FAMILY RESIDENCE / ELEVATION...  168784.27   \n",
       "4  SP20210188 SINGLE FAMILY RESIDENCE // PLAN 112...  118221.43   \n",
       "\n",
       "   BUILDING FOOTPRINT SQUARE FOOTAGE    PARCEL NO  NO UNITS  \\\n",
       "0                             4134.0  300-79-009B         1   \n",
       "1                             2591.0   502-40-584         1   \n",
       "2                             3707.0   503-35-101         1   \n",
       "3                             2330.0   502-40-707         1   \n",
       "4                             1632.0  220-29-011F         1   \n",
       "\n",
       "                                    JOB ADDRESS                 SUBDIVISION  \\\n",
       "0              9724 S 28TH Dr\\nLAVEEN, AZ 85339                   LAS LOMAS   \n",
       "1  19463 W ANNIKA Dr\\nLITCHFIELD PARK, AZ 85340   ZANJERO TRAILS PARCEL 34A   \n",
       "2          28228 N 213TH Dr\\nWITTMANN, AZ 85361                         NaN   \n",
       "3    5538 N 194TH Ln\\nLITCHFIELD PARK, AZ 85340   ZANJERO TRAILS PARCEL 34B   \n",
       "4               9636 E BOISE St\\nMESA, AZ 85207                         NaN   \n",
       "\n",
       "    LOT         JOB CITY JOB STATE  JOB ZIP                  OWNER NAME  \\\n",
       "0   9.0           LAVEEN        AZ  85339.0     ENRIQUEZ ALEJANDRO LUNA   \n",
       "1  82.0  LITCHFIELD PARK        AZ  85340.0  GEHAN HOMES OF ARIZONA LLC   \n",
       "2   NaN         WITTMANN        AZ  85361.0        KBBS DEVELOPMENT LLC   \n",
       "3  75.0  LITCHFIELD PARK        AZ  85340.0           WEEKLEY HOMES LLC   \n",
       "4   NaN             MESA        AZ  85207.0              RAMOS ELIJIO P   \n",
       "\n",
       "                          CONTRACTOR NAME CONTACTOR PHONE NUMBER  \\\n",
       "0                                     NaN                    NaN   \n",
       "1  Gehan Homes Construction Company, LLC.           4806465950.0   \n",
       "2                                     NaN                    NaN   \n",
       "3                      Weekley Homes, LLC           4807684987.0   \n",
       "4                   Copper Sky Homes, LLC           4802651455.0   \n",
       "\n",
       "         CONTRACTOR EMAIL  \n",
       "0                     NaN  \n",
       "1  mmoskal@gehanhomes.com  \n",
       "2                     NaN  \n",
       "3       TBRAY@DWHOMES.COM  \n",
       "4                     NaN  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "newHousing.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>DESCRIPTION</th>\n",
       "      <th>CATEGORY</th>\n",
       "      <th>TRACKING NUMBER</th>\n",
       "      <th>ISSUE DATE</th>\n",
       "      <th>THIS PERMIT IS FOR</th>\n",
       "      <th>VALUATION</th>\n",
       "      <th>BUILDING FOOTPRINT SQUARE FOOTAGE</th>\n",
       "      <th>PARCEL NO</th>\n",
       "      <th>NO UNITS</th>\n",
       "      <th>JOB ADDRESS</th>\n",
       "      <th>SUBDIVISION</th>\n",
       "      <th>LOT</th>\n",
       "      <th>JOB CITY</th>\n",
       "      <th>JOB STATE</th>\n",
       "      <th>JOB ZIP</th>\n",
       "      <th>OWNER NAME</th>\n",
       "      <th>CONTRACTOR NAME</th>\n",
       "      <th>CONTACTOR PHONE NUMBER</th>\n",
       "      <th>CONTRACTOR EMAIL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Residential</td>\n",
       "      <td>Production</td>\n",
       "      <td>B202215669</td>\n",
       "      <td>2023-07-17</td>\n",
       "      <td>SP20200181 // PRODUCTION SINGLE FAMILY RESIDEN...</td>\n",
       "      <td>217463.68</td>\n",
       "      <td>3002.0</td>\n",
       "      <td>502-32-808</td>\n",
       "      <td>1</td>\n",
       "      <td>4745 N 191ST Dr\\nLITCHFIELD PARK, AZ 85340</td>\n",
       "      <td>THE LANDINGS PARCEL 2-2</td>\n",
       "      <td>47.0</td>\n",
       "      <td>LITCHFIELD PARK</td>\n",
       "      <td>AZ</td>\n",
       "      <td>85340.0</td>\n",
       "      <td>LENNAR ARIZONA INC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>420</th>\n",
       "      <td>Residential</td>\n",
       "      <td>Production</td>\n",
       "      <td>B202303862</td>\n",
       "      <td>2023-05-04</td>\n",
       "      <td>SP20200190 SINGLE FAMILY RESIDENCE W/ 203 LF 6...</td>\n",
       "      <td>170740.14</td>\n",
       "      <td>2357.0</td>\n",
       "      <td>501-53-017</td>\n",
       "      <td>1</td>\n",
       "      <td>12377 W GLENN Dr\\nGLENDALE, AZ 85307</td>\n",
       "      <td>MARABELLA RANCH PARCEL 1</td>\n",
       "      <td>1</td>\n",
       "      <td>GLENDALE</td>\n",
       "      <td>AZ</td>\n",
       "      <td>85307.0</td>\n",
       "      <td>LENNAR ARIZONA INC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4807601249.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421</th>\n",
       "      <td>Residential</td>\n",
       "      <td>Production</td>\n",
       "      <td>B202303864</td>\n",
       "      <td>2023-05-04</td>\n",
       "      <td>SP20200157 SINGLE FAMILY RESIDENCE W/ 229 LF X...</td>\n",
       "      <td>182330.47</td>\n",
       "      <td>2517.0</td>\n",
       "      <td>501-53-018</td>\n",
       "      <td>1</td>\n",
       "      <td>12369 W GLENN Dr\\nGLENDALE, AZ 85307</td>\n",
       "      <td>MARABELLA RANCH PARCEL 1</td>\n",
       "      <td>2</td>\n",
       "      <td>GLENDALE</td>\n",
       "      <td>AZ</td>\n",
       "      <td>85307.0</td>\n",
       "      <td>LENNAR ARIZONA INC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4807601249.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422</th>\n",
       "      <td>Residential</td>\n",
       "      <td>Production</td>\n",
       "      <td>B202303865</td>\n",
       "      <td>2023-05-04</td>\n",
       "      <td>SP20200169 SINGLE FAMILY RESIDENCE W/ 202 LF X...</td>\n",
       "      <td>140532.82</td>\n",
       "      <td>1940.0</td>\n",
       "      <td>501-53-021</td>\n",
       "      <td>1</td>\n",
       "      <td>12345 W GLENN Dr\\nGLENDALE, AZ 85307</td>\n",
       "      <td>MARABELLA RANCH PARCEL 1</td>\n",
       "      <td>5</td>\n",
       "      <td>GLENDALE</td>\n",
       "      <td>AZ</td>\n",
       "      <td>85307.0</td>\n",
       "      <td>LENNAR ARIZONA INC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4807601249.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>423</th>\n",
       "      <td>Residential</td>\n",
       "      <td>Production</td>\n",
       "      <td>B202303866</td>\n",
       "      <td>2023-05-04</td>\n",
       "      <td>SP20200157 SINGLE FAMILY RESIDENCE w/ 239 LF X...</td>\n",
       "      <td>182330.47</td>\n",
       "      <td>2517.0</td>\n",
       "      <td>501-53-056</td>\n",
       "      <td>1</td>\n",
       "      <td>12370 W GLENN Dr\\nGLENDALE, AZ 85307</td>\n",
       "      <td>MARABELLA RANCH PARCEL 1</td>\n",
       "      <td>40</td>\n",
       "      <td>GLENDALE</td>\n",
       "      <td>AZ</td>\n",
       "      <td>85307.0</td>\n",
       "      <td>LENNAR ARIZONA INC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4807601249.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4492</th>\n",
       "      <td>Residential</td>\n",
       "      <td>Production</td>\n",
       "      <td>B202117515</td>\n",
       "      <td>2022-01-07</td>\n",
       "      <td>SP20200171 PRODUCTION SINGLE FAMILY RESIDENCE,...</td>\n",
       "      <td>226880.83</td>\n",
       "      <td>3132.0</td>\n",
       "      <td>501-53-708</td>\n",
       "      <td>0</td>\n",
       "      <td>12401 W VISTA Ave\\nGLENDALE, AZ 85307</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GLENDALE</td>\n",
       "      <td>AZ</td>\n",
       "      <td>85307</td>\n",
       "      <td>LENNAR ARIZONA INC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4529</th>\n",
       "      <td>Residential</td>\n",
       "      <td>Production</td>\n",
       "      <td>B202116584</td>\n",
       "      <td>2021-12-27</td>\n",
       "      <td>SP20210010 SFR PLAN 3520 ELEV A LOT 174 // 232...</td>\n",
       "      <td>189067.36</td>\n",
       "      <td>2610.0</td>\n",
       "      <td>501-05-185</td>\n",
       "      <td>1</td>\n",
       "      <td>17009 W ROYAL PALM Rd\\nWADDELL, AZ 85355</td>\n",
       "      <td>NORTHERN CROSSING</td>\n",
       "      <td>174.0</td>\n",
       "      <td>WADDELL</td>\n",
       "      <td>AZ</td>\n",
       "      <td>85355.0</td>\n",
       "      <td>LENNAR ARIZONA INC</td>\n",
       "      <td>Lennar Arizona Construction Inc.</td>\n",
       "      <td>4807601249.0</td>\n",
       "      <td>cory.calhoun@lennar.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4554</th>\n",
       "      <td>Residential</td>\n",
       "      <td>Production</td>\n",
       "      <td>B202116852</td>\n",
       "      <td>2021-12-28</td>\n",
       "      <td>SP20200190 // SFR , ELVEATION H, PLAN 3570  W/...</td>\n",
       "      <td>170740.14</td>\n",
       "      <td>2357.0</td>\n",
       "      <td>501-53-586</td>\n",
       "      <td>0</td>\n",
       "      <td>12546 W KALER Dr\\nGLENDALE, AZ 85307</td>\n",
       "      <td>MARBELLA RANCH PARCEL 5 AND PARCEL 6</td>\n",
       "      <td>8.0</td>\n",
       "      <td>GLENDALE</td>\n",
       "      <td>AZ</td>\n",
       "      <td>85307.0</td>\n",
       "      <td>LENNAR ARIZONA INC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4555</th>\n",
       "      <td>Residential</td>\n",
       "      <td>Production</td>\n",
       "      <td>B202116857</td>\n",
       "      <td>2021-12-27</td>\n",
       "      <td>SP20200170 // SFR MIRROR IMAGE - W. 247 LF 6FH...</td>\n",
       "      <td>212682.67</td>\n",
       "      <td>2936.0</td>\n",
       "      <td>501-53-774</td>\n",
       "      <td>0</td>\n",
       "      <td>12420 W WAGON WHEEL Dr\\nGLENDALE, AZ 85307</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GLENDALE</td>\n",
       "      <td>AZ</td>\n",
       "      <td>85307.0</td>\n",
       "      <td>LENNAR ARIZONA INC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4556</th>\n",
       "      <td>Residential</td>\n",
       "      <td>Production</td>\n",
       "      <td>B202116860</td>\n",
       "      <td>2021-12-27</td>\n",
       "      <td>SP20200173 SINGLE FAMILY RESIDENCE / 253 LF X ...</td>\n",
       "      <td>193848.37</td>\n",
       "      <td>2676.0</td>\n",
       "      <td>501-53-776</td>\n",
       "      <td>0</td>\n",
       "      <td>12432 W WAGON WHEEL Dr\\n 85307</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>85307.0</td>\n",
       "      <td>LENNAR ARIZONA INC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>248 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      DESCRIPTION    CATEGORY TRACKING NUMBER ISSUE DATE  \\\n",
       "9     Residential  Production      B202215669 2023-07-17   \n",
       "420   Residential  Production      B202303862 2023-05-04   \n",
       "421   Residential  Production      B202303864 2023-05-04   \n",
       "422   Residential  Production      B202303865 2023-05-04   \n",
       "423   Residential  Production      B202303866 2023-05-04   \n",
       "...           ...         ...             ...        ...   \n",
       "4492  Residential  Production      B202117515 2022-01-07   \n",
       "4529  Residential  Production      B202116584 2021-12-27   \n",
       "4554  Residential  Production      B202116852 2021-12-28   \n",
       "4555  Residential  Production      B202116857 2021-12-27   \n",
       "4556  Residential  Production      B202116860 2021-12-27   \n",
       "\n",
       "                                     THIS PERMIT IS FOR  VALUATION  \\\n",
       "9     SP20200181 // PRODUCTION SINGLE FAMILY RESIDEN...  217463.68   \n",
       "420   SP20200190 SINGLE FAMILY RESIDENCE W/ 203 LF 6...  170740.14   \n",
       "421   SP20200157 SINGLE FAMILY RESIDENCE W/ 229 LF X...  182330.47   \n",
       "422   SP20200169 SINGLE FAMILY RESIDENCE W/ 202 LF X...  140532.82   \n",
       "423   SP20200157 SINGLE FAMILY RESIDENCE w/ 239 LF X...  182330.47   \n",
       "...                                                 ...        ...   \n",
       "4492  SP20200171 PRODUCTION SINGLE FAMILY RESIDENCE,...  226880.83   \n",
       "4529  SP20210010 SFR PLAN 3520 ELEV A LOT 174 // 232...  189067.36   \n",
       "4554  SP20200190 // SFR , ELVEATION H, PLAN 3570  W/...  170740.14   \n",
       "4555  SP20200170 // SFR MIRROR IMAGE - W. 247 LF 6FH...  212682.67   \n",
       "4556  SP20200173 SINGLE FAMILY RESIDENCE / 253 LF X ...  193848.37   \n",
       "\n",
       "      BUILDING FOOTPRINT SQUARE FOOTAGE   PARCEL NO  NO UNITS  \\\n",
       "9                                3002.0  502-32-808         1   \n",
       "420                              2357.0  501-53-017         1   \n",
       "421                              2517.0  501-53-018         1   \n",
       "422                              1940.0  501-53-021         1   \n",
       "423                              2517.0  501-53-056         1   \n",
       "...                                 ...         ...       ...   \n",
       "4492                             3132.0  501-53-708         0   \n",
       "4529                             2610.0  501-05-185         1   \n",
       "4554                             2357.0  501-53-586         0   \n",
       "4555                             2936.0  501-53-774         0   \n",
       "4556                             2676.0  501-53-776         0   \n",
       "\n",
       "                                     JOB ADDRESS  \\\n",
       "9     4745 N 191ST Dr\\nLITCHFIELD PARK, AZ 85340   \n",
       "420         12377 W GLENN Dr\\nGLENDALE, AZ 85307   \n",
       "421         12369 W GLENN Dr\\nGLENDALE, AZ 85307   \n",
       "422         12345 W GLENN Dr\\nGLENDALE, AZ 85307   \n",
       "423         12370 W GLENN Dr\\nGLENDALE, AZ 85307   \n",
       "...                                          ...   \n",
       "4492       12401 W VISTA Ave\\nGLENDALE, AZ 85307   \n",
       "4529    17009 W ROYAL PALM Rd\\nWADDELL, AZ 85355   \n",
       "4554        12546 W KALER Dr\\nGLENDALE, AZ 85307   \n",
       "4555  12420 W WAGON WHEEL Dr\\nGLENDALE, AZ 85307   \n",
       "4556              12432 W WAGON WHEEL Dr\\n 85307   \n",
       "\n",
       "                               SUBDIVISION    LOT         JOB CITY JOB STATE  \\\n",
       "9                  THE LANDINGS PARCEL 2-2   47.0  LITCHFIELD PARK        AZ   \n",
       "420               MARABELLA RANCH PARCEL 1      1         GLENDALE        AZ   \n",
       "421               MARABELLA RANCH PARCEL 1      2         GLENDALE        AZ   \n",
       "422               MARABELLA RANCH PARCEL 1      5         GLENDALE        AZ   \n",
       "423               MARABELLA RANCH PARCEL 1     40         GLENDALE        AZ   \n",
       "...                                    ...    ...              ...       ...   \n",
       "4492                                   NaN    NaN         GLENDALE        AZ   \n",
       "4529                     NORTHERN CROSSING  174.0          WADDELL        AZ   \n",
       "4554  MARBELLA RANCH PARCEL 5 AND PARCEL 6    8.0         GLENDALE        AZ   \n",
       "4555                                   NaN    NaN         GLENDALE        AZ   \n",
       "4556                                   NaN    NaN              NaN       NaN   \n",
       "\n",
       "      JOB ZIP          OWNER NAME                   CONTRACTOR NAME  \\\n",
       "9     85340.0  LENNAR ARIZONA INC                               NaN   \n",
       "420   85307.0  LENNAR ARIZONA INC                               NaN   \n",
       "421   85307.0  LENNAR ARIZONA INC                               NaN   \n",
       "422   85307.0  LENNAR ARIZONA INC                               NaN   \n",
       "423   85307.0  LENNAR ARIZONA INC                               NaN   \n",
       "...       ...                 ...                               ...   \n",
       "4492    85307  LENNAR ARIZONA INC                               NaN   \n",
       "4529  85355.0  LENNAR ARIZONA INC  Lennar Arizona Construction Inc.   \n",
       "4554  85307.0  LENNAR ARIZONA INC                               NaN   \n",
       "4555  85307.0  LENNAR ARIZONA INC                               NaN   \n",
       "4556  85307.0  LENNAR ARIZONA INC                               NaN   \n",
       "\n",
       "     CONTACTOR PHONE NUMBER         CONTRACTOR EMAIL  \n",
       "9                       NaN                      NaN  \n",
       "420            4807601249.0                      NaN  \n",
       "421            4807601249.0                      NaN  \n",
       "422            4807601249.0                      NaN  \n",
       "423            4807601249.0                      NaN  \n",
       "...                     ...                      ...  \n",
       "4492                    NaN                      NaN  \n",
       "4529           4807601249.0  cory.calhoun@lennar.com  \n",
       "4554                    NaN                      NaN  \n",
       "4555                    NaN                      NaN  \n",
       "4556                    NaN                      NaN  \n",
       "\n",
       "[248 rows x 19 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "newHousing.loc[newHousing['OWNER NAME']=='LENNAR ARIZONA INC']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Save to csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "newHousing.to_csv('data/MaricopaCountyNewHousePermits.csv', index=False)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "base",
   "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.11.4"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}