clean_data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "df1 = pd.read_csv(\"./records.csv\")\n",
    "df2 = pd.read_csv(\"./records-2.csv\")\n",
    "df3 = pd.read_csv(\"./records-3.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "merged_1 = pd.merge(df1, df2, how='outer')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.merge(merged_1, df3, how = \"outer\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(5817, 5)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "Splitting 'location' column into two different columns :\n",
      "                               0          1\n",
      "0            Remote in Columbus   OH 43215\n",
      "1     Hybrid remote in Columbus   OH 43211\n",
      "2                           NaN        NaN\n",
      "3                           NaN        NaN\n",
      "4                           NaN        NaN\n",
      "...                         ...        ...\n",
      "5812                        NaN        NaN\n",
      "5813            Prescott Valley         AZ\n",
      "5814                     Tucson         AZ\n",
      "5815                     Tucson         AZ\n",
      "5816                        NaN        NaN\n",
      "\n",
      "[5817 rows x 2 columns]\n"
     ]
    }
   ],
   "source": [
    "print(\"\\nSplitting 'location' column into two different columns :\\n\", \n",
    "                                  df[\"Company Location\"].str.split(\",\",expand=True))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "df[['city','state']]=df[\"Company Location\"].str.split(\",\",expand=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>Job title</th>\n",
       "      <th>Salary</th>\n",
       "      <th>Date</th>\n",
       "      <th>Company Location</th>\n",
       "      <th>Company Name</th>\n",
       "      <th>city</th>\n",
       "      <th>state</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>HYBRID - Electronic and Digital Design Special...</td>\n",
       "      <td>$27.03 an hour</td>\n",
       "      <td>19 days ago</td>\n",
       "      <td>Remote in Columbus, OH 43215</td>\n",
       "      <td>State of Ohio Jobs</td>\n",
       "      <td>Remote in Columbus</td>\n",
       "      <td>OH 43215</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>Layout Design Artist</td>\n",
       "      <td>$20.76 an hour</td>\n",
       "      <td>1 day ago</td>\n",
       "      <td>Hybrid remote in Columbus, OH 43211</td>\n",
       "      <td>State of Ohio Jobs</td>\n",
       "      <td>Hybrid remote in Columbus</td>\n",
       "      <td>OH 43211</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>Design Researcher</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8 days ago</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Central Mutual Insurance Company</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>Public Information Officer</td>\n",
       "      <td>$24.53 an hour</td>\n",
       "      <td>30 days ago</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin County Child Support Enforcement Agency</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>Public Information Officer</td>\n",
       "      <td>$24.53 an hour</td>\n",
       "      <td>30 days ago</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin County Child Support Enforcement Agency</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5812</td>\n",
       "      <td>Extension Educator, 4-H Youth Development</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1 day ago</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Oklahoma State University</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5813</td>\n",
       "      <td>Facilities Management &amp; Services Worker II (Pr...</td>\n",
       "      <td>$20 an hour</td>\n",
       "      <td>30+ days ago</td>\n",
       "      <td>Prescott Valley, AZ</td>\n",
       "      <td>University of Arizona</td>\n",
       "      <td>Prescott Valley</td>\n",
       "      <td>AZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5814</td>\n",
       "      <td>Director, Cooperative Extension</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30+ days ago</td>\n",
       "      <td>Tucson, AZ</td>\n",
       "      <td>University of Arizona</td>\n",
       "      <td>Tucson</td>\n",
       "      <td>AZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5815</td>\n",
       "      <td>Associate Director, Programs, Family and Consu...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30+ days ago</td>\n",
       "      <td>Tucson, AZ</td>\n",
       "      <td>University of Arizona</td>\n",
       "      <td>Tucson</td>\n",
       "      <td>AZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5816</td>\n",
       "      <td>County Agent III (Assistant Professor) Commerc...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21 days ago</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rutgers University</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5817 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              Job title          Salary  \\\n",
       "0     HYBRID - Electronic and Digital Design Special...  $27.03 an hour   \n",
       "1                                  Layout Design Artist  $20.76 an hour   \n",
       "2                                     Design Researcher             NaN   \n",
       "3                            Public Information Officer  $24.53 an hour   \n",
       "4                            Public Information Officer  $24.53 an hour   \n",
       "...                                                 ...             ...   \n",
       "5812          Extension Educator, 4-H Youth Development             NaN   \n",
       "5813  Facilities Management & Services Worker II (Pr...     $20 an hour   \n",
       "5814                    Director, Cooperative Extension             NaN   \n",
       "5815  Associate Director, Programs, Family and Consu...             NaN   \n",
       "5816  County Agent III (Assistant Professor) Commerc...             NaN   \n",
       "\n",
       "              Date                     Company Location  \\\n",
       "0      19 days ago         Remote in Columbus, OH 43215   \n",
       "1        1 day ago  Hybrid remote in Columbus, OH 43211   \n",
       "2       8 days ago                                  NaN   \n",
       "3      30 days ago                                  NaN   \n",
       "4      30 days ago                                  NaN   \n",
       "...            ...                                  ...   \n",
       "5812     1 day ago                                  NaN   \n",
       "5813  30+ days ago                  Prescott Valley, AZ   \n",
       "5814  30+ days ago                           Tucson, AZ   \n",
       "5815  30+ days ago                           Tucson, AZ   \n",
       "5816   21 days ago                                  NaN   \n",
       "\n",
       "                                          Company Name  \\\n",
       "0                                   State of Ohio Jobs   \n",
       "1                                   State of Ohio Jobs   \n",
       "2                     Central Mutual Insurance Company   \n",
       "3     Franklin County Child Support Enforcement Agency   \n",
       "4     Franklin County Child Support Enforcement Agency   \n",
       "...                                                ...   \n",
       "5812                         Oklahoma State University   \n",
       "5813                             University of Arizona   \n",
       "5814                             University of Arizona   \n",
       "5815                             University of Arizona   \n",
       "5816                                Rutgers University   \n",
       "\n",
       "                           city      state  \n",
       "0            Remote in Columbus   OH 43215  \n",
       "1     Hybrid remote in Columbus   OH 43211  \n",
       "2                           NaN        NaN  \n",
       "3                           NaN        NaN  \n",
       "4                           NaN        NaN  \n",
       "...                         ...        ...  \n",
       "5812                        NaN        NaN  \n",
       "5813            Prescott Valley         AZ  \n",
       "5814                     Tucson         AZ  \n",
       "5815                     Tucson         AZ  \n",
       "5816                        NaN        NaN  \n",
       "\n",
       "[5817 rows x 7 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "state\n",
       " AL          356\n",
       " AL 35005      2\n",
       " AL 35020      5\n",
       " AL 35022     19\n",
       " AL 35023      1\n",
       "            ... \n",
       " UT            2\n",
       " VA            1\n",
       " WA            5\n",
       " WA 98225      4\n",
       " WI            1\n",
       "Name: city, Length: 200, dtype: int64"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "state_groups =df.groupby(\"state\")\n",
    "state_groups[\"city\"].count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "import matplotlib.pyplot as plt\n",
    "#plt.bar(state_groups.index, job_cnt, color='r', alpha=0.5, align=\"center\")\n",
    "job_count=state_groups.count()\n",
    "job_cnt=job_count['city']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZgAAAE6CAYAAAAr70SwAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/Il7ecAAAACXBIWXMAAAsTAAALEwEAmpwYAABlGklEQVR4nO2dd7idRbX/Pys9IY0SeiChFwWkioIiCggoqD9F0KvcK4pevSrq9doVr+1aEAuKoCgoWABpAoJIB2kBQiBAIIFU0utJcpKcMr8/vmucN5uTk52yc86J6/M8+9l7zzvv9FlrZs2881pKiSAIgiDY2PTq6gQEQRAEmyehYIIgCIKGEAomCIIgaAihYIIgCIKGEAomCIIgaAihYIIgCIKGEAom2GDMLJnZHl2djg3BzCab2Zu6Oh1BsDkRCiZYI2Z2l5l9sKvTsaGY2blmdvkmjO+LZvaimS01s+lm9qfKtXUq0/VNu5ldZGZn++8dzOwSM5tpZk1m9qyZfd3MtljXcNcxDZu03IPuRyiYINiImNmZwPuAN6WUBgOHArd3QVJOBG42s62AB4CBwJEppSHAccBwYPcuSNc/MREyaHMmpRSf+HT4Ae4CPui/PwRMBBYANwA7Vvwl4BPAC8A84PtArzWE2Rv4IjAJaAIeBUb6tdcAjwCL/fs1lfsmI6Gd/58LXO6/R3kazgSmehq+5NfeDKwCWoClwBNrSNdk4AvA08BC4DfAAL/2FPDWit++HserOgjnAuBHa4jjW0AbsMLTcoG7/xiYBizx8ji6s7QDw4BLgJnADOCbQO9KPAcA4/z3N4En11Qfm7rcUZv6FnA/0Ax8Fni0Jj2fBq7v6vYfnw3/dHkC4tN9Py4MPggc68LjYKA/8FPgnoq/BNwJbAXsAjyHK6YOwvysC7y9AQMOBLb2exei0X8f4Az/v7XfV4+g+yUaqR8IrAT2rfXbSV4nI0Uy0tNyP/BNv/Y/wJ8qfk8FnlxDOP+GlPBn0eyld0dl2sE9W3u+PwPMoii3l6UduBa4CNgC2BZ4GPhw5frnge/47weBr3eS701a7p7/qcD+Hl9/L699K34eB/5fV7f/+Gz4J6anQT28F/h1SumxlNJKNNI/0sxGVfx8N6W0IKU0FfgRElQd8UHgyymlCUk8kVKaD5wMPJ9S+l1KqTWl9AfgWeCt65DOr6eUmlNKTwBPIIG3LlyQUpqWUlqARtk5D5cDJ5nZUP//PuB3HQWQUroc+DhwAnA3MMfMPtdZpCmly1NK8z3f5yGhu3dHfs1sO+Ak4JyU0rKU0hzgfOD0ireTgZv999ZoprMmuqLcL00pjff4VgJ/QkoWM9sfKa4b1yH+oJsSCiaohx2BKflPSmkpMB/YqeJnWuX3FL+nI0Yi81incVTC2akDv2tiVuX3cmDwOtwLa8hDSuklNKP5f2Y2HK1vXLGmQFJKV6SU3oTWOT4CfMPMTliTfzP7bzN7xswWm9kiZALbZg3ed0Umuplmtsj9X4RmMnj69gH+4f7nAzusMcddU+7Tav5fBrzHzAwp7ytd8QQ9nFAwQT28hAQbAL77aGtk/8+MrPzexe/piGl0vLi8WhyVcHIcy4BBlWvbrzXVhXqPDO8sD5ehUfa7gAdSStW8dxxpSi0ppauAccArOkqLmR2NTHCnAVumlIajtRBbQ9qnITPUNiml4f4ZmlLa36+fANyRUmrz/38H3t7JYnpXlPtq7imlB9F6zdHAe1jD7DDoeYSCCerhD8B/mNlBZtYf+DbwUEppcsXPZ81sSzMbCXwSmT064ldoRL+n7yI6wMy2RiadvczsPWbWx8zeDexHMZWMBU43s75mdijwznVI/2xgVB07lj5mZjv7zqsv1eThOrQG9Ungt2sKwMz+3cxONrMhZtbLzE5E6w0PVdKyW+WWIUArMBfoY2ZfBYZWrq+W9pTSTOBvwHlmNtTj2N3MXu/+TwJuqtz/Qw/vMjPb1dO4k5n90MwOoHuUO6hMLwBaUkr3rUMcQTcmFEywNlJK6e/AV4A/I3v+7qxu8we4Hu2AGosE3CVrCO+HwJVISC5xfwN9HeYtaJF7PhrVvyWlNM/v+4rHuxD4OvD7dcjDVf4938we68Tf7z1dLyAz3jfzhZRSM8r/aOCaTsJYgnbJTQUWAd8D/rMiNH8MvNPMFprZT4BbgVvQxogpaIdZ1YTUUdrfD/Sj7Hi7GtjBTUwneHg53QvQLrEW4CEza0LbphcDE7tJuYNmLa9A613BZoKlFC8cCzrGhcL/ppSu6+q0dAd8drFXSunfujotHWFmh6ONCod3dVrWFTMbCMwBDk4pPd/V6Qk2Dn26OgFB98R38+yLtoz+y+Nms7PQInR35mtdnYD15D+BR0K5bF6Egglehpl9Fy1ofy6lVLvD6F8OM/sQ2nr9u5TSPV2cnDWSUnq4q9OwPpjZZLSp4W1dm5JgYxMmsiAIgqAhxCJ/EARB0BBCwQRBEAQNoUevwWyzzTZp1KhRXZ2MIAiCHsWjjz46L6U0otHx9GgFM2rUKMaMGdPVyQiCIOhRmNkm2bwTJrIgCIKgIYSCCYIgCBpCKJggCIKgIYSCCYIgCBpCKJggCIKgIYSCCYIgCBpCKJggCIKgIYSCCYIgCBpCKJggCIKgIYSCCYIgCBpCKJggCIKgIYSCCYIgCBpCKJggCIKgIYSCCYIgCBpCwxWMmfU2s8fN7Eb/P9rMHjKziWb2JzPr5+79/f9Evz6q0WkLgiAIGsemmMF8Enim8v+7wPkppT2AhcBZ7n4WsNDdz3d/QRAEQQ+loQrGzHYGTgZ+5f8NOBa42r1cBrzNf5/q//Hrb3T/QRAEQQ+k0TOYHwH/A7T7/62BRSmlVv8/HdjJf+8ETAPw64vdfxAEQdADaZiCMbO3AHNSSo9u5HDPNrMxZjZm7ty5GzPoIAiCYCPSyBnMa4FTzGwy8EdkGvsxMNzM+rifnYEZ/nsGMBLArw8D5tcGmlK6OKV0aErp0BEjRjQw+UEQBMGG0DAFk1L6Qkpp55TSKOB04I6U0nuBO4F3urczgev99w3+H79+R0opNSp9QRAEQWPpiudgPgd82swmojWWS9z9EmBrd/808PkuSFsQBEGwkeizdi8bTkrpLuAu//0CcHgHflYA79oU6QmCIAgaTzzJH/xLcu65XZ2CINj8CQUTBEEQNIRQMEEQBEFDCAUTBEEQNIRQMEEQBEFDCAUTBEEQNIRQMEHQjYjdbcHmRCiYIAiCoCGEggmCIAgaQiiYIAiCoCGEggmCIAgaQiiYIAiCoCGEggmCIAgaQiiYIAiCoCGEggmCIAgaQiiYIAiCoCE0TMGY2QAze9jMnjCz8Wb2dXe/1MxeNLOx/jnI3c3MfmJmE81snJkdXE888eRzEARB96SRb7RcCRybUlpqZn2B+8zsr37tsymlq2v8nwjs6Z8jgAv9OwiCIOiBNGwGk8RS/9vXP6mTW04Ffuv3PQgMN7MdGpW+IAiCoLE0dA3GzHqb2VhgDnBbSukhv/QtN4Odb2b93W0nYFrl9unuVhvm2WY2xszGzJ07t5HJD4IgCDaAhiqYlFJbSukgYGfgcDN7BfAFYB/gMGAr4HPrGObFKaVDU0qHjhgxYmMnOQiCINhIbJJdZCmlRcCdwJtTSjPdDLYS+A1wuHubAYys3LazuwVBEAQ9kEbuIhthZsP990DgOODZvK5iZga8DXjKb7kBeL/vJns1sDilNLNR6QuCIAgaSyN3ke0AXGZmvZEiuzKldKOZ3WFmIwADxgIfcf83AycBE4HlwH80MG1BEARBg2mYgkkpjQNe1YH7sWvwn4CPNSo9QRAEwaYlnuQPgiAIGkIomCAIgqAhhIIJgiAIGkIomCAIgqAhhIIJgiAIGkIomCAIgqAhhIIJgiAIGkIomCAIgqAhhIIJgiAIGkIomCAIgqAhhIIJgiAIGkIomCAIgqAhhIIJgiAIGkIomCAIgqAhhIIJgiAIGkIj32g5wMweNrMnzGy8mX3d3Ueb2UNmNtHM/mRm/dy9v/+f6NdHNSptQRAEQeNp5AxmJXBsSulA4CDgzf4q5O8C56eU9gAWAme5/7OAhe5+vvsLgiAIeigNUzBJLPW/ff2TgGOBq939MuBt/vtU/49ff6OZWaPSFwRBEDSWhq7BmFlvMxsLzAFuAyYBi1JKre5lOrCT/94JmAbg1xcDWzcyfUEQBEHjaKiCSSm1pZQOAnYGDgf22dAwzexsMxtjZmPmzp27ocEFQRAEDWKT7CJLKS0C7gSOBIabWR+/tDMww3/PAEYC+PVhwPwOwro4pXRoSunQESNGNDrpQRAEwXrSyF1kI8xsuP8eCBwHPIMUzTvd25nA9f77Bv+PX78jpZQalb4gCIKgsaxVwZjZu8xsiP/+spldY2YH1xH2DsCdZjYOeAS4LaV0I/A54NNmNhGtsVzi/i8Btnb3TwOfX/fsBEEQBN2FPmv3wldSSleZ2VHAm4DvAxcCR3R2U0ppHPCqDtxfQOsxte4rgHfVk+ggCIKg+1OPiazNv08GLk4p3QT0a1ySgiAIgs2BehTMDDO7CHg3cLOZ9a/zviAIgg3i3HP1CXom9SiK04BbgRN8N9hWwGcbmaggCIKg57NWBZNSWg5MBk40s48DO6SU/tbohAVBEAQ9m3p2kX0VHeGyNbAN8Bsz+3KjExYEQRD0bOrZRfZe4EDf5YWZ/R8wFvhmA9MVBEEQ9HDqWYN5CRhQ+d+f8vR9EARBEHTIGmcwZvZTdPrxYmC8md3m/48DHt40yQuCIAh6Kp2ZyMb496PAtRX3uxqWmiAIgmCzYY0KJqWU382Cv3VyL/87IaXU0uiEBUEQBD2btS7ym9kxaBfZZMCAkWZ2ZkrpnoamLAiCIOjR1LOL7Dzg+JTSBAAz2wv4A3BIIxMWBEEQ9Gzq2UXWNysXgJTSc+j1x0EQdEIccRL8q1PPDGaMmf0KuNz/v5eyASAIgiAIOqQeBfOfwMeAT/j/e4GfNyxFQRAEwWbBWhVMSmkl8EP/BEEQBEFdrHENxsyeNLNxa/g8YmZ/NLMDO7l/pJndaWZPm9l4M/uku59rZjPMbKx/Tqrc8wUzm2hmE8zshI2b1SAIgmBT0tkM5i1rue8VwKV08NZKpxX4TErpMX/l8qN+GgDA+SmlH1Q9m9l+wOnA/sCOwN/NbK+UUhtBEARBj6OzBy2nrOXeSWZ2cCf3zwRm+u8mM3sG2KmT8E4F/ugmuRfNbCJ6tfIDa0lHEARB0A3ZoDdTppS+Vo8/MxuFZjoPudN/uant12a2pbvtBEyr3DadzhVSEARB0I1p+KuPzWww8GfgnJTSEuBCYHfgIDTDOW8dwzvbzMaY2Zi5c+du7OQGQRAEG4nOFvlv9+/vrm/gZtYXKZcrUkrXAKSUZqeU2lJK7cAvkRkM9AqAkZXbd6aD1wKklC5OKR2aUjp0xIgR65u0IAiCoMF0NoPZwcxeA5xiZq8ys4Orn7UFbGYGXAI8k1L6YcV9h4q3twNP+e8bgNPNrL+ZjQb2JF4LEARB0GPpbBfZV4GvoJlE7TMwCTh2LWG/Fngf8KSZjXW3LwJnmNlBHsZk4MMAKaXxZnYl8DTagfax2EEWBEHQc+lsF9nVwNVm9pWU0jfWNeCU0n3o9OVabu7knm8B31rXuIIgCILuRz1P8n/DzE4BXudOd6WUbmxssoIgCIKezlp3kZnZd4BPItPV08AnzezbjU5YEARB0LOp57DLk4GDfNcXZnYZ8DhaTwmCIAiCDqn3OZjhld/DGpCOIAiCYDOjnhnMd4DHzexOtGj/OuDzDU1VEARB0OOpZ5H/D2Z2F3CYO30upTSroakKgiAIejz1zGDywZU3NDgtQRAEwWZEw88iC4IgCP41CQUTBME/Offcrk5BsDnRqYIxs95m9uymSkwQBEGw+dCpgvGzwCaY2S6bKD1BEATBZkI9i/xbAuPN7GFgWXZMKZ3SsFQFQRAEPZ56FMxXGp6KIAiCYLOjnudg7jazXYE9U0p/N7NBQO/GJy0IgiDoydRz2OWHgKuBi9xpJ+C6BqYpCIIg2AyoZ5vyx9DLw5YApJSeB7ZtZKKCIAiCnk89CmZlSmlV/mNmfdDbKDvFzEaa2Z1m9rSZjTezT7r7VmZ2m5k9799buruZ2U/MbKKZjavntcxBEARB96UeBXO3mX0RGGhmxwFXAX+p475W4DMppf2AVwMfM7P90EGZt6eU9gRupxyceSKwp3/OBi5cp5wEQRAE3Yp6FMzngbnAk8CH0SuPv7y2m1JKM1NKj/nvJuAZtH5zKnCZe7sMeJv/PhX4bRIPAsPNbIf6sxIEQRB0J+rZRdbuLxl7CJnGJqSU1moiq2Jmo4BXeRjb+eGZALOA7fz3TsC0ym3T3W0mQRAEQY+jnl1kJwOTgJ8AFwATzezEeiMws8HAn4FzUkpLqtdcUa2rsjrbzMaY2Zi5c+euy61BEATBJqQeE9l5wBtSSseklF4PvAE4v57AzawvUi5XpJSucefZ2fTl33PcfQYwsnL7zu62Gimli1NKh6aUDh0xYkQ9yQiCIAi6gHoUTFNKaWLl/wtA09puMjMDLgGeSSn9sHLpBuBM/30mcH3F/f2+m+zVwOKKKS0IgiDoYaxxDcbM3uE/x5jZzcCVyJz1LuCROsJ+LfA+4EkzG+tuXwT+D7jSzM4CpgCn+bWbgZOAicBy4D/WKSdBEARBt6KzRf63Vn7PBl7vv+cCA9cWcErpPsDWcPmNHfhP6KHOIAiCYDNgjQompRQziCAIgmC9Wes2ZTMbDXwcGFX1H8f1B0EQBJ1Rz3H916HF+r8A7Q1NTRAEQbDZUI+CWZFS+knDUxIEQRBsVtSjYH5sZl8D/gaszI75GJggCIIg6Ih6FMwr0XbjYykmsuT/gyAIgqBD6lEw7wJ2qx7ZHwRBEARro54n+Z8Chjc4HUEQBMFmRj0zmOHAs2b2CKuvwcQ25SAIgmCN1KNgvtbwVARBEASbHfW8D+buTZGQIAiCYPOinif5myjvbOkH9AWWpZSGNjJhQRAEQc+mnhnMkPzbj+A/FXh1IxMVBEEQ9Hzq2UX2T5K4DjihMckJgiAINhfqMZG9o/K3F3AosKJhKQqCIAg2C+rZRVZ9L0wrMBmZyYIgCIJgjdSzBrNe74Uxs18DbwHmpJRe4W7nAh9CLy0D+GJK6Wa/9gXgLKAN+ERK6db1iTcIgiDoHnT2yuSvdnJfSil9Yy1hXwpcAPy2xv38lNIPauLaDzgd2B/YEfi7me2VUmpbSxxBEARBN6WzRf5lHXxAs4zPrS3glNI9wII603Eq8MeU0sqU0ovARODwOu8NgiAIuiFrVDAppfPyB7gYGAj8B/BHYLcNiPO/zGycmf3azLZ0t52AaRU/093tZZjZ2WY2xszGzJ07tyMvQRAEQTeg023KZraVmX0TGIfMaQenlD6XUpqznvFdCOwOHATMBM5b1wBSShenlA5NKR06YsSI9UxGEARB0Gg6W4P5PvAONHt5ZUpp6YZGllKaXQn/l8CN/ncGMLLidWd3C4IgCHoonc1gPoMW3L8MvGRmS/zTZGZL1icyM9uh8vft6FUAADcAp5tZfzMbDewJPLw+cQRBEATdgzXOYFJK6/SUfy1m9gfgGGAbM5uOTmU+xswOQmebTQY+7HGNN7MrgafRszYfix1kQRAEPZt6HrRcL1JKZ3TgfEkn/r8FfKtR6QmCIAg2LRs0SwmCIAiCNREKJgiCIGgIoWCCIAiChhAKJgiCIGgIoWCCIAiChhAKJgiCADj33K5OweZHKJggCIKgIYSCCYIgCBpCKJggCIKgIYSCCYIgCBpCKJggCIKgIYSCCYIgCBpCKJggCIKgIYSCCYIgCBpCKJggCIKgITRMwZjZr81sjpk9VXHbysxuM7Pn/XtLdzcz+4mZTTSzcWZ2cKPSFQRBEGwaGjmDuRR4c43b54HbU0p7Arf7f4AT0WuS9wTOBi5sYLqCIAiCTUDDFExK6R5gQY3zqcBl/vsy4G0V998m8SAw3Mx2aFTagiAIgsazqddgtkspzfTfs4Dt/PdOwLSKv+nuFgRBEPRQumyRP6WUgLSu95nZ2WY2xszGzJ07twEpC4IgCDYGm1rBzM6mL/+e4+4zgJEVfzu728tIKV2cUjo0pXToiBEjGprYIAiCYP3Z1ArmBuBM/30mcH3F/f2+m+zVwOKKKS0IgiDogTRym/IfgAeAvc1supmdBfwfcJyZPQ+8yf8D3Ay8AEwEfgl8tFHpCoJa4kVTQdAY+jQq4JTSGWu49MYO/CbgY41KSxAEQbDpiSf5gyAIgoYQCiYIgiBoCKFggiAIgoYQCiYINkPOPTc2LwRdTyiYIKgQgjkINh6hYIIgCIKGEAomCDYzYga2dqKMNg0New4mCLo7IWSCoLHEDCYIgmA9iAHK2gkFEwRBEDSEUDBBEARBQwgFEwRBEDSEUDBBEARBQwgFEwRBEDSEUDBBEARBQwgFEwT/IsQxOMGmpksetDSzyUAT0Aa0ppQONbOtgD8Bo4DJwGkppYVdkb4gCIJgw+nKGcwbUkoHpZQO9f+fB25PKe0J3O7/gyAIgh5KdzKRnQpc5r8vA97WdUkJgiAINpSuUjAJ+JuZPWpmZ7vbdimlmf57FrBd1yQtCIIg2Bh01WGXR6WUZpjZtsBtZvZs9WJKKZlZ6uhGV0hnA+yyyy6NT2kQBEGwXnTJDCalNMO/5wDXAocDs81sBwD/nrOGey9OKR2aUjp0xIgRmyrJQRAEwTqyyRWMmW1hZkPyb+B44CngBuBM93YmcP2mTlsQBEGw8egKE9l2wLVmluP/fUrpFjN7BLjSzM4CpgCndUHagiAIgo3EJlcwKaUXgAM7cJ8PvHFTpycIgiBoDN1pm3IQBEGwGREKJgiCIGgIoWA2IXEOVBAE/0qEggmCBhIHTAb/yoSC6YGE0AqCoCcQCmYzIZTOpiPKOQjqIxRMEARB0BBCwQRBEAQNIRTMRiBMJpsv3b1uu3v6GkGYg3sOoWA2ItHog2DzIJTYxmGzVDBd2TA2ZcOMDhAEG05tn41+tfHYLBVMTyBGSEHQc4i+un6EgqmDDW1cG1OZREMP/pWJ9t+zCAWzGbC2Thedsj6inOpnUw+6om56JqFgGkR0iH8tor6D4OWEgqmTrlgzWZ/48j0h8DY9/wrrapt7/rozPbHsu52CMbM3m9kEM5toZp/fWOH2xMoJAuiagU1VWXb3vtNIE3F3z3t3p1spGDPrDfwMOBHYDzjDzPar9/6e2Bg6SnO9bo1iU3bInlhna6NRedqQGe2G+vtXmJ3VS08qh9rBwqamWykY4HBgYkrphZTSKuCPwKlru2l9FwzXJsg3Rqdb13TV+t+QxlHP/v6NubutNq56G/e6+FmX8t7YnWpN+Vvfe9fmvzN/3XFU3llaG1Ev3VHQ19vuOyqPtbl1dO/awu5qLKXU1Wn4J2b2TuDNKaUP+v/3AUeklP6r4uds4Gz/uzcwH5gHbFP5Jtzqduvq+MMt3MJt07vtmlIaQaNJKXWbD/BO4FeV/+8DLljLPWNqv8Otfreujj/cwi3cNr3bpvp0NxPZDGBk5f/O7hYEQRD0MLqbgnkE2NPMRptZP+B04IYuTlMQBEGwHvTp6gRUSSm1mtl/AbcCvYFfp5TGr+W2i9fwHW71u3V1/OEWbuG2ad02Cd1qkT8IgiDYfOhuJrIgCIJgMyEUzGaOmfXv6jSsK2bWJaZbM6urP3Tkz8ysnntq/flaY0f+raPf9cRpTmfpWdP92c3M+tSRp7XGUUcaBtcb7vrEV085bmgcmzK8dYx7WFenJRSMU+lYtQKgwwbakcDorDF7n9/RzAasLV4z62VmW3on393Mtl5DmFt2JozN7ATgE5X4O03fGsIY1IFb7w7c1th4zaz3moSZXzvczAb4/9cBnzezLdxP/l5T+kabWd+O0lKT377+nettv4rbvmY2LKXUbmYD3e2VZvbKmnD3NbOh7m+AmfU1syFm1i+5rbkmzgFefwOBLbI/Mxvkn9cD7zezgZW0DDWzI4BDzGxbMxuQ1mDHrsQ5vObSUOCfgruDtrV7vr+DNrGl18EXgNzuelX9mJ+u4fePyHXk13erKbNeXgbb53Sa2fFm9hkzOxE4x8NcLV3VOvPf+wBn1vafOujn9w8D+nWQl2E1eexfuZ7bSq9afzXXqr//qaBr4q+Wc3Z7RcWtd006qMT5iuzXapSGu+3onxPM7Ch3Ox74srfPE7yt7WdmO9bcO6SOMlxvNos1GDPrlVJqX8d73gC8HrgNWIA6ZCtwJGoUjwL/AF6Djq5ZCrQDw4DLgKPRJonFwAD3CzDEw9nS3d8ILAEeBs5DHfcA4AXgWWBfT8NBwBHAWOAjwErgz8DXgE8C09AW7nZgOOr8xwG/83zMAx5CgwYD/h04GVgGfAyY5GluA6b7vX/074eAB4CFwOCUUpOX0UnAwZ72VcAOnv8BXj7bAHsAzwOPo23lCTgU2BZ4Edjfr41BD8au8Hy84OX3QeDN6Iigx4ELgNnAvcBOns+pwP8B4ypC8ShgNPCfwBy/d5WX//0ppRu9k78SOAwdPbQzMAHYy8t6AjAR+H/AzV7eZ/rvnwC3AL/yut0FuN3z/bzXwStQ/a8AvoWE08GenvmetjcCd3t99gVuAt7m+drLy+A+YBBwvaflAGCy+5kGfCOldK2ZWUX4vgF4l4e7Z0rpLe5+MvAVr5tlnpcLgJdQO3kN8BngOi/7ER5fu6f/fz1f87zelwNNwDdTSi+Z2WGovfwWteVfAvd7mawAvg/8h9fFFsBbUDt8wPN/M2rTfYBmxDuAfYBvAD8EdgP+CnzZ62OJp/Uw1C7uBF7rcYxH/W0gai9zgXkppWnefs8Cfg/8GngQ+DQwC3g1ahufQQ9uG+qzp3v6BrjbUOBNwHuAM1A/2hb1hZVeNsuBRajtt3u4O3sdfhh4N2qrgzxvR3g53Q58F7X3PTz+uUguDPc0fxw4ze/5CPBR4JSU0goz2x94O/BWv3crL6flwM+RnHoIuAo97rEY7cr9CHCJl8PnPF+PppTaqMHM3ggMSin9pfZaXWzKh2425gd1lu9X/vdah3tPQA1lNhIey5CgWYUUyXL/PhuY4tfvRJ1unv9vQkKkxb9fQkLzAdRxbqyEd51X9EQPe7F/VvpnnKdnjoc/Gfgf1MHHeTgzgXs87vs9jp94+hb6vU3uvxUpkkdQ50zutsLjmw581e+dgYT/q1FHfwwd2XMsEuxfBp5ASnCpfx7xsvuZp2OV5302EqDzUUe71dN7BRJAi1DnWejXF/n3NNSxnkQdfomX1xLPR+7AX0ZC5E2etp94nuZ4Hpf4/3b00O5b3K0J+JGn9SEPaznwFKr/5zwv472cF7ufnKYPI+Fwr+e1FQnKGcDTnr8ZXndNfs9LSJHM8HuuBH7j9ybP1zT/bkWDnBWU9tXsaX7Q03dgpf2+2cvxVx5fCxIon/Syn+rxJf9MAP7m5f5RpNDa3d9j/jt5fscjgdTiZTPP/d+BhOw9fl8Tagc/8rKc6W5jkIJqcfepqC3t5WX8ZyTk25GAm+75m+11s8LLfy7w+dy3kcDPA4EpqB3fjtr7OM/3MjQA+LuX9bOonT+N2u29aNBzsdfJIkp7vKlSBld6+Y9xtzleR8uQ4muh9KVVqH+0eF3f4u7f9Lw9AXzP6+CvXt/PeH2t9HiSh53bxWMUuTPR3W7y+59Cg9I3e14WehmP8Xy+08t2mZfnVC/bZUjhPOnlnpDMWQpchAaFvWvk5PFowHvU+srpHjuDMbPtUUVdmFL6orv1QjPsNWbKzF6DlMWtSAn8N+rEp6CGPBWNMmahTr8DEq5ZYAxDI7Gn0UhlGGpIO6GOuAtqIDsjof0AGp3dgDrZnsA5aJS5A0UZLAR2RxU6EM2ofo1GwVtTRkhXoQ67HDWkFUh4vwt1+H2B7VHHGeF5GoQa6ig0qnwajVa3RI321agjjPJwp6PGP8Hz/BXUSfYBvo0UUauX0bFo9nCo5/V6pCT6ohHV02jEt8rz/WGPZ5Sn4Skv74FIuM1FguNjSHDs6nG9giIUZ1Bmcd9Do0E8D9/3cpvtce8NXItG0XPQTHEF6lxD0YxnGPBTNEo8BnXGaUgg9UEz2JOBy5Ggm4VmKn/3MI70vMxDbWonNIO4BZ1GscDrYbTH1+SfXl5H070uhnr5N6M20dvTfrzn+UJP0+f9nn8D/uT1d7yX8QI0Kt3WP5/2eF5AwuXnaER9iJfFQuAXwPtRmz0P1ft3PP7bkGAHtYl/B/4LzSCzQFxGGe23ojZ6HLIELEIDlq09rH5+zx1epkNRvY5Fbb7Ny2IgUnDvR216NhpUXujlfA9lBn+M3zvZ878/miU/7vHe5/G+DfWnLYHzPf0r/b4/I3Pyr9Es5n40c2hBs6r3ed56ed31Q/V8Hep7vdBgZgia3R2CZME9qI/cgc5VbPby6uf1NdTLeZHXxTaov7ajQcH2qL3thvoAnp+RaGZ6iMe9B6VP9KfMwJo8PPP8jkF9c0/38wxqU6NR3zQvw6O8bI9OKU0wmcp7Z+tGvfRIBZNNBWa2HRKqf0gpfc6v9U4ptbn9fGpKaXHNvfugDrCKMlp/CQmiPqiAt0aV1owazGLg62g62wdV1HwkhLJJZHskHCajKfkbkHmkycMfgSp0IBplHeBh9PH7d0SdZLrHPdz9NqPGtgp1hv9FQmMPv387v39L1EAHIYG5wuMdiTpGb/+/q4c5EHXmOZ62FZ6fO93/sUhYvtHTuK2ncZ6HtdzTuAVSCi2V9A/x3y+hzr7I3eb790Av55We1xWe7jxz+G80Gn/c0/8Wymi8Nxp15Tj/iEwEh3m6F3qZzPB6vBCZ136DBFqeLfTyz1APp83rqq/n6XIk0LZFQuIrFEVyBVKkue1shQT4UC/bvkgojPLyGOflOdrz/Wdk4sHvNaSMjvG6M0/PZDQIeRi1ncVIAL4OjWC/458X0eDkReBVnvb/9msjUFvZG/WVx5FZpdnj7u31cYmHubOXbV/P60zU/kYiobjAyySXdT7faoLfu8yvL0NtdjhFMLegAc0RXjfZpLkY1X8eUCR3N0/fFNTu9kKCf6i7vZYy4Fvp+d4DtdPdPb1XoPbT5G6rKvG8gAT0StSmdkSDlP2RcjvK0/2Qp3kVaqtjvcwORYOMV6F2O8zz8gRwoP9/Hg0AZnqeV3i6FnvZJNSG+qK67k8ZXOBp6+fpzyasYUhRfBZZOo5391avu/5oVvga1E9z/xrkflZ5ut/q8X8P1eU7UD2/AbXdW5Fyfx4NdPqiNnlZSukh6qGrTV3raBZ7JTqkreq2PRKMVXPZR5FQGFE1oVEU6j5odNtGERSXo0bShhrvV9BIca5XygQ0Qm/zxpHNN+PRCHA26sBPoU48E40uF6AOOs8bS555jEOjh+z/aY9/mYeb/ZyCOtVSpBjHeppeQopqoTeg8UgQzURKI4exFHXsWahhvUQRqMnTc52H9TgaNZ2ABMFSNPOZ5nle6mEv89+z/NozSCHM8TjvQgJsCsV8dQdSMLM8vVP8u41iLsrmrmc87y1IQPwSKdWxHnerf1q8TGcigbrCy6MVCeKxHvaXgUsp5qllns4lXuaTUQee4eFdizpwNpcuRKO83/n3+z29j3q5TPb/2Vy1FI3y/+xujyNFk813syv5bq78bvG42/33nWimdY2n/3k0Ex7g+fuNl893Ud0vpZiZfoQE2M89X9M8/y8gATgHtYccV/Lyusnv/3ZN2r6F2sRyiklsHqUdZVNmrpt21CafrITf4p9nURv+AuqnS72cVqH28YCXQ5Pft8DT/TiahXwd9ZtsEr3M71vs98727ye8js71cprtcXzJyzSbyLOZarH7fwS1ixmUGccznr9nvC4fRTOJ8UhO5LT8DsmK3A9+gQT1Qv+fTWFNHsc097vcy7PF01U1pWYz9BIv9zzYeg7VdzbXTvD7cjte6v4e8zTn8NqRvGumDLj+gvrnc2hm2AsNRFZ5Gs9GSvmHwEV1y+yuVhrroFy2otjQf4O0+BC/tqMXwufRNHQScFDl3rd45Y5Dwvo2NGJc5BV+C+pwS73AJ1HsoPNqKru98lnljXKWV04zRaC3ecXlSmzzcO/yyp/jaXnYG8ZYJNSyEEoe/gyKDXVhpUFmIbmK0nFzB89KLNv3V1BMbHmtIiubVV4e//A8L8cXSiv3ZIE4yf3ntaiZlbDy6K6VMtrKZbHSv3PnWu5lmwVP7Sfnf6GnIa9xtHVwTxPqFJ9GnSQLvDzzy5/FnraVle/5SECsqIT3PBrdtSGBlgVsq5dXtsWPrZR/My9P+1Pufwml/Syo+MtuqypuK9AC+R2UkeYLlPXBLGAGIvPLd72Mq210uvvJs7unKYokl01LxS2nObepWagt5HrKZfldjyevMVbzXPWXw1tYKZ/sbz5FQSUPL+c739+GBPLjlbLO159DwvRaz2NeC70eKYU8a5+L2sIiv+8eykCszdN0u9/7EKX9Nle+l7rfeyt1t4iyhrnQ3RYipTPZ/d+MzLitlbLPCjkPfqp10Vb5XW0bsyt1ldtudY2xWs5NlMFSLues6DvqW0vR5oHbkOzJ8uIFytrkLhXZ+bWKLB2MZNiOm5WC8cx9B416zkfmm/8FXufXtqWMoA+o3HMIEspTvPLzesdsr6xnvRJfqFR0FgS5o1YbQDZV5fWP3AlyJ32uxm9uJNktjyqqlZ/Dz6P9drQulP21sbqga+LljXNl5XduMPnzIqVTZ8GSFygvRR2hBXXUPKJt8jS01oSZ48ozgaqAavaym1txT0hxttW4VTvTM37v3Mr1rMwXenrGVsqxDQmSfP/f0IgyK9JsKqjtvHlHVA7nXvebF1ybkODJu6EeB75IWdRt9jCyIH4OKb4sJJ/1+BZR2kg1r1k5Z4U93ctrZcXPQvezxK9X67fd4/0CEmJ5VnkTUpR5oHEfL29n+X97pQxyOTzvcWWhuNLjX+j5XcXLhWBVYNUqr+leP1VBuLTm/xRWF4JVgft8Je25HeSF6WcoSmcsZdNMroOclqsom0hynx9XCa+2Pc6pxJkX9avpyya/mZX/kyt5zuFkZVgNv5WXt4WsQDpS9NWyzuWU42zy78Vod2K+b1pNOqr5qcqZp71+nqcMXhdTNgf9GM2OrwOGdiCDT0Pta1g9Mvufe657CI+hDH4FbV/cHrjZzD6FtqGOBHZPKY2r3LMzKthzkGb/ErJFjqHsJpqERoS5grdAHWJ7VAm3U6axvfzaKrTWkis4m85G+u+VaO1iCWV0kG3Ni9w9C6s8wu6HKvlyNLN50PMwBo0qZqIR5ADUmOZRZg4LPS14OFnhLENT2wH+vw8atfT1eweiBcR5aGq83MvpJsrsaK7fl5VPM2rAecE2d7xmZJYZROlsi70OjGJyaqnUz1zUyA3NUqEI81n+P6EtrHndJS+OZzPZEcjmnTvrdWhNqpffu8TT0RvVba6zIz38D1KEQF6DWIR2E13i6e6POudAygLtMk9Hs5fPjp6PYe7HKObUZr9/GFpDMGRzH+p+sxlziNfVXPezBJldHvX0DEHtfz5qC3/z+/ahrCEeSTElJo/7z5SBU15LWYnqfTBasG5F6xxtqH4HeTwP83KhmQVnXktb5GXZ7uWwvbtnt1mV3wmtk7V5Hp7yePA6G4ba00x3m+nlPwUtTi/zey5C7XgIxcSWB1Qnex5nIuE7FK0rTKikK+8EG+d5zQOAZX5fnkVmAd3byyr37YGo3+VnXPLi/WJK28tK/CFPGx7uYI+/d+X+TF6Qn02ZKeF5nUlRqsNZfRdmb4qcGkKZgWdWoXWgbdF6YD/U1t6P+t6HUkqfRDJyEaqHkiizDyBz80dSzdr2muhRCialdBWyS78dLZK/DnW2LdCuoy1SSi/W3DYejSwno+2JF3sYr6fY3Yei0egjlJH702i0NASNxpqR4HoYNcZ+qBNdjxrleNQAbkUC6WHU4Aag6foKNKpa6G4v+b1/RjOrsR7nvR7XbGRDfgF1invdz73IhPEz1AgWu9tQz29WCgNQY8sbBUD1vRgJgPs8vW9BjfaHaM0IZDc/2fPXx9M8idLJ5qEGmW3Ai9B0OyvMn1JmfoNRg27z+O5EQmUO6qgj0OLrPM/fi14mi72uhvh930KzraxkVvnviRRT3RBkdvwLUpCLKEp0sNfZcs/DbP+dy6WX/38BdfD/9XvnoLYzFfiA56+Pfw5wPwNQnc/3cFtQG2qhLEInpFD+4v4XUYT/IvezzD+DkDC8GS2y/geygc9HbXCsx7+lp7UPmoU9CvyBsplivJdxFrQ5r0+jPvFb1Ea2QXXc38PrhwYlWQAdTplNGquPurM5NAv5rHxxPzP89z+8jPL9eTPEdsjK8CBFgWU/f0ODuGmovW6J+k0/pFA/htrqfDQiPxn1hSVeRjM8v/NQ3x7o9/3V68Y83PtQf53qv7OpdSUa0bd6Gffy7/6et2c9LQ953lcg68oyj7PZ3e71OriWYkrPfSkr1jwgyLu4FqK+kQd1iz1No1B72QqtSS93f4Pdby9PX38kE35JGRzMQ+1xgYc5EJljJ6LNApcBpJRmor7/Gk8b/oBrX+D0lNJT1EmPUTCVJ2HvRA8G/Rr4bErpfLS18v0ppQXu9zAz+7iZfRAJgcVI6B2J1mjmoRFQX7TDo5kiqFa52wpUOVPRqGk5ZWdNH1Rhr6HsHBmMGvZrPaw9KItuR6NZ0GgkxBciIb8r2oV2GBpZ7Orur0Gj6gM93FehWcbeHm4WygM9zS96Gp5j9dFUX/+dv/MMZzGaFf2IsjYy1dN4v4fxKdSxF1FGPr0ojbwJNcJBqGGf4GXTjKbueQQ8z8PLI94jPQ9NqIP1RqPn4R7eTsBJSDgO9vAWe94/4v4meR1s5enahdLBXoeUw1uRkGlGgqI3Wmtr9TLY1uvne5SHau9FM+E8wj8K1d1CVG/f8jJfhJTFVMq61SA0wr7d62R/pGzwewZ6nCe425b+nWc6udPn3VYr0Pbos9EMbTYakR6GBMvuSPAPRG18CBJg7/U6mlEJa1u0BTfPEA/wvL0DtaV5lFlnL8oOJrx8m7zcJlfKco7XwWCk6Jd6WqC0wYFeB4aez+jtcfT1+wz1rSc8XwvRQ46z0Ch6O89/P8rs80bUPgai9nY26svDkCK+FbXnIV4OQynCuI/n47tIfvRy93Mos6ihqE8+j9r/VFSv2bqQw2j18r8D9dOnPD27oBnnFIpVYRfUXo6iLOBvQZnpNCMF2FYJJ28qGO1p6Ifqf4HX1R/8dxb8oyhm4F5etrujPtPqZdoH9Z0nUP9+Dn+EIKX0+6QTKnLdP+d1mh/q7ZNSuiil9DTrQlevq6zHOoyhEcYVa7j+Fsqup1mUXUZ5RD2HsiCeR0x5RHZVxe061OCWUmzk1e88gsvhVu3U2RZau0aSp9z5nqrtvaXmu/beLKBr1z/yYmS+XrUr53BaKCa5hZV0jHc/CyhrSbksbqTYwPOaz5JK+DmuFTXfrRQ7dTsvt9+3eXzZtFcNK+cjf7KtPa895TKbjEauqSaebH7LO7nyOkf2N8PrNNfXNWitpZr+qt16JVJAj1PWfKp5WYmE6x2V/OTrSzoIr6O1jGZWt53n/PzV03sJEj7TKTOcU5AAaK+E344EUVvFLa97LKyEm9v9fFZft8vtLpuJqmuP1TrJ/qp9oJqnbJLKuyyr+Wpl9T632POYBzm5XtopC9o/pCxgz0YDoMc8jHmU/pDLNm8qqV1/q/azFrQbL1//C5qN5N1fbWhWUl3vrA2j2p5zuVTXYXL5V/3ldFbbTxtqQ7P8/rwZoJr2diS33kHZvDCbl/ed3J7aK3Hl2VILZW1yPBo8N3v+vo1Og4Cy0/YbaGv9O1D732W95HVXK4x1VC69/Ht/4Gpgvw6Uz2/RrpEzkKnlIcqC5WTKQm+tIK52gpU139UOlmcleRqcKzk3tGoF53tzo8qCMq+f5DRMqjS03ECru0Wqyq215jv/ntBB/Nk23ow6/RloKryKsmNuvse1hLJLaiIa5VQV2lyKQL2L1bej5jTXlmcu66WoA1c7ZBYA1Y642NOzyP0soOyey/m4hrL2lLem5g0beafVHNQ+WtBIMu9cysJrEmVr8Uo0or2JskmjlfLMSbWT3+NxLUXrZHmx9apKPWRhmTcNTKqUa/bTVElTOzLLfRsJj1vQbHshmpnv7ff/CpnB7kKzz6qwzuaZHEcux0eRYlpEEWATauonD1aa/J6PehkuowjSjgYu1UFUjnMWGvk3Va63svpaYzMSWLkebqS0jzxoeobV+10Lmqn8gnI0zwL/3YQUa7v/XoDq/2HK4n6qhJOFcLU/tlMEdrW+qwr0Hx5vVoTtlXCqfTH3g2p/yHmvbopJHfzOu8/yzsOVrK4gnvC47/H85QHN/azep/LvFi+PXC65zu/1eycjmfAr4B01CuZc1FYeBvZfX5ndY0xkAKmcN1a1d9cyHTW8/qiAfoWETG//fhGNElaiCl9EeZhsLir46ykNZLyHNwk13Dke90Ue/5VIIC/wuCZTtlFOc7cXPewr/PcvPfwsqPr690qP62uoIdxAWY95CQnI6zzd11FGvzciU8c9aBrcghrGXNQp8yj2vci8cIOHdT0aKV9BWTuYiabdO6Ppeu7w23h826AnirNwWup5yesD+ZmGRz2e+V42f6OYq7IpYEElH7PRbGK611tev5mPzAm9/Pc+XhbvRusThyGhtsC/jWKC6UVZvD4XPY3dgswg09Ba0GRky58L/MDL8beep3d4PpZ4vl7p4ZyLzB2XIN7h6f+dl+Vdnpab0dPWd6EHPvH0/QK1xav9vm3QFvvvo0XU76N2d4jX2ZbI3LEvEnQ7oTawAClbkAklmzCfR+11X/e7BTI3tVLOs2vz+1ooLx7cErW9vJ6SFUcvilBvoSj8vGYAmolcjNpPG6qj59HOT5BJqxW1LTxfo9G6yeNIwT/j9+zi6c8m35yOx5F5qBcSqr09HXkDy7OongYhc2veyYaHe4fnowUNPHOd5XWkSZRBTVYGTZTjYz6ONgRMQUfBjEWDgGdQu/0hmlmfj9a5FqDjjOb79WwqNopSyvlLlI0keF7uR+3sr57nfdDsbRwyFS9A65J7oefQnqJswlmJtqnntZv/Q23x7cjcezlwckrpD0jhvMvNY1knzPby/be09pc+rpEepWAyKaUpwDkppfkAZvYqMzsSNeLpyG7+E9Sxvk15Evo1qOOORCPFfkjAfBc1jDZUsAejxb4lqKH+EQms5egYlPmoUpYhATQHdfS8wHgPGpU2o0ayxO+5wN1e9OvT3W0RGr3O8vhv9mu/QQ3t50ggTkYmm8lIOI71sL7t/u/zdDyH1gsGofOjpqKH076IGt4dnva8nfUm1ECTh7UV6pD3epFnm/4wig14rpfH9X59OBIA3/Sy3I9yasAQZB+fjgRtFtYPIAH4IlIKn/P6+bXXTzNSdA8hYXQRWovaFSmW96GdbzegXYVfRXWdBwMPUzZJ3I0U/8MUm/zdFIG7A3qS/gvo9IKLkOB9lZfnYM//D9zPt9F63hWUzQoHIMF5Alq7+H9ozek0NAJfiATAsZ6G7VB9D/K8fg8dOjjV070DUjig0eto9NT2h73snvM0ZqGeF9Hzut4AygyxFdXzYi+DRZR1xepMZSjFtLIICb28w3EoEjpZAS2nnDqwl7t/1OvuQaQ4/42yFtQHCfj9UHvMFoLxlNMQVqF1lK8gxf+/nv5vonYyzsMeija6TEWK5C+ordzj9TkYKeNVXpd5l9kVno4dkKB9rZdLm9fDb71OrkH9cZn//iha5xjqZfWA53ecl8EKz/dAd8ubNu7xeC9BfScPKidRTFQLPA8D0EBipdf19qhNf5VykO02aI14KWpP2yMZ9BE0iHsB9c28OeMK1JdHIbPXbUie/HdKabwfrzUFGJBSaks6BaUv6ivHpZSeY0PoarPXBpjL8lTueIoQ+ZBX7m8oO41u8srPJoK84LWq4jYbCeus7Sf7d7ZzZ3tyQpsM2lCHz2aQKZSHo5Z6OLVuLV7ZWRBMqbi1evwra9xq42hBjbM2jKrbM0gZXOBu49AMax5qiK2UEwmy6aINKZ28/ThP0y+kmAjyJ5v2ElIYufyy2z2Vss+j4KrdOZsq5lJmBgtY3Za9yH8vRUIkj26zHbmt4q/N0z3fw7uZMgKtmjiXIYXwDYrZMpuBmrzOjkfrG1N5+ZpB1aa/CAmiZR34a/d6SZS1plaKCesByrMHCylrJ3lGexna4PEAeng0l1suw5VotvOQ122+nhePs7mxanpZRBmNz6SYd/MstNnd8nrIEoqZLNdL1Rya48k7+Z5BA43LKKdO3MPqdb4AKYa8e7Dd6yyv98xAa015o83jSNFvRXm4M/ttp5yKMZ9i/syzq+p6THZrpmzvXUXpazlf1bW+Wreqv2wGnUFZE8ztveqW6/237raokrcveZmtQgPIayhWlInufyKlPzYjK8WSSh1M9fp5rJKubNF4knJQ6Q8rabsdmV9rlxZ2B67z3+9Dg5reG0VOd7Wi2EAlcwpSAuPRzOJhdD7Pc5RjHtooAiM3lkR5QC4vLGahl6fQL1S+cwU2URZK86jwyUq4yzpxW0QRRE9W3FpqwuvI7cm1hJHd7qLYoHN6b/drj1fCzcIu24arwmMxL7cP5+88gqzap1exujBLFHNeNi3mxfccV63AfqkST7OX+VMexs/QCHQp5VmglRSlVB1EZKWzCpkaqsIid97ZaHabn3OY6mFPQ+a6bCJpRk/0500ej3k+nq8pl5Vexnk9JQu1nJ4c9/xKnp/yOLLd/xnKKx1uQKPMhEbleRReLbscV3WdJKcpD6YepZxCvbJyb/ZXvS8ryjmVOqzWU75npqcnK8YHPOx/VOq8lWKqmUvZWHMZGkRdVam3vOHgOYqSrA5GplGehp9FaS/ZfxPF5JoVa3WxfXkHblkgL6+45Y0gK+p0q26AeLEOtzbKpoGplBM+7qOcVbjc3eejfjOHIrdepAx021H7yIPc5yjP82SltMTvzVaNW7wM70a7z37QgYK5Es0YnwL23Vgyukcedpkxs5vR8ywz0KjxEMp2xuWo0IdRtl7mjtqHcpBedutP6XCtaIrb6n76oIrL9uN2ykNNibItMNt7jWKbzn561/yHsm0zx9dGMVvWxkEnYWS3FZ7OrSk25eGU9YiEtu/+Do0ME8WWvzvlCJBB/oEiKBd4/lf4vX0ozwZMR6aubE/OZTALTeFfQFuTc3ztHv5yVO6Xom2sA5CQ2QXVS19Ur9t5WKNRRzjG3fKAIAu6M5ApJ4+Yh3lafodMaYY63lD3s6+nZyDlNOStKDsPd0ICehuPB9S2oGwvneH+migPvq2kPEy5wuvo98hc1Iq2H1+GRqXvRltGj/B8vA7NJj/h6d/RyyGXe5U84r4PbXzZljIzO8bD347yEq1szoIy+Onl4feinLrbXvH3CDJpbUF5dmIOEmJ7eF77V+5ZRekzfVAdD0DKYgSqn+coB8TO9XCeRSan/ZFAPJrSjpu8bN7k6cyDBjwP1bT1ZfXZ3gDKszm5/fVGddVGefh5RR1uW/i9fWvKiA7c+lauZUXdmyIXpqA1r0R5sPs+ZD7NVoKRlOe1tqU8j3ZwxW2V5/slZPZLlHa32MP7kOfnXC/zPAMeg5R+P2QBegE97vEsG4keuQaTSSmdhAppO2RvHEBZRNuColzyKKQPpZJr3XKD7UV5Ej4L/RZKJ6qOiKoLdFXBWh31ZH+rau7JbtURo3USR2dhZLd+qCHNRh1pGOVp8sdQR/0A6uBtlJHQGDRy6oVG4xPRaHqKu92KGuczHt4cZEZ8yNOxK+WU6fycQG8kHOdSZhwrkOnkb2g32yA0OvsxMm39DAmSbJ+eixp+E1KAc5Hg+QsaaTWjet4WCcL7KO9lucfzN9Pvv9z9j6Q8IT+BciRLHiFnc8ggyrM2bZSXy2XTUd61lv0No4yk8+yhzX+/iMxD/0CCdm+0ZvEpJLzvR+s2R6B1nBbE456urPhb3X0apc30Rm0/t+teSLldixRjX4rpBq+7XhV/eVCT229WPKv8/2GUp87zJoKtvcxXoH7xgPt9mDJLzGbIPv69o5fzQ6jupnqZ7Y3MSKPRTNS8zD+JZi9NaJH7DjRifxHVaR//vQVltxWojWazabOH93TFLdfZJP9tlCPtO3Prheoeyiw679KsdcszvDyDgdJns7VkMOprCz2uG7zc51CeCXvWy+iXlHXO16BZ9AjKCQeLkXLJM7qPezxbuPudaOByOrJy5AHfO4Fjktayb0RP8m805QI98Lh+MzsazVq2QQX7JFp4HY4Exnao0vbzW2a63+c7cHsJCUdQw8yjbFCDmIcqaA5qbIMr985EI+3qvb0oimoiGiFX48tuebq9/Vri6CyM7LYlEl5Ho043nrIA/0aKeeKzqGMfhKbJZyChdC9qtHehEWLy6/1RAz8dNebb0KjYUMc4ysN+BauP1nJHyoOX3OEWI8GUFepEJOx38rLISutXSFA9ijrX8ErYeYdQC5ruH03ZnbQQdfY8qn6csvvsALSu9d5KmvojgTMZLQ63elm2VPIzj7J7Ls8ymzvxt4Iyy32MMutZioTjJDSaXIbq4pdeLn3RQu7bPV0LPY681rElL2cF5QHEPCpONb8TEoqD3S3PdvPgKZvv2igP7SbUHudTjuLPiiK37TxL+BLaXDHc49mNsjV4KKqj3VE7ejPaPbcDGuAci0yQ7/Xyuxsps62Q8h2H6vNQ1A7+6N8voFlOH0/fHPSw5mC/Z+s63J70eNbH7QmPd7anc01uT6KNJHOQTOqLBP2rUNt+pYc9E8mlRaium/3eXdzvAkpb3ZpyLFF/NNMbjmbo7/eyGeTl/B5P06+T3ob6bi+3nVJKZ/mD6+eiA4M/TaPo6nWUdVxzORGNqmdS1lfuokxhs9szlBFUniU824Fb9WHLfP1ZyvQ6+3uJ1Rfv1nRvR24dpaGj8Dpy6yyMVRTz1W1IaD2BBOZSNPVt9XLJi6DVBdvqonR75VrVbX7FPfuv2q6rn1q3lZTDGvMnr0/U/m6nvAbgErSrL9uV84wijxZXUV6I9jxlLWEa5QHSl7yc/k7ZwTeHYj7KceZ1uGzCyHFV87SQ8ixFPf5yWbUhJdOKFk3noC272ZS5HA2IFiGBu5CybX4+qz9nkss2r8mtrMRbXdvKJqpcV7lssiktr9m1V65V89DagdvSSnj5O29kWYaU5uU16crteLLnbSxlTXCp1/E8yhtZl3t9nY8GHnnb8IuUdpLDvcfjXU55++hCyvpid3Kb5W4vIeXzlJdHnu2MpRwOOwVZEqZ6HlspM68JFEtDi5fd05Szyh71OKZ72V1DMWs/ARxWWWu5Cnil//8g2hDVH59sbOxPjzGRmdm+qAG2oO2s85BJZD9Uib/374lotNGOCtdQQ9+jxi3vZGn367uhRr4HZfdVL4qpKVG2JHZ0b3XHUkfxZbc8okxriaOzMPIC63zUaF9HeafDtpT3zs/34ltK2UmUp/s5H3h41RlHdss2/wWUmclAVl8kzQLoeYoiXOb+Z/v9RtlCmzvRNMoumWzqeAaN2j7oeV7o3+2UbbIrUD3ldY6HPP4hlFnFAL/3tZR3Y2RzYp5lLqSYP3JnXIyU0jzKYGUw5YDM1jr9LfSy35aypfanXgb3+/1nobUnkFC4FwmJwWjGsoKiJO6lmIDGuPtdlJnwXPd3DWXWMo5yBEkL5VXXgyi7I7NpaZG7gep1CWWnFF4vSytuz6PZUC8kRE9Eo+5mJDRXUJTKaC8X87z1RlvW56Ct29m0MxrN7kZ6GpuQdSGv6STUTramrM8NphzDs7wbum3h/7dDcqkPmi1vRzFvLkQWgVb0nMvdlFn4nsh0tgeawWULS96lN8jrYzfUzrIZ962obR+Ftvzfb2bHppQmeTq+ZmY/RlaNH6SUVqYGmbJ6jInMzEYje+0MJEDuoEwdh6CC253V99wvpZhJOnLLDRXUKPLmgAGV/1mw9O3k3rwwnk04a0vDMsoid2dxdBbGEs93FpgtSAGN9vT0R4pmG9TIt0DCoK/f14dyREz/SlhVt7w5oBk1+O38fx6pzvZw8sL3UCQYBvr/vAngGa+vDyIheg96a95zaP1giOdxCOU5mxYkcM718BagM59yB8vlkZXduehZiQEUZTbN09EPmf16oVfmDkdCebtKeDnuR/zeQymCfhBl19La/LWjTj4EKf8D3e29Xg6XAFemlL5vZv3dz1D0cOXHKc8a7YA/DIcGE4PQNupr0HMQVyKTx+uROfAAJKwec38/R2bQB9BgY0fKOsqtaNMDnqa9vU7e5OV3IzJ9jkCCagDlOagj0Qh8FBKGg5Ei3Y4yULgZrSn18XJahtbdDkJ99ADKLLQfGnC8wsv4z15+2yHFfZb7qS6iD/d7Rnoelnk6uqNbHpi1ItPvKymKeSCqpyno2aq/oUHdEKQkbkFm9IHo3MAzkbXiJFTPr0Ft71zUHvqjujoPndM4x9vY35Ap+mQv26NQ2/l9Sul5GkiPmcEknZJ8K1pj2BE9NfwBtNumCXXIW9Fo7BeUd5535nYRZTHwYsr5URdRTE9LKA9qrenei9yf1ZkGqzOOzsLoU3H7goe5GxIoN6ERzS6UNYo+lNNrs5La3t1GUI4gr7pl2/twim1/ERp59UMNegfKwmgreliwCQnyJUgJ7YjeRDib8mT4Y8h09D4kNO9F24R/5nl8Gs1O3wy8JqV0CJrO90aC7gI0Ss6mrzehUfRiysOmDyOB1Y4E6lOet6mUwxAXexnlBf8TPKxBlOdZsmmpHn+z3G0W5RW9E5FQzXb4fmY2OqW0EimcrfzzG8pJEfPQg5ptSGH8FCnSt6JZ3Xu8/JZQFnIHep2sQII53/sg5Wj5lUhA/cPL4AgP71g0u+rrZfVzpKD7+n3TkcCbgtb0rkbKdTdkdpmL2kB/JGSf97QtQIplALI8fAIt6vf2z1OetmdRX3o9UmZHIAW7xMtmImqHW7q/UX5vH89Hd3XLO+rmUV6xfS1qm0+gWcmeqM4nocFDfzRzuQf1ie3QYxi3o12Ht3g5Xedl9zn07palqO53As4xs8PQoOtGtJHmS8D8lNLVKaWvN1q5QDkiokfg07hkZrdQTsbthwTR7mg6+BSqmOY63VYhQXwHEry7owbQjCr0mHW8t9401BvHmuIdVXF7Ao1wjkMN+Dz09PjWlJ1YJyChtxSZd46n7DBam1s/d2vy9B5X8Zd3+RxD2RI6GwmsbJrbmjICbkFK6AJgbkrpYTN7FWUbZxvlTaMrU0pTzayXP3H8N2QOXIRG7ft5fg/2ehju8W+FRtIzkRKaj0bpP2b1d/bMcb/TKK/jhWKaWld/eSNGK1LUregJ8KP9/xTU2T8F7GFmt6IRfisyM13v6R9FOSZnR0/zeZ6ObdHsbwUyCy9F/XgvD+dIJKAWVe49hHL69Y1oZjPS05534eG/F3he34vq+BGkzHZAA4Em9AT8C0g5Hk3Z6Zdn4W9DiuAfaICQ12j6e54u9bI72vOyParvuV5PX0f1eYOX5wTK7romT99sNOvpCW6rkGlsntfJ42iA9Z+oTe2PlMh3UTu61Mv8B0ixvpayMWSnmu+bvG4ONbO/pZSWmtn7PKz3et1+ycPfJ6XUwiakx8xgqrjNcGVKqQ015nejnVV7IuG3+zq4vRNVcPX6fkhArs+99aah3jhq3U5GM7eq2z7ubzDq4CdR1nI+TDkY7w+ooz9D2edfj1szEmZG2bnWijpJP9SOdvD434xGZSdRFGF/tLYyHAncXfy+pb675a2U0flyZArYDrjWzHZDwuXbqMO1oU71KWSiORyN4szDn4fYFimj73v5XIG2Rv/C83UlEvjTkInq3R72H9GIfwKaBXXkr51yqOM8NCJ/N1rEPwPNKC8Czkgp/RoJko+hNYX9kIni7UiQXkMxo/wPxfSLfy/17z2Q4BrgdTwMmUOHe11M8zJtpqyxZeWzA+W1ACe4+ygP40WkgLZEo+8Rfs+hyLy3o6dtT9SWxiGFcSEaVPzW8/duD2u4xzccKc1n/PoANLA4x8vzG17eu1FOOtgFCdS90GBjTzSz2Ycy+9sSzW6364ZuN3i+/+ZufdAa4WC0EP80an+3ez0MQPV/IpIj/bwOvoqOevoJWmcejRTVO71cqt8JKeX3ppSSmfVOep/LWSmlc9x9FZITI81scOXVJw2nW6/B+KiVpPcU9Mrffnkg2kL7VdQ4f4009pXIdr8ubr+r/L4EPRB3xXrc29H1HF5HbvXGkd0eAf4dNarzUSO9Fc1WWtE0uhUtni71tO3k7n9Awu+PSFCsQCOlet0+5PHmzrQMjXjbKQLyKdTpvoAE0VBk4hiJhOoeaLS6BVqPOQX4b1bffTXQ4/ww6mxf8Lzs5fedgxTvNGQiakWmpFnI3LaPX98CdeAlFHt4GzIrrEAKemvPz86IyZQNGH9BCqQjf8/5tR093VdRDr5MaMTZ5GW0tbvvjcwVK5ASuAodkvkCxTY+gPKSs0HIXHiOxzEbCaEWpOQHI+W2t6dnNzQ7OQWt5cxCM7YnUDvpiwTcvpR1l7yjrcnLaWvKgavZvDeE8uzTL7xeJiAl8qLX12fQFuNPe17HoDa0ACnMQzxNP/EyeS2aaf0VKcN/UJ7v2NPDuAHV2VLKO+ab0aygu7qN9bw/hgYSewP/hfrom70uH0bP+HwambN/hAZMs73OtkKz8s+gNrUnknM3ogHKlMr3gSmlsWY2ystsSu1iva/BnIKOjDkppfQkm5Bup2DM7PXo4LbpqFDfgirgwx24fQk12CvQiPA6ynMGV/g9k5CwOw6Nwk9FpogP1dz7DBq1LUPmq47u/RASCLVutWk4FY28quF1FEdHaa51+wQa2Y1GAvUGNLJ8EzITnohG3K/2IhyPGvd1aHZnlF1lf3X/6+O2jLJQ+yuk2NvRukcLmqH0oux+Osv9fBYJOnO3VZTToT+OZhhG2UmXzSzLPdxzkEnhd15+b/M6OBgJ/C1Rx+zl5fRKL4s+qLP2R4JwX8ozDf9Abelwj2t4nf62RwJ3AuX5lZH+fSV6rmUoMi1u5/UxDSmDkZRTBn6Fnlvo5fE+R3lV8fVIEd+P+kE7Wh/8d8oGhgGU0yeupywIvxUNDK5HfWMnL8es0E5AJta3ohHwtkjo/wYp5h+jkfPdaA3kU6ittXmaT0L2/oO93Pt5fc2nvF9nnpfdtZ7GM5GgPMu/+6CnxZvMbB9kInuVh7UjGhg87+Eu9/rohQYvW3Rjt6VoEDUPKZhjEV8D3uXf97vf07wcdkcDg91Q2zkNtaMzUHv/b9S2zk0pXe2zkzY/9fgIr7urUPtYllJalQfiHncepB8JzEgpTWYT0x3XYCYg4dYfNbr3+3dHbodR3tV9IrLhVt0ORaOli9Gi2BTUSeat4d7Xu9vcNdx7GGpEtW614eQ4quF1FEdHaa51+wgSWF9GprF/oJHPQ6ghH4DMGgspu8FWoRFh3gwwyN0OWU+3NiQsDvHfe3s6dkG2/qM9jVuhzjIEmYhuQrbgu9Eo6kJkSpmJOtp1yGS2BRKQ70G0U0xz51NenzAaKaY9kaD8AFKu05GyMcoawjKk5LfwcjnCw9uTYtPewr8neHyd+Wum7I7b3+vqSaTchqE6B7WNSUjJfxOZMfbwdO6LZggf8u8haECwj+fnlUgYNSMhfpfHdTjllIcm/x7h974djYpPQQOfUzzOXkjRD/Y8nIOE9qGUTQvXodH0R73MmpCyWYhMOrtSjkh5E1Kab0SKYIKnvz+a+fRBAjGhdrk35XXhu1KE5Z7A/zOz8agP3412QT2KBGEfj280Esh5sLB1N3U7zPOZvE5f9LrJa17HoHp/NepbI7y+bkUDpaNQn7oQKeo3eDkdSDkc82Az+3tKaRGAK5khlK3dI4D+ZvatlNIsnIqyuZ8uolvNYCq2wW1RgxuKdqycikbub0OjzVuQILgXCexhnbgd6b9/j0Zu97u/e9AsJG/LPLrOe49cS3zZ7eg646gnH0+g2cB8JNiupbxbIy/a9kKCahnlKJC+aKTaTHm6fn3c8jpLoizCb4Xsw3uikesbKYuYIzx9w5F5agkSlqehDnMO5WVRpyBT0ZOUo2z6InJ8eU2hGY2Os/lrEmonH0CznIP9vlWeZirhtHt+mpBghLK7rl5/eSNCdsufxZRToa9Gs4dJyMwxECnIvl4OeaNDO1KW2XS3Eo3cd/dya6HUxwDKFvXkacn3LqIsKg9Ag5M9PS23oL4z3+Ptj5TxHmjTxRJUV4OQslpBOftsJFJY+3qec16norrc0tOypfvfirIdfgjlua4WyisBoLyH/i+oPw9EprsDKacS5BntIMrpBN3VrZlyLtjzaPC3DRoYtKF1pzNQn+7jZXGt5/cqZCpvR4O15R5mHtSspKzHTUJ95Fm0yWIiavcrKLsAP4pMbg+nlO6lO9DVT+e7gnsl2q20q//eFWn+eaij/wF1qDGUp6jHUh7oqrqtREKn1t9Kylk9+Z65lKej13TvSsobH6v3rikN42vcauPoKM21bv9wt39U3B5Ho8arKE+nP4W2r06hnM7bSnktcrYVt6+n28qKW7u75fQsQ8KtCY1CF6KdTos8nS9STqP+IVo/eozV7f55l1w2syzw33eizjaPcmrBYg9viZfndP/d7NdnUp5mn0Z5O2hHn7zek+t1bf7aKGe+tVWuL2X1UxbaURv9MuVh0j/VhJc83mleVvMq19s8nytZ/Un8VIk3r9HktZxq2CsoC+ZZ8DVV0tdEMWG2UZ4Kv4Uyo3nR09CKhOUSVj/NIe9e+5nX33jKgYz3ez3/Hxql5z53AWoHl3u+l1POLFtEeV1CDmclqyvv7u42h/KW1WVoVpvb4krKiewPUvrTCsrrNh6lnJU2DfX7xV6GS1C/mIAU2FK/viVaa73WZegufu27qO19rqvlekqp6xUMGvlk4TbPK+YJylPxuWMt4uUddUkHbtVPawf+VtVcW9u91U9H8S3pwH9ncXQWRnZrRx01C5ylfu15yjEUK5FQzoJ0DuVIkBbKttn1dVtJeb9EVbg2o7WQB5AwWkI5dqWZctBhs7v9DA0OcvpWUITbYqQo5lfyn+t5FkW5N6P1qfspr8xdWsl7Tns75bmY+cgMkRVlM+U9J9X6bqU8Sd2Zv5zH8Wjheon/3gMpkWy+Os3b9SOVtN2BRp9LK2G2snp9V9vDTMrBidlvMy9vp9X2lf2u4uXtq/ppoayZ1IaT6yVRjpRPlGPvV1Ae6J3g4TxCUQ4votnIjWgNYUylrn7v+brJ78ubCe6gvNflDiR876e8cfa+buh2q5fNYopynszqRxudj4T9Ii+7SV4fU/x/lnF/r9TdYi+/16O29Tr//zzlIdgfABdV5OdVaDY4ETjF3fYC9uxq2d4tFIwXyHfQtDtX4Fz/ZAFU29FrO8+6unV0fUPuzZ1zY8VRHSXnDt9U8TPb/1/k/++jvOBrhjfc2zbArQmNpBZW3JaiAcAC1Nnms/oMIM9EWiivX16ChEz2k0fQi/z6SrSQPJgyqrseCaLJSGD9GXWiRZS3jM6jdNSZlbKaQZml5gHL1ZW4liDFNZXyLpV6/OURaRauY9Bi7AL/PQLNMPNg4QNo19Akv38hmpXdQRHicygKIa+JZCW5ivISsBxvnqm1Vb7zSHqp/89KsaVyX6I8YJlnY+0e9ouV322Ugct4L99FHu8syvl/WUnmcBZTjo95jqI0fova50TKgGNV5Xdi9ZlRbvMrKv+7o9uySl6WV8pjIVpDfA61i/cgBdPqZbOI8g6j5X7PJMoJ3XPQjOUKZDL+DlpL+zYaAP2Py8otkXL6jv8/yuM80f/372p5Xv10izUYM3sXslUuQVshv0k5an8l5UiQvJd/FWXRs9YNyu6Wdsq7X2ajRcqVFJty/zrv7Sy+qls9cdSTjyyM8xbXZjS9TqjjnoFGNAuRTXY2st0bZdvyODRtXle3M5FyvxkJyZvR2VFz0VrLp9CI/XnKqbsHoc0Jg1Dn6U05q2ol2ma9BzIV3I3Mn21oFxmU7alZaM5ESqcFCfBPoR1Ob0UKaCs0SrsX2b7nokX+0V7mgynvBpmDzI/HUgT6svXwt5RytMwcT+MitPFhPDJX7oMEwIGeryWU89P6eFgPoRFqFvyDkfI5gdXXfdq9/BZTtk43exn3prxnZhLqK1v4Z4aXRVZEvSjnx2Uh2du/57rbDv7d1922pWy/3Qq1zafQrrSH0eDjbMpuv0GVuPpQXn61CG3lfRGt5Sz1/L8WzeiOoKyt9fc09aPMlLubWzvllQjZJL0N5TXKC718jvc67EN51nCW1+X9aO3pJbQRpBkNrrdGGyNmIkV0HVqzfQzt3GtH62l3o75+ITJJ34O/BjmldLmZWeoOQt3ptXYvjSeldBVa+MoLl30pFdiPcrxIG+rcfTtxA1XGNMrC7BzUEJZQDpjrvQ73dhZfr3WMo558NFEOCHwWNd4D0Q6T41DDnIR2/GyJ1q22Q2tX+6MR9X7r6TYcCaidKdt+s9srPG2/8/r6HRq5f8b93otGVxPRCP92yrMa27mfvh5nH/S+9af82rme1/me9/tQpz4IPdF/KlIgo93fHKQMnvN8TPBPb9ThHvS4e6F2tA8ScP2QqWFd/U30PD/q6ToUCZYvAF9EW7iPQcJ2AaKP110OZ4CX8QrK4Y/9vE6bkXJ5ye/Ng6phlE0GAymbDPr6Z2+kIIYiwb4Lqx+2mAcsUM7+aqZs477Gw8ym0K29DgZ7PrLCOAD1yaNRW8wz3zy76ovaMB7HvmiH1SDKcUJ51D6FchLEMv+8QHlnfXM3dZuB2sgKinlwEdqItAT1/zdVyuBeNAOfhxTHGDQzOR8NSh7y8pvmfm6nmGlnoEX7yylHUb0dPbT6OrQu/aqU0jIP7/1mtgXdjC5XMOagUdwItMOoDY1qe1EefluORj1Wh9uLaItgU+X6U6jypqKOvC731puGeuOox20psmX/nGIGesnLaLCHvzdqyJMoT3DnHUXPr6fbTP+93D9Vt/0oM5bD0Uj0XWiavit6eLINdaRdUCeZigTSLkhI7YgE33PIhPB91BH7+e/LPY6jUcdaDHzV9/5PRaPe/0MC/kj03MabPU1Z8bwBKZuZqAMfjxbed0KK4sb18Pcc5T0lLyGhfziaXZ2PFMc0pAB/SnnD4iT/nWeq21BeUdyLclJ1VkZDKWbJPOPoT9nBVjWZZj/tiDxTGexxQJlBGeV9NoMos+vTKPV/L0VJNHmd/s7T2NfrcEs00GhGg4BF6PmWMZ7XHFceNOUdZkNQ2z0Rmb23ZvW1vfme5upmje7mNhdZEFo9n79wt0spbzVdgQZMx6FZ6QTUjuahwdpOSDk8jGTNtV5H0708nkH948PAR1JKL6aUPoPkQCtak3mlXz/azN7oA/QzUkrLutPsBbrRNmVXMjegh67upjwFPnQ93Tq6viH31uu2IWmudfsTeg7mENTwnvPry9C++tGUM7mepmzTfWwD3Q5EQmU4EmZPVa7nEd330NPIzWjqfgLqRNehWcH9SAHdh5TFKNQBZ3maB6GO+2qkTK9AT+SfhQTVaKSsZwA7ppSm1DxoRv7t3/0pb00chTpjnhH/GXXsq9AAZn38rfK074wU3R6etwFIyX3Iy2drz/snKvkcT3n9bRbm/SlPyy9CM94+Hn5ebzO0nnEy5Ry5vpTXWw+gbH9uRW0ju2dzFZR1q90ouwxvRjOM3kjIj0bC8XZkwssK73r0DMuRSMhegh4a/G9k4rzA03MTGvBMRMp/J2S+2dPjOgUpp98ghd0bKcSRXp557ak7uzWj2fo1Xh+no9cP/wj1m9+hQciD6Pmi09EA5I/I9HwTmpFeg9r4GV52U5Hyzt/L0MPkfYEbU0r/aWYHoZnLjSmlF8zsPNRXZqAn+lvphnT5DAb++bSpocp6Go3yfok64cXr4dbR9Q25t163DUlzR24TkRC+Bwn0Q1CDzOaiLKATxZ7duhHcWpCA2MLjqF4f5mnLC5jvRrOHs4DHU0or3P/3/Ps8JHCOQQuWQ9Go+QS0EJoF9lnIrv8c0JZSmgBMSym1pJSmgBRK/q7+diWTZ47tSafETvX0vejxHwF8bwP8TXe3yUCvlNIznvZVnp/j0W6eaV4e/4lG7GPQjPga/+6FBP6tSPG2IIWy0N2O8Xq/H80u34AU3/YUZXKpx3MpUl5tyGQ11tNzPTJVXo3a0io0Yt4ZzfIeQCasO9EM8W6PZyLlPSQT0HbYvdEM7faU0hjgkJTSdUgJjaPM7k7y+0cj09GTaIY3A5nI7vK0Hut5HUV5ffMopLy6u9vuaMDX6mX5RTRznYnMV/uhGf0xSFF/EZ2KcSZq6xejAUseMFyBTrq4tOb7PKR8TgKOMLNfej3siawF+KzmXcDJ3VW5QDd5kj/50QZmlreetiA77XzUydfVraPrG3JvvW4bkuaO3GYjpft1JNhe759VaHT9EurQw1BH7ruR3QZ3cH1/NEV/HRJyn0Yj4TNSShOysDez6S78p3odPw48bma/RcpltIfbDwmmqSmlaVTISmRtVJVNrZvPdtqTXrb0snDX1Z9/t5lZ35RSs5nt7OVytZdDPzS7+QnamHAUErhvRVt134fq8iA0oNiZYqLLbm9Co+D7kEKuvfeVaC3oAP/ujR50vRmNtI9Fo+W9PO59kMnmG+iEhzzDzDPjHO8xaNvsD91/TsNR7vaJLMwqM8k2T+8jSHBeSZm5DkOz8fuR8G33shmMFNtrKbvdjuohbqchJTwOKZVH0Kakw4D3pZQmm9kh/n+q183FKaXpAGZ2BdCUUmpGfR7Kml31e4r7PxyZbQ/wenyLmS1KKd2QUrqNbk63MZFlzGwggHfegfl7fdw6ur4h99brtjHCqLjtikZCX0opzas99DN1cBDoxnDr7LrX02Ck7BajQ/ZWUw5rqNuXhbvODaQb4UqmxRdX83MgB7nw7YdmDfciJbwbZXH4ITR7OArNTr/YgdtnKSa62nvvQsKvaob8CRLu2SS5I6sL++z2Bw97e09zVYncg0xfD1fSsD1SoDvmmWRNGeRNB3mkn02JOe27UB6kfaP/HkV5/UEfygvMepLbi14ueyHT5cSqGbe2nNaHivm3F1Iwx6LnYK4CznRrQfdmTfuXu+qDH8WQf2+IW0fXN+Teet02Zj78/8CurpeaOurV1WnoLh+gr3/ntZafAL3zNTRT613jtz9aQO8L7N6B22h3693JvdXv0ZVroylnfu1a47Z7NexO4u1b628tZVBNZ+8O3Hrl7+rvnuq2KftAVQ74/9Nzm+kJn243gwleTnfb2x6sTmUm05eaDQkd+P3nRoVUMc/Vuq0hntX8rSkMeNkGiH+61ZuWjVY4wUahp8qAUDBBsBEIwRwELycUTBAEQdAQusU25SAIgmDzIxRMEARB0BBCwQRBEAQNIRRMEARB0BBCwQRBEAQNIRRMsFliZl8ys/FmNs7MxprZEWZ2jpkNquPeuvy539PN7Ev++0QzG2NmT5vZ434g4UZlXdIWBF1NKJhgs8PMjkSn0R6cUjoAnZU1DZ2QXI9wrtcf6Pj5W8zsFehk4X9LKe2HDs6cuG4pr4s1pq1ybEsQdAtCwQSbIzsA85JOPyalNA+9fnZH4E4zuxPAzC70Gcd4M/u6u32iA3/Hm9kDZvaYmV3l57DlV0wchI5q/x/gWymlZz3OtpTShe5vlJnd4bOp281sF3e/1MzemRNtOuwVMzvGzO4ys6vN7Fkzu8JER2lbambnmdkTwJfM7LpKeMeZ2bUNKN8gqI+uPqsmPvHZ2B90Wu9YdIz8z4HXu/tkYJuKv638uzc6QPKAWn/o1QT3AFv4/88BX/XfBwO/9d+PofdydJSev6DDCQE+AFznvy8F3lnxt9S/j0GHiO6MBoEPAEetIQ8JOM1/GzqOf4T//z3w1q6uj/j8635iBhNsdqSUlqKj6M9Grz74k5n9ewdeTzOzx9CLwfZHR8rX8mp3v9/MxqJ3e+zq196M3vexNo5Ewh70Uqqj6rjn4ZTS9KQTp8ei03w7og29L4aUUvLw/83Mhnu89aQvCBpCt3gfTBBsbJLOBbsLuMvMnkSK4Z+Y2Wh0NP1hKaWFZnYpehNkLQbcllI6o4Nrx6O3cIJOUj4EveirXlpxM7Ufyd6vcm1l5Xcba+6rK9LqZ6D9Bs2YVgBXpW78Mqpg8ydmMMFmh5ntbWZ7VpwOQi9wakLvhofy6unFZrYdWqzPVP09CLzWzPbwsLcws73MbBjQJ6U03/19H/iime3l/nqZ2Uf82j/QMesA70XviAGZuw7x36egY/LXRjVtLyOl9BJ6T8mXkbIJgi4jZjDB5shg4KduJmpFu7nORq+hvcXMXkopvcHMHkdrFtPQy7syF9f4+3fgD2bW36/nNwz+Pd+QUhpnZue4v0FobeRGv/xx4Ddm9llksvsPd/8lcL0v0N+CFN7aWC1ta/BzBVqHeaaO8IKgYcRpykGwHpjZr4BfpZQe7Oq01GJmFwCPp5Qu6eq0BP/ahIIJgs0IM3sUzYSOS75NOwi6ilAwQRAEQUOIRf4gCIKgIYSCCYIgCBpCKJggCIKgIYSCCYIgCBpCKJggCIKgIYSCCYIgCBrC/wcnMV4kXr/vgQAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "plt.bar(job_count.index, job_count['city'], color='b', alpha=0.5, align=\"center\")\n",
    "\n",
    "plt.xlim(-0.75, len(job_count.index))\n",
    "plt.ylim(0, max(job_count['city'])+50)\n",
    "plt.title(\"Job count by State/Country\")\n",
    "plt.xlabel(\"State/Country\")\n",
    "plt.ylabel(\"Number of Jobs\")\n",
    "\n",
    "plt.xticks(rotation=45)\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df.drop_duplicates(keep=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>Job title</th>\n",
       "      <th>Salary</th>\n",
       "      <th>Date</th>\n",
       "      <th>Company Location</th>\n",
       "      <th>Company Name</th>\n",
       "      <th>city</th>\n",
       "      <th>state</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>HYBRID - Electronic and Digital Design Special...</td>\n",
       "      <td>$27.03 an hour</td>\n",
       "      <td>19 days ago</td>\n",
       "      <td>Remote in Columbus, OH 43215</td>\n",
       "      <td>State of Ohio Jobs</td>\n",
       "      <td>Remote in Columbus</td>\n",
       "      <td>OH 43215</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>Layout Design Artist</td>\n",
       "      <td>$20.76 an hour</td>\n",
       "      <td>1 day ago</td>\n",
       "      <td>Hybrid remote in Columbus, OH 43211</td>\n",
       "      <td>State of Ohio Jobs</td>\n",
       "      <td>Hybrid remote in Columbus</td>\n",
       "      <td>OH 43211</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>Design Researcher</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8 days ago</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Central Mutual Insurance Company</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>12</td>\n",
       "      <td>Design Consultant</td>\n",
       "      <td>Up to $180,000 a year</td>\n",
       "      <td>30+ days ago</td>\n",
       "      <td>Dublin, OH 43016</td>\n",
       "      <td>Bassett Furniture</td>\n",
       "      <td>Dublin</td>\n",
       "      <td>OH 43016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>13</td>\n",
       "      <td>Product Design, Associate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4 days ago</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JPMorgan Chase Bank, N.A.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>14</td>\n",
       "      <td>Artist, Graphic Retail</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1 day ago</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Giant Eagle, Inc.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>15</td>\n",
       "      <td>Product Design Engineer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30+ days ago</td>\n",
       "      <td>Remote in London, OH</td>\n",
       "      <td>Harness.io</td>\n",
       "      <td>Remote in London</td>\n",
       "      <td>OH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>16</td>\n",
       "      <td>Designer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30+ days ago</td>\n",
       "      <td>NaN</td>\n",
       "      <td>McGraw Hill</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>17</td>\n",
       "      <td>Pricing Design Architect III - REMOTE/HYBRID</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15 days ago</td>\n",
       "      <td>Remote in Columbus, OH</td>\n",
       "      <td>FedEx Supply Chain</td>\n",
       "      <td>Remote in Columbus</td>\n",
       "      <td>OH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>18</td>\n",
       "      <td>Design Consultant</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30+ days ago</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The Cleary Company</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            Job title                 Salary  \\\n",
       "0   HYBRID - Electronic and Digital Design Special...         $27.03 an hour   \n",
       "1                                Layout Design Artist         $20.76 an hour   \n",
       "2                                   Design Researcher                    NaN   \n",
       "12                                  Design Consultant  Up to $180,000 a year   \n",
       "13                          Product Design, Associate                    NaN   \n",
       "14                             Artist, Graphic Retail                    NaN   \n",
       "15                            Product Design Engineer                    NaN   \n",
       "16                                           Designer                    NaN   \n",
       "17       Pricing Design Architect III - REMOTE/HYBRID                    NaN   \n",
       "18                                  Design Consultant                    NaN   \n",
       "\n",
       "            Date                     Company Location  \\\n",
       "0    19 days ago         Remote in Columbus, OH 43215   \n",
       "1      1 day ago  Hybrid remote in Columbus, OH 43211   \n",
       "2     8 days ago                                  NaN   \n",
       "12  30+ days ago                     Dublin, OH 43016   \n",
       "13    4 days ago                                  NaN   \n",
       "14     1 day ago                                  NaN   \n",
       "15  30+ days ago                 Remote in London, OH   \n",
       "16  30+ days ago                                  NaN   \n",
       "17   15 days ago               Remote in Columbus, OH   \n",
       "18  30+ days ago                                  NaN   \n",
       "\n",
       "                        Company Name                       city      state  \n",
       "0                 State of Ohio Jobs         Remote in Columbus   OH 43215  \n",
       "1                 State of Ohio Jobs  Hybrid remote in Columbus   OH 43211  \n",
       "2   Central Mutual Insurance Company                        NaN        NaN  \n",
       "12                 Bassett Furniture                     Dublin   OH 43016  \n",
       "13         JPMorgan Chase Bank, N.A.                        NaN        NaN  \n",
       "14                 Giant Eagle, Inc.                        NaN        NaN  \n",
       "15                        Harness.io           Remote in London         OH  \n",
       "16                       McGraw Hill                        NaN        NaN  \n",
       "17                FedEx Supply Chain         Remote in Columbus         OH  \n",
       "18                The Cleary Company                        NaN        NaN  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(2398, 7)"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Job title              0\n",
       "Salary              1774\n",
       "Date                  10\n",
       "Company Location     857\n",
       "Company Name           0\n",
       "city                 857\n",
       "state               1010\n",
       "dtype: int64"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.isna().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(857, 7)\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "857"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "print(df[pd.isnull(df['city'])].shape)\n",
    "df1 = df[pd.isnull(df['city'])]\n",
    "#print(df1[df1['city'] != np.nan]['Company Name'].unique())\n",
    "len(df1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv(\"clean_data.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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": 2
}