notebook.community

Edit and run 





In [ ]:



    


#
# TODO: Import whatever needs to be imported to make this work
#
# .. your code here ..

from sklearn.cluster import KMeans
import matplotlib
import matplotlib.pyplot as plt
import pandas as pd
%matplotlib inline

# Look Pretty

matplotlib.style.use('ggplot')
plt.style.use('ggplot')



    











In [ ]:



    


#
# TODO: To procure the dataset, follow these steps:
# 1. Navigate to: https://data.cityofchicago.org/Public-Safety/Crimes-2001-to-present/ijzp-q8t2
# 2. In the 'Primary Type' column, click on the 'Menu' button next to the info button,
#    and select 'Filter This Column'. It might take a second for the filter option to
#    show up, since it has to load the entire list first.
# 3. Scroll down to 'GAMBLING'
# 4. Click the light blue 'Export' button next to the 'Filter' button, and select 'Download As CSV'



    











In [43]:



    


#
# TODO: Load your dataset after importing Pandas
#
# .. your code here ..

df = pd.read_csv('Datasets/GAMBLING criminal report.csv')
df.shape



    


















    
Out[43]:








(14090, 22)

















In [44]:



    


#
# TODO: Drop any ROWs with nans in them
#
# .. your code here ..
df = df.dropna()
df.shape



    


















    
Out[44]:








(12875, 22)

















In [45]:



    


#
# TODO: Print out the dtypes of your dset
#
# .. your code here ..
df.dtypes



    


















    
Out[45]:








ID                        int64
Case Number              object
Date                     object
Block                    object
IUCR                      int64
Primary Type             object
Description              object
Location Description     object
Arrest                     bool
Domestic                   bool
Beat                      int64
District                  int64
Ward                    float64
Community Area          float64
FBI Code                  int64
X Coordinate            float64
Y Coordinate            float64
Year                      int64
Updated On               object
Latitude                float64
Longitude               float64
Location                 object
dtype: object

















In [46]:



    


#
# Coerce the 'Date' feature (which is currently a string object) into real date,
# and confirm by re-printing the dtypes. NOTE: This is a slow process...
#
# .. your code here ..
df.Date = pd.to_datetime(df.Date, coerce=True)
df.dtypes



    


















    






//anaconda/lib/python3.5/site-packages/ipykernel/__main__.py:6: FutureWarning: the coerce=True keyword is deprecated, use errors='coerce' instead










    
Out[46]:








ID                               int64
Case Number                     object
Date                    datetime64[ns]
Block                           object
IUCR                             int64
Primary Type                    object
Description                     object
Location Description            object
Arrest                            bool
Domestic                          bool
Beat                             int64
District                         int64
Ward                           float64
Community Area                 float64
FBI Code                         int64
X Coordinate                   float64
Y Coordinate                   float64
Year                             int64
Updated On                      object
Latitude                       float64
Longitude                      float64
Location                        object
dtype: object

















In [47]:



    


def doKMeans(df):
  #
  # INFO: Plot your data with a '.' marker, with 0.3 alpha at the Longitude,
  # and Latitude locations in your dataset. Longitude = x, Latitude = y
    fig = plt.figure()
    ax = fig.add_subplot(111)
    #ax.scatter(df.Longitude, df.Latitude, marker='.', alpha=0.3)
    #plt.show()
    
  #
  # TODO: Filter df so that you're only looking at Longitude and Latitude,
  # since the remaining columns aren't really applicable for this purpose.
    af = df[['Latitude', 'Longitude']]

  #
  # TODO: Use K-Means to try and find seven cluster centers in this df.
  # Be sure to name your kmeans model `model` so that the printing works.
    kmean = KMeans(n_clusters=8)
    model = kmean.fit(af)
    
  #
  # INFO: Print and plot the centroids...
    centroids = model.cluster_centers_
    ax.scatter(centroids[:,0], centroids[:,1], marker='x', c='red', alpha=0.5, linewidths=3, s=169)
    
    plt.show()
    print(centroids)
    
# INFO: Print & Plot your data
doKMeans(df)



    


















    

















    






[[ 41.75095773 -87.5801561 ]
 [ 41.89370667 -87.75747678]
 [ 41.77305852 -87.66587835]
 [ 41.69718213 -87.63130514]
 [ 41.87183531 -87.64663979]
 [ 41.98244509 -87.68528101]
 [ 41.87768571 -87.71596564]
 [ 41.79316295 -87.61789681]]

















In [51]:



    


#
# TODO: Filter out the data so that it only contains samples that have
# a Date > '2011-01-01', using indexing. Then, in a new figure, plot the
# crime incidents, as well as a new K-Means run's centroids.
#
newdf = df[df.Date > '2011-01-01']
doKMeans(df)



    


















    

















    






[[ 41.77298026 -87.66581476]
 [ 41.87766551 -87.71596538]
 [ 41.75093778 -87.58021566]
 [ 41.98237147 -87.68532949]
 [ 41.89370667 -87.75747678]
 [ 41.87183531 -87.64663979]
 [ 41.79321345 -87.61786731]
 [ 41.69687153 -87.63123048]]

















In [49]:



    


df



    


















    
Out[49]:










  
    

      
      ID
      Case Number
      Date
      Block
      IUCR
      Primary Type
      Description
      Location Description
      Arrest
      Domestic
      ...
      Ward
      Community Area
      FBI Code
      X Coordinate
      Y Coordinate
      Year
      Updated On
      Latitude
      Longitude
      Location
    

  
  
    

      0
      4647776
      HM172874
      2006-02-09 22:29:07
      075XX S COLFAX AVE
      1661
      GAMBLING
      GAME/DICE
      SIDEWALK
      True
      False
      ...
      7.0
      43.0
      19
      1194833.0
      1855572.0
      2006
      04/15/2016 08:55:02 AM
      41.758607
      -87.561511
      (41.758607126, -87.561510616)
    

    

      1
      4649196
      HM157167
      2006-02-01 12:30:27
      038XX W FERDINAND ST
      1661
      GAMBLING
      GAME/DICE
      SIDEWALK
      True
      False
      ...
      27.0
      23.0
      19
      1150871.0
      1903067.0
      2006
      04/15/2016 08:55:02 AM
      41.889909
      -87.721389
      (41.889909247, -87.721389051)
    

    

      2
      4649661
      HM159623
      2006-02-02 19:02:12
      050XX W SUPERIOR ST
      1661
      GAMBLING
      GAME/DICE
      SIDEWALK
      True
      False
      ...
      28.0
      25.0
      19
      1142605.0
      1904502.0
      2006
      04/15/2016 08:55:02 AM
      41.894005
      -87.751710
      (41.89400481, -87.751710086)
    

    

      3
      4650448
      HM158020
      2006-02-01 20:13:00
      056XX W WASHINGTON BLVD
      1661
      GAMBLING
      GAME/DICE
      RESIDENCE PORCH/HALLWAY
      True
      False
      ...
      29.0
      25.0
      19
      1138430.0
      1900175.0
      2006
      04/15/2016 08:55:02 AM
      41.882208
      -87.767149
      (41.882207608, -87.767148598)
    

    

      4
      4650940
      HM156984
      2006-02-01 10:10:00
      015XX W 72ND ST
      1661
      GAMBLING
      GAME/DICE
      SIDEWALK
      True
      False
      ...
      17.0
      67.0
      19
      1167231.0
      1856980.0
      2006
      04/15/2016 08:55:02 AM
      41.763106
      -87.662629
      (41.763105901, -87.66262925)
    

    

      5
      4651151
      HM161364
      2006-02-03 16:40:00
      001XX N LATROBE AVE
      1661
      GAMBLING
      GAME/DICE
      SIDEWALK
      True
      False
      ...
      28.0
      25.0
      19
      1141360.0
      1900477.0
      2006
      04/15/2016 08:55:02 AM
      41.882983
      -87.756382
      (41.882982785, -87.756382024)
    

    

      6
      4656683
      HM161437
      2006-02-03 16:30:00
      002XX W ALEXANDER ST
      1651
      GAMBLING
      GAME/CARDS
      OTHER
      True
      False
      ...
      25.0
      34.0
      19
      1174969.0
      1889230.0
      2006
      04/15/2016 08:55:02 AM
      41.851434
      -87.633305
      (41.851433926, -87.633305383)
    

    

      7
      4656759
      HM161911
      2006-02-03 20:00:00
      044XX N MILWAUKEE AVE
      1680
      GAMBLING
      OTHER
      ALLEY
      True
      False
      ...
      45.0
      15.0
      19
      1141580.0
      1928940.0
      2006
      04/15/2016 08:55:02 AM
      41.961084
      -87.754869
      (41.961084206, -87.754869118)
    

    

      8
      4657274
      HM159750
      2006-02-02 19:30:00
      084XX S PULASKI RD
      1680
      GAMBLING
      OTHER
      OTHER
      True
      False
      ...
      18.0
      70.0
      19
      1151210.0
      1848126.0
      2006
      04/15/2016 08:55:02 AM
      41.739137
      -87.721580
      (41.739136801, -87.721580463)
    

    

      9
      4657315
      HM159804
      2006-02-02 18:50:00
      049XX W FOSTER AVE
      1670
      GAMBLING
      GAME/AMUSEMENT DEVICE
      TAVERN/LIQUOR STORE
      True
      False
      ...
      45.0
      12.0
      19
      1142277.0
      1934118.0
      2006
      04/15/2016 08:55:02 AM
      41.975280
      -87.752177
      (41.975280123, -87.752177413)
    

    

      10
      4660220
      HM259820
      2006-03-29 15:35:00
      016XX N LECLAIRE AVE
      1661
      GAMBLING
      GAME/DICE
      SIDEWALK
      True
      False
      ...
      37.0
      25.0
      19
      1142298.0
      1910593.0
      2006
      04/15/2016 08:55:02 AM
      41.910725
      -87.752686
      (41.910724913, -87.752686197)
    

    

      11
      4662776
      HM168656
      2006-02-07 17:20:00
      002XX E 61ST ST
      1630
      GAMBLING
      WIREROOM/HORSES
      STREET
      True
      False
      ...
      20.0
      40.0
      19
      1178800.0
      1864618.0
      2006
      04/15/2016 08:55:02 AM
      41.783810
      -87.619995
      (41.783810008, -87.61999476)
    

    

      12
      4663539
      HM166553
      2006-02-06 15:18:40
      095XX S PRINCETON AVE
      1661
      GAMBLING
      GAME/DICE
      ALLEY
      True
      False
      ...
      21.0
      49.0
      19
      1175958.0
      1841741.0
      2006
      04/15/2016 08:55:02 AM
      41.721097
      -87.631099
      (41.721096996, -87.631099091)
    

    

      13
      4663794
      HM263708
      2006-03-31 13:00:00
      059XX W NORTH AVE
      1661
      GAMBLING
      GAME/DICE
      SIDEWALK
      True
      False
      ...
      29.0
      25.0
      19
      1136288.0
      1910021.0
      2006
      04/15/2016 08:55:02 AM
      41.909265
      -87.774779
      (41.909264799, -87.774778781)
    

    

      14
      4667660
      HM172239
      2006-02-09 15:45:24
      119XX S INDIANA AVE
      1661
      GAMBLING
      GAME/DICE
      RESIDENCE
      True
      False
      ...
      9.0
      53.0
      19
      1179716.0
      1826020.0
      2006
      04/15/2016 08:55:02 AM
      41.677871
      -87.617813
      (41.677871461, -87.617812794)
    

    

      15
      4668207
      HM146972
      2006-01-26 22:05:00
      034XX W BELMONT AVE
      1670
      GAMBLING
      GAME/AMUSEMENT DEVICE
      RESTAURANT
      True
      False
      ...
      35.0
      21.0
      19
      1153042.0
      1921070.0
      2006
      04/15/2016 08:55:02 AM
      41.939268
      -87.712938
      (41.939268304, -87.712937877)
    

    

      16
      4669202
      HM168718
      2006-02-07 17:50:00
      050XX W ARMITAGE AVE
      1670
      GAMBLING
      GAME/AMUSEMENT DEVICE
      RESTAURANT
      True
      False
      ...
      31.0
      19.0
      19
      1142305.0
      1912825.0
      2006
      04/15/2016 08:55:02 AM
      41.916850
      -87.752605
      (41.916849633, -87.752604962)
    

    

      17
      4669446
      HM170157
      2006-02-08 14:15:00
      004XX E 63RD ST
      1626
      GAMBLING
      ILLEGAL ILL LOTTERY
      STREET
      True
      False
      ...
      20.0
      42.0
      19
      1180239.0
      1863334.0
      2006
      04/15/2016 08:55:02 AM
      41.780254
      -87.614758
      (41.780253707, -87.61475825)
    

    

      18
      4669852
      HM174694
      2006-02-10 20:40:00
      068XX W IRVING PARK RD
      1670
      GAMBLING
      GAME/AMUSEMENT DEVICE
      RESTAURANT
      True
      False
      ...
      38.0
      17.0
      19
      1129855.0
      1925824.0
      2006
      04/15/2016 08:55:02 AM
      41.952743
      -87.798049
      (41.952742671, -87.798048765)
    

    

      19
      4669874
      HM175392
      2006-02-11 07:30:00
      061XX S DR MARTIN LUTHER KING JR DR
      1626
      GAMBLING
      ILLEGAL ILL LOTTERY
      STREET
      True
      False
      ...
      20.0
      40.0
      19
      1179972.0
      1864490.0
      2006
      04/15/2016 08:55:02 AM
      41.783432
      -87.615702
      (41.783432002, -87.615701737)
    

    

      20
      4669934
      HM180514
      2006-02-14 11:25:00
      023XX S WENTWORTH AVE
      1670
      GAMBLING
      GAME/AMUSEMENT DEVICE
      SMALL RETAIL STORE
      True
      False
      ...
      25.0
      34.0
      19
      1175345.0
      1888637.0
      2006
      04/15/2016 08:55:02 AM
      41.849798
      -87.631943
      (41.84979827, -87.631943164)
    

    

      21
      4670791
      HL780947
      2005-12-09 20:55:00
      031XX W LAWRENCE AVE
      1670
      GAMBLING
      GAME/AMUSEMENT DEVICE
      TAVERN/LIQUOR STORE
      True
      False
      ...
      33.0
      14.0
      19
      1154644.0
      1931723.0
      2005
      04/15/2016 08:55:02 AM
      41.968469
      -87.706764
      (41.968468875, -87.706763807)
    

    

      22
      4671669
      HM184475
      2006-02-16 12:51:59
      103XX S ELIZABETH ST
      1661
      GAMBLING
      GAME/DICE
      SCHOOL, PUBLIC, BUILDING
      True
      False
      ...
      21.0
      73.0
      19
      1169846.0
      1836216.0
      2006
      04/15/2016 08:55:02 AM
      41.706070
      -87.653646
      (41.706070186, -87.653645803)
    

    

      25
      4675582
      HM199572
      2006-02-24 21:10:00
      031XX W LAWRENCE AVE
      1670
      GAMBLING
      GAME/AMUSEMENT DEVICE
      TAVERN/LIQUOR STORE
      True
      False
      ...
      33.0
      14.0
      19
      1154644.0
      1931723.0
      2006
      04/15/2016 08:55:02 AM
      41.968469
      -87.706764
      (41.968468875, -87.706763807)
    

    

      26
      4684365
      HM243673
      2006-03-20 21:38:00
      001XX E 70TH ST
      1661
      GAMBLING
      GAME/DICE
      RESIDENCE PORCH/HALLWAY
      True
      False
      ...
      6.0
      69.0
      19
      1178591.0
      1858641.0
      2006
      04/15/2016 08:55:02 AM
      41.767413
      -87.620943
      (41.767413258, -87.620942554)
    

    

      27
      4685491
      HM199419
      2006-02-24 20:57:58
      054XX S BISHOP ST
      1611
      GAMBLING
      BOOKMAKING/SPORTS
      SIDEWALK
      True
      False
      ...
      16.0
      61.0
      19
      1167590.0
      1868722.0
      2006
      04/15/2016 08:55:02 AM
      41.795320
      -87.660977
      (41.795319727, -87.660976952)
    

    

      28
      4685568
      HM214684
      2006-03-05 11:05:00
      051XX W WASHINGTON BLVD
      1661
      GAMBLING
      GAME/DICE
      RESIDENCE PORCH/HALLWAY
      True
      False
      ...
      28.0
      25.0
      19
      1141945.0
      1900001.0
      2006
      04/15/2016 08:55:02 AM
      41.881666
      -87.754246
      (41.88166577, -87.754245643)
    

    

      29
      4686417
      HM220309
      2006-03-08 13:40:00
      062XX S STONY ISLAND AVE
      1661
      GAMBLING
      GAME/DICE
      SCHOOL, PUBLIC, BUILDING
      True
      False
      ...
      5.0
      42.0
      19
      1187940.0
      1864073.0
      2006
      04/15/2016 08:55:02 AM
      41.782102
      -87.586502
      (41.78210152, -87.586502002)
    

    

      30
      4686861
      HM174731
      2006-02-10 21:55:25
      079XX S MANISTEE AVE
      1661
      GAMBLING
      GAME/DICE
      APARTMENT
      True
      False
      ...
      7.0
      46.0
      19
      1195891.0
      1852756.0
      2006
      04/15/2016 08:55:02 AM
      41.750854
      -87.557726
      (41.750853701, -87.557726247)
    

    

      31
      4687668
      HM191630
      2006-02-20 20:31:23
      014XX W 13TH ST
      1661
      GAMBLING
      GAME/DICE
      CHA HALLWAY/STAIRWELL/ELEVATOR
      True
      False
      ...
      2.0
      28.0
      19
      1166925.0
      1894158.0
      2006
      04/15/2016 08:55:02 AM
      41.865133
      -87.662687
      (41.865132942, -87.662687356)
    

    

      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
    

    

      14060
      10913964
      JA227360
      2017-04-16 18:30:00
      032XX W WALNUT ST
      1661
      GAMBLING
      GAME/DICE
      SIDEWALK
      True
      False
      ...
      28.0
      27.0
      19
      1154797.0
      1901447.0
      2017
      04/23/2017 03:49:01 PM
      41.885386
      -87.707014
      (41.885386072, -87.707014386)
    

    

      14061
      10919938
      JA233253
      2017-04-21 10:10:00
      070XX S PAULINA ST
      1661
      GAMBLING
      GAME/DICE
      SIDEWALK
      True
      False
      ...
      17.0
      67.0
      19
      1166227.0
      1858056.0
      2017
      04/28/2017 03:58:42 PM
      41.766080
      -87.666279
      (41.766080013, -87.666278518)
    

    

      14062
      10923389
      JA237675
      2017-04-24 18:39:00
      015XX W WASHBURNE AVE
      1661
      GAMBLING
      GAME/DICE
      SIDEWALK
      True
      False
      ...
      2.0
      28.0
      19
      1166283.0
      1894477.0
      2017
      05/01/2017 03:53:39 PM
      41.866022
      -87.665035
      (41.866022043, -87.665035028)
    

    

      14063
      10923428
      JA237757
      2017-04-24 19:54:00
      011XX N HAMLIN AVE
      1661
      GAMBLING
      GAME/DICE
      SIDEWALK
      True
      False
      ...
      27.0
      23.0
      19
      1150837.0
      1907397.0
      2017
      05/01/2017 03:53:39 PM
      41.901792
      -87.721400
      (41.901791872, -87.721400499)
    

    

      14064
      10923537
      JA237907
      2017-04-24 21:57:00
      062XX S MAPLEWOOD AVE
      1661
      GAMBLING
      GAME/DICE
      SIDEWALK
      True
      False
      ...
      15.0
      66.0
      19
      1160441.0
      1863266.0
      2017
      05/01/2017 03:53:39 PM
      41.780498
      -87.687343
      (41.780498171, -87.687342915)
    

    

      14065
      10924879
      JA239380
      2017-04-25 23:50:00
      054XX W ADAMS ST
      1661
      GAMBLING
      GAME/DICE
      RESIDENTIAL YARD (FRONT/BACK)
      True
      False
      ...
      29.0
      25.0
      19
      1140309.0
      1898802.0
      2017
      05/02/2017 03:50:33 PM
      41.878406
      -87.760282
      (41.878405695, -87.760282469)
    

    

      14066
      10926028
      JA240461
      2017-04-26 18:50:00
      063XX S ARTESIAN AVE
      1661
      GAMBLING
      GAME/DICE
      SIDEWALK
      True
      False
      ...
      15.0
      66.0
      19
      1161127.0
      1862600.0
      2017
      05/03/2017 03:53:47 PM
      41.778656
      -87.684846
      (41.778656405, -87.684846319)
    

    

      14067
      10928211
      JA242791
      2017-04-28 14:35:00
      048XX W FULTON ST
      1661
      GAMBLING
      GAME/DICE
      SIDEWALK
      True
      False
      ...
      28.0
      25.0
      19
      1144218.0
      1901500.0
      2017
      05/05/2017 03:50:30 PM
      41.885737
      -87.745861
      (41.885736814, -87.74586147)
    

    

      14068
      10928234
      JA242734
      2017-04-28 13:19:00
      039XX W GRENSHAW ST
      1661
      GAMBLING
      GAME/DICE
      SIDEWALK
      True
      False
      ...
      24.0
      29.0
      19
      1150341.0
      1894751.0
      2017
      05/05/2017 03:50:30 PM
      41.867100
      -87.723552
      (41.867099577, -87.723552444)
    

    

      14069
      10928626
      JA243374
      2017-04-28 21:30:00
      039XX W ARTHINGTON ST
      1661
      GAMBLING
      GAME/DICE
      SIDEWALK
      True
      False
      ...
      24.0
      26.0
      19
      1150180.0
      1895743.0
      2017
      05/05/2017 03:50:30 PM
      41.869825
      -87.724118
      (41.869824877, -87.724117657)
    

    

      14070
      10934612
      JA250908
      2017-05-04 18:52:00
      025XX W LITHUANIAN PLAZA CT
      1661
      GAMBLING
      GAME/DICE
      SIDEWALK
      True
      False
      ...
      15.0
      66.0
      19
      1160725.0
      1858818.0
      2017
      05/11/2017 03:49:38 PM
      41.768286
      -87.686424
      (41.768286371, -87.686424382)
    

    

      14071
      10934766
      JA250998
      2017-05-04 20:00:00
      0000X N LECLAIRE AVE
      1661
      GAMBLING
      GAME/DICE
      SIDEWALK
      True
      False
      ...
      28.0
      25.0
      19
      1142385.0
      1899723.0
      2017
      05/11/2017 03:49:38 PM
      41.880895
      -87.752637
      (41.880894745, -87.752636861)
    

    

      14072
      10936764
      JA253441
      2017-05-06 18:34:00
      040XX W CARROLL AVE
      1661
      GAMBLING
      GAME/DICE
      SIDEWALK
      True
      False
      ...
      28.0
      26.0
      19
      1149404.0
      1901929.0
      2017
      05/13/2017 03:48:31 PM
      41.886815
      -87.726806
      (41.886815035, -87.726806109)
    

    

      14073
      10938662
      JA255958
      2017-05-08 19:17:00
      078XX S WESTERN AVE
      1661
      GAMBLING
      GAME/DICE
      CTA BUS STOP
      True
      False
      ...
      18.0
      70.0
      19
      1161741.0
      1852550.0
      2017
      05/15/2017 03:54:29 PM
      41.751065
      -87.682874
      (41.751065032, -87.682873958)
    

    

      14074
      10939630
      JA257255
      2017-05-09 18:58:00
      065XX S GREEN ST
      1661
      GAMBLING
      GAME/DICE
      RESIDENTIAL YARD (FRONT/BACK)
      True
      False
      ...
      20.0
      68.0
      19
      1171764.0
      1861420.0
      2017
      05/16/2017 03:52:21 PM
      41.775192
      -87.645885
      (41.775191608, -87.645884924)
    

    

      14075
      10943009
      JA261232
      2017-05-12 18:00:00
      039XX W GRENSHAW ST
      1661
      GAMBLING
      GAME/DICE
      SIDEWALK
      True
      False
      ...
      24.0
      29.0
      19
      1150335.0
      1894751.0
      2017
      05/19/2017 03:52:48 PM
      41.867100
      -87.723574
      (41.867099694, -87.723574471)
    

    

      14076
      10943842
      JA262457
      2017-05-13 17:15:00
      085XX S CARPENTER ST
      1661
      GAMBLING
      GAME/DICE
      SIDEWALK
      True
      False
      ...
      21.0
      71.0
      19
      1170808.0
      1848158.0
      2017
      05/20/2017 03:49:22 PM
      41.738820
      -87.649776
      (41.738819886, -87.649775783)
    

    

      14077
      10943997
      JA262561
      2017-05-13 18:50:00
      025XX W LITHUANIAN PLAZA CT
      1661
      GAMBLING
      GAME/DICE
      SIDEWALK
      True
      False
      ...
      15.0
      66.0
      19
      1160712.0
      1858818.0
      2017
      05/20/2017 03:49:22 PM
      41.768287
      -87.686472
      (41.768286639, -87.686472033)
    

    

      14078
      10945609
      JA264812
      2017-05-15 15:44:00
      007XX N CHRISTIANA AVE
      1661
      GAMBLING
      GAME/DICE
      SIDEWALK
      True
      False
      ...
      27.0
      23.0
      19
      1153910.0
      1904742.0
      2017
      05/22/2017 03:58:12 PM
      41.894446
      -87.710184
      (41.894445595, -87.710183758)
    

    

      14079
      10946869
      JA266188
      2017-05-16 14:30:00
      008XX N RIDGEWAY AVE
      1661
      GAMBLING
      GAME/DICE
      SIDEWALK
      True
      False
      ...
      27.0
      23.0
      19
      1151236.0
      1905273.0
      2017
      05/23/2017 03:50:10 PM
      41.895956
      -87.719991
      (41.895955585, -87.719990688)
    

    

      14080
      10948365
      JA267783
      2017-05-17 15:44:00
      039XX W GRENSHAW ST
      1661
      GAMBLING
      GAME/DICE
      SIDEWALK
      True
      False
      ...
      24.0
      29.0
      19
      1150355.0
      1894752.0
      2017
      05/24/2017 03:52:36 PM
      41.867102
      -87.723501
      (41.867102048, -87.723501022)
    

    

      14081
      10950176
      JA269765
      2017-05-18 18:30:00
      004XX N AVERS AVE
      1661
      GAMBLING
      GAME/DICE
      SIDEWALK
      True
      False
      ...
      27.0
      23.0
      19
      1150643.0
      1902782.0
      2017
      05/25/2017 03:51:51 PM
      41.889132
      -87.722234
      (41.889131636, -87.722233828)
    

    

      14082
      10950364
      JA270023
      2017-05-19 01:06:00
      039XX W VAN BUREN ST
      1661
      GAMBLING
      GAME/DICE
      SIDEWALK
      True
      False
      ...
      24.0
      26.0
      19
      1150266.0
      1897736.0
      2017
      05/26/2017 03:49:56 PM
      41.875292
      -87.723750
      (41.87529222, -87.72374996)
    

    

      14083
      10951481
      JA271139
      2017-05-19 18:35:00
      015XX S CHRISTIANA AVE
      1661
      GAMBLING
      GAME/DICE
      SIDEWALK
      True
      False
      ...
      24.0
      29.0
      19
      1154285.0
      1892181.0
      2017
      05/26/2017 03:49:56 PM
      41.859969
      -87.709142
      (41.859969423, -87.709141993)
    

    

      14084
      10952285
      JA272277
      2017-05-20 18:01:00
      075XX S STEWART AVE
      1661
      GAMBLING
      GAME/DICE
      SIDEWALK
      True
      False
      ...
      17.0
      69.0
      19
      1174930.0
      1855016.0
      2017
      05/27/2017 03:52:34 PM
      41.757548
      -87.634470
      (41.757548256, -87.634469566)
    

    

      14085
      10954410
      JA275023
      2017-05-22 19:30:00
      0000X N LECLAIRE AVE
      1661
      GAMBLING
      GAME/DICE
      SIDEWALK
      True
      False
      ...
      28.0
      25.0
      19
      1142385.0
      1899733.0
      2017
      05/29/2017 03:53:27 PM
      41.880922
      -87.752637
      (41.880922186, -87.752636613)
    

    

      14086
      10958861
      JA280223
      2017-05-26 16:05:00
      057XX S RACINE AVE
      1661
      GAMBLING
      GAME/DICE
      PARK PROPERTY
      True
      False
      ...
      16.0
      68.0
      19
      1169300.0
      1866734.0
      2017
      06/02/2017 03:54:37 PM
      41.789828
      -87.654764
      (41.789827555, -87.654763892)
    

    

      14087
      10960639
      JA282703
      2017-05-28 15:22:00
      012XX W 73RD PL
      1661
      GAMBLING
      GAME/DICE
      SIDEWALK
      True
      False
      ...
      17.0
      67.0
      19
      1169094.0
      1856038.0
      2017
      06/04/2017 03:51:15 PM
      41.760481
      -87.655828
      (41.760480866, -87.655828204)
    

    

      14088
      10960811
      JA282964
      2017-05-28 19:37:00
      039XX W JACKSON BLVD
      1661
      GAMBLING
      GAME/DICE
      SIDEWALK
      True
      False
      ...
      28.0
      26.0
      19
      1150169.0
      1898397.0
      2017
      06/04/2017 03:51:15 PM
      41.877108
      -87.724089
      (41.877107968, -87.724088882)
    

    

      14089
      10960884
      JA283059
      2017-05-28 21:26:00
      064XX S TALMAN AVE
      1661
      GAMBLING
      GAME/DICE
      SIDEWALK
      True
      False
      ...
      15.0
      66.0
      19
      1159818.0
      1861804.0
      2017
      06/04/2017 03:51:15 PM
      41.776499
      -87.689667
      (41.776499057, -87.689667076)
    

  



12875 rows × 22 columns



















In [ ]:



    






    











In [ ]:



    






    











In [ ]:



    






    











In [ ]:

Content source: jeffmkw/DAT210x-Lab

Similar notebooks:

notebook.community | gallery | about