In [1]:
import pandas as pd
In [5]:
# LAPD Crime and Collission Data
df = pd.read_csv("https://data.lacity.org/api/views/eta5-h8qx/rows.csv?accessType=DOWNLOAD")
In [7]:
df.dtypes
Out[7]:
Date Rptd object
DR NO int64
DATE OCC object
TIME OCC int64
AREA int64
AREA NAME object
RD int64
Crm Cd int64
Crm Cd Desc object
Status object
Status Desc object
LOCATION object
Cross Street object
Location 1 object
dtype: object
In [17]:
df[df["Crm Cd Desc"] == "ROBBERY"]
Out[17]:
Date Rptd
DR NO
DATE OCC
TIME OCC
AREA
AREA NAME
RD
Crm Cd
Crm Cd Desc
Status
Status Desc
LOCATION
Cross Street
Location 1
9
08/23/2014
140119696
08/23/2014
1120
1
Central
143
210
ROBBERY
IC
Invest Cont
400 S BROADWAY
NaN
(34.0495, -118.2494)
15
08/23/2014
140119710
08/23/2014
1800
1
Central
166
210
ROBBERY
IC
Invest Cont
600 S SAN PEDRO ST
NaN
(34.0423, -118.2452)
19
08/23/2014
140119715
08/23/2014
2015
1
Central
153
210
ROBBERY
AA
Adult Arrest
200 W 6TH ST
NaN
(34.046, -118.2509)
38
08/23/2014
140216326
08/23/2014
315
2
Rampart
245
210
ROBBERY
IC
Invest Cont
6TH ST
PARK VIEW AV
(34.062, -118.2804)
48
08/24/2014
140216351
08/23/2014
2200
2
Rampart
279
210
ROBBERY
IC
Invest Cont
CONNECTICUT ST
BLAINE ST
(34.0471, -118.2725)
65
08/23/2014
140301000
08/23/2014
225
3
Southwest
397
210
ROBBERY
AA
Adult Arrest
S VERMONT AV
W 42ND ST
(34.0042, -118.2916)
73
08/23/2014
140318180
08/23/2014
1400
3
Southwest
315
210
ROBBERY
AA
Adult Arrest
2300 W 23RD ST
NaN
(34.036, -118.3148)
155
08/23/2014
140617873
08/23/2014
1115
6
Hollywood
646
210
ROBBERY
AA
Adult Arrest
HOLLYWOOD BL
HIGHLAND AV
(34.1016, -118.3381)
278
08/23/2014
141218951
08/23/2014
545
12
77th Street
1253
210
ROBBERY
IC
Invest Cont
7700 S WESTERN AV
NaN
(33.97, -118.309)
279
08/23/2014
141218952
08/23/2014
430
12
77th Street
1263
210
ROBBERY
IC
Invest Cont
83RD ST
DENKER AV
(33.9637, -118.3167)
281
08/23/2014
141218959
08/23/2014
350
12
77th Street
1208
210
ROBBERY
IC
Invest Cont
FIGUEROA ST
47TH ST
(33.9961, -118.2827)
285
08/24/2014
141218969
08/23/2014
345
12
77th Street
1205
210
ROBBERY
IC
Invest Cont
SAINT ANDREWS
46TH ST
(34.0019, -118.3113)
292
08/25/2014
141219011
08/23/2014
820
12
77th Street
1273
210
ROBBERY
JA
Juv Arrest
1700 W MANCHESTER AV
NaN
(33.96, -118.3068)
293
08/25/2014
141219013
08/23/2014
1930
12
77th Street
1233
210
ROBBERY
IC
Invest Cont
1800 W SLAUSON AV
NaN
(33.9892, -118.3089)
294
08/23/2014
141219025
08/23/2014
1100
12
77th Street
1211
210
ROBBERY
IC
Invest Cont
3400 W SLAUSON AV
NaN
(33.989, -118.3308)
306
08/23/2014
141316884
08/23/2014
10
13
Newton
1347
210
ROBBERY
IC
Invest Cont
42ND ST
ASCOT AV
(34.0066, -118.2454)
311
08/23/2014
141316891
08/23/2014
1235
13
Newton
1303
210
ROBBERY
IC
Invest Cont
10TH ST
CROCKER ST
(34.0354, -118.251)
324
08/24/2014
141316911
08/23/2014
2115
13
Newton
1303
210
ROBBERY
IC
Invest Cont
OLYMPIC
WALL ST
(34.0376, -118.2531)
327
08/23/2014
141316919
08/23/2014
1710
13
Newton
1351
210
ROBBERY
IC
Invest Cont
4000 S MAIN ST
NaN
(34.0111, -118.274)
338
08/23/2014
141421697
08/23/2014
430
14
Pacific
1414
210
ROBBERY
IC
Invest Cont
LINCOLN
ROSE
(34.0014, -118.4679)
345
08/23/2014
141421747
08/23/2014
1645
14
Pacific
1434
210
ROBBERY
AA
Adult Arrest
VENICE
CENTINELA
(34.0033, -118.4345)
424
08/23/2014
141816001
08/23/2014
400
18
Southeast
1806
210
ROBBERY
IC
Invest Cont
88TH
AVALON
(33.9565, -118.2651)
444
08/23/2014
141816044
08/23/2014
2230
18
Southeast
1824
210
ROBBERY
IC
Invest Cont
900 E COLDEN AV
NaN
(33.9493, -118.2586)
445
08/23/2014
141816045
08/23/2014
1730
18
Southeast
1863
210
ROBBERY
IC
Invest Cont
400 E IMPERIAL HY
NaN
(33.9311, -118.2664)
460
08/23/2014
141901026
08/23/2014
1430
19
Mission
1985
210
ROBBERY
IC
Invest Cont
8400 VAN NUYS BL
NaN
(34.2232, -118.4488)
464
08/23/2014
141917663
08/23/2014
1005
19
Mission
1958
210
ROBBERY
IC
Invest Cont
9700 WOODMAN AV
NaN
(34.2467, -118.4479)
472
03/03/2014
140706302
02/28/2014
130
7
Wilshire
787
210
ROBBERY
IC
Invest Cont
CRENSHAW BL
WASHINGTON BL
(34.0357, -118.3334)
476
03/06/2014
140706419
02/28/2014
1200
7
Wilshire
758
210
ROBBERY
IC
Invest Cont
1100 S WINDSOR BL
NaN
(34.054, -118.3263)
768
02/28/2014
141706591
02/28/2014
1759
17
Devonshire
1701
210
ROBBERY
AA
Adult Arrest
19800 RINALDI ST
NaN
(34.2751, -118.5652)
896
02/28/2014
142006697
02/28/2014
1430
20
Olympic
2015
210
ROBBERY
IC
Invest Cont
200 N CATALINA ST
NaN
(34.0745, -118.2954)
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
240715
09/08/2014
141516828
09/08/2014
2215
15
N Hollywood
1585
210
ROBBERY
AA
Adult Arrest
10900 VENTURA BL
NaN
(34.1394, -118.3675)
240738
09/08/2014
141601369
09/08/2014
2320
16
Foothill
1601
210
ROBBERY
IC
Invest Cont
11500 GLENOAKS BL
NaN
(34.2851, -118.4238)
240802
09/08/2014
141816814
09/07/2014
2000
18
Southeast
1862
210
ROBBERY
IC
Invest Cont
IMPERIAL
MAIN
(33.931, -118.2739)
240814
09/08/2014
141901077
09/07/2014
2320
19
Mission
1971
210
ROBBERY
AA
Adult Arrest
15400 RAYEN ST
NaN
(34.2319, -118.4676)
240854
09/08/2014
142015922
09/08/2014
1
20
Olympic
2088
210
ROBBERY
IC
Invest Cont
1700 S VERMONT AV
NaN
(34.0427, -118.2916)
240861
09/08/2014
142015966
09/08/2014
1635
20
Olympic
2024
210
ROBBERY
IC
Invest Cont
3700 WILSHIRE BL
NaN
(34.0617, -118.3066)
240880
09/08/2014
142016000
09/08/2014
2130
20
Olympic
2044
210
ROBBERY
IC
Invest Cont
8TH ST
ARDMORE AV
(34.0577, -118.3037)
240911
09/07/2014
140120837
09/07/2014
1015
1
Central
166
210
ROBBERY
IC
Invest Cont
7TH
SAN JULIAN
(34.0412, -118.2474)
240924
09/07/2014
140217067
09/07/2014
135
2
Rampart
221
210
ROBBERY
IC
Invest Cont
300 N NORMANDIE AV
NaN
(34.0763, -118.3004)
240970
09/07/2014
140413867
09/07/2014
1142
4
Hollenbeck
465
210
ROBBERY
IC
Invest Cont
3100 E 4TH ST
NaN
(34.0359, -118.2011)
241028
09/07/2014
140813255
09/07/2014
130
8
West LA
807
210
ROBBERY
AA
Adult Arrest
2900 BEVERLY GLEN CI
NaN
(34.1268, -118.4444)
241096
09/07/2014
141220043
09/07/2014
1200
12
77th Street
1233
210
ROBBERY
IC
Invest Cont
1700 W 59TH PL
NaN
(33.9867, -118.3068)
241101
09/07/2014
141220051
09/07/2014
1840
12
77th Street
1235
210
ROBBERY
JA
Juv Arrest
62ND ST
NORMANDIE AV
(33.9833, -118.3035)
241113
09/07/2014
141317652
09/07/2014
445
13
Newton
1367
210
ROBBERY
IC
Invest Cont
VERNON AV
LONG BEACH
(34.0039, -118.2472)
241126
09/07/2014
141317684
09/07/2014
1420
13
Newton
1394
210
ROBBERY
IC
Invest Cont
FLORENCE AV
SAN PEDRO
(33.9747, -118.2717)
241175
09/07/2014
141613309
09/07/2014
105
16
Foothill
1622
210
ROBBERY
IC
Invest Cont
11200 SAN FERNANDO RD
NaN
(34.2732, -118.4296)
241217
09/07/2014
141816746
09/07/2014
1415
18
Southeast
1821
210
ROBBERY
IC
Invest Cont
CENTURY
VERMONT
(33.9455, -118.2916)
241223
09/07/2014
141816759
09/07/2014
1610
18
Southeast
1806
210
ROBBERY
IC
Invest Cont
91ST ST
AVALON
(33.9538, -118.2641)
241515
09/03/2014
141817176
09/03/2014
930
18
Southeast
1837
210
ROBBERY
IC
Invest Cont
1600 E 104TH ST
NaN
(33.9415, -118.2462)
241658
03/24/2014
141007431
12/08/2013
200
10
West Valley
1003
210
ROBBERY
IC
Invest Cont
YOLANDA AV
STRATHERN
(34.2089, -118.5405)
242141
08/21/2014
141115413
08/21/1941
2345
11
Northeast
1141
210
ROBBERY
IC
Invest Cont
1900 N ALEXANDRIA AV
NaN
(34.1054, -118.2984)
242234
08/19/2014
140513641
05/31/2011
1630
5
Harbor
515
210
ROBBERY
IC
Invest Cont
1600 MARINE AV
NaN
(33.7953, -118.265)
242270
08/19/2014
141613662
08/18/2014
1800
16
Foothill
1641
210
ROBBERY
IC
Invest Cont
PIERCE ST
REMICK AV
(34.2543, -118.431)
242353
08/18/2014
142114448
10/10/2012
1800
21
Topanga
2134
210
ROBBERY
JO
Juv Other
22200 SHERMAN WY
NaN
(34.201, -118.6103)
242603
08/12/2014
140317465
04/12/2013
1200
3
Southwest
315
210
ROBBERY
IC
Invest Cont
2600 S MANHATTAN PL
NaN
(34.0327, -118.3101)
242661
03/03/2014
141507076
03/03/2004
420
15
N Hollywood
1555
210
ROBBERY
AA
Adult Arrest
11300 RIVERSIDE DR
NaN
(34.1556, -118.3771)
242682
08/11/2014
141218204
08/09/2011
1230
12
77th Street
1243
210
ROBBERY
IC
Invest Cont
1700 W GAGE AV
NaN
(33.9824, -118.3068)
242870
02/26/2014
140706057
02/25/2013
1400
7
Wilshire
723
210
ROBBERY
AA
Adult Arrest
8200 BLACKBURN AV
NaN
(34.0715, -118.3678)
243439
02/15/2014
141206804
02/15/2013
940
12
77th Street
1203
210
ROBBERY
IC
Invest Cont
46TH
NORMANDIE
(34.0019, -118.3002)
243606
07/24/2014
141320117
07/18/2014
2230
13
Newton
1395
210
ROBBERY
IC
Invest Cont
FLORENCE
AVALON BL
(33.9748, -118.2652)
6958 rows × 14 columns
In [21]:
CrimeCounts = {}
for i in df["Crm Cd Desc"].unique():
CrimeCounts[i] = len(df[df["Crm Cd Desc"] == i])
In [22]:
CrimeCounts
Out[22]:
{'ARSON': 301,
'ASSAULT WITH DEADLY WEAPON ON POLICE OFFICER': 150,
'ASSAULT WITH DEADLY WEAPON, AGGRAVATED ASSAULT': 8341,
'ATTEMPTED ROBBERY': 1007,
'BATTERY - SIMPLE ASSAULT': 18487,
'BATTERY ON A FIREFIGHTER': 38,
'BATTERY POLICE': 452,
'BATTERY WITH SEXUAL CONTACT': 1111,
'BEASTIALITY, CRIME AGAINST NATURE SEXUAL ASSLT WITH ANIM': 3,
'BIGAMY': 3,
'BIKE - ATTEMPTED STOLEN': 1,
'BIKE - STOLEN': 1146,
'BOAT - STOLEN': 36,
'BOMB SCARE': 93,
'BRANDISH WEAPON': 741,
'BRIBERY': 1,
'BUNCO, ATTEMPT': 38,
'BUNCO, GRAND THEFT': 823,
'BUNCO, PETTY THEFT': 545,
'BURGLARY': 13913,
'BURGLARY FROM VEHICLE': 13148,
'BURGLARY FROM VEHICLE, ATTEMPTED': 260,
'BURGLARY, ATTEMPTED': 1168,
'CHILD ABANDONMENT': 8,
'CHILD ABUSE (PHYSICAL) - AGGRAVATED ASSAULT': 145,
'CHILD ABUSE (PHYSICAL) - SIMPLE ASSAULT': 812,
'CHILD ENDANGERMENT/NEG.': 566,
'CHILD NEGLECT (SEE 300 W.I.C.)': 552,
'CHILD STEALING': 123,
'CHILD, CRIME AGAINST': 1091,
'CONSPIRACY': 5,
'CONTEMPT OF COURT': 15,
'CONTRIBUTING': 14,
'COUNTERFEIT': 81,
'CREDIT CARDS, FRAUD USE ($950 & UNDER': 14,
'CREDIT CARDS, FRAUD USE ($950.01 & OVER)': 73,
'CRIMINAL HOMICIDE': 260,
'CRIMINAL THREATS - NO WEAPON DISPLAYED': 5827,
'CRUELTY TO ANIMALS': 142,
'DEFRAUDING INNKEEPER/THEFT OF SERVICES, $400 & UNDER': 222,
'DEFRAUDING INNKEEPER/THEFT OF SERVICES, OVER $400': 28,
'DISCHARGE FIREARMS/SHOTS FIRED': 366,
'DISHONEST EMPLOYEE - GRAND THEFT': 9,
'DISHONEST EMPLOYEE - PETTY THEFT': 9,
'DISHONEST EMPLOYEE ATTEMPTED THEFT': 1,
'DISRUPT SCHOOL': 2,
'DISTURBING THE PEACE': 316,
'DOCUMENT FORGERY / STOLEN FELONY': 2369,
'DOCUMENT WORTHLESS ($200.01 & OVER)': 62,
'DRIVING WITHOUT OWNER CONSENT (DWOC)': 29,
'DRUGS, TO A MINOR': 5,
'EMBEZZLEMENT, GRAND THEFT ($950.01 & OVER)': 925,
'EMBEZZLEMENT, PETTY THEFT ($950 & UNDER)': 73,
'EXTORTION': 150,
'FAILURE TO DISPERSE': 5,
'FAILURE TO YIELD': 13,
'FALSE IMPRISONMENT': 105,
'FALSE POLICE REPORT': 49,
'GRAND THEFT / AUTO REPAIR': 3,
'GRAND THEFT / INSURANCE FRAUD': 1,
'ILLEGAL DUMPING': 56,
'INDECENT EXPOSURE': 287,
'KIDNAPPING': 208,
'KIDNAPPING - GRAND ATTEMPT': 75,
'LETTERS, LEWD': 1958,
'LEWD CONDUCT': 104,
'LYNCHING': 5,
'LYNCHING - ATTEMPTED': 3,
'ORAL COPULATION': 199,
'OTHER ASSAULT': 132,
'OTHER MISCELLANEOUS CRIME': 2156,
'PANDERING': 17,
'PEEPING TOM': 127,
'PETTY THEFT - AUTO REPAIR': 2,
'PICKPOCKET': 45,
'PIMPING': 66,
'PROPERTY MISSING RVD VEH - GRAND THEFT ($950.01 & OVER)': 14,
'PROPERTY MISSING RVD VEH - PETTY ($950 & UNDER)': 11,
'PROWLER': 90,
'PURSE SNATCHING': 101,
'PURSE SNATCHING - ATTEMPT': 1,
'RAPE, ATTEMPTED': 111,
'RAPE, FORCIBLE': 1021,
'RECKLESS DRIVING': 13,
'REPLICA FIREARMS(SALE,DISPLAY,MANUFACTURE OR DISTRIBUTE)': 1,
'RESISTING ARREST': 374,
'ROBBERY': 6958,
'SEX OFFENDER REGISTRANT INCIDENT': 77,
'SEX, UNLAWFUL': 481,
'SEXUAL PENTRATION WITH A FOREIGN OBJECT': 208,
'SHOPLIFTING - ATTEMPT': 13,
'SHOPLIFTING - PETTY THEFT ($950 & UNDER)': 4581,
'SHOPLIFTING-GRAND THEFT ($950.01 & OVER)': 277,
'SHOTS FIRED AT INHABITED DWELLING': 247,
'SHOTS FIRED AT MOVING VEHICLE, TRAIN OR AIRCRAFT': 9,
'SODOMY/SEXUAL CONTACT B/W PENIS OF ONE PERS TO ANUS OTH': 154,
'SPOUSAL (COHAB) ABUSE - AGGRAVATED ASSAULT': 966,
'SPOUSAL(COHAB) ABUSE - SIMPLE ASSAULT': 11601,
'STALKING': 202,
'TELEPHONE PROPERTY - DAMAGE': 3,
'THEFT FROM MOTOR VEHICLE - ATTEMPT': 105,
'THEFT FROM MOTOR VEHICLE - GRAND ($400 AND OVER)': 2997,
'THEFT FROM MOTOR VEHICLE - PETTY ($950.01 & OVER)': 7808,
'THEFT FROM PERSON - ATTEMPT': 21,
'THEFT OF IDENTITY': 13521,
'THEFT PLAIN - ATTEMPT': 227,
'THEFT PLAIN - PETTY ($950 & UNDER)': 15840,
'THEFT, COIN MACHINE - ATTEMPT': 1,
'THEFT, COIN MACHINE - GRAND ($950.01 & OVER)': 2,
'THEFT, COIN MACHINE - PETTY ($950 & UNDER)': 7,
'THEFT, PERSON': 1218,
'THEFT-GRAND ($950.01 & OVER)EXCPT,GUNS,FOWL,LIVESTK,PROD': 6556,
'THREATENING PHONE CALLS/LETTERS': 227,
'THREATS, VERBAL/TERRORIST': 13,
'THROWING OBJECT AT MOVING VEHICLE': 112,
'TILL TAP - GRAND THEFT ($950.01 & OVER)': 1,
'TILL TAP - PETTY ($950 & UNDER)': 6,
'TRAFFIC DR #': 46983,
'TRESPASSING': 1658,
'UNAUTHORIZED COMPUTER ACCESS': 119,
'VANDALISM - FELONY ($400 & OVER, ALL CHURCH VANDALISMS)': 9646,
'VANDALISM - MISDEAMEANOR ($399 OR UNDER)': 9113,
'VEHICLE - ATTEMPT STOLEN': 258,
'VEHICLE - STOLEN': 13750,
'VIOLATION OF COURT ORDER': 2207,
'VIOLATION OF RESTRAINING ORDER': 1988,
'VIOLATION OF TEMPORARY RESTRAINING ORDER': 118,
'WEAPONS POSSESSION/BOMBING': 18}
In [25]:
CC = pd.Series(CrimeCounts)
In [27]:
%matplotlib inline
Out[27]:
<matplotlib.axes._subplots.AxesSubplot at 0x7f351cee7410>
In [37]:
CC.sort()
In [40]:
CC.head(50).plot(kind='barh',figsize=(6,20))
Out[40]:
<matplotlib.axes._subplots.AxesSubplot at 0x7f3514d9f190>
Content source: TeachingDataScience/python-data-080815
Similar notebooks: