{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import math  \n",
    "import matplotlib.pyplot as plt\n",
    "from pandas import ExcelWriter\n",
    "from pandas import ExcelFile"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "C:\\Users\\koles\\Downloads\n"
     ]
    }
   ],
   "source": [
    "import os\n",
    "currentDir = os.getcwd()\n",
    "print(currentDir)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CPSC_Case_Number</th>\n",
       "      <th>Treatment_Date</th>\n",
       "      <th>Age</th>\n",
       "      <th>Sex</th>\n",
       "      <th>Race</th>\n",
       "      <th>Other_Race</th>\n",
       "      <th>Hispanic Origin</th>\n",
       "      <th>Body_Part</th>\n",
       "      <th>Diagnosis</th>\n",
       "      <th>Other_Diagnosis</th>\n",
       "      <th>...</th>\n",
       "      <th>Fire_Involvement</th>\n",
       "      <th>Product_1</th>\n",
       "      <th>Product_2</th>\n",
       "      <th>Product_3</th>\n",
       "      <th>Alcohol involved</th>\n",
       "      <th>Drug involved</th>\n",
       "      <th>Narrative_1</th>\n",
       "      <th>Stratum</th>\n",
       "      <th>PSU</th>\n",
       "      <th>Weight</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>190103267</td>\n",
       "      <td>2019-01-01</td>\n",
       "      <td>81</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>79</td>\n",
       "      <td>57</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1141</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>81YOM TRIPEPD OVER A BOX AND FELL ONTO RIGHT H...</td>\n",
       "      <td>M</td>\n",
       "      <td>63</td>\n",
       "      <td>81.1520</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>190103268</td>\n",
       "      <td>2019-01-01</td>\n",
       "      <td>38</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>36</td>\n",
       "      <td>57</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1842</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>38YOF FELL DOWN A FLIGHT OF STAIRS AND SUSTAIN...</td>\n",
       "      <td>M</td>\n",
       "      <td>63</td>\n",
       "      <td>81.1520</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>190103269</td>\n",
       "      <td>2019-01-01</td>\n",
       "      <td>94</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>75</td>\n",
       "      <td>62</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1807</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>94YOM FELL TO THE FLOOR AT THE NURSING HOME ON...</td>\n",
       "      <td>M</td>\n",
       "      <td>63</td>\n",
       "      <td>81.1520</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>190103270</td>\n",
       "      <td>2019-01-01</td>\n",
       "      <td>86</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>75</td>\n",
       "      <td>62</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>611</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>86YOM FELL IN THE SHOWER AT HOME AND SUSTAINED...</td>\n",
       "      <td>M</td>\n",
       "      <td>63</td>\n",
       "      <td>81.1520</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>190103273</td>\n",
       "      <td>2019-01-01</td>\n",
       "      <td>87</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>32</td>\n",
       "      <td>53</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>679</td>\n",
       "      <td>1807</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>87YOF WAS GETTING UP FROM THE COUCH AND FELL T...</td>\n",
       "      <td>M</td>\n",
       "      <td>63</td>\n",
       "      <td>81.1520</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>358710</td>\n",
       "      <td>200314195</td>\n",
       "      <td>2019-12-31</td>\n",
       "      <td>44</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>81</td>\n",
       "      <td>64</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1842</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>44YOM P/W AFTER WALKING OUT OF HIS HOUSE TODAY...</td>\n",
       "      <td>V</td>\n",
       "      <td>57</td>\n",
       "      <td>17.3778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>358711</td>\n",
       "      <td>200314202</td>\n",
       "      <td>2019-12-31</td>\n",
       "      <td>37</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>31</td>\n",
       "      <td>71</td>\n",
       "      <td>PAIN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>557</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>37YOM P/W PAIN UNDER LT SIDE OF CHEST. AFTER M...</td>\n",
       "      <td>V</td>\n",
       "      <td>57</td>\n",
       "      <td>17.3778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>358712</td>\n",
       "      <td>200314203</td>\n",
       "      <td>2019-12-31</td>\n",
       "      <td>221</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>75</td>\n",
       "      <td>58</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1807</td>\n",
       "      <td>1864</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>21 MOM AFTER STANDING ON THE COUNTER AND FALLI...</td>\n",
       "      <td>V</td>\n",
       "      <td>57</td>\n",
       "      <td>17.3778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>358713</td>\n",
       "      <td>200314209</td>\n",
       "      <td>2019-12-31</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>76</td>\n",
       "      <td>56</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1616</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4YOF PRESENTS AFTER PUTTING A DOLL BRACELET UP...</td>\n",
       "      <td>V</td>\n",
       "      <td>57</td>\n",
       "      <td>17.3778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>358714</td>\n",
       "      <td>200314210</td>\n",
       "      <td>2019-12-31</td>\n",
       "      <td>206</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>76</td>\n",
       "      <td>53</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>611</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6MOM P/W SMALL LAC TO RT EYELID ADTER FATHER F...</td>\n",
       "      <td>V</td>\n",
       "      <td>57</td>\n",
       "      <td>17.3778</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>358715 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        CPSC_Case_Number Treatment_Date  Age  Sex  Race Other_Race  \\\n",
       "0              190103267     2019-01-01   81    1     0        NaN   \n",
       "1              190103268     2019-01-01   38    2     0        NaN   \n",
       "2              190103269     2019-01-01   94    1     0        NaN   \n",
       "3              190103270     2019-01-01   86    1     0        NaN   \n",
       "4              190103273     2019-01-01   87    2     0        NaN   \n",
       "...                  ...            ...  ...  ...   ...        ...   \n",
       "358710         200314195     2019-12-31   44    1     0        NaN   \n",
       "358711         200314202     2019-12-31   37    1     2        NaN   \n",
       "358712         200314203     2019-12-31  221    1     1        NaN   \n",
       "358713         200314209     2019-12-31    4    2     0        NaN   \n",
       "358714         200314210     2019-12-31  206    1     1        NaN   \n",
       "\n",
       "        Hispanic Origin  Body_Part  Diagnosis Other_Diagnosis  ...  \\\n",
       "0                     0         79         57             NaN  ...   \n",
       "1                     0         36         57             NaN  ...   \n",
       "2                     0         75         62             NaN  ...   \n",
       "3                     0         75         62             NaN  ...   \n",
       "4                     0         32         53             NaN  ...   \n",
       "...                 ...        ...        ...             ...  ...   \n",
       "358710                1         81         64             NaN  ...   \n",
       "358711                2         31         71            PAIN  ...   \n",
       "358712                2         75         58             NaN  ...   \n",
       "358713                0         76         56             NaN  ...   \n",
       "358714                2         76         53             NaN  ...   \n",
       "\n",
       "        Fire_Involvement  Product_1 Product_2  Product_3  Alcohol involved  \\\n",
       "0                      0       1141         0          0                 0   \n",
       "1                      0       1842         0          0                 0   \n",
       "2                      0       1807         0          0                 0   \n",
       "3                      0        611         0          0                 0   \n",
       "4                      0        679      1807          0                 0   \n",
       "...                  ...        ...       ...        ...               ...   \n",
       "358710                 0       1842         0          0                 0   \n",
       "358711                 0        557         0          0                 0   \n",
       "358712                 0       1807      1864          0                 0   \n",
       "358713                 0       1616         0          0                 0   \n",
       "358714                 0        611         0          0                 0   \n",
       "\n",
       "        Drug involved                                        Narrative_1  \\\n",
       "0                   0  81YOM TRIPEPD OVER A BOX AND FELL ONTO RIGHT H...   \n",
       "1                   0  38YOF FELL DOWN A FLIGHT OF STAIRS AND SUSTAIN...   \n",
       "2                   0  94YOM FELL TO THE FLOOR AT THE NURSING HOME ON...   \n",
       "3                   0  86YOM FELL IN THE SHOWER AT HOME AND SUSTAINED...   \n",
       "4                   0  87YOF WAS GETTING UP FROM THE COUCH AND FELL T...   \n",
       "...               ...                                                ...   \n",
       "358710              0  44YOM P/W AFTER WALKING OUT OF HIS HOUSE TODAY...   \n",
       "358711              0  37YOM P/W PAIN UNDER LT SIDE OF CHEST. AFTER M...   \n",
       "358712              0  21 MOM AFTER STANDING ON THE COUNTER AND FALLI...   \n",
       "358713              0  4YOF PRESENTS AFTER PUTTING A DOLL BRACELET UP...   \n",
       "358714              0  6MOM P/W SMALL LAC TO RT EYELID ADTER FATHER F...   \n",
       "\n",
       "        Stratum  PSU   Weight  \n",
       "0             M   63  81.1520  \n",
       "1             M   63  81.1520  \n",
       "2             M   63  81.1520  \n",
       "3             M   63  81.1520  \n",
       "4             M   63  81.1520  \n",
       "...         ...  ...      ...  \n",
       "358710        V   57  17.3778  \n",
       "358711        V   57  17.3778  \n",
       "358712        V   57  17.3778  \n",
       "358713        V   57  17.3778  \n",
       "358714        V   57  17.3778  \n",
       "\n",
       "[358715 rows x 25 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Read data from file excel file \"PredictionData.xls\" \n",
    "TraumaData = pd.read_excel(\"neiss2019.xlsx\") \n",
    "\n",
    "#Remove empty cells\n",
    "#TraumaData.dropna(how=\"all\", inplace=True)\n",
    "\n",
    "# Preview the data \n",
    "TraumaData"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "CPSC_Case_Number              int64\n",
       "Treatment_Date       datetime64[ns]\n",
       "Age                           int64\n",
       "Sex                           int64\n",
       "Race                          int64\n",
       "Other_Race                   object\n",
       "Hispanic Origin               int64\n",
       "Body_Part                     int64\n",
       "Diagnosis                     int64\n",
       "Other_Diagnosis              object\n",
       "Body_Part_2                 float64\n",
       "Diagnosis_2                 float64\n",
       "Other_Diagnosis_2            object\n",
       "Disposition                   int64\n",
       "Location                      int64\n",
       "Fire_Involvement              int64\n",
       "Product_1                     int64\n",
       "Product_2                     int64\n",
       "Product_3                     int64\n",
       "Alcohol involved              int64\n",
       "Drug involved                 int64\n",
       "Narrative_1                  object\n",
       "Stratum                      object\n",
       "PSU                           int64\n",
       "Weight                      float64\n",
       "dtype: object"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Review data types\n",
    "TraumaData.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create array to assign location\n",
    "Location=[['Unknown',0], ['Home',1], ['Farm',2], ['Apart', 3],['Street',4],['Public',5],['Mobile',6],['Industrial',7],\n",
    "     ['School', 8],['Sports',9]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create new array for descriptive location, use for-loop to assign new location\n",
    "LocNew=[]\n",
    "\n",
    "for code in TraumaData['Location']:\n",
    "    for (location,loccode) in Location:\n",
    "        if code=='':\n",
    "            location='missed'\n",
    "            LocNew.append(location)\n",
    "        elif code == loccode:\n",
    "            LocNew.append(location)\n",
    "            break"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "Diag=[['INGESTION',41], ['ASPIRATION',42], ['BURN ELECTRICAL',46], ['BURN NOT SPEC', 47],['BURN SCALD',48],['BURN CHEMICAL',49],['AMPUTATION',50],['BURNS THERMAL',51],\n",
    "     ['CONCUSSION', 52],['CONTUSIONS ABR',53], ['CRUSHING', 54],['DISLOCATION',55],['FOREIGN BODY',56],['FRACTURE',57],['HEMATOMA',58],['LACERATION',59],\n",
    "     ['DENTAL INJURY',60],['NERVE DAMAGE',61],['INTERNAL INJURY',62],['PUNCTURE',63],['STRAIN/SPRAIN',64],['ANOXIA',65],['HEMORRHAGE',66],['ELECTRIC SHOCK',67],\n",
    "      ['POISONING',68],['SUBMERSION',69],['OTHER',70],['OTHER',71],['AVULSION',72],['RADIATION',73],['DERMA/CONJUNCT',74]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create new array for descriptive Diagnosis, use for-loop to assign new Diagnosis\n",
    "DiagNew1=[]\n",
    "\n",
    "for code in TraumaData['Diagnosis']:\n",
    "    for (diag,diagcode) in Diag:\n",
    "        if code=='':\n",
    "            diag='missed'\n",
    "            DiagNew1.append(diag)\n",
    "        elif code == diagcode:\n",
    "            DiagNew1.append(diag)\n",
    "            break"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create new array for descriptive Diagnosis_2, use for-loop to assign new Secondary Diagnosis\n",
    "DiagNew2=[]\n",
    "\n",
    "for code in TraumaData['Diagnosis_2']:\n",
    "    for (diag,diagcode) in Diag:\n",
    "        if math.isnan(code):\n",
    "            diag='none'\n",
    "            DiagNew2.append(diag)\n",
    "        elif code=='':\n",
    "            diag='missed'\n",
    "            DiagNew1.append(diag)\n",
    "        elif code == diagcode:\n",
    "            DiagNew2.append(diag)\n",
    "            break"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "Disposition=[['NO INJURY',0], ['TREATED/EXAMINED AND RELEASED',1], ['TREATED AND TRANSFERRED',2], ['Apart', 3],['TREATED AND ADMITTED/HOSPITALIZED',4],['HELD FOR OBSERVATION',5],['LEFT WITHOUT BEING SEEN',6],['FATALITY INCL DOA/DIED IN ER',8],\n",
    "             ['UNKNOWN',9]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create new array for descriptive Disposition, use for-loop to assign new Disposition\n",
    "DispNew=[]\n",
    "\n",
    "for code in TraumaData['Disposition']:\n",
    "    for (disposition,dispcode) in Disposition:\n",
    "        if dispcode=='':\n",
    "            disposition='missed'\n",
    "            DispNew.append(disposition)\n",
    "        elif code == dispcode:\n",
    "            DispNew.append(disposition)\n",
    "            break"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "BodyPart=[['INTERNAL',0], ['SHOULDER',30], ['UPPER TRUNK',31], ['ELBOW', 32],['LOWER ARM',33],['WRIST',34],['KNEE',35],['LOWER LEG',36],\n",
    "     ['ANKLE', 37],['PUBIC REGION',38], ['HEAD', 75],['FACE',76],['EYEBALL',77],['UPPER TRUNK',78],['LOWER TRUNK',79],['UPPER ARM',80],\n",
    "     ['UPPER LEG',81],['HAND',82],['FOOT',83],['25-50% OF BODY',84],['ALL PARTS BODY',85],['OTHER',86],['NOT STATED/UNK',87],['MOUTH',88],\n",
    "      ['NECK',89],['LOWER ARM',90],['LOWER LEG',91],['FINGER',92],['TOE',93],['EAR',94]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create new array for descriptive Body Part, use for-loop to assign new bodyPart\n",
    "BPNew=[]\n",
    "\n",
    "for code in TraumaData['Body_Part']:\n",
    "    for (bodyPart,bpcode) in BodyPart:\n",
    "        if bpcode=='':\n",
    "            bodyPart ='missed'\n",
    "            BPNew.append(bodyPart)\n",
    "        elif code == bpcode:\n",
    "            BPNew.append(bodyPart)\n",
    "            break"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "AlcDrug=[['No/Unk',0], ['Positive',1]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create new array for descriptive EtOH use, use for-loop to assign new EtOH use\n",
    "EtOHNew=[]\n",
    "\n",
    "for code in TraumaData['Alcohol involved']:\n",
    "    for (ETStatus,ETcode) in AlcDrug:\n",
    "        if ETcode=='':\n",
    "            ETStatus ='missed'\n",
    "            EtOHNew.append(ETStatus)\n",
    "        elif code == ETcode:\n",
    "            EtOHNew.append(ETStatus)\n",
    "            break"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create new array for descriptive EtOH use, use for-loop to assign new EtOH use\n",
    "DrugNew=[]\n",
    "\n",
    "for code in TraumaData['Drug involved']:\n",
    "    for (drugStatus,drugCode) in AlcDrug:\n",
    "        if drugCode=='':\n",
    "            drugStatus ='missed'\n",
    "            DrugNew.append(drugStatus)\n",
    "        elif code == drugCode:\n",
    "            DrugNew.append(drugStatus)\n",
    "            break\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "Gender=[['Unk',0], ['Male',1],['Female',2]]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create new array for descriptive Gender use, use for-loop to assign new EtOH use\n",
    "genderNew=[]\n",
    "\n",
    "for code in TraumaData['Sex']:\n",
    "    for (sexStatus,sexCode) in Gender:\n",
    "        if sexCode=='':\n",
    "            drugStatus ='missed'\n",
    "            genderNew.append(sexStatus)\n",
    "        elif code == sexCode:\n",
    "            genderNew.append(sexStatus)\n",
    "            break"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "Race=[['Not Specified',0],['WHITE',1],['BLACK/AFRICAN AMERICAN',2],['OTHER',3],['ASIAN', 4],\n",
    "      ['AMERICAN INDIAN/ALASKA NATIVE',5],['NATIVE HAWAIIAN/PACIFIC ISLANDER',6]]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create new array for descriptive Race, use for-loop to assign new Race\n",
    "raceNew=[]\n",
    "\n",
    "for code in TraumaData['Race']:\n",
    "    for (raceStatus,raceCode) in Race:\n",
    "        if raceCode=='':\n",
    "            raceStatus ='missed'\n",
    "            raceNew.append(raceStatus)\n",
    "        elif code == raceCode:\n",
    "            raceNew.append(raceStatus)\n",
    "            break"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "productDic=[[0 , \"none\"],\n",
    "[101 , \"WASHING MACHINES WITHOUT WRINGERS OR OTHER DRYERS\"],\n",
    "[102 , \"WRINGER WASHING MACHINES\"],\n",
    "[103 , \"WASHING MACHINES WITH UNHEATED SPIN DRYERS\"],\n",
    "[106 , \"ELECTRIC CLOTHES DRYERS WITHOUT WASHERS\"],\n",
    "[107 , \"GAS CLOTHES DRYERS WITHOUT WASHERS\"],\n",
    "[108 , \"MANGLE IRONS\"],\n",
    "[110 , \"ELECTRIC HEATING PADS\"],\n",
    "[112 , \"SEWING MACHINES OR ACCESSORIES\"],\n",
    "[113 , \"FLOOR BUFFERS OR WAXERS\"],\n",
    "[114 , \"RUG SHAMPOOERS\"],\n",
    "[115 , \"VACUUM CLEANERS\"],\n",
    "[116 , \"ELECTRIC BROOMS\"],\n",
    "[118 , \"GAS WATER HEATERS\"],\n",
    "[119 , \"ELECTRIC WATER HEATERS\"],\n",
    "[125 , \"WATER SOFTENERS OR CONDITIONERS (APPLIANCES)\"],\n",
    "[126 , \"WASHING MACHINES NOT SPECIFIED\"],\n",
    "[127 , \"CLOTHES DRYERS NOT SPECIFIED\"],\n",
    "[131 , \"PROPANE LP OR BUTANE GAS TANKS OR FITTINGS\"],\n",
    "[132 , \"ELECTRIC BLANKETS OR SHEETS\"],\n",
    "[133 , \"OTHER WATER HEATERS\"],\n",
    "[134 , \"WATER HEATERS NOT SPECIFIED\"],\n",
    "[135 , \"WASHER,DRYER COMBINATIONS (WITHIN ONE FRAME)\"],\n",
    "[136 , \"DRINKING FOUNTAINS\"],\n",
    "[137 , \"AUTOMATIC DOORS OR DOOR OPENERS\"],\n",
    "[138 , \"AUTOMATIC GARAGE DOORS OR DOOR OPENERS\"],\n",
    "[139 , \"INCINERATORS\"],\n",
    "[140 , \"WASHING MACHINES OTHER OR NOT SPECIFIED\"],\n",
    "[202 , \"ELECTRIC COUNTER,MOUNTED COOKING SURFACES\"],\n",
    "[204 , \"GAS COUNTER,MOUNTED COOKING SURFACES\"],\n",
    "[212 , \"ELECTRIC CORN POPPERS\"],\n",
    "[213 , \"ELECTRIC CAN OPENERS\"],\n",
    "[214 , \"DISHWASHERS\"],\n",
    "[215 , \"ELECTRIC BLENDERS\"],\n",
    "[216 , \"ELECTRIC COUNTER,TOP OVENS BROILERS OR TOASTER OVENS\"],\n",
    "[217 , \"ELECTRIC COFFEE MAKERS OR TEAPOTS\"],\n",
    "[218 , \"ELECTRIC OR BATTERY,POWERED KNIVES\"],\n",
    "[219 , \"ELECTRIC DEEP FRYERS\"],\n",
    "[221 , \"FOOD WARMERS\"],\n",
    "[222 , \"ELECTRIC FRYING PANS AND SKILLETS\"],\n",
    "[223 , \"ELECTRIC GRIDDLES\"],\n",
    "[224 , \"HOT PLATES\"],\n",
    "[227 , \"ICE MAKERS (SEPARATE FROM REFRIGERATORS)\"],\n",
    "[231 , \"ELECTRIC MIXERS\"],\n",
    "[232 , \"ELECTRIC SCISSORS\"],\n",
    "[234 , \"TOASTERS\"],\n",
    "[235 , \"ELECTRIC WAFFLE IRONS\"],\n",
    "[236 , \"FAUCET WATER HEATERS\"],\n",
    "[237 , \"GARBAGE DISPOSERS\"],\n",
    "[238 , \"DRY HEAT IRONS\"],\n",
    "[239 , \"STEAM IRONS\"],\n",
    "[240 , \"ELECTRIC KNIFE SHARPENERS\"],\n",
    "[241 , \"ROTISSERIES\"],\n",
    "[242 , \"ELECTRIC IMMERSION WATER HEATERS\"],\n",
    "[247 , \"IRONS NOT SPECIFIED\"],\n",
    "[250 , \"RANGE OR OVEN ACCESSORIES\"],\n",
    "[252 , \"TRASH COMPACTORS\"],\n",
    "[255 , \"CLOTHES STEAMERS\"],\n",
    "[257 , \"COUNTER,MOUNTED COOKING SURFACES NOT SPECIFIED\"],\n",
    "[259 , \"ELECTRIC RANGES (WITH OVENS)\"],\n",
    "[260 , \"GAS RANGES (WITH OVENS)\"],\n",
    "[261 , \"ELECTRIC OVENS\"],\n",
    "[262 , \"GAS OVENS\"],\n",
    "[263 , \"FREEZERS (SEPARATE FROM REFRIGERATORS)\"],\n",
    "[264 , \"MICROWAVE OVENS\"],\n",
    "[265 , \"OTHER OVENS\"],\n",
    "[266 , \"OVENS NOT SPECIFIED\"],\n",
    "[267 , \"OTHER RANGES (WITH OVENS)\"],\n",
    "[268 , \"SLOW COOKERS\"],\n",
    "[269 , \"ELECTRIC KETTLES OR HOT POTS\"],\n",
    "[270 , \"ICE CRUSHERS\"],\n",
    "[271 , \"JUICERS\"],\n",
    "[273 , \"RANGES NOT SPECIFIED\"],\n",
    "[274 , \"ICE CREAM MAKERS\"],\n",
    "[275 , \"FOOD PROCESSORS\"],\n",
    "[276 , \"REFRIGERATORS\"],\n",
    "[277 , \"CLOTHING IRONS\"],\n",
    "[278 , \"ELECTRIC RANGES OR OVENS (EXCL COUNTER,TOP OVENS)\"],\n",
    "[279 , \"GAS RANGES OR OVENS\"],\n",
    "[280 , \"OTHER RANGES OR OVENS\"],\n",
    "[281 , \"RANGES OR OVENS NOT SPECIFIED\"],\n",
    "[304 , \"HUMIDIFIERS\"],\n",
    "[305 , \"VAPORIZERS\"],\n",
    "[306 , \"DEHUMIDIFIERS\"],\n",
    "[307 , \"AIR PURIFIERS\"],\n",
    "[308 , \"BOILERS\"],\n",
    "[309 , \"COAL FURNACES\"],\n",
    "[310 , \"GAS FURNACES\"],\n",
    "[311 , \"OIL FURNACES\"],\n",
    "[312 , \"ELECTRIC BASEBOARD HEATERS\"],\n",
    "[316 , \"WOOD BURNING FIREPLACES FACTORY BUILT\"],\n",
    "[318 , \"ELECTRIC FURNACES\"],\n",
    "[322 , \"FURNACES OTHER OR NOT SPECIFIED\"],\n",
    "[334 , \"GAS,BURNING FIREPLACES FACTORY BUILT\"],\n",
    "[336 , \"BUILT,IN FIREPLACES\"],\n",
    "[340 , \"THERMOSTATS (FOR HEATING OR COOLING SYSTEMS)\"],\n",
    "[342 , \"FIREPLACES NOT SPECIFIED\"],\n",
    "[346 , \"ELECTRIC FIREPLACES FACTORY BUILT\"],\n",
    "[348 , \"PORTABLE ELECTRIC HEATERS\"],\n",
    "[365 , \"HEAT PUMPS\"],\n",
    "[366 , \"CATALYTIC HEATERS\"],\n",
    "[367 , \"COAL OR WOOD,BURNING STOVES\"],\n",
    "[368 , \"GASOLINE HEATERS (NONCATALYTIC)\"],\n",
    "[369 , \"OTHER HEATERS OR HEATING SYSTEMS\"],\n",
    "[370 , \"HEATERS OR HEATING SYSTEMS NOT SPECIFIED\"],\n",
    "[371 , \"DUCTWORK FOR HEATING OR COOLING SYSTEMS\"],\n",
    "[372 , \"BRICK STONE OR MASONRY CHIMNEYS\"],\n",
    "[373 , \"METAL CHIMNEYS STOVEPIPES OR FLUES\"],\n",
    "[374 , \"PIPES (EXCLUDING SMOKING PIPES)\"],\n",
    "[378 , \"CHIMNEYS NOT SPECIFIED\"],\n",
    "[379 , \"RADIATORS (EXCLUDING VEHICLE RADIATORS)\"],\n",
    "[380 , \"FANS\"],\n",
    "[381 , \"AIR CONDITIONERS\"],\n",
    "[384 , \"FLOOR FURNACES (BUILT INTO FLOOR)\"],\n",
    "[386 , \"GAS OR LP FLOOR OR WALL HEATERS\"],\n",
    "[388 , \"ELECTRIC HEATERS NOT ELSEWHERE CLASSIFIED\"],\n",
    "[389 , \"GAS OR LP HEATERS NOT ELSEWHERE CLASSIFIED\"],\n",
    "[390 , \"HEAT TAPES ELECTRIC\"],\n",
    "[391 , \"PORTABLE GAS OR LP HEATERS\"],\n",
    "[392 , \"GAS OR LP HEATERS OTHER OR NOT SPECIFIED\"],\n",
    "[393 , \"HEATERS OR HEATING SYSTEMS OTHER OR NOT SPECIFIED\"],\n",
    "[394 , \"OUTDOOR PATIO HEATERS OR FIREPITS (MANUFACTURED)\"],\n",
    "[399 , \"KEROSENE OR OIL HEATERS\"],\n",
    "[401 , \"NONELECTRIC CAN OPENERS\"],\n",
    "[405 , \"UNPOWERED COFFEE MAKERS OR TEAPOTS\"],\n",
    "[408 , \"IRONING BOARDS OR COVERS\"],\n",
    "[412 , \"PRESSURE COOKERS OR CANNERS\"],\n",
    "[413 , \"WASTE CONTAINERS TRASH BASKETS OR REFUSE BINS\"],\n",
    "[416 , \"CORKSCREWS\"],\n",
    "[417 , \"FLATWARE (EXCL. KNIVES)\"],\n",
    "[419 , \"TIE RACKS BELT RACKS OR OTHER CLOTHES HANGERS\"],\n",
    "[420 , \"MANUAL SCISSORS\"],\n",
    "[421 , \"NONELECTRIC KNIFE SHARPENERS\"],\n",
    "[422 , \"BOTTLE OPENERS\"],\n",
    "[424 , \"GLASS DRINKING GLASSES\"],\n",
    "[427 , \"ICE PICKS\"],\n",
    "[428 , \"KITCHEN GADGETS NOT ELSEWHERE CLASSIFIED\"],\n",
    "[429 , \"FOOD SKEWERS\"],\n",
    "[431 , \"TOOTHPICKS OR HORS DOEUVRES PICKS\"],\n",
    "[432 , \"TRAYS (EXCL. FOOD WARMERS)\"],\n",
    "[434 , \"DOORSTOPS\"],\n",
    "[435 , \"KITCHEN MIXING BOWLS CANISTERS OR SIMILAR CONTAINERS\"],\n",
    "[436 , \"POTHOLDERS OVEN MITTS OR HOT PADS\"],\n",
    "[438 , \"LAUNDRY BASKETS\"],\n",
    "[443 , \"DRINKING STRAWS\"],\n",
    "[444 , \"KNIFE SHARPENERS NOT SPECIFIED\"],\n",
    "[450 , \"SCISSORS NOT SPECIFIED\"],\n",
    "[452 , \"COFFEE MAKERS OR TEAPOTS NOT SPECIFIED\"],\n",
    "[453 , \"CAN OPENERS NOT SPECIFIED\"],\n",
    "[454 , \"NONGLASS DRINKING GLASSES\"],\n",
    "[459 , \"MANUAL CLEANING EQUIPMENT\"],\n",
    "[460 , \"METAL COOKWARE (NONELECTRIC)\"],\n",
    "[461 , \"NONMETAL COOKWARE (NONELECTRIC)\"],\n",
    "[462 , \"CHAFING DISHES OR FONDUE POTS\"],\n",
    "[463 , \"CANDLES CANDLESTICKS AND OTHER CANDLE HOLDERS\"],\n",
    "[464 , \"KNIVES NOT ELSEWHERE CLASSIFIED\"],\n",
    "[465 , \"OTHER COOKWARE\"],\n",
    "[466 , \"COOKWARE NOT SPECIFIED\"],\n",
    "[469 , \"SLICERS AND CHOPPERS\"],\n",
    "[471 , \"FOOD GRINDERS\"],\n",
    "[474 , \"TABLEWARE AND ACCESSORIES (EXCL. DRINKING GLASSES CUPS AND MUGS)\"],\n",
    "[475 , \"DRINKING GLASSES NOT SPECIFIED\"],\n",
    "[477 , \"THERMOMETERS (EXCLUDING MEDICAL THERMOMETERS)\"],\n",
    "[478 , \"DRINKING GLASSES CUPS AND MUGS\"],\n",
    "[480 , \"MANUAL CLEANING EQUIPMENT (EXCL. BUCKETS AND PAILS)\"],\n",
    "[481 , \"BREAD MAKING MACHINES\"],\n",
    "[482 , \"APPLIANCES OTHER AND NOT SPECIFIED\"],\n",
    "[514 , \"CERAMICS SUPPLIES OR EQUIPMENT\"],\n",
    "[519 , \"TELEVISION TABLES OR STANDS\"],\n",
    "[529 , \"TELESCOPES BINOCULARS MICROSCOPES MAGNIFYING GLASSES\"],\n",
    "[530 , \"PHONOGRAPH RECORDS\"],\n",
    "[531 , \"RECORDING TAPES\"],\n",
    "[532 , \"GLASS BOTTLE CUTTING EQUIPMENT\"],\n",
    "[533 , \"LAPIDARY EQUIPMENT\"],\n",
    "[536 , \"PHOTOGRAPHIC EQUIPMENT\"],\n",
    "[545 , \"AMATEUR TWO,WAY RADIOS\"],\n",
    "[546 , \"STEREO OR HI,FI COMPONENTS OR ACCESSORIES\"],\n",
    "[547 , \"SOUND RECORDING OR RECEIVING EQUIPMENT NOT SPECIFIED\"],\n",
    "[549 , \"PROJECTORS\"],\n",
    "[550 , \"TELEPHONES OR TELEPHONE ACCESSORIES\"],\n",
    "[552 , \"ANTENNAS NOT SPECIFIED\"],\n",
    "[555 , \"RADIOS (SELF,CONTAINED UNITS)\"],\n",
    "[556 , \"TAPE RECORDERS OR PLAYERS (SELF,CONTAINED UNITS)\"],\n",
    "[557 , \"COMPUTERS (EQUIPMENT AND ELECTRONIC GAMES)\"],\n",
    "[558 , \"INDOOR ANTENNAS (SEPARATE)\"],\n",
    "[559 , \"RADIOS NOT SPECIFIED\"],\n",
    "[561 , \"OUTDOOR ANTENNAS (SEPARATE)\"],\n",
    "[562 , \"LASER POINTERS\"],\n",
    "[563 , \"RECORD PLAYERS (SELF,CONTAINED UNITS)\"],\n",
    "[564 , \"ART SUPPLIES OR EQUIPMENT\"],\n",
    "[565 , \"MUSICAL INSTRUMENTS ELECTRIC OR BATTERY OPERATED\"],\n",
    "[566 , \"MUSICAL INSTRMNTS NOT ELECT. OR BATTERY OR NOT SPEC.\"],\n",
    "[567 , \"COAXIAL CABLE\"],\n",
    "[569 , \"ART OR CERAMICS SUPPLIES AND EQUIPMENT (EXCL. PAINTBRUSHES)\"],\n",
    "[570 , \"MUSICAL INSTRUMENTS\"],\n",
    "[571 , \"BUSINESS AND OFFICE MACHINES\"],\n",
    "[572 , \"TELEVISIONS\"],\n",
    "[573 , \"OTHER SOUND RECORDING REPRODUCING OR RECEIVING EQUIP.\"],\n",
    "[574 , \"REMOTE CONTROL UNIVERSAL OR NS (EXCL. REMOTES FOR TOYS)\"],\n",
    "[575 , \"COMPACT DISCS (CDS) AND DVDS\"],\n",
    "[576 , \"VIDEO PLAYERS AND RECORDERS (EXCL CAMERAS)\"],\n",
    "[601 , \"BEDSPRINGS OR BEDFRAMES\"],\n",
    "[604 , \"DESKS CHESTS BUREAUS OR BUFFETS\"],\n",
    "[606 , \"GENERATORS OR POWER PLANTS\"],\n",
    "[609 , \"GLASS BATHTUB OR SHOWER ENCLOSURES\"],\n",
    "[610 , \"NONGLASS BATHTUB OR SHOWER ENCLOSURES\"],\n",
    "[611 , \"BATHTUBS OR SHOWERS\"],\n",
    "[612 , \"RUNNERS THROW RUGS OR DOORMATS\"],\n",
    "[613 , \"ROOM,SIZED WALL,TO,WALL OR OUTDOOR CARPETING\"],\n",
    "[617 , \"DRAPERIES CURTAINS SHOWER CURTAINS(FABRIC OR PLASTIC)\"],\n",
    "[618 , \"STEPLADDERS\"],\n",
    "[619 , \"STRAIGHT LADDERS\"],\n",
    "[620 , \"STEP STOOLS\"],\n",
    "[623 , \"BUTANE OR LP GAS METERS\"],\n",
    "[624 , \"ELECTRIC METERS (UTILITY)\"],\n",
    "[627 , \"LIGHT BULBS\"],\n",
    "[628 , \"ELECTRIC CHANDELIERS OR OTHER ATTACHED LIGHT FIXTURES\"],\n",
    "[638 , \"WINDOW SHADES VENETIAN BLINDS OR INDOOR SHUTTERS\"],\n",
    "[639 , \"FLASHLIGHTS OR BATTERY,POWERED LANTERNS\"],\n",
    "[648 , \"SINKS\"],\n",
    "[649 , \"TOILETS\"],\n",
    "[650 , \"SLIPCOVERS\"],\n",
    "[651 , \"TABLE LINENS\"],\n",
    "[652 , \"PICTURES PICTURE FRAMES OR WALL DECORATIONS\"],\n",
    "[653 , \"ARTIFICIAL FLOWERS OR PLANTS\"],\n",
    "[654 , \"KNICKKNACKS STATUES VASES OR URNS\"],\n",
    "[657 , \"TOWEL RACKS OR BARS\"],\n",
    "[661 , \"BUNK BEDS\"],\n",
    "[662 , \"WATERBEDS OR WATER PILLOWS\"],\n",
    "[663 , \"FIREPLACE EQUIPMENT\"],\n",
    "[666 , \"TOWELS OR CLOTHS\"],\n",
    "[667 , \"BEDSPREADS THROWS OR COMFORTERS\"],\n",
    "[669 , \"CLOTHESPINS\"],\n",
    "[670 , \"RECLINER CHAIR\"],\n",
    "[671 , \"ROCKING CHAIR\"],\n",
    "[672 , \"LAUNDRY HAMPERS\"],\n",
    "[676 , \"RUGS OR CARPETS NOT SPECIFIED\"],\n",
    "[679 , \"SOFAS COUCHES DAVENPORTS DIVANS OR STUDIO COUCHES\"],\n",
    "[680 , \"CONVERTIBLE BEDS HIDEAWAY BEDS OR SOFA BEDS\"],\n",
    "[684 , \"UNATTACHED APPLIANCE OR LAMP CORDS\"],\n",
    "[685 , \"EXTENSION CORDS\"],\n",
    "[687 , \"BENCHES\"],\n",
    "[688 , \"EXTENSION LADDERS\"],\n",
    "[689 , \"BLANKETS NOT SPECIFIED\"],\n",
    "[692 , \"MAGAZINE RACKS OR BOOK ENDS\"],\n",
    "[693 , \"FOOTLOCKERS\"],\n",
    "[694 , \"BEDS NOT SPECIFIED\"],\n",
    "[698 , \"HOT TUBS OR HOME SPAS\"],\n",
    "[699 , \"FAUCETS OR SPIGOTS\"],\n",
    "[701 , \"FIRE EXTINGUISHERS\"],\n",
    "[702 , \"FIRE OR SMOKE ALARMS\"],\n",
    "[704 , \"BURGLAR ALARMS\"],\n",
    "[706 , \"LIGHTNING RODS ARRESTERS OR OTHER GROUNDING DEVICES\"],\n",
    "[707 , \"PADLOCKS CHAIN LOCKS OR OTHER LOCKS\"],\n",
    "[709 , \"SAFES\"],\n",
    "[710 , \"ELECTRIC TIMERS\"],\n",
    "[711 , \"FIRE ESCAPE DEVICES\"],\n",
    "[712 , \"CARBON MONOXIDE DETECTORS\"],\n",
    "[713 , \"FIRE SPRINKLERS\"],\n",
    "[803 , \"POWER SANDERS\"],\n",
    "[804 , \"POWER ROUTERS\"],\n",
    "[805 , \"POWER LATHES\"],\n",
    "[807 , \"POWER JOINTERS\"],\n",
    "[808 , \"POWER SHAPERS\"],\n",
    "[809 , \"OTHER PORTABLE OR STATIONARY POWER TOOLS\"],\n",
    "[812 , \"ELECTRIC WELDING EQUIPMENT\"],\n",
    "[814 , \"HOISTS LIFTS JACKS OR JACK STANDS\"],\n",
    "[815 , \"ELECTRICAL TESTING EQUIPMENT\"],\n",
    "[819 , \"ELECTRIC MOTORS (SEPARATE)\"],\n",
    "[820 , \"INTERNAL COMBUSTION ENGINES (NONVEHICULAR)\"],\n",
    "[821 , \"AUTOMOTIVE TOOLS OR ACCESSORIES\"],\n",
    "[822 , \"PAINT SPRAYERS\"],\n",
    "[823 , \"AIR COMPRESSORS (SEPARATE)\"],\n",
    "[827 , \"HAMMERS\"],\n",
    "[828 , \"SCREWDRIVERS\"],\n",
    "[829 , \"MANUAL DRILLS\"],\n",
    "[830 , \"HAND SAWS\"],\n",
    "[831 , \"FUEL,BURNING WELDING EQUIPMENT\"],\n",
    "[832 , \"PORTABLE CIRCULAR POWER SAWS\"],\n",
    "[833 , \"WORKSHOP COMPOUNDS OR CHEMICALS\"],\n",
    "[834 , \"HEAVY,DUTY WORKSHOP STAPLERS\"],\n",
    "[835 , \"TOOLBOXES OR TOOL KITS\"],\n",
    "[836 , \"KNIVES WITH REPLACEABLE BLADES\"],\n",
    "[837 , \"WIRE NOT SPECIFIED\"],\n",
    "[841 , \"BENCH OR TABLE SAWS\"],\n",
    "[842 , \"BAND SAWS\"],\n",
    "[843 , \"RADIAL ARM SAWS\"],\n",
    "[844 , \"POWER HACK SAWS\"],\n",
    "[845 , \"SAWS NOT SPECIFIED\"],\n",
    "[847 , \"DRILLS NOT SPECIFIED\"],\n",
    "[852 , \"ROPE OR STRING\"],\n",
    "[854 , \"WORKSHOP FURNISHINGS\"],\n",
    "[855 , \"PORTABLE POWER DRILLS AND ACCESSORIES\"],\n",
    "[856 , \"STATIONARY POWER DRILLS AND ACCESSORIES\"],\n",
    "[857 , \"PLIERS WIRE CUTTERS OR WRENCHES\"],\n",
    "[858 , \"REAMERS\"],\n",
    "[859 , \"SOLDERING EQUIPMENT NOT SPECIFIED\"],\n",
    "[862 , \"MANUAL FILING OR SANDING TOOLS\"],\n",
    "[863 , \"OTHER POWER SAWS\"],\n",
    "[864 , \"SABRE SAWS\"],\n",
    "[865 , \"PORTABLE POWER WORKSHOP GRINDERS BUFFERS POLISHERS\"],\n",
    "[866 , \"ELECTRIC SOLDERING EQUIPMENT\"],\n",
    "[867 , \"WELDING EQUIPMENT NOT SPECIFIED\"],\n",
    "[868 , \"NONELECTRIC SOLDERING EQUIPMENT\"],\n",
    "[869 , \"GLUE GUNS\"],\n",
    "[870 , \"AWLS CHISELS OR PLANES\"],\n",
    "[871 , \"POWER DRILLS OR ACCESSORIES NOT SPECIFIED\"],\n",
    "[872 , \"POWER SAWS NOT SPECIFIED\"],\n",
    "[873 , \"STATIONARY POWER WORKSHOP GRINDERS BUFFERS POLISHERS\"],\n",
    "[874 , \"CUTTING TORCHES\"],\n",
    "[875 , \"JIGSAWS\"],\n",
    "[876 , \"POWER WORKSHOP GRINDERS BUFFERS POLISHERS N.S.\"],\n",
    "[877 , \"TROUBLE LIGHTS OR EXTENSION WORK LIGHTS\"],\n",
    "[878 , \"LEVELS\"],\n",
    "[879 , \"VISES OR WORKSHOP CLAMPS\"],\n",
    "[880 , \"DRAIN SNAKES\"],\n",
    "[881 , \"OTHER MANUAL WORKSHOP TOOLS\"],\n",
    "[882 , \"NAIL GUNS OR STUD DRIVERS\"],\n",
    "[883 , \"BATTERY CHARGERS/ADAPTERS\"],\n",
    "[884 , \"BATTERIES\"],\n",
    "[885 , \"CHAINS NOT ELSEWHERE CLASSIFIED\"],\n",
    "[886 , \"STRETCH CORDS OR STRETCH STRAPS\"],\n",
    "[887 , \"PAINTING EQUIP. POWERED (SPRAYERS ROLLERS BRUSHES)\"],\n",
    "[888 , \"SPRAYERS NOT ELSEWHERE CLASSIFIED\"],\n",
    "[889 , \"BATTERIES (MOTOR VEHICLE)\"],\n",
    "[890 , \"TORCHES NOT SPECIFIED\"],\n",
    "[891 , \"BATTERIES NOT SPECIFIED\"],\n",
    "[892 , \"NON,MOTOR VEHICLE BATTERIES\"],\n",
    "[893 , \"TOOLS NOT SPECIFIED\"],\n",
    "[894 , \"HACKSAWS\"],\n",
    "[895 , \"POWER SAWS OTHER OR NOT SPECIFIED\"],\n",
    "[896 , \"WELDING EQUIPMENT\"],\n",
    "[897 , \"POWER WORKSHOP GRINDERS BUFFERS OR POLISHERS\"],\n",
    "[898 , \"MANUAL WORKSHOP GRINDERS BUFFERS OR POLISHERS\"],\n",
    "[899 , \"WORKSHOP GRINDERS BUFFERS OR POLISHERS N.S.\"],\n",
    "[904 , \"FLOOR WAXES\"],\n",
    "[905 , \"FURNITURE POLISHES OR WAXES\"],\n",
    "[908 , \"PAINT THINNERS OR VARNISH THINNERS\"],\n",
    "[909 , \"ADHESIVES\"],\n",
    "[910 , \"GASOLINE\"],\n",
    "[913 , \"LUBRICANTS\"],\n",
    "[914 , \"DRY ICE\"],\n",
    "[915 , \"METHYL ALCOHOL (SOLVENT)\"],\n",
    "[917 , \"CHARCOAL\"],\n",
    "[920 , \"CAULKING OR SPACKLING COMPOUNDS\"],\n",
    "[921 , \"CHEMICALS NOT ELSEWHERE CLASSIFIED\"],\n",
    "[925 , \"PAINTBRUSHES OR ROLLERS MANUAL\"],\n",
    "[926 , \"PHOTOGRAPHIC CHEMICALS\"],\n",
    "[927 , \"TAPES (WITH ADHESIVE SURFACES)\"],\n",
    "[929 , \"DRAIN CLEANERS\"],\n",
    "[930 , \"AMMONIA HOUSEHOLD\"],\n",
    "[931 , \"METAL POLISHES TARNISH REMOVERS OR PREVENTATIVES\"],\n",
    "[932 , \"SHOE POLISHES\"],\n",
    "[933 , \"TURPENTINE\"],\n",
    "[934 , \"DISHWASHER DETERGENTS\"],\n",
    "[936 , \"ACIDS\"],\n",
    "[937 , \"RUST REMOVERS\"],\n",
    "[938 , \"SWIMMING POOL CHEMICALS\"],\n",
    "[940 , \"LIGHTER FLUIDS\"],\n",
    "[941 , \"FUELS FOR CHAFING DISHES OR FONDUE POTS\"],\n",
    "[942 , \"OVEN CLEANERS\"],\n",
    "[943 , \"MOTH REPELLENTS\"],\n",
    "[945 , \"PINE OIL CLEANING AND DISINFECTANT PREPARATIONS\"],\n",
    "[949 , \"LAUNDRY SOAPS OR DETERGENTS\"],\n",
    "[951 , \"TOILET BOWL PRODUCTS\"],\n",
    "[952 , \"FABRIC TREATMENT PRODUCTS\"],\n",
    "[953 , \"ABRASIVE CLEANERS\"],\n",
    "[954 , \"GENERAL PURPOSE HOUSEHOLD CLEANERS\"],\n",
    "[955 , \"AUTOMOTIVE CHEMICALS\"],\n",
    "[956 , \"BLEACHES (NONCOSMETIC)\"],\n",
    "[957 , \"DYES (NONCOSMETIC)\"],\n",
    "[958 , \"OTHER POLISHES\"],\n",
    "[959 , \"POLISHES NOT SPECIFIED\"],\n",
    "[960 , \"PAINTS VARNISHES OR SHELLACS\"],\n",
    "[961 , \"RUST PREVENTATIVES\"],\n",
    "[962 , \"DIESEL FUELS\"],\n",
    "[963 , \"KEROSENE\"],\n",
    "[964 , \"LAMP OILS\"],\n",
    "[965 , \"FUEL OILS NOT SPECIFIED\"],\n",
    "[966 , \"ANTIFREEZE\"],\n",
    "[967 , \"WINDSHIELD WIPER FLUIDS\"],\n",
    "[968 , \"CAUSTICS\"],\n",
    "[969 , \"LYE\"],\n",
    "[970 , \"WALLPAPER CLEANERS (CHEMICAL)\"],\n",
    "[971 , \"WALLPAPER STEAMERS\"],\n",
    "[972 , \"PAINT OR VARNISH REMOVERS PAINTBRUSH CLEANERS\"],\n",
    "[973 , \"LIQUID ROOM DEODORIZERS OR FRESHENERS\"],\n",
    "[974 , \"SOLID ROOM DEODORIZERS OR FRESHENERS\"],\n",
    "[975 , \"ROOM DEODORIZERS OR FRESHENERS NOT SPECIFIED\"],\n",
    "[976 , \"DETERGENTS NOT SPECIFIED\"],\n",
    "[977 , \"SPOT REMOVERS OR CLEANING FLUIDS\"],\n",
    "[978 , \"AUTOMOTIVE WAXES POLISHES OR CLEANERS\"],\n",
    "[979 , \"DISHWASHING LIQUID\"],\n",
    "[980 , \"FUEL STORAGE TANKS\"],\n",
    "[981 , \"GASOLINE CANS\"],\n",
    "[982 , \"SCHOOL LABORATORY CHEMICALS\"],\n",
    "[983 , \"SOAPS (EXCL. LAUNDRY SOAPS OR DETERGENTS)\"],\n",
    "[984 , \"SOLVENTS OTHER OR NOT SPECIFIED\"],\n",
    "[1001 , \"ELECTRIC FENCES\"],\n",
    "[1002 , \"HOME PASTEURIZERS\"],\n",
    "[1003 , \"CREAM SEPARATORS\"],\n",
    "[1004 , \"FARM TRACTORS\"],\n",
    "[1005 , \"POWER TAKE,OFFS\"],\n",
    "[1006 , \"FARM TILLAGE EQUIPMENT\"],\n",
    "[1009 , \"COMBINES OR THRESHING MACHINES\"],\n",
    "[1011 , \"FARM ELEVATORS OR CONVEYORS\"],\n",
    "[1012 , \"FARM WAGONS\"],\n",
    "[1014 , \"FARM SPRAYERS\"],\n",
    "[1015 , \"IRRIGATION EQUIPMENT\"],\n",
    "[1016 , \"FEED GRINDERS MIXERS OR BLENDERS\"],\n",
    "[1017 , \"MILKING MACHINES\"],\n",
    "[1018 , \"TOW CHAINS CABLES OR HEAVY,DUTY CHAINS\"],\n",
    "[1019 , \"POST,HOLE AUGERS\"],\n",
    "[1021 , \"FARM MOWERS\"],\n",
    "[1022 , \"TILLAGE EQUIPMENT NOT SPECIFIED\"],\n",
    "[1023 , \"FERTILIZERS NOT SPECIFIED\"],\n",
    "[1025 , \"ENDGATE SEEDERS\"],\n",
    "[1026 , \"OTHER CROP PROCESSING EQUIPMENT\"],\n",
    "[1030 , \"FORAGE HARVESTERS\"],\n",
    "[1036 , \"MANURE SPREADERS\"],\n",
    "[1037 , \"PUMP JACKS\"],\n",
    "[1038 , \"POST,HOLE DRIVERS\"],\n",
    "[1039 , \"FERTILIZER DISTRIBUTORS (GRANULAR)\"],\n",
    "[1040 , \"RAKES (FARM MACHINERY)\"],\n",
    "[1042 , \"WINDROWERS OR SWATHERS\"],\n",
    "[1043 , \"CROP CHOPPERS\"],\n",
    "[1044 , \"FORK LIFTS OR LIFT TRUCKS\"],\n",
    "[1052 , \"STANCHIONS\"],\n",
    "[1053 , \"FERTILIZERS AND OTHER CHEMICALS FOR OUTDOOR USE\"],\n",
    "[1054 , \"OTHER PLANTING EQUIPMENT\"],\n",
    "[1055 , \"HAY PROCESSING EQUIPMENT\"],\n",
    "[1056 , \"TOBACCO STRINGERS HARVESTERS OR SLEDS\"],\n",
    "[1057 , \"CROP PICKERS\"],\n",
    "[1058 , \"CORN PLANTERS OR GRAIN DRILLS\"],\n",
    "[1059 , \"SILO LOADERS AND UNLOADERS SCREW OR SWEEP AUGERS\"],\n",
    "[1060 , \"PLANTING EQUIPMENT NOT SPECIFIED\"],\n",
    "[1061 , \"CROP PROCESSING EQUIPMENT NOT SPECIFIED\"],\n",
    "[1062 , \"TRACTORS OTHER OR NOT SPECIFIED N.O.S.\"],\n",
    "[1102 , \"VACUUM CONTAINERS\"],\n",
    "[1103 , \"SELF,CONTAINED OPENERS\"],\n",
    "[1107 , \"OTHER CONTAINERS\"],\n",
    "[1112 , \"METAL CONTAINERS\"],\n",
    "[1114 , \"CARDBOARD PRODUCTS\"],\n",
    "[1116 , \"CONTAINERS WITH KEY OPENERS\"],\n",
    "[1120 , \"GLASS SOFT DRINK BOTTLES\"],\n",
    "[1122 , \"GLASS ALCOHOLIC BEVERAGE BOTTLES\"],\n",
    "[1123 , \"PLASTIC CONTAINERS (RIGID OR SEMI,RIGID)\"],\n",
    "[1124 , \"GLASS TUBING OR TEST TUBES\"],\n",
    "[1125 , \"WOODEN CONTAINERS\"],\n",
    "[1127 , \"NONGLASS BOTTLES OR JARS\"],\n",
    "[1128 , \"PAPER BAGS\"],\n",
    "[1130 , \"PLASTIC BAGS\"],\n",
    "[1131 , \"PLASTIC WRAPPING PRODUCTS\"],\n",
    "[1132 , \"PLASTIC PRODUCTS NOT SPECIFIED\"],\n",
    "[1133 , \"AEROSOL CONTAINERS\"],\n",
    "[1134 , \"OTHER GLASS BOTTLES OR JARS\"],\n",
    "[1135 , \"BOTTLES OR JARS NOT SPECIFIED\"],\n",
    "[1136 , \"CANNING JARS\"],\n",
    "[1137 , \"PAPER PRODUCTS\"],\n",
    "[1138 , \"PRESSURIZED CONTAINERS (NONAEROSOL)\"],\n",
    "[1139 , \"ALUMINUM FOIL WRAPPING PRODUCTS\"],\n",
    "[1140 , \"GLASS BOTTLES OR JARS NOT SPECIFIED\"],\n",
    "[1141 , \"CONTAINERS NOT SPECIFIED\"],\n",
    "[1142 , \"BAGS (EXCLUDING PAPER OR PLASTIC BAGS)\"],\n",
    "[1143 , \"BUCKETS OR PAILS\"],\n",
    "[1144 , \"BAGS NOT ELSEWHERE CLASSIFIED\"],\n",
    "[1145 , \"OTHER SPECIFIED PLASTIC PRODUCTS\"],\n",
    "[1200 , \"SPORTS AND RECREATIONAL ACTIVITY N.E.C.\"],\n",
    "[1202 , \"BICYCLES OR ACCESSORIES\"],\n",
    "[1204 , \"BASEBALL ACTIVITY AND RELATED EQUIPMENT\"],\n",
    "[1205 , \"BASKETBALL ACTIVITY AND RELATED EQUIPMENT\"],\n",
    "[1206 , \"BOWLING (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[1207 , \"BOXING (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[1208 , \"CROQUET (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[1211 , \"FOOTBALL (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[1212 , \"GOLF (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[1213 , \"GOLF CARTS MOTORIZED VEHICLE\"],\n",
    "[1215 , \"LACROSSE (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[1217 , \"SLEDS\"],\n",
    "[1232 , \"ELECTRIC CHARCOAL LIGHTERS\"],\n",
    "[1233 , \"TRAMPOLINES\"],\n",
    "[1234 , \"TREEHOUSES OR PLAYHOUSES\"],\n",
    "[1235 , \"ARCHERY (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[1237 , \"GAS AIR OR SPRING,OPERATED GUNS\"],\n",
    "[1239 , \"HORSEBACK RIDING (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[1240 , \"AQUARIUMS OR ACCESSORIES\"],\n",
    "[1242 , \"SLIDES OR SLIDING BOARDS\"],\n",
    "[1243 , \"SEE,SAWS OR TEETER BOARDS\"],\n",
    "[1244 , \"MONKEY BARS OR OTHER PLAYGROUND CLIMBING APPARATUS\"],\n",
    "[1246 , \"WADING POOLS\"],\n",
    "[1247 , \"FUEL CHARCOAL LIGHTERS\"],\n",
    "[1248 , \"DARTS (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[1255 , \"ALCOHOL,FUELED HEATERS\"],\n",
    "[1257 , \"HORSESHOES (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[1258 , \"MOUNTAIN CLIMBING (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[1260 , \"BILLIARDS OR POOL (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[1261 , \"SURFING (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[1264 , \"WATER SKIING (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[1266 , \"VOLLEYBALL (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[1267 , \"SOCCER (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[1268 , \"TRACK AND FIELD (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[1269 , \"TABLE TENNIS (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[1270 , \"WRESTLING (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[1271 , \"BATONS\"],\n",
    "[1272 , \"GYMNASTICS AND ASSOCIATED EQUIPMENT\"],\n",
    "[1273 , \"TOBOGGANS\"],\n",
    "[1274 , \"SNOW DISKS\"],\n",
    "[1275 , \"SCUBA DIVING (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[1276 , \"TETHERBALL (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[1277 , \"SWIMMING POOL SLIDES\"],\n",
    "[1278 , \"DIVING OR DIVING BOARDS\"],\n",
    "[1279 , \"ICE HOCKEY (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[1282 , \"HANDBALL (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[1283 , \"UNICYCLES\"],\n",
    "[1284 , \"SWIMMING POOLS NOT SPECIFIED\"],\n",
    "[1285 , \"CHARCOAL LIGHTERS NOT SPECIFIED\"],\n",
    "[1290 , \"SNOWMOBILES (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[1293 , \"AMUSEMENT ATTRACTIONS (INCLUDING RIDES)\"],\n",
    "[1294 , \"BLEACHERS\"],\n",
    "[1295 , \"FIELD HOCKEY (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[1299 , \"SNOW TUBING (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[1301 , \"TRICYCLES\"],\n",
    "[1306 , \"GASOLINE OR OTHER FUEL POWERED MODELS\"],\n",
    "[1309 , \"KITES OR KITE STRING\"],\n",
    "[1310 , \"POGO STICKS\"],\n",
    "[1313 , \"FIREWORKS\"],\n",
    "[1314 , \"ROCKETRY SETS\"],\n",
    "[1317 , \"FLYING TOYS\"],\n",
    "[1318 , \"UNPOWERED MODELS OR PARTS\"],\n",
    "[1319 , \"METAL OR PLASTIC MOLDING SETS\"],\n",
    "[1322 , \"CHILDRENS PLAY TENTS PLAY TUNNELS OR OTHER ENCLOSURES\"],\n",
    "[1325 , \"INFLATABLE TOYS\"],\n",
    "[1326 , \"BLOCKS STACKING TOYS OR PULL TOYS\"],\n",
    "[1327 , \"NONWHEELED RIDING TOYS UNPOWERED\"],\n",
    "[1328 , \"WAGONS (CHILDRENS)\"],\n",
    "[1329 , \"SCOOTERS UNPOWERED\"],\n",
    "[1330 , \"POWERED RIDING TOYS\"],\n",
    "[1332 , \"ELECTRIC TRAINS OR ACCESSORIES\"],\n",
    "[1333 , \"SKATEBOARDS\"],\n",
    "[1334 , \"ELECTRIC TOY OVENS\"],\n",
    "[1335 , \"ELECTRIC TOY IRONS\"],\n",
    "[1338 , \"TOY BOWS OR ARROWS\"],\n",
    "[1342 , \"COSTUMES OR MASKS\"],\n",
    "[1344 , \"TOY MUSICAL INSTRUMENTS\"],\n",
    "[1345 , \"BUILDING SETS\"],\n",
    "[1346 , \"CLACKER BALLS\"],\n",
    "[1347 , \"BALLOONS (TOY)\"],\n",
    "[1349 , \"STILTS\"],\n",
    "[1350 , \"SQUEEZE OR SQUEAKER TOYS\"],\n",
    "[1352 , \"SLINGSHOTS OR SLING,PROPELLED TOYS\"],\n",
    "[1353 , \"TOY BOXES OR CHESTS\"],\n",
    "[1354 , \"MARBLES\"],\n",
    "[1356 , \"ENGINE FUELS FOR MODELS\"],\n",
    "[1362 , \"WOODBURNING KITS\"],\n",
    "[1365 , \"WATER TOYS\"],\n",
    "[1376 , \"MOLDING COMPOUNDS\"],\n",
    "[1381 , \"TOYS NOT ELSEWHERE CLASSIFIED\"],\n",
    "[1383 , \"ELECTRIC TOY RACING CARS OR ACCESSORIES\"],\n",
    "[1389 , \"OTHER TOY WEAPONS (NONPROJECTILE)\"],\n",
    "[1390 , \"TOY GUNS NOT SPECIFIED\"],\n",
    "[1392 , \"TOY SPORTS EQUIPMENT\"],\n",
    "[1393 , \"CHEMISTRY SETS OR SCIENCE KITS\"],\n",
    "[1394 , \"DOLLS PLUSH TOYS AND ACTION FIGURES\"],\n",
    "[1395 , \"TOYS NOT SPECIFIED\"],\n",
    "[1398 , \"WHEELED RIDING TOYS UNPOWERED\"],\n",
    "[1399 , \"TOY GUNS WITH PROJECTILES\"],\n",
    "[1401 , \"POWER LAWN MOWERS NOT SPECIFIED\"],\n",
    "[1402 , \"MANUAL PUSH MOWERS (UNPOWERED)\"],\n",
    "[1403 , \"OTHER UNPOWERED GARDEN TOOLS\"],\n",
    "[1404 , \"POWER LAWN TRIMMERS OR EDGERS\"],\n",
    "[1405 , \"GARDEN TRACTORS\"],\n",
    "[1406 , \"SNOW THROWERS BLOWERS\"],\n",
    "[1407 , \"GARDEN SPRAYERS\"],\n",
    "[1408 , \"POWER TILLERS OR CULTIVATORS\"],\n",
    "[1409 , \"OTHER POWER GARDEN TOOLS\"],\n",
    "[1411 , \"CHAIN SAWS\"],\n",
    "[1413 , \"GREENHOUSE OR GARDENING SUPPLIES\"],\n",
    "[1414 , \"GARDEN HOSES NOZZLES OR SPRINKLERS\"],\n",
    "[1415 , \"MANUAL SNOW OR ICE REMOVAL TOOLS\"],\n",
    "[1417 , \"DECORATIVE YARD EQUIPMENT\"],\n",
    "[1422 , \"RIDING POWER LAWN MOWERS\"],\n",
    "[1425 , \"WHEELBARROWS OR LAWN CARTS\"],\n",
    "[1426 , \"HATCHETS OR AXES\"],\n",
    "[1427 , \"POWER HEDGE TRIMMERS\"],\n",
    "[1430 , \"SEED AND FERTILIZER SPREADERS\"],\n",
    "[1431 , \"GRASS AND LEAF CATCHERS (ATTACHMENTS FOR LAWN MOWERS)\"],\n",
    "[1432 , \"ANIMAL TRAPS\"],\n",
    "[1433 , \"POWER LEAF MULCHERS AND GRINDERS\"],\n",
    "[1434 , \"SNOW THROWERS OR BLOWERS (ATTACHMENTS FOR LAWN MOWERS)\"],\n",
    "[1435 , \"SNOW PLOWS\"],\n",
    "[1439 , \"LAWN MOWERS NOT SPECIFIED\"],\n",
    "[1441 , \"LAWN VACUUMS\"],\n",
    "[1445 , \"PLANT FOODS OR FERTILIZERS FOR POTTED PLANTS\"],\n",
    "[1446 , \"REEL POWER LAWN MOWERS\"],\n",
    "[1447 , \"PRUNING OR TRIMMING EQUIPMENT NOT SPECIFIED\"],\n",
    "[1448 , \"ROTARY POWER LAWN MOWERS\"],\n",
    "[1449 , \"MANUAL HEDGE TRIMMERS\"],\n",
    "[1450 , \"MANUAL LAWN TRIMMERS OR EDGERS\"],\n",
    "[1451 , \"SEEDS\"],\n",
    "[1452 , \"OUTDOOR ELECTRIC LIGHTING EQUIPMENT\"],\n",
    "[1453 , \"OTHER MANUAL PRUNING OR TRIMMING EQUIPMENT\"],\n",
    "[1454 , \"OTHER POWER PRUNING OR TRIMMING EQUIPMENT\"],\n",
    "[1455 , \"MANUAL PRUNING OR TRIMMING EQUIPMENT NOT SPECIFIED\"],\n",
    "[1456 , \"POWER PRUNING OR TRIMMING EQUIPMENT NOT SPECIFIED\"],\n",
    "[1457 , \"LOG SPLITTERS\"],\n",
    "[1458 , \"SNOW THROWERS OR BLOWERS (SELF,CONTAINED UNITS)\"],\n",
    "[1459 , \"SNOW THROWERS OR BLOWERS NOT SPECIFIED\"],\n",
    "[1460 , \"INSECT TRAPS POWERED\"],\n",
    "[1461 , \"LEAF BLOWERS\"],\n",
    "[1462 , \"PUMPS NOT ELSEWHERE CLASSIFIED\"],\n",
    "[1463 , \"BRUSHCUTTERS POWERED\"],\n",
    "[1464 , \"LAWN TRIMMERS OR EDGERS POWERED (EXCL. BRUSHCUTTERS)\"],\n",
    "[1465 , \"DECORATIVE YARD EQUIPMENT EXCL WATER FEATURES\"],\n",
    "[1466 , \"DECORATIVE WATER FEATURES INCL MAN,MADE PONDS & FOUNTAINS\"],\n",
    "[1502 , \"BABY CHANGING TABLES\"],\n",
    "[1505 , \"BABY CARRIAGES\"],\n",
    "[1506 , \"BABY GATES OR BARRIERS\"],\n",
    "[1508 , \"BABY WALKERS OR JUMPERS\"],\n",
    "[1509 , \"BABY BOTTLES OR NIPPLES\"],\n",
    "[1510 , \"BOTTLE WARMERS\"],\n",
    "[1511 , \"STERILIZERS (HOME USE)\"],\n",
    "[1512 , \"DIAPERS\"],\n",
    "[1513 , \"PLAYPENS\"],\n",
    "[1515 , \"BABY SCALES\"],\n",
    "[1517 , \"BABY RATTLES\"],\n",
    "[1518 , \"YOUTH CHAIRS\"],\n",
    "[1519 , \"CAR SEATS (FOR INFANTS OR CHILDREN)\"],\n",
    "[1520 , \"BABY EXERCISERS\"],\n",
    "[1522 , \"BABY STROLLERS\"],\n",
    "[1524 , \"BABY HARNESSES\"],\n",
    "[1525 , \"PACIFIERS OR TEETHING RINGS\"],\n",
    "[1526 , \"CRIB MOBILES OR CRIB GYMS\"],\n",
    "[1527 , \"BABY CARRIERS OR SLINGS (BACKPACKS)\"],\n",
    "[1528 , \"DIAPER PAILS\"],\n",
    "[1529 , \"PORTABLE CRIBS\"],\n",
    "[1531 , \"BABY CARRIERS (BICYCLE,MOUNTED)\"],\n",
    "[1533 , \"NIGHT,LIGHTS\"],\n",
    "[1534 , \"CAR BEDS FOR INFANTS\"],\n",
    "[1535 , \"POTTY CHAIRS OR TRAINING SEATS\"],\n",
    "[1536 , \"CRIB EXTENDER RAILS OR YOUTH BED RAILS\"],\n",
    "[1537 , \"BASSINETS OR CRADLES\"],\n",
    "[1539 , \"SHOELACE FASTENERS (FOR INFANTS)\"],\n",
    "[1542 , \"BABY MATTRESSES OR PADS\"],\n",
    "[1543 , \"NONPORTABLE CRIBS\"],\n",
    "[1544 , \"BABY BATHS OR BATHINETTES\"],\n",
    "[1545 , \"CRIBS NOT SPECIFIED\"],\n",
    "[1548 , \"BABY CARRIERS NOT SPECIFIED\"],\n",
    "[1549 , \"OTHER BABY CARRIERS\"],\n",
    "[1550 , \"INFANT & TODDLER PLAY CTRS EXCL JUMPERSBOUNCERS&EXERCISERS\"],\n",
    "[1551 , \"DIAPER FASTENERS\"],\n",
    "[1553 , \"PORTABLE BABY SWINGS (FOR HOME USE)\"],\n",
    "[1554 , \"SAFETY PINS\"],\n",
    "[1555 , \"HIGH CHAIRS\"],\n",
    "[1556 , \"ATTACHED HIGHCHAIR\"],\n",
    "[1557 , \"BABY BATHTUB SEATS OR RINGS (NOT TOYS)\"],\n",
    "[1558 , \"BABY BOUNCER SEATS (EXCL. JUMPERS)\"],\n",
    "[1560 , \"BABY SLINGS AND WRAPS\"],\n",
    "[1561 , \"FRAMED BABY CARRIERS (CARRIED ON THE BACK)\"],\n",
    "[1562 , \"OTHER SOFT BABY CARRIERS\"],\n",
    "[1597 , \"NON,POISONING DEATH OF VICTIM UNDER AGE 5 NO PRODUCT\"],\n",
    "[1598 , \"OVERLAY DEATHS\"],\n",
    "[1599 , \"INFANT DEATH\"],\n",
    "[1602 , \"HAIR DRYERS\"],\n",
    "[1604 , \"CIGARETTE OR PIPE LIGHTERS\"],\n",
    "[1605 , \"WIGS FALLS OR HAIRPIECES\"],\n",
    "[1606 , \"EYEGLASSES\"],\n",
    "[1607 , \"EYE PROTECTION DEVICES\"],\n",
    "[1608 , \"POWERED TOOTHBRUSHES OR ORAL IRRIGATORS\"],\n",
    "[1609 , \"SUN LAMPS\"],\n",
    "[1610 , \"MASSAGE DEVICES OR VIBRATORS\"],\n",
    "[1612 , \"SAUNAS\"],\n",
    "[1613 , \"ELECTRIC SHOE POLISHERS\"],\n",
    "[1615 , \"FOOTWEAR\"],\n",
    "[1616 , \"JEWELRY\"],\n",
    "[1617 , \"EAR PROTECTION DEVICES\"],\n",
    "[1618 , \"RESPIRATORY PROTECTION DEVICES\"],\n",
    "[1619 , \"PERSONAL PROTECTION DEVICES\"],\n",
    "[1620 , \"HEARING AIDS\"],\n",
    "[1622 , \"WATCHES\"],\n",
    "[1623 , \"LUGGAGE\"],\n",
    "[1624 , \"CONTACT LENSES\"],\n",
    "[1625 , \"LIGHTED MAKE,UP MIRRORS\"],\n",
    "[1629 , \"NONELECTRIC TOOTHBRUSHES\"],\n",
    "[1630 , \"PAPER MONEY OR COINS\"],\n",
    "[1634 , \"HEAT OR INFRARED LAMPS\"],\n",
    "[1635 , \"DENTURES OR FALSE TEETH\"],\n",
    "[1636 , \"ORTHODONTIC BRACES\"],\n",
    "[1637 , \"ELECTRIC COMBS\"],\n",
    "[1638 , \"COMBS OR HAIRBRUSHES UNPOWERED\"],\n",
    "[1641 , \"CLOTHESBRUSHES\"],\n",
    "[1643 , \"KEYS KEY RINGS OR KEY CHAINS\"],\n",
    "[1644 , \"NIGHTWEAR\"],\n",
    "[1645 , \"DAY WEAR\"],\n",
    "[1646 , \"OUTERWEAR\"],\n",
    "[1647 , \"CLOTHING ACCESSORIES\"],\n",
    "[1650 , \"DESK SUPPLIES\"],\n",
    "[1651 , \"COMBS NOT SPECIFIED\"],\n",
    "[1654 , \"PAPER CUTTERS\"],\n",
    "[1658 , \"CLOTHING NOT SPECIFIED\"],\n",
    "[1659 , \"MANICURE PEDICURE AND MAKE,UP BRUSHES/TOOLS\"],\n",
    "[1660 , \"UMBRELLAS\"],\n",
    "[1661 , \"NONELECTRIC RAZORS OR SHAVERS\"],\n",
    "[1662 , \"HAIR GROOMING EQUIPMENT OR ACCESSORIES N.S.\"],\n",
    "[1664 , \"ELECTRIC RAZORS OR SHAVERS\"],\n",
    "[1666 , \"TEETH CLEANING DEVICES NOT SPECIFIED\"],\n",
    "[1667 , \"RAZORS OR SHAVERS NOT SPECIFIED\"],\n",
    "[1669 , \"PINS AND NEEDLES\"],\n",
    "[1671 , \"SEWING BASKET ARTICLES\"],\n",
    "[1674 , \"HARD CONTACT LENSES\"],\n",
    "[1675 , \"SOFT CONTACT LENSES\"],\n",
    "[1676 , \"CONTACT LENSES NOT SPECIFIED\"],\n",
    "[1677 , \"OTHER CLOTHING\"],\n",
    "[1678 , \"BATH OR FACIAL CLEANSING BRUSHES\"],\n",
    "[1679 , \"GROCERY OR SHOPPING CARTS\"],\n",
    "[1680 , \"DOLLIES HANDTRUCKS OR LUGGAGE CARRIERS\"],\n",
    "[1681 , \"SUNTAN BOOTHS\"],\n",
    "[1682 , \"HAIR CURLERS CURLING IRONS CLIPS & HAIRPINS\"],\n",
    "[1683 , \"HAIR CLIPPERS AND TRIMMERS\"],\n",
    "[1684 , \"CARTS OTHER OR NOT SPECIFIED\"],\n",
    "[1685 , \"PENS AND PENCILS\"],\n",
    "[1686 , \"COINS\"],\n",
    "[1687 , \"LIGHTERS NOT SPECIFIED\"],\n",
    "[1688 , \"FUEL MULTI,PURPOSE LIGHTERS INCL. MICRO,TORCHES\"],\n",
    "[1689 , \"ELECTRIC MULTI,PURPOSE LIGHTERS\"],\n",
    "[1690 , \"MULTI,PURPOSE LIGHTERS NOT SPECIFIED\"],\n",
    "[1701 , \"ARTIFICIAL CHRISTMAS TREES\"],\n",
    "[1705 , \"ASHTRAYS\"],\n",
    "[1706 , \"CRUTCHES CANES OR WALKERS\"],\n",
    "[1707 , \"WHEELCHAIRS\"],\n",
    "[1708 , \"SPECIAL BEDS OR ORTHOPEDIC BEDS\"],\n",
    "[1710 , \"FIRST AID EQUIPMENT\"],\n",
    "[1711 , \"CHRISTMAS TREE LIGHTS\"],\n",
    "[1712 , \"CHRISTMAS TREE STANDS OR SUPPORTS\"],\n",
    "[1714 , \"SEASONAL DECORATIONS\"],\n",
    "[1715 , \"PET SUPPLIES\"],\n",
    "[1716 , \"HYPODERMIC NEEDLES OR SYRINGES\"],\n",
    "[1717 , \"ORTHOPEDIC BRACES\"],\n",
    "[1718 , \"FLARES\"],\n",
    "[1719 , \"LUNCH BOXES OR PAILS\"],\n",
    "[1720 , \"PARTY FAVORS\"],\n",
    "[1724 , \"LASERS\"],\n",
    "[1725 , \"CATHODE,RAY TUBES\"],\n",
    "[1726 , \"LOCKERS\"],\n",
    "[1727 , \"TRAFFIC CONTROL DEVICES\"],\n",
    "[1728 , \"MATCHBOOKS\"],\n",
    "[1729 , \"CHRISTMAS DECORATIONS (NONELECTRIC)\"],\n",
    "[1730 , \"WOODEN MATCHES\"],\n",
    "[1731 , \"MATCHES NOT SPECIFIED\"],\n",
    "[1732 , \"TOMBSTONES OR GRAVE MARKERS\"],\n",
    "[1733 , \"VENDING MACHINES\"],\n",
    "[1734 , \"MUSIC BOXES OR CHIMES\"],\n",
    "[1735 , \"COIN,OPERATED CAR,WASHING EQUIPMENT\"],\n",
    "[1736 , \"ELECTRIC CHRISTMAS DECORATIONS (EXCL. TREE LIGHTS)\"],\n",
    "[1737 , \"HOUSEPLANTS\"],\n",
    "[1738 , \"PUBLIC USE ITEMS NOT ELSEWHERE CLASSIFIED\"],\n",
    "[1739 , \"ASHTRAYS ELECTRIC OR BATTERY OPERATED\"],\n",
    "[1740 , \"ASHTRAYS NOT ELEC. OR BATTERY OR NOT SPECIFIED\"],\n",
    "[1741 , \"TARPAULINS\"],\n",
    "[1742 , \"HEATING OR COOLING COMFORT PACKS (NONELECTRIC)\"],\n",
    "[1743 , \"THERMOMETERS MEDICAL\"],\n",
    "[1744 , \"MOTORIZED VEHICLES NEC (3 OR MORE WHEELS)\"],\n",
    "[1803 , \"THERMAL OR SOUND INSULATION MATERIALS\"],\n",
    "[1807 , \"FLOORS OR FLOORING MATERIALS\"],\n",
    "[1808 , \"OUTDOOR AWNINGS OR SHUTTERS\"],\n",
    "[1811 , \"BRICKS OR CONCRETE BLOCKS (NOT PART OF STRUCTURE)\"],\n",
    "[1812 , \"GUTTERS DRAINPIPES DOWNSPOUTS OR RUN,OFF PIPES\"],\n",
    "[1814 , \"ELEVATORS OR OTHER LIFTS\"],\n",
    "[1816 , \"SCAFFOLDING\"],\n",
    "[1817 , \"PORCHES BALCONIES OPEN,SIDE FLOORS OR FLOOR OPENINGS\"],\n",
    "[1818 , \"CISTERNS CESSPOOLS OR SEPTIC TANKS\"],\n",
    "[1819 , \"NAILS SCREWS CARPET TACKS OR THUMBTACKS\"],\n",
    "[1820 , \"CABINET OR DOOR HARDWARE\"],\n",
    "[1821 , \"CLOTHESLINES OR CLOTHES DRYING RACKS\"],\n",
    "[1823 , \"STORM DOORS WITH GLASS PANELS\"],\n",
    "[1825 , \"SLIDING GLASS DOORS OR PANELS\"],\n",
    "[1826 , \"STORM WINDOWS\"],\n",
    "[1827 , \"SCREEN DOORS\"],\n",
    "[1828 , \"WINDOW SCREENS\"],\n",
    "[1829 , \"HANDRAILS RAILINGS OR BANISTERS\"],\n",
    "[1830 , \"SEPARATE GARAGES OR TOOL SHEDS\"],\n",
    "[1836 , \"JALOUSIE GLASS WINDOWS\"],\n",
    "[1838 , \"LUMBER BOARDS OR PANEL PIECES (NOT PART OF STRUCTURE)\"],\n",
    "[1840 , \"PULL,DOWN OR FOLDING STAIRS\"],\n",
    "[1841 , \"MOBILE HOMES\"],\n",
    "[1842 , \"STAIRS OR STEPS\"],\n",
    "[1843 , \"RAMPS OR LANDINGS\"],\n",
    "[1845 , \"PANEL DOORS (FLUSH OR SLAB)\"],\n",
    "[1849 , \"DOORS NOT SPECIFIED\"],\n",
    "[1854 , \"PLASTIC PANELS FOR DOORS OR WINDOWS\"],\n",
    "[1855 , \"PLASTIC PRODUCTS NOT ELSEWHERE CLASSIFIED\"],\n",
    "[1857 , \"ARTIFICIAL TURF\"],\n",
    "[1858 , \"STORM DOORS WITHOUT GLASS PANELS\"],\n",
    "[1863 , \"WALLPAPER\"],\n",
    "[1864 , \"COUNTERS OR COUNTERTOPS\"],\n",
    "[1865 , \"POLES\"],\n",
    "[1866 , \"GENERAL HOME OR ROOM INVOLVEMENT IN FIRES\"],\n",
    "[1867 , \"FIXED FLOOR,LENGTH GLASS PANELS\"],\n",
    "[1870 , \"WINDOW SILLS OR FRAMES\"],\n",
    "[1871 , \"FENCES OR FENCE POSTS\"],\n",
    "[1873 , \"WINDOWS OR WINDOW GLASS NOT SPECIFIED\"],\n",
    "[1875 , \"OTHER WINDOWS OR WINDOW GLASS\"],\n",
    "[1876 , \"HOUSE REPAIR OR CONSTRUCTION MATERIALSNEC\"],\n",
    "[1878 , \"DOOR SILLS OR FRAMES\"],\n",
    "[1879 , \"OTHER NONGLASS DOORS (NONGARAGE)\"],\n",
    "[1880 , \"NONGLASS DOORS (NONGARAGE) NOT SPECIFIED\"],\n",
    "[1882 , \"OTHER GLASS DOORS\"],\n",
    "[1883 , \"GLASS DOORS NOT SPECIFIED\"],\n",
    "[1884 , \"CEILINGS AND WALLS (INTERIOR PART OF COMPLETED STRUCTURE)\"],\n",
    "[1885 , \"WOOD PANELING AND PARTICLEBOARD\"],\n",
    "[1886 , \"GARAGE DOORS (EXCL. AUTOMATIC GARAGE DOORS OR OPENERS)\"],\n",
    "[1887 , \"TOOL SHEDS\"],\n",
    "[1888 , \"WINDOW OR DOOR SECURITY BARRIERS\"],\n",
    "[1889 , \"ELEVATORS OR OTHER LIFTS (EXCL. ESCALATORS HOISTS JACKS)\"],\n",
    "[1890 , \"ESCALATORS\"],\n",
    "[1891 , \"MOVING WALKS\"],\n",
    "[1892 , \"GLASS DOORS OR DOORS WITH GLASS PANELS\"],\n",
    "[1893 , \"DOORS OTHER OR NOT SPECIFIED\"],\n",
    "[1894 , \"WINDOWS AND WINDOW GLASS OTHER THAN STORM WINDOWS\"],\n",
    "[1895 , \"TREE STANDS (HUNTING)\"],\n",
    "[1898 , \"GAS FUMES OR GAS VAPORS OF UNKNOWN ORIGIN\"],\n",
    "[1899 , \"CARBON MONOXIDE POISONING (WHEN SOURCE IS UNKNOWN)\"],\n",
    "[1901 , \"MOTOR VEHICLES OR PARTS (LICENSED FOUR OR MORE WHEELS)\"],\n",
    "[1902 , \"TRAINS\"],\n",
    "[1903 , \"ALCOHOL (BEVERAGE)\"],\n",
    "[1906 , \"AIRCRAFT\"],\n",
    "[1909 , \"CIGARETTES CIGARS PIPES OR TOBACCO\"],\n",
    "[1910 , \"LICENSED TWO,WHEELED MOTOR VEHICLES\"],\n",
    "[1913 , \"COSMETICS INCL FACIAL & EYE MAKE,UP DEODORANTS ETC.\"],\n",
    "[1914 , \"VETERINARY MEDICINES\"],\n",
    "[1915 , \"LINIMENTS OR RUBBING COMPOUNDS\"],\n",
    "[1916 , \"PREPARATIONS CONTAINING IRON SALTS\"],\n",
    "[1923 , \"ASPIRIN OR ASPIRIN COMPOUNDS\"],\n",
    "[1926 , \"PESTICIDES\"],\n",
    "[1927 , \"LIQUID DRUGS\"],\n",
    "[1928 , \"ANTIHISTAMINES\"],\n",
    "[1929 , \"DRUGS OR MEDICATIONS NOT SPECIFIED\"],\n",
    "[1930 , \"ASPIRIN SUBSTITUTES\"],\n",
    "[1931 , \"TABLET OR CAPSULE DRUGS\"],\n",
    "[1932 , \"OTHER DRUGS OR MEDICATIONS\"],\n",
    "[1933 , \"FOODS (EXCLUDING HOT WATER)\"],\n",
    "[1934 , \"HOT WATER\"],\n",
    "[1935 , \"GUNPOWDER OR AMMUNITION\"],\n",
    "[1936 , \"BBS OR PELLETS\"],\n",
    "[1937 , \"AIR BAGS DEPLOYED (FOR NHTSA STUDY)\"],\n",
    "[1939 , \"ILLEGAL DRUGS (INCL COCAINE CRACK HEROIN MARIJ PCP)\"],\n",
    "[1940 , \"MOUTHWASHES OR MOUTH RINSES (EXCLUDING PEROXIDE)\"],\n",
    "[2001 , \"ANIMAL INDUCED INJURY\"],\n",
    "[2002 , \"PLANTS TREES AND SHRUBS\"],\n",
    "[2003 , \"INSECT INDUCED INJURIES\"],\n",
    "[2200 , \"INDUSTRIAL EQUIPMENT\"],\n",
    "[2288 , \"NO PRODUCT INVOLVED (OCCUPATIONAL INJURIES ONLY)\"],\n",
    "[2300 , \"SCHOOL EQUIPMENT\"],\n",
    "[2400 , \"MEDICAL EQUIPMENT\"],\n",
    "[2401 , \"RADIOGRAPHIC EQUIPMENT\"],\n",
    "[2402 , \"FLUOROSCOPIC EQUIPMENT\"],\n",
    "[2403 , \"THERAPEUTIC EQUIPMENT\"],\n",
    "[2404 , \"GERMICIDAL LAMPS\"],\n",
    "[2405 , \"DIATHERMY EQUIPMENT (SHORT WAVE MICROWAVE ULTRASONIC)\"],\n",
    "[2406 , \"BRACING OR SUPPORTING DEVICES\"],\n",
    "[2407 , \"BATHS (MEDICAL EQUIPMENT)\"],\n",
    "[2408 , \"CATHETERS\"],\n",
    "[2409 , \"CONTRACEPTIVE DEVICES INCLUDING IUDS\"],\n",
    "[2415 , \"DENTAL PADS OR RELINERS\"],\n",
    "[2420 , \"EAR PIERCING DEVICES\"],\n",
    "[2423 , \"HEART VALVES ARTIFICIAL\"],\n",
    "[2425 , \"TRACTION EQUIPMENT (HOME USE)\"],\n",
    "[2429 , \"INVITRO DIAGNOSTIC KITS\"],\n",
    "[2430 , \"KIDNEY DIALYSIS MACHINES\"],\n",
    "[2431 , \"INTRAOCULAR DEVICES\"],\n",
    "[2435 , \"OXYGEN ADMINISTRATION APPARATUS\"],\n",
    "[2437 , \"PACEMAKERS CARDIAC\"],\n",
    "[2439 , \"STIMULATORS ELECTRICAL\"],\n",
    "[2440 , \"SUPPORT GARMENTS AND STOCKINGS MEDICAL\"],\n",
    "[2443 , \"STERILIZERS MEDICAL\"],\n",
    "[2447 , \"RADIATION THERAPY EQUIPMENT\"],\n",
    "[2448 , \"OSTOMY APPLIANCES\"],\n",
    "[2450 , \"ANESTHESIOLOGICAL DEVICES NOT ELSEWHERE CLASSIFIED\"],\n",
    "[2452 , \"CARDIOVASCULAR DEVICES NOT ELSEWHERE CLASSIFIED\"],\n",
    "[2454 , \"DENTAL DEVICES NOT ELSEWHERE CLASSIFIED\"],\n",
    "[2456 , \"EAR NOSE AND THROAT DEVICES NOT ELSEWHERE CLASSIFIED\"],\n",
    "[2458 , \"GASTROENTEROLOGICAL OR UROLOGICAL DEVICES\"],\n",
    "[2460 , \"GENERAL OR PLASTIC SURGERY DEVICES\"],\n",
    "[2462 , \"OTHER HOSPITAL OR PERSONAL USE MEDICAL DEVICES\"],\n",
    "[2464 , \"NEUROLOGICAL DEVICES NOT ELSEWHERE CLASSIFIED\"],\n",
    "[2466 , \"OBSTETRICAL OR GYNECOLOGICAL DEVICES\"],\n",
    "[2468 , \"OPHTHALMIC DEVICES NOT ELSEWHERE CLASSIFIED\"],\n",
    "[2470 , \"PHYSIATRIC DEVICES NOT ELSEWHERE CLASSIFIED\"],\n",
    "[2472 , \"RADIOLOGICAL DEVICES NOT ELSEWHERE CLASSIFIED\"],\n",
    "[2474 , \"ARTIFICIAL LIMBS\"],\n",
    "[2475 , \"ATOMIZING DEVICES\"],\n",
    "[2476 , \"MONITORING SYSTEMS MEDICAL\"],\n",
    "[2477 , \"MEDICAL GLOVES\"],\n",
    "[2479 , \"PROSTHETIC DEVICES OTHER\"],\n",
    "[2480 , \"RESPIRATORY DEVICES NOT ELSEWHERE CLASSIFIED\"],\n",
    "[2500 , \"ANTIPERSPIRANTS AND DEODORANTS (UNDERARM)\"],\n",
    "[2510 , \"BATH PRODUCTS\"],\n",
    "[2511 , \"BUBBLE BATHS\"],\n",
    "[2520 , \"DEPILATORIES OR HAIR REMOVERS\"],\n",
    "[2531 , \"EYE MASCARAS\"],\n",
    "[2532 , \"EYELINERS\"],\n",
    "[2533 , \"OTHER EYE MAKE,UP PREPARATIONS\"],\n",
    "[2534 , \"EYE MAKE,UP PREPARATIONS NOT SPECIFIED\"],\n",
    "[2540 , \"FACE CARE PREPARATIONS\"],\n",
    "[2541 , \"FACE HORMONE CREAMS\"],\n",
    "[2550 , \"FRAGRANCE PREPARATIONS\"],\n",
    "[2560 , \"HAND AND BODY CREAMS OR LOTIONS\"],\n",
    "[2571 , \"HAIR COLORING SHAMPOOS\"],\n",
    "[2572 , \"HAIR DYES (PERMANENT DARK TONES)\"],\n",
    "[2573 , \"HAIR LIGHTENERS WITH COLOR (PERMANENT BLOND TONES)\"],\n",
    "[2574 , \"HAIR COLORING PREPARATIONS NOT SPECIFIED\"],\n",
    "[2575 , \"OTHER HAIR COLORING PREPARATIONS\"],\n",
    "[2580 , \"HAIR GROOMING PREPARATIONS\"],\n",
    "[2590 , \"NONCOLORING HAIR SHAMPOOS\"],\n",
    "[2600 , \"HAIR SPRAYS\"],\n",
    "[2610 , \"HAIR WAVING PREPARATIONS OR STRAIGHTENERS\"],\n",
    "[2621 , \"MAKE,UP PREPARATIONS\"],\n",
    "[2630 , \"NAIL PREPARATIONS\"],\n",
    "[2631 , \"NAIL HARDENERS\"],\n",
    "[2640 , \"ORAL HYGIENE PRODUCTS\"],\n",
    "[2650 , \"GENITAL AREA PRODUCTS\"],\n",
    "[2660 , \"POWDER PREPARATIONS\"],\n",
    "[2670 , \"SHAVING PREPARATIONS\"],\n",
    "[2680 , \"SOAPS\"],\n",
    "[2690 , \"SUNTAN OR SUNSCREEN PREPARATIONS\"],\n",
    "[3200 , \"WATER TUBING (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[3202 , \"PEDAL,POWERED ADULT VEHICLES (THREE OR MORE WHEELS)\"],\n",
    "[3203 , \"SKEET SHOOTING (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[3211 , \"GROUND WATER SLIDES\"],\n",
    "[3214 , \"CAMPING EQUIPMENT\"],\n",
    "[3215 , \"MOPEDS OR POWER,ASSISTED CYCLES\"],\n",
    "[3216 , \"ROLLER SKATING (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[3217 , \"SKATING (ACTIVITY APPAREL OR EQUIPMENT) NOT SPECIFIED\"],\n",
    "[3218 , \"CHARCOAL OR WOOD,BURNING GRILLS\"],\n",
    "[3219 , \"OTHER PLAYGROUND EQUIPMENT\"],\n",
    "[3220 , \"VOLLEYBALL (ACTIVITY APPAREL OR EQUIPMENT) N.S.\"],\n",
    "[3221 , \"ABOVE,GROUND SWIMMING POOLS (EXCL PORTABLE POOLS)\"],\n",
    "[3222 , \"BADMINTON (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[3223 , \"FISHING (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[3224 , \"OTHER GUNS OR FIREARMS\"],\n",
    "[3225 , \"ORGANIZED SOCCER (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[3226 , \"BASKETBALL (ACTIVITY APPAREL OR EQUIPMENT) N.S.\"],\n",
    "[3227 , \"INFORMAL FOOTBALL (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[3228 , \"ORGANIZED BASEBALL (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[3229 , \"ELECTRIC GRILLS\"],\n",
    "[3230 , \"KEROSENE GRILLS OR STOVES\"],\n",
    "[3231 , \"GYMNASTICS (ACTIVITY APPAREL OR EQUIPMENT) N.S.\"],\n",
    "[3233 , \"OTHER GRILLS OR STOVES\"],\n",
    "[3234 , \"RUGBY (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[3235 , \"OTHER BALL SPORTS (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[3236 , \"BALL SPORTS (ACTIVITY APPAREL OR EQUIPMENT) N.S.\"],\n",
    "[3237 , \"ORGANIZED GYMNASTICS (ACTIVITY APPAREL OR EQUIP.)\"],\n",
    "[3240 , \"INFORMAL BASEBALL (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[3241 , \"INFORMAL SOCCER (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[3242 , \"ORGANIZED BASKETBALL (ACTIVITY APPAREL OR EQUIP.)\"],\n",
    "[3243 , \"ORGANIZED VOLLEYBALL (ACTIVITY APPAREL OR EQUIP.)\"],\n",
    "[3244 , \"FOOTBALL (ACTIVITY APPAREL OR EQUIPMENT) N.S.\"],\n",
    "[3245 , \"STREET HOCKEY (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[3246 , \"SWINGS OR SWING SETS\"],\n",
    "[3247 , \"ICE OR SNOW BOATING (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[3248 , \"GAS OR LP GRILLS OR STOVES (FOR OUTDOOR USE)\"],\n",
    "[3249 , \"GRILLS NOT SPECIFIED\"],\n",
    "[3250 , \"PORTABLE FOOD OR BEVERAGE COOLERS\"],\n",
    "[3251 , \"BUILT,IN SWIMMING POOLS\"],\n",
    "[3252 , \"SLEEPING BAGS\"],\n",
    "[3253 , \"GUNS NOT SPECIFIED\"],\n",
    "[3254 , \"CHEERLEADING (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[3255 , \"ICE SKATING (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[3256 , \"SQUASH RACQUET BALL OR PADDLE BALL\"],\n",
    "[3257 , \"MARTIAL ARTS (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[3258 , \"MINIBIKES OR TRAIL BIKES\"],\n",
    "[3259 , \"GO,CARTS\"],\n",
    "[3260 , \"FENCING (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[3261 , \"SHUFFLEBOARD (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[3262 , \"SWIMMING POOL EQUIPMENT\"],\n",
    "[3263 , \"INFORMAL GYMNASTICS (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[3265 , \"WEIGHT LIFTING (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[3267 , \"INFORMAL BASKETBALL (ACTIVITY APPAREL OR EQUIP.)\"],\n",
    "[3268 , \"INFORMAL VOLLEYBALL (ACTIVITY APPAREL OR EQUIP.)\"],\n",
    "[3269 , \"ORGANIZED FOOTBALL (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[3270 , \"BASEBALL (ACTIVITY APPAREL OR EQUIP.) NOT SPECIFIED\"],\n",
    "[3271 , \"SOCCER (ACTIVITY APPAREL OR EQUIPMENT) NOT SPECIFIED\"],\n",
    "[3272 , \"HOCKEY (ACTIVITY APPAREL OR EQUIPMENT) NOT SPECIFIED\"],\n",
    "[3273 , \"PLAYGROUND EQUIPMENT NOT SPECIFIED\"],\n",
    "[3274 , \"SWIMMING (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[3276 , \"WATER POLO (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[3277 , \"EXERCISE EQUIPMENT\"],\n",
    "[3278 , \"DANCING (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[3279 , \"FLOTATION TOYS (EXCL OFFICIAL LIFE,SAVING DEVICES)\"],\n",
    "[3282 , \"CURLING (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[3283 , \"SNOW SKIING (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[3284 , \"TENNIS (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[3285 , \"ALL TERRAIN VEHICLES (THREE WHEELS/OFF,ROAD ONLY)\"],\n",
    "[3286 , \"ALL TERRAIN VEHICLES (FOUR WHEELS/OFF ROAD ONLY)\"],\n",
    "[3287 , \"ALL TERRAIN VEHICLES (OF WHEELS UNSPECIFIED/OFF ROAD)\"],\n",
    "[3288 , \"DUNE BUGGIES/BEACH BUGGIES\"],\n",
    "[3289 , \"DARTS FOR INDOOR USE (ACTIVITY OR EQUIPMENT)\"],\n",
    "[3290 , \"DARTS LAWN (ACTIVITY OR EQUIPMENT)\"],\n",
    "[3291 , \"DARTS NOT OTHERWISE SPECIFIED (N.O.S.)\"],\n",
    "[3292 , \"PERSONAL WATERCRAFT POWERED\"],\n",
    "[3293 , \"WATER SLIDES NOT ELSEWHERE CLASSIFIED\"],\n",
    "[3294 , \"WATER SLIDES BACKYARD/HOME (NOT SWIMMING POOL SLIDES)\"],\n",
    "[3295 , \"WATER SLIDES PUBLIC (STATIONARY AMUSEMENT RIDES)\"],\n",
    "[3296 , \"ALL TERR. VEH. (MORE THAN 4 WHEELS EXCLUSIVELY OFF,RD)\"],\n",
    "[3297 , \"IN,LINE SKATING (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[3298 , \"BOATS AND BOATING (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[3299 , \"EXERCISE (ACTIVITY OR APPAREL W/O EQUIP)\"],\n",
    "[4002 , \"BEDDING NOT SPECIFIED\"],\n",
    "[4003 , \"STOOLS NOT SPECIFIED\"],\n",
    "[4004 , \"MIRRORS OR MIRROR GLASS\"],\n",
    "[4005 , \"FILTERS\"],\n",
    "[4008 , \"NONELECTRIC BLANKETS\"],\n",
    "[4009 , \"NONBABY MATTRESSES\"],\n",
    "[4010 , \"MATTRESSES NOT SPECIFIED\"],\n",
    "[4011 , \"INFLATABLE FURNITURE\"],\n",
    "[4013 , \"OTHER FURNITURE\"],\n",
    "[4014 , \"FURNITURE NOT SPECIFIED\"],\n",
    "[4015 , \"UPHOLSTERED FOOTSTOOLS OTTOMANS OR HASSOCKS\"],\n",
    "[4016 , \"BEACH CHAIRS OR FOLDING CHAIRS\"],\n",
    "[4017 , \"NONUPHOLSTERED RECLINER CHAIRS\"],\n",
    "[4018 , \"NONUPHOLSTERED ROCKING CHAIRS\"],\n",
    "[4019 , \"UPHOLSTERED RECLINER CHAIRS\"],\n",
    "[4020 , \"UPHOLSTERED ROCKING CHAIRS\"],\n",
    "[4021 , \"OTHER CHAIRS\"],\n",
    "[4022 , \"CHAIRS NOT SPECIFIED\"],\n",
    "[4023 , \"RECLINER CHAIRS NOT SPECIFIED\"],\n",
    "[4024 , \"ROCKING CHAIRS NOT SPECIFIED\"],\n",
    "[4025 , \"BARSTOOLS OR KITCHEN STOOLS\"],\n",
    "[4026 , \"OTHER STOOLS\"],\n",
    "[4030 , \"BATHTUB OR SHOWER ENCLOSURES NOT SPECIFIED\"],\n",
    "[4032 , \"OTHER LADDERS\"],\n",
    "[4033 , \"LADDERS NOT SPECIFIED\"],\n",
    "[4036 , \"ELECTRIC TABLE LAMPS FLOOR LAMPS OR DESK LAMPS\"],\n",
    "[4039 , \"OTHER ELECTRIC LIGHTING EQUIPMENT\"],\n",
    "[4041 , \"ELECTRIC LIGHTING EQUIPMENT NOT SPECIFIED\"],\n",
    "[4042 , \"LIGHTING EQUIPMENT NOT SPECIFIED\"],\n",
    "[4043 , \"CLOCKS\"],\n",
    "[4045 , \"FABRICS (NOT PART OF FINISHED ITEM)\"],\n",
    "[4047 , \"BOOKS MAGAZINES ALBUMS OR SCRAPBOOKS\"],\n",
    "[4050 , \"PILLOWS\"],\n",
    "[4051 , \"SHEETS OR PILLOWCASES\"],\n",
    "[4052 , \"OTHER UPHOLSTERED CHAIRS\"],\n",
    "[4053 , \"UPHOLSTERED CHAIRS NOT SPECIFIED\"],\n",
    "[4054 , \"OTHER BEDDING\"],\n",
    "[4055 , \"DRAPERY OR CURTAIN RODS HOOKS OR RINGS\"],\n",
    "[4056 , \"CABINETS RACKS ROOM DIVIDERS AND SHELVES NEC\"],\n",
    "[4057 , \"TABLES (EXCL.  BABY CHANGING TABLES BILLIARD OR POOL TABLES\"],\n",
    "[4058 , \"BARS AND BAR ACCESSORIES NOT ELSEWHERE CLASSIFIED\"],\n",
    "[4059 , \"SCALES  (EXCL. BABY SCALES)\"],\n",
    "[4060 , \"FUEL,BURNING LIGHTING EQUIPMENT\"],\n",
    "[4061 , \"ELECTRIC OUTLETS OR RECEPTACLES\"],\n",
    "[4062 , \"ELECTRIC WIRE OR WIRING SYSTEMS (EXCL PANELBOARDS RECEPT\"],\n",
    "[4063 , \"PANELBOARDS CIRCUIT BREAKERS GFCIS OR FUSES\"],\n",
    "[4064 , \"FUTONS\"],\n",
    "[4065 , \"CLOCKS ELECTRIC OR BATTERY OPERATED\"],\n",
    "[4066 , \"SCALES ELECTRIC/BATTERY OPERATED (EXCLUD. BABY SCALES)\"],\n",
    "[4067 , \"CLOCKS NOT ELEC. OR BATTERY OR NOT SPECIFIED\"],\n",
    "[4068 , \"SCALES NOT ELEC. OR BATTERY OR NOT SPECIFIED\"],\n",
    "[4069 , \"COTS\"],\n",
    "[4070 , \"FLOOR LAMPS OR TABLE LAMPS HALOGEN\"],\n",
    "[4071 , \"FLOOR LAMPS OR TABLE LAMPS ELECTRIC (EXCL HALOGEN)\"],\n",
    "[4072 , \"BEDSPRINGS OR BEDFRAMES EXCL BUNK BEDS & ADULT BED RAILS\"],\n",
    "[4073 , \"ADULT BED RAILS\"],\n",
    "[4074 , \"CHAIRS OTHER OR NOT SPECIFIED\"],\n",
    "[4075 , \"BED RAILS\"],\n",
    "[4076 , \"BEDS OR BEDFRAMES OTHER OR NOT SPECIFIED\"],\n",
    "[4077 , \"EXTENSION OR STRAIGHT LADDERS\"],\n",
    "[4078 , \"LADDERS OTHER OR NOT SPECIFIED\"],\n",
    "[4079 , \"FOOTSTOOLS OTTOMANS OR HASSOCKS\"],\n",
    "[4080 , \"STOOLS OTHER OR NOT SPECIFIED\"],\n",
    "[4081 , \"CORDS ELECTRICAL OTHER OR NOT SPECIFIED\"],\n",
    "[4082 , \"TODDLER BEDS\"],\n",
    "[4083 , \"SURGE SUPPRESSORS OR POWER STRIPS\"],\n",
    "[4084 , \"RESIDENTIAL ALTERNATIVE ENERGY SYSTEMS FOR ON,SITE POWER GEN\"],\n",
    "[4802 , \"STRAPS NON,STRETCH OTHER OR NOT SPECIFIED\"],\n",
    "[5001 , \"OTHER TOY WEAPONS (PROJECTILE)\"],\n",
    "[5004 , \"TOYS NOT ELSEWHERE CLASSIFIED\"],\n",
    "[5005 , \"RIDING TOYS NOT SPECIFIED\"],\n",
    "[5006 , \"OTHER TOY GUNS\"],\n",
    "[5007 , \"TOY WEAPONS NOT SPECIFIED\"],\n",
    "[5010 , \"CRAYONS OR CHALK\"],\n",
    "[5011 , \"BOOK BAGS OR BACK CARRIERS (EXC. BABY CARR. LUGGAGE CAM\"],\n",
    "[5013 , \"TOY MAKE,UP KITS OR COSMETICS\"],\n",
    "[5015 , \"TOY CAPS CAP TOYS OR CAP GUNS\"],\n",
    "[5016 , \"BALLS OTHER OR NOT SPECIFIED\"],\n",
    "[5017 , \"FLYING DISCS AND BOOMERANGS\"],\n",
    "[5018 , \"DOLL HOUSES AND OTHER PLAY SCENES\"],\n",
    "[5019 , \"GAMES OR GAME PARTS (EXCL MARBLES & COMPUTER GAMES)\"],\n",
    "[5020 , \"PRETEND ELECTRONICS TOOLS HOUSEWARES & APPLIANCES\"],\n",
    "[5021 , \"TOY VEHICLES (EXCLUDING RIDING TOYS)\"],\n",
    "[5029 , \"CAMPING EQUIPMENT (EXCL. TRAILERS LIGHTING EQUIPMENT\"],\n",
    "[5030 , \"TRACK & FIELD (ACT. APPAREL EQP.; EX.  JOG RUN FIT)\"],\n",
    "[5031 , \"SNOWBOARDING (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[5032 , \"ROLLER HOCKEY (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[5033 , \"MOUNTAIN OR ALL,TERRAIN BICYCLES AND ACCESSORIES\"],\n",
    "[5034 , \"SOFTBALL (ACTIVITY APPAREL OR EQUIPMENT)\"],\n",
    "[5035 , \"MINIBIKES POWERED\"],\n",
    "[5036 , \"TWO,WHEELED POWERED OFF,ROAD VEHICLES\"],\n",
    "[5037 , \"HAMMOCKS\"],\n",
    "[5038 , \"PERSONAL FITNESS/ACTIVITY TRACKERS\"],\n",
    "[5040 , \"BICYCLES AND ACCESSORIES (EXCL.MOUNTAIN OR ALL,TERRAIN)\"],\n",
    "[5041 , \"BASEBALL (ACTIVITY APPAREL OR EQUIPMENT; EXCL SOFTBALL)\"],\n",
    "[5042 , \"SCOOTERS / SKATEBOARDS POWERED\"],\n",
    "[5043 , \"PORTABLE SWIMMING POOLS\"],\n",
    "[5044 , \"UTILITY VEHICLES\"],\n",
    "[5555 , \"< 5 POISONINGS NO OTHER CODE\"],\n",
    "[6666 , \"INHALED/ABUSED SUBSTANCE\"],\n",
    "[7001 , \"YARD / HOME IMPROVEMENT EQUIP CONSUMER USE NO OTHER CODE\"],\n",
    "[7777 , \"OTHER PRODUCT\"],\n",
    "[7878 , \"NO PRODUCT INVOLVED / PRODUCT NOT LISTED\"],\n",
    "[8888 , \"NO PRODUCT\"],\n",
    "[9000 , \"ASSIGNED CASE WITH OUT OF SCOPE PRODUCT\"],\n",
    "[9001 , \"MENTAL HEALTH SERVICES STUDY\"],\n",
    "[9002 , \"SEXUAL VIOLENCE\"],\n",
    "[9003 , \"NONSEXUAL INTIMATE PARTNER VIOLENCE\"],\n",
    "[9100 , \"OUT OF SCOPE PRODUCT RETAILER REPORT\"],\n",
    "[9200 , \"DRYWALL CONTROL NO COMPLAINT\"],\n",
    "[9999 , \"UNCATEGORIZED PRODUCT\"]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create new array for descriptive product involved, use for-loop to assign new product-1\n",
    "prodNew1=[]\n",
    "\n",
    "for code in TraumaData['Product_1']:\n",
    "    for (productCode, productDesc) in productDic:\n",
    "        if code=='':\n",
    "            productDesc ='missed'\n",
    "            prodNew1.append(productDesc)\n",
    "        elif code == productCode:\n",
    "            prodNew1.append(productDesc)\n",
    "            break"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create new array for descriptive product involved, use for-loop to assign new product-2\n",
    "prodNew2=[]\n",
    "\n",
    "for code in TraumaData['Product_2']:\n",
    "    for (productCode, productDesc) in productDic:\n",
    "        if code=='':\n",
    "            productDesc ='missed'\n",
    "            prodNew2.append(productDesc)\n",
    "        elif code == productCode:\n",
    "            prodNew2.append(productDesc)\n",
    "            break      "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create new array for descriptive product involved, use for-loop to assign new product-3\n",
    "prodNew3=[]\n",
    "\n",
    "for code in TraumaData['Product_3']:\n",
    "    for (productCode, productDesc) in productDic:\n",
    "        if code=='':\n",
    "            productDesc ='missed'\n",
    "            prodNew3.append(productDesc)\n",
    "        elif code == productCode:\n",
    "            prodNew3.append(productDesc)\n",
    "            break"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create new array for age\n",
    "ageNew=[]\n",
    "\n",
    "for age in TraumaData['Age']:\n",
    "    if age=='':\n",
    "        newAge ='missed'\n",
    "        ageNew.append(newAge)\n",
    "    elif age < 201:\n",
    "        newAge = age\n",
    "        ageNew.append(newAge)\n",
    "    else:\n",
    "        newAge = (age-200)/12\n",
    "        ageNew.append(newAge)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [],
   "source": [
    "TraumaData['Age']=ageNew\n",
    "TraumaData['Location']=LocNew\n",
    "TraumaData['Diagnosis1']=DiagNew1\n",
    "#TraumaData['Diagnosis2']=DiagNew2\n",
    "TraumaData['Disposition']=DispNew\n",
    "TraumaData['Alcohol']=EtOHNew\n",
    "TraumaData['Drugs']=DrugNew\n",
    "TraumaData['Sex']=genderNew\n",
    "TraumaData['Race']=raceNew\n",
    "TraumaData['Product1']=prodNew1\n",
    "TraumaData['Product2']=prodNew2\n",
    "TraumaData['Product3']=prodNew3\n",
    "TraumaData['BodyPart']=BPNew"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [],
   "source": [
    "df=TraumaData[['Treatment_Date','Age','Sex','Race','BodyPart','Diagnosis1','Disposition','Location',\n",
    "               'Product1','Product2','Product3','Alcohol', 'Drugs', ]]\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {},
   "outputs": [],
   "source": [
    "writer = pd.ExcelWriter('newtraumadata.xlsx')\n",
    "# write dataframe to excel sheet named 'page1'\n",
    "df.to_excel(writer, 'page1')\n",
    "# save the excel file\n",
    "writer.save()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}