From The Guardian's http://www.theguardian.com/us-news/ng-interactive/2015/jun/01/the-counted-police-killings-us-database "The US government has no comprehensive record of the number of people killed by law enforcement. This lack of basic data has been glaring amid the protests, riots and worldwide debate set in motion by the fatal police shooting of Michael Brown, an unarmed 18-year-old, in Ferguson, Missouri, in August 2014."
In [2]:
!pip install pandas
Requirement already satisfied (use --upgrade to upgrade): pandas in /Users/mercybenzaquen/.virtualenvs/Homework8/lib/python3.5/site-packages
Requirement already satisfied (use --upgrade to upgrade): numpy>=1.7.0 in /Users/mercybenzaquen/.virtualenvs/Homework8/lib/python3.5/site-packages (from pandas)
Requirement already satisfied (use --upgrade to upgrade): python-dateutil>=2 in /Users/mercybenzaquen/.virtualenvs/Homework8/lib/python3.5/site-packages (from pandas)
Requirement already satisfied (use --upgrade to upgrade): pytz>=2011k in /Users/mercybenzaquen/.virtualenvs/Homework8/lib/python3.5/site-packages (from pandas)
Requirement already satisfied (use --upgrade to upgrade): six>=1.5 in /Users/mercybenzaquen/.virtualenvs/Homework8/lib/python3.5/site-packages (from python-dateutil>=2->pandas)
In [3]:
!pip install matplotlib
Requirement already satisfied (use --upgrade to upgrade): matplotlib in /Users/mercybenzaquen/.virtualenvs/Homework8/lib/python3.5/site-packages
Requirement already satisfied (use --upgrade to upgrade): pyparsing!=2.0.0,!=2.0.4,>=1.5.6 in /Users/mercybenzaquen/.virtualenvs/Homework8/lib/python3.5/site-packages (from matplotlib)
Requirement already satisfied (use --upgrade to upgrade): numpy>=1.6 in /Users/mercybenzaquen/.virtualenvs/Homework8/lib/python3.5/site-packages (from matplotlib)
Requirement already satisfied (use --upgrade to upgrade): python-dateutil in /Users/mercybenzaquen/.virtualenvs/Homework8/lib/python3.5/site-packages (from matplotlib)
Requirement already satisfied (use --upgrade to upgrade): pytz in /Users/mercybenzaquen/.virtualenvs/Homework8/lib/python3.5/site-packages (from matplotlib)
Requirement already satisfied (use --upgrade to upgrade): cycler in /Users/mercybenzaquen/.virtualenvs/Homework8/lib/python3.5/site-packages (from matplotlib)
Requirement already satisfied (use --upgrade to upgrade): six>=1.5 in /Users/mercybenzaquen/.virtualenvs/Homework8/lib/python3.5/site-packages (from python-dateutil->matplotlib)
In [4]:
import pandas as pd
import matplotlib.pyplot as plt
%matplotlib inline
/Users/mercybenzaquen/.virtualenvs/Homework8/lib/python3.5/site-packages/matplotlib/__init__.py:1035: UserWarning: Duplicate key in file "/Users/mercybenzaquen/.matplotlib/matplotlibrc", line #2
(fname, cnt))
In [5]:
df = pd.read_csv('the-counted-2015.csv', encoding = "ISO-8859-1")
In [6]:
df.head()
Out[6]:
uid
name
age
gender
raceethnicity
month
day
year
streetaddress
city
state
classification
lawenforcementagency
armed
0
2
Matthew Ajibade
22
Male
Black
January
1
2015
1050 Carl Griffin Dr
Savannah
GA
Death in custody
Chatham County Sheriff's Office
No
1
4
Lewis Lembke
47
Male
White
January
2
2015
4505 SW Masters Loop
Aloha
OR
Gunshot
Washington County Sheriff's Office
Firearm
2
7
Tim Elliott
53
Male
Asian/Pacific Islander
January
2
2015
600 E Island Lake Dr
Shelton
WA
Gunshot
Mason County Sheriff's Office
Firearm
3
5
Michael Kocher Jr
19
Male
White
January
3
2015
2600 Kaumualii Hwy
Kaumakani
HI
Struck by vehicle
Kauai Police Department
No
4
6
John Quintero
23
Male
Hispanic/Latino
January
3
2015
500 North Oliver Ave
Wichita
KS
Gunshot
Wichita Police Department
No
In [7]:
df.tail(1) #there is one line per incident, so tail will give us the last incident.
Out[7]:
uid
name
age
gender
raceethnicity
month
day
year
streetaddress
city
state
classification
lawenforcementagency
armed
1145
1170
James McBride
74
Male
Black
September
29
2015
110 Irving St NW
Washington
DC
Death in custody
Special police, Washington DC
No
In [8]:
df.sort_values('age', ascending=False).head(10)
Out[8]:
uid
name
age
gender
raceethnicity
month
day
year
streetaddress
city
state
classification
lawenforcementagency
armed
147
146
Alejandro Salazar
Unknown
Male
Hispanic/Latino
February
20
2015
1200 E Airtex Dr
Houston
TX
Gunshot
US Marshals Service, Texas Department of Crimi...
Firearm
88
1051
Robert Edwards
Unknown
Male
Unknown
January
30
2015
6607 S Interstate 35
Austin
TX
Death in custody
Austin Police Department
No
1066
1089
Unknown
Unknown
Male
Unknown
December
10
2015
200 E Stetson Ave
Hemet
CA
Gunshot
Hemet Police Department
Firearm
1072
1097
Unknown
Unknown
Male
Unknown
December
12
2015
698 Kenton St
Aurora
CO
Gunshot
Aurora Police Department
Knife
35
37
Louis Becker
87
Male
White
January
14
2015
New York State Rte 23 and Cairo Junction Rd
Catskill
NY
Struck by vehicle
New York State Police
No
508
504
Raymond Phillips
85
Male
White
June
11
2015
1000 Bear Creek Pike
Columbia
TN
Gunshot
Columbia Police Department
Firearm
326
317
Richard 'Buddy' Weaver
83
Male
White
April
12
2015
Sleepy Hollow Dr and Misty Glen Dr
Newalla
OK
Gunshot
Oklahoma City Police Department
Other
269
273
Douglas Harris
77
Male
Black
March
27
2015
7901 1st Ave S
Birmingham
AL
Gunshot
Birmingham Police Department
Firearm
613
607
Nyal Brown
77
Male
White
July
13
2015
3505 Sullivant Ave
Columbus
OH
Struck by vehicle
Franklin County Sheriff's Office
No
709
712
Robert Quinn
77
Male
Unknown
August
9
2015
101 N Main St
Pittston
PA
Gunshot
Pittston Police Department
Non-lethal firearm
In [9]:
df.sort_values('age', ascending=True).head(5)
Out[9]:
uid
name
age
gender
raceethnicity
month
day
year
streetaddress
city
state
classification
lawenforcementagency
armed
906
915
Jorge Tapia
15
Male
Hispanic/Latino
October
15
2015
SW 137th Ave and SW 280th St
Homestead
FL
Gunshot
Miami-Dade Police Department
Firearm
711
710
Andre Green
15
Male
Black
August
10
2015
3300 N Butler Ave
Indianapolis
IN
Gunshot
Indianapolis Metropolitan Police Department
Vehicle
519
514
Zane Terryn
15
Male
White
June
14
2015
4455 King St
Cocoa
FL
Gunshot
Brevard County Sheriff's Office
Firearm
243
237
Kendre Alston
16
Male
Black
March
19
2015
Mount Olive Cemetery
Jacksonville
FL
Gunshot
Jacksonville Sheriff's Office
Firearm
863
893
Isabella Chinchilla
16
Female
White
September
26
2015
US-27
Carrollton
GA
Struck by vehicle
Georgia State Patrol
No
In [10]:
df['age'].describe() #I could not get the average :s!
#I thought using describe I would get something like this:
#count 18617.000000
#mean 53.314841
#std 10.679143
#min 25.000000
#25% 45.400000
#50% 53.000000
#75% 60.500000
#max 98.100000
#Name: age, dtype: float64
Out[10]:
count 1146
unique 66
top 24
freq 46
Name: age, dtype: object
In [11]:
df['state'].value_counts()
Out[11]:
CA 211
TX 110
FL 71
AZ 44
GA 39
OK 38
OH 37
CO 32
LA 28
NC 26
NY 25
PA 24
WA 23
IL 23
NJ 23
VA 23
MO 22
NM 21
TN 21
SC 21
IN 21
MI 20
NV 19
KY 19
AL 19
MD 17
OR 17
MN 13
WI 12
WV 12
MS 12
KS 11
UT 10
MA 10
NE 9
ID 8
DC 7
WY 6
AR 5
HI 5
AK 5
IA 5
DE 4
MT 4
CT 4
NH 3
ME 2
SD 2
RI 1
VT 1
ND 1
Name: state, dtype: int64
In [12]:
df['city'].value_counts()
Out[12]:
Los Angeles 20
Houston 17
Las Vegas 12
Phoenix 10
Chicago 10
Indianapolis 10
Dallas 9
Miami 9
San Francisco 9
New York 8
Columbus 8
San Antonio 8
San Diego 8
Washington 7
San Jose 7
Bakersfield 7
Denver 7
Oklahoma City 7
Austin 7
Jacksonville 6
Oakland 6
Columbia 6
Kansas City 6
Orlando 5
Fresno 5
Arlington 5
Hemet 5
Cleveland 5
Long Beach 5
Albuquerque 5
..
Sunset 1
Mesquite 1
San Bernadino 1
Muscle Shoals 1
Union 1
Mitchell 1
Goose Creek 1
Randallstown 1
Washington County 1
Tehachapi 1
Old Town 1
Forest Grove 1
Baytown 1
Pride 1
Kahului 1
Roslindale 1
Harmony 1
Northglenn 1
Palmdale 1
West Palm Beach 1
El Monte 1
Terre Haute 1
Fort Gibson 1
St Martinville 1
Evergreen 1
Hartford 1
Findlay 1
Syracuse 1
Levelland 1
Ville Platte 1
Name: city, dtype: int64
In [13]:
los_angeles = df['city'] == 'Los Angeles'
#df['complete_date'] = df['day'], df['year']
df[los_angeles]
#I wanted to add a new column to order the incidents chronologically (month, day, year) but I got an error saying,
#ValueError: Length of values does not match length of index
Out[13]:
uid
name
age
gender
raceethnicity
month
day
year
streetaddress
city
state
classification
lawenforcementagency
armed
11
12
Brian Pickett
26
Male
Black
January
6
2015
1618 E 123rd St
Los Angeles
CA
Taser
Los Angeles County Sheriff's Department
No
52
52
Pablo Meza
24
Male
Hispanic/Latino
January
17
2015
Jesse St and Mateo St
Los Angeles
CA
Gunshot
Los Angeles Police Department
Firearm
115
114
Dean Bucheit
64
Male
White
February
9
2015
13600 Culver Blvd
Los Angeles
CA
Struck by vehicle
Los Angeles Police Department
No
175
174
Charly 'Africa' Keunang
43
Male
Black
March
1
2015
500 San Pedro St
Los Angeles
CA
Gunshot
Los Angeles Police Department
No
214
211
Antonio Perez
32
Male
Hispanic/Latino
March
12
2015
2400 Flower St
Los Angeles
CA
Gunshot
Los Angeles County Sheriff's Department
No
265
263
Victor Terrazas
28
Male
Hispanic/Latino
March
25
2015
10200 S Vermont Ave
Los Angeles
CA
Gunshot
Los Angeles County Sheriff's Department
Firearm
310
305
Roberto Rodriguez
39
Male
Hispanic/Latino
April
8
2015
4th St and Mathews St
Los Angeles
CA
Gunshot
Los Angeles Police Department
Firearm
351
340
Luis Molina Martinez
35
Male
Hispanic/Latino
April
21
2015
3400 Manitou Ave
Los Angeles
CA
Gunshot
Los Angeles Police Department
Knife
398
384
Brendon Glenn
29
Male
Black
May
6
2015
52 Windward Ave
Los Angeles
CA
Gunshot
Los Angeles Police Department
No
577
576
Jason Hendley
29
Male
Black
July
6
2015
13000 Gavina Ave
Los Angeles
CA
Gunshot
Los Angeles Police Department
Knife
595
595
Neil White
38
Male
White
July
9
2015
800 S Sycamore Ave
Los Angeles
CA
Gunshot
Los Angeles Police Department
Other
610
617
Jason Davis
41
Male
White
July
13
2015
671 Rose Ave
Los Angeles
CA
Gunshot
Los Angeles Police Department
Other
716
718
Redel Jones
30
Female
Black
August
12
2015
Marlton Avenue and Santo Tomas Drive
Los Angeles
CA
Gunshot
Los Angeles Police Department
Knife
763
769
Manuel Soriano
29
Male
Hispanic/Latino
August
27
2015
Van Nuys Blvd and Valerio St
Los Angeles
CA
Gunshot
Los Angeles Police Department
Other
824
833
Florencio Chaidez
32
Male
Hispanic/Latino
September
15
2015
Parthenia St and Cedros Ave
Los Angeles
CA
Gunshot
Los Angeles Police Department
Firearm
828
840
Carlos Wilhelm
39
Male
Hispanic/Latino
September
16
2015
4100 Willimet St
Los Angeles
CA
Gunshot
Los Angeles Police Department
Firearm
866
874
Norma Guzman
37
Female
Hispanic/Latino
September
27
2015
2100 S San Pedro St
Los Angeles
CA
Gunshot
Los Angeles Police Department
Knife
878
889
James Byrd
45
Male
White
October
3
2015
Sepulveda Blvd and Victory Blvd
Los Angeles
CA
Gunshot
Los Angeles Police Department
No
921
937
Dion Ramirez
54
Male
Black
October
19
2015
400 W 111th St
Los Angeles
CA
Gunshot
Los Angeles County Sheriff's Department
Vehicle
981
1000
Miguel Cano
34
Male
Hispanic/Latino
November
9
2015
Andasol Ave and Elkwood St
Los Angeles
CA
Gunshot
Los Angeles Police Department
Unknown
In [14]:
df['month'].value_counts()
Out[14]:
July 124
March 114
August 102
April 102
September 96
December 95
January 91
October 90
May 86
November 84
February 83
June 79
Name: month, dtype: int64
In [15]:
df['July'] = df['month'] == 'July'
df['July'].value_counts()
Out[15]:
False 1022
True 124
Name: July, dtype: int64
In [16]:
july_count = df.groupby('month')['day'].value_counts()
pd.DataFrame(july_count)
#I tried to do df.groupby('July')['day'].value_counts() but it did not work.
#Here I am getting the results but I am not able to see July.
Out[16]:
day
month
day
April
21
8
8
7
15
7
2
5
4
5
6
5
22
5
30
5
9
4
12
4
23
4
25
4
28
4
3
3
14
3
16
3
17
3
19
3
26
3
29
3
1
2
10
2
13
2
18
2
24
2
7
1
11
1
20
1
27
1
August
5
6
...
...
...
September
21
7
4
5
5
5
10
5
23
5
1
4
6
4
9
4
13
4
18
4
22
4
24
4
26
4
7
3
15
3
20
3
25
3
27
3
29
3
3
2
8
2
11
2
12
2
14
2
16
2
17
2
28
2
2
1
19
1
30
1
342 rows × 1 columns
In [17]:
df['raceethnicity'].value_counts()
#this results do not align with those in the Guardian's website. ???
Out[17]:
White 582
Black 305
Hispanic/Latino 195
Asian/Pacific Islander 24
Unknown 22
Native American 13
Arab-American 4
Other 1
Name: raceethnicity, dtype: int64
In [18]:
df['gender'].value_counts()
Out[18]:
Male 1092
Female 53
Non-conforming 1
Name: gender, dtype: int64
In [19]:
df['armed'].value_counts()
Out[19]:
Firearm 554
No 229
Knife 154
Other 62
Unknown 54
Non-lethal firearm 45
Vehicle 44
Disputed 4
Name: armed, dtype: int64
In [20]:
df.head(20)
Out[20]:
uid
name
age
gender
raceethnicity
month
day
year
streetaddress
city
state
classification
lawenforcementagency
armed
July
0
2
Matthew Ajibade
22
Male
Black
January
1
2015
1050 Carl Griffin Dr
Savannah
GA
Death in custody
Chatham County Sheriff's Office
No
False
1
4
Lewis Lembke
47
Male
White
January
2
2015
4505 SW Masters Loop
Aloha
OR
Gunshot
Washington County Sheriff's Office
Firearm
False
2
7
Tim Elliott
53
Male
Asian/Pacific Islander
January
2
2015
600 E Island Lake Dr
Shelton
WA
Gunshot
Mason County Sheriff's Office
Firearm
False
3
5
Michael Kocher Jr
19
Male
White
January
3
2015
2600 Kaumualii Hwy
Kaumakani
HI
Struck by vehicle
Kauai Police Department
No
False
4
6
John Quintero
23
Male
Hispanic/Latino
January
3
2015
500 North Oliver Ave
Wichita
KS
Gunshot
Wichita Police Department
No
False
5
8
Matthew Hoffman
32
Male
White
January
4
2015
630 Valencia St
San Francisco
CA
Gunshot
San Francisco Police Department
Non-lethal firearm
False
6
91
Kenneth Brown
18
Male
White
January
4
2015
NaN
Guthrie
OK
Gunshot
Oklahoma State Police
Firearm
False
7
9
Kenneth Buck
22
Male
Hispanic/Latino
January
5
2015
E Knox Rd and N Exeter St
Chandler
AZ
Gunshot
Chandler Police Department
Firearm
False
8
10
Michael Rodriguez
39
Male
Hispanic/Latino
January
5
2015
818 31st St
Evans
CO
Gunshot
Evans Police Department
Other
False
9
1010
Frank Smart
39
Male
Black
January
5
2015
950 Second Ave
Pittsburgh
PA
Death in custody
Allegheny County Bureau of Corrections
No
False
10
11
Patrick Wetter
25
Male
White
January
6
2015
800 Howard St
Stockton
CA
Gunshot
Stockton Police Department
Knife
False
11
12
Brian Pickett
26
Male
Black
January
6
2015
1618 E 123rd St
Los Angeles
CA
Taser
Los Angeles County Sheriff's Department
No
False
12
13
Autumn Steele
34
Female
White
January
6
2015
104 N Garfield Ave
Burlington
IA
Gunshot
Burlington Police Department
No
False
13
14
Brock Nichols
35
Male
White
January
6
2015
2388 E Kansas Hwy 4
Assaria
KS
Gunshot
Saline County Sheriff's Office
Firearm
False
14
15
Leslie Sapp III
47
Male
Black
January
6
2015
Redlyn St
Pittsburgh
PA
Gunshot
US Marshals Service, Pennsylvania State Police...
Non-lethal firearm
False
15
16
Nicholas Brickman
30
Male
White
January
7
2015
SE 4th St and Scott Ave
Des Moines
IA
Gunshot
Des Moines Police Department
Firearm
False
16
17
Joseph Caffarello
31
Male
White
January
7
2015
6300 Scott St
Rosemont
IL
Gunshot
Rosemont Police Department
Vehicle
False
17
20
Andre Murphy Sr
42
Male
Black
January
7
2015
1223 Omaha Ave
Norfolk
NE
Death in custody
Norfolk Police Division
No
False
18
422
Hashim Abdul-Rasheed
41
Male
Black
January
7
2015
4600 International Gateway
Columbus
OH
Gunshot
Columbus Police Department
Knife
False
19
18
Ronald Sneed
32
Male
Black
January
7
2015
310 Yaupon St
Freeport
TX
Gunshot
Freeport Police Department
Firearm
False
In [21]:
df['lawenforcementagency'].value_counts()
Out[21]:
Los Angeles Police Department 23
Los Angeles County Sheriff's Department 15
Houston Police Department 11
Chicago Police Department 10
New York Police Department 10
Indianapolis Metropolitan Police Department 9
Las Vegas Metropolitan Police Department 9
San Francisco Police Department 8
Oklahoma City Police Department 8
Phoenix Police Department 8
Miami-Dade Police Department 7
Dallas Police Department 7
San Diego Police Department 7
Austin Police Department 7
Riverside County Sheriff's Department 7
San Jose Police Department 6
Jacksonville Sheriff's Office 6
Pennsylvania State Police 6
Bakersfield Police Department 6
San Antonio Police Department 5
Fresno Police Department 5
Aurora Police Department 5
Baltimore County Police Department 5
Washington County Sheriff's Office 5
Unknown 5
Harris County Sheriff's Office 5
Fort Worth Police Department 5
Long Beach Police Department 5
Oakland Police Department 5
Mesa Police Department 4
..
Conecuh County Sheriff's Office, Alabama Department of Public Safety 1
Orange County Sheriff's Department 1
Los Angeles County SheriffÛªs Department, Baldwin Park Police Department 1
Franklin Parish Sheriff's Office 1
Delano Police Department 1
Contra Costa Sheriff's Office 1
Elizabethtown Police Department 1
Vermont State Police, Drug Enforcement Administration 1
Floyd County Sheriff's Office 1
Farmersville Police Department 1
Dekalb County Sheriff's Department, Missouri State Highway Patrol 1
Nocona Police Department 1
Fountain Police Department 1
Seaside Police Department 1
Haverhill Police Department 1
St Tammany Parish Sheriff's Office 1
Alton Police Department 1
Maricopa Police Department 1
Kansas City Police Department, US Marshals 1
Metropolis Police Department 1
Freeport Police Department 1
Marana Police Department 1
Las Vegas Police Department 1
Winston Salem Police Department 1
San Bernardino County Sheriff's Office 1
Summit County Sheriff's Office 1
Tulalip Tribal Police Department, Snohomish County Sheriff's Office 1
Ca̱on City Police Department 1
Grand Junction Police Department 1
Green County Sheriff's Department 1
Name: lawenforcementagency, dtype: int64
In [22]:
df['classification'].value_counts()
Out[22]:
Gunshot 1019
Taser 49
Death in custody 43
Struck by vehicle 34
Other 1
Name: classification, dtype: int64
In [23]:
male = df['gender'] == 'Male'
latino = df['raceethnicity'] == 'Hispanic/Latino'
knife = df['armed'] == 'Knife'
df[male&latino&knife]
#How can I count them now? It tells me it is not possible?
Out[23]:
uid
name
age
gender
raceethnicity
month
day
year
streetaddress
city
state
classification
lawenforcementagency
armed
July
40
42
Jose Ceja
36
Male
Hispanic/Latino
January
15
2015
2007 Sousa Ct
Fairfield
CA
Gunshot
Fairfield Police Department
Knife
False
54
53
Daniel Brumley
25
Male
Hispanic/Latino
January
17
2015
NE 36th St
Fort Worth
TX
Gunshot
Fort Worth Police Department
Knife
False
66
65
Jose Antonio Espinoza Ruiz
56
Male
Hispanic/Latino
January
23
2015
202 Avenue A
Levelland
TX
Gunshot
Levelland Police Department
Knife
False
72
72
David Garcia
33
Male
Hispanic/Latino
January
26
2015
1134 E St
Wasco
CA
Gunshot
Kern County Sheriff's Office
Knife
False
131
133
Daniel Mejia
37
Male
Hispanic/Latino
February
15
2015
200 S McNab Pkwy
San Manuel
AZ
Gunshot
Pinal County Sheriff's Office
Knife
False
163
161
Amilcar Perez-Lopez
21
Male
Hispanic/Latino
February
26
2015
Folsom St and 24th St
San Francisco
CA
Gunshot
San Francisco Police Department
Knife
False
267
264
Adrian Solis
35
Male
Hispanic/Latino
March
26
2015
1515 Bayview Ave
Wilmington
CA
Gunshot
Los Angeles Police Department
Knife
False
320
313
Angel Corona Jr
21
Male
Hispanic/Latino
April
10
2015
4740 Barham Ave
Corning
CA
Gunshot
Tehama County Sheriff's Department
Knife
False
339
330
Rodolfo Velazquez
47
Male
Hispanic/Latino
April
16
2015
West Lerdo Hwy and South Wall St
Shafter
CA
Gunshot
Shafter Police Department
Knife
False
351
340
Luis Molina Martinez
35
Male
Hispanic/Latino
April
21
2015
3400 Manitou Ave
Los Angeles
CA
Gunshot
Los Angeles Police Department
Knife
False
359
349
Carlos Ramirez
51
Male
Hispanic/Latino
April
22
2015
101 Naco Hwy
Bisbee
AZ
Gunshot
Bisbee Police Department
Knife
False
434
425
Alfredo Rials-Torres
54
Male
Hispanic/Latino
May
19
2015
4219 2nd Road N
Arlington
VA
Gunshot
Arlington Police Department
Knife
False
441
436
Elvin Diaz
24
Male
Hispanic/Latino
May
21
2015
10 Temple Ave
Hackensack
NJ
Gunshot
Hackensack Police Department
Knife
False
483
471
Edelmiro Hernandez
33
Male
Hispanic/Latino
June
3
2015
11799 Featherwood Dr
Houston
TX
Gunshot
Houston Police Department
Knife
False
495
491
Rene Garcia
30
Male
Hispanic/Latino
June
8
2015
La Palma Ave and Helena St
Anaheim
CA
Gunshot
Anaheim Police Department
Knife
False
507
505
Raymond Peralta-Lantigua
22
Male
Hispanic/Latino
June
11
2015
185Johnson Ave
Hackensack
NJ
Gunshot
Hackensack Police Department
Knife
False
529
526
Santos Laboy
45
Male
Hispanic/Latino
June
19
2015
Charles River Esplanade
Boston
MA
Gunshot
Massachusetts State Police
Knife
False
563
562
Cesar Juarez
27
Male
Hispanic/Latino
July
3
2015
700 Nogales St
West Covina
CA
Gunshot
West Covina Police Department
Knife
True
579
587
David Sarabia
27
Male
Hispanic/Latino
July
6
2015
Green Sands Ave and Augusta Ln
Atwater
CA
Gunshot
Atwater Police Department
Knife
True
698
695
Gustavo Ponce-Galon
42
Male
Hispanic/Latino
August
6
2015
159 Seneca Trail
Elsmere
KY
Gunshot
Elsmere Police Department
Knife
False
707
711
Edrian Rivera
22
Male
Hispanic/Latino
August
9
2015
San Antonio Ave and Packing Pl
San Jose
CA
Gunshot
San Jose Police Department
Knife
False
773
778
Roger Albrecht
43
Male
Hispanic/Latino
August
29
2015
6500 Spring Branch St
San Antonio
TX
Gunshot
San Antonio Police Department
Knife
False
810
817
Santino Burce
34
Male
Hispanic/Latino
September
10
2015
Valley Blvd and Juniper Ave
Fontana
CA
Gunshot
Fontana Police Department
Knife
False
875
887
Christian Pena
26
Male
Hispanic/Latino
October
2
2015
200 S Linden Ave
Rialto
CA
Gunshot
Rialto Police Department
Knife
False
887
902
Gary Boitano
19
Male
Hispanic/Latino
October
9
2015
6400 Cardinal Ln
Columbia
MD
Gunshot
Howard County Police Department
Knife
False
896
911
Robert Medellin
43
Male
Hispanic/Latino
October
11
2015
5200 W 40th St
Odessa
TX
Gunshot
Ector County Sheriff's Office
Knife
False
928
942
Miguel Galena
35
Male
Hispanic/Latino
October
21
2015
200 East First Street
Calexico
CA
Gunshot
US Customs and Border Protection
Knife
False
994
1013
Moises Nerio
42
Male
Hispanic/Latino
November
12
2015
1200 Ayala Dr
Sunnyvale
CA
Gunshot
Sunnyvale Bureau of Police Services
Knife
False
1024
1045
Henry Reyna
49
Male
Hispanic/Latino
November
23
2015
5000 Concord St
Corpus Christi
TX
Gunshot
Corpus Christi Police Department
Knife
False
1071
1098
Roy Carreon
49
Male
Hispanic/Latino
December
12
2015
500 Tia Juana St N
San Bernardino
CA
Gunshot
San Bernardino Police Department
Knife
False
1117
1142
Omar Ventura
23
Male
Hispanic/Latino
December
24
2015
200 N Larson St
Porterville
CA
Gunshot
Porterville Police Department
Knife
False
1132
1157
Fred Perez
55
Male
Hispanic/Latino
December
30
2015
E Belmont Ave and N Weber Ave
Fresno
CA
Gunshot
Fresno Police Department
Knife
False
In [24]:
df['gender'].value_counts()
Out[24]:
Male 1092
Female 53
Non-conforming 1
Name: gender, dtype: int64
In [25]:
#doesn't look right!
plt.style.use('ggplot')
df['age'].value_counts().hist()
Out[25]:
<matplotlib.axes._subplots.AxesSubplot at 0x10c41ef60>
In [26]:
#we had to create a new list since histograms need floats and we had strings (unknown)
age2 = []
for point in df['age']:
if point != 'Unknown':
age2.append(float(point))
else:
age2.append(0)
df['age_2'] = age2
df['age_2'].hist()
df['age'].sort_values()
#we still have unknown values plotted
Out[26]:
906 15
711 15
519 15
243 16
863 16
1002 16
154 16
739 17
855 17
510 17
172 17
862 17
92 17
74 17
63 17
432 17
594 17
299 17
482 18
918 18
587 18
944 18
900 18
969 18
469 18
403 18
1040 18
882 18
779 18
6 18
...
56 67
977 68
419 68
36 68
75 68
593 68
1034 69
494 69
47 69
684 71
25 71
402 72
334 72
1133 74
1145 74
112 74
34 75
375 76
615 76
781 76
269 77
613 77
709 77
326 83
508 85
35 87
147 Unknown
1072 Unknown
1066 Unknown
88 Unknown
Name: age, dtype: object
In [27]:
no_unknowns = df.drop(df.index[[147, 1072, 1066, 88]])
no_unknowns['age'].sort_values()
age2 = []
for point in no_unknowns['age']:
age2.append(float(point))
no_unknowns['age2'] = age2
no_unknowns['age2'].hist()
Out[27]:
<matplotlib.axes._subplots.AxesSubplot at 0x10c51f400>
In [28]:
df['state'].value_counts().hist()
df['state'].value_counts()
Out[28]:
CA 211
TX 110
FL 71
AZ 44
GA 39
OK 38
OH 37
CO 32
LA 28
NC 26
NY 25
PA 24
WA 23
IL 23
NJ 23
VA 23
MO 22
NM 21
TN 21
SC 21
IN 21
MI 20
NV 19
KY 19
AL 19
MD 17
OR 17
MN 13
WI 12
WV 12
MS 12
KS 11
UT 10
MA 10
NE 9
ID 8
DC 7
WY 6
AR 5
HI 5
AK 5
IA 5
DE 4
MT 4
CT 4
NH 3
ME 2
SD 2
RI 1
VT 1
ND 1
Name: state, dtype: int64
In [ ]:
In [ ]:
In [ ]:
Content source: mercybenzaquen/foundations-homework
Similar notebooks: