initial_exploring.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 50,
   "id": "409899df-3c30-4b1f-a1b7-62251260ed18",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import plotly as pl\n",
    "import seaborn as sns\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "0ba1cf3d-22fe-4c97-863e-bfbee6f7a4ac",
   "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>Employer</th>\n",
       "      <th>Union</th>\n",
       "      <th>Union Local</th>\n",
       "      <th>Case Number</th>\n",
       "      <th>BU</th>\n",
       "      <th>NAICS</th>\n",
       "      <th>Industry</th>\n",
       "      <th>City, State</th>\n",
       "      <th># Idled</th>\n",
       "      <th>Start Date</th>\n",
       "      <th>End Date</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Unnamed: 12</th>\n",
       "      <th>Unnamed: 13</th>\n",
       "      <th>Unnamed: 14</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Interstate Paper Converting Corp</td>\n",
       "      <td>USA 13058</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1984AA00L294</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Manufacturing</td>\n",
       "      <td>Secaucus, NJ</td>\n",
       "      <td>27.0</td>\n",
       "      <td>2/25/84</td>\n",
       "      <td>3/15/84</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Wgbh Educational Foundation, Wgbh Tv</td>\n",
       "      <td>NABET 18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1984AA00L307</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Information</td>\n",
       "      <td>Boston, MA</td>\n",
       "      <td>600.0</td>\n",
       "      <td>2/9/84</td>\n",
       "      <td>2/9/84</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Nielsen Lithographing Co</td>\n",
       "      <td>GCIU 508</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1984AA00L324</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Manufacturing</td>\n",
       "      <td>Cincinnati, OH</td>\n",
       "      <td>29.0</td>\n",
       "      <td>1/25/84</td>\n",
       "      <td>7/19/84</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Newark Metal Products</td>\n",
       "      <td>LIUNA 734</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1984AA00L339</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Manufacturing</td>\n",
       "      <td>Kenilworth, NJ</td>\n",
       "      <td>15.0</td>\n",
       "      <td>11/28/83</td>\n",
       "      <td>3/27/84</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Universal Construction Inc</td>\n",
       "      <td>IBT 492</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1984AA00L359</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Construction</td>\n",
       "      <td>Albuquerque, NM</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5/21/84</td>\n",
       "      <td>9/5/84</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28629</th>\n",
       "      <td>Amita Health St. Joseph Medical Center</td>\n",
       "      <td>Illinois Nurses Association</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020N1801267</td>\n",
       "      <td>800.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>Health Care and Social Assistance</td>\n",
       "      <td>Joliet, IL</td>\n",
       "      <td>780.0</td>\n",
       "      <td>7/4/20</td>\n",
       "      <td>7/22/20</td>\n",
       "      <td>19.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28630</th>\n",
       "      <td>Infinity Healthcare Management of Illinois</td>\n",
       "      <td>SEIU Healthcare</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020N1801783</td>\n",
       "      <td>940.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>Health Care and Social Assistance</td>\n",
       "      <td>Hillside, IL</td>\n",
       "      <td>940.0</td>\n",
       "      <td>11/23/20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28631</th>\n",
       "      <td>Johnson Controls Inc. - Test Lab</td>\n",
       "      <td>UAW 1872</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020N1802519</td>\n",
       "      <td>60.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>Manufacturing</td>\n",
       "      <td>York, PA</td>\n",
       "      <td>60.0</td>\n",
       "      <td>9/28/20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>98.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28632</th>\n",
       "      <td>Gahanna Schools</td>\n",
       "      <td>OEA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.02111E+11</td>\n",
       "      <td>570.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>Educational Services</td>\n",
       "      <td>Gahanna, OH</td>\n",
       "      <td>6.0</td>\n",
       "      <td>10/13/20</td>\n",
       "      <td>10/18/20</td>\n",
       "      <td>6.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28633</th>\n",
       "      <td>Montefiore @ New Rochelle</td>\n",
       "      <td>NYSNA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.02112E+11</td>\n",
       "      <td>225.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>Health Care and Social Assistance</td>\n",
       "      <td>New Rochelle, NY</td>\n",
       "      <td>225.0</td>\n",
       "      <td>12/1/20</td>\n",
       "      <td>12/11/20</td>\n",
       "      <td>11.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>28634 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         Employer  \\\n",
       "0                Interstate Paper Converting Corp   \n",
       "1            Wgbh Educational Foundation, Wgbh Tv   \n",
       "2                        Nielsen Lithographing Co   \n",
       "3                           Newark Metal Products   \n",
       "4                      Universal Construction Inc   \n",
       "...                                           ...   \n",
       "28629      Amita Health St. Joseph Medical Center   \n",
       "28630  Infinity Healthcare Management of Illinois   \n",
       "28631            Johnson Controls Inc. - Test Lab   \n",
       "28632                             Gahanna Schools   \n",
       "28633                   Montefiore @ New Rochelle   \n",
       "\n",
       "                             Union Union Local   Case Number     BU  NAICS  \\\n",
       "0                        USA 13058         NaN  1984AA00L294    NaN    NaN   \n",
       "1                         NABET 18         NaN  1984AA00L307    NaN    NaN   \n",
       "2                         GCIU 508         NaN  1984AA00L324    NaN    NaN   \n",
       "3                        LIUNA 734         NaN  1984AA00L339    NaN    NaN   \n",
       "4                          IBT 492         NaN  1984AA00L359    NaN    NaN   \n",
       "...                            ...         ...           ...    ...    ...   \n",
       "28629  Illinois Nurses Association         NaN  2020N1801267  800.0   62.0   \n",
       "28630              SEIU Healthcare         NaN  2020N1801783  940.0   62.0   \n",
       "28631                     UAW 1872         NaN  2020N1802519   60.0   31.0   \n",
       "28632                          OEA         NaN   2.02111E+11  570.0   61.0   \n",
       "28633                        NYSNA         NaN   2.02112E+11  225.0   62.0   \n",
       "\n",
       "                                Industry       City, State  # Idled  \\\n",
       "0                          Manufacturing      Secaucus, NJ     27.0   \n",
       "1                            Information        Boston, MA    600.0   \n",
       "2                          Manufacturing    Cincinnati, OH     29.0   \n",
       "3                          Manufacturing    Kenilworth, NJ     15.0   \n",
       "4                           Construction   Albuquerque, NM      4.0   \n",
       "...                                  ...               ...      ...   \n",
       "28629  Health Care and Social Assistance        Joliet, IL    780.0   \n",
       "28630  Health Care and Social Assistance      Hillside, IL    940.0   \n",
       "28631                      Manufacturing          York, PA     60.0   \n",
       "28632               Educational Services       Gahanna, OH      6.0   \n",
       "28633  Health Care and Social Assistance  New Rochelle, NY    225.0   \n",
       "\n",
       "      Start Date  End Date  Duration  Unnamed: 12  Unnamed: 13  Unnamed: 14  \n",
       "0        2/25/84   3/15/84       NaN          NaN          NaN          NaN  \n",
       "1         2/9/84    2/9/84       NaN          NaN          NaN          NaN  \n",
       "2        1/25/84   7/19/84       NaN          NaN          NaN          NaN  \n",
       "3       11/28/83   3/27/84       NaN          NaN          NaN          NaN  \n",
       "4        5/21/84    9/5/84       NaN          NaN          NaN          NaN  \n",
       "...          ...       ...       ...          ...          ...          ...  \n",
       "28629     7/4/20   7/22/20      19.0          NaN          NaN          NaN  \n",
       "28630   11/23/20       NaN       9.0          NaN          NaN          NaN  \n",
       "28631    9/28/20       NaN      98.0          NaN          NaN          NaN  \n",
       "28632   10/13/20  10/18/20       6.0          NaN          NaN          NaN  \n",
       "28633    12/1/20  12/11/20      11.0          NaN          NaN          NaN  \n",
       "\n",
       "[28634 rows x 15 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "strike_df = pd.read_csv(\"work_stoppages-7b69492.csv\")\n",
    "strike_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "2b7f4ad8-064e-4346-8b82-e7fda6f424c4",
   "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>Employer</th>\n",
       "      <th>Union</th>\n",
       "      <th>Union Local</th>\n",
       "      <th>Case Number</th>\n",
       "      <th>BU</th>\n",
       "      <th>NAICS</th>\n",
       "      <th>Industry</th>\n",
       "      <th>City, State</th>\n",
       "      <th># Idled</th>\n",
       "      <th>Start Date</th>\n",
       "      <th>End Date</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Unnamed: 12</th>\n",
       "      <th>Unnamed: 13</th>\n",
       "      <th>Unnamed: 14</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Interstate Paper Converting Corp</td>\n",
       "      <td>USA 13058</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1984AA00L294</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Manufacturing</td>\n",
       "      <td>Secaucus, NJ</td>\n",
       "      <td>27.0</td>\n",
       "      <td>1984-02-25</td>\n",
       "      <td>1984-03-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Wgbh Educational Foundation, Wgbh Tv</td>\n",
       "      <td>NABET 18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1984AA00L307</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Information</td>\n",
       "      <td>Boston, MA</td>\n",
       "      <td>600.0</td>\n",
       "      <td>1984-02-09</td>\n",
       "      <td>1984-02-09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Nielsen Lithographing Co</td>\n",
       "      <td>GCIU 508</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1984AA00L324</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Manufacturing</td>\n",
       "      <td>Cincinnati, OH</td>\n",
       "      <td>29.0</td>\n",
       "      <td>1984-01-25</td>\n",
       "      <td>1984-07-19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Newark Metal Products</td>\n",
       "      <td>LIUNA 734</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1984AA00L339</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Manufacturing</td>\n",
       "      <td>Kenilworth, NJ</td>\n",
       "      <td>15.0</td>\n",
       "      <td>1983-11-28</td>\n",
       "      <td>1984-03-27</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Universal Construction Inc</td>\n",
       "      <td>IBT 492</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1984AA00L359</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Construction</td>\n",
       "      <td>Albuquerque, NM</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1984-05-21</td>\n",
       "      <td>1984-09-05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                               Employer      Union Union Local   Case Number  \\\n",
       "0      Interstate Paper Converting Corp  USA 13058         NaN  1984AA00L294   \n",
       "1  Wgbh Educational Foundation, Wgbh Tv   NABET 18         NaN  1984AA00L307   \n",
       "2              Nielsen Lithographing Co   GCIU 508         NaN  1984AA00L324   \n",
       "3                 Newark Metal Products  LIUNA 734         NaN  1984AA00L339   \n",
       "4            Universal Construction Inc    IBT 492         NaN  1984AA00L359   \n",
       "\n",
       "   BU  NAICS       Industry      City, State  # Idled Start Date   End Date  \\\n",
       "0 NaN    NaN  Manufacturing     Secaucus, NJ     27.0 1984-02-25 1984-03-15   \n",
       "1 NaN    NaN    Information       Boston, MA    600.0 1984-02-09 1984-02-09   \n",
       "2 NaN    NaN  Manufacturing   Cincinnati, OH     29.0 1984-01-25 1984-07-19   \n",
       "3 NaN    NaN  Manufacturing   Kenilworth, NJ     15.0 1983-11-28 1984-03-27   \n",
       "4 NaN    NaN   Construction  Albuquerque, NM      4.0 1984-05-21 1984-09-05   \n",
       "\n",
       "   Duration  Unnamed: 12  Unnamed: 13  Unnamed: 14  \n",
       "0       NaN          NaN          NaN          NaN  \n",
       "1       NaN          NaN          NaN          NaN  \n",
       "2       NaN          NaN          NaN          NaN  \n",
       "3       NaN          NaN          NaN          NaN  \n",
       "4       NaN          NaN          NaN          NaN  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "strike_df['Start Date']= pd.to_datetime(strike_df['Start Date'])\n",
    "strike_df['End Date']= pd.to_datetime(strike_df['End Date'])\n",
    "strike_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "1f0d9313-bf0a-4c48-ad29-0b0c8fa2cb48",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Start Date</th>\n",
       "      <th>End Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1045</th>\n",
       "      <td>1985-06-27</td>\n",
       "      <td>NaT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1220</th>\n",
       "      <td>1985-03-11</td>\n",
       "      <td>NaT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6005</th>\n",
       "      <td>1990-03-01</td>\n",
       "      <td>NaT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6206</th>\n",
       "      <td>1990-10-14</td>\n",
       "      <td>NaT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6207</th>\n",
       "      <td>1990-10-14</td>\n",
       "      <td>NaT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28622</th>\n",
       "      <td>2020-10-26</td>\n",
       "      <td>NaT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28626</th>\n",
       "      <td>2020-12-16</td>\n",
       "      <td>NaT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28628</th>\n",
       "      <td>2020-08-23</td>\n",
       "      <td>NaT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28630</th>\n",
       "      <td>2020-11-23</td>\n",
       "      <td>NaT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28631</th>\n",
       "      <td>2020-09-28</td>\n",
       "      <td>NaT</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>170 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Start Date End Date\n",
       "1045  1985-06-27      NaT\n",
       "1220  1985-03-11      NaT\n",
       "6005  1990-03-01      NaT\n",
       "6206  1990-10-14      NaT\n",
       "6207  1990-10-14      NaT\n",
       "...          ...      ...\n",
       "28622 2020-10-26      NaT\n",
       "28626 2020-12-16      NaT\n",
       "28628 2020-08-23      NaT\n",
       "28630 2020-11-23      NaT\n",
       "28631 2020-09-28      NaT\n",
       "\n",
       "[170 rows x 2 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "strike_df['End Date']-strike_df['Start Date']\n",
    "strike_df.loc[(strike_df['End Date']-strike_df['Start Date']).isna(), ['Start Date','End Date']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "6fbed879-e7ce-4dc2-9122-efe6225e1040",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Youngstown, OH', ', '], dtype=object)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "strike_df.loc[strike_df['Employer']==\"Youngstown State University\",]['City, State'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "a3d84ee3-ee73-4432-b152-c799af7813f9",
   "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>Employer</th>\n",
       "      <th>Union</th>\n",
       "      <th>Union Local</th>\n",
       "      <th>Case Number</th>\n",
       "      <th>BU</th>\n",
       "      <th>NAICS</th>\n",
       "      <th>Industry</th>\n",
       "      <th>City, State</th>\n",
       "      <th># Idled</th>\n",
       "      <th>Start Date</th>\n",
       "      <th>End Date</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Unnamed: 12</th>\n",
       "      <th>Unnamed: 13</th>\n",
       "      <th>Unnamed: 14</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>12045</th>\n",
       "      <td>GLADMAN MENTAL HEALTH REHABILITATION CENTER</td>\n",
       "      <td>SEIU Local 250</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2004IP002195</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Health Care and Social Assistance</td>\n",
       "      <td>,</td>\n",
       "      <td>20.0</td>\n",
       "      <td>2005-06-20</td>\n",
       "      <td>2005-06-24</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13593</th>\n",
       "      <td>Lawrence and Memorial Hospital</td>\n",
       "      <td>AFT Local 5049</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.01311E+11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Health Care and Social Assistance</td>\n",
       "      <td>,</td>\n",
       "      <td>525.0</td>\n",
       "      <td>2013-11-27</td>\n",
       "      <td>2013-12-19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13700</th>\n",
       "      <td>Will County Circuit Court Clerk</td>\n",
       "      <td>AFSCME Local 1028</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.01411E+11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>County Government</td>\n",
       "      <td>,</td>\n",
       "      <td>125.0</td>\n",
       "      <td>2013-11-18</td>\n",
       "      <td>2013-12-04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13706</th>\n",
       "      <td>12th Judicial Circuit - Will County</td>\n",
       "      <td>AFSCME Local 1028</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.01411E+11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>County Government</td>\n",
       "      <td>,</td>\n",
       "      <td>50.0</td>\n",
       "      <td>2013-11-18</td>\n",
       "      <td>2013-12-05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13788</th>\n",
       "      <td>Sparks Steak House</td>\n",
       "      <td>UFCW Local 342</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0151E+11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Accommodation and Food Services</td>\n",
       "      <td>,</td>\n",
       "      <td>40.0</td>\n",
       "      <td>2014-12-14</td>\n",
       "      <td>2015-09-09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13791</th>\n",
       "      <td>Tommy Car Aoto Group</td>\n",
       "      <td>IAM District 15 Lodge</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.01511E+11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Retail Trade</td>\n",
       "      <td>,</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2014-11-05</td>\n",
       "      <td>2015-10-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13795</th>\n",
       "      <td>Verizon Mid-Atlantic (7)</td>\n",
       "      <td>CWA District 2-13 Local 2111</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0159E+11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Utilities</td>\n",
       "      <td>,</td>\n",
       "      <td>24093.0</td>\n",
       "      <td>2016-04-13</td>\n",
       "      <td>2016-06-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13797</th>\n",
       "      <td>Ready Mix Contractors</td>\n",
       "      <td>Belleville, Illinois &amp; IBT 50 Local</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0159E+11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Accommodation and Food Services</td>\n",
       "      <td>,</td>\n",
       "      <td>140.0</td>\n",
       "      <td>2015-07-16</td>\n",
       "      <td>2015-07-26</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13889</th>\n",
       "      <td>DATTCO BUS</td>\n",
       "      <td>SEIU Local 2001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.01611E+11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Transportation and Warehousing</td>\n",
       "      <td>,</td>\n",
       "      <td>102.0</td>\n",
       "      <td>2016-05-17</td>\n",
       "      <td>2016-05-17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13894</th>\n",
       "      <td>Greenleaf  Services, Inc. &amp; The Davey Tree Exp...</td>\n",
       "      <td>LIUNA Local 572</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.01612E+11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Personal Serv &amp; Private Organizations</td>\n",
       "      <td>,</td>\n",
       "      <td>60.0</td>\n",
       "      <td>2016-07-19</td>\n",
       "      <td>2016-10-18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13899</th>\n",
       "      <td>SMACNA</td>\n",
       "      <td>SMART 2 Local</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0169E+11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Accommodation and Food Services</td>\n",
       "      <td>,</td>\n",
       "      <td>147.0</td>\n",
       "      <td>2016-07-01</td>\n",
       "      <td>2016-07-06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13989</th>\n",
       "      <td>Aristacare at Delaire</td>\n",
       "      <td>SEIU (UHWE) 1199</td>\n",
       "      <td>1199</td>\n",
       "      <td>2.0171E+11</td>\n",
       "      <td>150.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>Health Care and Social Assistance</td>\n",
       "      <td>,</td>\n",
       "      <td>150.0</td>\n",
       "      <td>2018-01-15</td>\n",
       "      <td>2018-01-15</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13994</th>\n",
       "      <td>Berkshire Medical Center</td>\n",
       "      <td>MNA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.01711E+11</td>\n",
       "      <td>800.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>Health Care and Social Assistance</td>\n",
       "      <td>,</td>\n",
       "      <td>800.0</td>\n",
       "      <td>2017-10-03</td>\n",
       "      <td>2017-10-07</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14081</th>\n",
       "      <td>Four Roses Distillery LLC</td>\n",
       "      <td>UFCW AFL-CIO CLC 10D</td>\n",
       "      <td>10D</td>\n",
       "      <td>2.01812E+11</td>\n",
       "      <td>35.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>Accommodation and Food Services</td>\n",
       "      <td>,</td>\n",
       "      <td>25.0</td>\n",
       "      <td>2018-09-07</td>\n",
       "      <td>2018-09-21</td>\n",
       "      <td>15.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14082</th>\n",
       "      <td>Four Roses Distillery LLC</td>\n",
       "      <td>Firemen &amp; Oilers Union (NCFO District-32BJ/SEI...</td>\n",
       "      <td>320</td>\n",
       "      <td>2.01812E+11</td>\n",
       "      <td>6.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>Accommodation and Food Services</td>\n",
       "      <td>,</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2018-09-07</td>\n",
       "      <td>2018-09-21</td>\n",
       "      <td>15.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14084</th>\n",
       "      <td>Claymont City School Disrict</td>\n",
       "      <td>OAPSE 4</td>\n",
       "      <td>4</td>\n",
       "      <td>2.01812E+11</td>\n",
       "      <td>70.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>Educational Services</td>\n",
       "      <td>,</td>\n",
       "      <td>70.0</td>\n",
       "      <td>2019-03-22</td>\n",
       "      <td>2019-04-16</td>\n",
       "      <td>26.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14193</th>\n",
       "      <td>Four Seasons Nursing Center</td>\n",
       "      <td>SEIU Healthcare</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.01912E+11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>72.0</td>\n",
       "      <td>Accommodation and Food Services</td>\n",
       "      <td>,</td>\n",
       "      <td>50.0</td>\n",
       "      <td>2020-10-19</td>\n",
       "      <td>2020-10-20</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14276</th>\n",
       "      <td>Youngstown State University</td>\n",
       "      <td>Ohio Education Association</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.02012E+11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>61.0</td>\n",
       "      <td>Educational Services</td>\n",
       "      <td>,</td>\n",
       "      <td>400.0</td>\n",
       "      <td>2020-10-13</td>\n",
       "      <td>2020-10-16</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28306</th>\n",
       "      <td>Aristacare at Delaire</td>\n",
       "      <td>SEIU (UHWE) 1199</td>\n",
       "      <td>1199</td>\n",
       "      <td>2.0171E+11</td>\n",
       "      <td>150.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>Health Care and Social Assistance</td>\n",
       "      <td>,</td>\n",
       "      <td>150.0</td>\n",
       "      <td>2018-01-15</td>\n",
       "      <td>2018-01-15</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28311</th>\n",
       "      <td>Berkshire Medical Center</td>\n",
       "      <td>MNA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.01711E+11</td>\n",
       "      <td>800.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>Health Care and Social Assistance</td>\n",
       "      <td>,</td>\n",
       "      <td>800.0</td>\n",
       "      <td>2017-10-03</td>\n",
       "      <td>2017-10-07</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28398</th>\n",
       "      <td>Four Roses Distillery LLC</td>\n",
       "      <td>UFCW AFL-CIO CLC 10D</td>\n",
       "      <td>10D</td>\n",
       "      <td>2.01812E+11</td>\n",
       "      <td>35.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>Accommodation and Food Services</td>\n",
       "      <td>,</td>\n",
       "      <td>25.0</td>\n",
       "      <td>2018-09-07</td>\n",
       "      <td>2018-09-21</td>\n",
       "      <td>15.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28399</th>\n",
       "      <td>Four Roses Distillery LLC</td>\n",
       "      <td>Firemen &amp; Oilers Union (NCFO District-32BJ/SEI...</td>\n",
       "      <td>320</td>\n",
       "      <td>2.01812E+11</td>\n",
       "      <td>6.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>Accommodation and Food Services</td>\n",
       "      <td>,</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2018-09-07</td>\n",
       "      <td>2018-09-21</td>\n",
       "      <td>15.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28401</th>\n",
       "      <td>Claymont City School Disrict</td>\n",
       "      <td>OAPSE 4</td>\n",
       "      <td>4</td>\n",
       "      <td>2.01812E+11</td>\n",
       "      <td>70.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>Educational Services</td>\n",
       "      <td>,</td>\n",
       "      <td>70.0</td>\n",
       "      <td>2019-03-22</td>\n",
       "      <td>2019-04-16</td>\n",
       "      <td>26.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28510</th>\n",
       "      <td>Four Seasons Nursing Center</td>\n",
       "      <td>SEIU Healthcare</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.01912E+11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>72.0</td>\n",
       "      <td>Accommodation and Food Services</td>\n",
       "      <td>,</td>\n",
       "      <td>50.0</td>\n",
       "      <td>2020-10-19</td>\n",
       "      <td>2020-10-20</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28593</th>\n",
       "      <td>Youngstown State University</td>\n",
       "      <td>Ohio Education Association</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.02012E+11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>61.0</td>\n",
       "      <td>Educational Services</td>\n",
       "      <td>,</td>\n",
       "      <td>400.0</td>\n",
       "      <td>2020-10-13</td>\n",
       "      <td>2020-10-16</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                Employer  \\\n",
       "12045        GLADMAN MENTAL HEALTH REHABILITATION CENTER   \n",
       "13593                     Lawrence and Memorial Hospital   \n",
       "13700                    Will County Circuit Court Clerk   \n",
       "13706                12th Judicial Circuit - Will County   \n",
       "13788                                 Sparks Steak House   \n",
       "13791                               Tommy Car Aoto Group   \n",
       "13795                           Verizon Mid-Atlantic (7)   \n",
       "13797                              Ready Mix Contractors   \n",
       "13889                                         DATTCO BUS   \n",
       "13894  Greenleaf  Services, Inc. & The Davey Tree Exp...   \n",
       "13899                                            SMACNA    \n",
       "13989                              Aristacare at Delaire   \n",
       "13994                           Berkshire Medical Center   \n",
       "14081                          Four Roses Distillery LLC   \n",
       "14082                          Four Roses Distillery LLC   \n",
       "14084                       Claymont City School Disrict   \n",
       "14193                        Four Seasons Nursing Center   \n",
       "14276                        Youngstown State University   \n",
       "28306                              Aristacare at Delaire   \n",
       "28311                           Berkshire Medical Center   \n",
       "28398                          Four Roses Distillery LLC   \n",
       "28399                          Four Roses Distillery LLC   \n",
       "28401                       Claymont City School Disrict   \n",
       "28510                        Four Seasons Nursing Center   \n",
       "28593                        Youngstown State University   \n",
       "\n",
       "                                                   Union Union Local  \\\n",
       "12045                                     SEIU Local 250         NaN   \n",
       "13593                                     AFT Local 5049         NaN   \n",
       "13700                                  AFSCME Local 1028         NaN   \n",
       "13706                                  AFSCME Local 1028         NaN   \n",
       "13788                                     UFCW Local 342         NaN   \n",
       "13791                             IAM District 15 Lodge          NaN   \n",
       "13795                       CWA District 2-13 Local 2111         NaN   \n",
       "13797               Belleville, Illinois & IBT 50 Local          NaN   \n",
       "13889                                    SEIU Local 2001         NaN   \n",
       "13894                                    LIUNA Local 572         NaN   \n",
       "13899                                     SMART 2 Local          NaN   \n",
       "13989                                   SEIU (UHWE) 1199        1199   \n",
       "13994                                                MNA         NaN   \n",
       "14081                               UFCW AFL-CIO CLC 10D         10D   \n",
       "14082  Firemen & Oilers Union (NCFO District-32BJ/SEI...         320   \n",
       "14084                                            OAPSE 4           4   \n",
       "14193                                    SEIU Healthcare         NaN   \n",
       "14276                         Ohio Education Association         NaN   \n",
       "28306                                   SEIU (UHWE) 1199        1199   \n",
       "28311                                                MNA         NaN   \n",
       "28398                               UFCW AFL-CIO CLC 10D         10D   \n",
       "28399  Firemen & Oilers Union (NCFO District-32BJ/SEI...         320   \n",
       "28401                                            OAPSE 4           4   \n",
       "28510                                    SEIU Healthcare         NaN   \n",
       "28593                         Ohio Education Association         NaN   \n",
       "\n",
       "        Case Number     BU  NAICS                               Industry  \\\n",
       "12045  2004IP002195    NaN    NaN      Health Care and Social Assistance   \n",
       "13593   2.01311E+11    NaN    NaN      Health Care and Social Assistance   \n",
       "13700   2.01411E+11    NaN    NaN                      County Government   \n",
       "13706   2.01411E+11    NaN    NaN                      County Government   \n",
       "13788    2.0151E+11    NaN    NaN        Accommodation and Food Services   \n",
       "13791   2.01511E+11    NaN    NaN                           Retail Trade   \n",
       "13795    2.0159E+11    NaN    NaN                              Utilities   \n",
       "13797    2.0159E+11    NaN    NaN        Accommodation and Food Services   \n",
       "13889   2.01611E+11    NaN    NaN         Transportation and Warehousing   \n",
       "13894   2.01612E+11    NaN    NaN  Personal Serv & Private Organizations   \n",
       "13899    2.0169E+11    NaN    NaN        Accommodation and Food Services   \n",
       "13989    2.0171E+11  150.0   62.0      Health Care and Social Assistance   \n",
       "13994   2.01711E+11  800.0   62.0      Health Care and Social Assistance   \n",
       "14081   2.01812E+11   35.0   72.0        Accommodation and Food Services   \n",
       "14082   2.01812E+11    6.0   72.0        Accommodation and Food Services   \n",
       "14084   2.01812E+11   70.0   61.0                   Educational Services   \n",
       "14193   2.01912E+11    NaN   72.0        Accommodation and Food Services   \n",
       "14276   2.02012E+11    NaN   61.0                   Educational Services   \n",
       "28306    2.0171E+11  150.0   62.0      Health Care and Social Assistance   \n",
       "28311   2.01711E+11  800.0   62.0      Health Care and Social Assistance   \n",
       "28398   2.01812E+11   35.0   72.0        Accommodation and Food Services   \n",
       "28399   2.01812E+11    6.0   72.0        Accommodation and Food Services   \n",
       "28401   2.01812E+11   70.0   61.0                   Educational Services   \n",
       "28510   2.01912E+11    NaN   72.0        Accommodation and Food Services   \n",
       "28593   2.02012E+11    NaN   61.0                   Educational Services   \n",
       "\n",
       "      City, State  # Idled Start Date   End Date  Duration  Unnamed: 12  \\\n",
       "12045          ,      20.0 2005-06-20 2005-06-24       NaN          NaN   \n",
       "13593          ,     525.0 2013-11-27 2013-12-19       NaN          NaN   \n",
       "13700          ,     125.0 2013-11-18 2013-12-04       NaN          NaN   \n",
       "13706          ,      50.0 2013-11-18 2013-12-05       NaN          NaN   \n",
       "13788          ,      40.0 2014-12-14 2015-09-09       NaN          NaN   \n",
       "13791          ,      10.0 2014-11-05 2015-10-01       NaN          NaN   \n",
       "13795          ,   24093.0 2016-04-13 2016-06-01       NaN          NaN   \n",
       "13797          ,     140.0 2015-07-16 2015-07-26       NaN          NaN   \n",
       "13889          ,     102.0 2016-05-17 2016-05-17       NaN          NaN   \n",
       "13894          ,      60.0 2016-07-19 2016-10-18       NaN          NaN   \n",
       "13899          ,     147.0 2016-07-01 2016-07-06       NaN          NaN   \n",
       "13989          ,     150.0 2018-01-15 2018-01-15       1.0          NaN   \n",
       "13994          ,     800.0 2017-10-03 2017-10-07       5.0          NaN   \n",
       "14081          ,      25.0 2018-09-07 2018-09-21      15.0          NaN   \n",
       "14082          ,       6.0 2018-09-07 2018-09-21      15.0          NaN   \n",
       "14084          ,      70.0 2019-03-22 2019-04-16      26.0          NaN   \n",
       "14193          ,      50.0 2020-10-19 2020-10-20       2.0          NaN   \n",
       "14276          ,     400.0 2020-10-13 2020-10-16       4.0          NaN   \n",
       "28306          ,     150.0 2018-01-15 2018-01-15       1.0          NaN   \n",
       "28311          ,     800.0 2017-10-03 2017-10-07       5.0          NaN   \n",
       "28398          ,      25.0 2018-09-07 2018-09-21      15.0          NaN   \n",
       "28399          ,       6.0 2018-09-07 2018-09-21      15.0          NaN   \n",
       "28401          ,      70.0 2019-03-22 2019-04-16      26.0          NaN   \n",
       "28510          ,      50.0 2020-10-19 2020-10-20       2.0          NaN   \n",
       "28593          ,     400.0 2020-10-13 2020-10-16       4.0          NaN   \n",
       "\n",
       "       Unnamed: 13  Unnamed: 14  \n",
       "12045          NaN          NaN  \n",
       "13593          NaN          NaN  \n",
       "13700          NaN          NaN  \n",
       "13706          NaN          NaN  \n",
       "13788          NaN          NaN  \n",
       "13791          NaN          NaN  \n",
       "13795          NaN          NaN  \n",
       "13797          NaN          NaN  \n",
       "13889          NaN          NaN  \n",
       "13894          NaN          NaN  \n",
       "13899          NaN          NaN  \n",
       "13989          NaN          NaN  \n",
       "13994          NaN          NaN  \n",
       "14081          NaN          NaN  \n",
       "14082          NaN          NaN  \n",
       "14084          NaN          NaN  \n",
       "14193          NaN          NaN  \n",
       "14276          NaN          NaN  \n",
       "28306          NaN          NaN  \n",
       "28311          NaN          NaN  \n",
       "28398          NaN          NaN  \n",
       "28399          NaN          NaN  \n",
       "28401          NaN          NaN  \n",
       "28510          NaN          NaN  \n",
       "28593          NaN          NaN  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "strike_df.loc[strike_df['City, State']==\", \",]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "c2092773-8700-485e-baa4-8ad4a3cec740",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Industry\n",
       "Accommodation and Food Services                 208\n",
       "Arts, Entertainment and Recreation               92\n",
       "Construction                                   2420\n",
       "County Government                                 6\n",
       "Educational Services                            448\n",
       "Federal Government                                4\n",
       "Federal, State or Local Government              886\n",
       "Finance and Insurance                             8\n",
       "Health Care and Social Assistance              2272\n",
       "Information                                     278\n",
       "Local Government                                 30\n",
       "Manufacturing                                 15486\n",
       "Mining and Oil & Gas Extraction                  42\n",
       "Mining, Quarrying and Oil & Gas Extraction      288\n",
       "Not Provided                                     48\n",
       "Not Specified                                     4\n",
       "Personal Serv & Private Organizations            38\n",
       "Professional, Scientific &Tech Serv              36\n",
       "Real Estate and Rental & Leasing                  6\n",
       "Retail Trade                                   4148\n",
       "State Government                                  4\n",
       "Support Serv. & Waste Management                300\n",
       "Transportation and Warehousing                 1078\n",
       "Utilities                                       332\n",
       "Wholesale Trade                                  30\n",
       "dtype: int64"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "strike_df.groupby(\"Industry\").size()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "9d1276f4-fbe8-4707-aabe-861e68f4c884",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Year</th>\n",
       "      <th>State</th>\n",
       "      <th>State.Minimum.Wage</th>\n",
       "      <th>State.Minimum.Wage.2020.Dollars</th>\n",
       "      <th>Federal.Minimum.Wage</th>\n",
       "      <th>Federal.Minimum.Wage.2020.Dollars</th>\n",
       "      <th>Effective.Minimum.Wage</th>\n",
       "      <th>Effective.Minimum.Wage.2020.Dollars</th>\n",
       "      <th>CPI.Average</th>\n",
       "      <th>Department.Of.Labor.Uncleaned.Data</th>\n",
       "      <th>Department.Of.Labor.Cleaned.Low.Value</th>\n",
       "      <th>Department.Of.Labor.Cleaned.Low.Value.2020.Dollars</th>\n",
       "      <th>Department.Of.Labor.Cleaned.High.Value</th>\n",
       "      <th>Department.Of.Labor.Cleaned.High.Value.2020.Dollars</th>\n",
       "      <th>Footnote</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1968</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.15</td>\n",
       "      <td>8.55</td>\n",
       "      <td>1.15</td>\n",
       "      <td>8.55</td>\n",
       "      <td>34.80</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1968</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>2.10000</td>\n",
       "      <td>15.61</td>\n",
       "      <td>1.15</td>\n",
       "      <td>8.55</td>\n",
       "      <td>2.10</td>\n",
       "      <td>15.61</td>\n",
       "      <td>34.80</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.10000</td>\n",
       "      <td>15.61</td>\n",
       "      <td>2.10000</td>\n",
       "      <td>15.61</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1968</td>\n",
       "      <td>Arizona</td>\n",
       "      <td>0.46800</td>\n",
       "      <td>3.48</td>\n",
       "      <td>1.15</td>\n",
       "      <td>8.55</td>\n",
       "      <td>1.15</td>\n",
       "      <td>8.55</td>\n",
       "      <td>34.80</td>\n",
       "      <td>18.72 - 26.40/wk(b)</td>\n",
       "      <td>0.46800</td>\n",
       "      <td>3.48</td>\n",
       "      <td>0.66000</td>\n",
       "      <td>4.91</td>\n",
       "      <td>(b)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1968</td>\n",
       "      <td>Arkansas</td>\n",
       "      <td>0.15625</td>\n",
       "      <td>1.16</td>\n",
       "      <td>1.15</td>\n",
       "      <td>8.55</td>\n",
       "      <td>1.15</td>\n",
       "      <td>8.55</td>\n",
       "      <td>34.80</td>\n",
       "      <td>1.25/day(b)</td>\n",
       "      <td>0.15625</td>\n",
       "      <td>1.16</td>\n",
       "      <td>0.15625</td>\n",
       "      <td>1.16</td>\n",
       "      <td>(b)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1968</td>\n",
       "      <td>California</td>\n",
       "      <td>1.65000</td>\n",
       "      <td>12.26</td>\n",
       "      <td>1.15</td>\n",
       "      <td>8.55</td>\n",
       "      <td>1.65</td>\n",
       "      <td>12.26</td>\n",
       "      <td>34.80</td>\n",
       "      <td>1.65(b)</td>\n",
       "      <td>1.65000</td>\n",
       "      <td>12.26</td>\n",
       "      <td>1.65000</td>\n",
       "      <td>12.26</td>\n",
       "      <td>(b)</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2857</th>\n",
       "      <td>2020</td>\n",
       "      <td>Virginia</td>\n",
       "      <td>7.25000</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>258.66</td>\n",
       "      <td>7.25[c]</td>\n",
       "      <td>7.25000</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25000</td>\n",
       "      <td>7.25</td>\n",
       "      <td>[c]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2858</th>\n",
       "      <td>2020</td>\n",
       "      <td>Washington</td>\n",
       "      <td>13.50000</td>\n",
       "      <td>13.50</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>13.50</td>\n",
       "      <td>13.50</td>\n",
       "      <td>258.66</td>\n",
       "      <td>13.5</td>\n",
       "      <td>13.50000</td>\n",
       "      <td>13.50</td>\n",
       "      <td>13.50000</td>\n",
       "      <td>13.50</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2859</th>\n",
       "      <td>2020</td>\n",
       "      <td>West Virginia</td>\n",
       "      <td>8.75000</td>\n",
       "      <td>8.75</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>8.75</td>\n",
       "      <td>8.75</td>\n",
       "      <td>258.66</td>\n",
       "      <td>8.75</td>\n",
       "      <td>8.75000</td>\n",
       "      <td>8.75</td>\n",
       "      <td>8.75000</td>\n",
       "      <td>8.75</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2860</th>\n",
       "      <td>2020</td>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>7.25000</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>258.66</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25000</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25000</td>\n",
       "      <td>7.25</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2861</th>\n",
       "      <td>2020</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>5.15000</td>\n",
       "      <td>5.15</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>258.66</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.15000</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.15000</td>\n",
       "      <td>5.15</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2862 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Year          State  State.Minimum.Wage  \\\n",
       "0     1968        Alabama             0.00000   \n",
       "1     1968         Alaska             2.10000   \n",
       "2     1968        Arizona             0.46800   \n",
       "3     1968       Arkansas             0.15625   \n",
       "4     1968     California             1.65000   \n",
       "...    ...            ...                 ...   \n",
       "2857  2020       Virginia             7.25000   \n",
       "2858  2020     Washington            13.50000   \n",
       "2859  2020  West Virginia             8.75000   \n",
       "2860  2020      Wisconsin             7.25000   \n",
       "2861  2020        Wyoming             5.15000   \n",
       "\n",
       "      State.Minimum.Wage.2020.Dollars  Federal.Minimum.Wage  \\\n",
       "0                                0.00                  1.15   \n",
       "1                               15.61                  1.15   \n",
       "2                                3.48                  1.15   \n",
       "3                                1.16                  1.15   \n",
       "4                               12.26                  1.15   \n",
       "...                               ...                   ...   \n",
       "2857                             7.25                  7.25   \n",
       "2858                            13.50                  7.25   \n",
       "2859                             8.75                  7.25   \n",
       "2860                             7.25                  7.25   \n",
       "2861                             5.15                  7.25   \n",
       "\n",
       "      Federal.Minimum.Wage.2020.Dollars  Effective.Minimum.Wage  \\\n",
       "0                                  8.55                    1.15   \n",
       "1                                  8.55                    2.10   \n",
       "2                                  8.55                    1.15   \n",
       "3                                  8.55                    1.15   \n",
       "4                                  8.55                    1.65   \n",
       "...                                 ...                     ...   \n",
       "2857                               7.25                    7.25   \n",
       "2858                               7.25                   13.50   \n",
       "2859                               7.25                    8.75   \n",
       "2860                               7.25                    7.25   \n",
       "2861                               7.25                    7.25   \n",
       "\n",
       "      Effective.Minimum.Wage.2020.Dollars  CPI.Average  \\\n",
       "0                                    8.55        34.80   \n",
       "1                                   15.61        34.80   \n",
       "2                                    8.55        34.80   \n",
       "3                                    8.55        34.80   \n",
       "4                                   12.26        34.80   \n",
       "...                                   ...          ...   \n",
       "2857                                 7.25       258.66   \n",
       "2858                                13.50       258.66   \n",
       "2859                                 8.75       258.66   \n",
       "2860                                 7.25       258.66   \n",
       "2861                                 7.25       258.66   \n",
       "\n",
       "     Department.Of.Labor.Uncleaned.Data  \\\n",
       "0                                   ...   \n",
       "1                                   2.1   \n",
       "2                   18.72 - 26.40/wk(b)   \n",
       "3                           1.25/day(b)   \n",
       "4                               1.65(b)   \n",
       "...                                 ...   \n",
       "2857                            7.25[c]   \n",
       "2858                               13.5   \n",
       "2859                               8.75   \n",
       "2860                               7.25   \n",
       "2861                               5.15   \n",
       "\n",
       "      Department.Of.Labor.Cleaned.Low.Value  \\\n",
       "0                                   0.00000   \n",
       "1                                   2.10000   \n",
       "2                                   0.46800   \n",
       "3                                   0.15625   \n",
       "4                                   1.65000   \n",
       "...                                     ...   \n",
       "2857                                7.25000   \n",
       "2858                               13.50000   \n",
       "2859                                8.75000   \n",
       "2860                                7.25000   \n",
       "2861                                5.15000   \n",
       "\n",
       "      Department.Of.Labor.Cleaned.Low.Value.2020.Dollars  \\\n",
       "0                                                  0.00    \n",
       "1                                                 15.61    \n",
       "2                                                  3.48    \n",
       "3                                                  1.16    \n",
       "4                                                 12.26    \n",
       "...                                                 ...    \n",
       "2857                                               7.25    \n",
       "2858                                              13.50    \n",
       "2859                                               8.75    \n",
       "2860                                               7.25    \n",
       "2861                                               5.15    \n",
       "\n",
       "      Department.Of.Labor.Cleaned.High.Value  \\\n",
       "0                                    0.00000   \n",
       "1                                    2.10000   \n",
       "2                                    0.66000   \n",
       "3                                    0.15625   \n",
       "4                                    1.65000   \n",
       "...                                      ...   \n",
       "2857                                 7.25000   \n",
       "2858                                13.50000   \n",
       "2859                                 8.75000   \n",
       "2860                                 7.25000   \n",
       "2861                                 5.15000   \n",
       "\n",
       "      Department.Of.Labor.Cleaned.High.Value.2020.Dollars Footnote  \n",
       "0                                                  0.00        NaN  \n",
       "1                                                 15.61        NaN  \n",
       "2                                                  4.91        (b)  \n",
       "3                                                  1.16        (b)  \n",
       "4                                                 12.26        (b)  \n",
       "...                                                 ...        ...  \n",
       "2857                                               7.25        [c]  \n",
       "2858                                              13.50        NaN  \n",
       "2859                                               8.75        NaN  \n",
       "2860                                               7.25        NaN  \n",
       "2861                                               5.15        NaN  \n",
       "\n",
       "[2862 rows x 15 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "min_wages = pd.read_csv(\"min_wage.csv\",encoding='cp1252')\n",
    "min_wages"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "d37b19a6-88dd-4766-9c6a-de3f1c502dc2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Year</th>\n",
       "      <th>State</th>\n",
       "      <th>State.Minimum.Wage</th>\n",
       "      <th>State.Minimum.Wage.2020.Dollars</th>\n",
       "      <th>Federal.Minimum.Wage</th>\n",
       "      <th>Federal.Minimum.Wage.2020.Dollars</th>\n",
       "      <th>Effective.Minimum.Wage</th>\n",
       "      <th>Effective.Minimum.Wage.2020.Dollars</th>\n",
       "      <th>CPI.Average</th>\n",
       "      <th>Department.Of.Labor.Uncleaned.Data</th>\n",
       "      <th>Department.Of.Labor.Cleaned.Low.Value</th>\n",
       "      <th>Department.Of.Labor.Cleaned.Low.Value.2020.Dollars</th>\n",
       "      <th>Department.Of.Labor.Cleaned.High.Value</th>\n",
       "      <th>Department.Of.Labor.Cleaned.High.Value.2020.Dollars</th>\n",
       "      <th>Footnote</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1352</th>\n",
       "      <td>1993</td>\n",
       "      <td>Arizona</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>144.50</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1353</th>\n",
       "      <td>1993</td>\n",
       "      <td>Arkansas</td>\n",
       "      <td>3.65</td>\n",
       "      <td>6.53</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>144.50</td>\n",
       "      <td>3.65</td>\n",
       "      <td>3.65</td>\n",
       "      <td>6.53</td>\n",
       "      <td>3.65</td>\n",
       "      <td>6.53</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1354</th>\n",
       "      <td>1993</td>\n",
       "      <td>California</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>144.50</td>\n",
       "      <td>4.25</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1355</th>\n",
       "      <td>1993</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>3.00</td>\n",
       "      <td>5.37</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>144.50</td>\n",
       "      <td>3</td>\n",
       "      <td>3.00</td>\n",
       "      <td>5.37</td>\n",
       "      <td>3.00</td>\n",
       "      <td>5.37</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1356</th>\n",
       "      <td>1993</td>\n",
       "      <td>Connecticut</td>\n",
       "      <td>4.27</td>\n",
       "      <td>7.64</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>4.27</td>\n",
       "      <td>7.64</td>\n",
       "      <td>144.50</td>\n",
       "      <td>4.27</td>\n",
       "      <td>4.27</td>\n",
       "      <td>7.64</td>\n",
       "      <td>4.27</td>\n",
       "      <td>7.64</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2851</th>\n",
       "      <td>2020</td>\n",
       "      <td>South Dakota</td>\n",
       "      <td>9.30</td>\n",
       "      <td>9.30</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>9.30</td>\n",
       "      <td>9.30</td>\n",
       "      <td>258.66</td>\n",
       "      <td>9.3</td>\n",
       "      <td>9.30</td>\n",
       "      <td>9.30</td>\n",
       "      <td>9.30</td>\n",
       "      <td>9.30</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2856</th>\n",
       "      <td>2020</td>\n",
       "      <td>Vermont</td>\n",
       "      <td>10.96</td>\n",
       "      <td>10.96</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>10.96</td>\n",
       "      <td>10.96</td>\n",
       "      <td>258.66</td>\n",
       "      <td>10.96(e)</td>\n",
       "      <td>10.96</td>\n",
       "      <td>10.96</td>\n",
       "      <td>10.96</td>\n",
       "      <td>10.96</td>\n",
       "      <td>(e)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2858</th>\n",
       "      <td>2020</td>\n",
       "      <td>Washington</td>\n",
       "      <td>13.50</td>\n",
       "      <td>13.50</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>13.50</td>\n",
       "      <td>13.50</td>\n",
       "      <td>258.66</td>\n",
       "      <td>13.5</td>\n",
       "      <td>13.50</td>\n",
       "      <td>13.50</td>\n",
       "      <td>13.50</td>\n",
       "      <td>13.50</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2859</th>\n",
       "      <td>2020</td>\n",
       "      <td>West Virginia</td>\n",
       "      <td>8.75</td>\n",
       "      <td>8.75</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>8.75</td>\n",
       "      <td>8.75</td>\n",
       "      <td>258.66</td>\n",
       "      <td>8.75</td>\n",
       "      <td>8.75</td>\n",
       "      <td>8.75</td>\n",
       "      <td>8.75</td>\n",
       "      <td>8.75</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2860</th>\n",
       "      <td>2020</td>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>258.66</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>952 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Year          State  State.Minimum.Wage  \\\n",
       "1352  1993        Arizona                0.00   \n",
       "1353  1993       Arkansas                3.65   \n",
       "1354  1993     California                4.25   \n",
       "1355  1993       Colorado                3.00   \n",
       "1356  1993    Connecticut                4.27   \n",
       "...    ...            ...                 ...   \n",
       "2851  2020   South Dakota                9.30   \n",
       "2856  2020        Vermont               10.96   \n",
       "2858  2020     Washington               13.50   \n",
       "2859  2020  West Virginia                8.75   \n",
       "2860  2020      Wisconsin                7.25   \n",
       "\n",
       "      State.Minimum.Wage.2020.Dollars  Federal.Minimum.Wage  \\\n",
       "1352                             0.00                  4.25   \n",
       "1353                             6.53                  4.25   \n",
       "1354                             7.61                  4.25   \n",
       "1355                             5.37                  4.25   \n",
       "1356                             7.64                  4.25   \n",
       "...                               ...                   ...   \n",
       "2851                             9.30                  7.25   \n",
       "2856                            10.96                  7.25   \n",
       "2858                            13.50                  7.25   \n",
       "2859                             8.75                  7.25   \n",
       "2860                             7.25                  7.25   \n",
       "\n",
       "      Federal.Minimum.Wage.2020.Dollars  Effective.Minimum.Wage  \\\n",
       "1352                               7.61                    4.25   \n",
       "1353                               7.61                    4.25   \n",
       "1354                               7.61                    4.25   \n",
       "1355                               7.61                    4.25   \n",
       "1356                               7.61                    4.27   \n",
       "...                                 ...                     ...   \n",
       "2851                               7.25                    9.30   \n",
       "2856                               7.25                   10.96   \n",
       "2858                               7.25                   13.50   \n",
       "2859                               7.25                    8.75   \n",
       "2860                               7.25                    7.25   \n",
       "\n",
       "      Effective.Minimum.Wage.2020.Dollars  CPI.Average  \\\n",
       "1352                                 7.61       144.50   \n",
       "1353                                 7.61       144.50   \n",
       "1354                                 7.61       144.50   \n",
       "1355                                 7.61       144.50   \n",
       "1356                                 7.64       144.50   \n",
       "...                                   ...          ...   \n",
       "2851                                 9.30       258.66   \n",
       "2856                                10.96       258.66   \n",
       "2858                                13.50       258.66   \n",
       "2859                                 8.75       258.66   \n",
       "2860                                 7.25       258.66   \n",
       "\n",
       "     Department.Of.Labor.Uncleaned.Data  \\\n",
       "1352                                ...   \n",
       "1353                               3.65   \n",
       "1354                               4.25   \n",
       "1355                                  3   \n",
       "1356                               4.27   \n",
       "...                                 ...   \n",
       "2851                                9.3   \n",
       "2856                           10.96(e)   \n",
       "2858                               13.5   \n",
       "2859                               8.75   \n",
       "2860                               7.25   \n",
       "\n",
       "      Department.Of.Labor.Cleaned.Low.Value  \\\n",
       "1352                                   0.00   \n",
       "1353                                   3.65   \n",
       "1354                                   4.25   \n",
       "1355                                   3.00   \n",
       "1356                                   4.27   \n",
       "...                                     ...   \n",
       "2851                                   9.30   \n",
       "2856                                  10.96   \n",
       "2858                                  13.50   \n",
       "2859                                   8.75   \n",
       "2860                                   7.25   \n",
       "\n",
       "      Department.Of.Labor.Cleaned.Low.Value.2020.Dollars  \\\n",
       "1352                                               0.00    \n",
       "1353                                               6.53    \n",
       "1354                                               7.61    \n",
       "1355                                               5.37    \n",
       "1356                                               7.64    \n",
       "...                                                 ...    \n",
       "2851                                               9.30    \n",
       "2856                                              10.96    \n",
       "2858                                              13.50    \n",
       "2859                                               8.75    \n",
       "2860                                               7.25    \n",
       "\n",
       "      Department.Of.Labor.Cleaned.High.Value  \\\n",
       "1352                                    0.00   \n",
       "1353                                    3.65   \n",
       "1354                                    4.25   \n",
       "1355                                    3.00   \n",
       "1356                                    4.27   \n",
       "...                                      ...   \n",
       "2851                                    9.30   \n",
       "2856                                   10.96   \n",
       "2858                                   13.50   \n",
       "2859                                    8.75   \n",
       "2860                                    7.25   \n",
       "\n",
       "      Department.Of.Labor.Cleaned.High.Value.2020.Dollars Footnote  \n",
       "1352                                               0.00        NaN  \n",
       "1353                                               6.53        NaN  \n",
       "1354                                               7.61        NaN  \n",
       "1355                                               5.37        NaN  \n",
       "1356                                               7.64        NaN  \n",
       "...                                                 ...        ...  \n",
       "2851                                               9.30        NaN  \n",
       "2856                                              10.96        (e)  \n",
       "2858                                              13.50        NaN  \n",
       "2859                                               8.75        NaN  \n",
       "2860                                               7.25        NaN  \n",
       "\n",
       "[952 rows x 15 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "min_wages = min_wages[min_wages['Year']>=1993]\n",
    "min_wages[min_wages['State'].isin(\n",
    "    ['Connecticut', 'Iowa', 'Oregon', 'Rhode Island', 'Hawaii', 'New Jersey', 'Delaware',\n",
    "     'Massachusetts', 'Vermont', 'Washington',\n",
    "       'California', 'Maine', 'Illinois', 'New York', 'Florida',\n",
    "       'Minnesota', 'Wisconsin', 'Arizona', 'Arkansas', 'Colorado',\n",
    "       'Maryland', 'Michigan', 'Missouri', 'Nevada', 'North Carolina',\n",
    "       'Ohio', 'Pennsylvania', 'West Virginia', 'New Hampshire',\n",
    "       'New Mexico', 'Montana', 'Guam', 'Nebraska', 'South Dakota'])]\n",
    "#min_wages[min_wages['Effective.Minimum.Wage'] > min_wages['Federal.Minimum.Wage']]['State'].unique()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "8676b33b-4756-45fb-8ac1-088e9f1f2600",
   "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>Organizations involved</th>\n",
       "      <th>States</th>\n",
       "      <th>Areas</th>\n",
       "      <th>Ownership</th>\n",
       "      <th>Industry code[1]</th>\n",
       "      <th>Union</th>\n",
       "      <th>Union acronym</th>\n",
       "      <th>Union Local</th>\n",
       "      <th>Bargaining unit</th>\n",
       "      <th>Work stoppage beginning date</th>\n",
       "      <th>Work stoppage ending date</th>\n",
       "      <th>Number of workers[2]</th>\n",
       "      <th>Days idle, cumulative for this work stoppage[3]</th>\n",
       "      <th>Note</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Marine Towing and Transportation Employers' As...</td>\n",
       "      <td>NY</td>\n",
       "      <td>New York</td>\n",
       "      <td>Private industry</td>\n",
       "      <td>488330</td>\n",
       "      <td>International Longshoremen's Association</td>\n",
       "      <td>ILA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1988-02-16</td>\n",
       "      <td>1993-12-20</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>2879500.0</td>\n",
       "      <td>The number of workers decreased to 2,000 in De...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Boeing Company</td>\n",
       "      <td>WA</td>\n",
       "      <td>Seattle</td>\n",
       "      <td>Private industry</td>\n",
       "      <td>336411</td>\n",
       "      <td>Seattle Professional Engineering Employees Ass...</td>\n",
       "      <td>SPEEA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1993-01-19</td>\n",
       "      <td>1993-01-19</td>\n",
       "      <td>21000.0</td>\n",
       "      <td>21000.0</td>\n",
       "      <td>The union name was changed to the Society of P...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Boston Gas Company</td>\n",
       "      <td>MA</td>\n",
       "      <td>Boston</td>\n",
       "      <td>Private industry</td>\n",
       "      <td>22121</td>\n",
       "      <td>United Steelworkers</td>\n",
       "      <td>USW</td>\n",
       "      <td>12003</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1993-01-24</td>\n",
       "      <td>1993-05-20</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>83000.0</td>\n",
       "      <td>Boston Gas Company also does business as \"Nati...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Bituminous Coal Operators Association</td>\n",
       "      <td>IN, IL, KY, WV</td>\n",
       "      <td>Multiple states</td>\n",
       "      <td>Private industry</td>\n",
       "      <td>212112</td>\n",
       "      <td>United Mine Workers of America</td>\n",
       "      <td>UMWA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1993-02-02</td>\n",
       "      <td>1993-03-02</td>\n",
       "      <td>6700.0</td>\n",
       "      <td>103400.0</td>\n",
       "      <td>Number of workers involved increased from 5,00...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Douglas Aircraft</td>\n",
       "      <td>CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Private industry</td>\n",
       "      <td>336411</td>\n",
       "      <td>International Association of Machinists</td>\n",
       "      <td>IAM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1993-03-02</td>\n",
       "      <td>1993-03-03</td>\n",
       "      <td>6800.0</td>\n",
       "      <td>13600.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                              Organizations involved          States  \\\n",
       "0  Marine Towing and Transportation Employers' As...              NY   \n",
       "1                                     Boeing Company              WA   \n",
       "2                                 Boston Gas Company              MA   \n",
       "3              Bituminous Coal Operators Association  IN, IL, KY, WV   \n",
       "4                                   Douglas Aircraft              CA   \n",
       "\n",
       "             Areas         Ownership Industry code[1]  \\\n",
       "0         New York  Private industry           488330   \n",
       "1          Seattle  Private industry           336411   \n",
       "2           Boston  Private industry            22121   \n",
       "3  Multiple states  Private industry           212112   \n",
       "4              NaN  Private industry           336411   \n",
       "\n",
       "                                               Union Union acronym  \\\n",
       "0           International Longshoremen's Association           ILA   \n",
       "1  Seattle Professional Engineering Employees Ass...         SPEEA   \n",
       "2                                United Steelworkers           USW   \n",
       "3                     United Mine Workers of America          UMWA   \n",
       "4            International Association of Machinists           IAM   \n",
       "\n",
       "  Union Local Bargaining unit Work stoppage beginning date  \\\n",
       "0         NaN             NaN                   1988-02-16   \n",
       "1         NaN             NaN                   1993-01-19   \n",
       "2       12003             NaN                   1993-01-24   \n",
       "3         NaN             NaN                   1993-02-02   \n",
       "4         NaN             NaN                   1993-03-02   \n",
       "\n",
       "  Work stoppage ending date  Number of workers[2]  \\\n",
       "0                1993-12-20                2500.0   \n",
       "1                1993-01-19               21000.0   \n",
       "2                1993-05-20                1000.0   \n",
       "3                1993-03-02                6700.0   \n",
       "4                1993-03-03                6800.0   \n",
       "\n",
       "   Days idle, cumulative for this work stoppage[3]  \\\n",
       "0                                        2879500.0   \n",
       "1                                          21000.0   \n",
       "2                                          83000.0   \n",
       "3                                         103400.0   \n",
       "4                                          13600.0   \n",
       "\n",
       "                                                Note  \n",
       "0  The number of workers decreased to 2,000 in De...  \n",
       "1  The union name was changed to the Society of P...  \n",
       "2  Boston Gas Company also does business as \"Nati...  \n",
       "3  Number of workers involved increased from 5,00...  \n",
       "4                                                NaN  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bls_df = pd.read_excel(\"monthly-listing-3.xlsx\",header=1)\n",
    "bls_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "24783f03-923f-4e7f-9857-571a4149c756",
   "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>Organizations involved</th>\n",
       "      <th>States</th>\n",
       "      <th>Areas</th>\n",
       "      <th>Ownership</th>\n",
       "      <th>Industry code[1]</th>\n",
       "      <th>Union</th>\n",
       "      <th>Union acronym</th>\n",
       "      <th>Union Local</th>\n",
       "      <th>Bargaining unit</th>\n",
       "      <th>Work stoppage beginning date</th>\n",
       "      <th>Work stoppage ending date</th>\n",
       "      <th>Number of workers[2]</th>\n",
       "      <th>Days idle, cumulative for this work stoppage[3]</th>\n",
       "      <th>Note</th>\n",
       "      <th>NAICS_col</th>\n",
       "      <th>start_year</th>\n",
       "      <th>end_year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Marine Towing and Transportation Employers' As...</td>\n",
       "      <td>NY</td>\n",
       "      <td>New York</td>\n",
       "      <td>Private industry</td>\n",
       "      <td>488330</td>\n",
       "      <td>International Longshoremen's Association</td>\n",
       "      <td>ILA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1988-02-16</td>\n",
       "      <td>1993-12-20</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>2879500.0</td>\n",
       "      <td>The number of workers decreased to 2,000 in De...</td>\n",
       "      <td>48</td>\n",
       "      <td>1988.0</td>\n",
       "      <td>1993.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Boeing Company</td>\n",
       "      <td>WA</td>\n",
       "      <td>Seattle</td>\n",
       "      <td>Private industry</td>\n",
       "      <td>336411</td>\n",
       "      <td>Seattle Professional Engineering Employees Ass...</td>\n",
       "      <td>SPEEA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1993-01-19</td>\n",
       "      <td>1993-01-19</td>\n",
       "      <td>21000.0</td>\n",
       "      <td>21000.0</td>\n",
       "      <td>The union name was changed to the Society of P...</td>\n",
       "      <td>33</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>1993.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Boston Gas Company</td>\n",
       "      <td>MA</td>\n",
       "      <td>Boston</td>\n",
       "      <td>Private industry</td>\n",
       "      <td>22121</td>\n",
       "      <td>United Steelworkers</td>\n",
       "      <td>USW</td>\n",
       "      <td>12003</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1993-01-24</td>\n",
       "      <td>1993-05-20</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>83000.0</td>\n",
       "      <td>Boston Gas Company also does business as \"Nati...</td>\n",
       "      <td>22</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>1993.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Bituminous Coal Operators Association</td>\n",
       "      <td>IN, IL, KY, WV</td>\n",
       "      <td>Multiple states</td>\n",
       "      <td>Private industry</td>\n",
       "      <td>212112</td>\n",
       "      <td>United Mine Workers of America</td>\n",
       "      <td>UMWA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1993-02-02</td>\n",
       "      <td>1993-03-02</td>\n",
       "      <td>6700.0</td>\n",
       "      <td>103400.0</td>\n",
       "      <td>Number of workers involved increased from 5,00...</td>\n",
       "      <td>21</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>1993.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Douglas Aircraft</td>\n",
       "      <td>CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Private industry</td>\n",
       "      <td>336411</td>\n",
       "      <td>International Association of Machinists</td>\n",
       "      <td>IAM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1993-03-02</td>\n",
       "      <td>1993-03-03</td>\n",
       "      <td>6800.0</td>\n",
       "      <td>13600.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>33</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>1993.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                              Organizations involved          States  \\\n",
       "0  Marine Towing and Transportation Employers' As...              NY   \n",
       "1                                     Boeing Company              WA   \n",
       "2                                 Boston Gas Company              MA   \n",
       "3              Bituminous Coal Operators Association  IN, IL, KY, WV   \n",
       "4                                   Douglas Aircraft              CA   \n",
       "\n",
       "             Areas         Ownership Industry code[1]  \\\n",
       "0         New York  Private industry           488330   \n",
       "1          Seattle  Private industry           336411   \n",
       "2           Boston  Private industry            22121   \n",
       "3  Multiple states  Private industry           212112   \n",
       "4              NaN  Private industry           336411   \n",
       "\n",
       "                                               Union Union acronym  \\\n",
       "0           International Longshoremen's Association           ILA   \n",
       "1  Seattle Professional Engineering Employees Ass...         SPEEA   \n",
       "2                                United Steelworkers           USW   \n",
       "3                     United Mine Workers of America          UMWA   \n",
       "4            International Association of Machinists           IAM   \n",
       "\n",
       "  Union Local Bargaining unit Work stoppage beginning date  \\\n",
       "0         NaN             NaN                   1988-02-16   \n",
       "1         NaN             NaN                   1993-01-19   \n",
       "2       12003             NaN                   1993-01-24   \n",
       "3         NaN             NaN                   1993-02-02   \n",
       "4         NaN             NaN                   1993-03-02   \n",
       "\n",
       "  Work stoppage ending date  Number of workers[2]  \\\n",
       "0                1993-12-20                2500.0   \n",
       "1                1993-01-19               21000.0   \n",
       "2                1993-05-20                1000.0   \n",
       "3                1993-03-02                6700.0   \n",
       "4                1993-03-03                6800.0   \n",
       "\n",
       "   Days idle, cumulative for this work stoppage[3]  \\\n",
       "0                                        2879500.0   \n",
       "1                                          21000.0   \n",
       "2                                          83000.0   \n",
       "3                                         103400.0   \n",
       "4                                          13600.0   \n",
       "\n",
       "                                                Note NAICS_col  start_year  \\\n",
       "0  The number of workers decreased to 2,000 in De...        48      1988.0   \n",
       "1  The union name was changed to the Society of P...        33      1993.0   \n",
       "2  Boston Gas Company also does business as \"Nati...        22      1993.0   \n",
       "3  Number of workers involved increased from 5,00...        21      1993.0   \n",
       "4                                                NaN        33      1993.0   \n",
       "\n",
       "   end_year  \n",
       "0    1993.0  \n",
       "1    1993.0  \n",
       "2    1993.0  \n",
       "3    1993.0  \n",
       "4    1993.0  "
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bls_df[\"NAICS_col\"] = bls_df[\"Industry code[1]\"].astype(str).str[:2]\n",
    "bls_df[\"start_year\"] = pd.DatetimeIndex(bls_df[\"Work stoppage beginning date\"]).year\n",
    "bls_df[\"end_year\"] = pd.DatetimeIndex(bls_df[\"Work stoppage ending date\"]).year\n",
    "bls_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "f07aae2d-4490-4a24-8f94-992832463028",
   "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>NAICS_col</th>\n",
       "      <th>start_year</th>\n",
       "      <th>Number of workers[2]</th>\n",
       "      <th>Days idle, cumulative for this work stoppage[3]</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>11</td>\n",
       "      <td>2022.0</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>39600.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>21</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>6900.0</td>\n",
       "      <td>597675.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>21</td>\n",
       "      <td>1996.0</td>\n",
       "      <td>1700.0</td>\n",
       "      <td>5100.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>21</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>134100.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>21</td>\n",
       "      <td>2007.0</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>9600.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238</th>\n",
       "      <td>92</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>5666.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239</th>\n",
       "      <td>92</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>1900.0</td>\n",
       "      <td>2800.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>92</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>1850.0</td>\n",
       "      <td>7200.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241</th>\n",
       "      <td>92</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>2600.0</td>\n",
       "      <td>9550.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>92</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>2000.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>243 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    NAICS_col  start_year  Number of workers[2]  \\\n",
       "0          11      2022.0                1200.0   \n",
       "1          21      1993.0                6900.0   \n",
       "2          21      1996.0                1700.0   \n",
       "3          21      2005.0                1500.0   \n",
       "4          21      2007.0                1200.0   \n",
       "..        ...         ...                   ...   \n",
       "238        92      2013.0                2000.0   \n",
       "239        92      2015.0                1900.0   \n",
       "240        92      2016.0                1850.0   \n",
       "241        92      2017.0                2600.0   \n",
       "242        92      2020.0                1000.0   \n",
       "\n",
       "     Days idle, cumulative for this work stoppage[3]  \n",
       "0                                       39600.000000  \n",
       "1                                      597675.000000  \n",
       "2                                        5100.000000  \n",
       "3                                      134100.000000  \n",
       "4                                        9600.000000  \n",
       "..                                               ...  \n",
       "238                                      5666.666667  \n",
       "239                                      2800.000000  \n",
       "240                                      7200.000000  \n",
       "241                                      9550.000000  \n",
       "242                                      2000.000000  \n",
       "\n",
       "[243 rows x 4 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "grouped_df = bls_df.groupby([\"NAICS_col\",\"start_year\"]).mean()\n",
    "grouped_df = grouped_df.reset_index()\n",
    "grouped_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "f9e17b5b-7be0-4bd7-9e36-90193f6f56af",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAkQAAAHFCAYAAAAT5Oa6AAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjYuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8o6BhiAAAACXBIWXMAAA9hAAAPYQGoP6dpAACDQ0lEQVR4nO3deVyU1f4H8M8zAzPsww6yu6IGpoKCtqi5l5n169pNpbyZ7ZptlrdF65aWlW12y7pdNTVt0/ZLrlmmKKKomJqiKCibCsO+zvn9gfPkCMoMMDwzzOf9es2reObM83znYYQv53zPOZIQQoCIiIjIgamUDoCIiIhIaUyIiIiIyOExISIiIiKHx4SIiIiIHB4TIiIiInJ4TIiIiIjI4TEhIiIiIofHhIiIiIgcHhMiIiIicnhMiMiu7Nu3D5Ik4ciRIwCAt956C1FRUW1+nb1792LIkCHQ6XSQJAlvv/12m1+jtebNmwdJknD27FmlQ7F5P/30E+bNm2fx6yRJMnndsmXLIEkSdu/e3XbBNeG5555DREQEnJyc4O3tbdVrGT9Hbcl4n7Kystr0vEYt/X62VElJCV555RUMHToUwcHB8PDwQGxsLF577TVUVVU1av/cc89h3LhxCA0NhSRJmDp1arvFSi3HhIjsSmpqKry9vdGjRw8AQEpKCgYOHNjm17nnnnuQm5uLNWvWYMeOHfj73//e5teg9vPTTz/hxRdftPh1O3bswL333muFiC7v22+/xSuvvIK77roLW7duxcaNG616vXvvvRc7duyw6jXaWku/ny116tQpvP322+jfvz8++ugjfPfdd7j99tsxb948jBs3DpfugPXWW2/h3LlzGD9+PDQaTbvFSa3jpHQARJZITU3FwIED5b9oU1JSMGPGjDa/TkZGBqZPn46xY8e2+blbq7KyEi4uLla/Tn19Perq6qDVaq1+LVsihEBVVRVcXV2RmJjY7tfPyMgAAMycOROBgYFtcs6Kigq4ubk1+VxYWBjCwsLa5Dq26OLvZ0t17twZWVlZcHd3l4/dcMMNcHd3x1NPPYXff/8d1157rfxcaWkpVKqG/oYVK1a0PHhqV+whIrtiTIgAIC8vD6dOnbKohygjIwO33HILfHx84OLigr59+2L58uXy88au/rq6OnzwwQeQJOmKwwkDBgzATTfdZHIsNjYWkiQhNTVVPrZ27VpIkoQDBw7Ix7Zt24bhw4fD09MTbm5uGDx4MH788UeTcxnjWb9+Pe655x4EBATAzc0N1dXVTcZz+PBhdOnSBQkJCSgoKJDv0/3334+wsDBoNBp07twZL774Iurq6uTXZWVlQZIkLFy4EC+//DI6d+4MrVaLLVu2wGAw4OWXX0Z0dDRcXV3h7e2NPn364J133mn2fp86dQpTpkxBYGAgtFotevXqhTfffBMGg6HRtd944w0sWrQInTt3hoeHBwYNGoSUlJRmr1FRUYEnn3wSnTt3houLC3x9fREfH4/Vq1cDAKZOnYr3338fAOTv58XDOZIk4ZFHHsGHH36IXr16QavVyp+JS4fMmpKbm4u4uDh0794dR48eBdAwxGKMSaPRIDQ0FLNmzUJ5efkVzxUVFYXnnnsOABAUFGRyfYPBgIULF6Jnz57QarUIDAzEXXfdhZycHJNzDB06FDExMfj1118xePBguLm54Z577rnsNZsaMouKisK4ceOQnJyM/v37w9XVFT179sR///vfRq9PSUnBNddcAxcXF4SEhGDOnDmora1t1O5y9zIqKspkSMka389ly5ahe/fuGD16dKPrl5WVQafT4eGHH77sPXJ3dzdJhoyMP3uys7NNjhuTIbIzgsjGRUZGCgDNPu6+++4rnufw4cPC09NTdO3aVXz66afixx9/FHfeeacAIF577TUhhBAFBQVix44dAoC4/fbbxY4dO8SOHTsue85nnnlGeHh4iJqaGiGEEHl5eQKAcHV1Fa+88orc7sEHHxRBQUHy17/88otwdnYWcXFx4vPPPxfffPONGDVqlJAkSaxZs0Zut3TpUgFAhIaGivvuu0/873//E1999ZWoq6sTc+fOFQBEYWGhfE4fHx9xyy23iPLyciGEELm5uSI8PFxERkaKJUuWiI0bN4p//etfQqvViqlTp8rXOXHihHydYcOGia+++kqsX79enDhxQixYsECo1Woxd+5csWnTJpGcnCzefvttMW/evCve74KCAhEaGioCAgLEhx9+KJKTk8UjjzwiAIgHH3yw0bWjoqLEmDFjxDfffCO++eYbERsbK3x8fERxcfEVr3P//fcLNzc3sWjRIrFlyxbxww8/iFdffVW89957Qgghjh07Jm6//XYBQP5+7tixQ1RVVQkhhPy++/TpIz777DOxefNmkZGRIT83d+7cRt+P1NRUIYQQBw4cEOHh4WLQoEHy96G8vFz07dtX+Pv7i0WLFomNGzeKd955R+h0OnHDDTcIg8Fw2feyZ88eMW3aNAFAJCcnix07dojs7GwhhBD33XefACAeeeQRkZycLD788EMREBAgwsPD5WsLIcSQIUOEr6+vCA8PF++9957YsmWL2Lp162WvafwcXSwyMlKEhYWJ3r17i08//VT8/PPP4m9/+5sAYHKugwcPCjc3N9G7d2+xevVq8e2334rRo0eLiIgIAUCcOHFCbnvpvbz4Whf/27XW9/Odd94RkiSJP//80+T677//vgAgDh48eNl71Ny927dv32XbuLu7N/uziWwDEyKyeQcPHhR79+4VCxcuFBqNRqSmpoq9e/eKCRMmiGuuuUbs3btX7N27V5w8efKK5/n73/8utFqtOHXqlMnxsWPHCjc3N5NfvADEww8/3GxsGzduFADEr7/+KoQQYuXKlcLT01M89NBDYtiwYXK77t27i0mTJslfJyYmisDAQFFaWiofq6urEzExMSIsLEz+pWn8BXzXXXc1uvbFCdGKFSuERqMRM2fOFPX19XKb+++/X3h4eDS6N2+88YbJLwFjUtK1a1c5uTMaN26c6Nu3b7P34lLPPPOMACB27txpcvzBBx8UkiSJI0eOmFw7NjZW1NXVye127dolAIjVq1df8ToxMTFiwoQJV2zz8MMPN/qlbwRA6HQ6cf78+Safu1xCtGHDBuHl5SVuv/12UVlZKbdZsGCBUKlUctJk9NVXXwkA4qeffrpirJcmukIIcejQIQFAPPTQQyZtd+7cKQCIf/7zn/KxIUOGCABi06ZNV7zOpde7WGRkpHBxcTH53FRWVgpfX19x//33y8fuuOMO4erqKvLy8uRjdXV1omfPni1OiKz1/SwpKRGenp7i0UcfNTneu3dvk3+r5tq3b59wdXUVt9566xXbMSGyH+zXI5vXu3dv9O3bF2fOnMGAAQMQHx+Pvn374s8//8TIkSPRt29f9O3bFxEREVc8z+bNmzF8+HCEh4ebHJ86dSoqKipaVFhqHCowFr5u2LABQ4cOxZgxY7B9+3ZUVFQgOzsbR48exYgRIwAA5eXl2LlzJ26//XZ4eHjI51Kr1UhKSkJOTo48i87o//7v/y4bwyuvvIKpU6fi1VdfxTvvvGPSXf/DDz9g2LBhCAkJQV1dnfww1kZt3brV5Fzjx4+Hs7OzybGBAwdi3759eOihh/Dzzz+jpKTErHuzefNm9O7du9GQ5tSpUyGEwObNm02O33TTTVCr1fLXffr0AQCcPHnyitcZOHAg/ve//+GZZ57BL7/8gsrKSrPiu9gNN9wAHx8fs9svX74cN954I+6991588cUXJjVdP/zwA2JiYtC3b1+Tez569GhIkoRffvnF4vi2bNkCAI1mKw0cOBC9evXCpk2bTI77+PjghhtusPg6F7v035SLiwt69Ohh8v3YsmULhg8fjqCgIPmYWq3GHXfc0eLrWuv76enpiX/84x9YtmyZPHS5efNm/PHHH3jkkUcsOn9WVhbGjRuH8PBw/Oc//7E4PrJNTIjIphkLe+vq6rB161Zce+21qKurQ0FBAQ4dOoRrrrkGdXV1qK+vb/Zc586dQ6dOnRodDwkJkZ+3lIuLC6655ho5Idq0aRNGjhyJoUOHor6+Hr/99hs2bNgAAHJCVFRUBCGERbE01dZo5cqVCA0NbXImXH5+Pr7//ns4OzubPK666ioAaDRlv6nrzJkzB2+88QZSUlIwduxY+Pn5Yfjw4c1OPbf0fvv5+Zl8bSzmbu4X4rvvvounn34a33zzDYYNGwZfX19MmDBBrucxx5Xub1PWrFkDV1dX3HvvvY3qb/Lz87F///5G99zT0xNCiBYtk2C8V5e7n5Z8Xsx16fcDaPieXPz9OHfuHIKDgxu1a+qYuaz5/ZwxYwZKS0uxatUqAMDixYsRFhaGW265xexznzx5EsOGDYOTkxM2bdoEX19fs19Lto0JEdm04cOHy79Q9u7di9deew3Ozs4ICgqCEAIjR46Es7Mzhg8f3uy5/Pz8kJub2+j4mTNnAAD+/v4tjnHXrl3YtWsXcnJyMHLkSHh6emLAgAHYsGEDNm7ciB49esg9Uz4+PlCpVBbFcqXC7uTkZDg7O+O6665r1Jvi7++PUaNGITU1tcnHtGnTmr2Ok5MTHn/8cezZswfnz5/H6tWrkZ2djdGjR6OiouKycVnrfl/K3d0dL774Ig4fPoy8vDx88MEHSElJwc0332z2OSxdh2fVqlXo2bMnhgwZgvT0dJPn/P39ERsbe9l7/vzzz1t0LeCv5ORy99OSz0tb8vPzQ15eXqPjTR3TarVNTga4NJmz5vezW7duGDt2LN5//31kZ2fju+++wwMPPGDSM3klJ0+exNChQyGEwJYtWzr07DxHxISIbNqSJUuQmpqK+fPnw9XVFSkpKUhNTcXNN9+M66+/Xv4ls2TJkmbPNXz4cGzevFn+hWz06aefws3NrcVTrEeMGIG6ujo8//zzCAsLQ8+ePeXjGzduxObNm+XeIaDhB35CQgLWrl1r8te2wWDAypUrERYWJq+zZI7IyEj89ttv0Gq1uO6660z+kh43bhwyMjLQtWtXxMfHN3oYe2vM5e3tjdtvvx0PP/wwzp8/f8WF94YPH44//vgDe/bsMTn+6aefQpIkDBs2zKJrmyMoKAhTp07FnXfeiSNHjsgJm7m9Teby9fXFxo0b0atXLwwbNsxkNty4ceOQmZkJPz+/Ju95SxYSNQ5/rVy50uR4amoqDh06ZNYfBNYwbNgwbNq0Cfn5+fKx+vp6fP75543aRkVFYf/+/SbHNm/ejLKyssue3xrfz0cffRT79+/H3XffDbVajenTp5v1ulOnTsk9v5s3b0ZkZKTF1ybbxnWIyKZFR0cDAP79739j+PDhSEhIANCwkvQzzzyD+Ph4s881d+5cuabmhRdegK+vL1atWoUff/wRCxcuhE6na1GMcXFx8PHxwfr16/GPf/xDPj5ixAj861//kv//YgsWLMDIkSMxbNgwPPnkk9BoNPj3v/+NjIwMrF692uK/8Dt16oStW7di9OjRuP7667FhwwbExMTgpZdewoYNGzB48GDMnDkT0dHRqKqqQlZWFn766Sd8+OGHzf6Ve/PNNyMmJgbx8fEICAjAyZMn8fbbbyMyMhLdu3e/7Osee+wxfPrpp7jpppvw0ksvITIyEj/++CP+/e9/48EHH7Qo6buShIQEjBs3Dn369IGPjw8OHTqEFStWYNCgQfLaO7GxsQCA1157DWPHjoVarUafPn1atWiep6cnkpOTcdttt2HkyJH47rvvMGzYMMyaNQtff/01rr/+ejz22GPo06cPDAYDTp06hfXr1+OJJ56QP8fmio6Oxn333Yf33nsPKpUKY8eORVZWFp5//nmEh4fjsccea/H7aI3nnnsO3333HW644Qa88MILcHNzw/vvv9/k8gJJSUl4/vnn8cILL2DIkCH4448/sHjx4kb/7qz9/Rw5ciR69+6NLVu2yEtCNKegoADDhg1Dbm4uPvnkExQUFMjLWgCN13LaunUrCgsLATQkiCdPnsRXX30FABgyZAgCAgKavSYpQNGSbiIz1NfXi4CAALFkyRIhRMPUZADNzipryoEDB8TNN98sdDqd0Gg04uqrrxZLly5t1A5mzjIzuvXWWwUAsWrVKvlYTU2NcHd3FyqVShQVFTV6zW+//SZuuOEG4e7uLlxdXUViYqL4/vvvTdpcOs37Yk3NRiouLhbXXHON8PX1lV9TWFgoZs6cKTp37iycnZ2Fr6+viIuLE88++6woKysTQvw10+v1119vdJ0333xTDB48WPj7+wuNRiMiIiLEtGnTRFZWVrP35eTJk2LSpEnCz89PODs7i+joaPH666+bzIS70rVxmZlJF3vmmWdEfHy88PHxEVqtVnTp0kU89thj4uzZs3Kb6upqce+994qAgAAhSZLJDKgrfa8vvX5T34/q6mrxf//3f8LFxUX8+OOPQgghysrKxHPPPSeio6OFRqMROp1OxMbGiscee8xkRlZTmvq+CtHw7+C1114TPXr0EM7OzsLf319MmTJFnpZvNGTIEHHVVVdd8RpNXe9ikZGR4qabbmrUdsiQIWLIkCEmx37//XeRmJgotFqtCA4OFk899ZT46KOPGs0yq66uFrNnzxbh4eHC1dVVDBkyRKSnpzeaZWbN76fRvHnzBACRkpJi1j3asmXLFZf8uPQzapzp19Rjy5YtZl2T2p8kxCVrjhMREXVg8fHxjRZPJeKQGRERdXglJSXIyMjADz/8gLS0NKxbt07pkMjGMCEiIqIOb8+ePRg2bBj8/Pwwd+5cTJgwQemQyMZwyIyIiIgcHqfdExERkcNjQkREREQOjwkREREROTwWVZvJYDDgzJkz8PT0bLdl8YmIiKh1hBAoLS1FSEiIyebXl2JCZKYzZ8402iWdiIiI7EN2dvYVV+ZnQmQmT09PAA031MvLS+FoiIiIyBwlJSUIDw+Xf49fDhMiMxmHyby8vJgQERER2Znmyl1YVE1EREQOjwkREREROTwmREREROTwmBARERGRw1M0IYqKioIkSY0eDz/8MICGtQPmzZuHkJAQuLq6YujQoTh48KDJOaqrqzFjxgz4+/vD3d0d48ePR05OjkmboqIiJCUlQafTQafTISkpCcXFxe31NomIiMjGKZoQpaamIjc3V35s2LABAPC3v/0NALBw4UIsWrQIixcvRmpqKoKDgzFy5EiUlpbK55g1axbWrVuHNWvWYNu2bSgrK8O4ceNQX18vt5k0aRLS09ORnJyM5ORkpKenIykpqX3fLBEREdkuYUMeffRR0bVrV2EwGITBYBDBwcHi1VdflZ+vqqoSOp1OfPjhh0IIIYqLi4Wzs7NYs2aN3Ob06dNCpVKJ5ORkIYQQf/zxhwAgUlJS5DY7duwQAMThw4fNjk2v1wsAQq/Xt/ZtEhERUTsx9/e3zdQQ1dTUYOXKlbjnnnsgSRJOnDiBvLw8jBo1Sm6j1WoxZMgQbN++HQCQlpaG2tpakzYhISGIiYmR2+zYsQM6nQ4JCQlym8TEROh0OrlNU6qrq1FSUmLyICIioo7JZhKib775BsXFxZg6dSoAIC8vDwAQFBRk0i4oKEh+Li8vDxqNBj4+PldsExgY2Oh6gYGBcpumLFiwQK450ul03LaDiIioA7OZhOiTTz7B2LFjERISYnL80pUlhRDNrjZ5aZum2jd3njlz5kCv18uP7Oxsc94GERER2SGbSIhOnjyJjRs34t5775WPBQcHA0CjXpyCggK51yg4OBg1NTUoKiq6Ypv8/PxG1ywsLGzU+3QxrVYrb9PB7TqIiIg6NptIiJYuXYrAwEDcdNNN8rHOnTsjODhYnnkGNNQZbd26FYMHDwYAxMXFwdnZ2aRNbm4uMjIy5DaDBg2CXq/Hrl275DY7d+6EXq+X2xAREZFjU3xzV4PBgKVLl+Luu++Gk9Nf4UiShFmzZmH+/Pno3r07unfvjvnz58PNzQ2TJk0CAOh0OkybNg1PPPEE/Pz84OvriyeffBKxsbEYMWIEAKBXr14YM2YMpk+fjiVLlgAA7rvvPowbNw7R0dHt/4YvUVNnwMlz5QjWucDTxVnpcIiIiByS4gnRxo0bcerUKdxzzz2Nnps9ezYqKyvx0EMPoaioCAkJCVi/fj08PT3lNm+99RacnJwwceJEVFZWYvjw4Vi2bBnUarXcZtWqVZg5c6Y8G238+PFYvHix9d+cGW7/cDv25+ixJCkOo68KVjocIiIihyQJIYTSQdiDkpIS6HQ66PX6Nq0nenTNXnybfgZPjY7Gw8O6tdl5iYiIyPzf3zZRQ+TIugV4AAAyC8oUjoSIiMhxMSFSWLfAhoToWCETIiIiIqUwIVKYMSHKLCgDRy+JiIiUwYRIYZF+7lCrJJTX1CNXX6V0OERERA6JCZHCNE4qRPq5AQCOsY6IiIhIEUyIbEB3Yx0REyIiIiJFMCGyASysJiIiUhYTIhvQjT1EREREimJCZAO6BTSsvM21iIiIiJTBhMgGdA10BwCcK69BUXmNwtEQERE5HiZENsBN44RQb1cArCMiIiJSAhMiG9GVdURERESKYUJkI4x7mjEhIiIian9MiGwEZ5oREREphwmRjWBCREREpBwmRDbCmBCdLq5EeXWdwtEQETmOgpIqPP5FOtKzi5UOhRTEhMhG+Lpr4OuuAQAcLyxXOBoiIsfx1sY/sXbPaby5/ojSoZCCmBDZELmwurBU4UiIiBxDSVUtvtl7BgCw91Qx6g1C4YhIKUyIbAin3hMRta+1aTmorK0HAJRV1+FwXonCEZFSmBDZEBZWExG1HyEEVu48BQBwVksAgLSTRUqGRApiQmRDmBAREbWflOPncaygDG4aNf5xTWcAQGoWEyJHxYTIhhgTopPnKlBbb1A4GiKijm1lykkAwC19QzG0RwAAIC3rvJIhkYKYENmQEJ0L3DRq1BkETp7jTDMiImspKKnCzwfzAABTEiPQN8IbapWEM/oqnC6uVDg6UgITIhsiSRKHzYiI2sHnqdmoMwj0j/DGVSE6uGmccFWIFwBgN3uJHBITIhvDPc2IiKyrrt6Az3Y1FFMnDYqUj8dF+gBgYbWjYkJkYzj1nojIujYfLkCuvgo+bs4YG9NJPh4f6QsA2M3CaofEhMjGyENmhUyIiIisYcWFYuqJA8Lh4qyWj8dHNfQQHc4rQWlVrSKxkXKYENkYY0KUWVAOA1dMJSJqU1lny/Hb0bOQJGDywEiT54K8XBDu6wqDaFi1mhwLEyIbE+nrBme1hMraepzRc6YDEVFbWrWzoXfo+u4BiPBza/S8PGzGOiKHw4TIxjipVYjycwfAOiIiorZUVVuPL9NyAABJiZFNtvmrsJozzRwNEyIbxKn3RERt78f9uSiuqEWotyuG9Qxsss2AqIYeor2nilHHBXIdChMiGyTXEbGwmoiozRiLqSclRECtkpps0z3QA14uTqioqceh3NL2DI8UxoTIBrGHiIiobWWc1iM9uxjOagkT48Mv206lktD/wrDZbg6bORQmRDao64XFGY8WlEEIzjQjImot475lY2I6IcBTe8W2xmEzrkfkWJgQ2aCuAR6QJKC4ohbnymuUDoeIyK7pK2vxbfoZAMCUhIhm28dd1EPEP0odBxMiG+SqUSPU2xUAh82IiFpr7Z4cVNbWo0eQBwZ29m22/dVh3nBSScgvqUZOEZc/cRRMiGwU64iIiFpPCIFVOxv2LZuSGAlJarqY+mKuGjViQnUAWEfkSJgQ2Shu8kpE1Hopx8/jWEEZ3DRq3Nov1OzXxRuHzVhH5DCYENkoTr0nImo9YzH1hH6h8HRxNvt1xn3NuPO942BCZKM4ZEZE1DoFJVX4+WAeAGBKQtMrU19O3IUtPI7kl0JfyY1eHQETIhtlTIhy9VUoq65TOBoiIvuzJjUbdQaBuEgf9A7xsui1AZ5aRPm5QQhgzyn2EjkCJkQ2yttNA3+PhrUyMtlLRERkkbp6A1bvMhZTNz/VvinGXqI01hE5BCZENqxbIDd5JSJqiU2HC5Crr4KPmzPGxnRq0TmMdUScaeYYmBDZMLmOiIXVREQWMRZTTxwQDhdndYvOMeBCQpSeXYxabvTa4TEhsmGcek9EZLmss+X47ehZSBIweaBlxdQX6+LvAW83Z1TVGnDwTEkbRki2iAmRDesW6AmANURERJZYtbOhd2hIjwBE+Lm1+DwqlYS4CON6RBw26+iYENkw45DZyfMVqKljdy0RUXOqauvxZVoOAMun2jclnhu9OgzFE6LTp09jypQp8PPzg5ubG/r27Yu0tDT5eSEE5s2bh5CQELi6umLo0KE4ePCgyTmqq6sxY8YM+Pv7w93dHePHj0dOTo5Jm6KiIiQlJUGn00Gn0yEpKQnFxcXt8RZbLMhLCw+tE+oNAlnnypUOh4jI5v2wPxfFFbUI9XbFsJ6BrT7fX4XVRdzotYNTNCEqKirCNddcA2dnZ/zvf//DH3/8gTfffBPe3t5ym4ULF2LRokVYvHgxUlNTERwcjJEjR6K0tFRuM2vWLKxbtw5r1qzBtm3bUFZWhnHjxqG+vl5uM2nSJKSnpyM5ORnJyclIT09HUlJSe75di0mShK5coJGIyGzGYupJCRFQq5rft6w5saE6aNQqnC2rxqnzFa0+H9kuJyUv/tprryE8PBxLly6Vj0VFRcn/L4TA22+/jWeffRa33XYbAGD58uUICgrCZ599hvvvvx96vR6ffPIJVqxYgREjRgAAVq5cifDwcGzcuBGjR4/GoUOHkJycjJSUFCQkJAAAPv74YwwaNAhHjhxBdHR0+71pC3UL8MC+7GImREREzcg4rUd6djGc1RImxoe3yTldnNWICfXCnlPF2J1VhEg/9zY5L9keRXuIvvvuO8THx+Nvf/sbAgMD0a9fP3z88cfy8ydOnEBeXh5GjRolH9NqtRgyZAi2b98OAEhLS0Ntba1Jm5CQEMTExMhtduzYAZ1OJydDAJCYmAidTie3uVR1dTVKSkpMHkow1hEdZUJERHRFxt6hMTGdEOCpbbPzDjDWEXE9og5N0YTo+PHj+OCDD9C9e3f8/PPPeOCBBzBz5kx8+umnAIC8vIY9aIKCgkxeFxQUJD+Xl5cHjUYDHx+fK7YJDGw8lhwYGCi3udSCBQvkeiOdTofw8Lb5a8NS3NOMiKh5+spafJt+BgAwJaFlK1NfTlykcaYZC6s7MkUTIoPBgP79+2P+/Pno168f7r//fkyfPh0ffPCBSTtJMh0HFkI0OnapS9s01f5K55kzZw70er38yM7ONvdttSljQnS8sAz1Bhb0ERE1Ze2eHFTW1qNHkAcGdvZt03MbE6KjBWUorqhp03OT7VA0IerUqRN69+5tcqxXr144daph/5ng4GAAaNSLU1BQIPcaBQcHo6amBkVFRVdsk5+f3+j6hYWFjXqfjLRaLby8vEweSgj3cYVGrUJ1nQGniyoViYGIyJYJIeThsimJkc3+wWwpPw8tugQ01A6lnWQvUUelaEJ0zTXX4MiRIybH/vzzT0RGNqwd0blzZwQHB2PDhg3y8zU1Ndi6dSsGDx4MAIiLi4Ozs7NJm9zcXGRkZMhtBg0aBL1ej127dsltdu7cCb1eL7exVU5qFTr7X9jTrLC0mdZERI5nx/FzyCwsh5tGjVv7hVrlGvGRf02/p45J0YToscceQ0pKCubPn49jx47hs88+w0cffYSHH34YQMMw16xZszB//nysW7cOGRkZmDp1Ktzc3DBp0iQAgE6nw7Rp0/DEE09g06ZN2Lt3L6ZMmYLY2Fh51lmvXr0wZswYTJ8+HSkpKUhJScH06dMxbtw4m55hZsQ6IiKiy1uV0jCqMKFfKDxdnK1yjXjufN/hKTrtfsCAAVi3bh3mzJmDl156CZ07d8bbb7+NyZMny21mz56NyspKPPTQQygqKkJCQgLWr18PT09Puc1bb70FJycnTJw4EZWVlRg+fDiWLVsGtfqvDf1WrVqFmTNnyrPRxo8fj8WLF7ffm20FrkVERNS0gpIq/HywoayiLVamvhzjAo3pOcWorquH1qllG8aS7ZIEl940S0lJCXQ6HfR6fbvXE3237wxmrt6L/hHeWPvQNe16bSIiW/bupqNYtOFPxEX64OsHrVcCIYRA/Msbca68Bl8/OFgutCbbZ+7vb8W37qDmdb+oh4j5KxFRg7p6A1bvahgum5LYtlPtLyVJEvpfSILSuB5Rh8SEyA509neHSgJKqupQWFatdDhERDZh0+EC5Oqr4OuuwdiYTla/XjzXI+rQmBDZARdnNcJ93QCwjoiIyMg41f5v8WFwcbZ+TY9x5/s0bvTaITEhshPdAhqGzTKZEBER4cTZcvx29CwkCZg80HrF1BeLCfWCxkmFc+U1OHG2vF2uSe2HCZGd4NR7IqK/fLazoXdoSI8ARPi5tcs1tU5qXB2mA8D1iDoiJkR2Qp56X8iEiIgcW1VtPb5MywFg3an2TTEOm+3OYmF1R8OEyE6wh4iIqMEP+3NRXFGLUG9XDOvZeONua+KK1R0XEyI7YUyI8kuqUVJVq3A0RETKMRZTT0qIgFrVtvuWNce4/tDxwnKc46zfDoUJkZ3wcnFGoKcWAAurichxZZzWIz27GM5qCRPjw9v9+t5uGnltOG702rEwIbIjHDYjIkdn7B0aE9MJARf+SGxvxm08mBB1LEyI7AgTIiJyZPrKWnyTfhoAkJTYvsXUF4u7sNEr64g6FiZEdoQJERE5srV7clBVa0CPIA8MiFJuLzFjYfWBHD2qausVi4PaFhMiO2JcnJFT74nI0Qgh5OGyKYmRkKT2Laa+WKSfG/w9tKipN+DAab1icVDbYkJkR4w9RNnnK/hXCRE5lB3HzyGzsBxuGjVu7ReqaCySJHFfsw6ICZEdCfDUwtPFCQYBLhtPRA5lVUrDrvYT+oXC08VZ4WguLqzmAo0dBRMiOyJJEuuIiMjhFJRU4eeDeQDaf2Xqy5FXrD5ZBIOBG712BEyI7IxcR8SEiIgcxJrUbNQZBOIifdA7xEvpcAAAV4V4wcVZheKKWhw/y5/HHQETIjvTjXuaEZEDqas34LOdDcNlSk61v5SzWoWrw7wBsI6oo2BCZGe6BzUkRFytmogcwabDBcgrqYKvuwZjY4OVDsfEgAvDZqlMiDoEJkR2pluAJwDg+Nly1HPcmog6OONU+7/Fh0HrpFY4GlNxLKzuUJgQ2ZlQH1donVSoqTMg+3yF0uEQEVnNibPl+O3oWUgSMHmg7QyXGfWP8IEkAVnnKlBYyo1e7R0TIjujVknowsJqInIAn+1s6B0a0iMAEX5uCkfTmM7VGT0CG3rtua+Z/WNCZIdYWE1EHV1VbT2+2J0DwLaKqS9lXI9odxaHzewdEyI7xKn3RNTR/bA/F/rKWoR6u2JodKDS4VyWnBCxh8juMSGyQ1yckYg6uhUXiqknJURArVJu37LmxF/Y+f7gGT0qa7ilkj1jQmSHjAlRZkEZhOBMMyLqWDJO67EvuxjOagl3DAhXOpwrCvNxRZCXFrX1AvtyipUOh1qBCZEdivJ3g0oCSqvrUMCZDUTUwRin2o+J6QR/D63C0VxZw0avDb1ELKy2b0yI7JDWSY1IP3cAwNF8DpsRUcehr6zFN+mnAdh2MfXF4iJZWN0RMCGyU13lwupShSMhImo7a/fkoKrWgB5BHhhwoWDZ1hlXrE7jRq92jQmRneLUeyLqaIQQ8nBZUmIkJMl2i6kv1quTJ9w0apRU1eEoJ7vYLSZEdoozzYioo9lx/BwyC8vhplFjQr9QpcMxm5Nahb7h3gCA3dzGw24xIbJTfyVE5QpHQkTUNoy9Q7f2C4Wni7PC0Vgm/kIdURo3erVbTIjsVNeAhqLqs2XV0FfUKhwNEVHrFJRUYf3BfADAFDsppr5Y/IU6olT2ENktJkR2ytPFGcFeLgCAY4UsrCYi+7YmNRt1BoG4SB/06uSldDgW6xfhDZUEZJ+vREFJldLhUAs4mdPou+++s/jEI0eOhKurq8WvI/N1C/RAXkkVjhWUIe7COhhERPamrt6Az3aeAmA/U+0v5enijOhgLxzKLcHuk0W4MbaT0iGRhcxKiCZMmGDRSSVJwtGjR9GlS5eWxERm6hbogW3HzrKwmojs2qbDBcgrqYKvuwZjY4OVDqfFBkT54FBuCVKzzjMhskNmD5nl5eXBYDCY9XBzc7NmzHQBZ5oRUUdgLKaeGB8OrZNa4WhazrhAI1estk9mJUR33323RcNfU6ZMgZeX/Y0B2xuuRURE9u7E2XL8dvQsJAmYnBChdDitYiysPnimBBU1dQpHQ5YyKyFaunQpPD09zT7pBx98AH9//xYHReYxJkQ5RZWoquUuy0Rkf1Zd6B0a2iMA4b72PboQ6u2KEJ0L6g0C6aeKlQ6HLMRZZnbMz10DbzdnCAFkspeIiOxMVW09vkzLAWCfU+2bEnehl2g3h83sjkUJUW5uLlauXImffvoJNTU1Js+Vl5fjpZdeatPg6MokSUK3ANYREZF9+mF/LvSVtQj1dsXQ6EClw2kTxgUamRDZH7MTotTUVPTu3RsPP/wwbr/9dsTExODgwYPy82VlZXjxxRetEiRdnnHYLJMJERHZmRUXhssmJURArbKPfcuaYyys3nuyCPXc6NWumJ0Q/fOf/8Rtt92GoqIi5OfnY+TIkRgyZAj27t1rzfioGSysJiJ7dCBHj33ZxXBWS7hjQLjS4bSZnsGe8NA6obS6DkfyuGiuPTE7IUpLS8PTTz8NlUoFT09PvP/++5g9ezaGDx+O1NRUa8ZIV9CVU++JyA4Zp9qPjekEfw+twtG0HSe1Cv0ivAEAadzGw65YVENUVWW6HPns2bPxz3/+E6NGjcL27dvbNDAyj7GG6MTZctTVGxSOhoioefrKWny77zSAjlNMfbE41hHZJbNWqgaAmJgYbN++HX369DE5/uSTT0IIgTvvvLPNg6PmhXq7wtVZjcraepw8X4GuFxIkIiJb9XVaDqpqDYgO8sSAKB+lw2lzA4wzzbjzvV0xu4forrvuwu+//97kc0899RReeuklRETY96Ja9kilktDlws73HDYjIlsnhMCqnQ3DZVMSIyBJHaOY+mJ9w72hVkk4XVyJXH2l0uGQmcxOiO69916sWLHiss/Pnj0bJ06csOji8+bNgyRJJo/g4L/2sRFCYN68eQgJCYGrqyuGDh1qMrMNAKqrqzFjxgz4+/vD3d0d48ePR05OjkmboqIiJCUlQafTQafTISkpCcXFxRbFasu4hQcR2Ysdx88hs7Acbho1JvQLVTocq3DXOqFXp4bFjNlLZD8UX5jxqquuQm5urvw4cOCA/NzChQuxaNEiLF68GKmpqQgODsbIkSNRWvpX5f6sWbOwbt06rFmzBtu2bUNZWRnGjRuH+vq/Vm6eNGkS0tPTkZycjOTkZKSnpyMpKald36c1GeuIOPWeiGydsZj61n6h8HRxVjga64mPNA6bsbDaXpiVEPXv3x9FReZnuddeey1Onz5tVlsnJycEBwfLj4CAAAANvUNvv/02nn32Wdx2222IiYnB8uXLUVFRgc8++wwAoNfr8cknn+DNN9/EiBEj0K9fP6xcuRIHDhzAxo0bAQCHDh1CcnIy/vOf/2DQoEEYNGgQPv74Y/zwww84cuSI2e/JlnHqPRHZg/ySKqw/mA+gYxZTXyw+ioXV9sasour09HTs27cPvr6+Zp00PT0d1dXVZrU9evQoQkJCoNVqkZCQgPnz56NLly44ceIE8vLyMGrUKLmtVqvFkCFDsH37dtx///1IS0tDbW2tSZuQkBC5AHz06NHYsWMHdDodEhIS5DaJiYnQ6XTYvn07oqOjm4yrurra5D2UlJSY9X6UcPHijEKIDjkmT0T2b82ubNQZBOIjfdCrU8feANzYQ3QotwRl1XXw0Jo9h4kUYvZ3aPjw4RDCvFU3zf2FnJCQgE8//RQ9evRAfn4+Xn75ZQwePBgHDx5EXl4eACAoKMjkNUFBQTh5sqHLNS8vDxqNBj4+Po3aGF+fl5eHwMDGS8IHBgbKbZqyYMECu1l5O9LPHWqVhPKaeuTqqxDi7ap0SEREJurqDVi96xSAjt87BADBOheEervidHEl0k8V49ru3PDc1pmVEFlaLA0AYWFhzbYZO3as/P+xsbEYNGgQunbtiuXLlyMxMRFA4+TKnB6QS9s01b6588yZMwePP/64/HVJSQnCw21zNVWNkwqRfm44XliOYwVlTIiIyOZsPFSAvJIq+LprMDY2uPkXdAADonxwOr0SqVnnmRDZAbMSosjI9snm3d3dERsbi6NHj2LChAkAGnp4OnXqJLcpKCiQe42Cg4NRU1ODoqIik16igoICDB48WG6Tn5/f6FqFhYWNep8uptVqodXaz+qp3QI85ITo+h4BSodDRGTCONV+Ynw4tE5qhaNpH3FRvvgm/QzSWEdkFyyeZbZ8+XL8+OOP8tezZ8+Gt7c3Bg8eLA9ltVR1dTUOHTqETp06oXPnzggODsaGDRvk52tqarB161Y52YmLi4Ozs7NJm9zcXGRkZMhtBg0aBL1ej127dsltdu7cCb1eL7fpCLoHsbCaiGzTibPl+O3oWUgSMDnBcdarizdu9HqqiDsJ2AGLE6L58+fD1bVhSGbHjh1YvHgxFi5cCH9/fzz22GMWnevJJ5/E1q1bceLECezcuRO33347SkpKcPfdd0OSJMyaNQvz58/HunXrkJGRgalTp8LNzQ2TJk0CAOh0OkybNg1PPPEENm3ahL1792LKlCmIjY3FiBEjAAC9evXCmDFjMH36dKSkpCAlJQXTp0/HuHHjLltQbY+4FhER2apVF6baD+0RgHBfN4WjaT89gjzh6eKE8pp6HOZGrzbP4rL37OxsdOvWDQDwzTff4Pbbb8d9992Ha665BkOHDrXoXDk5Objzzjtx9uxZBAQEIDExESkpKfIQ3ezZs1FZWYmHHnoIRUVFSEhIwPr16+Hp6Smf46233oKTkxMmTpyIyspKDB8+HMuWLYNa/VeX7KpVqzBz5kx5Ntr48eOxePFiS9+6TesW0HBPuBYREdmSqtp6fJnWsFiuIxRTX0ytktA/wgdb/yzE7qzziAnVKR0SXYHFCZGHhwfOnTuHiIgIrF+/Xu4VcnFxQWWlZUuUr1mz5orPS5KEefPmYd68eZdt4+Ligvfeew/vvffeZdv4+vpi5cqVFsVmb7oGNmzfca68BkXlNfBx1ygcERER8P2+M9BX1iLU2xVDoxvP+O3o4iMvJEQnizD1ms5Kh0NXYHFCNHLkSNx7773o168f/vzzT9x0000AgIMHDyIqKqqt4yMzuWmc5CmexwrLMMDdvDWjiIisaeXOhqn2kxIioFY53hpp8Rdt9Mp14mybxTVE77//PgYPHozCwkJ8/fXX8PPzAwCkpaVxx3uFdWUdERHZkAM5euzLLoazWsIdA2xz2RJr6xvuDSeVhLySKpwu5kavtsyiHqK6ujq88847mD17dqM1eexlEcOOrFuAB379s5AJERHZBOO+ZWNjOsHfw36WMWlLrho1rgrxwr4cPdJOFiHMx3GKyu2NRT1ETk5OeP311002TiXbwZlmRGQr9JW1+HZfw56WjlZMfam4yL+Gzch2WTxkNmLECPzyyy9WCIVaiwkREdmKr9NyUFVrQHSQJwZE+TT/gg7M+P5Ts84rHAldicVF1WPHjsWcOXOQkZGBuLg4uLu7mzw/fvz4NguOLGNMiE4XV6K8ug7u3EyQiBQghMDKCytTT0mMcPhC4rgLCdGR/FKUVNXCy8VZ4YioKRb/xnzwwQcBAIsWLWr0nCRJHE5TkK+7Br7uGpwvr8HxwnLEhnHNCyJqfzsyz+F4YTncNWpM6BeqdDiKC/R0QYSvG06dr8DeU8UYwu2VbJLFQ2YGg+GyDyZDyusWYNzCg6uiEpEyjL1DE/qFwpO9IQCA+Au9RLs5bGazLE6ILlZVVdVWcVAb4dR7IlJSfkkVfj7YsKG2oxdTXyyehdU2z+KEqL6+Hv/6178QGhoKDw8PHD9+HADw/PPP45NPPmnzAMkyLKwmIiWt2ZWNeoNAfKQPenXyUjocm2HsIUrPLkYtN3q1SRYnRK+88gqWLVuGhQsXQqP5a3uI2NhY/Oc//2nT4MhyTIiISCl19Qas3tWwMjV7h0x1C/CAztUZlbX1+ONMidLhUBMsTog+/fRTfPTRR5g8ebLJBqp9+vTB4cOH2zQ4spwxITp5roJ/hRBRu9p4qAB5JVXwdddgbGyw0uHYFJVKQlzkhTqikxw2s0UWJ0SnT5+Wd7u/mMFgQG1tbZsERS0XonOBm0aNOoPAyXPlSodDRA5k1YVi6onx4dA6qZtp7XiMCVHaSRZW2yKLE6KrrroKv/32W6PjX375Jfr169cmQVHLSZKErgEcNiOi9nXibDl+O3oWkgRMTohQOhybFB9pXKCxYaNXsi0Wr0M0d+5cJCUl4fTp0zAYDFi7di2OHDmCTz/9FD/88IM1YiQLdQ/0wIHTeiZERNRuVl3Yt2xojwCE+3K/rqZcHe4NZ7WEwtJqZJ+vRIQf75MtsbiH6Oabb8bnn3+On376CZIk4YUXXsChQ4fw/fffY+TIkdaIkSzEqfdE1J6qauvxZVoOACBpEIupL8fFWY2Y0IYFc3dz2MzmWNxDlJ2djdGjR2P06NGNnktJSUFiYmKbBEYtJ880K2RCRETW9/2+M9BX1iLU2xVDegQqHY5Ni4/0wd5Txdh9sgi39Q9TOhy6iMU9RCNHjsS5c+caHf/9998xZsyYNgmKWseYEGUWlMNg4Dg1EVnXyp0NU+0nJURArXLsfcuaEx9lXKCRPUS2xuKE6LrrrsOoUaNQWvrX1hC//vorbrzxRsydO7dNg6OWifR1g7NaQmVtPc7oK5UOh4g6sAM5euzLLoazWsIdA8KVDsfmGWea/ZlfBn0FZ2bbEosToo8++gidO3fGTTfdhKqqKmzZsgU33XQTXnrpJTz22GPWiJEs5KRWIcrPHQDriIjIulZeKKYeG9MJ/h5ahaOxff4eWnT2b/j5vOcU1yOyJRYnRJIkYfXq1XBxccHw4cMxfvx4LFiwAI8++qg14qMW4orVRGRt+opafLvvNAAWU1vir+n3HDazJWYVVe/fv7/Rsblz5+LOO+/ElClTcP3118tt+vTp07YRUovIdUQsrCYiK/l6Tw6qag2IDvKUf8lT8+KjfPBlWg5XrLYxZiVEffv2hSRJJgtJGb9esmQJPvroIwghIEkS6uvrrRYsmc+YEB3NZ0JERG1PCIGVF1amnjIoEpLEYmpzxV3Y+X5fdjFq6gzQOFk8WENWYFZCdOLECWvHQW1MXq26sExOVomI2sqOzHM4XlgOd40at/YLVTocu9I1wB0+bs4oqqhFxhk9+kewd80WmJUQRUY2jA3X1tbivvvuw/PPP48uXbpYNTBqna4BHpAkoLiiFufKa1jsSERtytg7NKFfKDy0Fi9p59AkSUJcpC82HspHWlYREyIbYVE/nbOzM9atW2etWKgNuWrUCPV2BcDCaiJqW/klVfj5YD4AYEoii6lbIj6qIQniitW2w+KBy1tvvRXffPONFUKhtsaZZkRkDWt2ZaPeIBAf6YNenbyUDscuGYvQ005yo1dbYXE/Z7du3fCvf/0L27dvR1xcHNzd3U2enzlzZpsFR63TLcADvxwpZEJERG2mrt6A1bsaVqbmVPuWiw3TQeOkwtmyGmSdq5DXJiLlWJwQ/ec//4G3tzfS0tKQlpZm8pwkSUyIbAin3hNRW9t4qAB5JVXwc9dgTEyw0uHYLa2TGn1Cddh9sgi7s84zIbIBFidEnHFmPzhkRkRtzbgy9cQB4dA6qRWOxr7FRflg98kipJ0swt/iue2J0lq1+IEQgmOfNsyYEOXqq1BWXadwNERk706cLce2Y2chScCkgRFKh2P3BlxYj4grVtuGFiVEn376KWJjY+Hq6gpXV1f06dMHK1asaOvYqJW83TTydPtM9hIRUSututA7NLRHAMJ93RSOxv4ZN3rNLCxHUXmNwtGQxQnRokWL8OCDD+LGG2/EF198gc8//xxjxozBAw88gLfeessaMVIrdAvkJq9E1HpVtfX4Mi0HAIup24qPuwZdAxp+RqdxGw/FWVxD9N577+GDDz7AXXfdJR+75ZZbcNVVV2HevHnc8d7GdAv0QMrx8zjGwmoiaoXv952BvrIWod6uGNIjUOlwOoz4SF9kFpYj9eR5jOgdpHQ4Ds3iHqLc3FwMHjy40fHBgwcjNze3TYKittMtgIXVRNR6xmLqyYkRUKu4FVBbMS7QmJbFHiKlWZwQdevWDV988UWj459//jm6d+/eJkFR2+kW6AmANURE1HL7c4qxL0cPZ7WEiZwN1abioxoKq/ef1qO6jpujK8niIbMXX3wRd9xxB3799Vdcc801kCQJ27Ztw6ZNm5pMlEhZxplmJ89XcFdlImoRY+/QjbGduC9iG4vyc4OfuwbnymuQcVqPuAszz6j9Wfzb8f/+7/+wc+dO+Pv745tvvsHatWvh7++PXbt24dZbb7VGjNQKQV5aeGidUG8QyDpXrnQ4RGRn9BW1+G7fGQDct8waJEmSh81SOWymqBZtURwXF4eVK1e2dSxkBZIkoWugB/ZlF+NYQRl6BHkqHRIR2ZGv9+SgqtaA6CBPef8talvxkb74+WA+dmcVAUOUjsZxWdxDNHnyZHz88cc4evSoNeIhK2BhNRG1hBACK3c2DJdNGRQJSWIxtTXEGQurT57nYscKsjgh8vDwwJtvvono6GiEhITgzjvvxIcffojDhw9bIz5qA8Y6oqNMiIjIAjsyz+F4YTncNWrc2i9U6XA6rJgQHbROKhRV1CKzkKUNSrE4IVqyZAkOHz6MM2fOYNGiRdDpdHjnnXdw1VVXoVOnTtaIkVqJe5oRUUusuFBMfWv/UHhoW1RhQWbQOKlwdbg3gIZeIlJGi6cceXp6wsfHBz4+PvD29oaTkxOCg7nzsS0yJkTHC8tQb2B3LBE1L7+kCuv/yAfAYur2YKzP2s3CasVYnBA9/fTTSExMhL+/P5577jnU1NRgzpw5yM/Px969e60RI7VSuI8rNGoVqusMOF1UqXQ4RGQHVu86hXqDwIAoH/QM9lI6nA7PONNsN7fwUIzFfaCvv/46AgICMHfuXNxyyy3o1auXNeKiNuSkVqGzvzuO5JfiWGEpIvy4KSMRXV5dvQFrdmUDYO9Qe4mLaFh/6MTZcpwtq+Z6TwqwuIdo7969ePbZZ7Fr1y5cf/31CA4Oxh133IEPPvgAhw4dskaM1AZYR0RE5tp4qAB5JVXwc9dgTAxLIdqDzs0ZPYIafk5zo1dlWJwQXX311Zg5cybWrl2LwsJC/Pzzz3Bzc8PMmTMRExNjjRipDXRlQkREZjKuTD1xQDi0TmqFo3EcxlWqmRApo0VF1Xv37sVbb72FW265BcOGDcOKFStw9dVX4/HHH29xIAsWLIAkSZg1a5Z8TAiBefPmISQkBK6urhg6dCgOHjxo8rrq6mrMmDED/v7+cHd3x/jx45GTk2PSpqioCElJSdDpdNDpdEhKSkJxcXGLY7VH7CEiInMcLyzDtmNnIUnApIERSofjUAbIK1ZzppkSLE6IfHx8MHDgQKxatQrdu3fHp59+ivPnz2P37t14/fXXWxREamoqPvroI/Tp08fk+MKFC7Fo0SIsXrwYqampCA4OxsiRI1FaWiq3mTVrFtatW4c1a9Zg27ZtKCsrw7hx41Bf/9cmeZMmTUJ6ejqSk5ORnJyM9PR0JCUltShWe3Xx4oxc+IuILmfVzlMAgGHRgQj3Zb1he4q/0EOUcVqPqlpu9NreLC6qXrFiBa6//np4ebXNrIOysjJ59euXX35ZPi6EwNtvv41nn30Wt912GwBg+fLlCAoKwmeffYb7778fer0en3zyCVasWIERI0YAAFauXInw8HBs3LgRo0ePxqFDh5CcnIyUlBQkJCQAAD7++GMMGjQIR44cQXR0dJu8D1vXJcAdKgkoqapDYVk1Aj1dlA6JiGxMZU09vkpr6GGfksjeofYW7uuKAE8tCkursT9Hj4GdudFre7K4h2jcuHFtlgwBwMMPP4ybbrpJTmiMTpw4gby8PIwaNUo+ptVqMWTIEGzfvh0AkJaWhtraWpM2ISEhiImJkdvs2LEDOp1OToYAIDExETqdTm7TlOrqapSUlJg87JmLs1r+a4/DZkTUlO/3n4G+shZhPq4Y0iNQ6XAcjiRJHDZTUIsXZmwLa9aswZ49e7BgwYJGz+Xl5QEAgoKCTI4HBQXJz+Xl5UGj0cDHx+eKbQIDG//DDgwMlNs0ZcGCBXLNkU6nQ3h4uGVvzgYZh80ymRARURNWXSimnpQQAbWK+5YpgYXVylEsIcrOzsajjz6KlStXwsXl8sM3l24mKIRodoPBS9s01b6588yZMwd6vV5+ZGdnX/Ga9oCF1UR0OftzirEvRw9ntYSJ8fb/B6C9Mq5YnXayCAbuLNCuFEuI0tLSUFBQgLi4ODg5OcHJyQlbt27Fu+++CycnJ7ln6NJenIKCAvm54OBg1NTUoKio6Ipt8vPzG12/sLCwUe/TxbRaLby8vEwe9k6eel/IhIiITBmn2t8Y24mLAiqod4gXXJ3V0FfW8md1OzMrIerfv7+cdLz00kuoqKho9YWHDx+OAwcOID09XX7Ex8dj8uTJSE9PR5cuXRAcHIwNGzbIr6mpqcHWrVsxePBgAEBcXBycnZ1N2uTm5iIjI0NuM2jQIOj1euzatUtus3PnTuj1ermNo2APERE1RV9Ri+/2nQHAlamV5qxWoe+FjV65r1n7MishOnToEMrLywEAL774IsrKWv8L1dPTEzExMSYPd3d3+Pn5ISYmRl6TaP78+Vi3bh0yMjIwdepUuLm5YdKkSQAAnU6HadOm4YknnsCmTZuwd+9eTJkyBbGxsXKRdq9evTBmzBhMnz4dKSkpSElJwfTp0zFu3DiHmWFmZEyI8kuqUVJVq3A0RGQrvtqTg6paA3oGe8pDNqScv/Y1Y2F1ezJr2n3fvn3xj3/8A9deey2EEHjjjTfg4eHRZNsXXnihzYKbPXs2Kisr8dBDD6GoqAgJCQlYv349PD095TZvvfUWnJycMHHiRFRWVmL48OFYtmwZ1Oq/VlddtWoVZs6cKc9GGz9+PBYvXtxmcdoLLxdnBHpqUVBajcyCMvSL4A8+IkcnhJCLqScnRjZbo0nWF3dRHRG1H0mYsUrfkSNHMHfuXGRmZmLPnj3o3bs3nJwa51KSJGHPnj1WCVRpJSUl0Ol00Ov1dl1PNOnjFGzPPIfXb++Dv7Fwksjh/X7sLCb/ZyfcNWrsfHYEPLQWL09HbaykqhZXv7geQgC7nh3OdeNaydzf32Z98qOjo7FmzRoAgEqlwqZNm5qcyk62r1ugB7ZnnmMdEREB+KuY+tb+oUyGbISXizOigzxxOK8UaVlFGBvbSemQHILFs8wMBgOTITvGwmoiMsovqcL6Pxpm4bKY2rb8VUfEYbP20qJp95mZmZgxYwZGjBiBkSNHYubMmcjMzGzr2MgK5D3NOJ2TyOGt3nUK9QaBAVE+6Blsv6UAHdGAqIYFGndzxep2Y3FC9PPPP6N3797YtWsX+vTpg5iYGOzcuRNXXXWVyfR3sk3GHqLs8xXcPJDIgdXWG7B6V8NGruwdsj3GwuqDZ0pQWcOf1e3B4gHjZ555Bo899hheffXVRseffvppjBw5ss2Co7YX4KmFp4sTSqvqcOJsOXp14l+FRI5o06F85JdUw89dgzExwUqHQ5cI9XZFsJcL8kqqkJ5djEFd/ZQOqcOzuIfo0KFDmDZtWqPj99xzD/744482CYqsR5Ik1hEREVamNPQOTRwQDq2TupnW1N4kSUKcsY6Iw2btwuKEKCAgAOnp6Y2Op6ens9jaTsh1REyIiBzS8cIybDt2FpIETBoYoXQ4dBkDIllY3Z4sHjKbPn067rvvPhw/fhyDBw+GJEnYtm0bXnvtNTzxxBPWiJHaWDfuaUbk0FbtbOgdGhYdiHBfN4WjocuJv1BYvedUw0avKhUXzbQmixOi559/Hp6ennjzzTcxZ84cAEBISAjmzZuHmTNntnmA1PaMCVEme4iIHE5lTT2+SssBAExJZO+QLesZ7Ak3jRqlVXX4s6CUMwGtzOIhM0mS8NhjjyEnJwd6vR56vR45OTl49NFHueS7nege2LD1yfGz5ag3NLtQORF1IN/vPwN9ZS3CfFwxpAfLHGyZk1qF/he2WErlRq9W16J1iIw8PT1N9hUj+xDq4wqtkwo1dQZkn69QOhwiakfGfcsmJURAzSEYmyfva8bCaqtrVUJE9kmtktCFhdVEDmd/TjH25eihUaswkXsZ2gWuWN1+mBA5KBZWEzke475lY2OD4e+hVTgaMke/CB+oJCCnqBJ5+iqlw+nQmBA5KE69J3Is+opafLfvDAAgiStT2w0PrZO8gO7ukxw2syaLEqLa2loMGzYMf/75p7XioXbCxRmJHMtXe3JQVWtAz2BPuS6F7EO8cT0iFlZblUUJkbOzMzIyMjibrAO4eOq9EJxpRtSRCSHkYurJiZH8GW5n4owbvbKHyKosHjK766678Mknn1gjFmpHUf5uUElAaXUdCkqrlQ6HiKxoe+Y5HD9bDneNGrf2C1U6HLLQgAuF1YdyS1FeXadwNB2XxQsz1tTU4D//+Q82bNiA+Ph4uLu7mzy/aNGiNguOrEfrpEaknztOnC3H0fwyBHm5KB0SEVmJsZj61v6h8NBa/GOfFNZJ54pQb1ecLq5EenYxrunmr3RIHZLF/zIyMjLQv39/AGhUS8RuWPvSNcADJ86W41hBKa7tzn9gRB1Rnr4K6//IBwBMYTG13YqL9MHp4krszipiQmQlFidEW7ZssUYcpIBugR7YeCifU++JOrA1qadQbxAYEOXDrR/s2IAoH3y37wzriKyoxdPujx07hp9//hmVlZUAwMJcO8SZZkQdW229Aat3NWzkyt4h+xYX2VBYvfdUMbdcshKLE6Jz585h+PDh6NGjB2688Ubk5uYCAO69917udm9n/kqIyhWOhIisYdOhfOSXVMPPXYMxMcFKh0OtEB3sCU+tE8qq63A4r0TpcDokixOixx57DM7Ozjh16hTc3Nzk43fccQeSk5PbNDiyrq4BDQXxZ8uqoa+oVTgaImprK1MaeocmDgiH1kmtcDTUGmqVhH5cj8iqLE6I1q9fj9deew1hYWEmx7t3746TJ0+2WWBkfZ4uzgi+MLvsWGGpwtEQUVs6XliGbcfOQpKASQMjlA6H2oC8QCP3NbMKixOi8vJyk54ho7Nnz0Kr5d449oZ1REQd06qdDb1Dw6IDEe7b+Gc22R9jQsSd763D4oTo+uuvx6effip/LUkSDAYDXn/9dQwbNqxNgyPrY0JE1PFU1tTjy93ZALhvWUfSN8IbapWEM/oqnC6uVDqcDsfiafevv/46hg4dit27d6OmpgazZ8/GwYMHcf78efz+++/WiJGsqCsTIqIO5/v9Z1BSVYcwH1dc3yNA6XCojbhpnHBViBf25+ixO+s8Qvty1fG2ZHEPUe/evbF//34MHDgQI0eORHl5OW677Tbs3bsXXbt2tUaMZEXdjQkR1yIi6jCMK1NPToiEWsUFczsS48a8aawjanMtWsM9ODgYL774YlvHQgowDpnlFFWiqrYeLs6ciUJkz/bnFGN/jh4atQoT48OafwHZlfhIXyz9PYszzaygRQlRUVERPvnkExw6dAiSJKFXr174xz/+AV9f37aOj6zMz10DbzdnFFfUIrOwDFeF6JQOiYhawdg7NDY2GH4enOjS0cRf2Oj1cF4JSqtq4enirHBEHYfFQ2Zbt25F586d8e6776KoqAjnz5/Hu+++i86dO2Pr1q3WiJGsSJIkdAtgHRFRR6CvqMV3+84AYDF1RxXk5YJwX1cYRMOq1dR2LE6IHn74YUycOBEnTpzA2rVrsXbtWhw/fhx///vf8fDDD1sjRrIy47BZJhMiIrv21Z4cVNUa0DPYU641oY4n/sI2HlyPqG1ZnBBlZmbiiSeegFr9V62JWq3G448/jszMzDYNjtpHNxZWE9k9IQRWXRgum5IYCUliMXVHZRw22831iNqUxQlR//79cejQoUbHDx06hL59+7ZFTNTOOPWeyP5tzzyH42fL4a5RY0I/TsfuyIw9ROnZxairNygcTcdhVlH1/v375f+fOXMmHn30URw7dgyJiYkAgJSUFLz//vt49dVXrRMlWZWxhujE2XLU1RvgpLY4TyYiha3Y0dA7dFv/MHhoWzRfhuxE90APeLk4oaSqDodySxEbxskwbcGsfzV9+/aFJEkQQsjHZs+e3ajdpEmTcMcdd7RddNQuQr1d4eqsRmVtPU6er0DXCwkSEdmHPH0VNhzKB9AwXEYdm0oloX+kD345UojUrPNMiNqIWQnRiRMnrB0HKUilktAlwB0Hz5TgWEEZEyIiO7Mm9RTqDQIDonwQHeypdDjUDgZE+eKXI4VIO1mEe67trHQ4HYJZCVFkJP/i6Oi6BXrICdHoq5SOhojMVVtvwOpdDRu5snfIcRhnEe4+eR5CCBbRt4EWDTSfPn0av//+OwoKCmAwmBZ0zZw5s00Co/ZlrCPi1Hsi+7LpUD7yS6rh567BmJhgpcOhdnJ1mDecVBLyS6qRU1SJcF83pUOyexYnREuXLsUDDzwAjUYDPz8/k6xUkiQmRHaKU++J7NOKC1Pt7xgQDq0Tt95xFK4aNWJCdUjPLsbuk+eZELUBi6cTvfDCC3jhhReg1+uRlZWFEydOyI/jx49bI0ZqBxcvznhx8TwR2a7MwjL8fuwcJAm4c2CE0uFQO4s3DptxX7M2YXFCVFFRgb///e9QqTg1uyOJ9HOHWiWhvKYeufoqpcMhIjOsSmmoHbohOpA9BA7IuEBjGlesbhMWZzXTpk3Dl19+aY1YSEEaJxUi/Rp+oHKBRiLbV1lTj6/SsgGwmNpRxV1YoPFIfin0lbUKR2P/LK4hWrBgAcaNG4fk5GTExsbC2dl0p91Fixa1WXDUvroFeOB4YTmOFZTh+h4BSodDRFfw/f4zKKmqQ5iPK/+9OqgATy2i/NyQda4Ce04VYVh0oNIh2TWLE6L58+fj559/RnR0NAA0Kqom+9Ut0APr/8hnYTWRHVh5oZh6ckIk1Cr+7HVUcZG+yDpXgbQsJkStZXFCtGjRIvz3v//F1KlTrRAOKal7EPc0I7IH+7KLsT9HD41ahYnxYUqHQwqKj/LB13tykMqNXlvN4hoirVaLa665xhqxkMK6BTSscMu1iIhsm7F36MbYYPh5aBWOhpQ04EJh9b6cYtRyo9dWsTghevTRR/Hee++1ycU/+OAD9OnTB15eXvDy8sKgQYPwv//9T35eCIF58+YhJCQErq6uGDp0KA4ePGhyjurqasyYMQP+/v5wd3fH+PHjkZOTY9KmqKgISUlJ0Ol00Ol0SEpKQnFxcZu8h46ka6A7AOBceQ2KymsUjoaImqKvqMV3+84AYDE1AV38PeDt5oyqWgMOnilROhy7ZnFCtGvXLixfvhxdunTBzTffjNtuu83kYYmwsDC8+uqr2L17N3bv3o0bbrgBt9xyi5z0LFy4EIsWLcLixYuRmpqK4OBgjBw5EqWlpfI5Zs2ahXXr1mHNmjXYtm0bysrKMG7cONTX18ttJk2ahPT0dCQnJyM5ORnp6elISkqy9K13eG4aJ4R6uwLgAo1EturLtGxU1xnQM9hT3r6BHJdKJSEuwrgeEYfNWsPiGiJvb2+LE5/Lufnmm02+fuWVV/DBBx8gJSUFvXv3xttvv41nn31Wvt7y5csRFBSEzz77DPfffz/0ej0++eQTrFixAiNGjAAArFy5EuHh4di4cSNGjx6NQ4cOITk5GSkpKUhISAAAfPzxxxg0aBCOHDkiF4dTg66BHjhdXIljBWUYEOWrdDhEdBEhBD7b+de+ZZzIQgAQH+WLTYcLsDurCPdep3Q09qtFW3dYQ319Pb788kuUl5dj0KBBOHHiBPLy8jBq1Ci5jVarxZAhQ7B9+3bcf//9SEtLQ21trUmbkJAQxMTEYPv27Rg9ejR27NgBnU4nJ0MAkJiYCJ1Oh+3bt182IaqurkZ1dbX8dUmJY3RFdgvwwK9/FrKwmsgGbc88h+Nny+GuUWNCv1ClwyEbYVygcffJIm702gqKLzd94MABeHh4QKvV4oEHHsC6devQu3dv5OXlAQCCgoJM2gcFBcnP5eXlQaPRwMfH54ptAgMbT0UMDAyU2zRlwYIFcs2RTqdDeHh4q96nvZD3NGNCRGRzVuxoKKa+rX8YPLQt2pubOqDYUB00ahXOllXj1PkKpcOxWxb/i+rcufMVs09L9zOLjo5Geno6iouL8fXXX+Puu+/G1q1b5ecvvZY52e+lbZpq39x55syZg8cff1z+uqSkxCGSIiZERLYpT1+FDYfyAbCYmky5OKsRE+qFPaeKkZpVhEg/d6VDsksWJ0SzZs0y+bq2thZ79+5FcnIynnrqKYsD0Gg06NatGwAgPj4eqampeOedd/D0008DaOjh6dSpk9y+oKBA7jUKDg5GTU0NioqKTHqJCgoKMHjwYLlNfn5+o+sWFhY26n26mFarhVbreNNZjQnR6eJKlFfXwZ1/hRLZhNW7TqHeIDAwyhfRwZ5Kh0M2ZkCUL/acKkbayfO4PY5rU7WExb/tHn300SaPv//++9i9e3erAxJCoLq6Gp07d0ZwcDA2bNiAfv36AQBqamqwdetWvPbaawCAuLg4ODs7Y8OGDZg4cSIAIDc3FxkZGVi4cCEAYNCgQdDr9di1axcGDhwIANi5cyf0er2cNNFffN018HXX4Hx5DY4XliM2TKd0SEQOr7begDWpDcXUkxO5qz01ZpxxuDuLG722VJvVEI0dOxZff/21Ra/55z//id9++w1ZWVk4cOAAnn32Wfzyyy+YPHkyJEnCrFmzMH/+fKxbtw4ZGRmYOnUq3NzcMGnSJACATqfDtGnT8MQTT2DTpk3Yu3cvpkyZgtjYWHnWWa9evTBmzBhMnz4dKSkpSElJwfTp0zFu3DjOMLuMbgEXhs0KS5tpSUTtYeMf+cgvqYa/hwZjYoKVDodskDEhOlpQhuIKriPXEm02HvLVV1/B19eyadr5+flISkpCbm4udDod+vTpg+TkZIwcORIAMHv2bFRWVuKhhx5CUVEREhISsH79enh6/tVd/NZbb8HJyQkTJ05EZWUlhg8fjmXLlkGtVsttVq1ahZkzZ8qz0caPH4/Fixe3wbvumLoGemBX1nnWERHZiJU7G4qpJ8aHQ+ukbqY1OSI/Dy26BLjjeGE50k4WYXivy5eEUNMkIYSw5AX9+vUzKUYWQiAvLw+FhYX497//jfvuu6/Ng7QFJSUl0Ol00Ov18PLyUjocq/pk2wn864c/MPqqICxJilc6HCKHlllYhuFvboUkAb8+NQzhvm5Kh0Q2avZX+/DF7hw8OLQrnh7TU+lwbIa5v78t7iGaMGGCydcqlQoBAQEYOnQoevbkN6Aj4EwzItuxKqWhduiG6EAmQ3RF8ZG++GJ3DtJYR9QiFidEc+fOtUYcZEOMCdHJcxWorTfAWa34clVEDqmyph5fpWUD4FR7ap5xgcb0nGJU19VzeNVC/E1HjYToXOCmUaPOIHDyXLnS4RA5rO/3nUFJVR3CfV1xfY8ApcMhG9fZ3x1+7hrU1BmQcdoxdldoS2YnRCqVCmq1+ooPJyeuWdMRSJKErgEcNiNSmrGYetLASKhV3I6BrkySJPS/MNss7SQ3erWU2RnMunXrLvvc9u3b8d5778HC+myyYd0CPXDgtJ4JEZFC9mUXY3+OHhq1ChPjudAemSc+0gcb/shHalYR7rte6Wjsi9kJ0S233NLo2OHDhzFnzhx8//33mDx5Mv71r3+1aXCkHBZWEylrZUpD79CNscHw83C8VfOpZeKjGpa/2cONXi3WohqiM2fOYPr06ejTpw/q6uqQnp6O5cuXIyKCK6h2FHJCVMiEiKi96Stq8d2+MwBYTE2WiQn1gsZJhXPlNThxljWglrAoIdLr9Xj66afRrVs3HDx4EJs2bcL333+PmJgYa8VHCjEmRJkF5TAYOBRK1J6+TMtGdZ0BPYM95RWIicyhdVLj6gtbLnEbD8uYnRAtXLgQXbp0wQ8//IDVq1dj+/btuO6666wZGyko0tcNzmoJlbX1OKOvVDocIodhMAis2tmw9tCUxEgOeZDFjMNmu1lYbRGza4ieeeYZuLq6olu3bli+fDmWL1/eZLu1a9e2WXCkHCe1ClF+7jhaUIZjBWUI8+GCcETtYXvmOZw4Ww4PrRMm9AtVOhyyQ/HGjV5PsofIEmYnRHfddRf/UnEw3QI95IRoaHSg0uEQOQRjMfWt/ULhoeVSJmQ54zDr8cJynCurZlG+mcz+17Zs2TIrhkG2SK4jYmE1UbvI01dhw6F8ACymppbzdtOg+4U/aNNOFmHUVcFKh2QXuFI1XZYxITqaz4SIqD2s3nUK9QaBgVG+iA72VDocsmPGbTzSOGxmNiZEdFnyatWFZVx0k8jKausNWJPaUEw9OZFLmFDrxEUaC6uZEJmLCRFdVtcAD0gSUFxRi3PlNUqHQ9ShbfwjH/kl1fD30GBMDIc4qHWMhdUHcvSoqq1XOBr7wISILstVo0aotysArlhNZG3Gfcsmxodzl3JqtUg/N/h7aFFTb8CB03qlw7ELTIjoiriFB5H1ZRaW4fdj5yBJwKQEDpdR60mS9Nf0ey7QaBYmRHRF3bjrPZHVrUppqB26ITqQa35RmzEWVu/O4gKN5mBCRFfEqfdE1lVZU4+v0rIBcKo9tS3jitVpp4q4BZMZmBDRFXHIjMi6vt93BiVVdQj3dcX1PQKUDoc6kKtCvODirEJxRS2On+XP8OYwIaIrMiZEufoqlFXXKRwNUcdjLKaeNDASahV3A6C246xW4eowbwCsIzIHEyK6Im83Dfw9NACATPYSEbWpfdnF2J+jh0atwsT4MKXDoQ5owIVhs1QmRM1iQkTN4rAZkXUY9y27MTaY+02RVcTJK1azsLo5TIioWXJCxMJqojZTXFGD7/adAQAkDWIxNVlH/wgfSBKQda4ChaXVSodj05gQUbM49Z6o7X2VloPqOgN6Bnuif4SP0uFQB6VzdUaPwIZ98dhLdGVMiKhZ3S78Y2INEVHbMBgEVu1sWHtoSmIkJInF1GQ9f61HxDqiK2FCRM0yDpmdPF+BmjqDwtEQ2b/tmedw4mw5PLROmNAvVOlwqIOTEyJu9HpFTIioWUFeWnhonVBvEMg6V650OER2z1hMfWu/UHhonRSOhjq6+As732ec1qOyhhu9Xg4TImqWJEnoyplmRG0iT1+FDYfyAXBlamofYT6uCPLSos4gsC+nWOlwbBYTIjILC6uJ2sbqXadQbxAYGOWL6GBPpcMhB9Cw0euFbTw4bHZZTIjILMY6oqNMiIharLbegNW7LhRTc6o9taO4SG702hwmRGQWLs5I1Hob/8hHQWk1/D00GHNVsNLhkAMxrliddpIbvV4OEyIyizEhOl5Yhnr+YyJqkRUXiqknxodD48Qfv9R+enXyhJtGjZKqOvb0Xwb/RZJZwn1coVGrUF1nwOmiSqXDIbI7mYVl2J55DpIETEqIUDoccjBOahX6hnsDAHZzgcYmMSEiszipVejs7w4AOFZYqnA0RPZnVUpD7dAN0YEI83FTOBpyRPGRXKDxSpgQkdlYR0TUMpU19fgqLRsAi6lJOfEX6ojYQ9Q0JkRkNq5FRNQy3+87g5KqOoT7umJI9wClwyEH1S/CGyoJyD5fifySKqXDsTlMiMhs7CEiahljMfXkhEioVNy3jJTh6eKM6GAvABw2awoTIjLbxYszCsGZZkTm2JddjAOn9dCoVfhbXJjS4ZCDGyDva8Zhs0sxISKzdQlwhyQBJVV1KCyrVjocIrtg7B26MTYYfh5ahaMhR2dcoJErVjfGhIjM5uKsRoRvw+wYDpsRNa+4ogbf7zsDAEhiMTXZAGNh9cEzJaioqVM4GtvChIgsYhw2y2RCRNSsr9JyUF1nQM9gT/SP8FE6HCKEersiROeCeoNA+qlipcOxKUyIyCIsrCYyj8EgsGpnw9pDSYMiIUkspibbECdPv+ew2cWYEJFF5Kn3hUyIiK5ke+Y5nDhbDg+tEyb0DVU6HCKZvEAjEyITTIjIIuwhIjLPipQsAMBt/UPhrnVSNhiiixgLq/ecLOLelBdhQkQWMSZE+SXVKKmqVTgaItuUq6/ExkMFAIApiSymJtvSM9gTHlonlFXX4Uget2IyUjQhWrBgAQYMGABPT08EBgZiwoQJOHLkiEkbIQTmzZuHkJAQuLq6YujQoTh48KBJm+rqasyYMQP+/v5wd3fH+PHjkZOTY9KmqKgISUlJ0Ol00Ol0SEpKQnFxsbXfYofj5eKMQM+GqcMsrCZq2upd2ag3CAyM8kWPIE+lwyEy4aRWoV+ENwAgjesRyRRNiLZu3YqHH34YKSkp2LBhA+rq6jBq1CiUl5fLbRYuXIhFixZh8eLFSE1NRXBwMEaOHInS0r+y2lmzZmHdunVYs2YNtm3bhrKyMowbNw719fVym0mTJiE9PR3JyclITk5Geno6kpKS2vX9dhTGXqKjTIiIGqmtN2DNroZiau5bRrbKOGyWyhWrZYoObCcnJ5t8vXTpUgQGBiItLQ3XX389hBB4++238eyzz+K2224DACxfvhxBQUH47LPPcP/990Ov1+OTTz7BihUrMGLECADAypUrER4ejo0bN2L06NE4dOgQkpOTkZKSgoSEBADAxx9/jEGDBuHIkSOIjo5u3zdu57oFemB75jn2EBE1YeMf+SgorYa/hwZjrgpWOhyiJg24MNOMCzT+xaZqiPR6PQDA17fhG3XixAnk5eVh1KhRchutVoshQ4Zg+/btAIC0tDTU1taatAkJCUFMTIzcZseOHdDpdHIyBACJiYnQ6XRyGzIfC6uJLs+4MvUdA8KhcbKpH7FEsr7h3lCrJJwurkSuvlLpcGyCzfxrFULg8ccfx7XXXouYmBgAQF5eHgAgKCjIpG1QUJD8XF5eHjQaDXx8fK7YJjAwsNE1AwMD5TaXqq6uRklJicmDGsh7mnHqPZGJYwVl2J55DpIE3DkwQulwiC7LXeuEXp0a6tu40WsDm0mIHnnkEezfvx+rV69u9NylC5oJIZpd5OzSNk21v9J5FixYIBdg63Q6hIeHm/M2HIKxhyj7fAWqauubaU3kOFbtbOgdGt4zEGE+bgpHQ3Rl8ZEXFmjMYmE1YCMJ0YwZM/Ddd99hy5YtCAv7azfo4OCG8fdLe3EKCgrkXqPg4GDU1NSgqKjoim3y8/MbXbewsLBR75PRnDlzoNfr5Ud2dnbL32AHE+CphaeLEwwCOHG2vPkXEDmAipo6fJXWMLt1Mqfakx2Ij+ICjRdTNCESQuCRRx7B2rVrsXnzZnTu3Nnk+c6dOyM4OBgbNmyQj9XU1GDr1q0YPHgwACAuLg7Ozs4mbXJzc5GRkSG3GTRoEPR6PXbt2iW32blzJ/R6vdzmUlqtFl5eXiYPaiBJEuuIiC7x/b4zKK2qQ7ivK4Z0D1A6HKJmGXuIDuWWoKyaG70qOsvs4YcfxmeffYZvv/0Wnp6eck+QTqeDq6srJEnCrFmzMH/+fHTv3h3du3fH/Pnz4ebmhkmTJsltp02bhieeeAJ+fn7w9fXFk08+idjYWHnWWa9evTBmzBhMnz4dS5YsAQDcd999GDduHGeYtVC3AA/sPVXMhIjogpUpDVPtJydEQqXivmVk+4J1Lgj1dsXp4krsPVWE6xw8kVc0Ifrggw8AAEOHDjU5vnTpUkydOhUAMHv2bFRWVuKhhx5CUVEREhISsH79enh6/rXY2VtvvQUnJydMnDgRlZWVGD58OJYtWwa1Wi23WbVqFWbOnCnPRhs/fjwWL15s3TfYgXXjnmZEsn3ZxThwWg+NWoW/xYU1/wIiGzEgygen0yuxO4sJkaIJkRDN76EiSRLmzZuHefPmXbaNi4sL3nvvPbz33nuXbePr64uVK1e2JExqgjEh4lpERH9Ntb+pTyf4eWgVjobIfHFRvvgm/QzXI4KNFFWT/TEmRMfPlnNzQHJoxRU1+H7fGQDAlEROtSf7Ytz5fs+pItTVGxSORllMiKhFwnzcoHVSoabOgOzzFUqHQ6SYr9JyUF1nQK9OXugf4dP8C4hsSI8gT3i6OKGiph6HHXyjVyZE1CJqlYQuAZxpRo7NYBBYtfPCvmWJEc2uj0Zka9QqSU7kHX09IiZE1GIsrCZH93vmWZw4Ww4PrRMm9A1VOhyiFjEOmzn6ekRMiKjFurGHiBzcygvF1Lf1D4W7VtE5KkQtFh9lXLG6yKzJTh0VEyJqMS7OSI4sV1+JjYcKAABTuDI12bG+4d5wcVYhr6QKH/16XOlwFMOEiFrs4qn3jvxXBTmm1buyUW8QGNjZFz2CPJt/AZGNctWo8eyNvQAAryUfxrajZxWOSBlMiKjFovzdoJKA0uo6FJRWKx0OUbuprTdgzS5jMTV7h8j+TUmMxO1xYTAIYMbqPQ45e5gJEbWY1kmNSD93AMDRfA6bkePY8Ec+Ckqr4e+hwZirgpUOh6jVJEnCyxNi0CdMh6KKWjywMg1VtfVKh9WumBBRq3SVC6sde/0KcizGYuo7BoRD48Qfo9QxuDir8cGUOPi6a3DwTAn+ufaAQ5VDcFoEtUq3QA9sPJSP93/JxIZD+fBx08DPXQMf97/+63vRw8dNA2c1f4GQ/TpWUIbtmecgScCdA7kyNXUsod6uWDypH5I+2YW1e0+jT5gOU6/prHRY7YIJEbVKYhdffLg1E4Wl1Sg0s47Iy8XJJEnyNSZObppGx33dNfDQOnHBO7IZq3Y29A4N7xmIMB83haMhanuDu/pjztieePnHQ/jXj4fQq5MXErr4KR2W1UnCkfrDWqGkpAQ6nQ56vR5eXl5Kh2NTjheWIbuoEufLq3G+vFb+b1F5Dc6X1+B8RcN/iypq0JJPm0atgo+7c0Pvk4fGpBdKTpzcNPD1aPivjzt7ocg6KmrqkDB/E0qr6rD0HwMwLDpQ6ZCIrEIIgVmfp+Pb9DPw99Dg+xnXopPOVemwWsTc39/sIaJW6xLgIW/jcSX1BgF9ZW1DknTRo6iiBufKGv576XOVtfWoqTcgv6Qa+SXmz2TzdHEyHbq7JGG6dFjPk71QZIbv951BaVUdwn1dMaR7gNLhEFmNJEl49bY+OJJXisN5pXhg5R58cX8itE5qpUOzGiZE1G7UKknu0TFXZU09zlfUoKi8BufKm/6v3AN1IbkyCKC0qg6lVXXIOmfe1FFntdSQNDUxZHdxL5QxifJ207CY1sEIIbDiQjH15IRIqFRMoKljc9Wo8VFSPG5evA37sosx99uDePX/+igdltUwISKb5qpRI1TjilBv87pq6w0CJZW1DcnSFXqeLn6uoqYetfUCBaXVFq2n5HlxLZRb45ooeVjvQu8Ue6Hs274cPTJOl0DjpMLE+HClwyFqFxF+bnj3zn6YunQX1qRmo0+YNyYldMzJBEyIqENRqyT4XEhEzFVVW98oYTp/cf1TWY3cS3W+iV6oky3shbp4OM9YG3XpjDz2QtkO41T7m2I7WdTLSWTvhvQIwJOjovH6z0cw97sMRAd7Iu7ChrAdCRMicnguzmqEeLsixMxeKIOxFqqJnqfzFw/nXfR8i3uhtE7wvaSQ3KSg/JLaKC8X9kJZQ3FFDb7fdwYAMCWxY/51THQlDw3tiozTevwvIw8PrUrD9zOuRaCni9JhtSkmREQWUl3UC9XVzLraS3uhLh6yu7QmyphIGUTDtiil1eb3QjldiO3SQvLL1UWxF8o8X6XloLrOgF6dvNA/ouP9ZUzUHEmS8PrfrsaxgjIcLSjDw6v2YNW9iR3q5wcTIqJ20JJeqJKq2ssXkl9UTG7slSqvqUedQVi0JhTQ0At16QKal9ZGXdwz5Wi9UAaDwKqdxn3LIhzqvRNdzEPrhCVJcbhl8e9IzSrCKz/+gRdviVE6rDbDhIjIBqlUErzdGmazwYJeqCsVkl/cO2X8/4t7oU6ZuZmjsRfqSoXkF9dGebs52/VU3d8zz+LE2XJ4aJ0woW+o0uEQKapLgAfeuqMv7v10N5bvOInYMG/cHhemdFhtggkRUQfh4qxGJ52r2YunGXuhrlRIbux9Mh5raS+Uh9bpsoXkfu4a+HtqMKiLP1w1tpc4GYupb+sfCnctf2QSjegdhEeHd8c7m47in+sOIDrIE7FhOqXDajX+6yZyUBf3QnWxsBfKnELy8+W1KKqoQb1BoKy6DmXN9EIFemrx2Mge+FtcGJxsZKXxXH0lNvyRDwCYkhipcDREtuPR4d2RcVqPTYcL8MDKNHz3yDXw89AqHVarcOsOM3HrDiLLGQwCpVV1OFdefcVC8sN5pcjVVwEAugS4Y/bonhh9VZDi9TqLNvyJdzcdxcDOvvji/kGKxkJka/SVtZjw/u84cbYcg7v64dN7BtrMHzMX49YdRKQ4lUqCzs0ZOjfnK7arrqvHqpRTeG/zURwvLMcDK9PQL8Ibc8b2wsDOvu0UranaegPW7DIWU7N3iOhSOldnLEmKw4T3f8f2zHN4Lfkwnr2pt9JhtZjtpXJE5HC0Tmrcc21nbJ09DDNu6AZXZzX2nirGxCU7cO/yVBzJK233mDb8kY+C0mr4e2gw5qrgdr8+kT3oEeSJN/92NQDg499O4LsL63XZIyZERGQzvFyc8cSoaGx9aigmJ0RArZKw8VABxr7zK576ch/OFFe2WyzGYuo7BoR3qLVWiNra2NhOeHBoVwDA7K/24VBuicIRtQz/lRORzQn0csErt8Zi/WPXY2xMMAwC+DItB0Pf+AULfjoEfUWtVa9/rKAM2zPPQSUBdw7kytREzXlyVDSu6+6PqloD7l+RhuKKGqVDshgTIiKyWV0DPPDBlDisfWgwBnb2RU2dAUt+PY7rFm7Gkq2ZqKqtt8p1V+1s6B26oWcgwnzcrHINoo5ErZLw3p39EO7rilPnK/DomnTUG+xrzhYTIiKyef0jfPD5fYlYOnUAooM8UVJVhwX/O4xhb/yCL3Znt+kP3oqaOnyVlgOAxdRElvB202DJlHi4OKuw9c9CLNpwROmQLMKEiIjsgiRJGNYzED89eh3e+NvVCNG5IFdfhdlf7cfYd37Fxj/y0RariHy/7wxKq+oQ4euG67ubuUATEQEAeod44bX/6wMAeH9LJpIz8hSOyHxMiIjIrqhVEm6PC8PmJ4fi2Rt7QefqjD/zy3Dvp7sxcckOpJ083+JzCyGw4kIx9aSECKhU3LeMyFK39A3FtGs7AwCe+CIdxwraf5ZoSzAhIiK75OKsxvTru+DX2cPw4NCu0DqpkJpVhP/7YAfu+3Q3jhWUWXzOfTl6ZJwugcZJhYnx4VaImsgxzBnbE4ldfFFeU4/7Pk1DSZV1J0K0BSZERGTXdK7OeHpMT/zy1FDcER8OlQSs/yMfo97aijlr9yO/pMrscxmn2t8U2wm+7hprhUzU4TmpVVg8qT866Vxw/Gw5Hv98Hww2XmTNhIiIOoROOle8dnsf/DzreozsHQSDAFbvysaQ17dgYfJh6Cuv/BdqcUUNvr+wqByLqYlaz99Diw+nxEHjpMLGQ/lYvOWY0iFdERMiIupQugd54uO74vHVA4MQF+mDqloD/v1LJoa8vgX/+e04quuanqr/VVoOqusM6NXJC/0jvNs3aKIO6upwb7w8IQYA8NbGP7H5cL7CEV0eEyIi6pDio3zx1QOD8PFd8egW6IHiilq8/OMh3PDGVqzdk2MyVd9gEPJwWVJipOKbyhJ1JBPjwzElMQJCAI+uSceJs+VKh9QkJkRE1GFJkoSRvYOQ/Oh1eO3/YhHkpcXp4ko8/sU+3PTub9hypABCCPyeeRZZ5yrgoXXCLX1DlA6bqMN5YdxViIv0QWlVHe5fsRvl1XVKh9SIJNpi4Q4HUFJSAp1OB71eDy8vL6XDIaIWqKypx7LtWfj3L8dQWtXwAzmxiy/qDQKpWUW4a1AkXrolRuEoiTqmgpIqjHtvGwpKq3FjbDDen9S/XXpjzf39zR4iInIYrho1HhzaFb/NHobp13WGRq1CyvHzSM0qAsBiaiJrCvRywQdT+sNZLeGnA3lY8utxpUMywYSIiByOt5sGz97UG5ufHIL/6x8GSQJG9Q5CjyBPpUMj6tDiIn0x9+arAAALkw/jt6OFCkf0Fw6ZmYlDZkQdV2lVLbROamic+DcikbUJIfD01/vxxe4ceLs54/tHrkW4r/U2UeaQGRGRmTxdnJkMEbUTSZLw0i0xuDpMh+KKWty/Ig2VNU0vh9Ge+BOAiIiI2pWLsxofTImDn7sGf+SWYM7a/W2yOXNrMCEiIiKidhfi7Yr3J/eHWiXhm/QzWPp7lqLxMCEiIiIiRSR28cOzN/YCALzy0yGkHD+nWCxMiIiIiEgx/7gmChP6hsDLxQkGBYfNFE2Ifv31V9x8880ICQmBJEn45ptvTJ4XQmDevHkICQmBq6srhg4dioMHD5q0qa6uxowZM+Dv7w93d3eMHz8eOTk5Jm2KioqQlJQEnU4HnU6HpKQkFBcXW/ndERERUXMkScKC2/rgh5nXYXBXf8XiUDQhKi8vx9VXX43Fixc3+fzChQuxaNEiLF68GKmpqQgODsbIkSNRWloqt5k1axbWrVuHNWvWYNu2bSgrK8O4ceNQX/9XxfqkSZOQnp6O5ORkJCcnIz09HUlJSVZ/f0RERNQ8V40aod6uygYhbAQAsW7dOvlrg8EggoODxauvviofq6qqEjqdTnz44YdCCCGKi4uFs7OzWLNmjdzm9OnTQqVSieTkZCGEEH/88YcAIFJSUuQ2O3bsEADE4cOHzY5Pr9cLAEKv17f0LRIREVE7M/f3t83WEJ04cQJ5eXkYNWqUfEyr1WLIkCHYvn07ACAtLQ21tbUmbUJCQhATEyO32bFjB3Q6HRISEuQ2iYmJ0Ol0chsiIiJybE5KB3A5eXl5AICgoCCT40FBQTh58qTcRqPRwMfHp1Eb4+vz8vIQGBjY6PyBgYFym6ZUV1ejurpa/rqkpKRlb4SIiIhsns32EBlduhOuEKLZ3XEvbdNU++bOs2DBArkIW6fTITw83MLIiYiIyF7YbEIUHBwMAI16cQoKCuReo+DgYNTU1KCoqOiKbfLz8xudv7CwsFHv08XmzJkDvV4vP7Kzs1v1foiIiMh22WxC1LlzZwQHB2PDhg3ysZqaGmzduhWDBw8GAMTFxcHZ2dmkTW5uLjIyMuQ2gwYNgl6vx65du+Q2O3fuhF6vl9s0RavVwsvLy+RBREREHZOiNURlZWU4duyY/PWJEyeQnp4OX19fREREYNasWZg/fz66d++O7t27Y/78+XBzc8OkSZMAADqdDtOmTcMTTzwBPz8/+Pr64sknn0RsbCxGjBgBAOjVqxfGjBmD6dOnY8mSJQCA++67D+PGjUN0dHT7v2kiIiKyOYomRLt378awYcPkrx9//HEAwN13341ly5Zh9uzZqKysxEMPPYSioiIkJCRg/fr18PT0lF/z1ltvwcnJCRMnTkRlZSWGDx+OZcuWQa1Wy21WrVqFmTNnyrPRxo8ff9m1j4iIiMjxSEIovL2snSgpKYFOp4Ner+fwGRERkZ0w9/e3zdYQEREREbUXJkRERETk8JgQERERkcNjQkREREQOz2a37rA1xtpzbuFBRERkP4y/t5ubQ8aEyEylpaUAwC08iIiI7FBpaSl0Ot1ln+e0ezMZDAacOXMGnp6eze6lZm9KSkoQHh6O7OxsLinQArx/rcd72Dq8f63He9g6tnz/hBAoLS1FSEgIVKrLVwqxh8hMKpUKYWFhSodhVdyipHV4/1qP97B1eP9aj/ewdWz1/l2pZ8iIRdVERETk8JgQERERkcNjQkTQarWYO3cutFqt0qHYJd6/1uM9bB3ev9bjPWydjnD/WFRNREREDo89REREROTwmBARERGRw2NCRERERA6PCRERERE5PCZEHcCvv/6Km2++GSEhIZAkCd98843J8/n5+Zg6dSpCQkLg5uaGMWPG4OjRoyZtMjMzceuttyIgIABeXl6YOHEi8vPzTdpERUVBkiSTxzPPPGPtt2d1CxYswIABA+Dp6YnAwEBMmDABR44cMWkjhMC8efMQEhICV1dXDB06FAcPHjRpU11djRkzZsDf3x/u7u4YP348cnJyTNoUFRUhKSkJOp0OOp0OSUlJKC4utvZbtLr2vIcd8XPYVvfvo48+wtChQ+Hl5QVJkpr8bPEz2Pp7yM9g0/fv/PnzmDFjBqKjo+Hm5oaIiAjMnDkTer3e5Dy2+hlkQtQBlJeX4+qrr8bixYsbPSeEwIQJE3D8+HF8++232Lt3LyIjIzFixAiUl5fLrx81ahQkScLmzZvx+++/o6amBjfffDMMBoPJ+V566SXk5ubKj+eee65d3qM1bd26FQ8//DBSUlKwYcMG1NXVYdSoUfL9AYCFCxdi0aJFWLx4MVJTUxEcHIyRI0fKe9wBwKxZs7Bu3TqsWbMG27ZtQ1lZGcaNG4f6+nq5zaRJk5Ceno7k5GQkJycjPT0dSUlJ7fp+raE97yHQ8T6HbXX/KioqMGbMGPzzn/+87LX4GWz9PQT4GWzq/p05cwZnzpzBG2+8gQMHDmDZsmVITk7GtGnTTK5ls59BQR0KALFu3Tr56yNHjggAIiMjQz5WV1cnfH19xccffyyEEOLnn38WKpVK6PV6uc358+cFALFhwwb5WGRkpHjrrbes/h6UVlBQIACIrVu3CiGEMBgMIjg4WLz66qtym6qqKqHT6cSHH34ohBCiuLhYODs7izVr1shtTp8+LVQqlUhOThZCCPHHH38IACIlJUVus2PHDgFAHD58uD3eWrux1j0UwjE+hy25fxfbsmWLACCKiopMjvMz2Pp7KAQ/g0ZXun9GX3zxhdBoNKK2tlYIYdufQfYQdXDV1dUAABcXF/mYWq2GRqPBtm3b5DaSJJksqOXi4gKVSiW3MXrttdfg5+eHvn374pVXXkFNTU07vIv2Zeze9fX1BQCcOHECeXl5GDVqlNxGq9ViyJAh2L59OwAgLS0NtbW1Jm1CQkIQExMjt9mxYwd0Oh0SEhLkNomJidDpdHKbjsJa99Coo38OW3L/zMHPYOvvoRE/g+bdP71eDy8vLzg5NWydasufQW7u2sH17NkTkZGRmDNnDpYsWQJ3d3csWrQIeXl5yM3NBdDwYXR3d8fTTz+N+fPnQwiBp59+GgaDQW4DAI8++ij69+8PHx8f7Nq1C3PmzMGJEyfwn//8R6m31+aEEHj88cdx7bXXIiYmBgCQl5cHAAgKCjJpGxQUhJMnT8ptNBoNfHx8GrUxvj4vLw+BgYGNrhkYGCi36QiseQ+Bjv85bOn9Mwc/g62/hwA/gxe70v07d+4c/vWvf+H++++Xj9nyZ5AJUQfn7OyMr7/+GtOmTYOvry/UajVGjBiBsWPHym0CAgLw5Zdf4sEHH8S7774LlUqFO++8E/3794darZbbPfbYY/L/9+nTBz4+Prj99tvlv5Q6gkceeQT79+9v1DMGAJIkmXwthGh07FKXtmmqvTnnsSfWvocd/XPY1vevuXO09Dy2zNr3kJ/Bv1zu/pWUlOCmm25C7969MXfu3Cue40rnaU8cMnMAcXFxSE9PR3FxMXJzc5GcnIxz586hc+fOcptRo0YhMzMTBQUFOHv2LFasWIHTp0+btLlUYmIiAODYsWNWfw/tYcaMGfjuu++wZcsWhIWFyceDg4MBoNFfLwUFBfJfS8HBwaipqUFRUdEV21w6cw8ACgsLG/3VZa+sfQ+b0pE+h625f+bgZ7D197Ap/Aya3r/S0lKMGTMGHh4eWLduHZydnU3OY6ufQSZEDkSn0yEgIABHjx7F7t27ccsttzRq4+/vD29vb2zevBkFBQUYP378Zc+3d+9eAECnTp2sFnN7EELgkUcewdq1a7F58+ZGSWDnzp0RHByMDRs2yMdqamqwdetWDB48GEBD0uns7GzSJjc3FxkZGXKbQYMGQa/XY9euXXKbnTt3Qq/Xy23sVXvdw6Z0hM9hW9w/c/Az2Pp72BR+Bv+6fyUlJRg1ahQ0Gg2+++47k/pVwMY/g+1awk1WUVpaKvbu3Sv27t0rAIhFixaJvXv3ipMnTwohGqr8t2zZIjIzM8U333wjIiMjxW233WZyjv/+979ix44d4tixY2LFihXC19dXPP744/Lz27dvl897/Phx8fnnn4uQkBAxfvz4dn2v1vDggw8KnU4nfvnlF5Gbmys/Kioq5Davvvqq0Ol0Yu3ateLAgQPizjvvFJ06dRIlJSVymwceeECEhYWJjRs3ij179ogbbrhBXH311aKurk5uM2bMGNGnTx+xY8cOsWPHDhEbGyvGjRvXru/XGtrrHnbUz2Fb3b/c3Fyxd+9e8fHHHwsA4tdffxV79+4V586dk9vwM9i6e8jP4OXvX0lJiUhISBCxsbHi2LFjJuexh5+DTIg6AOP00Esfd999txBCiHfeeUeEhYUJZ2dnERERIZ577jlRXV1tco6nn35aBAUFCWdnZ9G9e3fx5ptvCoPBID+flpYmEhIShE6nEy4uLiI6OlrMnTtXlJeXt+dbtYqm7h0AsXTpUrmNwWAQc+fOFcHBwUKr1Yrrr79eHDhwwOQ8lZWV4pFHHhG+vr7C1dVVjBs3Tpw6dcqkzblz58TkyZOFp6en8PT0FJMnT25yWq+9aa972FE/h211/+bOndvsefgZbN095Gfw8vfvcr+LAIgTJ07I7Wz1MygJIURb9jgRERER2RvWEBEREZHDY0JEREREDo8JERERETk8JkRERETk8JgQERERkcNjQkREREQOjwkREREROTwmREREROTwmBARkU2aOnUqJkyY0GbnGzp0KGbNmtVm5yOijoUJERF1aLW1tUqHYJGamhqlQyBySEyIiEhRX331FWJjY+Hq6go/Pz+MGDECTz31FJYvX45vv/0WkiRBkiT88ssvAICnn34aPXr0gJubG7p06YLnn3/eJOmZN28e+vbti//+97/o0qULtFot7r77bmzduhXvvPOOfL6srKzLxiSEQLdu3fDGG2+YHM/IyIBKpUJmZiYAQK/X47777kNgYCC8vLxwww03YN++fXL7zMxM3HLLLQgKCoKHhwcGDBiAjRs3mpwzKioKL7/8MqZOnQqdTofp06e38o4SUUs4KR0AETmu3Nxc3HnnnVi4cCFuvfVWlJaW4rfffsNdd92FU6dOoaSkBEuXLgUA+Pr6AgA8PT2xbNkyhISE4MCBA5g+fTo8PT0xe/Zs+bzHjh3DF198ga+//hpqtRqRkZE4evQoYmJi8NJLLwEAAgICLhuXJEm45557sHTpUjz55JPy8f/+97+47rrr0LVrVwghcNNNN8HX1xc//fQTdDodlixZguHDh+PPP/+Er68vysrKcOONN+Lll1+Gi4sLli9fjptvvhlHjhxBRESEfN7XX38dzz//PJ577rk2vb9EZAFl95YlIkeWlpYmAIisrKxGz919993illtuafYcCxcuFHFxcfLXc+fOFc7OzqKgoMCk3ZAhQ8Sjjz5qdmxnzpwRarVa7Ny5UwghRE1NjQgICBDLli0TQgixadMm4eXlJaqqqkxe17VrV7FkyZLLnrd3797ivffek7+OjIwUEyZMMDsuIrIO9hARkWKuvvpqDB8+HLGxsRg9ejRGjRqF22+/HT4+Ppd9zVdffYW3334bx44dQ1lZGerq6uDl5WXSJjIy8oo9QObo1KkTbrrpJvz3v//FwIED8cMPP6Cqqgp/+9vfAABpaWkoKyuDn5+fyesqKyvlIbXy8nK8+OKL+OGHH3DmzBnU1dWhsrISp06dMnlNfHx8q2IlotZjDRERKUatVmPDhg343//+h969e+O9995DdHQ0Tpw40WT7lJQU/P3vf8fYsWPxww8/YO/evXj22WcbFSK7u7u3SXz33nsv1qxZg8rKSixduhR33HEH3NzcAAAGgwGdOnVCenq6yePIkSN46qmnAABPPfUUvv76a7zyyiv47bffkJ6ejtjYWKvFS0Qtxx4iIlKUJEm45pprcM011+CFF15AZGQk1q1bB41Gg/r6epO2v//+OyIjI/Hss8/Kx06ePGnWdZo6X3NuvPFGuLu744MPPsD//vc//Prrr/Jz/fv3R15eHpycnBAVFdXk63/77TdMnToVt956KwCgrKzsisXcRKQc9hARkWJ27tyJ+fPnY/fu3Th16hTWrl2LwsJC9OrVC1FRUdi/fz+OHDmCs2fPora2Ft26dcOpU6ewZs0aZGZm4t1338W6devMulZUVBR27tyJrKwsnD17FgaDodnXqNVqTJ06FXPmzEG3bt0waNAg+bkRI0Zg0KBBmDBhAn7++WdkZWVh+/bteO6557B7924AQLdu3bB27Vqkp6dj3759mDRpklnXJaL2x4SIiBTj5eWFX3/9FTfeeCN69OiB5557Dm+++SbGjh2L6dOnIzo6GvHx8QgICMDvv/+OW265BY899hgeeeQR9O3bF9u3b8fzzz9v1rWefPJJqNVq9O7dGwEBAY3qeC5n2rRpqKmpwT333GNyXJIk/PTTT7j++utxzz33oEePHvj73/+OrKwsBAUFAQDeeust+Pj4YPDgwbj55psxevRo9O/f37KbRETtQhJCCKWDICKyVb///juGDh2KnJwcOdEhoo6HCRERUROqq6uRnZ2N++67D506dcKqVauUDomIrIhDZkTkkB544AF4eHg0+XjggQewevVqREdHQ6/XY+HChUqHS0RWxh4iInJIBQUFKCkpafI5Ly8vBAYGtnNERKQkJkRERETk8DhkRkRERA6PCRERERE5PCZERERE5PCYEBEREZHDY0JEREREDo8JERERETk8JkRERETk8JgQERERkcP7f7/2p3BpWRb7AAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 640x480 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "sub_df = grouped_df[grouped_df[\"NAICS_col\"] == \"21\"]\n",
    "sns.lineplot(x = sub_df[\"start_year\"], y= sub_df[\"Number of workers[2]\"])\n",
    "plt.title('# of workers on strike for industry ' + \"21\");\n",
    "\n",
    "# for code in grouped_df[\"NAICS_col\"].unique():\n",
    "#     sub_df = grouped_df[grouped_df[\"NAICS_col\"] == code]\n",
    "#     sns.lineplot(x = sub_df[\"start_year\"], y= sub_df[\"Number of workers[2]\"])\n",
    "#     plt.title('# of workers on strike for industry ' + code)\n",
    "#     plt.figure();"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "d07be55e-a3ee-4956-8f02-4c1747a20f5e",
   "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>Organizations involved</th>\n",
       "      <th>States</th>\n",
       "      <th>Areas</th>\n",
       "      <th>Ownership</th>\n",
       "      <th>Industry code[1]</th>\n",
       "      <th>Union</th>\n",
       "      <th>Union acronym</th>\n",
       "      <th>Union Local</th>\n",
       "      <th>Bargaining unit</th>\n",
       "      <th>Work stoppage beginning date</th>\n",
       "      <th>Work stoppage ending date</th>\n",
       "      <th>Number of workers[2]</th>\n",
       "      <th>Days idle, cumulative for this work stoppage[3]</th>\n",
       "      <th>Note</th>\n",
       "      <th>NAICS_col</th>\n",
       "      <th>start_year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Douglas Aircraft</td>\n",
       "      <td>CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Private industry</td>\n",
       "      <td>336411</td>\n",
       "      <td>International Association of Machinists</td>\n",
       "      <td>IAM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1993-03-02</td>\n",
       "      <td>1993-03-03</td>\n",
       "      <td>6800.0</td>\n",
       "      <td>13600.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>33</td>\n",
       "      <td>1993.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Kaiser Permanente</td>\n",
       "      <td>CA</td>\n",
       "      <td>Southern</td>\n",
       "      <td>Private industry</td>\n",
       "      <td>62211</td>\n",
       "      <td>Service Employees International Union</td>\n",
       "      <td>SEIU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1993-04-01</td>\n",
       "      <td>1993-04-01</td>\n",
       "      <td>12000.0</td>\n",
       "      <td>12000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62</td>\n",
       "      <td>1993.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Vallejo Board of Education</td>\n",
       "      <td>CA</td>\n",
       "      <td>Vallejo</td>\n",
       "      <td>Local government</td>\n",
       "      <td>61111</td>\n",
       "      <td>National Education Association</td>\n",
       "      <td>NEA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1993-04-16</td>\n",
       "      <td>1993-04-17</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>61</td>\n",
       "      <td>1993.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>PPG Industries, Inc.</td>\n",
       "      <td>CA, PA</td>\n",
       "      <td>Multiple states</td>\n",
       "      <td>Private industry</td>\n",
       "      <td>32721</td>\n",
       "      <td>Aluminum, Brick and Glass Workers of America</td>\n",
       "      <td>ABGW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1993-05-08</td>\n",
       "      <td>1993-07-14</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>73200.0</td>\n",
       "      <td>Number of workers involved decreased below 1,0...</td>\n",
       "      <td>32</td>\n",
       "      <td>1993.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Los Angeles Department of Water and Power</td>\n",
       "      <td>CA</td>\n",
       "      <td>Los Angeles County</td>\n",
       "      <td>Local government</td>\n",
       "      <td>22131</td>\n",
       "      <td>International Brotherhood of Electrical Worker...</td>\n",
       "      <td>IBEW, EAA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1993-09-01</td>\n",
       "      <td>1993-09-09</td>\n",
       "      <td>9000.0</td>\n",
       "      <td>54000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22</td>\n",
       "      <td>1993.0</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>618</th>\n",
       "      <td>Frontier Communications</td>\n",
       "      <td>CA</td>\n",
       "      <td>Southern California</td>\n",
       "      <td>Private industry</td>\n",
       "      <td>517311</td>\n",
       "      <td>Communication Workers of America</td>\n",
       "      <td>CWA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-08-19</td>\n",
       "      <td>2022-08-24</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51</td>\n",
       "      <td>2022.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>623</th>\n",
       "      <td>San Francisco International Airport</td>\n",
       "      <td>CA</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>Local government</td>\n",
       "      <td>722510</td>\n",
       "      <td>Union of Needletrades, Industrial, and Textile...</td>\n",
       "      <td>UNITE HERE</td>\n",
       "      <td>Local 2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-09-26</td>\n",
       "      <td>2022-09-28</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>72</td>\n",
       "      <td>2022.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>624</th>\n",
       "      <td>Sutter Health Hospitals</td>\n",
       "      <td>CA</td>\n",
       "      <td>Berkeley</td>\n",
       "      <td>Private industry</td>\n",
       "      <td>622110</td>\n",
       "      <td>California Nurses Association/National Nurses ...</td>\n",
       "      <td>CNA/NNU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-10-24</td>\n",
       "      <td>2022-10-29</td>\n",
       "      <td>1800.0</td>\n",
       "      <td>9000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62</td>\n",
       "      <td>2022.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>625</th>\n",
       "      <td>University of California</td>\n",
       "      <td>CA</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>State government</td>\n",
       "      <td>61131</td>\n",
       "      <td>United Auto Workers</td>\n",
       "      <td>UAW</td>\n",
       "      <td>Local 2865, 5810</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-11-14</td>\n",
       "      <td>2022-12-23</td>\n",
       "      <td>48000.0</td>\n",
       "      <td>1272000.0</td>\n",
       "      <td>48,000 workers from 11/14-12/11. Number droppe...</td>\n",
       "      <td>61</td>\n",
       "      <td>2022.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>628</th>\n",
       "      <td>Alta Bates Summit</td>\n",
       "      <td>CA</td>\n",
       "      <td>Oakland and Berkeley</td>\n",
       "      <td>Private industry</td>\n",
       "      <td>622110</td>\n",
       "      <td>California Nurses Association/National Nurses ...</td>\n",
       "      <td>NNU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-12-24</td>\n",
       "      <td>2023-01-01</td>\n",
       "      <td>1800.0</td>\n",
       "      <td>7200.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62</td>\n",
       "      <td>2022.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>158 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                        Organizations involved  States                 Areas  \\\n",
       "4                             Douglas Aircraft      CA                   NaN   \n",
       "8                            Kaiser Permanente      CA              Southern   \n",
       "9                   Vallejo Board of Education      CA               Vallejo   \n",
       "11                        PPG Industries, Inc.  CA, PA       Multiple states   \n",
       "25   Los Angeles Department of Water and Power      CA    Los Angeles County   \n",
       "..                                         ...     ...                   ...   \n",
       "618                    Frontier Communications      CA   Southern California   \n",
       "623        San Francisco International Airport      CA         San Francisco   \n",
       "624                    Sutter Health Hospitals      CA              Berkeley   \n",
       "625                   University of California      CA             Statewide   \n",
       "628                          Alta Bates Summit      CA  Oakland and Berkeley   \n",
       "\n",
       "            Ownership Industry code[1]  \\\n",
       "4    Private industry           336411   \n",
       "8    Private industry            62211   \n",
       "9    Local government            61111   \n",
       "11   Private industry            32721   \n",
       "25   Local government            22131   \n",
       "..                ...              ...   \n",
       "618  Private industry           517311   \n",
       "623  Local government           722510   \n",
       "624  Private industry           622110   \n",
       "625  State government            61131   \n",
       "628  Private industry           622110   \n",
       "\n",
       "                                                 Union Union acronym  \\\n",
       "4              International Association of Machinists           IAM   \n",
       "8                Service Employees International Union          SEIU   \n",
       "9                       National Education Association           NEA   \n",
       "11        Aluminum, Brick and Glass Workers of America          ABGW   \n",
       "25   International Brotherhood of Electrical Worker...     IBEW, EAA   \n",
       "..                                                 ...           ...   \n",
       "618                   Communication Workers of America           CWA   \n",
       "623  Union of Needletrades, Industrial, and Textile...    UNITE HERE   \n",
       "624  California Nurses Association/National Nurses ...       CNA/NNU   \n",
       "625                                United Auto Workers           UAW   \n",
       "628  California Nurses Association/National Nurses ...           NNU   \n",
       "\n",
       "          Union Local Bargaining unit Work stoppage beginning date  \\\n",
       "4                 NaN             NaN                   1993-03-02   \n",
       "8                 NaN             NaN                   1993-04-01   \n",
       "9                 NaN             NaN                   1993-04-16   \n",
       "11                NaN             NaN                   1993-05-08   \n",
       "25                NaN             NaN                   1993-09-01   \n",
       "..                ...             ...                          ...   \n",
       "618               NaN             NaN                   2022-08-19   \n",
       "623           Local 2             NaN                   2022-09-26   \n",
       "624               NaN             NaN                   2022-10-24   \n",
       "625  Local 2865, 5810             NaN                   2022-11-14   \n",
       "628               NaN             NaN                   2022-12-24   \n",
       "\n",
       "    Work stoppage ending date  Number of workers[2]  \\\n",
       "4                  1993-03-03                6800.0   \n",
       "8                  1993-04-01               12000.0   \n",
       "9                  1993-04-17                1000.0   \n",
       "11                 1993-07-14                1600.0   \n",
       "25                 1993-09-09                9000.0   \n",
       "..                        ...                   ...   \n",
       "618                2022-08-24                2000.0   \n",
       "623                2022-09-28                1000.0   \n",
       "624                2022-10-29                1800.0   \n",
       "625                2022-12-23               48000.0   \n",
       "628                2023-01-01                1800.0   \n",
       "\n",
       "     Days idle, cumulative for this work stoppage[3]  \\\n",
       "4                                            13600.0   \n",
       "8                                            12000.0   \n",
       "9                                             2000.0   \n",
       "11                                           73200.0   \n",
       "25                                           54000.0   \n",
       "..                                               ...   \n",
       "618                                           8000.0   \n",
       "623                                           3000.0   \n",
       "624                                           9000.0   \n",
       "625                                        1272000.0   \n",
       "628                                           7200.0   \n",
       "\n",
       "                                                  Note NAICS_col  start_year  \n",
       "4                                                  NaN        33      1993.0  \n",
       "8                                                  NaN        62      1993.0  \n",
       "9                                                  NaN        61      1993.0  \n",
       "11   Number of workers involved decreased below 1,0...        32      1993.0  \n",
       "25                                                 NaN        22      1993.0  \n",
       "..                                                 ...       ...         ...  \n",
       "618                                                NaN        51      2022.0  \n",
       "623                                                NaN        72      2022.0  \n",
       "624                                                NaN        62      2022.0  \n",
       "625  48,000 workers from 11/14-12/11. Number droppe...        61      2022.0  \n",
       "628                                                NaN        62      2022.0  \n",
       "\n",
       "[158 rows x 16 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ca_df = bls_df[bls_df[\"States\"].astype(str).str.contains(\"CA\")]\n",
    "ca_df\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "5c3f01ce-cc0c-41bd-93ee-b624c82514f1",
   "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>NAICS_col</th>\n",
       "      <th>start_year</th>\n",
       "      <th>Number of workers[2]</th>\n",
       "      <th>Days idle, cumulative for this work stoppage[3]</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>21</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>6600.0</td>\n",
       "      <td>322100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>22</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>30000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>23</td>\n",
       "      <td>1995.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>108000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>23</td>\n",
       "      <td>1999.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>2000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>23</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>14400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>92</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>2500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>92</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>1900.0</td>\n",
       "      <td>2800.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>92</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>1850.0</td>\n",
       "      <td>7200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>92</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>2600.0</td>\n",
       "      <td>9550.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>92</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>2000.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>94 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   NAICS_col  start_year  Number of workers[2]  \\\n",
       "0         21      2015.0                6600.0   \n",
       "1         22      1993.0                7500.0   \n",
       "2         23      1995.0                3000.0   \n",
       "3         23      1999.0                1000.0   \n",
       "4         23      2000.0                1200.0   \n",
       "..       ...         ...                   ...   \n",
       "89        92      2013.0                2500.0   \n",
       "90        92      2015.0                1900.0   \n",
       "91        92      2016.0                1850.0   \n",
       "92        92      2017.0                2600.0   \n",
       "93        92      2020.0                1000.0   \n",
       "\n",
       "    Days idle, cumulative for this work stoppage[3]  \n",
       "0                                          322100.0  \n",
       "1                                           30000.0  \n",
       "2                                          108000.0  \n",
       "3                                            2000.0  \n",
       "4                                           14400.0  \n",
       "..                                              ...  \n",
       "89                                           2500.0  \n",
       "90                                           2800.0  \n",
       "91                                           7200.0  \n",
       "92                                           9550.0  \n",
       "93                                           2000.0  \n",
       "\n",
       "[94 rows x 4 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "grouped_ca_df = ca_df.groupby([\"NAICS_col\",\"start_year\"]).mean()\n",
    "grouped_ca_df = grouped_ca_df.reset_index()\n",
    "grouped_ca_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "fa371415-e378-4744-9f74-76dece24a985",
   "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>NAICS_col</th>\n",
       "      <th>start_year</th>\n",
       "      <th>Number of workers[2]</th>\n",
       "      <th>Days idle, cumulative for this work stoppage[3]</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>21</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>6600.0</td>\n",
       "      <td>322100.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  NAICS_col  start_year  Number of workers[2]  \\\n",
       "0        21      2015.0                6600.0   \n",
       "\n",
       "   Days idle, cumulative for this work stoppage[3]  \n",
       "0                                         322100.0  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "grouped_ca_df[grouped_ca_df[\"NAICS_col\"] == \"21\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "dbf635a2-151a-4851-b57c-110a591b6620",
   "metadata": {},
   "outputs": [],
   "source": [
    "# for code in grouped_ca_df[\"NAICS_col\"].unique():\n",
    "#     sub_ca_df = grouped_ca_df[grouped_ca_df[\"NAICS_col\"] == code]\n",
    "#     sns.lineplot(x = sub_ca_df[\"start_year\"], y= sub_ca_df[\"Number of workers[2]\"])\n",
    "#     plt.title('# of workers on strike for industry ' + code)\n",
    "#     plt.figure();"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "ae419c55-bb53-49e1-a0b9-a31da026f879",
   "metadata": {},
   "outputs": [],
   "source": [
    "def state_drawer(state, industry=\"\"):\n",
    "    if state == \"\":\n",
    "        state_df= bls_df\n",
    "    else:\n",
    "        state_df = bls_df[bls_df[\"States\"].astype(str).str.contains(state)]\n",
    "    group_df = state_df.groupby([\"NAICS_col\",\"start_year\"]).mean()\n",
    "    group_df = group_df.reset_index()\n",
    "    if industry == \"\":\n",
    "        for code in group_df[\"NAICS_col\"].unique():\n",
    "            sub_df = group_df[group_df[\"NAICS_col\"] == code]\n",
    "            sns.lineplot(x = sub_df[\"start_year\"], y= sub_df[\"Number of workers[2]\"])\n",
    "            plt.title('# of workers on strike for industry ' + code)\n",
    "            plt.figure();\n",
    "    else:\n",
    "        sub_df = group_df[group_df[\"NAICS_col\"] == industry]\n",
    "        sns.lineplot(x = sub_df[\"start_year\"], y= sub_df[\"Number of workers[2]\"])\n",
    "        plt.title('# of workers on strike for industry ' + industry)\n",
    "        plt.figure();\n",
    "\n",
    "# state_drawer(\"CA\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "42a61794-f313-4bd4-9d00-9df405a1fd29",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "674.0"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bls_df_no_nan = bls_df[~bls_df['States'].isna()]\n",
    "bls_df_no_nan#[~bls_df_no_nan['States'].str.contains(\",\")].groupby(['States','start_year']).sum()\n",
    "(bls_df_no_nan['end_year']-bls_df_no_nan['start_year']).sum() + len(bls_df_no_nan['end_year']-bls_df_no_nan['start_year'])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "1411cf7f-2bbe-41ea-b796-0b1b77149d3d",
   "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>Organizations involved</th>\n",
       "      <th>States</th>\n",
       "      <th>Areas</th>\n",
       "      <th>Ownership</th>\n",
       "      <th>Industry code[1]</th>\n",
       "      <th>Union</th>\n",
       "      <th>Union acronym</th>\n",
       "      <th>Union Local</th>\n",
       "      <th>Bargaining unit</th>\n",
       "      <th>Work stoppage beginning date</th>\n",
       "      <th>Work stoppage ending date</th>\n",
       "      <th>Number of workers[2]</th>\n",
       "      <th>Days idle, cumulative for this work stoppage[3]</th>\n",
       "      <th>Note</th>\n",
       "      <th>NAICS_col</th>\n",
       "      <th>start_year</th>\n",
       "      <th>end_year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Marine Towing and Transportation Employers' As...</td>\n",
       "      <td>NY</td>\n",
       "      <td>New York</td>\n",
       "      <td>Private industry</td>\n",
       "      <td>488330</td>\n",
       "      <td>International Longshoremen's Association</td>\n",
       "      <td>ILA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1988-02-16</td>\n",
       "      <td>1993-12-20</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>2879500.0</td>\n",
       "      <td>The number of workers decreased to 2,000 in De...</td>\n",
       "      <td>48</td>\n",
       "      <td>1988.0</td>\n",
       "      <td>1993.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Boeing Company</td>\n",
       "      <td>WA</td>\n",
       "      <td>Seattle</td>\n",
       "      <td>Private industry</td>\n",
       "      <td>336411</td>\n",
       "      <td>Seattle Professional Engineering Employees Ass...</td>\n",
       "      <td>SPEEA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1993-01-19</td>\n",
       "      <td>1993-01-19</td>\n",
       "      <td>21000.0</td>\n",
       "      <td>21000.0</td>\n",
       "      <td>The union name was changed to the Society of P...</td>\n",
       "      <td>33</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>1993.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Boston Gas Company</td>\n",
       "      <td>MA</td>\n",
       "      <td>Boston</td>\n",
       "      <td>Private industry</td>\n",
       "      <td>22121</td>\n",
       "      <td>United Steelworkers</td>\n",
       "      <td>USW</td>\n",
       "      <td>12003</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1993-01-24</td>\n",
       "      <td>1993-05-20</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>83000.0</td>\n",
       "      <td>Boston Gas Company also does business as \"Nati...</td>\n",
       "      <td>22</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>1993.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Bituminous Coal Operators Association</td>\n",
       "      <td>IN, IL, KY, WV</td>\n",
       "      <td>Multiple states</td>\n",
       "      <td>Private industry</td>\n",
       "      <td>212112</td>\n",
       "      <td>United Mine Workers of America</td>\n",
       "      <td>UMWA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1993-02-02</td>\n",
       "      <td>1993-03-02</td>\n",
       "      <td>6700.0</td>\n",
       "      <td>103400.0</td>\n",
       "      <td>Number of workers involved increased from 5,00...</td>\n",
       "      <td>21</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>1993.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Douglas Aircraft</td>\n",
       "      <td>CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Private industry</td>\n",
       "      <td>336411</td>\n",
       "      <td>International Association of Machinists</td>\n",
       "      <td>IAM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1993-03-02</td>\n",
       "      <td>1993-03-03</td>\n",
       "      <td>6800.0</td>\n",
       "      <td>13600.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>33</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>1993.0</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>624</th>\n",
       "      <td>Sutter Health Hospitals</td>\n",
       "      <td>CA</td>\n",
       "      <td>Berkeley</td>\n",
       "      <td>Private industry</td>\n",
       "      <td>622110</td>\n",
       "      <td>California Nurses Association/National Nurses ...</td>\n",
       "      <td>CNA/NNU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-10-24</td>\n",
       "      <td>2022-10-29</td>\n",
       "      <td>1800.0</td>\n",
       "      <td>9000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62</td>\n",
       "      <td>2022.0</td>\n",
       "      <td>2022.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>625</th>\n",
       "      <td>University of California</td>\n",
       "      <td>CA</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>State government</td>\n",
       "      <td>61131</td>\n",
       "      <td>United Auto Workers</td>\n",
       "      <td>UAW</td>\n",
       "      <td>Local 2865, 5810</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-11-14</td>\n",
       "      <td>2022-12-23</td>\n",
       "      <td>48000.0</td>\n",
       "      <td>1272000.0</td>\n",
       "      <td>48,000 workers from 11/14-12/11. Number droppe...</td>\n",
       "      <td>61</td>\n",
       "      <td>2022.0</td>\n",
       "      <td>2022.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>626</th>\n",
       "      <td>The New School</td>\n",
       "      <td>NY</td>\n",
       "      <td>NY</td>\n",
       "      <td>Private industry</td>\n",
       "      <td>61131</td>\n",
       "      <td>Academics Come Together - United Auto Workers</td>\n",
       "      <td>ACT-UAW</td>\n",
       "      <td>Local 7902</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-11-16</td>\n",
       "      <td>2022-12-10</td>\n",
       "      <td>1700.0</td>\n",
       "      <td>28900.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>61</td>\n",
       "      <td>2022.0</td>\n",
       "      <td>2022.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>627</th>\n",
       "      <td>New York Times</td>\n",
       "      <td>NY</td>\n",
       "      <td>NY</td>\n",
       "      <td>Private industry</td>\n",
       "      <td>511110</td>\n",
       "      <td>The NewsGuild</td>\n",
       "      <td>TNG-CWA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-12-08</td>\n",
       "      <td>2022-12-08</td>\n",
       "      <td>1100.0</td>\n",
       "      <td>1100.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51</td>\n",
       "      <td>2022.0</td>\n",
       "      <td>2022.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>628</th>\n",
       "      <td>Alta Bates Summit</td>\n",
       "      <td>CA</td>\n",
       "      <td>Oakland and Berkeley</td>\n",
       "      <td>Private industry</td>\n",
       "      <td>622110</td>\n",
       "      <td>California Nurses Association/National Nurses ...</td>\n",
       "      <td>NNU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-12-24</td>\n",
       "      <td>2023-01-01</td>\n",
       "      <td>1800.0</td>\n",
       "      <td>7200.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62</td>\n",
       "      <td>2022.0</td>\n",
       "      <td>2023.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>628 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                Organizations involved          States  \\\n",
       "0    Marine Towing and Transportation Employers' As...              NY   \n",
       "1                                       Boeing Company              WA   \n",
       "2                                   Boston Gas Company              MA   \n",
       "3                Bituminous Coal Operators Association  IN, IL, KY, WV   \n",
       "4                                     Douglas Aircraft              CA   \n",
       "..                                                 ...             ...   \n",
       "624                            Sutter Health Hospitals              CA   \n",
       "625                           University of California              CA   \n",
       "626                                     The New School              NY   \n",
       "627                                     New York Times              NY   \n",
       "628                                  Alta Bates Summit              CA   \n",
       "\n",
       "                    Areas         Ownership Industry code[1]  \\\n",
       "0                New York  Private industry           488330   \n",
       "1                 Seattle  Private industry           336411   \n",
       "2                  Boston  Private industry            22121   \n",
       "3         Multiple states  Private industry           212112   \n",
       "4                     NaN  Private industry           336411   \n",
       "..                    ...               ...              ...   \n",
       "624              Berkeley  Private industry           622110   \n",
       "625             Statewide  State government            61131   \n",
       "626                    NY  Private industry            61131   \n",
       "627                    NY  Private industry           511110   \n",
       "628  Oakland and Berkeley  Private industry           622110   \n",
       "\n",
       "                                                 Union Union acronym  \\\n",
       "0             International Longshoremen's Association           ILA   \n",
       "1    Seattle Professional Engineering Employees Ass...         SPEEA   \n",
       "2                                  United Steelworkers           USW   \n",
       "3                       United Mine Workers of America          UMWA   \n",
       "4              International Association of Machinists           IAM   \n",
       "..                                                 ...           ...   \n",
       "624  California Nurses Association/National Nurses ...       CNA/NNU   \n",
       "625                                United Auto Workers           UAW   \n",
       "626      Academics Come Together - United Auto Workers       ACT-UAW   \n",
       "627                                      The NewsGuild       TNG-CWA   \n",
       "628  California Nurses Association/National Nurses ...           NNU   \n",
       "\n",
       "          Union Local Bargaining unit Work stoppage beginning date  \\\n",
       "0                 NaN             NaN                   1988-02-16   \n",
       "1                 NaN             NaN                   1993-01-19   \n",
       "2               12003             NaN                   1993-01-24   \n",
       "3                 NaN             NaN                   1993-02-02   \n",
       "4                 NaN             NaN                   1993-03-02   \n",
       "..                ...             ...                          ...   \n",
       "624               NaN             NaN                   2022-10-24   \n",
       "625  Local 2865, 5810             NaN                   2022-11-14   \n",
       "626        Local 7902             NaN                   2022-11-16   \n",
       "627               NaN             NaN                   2022-12-08   \n",
       "628               NaN             NaN                   2022-12-24   \n",
       "\n",
       "    Work stoppage ending date  Number of workers[2]  \\\n",
       "0                  1993-12-20                2500.0   \n",
       "1                  1993-01-19               21000.0   \n",
       "2                  1993-05-20                1000.0   \n",
       "3                  1993-03-02                6700.0   \n",
       "4                  1993-03-03                6800.0   \n",
       "..                        ...                   ...   \n",
       "624                2022-10-29                1800.0   \n",
       "625                2022-12-23               48000.0   \n",
       "626                2022-12-10                1700.0   \n",
       "627                2022-12-08                1100.0   \n",
       "628                2023-01-01                1800.0   \n",
       "\n",
       "     Days idle, cumulative for this work stoppage[3]  \\\n",
       "0                                          2879500.0   \n",
       "1                                            21000.0   \n",
       "2                                            83000.0   \n",
       "3                                           103400.0   \n",
       "4                                            13600.0   \n",
       "..                                               ...   \n",
       "624                                           9000.0   \n",
       "625                                        1272000.0   \n",
       "626                                          28900.0   \n",
       "627                                           1100.0   \n",
       "628                                           7200.0   \n",
       "\n",
       "                                                  Note NAICS_col  start_year  \\\n",
       "0    The number of workers decreased to 2,000 in De...        48      1988.0   \n",
       "1    The union name was changed to the Society of P...        33      1993.0   \n",
       "2    Boston Gas Company also does business as \"Nati...        22      1993.0   \n",
       "3    Number of workers involved increased from 5,00...        21      1993.0   \n",
       "4                                                  NaN        33      1993.0   \n",
       "..                                                 ...       ...         ...   \n",
       "624                                                NaN        62      2022.0   \n",
       "625  48,000 workers from 11/14-12/11. Number droppe...        61      2022.0   \n",
       "626                                                NaN        61      2022.0   \n",
       "627                                                NaN        51      2022.0   \n",
       "628                                                NaN        62      2022.0   \n",
       "\n",
       "     end_year  \n",
       "0      1993.0  \n",
       "1      1993.0  \n",
       "2      1993.0  \n",
       "3      1993.0  \n",
       "4      1993.0  \n",
       "..        ...  \n",
       "624    2022.0  \n",
       "625    2022.0  \n",
       "626    2022.0  \n",
       "627    2022.0  \n",
       "628    2023.0  \n",
       "\n",
       "[628 rows x 17 columns]"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bls_df_no_nan"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "e331d9d4-4a4c-4a45-ba47-ccdd167b3a63",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}