Getting strated with Pandas.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "To add comments:\n",
    "\n",
    "Write all your comments here in the cell and change cell type to Markdown!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "s = pd.Series([1,2.0,3,4.55, 5,np.nan,6,'7Letters' ,8])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "Python is a Language that takes indentation serously!\n",
    "    Indent correctly\n",
    "        To get the code right,\n",
    "    Okay?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "import zipfile\n",
    "import urllib.request\n",
    "import os\n",
    "\n",
    "source_url = 'ftp://ftp.nhtsa.dot.gov/GES/GES12/GES12_Flatfile.zip'\n",
    "zip_name = 'GES12_Flatfile.zip'\n",
    "cwd = os.getcwd()\n",
    "dir_path  = os.path.join(cwd, 'GES2012')\n",
    "zip_path = os.path.join(dir_path, zip_name)\n",
    "\n",
    "# We'll make a directory for you to play around with,\n",
    "# then when you're done playing you can just delete the directory\n",
    "if not os.path.exists(dir_path):\n",
    "    os.makedirs(dir_path)\n",
    "\n",
    "# Download the file from GES website if you haven't already\n",
    "if not os.path.exists(zip_path):\n",
    "    response = urllib.request.urlopen(source_url)\n",
    "    with open(zip_path, 'wb') as fh:\n",
    "        x = response.read()\n",
    "        fh.write(x)\n",
    "\n",
    "# Extract all the files from that zipfile\n",
    "with zipfile.ZipFile(os.path.join(dir_path, zip_name), 'r') as z:\n",
    "    z.extractall(dir_path)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['2012GESFlatFileTXT.sas',\n",
       " 'ACCIDENT.TXT',\n",
       " 'CEVENT.TXT',\n",
       " 'DAMAGE.TXT',\n",
       " 'DISTRACT.TXT',\n",
       " 'DRIMPAIR.TXT',\n",
       " 'FACTOR.TXT',\n",
       " 'GES12_Flatfile.zip',\n",
       " 'MANEUVER.TXT',\n",
       " 'NMCRASH.TXT',\n",
       " 'NMIMPAIR.TXT',\n",
       " 'NMPRIOR.TXT',\n",
       " 'PARKWORK.TXT',\n",
       " 'PERSON.TXT',\n",
       " 'SAFETYEQ.TXT',\n",
       " 'VEHICLE.TXT',\n",
       " 'VEVENT.TXT',\n",
       " 'VIOLATN.TXT',\n",
       " 'VISION.TXT',\n",
       " 'VSOE.TXT']"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#See what we just unzipped\n",
    "os.listdir(dir_path)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Let's see how Pandas rolls...!!! Eeeehhaaaaw!\n",
    "\n",
    "#1 Loding the Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "'''\n",
    "This is how you comment in Python\n",
    "\n",
    "'''\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import sklearn\n",
    "\n",
    "cwd = os.getcwd()\n",
    "dir_path  = os.path.join(cwd, 'GES2012')\n",
    "input_file_path = os.path.join(dir_path, 'PERSON.TXT')\n",
    "\n",
    "input_data = pd.read_csv(input_file_path, delimiter='\\t')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['AGE',\n",
       " 'AGE_IM',\n",
       " 'AIR_BAG',\n",
       " 'ALC_RES',\n",
       " 'ALC_STATUS',\n",
       " 'ATST_TYP',\n",
       " 'BODY_TYP',\n",
       " 'CASENUM',\n",
       " 'DRINKING',\n",
       " 'DRUGRES1',\n",
       " 'DRUGRES2',\n",
       " 'DRUGRES3',\n",
       " 'DRUGS',\n",
       " 'DRUGTST1',\n",
       " 'DRUGTST2',\n",
       " 'DRUGTST3',\n",
       " 'DSTATUS',\n",
       " 'EJECTION',\n",
       " 'EJECT_IM',\n",
       " 'EMER_USE',\n",
       " 'FIRE_EXP',\n",
       " 'HARM_EV',\n",
       " 'HOSPITAL',\n",
       " 'HOUR',\n",
       " 'IMPACT1',\n",
       " 'INJSEV_IM',\n",
       " 'INJ_SEV',\n",
       " 'LOCATION',\n",
       " 'MAKE',\n",
       " 'MAN_COLL',\n",
       " 'MINUTE',\n",
       " 'MOD_YEAR',\n",
       " 'MONTH',\n",
       " 'PERALCH_IM',\n",
       " 'PER_NO',\n",
       " 'PER_TYP',\n",
       " 'PJ',\n",
       " 'PSU',\n",
       " 'PSUSTRAT',\n",
       " 'P_SF1',\n",
       " 'P_SF2',\n",
       " 'P_SF3',\n",
       " 'REGION',\n",
       " 'REST_MIS',\n",
       " 'REST_USE',\n",
       " 'ROLLOVER',\n",
       " 'SCH_BUS',\n",
       " 'SEAT_IM',\n",
       " 'SEAT_POS',\n",
       " 'SEX',\n",
       " 'SEX_IM',\n",
       " 'SPEC_USE',\n",
       " 'STRATUM',\n",
       " 'STR_VEH',\n",
       " 'TOW_VEH',\n",
       " 'VEH_NO',\n",
       " 'VE_FORMS',\n",
       " 'WEIGHT']"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sorted(input_data.columns)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#2: Now that we have the data, we will first start by exploring what we have. The more insights and data undertsandig we have, the better we will be able to work with the data!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "CASENUM         int64\n",
       "VEH_NO          int64\n",
       "PER_NO          int64\n",
       "SEX_IM          int64\n",
       "INJSEV_IM       int64\n",
       "EJECT_IM        int64\n",
       "PERALCH_IM      int64\n",
       "SEAT_IM         int64\n",
       "AGE_IM          int64\n",
       "VE_FORMS        int64\n",
       "WEIGHT        float64\n",
       "REGION          int64\n",
       "STRATUM         int64\n",
       "PJ              int64\n",
       "PSU             int64\n",
       "PSUSTRAT        int64\n",
       "STR_VEH         int64\n",
       "MONTH           int64\n",
       "HOUR            int64\n",
       "MINUTE          int64\n",
       "HARM_EV         int64\n",
       "MAN_COLL        int64\n",
       "SCH_BUS         int64\n",
       "MAKE          float64\n",
       "BODY_TYP      float64\n",
       "MOD_YEAR      float64\n",
       "TOW_VEH       float64\n",
       "SPEC_USE      float64\n",
       "EMER_USE      float64\n",
       "ROLLOVER      float64\n",
       "IMPACT1       float64\n",
       "FIRE_EXP      float64\n",
       "AGE             int64\n",
       "SEX             int64\n",
       "PER_TYP         int64\n",
       "INJ_SEV         int64\n",
       "SEAT_POS        int64\n",
       "REST_USE        int64\n",
       "REST_MIS        int64\n",
       "AIR_BAG         int64\n",
       "EJECTION        int64\n",
       "DRINKING        int64\n",
       "ALC_STATUS      int64\n",
       "ATST_TYP        int64\n",
       "ALC_RES         int64\n",
       "DRUGS           int64\n",
       "DSTATUS         int64\n",
       "DRUGTST1        int64\n",
       "DRUGTST2        int64\n",
       "DRUGTST3        int64\n",
       "DRUGRES1        int64\n",
       "DRUGRES2        int64\n",
       "DRUGRES3        int64\n",
       "HOSPITAL        int64\n",
       "P_SF1           int64\n",
       "P_SF2           int64\n",
       "P_SF3           int64\n",
       "LOCATION        int64\n",
       "dtype: object"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "input_data.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<bound method NDFrame.sample of              CASENUM  VEH_NO  PER_NO  SEX_IM  INJSEV_IM  EJECT_IM  PERALCH_IM  \\\n",
       "0       201210432623       1       1       1          0         0           0   \n",
       "1       201210432623       2       1       2          0         0           0   \n",
       "2       201210432628       1       1       1          1         0           0   \n",
       "3       201210432628       1       2       2          1         0           0   \n",
       "4       201210432628       2       1       2          0         0           0   \n",
       "5       201210432637       1       1       1          0         0           1   \n",
       "6       201210432637       1       2       2          0         0           0   \n",
       "7       201210432654       1       1       2          0         0           0   \n",
       "8       201210432654       1       2       2          0         0           0   \n",
       "9       201210432654       2       1       2          1         0           0   \n",
       "10      201210432654       3       1       2          1         0           0   \n",
       "11      201210432656       1       1       1          2         0           0   \n",
       "12      201210432657       1       1       2          0         0           0   \n",
       "13      201210432657       1       2       1          0         0           0   \n",
       "14      201210432657       2       1       2          0         0           0   \n",
       "15      201210432658       1       1       1          0         0           1   \n",
       "16      201210432662       1       1       1          0         0           0   \n",
       "17      201210432662       1       2       1          1         0           1   \n",
       "18      201210432662       2       1       2          0         0           0   \n",
       "19      201210432666       1       1       1          0         0           0   \n",
       "20      201210432690       1       1       1          0         0           0   \n",
       "21      201210432690       2       1       2          0         0           0   \n",
       "22      201210432697       1       1       2          0         0           0   \n",
       "23      201210432699       1       1       1          0         0           0   \n",
       "24      201210432701       1       1       1          0         0           0   \n",
       "25      201210432701       2       1       1          0         0           0   \n",
       "26      201210432710       1       1       1          0         0           0   \n",
       "27      201210432710       1       2       1          0         0           0   \n",
       "28      201210432710       2       1       1          0         0           0   \n",
       "29      201210432711       1       1       2          1         0           0   \n",
       "...              ...     ...     ...     ...        ...       ...         ...   \n",
       "153047  201299502467       0       2       2          2         8           0   \n",
       "153048  201299502467       1       1       1          0         0           0   \n",
       "153049  201299502477       1       1       1          0         0           1   \n",
       "153050  201299502477       2       1       2          3         0           0   \n",
       "153051  201299502478       1       1       1          0         0           0   \n",
       "153052  201299502505       1       1       1          1         0           0   \n",
       "153053  201299502505       2       1       1          2         0           0   \n",
       "153054  201299502514       0       1       1          2         8           0   \n",
       "153055  201299502514       1       1       2          0         0           0   \n",
       "153056  201299502515       1       1       2          1         0           0   \n",
       "153057  201299502515       2       1       1          0         0           0   \n",
       "153058  201299502516       1       1       1          2         0           0   \n",
       "153059  201299502516       2       1       2          2         0           0   \n",
       "153060  201299502528       1       1       2          1         0           0   \n",
       "153061  201299502528       1       2       1          0         0           0   \n",
       "153062  201299502528       2       1       2          1         0           0   \n",
       "153063  201299502528       2       2       2          1         0           0   \n",
       "153064  201299502528       2       3       2          0         0           0   \n",
       "153065  201299502528       3       1       2          0         0           0   \n",
       "153066  201299502528       3       2       1          0         0           0   \n",
       "153067  201299502528       4       1       2          0         0           0   \n",
       "153068  201299502528       4       2       1          0         0           0   \n",
       "153069  201299502528       4       3       1          0         0           0   \n",
       "153070  201299502534       1       1       2          0         0           0   \n",
       "153071  201299502534       2       1       2          1         0           0   \n",
       "153072  201299502534       3       1       1          0         0           0   \n",
       "153073  201299502540       0       1       2          1         8           0   \n",
       "153074  201299502540       1       1       1          0         0           0   \n",
       "153075  201299502542       1       1       1          0         0           0   \n",
       "153076  201299502542       2       1       1          2         0           0   \n",
       "\n",
       "        SEAT_IM  AGE_IM  VE_FORMS    ...     DRUGTST2  DRUGTST3  DRUGRES1  \\\n",
       "0            11      43         2    ...            0         0        95   \n",
       "1            11      68         2    ...            0         0        95   \n",
       "2            11      67         2    ...            0         0        95   \n",
       "3            13      69         2    ...            0         0         0   \n",
       "4            11      36         2    ...            0         0        95   \n",
       "5            11      48         1    ...            0         0        95   \n",
       "6            13      23         1    ...            0         0         0   \n",
       "7            11      32         3    ...            0         0        95   \n",
       "8            13      32         3    ...            0         0         0   \n",
       "9            11      20         3    ...            0         0        95   \n",
       "10           11      26         3    ...            0         0        95   \n",
       "11           11      89         1    ...            0         0        95   \n",
       "12           11      17         2    ...            0         0        95   \n",
       "13           13      18         2    ...            0         0         0   \n",
       "14           11      32         2    ...            0         0        95   \n",
       "15           11      22         1    ...            0         0        95   \n",
       "16           11      23         2    ...            0         0        95   \n",
       "17           13      26         2    ...            0         0         0   \n",
       "18           11      62         2    ...            0         0        95   \n",
       "19           11      46         1    ...            0         0        95   \n",
       "20           11      57         2    ...            0         0        95   \n",
       "21           11      55         2    ...            0         0        95   \n",
       "22           11      50         1    ...            0         0        95   \n",
       "23           11      60         1    ...            0         0        95   \n",
       "24           11      36         2    ...            0         0        95   \n",
       "25           11      51         2    ...            0         0        95   \n",
       "26           11      24         2    ...            0         0        95   \n",
       "27           13      24         2    ...            0         0         0   \n",
       "28           11      24         2    ...            0         0        95   \n",
       "29           11      40         3    ...            0         0        95   \n",
       "...         ...     ...       ...    ...          ...       ...       ...   \n",
       "153047        0       9         1    ...            0         0         0   \n",
       "153048       11      51         1    ...            0         0        95   \n",
       "153049       11      20         2    ...            0         0        95   \n",
       "153050       11      42         2    ...            0         0        95   \n",
       "153051       11      24         1    ...            0         0         0   \n",
       "153052       11      24         2    ...            0         0        95   \n",
       "153053       11      31         2    ...            0         0        95   \n",
       "153054        0      65         1    ...            0         0         0   \n",
       "153055       11      22         1    ...            0         0        95   \n",
       "153056       11      30         2    ...            0         0        95   \n",
       "153057       11      45         2    ...            0         0        95   \n",
       "153058       11      24         2    ...            0         0        95   \n",
       "153059       11      26         2    ...            0         0        95   \n",
       "153060       11      33         4    ...            0         0        95   \n",
       "153061       13      24         4    ...            0         0         0   \n",
       "153062       11      47         4    ...            0         0        95   \n",
       "153063       23      11         4    ...            0         0         0   \n",
       "153064       13      17         4    ...            0         0         0   \n",
       "153065       11      52         4    ...            0         0        95   \n",
       "153066       13      15         4    ...            0         0         0   \n",
       "153067       11      52         4    ...            0         0        95   \n",
       "153068       13      13         4    ...            0         0         0   \n",
       "153069       21      10         4    ...            0         0         0   \n",
       "153070       11      19         3    ...            0         0        95   \n",
       "153071       11      59         3    ...            0         0        95   \n",
       "153072       11      49         3    ...            0         0        95   \n",
       "153073        0      43         1    ...            0         0         0   \n",
       "153074       11      52         1    ...            0         0        95   \n",
       "153075       11      28         2    ...            0         0        95   \n",
       "153076       11      76         2    ...            0         0        95   \n",
       "\n",
       "        DRUGRES2  DRUGRES3  HOSPITAL  P_SF1  P_SF2  P_SF3  LOCATION  \n",
       "0              0         0         0      0      0      0         0  \n",
       "1              0         0         0      0      0      0         0  \n",
       "2              0         0         5      0      0      0         0  \n",
       "3              0         0         5      0      0      0         0  \n",
       "4              0         0         0      0      0      0         0  \n",
       "5              0         0         0      0      0      0         0  \n",
       "6              0         0         0      0      0      0         0  \n",
       "7              0         0         0      0      0      0         0  \n",
       "8              0         0         0      0      0      0         0  \n",
       "9              0         0         0      0      0      0         0  \n",
       "10             0         0         6      0      0      0         0  \n",
       "11             0         0         0      0      0      0         0  \n",
       "12             0         0         0      0      0      0         0  \n",
       "13             0         0         0      0      0      0         0  \n",
       "14             0         0         0      0      0      0         0  \n",
       "15             0         0         0      0      0      0         0  \n",
       "16             0         0         0      0      0      0         0  \n",
       "17             0         0         0      0      0      0         0  \n",
       "18             0         0         0      0      0      0         0  \n",
       "19             0         0         0      0      0      0         0  \n",
       "20             0         0         0      0      0      0         0  \n",
       "21             0         0         0      0      0      0         0  \n",
       "22             0         0         0      0      0      0         0  \n",
       "23             0         0         0      0      0      0         0  \n",
       "24             0         0         0      0      0      0         0  \n",
       "25             0         0         0      0      0      0         0  \n",
       "26             0         0         0      0      0      0         0  \n",
       "27             0         0         0      0      0      0         0  \n",
       "28             0         0         0      0      0      0         0  \n",
       "29             0         0         5      0      0      0         0  \n",
       "...          ...       ...       ...    ...    ...    ...       ...  \n",
       "153047         0         0         5      0      0      0         1  \n",
       "153048         0         0         0      0      0      0         0  \n",
       "153049         0         0         0      0      0      0         0  \n",
       "153050         0         0         5      0      0      0         0  \n",
       "153051         0         0         0     99     99     99         0  \n",
       "153052         0         0         0      0      0      0         0  \n",
       "153053         0         0         5      0      0      0         0  \n",
       "153054         0         0         5      0      0      0        11  \n",
       "153055         0         0         0      0      0      0         0  \n",
       "153056         0         0         5      0      0      0         0  \n",
       "153057         0         0         0      0      0      0         0  \n",
       "153058         0         0         0      0      0      0         0  \n",
       "153059         0         0         0      0      0      0         0  \n",
       "153060         0         0         0      0      0      0         0  \n",
       "153061         0         0         0      0      0      0         0  \n",
       "153062         0         0         0      0      0      0         0  \n",
       "153063         0         0         0      0      0      0         0  \n",
       "153064         0         0         0      0      0      0         0  \n",
       "153065         0         0         0      0      0      0         0  \n",
       "153066         0         0         0      0      0      0         0  \n",
       "153067         0         0         0      0      0      0         0  \n",
       "153068         0         0         0      0      0      0         0  \n",
       "153069         0         0         0      0      0      0         0  \n",
       "153070         0         0         0      0      0      0         0  \n",
       "153071         0         0         5      0      0      0         0  \n",
       "153072         0         0         0      0      0      0         0  \n",
       "153073         0         0         5      0      0      0        11  \n",
       "153074         0         0         0      0      0      0         0  \n",
       "153075         0         0         0      0      0      0         0  \n",
       "153076         0         0         0      0      0      0         0  \n",
       "\n",
       "[153077 rows x 58 columns]>"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "input_data.sample"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CASENUM</th>\n",
       "      <th>VEH_NO</th>\n",
       "      <th>PER_NO</th>\n",
       "      <th>SEX_IM</th>\n",
       "      <th>INJSEV_IM</th>\n",
       "      <th>EJECT_IM</th>\n",
       "      <th>PERALCH_IM</th>\n",
       "      <th>SEAT_IM</th>\n",
       "      <th>AGE_IM</th>\n",
       "      <th>VE_FORMS</th>\n",
       "      <th>...</th>\n",
       "      <th>DRUGTST2</th>\n",
       "      <th>DRUGTST3</th>\n",
       "      <th>DRUGRES1</th>\n",
       "      <th>DRUGRES2</th>\n",
       "      <th>DRUGRES3</th>\n",
       "      <th>HOSPITAL</th>\n",
       "      <th>P_SF1</th>\n",
       "      <th>P_SF2</th>\n",
       "      <th>P_SF3</th>\n",
       "      <th>LOCATION</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>201210432623</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>43</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>95</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>201210432623</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>68</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>95</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>201210432628</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>67</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>95</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>201210432628</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>69</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>201210432628</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>36</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>95</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 58 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        CASENUM  VEH_NO  PER_NO  SEX_IM  INJSEV_IM  EJECT_IM  PERALCH_IM  \\\n",
       "0  201210432623       1       1       1          0         0           0   \n",
       "1  201210432623       2       1       2          0         0           0   \n",
       "2  201210432628       1       1       1          1         0           0   \n",
       "3  201210432628       1       2       2          1         0           0   \n",
       "4  201210432628       2       1       2          0         0           0   \n",
       "\n",
       "   SEAT_IM  AGE_IM  VE_FORMS    ...     DRUGTST2  DRUGTST3  DRUGRES1  \\\n",
       "0       11      43         2    ...            0         0        95   \n",
       "1       11      68         2    ...            0         0        95   \n",
       "2       11      67         2    ...            0         0        95   \n",
       "3       13      69         2    ...            0         0         0   \n",
       "4       11      36         2    ...            0         0        95   \n",
       "\n",
       "   DRUGRES2  DRUGRES3  HOSPITAL  P_SF1  P_SF2  P_SF3  LOCATION  \n",
       "0         0         0         0      0      0      0         0  \n",
       "1         0         0         0      0      0      0         0  \n",
       "2         0         0         5      0      0      0         0  \n",
       "3         0         0         5      0      0      0         0  \n",
       "4         0         0         0      0      0      0         0  \n",
       "\n",
       "[5 rows x 58 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "input_data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CASENUM</th>\n",
       "      <th>VEH_NO</th>\n",
       "      <th>PER_NO</th>\n",
       "      <th>SEX_IM</th>\n",
       "      <th>INJSEV_IM</th>\n",
       "      <th>EJECT_IM</th>\n",
       "      <th>PERALCH_IM</th>\n",
       "      <th>SEAT_IM</th>\n",
       "      <th>AGE_IM</th>\n",
       "      <th>VE_FORMS</th>\n",
       "      <th>...</th>\n",
       "      <th>DRUGTST2</th>\n",
       "      <th>DRUGTST3</th>\n",
       "      <th>DRUGRES1</th>\n",
       "      <th>DRUGRES2</th>\n",
       "      <th>DRUGRES3</th>\n",
       "      <th>HOSPITAL</th>\n",
       "      <th>P_SF1</th>\n",
       "      <th>P_SF2</th>\n",
       "      <th>P_SF3</th>\n",
       "      <th>LOCATION</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>153072</th>\n",
       "      <td>201299502534</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>49</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>95</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153073</th>\n",
       "      <td>201299502540</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>43</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153074</th>\n",
       "      <td>201299502540</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>52</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>95</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153075</th>\n",
       "      <td>201299502542</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>28</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>95</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153076</th>\n",
       "      <td>201299502542</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>76</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>95</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 58 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             CASENUM  VEH_NO  PER_NO  SEX_IM  INJSEV_IM  EJECT_IM  PERALCH_IM  \\\n",
       "153072  201299502534       3       1       1          0         0           0   \n",
       "153073  201299502540       0       1       2          1         8           0   \n",
       "153074  201299502540       1       1       1          0         0           0   \n",
       "153075  201299502542       1       1       1          0         0           0   \n",
       "153076  201299502542       2       1       1          2         0           0   \n",
       "\n",
       "        SEAT_IM  AGE_IM  VE_FORMS    ...     DRUGTST2  DRUGTST3  DRUGRES1  \\\n",
       "153072       11      49         3    ...            0         0        95   \n",
       "153073        0      43         1    ...            0         0         0   \n",
       "153074       11      52         1    ...            0         0        95   \n",
       "153075       11      28         2    ...            0         0        95   \n",
       "153076       11      76         2    ...            0         0        95   \n",
       "\n",
       "        DRUGRES2  DRUGRES3  HOSPITAL  P_SF1  P_SF2  P_SF3  LOCATION  \n",
       "153072         0         0         0      0      0      0         0  \n",
       "153073         0         0         5      0      0      0        11  \n",
       "153074         0         0         0      0      0      0         0  \n",
       "153075         0         0         0      0      0      0         0  \n",
       "153076         0         0         0      0      0      0         0  \n",
       "\n",
       "[5 rows x 58 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "input_data.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(153077, 58)"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "input_data.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['CASENUM', 'VEH_NO', 'PER_NO', 'SEX_IM', 'INJSEV_IM', 'EJECT_IM',\n",
       "       'PERALCH_IM', 'SEAT_IM', 'AGE_IM', 'VE_FORMS', 'WEIGHT', 'REGION',\n",
       "       'STRATUM', 'PJ', 'PSU', 'PSUSTRAT', 'STR_VEH', 'MONTH', 'HOUR',\n",
       "       'MINUTE', 'HARM_EV', 'MAN_COLL', 'SCH_BUS', 'MAKE', 'BODY_TYP',\n",
       "       'MOD_YEAR', 'TOW_VEH', 'SPEC_USE', 'EMER_USE', 'ROLLOVER', 'IMPACT1',\n",
       "       'FIRE_EXP', 'AGE', 'SEX', 'PER_TYP', 'INJ_SEV', 'SEAT_POS', 'REST_USE',\n",
       "       'REST_MIS', 'AIR_BAG', 'EJECTION', 'DRINKING', 'ALC_STATUS', 'ATST_TYP',\n",
       "       'ALC_RES', 'DRUGS', 'DSTATUS', 'DRUGTST1', 'DRUGTST2', 'DRUGTST3',\n",
       "       'DRUGRES1', 'DRUGRES2', 'DRUGRES3', 'HOSPITAL', 'P_SF1', 'P_SF2',\n",
       "       'P_SF3', 'LOCATION'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "input_data.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CASENUM</th>\n",
       "      <th>VEH_NO</th>\n",
       "      <th>PER_NO</th>\n",
       "      <th>SEX_IM</th>\n",
       "      <th>INJSEV_IM</th>\n",
       "      <th>EJECT_IM</th>\n",
       "      <th>PERALCH_IM</th>\n",
       "      <th>SEAT_IM</th>\n",
       "      <th>AGE_IM</th>\n",
       "      <th>VE_FORMS</th>\n",
       "      <th>...</th>\n",
       "      <th>DRUGTST2</th>\n",
       "      <th>DRUGTST3</th>\n",
       "      <th>DRUGRES1</th>\n",
       "      <th>DRUGRES2</th>\n",
       "      <th>DRUGRES3</th>\n",
       "      <th>HOSPITAL</th>\n",
       "      <th>P_SF1</th>\n",
       "      <th>P_SF2</th>\n",
       "      <th>P_SF3</th>\n",
       "      <th>LOCATION</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>1.530770e+05</td>\n",
       "      <td>153077.000000</td>\n",
       "      <td>153077.000000</td>\n",
       "      <td>153077.000000</td>\n",
       "      <td>153077.000000</td>\n",
       "      <td>153077.000000</td>\n",
       "      <td>153077.000000</td>\n",
       "      <td>153077.000000</td>\n",
       "      <td>153077.000000</td>\n",
       "      <td>153077.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>153077.0</td>\n",
       "      <td>153077.0</td>\n",
       "      <td>153077.000000</td>\n",
       "      <td>153077.0</td>\n",
       "      <td>153077.0</td>\n",
       "      <td>153077.000000</td>\n",
       "      <td>153077.000000</td>\n",
       "      <td>153077.000000</td>\n",
       "      <td>153077.000000</td>\n",
       "      <td>153077.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>2.012372e+11</td>\n",
       "      <td>1.478530</td>\n",
       "      <td>1.408938</td>\n",
       "      <td>1.434539</td>\n",
       "      <td>0.658107</td>\n",
       "      <td>0.465119</td>\n",
       "      <td>0.033277</td>\n",
       "      <td>12.388393</td>\n",
       "      <td>36.411479</td>\n",
       "      <td>1.991116</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>36.940781</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.242368</td>\n",
       "      <td>0.822540</td>\n",
       "      <td>0.569772</td>\n",
       "      <td>0.569772</td>\n",
       "      <td>0.295119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>2.856141e+07</td>\n",
       "      <td>0.744841</td>\n",
       "      <td>0.884132</td>\n",
       "      <td>0.495698</td>\n",
       "      <td>1.060698</td>\n",
       "      <td>1.861087</td>\n",
       "      <td>0.179361</td>\n",
       "      <td>5.140169</td>\n",
       "      <td>18.591070</td>\n",
       "      <td>0.839858</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>105.800832</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.269444</td>\n",
       "      <td>8.663603</td>\n",
       "      <td>7.488869</td>\n",
       "      <td>7.488869</td>\n",
       "      <td>2.601399</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>2.012104e+11</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>2.012177e+11</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>11.000000</td>\n",
       "      <td>22.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>2.012281e+11</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>11.000000</td>\n",
       "      <td>33.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>2.012297e+11</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>50.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>95.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>2.012995e+11</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>28.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>55.000000</td>\n",
       "      <td>112.000000</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>999.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>99.000000</td>\n",
       "      <td>99.000000</td>\n",
       "      <td>99.000000</td>\n",
       "      <td>99.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8 rows × 58 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            CASENUM         VEH_NO         PER_NO         SEX_IM  \\\n",
       "count  1.530770e+05  153077.000000  153077.000000  153077.000000   \n",
       "mean   2.012372e+11       1.478530       1.408938       1.434539   \n",
       "std    2.856141e+07       0.744841       0.884132       0.495698   \n",
       "min    2.012104e+11       0.000000       1.000000       1.000000   \n",
       "25%    2.012177e+11       1.000000       1.000000       1.000000   \n",
       "50%    2.012281e+11       1.000000       1.000000       1.000000   \n",
       "75%    2.012297e+11       2.000000       2.000000       2.000000   \n",
       "max    2.012995e+11      20.000000      28.000000       2.000000   \n",
       "\n",
       "           INJSEV_IM       EJECT_IM     PERALCH_IM        SEAT_IM  \\\n",
       "count  153077.000000  153077.000000  153077.000000  153077.000000   \n",
       "mean        0.658107       0.465119       0.033277      12.388393   \n",
       "std         1.060698       1.861087       0.179361       5.140169   \n",
       "min         0.000000       0.000000       0.000000       0.000000   \n",
       "25%         0.000000       0.000000       0.000000      11.000000   \n",
       "50%         0.000000       0.000000       0.000000      11.000000   \n",
       "75%         1.000000       0.000000       0.000000      13.000000   \n",
       "max         6.000000       8.000000       1.000000      55.000000   \n",
       "\n",
       "              AGE_IM       VE_FORMS      ...        DRUGTST2  DRUGTST3  \\\n",
       "count  153077.000000  153077.000000      ...        153077.0  153077.0   \n",
       "mean       36.411479       1.991116      ...             0.0       0.0   \n",
       "std        18.591070       0.839858      ...             0.0       0.0   \n",
       "min         0.000000       1.000000      ...             0.0       0.0   \n",
       "25%        22.000000       2.000000      ...             0.0       0.0   \n",
       "50%        33.000000       2.000000      ...             0.0       0.0   \n",
       "75%        50.000000       2.000000      ...             0.0       0.0   \n",
       "max       112.000000      20.000000      ...             0.0       0.0   \n",
       "\n",
       "            DRUGRES1  DRUGRES2  DRUGRES3       HOSPITAL          P_SF1  \\\n",
       "count  153077.000000  153077.0  153077.0  153077.000000  153077.000000   \n",
       "mean       36.940781       0.0       0.0       1.242368       0.822540   \n",
       "std       105.800832       0.0       0.0       2.269444       8.663603   \n",
       "min         0.000000       0.0       0.0       0.000000       0.000000   \n",
       "25%         0.000000       0.0       0.0       0.000000       0.000000   \n",
       "50%         0.000000       0.0       0.0       0.000000       0.000000   \n",
       "75%        95.000000       0.0       0.0       0.000000       0.000000   \n",
       "max       999.000000       0.0       0.0       9.000000      99.000000   \n",
       "\n",
       "               P_SF2          P_SF3       LOCATION  \n",
       "count  153077.000000  153077.000000  153077.000000  \n",
       "mean        0.569772       0.569772       0.295119  \n",
       "std         7.488869       7.488869       2.601399  \n",
       "min         0.000000       0.000000       0.000000  \n",
       "25%         0.000000       0.000000       0.000000  \n",
       "50%         0.000000       0.000000       0.000000  \n",
       "75%         0.000000       0.000000       0.000000  \n",
       "max        99.000000      99.000000      99.000000  \n",
       "\n",
       "[8 rows x 58 columns]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "input_data.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "RangeIndex(start=0, stop=153077, step=1)"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "input_data.index\n",
    "input_data.values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>...</th>\n",
       "      <th>153067</th>\n",
       "      <th>153068</th>\n",
       "      <th>153069</th>\n",
       "      <th>153070</th>\n",
       "      <th>153071</th>\n",
       "      <th>153072</th>\n",
       "      <th>153073</th>\n",
       "      <th>153074</th>\n",
       "      <th>153075</th>\n",
       "      <th>153076</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>CASENUM</th>\n",
       "      <td>2.012104e+11</td>\n",
       "      <td>2.012104e+11</td>\n",
       "      <td>2.012104e+11</td>\n",
       "      <td>2.012104e+11</td>\n",
       "      <td>2.012104e+11</td>\n",
       "      <td>2.012104e+11</td>\n",
       "      <td>2.012104e+11</td>\n",
       "      <td>2.012104e+11</td>\n",
       "      <td>2.012104e+11</td>\n",
       "      <td>2.012104e+11</td>\n",
       "      <td>...</td>\n",
       "      <td>2.012995e+11</td>\n",
       "      <td>2.012995e+11</td>\n",
       "      <td>2.012995e+11</td>\n",
       "      <td>2.012995e+11</td>\n",
       "      <td>2.012995e+11</td>\n",
       "      <td>2.012995e+11</td>\n",
       "      <td>2.012995e+11</td>\n",
       "      <td>2.012995e+11</td>\n",
       "      <td>2.012995e+11</td>\n",
       "      <td>2.012995e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VEH_NO</th>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>4.000000e+00</td>\n",
       "      <td>4.000000e+00</td>\n",
       "      <td>4.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PER_NO</th>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SEX_IM</th>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>INJSEV_IM</th>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EJECT_IM</th>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PERALCH_IM</th>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SEAT_IM</th>\n",
       "      <td>1.100000e+01</td>\n",
       "      <td>1.100000e+01</td>\n",
       "      <td>1.100000e+01</td>\n",
       "      <td>1.300000e+01</td>\n",
       "      <td>1.100000e+01</td>\n",
       "      <td>1.100000e+01</td>\n",
       "      <td>1.300000e+01</td>\n",
       "      <td>1.100000e+01</td>\n",
       "      <td>1.300000e+01</td>\n",
       "      <td>1.100000e+01</td>\n",
       "      <td>...</td>\n",
       "      <td>1.100000e+01</td>\n",
       "      <td>1.300000e+01</td>\n",
       "      <td>2.100000e+01</td>\n",
       "      <td>1.100000e+01</td>\n",
       "      <td>1.100000e+01</td>\n",
       "      <td>1.100000e+01</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.100000e+01</td>\n",
       "      <td>1.100000e+01</td>\n",
       "      <td>1.100000e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AGE_IM</th>\n",
       "      <td>4.300000e+01</td>\n",
       "      <td>6.800000e+01</td>\n",
       "      <td>6.700000e+01</td>\n",
       "      <td>6.900000e+01</td>\n",
       "      <td>3.600000e+01</td>\n",
       "      <td>4.800000e+01</td>\n",
       "      <td>2.300000e+01</td>\n",
       "      <td>3.200000e+01</td>\n",
       "      <td>3.200000e+01</td>\n",
       "      <td>2.000000e+01</td>\n",
       "      <td>...</td>\n",
       "      <td>5.200000e+01</td>\n",
       "      <td>1.300000e+01</td>\n",
       "      <td>1.000000e+01</td>\n",
       "      <td>1.900000e+01</td>\n",
       "      <td>5.900000e+01</td>\n",
       "      <td>4.900000e+01</td>\n",
       "      <td>4.300000e+01</td>\n",
       "      <td>5.200000e+01</td>\n",
       "      <td>2.800000e+01</td>\n",
       "      <td>7.600000e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VE_FORMS</th>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>4.000000e+00</td>\n",
       "      <td>4.000000e+00</td>\n",
       "      <td>4.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WEIGHT</th>\n",
       "      <td>2.714600e+01</td>\n",
       "      <td>2.714600e+01</td>\n",
       "      <td>5.429200e+01</td>\n",
       "      <td>5.429200e+01</td>\n",
       "      <td>5.429200e+01</td>\n",
       "      <td>1.085840e+02</td>\n",
       "      <td>1.085840e+02</td>\n",
       "      <td>8.985326e+01</td>\n",
       "      <td>8.985326e+01</td>\n",
       "      <td>8.985326e+01</td>\n",
       "      <td>...</td>\n",
       "      <td>9.984590e+01</td>\n",
       "      <td>9.984590e+01</td>\n",
       "      <td>9.984590e+01</td>\n",
       "      <td>5.546994e+01</td>\n",
       "      <td>5.546994e+01</td>\n",
       "      <td>5.546994e+01</td>\n",
       "      <td>2.218798e+02</td>\n",
       "      <td>2.218798e+02</td>\n",
       "      <td>1.109399e+01</td>\n",
       "      <td>1.109399e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>REGION</th>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>4.000000e+00</td>\n",
       "      <td>4.000000e+00</td>\n",
       "      <td>4.000000e+00</td>\n",
       "      <td>4.000000e+00</td>\n",
       "      <td>4.000000e+00</td>\n",
       "      <td>4.000000e+00</td>\n",
       "      <td>4.000000e+00</td>\n",
       "      <td>4.000000e+00</td>\n",
       "      <td>4.000000e+00</td>\n",
       "      <td>4.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>STRATUM</th>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>5.000000e+00</td>\n",
       "      <td>5.000000e+00</td>\n",
       "      <td>5.000000e+00</td>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>5.000000e+00</td>\n",
       "      <td>5.000000e+00</td>\n",
       "      <td>5.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>5.000000e+00</td>\n",
       "      <td>5.000000e+00</td>\n",
       "      <td>5.000000e+00</td>\n",
       "      <td>4.000000e+00</td>\n",
       "      <td>4.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PJ</th>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>1.000000e+01</td>\n",
       "      <td>1.000000e+01</td>\n",
       "      <td>1.000000e+01</td>\n",
       "      <td>...</td>\n",
       "      <td>7.000000e+00</td>\n",
       "      <td>7.000000e+00</td>\n",
       "      <td>7.000000e+00</td>\n",
       "      <td>7.000000e+00</td>\n",
       "      <td>7.000000e+00</td>\n",
       "      <td>7.000000e+00</td>\n",
       "      <td>7.000000e+00</td>\n",
       "      <td>7.000000e+00</td>\n",
       "      <td>7.000000e+00</td>\n",
       "      <td>7.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PSU</th>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>7.900000e+01</td>\n",
       "      <td>7.900000e+01</td>\n",
       "      <td>7.900000e+01</td>\n",
       "      <td>7.900000e+01</td>\n",
       "      <td>7.900000e+01</td>\n",
       "      <td>7.900000e+01</td>\n",
       "      <td>7.900000e+01</td>\n",
       "      <td>7.900000e+01</td>\n",
       "      <td>7.900000e+01</td>\n",
       "      <td>7.900000e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PSUSTRAT</th>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>1.000000e+01</td>\n",
       "      <td>1.000000e+01</td>\n",
       "      <td>1.000000e+01</td>\n",
       "      <td>1.000000e+01</td>\n",
       "      <td>1.000000e+01</td>\n",
       "      <td>1.000000e+01</td>\n",
       "      <td>1.000000e+01</td>\n",
       "      <td>1.000000e+01</td>\n",
       "      <td>1.000000e+01</td>\n",
       "      <td>1.000000e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>STR_VEH</th>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MONTH</th>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>4.000000e+00</td>\n",
       "      <td>4.000000e+00</td>\n",
       "      <td>7.000000e+00</td>\n",
       "      <td>7.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HOUR</th>\n",
       "      <td>1.400000e+01</td>\n",
       "      <td>1.400000e+01</td>\n",
       "      <td>1.300000e+01</td>\n",
       "      <td>1.300000e+01</td>\n",
       "      <td>1.300000e+01</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.900000e+01</td>\n",
       "      <td>1.900000e+01</td>\n",
       "      <td>1.900000e+01</td>\n",
       "      <td>...</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>7.000000e+00</td>\n",
       "      <td>7.000000e+00</td>\n",
       "      <td>7.000000e+00</td>\n",
       "      <td>1.600000e+01</td>\n",
       "      <td>1.600000e+01</td>\n",
       "      <td>1.000000e+01</td>\n",
       "      <td>1.000000e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MINUTE</th>\n",
       "      <td>7.000000e+00</td>\n",
       "      <td>7.000000e+00</td>\n",
       "      <td>4.100000e+01</td>\n",
       "      <td>4.100000e+01</td>\n",
       "      <td>4.100000e+01</td>\n",
       "      <td>3.200000e+01</td>\n",
       "      <td>3.200000e+01</td>\n",
       "      <td>5.500000e+01</td>\n",
       "      <td>5.500000e+01</td>\n",
       "      <td>5.500000e+01</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>5.000000e+01</td>\n",
       "      <td>5.000000e+01</td>\n",
       "      <td>5.000000e+01</td>\n",
       "      <td>1.000000e+01</td>\n",
       "      <td>1.000000e+01</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HARM_EV</th>\n",
       "      <td>1.200000e+01</td>\n",
       "      <td>1.200000e+01</td>\n",
       "      <td>1.200000e+01</td>\n",
       "      <td>1.200000e+01</td>\n",
       "      <td>1.200000e+01</td>\n",
       "      <td>4.300000e+01</td>\n",
       "      <td>4.300000e+01</td>\n",
       "      <td>1.100000e+01</td>\n",
       "      <td>1.100000e+01</td>\n",
       "      <td>1.100000e+01</td>\n",
       "      <td>...</td>\n",
       "      <td>1.200000e+01</td>\n",
       "      <td>1.200000e+01</td>\n",
       "      <td>1.200000e+01</td>\n",
       "      <td>1.200000e+01</td>\n",
       "      <td>1.200000e+01</td>\n",
       "      <td>1.200000e+01</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>1.200000e+01</td>\n",
       "      <td>1.200000e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MAN_COLL</th>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>7.000000e+00</td>\n",
       "      <td>7.000000e+00</td>\n",
       "      <td>7.000000e+00</td>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>6.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SCH_BUS</th>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MAKE</th>\n",
       "      <td>2.300000e+01</td>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>2.000000e+01</td>\n",
       "      <td>2.000000e+01</td>\n",
       "      <td>1.200000e+01</td>\n",
       "      <td>4.900000e+01</td>\n",
       "      <td>4.900000e+01</td>\n",
       "      <td>4.900000e+01</td>\n",
       "      <td>4.900000e+01</td>\n",
       "      <td>6.300000e+01</td>\n",
       "      <td>...</td>\n",
       "      <td>1.200000e+01</td>\n",
       "      <td>1.200000e+01</td>\n",
       "      <td>1.200000e+01</td>\n",
       "      <td>4.900000e+01</td>\n",
       "      <td>5.900000e+01</td>\n",
       "      <td>1.200000e+01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.000000e+01</td>\n",
       "      <td>2.000000e+01</td>\n",
       "      <td>3.500000e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BODY_TYP</th>\n",
       "      <td>6.400000e+01</td>\n",
       "      <td>2.900000e+01</td>\n",
       "      <td>4.900000e+01</td>\n",
       "      <td>4.900000e+01</td>\n",
       "      <td>3.900000e+01</td>\n",
       "      <td>4.000000e+00</td>\n",
       "      <td>4.000000e+00</td>\n",
       "      <td>4.000000e+00</td>\n",
       "      <td>4.000000e+00</td>\n",
       "      <td>4.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>3.100000e+01</td>\n",
       "      <td>3.100000e+01</td>\n",
       "      <td>3.100000e+01</td>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>4.000000e+00</td>\n",
       "      <td>3.100000e+01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.100000e+01</td>\n",
       "      <td>2.100000e+01</td>\n",
       "      <td>9.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MOD_YEAR</th>\n",
       "      <td>2.007000e+03</td>\n",
       "      <td>2.006000e+03</td>\n",
       "      <td>2.005000e+03</td>\n",
       "      <td>2.005000e+03</td>\n",
       "      <td>2.000000e+03</td>\n",
       "      <td>1.995000e+03</td>\n",
       "      <td>1.995000e+03</td>\n",
       "      <td>1.996000e+03</td>\n",
       "      <td>1.996000e+03</td>\n",
       "      <td>2.001000e+03</td>\n",
       "      <td>...</td>\n",
       "      <td>2.011000e+03</td>\n",
       "      <td>2.011000e+03</td>\n",
       "      <td>2.011000e+03</td>\n",
       "      <td>9.999000e+03</td>\n",
       "      <td>2.007000e+03</td>\n",
       "      <td>2.004000e+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.999000e+03</td>\n",
       "      <td>2.008000e+03</td>\n",
       "      <td>1.994000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TOW_VEH</th>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SPEC_USE</th>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EMER_USE</th>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ROLLOVER</th>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IMPACT1</th>\n",
       "      <td>1.200000e+01</td>\n",
       "      <td>6.200000e+01</td>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>1.200000e+01</td>\n",
       "      <td>1.200000e+01</td>\n",
       "      <td>1.200000e+01</td>\n",
       "      <td>1.200000e+01</td>\n",
       "      <td>1.200000e+01</td>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>9.000000e+00</td>\n",
       "      <td>9.000000e+00</td>\n",
       "      <td>9.000000e+00</td>\n",
       "      <td>8.300000e+01</td>\n",
       "      <td>1.200000e+01</td>\n",
       "      <td>1.200000e+01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.200000e+01</td>\n",
       "      <td>1.200000e+01</td>\n",
       "      <td>1.100000e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FIRE_EXP</th>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AGE</th>\n",
       "      <td>4.300000e+01</td>\n",
       "      <td>6.800000e+01</td>\n",
       "      <td>6.700000e+01</td>\n",
       "      <td>6.900000e+01</td>\n",
       "      <td>3.600000e+01</td>\n",
       "      <td>4.800000e+01</td>\n",
       "      <td>2.300000e+01</td>\n",
       "      <td>3.200000e+01</td>\n",
       "      <td>3.200000e+01</td>\n",
       "      <td>2.000000e+01</td>\n",
       "      <td>...</td>\n",
       "      <td>5.200000e+01</td>\n",
       "      <td>1.300000e+01</td>\n",
       "      <td>1.000000e+01</td>\n",
       "      <td>1.900000e+01</td>\n",
       "      <td>5.900000e+01</td>\n",
       "      <td>4.900000e+01</td>\n",
       "      <td>4.300000e+01</td>\n",
       "      <td>5.200000e+01</td>\n",
       "      <td>2.800000e+01</td>\n",
       "      <td>7.600000e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SEX</th>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PER_TYP</th>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>5.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>INJ_SEV</th>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SEAT_POS</th>\n",
       "      <td>1.100000e+01</td>\n",
       "      <td>1.100000e+01</td>\n",
       "      <td>1.100000e+01</td>\n",
       "      <td>1.300000e+01</td>\n",
       "      <td>1.100000e+01</td>\n",
       "      <td>1.100000e+01</td>\n",
       "      <td>1.300000e+01</td>\n",
       "      <td>1.100000e+01</td>\n",
       "      <td>1.300000e+01</td>\n",
       "      <td>1.100000e+01</td>\n",
       "      <td>...</td>\n",
       "      <td>1.100000e+01</td>\n",
       "      <td>1.300000e+01</td>\n",
       "      <td>2.100000e+01</td>\n",
       "      <td>1.100000e+01</td>\n",
       "      <td>1.100000e+01</td>\n",
       "      <td>1.100000e+01</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.100000e+01</td>\n",
       "      <td>1.100000e+01</td>\n",
       "      <td>1.100000e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>REST_USE</th>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>7.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>9.600000e+01</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>3.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>REST_MIS</th>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AIR_BAG</th>\n",
       "      <td>9.800000e+01</td>\n",
       "      <td>9.800000e+01</td>\n",
       "      <td>9.800000e+01</td>\n",
       "      <td>9.800000e+01</td>\n",
       "      <td>9.800000e+01</td>\n",
       "      <td>9.000000e+00</td>\n",
       "      <td>9.000000e+00</td>\n",
       "      <td>9.800000e+01</td>\n",
       "      <td>9.800000e+01</td>\n",
       "      <td>9.800000e+01</td>\n",
       "      <td>...</td>\n",
       "      <td>2.000000e+01</td>\n",
       "      <td>2.000000e+01</td>\n",
       "      <td>2.000000e+01</td>\n",
       "      <td>9.000000e+00</td>\n",
       "      <td>9.000000e+00</td>\n",
       "      <td>2.000000e+01</td>\n",
       "      <td>9.700000e+01</td>\n",
       "      <td>2.000000e+01</td>\n",
       "      <td>2.000000e+01</td>\n",
       "      <td>2.000000e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EJECTION</th>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>7.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>7.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>7.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>7.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DRINKING</th>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ALC_STATUS</th>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ATST_TYP</th>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>...</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>9.500000e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ALC_RES</th>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>9.600000e+01</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>9.600000e+01</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>9.600000e+01</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>...</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>9.600000e+01</td>\n",
       "      <td>9.600000e+01</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>9.600000e+01</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>9.500000e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DRUGS</th>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DSTATUS</th>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>8.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DRUGTST1</th>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>6.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DRUGTST2</th>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DRUGTST3</th>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DRUGRES1</th>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>...</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>9.500000e+01</td>\n",
       "      <td>9.500000e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DRUGRES2</th>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DRUGRES3</th>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HOSPITAL</th>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>5.000000e+00</td>\n",
       "      <td>5.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>5.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>5.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_SF1</th>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_SF2</th>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_SF3</th>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LOCATION</th>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.100000e+01</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>58 rows × 153077 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  0             1             2             3       \\\n",
       "CASENUM     2.012104e+11  2.012104e+11  2.012104e+11  2.012104e+11   \n",
       "VEH_NO      1.000000e+00  2.000000e+00  1.000000e+00  1.000000e+00   \n",
       "PER_NO      1.000000e+00  1.000000e+00  1.000000e+00  2.000000e+00   \n",
       "SEX_IM      1.000000e+00  2.000000e+00  1.000000e+00  2.000000e+00   \n",
       "INJSEV_IM   0.000000e+00  0.000000e+00  1.000000e+00  1.000000e+00   \n",
       "EJECT_IM    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "PERALCH_IM  0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "SEAT_IM     1.100000e+01  1.100000e+01  1.100000e+01  1.300000e+01   \n",
       "AGE_IM      4.300000e+01  6.800000e+01  6.700000e+01  6.900000e+01   \n",
       "VE_FORMS    2.000000e+00  2.000000e+00  2.000000e+00  2.000000e+00   \n",
       "WEIGHT      2.714600e+01  2.714600e+01  5.429200e+01  5.429200e+01   \n",
       "REGION      1.000000e+00  1.000000e+00  1.000000e+00  1.000000e+00   \n",
       "STRATUM     2.000000e+00  2.000000e+00  5.000000e+00  5.000000e+00   \n",
       "PJ          3.000000e+00  3.000000e+00  3.000000e+00  3.000000e+00   \n",
       "PSU         2.000000e+00  2.000000e+00  2.000000e+00  2.000000e+00   \n",
       "PSUSTRAT    3.000000e+00  3.000000e+00  3.000000e+00  3.000000e+00   \n",
       "STR_VEH     0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "MONTH       1.000000e+00  1.000000e+00  1.000000e+00  1.000000e+00   \n",
       "HOUR        1.400000e+01  1.400000e+01  1.300000e+01  1.300000e+01   \n",
       "MINUTE      7.000000e+00  7.000000e+00  4.100000e+01  4.100000e+01   \n",
       "HARM_EV     1.200000e+01  1.200000e+01  1.200000e+01  1.200000e+01   \n",
       "MAN_COLL    6.000000e+00  6.000000e+00  1.000000e+00  1.000000e+00   \n",
       "SCH_BUS     0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "MAKE        2.300000e+01  6.000000e+00  2.000000e+01  2.000000e+01   \n",
       "BODY_TYP    6.400000e+01  2.900000e+01  4.900000e+01  4.900000e+01   \n",
       "MOD_YEAR    2.007000e+03  2.006000e+03  2.005000e+03  2.005000e+03   \n",
       "TOW_VEH     0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "SPEC_USE    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "EMER_USE    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "ROLLOVER    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "IMPACT1     1.200000e+01  6.200000e+01  6.000000e+00  6.000000e+00   \n",
       "FIRE_EXP    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "AGE         4.300000e+01  6.800000e+01  6.700000e+01  6.900000e+01   \n",
       "SEX         1.000000e+00  2.000000e+00  1.000000e+00  2.000000e+00   \n",
       "PER_TYP     1.000000e+00  1.000000e+00  1.000000e+00  2.000000e+00   \n",
       "INJ_SEV     0.000000e+00  0.000000e+00  1.000000e+00  1.000000e+00   \n",
       "SEAT_POS    1.100000e+01  1.100000e+01  1.100000e+01  1.300000e+01   \n",
       "REST_USE    3.000000e+00  3.000000e+00  3.000000e+00  3.000000e+00   \n",
       "REST_MIS    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "AIR_BAG     9.800000e+01  9.800000e+01  9.800000e+01  9.800000e+01   \n",
       "EJECTION    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "DRINKING    0.000000e+00  0.000000e+00  0.000000e+00  8.000000e+00   \n",
       "ALC_STATUS  8.000000e+00  8.000000e+00  8.000000e+00  0.000000e+00   \n",
       "ATST_TYP    9.500000e+01  9.500000e+01  9.500000e+01  0.000000e+00   \n",
       "ALC_RES     9.500000e+01  9.500000e+01  9.500000e+01  9.600000e+01   \n",
       "DRUGS       0.000000e+00  0.000000e+00  0.000000e+00  8.000000e+00   \n",
       "DSTATUS     8.000000e+00  8.000000e+00  8.000000e+00  0.000000e+00   \n",
       "DRUGTST1    6.000000e+00  6.000000e+00  6.000000e+00  0.000000e+00   \n",
       "DRUGTST2    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "DRUGTST3    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "DRUGRES1    9.500000e+01  9.500000e+01  9.500000e+01  0.000000e+00   \n",
       "DRUGRES2    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "DRUGRES3    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "HOSPITAL    0.000000e+00  0.000000e+00  5.000000e+00  5.000000e+00   \n",
       "P_SF1       0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "P_SF2       0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "P_SF3       0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "LOCATION    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "\n",
       "                  4             5             6             7       \\\n",
       "CASENUM     2.012104e+11  2.012104e+11  2.012104e+11  2.012104e+11   \n",
       "VEH_NO      2.000000e+00  1.000000e+00  1.000000e+00  1.000000e+00   \n",
       "PER_NO      1.000000e+00  1.000000e+00  2.000000e+00  1.000000e+00   \n",
       "SEX_IM      2.000000e+00  1.000000e+00  2.000000e+00  2.000000e+00   \n",
       "INJSEV_IM   0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "EJECT_IM    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "PERALCH_IM  0.000000e+00  1.000000e+00  0.000000e+00  0.000000e+00   \n",
       "SEAT_IM     1.100000e+01  1.100000e+01  1.300000e+01  1.100000e+01   \n",
       "AGE_IM      3.600000e+01  4.800000e+01  2.300000e+01  3.200000e+01   \n",
       "VE_FORMS    2.000000e+00  1.000000e+00  1.000000e+00  3.000000e+00   \n",
       "WEIGHT      5.429200e+01  1.085840e+02  1.085840e+02  8.985326e+01   \n",
       "REGION      1.000000e+00  1.000000e+00  1.000000e+00  1.000000e+00   \n",
       "STRATUM     5.000000e+00  6.000000e+00  6.000000e+00  5.000000e+00   \n",
       "PJ          3.000000e+00  2.000000e+00  2.000000e+00  1.000000e+01   \n",
       "PSU         2.000000e+00  2.000000e+00  2.000000e+00  2.000000e+00   \n",
       "PSUSTRAT    3.000000e+00  3.000000e+00  3.000000e+00  3.000000e+00   \n",
       "STR_VEH     0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "MONTH       1.000000e+00  1.000000e+00  1.000000e+00  1.000000e+00   \n",
       "HOUR        1.300000e+01  0.000000e+00  0.000000e+00  1.900000e+01   \n",
       "MINUTE      4.100000e+01  3.200000e+01  3.200000e+01  5.500000e+01   \n",
       "HARM_EV     1.200000e+01  4.300000e+01  4.300000e+01  1.100000e+01   \n",
       "MAN_COLL    1.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "SCH_BUS     0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "MAKE        1.200000e+01  4.900000e+01  4.900000e+01  4.900000e+01   \n",
       "BODY_TYP    3.900000e+01  4.000000e+00  4.000000e+00  4.000000e+00   \n",
       "MOD_YEAR    2.000000e+03  1.995000e+03  1.995000e+03  1.996000e+03   \n",
       "TOW_VEH     0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "SPEC_USE    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "EMER_USE    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "ROLLOVER    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "IMPACT1     1.200000e+01  1.200000e+01  1.200000e+01  1.200000e+01   \n",
       "FIRE_EXP    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "AGE         3.600000e+01  4.800000e+01  2.300000e+01  3.200000e+01   \n",
       "SEX         2.000000e+00  1.000000e+00  2.000000e+00  2.000000e+00   \n",
       "PER_TYP     1.000000e+00  1.000000e+00  2.000000e+00  1.000000e+00   \n",
       "INJ_SEV     0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "SEAT_POS    1.100000e+01  1.100000e+01  1.300000e+01  1.100000e+01   \n",
       "REST_USE    3.000000e+00  3.000000e+00  7.000000e+00  3.000000e+00   \n",
       "REST_MIS    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "AIR_BAG     9.800000e+01  9.000000e+00  9.000000e+00  9.800000e+01   \n",
       "EJECTION    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "DRINKING    0.000000e+00  1.000000e+00  8.000000e+00  0.000000e+00   \n",
       "ALC_STATUS  8.000000e+00  8.000000e+00  0.000000e+00  8.000000e+00   \n",
       "ATST_TYP    9.500000e+01  9.500000e+01  0.000000e+00  9.500000e+01   \n",
       "ALC_RES     9.500000e+01  9.500000e+01  9.600000e+01  9.500000e+01   \n",
       "DRUGS       0.000000e+00  0.000000e+00  8.000000e+00  0.000000e+00   \n",
       "DSTATUS     8.000000e+00  8.000000e+00  0.000000e+00  8.000000e+00   \n",
       "DRUGTST1    6.000000e+00  6.000000e+00  0.000000e+00  6.000000e+00   \n",
       "DRUGTST2    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "DRUGTST3    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "DRUGRES1    9.500000e+01  9.500000e+01  0.000000e+00  9.500000e+01   \n",
       "DRUGRES2    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "DRUGRES3    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "HOSPITAL    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "P_SF1       0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "P_SF2       0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "P_SF3       0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "LOCATION    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "\n",
       "                  8             9           ...             153067  \\\n",
       "CASENUM     2.012104e+11  2.012104e+11      ...       2.012995e+11   \n",
       "VEH_NO      1.000000e+00  2.000000e+00      ...       4.000000e+00   \n",
       "PER_NO      2.000000e+00  1.000000e+00      ...       1.000000e+00   \n",
       "SEX_IM      2.000000e+00  2.000000e+00      ...       2.000000e+00   \n",
       "INJSEV_IM   0.000000e+00  1.000000e+00      ...       0.000000e+00   \n",
       "EJECT_IM    0.000000e+00  0.000000e+00      ...       0.000000e+00   \n",
       "PERALCH_IM  0.000000e+00  0.000000e+00      ...       0.000000e+00   \n",
       "SEAT_IM     1.300000e+01  1.100000e+01      ...       1.100000e+01   \n",
       "AGE_IM      3.200000e+01  2.000000e+01      ...       5.200000e+01   \n",
       "VE_FORMS    3.000000e+00  3.000000e+00      ...       4.000000e+00   \n",
       "WEIGHT      8.985326e+01  8.985326e+01      ...       9.984590e+01   \n",
       "REGION      1.000000e+00  1.000000e+00      ...       4.000000e+00   \n",
       "STRATUM     5.000000e+00  5.000000e+00      ...       6.000000e+00   \n",
       "PJ          1.000000e+01  1.000000e+01      ...       7.000000e+00   \n",
       "PSU         2.000000e+00  2.000000e+00      ...       7.900000e+01   \n",
       "PSUSTRAT    3.000000e+00  3.000000e+00      ...       1.000000e+01   \n",
       "STR_VEH     0.000000e+00  0.000000e+00      ...       0.000000e+00   \n",
       "MONTH       1.000000e+00  1.000000e+00      ...       1.000000e+00   \n",
       "HOUR        1.900000e+01  1.900000e+01      ...       8.000000e+00   \n",
       "MINUTE      5.500000e+01  5.500000e+01      ...       0.000000e+00   \n",
       "HARM_EV     1.100000e+01  1.100000e+01      ...       1.200000e+01   \n",
       "MAN_COLL    0.000000e+00  0.000000e+00      ...       7.000000e+00   \n",
       "SCH_BUS     0.000000e+00  0.000000e+00      ...       0.000000e+00   \n",
       "MAKE        4.900000e+01  6.300000e+01      ...       1.200000e+01   \n",
       "BODY_TYP    4.000000e+00  4.000000e+00      ...       3.100000e+01   \n",
       "MOD_YEAR    1.996000e+03  2.001000e+03      ...       2.011000e+03   \n",
       "TOW_VEH     0.000000e+00  0.000000e+00      ...       0.000000e+00   \n",
       "SPEC_USE    0.000000e+00  0.000000e+00      ...       0.000000e+00   \n",
       "EMER_USE    0.000000e+00  0.000000e+00      ...       0.000000e+00   \n",
       "ROLLOVER    0.000000e+00  0.000000e+00      ...       0.000000e+00   \n",
       "IMPACT1     1.200000e+01  6.000000e+00      ...       9.000000e+00   \n",
       "FIRE_EXP    0.000000e+00  0.000000e+00      ...       0.000000e+00   \n",
       "AGE         3.200000e+01  2.000000e+01      ...       5.200000e+01   \n",
       "SEX         2.000000e+00  2.000000e+00      ...       2.000000e+00   \n",
       "PER_TYP     2.000000e+00  1.000000e+00      ...       1.000000e+00   \n",
       "INJ_SEV     0.000000e+00  1.000000e+00      ...       0.000000e+00   \n",
       "SEAT_POS    1.300000e+01  1.100000e+01      ...       1.100000e+01   \n",
       "REST_USE    3.000000e+00  3.000000e+00      ...       3.000000e+00   \n",
       "REST_MIS    0.000000e+00  0.000000e+00      ...       0.000000e+00   \n",
       "AIR_BAG     9.800000e+01  9.800000e+01      ...       2.000000e+01   \n",
       "EJECTION    0.000000e+00  0.000000e+00      ...       7.000000e+00   \n",
       "DRINKING    8.000000e+00  0.000000e+00      ...       0.000000e+00   \n",
       "ALC_STATUS  0.000000e+00  8.000000e+00      ...       8.000000e+00   \n",
       "ATST_TYP    0.000000e+00  9.500000e+01      ...       9.500000e+01   \n",
       "ALC_RES     9.600000e+01  9.500000e+01      ...       9.500000e+01   \n",
       "DRUGS       8.000000e+00  0.000000e+00      ...       0.000000e+00   \n",
       "DSTATUS     0.000000e+00  8.000000e+00      ...       8.000000e+00   \n",
       "DRUGTST1    0.000000e+00  6.000000e+00      ...       6.000000e+00   \n",
       "DRUGTST2    0.000000e+00  0.000000e+00      ...       0.000000e+00   \n",
       "DRUGTST3    0.000000e+00  0.000000e+00      ...       0.000000e+00   \n",
       "DRUGRES1    0.000000e+00  9.500000e+01      ...       9.500000e+01   \n",
       "DRUGRES2    0.000000e+00  0.000000e+00      ...       0.000000e+00   \n",
       "DRUGRES3    0.000000e+00  0.000000e+00      ...       0.000000e+00   \n",
       "HOSPITAL    0.000000e+00  0.000000e+00      ...       0.000000e+00   \n",
       "P_SF1       0.000000e+00  0.000000e+00      ...       0.000000e+00   \n",
       "P_SF2       0.000000e+00  0.000000e+00      ...       0.000000e+00   \n",
       "P_SF3       0.000000e+00  0.000000e+00      ...       0.000000e+00   \n",
       "LOCATION    0.000000e+00  0.000000e+00      ...       0.000000e+00   \n",
       "\n",
       "                  153068        153069        153070        153071  \\\n",
       "CASENUM     2.012995e+11  2.012995e+11  2.012995e+11  2.012995e+11   \n",
       "VEH_NO      4.000000e+00  4.000000e+00  1.000000e+00  2.000000e+00   \n",
       "PER_NO      2.000000e+00  3.000000e+00  1.000000e+00  1.000000e+00   \n",
       "SEX_IM      1.000000e+00  1.000000e+00  2.000000e+00  2.000000e+00   \n",
       "INJSEV_IM   0.000000e+00  0.000000e+00  0.000000e+00  1.000000e+00   \n",
       "EJECT_IM    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "PERALCH_IM  0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "SEAT_IM     1.300000e+01  2.100000e+01  1.100000e+01  1.100000e+01   \n",
       "AGE_IM      1.300000e+01  1.000000e+01  1.900000e+01  5.900000e+01   \n",
       "VE_FORMS    4.000000e+00  4.000000e+00  3.000000e+00  3.000000e+00   \n",
       "WEIGHT      9.984590e+01  9.984590e+01  5.546994e+01  5.546994e+01   \n",
       "REGION      4.000000e+00  4.000000e+00  4.000000e+00  4.000000e+00   \n",
       "STRATUM     6.000000e+00  6.000000e+00  5.000000e+00  5.000000e+00   \n",
       "PJ          7.000000e+00  7.000000e+00  7.000000e+00  7.000000e+00   \n",
       "PSU         7.900000e+01  7.900000e+01  7.900000e+01  7.900000e+01   \n",
       "PSUSTRAT    1.000000e+01  1.000000e+01  1.000000e+01  1.000000e+01   \n",
       "STR_VEH     0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "MONTH       1.000000e+00  1.000000e+00  1.000000e+00  1.000000e+00   \n",
       "HOUR        8.000000e+00  8.000000e+00  7.000000e+00  7.000000e+00   \n",
       "MINUTE      0.000000e+00  0.000000e+00  5.000000e+01  5.000000e+01   \n",
       "HARM_EV     1.200000e+01  1.200000e+01  1.200000e+01  1.200000e+01   \n",
       "MAN_COLL    7.000000e+00  7.000000e+00  6.000000e+00  6.000000e+00   \n",
       "SCH_BUS     0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "MAKE        1.200000e+01  1.200000e+01  4.900000e+01  5.900000e+01   \n",
       "BODY_TYP    3.100000e+01  3.100000e+01  6.000000e+00  4.000000e+00   \n",
       "MOD_YEAR    2.011000e+03  2.011000e+03  9.999000e+03  2.007000e+03   \n",
       "TOW_VEH     0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "SPEC_USE    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "EMER_USE    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "ROLLOVER    0.000000e+00  0.000000e+00  1.000000e+00  0.000000e+00   \n",
       "IMPACT1     9.000000e+00  9.000000e+00  8.300000e+01  1.200000e+01   \n",
       "FIRE_EXP    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "AGE         1.300000e+01  1.000000e+01  1.900000e+01  5.900000e+01   \n",
       "SEX         1.000000e+00  1.000000e+00  2.000000e+00  2.000000e+00   \n",
       "PER_TYP     2.000000e+00  2.000000e+00  1.000000e+00  1.000000e+00   \n",
       "INJ_SEV     0.000000e+00  0.000000e+00  0.000000e+00  1.000000e+00   \n",
       "SEAT_POS    1.300000e+01  2.100000e+01  1.100000e+01  1.100000e+01   \n",
       "REST_USE    3.000000e+00  3.000000e+00  3.000000e+00  3.000000e+00   \n",
       "REST_MIS    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "AIR_BAG     2.000000e+01  2.000000e+01  9.000000e+00  9.000000e+00   \n",
       "EJECTION    0.000000e+00  0.000000e+00  7.000000e+00  0.000000e+00   \n",
       "DRINKING    8.000000e+00  8.000000e+00  0.000000e+00  0.000000e+00   \n",
       "ALC_STATUS  0.000000e+00  0.000000e+00  8.000000e+00  8.000000e+00   \n",
       "ATST_TYP    0.000000e+00  0.000000e+00  9.500000e+01  9.500000e+01   \n",
       "ALC_RES     9.600000e+01  9.600000e+01  9.500000e+01  9.500000e+01   \n",
       "DRUGS       8.000000e+00  8.000000e+00  0.000000e+00  0.000000e+00   \n",
       "DSTATUS     0.000000e+00  0.000000e+00  8.000000e+00  8.000000e+00   \n",
       "DRUGTST1    0.000000e+00  0.000000e+00  6.000000e+00  6.000000e+00   \n",
       "DRUGTST2    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "DRUGTST3    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "DRUGRES1    0.000000e+00  0.000000e+00  9.500000e+01  9.500000e+01   \n",
       "DRUGRES2    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "DRUGRES3    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "HOSPITAL    0.000000e+00  0.000000e+00  0.000000e+00  5.000000e+00   \n",
       "P_SF1       0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "P_SF2       0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "P_SF3       0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "LOCATION    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "\n",
       "                  153072        153073        153074        153075  \\\n",
       "CASENUM     2.012995e+11  2.012995e+11  2.012995e+11  2.012995e+11   \n",
       "VEH_NO      3.000000e+00  0.000000e+00  1.000000e+00  1.000000e+00   \n",
       "PER_NO      1.000000e+00  1.000000e+00  1.000000e+00  1.000000e+00   \n",
       "SEX_IM      1.000000e+00  2.000000e+00  1.000000e+00  1.000000e+00   \n",
       "INJSEV_IM   0.000000e+00  1.000000e+00  0.000000e+00  0.000000e+00   \n",
       "EJECT_IM    0.000000e+00  8.000000e+00  0.000000e+00  0.000000e+00   \n",
       "PERALCH_IM  0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "SEAT_IM     1.100000e+01  0.000000e+00  1.100000e+01  1.100000e+01   \n",
       "AGE_IM      4.900000e+01  4.300000e+01  5.200000e+01  2.800000e+01   \n",
       "VE_FORMS    3.000000e+00  1.000000e+00  1.000000e+00  2.000000e+00   \n",
       "WEIGHT      5.546994e+01  2.218798e+02  2.218798e+02  1.109399e+01   \n",
       "REGION      4.000000e+00  4.000000e+00  4.000000e+00  4.000000e+00   \n",
       "STRATUM     5.000000e+00  4.000000e+00  4.000000e+00  3.000000e+00   \n",
       "PJ          7.000000e+00  7.000000e+00  7.000000e+00  7.000000e+00   \n",
       "PSU         7.900000e+01  7.900000e+01  7.900000e+01  7.900000e+01   \n",
       "PSUSTRAT    1.000000e+01  1.000000e+01  1.000000e+01  1.000000e+01   \n",
       "STR_VEH     0.000000e+00  1.000000e+00  0.000000e+00  0.000000e+00   \n",
       "MONTH       1.000000e+00  4.000000e+00  4.000000e+00  7.000000e+00   \n",
       "HOUR        7.000000e+00  1.600000e+01  1.600000e+01  1.000000e+01   \n",
       "MINUTE      5.000000e+01  1.000000e+01  1.000000e+01  0.000000e+00   \n",
       "HARM_EV     1.200000e+01  8.000000e+00  8.000000e+00  1.200000e+01   \n",
       "MAN_COLL    6.000000e+00  0.000000e+00  0.000000e+00  6.000000e+00   \n",
       "SCH_BUS     0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "MAKE        1.200000e+01           NaN  2.000000e+01  2.000000e+01   \n",
       "BODY_TYP    3.100000e+01           NaN  3.100000e+01  2.100000e+01   \n",
       "MOD_YEAR    2.004000e+03           NaN  1.999000e+03  2.008000e+03   \n",
       "TOW_VEH     0.000000e+00           NaN  0.000000e+00  0.000000e+00   \n",
       "SPEC_USE    0.000000e+00           NaN  0.000000e+00  0.000000e+00   \n",
       "EMER_USE    0.000000e+00           NaN  0.000000e+00  0.000000e+00   \n",
       "ROLLOVER    0.000000e+00           NaN  0.000000e+00  0.000000e+00   \n",
       "IMPACT1     1.200000e+01           NaN  1.200000e+01  1.200000e+01   \n",
       "FIRE_EXP    0.000000e+00           NaN  0.000000e+00  0.000000e+00   \n",
       "AGE         4.900000e+01  4.300000e+01  5.200000e+01  2.800000e+01   \n",
       "SEX         1.000000e+00  2.000000e+00  1.000000e+00  1.000000e+00   \n",
       "PER_TYP     1.000000e+00  5.000000e+00  1.000000e+00  1.000000e+00   \n",
       "INJ_SEV     0.000000e+00  1.000000e+00  0.000000e+00  0.000000e+00   \n",
       "SEAT_POS    1.100000e+01  0.000000e+00  1.100000e+01  1.100000e+01   \n",
       "REST_USE    3.000000e+00  9.600000e+01  3.000000e+00  3.000000e+00   \n",
       "REST_MIS    0.000000e+00  8.000000e+00  0.000000e+00  0.000000e+00   \n",
       "AIR_BAG     2.000000e+01  9.700000e+01  2.000000e+01  2.000000e+01   \n",
       "EJECTION    7.000000e+00  8.000000e+00  0.000000e+00  7.000000e+00   \n",
       "DRINKING    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "ALC_STATUS  8.000000e+00  0.000000e+00  8.000000e+00  8.000000e+00   \n",
       "ATST_TYP    9.500000e+01  0.000000e+00  9.500000e+01  9.500000e+01   \n",
       "ALC_RES     9.500000e+01  9.600000e+01  9.500000e+01  9.500000e+01   \n",
       "DRUGS       0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "DSTATUS     8.000000e+00  0.000000e+00  8.000000e+00  8.000000e+00   \n",
       "DRUGTST1    6.000000e+00  0.000000e+00  6.000000e+00  6.000000e+00   \n",
       "DRUGTST2    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "DRUGTST3    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "DRUGRES1    9.500000e+01  0.000000e+00  9.500000e+01  9.500000e+01   \n",
       "DRUGRES2    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "DRUGRES3    0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "HOSPITAL    0.000000e+00  5.000000e+00  0.000000e+00  0.000000e+00   \n",
       "P_SF1       0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "P_SF2       0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "P_SF3       0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "LOCATION    0.000000e+00  1.100000e+01  0.000000e+00  0.000000e+00   \n",
       "\n",
       "                  153076  \n",
       "CASENUM     2.012995e+11  \n",
       "VEH_NO      2.000000e+00  \n",
       "PER_NO      1.000000e+00  \n",
       "SEX_IM      1.000000e+00  \n",
       "INJSEV_IM   2.000000e+00  \n",
       "EJECT_IM    0.000000e+00  \n",
       "PERALCH_IM  0.000000e+00  \n",
       "SEAT_IM     1.100000e+01  \n",
       "AGE_IM      7.600000e+01  \n",
       "VE_FORMS    2.000000e+00  \n",
       "WEIGHT      1.109399e+01  \n",
       "REGION      4.000000e+00  \n",
       "STRATUM     3.000000e+00  \n",
       "PJ          7.000000e+00  \n",
       "PSU         7.900000e+01  \n",
       "PSUSTRAT    1.000000e+01  \n",
       "STR_VEH     0.000000e+00  \n",
       "MONTH       7.000000e+00  \n",
       "HOUR        1.000000e+01  \n",
       "MINUTE      0.000000e+00  \n",
       "HARM_EV     1.200000e+01  \n",
       "MAN_COLL    6.000000e+00  \n",
       "SCH_BUS     0.000000e+00  \n",
       "MAKE        3.500000e+01  \n",
       "BODY_TYP    9.000000e+00  \n",
       "MOD_YEAR    1.994000e+03  \n",
       "TOW_VEH     0.000000e+00  \n",
       "SPEC_USE    0.000000e+00  \n",
       "EMER_USE    0.000000e+00  \n",
       "ROLLOVER    0.000000e+00  \n",
       "IMPACT1     1.100000e+01  \n",
       "FIRE_EXP    0.000000e+00  \n",
       "AGE         7.600000e+01  \n",
       "SEX         1.000000e+00  \n",
       "PER_TYP     1.000000e+00  \n",
       "INJ_SEV     2.000000e+00  \n",
       "SEAT_POS    1.100000e+01  \n",
       "REST_USE    3.000000e+00  \n",
       "REST_MIS    0.000000e+00  \n",
       "AIR_BAG     2.000000e+01  \n",
       "EJECTION    0.000000e+00  \n",
       "DRINKING    0.000000e+00  \n",
       "ALC_STATUS  8.000000e+00  \n",
       "ATST_TYP    9.500000e+01  \n",
       "ALC_RES     9.500000e+01  \n",
       "DRUGS       0.000000e+00  \n",
       "DSTATUS     8.000000e+00  \n",
       "DRUGTST1    6.000000e+00  \n",
       "DRUGTST2    0.000000e+00  \n",
       "DRUGTST3    0.000000e+00  \n",
       "DRUGRES1    9.500000e+01  \n",
       "DRUGRES2    0.000000e+00  \n",
       "DRUGRES3    0.000000e+00  \n",
       "HOSPITAL    0.000000e+00  \n",
       "P_SF1       0.000000e+00  \n",
       "P_SF2       0.000000e+00  \n",
       "P_SF3       0.000000e+00  \n",
       "LOCATION    0.000000e+00  \n",
       "\n",
       "[58 rows x 153077 columns]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "'''\n",
    "To transpose dataframe, input_data.T\n",
    "'''\n",
    "input_data.T"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#3: Data Cleaning. Most cumbersome!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    100840\n",
       "2     20758\n",
       "1     19380\n",
       "3      9738\n",
       "5      1179\n",
       "4      1178\n",
       "6         4\n",
       "Name: INJSEV_IM, dtype: int64"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "input_data.INJSEV_IM.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# Drop those odd cases\n",
    "input_data = input_data[input_data.INJSEV_IM != 6]\n",
    "\n",
    "for column_name in input_data.columns:\n",
    "    n_nans = input_data[column_name].isnull().sum()\n",
    "    if n_nans > 0:\n",
    "        print column_name, n_nans"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "print input_data.shape\n",
    "data = input_data[~input_data.MAKE.isnull()]\n",
    "discarded = data.pop('INJ_SEV')\n",
    "target = data.pop('INJSEV_IM')\n",
    "print data.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#4 Now we model"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "from sklearn.linear_model import LinearRegression\n",
    "from sklearn.metrics import roc_auc_score\n",
    "from sklearn.grid_search import GridSearchCV\n",
    "\n",
    "# Train on half of the data while reserving the other half for\n",
    "# model comparisons\n",
    "xtrain, xtest, ytrain, ytest = sklearn.cross_validation.train_test_split(\n",
    "    data.values, target.values, train_size=0.5)\n",
    "\n",
    "linreg = LinearRegression()\n",
    "linreg.fit(xtrain, ytrain)\n",
    "\n",
    "lr_preds = linreg.predict(xtest)\n",
    "lr_perf = roc_auc_score(ytest, lr_preds)\n",
    "print 'OLS: Area under the ROC curve = {}'.format(lr_perf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "OLS: Area under the ROC curve = 0.935139729907"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}