{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Tablesaw \n", "\n", "[Tablesaw](https://jtablesaw.wordpress.com/) comes built-in to the BeakerX Groovy kernel.\n", "Tablesaw provides the ability to easily transform, summarize, and filter data, as well as computing descriptive statistics and fundamental machine learning algorithms.\n", "\n", "This notebook has some basic demos of how to use Tablesaw, including visualizing the results. This notebook uses the Beaker interactive visualizaiton libraries, but Tablesaw's APIs also work. The notebook covers basic table manipulation, k-means clustering, and linear regression.\n", "\n", "## Basics of Table manipulation\n", "\n", "More description is available at https://jtablesaw.wordpress.com/an-introduction/" ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "Structure of tornadoes_2014.csv\n", "Index Column Name Column Type \n", "0 Date LOCAL_DATE \n", "1 Time LOCAL_TIME \n", "2 State CATEGORY \n", "3 State No SHORT_INT \n", "4 Scale SHORT_INT \n", "5 Injuries SHORT_INT \n", "6 Fatalities SHORT_INT \n", "7 Start Lat FLOAT \n", "8 Start Lon FLOAT \n", "9 Length FLOAT \n", "10 Width FLOAT \n" ] }, "execution_count": 2, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tornadoes = Table.createFromCsv(\"Tablesaw/tornadoes_2014.csv\")\n", "//print dataset structure \n", "tornadoes.structure().print()" ] }, { "cell_type": "code", "execution_count": 6, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "[Date, Time, State, State No, Scale, Injuries, Fatalities, Start Lat, Start Lon, Length, Width]" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "//get header names\n", "tornadoes.columnNames()" ] }, { "cell_type": "code", "execution_count": 7, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "908 rows X 11 cols" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "//displays the row and column counts\n", "tornadoes.shape()" ] }, { "cell_type": "code", "execution_count": 8, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "tornadoes_2014.csv\n", "Date Time State State No Scale Injuries Fatalities Start Lat Start Lon Length Width \n", "2014-01-11 06:37:00 GA 0 0 0 0 34.3328 -84.5286 2.9 10.0 \n", "2014-01-11 14:32:00 VA 0 0 0 0 37.025 -76.6377 1.36 100.0 \n", "2014-01-11 14:32:00 VA 0 0 0 0 36.8769 -76.6721 1.95 50.0 \n", "2014-01-11 14:50:00 VA 0 0 0 0 37.08 -76.3 1.08 75.0 \n", "2014-02-20 14:25:00 IL 0 2 1 0 39.518 -90.841 12.09 80.0 \n", "2014-02-20 14:48:00 IL 0 0 0 0 39.7853 -90.4215 0.27 25.0 \n", "2014-02-20 14:52:00 IL 0 0 0 0 39.8193 -90.4178 8.17 50.0 \n", "2014-02-20 15:43:00 IL 0 0 0 0 39.5671 -89.6256 0.22 75.0 \n", "2014-02-20 15:57:00 IL 0 1 0 0 38.7575 -89.6151 20.56 300.0 \n", "2014-02-20 16:09:00 IL 0 2 1 0 39.2586 -89.234 22.38 200.0 \n" ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "//displays the first n rows\n", "tornadoes.first(10).print()" ] }, { "cell_type": "code", "execution_count": 9, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "Structure of tornadoes_2014.csv\n", "Index Column Name Column Type \n", "7 Start Lat FLOAT \n", "8 Start Lon FLOAT \n", "9 Length FLOAT \n", "10 Width FLOAT \n" ] }, "execution_count": 9, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tornadoes.structure().selectWhere(column(\"Column Type\").isEqualTo(\"FLOAT\")).print()" ] }, { "cell_type": "code", "execution_count": 10, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "\n", "Table summary for: tornadoes_2014.csv\n", "Column: Date\n", "Measure Value \n", "Count 908 \n", "Missing 0 \n", "Earliest 2014-01-11 \n", "Latest 2014-12-29 \n", "\n", "Column: Time\n", "Measure Value \n", "Count 908 \n", "Missing 0 \n", "Earliest 00:01 \n", "Latest 23:59 \n", "\n", "Column: State\n", "Category Count \n", "GA 32 \n", "NM 15 \n", "MT 8 \n", "CO 49 \n", "WV 9 \n", "IN 28 \n", "MD 2 \n", "CA 9 \n", "AL 55 \n", "TN 18 \n", "NV 6 \n", "PA 9 \n", "WY 13 \n", "ID 3 \n", "KS 41 \n", "IA 56 \n", "MN 24 \n", "TX 46 \n", "WA 3 \n", "OK 17 \n", "NE 62 \n", "AR 20 \n", "ND 14 \n", "WI 22 \n", "IL 49 \n", "SD 29 \n", "MS 42 \n", "FL 28 \n", "AZ 3 \n", "NY 11 \n", "NC 32 \n", "OH 20 \n", "DE 1 \n", "VA 12 \n", "MO 47 \n", "ME 4 \n", "LA 15 \n", "MI 13 \n", "SC 7 \n", "KY 28 \n", "MA 3 \n", "CT 1 \n", "NH 2 \n", "\n", "Column: State No\n", "Measure Value \n", "n 908.0 \n", "sum 0.0 \n", "Mean 0.0 \n", "Min 0.0 \n", "Max 0.0 \n", "Range 0.0 \n", "Variance 0.0 \n", "Std. Dev 0.0 \n", "\n", "Column: Scale\n", "Measure Value \n", "n 908.0 \n", "sum 567.0 \n", "Mean 0.6244493 \n", "Min 0.0 \n", "Max 4.0 \n", "Range 4.0 \n", "Variance 0.6272737 \n", "Std. Dev 0.79200613 \n", "\n", "Column: Injuries\n", "Measure Value \n", "n 908.0 \n", "sum 684.0 \n", "Mean 0.75330395 \n", "Min 0.0 \n", "Max 193.0 \n", "Range 193.0 \n", "Variance 57.68108 \n", "Std. Dev 7.594806 \n", "\n", "Column: Fatalities\n", "Measure Value \n", "n 908.0 \n", "sum 48.0 \n", "Mean 0.052863438 \n", "Min 0.0 \n", "Max 16.0 \n", "Range 16.0 \n", "Variance 0.44262686 \n", "Std. Dev 0.6653021 \n", "\n", "Column: Start Lat\n", "Measure Value \n", "n 908.0 \n", "sum 34690.984 \n", "Mean 38.20593 \n", "Min 0.0 \n", "Max 48.86 \n", "Range 48.86 \n", "Variance 22.448586 \n", "Std. Dev 4.7379937 \n", "\n", "Column: Start Lon\n", "Measure Value \n", "n 908.0 \n", "sum -83613.02 \n", "Mean -92.08483 \n", "Min -122.946 \n", "Max 0.0 \n", "Range 122.946 \n", "Variance 91.84773 \n", "Std. Dev 9.583722 \n", "\n", "Column: Length\n", "Measure Value \n", "n 908.0 \n", "sum 3014.49 \n", "Mean 3.319923 \n", "Min 0.0 \n", "Max 45.68 \n", "Range 45.68 \n", "Variance 28.736567 \n", "Std. Dev 5.3606496 \n", "\n", "Column: Width\n", "Measure Value \n", "n 908.0 \n", "sum 149778.0 \n", "Mean 164.95375 \n", "Min 0.0 \n", "Max 2640.0 \n", "Range 2640.0 \n", "Variance 57764.465 \n", "Std. Dev 240.34239 \n", "\n", "\n" ] }, "execution_count": 10, "metadata": {}, "output_type": "execute_result" } ], "source": [ "//summarize the data in each column\n", "tornadoes.summary()" ] }, { "cell_type": "code", "execution_count": 11, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "[Date, Time, State, State No, Scale, Injuries, Fatalities, Start Lat, Start Lon, Length, Width, Date month]" ] }, "execution_count": 11, "metadata": {}, "output_type": "execute_result" } ], "source": [ "//Mapping operations\n", "def month = tornadoes.dateColumn(\"Date\").month()\n", "tornadoes.addColumn(month);\n", "tornadoes.columnNames()" ] }, { "cell_type": "code", "execution_count": 12, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "tornadoes_2014.csv\n", "Date Time State State No Scale Injuries Fatalities Start Lat Start Lon Length Width Date month \n", "2014-04-27 18:06:00 AR 0 4 193 16 34.7787 -92.652 41.1 1320.0 APRIL \n", "2014-04-28 14:51:00 MS 0 4 84 10 32.88 -89.43 33.39 1320.0 APRIL \n", "2014-07-08 17:02:00 NY 0 2 0 4 42.99 -75.64 2.5 235.0 JULY \n", "2014-12-23 14:20:00 MS 0 3 50 3 31.2273 -89.8331 12.51 880.0 DECEMBER \n", "2014-04-27 14:20:00 IA 0 1 0 2 41.1325 -92.3117 45.68 1600.0 APRIL \n", "2014-12-23 15:22:00 MS 0 2 0 2 31.6986 -89.2239 5.89 350.0 DECEMBER \n", "2014-04-28 15:47:00 AL 0 3 30 2 34.7753 -87.2324 15.56 600.0 APRIL \n", "2014-04-28 19:09:00 TN 0 3 0 2 35.0066 -86.5497 26.76 500.0 APRIL \n", "2014-04-25 17:20:00 NC 0 2 1 1 36.054 -76.74 37.48 400.0 APRIL \n", "2014-10-13 04:37:00 AR 0 2 4 1 33.6617 -94.2303 2.51 400.0 OCTOBER \n", "2014-04-27 16:29:00 OK 0 2 37 1 36.912 -94.8215 11.37 325.0 APRIL \n", "2014-04-28 17:27:00 MS 0 3 10 1 32.2291 -90.2225 29.72 400.0 APRIL \n", "2014-04-27 16:29:00 OK 0 2 12 1 36.912 -94.8215 7.1 325.0 APRIL \n", "2014-06-16 15:13:00 NE 0 4 0 1 41.9742 -97.04 11.5 500.0 JUNE \n", "2014-06-16 15:00:00 NE 0 4 20 1 41.9528 -97.1369 23.94 500.0 JUNE \n", "2014-02-20 16:54:00 IL 0 1 0 0 39.1784 -88.7233 1.54 100.0 FEBRUARY \n", "2014-02-20 17:43:00 IL 0 0 0 0 39.7821 -87.7409 3.0 75.0 FEBRUARY \n", "2014-02-20 18:40:00 IN 0 0 0 0 40.0044 -86.8666 7.48 40.0 FEBRUARY \n", "2014-02-20 18:42:00 KY 0 0 0 0 37.48 -87.8974 6.22 125.0 FEBRUARY \n", "2014-02-20 19:11:00 MS 0 0 0 0 31.0737 -90.0019 0.45 40.0 FEBRUARY \n", "2014-02-20 19:12:00 KY 0 0 0 0 37.1 -87.75 1.59 125.0 FEBRUARY \n", "2014-02-20 19:48:00 MS 0 0 0 0 31.253 -89.77 0.52 50.0 FEBRUARY \n", "2014-02-20 20:32:00 IN 0 0 0 0 39.656 -85.5679 0.04 25.0 FEBRUARY \n", "2014-02-20 20:33:00 LA 0 1 0 0 30.6913 -92.3903 2.65 75.0 FEBRUARY \n", "2014-02-20 20:45:00 AL 0 1 0 0 34.6889 -87.2589 10.72 450.0 FEBRUARY \n", "2014-02-20 20:51:00 AL 0 1 0 0 34.7858 -87.315 1.82 400.0 FEBRUARY \n", "2014-02-20 20:55:00 AL 0 1 1 0 34.895 -87.2783 2.67 500.0 FEBRUARY \n", "2014-02-20 21:05:00 AL 0 1 0 0 34.8798 -87.0707 2.73 500.0 FEBRUARY \n", "2014-02-20 21:14:00 IN 0 1 0 0 39.1792 -85.2854 0.81 50.0 FEBRUARY \n", "2014-02-20 21:28:00 MS 0 1 0 0 31.455 -89.366 4.62 100.0 FEBRUARY \n", "2014-02-20 21:50:00 MS 0 0 0 0 31.607 -89.255 0.6 50.0 FEBRUARY \n", "2014-02-20 21:53:00 TN 0 1 0 0 35.1935 -86.3331 1.64 400.0 FEBRUARY \n", "2014-02-20 21:53:00 OH 0 0 0 0 39.889 -84.4078 2.03 80.0 FEBRUARY \n", "2014-02-20 22:08:00 TN 0 1 0 0 35.176 -86.2048 1.05 100.0 FEBRUARY \n", "2014-02-20 22:23:00 TN 0 1 0 0 35.287 -85.992 1.98 400.0 FEBRUARY \n", "2014-02-20 22:29:00 TN 0 1 0 0 35.3303 -85.9324 1.21 250.0 FEBRUARY \n", "2014-02-20 23:54:00 OH 0 0 0 0 40.2952 -82.9659 0.13 80.0 FEBRUARY \n", "2014-02-21 00:28:00 AL 0 2 1 0 34.4941 -85.6754 0.83 50.0 FEBRUARY \n", "2014-02-21 01:56:00 AL 0 0 0 0 33.6512 -86.4678 4.2 150.0 FEBRUARY \n", "2014-02-21 07:21:00 GA 0 2 0 0 32.5745 -82.9754 17.47 200.0 FEBRUARY \n", "2014-02-21 07:29:00 GA 0 0 0 0 31.43 -83.576 2.22 300.0 FEBRUARY \n", "2014-02-21 11:15:00 NC 0 0 0 0 34.6697 -79.2903 0.49 25.0 FEBRUARY \n", "2014-02-21 11:23:00 MD 0 0 0 0 38.242 -76.68 23.63 75.0 FEBRUARY \n", "2014-02-21 11:38:00 NC 0 0 0 0 34.7993 -78.9753 0.16 35.0 FEBRUARY \n", "2014-02-21 12:26:00 NC 0 1 0 0 35.277 -78.258 0.83 175.0 FEBRUARY \n", "2014-02-28 20:17:00 CA 0 0 0 0 38.6297 -121.706 0.74 50.0 FEBRUARY \n", "2014-03-01 13:40:00 AZ 0 0 0 0 33.4176 -111.854 0.45 100.0 MARCH \n", "2014-03-06 11:00:00 FL 0 0 0 0 27.865 -82.85 0.05 10.0 MARCH \n", "2014-03-06 11:38:00 FL 0 0 0 0 27.982 -82.604 1.38 15.0 MARCH \n", "2014-03-06 13:30:00 FL 0 0 0 0 26.5793 -80.713 0.25 50.0 MARCH \n", "2014-03-25 20:15:00 CA 0 0 0 0 39.71 -121.67 0.26 10.0 MARCH \n", "2014-03-26 18:24:00 CA 0 0 0 0 38.8051 -121.534 0.63 25.0 MARCH \n", "2014-03-26 18:30:00 CA 0 1 0 0 39.5905 -122.089 0.7 50.0 MARCH \n", "2014-03-26 18:33:00 CA 0 1 0 0 39.5722 -122.099 0.95 50.0 MARCH \n", "2014-03-26 18:45:00 CA 0 1 0 0 39.5845 -122.145 0.58 50.0 MARCH \n", "2014-03-26 19:10:00 CA 0 0 0 0 38.7624 -121.416 4.02 20.0 MARCH \n", "2014-03-27 15:03:00 MO 0 1 0 0 39.91 -94.2 9.25 200.0 MARCH \n", "2014-03-27 15:22:00 MO 0 2 0 0 40.03 -94.0 2.98 100.0 MARCH \n", "2014-03-27 15:41:00 IA 0 0 0 0 40.9854 -93.7744 0.73 75.0 MARCH \n", "2014-03-27 15:55:00 MO 0 0 0 0 40.1 -93.66 12.84 500.0 MARCH \n", "2014-03-28 20:23:00 LA 0 1 0 0 31.4215 -92.4232 1.52 200.0 MARCH \n", "2014-03-29 12:20:00 FL 0 0 0 0 28.3892 -81.1332 2.43 100.0 MARCH \n", "2014-03-29 18:57:00 NC 0 0 0 0 35.591 -78.6905 0.18 145.0 MARCH \n", "2014-03-29 19:08:00 NC 0 0 0 0 35.6539 -78.6334 0.12 75.0 MARCH \n", "2014-03-29 20:40:00 CA 0 0 0 0 39.8435 -121.974 0.01 10.0 MARCH \n", "2014-03-31 14:50:00 MN 0 0 0 0 44.554 -95.9919 10.67 100.0 MARCH \n", "2014-04-02 17:55:00 KS 0 0 0 0 37.0007 -98.3685 0.26 40.0 APRIL \n", "2014-04-02 19:23:00 KS 0 0 0 0 37.2559 -95.9653 0.02 10.0 APRIL \n", "2014-04-03 04:19:00 MO 0 1 0 0 38.67 -90.3625 0.63 100.0 APRIL \n", "2014-04-03 07:30:00 IL 0 1 0 0 38.1057 -88.2256 0.99 90.0 APRIL \n", "2014-04-03 18:27:00 TX 0 0 1 0 33.1851 -96.5234 0.94 40.0 APRIL \n", "2014-04-03 18:56:00 MO 0 0 0 0 36.7518 -90.5799 0.19 50.0 APRIL \n", "2014-04-03 19:03:00 TX 0 1 4 0 33.1959 -96.2488 11.8 750.0 APRIL \n", "2014-04-03 19:40:00 IL 0 0 0 0 37.4657 -89.3103 0.27 50.0 APRIL \n", "2014-04-03 19:52:00 IL 0 0 0 0 37.5092 -89.167 5.03 85.0 APRIL \n", "2014-04-03 20:00:00 MO 0 1 0 0 36.8006 -90.2088 0.55 75.0 APRIL \n", "2014-04-03 20:00:00 IL 0 0 0 0 37.5429 -89.0922 3.18 75.0 APRIL \n", "2014-04-03 20:01:00 MO 0 1 0 0 36.8047 -90.2004 7.43 75.0 APRIL \n", "2014-04-03 20:20:00 TX 0 0 1 0 33.2671 -95.587 0.56 250.0 APRIL \n", "2014-04-03 20:25:00 IL 0 1 0 0 37.6192 -88.8914 0.77 50.0 APRIL \n", "2014-04-03 20:40:00 MO 0 2 0 0 36.6843 -90.8698 3.48 220.0 APRIL \n", "2014-04-04 06:23:00 LA 0 1 0 0 30.3977 -93.1845 1.84 100.0 APRIL \n", "2014-04-04 07:11:00 LA 0 0 0 0 30.3718 -92.5016 0.81 50.0 APRIL \n", "2014-04-06 18:41:00 MS 0 1 0 0 32.8022 -89.0136 1.25 150.0 APRIL \n", "2014-04-07 01:02:00 MS 0 2 8 0 31.6717 -89.6567 16.48 600.0 APRIL \n", "2014-04-07 11:55:00 GA 0 1 0 0 31.5444 -83.2685 1.93 165.0 APRIL \n", "2014-04-07 13:49:00 NC 0 2 5 0 35.57 -76.66 4.7 300.0 APRIL \n", "2014-04-07 14:00:00 NC 0 1 0 0 35.6 -76.54 1.32 200.0 APRIL \n", "2014-04-07 15:23:00 FL 0 0 0 0 30.3879 -84.1433 0.51 50.0 APRIL \n", "2014-04-07 19:50:00 GA 0 0 3 0 33.3025 -84.385 0.94 150.0 APRIL \n", "2014-04-13 14:46:00 TX 0 0 0 0 33.0181 -94.9673 0.28 25.0 APRIL \n", "2014-04-13 15:45:00 TX 0 1 1 0 31.1251 -95.4477 0.79 20.0 APRIL \n", "2014-04-13 16:56:00 IA 0 0 0 0 41.488 -91.4437 1.3 25.0 APRIL \n", "2014-04-13 16:58:00 OK 0 0 0 0 34.59 -97.71 0.37 50.0 APRIL \n", "2014-04-13 17:05:00 OK 0 0 0 0 34.58 -97.66 0.3 40.0 APRIL \n", "2014-04-13 19:45:00 AR 0 1 0 0 35.3658 -94.0375 5.4 450.0 APRIL \n", "2014-04-20 16:10:00 KS 0 0 0 0 39.4 -100.938 0.1 10.0 APRIL \n", "2014-04-20 16:30:00 TX 0 0 0 0 34.51 -100.07 0.2 50.0 APRIL \n", "2014-04-20 16:47:00 KS 0 0 0 0 39.6128 -101.151 0.1 10.0 APRIL \n", "2014-04-24 13:59:00 NC 0 1 0 0 36.2015 -77.9465 1.86 75.0 APRIL \n", "2014-04-24 21:45:00 IL 0 1 0 0 37.7305 -89.3434 2.21 100.0 APRIL \n", "2014-04-25 14:38:00 NC 0 0 0 0 35.479 -77.782 0.27 50.0 APRIL \n", "2014-04-25 14:46:00 NC 0 1 0 0 35.53 -77.74 4.18 125.0 APRIL \n", "2014-04-25 15:18:00 NC 0 0 0 0 35.6 -77.46 0.01 20.0 APRIL \n", "2014-04-25 17:20:00 NC 0 2 0 0 0.0 0.0 0.0 0.0 APRIL \n", "2014-04-25 17:22:00 NC 0 2 2 0 36.06 -76.705 33.46 400.0 APRIL \n", "2014-04-25 17:22:00 NC 0 2 0 0 35.47 -77.26 1.13 75.0 APRIL \n", "2014-04-25 17:35:00 NC 0 3 16 0 35.51 -77.12 20.99 350.0 APRIL \n", "2014-04-25 17:50:00 NC 0 1 0 0 36.2 -76.28 6.21 200.0 APRIL \n", "2014-04-25 18:12:00 NC 0 0 0 0 36.338 -76.241 0.47 50.0 APRIL \n", "2014-04-25 18:28:00 NC 0 0 0 0 36.1985 -75.871 0.83 30.0 APRIL \n", "2014-04-27 11:51:00 MO 0 0 0 0 38.9934 -93.9689 2.38 50.0 APRIL \n", "2014-04-27 13:26:00 NE 0 0 0 0 40.3448 -98.885 0.14 35.0 APRIL \n", "2014-04-27 15:40:00 NE 0 0 0 0 40.9527 -97.7065 0.07 45.0 APRIL \n", "2014-04-27 15:40:00 IA 0 0 0 0 41.9625 -91.3819 0.5 50.0 APRIL \n", "2014-04-27 16:17:00 NE 0 0 0 0 41.2007 -97.7065 0.4 45.0 APRIL \n", "2014-04-27 16:31:00 OK 0 1 0 0 34.548 -94.7109 1.5 250.0 APRIL \n", "2014-04-27 16:35:00 KS 0 2 25 0 36.9987 -94.753 4.27 150.0 APRIL \n", "2014-04-27 16:40:00 KS 0 2 0 0 37.9269 -94.7125 16.13 400.0 APRIL \n", "2014-04-27 16:48:00 KS 0 2 0 0 38.0371 -94.6419 8.5 400.0 APRIL \n", "2014-04-27 17:15:00 MO 0 0 0 0 37.7302 -94.3995 0.34 100.0 APRIL \n", "2014-04-27 18:30:00 WA 0 0 0 0 46.8649 -122.262 0.2 25.0 APRIL \n", "2014-04-27 19:16:00 AR 0 2 1 0 35.2491 -91.9215 7.32 880.0 APRIL \n", "2014-04-27 19:38:00 AR 0 0 0 0 35.4236 -91.674 1.64 250.0 APRIL \n", "2014-04-27 19:43:00 AR 0 1 0 0 35.4639 -91.6414 5.28 100.0 APRIL \n", "2014-04-27 19:52:00 AR 0 1 0 0 35.5439 -91.5524 0.84 50.0 APRIL \n", "2014-04-27 22:45:00 MO 0 0 0 0 36.91 -92.81 0.88 100.0 APRIL \n", "2014-04-28 02:09:00 LA 0 2 0 0 32.8866 -93.875 5.06 550.0 APRIL \n", "2014-04-28 05:46:00 TN 0 0 0 0 35.3615 -89.7486 1.54 75.0 APRIL \n", "2014-04-28 11:36:00 TN 0 1 0 0 35.8808 -85.2931 2.05 100.0 APRIL \n", "2014-04-28 12:57:00 MS 0 0 0 0 32.7526 -90.6067 0.24 50.0 APRIL \n", "2014-04-28 13:38:00 MS 0 3 32 0 34.2261 -88.8242 30.97 440.0 APRIL \n", "2014-04-28 13:51:00 MS 0 1 0 0 33.4039 -89.6647 3.41 100.0 APRIL \n", "2014-04-28 14:56:00 AL 0 1 0 0 34.5219 -87.7494 3.19 100.0 APRIL \n", "2014-04-28 15:56:00 MS 0 1 1 0 32.2835 -90.8697 4.67 200.0 APRIL \n", "2014-04-28 16:10:00 TN 0 2 1 0 36.4286 -89.1416 9.84 150.0 APRIL \n", "2014-04-28 16:10:00 TN 0 2 1 0 36.4286 -89.1416 12.08 150.0 APRIL \n", "2014-04-28 16:14:00 MS 0 1 0 0 33.23 -88.79 7.11 100.0 APRIL \n", "2014-04-28 16:20:00 MS 0 1 0 0 32.3559 -90.5975 13.75 500.0 APRIL \n", "2014-04-28 16:24:00 KY 0 1 0 0 36.5028 -89.0289 2.24 60.0 APRIL \n", "2014-04-28 16:38:00 AL 0 0 0 0 34.1854 -87.998 7.72 100.0 APRIL \n", "2014-04-28 16:39:00 MS 0 1 0 0 33.3011 -88.6286 0.64 100.0 APRIL \n", "2014-04-28 16:46:00 KY 0 0 0 0 36.6537 -88.8654 1.03 25.0 APRIL \n", "2014-04-28 16:48:00 MS 0 1 0 0 32.1229 -90.6352 10.86 300.0 APRIL \n", "2014-04-28 16:50:00 AL 0 1 0 0 34.9476 -86.6465 8.91 100.0 APRIL \n", "2014-04-28 16:53:00 MS 0 2 0 0 33.3664 -88.538 10.31 300.0 APRIL \n", "2014-04-28 17:00:00 MS 0 1 0 0 32.5141 -90.1947 3.82 200.0 APRIL \n", "2014-04-28 17:00:00 GA 0 2 0 0 33.122 -85.0556 5.7 150.0 APRIL \n", "2014-04-28 17:08:00 MS 0 1 0 0 33.49 -88.39 6.35 250.0 APRIL \n", "2014-04-28 17:09:00 TN 0 2 0 0 35.0186 -86.4875 9.53 250.0 APRIL \n", "2014-04-28 17:13:00 MS 0 0 0 0 32.5886 -90.0994 0.8 75.0 APRIL \n", "2014-04-28 17:19:00 MS 0 1 0 0 33.5251 -88.3037 1.95 100.0 APRIL \n", "2014-04-28 17:19:00 MS 0 1 0 0 33.5251 -88.3037 10.03 500.0 APRIL \n", "2014-04-28 17:22:00 AL 0 1 0 0 33.5379 -88.2741 8.08 500.0 APRIL \n", "2014-04-28 17:38:00 MS 0 2 0 0 33.4382 -88.4064 8.06 300.0 APRIL \n", "2014-04-28 17:38:00 MS 0 2 5 0 33.4382 -88.4064 14.27 500.0 APRIL \n", "2014-04-28 17:54:00 AL 0 2 5 0 33.4888 -88.2802 6.21 500.0 APRIL \n", "2014-04-28 18:08:00 MS 0 1 0 0 32.6746 -89.4246 5.05 100.0 APRIL \n", "2014-04-28 18:35:00 AL 0 1 0 0 33.8878 -87.7094 6.97 350.0 APRIL \n", "2014-04-28 18:36:00 MS 0 3 3 0 32.3703 -89.4564 4.27 150.0 APRIL \n", "2014-04-28 18:54:00 MS 0 1 0 0 32.3824 -89.2825 9.57 150.0 APRIL \n", "2014-04-28 19:12:00 MS 0 2 0 0 32.4116 -89.1147 5.59 400.0 APRIL \n", "2014-04-28 19:18:00 AL 0 1 0 0 34.7945 -85.6557 6.13 100.0 APRIL \n", "2014-04-28 19:35:00 MS 0 1 0 0 32.4262 -88.9417 13.11 100.0 APRIL \n", "2014-04-28 19:40:00 AL 0 1 0 0 33.8344 -87.1945 2.39 150.0 APRIL \n", "2014-04-28 20:30:00 AL 0 1 0 0 32.4208 -88.271 1.03 150.0 APRIL \n", "2014-04-28 20:39:00 AL 0 3 0 0 34.0957 -86.7598 8.88 350.0 APRIL \n", "2014-04-28 20:40:00 MS 0 3 15 0 31.7419 -89.0892 10.46 880.0 APRIL \n", "2014-04-28 20:59:00 AL 0 1 13 0 33.0625 -87.6345 12.47 1500.0 APRIL \n", "2014-04-28 21:00:00 AL 0 1 4 0 33.7514 -86.8303 8.78 800.0 APRIL \n", "2014-04-28 21:05:00 GA 0 1 0 0 34.951 -84.8718 3.95 100.0 APRIL \n", "2014-04-28 21:05:00 TN 0 1 0 0 34.9876 -84.8321 0.56 100.0 APRIL \n", "2014-04-28 21:05:00 GA 0 1 0 0 34.951 -84.8718 3.39 100.0 APRIL \n", "2014-04-28 21:09:00 MS 0 2 0 0 31.7579 -88.7559 9.2 250.0 APRIL \n", "2014-04-28 21:13:00 AL 0 2 3 0 33.5856 -87.0055 5.46 1800.0 APRIL \n", "2014-04-28 21:55:00 AL 0 1 0 0 33.3129 -87.2197 4.46 675.0 APRIL \n", "2014-04-28 22:00:00 AL 0 1 0 0 33.3162 -87.111 7.62 913.0 APRIL \n", "2014-04-28 22:16:00 AL 0 2 0 0 33.3592 -86.995 5.14 600.0 APRIL \n", "2014-04-28 22:22:00 AL 0 1 0 0 33.8908 -86.4871 7.81 1000.0 APRIL \n", "2014-04-28 23:15:00 AL 0 1 0 0 31.5759 -87.7633 0.31 200.0 APRIL \n", "2014-04-28 23:24:00 AL 0 2 2 0 33.7993 -86.5395 14.6 1300.0 APRIL \n", "2014-04-28 23:32:00 AL 0 3 0 0 34.1703 -86.0439 11.73 600.0 APRIL \n", "2014-04-28 23:54:00 AL 0 2 0 0 34.3073 -85.9305 2.47 200.0 APRIL \n", "2014-04-29 00:06:00 AL 0 2 0 0 34.3491 -85.8401 11.71 200.0 APRIL \n", "2014-04-29 00:17:00 AL 0 1 0 0 34.0896 -86.155 6.28 200.0 APRIL \n", "2014-04-29 00:28:00 AL 0 0 0 0 34.2243 -86.0781 2.42 75.0 APRIL \n", "2014-04-29 00:36:00 AL 0 1 0 0 34.5048 -85.6174 10.2 200.0 APRIL \n", "2014-04-29 01:23:00 AL 0 1 0 0 34.4282 -85.6466 1.05 200.0 APRIL \n", "2014-04-29 02:25:00 AL 0 0 0 0 32.417 -85.4585 1.74 75.0 APRIL \n", "2014-04-29 02:56:00 AL 0 3 13 0 32.465 -85.2336 11.45 1200.0 APRIL \n", "2014-04-29 12:25:00 NC 0 0 0 0 35.17 -77.35 0.04 25.0 APRIL \n", "2014-04-29 13:52:00 NC 0 1 0 0 35.02 -78.682 1.72 200.0 APRIL \n", "2014-04-29 16:09:00 NC 0 0 0 0 35.848 -77.434 4.15 100.0 APRIL \n", "2014-04-29 17:49:00 NC 0 0 0 0 35.441 -77.7891 0.02 25.0 APRIL \n", "2014-04-29 18:10:00 NC 0 1 0 0 35.1491 -78.3948 0.81 100.0 APRIL \n", "2014-04-30 00:44:00 FL 0 1 0 0 30.8785 -85.5282 1.62 100.0 APRIL \n", "2014-04-30 00:52:00 FL 0 1 0 0 30.8788 -85.3641 4.61 150.0 APRIL \n", "2014-05-06 14:05:00 WY 0 0 0 0 43.2194 -108.383 4.79 30.0 MAY \n", "2014-05-06 14:07:00 WY 0 1 0 0 43.2966 -108.337 1.52 50.0 MAY \n", "2014-05-07 15:08:00 WY 0 0 0 0 41.905 -109.385 0.53 30.0 MAY \n", "2014-05-07 15:15:00 CO 0 0 0 0 40.23 -104.81 2.62 100.0 MAY \n", "2014-05-07 16:05:00 CO 0 0 0 0 40.02 -103.03 0.1 50.0 MAY \n", "2014-05-07 16:22:00 CO 0 0 0 0 40.13 -103.08 5.46 100.0 MAY \n", "2014-05-07 17:25:00 CO 0 0 0 0 40.6 -102.63 0.1 50.0 MAY \n", "2014-05-07 18:03:00 TX 0 0 0 0 34.033 -98.602 0.2 75.0 MAY \n", "2014-05-07 18:06:00 OK 0 0 0 0 34.767 -98.697 1.5 400.0 MAY \n", "2014-05-08 12:45:00 MO 0 0 0 0 36.7525 -93.9845 2.39 50.0 MAY \n", "2014-05-08 14:15:00 TX 0 0 0 0 32.757 -96.889 0.46 120.0 MAY \n", "2014-05-08 15:10:00 CO 0 0 0 0 39.08 -103.62 0.1 50.0 MAY \n", "2014-05-08 15:27:00 CO 0 0 0 0 39.05 -103.57 0.1 50.0 MAY \n", "2014-05-08 15:51:00 MN 0 0 0 0 43.9552 -94.6083 0.83 50.0 MAY \n", "2014-05-08 16:09:00 MN 0 0 0 0 44.1073 -94.379 2.1 50.0 MAY \n", "2014-05-08 16:10:00 MO 0 1 0 0 36.9964 -92.7143 2.5 100.0 MAY \n", "2014-05-08 19:44:00 AR 0 1 0 0 35.3094 -93.1162 1.66 50.0 MAY \n", "2014-05-10 11:47:00 ID 0 0 0 0 43.9914 -112.615 0.02 15.0 MAY \n", "2014-05-10 14:07:00 AL 0 1 0 0 31.0012 -85.6421 2.15 100.0 MAY \n", "2014-05-10 16:15:00 MO 0 2 0 0 39.2115 -94.1926 12.63 500.0 MAY \n", "2014-05-10 17:00:00 MO 0 0 0 0 39.2118 -93.8694 0.64 25.0 MAY \n", "2014-05-10 18:26:00 MO 0 1 0 0 39.1665 -93.172 7.27 1350.0 MAY \n", "2014-05-10 19:16:00 KS 0 0 0 0 37.6598 -96.2804 0.08 75.0 MAY \n", "2014-05-11 14:26:00 NE 0 0 0 0 40.3824 -98.2745 0.07 150.0 MAY \n", "2014-05-11 14:50:00 NE 0 3 0 0 40.4926 -98.1207 20.21 1300.0 MAY \n", "2014-05-11 15:24:00 IA 0 0 0 0 40.6059 -91.5592 0.1 30.0 MAY \n", "2014-05-11 15:25:00 NE 0 2 0 0 40.6638 -97.7309 9.38 750.0 MAY \n", "2014-05-11 15:25:00 NE 0 0 0 0 40.6185 -97.6994 0.04 100.0 MAY \n", "2014-05-11 15:40:00 NE 0 1 0 0 40.6424 -97.5922 6.14 150.0 MAY \n", "2014-05-11 15:57:00 NE 0 3 0 0 40.6922 -97.4531 19.14 2640.0 MAY \n", "2014-05-11 16:04:00 NE 0 0 0 0 40.7501 -97.3875 0.61 25.0 MAY \n", "2014-05-11 16:13:00 NE 0 0 0 0 40.79 -97.29 1.71 100.0 MAY \n", "2014-05-11 16:23:00 NE 0 2 0 0 40.77 -97.2 7.96 500.0 MAY \n", "2014-05-11 16:53:00 NE 0 2 0 0 40.872 -97.0351 4.67 330.0 MAY \n", "2014-05-11 16:58:00 NE 0 1 0 0 40.7407 -97.3808 5.55 700.0 MAY \n", "2014-05-11 17:07:00 NE 0 1 0 0 40.9211 -96.9135 3.0 400.0 MAY \n", "2014-05-11 17:11:00 NE 0 2 0 0 40.97 -96.7955 2.5 300.0 MAY \n", "2014-05-11 17:12:00 KS 0 1 0 0 38.1383 -99.2157 3.3 150.0 MAY \n", "2014-05-11 17:20:00 NE 0 1 0 0 40.959 -96.7986 5.27 280.0 MAY \n", "2014-05-11 17:42:00 NE 0 0 0 0 41.0609 -96.6082 1.8 200.0 MAY \n", "2014-05-11 17:44:00 KS 0 0 0 0 37.8772 -99.4722 0.75 25.0 MAY \n", "2014-05-11 17:55:00 NE 0 1 1 0 40.2988 -97.2741 15.5 500.0 MAY \n", "2014-05-11 17:59:00 NE 0 1 0 0 41.1632 -96.3776 10.69 800.0 MAY \n", "2014-05-11 18:21:00 NE 0 1 0 0 41.2989 -96.254 5.16 200.0 MAY \n", "2014-05-11 18:32:00 SD 0 0 0 0 42.8713 -96.7332 2.4 50.0 MAY \n", "2014-05-11 19:35:00 IA 0 1 0 0 43.0973 -96.0144 3.91 100.0 MAY \n", "2014-05-11 19:44:00 KS 0 0 0 0 38.1762 -98.5622 3.43 50.0 MAY \n", "2014-05-11 19:50:00 IA 0 0 0 0 43.1031 -95.9293 0.86 50.0 MAY \n", "2014-05-11 19:59:00 IA 0 0 0 0 43.178 -95.814 0.49 50.0 MAY \n", "2014-05-11 20:03:00 KS 0 0 0 0 37.5155 -98.9246 4.6 50.0 MAY \n", "2014-05-11 20:12:00 KS 0 0 0 0 38.191 -98.2257 0.42 50.0 MAY \n", "2014-05-11 20:20:00 KS 0 0 0 0 38.2345 -98.2205 1.02 50.0 MAY \n", "2014-05-11 20:43:00 IA 0 2 0 0 41.6108 -94.5128 10.35 240.0 MAY \n", "2014-05-11 20:51:00 KS 0 0 0 0 38.2951 -97.789 1.25 75.0 MAY \n", "2014-05-11 20:54:00 KS 0 0 0 0 38.2239 -97.8003 0.68 50.0 MAY \n", "2014-05-11 20:56:00 IA 0 1 0 0 41.7239 -94.4243 4.33 190.0 MAY \n", "2014-05-11 21:05:00 KS 0 0 0 0 38.363 -97.6304 1.13 75.0 MAY \n", "2014-05-11 21:21:00 IA 0 0 0 0 41.7351 -93.9776 5.91 100.0 MAY \n", "2014-05-11 21:44:00 IA 0 0 0 0 41.9471 -93.7634 1.68 100.0 MAY \n", "2014-05-12 17:45:00 OH 0 0 0 0 41.3474 -82.0332 1.08 100.0 MAY \n", "2014-05-12 18:15:00 OH 0 0 0 0 41.086 -81.864 0.21 40.0 MAY \n", "2014-05-14 12:23:00 KY 0 0 0 0 37.9318 -85.5882 1.5 50.0 MAY \n", "2014-05-14 13:18:00 AL 0 0 0 0 31.9493 -85.7406 0.87 200.0 MAY \n", "2014-05-14 13:21:00 AL 0 0 0 0 32.903 -85.9304 1.89 150.0 MAY \n", "2014-05-14 14:28:00 AL 0 0 0 0 33.2496 -85.949 0.1 30.0 MAY \n", "2014-05-14 14:30:00 NE 0 0 0 0 42.07 -103.24 0.78 30.0 MAY \n", "2014-05-14 15:36:00 KY 0 2 0 0 36.9142 -87.4512 3.74 150.0 MAY \n", "2014-05-14 15:44:00 OH 0 3 0 0 39.6808 -83.848 8.93 400.0 MAY \n", "2014-05-14 21:49:00 GA 0 0 0 0 32.1861 -83.1767 1.72 100.0 MAY \n", "2014-05-14 22:03:00 GA 0 1 0 0 34.3542 -83.5003 7.75 200.0 MAY \n", "2014-05-15 04:46:00 NC 0 0 0 0 35.1297 -80.9008 0.5 40.0 MAY \n", "2014-05-15 07:15:00 FL 0 1 0 0 30.1615 -82.7894 0.4 50.0 MAY \n", "2014-05-15 12:29:00 FL 0 0 0 0 25.7858 -80.3288 0.27 30.0 MAY \n", "2014-05-15 16:10:00 NC 0 1 0 0 35.9538 -78.9347 0.76 150.0 MAY \n", "2014-05-15 17:03:00 PA 0 0 0 0 41.133 -77.431 0.32 100.0 MAY \n", "2014-05-16 01:31:00 VA 0 0 0 0 38.9626 -77.6952 0.4 75.0 MAY \n", "2014-05-18 17:50:00 MT 0 0 0 0 45.16 -105.16 0.1 25.0 MAY \n", "2014-05-18 18:35:00 NE 0 0 0 0 42.01 -103.45 2.07 30.0 MAY \n", "2014-05-18 19:20:00 NE 0 0 0 0 42.1 -103.15 6.18 30.0 MAY \n", "2014-05-20 17:25:00 NE 0 0 0 0 41.9258 -103.924 0.68 25.0 MAY \n", "2014-05-21 13:38:00 NV 0 0 0 0 40.8515 -115.741 0.23 25.0 MAY \n", "2014-05-21 13:48:00 NV 0 0 0 0 40.8362 -115.783 0.26 125.0 MAY \n", "2014-05-21 14:05:00 CO 0 0 0 0 39.7 -104.81 0.1 50.0 MAY \n", "2014-05-21 14:30:00 CO 0 0 0 0 39.7607 -104.81 0.1 50.0 MAY \n", "2014-05-21 14:45:00 CO 0 0 0 0 39.75 -104.6 0.1 50.0 MAY \n", "2014-05-21 16:20:00 CO 0 0 0 0 39.73 -104.17 0.1 50.0 MAY \n", "2014-05-21 17:06:00 CO 0 0 0 0 39.87 -104.04 0.1 50.0 MAY \n", "2014-05-21 17:30:00 NV 0 0 0 0 40.21 -116.93 0.24 50.0 MAY \n", "2014-05-21 18:40:00 ID 0 0 0 0 42.8465 -113.049 3.0 20.0 MAY \n", "2014-05-21 19:15:00 WY 0 0 0 0 42.2021 -105.005 0.94 25.0 MAY \n", "2014-05-22 12:45:00 CO 0 0 0 0 37.5979 -105.613 0.3 25.0 MAY \n", "2014-05-22 13:33:00 NY 0 3 0 0 42.82 -74.19 6.79 440.0 MAY \n", "2014-05-22 14:54:00 DE 0 1 2 0 39.098 -75.667 0.35 50.0 MAY \n", "2014-05-22 15:45:00 VA 0 0 0 0 37.26 -77.24 0.69 25.0 MAY \n", "2014-05-22 16:05:00 VA 0 0 0 0 37.78 -76.94 0.85 50.0 MAY \n", "2014-05-22 16:20:00 VA 0 0 0 0 37.05 -77.1 1.38 100.0 MAY \n", "2014-05-23 13:35:00 WY 0 0 0 0 42.7319 -106.423 2.0 40.0 MAY \n", "2014-05-23 19:05:00 NM 0 0 0 0 32.2718 -103.467 3.65 200.0 MAY \n", "2014-05-24 14:36:00 WY 0 0 0 0 44.9217 -108.443 0.77 20.0 MAY \n", "2014-05-24 16:21:00 TX 0 0 0 0 30.9255 -101.836 0.12 50.0 MAY \n", "2014-05-25 11:39:00 CO 0 0 0 0 38.9285 -105.267 0.08 25.0 MAY \n", "2014-05-25 12:45:00 TX 0 0 0 0 30.3808 -102.874 1.16 200.0 MAY \n", "2014-05-26 10:46:00 TX 0 0 0 0 30.0941 -97.4599 0.5 30.0 MAY \n", "2014-05-26 11:50:00 ME 0 0 0 0 46.148 -67.992 0.23 180.0 MAY \n", "2014-05-26 14:38:00 TX 0 0 0 0 32.4985 -102.105 0.6 200.0 MAY \n", "2014-05-26 15:20:00 TX 0 0 0 0 28.0553 -97.6463 0.12 50.0 MAY \n", "2014-05-26 16:38:00 TX 0 2 0 0 32.2946 -101.286 1.01 400.0 MAY \n", "2014-05-26 16:52:00 TX 0 0 0 0 33.5125 -102.198 2.05 30.0 MAY \n", "2014-05-26 16:57:00 TX 0 0 0 0 31.8935 -101.594 1.33 500.0 MAY \n", "2014-05-26 17:26:00 TX 0 0 0 0 31.87 -101.381 0.67 200.0 MAY \n", "2014-05-26 17:42:00 TX 0 0 0 0 31.8462 -101.355 0.79 300.0 MAY \n", "2014-05-26 17:47:00 TX 0 0 0 0 31.72 -101.21 0.22 40.0 MAY \n", "2014-05-26 18:46:00 ND 0 2 9 0 47.71 -103.28 0.46 100.0 MAY \n", "2014-05-27 11:38:00 OK 0 0 0 0 35.6111 -96.0689 0.3 50.0 MAY \n", "2014-05-27 12:55:00 OK 0 0 0 0 34.18 -97.6775 0.1 30.0 MAY \n", "2014-05-27 13:00:00 OK 0 0 0 0 34.51 -98.49 0.12 50.0 MAY \n", "2014-05-27 13:17:00 SD 0 1 0 0 44.113 -103.593 2.16 300.0 MAY \n", "2014-05-27 17:30:00 TX 0 1 0 0 27.7519 -98.0538 2.34 550.0 MAY \n", "2014-05-27 18:45:00 TX 0 1 0 0 27.3649 -98.1278 5.26 650.0 MAY \n", "2014-05-28 04:32:00 LA 0 1 0 0 30.0389 -90.5975 2.55 75.0 MAY \n", "2014-05-28 11:47:00 IL 0 0 0 0 40.3673 -88.7569 0.2 50.0 MAY \n", "2014-05-28 12:40:00 IL 0 0 0 0 40.7632 -89.0007 0.61 100.0 MAY \n", "2014-05-30 14:38:00 FL 0 0 0 0 26.73 -81.16 0.25 10.0 MAY \n", "2014-05-30 14:45:00 FL 0 0 0 0 27.8175 -82.2657 0.45 50.0 MAY \n", "2014-05-30 16:30:00 SD 0 0 0 0 44.604 -99.278 3.65 50.0 MAY \n", "2014-05-30 16:44:00 SD 0 0 0 0 44.651 -99.312 1.77 50.0 MAY \n", "2014-05-31 08:30:00 SC 0 0 0 0 32.6005 -80.0889 0.11 30.0 MAY \n", "2014-05-31 13:34:00 WY 0 0 0 0 43.34 -110.006 0.32 30.0 MAY \n", "2014-05-31 14:55:00 MT 0 0 0 0 46.73 -106.76 0.1 25.0 MAY \n", "2014-05-31 19:15:00 MT 0 0 0 0 45.86 -105.68 0.1 25.0 MAY \n", "2014-06-01 11:42:00 IA 0 0 0 0 43.3731 -93.931 1.08 25.0 JUNE \n", "2014-06-01 16:43:00 KS 0 0 0 0 39.7684 -97.8971 0.09 50.0 JUNE \n", "2014-06-01 17:12:00 KS 0 0 0 0 39.7145 -97.58 0.01 25.0 JUNE \n", "2014-06-01 17:21:00 ND 0 0 0 0 46.85 -97.29 0.1 25.0 JUNE \n", "2014-06-01 18:03:00 ND 0 0 0 0 46.98 -98.94 0.04 20.0 JUNE \n", "2014-06-02 20:15:00 KY 0 1 0 0 37.0083 -88.5071 1.53 150.0 JUNE \n", "2014-06-03 12:07:00 WY 0 0 0 0 43.7665 -108.864 2.21 30.0 JUNE \n", "2014-06-03 15:18:00 NE 0 0 0 0 41.7341 -99.0582 1.15 50.0 JUNE \n", "2014-06-03 16:01:00 NE 0 0 0 0 41.6372 -98.5321 0.01 25.0 JUNE \n", "2014-06-03 16:02:00 IA 0 2 0 0 41.3174 -95.5606 2.81 680.0 JUNE \n", "2014-06-03 19:20:00 KS 0 0 0 0 38.11 -101.26 0.7 50.0 JUNE \n", "2014-06-03 21:30:00 KS 0 3 2 0 39.97 -96.0455 6.33 500.0 JUNE \n", "2014-06-03 21:33:00 NE 0 1 0 0 40.9207 -97.903 4.12 700.0 JUNE \n", "2014-06-03 22:24:00 KS 0 1 0 0 39.7204 -95.466 2.62 200.0 JUNE \n", "2014-06-04 04:25:00 IL 0 0 0 0 39.1737 -90.3107 1.44 30.0 JUNE \n", "2014-06-04 09:55:00 OH 0 0 0 0 38.6406 -83.2187 1.24 300.0 JUNE \n", "2014-06-04 13:40:00 OH 0 0 0 0 39.1906 -83.8202 4.11 200.0 JUNE \n", "2014-06-04 16:01:00 CO 0 0 0 0 39.76 -104.4 0.1 50.0 JUNE \n", "2014-06-04 17:16:00 KY 0 1 0 0 37.5398 -87.9671 1.14 100.0 JUNE \n", "2014-06-04 17:30:00 KY 0 1 0 0 37.504 -87.914 1.08 75.0 JUNE \n", "2014-06-04 19:30:00 WV 0 1 0 0 38.478 -82.2242 0.51 400.0 JUNE \n", "2014-06-04 20:15:00 CO 0 0 0 0 39.56 -103.58 0.1 50.0 JUNE \n", "2014-06-04 22:15:00 CO 0 1 0 0 39.2971 -103.742 5.24 200.0 JUNE \n", "2014-06-04 22:44:00 CO 0 0 0 0 39.17 -103.32 3.39 100.0 JUNE \n", "2014-06-05 13:14:00 SD 0 0 0 0 43.63 -96.9 0.17 50.0 JUNE \n", "2014-06-05 13:51:00 NE 0 1 0 0 42.1761 -96.5012 1.49 100.0 JUNE \n", "2014-06-05 14:40:00 SD 0 0 0 0 43.41 -96.664 0.4 50.0 JUNE \n", "2014-06-05 15:25:00 ND 0 0 0 0 46.0193 -97.9442 0.1 10.0 JUNE \n", "2014-06-05 15:34:00 AL 0 1 0 0 34.7135 -86.9759 0.74 100.0 JUNE \n", "2014-06-05 16:02:00 ND 0 0 0 0 46.7493 -97.3052 0.1 10.0 JUNE \n", "2014-06-05 16:05:00 MN 0 0 0 0 43.71 -96.32 0.25 50.0 JUNE \n", "2014-06-05 17:21:00 GA 0 0 0 0 34.6123 -84.5534 0.77 50.0 JUNE \n", "2014-06-05 17:49:00 MN 0 0 0 0 43.92 -95.94 0.28 50.0 JUNE \n", "2014-06-05 20:07:00 CO 0 0 0 0 38.1625 -102.975 0.42 50.0 JUNE \n", "2014-06-06 12:05:00 NE 0 0 0 0 42.78 -102.16 0.2 40.0 JUNE \n", "2014-06-06 13:00:00 NE 0 0 0 0 42.9425 -101.283 0.2 40.0 JUNE \n", "2014-06-06 13:35:00 AR 0 1 2 0 35.7888 -91.6408 3.26 75.0 JUNE \n", "2014-06-06 13:51:00 CO 0 1 1 0 37.1532 -104.411 8.58 400.0 JUNE \n", "2014-06-06 13:55:00 NE 0 0 0 0 41.13 -103.89 0.91 25.0 JUNE \n", "2014-06-06 13:56:00 CO 0 0 0 0 40.85 -104.27 0.1 50.0 JUNE \n", "2014-06-06 14:00:00 AR 0 1 0 0 35.4034 -91.1282 2.03 50.0 JUNE \n", "2014-06-06 14:20:00 CO 0 0 0 0 40.17 -104.33 0.5 100.0 JUNE \n", "2014-06-06 14:46:00 CO 0 1 0 0 37.1889 -104.179 1.35 100.0 JUNE \n", "2014-06-06 14:53:00 CO 0 0 0 0 40.82 -102.61 0.1 100.0 JUNE \n", "2014-06-06 16:25:00 NM 0 0 0 0 36.51 -104.22 0.85 100.0 JUNE \n", "2014-06-06 17:35:00 NM 0 0 0 0 34.4876 -103.335 1.24 50.0 JUNE \n", "2014-06-06 17:47:00 KS 0 0 0 0 37.99 -101.22 0.51 25.0 JUNE \n", "2014-06-06 17:58:00 KS 0 0 0 0 37.9843 -101.148 0.6 25.0 JUNE \n", "2014-06-06 17:59:00 KS 0 0 0 0 38.01 -101.13 0.34 25.0 JUNE \n", "2014-06-06 18:15:00 TX 0 0 0 0 35.6958 -102.513 2.46 25.0 JUNE \n", "2014-06-06 18:46:00 SC 0 0 0 0 33.19 -80.96 0.83 40.0 JUNE \n", "2014-06-06 18:52:00 TX 0 0 0 0 36.0816 -100.927 1.65 70.0 JUNE \n", "2014-06-07 08:33:00 NM 0 0 0 0 36.25 -103.28 0.1 20.0 JUNE \n", "2014-06-07 13:35:00 MO 0 0 0 0 38.3663 -91.4706 0.05 20.0 JUNE \n", "2014-06-07 13:48:00 KY 0 1 0 0 36.5565 -89.4974 3.02 200.0 JUNE \n", "2014-06-07 13:48:00 KY 0 1 0 0 36.5565 -89.4974 18.19 200.0 JUNE \n", "2014-06-07 14:00:00 MO 0 1 0 0 36.5218 -89.4644 3.41 200.0 JUNE \n", "2014-06-07 14:12:00 TN 0 1 0 0 36.4798 -89.4321 11.76 200.0 JUNE \n", "2014-06-07 14:56:00 MO 0 0 0 0 38.7436 -90.6011 2.67 20.0 JUNE \n", "2014-06-07 15:14:00 MO 0 0 0 0 38.7817 -90.4592 4.22 40.0 JUNE \n", "2014-06-07 16:19:00 IL 0 0 0 0 38.1657 -90.218 0.34 40.0 JUNE \n", "2014-06-07 16:43:00 IL 0 0 0 0 38.2023 -90.0563 0.3 30.0 JUNE \n", "2014-06-07 16:58:00 NM 0 0 0 0 34.2557 -105.612 0.25 50.0 JUNE \n", "2014-06-07 17:14:00 NM 0 0 0 0 34.2501 -105.639 0.1 50.0 JUNE \n", "2014-06-07 19:25:00 NM 0 0 0 0 33.6912 -104.528 3.73 50.0 JUNE \n", "2014-06-07 23:59:00 GA 0 0 0 0 33.0113 -85.1496 1.8 280.0 JUNE \n", "2014-06-08 10:55:00 CO 0 1 0 0 39.113 -105.057 0.25 100.0 JUNE \n", "2014-06-08 11:06:00 CO 0 0 0 0 39.1586 -104.921 0.1 50.0 JUNE \n", "2014-06-08 12:32:00 CO 0 2 0 0 38.98 -105.445 6.0 150.0 JUNE \n", "2014-06-08 12:54:00 CO 0 0 0 0 40.84 -104.23 0.1 50.0 JUNE \n", "2014-06-08 12:58:00 CO 0 1 1 0 39.7 -104.81 0.25 100.0 JUNE \n", "2014-06-08 13:00:00 CO 0 1 0 0 39.0196 -105.33 0.33 75.0 JUNE \n", "2014-06-08 13:00:00 WY 0 0 0 0 41.0688 -104.255 0.54 25.0 JUNE \n", "2014-06-08 13:12:00 CO 0 0 0 0 39.14 -104.82 0.1 50.0 JUNE \n", "2014-06-08 13:17:00 CO 0 0 0 0 40.12 -104.34 0.1 50.0 JUNE \n", "2014-06-08 13:43:00 CO 0 0 0 0 39.55 -104.32 0.1 50.0 JUNE \n", "2014-06-08 13:43:00 CO 0 0 0 0 39.55 -104.32 0.1 50.0 JUNE \n", "2014-06-08 14:23:00 NM 0 1 0 0 33.7 -105.381 1.75 160.0 JUNE \n", "2014-06-08 15:45:00 NM 0 0 0 0 35.91 -104.83 2.82 50.0 JUNE \n", "2014-06-08 16:35:00 NM 0 0 0 0 36.44 -104.59 1.39 50.0 JUNE \n", "2014-06-08 16:40:00 NM 0 0 0 0 36.5019 -104.538 1.08 50.0 JUNE \n", "2014-06-08 18:41:00 WV 0 1 0 0 39.456 -77.981 1.0 100.0 JUNE \n", "2014-06-08 19:05:00 NM 0 0 0 0 32.35 -104.084 0.22 200.0 JUNE \n", "2014-06-09 07:16:00 TX 0 0 0 0 33.5532 -94.8031 1.71 200.0 JUNE \n", "2014-06-09 19:30:00 AL 0 1 0 0 34.5822 -87.5607 5.86 150.0 JUNE \n", "2014-06-09 20:17:00 SC 0 0 0 0 33.3226 -80.5837 1.87 75.0 JUNE \n", "2014-06-10 12:44:00 AL 0 1 0 0 34.6437 -86.0211 8.4 300.0 JUNE \n", "2014-06-10 15:06:00 TN 0 0 0 0 35.88 -84.51 0.5 100.0 JUNE \n", "2014-06-10 17:23:00 IN 0 0 0 0 38.9889 -86.94 0.5 25.0 JUNE \n", "2014-06-11 12:14:00 ND 0 0 0 0 48.11 -98.81 0.4 30.0 JUNE \n", "2014-06-11 15:54:00 KS 0 0 0 0 38.5212 -101.685 0.1 10.0 JUNE \n", "2014-06-11 15:55:00 MI 0 1 0 0 43.24 -84.21 5.3 300.0 JUNE \n", "2014-06-11 17:10:00 PA 0 1 0 0 40.02 -78.42 10.98 100.0 JUNE \n", "2014-06-11 17:15:00 MN 0 1 0 0 46.5538 -94.9473 1.0 10.0 JUNE \n", "2014-06-11 17:18:00 SD 0 1 0 0 45.6587 -97.6692 0.11 50.0 JUNE \n", "2014-06-11 18:58:00 KS 0 1 0 0 38.7119 -101.098 0.1 25.0 JUNE \n", "2014-06-11 19:20:00 TX 0 0 0 0 31.49 -100.39 0.69 50.0 JUNE \n", "2014-06-11 19:24:00 TX 0 0 0 0 31.4479 -100.378 0.59 75.0 JUNE \n", "2014-06-12 19:18:00 TX 0 0 0 0 30.9321 -98.0402 0.12 50.0 JUNE \n", "2014-06-12 19:25:00 TX 0 2 0 0 30.8685 -98.0875 1.68 100.0 JUNE \n", "2014-06-12 21:30:00 MS 0 1 1 0 34.0312 -88.8194 1.29 200.0 JUNE \n", "2014-06-13 16:41:00 WY 0 2 1 0 44.714 -104.573 16.51 530.0 JUNE \n", "2014-06-13 16:45:00 MT 0 0 0 0 48.43 -109.23 0.25 10.0 JUNE \n", "2014-06-14 16:27:00 KS 0 1 0 0 39.4611 -99.4606 0.78 110.0 JUNE \n", "2014-06-14 17:11:00 CO 0 0 0 0 39.56 -103.53 0.1 50.0 JUNE \n", "2014-06-14 18:31:00 NE 0 0 0 0 40.2937 -99.0621 1.19 75.0 JUNE \n", "2014-06-14 19:25:00 NE 0 0 0 0 40.0516 -98.6851 0.27 25.0 JUNE \n", "2014-06-14 21:05:00 NE 0 0 0 0 40.7197 -98.2167 0.01 25.0 JUNE \n", "2014-06-14 21:24:00 NE 0 0 0 0 40.7197 -98.2167 0.01 25.0 JUNE \n", "2014-06-15 03:17:00 MO 0 0 0 0 38.7347 -94.5357 2.9 25.0 JUNE \n", "2014-06-16 14:38:00 NE 0 0 0 0 41.8596 -97.3602 1.25 100.0 JUNE \n", "2014-06-16 14:42:00 NE 0 4 0 0 41.893 -97.33 12.11 400.0 JUNE \n", "2014-06-16 14:43:00 IA 0 0 0 0 43.37 -96.31 0.2 50.0 JUNE \n", "2014-06-16 15:40:00 NE 0 4 0 0 42.127 -96.8686 15.84 530.0 JUNE \n", "2014-06-16 16:41:00 NE 0 0 0 0 42.36 -96.59 0.26 50.0 JUNE \n", "2014-06-16 16:44:00 IA 0 0 0 0 42.8956 -94.627 6.09 250.0 JUNE \n", "2014-06-16 17:22:00 IA 0 0 0 0 42.7741 -94.1259 4.61 50.0 JUNE \n", "2014-06-16 17:24:00 NE 0 0 0 0 41.7 -99.37 0.2 40.0 JUNE \n", "2014-06-16 17:35:00 NE 0 1 0 0 41.758 -99.2362 2.4 400.0 JUNE \n", "2014-06-16 17:48:00 IA 0 1 0 0 43.2062 -93.3101 3.03 110.0 JUNE \n", "2014-06-16 17:52:00 IA 0 1 0 0 42.875 -93.5054 2.57 175.0 JUNE \n", "2014-06-16 17:56:00 IA 0 0 0 0 43.2216 -93.2126 1.1 40.0 JUNE \n", "2014-06-16 18:01:00 NE 0 2 0 0 41.8028 -99.1407 5.19 500.0 JUNE \n", "2014-06-16 18:20:00 NE 0 2 0 0 41.8397 -98.9986 1.56 700.0 JUNE \n", "2014-06-16 18:28:00 NE 0 2 0 0 41.8348 -98.9567 0.3 400.0 JUNE \n", "2014-06-16 18:30:00 NE 0 0 0 0 41.8295 -98.9537 0.2 40.0 JUNE \n", "2014-06-16 18:39:00 IA 0 1 0 0 42.7918 -92.823 4.71 100.0 JUNE \n", "2014-06-16 18:45:00 IA 0 0 0 0 42.7831 -92.7498 1.72 150.0 JUNE \n", "2014-06-16 18:52:00 IA 0 1 0 0 42.7849 -92.6323 2.12 120.0 JUNE \n", "2014-06-16 19:12:00 IA 0 0 0 0 42.8134 -92.3349 2.0 75.0 JUNE \n", "2014-06-16 20:23:00 ND 0 0 0 0 46.71 -102.9 1.35 25.0 JUNE \n", "2014-06-16 20:30:00 IA 0 1 0 0 42.5412 -91.6484 1.31 50.0 JUNE \n", "2014-06-16 20:33:00 IA 0 1 0 0 42.551 -91.609 12.59 50.0 JUNE \n", "2014-06-16 21:05:00 IA 0 0 0 0 41.9792 -91.8728 0.07 30.0 JUNE \n", "2014-06-16 21:45:00 WI 0 2 5 0 42.7376 -90.5188 3.76 100.0 JUNE \n", "2014-06-16 21:49:00 WI 0 1 0 0 42.7521 -90.4731 0.49 25.0 JUNE \n", "2014-06-16 22:00:00 WI 0 1 0 0 42.8054 -90.3731 4.35 200.0 JUNE \n", "2014-06-16 22:00:00 WI 0 1 0 0 42.8119 -90.3672 1.17 50.0 JUNE \n", "2014-06-16 22:10:00 WI 0 1 0 0 42.8208 -90.2636 0.41 100.0 JUNE \n", "2014-06-16 22:36:00 WI 0 1 0 0 42.825 -89.7828 0.51 125.0 JUNE \n", "2014-06-16 22:36:00 WI 0 1 0 0 42.8157 -89.7947 0.4 125.0 JUNE \n", "2014-06-16 23:08:00 WI 0 3 0 0 43.0024 -89.5579 0.96 100.0 JUNE \n", "2014-06-16 23:15:00 WI 0 2 0 0 43.0431 -89.4799 0.22 200.0 JUNE \n", "2014-06-16 23:21:00 WI 0 1 0 0 43.0772 -89.3696 1.49 300.0 JUNE \n", "2014-06-17 03:40:00 WI 0 1 0 0 42.5323 -89.6119 6.78 641.0 JUNE \n", "2014-06-17 09:57:00 MI 0 1 0 0 44.3722 -83.8247 1.58 100.0 JUNE \n", "2014-06-17 14:27:00 MT 0 3 0 0 45.4783 -104.183 10.0 880.0 JUNE \n", "2014-06-17 15:54:00 MT 0 0 0 0 47.715 -106.704 0.07 15.0 JUNE \n", "2014-06-17 16:40:00 NE 0 0 0 0 42.986 -101.876 0.2 40.0 JUNE \n", "2014-06-17 16:40:00 NE 0 0 0 0 42.5845 -101.761 0.37 40.0 JUNE \n", "2014-06-17 17:28:00 NE 0 0 0 0 42.5122 -101.709 0.73 40.0 JUNE \n", "2014-06-17 18:00:00 NE 0 0 0 0 42.4255 -101.553 0.66 40.0 JUNE \n", "2014-06-17 18:57:00 NE 0 1 0 0 42.5606 -97.3137 3.94 630.0 JUNE \n", "2014-06-17 19:09:00 NE 0 3 0 0 42.5371 -97.2563 3.96 2059.0 JUNE \n", "2014-06-17 19:39:00 NE 0 0 0 0 42.12 -101.15 0.2 20.0 JUNE \n", "2014-06-17 20:03:00 NY 0 1 0 0 43.13 -75.58 11.0 250.0 JUNE \n", "2014-06-17 20:07:00 NE 0 0 0 0 41.9607 -101.269 1.7 40.0 JUNE \n", "2014-06-17 20:10:00 NE 0 1 0 0 42.5078 -97.0519 3.39 850.0 JUNE \n", "2014-06-17 20:10:00 NE 0 0 0 0 42.516 -97.1589 1.29 100.0 JUNE \n", "2014-06-17 20:28:00 NE 0 2 0 0 42.4822 -97.0599 0.94 200.0 JUNE \n", "2014-06-17 20:45:00 NE 0 2 0 0 42.4988 -97.0407 7.81 850.0 JUNE \n", "2014-06-17 21:44:00 SD 0 2 0 0 43.5975 -97.0583 3.37 400.0 JUNE \n", "2014-06-17 22:27:00 IA 0 0 0 0 43.27 -96.0 0.3 50.0 JUNE \n", "2014-06-18 00:15:00 IA 0 0 0 0 43.09 -95.33 0.2 50.0 JUNE \n", "2014-06-18 06:27:00 WI 0 0 0 0 43.1564 -89.7122 0.16 30.0 JUNE \n", "2014-06-18 17:05:00 SD 0 1 0 0 44.2509 -99.3672 0.73 40.0 JUNE \n", "2014-06-18 17:07:00 SD 0 0 0 0 44.18 -99.28 2.0 400.0 JUNE \n", "2014-06-18 17:45:00 SD 0 0 0 0 44.023 -98.939 0.65 250.0 JUNE \n", "2014-06-18 17:58:00 SD 0 1 0 0 44.0487 -98.8351 0.67 50.0 JUNE \n", "2014-06-18 18:00:00 SD 0 0 0 0 45.122 -98.995 1.17 75.0 JUNE \n", "2014-06-18 18:00:00 SD 0 0 0 0 44.433 -99.268 0.21 75.0 JUNE \n", "2014-06-18 18:01:00 SD 0 1 0 0 43.948 -98.7844 6.83 150.0 JUNE \n", "2014-06-18 18:08:00 ND 0 0 0 0 45.99 -99.43 0.02 20.0 JUNE \n", "2014-06-18 18:08:00 SD 0 2 0 0 44.0635 -98.8025 0.77 100.0 JUNE \n", "2014-06-18 18:30:00 SD 0 2 1 0 44.0725 -98.573 2.22 200.0 JUNE \n", "2014-06-18 18:43:00 SD 0 4 2 0 44.0372 -98.4032 11.5 880.0 JUNE \n", "2014-06-18 18:45:00 SD 0 2 0 0 44.034 -98.8908 1.09 100.0 JUNE \n", "2014-06-18 18:49:00 PA 0 0 0 0 41.1059 -79.2986 4.57 150.0 JUNE \n", "2014-06-18 20:16:00 CO 0 0 0 0 40.38 -102.95 0.1 50.0 JUNE \n", "2014-06-18 20:26:00 CO 0 0 0 0 40.3 -103.07 0.1 50.0 JUNE \n", "2014-06-18 20:36:00 CO 0 0 0 0 40.23 -103.07 0.1 50.0 JUNE \n", "2014-06-18 21:24:00 MN 0 0 0 0 44.48 -95.75 0.25 50.0 JUNE \n", "2014-06-19 12:30:00 IA 0 0 0 0 43.15 -95.15 0.15 50.0 JUNE \n", "2014-06-19 13:05:00 SD 0 0 0 0 44.6507 -102.093 0.1 10.0 JUNE \n", "2014-06-19 13:45:00 SD 0 0 0 0 44.5591 -102.113 0.1 10.0 JUNE \n", "2014-06-19 14:03:00 SD 0 0 0 0 44.36 -101.47 0.05 10.0 JUNE \n", "2014-06-19 14:04:00 IA 0 1 0 0 42.4483 -91.3733 15.69 75.0 JUNE \n", "2014-06-19 15:00:00 MN 0 0 0 0 45.3015 -95.7448 0.87 10.0 JUNE \n", "2014-06-19 15:13:00 MN 0 0 0 0 45.2761 -95.6648 4.43 20.0 JUNE \n", "2014-06-19 15:16:00 MN 0 0 0 0 45.7709 -95.7135 3.62 10.0 JUNE \n", "2014-06-19 15:32:00 MN 0 0 0 0 45.3242 -95.5615 0.69 10.0 JUNE \n", "2014-06-19 15:37:00 MN 0 0 0 0 45.0164 -95.5637 1.03 10.0 JUNE \n", "2014-06-19 15:45:00 MN 0 0 0 0 44.9307 -95.4879 0.15 10.0 JUNE \n", "2014-06-20 16:10:00 MN 0 0 0 0 46.4134 -95.6082 0.3 20.0 JUNE \n", "2014-06-21 13:28:00 NM 0 0 0 0 35.0401 -106.07 0.1 30.0 JUNE \n", "2014-06-21 14:36:00 CO 0 1 0 0 40.0 -104.64 0.25 100.0 JUNE \n", "2014-06-21 14:42:00 CO 0 0 0 0 39.8 -104.59 0.1 50.0 JUNE \n", "2014-06-21 15:11:00 CO 0 0 0 0 39.8 -104.42 0.1 50.0 JUNE \n", "2014-06-21 17:43:00 KS 0 0 0 0 38.07 -101.75 0.49 25.0 JUNE \n", "2014-06-21 18:45:00 SD 0 0 0 0 45.3 -100.89 0.28 20.0 JUNE \n", "2014-06-21 19:35:00 MN 0 1 0 0 47.63 -96.4411 2.0 300.0 JUNE \n", "2014-06-22 16:42:00 OK 0 0 0 0 36.6354 -100.272 2.01 100.0 JUNE \n", "2014-06-22 17:03:00 OK 0 1 0 0 36.6286 -100.396 3.77 150.0 JUNE \n", "2014-06-22 17:31:00 OK 0 0 0 0 36.5151 -100.4 0.44 50.0 JUNE \n", "2014-06-22 17:57:00 TX 0 0 0 0 36.4234 -100.416 2.0 50.0 JUNE \n", "2014-06-22 18:06:00 CO 0 0 0 0 40.4 -104.12 0.1 50.0 JUNE \n", "2014-06-22 18:22:00 TX 0 0 0 0 36.3226 -100.335 1.0 75.0 JUNE \n", "2014-06-22 20:50:00 TX 0 1 0 0 35.9433 -100.558 1.86 100.0 JUNE \n", "2014-06-23 12:30:00 SC 0 0 0 0 32.4281 -80.6726 0.01 50.0 JUNE \n", "2014-06-23 16:22:00 IL 0 0 0 0 38.3579 -88.4382 2.89 200.0 JUNE \n", "2014-06-23 16:26:00 IL 0 0 0 0 38.3662 -88.4126 1.8 150.0 JUNE \n", "2014-06-23 16:55:00 OH 0 1 0 0 41.2301 -81.8305 1.72 120.0 JUNE \n", "2014-06-23 18:59:00 OK 0 0 0 0 34.8701 -95.5599 0.5 50.0 JUNE \n", "2014-06-24 11:15:00 IN 0 0 0 0 39.4104 -86.7271 0.5 75.0 JUNE \n", "2014-06-24 11:30:00 IN 0 1 0 0 39.4986 -86.6312 0.25 75.0 JUNE \n", "2014-06-24 12:32:00 IN 0 1 0 0 39.7257 -86.3496 2.84 75.0 JUNE \n", "2014-06-25 14:00:00 WI 0 0 0 0 42.74 -89.44 0.33 30.0 JUNE \n", "2014-06-25 15:14:00 TX 0 0 0 0 28.3177 -97.2761 0.37 50.0 JUNE \n", "2014-06-25 18:05:00 WY 0 1 0 0 44.572 -104.62 5.92 100.0 JUNE \n", "2014-06-26 13:22:00 TX 0 0 1 0 29.3369 -94.9646 0.04 75.0 JUNE \n", "2014-06-26 16:55:00 WY 0 0 0 0 44.053 -105.689 0.33 30.0 JUNE \n", "2014-06-27 10:07:00 TX 0 0 0 0 30.1343 -94.9272 0.01 20.0 JUNE \n", "2014-06-27 10:24:00 TX 0 0 0 0 30.35 -94.9994 0.03 25.0 JUNE \n", "2014-06-27 12:46:00 LA 0 0 0 0 30.0599 -92.8295 4.62 300.0 JUNE \n", "2014-06-27 13:36:00 FL 0 0 0 0 26.5491 -82.0206 1.24 20.0 JUNE \n", "2014-06-27 14:03:00 WI 0 1 0 0 44.9294 -91.7668 7.02 100.0 JUNE \n", "2014-06-27 14:18:00 CO 0 0 0 0 38.5737 -103.057 2.14 100.0 JUNE \n", "2014-06-27 16:40:00 KS 0 0 0 0 39.3 -101.54 1.0 25.0 JUNE \n", "2014-06-27 16:44:00 KS 0 0 0 0 39.29 -101.38 2.0 25.0 JUNE \n", "2014-06-28 13:25:00 TX 0 0 0 0 29.8018 -95.4824 0.73 10.0 JUNE \n", "2014-06-28 14:22:00 OK 0 0 0 0 36.4323 -95.2831 4.3 400.0 JUNE \n", "2014-06-29 05:05:00 KS 0 1 0 0 38.82 -100.56 1.0 50.0 JUNE \n", "2014-06-29 18:28:00 IA 0 0 0 0 42.302 -93.7356 1.99 40.0 JUNE \n", "2014-06-29 19:08:00 IA 0 0 0 0 41.7182 -95.5114 0.5 50.0 JUNE \n", "2014-06-29 19:18:00 IA 0 1 0 0 42.3471 -92.6911 1.9 50.0 JUNE \n", "2014-06-29 19:25:00 IA 0 1 0 0 42.268 -93.0937 1.27 75.0 JUNE \n", "2014-06-29 20:12:00 MO 0 0 0 0 39.5627 -95.0526 0.25 25.0 JUNE \n", "2014-06-29 20:20:00 KS 0 0 0 0 39.0807 -95.6889 1.63 30.0 JUNE \n", "2014-06-29 20:55:00 MO 0 1 0 0 40.3532 -93.4855 6.31 300.0 JUNE \n", "2014-06-29 21:00:00 WI 0 1 0 0 42.9988 -90.6404 8.18 600.0 JUNE \n", "2014-06-29 21:18:00 WI 0 2 0 0 43.0123 -90.4216 29.07 400.0 JUNE \n", "2014-06-29 21:26:00 WI 0 2 0 0 42.9705 -90.2243 5.05 200.0 JUNE \n", "2014-06-29 21:36:00 IA 0 0 0 0 42.09 -90.96 0.1 25.0 JUNE \n", "2014-06-29 22:27:00 WI 0 1 0 0 42.9541 -89.3773 2.32 500.0 JUNE \n", "2014-06-29 23:30:00 IL 0 1 0 0 41.9613 -90.1153 2.24 600.0 JUNE \n", "2014-06-29 23:45:00 MO 0 1 0 0 40.4616 -92.5177 4.74 300.0 JUNE \n", "2014-06-30 11:42:00 IA 0 1 0 0 41.4638 -94.4672 7.12 200.0 JUNE \n", "2014-06-30 12:02:00 IA 0 1 0 0 42.1635 -93.2637 7.54 460.0 JUNE \n", "2014-06-30 12:13:00 IA 0 1 0 0 41.4042 -93.9532 1.34 75.0 JUNE \n", "2014-06-30 12:15:00 IA 0 1 0 0 42.1714 -93.1434 11.01 190.0 JUNE \n", "2014-06-30 12:15:00 IA 0 1 0 0 41.3993 -93.9163 6.38 400.0 JUNE \n", "2014-06-30 12:27:00 IA 0 1 0 0 41.3891 -93.7385 2.03 190.0 JUNE \n", "2014-06-30 13:02:00 IA 0 2 0 0 42.2117 -92.5253 3.7 150.0 JUNE \n", "2014-06-30 13:27:00 IA 0 1 0 0 42.2264 -91.9131 0.43 75.0 JUNE \n", "2014-06-30 15:40:00 MO 0 0 0 0 40.4369 -94.7211 3.52 200.0 JUNE \n", "2014-06-30 17:20:00 CO 0 0 0 0 37.3612 -102.656 0.27 50.0 JUNE \n", "2014-06-30 17:43:00 MO 0 1 0 0 40.3844 -94.3019 2.15 300.0 JUNE \n", "2014-06-30 18:53:00 MO 0 0 0 0 40.1551 -93.9938 2.99 200.0 JUNE \n", "2014-06-30 20:16:00 IL 0 1 0 0 41.5886 -88.9526 1.51 50.0 JUNE \n", "2014-06-30 20:34:00 MO 0 1 0 0 39.2136 -94.3742 0.8 200.0 JUNE \n", "2014-06-30 20:38:00 IL 0 1 0 0 41.4817 -88.5843 1.15 50.0 JUNE \n", "2014-06-30 20:44:00 IL 0 0 0 0 41.4411 -88.4692 2.16 50.0 JUNE \n", "2014-06-30 20:55:00 IL 0 1 0 0 41.6272 -88.1846 3.06 75.0 JUNE \n", "2014-06-30 21:25:00 IL 0 1 0 0 41.2556 -87.7816 4.07 200.0 JUNE \n", "2014-06-30 21:25:00 IL 0 1 0 0 41.2491 -87.7427 8.69 150.0 JUNE \n", "2014-06-30 21:26:00 IL 0 1 0 0 41.2639 -87.7219 3.05 300.0 JUNE \n", "2014-06-30 21:29:00 IL 0 1 0 0 41.2005 -87.6639 2.15 225.0 JUNE \n", "2014-06-30 21:31:00 IL 0 1 0 0 41.1867 -87.6391 3.09 150.0 JUNE \n", "2014-06-30 21:32:00 IL 0 1 0 0 41.2651 -87.5685 2.35 200.0 JUNE \n", "2014-06-30 21:32:00 IL 0 1 0 0 41.2651 -87.5685 3.4 200.0 JUNE \n", "2014-06-30 21:33:00 IL 0 1 0 0 41.2624 -87.554 1.66 100.0 JUNE \n", "2014-06-30 21:35:00 IN 0 1 0 0 41.2782 -87.5267 1.05 200.0 JUNE \n", "2014-06-30 21:35:00 IN 0 1 0 0 41.1863 -87.5263 6.24 300.0 JUNE \n", "2014-06-30 21:38:00 IN 0 1 0 0 41.2609 -87.4869 9.92 500.0 JUNE \n", "2014-06-30 21:39:00 IN 0 1 0 0 41.2537 -87.4601 2.57 250.0 JUNE \n", "2014-06-30 21:39:00 IN 0 1 0 0 41.2784 -87.4677 2.01 150.0 JUNE \n", "2014-06-30 21:42:00 IN 0 1 0 0 41.1918 -87.4071 3.85 300.0 JUNE \n", "2014-06-30 21:49:00 IN 0 1 0 0 41.1888 -87.2757 6.26 200.0 JUNE \n", "2014-06-30 21:55:00 IN 0 1 0 0 41.223 -87.128 0.94 100.0 JUNE \n", "2014-06-30 22:11:00 IN 0 1 0 0 41.5625 -86.858 0.26 200.0 JUNE \n", "2014-06-30 22:24:00 IN 0 1 0 0 41.4787 -86.6837 4.72 200.0 JUNE \n", "2014-06-30 22:25:00 IN 0 1 0 0 41.4189 -86.6409 4.93 400.0 JUNE \n", "2014-06-30 22:29:00 IN 0 1 0 0 41.4187 -86.5304 4.85 400.0 JUNE \n", "2014-06-30 22:35:00 IN 0 1 0 0 41.346 -86.4435 6.85 150.0 JUNE \n", "2014-06-30 22:41:00 IN 0 1 0 0 41.361 -86.2893 0.16 50.0 JUNE \n", "2014-06-30 23:06:00 IN 0 1 0 0 41.1979 -85.9217 0.55 150.0 JUNE \n", "2014-06-30 23:06:00 IN 0 0 0 0 41.4124 -85.9189 1.79 50.0 JUNE \n", "2014-06-30 23:08:00 IN 0 1 0 0 41.0314 -85.8965 7.01 150.0 JUNE \n", "2014-06-30 23:22:00 IN 0 1 0 0 41.0516 -85.6567 0.45 50.0 JUNE \n", "2014-06-30 23:38:00 IN 0 1 0 0 41.6414 -85.4396 0.93 50.0 JUNE \n", "2014-07-02 16:00:00 TX 0 0 0 0 33.1018 -99.613 0.22 50.0 JULY \n", "2014-07-03 14:36:00 NC 0 1 0 0 34.805 -78.009 0.77 200.0 JULY \n", "2014-07-03 18:50:00 NC 0 1 0 0 35.9565 -77.2038 1.13 100.0 JULY \n", "2014-07-03 21:25:00 NC 0 0 0 0 36.34 -76.98 0.9 30.0 JULY \n", "2014-07-03 23:15:00 VA 0 0 0 0 36.88 -76.08 0.31 30.0 JULY \n", "2014-07-03 23:40:00 VA 0 0 0 0 36.92 -76.27 0.25 30.0 JULY \n", "2014-07-04 18:00:00 NH 0 0 0 0 43.5868 -71.3521 0.36 10.0 JULY \n", "2014-07-06 12:42:00 FL 0 0 0 0 28.6506 -80.8433 0.09 35.0 JULY \n", "2014-07-06 17:03:00 IA 0 0 0 0 42.3244 -93.6873 0.55 25.0 JULY \n", "2014-07-06 18:00:00 IA 0 0 0 0 42.6341 -92.8757 0.4 15.0 JULY \n", "2014-07-06 18:58:00 IA 0 1 0 0 42.3327 -92.6384 3.21 100.0 JULY \n", "2014-07-06 19:02:00 MI 0 0 0 0 46.3605 -88.181 5.65 100.0 JULY \n", "2014-07-06 19:08:00 IA 0 0 0 0 42.2975 -92.5902 1.47 20.0 JULY \n", "2014-07-06 19:12:00 IA 0 1 0 0 42.2878 -92.5499 9.68 225.0 JULY \n", "2014-07-06 19:25:00 ND 0 0 0 0 48.028 -102.742 3.77 40.0 JULY \n", "2014-07-06 19:41:00 IA 0 0 0 0 41.5155 -94.2749 0.94 20.0 JULY \n", "2014-07-06 19:45:00 IA 0 0 0 0 41.8202 -93.0568 4.63 80.0 JULY \n", "2014-07-06 19:56:00 IA 0 0 0 0 42.09 -92.25 0.1 10.0 JULY \n", "2014-07-06 20:15:00 IA 0 0 0 0 41.7245 -92.9674 0.52 25.0 JULY \n", "2014-07-06 20:20:00 MI 0 1 6 0 42.85 -85.7 6.25 400.0 JULY \n", "2014-07-06 22:16:00 MI 0 0 0 0 42.94 -84.98 1.0 50.0 JULY \n", "2014-07-06 22:34:00 MI 0 0 0 0 42.9858 -84.9056 0.75 150.0 JULY \n", "2014-07-06 23:00:00 MI 0 0 0 0 43.02 -84.65 1.6 80.0 JULY \n", "2014-07-07 17:40:00 KY 0 0 0 0 38.7711 -84.9331 0.47 200.0 JULY \n", "2014-07-07 17:43:00 MN 0 0 0 0 44.8051 -92.8079 1.3 50.0 JULY \n", "2014-07-07 17:43:00 MN 0 0 0 0 44.8051 -92.8079 2.59 50.0 JULY \n", "2014-07-07 17:46:00 WI 0 0 0 0 44.7987 -92.7831 1.29 50.0 JULY \n", "2014-07-08 11:33:00 OH 0 1 0 0 41.2422 -82.003 8.3 200.0 JULY \n", "2014-07-08 11:43:00 OH 0 1 0 0 41.2702 -81.7612 1.57 200.0 JULY \n", "2014-07-08 12:15:00 OH 0 0 0 0 41.0243 -80.8262 5.39 200.0 JULY \n", "2014-07-08 12:48:00 PA 0 1 0 0 41.1977 -80.3272 2.46 150.0 JULY \n", "2014-07-08 13:25:00 WV 0 1 0 0 39.53 -80.06 2.24 50.0 JULY \n", "2014-07-08 13:55:00 WV 0 1 0 0 39.3729 -80.0405 4.41 150.0 JULY \n", "2014-07-08 16:15:00 PA 0 2 0 0 41.55 -76.48 6.68 500.0 JULY \n", "2014-07-08 16:33:00 NY 0 1 0 0 43.2 -75.6 1.0 600.0 JULY \n", "2014-07-08 16:48:00 NY 0 1 0 0 43.778 -75.5766 12.32 300.0 JULY \n", "2014-07-08 17:00:00 PA 0 0 0 0 41.23 -76.23 0.9 50.0 JULY \n", "2014-07-08 17:05:00 PA 0 1 0 0 41.75 -75.74 1.4 150.0 JULY \n", "2014-07-08 17:25:00 NY 0 1 0 0 43.12 -75.22 1.3 65.0 JULY \n", "2014-07-08 18:40:00 NY 0 0 0 0 43.6905 -73.9874 1.09 100.0 JULY \n", "2014-07-10 13:35:00 VA 0 0 10 0 36.8432 -75.9763 0.34 30.0 JULY \n", "2014-07-12 11:20:00 FL 0 0 0 0 27.2367 -80.757 0.08 15.0 JULY \n", "2014-07-12 14:45:00 CO 0 0 0 0 38.5867 -104.476 0.53 50.0 JULY \n", "2014-07-12 20:20:00 IL 0 0 0 0 41.2584 -90.7362 0.38 50.0 JULY \n", "2014-07-12 20:30:00 IL 0 1 0 0 41.2674 -90.6666 3.7 100.0 JULY \n", "2014-07-12 20:46:00 IL 0 1 0 0 41.2387 -90.5289 2.78 50.0 JULY \n", "2014-07-12 21:00:00 IL 0 1 0 0 41.2141 -90.4256 0.66 50.0 JULY \n", "2014-07-13 13:40:00 WY 0 0 0 0 41.14 -104.628 0.17 25.0 JULY \n", "2014-07-13 14:34:00 NY 0 1 0 0 42.43 -76.93 3.5 125.0 JULY \n", "2014-07-13 15:09:00 NE 0 0 0 0 41.1142 -103.66 0.14 25.0 JULY \n", "2014-07-13 17:37:00 WV 0 0 0 0 39.3996 -78.1886 0.07 50.0 JULY \n", "2014-07-13 18:30:00 NY 0 1 0 0 41.85 -74.77 0.75 270.0 JULY \n", "2014-07-14 11:40:00 CO 0 0 0 0 38.2166 -102.497 0.37 75.0 JULY \n", "2014-07-15 16:52:00 ME 0 1 0 0 44.9107 -69.4075 2.75 800.0 JULY \n", "2014-07-16 18:08:00 TX 0 0 0 0 36.3478 -102.054 0.01 50.0 JULY \n", "2014-07-16 18:26:00 TX 0 0 0 0 36.3128 -102.053 1.34 100.0 JULY \n", "2014-07-16 19:23:00 TX 0 0 0 0 36.0292 -102.084 3.07 100.0 JULY \n", "2014-07-21 12:35:00 TX 0 0 0 0 29.3788 -94.9056 0.1 20.0 JULY \n", "2014-07-21 18:35:00 ND 0 0 0 0 47.62 -98.59 9.08 100.0 JULY \n", "2014-07-21 18:47:00 ND 0 0 0 0 47.78 -98.52 0.01 20.0 JULY \n", "2014-07-21 19:29:00 ND 0 1 0 0 47.82 -97.57 8.0 300.0 JULY \n", "2014-07-21 19:52:00 MN 0 2 0 0 47.7 -96.86 37.92 800.0 JULY \n", "2014-07-23 17:26:00 MS 0 0 0 0 32.429 -90.0285 0.7 25.0 JULY \n", "2014-07-24 06:25:00 VA 0 1 5 0 37.2893 -76.071 7.69 150.0 JULY \n", "2014-07-24 06:30:00 NH 0 0 0 0 43.687 -71.3051 0.02 10.0 JULY \n", "2014-07-24 15:59:00 FL 0 0 0 0 28.4592 -80.992 0.25 15.0 JULY \n", "2014-07-24 19:19:00 MT 0 0 0 0 46.99 -104.27 1.0 100.0 JULY \n", "2014-07-25 14:24:00 FL 0 1 0 0 28.9807 -80.9281 1.69 75.0 JULY \n", "2014-07-27 10:50:00 CT 0 0 0 0 41.6055 -72.9833 0.72 100.0 JULY \n", "2014-07-27 13:29:00 OH 0 0 0 0 40.1236 -83.6134 0.07 50.0 JULY \n", "2014-07-27 14:24:00 KY 0 1 0 0 36.9573 -83.3506 2.0 900.0 JULY \n", "2014-07-27 14:55:00 MA 0 1 0 0 42.453 -73.1858 0.25 20.0 JULY \n", "2014-07-27 15:05:00 ME 0 0 0 0 43.8971 -70.587 0.63 10.0 JULY \n", "2014-07-27 15:45:00 TN 0 1 0 0 36.462 -82.56 0.5 50.0 JULY \n", "2014-07-27 15:47:00 TN 0 0 0 0 36.4477 -82.5498 7.1 300.0 JULY \n", "2014-07-27 15:58:00 TN 0 3 0 0 36.4695 -83.9766 4.66 800.0 JULY \n", "2014-07-27 17:14:00 WV 0 1 0 0 39.3366 -81.1412 4.1 200.0 JULY \n", "2014-07-27 18:05:00 WI 0 0 0 0 43.948 -88.495 0.01 10.0 JULY \n", "2014-07-27 18:39:00 OH 0 0 0 0 39.186 -83.6645 2.52 1300.0 JULY \n", "2014-07-27 18:50:00 WV 0 1 0 0 39.1202 -80.2948 1.07 50.0 JULY \n", "2014-07-28 07:32:00 MA 0 2 2 0 42.398 -71.0219 1.93 660.0 JULY \n", "2014-07-28 13:49:00 ME 0 1 0 0 43.66 -70.68 1.71 80.0 JULY \n", "2014-07-28 15:53:00 CO 0 0 0 0 40.06 -104.8 0.1 50.0 JULY \n", "2014-07-28 16:09:00 CO 0 0 0 0 39.83 -104.79 0.1 50.0 JULY \n", "2014-07-31 14:10:00 NV 0 0 0 0 40.9837 -116.383 0.48 7.0 JULY \n", "2014-07-31 17:10:00 MT 0 0 0 0 48.48 -108.37 0.1 5.0 JULY \n", "2014-08-04 13:40:00 NV 0 0 0 0 35.83 -114.87 0.08 25.0 AUGUST \n", "2014-08-06 18:10:00 CO 0 0 0 0 39.76 -104.42 0.1 50.0 AUGUST \n", "2014-08-09 14:45:00 KS 0 0 0 0 39.8176 -101.878 0.5 10.0 AUGUST \n", "2014-08-09 14:57:00 KS 0 0 0 0 39.6848 -101.693 0.25 10.0 AUGUST \n", "2014-08-09 15:30:00 SD 0 0 0 0 44.7104 -96.4848 0.83 20.0 AUGUST \n", "2014-08-09 15:55:00 KS 0 0 0 0 39.62 -101.63 0.25 10.0 AUGUST \n", "2014-08-11 12:46:00 WI 0 0 0 0 46.5843 -90.9227 0.05 3.0 AUGUST \n", "2014-08-11 13:00:00 OH 0 0 0 0 40.15 -82.056 0.16 25.0 AUGUST \n", "2014-08-12 09:15:00 OH 0 0 0 0 40.1753 -82.6321 0.09 20.0 AUGUST \n", "2014-08-13 19:30:00 WA 0 0 0 0 46.32 -119.8 0.25 15.0 AUGUST \n", "2014-08-15 11:55:00 FL 0 0 0 0 27.52 -80.3563 0.15 15.0 AUGUST \n", "2014-08-15 14:39:00 AZ 0 0 0 0 32.2659 -109.999 0.79 50.0 AUGUST \n", "2014-08-16 14:33:00 FL 0 0 0 0 26.42 -80.27 0.37 10.0 AUGUST \n", "2014-08-17 15:33:00 KY 0 1 0 0 37.7191 -87.5226 1.65 60.0 AUGUST \n", "2014-08-17 16:31:00 KY 0 0 0 0 37.3 -87.0154 0.59 125.0 AUGUST \n", "2014-08-17 18:00:00 IA 0 0 0 0 43.4287 -94.6202 0.83 25.0 AUGUST \n", "2014-08-18 15:23:00 WI 0 0 0 0 44.2299 -88.6176 2.06 50.0 AUGUST \n", "2014-08-20 12:04:00 MI 0 0 0 0 42.7729 -82.8373 0.29 100.0 AUGUST \n", "2014-08-20 13:45:00 ID 0 0 0 0 43.8995 -113.592 0.1 5.0 AUGUST \n", "2014-08-21 04:20:00 MN 0 0 0 0 44.04 -94.92 0.1 50.0 AUGUST \n", "2014-08-21 14:25:00 PA 0 0 0 0 41.09 -78.99 0.54 20.0 AUGUST \n", "2014-08-21 14:27:00 PA 0 0 0 0 41.07 -79.01 5.36 50.0 AUGUST \n", "2014-08-23 16:30:00 SD 0 0 0 0 45.18 -99.11 2.13 10.0 AUGUST \n", "2014-08-23 16:35:00 SD 0 0 0 0 45.18 -99.13 4.4 15.0 AUGUST \n", "2014-08-23 17:31:00 SD 0 1 0 0 45.48 -98.98 1.46 10.0 AUGUST \n", "2014-08-24 16:47:00 MN 0 0 0 0 45.7971 -93.9829 5.67 150.0 AUGUST \n", "2014-08-25 17:40:00 CO 0 0 0 0 38.374 -105.139 0.96 75.0 AUGUST \n", "2014-08-28 16:30:00 KS 0 0 0 0 39.2132 -98.9165 0.1 25.0 AUGUST \n", "2014-08-28 17:30:00 KS 0 1 0 0 38.72 -98.92 2.0 220.0 AUGUST \n", "2014-08-28 17:44:00 SD 0 0 0 0 43.04 -97.38 3.74 50.0 AUGUST \n", "2014-08-31 18:10:00 MA 0 0 0 0 42.24 -71.8 2.06 176.0 AUGUST \n", "2014-08-31 18:57:00 IA 0 0 0 0 42.1122 -94.6781 1.9 60.0 AUGUST \n", "2014-08-31 19:36:00 IA 0 1 0 0 42.3072 -94.0661 3.32 40.0 AUGUST \n", "2014-09-01 11:47:00 MI 0 1 0 0 44.8064 -85.0215 4.02 125.0 SEPTEMBER \n", "2014-09-01 12:16:00 MI 0 1 0 0 44.7577 -84.7721 9.14 75.0 SEPTEMBER \n", "2014-09-01 12:42:00 MI 0 1 0 0 44.9133 -84.5127 7.21 210.0 SEPTEMBER \n", "2014-09-01 12:43:00 MI 0 0 0 0 45.227 -84.548 0.67 30.0 SEPTEMBER \n", "2014-09-01 18:41:00 OK 0 0 0 0 36.9279 -95.1 0.2 50.0 SEPTEMBER \n", "2014-09-01 19:01:00 KS 0 0 0 0 37.1237 -96.7113 3.69 100.0 SEPTEMBER \n", "2014-09-01 19:25:00 KS 0 1 0 0 37.0552 -96.5181 7.4 100.0 SEPTEMBER \n", "2014-09-01 21:43:00 MO 0 1 0 0 38.4299 -90.6635 6.4 60.0 SEPTEMBER \n", "2014-09-01 22:13:00 MO 0 1 0 0 37.0272 -94.4483 2.22 100.0 SEPTEMBER \n", "2014-09-01 22:14:00 MO 0 1 0 0 37.0257 -94.427 2.7 400.0 SEPTEMBER \n", "2014-09-01 22:36:00 MO 0 0 0 0 37.0137 -94.1192 1.24 100.0 SEPTEMBER \n", "2014-09-02 13:09:00 LA 0 1 0 0 32.1474 -93.5826 6.04 350.0 SEPTEMBER \n", "2014-09-02 17:10:00 NY 0 1 0 0 42.1044 -76.7103 6.0 150.0 SEPTEMBER \n", "2014-09-02 18:32:00 NY 0 1 0 0 42.1375 -75.36 0.1 50.0 SEPTEMBER \n", "2014-09-04 02:26:00 ND 0 0 0 0 46.79 -98.09 1.05 30.0 SEPTEMBER \n", "2014-09-04 03:17:00 ND 0 1 0 0 46.65 -97.25 11.64 250.0 SEPTEMBER \n", "2014-09-04 03:48:00 MN 0 2 0 0 46.5 -96.27 2.7 200.0 SEPTEMBER \n", "2014-09-04 04:42:00 MN 0 1 0 0 46.49 -95.39 2.0 250.0 SEPTEMBER \n", "2014-09-06 12:39:00 LA 0 0 0 0 29.9401 -92.7596 0.01 10.0 SEPTEMBER \n", "2014-09-07 12:27:00 SC 0 0 0 0 33.4296 -80.3952 0.43 30.0 SEPTEMBER \n", "2014-09-08 14:45:00 NC 0 2 1 0 34.828 -77.902 0.15 100.0 SEPTEMBER \n", "2014-09-09 15:29:00 NE 0 1 0 0 40.6237 -95.9883 7.72 965.0 SEPTEMBER \n", "2014-09-09 16:50:00 MO 0 0 0 0 40.4411 -95.4534 4.89 25.0 SEPTEMBER \n", "2014-09-09 18:10:00 MO 0 0 0 0 40.2017 -95.0852 3.04 30.0 SEPTEMBER \n", "2014-09-09 18:35:00 MO 0 0 0 0 40.1757 -95.1212 0.08 25.0 SEPTEMBER \n", "2014-09-09 18:40:00 MO 0 0 0 0 40.1853 -95.108 0.11 25.0 SEPTEMBER \n", "2014-09-09 20:10:00 MO 0 0 0 0 38.7557 -90.5923 1.69 25.0 SEPTEMBER \n", "2014-09-09 21:22:00 MO 0 0 0 0 39.9877 -94.3508 0.75 25.0 SEPTEMBER \n", "2014-09-10 01:40:00 MO 0 1 0 0 40.17 -92.74 18.27 20.0 SEPTEMBER \n", "2014-09-10 15:22:00 OH 0 0 0 0 41.17 -81.4 0.47 50.0 SEPTEMBER \n", "2014-09-10 15:29:00 OH 0 0 0 0 41.191 -81.377 0.96 50.0 SEPTEMBER \n", "2014-09-10 15:34:00 OH 0 0 0 0 41.202 -81.299 0.1 20.0 SEPTEMBER \n", "2014-09-10 15:54:00 OH 0 0 0 0 41.335 -81.185 0.76 50.0 SEPTEMBER \n", "2014-09-17 14:38:00 AR 0 0 0 0 35.9894 -92.9662 2.73 250.0 SEPTEMBER \n", "2014-09-19 17:19:00 MN 0 2 0 0 48.86 -97.02 10.0 500.0 SEPTEMBER \n", "2014-09-19 18:21:00 MN 0 1 0 0 48.7 -96.38 7.0 300.0 SEPTEMBER \n", "2014-09-20 18:00:00 NV 0 0 0 0 39.07 -116.51 0.4 20.0 SEPTEMBER \n", "2014-09-21 03:47:00 MI 0 1 0 0 42.7 -83.19 1.23 150.0 SEPTEMBER \n", "2014-09-27 14:55:00 AZ 0 0 0 0 34.465 -112.411 2.1 700.0 SEPTEMBER \n", "2014-09-29 16:25:00 NM 0 1 0 0 36.9028 -106.813 2.26 700.0 SEPTEMBER \n", "2014-09-29 16:25:00 NM 0 1 0 0 36.9028 -106.813 2.26 700.0 SEPTEMBER \n", "2014-09-30 15:45:00 SD 0 0 0 0 45.89 -99.25 0.3 10.0 SEPTEMBER \n", "2014-10-02 19:24:00 AR 0 1 0 0 34.5317 -92.1162 12.71 300.0 OCTOBER \n", "2014-10-02 19:55:00 AR 0 1 0 0 34.6272 -91.5553 4.08 200.0 OCTOBER \n", "2014-10-02 20:28:00 AR 0 0 0 0 35.5725 -90.9038 0.7 33.0 OCTOBER \n", "2014-10-02 23:10:00 KY 0 1 0 0 36.8302 -88.3529 0.38 125.0 OCTOBER \n", "2014-10-03 00:15:00 KY 0 1 0 0 36.8523 -87.5913 1.36 110.0 OCTOBER \n", "2014-10-03 02:12:00 AL 0 0 0 0 34.6881 -86.7267 0.7 250.0 OCTOBER \n", "2014-10-03 03:02:00 AL 0 0 0 0 34.401 -86.149 0.48 75.0 OCTOBER \n", "2014-10-06 00:01:00 OK 0 1 0 0 35.2508 -94.7246 0.8 75.0 OCTOBER \n", "2014-10-06 17:02:00 KY 0 1 0 0 36.8339 -85.3973 0.17 100.0 OCTOBER \n", "2014-10-06 17:13:00 KY 0 1 0 0 36.842 -85.1959 2.17 150.0 OCTOBER \n", "2014-10-06 17:40:00 GA 0 1 0 0 34.9304 -85.1225 0.29 100.0 OCTOBER \n", "2014-10-07 12:50:00 KY 0 1 0 0 38.4602 -85.4629 0.12 50.0 OCTOBER \n", "2014-10-07 13:39:00 KY 0 1 0 0 38.4618 -84.691 12.13 150.0 OCTOBER \n", "2014-10-07 13:48:00 KY 0 1 0 0 38.2846 -84.6896 2.79 150.0 OCTOBER \n", "2014-10-07 13:49:00 KY 0 1 0 0 38.2921 -84.6292 3.55 150.0 OCTOBER \n", "2014-10-07 14:05:00 KY 0 1 0 0 38.3789 -84.358 3.66 275.0 OCTOBER \n", "2014-10-07 14:12:00 KY 0 1 1 0 38.2016 -84.256 1.7 60.0 OCTOBER \n", "2014-10-07 14:35:00 KY 0 1 0 0 38.2059 -83.9386 0.6 50.0 OCTOBER \n", "2014-10-07 14:53:00 KY 0 1 0 0 38.0696 -83.6598 0.3 35.0 OCTOBER \n", "2014-10-07 16:35:00 IN 0 0 0 0 39.5006 -86.7748 0.1 50.0 OCTOBER \n", "2014-10-07 20:41:00 WV 0 2 0 0 37.6014 -81.2012 3.01 150.0 OCTOBER \n", "2014-10-07 20:44:00 KY 0 1 0 0 37.6141 -82.5948 0.1 130.0 OCTOBER \n", "2014-10-07 21:39:00 WV 0 1 2 0 37.4533 -81.2164 5.54 180.0 OCTOBER \n", "2014-10-09 20:10:00 TX 0 1 0 0 35.4213 -101.045 7.03 125.0 OCTOBER \n", "2014-10-10 19:35:00 TN 0 1 0 0 35.8594 -87.3851 1.97 100.0 OCTOBER \n", "2014-10-13 03:52:00 TX 0 1 0 0 32.7681 -95.0456 5.8 275.0 OCTOBER \n", "2014-10-13 04:04:00 AR 0 1 0 0 34.5766 -94.3911 3.66 300.0 OCTOBER \n", "2014-10-13 04:19:00 AR 0 1 0 0 36.1783 -93.8792 3.0 375.0 OCTOBER \n", "2014-10-13 04:43:00 AR 0 0 0 0 33.7279 -94.2339 0.09 50.0 OCTOBER \n", "2014-10-13 05:25:00 MO 0 1 0 0 36.5048 -93.39 0.09 75.0 OCTOBER \n", "2014-10-13 05:58:00 MO 0 0 0 0 37.1593 -93.6799 0.07 50.0 OCTOBER \n", "2014-10-13 06:20:00 MO 0 0 0 0 37.3537 -93.6061 0.43 100.0 OCTOBER \n", "2014-10-13 06:40:00 AR 0 1 0 0 34.0405 -92.9554 3.32 250.0 OCTOBER \n", "2014-10-13 08:00:00 LA 0 1 0 0 31.9764 -93.6991 0.9 200.0 OCTOBER \n", "2014-10-13 08:27:00 AR 0 1 0 0 34.5441 -92.0074 3.31 150.0 OCTOBER \n", "2014-10-13 10:11:00 LA 0 1 0 0 32.4375 -92.2781 0.7 225.0 OCTOBER \n", "2014-10-13 10:16:00 LA 0 2 0 0 32.4921 -92.2421 9.05 300.0 OCTOBER \n", "2014-10-13 11:48:00 AR 0 0 0 0 36.439 -90.3982 0.87 100.0 OCTOBER \n", "2014-10-13 11:59:00 IL 0 0 0 0 38.1272 -90.0143 0.29 50.0 OCTOBER \n", "2014-10-13 12:24:00 IL 0 1 0 0 38.4703 -89.9263 1.38 100.0 OCTOBER \n", "2014-10-13 12:30:00 MO 0 1 0 0 36.9498 -90.1113 9.35 75.0 OCTOBER \n", "2014-10-13 12:43:00 IL 0 1 0 0 38.5363 -89.7248 0.25 50.0 OCTOBER \n", "2014-10-13 12:45:00 MO 0 1 0 0 37.1193 -90.0415 7.16 100.0 OCTOBER \n", "2014-10-13 13:02:00 MO 0 1 0 0 37.2423 -89.9396 2.0 50.0 OCTOBER \n", "2014-10-13 14:54:00 IL 0 2 0 0 39.631 -88.9567 10.0 200.0 OCTOBER \n", "2014-10-13 15:06:00 IL 0 1 0 0 38.4443 -88.9185 3.52 100.0 OCTOBER \n", "2014-10-13 15:07:00 IL 0 1 0 0 38.3715 -88.7566 0.66 50.0 OCTOBER \n", "2014-10-13 15:12:00 IL 0 1 0 0 39.8184 -88.88 0.2 50.0 OCTOBER \n", "2014-10-13 15:20:00 FL 0 0 0 0 30.287 -85.1792 2.58 30.0 OCTOBER \n", "2014-10-13 15:29:00 IL 0 0 0 0 40.0188 -88.7722 2.75 50.0 OCTOBER \n", "2014-10-13 15:43:00 AL 0 0 0 0 34.208 -88.1077 6.01 50.0 OCTOBER \n", "2014-10-13 16:25:00 IN 0 1 0 0 38.0981 -87.9087 3.75 150.0 OCTOBER \n", "2014-10-13 17:09:00 TN 0 1 0 0 36.5001 -87.2952 4.18 75.0 OCTOBER \n", "2014-10-13 17:48:00 AL 0 0 0 0 34.0087 -88.001 1.08 150.0 OCTOBER \n", "2014-10-13 18:29:00 FL 0 0 0 0 29.89 -84.91 0.01 20.0 OCTOBER \n", "2014-10-13 18:29:00 AL 0 1 1 0 34.7318 -87.7029 3.48 200.0 OCTOBER \n", "2014-10-13 18:50:00 FL 0 0 0 0 30.01 -84.91 0.01 20.0 OCTOBER \n", "2014-10-13 19:59:00 FL 0 0 0 0 30.02 -84.98 2.07 20.0 OCTOBER \n", "2014-10-13 20:58:00 FL 0 0 0 0 30.14 -84.91 0.01 20.0 OCTOBER \n", "2014-10-14 02:00:00 FL 0 0 0 0 30.78 -85.36 1.73 20.0 OCTOBER \n", "2014-10-14 02:40:00 GA 0 1 0 0 32.7979 -84.7091 5.86 200.0 OCTOBER \n", "2014-10-14 03:15:00 GA 0 0 0 0 33.6552 -84.5147 2.99 75.0 OCTOBER \n", "2014-10-14 03:20:00 GA 0 0 0 0 33.6776 -84.4662 2.63 75.0 OCTOBER \n", "2014-10-14 03:33:00 GA 0 0 0 0 33.8427 -84.4407 1.07 75.0 OCTOBER \n", "2014-10-14 03:43:00 GA 0 1 0 0 33.9821 -84.3918 1.25 100.0 OCTOBER \n", "2014-10-14 03:55:00 GA 0 1 0 0 34.0748 -84.3255 7.51 100.0 OCTOBER \n", "2014-10-14 06:11:00 SC 0 0 0 0 34.68 -83.21 0.89 100.0 OCTOBER \n", "2014-10-14 18:00:00 SC 0 0 0 0 35.12 -82.24 1.0 50.0 OCTOBER \n", "2014-10-14 18:48:00 NC 0 0 0 0 35.55 -82.07 0.5 100.0 OCTOBER \n", "2014-10-15 10:23:00 VA 0 0 0 0 38.78 -77.06 2.32 75.0 OCTOBER \n", "2014-10-15 11:13:00 MD 0 0 0 0 39.128 -76.829 0.3 75.0 OCTOBER \n", "2014-10-23 14:40:00 WA 0 1 0 0 46.13 -122.946 1.3 66.0 OCTOBER \n", "2014-11-16 19:48:00 LA 0 0 0 0 30.4023 -90.9214 1.12 100.0 NOVEMBER \n", "2014-11-16 20:11:00 LA 0 1 0 0 30.5597 -90.7428 3.87 300.0 NOVEMBER \n", "2014-11-16 20:27:00 MS 0 1 0 0 31.683 -88.9929 2.65 100.0 NOVEMBER \n", "2014-11-17 01:11:00 AL 0 1 0 0 32.699 -87.4659 3.53 300.0 NOVEMBER \n", "2014-11-17 01:37:00 AL 0 1 0 0 31.4418 -88.1545 21.9 150.0 NOVEMBER \n", "2014-11-17 02:51:00 FL 0 0 0 0 30.3 -85.92 0.01 50.0 NOVEMBER \n", "2014-11-17 03:59:00 AL 0 1 0 0 31.6093 -86.7471 5.89 150.0 NOVEMBER \n", "2014-11-17 04:17:00 FL 0 2 2 0 30.4025 -85.0746 22.21 420.0 NOVEMBER \n", "2014-11-17 04:25:00 AL 0 1 0 0 31.7369 -86.4303 40.73 500.0 NOVEMBER \n", "2014-11-17 05:57:00 FL 0 0 0 0 30.699 -85.0191 0.5 50.0 NOVEMBER \n", "2014-11-17 06:24:00 AL 0 1 0 0 32.199 -85.0592 0.22 100.0 NOVEMBER \n", "2014-11-17 08:57:00 GA 0 1 0 0 32.5567 -83.3719 0.05 100.0 NOVEMBER \n", "2014-11-17 12:00:00 FL 0 0 0 0 30.1447 -82.2818 0.8 75.0 NOVEMBER \n", "2014-11-23 11:35:00 AL 0 0 0 0 32.6387 -87.8364 2.05 150.0 NOVEMBER \n", "2014-11-23 14:03:00 AL 0 1 0 0 31.9603 -85.094 3.23 400.0 NOVEMBER \n", "2014-11-23 14:03:00 AL 0 1 0 0 31.9603 -85.094 16.72 400.0 NOVEMBER \n", "2014-11-23 14:07:00 GA 0 1 0 0 32.0002 -85.0653 13.49 75.0 NOVEMBER \n", "2014-11-23 14:27:00 GA 0 1 0 0 32.0315 -84.8078 0.47 100.0 NOVEMBER \n", "2014-11-23 14:37:00 GA 0 1 0 0 32.2982 -84.7905 21.08 75.0 NOVEMBER \n", "2014-11-23 15:01:00 GA 0 0 0 0 32.615 -84.5513 3.16 50.0 NOVEMBER \n", "2014-11-23 15:20:00 GA 0 0 0 0 32.8945 -84.3502 10.98 200.0 NOVEMBER \n", "2014-11-23 15:40:00 GA 0 1 0 0 32.8818 -84.0179 20.02 70.0 NOVEMBER \n", "2014-11-23 15:40:00 GA 0 0 0 0 33.0747 -84.2059 1.44 70.0 NOVEMBER \n", "2014-11-23 15:49:00 GA 0 1 0 0 33.1532 -84.1128 21.55 100.0 NOVEMBER \n", "2014-11-23 16:10:00 GA 0 1 0 0 32.3152 -83.6336 6.4 50.0 NOVEMBER \n", "2014-12-12 11:20:00 CA 0 0 0 0 33.9823 -118.291 0.73 10.0 DECEMBER \n", "2014-12-14 17:09:00 OK 0 0 0 0 35.62 -97.38 0.17 50.0 DECEMBER \n", "2014-12-14 17:38:00 KS 0 0 0 0 37.2915 -98.0097 5.98 100.0 DECEMBER \n", "2014-12-15 17:02:00 MS 0 0 0 0 31.8276 -89.6172 1.53 50.0 DECEMBER \n", "2014-12-15 17:56:00 MS 0 0 0 0 32.3668 -90.7339 1.17 75.0 DECEMBER \n", "2014-12-15 23:18:00 MS 0 0 0 0 31.0936 -90.0188 1.33 150.0 DECEMBER \n", "2014-12-23 12:58:00 GA 0 0 0 0 30.77 -83.33 0.1 25.0 DECEMBER \n", "2014-12-23 13:19:00 LA 0 2 0 0 30.7289 -90.4799 4.62 150.0 DECEMBER \n", "2014-12-23 14:45:00 MS 0 0 0 0 31.4143 -89.5509 0.06 50.0 DECEMBER \n", "2014-12-23 14:46:00 MS 0 0 0 0 31.4247 -89.5358 0.24 50.0 DECEMBER \n", "2014-12-23 16:27:00 MS 0 0 0 0 32.0005 -88.4854 0.49 100.0 DECEMBER \n", "2014-12-24 09:30:00 NC 0 1 1 0 34.3124 -77.917 0.2 25.0 DECEMBER \n", "2014-12-24 11:50:00 GA 0 1 0 0 31.406 -82.251 5.69 100.0 DECEMBER \n", "2014-12-24 16:16:00 OH 0 0 0 0 39.728 -82.634 0.63 30.0 DECEMBER \n", "2014-12-27 13:12:00 TX 0 0 0 0 30.3853 -94.7823 0.23 75.0 DECEMBER \n", "2014-12-27 14:00:00 TX 0 1 0 0 30.6829 -94.2553 4.25 50.0 DECEMBER \n", "2014-12-27 14:35:00 TX 0 1 0 0 30.864 -93.979 1.98 150.0 DECEMBER \n", "2014-12-29 10:26:00 GA 0 2 9 0 30.8157 -83.2833 0.74 180.0 DECEMBER \n", "2014-01-11 06:37:00 GA 0 0 0 0 34.3328 -84.5286 2.9 10.0 JANUARY \n", "2014-01-11 14:32:00 VA 0 0 0 0 37.025 -76.6377 1.36 100.0 JANUARY \n", "2014-01-11 14:32:00 VA 0 0 0 0 36.8769 -76.6721 1.95 50.0 JANUARY \n", "2014-01-11 14:50:00 VA 0 0 0 0 37.08 -76.3 1.08 75.0 JANUARY \n", "2014-02-20 14:25:00 IL 0 2 1 0 39.518 -90.841 12.09 80.0 FEBRUARY \n", "2014-02-20 14:48:00 IL 0 0 0 0 39.7853 -90.4215 0.27 25.0 FEBRUARY \n", "2014-02-20 14:52:00 IL 0 0 0 0 39.8193 -90.4178 8.17 50.0 FEBRUARY \n", "2014-02-20 15:43:00 IL 0 0 0 0 39.5671 -89.6256 0.22 75.0 FEBRUARY \n", "2014-02-20 15:57:00 IL 0 1 0 0 38.7575 -89.6151 20.56 300.0 FEBRUARY \n", "2014-02-20 16:09:00 IL 0 2 1 0 39.2586 -89.234 22.38 200.0 FEBRUARY \n", "2014-02-20 16:36:00 IL 0 1 0 0 39.0158 -88.998 4.8 50.0 FEBRUARY \n", "2014-02-20 16:39:00 MO 0 1 5 0 36.1895 -89.8812 0.24 70.0 FEBRUARY \n", "2014-02-20 16:40:00 IL 0 1 0 0 37.6987 -89.3713 0.39 50.0 FEBRUARY \n", "2014-02-20 16:40:00 IL 0 0 0 0 39.5176 -88.8109 0.28 50.0 FEBRUARY \n", "2014-02-20 16:41:00 MO 0 1 0 0 36.2349 -89.8029 0.04 25.0 FEBRUARY \n" ] }, "execution_count": 12, "metadata": {}, "output_type": "execute_result" } ], "source": [ "//Sorting by column\n", "tornadoes.sortOn(\"-Fatalities\").print()" ] }, { "cell_type": "code", "execution_count": 13, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "Column: Fatalities\n", "Measure Value \n", "n 908.0 \n", "sum 48.0 \n", "Mean 0.052863438 \n", "Min 0.0 \n", "Max 16.0 \n", "Range 16.0 \n", "Variance 0.44262686 \n", "Std. Dev 0.6653021 \n" ] }, "execution_count": 13, "metadata": {}, "output_type": "execute_result" } ], "source": [ "//Descriptive statistics\n", "tornadoes.column(\"Fatalities\").summary().print();" ] }, { "cell_type": "code", "execution_count": 14, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "Median injuries by Tornado Scale\n", "Scale Median [Injuries] \n", "0 0.0 \n", "1 0.0 \n", "2 0.0 \n", "3 0.0 \n", "4 2.0 \n" ] }, "execution_count": 14, "metadata": {}, "output_type": "execute_result" } ], "source": [ "//Performing totals and sub-totals\n", "def injuriesByScale = tornadoes.median(\"Injuries\").by(\"Scale\")\n", "injuriesByScale.setName(\"Median injuries by Tornado Scale\")\n", "injuriesByScale.print()" ] }, { "cell_type": "code", "execution_count": 15, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "Crosstab Counts: State x Scale\n", " 0 1 2 3 4 total \n", "AL 12 32 7 4 0 55 \n", "AR 5 12 2 0 1 20 \n", "AZ 3 0 0 0 0 3 \n", "CA 6 3 0 0 0 9 \n", "CO 41 7 1 0 0 49 \n", "CT 1 0 0 0 0 1 \n", "DE 0 1 0 0 0 1 \n", "FL 23 4 1 0 0 28 \n", "GA 13 16 3 0 0 32 \n", "IA 31 22 3 0 0 56 \n", "ID 3 0 0 0 0 3 \n", "IL 19 27 3 0 0 49 \n", "IN 6 22 0 0 0 28 \n", "KS 30 7 3 1 0 41 \n", "KY 6 21 1 0 0 28 \n", "LA 4 8 3 0 0 15 \n", "MA 1 1 1 0 0 3 \n", "MD 2 0 0 0 0 2 \n", "ME 2 2 0 0 0 4 \n", "MI 6 7 0 0 0 13 \n", "MN 17 4 3 0 0 24 \n", "MO 23 21 3 0 0 47 \n", "MS 12 17 7 5 1 42 \n", "MT 7 0 0 1 0 8 \n", "NC 14 11 6 1 0 32 \n", "ND 11 2 1 0 0 14 \n", "NE 33 13 9 3 4 62 \n", "NH 2 0 0 0 0 2 \n", "NM 12 3 0 0 0 15 \n", "NV 6 0 0 0 0 6 \n", "NY 1 8 1 1 0 11 \n", "OH 16 3 0 1 0 20 \n", "OK 12 3 2 0 0 17 \n", "PA 5 3 1 0 0 9 \n", "SC 7 0 0 0 0 7 \n", "SD 18 6 4 0 1 29 \n", "TN 3 10 3 2 0 18 \n", "TX 35 9 2 0 0 46 \n", "VA 11 1 0 0 0 12 \n", "WA 2 1 0 0 0 3 \n", "WI 6 11 4 1 0 22 \n", "WV 1 7 1 0 0 9 \n", "WY 10 2 1 0 0 13 \n", "Total 478 327 76 20 7 908 \n" ] }, "execution_count": 15, "metadata": {}, "output_type": "execute_result" } ], "source": [ "//Cross Tabs\n", "CrossTab.xCount(tornadoes, tornadoes.categoryColumn(\"State\"), tornadoes.shortColumn(\"Scale\")).print()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## K-means clustering\n", "\n", "K-means is the most common form of “centroid” clustering. Unlike classification, clustering is an unsupervised learning method. The categories are not predetermined. Instead, the goal is to search for natural groupings in the dataset, such that the members of each group are similar to each other and different from the members of the other groups. The K represents the number of groups to find.\n", "\n", "We’ll use a well known Scotch Whiskey dataset, which is used to cluster whiskeys according to their taste based on data collected from tasting notes. As always, we start by loading data and printing its structure.\n", "\n", "More description is available at https://jtablesaw.wordpress.com/2016/08/08/k-means-clustering-in-java/" ] }, { "cell_type": "code", "execution_count": 16, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "Structure of whiskey.csv\n", "Index Column Name Column Type \n", "0 RowID SHORT_INT \n", "1 Distillery CATEGORY \n", "2 Body SHORT_INT \n", "3 Sweetness SHORT_INT \n", "4 Smoky SHORT_INT \n", "5 Medicinal SHORT_INT \n", "6 Tobacco SHORT_INT \n", "7 Honey SHORT_INT \n", "8 Spicy SHORT_INT \n", "9 Winey SHORT_INT \n", "10 Nutty SHORT_INT \n", "11 Malty SHORT_INT \n", "12 Fruity SHORT_INT \n", "13 Floral SHORT_INT \n", "14 Postcode CATEGORY \n", "15 Latitude FLOAT \n", "16 Longitude INTEGER \n" ] }, "execution_count": 16, "metadata": {}, "output_type": "execute_result" } ], "source": [ "t = Table.createFromCsv(\"Tablesaw/whiskey.csv\")\n", "t.structure().print();" ] }, { "cell_type": "code", "execution_count": 17, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "Clusters\n", "Label Cluster \n", "Aberfeldy 0 \n", "Aberlour 0 \n", "Auchroisk 0 \n", "Balmenach 0 \n", "Belvenie 0 \n", "BenNevis 0 \n", "Benrinnes 0 \n", "Benromach 0 \n", "BlairAthol 0 \n", "Dailuaine 0 \n", "Dalmore 0 \n", "Deanston 0 \n", "Edradour 0 \n", "GlenOrd 0 \n", "Glendronach 0 \n", "Glendullan 0 \n", "Glenfarclas 0 \n", "Glenlivet 0 \n", "Glenrothes 0 \n", "Glenturret 0 \n", "Knochando 0 \n", "Longmorn 0 \n", "Macallan 0 \n", "Mortlach 0 \n", "RoyalLochnagar 0 \n", "Scapa 0 \n", "Strathisla 0 \n", "Ardbeg 1 \n", "Caol Ila 1 \n", "Clynelish 1 \n", "Lagavulin 1 \n", "Laphroig 1 \n", "Talisker 1 \n", "Ardmore 2 \n", "Balblair 2 \n", "Bowmore 2 \n", "GlenDeveronMacduff 2 \n", "GlenScotia 2 \n", "Highland Park 2 \n", "Isle of Jura 2 \n", "Oban 2 \n", "OldFettercairn 2 \n", "OldPulteney 2 \n", "Springbank 2 \n", "Tomatin 2 \n", "Tormore 2 \n", "Benriach 3 \n", "Bladnoch 3 \n", "Bruichladdich 3 \n", "Bunnahabhain 3 \n", "Craigallechie 3 \n", "Dalwhinnie 3 \n", "GlenGarioch 3 \n", "GlenMoray 3 \n", "Glenkinchie 3 \n", "Glenlossie 3 \n", "Inchgower 3 \n", "Loch Lomond 3 \n", "RoyalBrackla 3 \n", "Teaninich 3 \n", "Tomintoul 3 \n", "AnCnoc 4 \n", "ArranIsleOf 4 \n", "Auchentoshan 4 \n", "Aultmore 4 \n", "Cardhu 4 \n", "Craigganmore 4 \n", "Dufftown 4 \n", "GlenElgin 4 \n", "GlenGrant 4 \n", "GlenKeith 4 \n", "GlenSpey 4 \n", "Glenallachie 4 \n", "Glenfiddich 4 \n", "Glengoyne 4 \n", "Glenmorangie 4 \n", "Linkwood 4 \n", "Mannochmore 4 \n", "Miltonduff 4 \n", "Speyburn 4 \n", "Speyside 4 \n", "Strathmill 4 \n", "Tamdhu 4 \n", "Tamnavulin 4 \n", "Tobermory 4 \n", "Tullibardine 4 \n" ] }, "execution_count": 17, "metadata": {}, "output_type": "execute_result" } ], "source": [ "model = new Kmeans(\n", " 5,\n", " t.nCol(2), t.nCol(3), t.nCol(4), t.nCol(5), t.nCol(6), t.nCol(7),\n", " t.nCol(8), t.nCol(9), t.nCol(10), t.nCol(11), t.nCol(12), t.nCol(13)\n", ");\n", "\n", "//print claster formation\n", "model.clustered(t.column(\"Distillery\")).print();" ] }, { "cell_type": "code", "execution_count": 18, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "Centroids\n", "Cluster Body Sweetness Smoky Medicinal Tobacco Honey Spicy Winey Nutty Malty Fruity Floral \n", "0 2.7037036 2.4074075 1.4074074 0.074074075 0.0 1.8888888 1.6296296 1.8518518 1.8888888 2.074074 2.148148 1.7037038 \n", "1 3.6666667 1.5 3.6666667 3.3333333 0.6666667 0.16666667 1.6666666 0.5 1.1666666 1.3333334 1.1666666 0.16666667 \n", "2 1.9230769 2.0769231 2.0 1.0769231 0.23076923 1.1538461 1.3076923 0.84615386 1.6153846 1.7692307 0.9230769 1.0 \n", "3 1.3333334 2.0 1.4666667 0.46666667 0.13333334 1.2 1.8 0.53333336 0.8 1.8666667 1.8666667 2.4 \n", "4 1.52 2.64 0.96 0.16 0.04 0.88 0.84 0.48 1.4 1.6 2.0 2.0 \n" ] }, "execution_count": 18, "metadata": {}, "output_type": "execute_result" } ], "source": [ "//print centroids for each claster\n", "model.labeledCentroids().print();" ] }, { "cell_type": "code", "execution_count": 19, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "384.36957264957266" ] }, "execution_count": 19, "metadata": {}, "output_type": "execute_result" } ], "source": [ "//gets the distortion for our model\n", "model.distortion()" ] }, { "cell_type": "code", "execution_count": 20, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
" ] }, "execution_count": 20, "metadata": {}, "output_type": "execute_result" } ], "source": [ "def n = t.rowCount();\n", "def kValues = new double[n - 2];\n", "def distortions = new double[n - 2];\n", "\n", "for (int k = 2; k < n; k++) {\n", " kValues[k - 2] = k;\n", " def kmeans = new Kmeans(k,\n", " t.nCol(2), t.nCol(3), t.nCol(4), t.nCol(5), t.nCol(6), t.nCol(7),\n", " t.nCol(8), t.nCol(9), t.nCol(10), t.nCol(11), t.nCol(12), t.nCol(13)\n", " );\n", " distortions[k - 2] = kmeans.distortion();\n", "}\n", "def linearYPlot = new Plot(title: \"K-means clustering demo\", xLabel:\"K\", yLabel: \"distortion\")\n", "linearYPlot << new Line(x: kValues, y: distortions)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Play (Money)ball with Linear Regression\n", "\n", "In baseball, you make the playoffs by winning more games than your rivals. The number of games the rivals win is out of your control so the A’s looked instead at how many wins it took historically to make the playoffs. They decided that 95 wins would give them a strong chance. Here’s how we might check that assumption in Tablesaw.\n", "\n", "More description is available at https://jtablesaw.wordpress.com/2016/07/31/play-moneyball-data-science-in-tablesaw/" ] }, { "cell_type": "code", "execution_count": 21, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "" ] }, "execution_count": 21, "metadata": {}, "output_type": "execute_result" } ], "source": [ "baseball = Table.createFromCsv(\"Tablesaw/baseball.csv\");\n", "\n", "// filter to the data available at the start of the 2002 season\n", "moneyball = baseball.selectWhere(column(\"year\").isLessThan(2002));\n", "wins = moneyball.nCol(\"W\");\n", "year = moneyball.nCol(\"Year\");\n", "playoffs = moneyball.column(\"Playoffs\");\n", "runDifference = moneyball.shortColumn(\"RS\").subtract(moneyball.shortColumn(\"RA\"));\n", "moneyball.addColumn(runDifference);\n", "runDifference.setName(\"RD\");\n", "\n", "def Plot = new Plot(title: \"RD x Wins\", xLabel:\"RD\", yLabel: \"W\")\n", "Plot << new Points(x: moneyball.numericColumn(\"RD\").toDoubleArray(), y: moneyball.numericColumn(\"W\").toDoubleArray())" ] }, { "cell_type": "code", "execution_count": 22, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "Linear Model:\n", "\n", "Residuals:\n", "\t Min\t 1Q\t Median\t 3Q\t Max\n", "\t -14.2662\t -2.6511\t 0.1282\t 2.9365\t 11.6570\n", "\n", "Coefficients:\n", " Estimate Std. Error t value Pr(>|t|)\n", "(Intercept) 80.8814 0.1312 616.6747 0.0000 ***\n", "RD 0.1058 0.0013 81.5536 0.0000 ***\n", "---------------------------------------------------------------------\n", "Significance codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1\n", "\n", "Residual standard error: 3.9391 on 900 degrees of freedom\n", "Multiple R-squared: 0.8808, Adjusted R-squared: 0.8807\n", "F-statistic: 6650.9926 on 1 and 900 DF, p-value: 0.000\n" ] }, "execution_count": 22, "metadata": {}, "output_type": "execute_result" } ], "source": [ "winsModel = LeastSquares.train(wins, runDifference);" ] }, { "cell_type": "code", "execution_count": 23, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "Linear Model:\n", "\n", "Residuals:\n", "\t Min\t 1Q\t Median\t 3Q\t Max\n", "\t -70.8379\t -17.1810\t -1.0917\t 16.7812\t 90.0358\n", "\n", "Coefficients:\n", " Estimate Std. Error t value Pr(>|t|)\n", "(Intercept) -804.6271 18.9208 -42.5261 0.0000 ***\n", "OBP 2737.7682 90.6846 30.1900 0.0000 ***\n", "SLG 1584.9085 42.1556 37.5966 0.0000 ***\n", "---------------------------------------------------------------------\n", "Significance codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1\n", "\n", "Residual standard error: 24.7900 on 899 degrees of freedom\n", "Multiple R-squared: 0.9296, Adjusted R-squared: 0.9294\n", "F-statistic: 5933.7256 on 2 and 899 DF, p-value: 0.000\n" ] }, "execution_count": 23, "metadata": {}, "output_type": "execute_result" } ], "source": [ "def runDiff = new double[1];\n", "runDiff[0] = 135;\n", "def expectedWins = winsModel.predict(runDiff);\n", "runsScored2 = LeastSquares.train(moneyball.nCol(\"RS\"), moneyball.nCol(\"OBP\"), moneyball.nCol(\"SLG\"));" ] }, { "cell_type": "code", "execution_count": 24, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "" ] }, "execution_count": 24, "metadata": {}, "output_type": "execute_result" } ], "source": [ "new Histogram(xLabel:\"X\",\n", " yLabel:\"Proportion\",\n", " data: Arrays.asList(runsScored2.residuals()), \n", " binCount: 25);" ] } ], "metadata": { "anaconda-cloud": {}, "kernelspec": { "display_name": "Groovy", "language": "groovy", "name": "groovy" }, "language_info": { "codemirror_mode": "", "file_extension": ".groovy", "mimetype": "", "name": "Groovy", "nbconverter_exporter": "", "pygments_lexer": "", "version": "2.4.6" } }, "nbformat": 4, "nbformat_minor": 2 }