Tablesaw

Tablesaw comes built-in to the BeakerX Groovy kernel. Tablesaw provides the ability to easily transform, summarize, and filter data, as well as computing descriptive statistics and fundamental machine learning algorithms.

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.

Basics of Table manipulation

More description is available at https://jtablesaw.wordpress.com/an-introduction/

In [2]:
tornadoes = Table.createFromCsv("Tablesaw/tornadoes_2014.csv")
//print dataset structure    
tornadoes.structure().print()
Out[2]:
Structure of tornadoes_2014.csv
Index Column Name Column Type 
0     Date        LOCAL_DATE  
1     Time        LOCAL_TIME  
2     State       CATEGORY    
3     State No    SHORT_INT   
4     Scale       SHORT_INT   
5     Injuries    SHORT_INT   
6     Fatalities  SHORT_INT   
7     Start Lat   FLOAT       
8     Start Lon   FLOAT       
9     Length      FLOAT       
10    Width       FLOAT       
In [6]:
//get header names
tornadoes.columnNames()
Out[6]:
[Date, Time, State, State No, Scale, Injuries, Fatalities, Start Lat, Start Lon, Length, Width]
In [7]:
//displays the row and column counts
tornadoes.shape()
Out[7]:
908 rows X 11 cols
In [8]:
//displays the first n rows
tornadoes.first(10).print()
Out[8]:
tornadoes_2014.csv
Date       Time     State State No Scale Injuries Fatalities Start Lat Start Lon Length Width 
2014-01-11 06:37:00 GA    0        0     0        0          34.3328   -84.5286  2.9    10.0  
2014-01-11 14:32:00 VA    0        0     0        0          37.025    -76.6377  1.36   100.0 
2014-01-11 14:32:00 VA    0        0     0        0          36.8769   -76.6721  1.95   50.0  
2014-01-11 14:50:00 VA    0        0     0        0          37.08     -76.3     1.08   75.0  
2014-02-20 14:25:00 IL    0        2     1        0          39.518    -90.841   12.09  80.0  
2014-02-20 14:48:00 IL    0        0     0        0          39.7853   -90.4215  0.27   25.0  
2014-02-20 14:52:00 IL    0        0     0        0          39.8193   -90.4178  8.17   50.0  
2014-02-20 15:43:00 IL    0        0     0        0          39.5671   -89.6256  0.22   75.0  
2014-02-20 15:57:00 IL    0        1     0        0          38.7575   -89.6151  20.56  300.0 
2014-02-20 16:09:00 IL    0        2     1        0          39.2586   -89.234   22.38  200.0 
In [9]:
tornadoes.structure().selectWhere(column("Column Type").isEqualTo("FLOAT")).print()
Out[9]:
Structure of tornadoes_2014.csv
Index Column Name Column Type 
7     Start Lat   FLOAT       
8     Start Lon   FLOAT       
9     Length      FLOAT       
10    Width       FLOAT       
In [10]:
//summarize the data in each column
tornadoes.summary()
Out[10]:
Table summary for: tornadoes_2014.csv
Column: Date
Measure  Value      
Count    908        
Missing  0          
Earliest 2014-01-11 
Latest   2014-12-29 

Column: Time
Measure  Value 
Count    908   
Missing  0     
Earliest 00:01 
Latest   23:59 

Column: State
Category Count 
GA       32    
NM       15    
MT       8     
CO       49    
WV       9     
IN       28    
MD       2     
CA       9     
AL       55    
TN       18    
NV       6     
PA       9     
WY       13    
ID       3     
KS       41    
IA       56    
MN       24    
TX       46    
WA       3     
OK       17    
NE       62    
AR       20    
ND       14    
WI       22    
IL       49    
SD       29    
MS       42    
FL       28    
AZ       3     
NY       11    
NC       32    
OH       20    
DE       1     
VA       12    
MO       47    
ME       4     
LA       15    
MI       13    
SC       7     
KY       28    
MA       3     
CT       1     
NH       2     

Column: State No
Measure  Value 
n        908.0 
sum      0.0   
Mean     0.0   
Min      0.0   
Max      0.0   
Range    0.0   
Variance 0.0   
Std. Dev 0.0   

Column: Scale
Measure  Value      
n        908.0      
sum      567.0      
Mean     0.6244493  
Min      0.0        
Max      4.0        
Range    4.0        
Variance 0.6272737  
Std. Dev 0.79200613 

Column: Injuries
Measure  Value      
n        908.0      
sum      684.0      
Mean     0.75330395 
Min      0.0        
Max      193.0      
Range    193.0      
Variance 57.68108   
Std. Dev 7.594806   

Column: Fatalities
Measure  Value       
n        908.0       
sum      48.0        
Mean     0.052863438 
Min      0.0         
Max      16.0        
Range    16.0        
Variance 0.44262686  
Std. Dev 0.6653021   

Column: Start Lat
Measure  Value     
n        908.0     
sum      34690.984 
Mean     38.20593  
Min      0.0       
Max      48.86     
Range    48.86     
Variance 22.448586 
Std. Dev 4.7379937 

Column: Start Lon
Measure  Value     
n        908.0     
sum      -83613.02 
Mean     -92.08483 
Min      -122.946  
Max      0.0       
Range    122.946   
Variance 91.84773  
Std. Dev 9.583722  

Column: Length
Measure  Value     
n        908.0     
sum      3014.49   
Mean     3.319923  
Min      0.0       
Max      45.68     
Range    45.68     
Variance 28.736567 
Std. Dev 5.3606496 

Column: Width
Measure  Value     
n        908.0     
sum      149778.0  
Mean     164.95375 
Min      0.0       
Max      2640.0    
Range    2640.0    
Variance 57764.465 
Std. Dev 240.34239 


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

K-means clustering

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.

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.

More description is available at https://jtablesaw.wordpress.com/2016/08/08/k-means-clustering-in-java/

In [16]:
t = Table.createFromCsv("Tablesaw/whiskey.csv")
t.structure().print();
Out[16]:
Structure of whiskey.csv
Index Column Name Column Type 
0     RowID       SHORT_INT   
1     Distillery  CATEGORY    
2     Body        SHORT_INT   
3     Sweetness   SHORT_INT   
4     Smoky       SHORT_INT   
5     Medicinal   SHORT_INT   
6     Tobacco     SHORT_INT   
7     Honey       SHORT_INT   
8     Spicy       SHORT_INT   
9     Winey       SHORT_INT   
10    Nutty       SHORT_INT   
11    Malty       SHORT_INT   
12    Fruity      SHORT_INT   
13    Floral      SHORT_INT   
14    Postcode    CATEGORY    
15    Latitude    FLOAT       
16    Longitude   INTEGER     
In [17]:
model = new Kmeans(
    5,
    t.nCol(2), t.nCol(3), t.nCol(4), t.nCol(5), t.nCol(6), t.nCol(7),
    t.nCol(8), t.nCol(9), t.nCol(10), t.nCol(11), t.nCol(12), t.nCol(13)
);

//print claster formation
model.clustered(t.column("Distillery")).print();
Out[17]:
Clusters
Label              Cluster 
Aberfeldy          0       
Aberlour           0       
Auchroisk          0       
Balmenach          0       
Belvenie           0       
BenNevis           0       
Benrinnes          0       
Benromach          0       
BlairAthol         0       
Dailuaine          0       
Dalmore            0       
Deanston           0       
Edradour           0       
GlenOrd            0       
Glendronach        0       
Glendullan         0       
Glenfarclas        0       
Glenlivet          0       
Glenrothes         0       
Glenturret         0       
Knochando          0       
Longmorn           0       
Macallan           0       
Mortlach           0       
RoyalLochnagar     0       
Scapa              0       
Strathisla         0       
Ardbeg             1       
Caol Ila           1       
Clynelish          1       
Lagavulin          1       
Laphroig           1       
Talisker           1       
Ardmore            2       
Balblair           2       
Bowmore            2       
GlenDeveronMacduff 2       
GlenScotia         2       
Highland Park      2       
Isle of Jura       2       
Oban               2       
OldFettercairn     2       
OldPulteney        2       
Springbank         2       
Tomatin            2       
Tormore            2       
Benriach           3       
Bladnoch           3       
Bruichladdich      3       
Bunnahabhain       3       
Craigallechie      3       
Dalwhinnie         3       
GlenGarioch        3       
GlenMoray          3       
Glenkinchie        3       
Glenlossie         3       
Inchgower          3       
Loch Lomond        3       
RoyalBrackla       3       
Teaninich          3       
Tomintoul          3       
AnCnoc             4       
ArranIsleOf        4       
Auchentoshan       4       
Aultmore           4       
Cardhu             4       
Craigganmore       4       
Dufftown           4       
GlenElgin          4       
GlenGrant          4       
GlenKeith          4       
GlenSpey           4       
Glenallachie       4       
Glenfiddich        4       
Glengoyne          4       
Glenmorangie       4       
Linkwood           4       
Mannochmore        4       
Miltonduff         4       
Speyburn           4       
Speyside           4       
Strathmill         4       
Tamdhu             4       
Tamnavulin         4       
Tobermory          4       
Tullibardine       4       
In [18]:
//print centroids for each claster
model.labeledCentroids().print();
Out[18]:
Centroids
Cluster Body      Sweetness Smoky     Medicinal   Tobacco    Honey      Spicy     Winey      Nutty     Malty     Fruity    Floral     
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  
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 
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        
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        
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        
In [19]:
//gets the distortion for our model
model.distortion()
Out[19]:
384.36957264957266
In [20]:
def n = t.rowCount();
def kValues = new double[n - 2];
def distortions = new double[n - 2];

for (int k = 2; k < n; k++) {
  kValues[k - 2] = k;
  def kmeans = new Kmeans(k,
      t.nCol(2), t.nCol(3), t.nCol(4), t.nCol(5), t.nCol(6), t.nCol(7),
      t.nCol(8), t.nCol(9), t.nCol(10), t.nCol(11), t.nCol(12), t.nCol(13)
  );
  distortions[k - 2] = kmeans.distortion();
}
def linearYPlot = new Plot(title: "K-means clustering demo", xLabel:"K", yLabel: "distortion")
linearYPlot << new Line(x: kValues, y: distortions)
Out[20]:

Play (Money)ball with Linear Regression

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.

More description is available at https://jtablesaw.wordpress.com/2016/07/31/play-moneyball-data-science-in-tablesaw/

In [21]:
baseball = Table.createFromCsv("Tablesaw/baseball.csv");

// filter to the data available at the start of the 2002 season
moneyball = baseball.selectWhere(column("year").isLessThan(2002));
wins = moneyball.nCol("W");
year = moneyball.nCol("Year");
playoffs = moneyball.column("Playoffs");
runDifference = moneyball.shortColumn("RS").subtract(moneyball.shortColumn("RA"));
moneyball.addColumn(runDifference);
runDifference.setName("RD");

def Plot = new Plot(title: "RD x Wins", xLabel:"RD", yLabel: "W")
Plot << new Points(x: moneyball.numericColumn("RD").toDoubleArray(), y: moneyball.numericColumn("W").toDoubleArray())
Out[21]:
In [22]:
winsModel = LeastSquares.train(wins, runDifference);
Out[22]:
Linear Model:

Residuals:
	       Min	        1Q	    Median	        3Q	       Max
	  -14.2662	   -2.6511	    0.1282	    2.9365	   11.6570

Coefficients:
            Estimate        Std. Error        t value        Pr(>|t|)
(Intercept)    80.8814            0.1312       616.6747          0.0000 ***
RD              0.1058            0.0013        81.5536          0.0000 ***
---------------------------------------------------------------------
Significance codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1

Residual standard error: 3.9391 on 900 degrees of freedom
Multiple R-squared: 0.8808,    Adjusted R-squared: 0.8807
F-statistic: 6650.9926 on 1 and 900 DF,  p-value: 0.000
In [23]:
def runDiff = new double[1];
runDiff[0] = 135;
def expectedWins = winsModel.predict(runDiff);
runsScored2 = LeastSquares.train(moneyball.nCol("RS"), moneyball.nCol("OBP"), moneyball.nCol("SLG"));
Out[23]:
Linear Model:

Residuals:
	       Min	        1Q	    Median	        3Q	       Max
	  -70.8379	  -17.1810	   -1.0917	   16.7812	   90.0358

Coefficients:
            Estimate        Std. Error        t value        Pr(>|t|)
(Intercept)  -804.6271           18.9208       -42.5261          0.0000 ***
OBP          2737.7682           90.6846        30.1900          0.0000 ***
SLG          1584.9085           42.1556        37.5966          0.0000 ***
---------------------------------------------------------------------
Significance codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1

Residual standard error: 24.7900 on 899 degrees of freedom
Multiple R-squared: 0.9296,    Adjusted R-squared: 0.9294
F-statistic: 5933.7256 on 2 and 899 DF,  p-value: 0.000
In [24]:
new Histogram(xLabel:"X",
              yLabel:"Proportion",
              data: Arrays.asList(runsScored2.residuals()), 
              binCount: 25);
Out[24]: