EDA.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The watermark extension is already loaded. To reload it, use:\n",
      "  %reload_ext watermark\n",
      "2017-05-08 \n",
      "\n",
      "CPython 3.5.2\n",
      "IPython 5.1.0\n",
      "\n",
      "pandas 0.18.1\n",
      "\n",
      "compiler   : GCC 4.2.1 Compatible Apple LLVM 4.2 (clang-425.0.28)\n",
      "system     : Darwin\n",
      "release    : 16.5.0\n",
      "machine    : x86_64\n",
      "processor  : i386\n",
      "CPU cores  : 4\n",
      "interpreter: 64bit\n"
     ]
    }
   ],
   "source": [
    "%load_ext watermark\n",
    "%watermark -d -v -m -p pandas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import glob"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Read Microseismicity events"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "path ='../data/microseismic_and_blasting_2009_2016/' # use your path\n",
    "allEvents = glob.glob(path + \"/*events.csv\")\n",
    "allBlasts = glob.glob(path + \"/*blasts.csv\")\n",
    "\n",
    "frameEvents = pd.DataFrame()\n",
    "list_ = []\n",
    "for file_ in allEvents:\n",
    "    df = pd.read_csv(file_,index_col=None, header=0)\n",
    "    list_.append(df)\n",
    "frameEvents = pd.concat(list_)\n",
    "\n",
    "frameBlasts = pd.DataFrame()\n",
    "list_ = []\n",
    "for file in allBlasts:\n",
    "    df = pd.read_csv(file_,index_col=None, header=0)\n",
    "    list_.append(df)\n",
    "frameBlasts = pd.concat(list_)\n",
    "\n",
    "frames = [frameEvents,frameBlasts]\n",
    "frame = pd.concat(frames)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "n    1185824\n",
       "e     779955\n",
       "u        425\n",
       "a         15\n",
       "Name: Type, dtype: int64"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "frame['Type'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\u001b[31m../data/microseismic and blasting 2009-2016/2016events.csv\u001b[m\u001b[m*\r\n"
     ]
    }
   ],
   "source": [
    "ls ../data/microseismic_and_blasting_2009_2016/"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date(y/m/d)</th>\n",
       "      <th>Time(H:M:S)</th>\n",
       "      <th>MilliSec</th>\n",
       "      <th>Type</th>\n",
       "      <th>Northing</th>\n",
       "      <th>Easting</th>\n",
       "      <th>Depth</th>\n",
       "      <th>NN_Err</th>\n",
       "      <th>EE_Err</th>\n",
       "      <th>DD_Err</th>\n",
       "      <th>...</th>\n",
       "      <th>Es/Ep</th>\n",
       "      <th>SourceRo</th>\n",
       "      <th>AspRadius</th>\n",
       "      <th>StaticSD</th>\n",
       "      <th>AppStress</th>\n",
       "      <th>DyStressD</th>\n",
       "      <th>MaxDispla</th>\n",
       "      <th>PeakVelPar</th>\n",
       "      <th>PeakAccPar</th>\n",
       "      <th>Unnamed: 24</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2009/01/28</td>\n",
       "      <td>14:58:30</td>\n",
       "      <td>154</td>\n",
       "      <td>n</td>\n",
       "      <td>10151.63</td>\n",
       "      <td>10346.47</td>\n",
       "      <td>3098.37</td>\n",
       "      <td>23.86</td>\n",
       "      <td>8.01</td>\n",
       "      <td>11.85</td>\n",
       "      <td>...</td>\n",
       "      <td>4.18</td>\n",
       "      <td>0.93</td>\n",
       "      <td>0.56</td>\n",
       "      <td>960305.56</td>\n",
       "      <td>53866.10</td>\n",
       "      <td>827017.75</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>66841.81</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2009/01/28</td>\n",
       "      <td>14:59:56</td>\n",
       "      <td>872</td>\n",
       "      <td>e</td>\n",
       "      <td>10127.32</td>\n",
       "      <td>10308.23</td>\n",
       "      <td>2620.29</td>\n",
       "      <td>67.67</td>\n",
       "      <td>16.63</td>\n",
       "      <td>29.62</td>\n",
       "      <td>...</td>\n",
       "      <td>2.06</td>\n",
       "      <td>2.85</td>\n",
       "      <td>0.69</td>\n",
       "      <td>32582.77</td>\n",
       "      <td>1990.87</td>\n",
       "      <td>171515.97</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>15204.68</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2009/01/28</td>\n",
       "      <td>15:00:31</td>\n",
       "      <td>904</td>\n",
       "      <td>n</td>\n",
       "      <td>10144.80</td>\n",
       "      <td>10330.61</td>\n",
       "      <td>3103.87</td>\n",
       "      <td>90.94</td>\n",
       "      <td>18.55</td>\n",
       "      <td>38.43</td>\n",
       "      <td>...</td>\n",
       "      <td>15.31</td>\n",
       "      <td>2.70</td>\n",
       "      <td>4.42</td>\n",
       "      <td>1841950.50</td>\n",
       "      <td>169490.97</td>\n",
       "      <td>8505005.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1.12</td>\n",
       "      <td>830952.19</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2009/01/28</td>\n",
       "      <td>15:01:29</td>\n",
       "      <td>443</td>\n",
       "      <td>e</td>\n",
       "      <td>10008.00</td>\n",
       "      <td>10236.90</td>\n",
       "      <td>3082.62</td>\n",
       "      <td>13.45</td>\n",
       "      <td>4.49</td>\n",
       "      <td>7.21</td>\n",
       "      <td>...</td>\n",
       "      <td>1.38</td>\n",
       "      <td>1.45</td>\n",
       "      <td>0.53</td>\n",
       "      <td>337241.63</td>\n",
       "      <td>10414.42</td>\n",
       "      <td>501905.66</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>43154.95</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2009/01/28</td>\n",
       "      <td>15:11:21</td>\n",
       "      <td>191</td>\n",
       "      <td>e</td>\n",
       "      <td>10006.04</td>\n",
       "      <td>10234.48</td>\n",
       "      <td>3082.73</td>\n",
       "      <td>10.76</td>\n",
       "      <td>3.58</td>\n",
       "      <td>5.81</td>\n",
       "      <td>...</td>\n",
       "      <td>0.49</td>\n",
       "      <td>1.52</td>\n",
       "      <td>0.40</td>\n",
       "      <td>226187.47</td>\n",
       "      <td>6157.43</td>\n",
       "      <td>499342.22</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>44361.63</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2009/01/28</td>\n",
       "      <td>15:12:10</td>\n",
       "      <td>670</td>\n",
       "      <td>n</td>\n",
       "      <td>10132.89</td>\n",
       "      <td>10343.98</td>\n",
       "      <td>3100.33</td>\n",
       "      <td>21.06</td>\n",
       "      <td>7.96</td>\n",
       "      <td>9.49</td>\n",
       "      <td>...</td>\n",
       "      <td>3.16</td>\n",
       "      <td>1.57</td>\n",
       "      <td>0.93</td>\n",
       "      <td>488801.53</td>\n",
       "      <td>19782.07</td>\n",
       "      <td>486382.09</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>50996.20</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2009/01/28</td>\n",
       "      <td>22:34:02</td>\n",
       "      <td>245</td>\n",
       "      <td>e</td>\n",
       "      <td>9974.08</td>\n",
       "      <td>10144.34</td>\n",
       "      <td>3098.28</td>\n",
       "      <td>38.71</td>\n",
       "      <td>9.99</td>\n",
       "      <td>17.68</td>\n",
       "      <td>...</td>\n",
       "      <td>3.36</td>\n",
       "      <td>2.57</td>\n",
       "      <td>0.61</td>\n",
       "      <td>105212.33</td>\n",
       "      <td>4630.88</td>\n",
       "      <td>427606.06</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>36742.85</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2009/01/28</td>\n",
       "      <td>22:46:24</td>\n",
       "      <td>380</td>\n",
       "      <td>e</td>\n",
       "      <td>10156.98</td>\n",
       "      <td>9957.34</td>\n",
       "      <td>3041.54</td>\n",
       "      <td>43.37</td>\n",
       "      <td>15.11</td>\n",
       "      <td>27.63</td>\n",
       "      <td>...</td>\n",
       "      <td>8.40</td>\n",
       "      <td>1.57</td>\n",
       "      <td>0.90</td>\n",
       "      <td>741688.13</td>\n",
       "      <td>48755.10</td>\n",
       "      <td>1196740.75</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>112214.88</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2009/01/28</td>\n",
       "      <td>22:55:05</td>\n",
       "      <td>356</td>\n",
       "      <td>e</td>\n",
       "      <td>10148.50</td>\n",
       "      <td>9958.03</td>\n",
       "      <td>3059.75</td>\n",
       "      <td>9.50</td>\n",
       "      <td>3.35</td>\n",
       "      <td>5.32</td>\n",
       "      <td>...</td>\n",
       "      <td>6.06</td>\n",
       "      <td>1.72</td>\n",
       "      <td>0.41</td>\n",
       "      <td>320383.31</td>\n",
       "      <td>19074.81</td>\n",
       "      <td>1214091.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>123405.10</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2009/01/28</td>\n",
       "      <td>23:06:25</td>\n",
       "      <td>166</td>\n",
       "      <td>e</td>\n",
       "      <td>10146.10</td>\n",
       "      <td>9957.69</td>\n",
       "      <td>3058.05</td>\n",
       "      <td>30.25</td>\n",
       "      <td>10.09</td>\n",
       "      <td>16.71</td>\n",
       "      <td>...</td>\n",
       "      <td>3.04</td>\n",
       "      <td>1.66</td>\n",
       "      <td>0.38</td>\n",
       "      <td>419159.38</td>\n",
       "      <td>16583.20</td>\n",
       "      <td>1075391.75</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>123167.91</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2009/01/29</td>\n",
       "      <td>00:02:01</td>\n",
       "      <td>657</td>\n",
       "      <td>e</td>\n",
       "      <td>10158.69</td>\n",
       "      <td>9955.60</td>\n",
       "      <td>3054.40</td>\n",
       "      <td>19.51</td>\n",
       "      <td>5.33</td>\n",
       "      <td>8.88</td>\n",
       "      <td>...</td>\n",
       "      <td>4.77</td>\n",
       "      <td>1.79</td>\n",
       "      <td>0.49</td>\n",
       "      <td>246394.78</td>\n",
       "      <td>11598.21</td>\n",
       "      <td>703487.06</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>76777.50</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2009/01/29</td>\n",
       "      <td>01:14:18</td>\n",
       "      <td>24</td>\n",
       "      <td>e</td>\n",
       "      <td>10273.37</td>\n",
       "      <td>10327.30</td>\n",
       "      <td>3030.34</td>\n",
       "      <td>47.65</td>\n",
       "      <td>25.70</td>\n",
       "      <td>49.57</td>\n",
       "      <td>...</td>\n",
       "      <td>2.15</td>\n",
       "      <td>1.41</td>\n",
       "      <td>0.59</td>\n",
       "      <td>257231.59</td>\n",
       "      <td>11109.61</td>\n",
       "      <td>266017.22</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>23750.35</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2009/01/30</td>\n",
       "      <td>20:15:17</td>\n",
       "      <td>587</td>\n",
       "      <td>e</td>\n",
       "      <td>10001.35</td>\n",
       "      <td>10050.70</td>\n",
       "      <td>3150.42</td>\n",
       "      <td>3.07</td>\n",
       "      <td>1.91</td>\n",
       "      <td>4.42</td>\n",
       "      <td>...</td>\n",
       "      <td>22.25</td>\n",
       "      <td>0.67</td>\n",
       "      <td>0.61</td>\n",
       "      <td>2213762.50</td>\n",
       "      <td>165204.72</td>\n",
       "      <td>2277209.75</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>190779.80</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2009/01/31</td>\n",
       "      <td>07:28:19</td>\n",
       "      <td>115</td>\n",
       "      <td>e</td>\n",
       "      <td>10303.29</td>\n",
       "      <td>10346.57</td>\n",
       "      <td>3036.89</td>\n",
       "      <td>21.45</td>\n",
       "      <td>7.65</td>\n",
       "      <td>27.51</td>\n",
       "      <td>...</td>\n",
       "      <td>10.60</td>\n",
       "      <td>1.74</td>\n",
       "      <td>0.71</td>\n",
       "      <td>452050.13</td>\n",
       "      <td>33475.25</td>\n",
       "      <td>981628.50</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>98489.67</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2009/01/31</td>\n",
       "      <td>11:10:41</td>\n",
       "      <td>44</td>\n",
       "      <td>n</td>\n",
       "      <td>10150.92</td>\n",
       "      <td>10179.48</td>\n",
       "      <td>3030.32</td>\n",
       "      <td>14.13</td>\n",
       "      <td>11.96</td>\n",
       "      <td>25.29</td>\n",
       "      <td>...</td>\n",
       "      <td>16.05</td>\n",
       "      <td>0.84</td>\n",
       "      <td>0.62</td>\n",
       "      <td>539904.44</td>\n",
       "      <td>50340.05</td>\n",
       "      <td>658995.44</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>74881.02</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2009/01/31</td>\n",
       "      <td>12:04:06</td>\n",
       "      <td>566</td>\n",
       "      <td>e</td>\n",
       "      <td>10150.74</td>\n",
       "      <td>10183.47</td>\n",
       "      <td>3078.39</td>\n",
       "      <td>15.00</td>\n",
       "      <td>15.04</td>\n",
       "      <td>23.97</td>\n",
       "      <td>...</td>\n",
       "      <td>2.06</td>\n",
       "      <td>0.49</td>\n",
       "      <td>0.66</td>\n",
       "      <td>4576993.00</td>\n",
       "      <td>208421.55</td>\n",
       "      <td>1555793.75</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>200166.63</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2009/01/31</td>\n",
       "      <td>12:19:20</td>\n",
       "      <td>224</td>\n",
       "      <td>e</td>\n",
       "      <td>10151.70</td>\n",
       "      <td>10169.00</td>\n",
       "      <td>3057.41</td>\n",
       "      <td>9.06</td>\n",
       "      <td>9.15</td>\n",
       "      <td>14.44</td>\n",
       "      <td>...</td>\n",
       "      <td>182.62</td>\n",
       "      <td>0.91</td>\n",
       "      <td>0.60</td>\n",
       "      <td>545677.50</td>\n",
       "      <td>62017.79</td>\n",
       "      <td>1306208.13</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>150232.95</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2009/01/31</td>\n",
       "      <td>22:52:21</td>\n",
       "      <td>422</td>\n",
       "      <td>e</td>\n",
       "      <td>10165.58</td>\n",
       "      <td>10346.03</td>\n",
       "      <td>3083.20</td>\n",
       "      <td>10.29</td>\n",
       "      <td>4.95</td>\n",
       "      <td>5.65</td>\n",
       "      <td>...</td>\n",
       "      <td>2.55</td>\n",
       "      <td>1.60</td>\n",
       "      <td>0.69</td>\n",
       "      <td>435493.97</td>\n",
       "      <td>16238.35</td>\n",
       "      <td>594276.63</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>50954.04</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2009/01/31</td>\n",
       "      <td>22:54:00</td>\n",
       "      <td>669</td>\n",
       "      <td>e</td>\n",
       "      <td>10176.75</td>\n",
       "      <td>10348.67</td>\n",
       "      <td>3060.97</td>\n",
       "      <td>9.76</td>\n",
       "      <td>2.65</td>\n",
       "      <td>7.54</td>\n",
       "      <td>...</td>\n",
       "      <td>6.85</td>\n",
       "      <td>0.73</td>\n",
       "      <td>0.50</td>\n",
       "      <td>1243412.25</td>\n",
       "      <td>66201.84</td>\n",
       "      <td>779625.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>67549.67</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2009/01/31</td>\n",
       "      <td>22:58:23</td>\n",
       "      <td>614</td>\n",
       "      <td>e</td>\n",
       "      <td>10264.26</td>\n",
       "      <td>10363.49</td>\n",
       "      <td>2963.24</td>\n",
       "      <td>34.00</td>\n",
       "      <td>13.47</td>\n",
       "      <td>74.05</td>\n",
       "      <td>...</td>\n",
       "      <td>13.27</td>\n",
       "      <td>0.98</td>\n",
       "      <td>0.72</td>\n",
       "      <td>632010.31</td>\n",
       "      <td>36355.68</td>\n",
       "      <td>693345.06</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>71440.38</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2009/02/01</td>\n",
       "      <td>07:39:05</td>\n",
       "      <td>788</td>\n",
       "      <td>e</td>\n",
       "      <td>9946.61</td>\n",
       "      <td>10205.37</td>\n",
       "      <td>3081.42</td>\n",
       "      <td>40.12</td>\n",
       "      <td>10.53</td>\n",
       "      <td>24.94</td>\n",
       "      <td>...</td>\n",
       "      <td>6.43</td>\n",
       "      <td>1.44</td>\n",
       "      <td>0.57</td>\n",
       "      <td>127858.58</td>\n",
       "      <td>7591.25</td>\n",
       "      <td>309495.47</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>32517.12</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2009/02/01</td>\n",
       "      <td>14:08:16</td>\n",
       "      <td>106</td>\n",
       "      <td>e</td>\n",
       "      <td>10224.76</td>\n",
       "      <td>10102.28</td>\n",
       "      <td>2715.83</td>\n",
       "      <td>31.63</td>\n",
       "      <td>21.90</td>\n",
       "      <td>17.60</td>\n",
       "      <td>...</td>\n",
       "      <td>5.73</td>\n",
       "      <td>2.61</td>\n",
       "      <td>0.77</td>\n",
       "      <td>644529.75</td>\n",
       "      <td>24424.95</td>\n",
       "      <td>2460795.50</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>163601.13</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2009/02/01</td>\n",
       "      <td>19:14:45</td>\n",
       "      <td>595</td>\n",
       "      <td>e</td>\n",
       "      <td>10102.07</td>\n",
       "      <td>10026.08</td>\n",
       "      <td>2955.96</td>\n",
       "      <td>47.97</td>\n",
       "      <td>20.44</td>\n",
       "      <td>13.55</td>\n",
       "      <td>...</td>\n",
       "      <td>30.07</td>\n",
       "      <td>0.49</td>\n",
       "      <td>0.67</td>\n",
       "      <td>5716290.00</td>\n",
       "      <td>458720.03</td>\n",
       "      <td>2254723.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>189659.42</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2009/02/02</td>\n",
       "      <td>05:38:57</td>\n",
       "      <td>73</td>\n",
       "      <td>e</td>\n",
       "      <td>9998.62</td>\n",
       "      <td>10049.83</td>\n",
       "      <td>3195.91</td>\n",
       "      <td>4.98</td>\n",
       "      <td>3.20</td>\n",
       "      <td>4.77</td>\n",
       "      <td>...</td>\n",
       "      <td>2.93</td>\n",
       "      <td>0.51</td>\n",
       "      <td>0.60</td>\n",
       "      <td>16865670.00</td>\n",
       "      <td>879968.00</td>\n",
       "      <td>5057313.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.02</td>\n",
       "      <td>415500.28</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2009/02/04</td>\n",
       "      <td>15:52:25</td>\n",
       "      <td>462</td>\n",
       "      <td>e</td>\n",
       "      <td>10318.39</td>\n",
       "      <td>10192.71</td>\n",
       "      <td>2658.10</td>\n",
       "      <td>110.43</td>\n",
       "      <td>26.47</td>\n",
       "      <td>158.30</td>\n",
       "      <td>...</td>\n",
       "      <td>4.49</td>\n",
       "      <td>3.01</td>\n",
       "      <td>0.97</td>\n",
       "      <td>214037.55</td>\n",
       "      <td>6753.37</td>\n",
       "      <td>817230.13</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>97644.58</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2009/02/04</td>\n",
       "      <td>18:05:16</td>\n",
       "      <td>235</td>\n",
       "      <td>e</td>\n",
       "      <td>9996.61</td>\n",
       "      <td>10058.46</td>\n",
       "      <td>3000.19</td>\n",
       "      <td>10.08</td>\n",
       "      <td>8.31</td>\n",
       "      <td>7.19</td>\n",
       "      <td>...</td>\n",
       "      <td>9.21</td>\n",
       "      <td>0.58</td>\n",
       "      <td>0.50</td>\n",
       "      <td>5083720.50</td>\n",
       "      <td>273187.94</td>\n",
       "      <td>2381671.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>184809.42</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2009/02/04</td>\n",
       "      <td>20:06:08</td>\n",
       "      <td>103</td>\n",
       "      <td>e</td>\n",
       "      <td>9992.74</td>\n",
       "      <td>10241.26</td>\n",
       "      <td>3065.38</td>\n",
       "      <td>50.65</td>\n",
       "      <td>18.89</td>\n",
       "      <td>24.39</td>\n",
       "      <td>...</td>\n",
       "      <td>16.87</td>\n",
       "      <td>1.44</td>\n",
       "      <td>0.66</td>\n",
       "      <td>417008.88</td>\n",
       "      <td>23637.27</td>\n",
       "      <td>974082.69</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>96146.00</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2009/02/04</td>\n",
       "      <td>20:54:07</td>\n",
       "      <td>986</td>\n",
       "      <td>e</td>\n",
       "      <td>10367.91</td>\n",
       "      <td>10246.35</td>\n",
       "      <td>2844.88</td>\n",
       "      <td>12.73</td>\n",
       "      <td>22.80</td>\n",
       "      <td>15.32</td>\n",
       "      <td>...</td>\n",
       "      <td>5.71</td>\n",
       "      <td>2.08</td>\n",
       "      <td>1.05</td>\n",
       "      <td>831600.69</td>\n",
       "      <td>34059.37</td>\n",
       "      <td>1667771.63</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>135078.09</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2009/02/04</td>\n",
       "      <td>22:37:05</td>\n",
       "      <td>878</td>\n",
       "      <td>u</td>\n",
       "      <td>10249.61</td>\n",
       "      <td>10229.24</td>\n",
       "      <td>2965.56</td>\n",
       "      <td>74.27</td>\n",
       "      <td>20.40</td>\n",
       "      <td>20.59</td>\n",
       "      <td>...</td>\n",
       "      <td>15.22</td>\n",
       "      <td>2.90</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2854647.25</td>\n",
       "      <td>213526.48</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.05</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2009/02/05</td>\n",
       "      <td>06:34:15</td>\n",
       "      <td>841</td>\n",
       "      <td>e</td>\n",
       "      <td>10250.11</td>\n",
       "      <td>10204.96</td>\n",
       "      <td>2691.13</td>\n",
       "      <td>17.10</td>\n",
       "      <td>10.04</td>\n",
       "      <td>12.95</td>\n",
       "      <td>...</td>\n",
       "      <td>3.85</td>\n",
       "      <td>2.86</td>\n",
       "      <td>1.03</td>\n",
       "      <td>68189.24</td>\n",
       "      <td>3276.90</td>\n",
       "      <td>183998.38</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>14906.63</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>2009/02/06</td>\n",
       "      <td>15:21:47</td>\n",
       "      <td>281</td>\n",
       "      <td>e</td>\n",
       "      <td>10037.64</td>\n",
       "      <td>10023.72</td>\n",
       "      <td>3023.31</td>\n",
       "      <td>15.02</td>\n",
       "      <td>18.07</td>\n",
       "      <td>12.57</td>\n",
       "      <td>...</td>\n",
       "      <td>3.70</td>\n",
       "      <td>1.65</td>\n",
       "      <td>0.52</td>\n",
       "      <td>375772.53</td>\n",
       "      <td>12670.07</td>\n",
       "      <td>668995.88</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>70972.84</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>2009/02/07</td>\n",
       "      <td>02:39:09</td>\n",
       "      <td>701</td>\n",
       "      <td>e</td>\n",
       "      <td>10288.42</td>\n",
       "      <td>10053.56</td>\n",
       "      <td>2672.99</td>\n",
       "      <td>58.56</td>\n",
       "      <td>42.31</td>\n",
       "      <td>86.14</td>\n",
       "      <td>...</td>\n",
       "      <td>0.49</td>\n",
       "      <td>1.09</td>\n",
       "      <td>0.73</td>\n",
       "      <td>911915.63</td>\n",
       "      <td>61874.09</td>\n",
       "      <td>859208.31</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>71924.39</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>2009/02/07</td>\n",
       "      <td>09:58:41</td>\n",
       "      <td>219</td>\n",
       "      <td>e</td>\n",
       "      <td>9991.96</td>\n",
       "      <td>10054.29</td>\n",
       "      <td>2952.81</td>\n",
       "      <td>6.25</td>\n",
       "      <td>3.55</td>\n",
       "      <td>2.60</td>\n",
       "      <td>...</td>\n",
       "      <td>2.55</td>\n",
       "      <td>4.00</td>\n",
       "      <td>1.03</td>\n",
       "      <td>895711.63</td>\n",
       "      <td>38608.79</td>\n",
       "      <td>4611073.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>302129.13</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>2009/02/07</td>\n",
       "      <td>22:46:26</td>\n",
       "      <td>258</td>\n",
       "      <td>e</td>\n",
       "      <td>9946.29</td>\n",
       "      <td>10035.08</td>\n",
       "      <td>2870.26</td>\n",
       "      <td>15.11</td>\n",
       "      <td>14.47</td>\n",
       "      <td>13.64</td>\n",
       "      <td>...</td>\n",
       "      <td>3.34</td>\n",
       "      <td>1.22</td>\n",
       "      <td>0.55</td>\n",
       "      <td>1003752.25</td>\n",
       "      <td>49820.25</td>\n",
       "      <td>1576861.13</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>145229.41</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>2009/02/08</td>\n",
       "      <td>06:33:49</td>\n",
       "      <td>427</td>\n",
       "      <td>e</td>\n",
       "      <td>10336.66</td>\n",
       "      <td>10213.86</td>\n",
       "      <td>2715.57</td>\n",
       "      <td>88.89</td>\n",
       "      <td>15.96</td>\n",
       "      <td>99.28</td>\n",
       "      <td>...</td>\n",
       "      <td>2.42</td>\n",
       "      <td>3.41</td>\n",
       "      <td>0.88</td>\n",
       "      <td>365822.72</td>\n",
       "      <td>12280.87</td>\n",
       "      <td>820964.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>75993.69</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>2009/02/08</td>\n",
       "      <td>06:37:04</td>\n",
       "      <td>458</td>\n",
       "      <td>e</td>\n",
       "      <td>10304.97</td>\n",
       "      <td>10226.21</td>\n",
       "      <td>2654.36</td>\n",
       "      <td>74.74</td>\n",
       "      <td>15.18</td>\n",
       "      <td>127.46</td>\n",
       "      <td>...</td>\n",
       "      <td>0.99</td>\n",
       "      <td>1.97</td>\n",
       "      <td>0.79</td>\n",
       "      <td>614572.44</td>\n",
       "      <td>46816.17</td>\n",
       "      <td>959851.56</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>66490.89</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>2009/02/08</td>\n",
       "      <td>06:39:47</td>\n",
       "      <td>438</td>\n",
       "      <td>e</td>\n",
       "      <td>10312.79</td>\n",
       "      <td>10254.15</td>\n",
       "      <td>2740.12</td>\n",
       "      <td>89.42</td>\n",
       "      <td>26.56</td>\n",
       "      <td>90.24</td>\n",
       "      <td>...</td>\n",
       "      <td>2.54</td>\n",
       "      <td>2.11</td>\n",
       "      <td>0.76</td>\n",
       "      <td>1067109.50</td>\n",
       "      <td>33620.00</td>\n",
       "      <td>1068604.88</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>89424.30</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>2009/02/08</td>\n",
       "      <td>06:39:52</td>\n",
       "      <td>344</td>\n",
       "      <td>e</td>\n",
       "      <td>10192.14</td>\n",
       "      <td>10229.59</td>\n",
       "      <td>2817.84</td>\n",
       "      <td>46.64</td>\n",
       "      <td>8.64</td>\n",
       "      <td>44.35</td>\n",
       "      <td>...</td>\n",
       "      <td>1.12</td>\n",
       "      <td>1.75</td>\n",
       "      <td>0.96</td>\n",
       "      <td>172730.33</td>\n",
       "      <td>3010.45</td>\n",
       "      <td>220595.75</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>20106.01</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>2009/02/08</td>\n",
       "      <td>06:42:08</td>\n",
       "      <td>796</td>\n",
       "      <td>e</td>\n",
       "      <td>10249.48</td>\n",
       "      <td>10220.39</td>\n",
       "      <td>2738.07</td>\n",
       "      <td>94.24</td>\n",
       "      <td>18.77</td>\n",
       "      <td>144.06</td>\n",
       "      <td>...</td>\n",
       "      <td>1.41</td>\n",
       "      <td>1.15</td>\n",
       "      <td>0.55</td>\n",
       "      <td>475009.63</td>\n",
       "      <td>14103.82</td>\n",
       "      <td>341334.84</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>28653.42</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>2009/02/08</td>\n",
       "      <td>06:54:48</td>\n",
       "      <td>879</td>\n",
       "      <td>e</td>\n",
       "      <td>10276.62</td>\n",
       "      <td>10012.65</td>\n",
       "      <td>2600.12</td>\n",
       "      <td>24.32</td>\n",
       "      <td>29.69</td>\n",
       "      <td>65.35</td>\n",
       "      <td>...</td>\n",
       "      <td>0.24</td>\n",
       "      <td>1.63</td>\n",
       "      <td>0.84</td>\n",
       "      <td>616927.38</td>\n",
       "      <td>70683.98</td>\n",
       "      <td>913539.88</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>89846.95</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>2009/02/08</td>\n",
       "      <td>06:57:07</td>\n",
       "      <td>730</td>\n",
       "      <td>e</td>\n",
       "      <td>10225.49</td>\n",
       "      <td>10221.30</td>\n",
       "      <td>2745.34</td>\n",
       "      <td>42.33</td>\n",
       "      <td>9.97</td>\n",
       "      <td>68.86</td>\n",
       "      <td>...</td>\n",
       "      <td>4.12</td>\n",
       "      <td>2.85</td>\n",
       "      <td>0.92</td>\n",
       "      <td>165977.03</td>\n",
       "      <td>6043.31</td>\n",
       "      <td>310043.88</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>25345.17</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>2009/02/08</td>\n",
       "      <td>07:22:19</td>\n",
       "      <td>771</td>\n",
       "      <td>e</td>\n",
       "      <td>10097.42</td>\n",
       "      <td>9846.77</td>\n",
       "      <td>2589.60</td>\n",
       "      <td>39.99</td>\n",
       "      <td>59.15</td>\n",
       "      <td>77.34</td>\n",
       "      <td>...</td>\n",
       "      <td>0.26</td>\n",
       "      <td>2.39</td>\n",
       "      <td>0.78</td>\n",
       "      <td>544436.31</td>\n",
       "      <td>31622.19</td>\n",
       "      <td>1233536.13</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>102763.63</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>2009/02/08</td>\n",
       "      <td>10:06:08</td>\n",
       "      <td>661</td>\n",
       "      <td>e</td>\n",
       "      <td>10388.62</td>\n",
       "      <td>10350.95</td>\n",
       "      <td>2862.61</td>\n",
       "      <td>105.13</td>\n",
       "      <td>48.97</td>\n",
       "      <td>34.65</td>\n",
       "      <td>...</td>\n",
       "      <td>1.97</td>\n",
       "      <td>3.49</td>\n",
       "      <td>0.82</td>\n",
       "      <td>230120.48</td>\n",
       "      <td>8968.11</td>\n",
       "      <td>661800.56</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>44431.28</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>2009/02/08</td>\n",
       "      <td>14:37:49</td>\n",
       "      <td>353</td>\n",
       "      <td>e</td>\n",
       "      <td>10311.08</td>\n",
       "      <td>10136.13</td>\n",
       "      <td>2876.82</td>\n",
       "      <td>16.01</td>\n",
       "      <td>6.91</td>\n",
       "      <td>9.62</td>\n",
       "      <td>...</td>\n",
       "      <td>7.87</td>\n",
       "      <td>4.47</td>\n",
       "      <td>0.78</td>\n",
       "      <td>60433.39</td>\n",
       "      <td>3610.43</td>\n",
       "      <td>511706.72</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>38395.36</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>2009/02/08</td>\n",
       "      <td>15:36:01</td>\n",
       "      <td>256</td>\n",
       "      <td>e</td>\n",
       "      <td>10294.75</td>\n",
       "      <td>10139.45</td>\n",
       "      <td>2881.74</td>\n",
       "      <td>26.61</td>\n",
       "      <td>11.97</td>\n",
       "      <td>15.46</td>\n",
       "      <td>...</td>\n",
       "      <td>3.35</td>\n",
       "      <td>2.36</td>\n",
       "      <td>0.79</td>\n",
       "      <td>376994.69</td>\n",
       "      <td>11024.27</td>\n",
       "      <td>561353.69</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>46623.26</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>2009/02/08</td>\n",
       "      <td>20:33:39</td>\n",
       "      <td>508</td>\n",
       "      <td>e</td>\n",
       "      <td>10009.90</td>\n",
       "      <td>10048.74</td>\n",
       "      <td>2993.15</td>\n",
       "      <td>17.14</td>\n",
       "      <td>10.53</td>\n",
       "      <td>8.11</td>\n",
       "      <td>...</td>\n",
       "      <td>173.27</td>\n",
       "      <td>0.60</td>\n",
       "      <td>0.81</td>\n",
       "      <td>7892865.50</td>\n",
       "      <td>447978.66</td>\n",
       "      <td>4116630.50</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.02</td>\n",
       "      <td>296266.13</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>2009/02/08</td>\n",
       "      <td>22:51:23</td>\n",
       "      <td>350</td>\n",
       "      <td>e</td>\n",
       "      <td>10247.65</td>\n",
       "      <td>10331.15</td>\n",
       "      <td>3081.33</td>\n",
       "      <td>9.37</td>\n",
       "      <td>6.58</td>\n",
       "      <td>6.13</td>\n",
       "      <td>...</td>\n",
       "      <td>4.21</td>\n",
       "      <td>6.27</td>\n",
       "      <td>1.15</td>\n",
       "      <td>447919.63</td>\n",
       "      <td>19526.96</td>\n",
       "      <td>2338621.25</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.02</td>\n",
       "      <td>185340.02</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>2009/02/08</td>\n",
       "      <td>23:04:00</td>\n",
       "      <td>619</td>\n",
       "      <td>e</td>\n",
       "      <td>10103.85</td>\n",
       "      <td>9859.10</td>\n",
       "      <td>2578.21</td>\n",
       "      <td>47.25</td>\n",
       "      <td>58.12</td>\n",
       "      <td>78.95</td>\n",
       "      <td>...</td>\n",
       "      <td>0.36</td>\n",
       "      <td>3.90</td>\n",
       "      <td>0.71</td>\n",
       "      <td>97664.52</td>\n",
       "      <td>9738.03</td>\n",
       "      <td>658182.63</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>46274.56</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>2009/02/08</td>\n",
       "      <td>23:16:04</td>\n",
       "      <td>193</td>\n",
       "      <td>e</td>\n",
       "      <td>10068.31</td>\n",
       "      <td>9859.28</td>\n",
       "      <td>2568.92</td>\n",
       "      <td>48.16</td>\n",
       "      <td>68.74</td>\n",
       "      <td>96.02</td>\n",
       "      <td>...</td>\n",
       "      <td>0.46</td>\n",
       "      <td>4.23</td>\n",
       "      <td>1.05</td>\n",
       "      <td>188512.64</td>\n",
       "      <td>9355.15</td>\n",
       "      <td>712191.06</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>53034.07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>2009/02/08</td>\n",
       "      <td>23:45:45</td>\n",
       "      <td>649</td>\n",
       "      <td>e</td>\n",
       "      <td>10058.39</td>\n",
       "      <td>10025.72</td>\n",
       "      <td>3005.16</td>\n",
       "      <td>26.80</td>\n",
       "      <td>26.05</td>\n",
       "      <td>16.49</td>\n",
       "      <td>...</td>\n",
       "      <td>0.07</td>\n",
       "      <td>2.87</td>\n",
       "      <td>0.88</td>\n",
       "      <td>542659.13</td>\n",
       "      <td>55593.17</td>\n",
       "      <td>1484096.38</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>166519.84</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>2009/02/09</td>\n",
       "      <td>02:20:15</td>\n",
       "      <td>48</td>\n",
       "      <td>e</td>\n",
       "      <td>10188.93</td>\n",
       "      <td>10160.38</td>\n",
       "      <td>2979.95</td>\n",
       "      <td>24.43</td>\n",
       "      <td>21.21</td>\n",
       "      <td>22.78</td>\n",
       "      <td>...</td>\n",
       "      <td>13.07</td>\n",
       "      <td>4.97</td>\n",
       "      <td>1.66</td>\n",
       "      <td>59242.67</td>\n",
       "      <td>3814.50</td>\n",
       "      <td>294459.50</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>17528.87</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>2009/02/09</td>\n",
       "      <td>04:12:35</td>\n",
       "      <td>700</td>\n",
       "      <td>e</td>\n",
       "      <td>10136.87</td>\n",
       "      <td>9949.81</td>\n",
       "      <td>3057.88</td>\n",
       "      <td>3.71</td>\n",
       "      <td>4.24</td>\n",
       "      <td>3.04</td>\n",
       "      <td>...</td>\n",
       "      <td>11.93</td>\n",
       "      <td>1.87</td>\n",
       "      <td>0.74</td>\n",
       "      <td>152711.59</td>\n",
       "      <td>7313.13</td>\n",
       "      <td>323386.38</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>44600.19</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>2009/02/09</td>\n",
       "      <td>07:04:56</td>\n",
       "      <td>920</td>\n",
       "      <td>e</td>\n",
       "      <td>10330.10</td>\n",
       "      <td>10132.29</td>\n",
       "      <td>2862.94</td>\n",
       "      <td>54.79</td>\n",
       "      <td>22.68</td>\n",
       "      <td>35.04</td>\n",
       "      <td>...</td>\n",
       "      <td>95.63</td>\n",
       "      <td>1.39</td>\n",
       "      <td>0.68</td>\n",
       "      <td>105657.75</td>\n",
       "      <td>16616.39</td>\n",
       "      <td>534861.56</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>43984.45</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>2009/02/09</td>\n",
       "      <td>08:13:05</td>\n",
       "      <td>328</td>\n",
       "      <td>e</td>\n",
       "      <td>10141.41</td>\n",
       "      <td>9961.40</td>\n",
       "      <td>3051.29</td>\n",
       "      <td>27.08</td>\n",
       "      <td>24.79</td>\n",
       "      <td>23.82</td>\n",
       "      <td>...</td>\n",
       "      <td>8.33</td>\n",
       "      <td>2.46</td>\n",
       "      <td>0.80</td>\n",
       "      <td>49830.40</td>\n",
       "      <td>2867.84</td>\n",
       "      <td>202789.02</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>31722.05</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>2009/02/09</td>\n",
       "      <td>08:19:43</td>\n",
       "      <td>971</td>\n",
       "      <td>e</td>\n",
       "      <td>10140.94</td>\n",
       "      <td>9946.69</td>\n",
       "      <td>3065.22</td>\n",
       "      <td>5.42</td>\n",
       "      <td>4.64</td>\n",
       "      <td>5.60</td>\n",
       "      <td>...</td>\n",
       "      <td>4.88</td>\n",
       "      <td>1.91</td>\n",
       "      <td>0.87</td>\n",
       "      <td>148813.73</td>\n",
       "      <td>7521.11</td>\n",
       "      <td>375190.88</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>48673.79</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>2009/02/09</td>\n",
       "      <td>11:43:11</td>\n",
       "      <td>781</td>\n",
       "      <td>n</td>\n",
       "      <td>10147.88</td>\n",
       "      <td>10173.19</td>\n",
       "      <td>3026.32</td>\n",
       "      <td>8.54</td>\n",
       "      <td>4.48</td>\n",
       "      <td>4.29</td>\n",
       "      <td>...</td>\n",
       "      <td>9.17</td>\n",
       "      <td>1.36</td>\n",
       "      <td>0.88</td>\n",
       "      <td>190489.36</td>\n",
       "      <td>11213.32</td>\n",
       "      <td>248857.09</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>24629.06</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>2009/02/09</td>\n",
       "      <td>11:43:12</td>\n",
       "      <td>559</td>\n",
       "      <td>n</td>\n",
       "      <td>10138.73</td>\n",
       "      <td>10175.47</td>\n",
       "      <td>3011.16</td>\n",
       "      <td>8.92</td>\n",
       "      <td>4.76</td>\n",
       "      <td>5.03</td>\n",
       "      <td>...</td>\n",
       "      <td>2.16</td>\n",
       "      <td>1.64</td>\n",
       "      <td>0.73</td>\n",
       "      <td>99573.47</td>\n",
       "      <td>4938.45</td>\n",
       "      <td>230799.48</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>18269.55</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>2009/02/09</td>\n",
       "      <td>11:56:19</td>\n",
       "      <td>320</td>\n",
       "      <td>e</td>\n",
       "      <td>10013.93</td>\n",
       "      <td>10058.34</td>\n",
       "      <td>2947.61</td>\n",
       "      <td>7.61</td>\n",
       "      <td>5.47</td>\n",
       "      <td>4.96</td>\n",
       "      <td>...</td>\n",
       "      <td>16.28</td>\n",
       "      <td>2.13</td>\n",
       "      <td>0.49</td>\n",
       "      <td>154389.11</td>\n",
       "      <td>8165.52</td>\n",
       "      <td>684665.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>74230.17</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>2009/02/09</td>\n",
       "      <td>12:02:24</td>\n",
       "      <td>213</td>\n",
       "      <td>e</td>\n",
       "      <td>10367.99</td>\n",
       "      <td>10364.80</td>\n",
       "      <td>2622.04</td>\n",
       "      <td>135.34</td>\n",
       "      <td>62.66</td>\n",
       "      <td>172.31</td>\n",
       "      <td>...</td>\n",
       "      <td>0.28</td>\n",
       "      <td>1.41</td>\n",
       "      <td>0.78</td>\n",
       "      <td>1660248.75</td>\n",
       "      <td>94963.54</td>\n",
       "      <td>1372731.38</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>116378.97</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>2009/02/10</td>\n",
       "      <td>02:08:04</td>\n",
       "      <td>365</td>\n",
       "      <td>e</td>\n",
       "      <td>10113.76</td>\n",
       "      <td>9922.42</td>\n",
       "      <td>2668.43</td>\n",
       "      <td>33.72</td>\n",
       "      <td>32.82</td>\n",
       "      <td>44.97</td>\n",
       "      <td>...</td>\n",
       "      <td>7.62</td>\n",
       "      <td>3.52</td>\n",
       "      <td>1.04</td>\n",
       "      <td>341739.25</td>\n",
       "      <td>17861.00</td>\n",
       "      <td>968411.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>62130.79</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Date(y/m/d) Time(H:M:S)  MilliSec Type  Northing   Easting    Depth  \\\n",
       "0   2009/01/28    14:58:30       154    n  10151.63  10346.47  3098.37   \n",
       "1   2009/01/28    14:59:56       872    e  10127.32  10308.23  2620.29   \n",
       "2   2009/01/28    15:00:31       904    n  10144.80  10330.61  3103.87   \n",
       "3   2009/01/28    15:01:29       443    e  10008.00  10236.90  3082.62   \n",
       "4   2009/01/28    15:11:21       191    e  10006.04  10234.48  3082.73   \n",
       "5   2009/01/28    15:12:10       670    n  10132.89  10343.98  3100.33   \n",
       "6   2009/01/28    22:34:02       245    e   9974.08  10144.34  3098.28   \n",
       "7   2009/01/28    22:46:24       380    e  10156.98   9957.34  3041.54   \n",
       "8   2009/01/28    22:55:05       356    e  10148.50   9958.03  3059.75   \n",
       "9   2009/01/28    23:06:25       166    e  10146.10   9957.69  3058.05   \n",
       "10  2009/01/29    00:02:01       657    e  10158.69   9955.60  3054.40   \n",
       "11  2009/01/29    01:14:18        24    e  10273.37  10327.30  3030.34   \n",
       "12  2009/01/30    20:15:17       587    e  10001.35  10050.70  3150.42   \n",
       "13  2009/01/31    07:28:19       115    e  10303.29  10346.57  3036.89   \n",
       "14  2009/01/31    11:10:41        44    n  10150.92  10179.48  3030.32   \n",
       "15  2009/01/31    12:04:06       566    e  10150.74  10183.47  3078.39   \n",
       "16  2009/01/31    12:19:20       224    e  10151.70  10169.00  3057.41   \n",
       "17  2009/01/31    22:52:21       422    e  10165.58  10346.03  3083.20   \n",
       "18  2009/01/31    22:54:00       669    e  10176.75  10348.67  3060.97   \n",
       "19  2009/01/31    22:58:23       614    e  10264.26  10363.49  2963.24   \n",
       "20  2009/02/01    07:39:05       788    e   9946.61  10205.37  3081.42   \n",
       "21  2009/02/01    14:08:16       106    e  10224.76  10102.28  2715.83   \n",
       "22  2009/02/01    19:14:45       595    e  10102.07  10026.08  2955.96   \n",
       "23  2009/02/02    05:38:57        73    e   9998.62  10049.83  3195.91   \n",
       "24  2009/02/04    15:52:25       462    e  10318.39  10192.71  2658.10   \n",
       "25  2009/02/04    18:05:16       235    e   9996.61  10058.46  3000.19   \n",
       "26  2009/02/04    20:06:08       103    e   9992.74  10241.26  3065.38   \n",
       "27  2009/02/04    20:54:07       986    e  10367.91  10246.35  2844.88   \n",
       "28  2009/02/04    22:37:05       878    u  10249.61  10229.24  2965.56   \n",
       "29  2009/02/05    06:34:15       841    e  10250.11  10204.96  2691.13   \n",
       "..         ...         ...       ...  ...       ...       ...      ...   \n",
       "70  2009/02/06    15:21:47       281    e  10037.64  10023.72  3023.31   \n",
       "71  2009/02/07    02:39:09       701    e  10288.42  10053.56  2672.99   \n",
       "72  2009/02/07    09:58:41       219    e   9991.96  10054.29  2952.81   \n",
       "73  2009/02/07    22:46:26       258    e   9946.29  10035.08  2870.26   \n",
       "74  2009/02/08    06:33:49       427    e  10336.66  10213.86  2715.57   \n",
       "75  2009/02/08    06:37:04       458    e  10304.97  10226.21  2654.36   \n",
       "76  2009/02/08    06:39:47       438    e  10312.79  10254.15  2740.12   \n",
       "77  2009/02/08    06:39:52       344    e  10192.14  10229.59  2817.84   \n",
       "78  2009/02/08    06:42:08       796    e  10249.48  10220.39  2738.07   \n",
       "79  2009/02/08    06:54:48       879    e  10276.62  10012.65  2600.12   \n",
       "80  2009/02/08    06:57:07       730    e  10225.49  10221.30  2745.34   \n",
       "81  2009/02/08    07:22:19       771    e  10097.42   9846.77  2589.60   \n",
       "82  2009/02/08    10:06:08       661    e  10388.62  10350.95  2862.61   \n",
       "83  2009/02/08    14:37:49       353    e  10311.08  10136.13  2876.82   \n",
       "84  2009/02/08    15:36:01       256    e  10294.75  10139.45  2881.74   \n",
       "85  2009/02/08    20:33:39       508    e  10009.90  10048.74  2993.15   \n",
       "86  2009/02/08    22:51:23       350    e  10247.65  10331.15  3081.33   \n",
       "87  2009/02/08    23:04:00       619    e  10103.85   9859.10  2578.21   \n",
       "88  2009/02/08    23:16:04       193    e  10068.31   9859.28  2568.92   \n",
       "89  2009/02/08    23:45:45       649    e  10058.39  10025.72  3005.16   \n",
       "90  2009/02/09    02:20:15        48    e  10188.93  10160.38  2979.95   \n",
       "91  2009/02/09    04:12:35       700    e  10136.87   9949.81  3057.88   \n",
       "92  2009/02/09    07:04:56       920    e  10330.10  10132.29  2862.94   \n",
       "93  2009/02/09    08:13:05       328    e  10141.41   9961.40  3051.29   \n",
       "94  2009/02/09    08:19:43       971    e  10140.94   9946.69  3065.22   \n",
       "95  2009/02/09    11:43:11       781    n  10147.88  10173.19  3026.32   \n",
       "96  2009/02/09    11:43:12       559    n  10138.73  10175.47  3011.16   \n",
       "97  2009/02/09    11:56:19       320    e  10013.93  10058.34  2947.61   \n",
       "98  2009/02/09    12:02:24       213    e  10367.99  10364.80  2622.04   \n",
       "99  2009/02/10    02:08:04       365    e  10113.76   9922.42  2668.43   \n",
       "\n",
       "    NN_Err  EE_Err  DD_Err     ...        Es/Ep  SourceRo  AspRadius  \\\n",
       "0    23.86    8.01   11.85     ...         4.18      0.93       0.56   \n",
       "1    67.67   16.63   29.62     ...         2.06      2.85       0.69   \n",
       "2    90.94   18.55   38.43     ...        15.31      2.70       4.42   \n",
       "3    13.45    4.49    7.21     ...         1.38      1.45       0.53   \n",
       "4    10.76    3.58    5.81     ...         0.49      1.52       0.40   \n",
       "5    21.06    7.96    9.49     ...         3.16      1.57       0.93   \n",
       "6    38.71    9.99   17.68     ...         3.36      2.57       0.61   \n",
       "7    43.37   15.11   27.63     ...         8.40      1.57       0.90   \n",
       "8     9.50    3.35    5.32     ...         6.06      1.72       0.41   \n",
       "9    30.25   10.09   16.71     ...         3.04      1.66       0.38   \n",
       "10   19.51    5.33    8.88     ...         4.77      1.79       0.49   \n",
       "11   47.65   25.70   49.57     ...         2.15      1.41       0.59   \n",
       "12    3.07    1.91    4.42     ...        22.25      0.67       0.61   \n",
       "13   21.45    7.65   27.51     ...        10.60      1.74       0.71   \n",
       "14   14.13   11.96   25.29     ...        16.05      0.84       0.62   \n",
       "15   15.00   15.04   23.97     ...         2.06      0.49       0.66   \n",
       "16    9.06    9.15   14.44     ...       182.62      0.91       0.60   \n",
       "17   10.29    4.95    5.65     ...         2.55      1.60       0.69   \n",
       "18    9.76    2.65    7.54     ...         6.85      0.73       0.50   \n",
       "19   34.00   13.47   74.05     ...        13.27      0.98       0.72   \n",
       "20   40.12   10.53   24.94     ...         6.43      1.44       0.57   \n",
       "21   31.63   21.90   17.60     ...         5.73      2.61       0.77   \n",
       "22   47.97   20.44   13.55     ...        30.07      0.49       0.67   \n",
       "23    4.98    3.20    4.77     ...         2.93      0.51       0.60   \n",
       "24  110.43   26.47  158.30     ...         4.49      3.01       0.97   \n",
       "25   10.08    8.31    7.19     ...         9.21      0.58       0.50   \n",
       "26   50.65   18.89   24.39     ...        16.87      1.44       0.66   \n",
       "27   12.73   22.80   15.32     ...         5.71      2.08       1.05   \n",
       "28   74.27   20.40   20.59     ...        15.22      2.90       0.00   \n",
       "29   17.10   10.04   12.95     ...         3.85      2.86       1.03   \n",
       "..     ...     ...     ...     ...          ...       ...        ...   \n",
       "70   15.02   18.07   12.57     ...         3.70      1.65       0.52   \n",
       "71   58.56   42.31   86.14     ...         0.49      1.09       0.73   \n",
       "72    6.25    3.55    2.60     ...         2.55      4.00       1.03   \n",
       "73   15.11   14.47   13.64     ...         3.34      1.22       0.55   \n",
       "74   88.89   15.96   99.28     ...         2.42      3.41       0.88   \n",
       "75   74.74   15.18  127.46     ...         0.99      1.97       0.79   \n",
       "76   89.42   26.56   90.24     ...         2.54      2.11       0.76   \n",
       "77   46.64    8.64   44.35     ...         1.12      1.75       0.96   \n",
       "78   94.24   18.77  144.06     ...         1.41      1.15       0.55   \n",
       "79   24.32   29.69   65.35     ...         0.24      1.63       0.84   \n",
       "80   42.33    9.97   68.86     ...         4.12      2.85       0.92   \n",
       "81   39.99   59.15   77.34     ...         0.26      2.39       0.78   \n",
       "82  105.13   48.97   34.65     ...         1.97      3.49       0.82   \n",
       "83   16.01    6.91    9.62     ...         7.87      4.47       0.78   \n",
       "84   26.61   11.97   15.46     ...         3.35      2.36       0.79   \n",
       "85   17.14   10.53    8.11     ...       173.27      0.60       0.81   \n",
       "86    9.37    6.58    6.13     ...         4.21      6.27       1.15   \n",
       "87   47.25   58.12   78.95     ...         0.36      3.90       0.71   \n",
       "88   48.16   68.74   96.02     ...         0.46      4.23       1.05   \n",
       "89   26.80   26.05   16.49     ...         0.07      2.87       0.88   \n",
       "90   24.43   21.21   22.78     ...        13.07      4.97       1.66   \n",
       "91    3.71    4.24    3.04     ...        11.93      1.87       0.74   \n",
       "92   54.79   22.68   35.04     ...        95.63      1.39       0.68   \n",
       "93   27.08   24.79   23.82     ...         8.33      2.46       0.80   \n",
       "94    5.42    4.64    5.60     ...         4.88      1.91       0.87   \n",
       "95    8.54    4.48    4.29     ...         9.17      1.36       0.88   \n",
       "96    8.92    4.76    5.03     ...         2.16      1.64       0.73   \n",
       "97    7.61    5.47    4.96     ...        16.28      2.13       0.49   \n",
       "98  135.34   62.66  172.31     ...         0.28      1.41       0.78   \n",
       "99   33.72   32.82   44.97     ...         7.62      3.52       1.04   \n",
       "\n",
       "       StaticSD  AppStress   DyStressD  MaxDispla  PeakVelPar  PeakAccPar  \\\n",
       "0     960305.56   53866.10   827017.75       0.00        0.00    66841.81   \n",
       "1      32582.77    1990.87   171515.97       0.00        0.00    15204.68   \n",
       "2    1841950.50  169490.97  8505005.00       0.01        1.12   830952.19   \n",
       "3     337241.63   10414.42   501905.66       0.00        0.00    43154.95   \n",
       "4     226187.47    6157.43   499342.22       0.00        0.00    44361.63   \n",
       "5     488801.53   19782.07   486382.09       0.00        0.00    50996.20   \n",
       "6     105212.33    4630.88   427606.06       0.00        0.00    36742.85   \n",
       "7     741688.13   48755.10  1196740.75       0.00        0.01   112214.88   \n",
       "8     320383.31   19074.81  1214091.00       0.00        0.00   123405.10   \n",
       "9     419159.38   16583.20  1075391.75       0.00        0.00   123167.91   \n",
       "10    246394.78   11598.21   703487.06       0.00        0.00    76777.50   \n",
       "11    257231.59   11109.61   266017.22       0.00        0.00    23750.35   \n",
       "12   2213762.50  165204.72  2277209.75       0.00        0.01   190779.80   \n",
       "13    452050.13   33475.25   981628.50       0.00        0.01    98489.67   \n",
       "14    539904.44   50340.05   658995.44       0.00        0.00    74881.02   \n",
       "15   4576993.00  208421.55  1555793.75       0.00        0.01   200166.63   \n",
       "16    545677.50   62017.79  1306208.13       0.00        0.01   150232.95   \n",
       "17    435493.97   16238.35   594276.63       0.00        0.00    50954.04   \n",
       "18   1243412.25   66201.84   779625.00       0.00        0.00    67549.67   \n",
       "19    632010.31   36355.68   693345.06       0.00        0.00    71440.38   \n",
       "20    127858.58    7591.25   309495.47       0.00        0.00    32517.12   \n",
       "21    644529.75   24424.95  2460795.50       0.00        0.01   163601.13   \n",
       "22   5716290.00  458720.03  2254723.00       0.00        0.01   189659.42   \n",
       "23  16865670.00  879968.00  5057313.00       0.00        0.02   415500.28   \n",
       "24    214037.55    6753.37   817230.13       0.00        0.01    97644.58   \n",
       "25   5083720.50  273187.94  2381671.00       0.00        0.01   184809.42   \n",
       "26    417008.88   23637.27   974082.69       0.00        0.00    96146.00   \n",
       "27    831600.69   34059.37  1667771.63       0.00        0.01   135078.09   \n",
       "28   2854647.25  213526.48        0.00       0.00        0.05        0.00   \n",
       "29     68189.24    3276.90   183998.38       0.00        0.00    14906.63   \n",
       "..          ...        ...         ...        ...         ...         ...   \n",
       "70    375772.53   12670.07   668995.88       0.00        0.00    70972.84   \n",
       "71    911915.63   61874.09   859208.31       0.00        0.00    71924.39   \n",
       "72    895711.63   38608.79  4611073.00       0.00        0.04   302129.13   \n",
       "73   1003752.25   49820.25  1576861.13       0.00        0.01   145229.41   \n",
       "74    365822.72   12280.87   820964.00       0.00        0.01    75993.69   \n",
       "75    614572.44   46816.17   959851.56       0.00        0.01    66490.89   \n",
       "76   1067109.50   33620.00  1068604.88       0.00        0.01    89424.30   \n",
       "77    172730.33    3010.45   220595.75       0.00        0.00    20106.01   \n",
       "78    475009.63   14103.82   341334.84       0.00        0.00    28653.42   \n",
       "79    616927.38   70683.98   913539.88       0.00        0.01    89846.95   \n",
       "80    165977.03    6043.31   310043.88       0.00        0.00    25345.17   \n",
       "81    544436.31   31622.19  1233536.13       0.00        0.01   102763.63   \n",
       "82    230120.48    8968.11   661800.56       0.00        0.00    44431.28   \n",
       "83     60433.39    3610.43   511706.72       0.00        0.00    38395.36   \n",
       "84    376994.69   11024.27   561353.69       0.00        0.00    46623.26   \n",
       "85   7892865.50  447978.66  4116630.50       0.00        0.02   296266.13   \n",
       "86    447919.63   19526.96  2338621.25       0.00        0.02   185340.02   \n",
       "87     97664.52    9738.03   658182.63       0.00        0.00    46274.56   \n",
       "88    188512.64    9355.15   712191.06       0.00        0.00    53034.07   \n",
       "89    542659.13   55593.17  1484096.38       0.00        0.01   166519.84   \n",
       "90     59242.67    3814.50   294459.50       0.00        0.00    17528.87   \n",
       "91    152711.59    7313.13   323386.38       0.00        0.00    44600.19   \n",
       "92    105657.75   16616.39   534861.56       0.00        0.00    43984.45   \n",
       "93     49830.40    2867.84   202789.02       0.00        0.00    31722.05   \n",
       "94    148813.73    7521.11   375190.88       0.00        0.00    48673.79   \n",
       "95    190489.36   11213.32   248857.09       0.00        0.00    24629.06   \n",
       "96     99573.47    4938.45   230799.48       0.00        0.00    18269.55   \n",
       "97    154389.11    8165.52   684665.00       0.00        0.00    74230.17   \n",
       "98   1660248.75   94963.54  1372731.38       0.00        0.01   116378.97   \n",
       "99    341739.25   17861.00   968411.00       0.00        0.01    62130.79   \n",
       "\n",
       "    Unnamed: 24  \n",
       "0           NaN  \n",
       "1           NaN  \n",
       "2           NaN  \n",
       "3           NaN  \n",
       "4           NaN  \n",
       "5           NaN  \n",
       "6           NaN  \n",
       "7           NaN  \n",
       "8           NaN  \n",
       "9           NaN  \n",
       "10          NaN  \n",
       "11          NaN  \n",
       "12          NaN  \n",
       "13          NaN  \n",
       "14          NaN  \n",
       "15          NaN  \n",
       "16          NaN  \n",
       "17          NaN  \n",
       "18          NaN  \n",
       "19          NaN  \n",
       "20          NaN  \n",
       "21          NaN  \n",
       "22          NaN  \n",
       "23          NaN  \n",
       "24          NaN  \n",
       "25          NaN  \n",
       "26          NaN  \n",
       "27          NaN  \n",
       "28          NaN  \n",
       "29          NaN  \n",
       "..          ...  \n",
       "70          NaN  \n",
       "71          NaN  \n",
       "72          NaN  \n",
       "73          NaN  \n",
       "74          NaN  \n",
       "75          NaN  \n",
       "76          NaN  \n",
       "77          NaN  \n",
       "78          NaN  \n",
       "79          NaN  \n",
       "80          NaN  \n",
       "81          NaN  \n",
       "82          NaN  \n",
       "83          NaN  \n",
       "84          NaN  \n",
       "85          NaN  \n",
       "86          NaN  \n",
       "87          NaN  \n",
       "88          NaN  \n",
       "89          NaN  \n",
       "90          NaN  \n",
       "91          NaN  \n",
       "92          NaN  \n",
       "93          NaN  \n",
       "94          NaN  \n",
       "95          NaN  \n",
       "96          NaN  \n",
       "97          NaN  \n",
       "98          NaN  \n",
       "99          NaN  \n",
       "\n",
       "[100 rows x 25 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "frame.head(100)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "kernelspec": {
   "display_name": "Python [Root]",
   "language": "python",
   "name": "Python [Root]"
  },
  "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
}