In [13]:
import pandas as pd
import sys
import os
import numpy as np
from mapboxgl.viz import *
from mapboxgl.utils import *
Concatenated all 4 databases into one called "MyLA311_All_Requests.csv"
In [14]:
fifteen = pd.read_csv("MyLA311_Service_Request_Data_2015.csv", low_memory = False)
sixteen = pd.read_csv("MyLA311_Service_Request_Data_2016.csv", low_memory = False)
seventeen = pd.read_csv("MyLA311_Service_Request_Data_2017.csv", low_memory = False)
eighteen = pd.read_csv("MyLA311_Service_Request_Data_2018.csv", low_memory = False)
In [15]:
all_311_requests = pd.concat([fifteen, sixteen, seventeen, eighteen], axis=0).sort_index()
In [16]:
all_311_requests.to_csv("MyLA311_All_Requests.csv", encoding = 'utf-8', index = False)
Parsed the merged database for all empty coordinates and removed them
In [17]:
my_311 = pd.read_csv("MyLA311_All_Requests.csv",sep=',', low_memory = False)
my_311['Longitude'].replace('', np.nan, inplace=True)
my_311.dropna(subset=['Longitude'], inplace=True)
my_311.to_csv('311_parsed_coordinates.csv', encoding = 'utf-8', index = False)
Splitting the CreatedDate column into two: one for the date, one for the time
In [18]:
import pandas as pd
import numpy as np
import datetime
df = pd.read_csv('311_parsed_coordinates.csv')
df[['Created Date','Created Time']] = df.CreatedDate.str.split(expand=True)
df
/anaconda3/lib/python3.6/site-packages/IPython/core/interactiveshell.py:2728: DtypeWarning: Columns (16,24) have mixed types. Specify dtype option on import or set low_memory=False.
interactivity=interactivity, compiler=compiler, result=result)
Out[18]:
SRNumber
CreatedDate
UpdatedDate
ActionTaken
Owner
RequestType
Status
RequestSource
MobileOS
Anonymous
...
TBMColumn
TBMRow
APC
CD
CDMember
NC
NCName
PolicePrecinct
Created Date
Created Time
0
1-78597941
12/10/15 9:34
12/11/15 8:55
SR Created
BOS
Metal/Household Appliances
Closed
Mobile App
Android
Y
...
G
5.0
Central APC
13.0
Mitch O'Farrell
33.0
HOLLYWOOD STUDIO DISTRICT NC
HOLLYWOOD
12/10/15
9:34
1
1-952588571
3/3/18 11:57
3/3/18 12:00
SR Created
OCB
Graffiti Removal
Closed
Driver Self Report
NaN
N
...
G
4.0
Central APC
13.0
NaN
30.0
HOLLYWOOD UNITED NC
HOLLYWOOD
3/3/18
11:57
2
1-88226921
1/1/16 8:28
1/4/16 14:52
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
B
1.0
East Los Angeles APC
1.0
Gilbert Cedillo
47.0
LINCOLN HEIGHTS NC
HOLLENBECK
1/1/16
8:28
3
1-513938562
4/10/17 11:39
4/12/17 9:56
SR Created
BOS
Bulky Items
Closed
Mobile App
iOS
N
...
J
3.0
South Valley APC
4.0
David Ryu
26.0
SHERMAN OAKS NC
VAN NUYS
4/10/17
11:39
4
1-513940271
4/10/17 11:42
4/14/17 7:50
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
A
5.0
North Valley APC
7.0
Vacant
5.0
SYLMAR NC
MISSION
4/10/17
11:42
5
1-88276381
1/1/16 11:07
1/8/16 11:19
SR Created
BOS
Bulky Items
Closed
Call
NaN
Y
...
J
4.0
Central APC
1.0
Gilbert Cedillo
76.0
PICO UNION NC
OLYMPIC
1/1/16
11:07
6
1-1074967561
6/22/18 11:13
6/23/18 12:51
SR Created
ITA
Other
Closed
Self Service
NaN
N
...
D
6.0
South Valley APC
6.0
Nury Martinez
19.0
LAKE BALBOA NC
WEST VALLEY
6/22/18
11:13
7
1-44772241
10/1/15 3:11
10/8/15 17:00
SR Created
BOS
Bulky Items
Closed
Email
NaN
N
...
A
1.0
Central APC
13.0
Mitch O'Farrell
55.0
WILSHIRE CENTER - KOREATOWN NC
OLYMPIC
10/1/15
3:11
8
1-88295291
1/1/16 14:02
1/6/16 10:38
SR Created
BOS
Bulky Items
Closed
Call
NaN
Y
...
B
4.0
Central APC
1.0
Gilbert Cedillo
76.0
PICO UNION NC
RAMPART
1/1/16
14:02
9
1-513938351
4/10/17 11:42
4/12/17 14:28
SR Created
BOS
Bulky Items
Closed
Call
NaN
Y
...
A
5.0
South Valley APC
2.0
Paul Krekorian
27.0
STUDIO CITY NC
NORTH HOLLYWOOD
4/10/17
11:42
10
1-952753491
3/4/18 6:30
3/5/18 13:13
SR Created
BOS
Electronic Waste
Closed
Self Service
NaN
N
...
A
1.0
North Valley APC
7.0
Monica Rodriguez
5.0
SYLMAR NC
MISSION
3/4/18
6:30
11
1-78929421
12/10/15 14:34
12/16/15 13:26
SR Created
BOS
Metal/Household Appliances
Cancelled
Call
NaN
N
...
D
1.0
South Valley APC
3.0
Bob Blumenfield
16.0
WOODLAND HILLS-WARNER CENTER NC
TOPANGA
12/10/15
14:34
12
1-88310551
1/1/16 15:24
1/5/16 13:28
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
B
2.0
East Los Angeles APC
1.0
Gilbert Cedillo
41.0
HISTORIC HIGHLAND PARK NC
NORTHEAST
1/1/16
15:24
13
1-952753431
3/4/18 6:23
3/9/18 9:58
SR Created
BOS
Bulky Items
Closed
Self Service
NaN
N
...
A
3.0
South Valley APC
3.0
Bob Blumenfield
13.0
CANOGA PARK NC
TOPANGA
3/4/18
6:23
14
1-59599861
11/2/15 8:11
11/5/15 14:30
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
A
1.0
South Los Angeles APC
8.0
Marqueece Harris-Dawson
NaN
NaN
77TH STREET
11/2/15
8:11
15
1-513942821
4/10/17 11:43
4/17/17 8:33
SR Created
BOS
Bulky Items
Closed
Self Service
NaN
N
...
B
5.0
East Los Angeles APC
1.0
Gilbert Cedillo
42.0
ARROYO SECO NC
HOLLENBECK
4/10/17
11:43
16
1-59622271
11/2/15 8:49
11/4/15 16:00
SR Created
BOS
Electronic Waste
Closed
Call
NaN
N
...
B
3.0
South Los Angeles APC
8.0
Marqueece Harris-Dawson
87.0
EMPOWERMENT CONGRESS SOUTHEAST AREA NDC
SOUTHEAST
11/2/15
8:49
17
1-88309281
1/1/16 16:11
1/6/16 9:08
SR Created
BOS
Bulky Items
Closed
Call
NaN
Y
...
D
3.0
Central APC
1.0
Gilbert Cedillo
97.0
WESTLAKE NORTH NC
RAMPART
1/1/16
16:11
18
1-513946071
4/10/17 11:43
4/12/17 10:40
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
D
1.0
South Los Angeles APC
9.0
Curren D. Price Jr.
78.0
SOUTH CENTRAL NC
NEWTON
4/10/17
11:43
19
1-952753561
3/4/18 6:31
3/9/18 12:38
SR Created
BOS
Homeless Encampment
Closed
Self Service
NaN
N
...
F
7.0
North Valley APC
7.0
Monica Rodriguez
9.0
FOOTHILL TRAILS DISTRICT NC
FOOTHILL
3/4/18
6:31
20
1-59618771
11/2/15 8:49
11/4/15 15:00
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
E
4.0
South Los Angeles APC
9.0
Curren D. Price Jr.
125.0
ZAPATA KING NC
NEWTON
11/2/15
8:49
21
1-88376161
1/2/16 8:38
1/6/16 10:45
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
C
3.0
East Los Angeles APC
1.0
Gilbert Cedillo
41.0
HISTORIC HIGHLAND PARK NC
NORTHEAST
1/2/16
8:38
22
1-513945898
4/10/17 11:43
4/17/17 10:59
SR Created
BOS
Bulky Items
Closed
Mobile App
Android
N
...
D
6.0
Central APC
14.0
Jose Huizar
52.0
DOWNTOWN LOS ANGELES
CENTRAL
4/10/17
11:43
23
1-952764861
3/4/18 6:56
3/8/18 7:19
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
C
3.0
Central APC
4.0
David Ryu
58.0
MID CITY WEST CC
WILSHIRE
3/4/18
6:56
24
1-952759351
3/4/18 6:57
3/9/18 10:00
SR Created
BOS
Homeless Encampment
Closed
Mobile App
iOS
N
...
J
2.0
South Valley APC
3.0
Bob Blumenfield
16.0
WOODLAND HILLS-WARNER CENTER NC
TOPANGA
3/4/18
6:57
25
1-513946221
4/10/17 11:43
4/14/17 13:10
SR Created
BOS
Bulky Items
Closed
Call
NaN
Y
...
B
7.0
South Los Angeles APC
10.0
Herb J. Wesson Jr.
75.0
WEST ADAMS NC
SOUTHWEST
4/10/17
11:43
26
1-59623111
11/2/15 8:54
11/3/15 14:00
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
B
2.0
North Valley APC
3.0
Bob Blumenfield
13.0
CANOGA PARK NC
TOPANGA
11/2/15
8:54
27
1-88430141
1/2/16 10:47
1/8/16 13:28
SR Created
BOS
Bulky Items
Closed
Call
NaN
Y
...
A
4.0
Central APC
1.0
Gilbert Cedillo
76.0
PICO UNION NC
OLYMPIC
1/2/16
10:47
28
1-88449071
1/2/16 11:21
1/5/16 11:50
SR Created
BOS
Bulky Items
Closed
Call
NaN
Y
...
J
5.0
East Los Angeles APC
1.0
Gilbert Cedillo
102.0
GREATER CYPRESS PARK NC
NORTHEAST
1/2/16
11:21
29
1-513946281
4/10/17 11:44
4/10/17 11:44
SR Created
BOS
Bulky Items
Closed
Driver Self Report
NaN
Y
...
G
2.0
North Valley APC
6.0
Nury Martinez
23.0
NORTH HOLLYWOOD NORTHEAST NC
FOOTHILL
4/10/17
11:44
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
2483664
1-820215191
11/16/17 15:01
11/17/17 12:45
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
B
2.0
South Los Angeles APC
10.0
Herb J. Wesson Jr.
79.0
EMPOWERMENT CONGRESS WEST AREA NDC
SOUTHWEST
11/16/17
15:01
2483665
1-820218661
11/16/17 15:02
11/24/17 8:11
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
G
2.0
South Los Angeles APC
8.0
Marqueece Harris-Dawson
84.0
EMPOWERMENT CONGRESS SOUTHWEST AREA NDC
77TH STREET
11/16/17
15:02
2483666
1-820218811
11/16/17 15:02
11/17/17 12:48
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
A
6.0
South Los Angeles APC
10.0
Herb J. Wesson Jr.
73.0
MID CITY NC
WILSHIRE
11/16/17
15:02
2483667
1-820219621
11/16/17 15:02
11/17/17 12:55
SR Created
BOS
Bulky Items
Closed
Self Service
NaN
N
...
B
4.0
North Valley APC
6.0
Nury Martinez
6.0
ARLETA NC
MISSION
11/16/17
15:02
2483668
1-820220931
11/16/17 15:02
11/17/17 10:23
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
F
5.0
South Los Angeles APC
15.0
Joe Buscaino
88.0
WATTS NC
SOUTHEAST
11/16/17
15:02
2483669
1-820221011
11/16/17 15:02
11/20/17 9:33
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
J
2.0
North Valley APC
7.0
Monica Rodriguez
10.0
SUNLAND-TUJUNGA NC
FOOTHILL
11/16/17
15:02
2483670
1-820217761
11/16/17 15:03
11/17/17 9:44
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
A
2.0
Central APC
10.0
Herb J. Wesson Jr.
55.0
WILSHIRE CENTER - KOREATOWN NC
OLYMPIC
11/16/17
15:03
2483671
1-820221611
11/16/17 15:03
11/17/17 8:13
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
E
3.0
South Los Angeles APC
9.0
Curren D. Price Jr.
87.0
EMPOWERMENT CONGRESS SOUTHEAST AREA NDC
SOUTHEAST
11/16/17
15:03
2483672
1-820221971
11/16/17 15:03
11/17/17 9:07
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
E
6.0
South Los Angeles APC
8.0
Marqueece Harris-Dawson
87.0
EMPOWERMENT CONGRESS SOUTHEAST AREA NDC
SOUTHEAST
11/16/17
15:03
2483673
1-820222111
11/16/17 15:03
11/22/17 13:26
SR Created
BOS
Illegal Dumping Pickup
Closed
Call
NaN
N
...
H
4.0
East Los Angeles APC
1.0
Gilbert Cedillo
102.0
GREATER CYPRESS PARK NC
NORTHEAST
11/16/17
15:03
2483674
1-784437471
10/19/17 18:12
10/23/17 6:19
SR Created
OCB
Graffiti Removal
Closed
Call
NaN
N
...
F
7.0
South Los Angeles APC
15.0
Joe Buscaino
90.0
HARBOR GATEWAY NORTH NC
SOUTHEAST
10/19/17
18:12
2483675
1-785428391
10/20/17 14:01
10/23/17 6:27
SR Created
OCB
Graffiti Removal
Closed
Call
NaN
N
...
B
1.0
Harbor APC
15.0
Joe Buscaino
90.0
HARBOR GATEWAY NORTH NC
SOUTHEAST
10/20/17
14:01
2483676
1-785457211
10/20/17 14:13
10/23/17 6:26
SR Created
OCB
Graffiti Removal
Closed
Email
NaN
N
...
G
4.0
South Los Angeles APC
15.0
Joe Buscaino
88.0
WATTS NC
SOUTHEAST
10/20/17
14:13
2483677
1-786102412
10/21/17 14:31
10/23/17 6:29
SR Created
OCB
Graffiti Removal
Closed
Mobile App
Android
Y
...
B
6.0
Harbor APC
15.0
Joe Buscaino
90.0
HARBOR GATEWAY NORTH NC
SOUTHEAST
10/21/17
14:31
2483678
1-786818528
10/23/17 9:03
10/30/17 3:43
SR Created
BOS
Illegal Dumping Pickup
Closed
Mobile App
iOS
N
...
F
1.0
North Valley APC
6.0
Nury Martinez
8.0
SUN VALLEY AREA NC
FOOTHILL
10/23/17
9:03
2483679
1-659247281
7/31/17 9:32
8/2/17 16:11
SR Created
BOS
Metal/Household Appliances
Closed
Call
NaN
N
...
A
5.0
West Los Angeles APC
11.0
Mike Bonin
66.0
WEST LOS ANGELES NC
WEST LOS ANGELES
7/31/17
9:32
2483680
1-786596581
10/23/17 6:37
10/26/17 14:34
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
G
5.0
North Valley APC
7.0
Monica Rodriguez
112.0
NORTH HILLS EAST
MISSION
10/23/17
6:37
2483681
1-653389951
7/28/17 14:10
8/2/17 17:11
SR Created
BOS
Metal/Household Appliances
Closed
Call
NaN
N
...
C
2.0
West Los Angeles APC
11.0
Mike Bonin
67.0
MAR VISTA CC
PACIFIC
7/28/17
14:10
2483682
1-655064311
7/29/17 20:16
8/2/17 12:48
SR Created
BOS
Metal/Household Appliances
Closed
Call
NaN
N
...
A
3.0
South Valley APC
4.0
David Ryu
26.0
SHERMAN OAKS NC
VAN NUYS
7/29/17
20:16
2483683
1-784767511
10/20/17 8:45
10/23/17 6:57
SR Created
BOS
Electronic Waste
Closed
Self Service
NaN
Y
...
B
1.0
East Los Angeles APC
1.0
Gilbert Cedillo
47.0
LINCOLN HEIGHTS NC
HOLLENBECK
10/20/17
8:45
2483684
1-786819100
10/23/17 9:03
10/23/17 9:04
SR Created
BOS
Illegal Dumping Pickup
Closed
Driver Self Report
NaN
N
...
G
2.0
North Valley APC
12.0
Mitchell Englander
124.0
NORTHRIDGE SOUTH NC
DEVONSHIRE
10/23/17
9:03
2483685
1-652820971
7/28/17 10:21
8/2/17 12:50
SR Created
BOS
Electronic Waste
Closed
Call
NaN
N
...
J
5.0
South Valley APC
4.0
David Ryu
26.0
SHERMAN OAKS NC
VAN NUYS
7/28/17
10:21
2483686
1-786820581
10/23/17 9:04
10/24/17 12:47
SR Created
BOS
Illegal Dumping Pickup
Closed
Call
NaN
N
...
J
6.0
East Los Angeles APC
1.0
Gilbert Cedillo
102.0
GREATER CYPRESS PARK NC
NORTHEAST
10/23/17
9:04
2483687
1-782351151
10/18/17 12:15
10/23/17 6:39
SR Created
OCB
Graffiti Removal
Closed
Call
NaN
N
...
J
4.0
West Los Angeles APC
11.0
Mike Bonin
68.0
VENICE NC
PACIFIC
10/18/17
12:15
2483688
1-783191715
10/19/17 7:05
10/23/17 6:49
SR Created
OCB
Graffiti Removal
Closed
Mobile App
iOS
N
...
B
2.0
Harbor APC
15.0
Joe Buscaino
96.0
COASTAL SAN PEDRO NC
HARBOR
10/19/17
7:05
2483689
1-783534969
10/19/17 10:09
10/23/17 6:51
SR Created
OCB
Graffiti Removal
Closed
Mobile App
iOS
N
...
J
3.0
Central APC
5.0
Paul Koretz
61.0
SOUTH ROBERTSON NC
WEST LOS ANGELES
10/19/17
10:09
2483690
1-783547961
10/19/17 10:15
10/23/17 6:49
SR Created
OCB
Graffiti Removal
Closed
Email
NaN
N
...
B
4.0
Central APC
4.0
David Ryu
29.0
HOLLYWOOD HILLS WEST NC
HOLLYWOOD
10/19/17
10:15
2483691
1-785674481
10/20/17 16:12
10/23/17 6:39
SR Created
OCB
Graffiti Removal
Closed
Self Service
NaN
N
...
E
5.0
Harbor APC
15.0
Joe Buscaino
93.0
WILMINGTON NC
HARBOR
10/20/17
16:12
2483692
1-786599005
10/23/17 6:50
10/23/17 19:30
SR Created
OCB
Graffiti Removal
Closed
Mobile App
iOS
Y
...
H
5.0
North Valley APC
12.0
Mitchell Englander
99.0
CHATSWORTH NC
DEVONSHIRE
10/23/17
6:50
2483693
1-786605611
10/23/17 6:52
10/23/17 15:21
SR Created
ITA
Other
Cancelled
Mobile App
iOS
N
...
C
6.0
Harbor APC
15.0
Joe Buscaino
93.0
WILMINGTON NC
HARBOR
10/23/17
6:52
2483694 rows × 35 columns
Converting Date to date format and creating a new column for week numbers based on that
In [19]:
df['Created Date'] = pd.to_datetime(df['Created Date'], errors='coerce')
df.sort_values('Created Date', inplace = True)
df['Week Number'] = df['Created Date'].dt.week
df
Out[19]:
SRNumber
CreatedDate
UpdatedDate
ActionTaken
Owner
RequestType
Status
RequestSource
MobileOS
Anonymous
...
TBMRow
APC
CD
CDMember
NC
NCName
PolicePrecinct
Created Date
Created Time
Week Number
40349
1-22838691
8/5/15 11:22
8/13/15 16:39
SR Created
BOS
Metal/Household Appliances
Closed
Call
NaN
N
...
3.0
West Los Angeles APC
5.0
Paul Koretz
61.0
SOUTH ROBERTSON NC
WEST LOS ANGELES
2015-08-05
11:22
32
37709
1-22711481
8/5/15 7:52
8/9/15 23:34
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
5.0
South Valley APC
3.0
Bob Blumenfield
16.0
WOODLAND HILLS-WARNER CENTER NC
TOPANGA
2015-08-05
7:52
32
42456
1-22942441
8/5/15 14:33
8/10/15 11:42
SR Created
BOS
Dead Animal Removal
Closed
Call
NaN
N
...
6.0
South Los Angeles APC
9.0
Curren D. Price Jr.
86.0
COMMUNITY AND NEIGHBORS FOR NINTH DISTRICT UNI...
NEWTON
2015-08-05
14:33
32
37712
1-22712351
8/5/15 7:52
12/18/15 11:53
SR Created
BOS
Other
Cancelled
Call
NaN
N
...
5.0
South Valley APC
4.0
David Ryu
26.0
SHERMAN OAKS NC
VAN NUYS
2015-08-05
7:52
32
37713
1-22710461
8/5/15 7:53
8/17/15 21:26
SR Created
BOS
Illegal Dumping Pickup
Closed
Call
NaN
N
...
2.0
Central APC
4.0
David Ryu
36.0
LOS FELIZ NC
NORTHEAST
2015-08-05
7:53
32
37719
1-22711531
8/5/15 7:53
8/15/15 18:47
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
3.0
South Los Angeles APC
9.0
Curren D. Price Jr.
125.0
ZAPATA KING NC
NEWTON
2015-08-05
7:53
32
42452
1-22941161
8/5/15 14:32
8/5/15 14:32
SR Created
BOS
Feedback
Open
Call
NaN
N
...
6.0
Central APC
13.0
Mitch O'Farrell
33.0
HOLLYWOOD STUDIO DISTRICT NC
HOLLYWOOD
2015-08-05
14:32
32
37720
1-22710511
8/5/15 7:54
8/9/15 23:34
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
4.0
Central APC
10.0
Herb J. Wesson Jr.
60.0
P.I.C.O. NC
WILSHIRE
2015-08-05
7:54
32
37725
1-22709721
8/5/15 7:54
8/9/15 21:47
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
7.0
Central APC
5.0
Paul Koretz
58.0
MID CITY WEST CC
WILSHIRE
2015-08-05
7:54
32
42449
1-22943481
8/5/15 14:32
8/9/15 23:59
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
3.0
South Valley APC
12.0
Mitchell Englander
11.0
WEST HILLS NC
TOPANGA
2015-08-05
14:32
32
37729
1-22709771
8/5/15 7:55
8/9/15 15:54
SR Created
BOS
Metal/Household Appliances
Closed
Call
NaN
N
...
5.0
South Valley APC
6.0
Nury Martinez
20.0
VAN NUYS NC
VAN NUYS
2015-08-05
7:55
32
37735
1-22711761
8/5/15 7:57
8/11/15 7:34
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
5.0
North Valley APC
7.0
Felipe Fuentes
10.0
SUNLAND-TUJUNGA NC
FOOTHILL
2015-08-05
7:57
32
37739
1-22710691
8/5/15 7:57
8/9/15 23:34
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
4.0
Central APC
5.0
Paul Koretz
61.0
SOUTH ROBERTSON NC
WEST LOS ANGELES
2015-08-05
7:57
32
37743
1-22711791
8/5/15 7:57
8/11/15 14:47
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
5.0
South Los Angeles APC
8.0
Marqueece Harris-Dawson
87.0
EMPOWERMENT CONGRESS SOUTHEAST AREA NDC
SOUTHEAST
2015-08-05
7:57
32
42444
1-22941091
8/5/15 14:31
8/9/15 23:59
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
6.0
South Valley APC
6.0
Nury Martinez
19.0
LAKE BALBOA NC
WEST VALLEY
2015-08-05
14:31
32
37746
1-22712521
8/5/15 7:59
8/11/15 14:24
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
5.0
Harbor APC
15.0
Joe Buscaino
92.0
HARBOR CITY NC
HARBOR
2015-08-05
7:59
32
37748
1-22710831
8/5/15 7:59
8/12/15 17:14
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
2.0
Central APC
1.0
Gilbert Cedillo
46.0
HISTORIC CULTURAL NC
CENTRAL
2015-08-05
7:59
32
37752
1-22709941
8/5/15 8:00
8/10/15 9:29
SR Created
BOS
Electronic Waste
Closed
Call
NaN
N
...
7.0
South Valley APC
2.0
Paul Krekorian
21.0
GREATER VALLEY GLEN COUNCIL
VAN NUYS
2015-08-05
8:00
32
37756
1-22712651
8/5/15 8:01
8/12/15 15:48
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
6.0
Central APC
14.0
Jose Huizar
52.0
DOWNTOWN LOS ANGELES
CENTRAL
2015-08-05
8:01
32
37759
1-22712031
8/5/15 8:02
8/11/15 7:25
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
4.0
North Valley APC
12.0
Mitchell Englander
4.0
GRANADA HILLS NORTH NC
DEVONSHIRE
2015-08-05
8:02
32
42438
1-22940231
8/5/15 14:30
8/11/15 14:19
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
6.0
West Los Angeles APC
5.0
Paul Koretz
62.0
WESTSIDE NC
WEST LOS ANGELES
2015-08-05
14:30
32
37766
1-22710951
8/5/15 8:03
8/9/15 23:34
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
5.0
South Valley APC
2.0
Paul Krekorian
22.0
NOHO WEST NC
NORTH HOLLYWOOD
2015-08-05
8:03
32
37769
1-22710091
8/5/15 8:03
8/9/15 15:50
SR Created
BOS
Metal/Household Appliances
Closed
Call
NaN
N
...
5.0
Harbor APC
15.0
Joe Buscaino
92.0
HARBOR CITY NC
HARBOR
2015-08-05
8:03
32
37772
1-22712161
8/5/15 8:03
8/5/15 16:09
SR Created
BOS
Dead Animal Removal
Closed
Call
NaN
N
...
4.0
South Los Angeles APC
8.0
Marqueece Harris-Dawson
84.0
EMPOWERMENT CONGRESS SOUTHWEST AREA NDC
77TH STREET
2015-08-05
8:03
32
42434
1-22938151
8/5/15 14:29
8/9/15 22:18
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
7.0
South Valley APC
2.0
Paul Krekorian
21.0
GREATER VALLEY GLEN COUNCIL
VAN NUYS
2015-08-05
14:29
32
42433
1-22940161
8/5/15 14:28
8/9/15 23:35
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
1.0
North Valley APC
7.0
Felipe Fuentes
7.0
PACOIMA NC
FOOTHILL
2015-08-05
14:28
32
37775
1-22712241
8/5/15 8:04
8/9/15 23:34
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
2.0
West Los Angeles APC
5.0
Paul Koretz
115.0
PALMS NC
PACIFIC
2015-08-05
8:04
32
37780
1-22711061
8/5/15 8:04
8/9/15 15:54
SR Created
BOS
Metal/Household Appliances
Closed
Call
NaN
N
...
4.0
North Valley APC
7.0
Felipe Fuentes
7.0
PACOIMA NC
FOOTHILL
2015-08-05
8:04
32
37704
1-22709591
8/5/15 7:50
8/9/15 21:47
SR Created
BOS
Bulky Items
Closed
Call
NaN
N
...
4.0
Central APC
4.0
David Ryu
36.0
LOS FELIZ NC
NORTHEAST
2015-08-05
7:50
32
37702
1-22711351
8/5/15 7:49
8/12/15 17:37
SR Created
BOS
Illegal Dumping Pickup
Closed
Call
NaN
N
...
5.0
East Los Angeles APC
14.0
Jose Huizar
48.0
LA-32 NC
HOLLENBECK
2015-08-05
7:49
32
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
1485521
1-1110284391
7/23/18 8:02
7/23/18 9:03
SR Created
BOS
Dead Animal Removal
Closed
Call
NaN
N
...
5.0
South Valley APC
3.0
Bob Blumenfield
15.0
RESEDA NC
WEST VALLEY
2018-07-23
8:02
30
1483294
1-1110242066
7/23/18 7:43
7/23/18 7:43
SR Created
BOS
Electronic Waste
Open
Mobile App
iOS
N
...
6.0
Central APC
13.0
Mitch O'Farrell
33.0
HOLLYWOOD STUDIO DISTRICT NC
HOLLYWOOD
2018-07-23
7:43
30
1485584
1-1110457911
7/23/18 9:11
7/23/18 9:11
SR Created
BOS
Bulky Items
Open
Call
NaN
N
...
3.0
Central APC
10.0
Herb J. Wesson Jr.
55.0
WILSHIRE CENTER - KOREATOWN NC
OLYMPIC
2018-07-23
9:11
30
1485587
1-1110458501
7/23/18 9:11
7/23/18 9:11
SR Created
BOS
Bulky Items
Open
Call
NaN
N
...
1.0
South Valley APC
2.0
Paul Krekorian
24.0
MID-TOWN NORTH HOLLYWOOD NC
NORTH HOLLYWOOD
2018-07-23
9:11
30
1485591
1-1110460271
7/23/18 9:12
7/23/18 9:12
SR Created
BOS
Metal/Household Appliances
Open
Call
NaN
N
...
3.0
Central APC
1.0
Gilbert Cedillo
121.0
WESTLAKE SOUTH NC
RAMPART
2018-07-23
9:12
30
1485633
1-1110466861
7/23/18 9:14
7/23/18 9:14
SR Created
BOS
Dead Animal Removal
Open
Call
NaN
N
...
6.0
South Los Angeles APC
15.0
Joe Buscaino
90.0
HARBOR GATEWAY NORTH NC
SOUTHEAST
2018-07-23
9:14
30
1485630
1-1110463981
7/23/18 9:14
7/23/18 9:14
SR Created
BOS
Bulky Items
Open
Call
NaN
N
...
5.0
South Valley APC
6.0
Nury Martinez
19.0
LAKE BALBOA NC
WEST VALLEY
2018-07-23
9:14
30
1485628
1-1110466268
7/23/18 9:14
7/23/18 9:14
SR Created
BOS
Bulky Items
Open
Mobile App
iOS
Y
...
5.0
West Los Angeles APC
11.0
Mike Bonin
68.0
VENICE NC
PACIFIC
2018-07-23
9:14
30
1483266
1-1110257511
7/23/18 7:50
7/23/18 7:50
SR Created
BOS
Bulky Items
Open
Call
NaN
N
...
4.0
South Los Angeles APC
8.0
Marqueece Harris-Dawson
80.0
PARK MESA HEIGHTS CC
SOUTHWEST
2018-07-23
7:50
30
1485624
1-1110465391
7/23/18 9:14
7/23/18 9:14
SR Created
BOS
Metal/Household Appliances
Open
Call
NaN
N
...
4.0
South Los Angeles APC
8.0
Marqueece Harris-Dawson
80.0
PARK MESA HEIGHTS CC
SOUTHWEST
2018-07-23
9:14
30
1485620
1-1110461170
7/23/18 9:13
7/23/18 9:14
SR Created
BOS
Homeless Encampment
Open
Mobile App
iOS
N
...
4.0
West Los Angeles APC
11.0
Mike Bonin
68.0
VENICE NC
PACIFIC
2018-07-23
9:13
30
1483268
1-1110257691
7/23/18 7:50
7/23/18 7:50
SR Created
BOS
Bulky Items
Open
Call
NaN
N
...
5.0
North Valley APC
7.0
Monica Rodriguez
5.0
SYLMAR NC
MISSION
2018-07-23
7:50
30
1485619
1-1110461111
7/23/18 9:13
7/23/18 9:13
SR Created
BOS
Bulky Items
Open
Call
NaN
N
...
6.0
South Los Angeles APC
10.0
Herb J. Wesson Jr.
74.0
UNITED NEIGHBORHOODS OF THE HISTORIC ARLINGTON...
WILSHIRE
2018-07-23
9:13
30
1483272
1-1110240881
7/23/18 7:42
7/23/18 7:42
SR Created
BOS
Bulky Items
Open
Call
NaN
N
...
3.0
North Valley APC
2.0
Paul Krekorian
22.0
NOHO WEST NC
NORTH HOLLYWOOD
2018-07-23
7:42
30
1485616
1-1110460971
7/23/18 9:13
7/23/18 9:13
SR Created
BOS
Bulky Items
Open
Call
NaN
N
...
5.0
South Valley APC
6.0
Nury Martinez
19.0
LAKE BALBOA NC
WEST VALLEY
2018-07-23
9:13
30
1483273
1-1110240690
7/23/18 7:42
7/23/18 7:42
SR Created
BOS
Bulky Items
Open
Mobile App
iOS
N
...
2.0
Harbor APC
15.0
Joe Buscaino
96.0
COASTAL SAN PEDRO NC
HARBOR
2018-07-23
7:42
30
1485613
1-1110463211
7/23/18 9:13
7/23/18 9:13
SR Created
BOS
Bulky Items
Open
Call
NaN
N
...
4.0
South Los Angeles APC
8.0
Marqueece Harris-Dawson
80.0
PARK MESA HEIGHTS CC
SOUTHWEST
2018-07-23
9:13
30
1485610
1-1110462651
7/23/18 9:13
7/23/18 9:13
SR Created
BOS
Bulky Items
Open
Call
NaN
N
...
1.0
East Los Angeles APC
1.0
Gilbert Cedillo
44.0
GREATER ECHO PARK ELYSIAN NC
RAMPART
2018-07-23
9:13
30
1485607
1-1110462491
7/23/18 9:12
7/23/18 9:12
SR Created
BOS
Bulky Items
Open
Call
NaN
N
...
3.0
South Valley APC
2.0
Paul Krekorian
24.0
MID-TOWN NORTH HOLLYWOOD NC
NORTH HOLLYWOOD
2018-07-23
9:12
30
1483281
1-1110241776
7/23/18 7:42
7/23/18 7:42
SR Created
BOS
Bulky Items
Open
Mobile App
iOS
N
...
2.0
North Valley APC
2.0
Paul Krekorian
22.0
NOHO WEST NC
NORTH HOLLYWOOD
2018-07-23
7:42
30
1483283
1-1110243221
7/23/18 7:41
7/23/18 7:42
SR Created
BOS
Bulky Items
Open
Call
NaN
N
...
5.0
South Los Angeles APC
8.0
Marqueece Harris-Dawson
80.0
PARK MESA HEIGHTS CC
SOUTHWEST
2018-07-23
7:41
30
1485603
1-1110458771
7/23/18 9:12
7/23/18 9:12
SR Created
BOS
Bulky Items
Open
Call
NaN
N
...
3.0
South Valley APC
2.0
Paul Krekorian
25.0
NC VALLEY VILLAGE
NORTH HOLLYWOOD
2018-07-23
9:12
30
1485601
1-1110211336
7/23/18 7:19
7/23/18 9:12
SR Created
BOS
Dead Animal Removal
Closed
Mobile App
iOS
Y
...
6.0
South Valley APC
3.0
Bob Blumenfield
14.0
WINNETKA NC
TOPANGA
2018-07-23
7:19
30
1483287
1-1110241848
7/23/18 7:42
7/23/18 7:42
SR Created
BOS
Bulky Items
Open
Mobile App
iOS
N
...
4.0
North Valley APC
7.0
Monica Rodriguez
5.0
SYLMAR NC
MISSION
2018-07-23
7:42
30
1483289
1-1110240974
7/23/18 7:42
7/23/18 7:42
SR Created
BOS
Bulky Items
Open
Mobile App
iOS
N
...
2.0
South Los Angeles APC
8.0
Marqueece Harris-Dawson
77.0
EMPOWERMENT CONGRESS NORTH AREA NDC
SOUTHWEST
2018-07-23
7:42
30
1485598
1-1110261311
7/23/18 7:51
7/23/18 9:12
SR Created
BOS
Dead Animal Removal
Closed
Self Service
NaN
N
...
6.0
South Valley APC
3.0
Bob Blumenfield
13.0
CANOGA PARK NC
TOPANGA
2018-07-23
7:51
30
1483291
1-1110243061
7/23/18 7:43
7/23/18 7:43
SR Created
BOS
Bulky Items
Open
Call
NaN
N
...
1.0
South Los Angeles APC
8.0
Marqueece Harris-Dawson
NaN
NaN
77TH STREET
2018-07-23
7:43
30
1485595
1-1110458091
7/23/18 9:12
7/23/18 9:12
SR Created
BSL
Single Streetlight Issue
Open
Email
NaN
N
...
7.0
Central APC
5.0
Paul Koretz
119.0
GREATER WILSHIRE NC
WILSHIRE
2018-07-23
9:12
30
1483261
1-1110257407
7/23/18 7:49
7/23/18 7:49
SR Created
BOS
Bulky Items
Open
Mobile App
iOS
N
...
2.0
North Valley APC
2.0
Paul Krekorian
8.0
SUN VALLEY AREA NC
FOOTHILL
2018-07-23
7:49
30
1487626
1-1110661371
7/23/18 10:24
7/23/18 10:24
SR Created
BOS
Homeless Encampment
Open
Self Service
NaN
N
...
4.0
South Valley APC
4.0
David Ryu
26.0
SHERMAN OAKS NC
VAN NUYS
2018-07-23
10:24
30
2483694 rows × 36 columns
New CSV for dataframe with week number column added on called "311_week_number.csv"
In [20]:
df.to_csv('311_week_number.csv', encoding = 'utf-8', index = False)
Reading "311_week_number.csv" to check if task was accomplished
In [21]:
cols = ['RequestType', 'RequestSource', 'Address', 'Latitude' , 'Longitude', 'CD', 'Created Date', 'Created Time', 'Week Number']
data = pd.read_csv("311_week_number.csv", usecols = cols, low_memory = False)
data
Out[21]:
RequestType
RequestSource
Address
Latitude
Longitude
CD
Created Date
Created Time
Week Number
0
Metal/Household Appliances
Call
1115 S ELM DR, 90035
34.056445
-118.395187
5.0
2015-08-05
11:22
32
1
Bulky Items
Call
20219 W CHAPTER DR, 91364
34.148923
-118.576744
3.0
2015-08-05
7:52
32
2
Dead Animal Removal
Call
346 W 64TH ST, 90003
33.981244
-118.280030
9.0
2015-08-05
14:33
32
3
Other
Call
14435 W BENEFIT ST, 91423
34.148889
-118.447419
4.0
2015-08-05
7:52
32
4
Illegal Dumping Pickup
Call
LOS FELIZ BLVD at GRIFFITH PARK BLVD, 90027
34.113826
-118.277039
4.0
2015-08-05
7:53
32
5
Bulky Items
Call
721 E 43RD PL, 90011
34.004913
-118.263076
9.0
2015-08-05
7:53
32
6
Feedback
Call
731 N ST ANDREWS PL, 90038
34.084435
-118.311530
13.0
2015-08-05
14:32
32
7
Bulky Items
Call
1260 S CLOVERDALE AVE, 90019
34.051757
-118.350011
10.0
2015-08-05
7:54
32
8
Bulky Items
Call
360 N EDINBURGH AVE, 90048
34.077845
-118.363621
5.0
2015-08-05
7:54
32
9
Bulky Items
Call
7730 N LENA AVE, 91304
34.211079
-118.626299
12.0
2015-08-05
14:32
32
10
Metal/Household Appliances
Call
6833 N SEPULVEDA BLVD, 91406
34.194954
-118.466438
6.0
2015-08-05
7:55
32
11
Bulky Items
Call
7104 W HIGHCLIFF TR, 91042
34.245145
-118.286781
7.0
2015-08-05
7:57
32
12
Bulky Items
Call
1643 S CREST DR, 90035
34.049798
-118.387688
5.0
2015-08-05
7:57
32
13
Bulky Items
Call
626 E 105TH ST, 90002
33.940920
-118.264252
8.0
2015-08-05
7:57
32
14
Bulky Items
Call
16434 W HAYNES ST, 91406
34.189020
-118.491543
6.0
2015-08-05
14:31
32
15
Bulky Items
Call
1627 W 261ST ST, 90710
33.786100
-118.305316
15.0
2015-08-05
7:59
32
16
Bulky Items
Call
906 N BEAUDRY AVE, 90012
34.067500
-118.246638
1.0
2015-08-05
7:59
32
17
Electronic Waste
Call
6016 N SUNNYSLOPE AVE, 91401
34.180182
-118.426787
2.0
2015-08-05
8:00
32
18
Bulky Items
Call
1149 S BROADWAY, 90015
34.038578
-118.260191
14.0
2015-08-05
8:01
32
19
Bulky Items
Call
17447 W TUSCAN DR, 91344
34.305303
-118.513290
12.0
2015-08-05
8:02
32
20
Bulky Items
Call
10645 W ROUNTREE ROAD, 90064
34.037392
-118.419301
5.0
2015-08-05
14:30
32
21
Bulky Items
Call
6952 N NAGLE AVE, 91605
34.197161
-118.423487
2.0
2015-08-05
8:03
32
22
Metal/Household Appliances
Call
1627 W 261ST ST, 90710
33.786100
-118.305316
15.0
2015-08-05
8:03
32
23
Dead Animal Removal
Call
9835 S WESTERN AVE, 90047
33.945820
-118.309423
8.0
2015-08-05
8:03
32
24
Bulky Items
Call
13506 W DELANO ST, 91401
34.182014
-118.427349
2.0
2015-08-05
14:29
32
25
Bulky Items
Call
11171 N DE HAVEN AVE, 91331
34.273223
-118.412948
7.0
2015-08-05
14:28
32
26
Bulky Items
Call
3736 S WESTWOOD BLVD, 90034
34.018793
-118.411028
5.0
2015-08-05
8:04
32
27
Metal/Household Appliances
Call
10221 N AMBOY AVE, 91331
34.255942
-118.426425
7.0
2015-08-05
8:04
32
28
Bulky Items
Call
4618 W KINGSWELL AVE, 90027
34.102469
-118.290354
4.0
2015-08-05
7:50
32
29
Illegal Dumping Pickup
Call
4398 E HARRIMAN AVE, 90032
34.095404
-118.179368
14.0
2015-08-05
7:49
32
...
...
...
...
...
...
...
...
...
...
2483664
Dead Animal Removal
Call
19406 W GAULT ST, 91335
34.199368
-118.555880
3.0
2018-07-23
8:02
30
2483665
Electronic Waste
Mobile App
824 N OXFORD AVE, 90029
34.085207
-118.307673
13.0
2018-07-23
7:43
30
2483666
Bulky Items
Call
723 S HARVARD BLVD, 90005
34.059036
-118.304475
10.0
2018-07-23
9:11
30
2483667
Bulky Items
Call
5825 N BUCKNELL AVE, 91607
34.176407
-118.392485
2.0
2018-07-23
9:11
30
2483668
Metal/Household Appliances
Call
629 S BURLINGTON AVE, 90057
34.057269
-118.272162
1.0
2018-07-23
9:12
30
2483669
Dead Animal Removal
Call
115TH ST AT STANFORD AVE, 90059
33.930091
-118.262186
15.0
2018-07-23
9:14
30
2483670
Bulky Items
Call
6853 N TEXHOMA AVE, 91406
34.195366
-118.515444
6.0
2018-07-23
9:14
30
2483671
Bulky Items
Mobile App
563 E BROADWAY, 90291
33.994510
-118.468741
11.0
2018-07-23
9:14
30
2483672
Bulky Items
Call
4727 S 6TH AVE, 90043
34.000220
-118.323790
8.0
2018-07-23
7:50
30
2483673
Metal/Household Appliances
Call
4500 S 5TH AVE, 90043
34.002555
-118.322374
8.0
2018-07-23
9:14
30
2483674
Homeless Encampment
Mobile App
109 S LINCOLN BLVD, 90291
34.002352
-118.470359
11.0
2018-07-23
9:13
30
2483675
Bulky Items
Call
12600 N SAN FERNANDO ROAD, 91342
34.298792
-118.457741
7.0
2018-07-23
7:50
30
2483676
Bulky Items
Call
2142 S 3RD AVE, 90018
34.037725
-118.319993
10.0
2018-07-23
9:13
30
2483677
Bulky Items
Call
12749 W STAGG ST, 91605
34.211662
-118.411491
2.0
2018-07-23
7:42
30
2483678
Bulky Items
Call
6853 N TEXHOMA AVE, 91406
34.195366
-118.515444
6.0
2018-07-23
9:13
30
2483679
Bulky Items
Mobile App
564 W 36TH ST, 90731
33.711610
-118.289281
15.0
2018-07-23
7:42
30
2483680
Bulky Items
Call
4500 S 5TH AVE, 90043
34.002555
-118.322374
8.0
2018-07-23
9:13
30
2483681
Bulky Items
Call
1342 W CALUMET AVE, 90026
34.068637
-118.255209
1.0
2018-07-23
9:13
30
2483682
Bulky Items
Call
11040 W HESBY ST, 91601
34.161890
-118.371986
2.0
2018-07-23
9:12
30
2483683
Bulky Items
Mobile App
8027 N TEESDALE AVE, 91605
34.216669
-118.410381
2.0
2018-07-23
7:42
30
2483684
Bulky Items
Call
5127 S 6TH AVE, 90043
33.995969
-118.323783
8.0
2018-07-23
7:41
30
2483685
Bulky Items
Call
12361 W HARTSOOK ST, 91607
34.164073
-118.403056
2.0
2018-07-23
9:12
30
2483686
Dead Animal Removal
Mobile App
6804 N DE SOTO AVE, 91303
34.194110
-118.586945
3.0
2018-07-23
7:19
30
2483687
Bulky Items
Mobile App
13170 N BORDEN AVE, 91342
34.309665
-118.445807
7.0
2018-07-23
7:42
30
2483688
Bulky Items
Mobile App
1615 W MIDDLETON PL, 90062
34.015627
-118.309488
8.0
2018-07-23
7:42
30
2483689
Dead Animal Removal
Self Service
20905 W BASSETT ST, 91303
34.195694
-118.588874
3.0
2018-07-23
7:51
30
2483690
Bulky Items
Call
719 W 77TH ST, 90044
33.969876
-118.286141
8.0
2018-07-23
7:43
30
2483691
Single Streetlight Issue
Email
462 N MANSFIELD AVE, 90036
34.080132
-118.340723
5.0
2018-07-23
9:12
30
2483692
Bulky Items
Mobile App
10704 W STRATHERN ST, 91352
34.215580
-118.364732
2.0
2018-07-23
7:49
30
2483693
Homeless Encampment
Self Service
14475 W VENTURA BLVD, 91423
34.151019
-118.448336
4.0
2018-07-23
10:24
30
2483694 rows × 9 columns
In [22]:
df = data.dropna()
df
Out[22]:
RequestType
RequestSource
Address
Latitude
Longitude
CD
Created Date
Created Time
Week Number
0
Metal/Household Appliances
Call
1115 S ELM DR, 90035
34.056445
-118.395187
5.0
2015-08-05
11:22
32
1
Bulky Items
Call
20219 W CHAPTER DR, 91364
34.148923
-118.576744
3.0
2015-08-05
7:52
32
2
Dead Animal Removal
Call
346 W 64TH ST, 90003
33.981244
-118.280030
9.0
2015-08-05
14:33
32
3
Other
Call
14435 W BENEFIT ST, 91423
34.148889
-118.447419
4.0
2015-08-05
7:52
32
4
Illegal Dumping Pickup
Call
LOS FELIZ BLVD at GRIFFITH PARK BLVD, 90027
34.113826
-118.277039
4.0
2015-08-05
7:53
32
5
Bulky Items
Call
721 E 43RD PL, 90011
34.004913
-118.263076
9.0
2015-08-05
7:53
32
6
Feedback
Call
731 N ST ANDREWS PL, 90038
34.084435
-118.311530
13.0
2015-08-05
14:32
32
7
Bulky Items
Call
1260 S CLOVERDALE AVE, 90019
34.051757
-118.350011
10.0
2015-08-05
7:54
32
8
Bulky Items
Call
360 N EDINBURGH AVE, 90048
34.077845
-118.363621
5.0
2015-08-05
7:54
32
9
Bulky Items
Call
7730 N LENA AVE, 91304
34.211079
-118.626299
12.0
2015-08-05
14:32
32
10
Metal/Household Appliances
Call
6833 N SEPULVEDA BLVD, 91406
34.194954
-118.466438
6.0
2015-08-05
7:55
32
11
Bulky Items
Call
7104 W HIGHCLIFF TR, 91042
34.245145
-118.286781
7.0
2015-08-05
7:57
32
12
Bulky Items
Call
1643 S CREST DR, 90035
34.049798
-118.387688
5.0
2015-08-05
7:57
32
13
Bulky Items
Call
626 E 105TH ST, 90002
33.940920
-118.264252
8.0
2015-08-05
7:57
32
14
Bulky Items
Call
16434 W HAYNES ST, 91406
34.189020
-118.491543
6.0
2015-08-05
14:31
32
15
Bulky Items
Call
1627 W 261ST ST, 90710
33.786100
-118.305316
15.0
2015-08-05
7:59
32
16
Bulky Items
Call
906 N BEAUDRY AVE, 90012
34.067500
-118.246638
1.0
2015-08-05
7:59
32
17
Electronic Waste
Call
6016 N SUNNYSLOPE AVE, 91401
34.180182
-118.426787
2.0
2015-08-05
8:00
32
18
Bulky Items
Call
1149 S BROADWAY, 90015
34.038578
-118.260191
14.0
2015-08-05
8:01
32
19
Bulky Items
Call
17447 W TUSCAN DR, 91344
34.305303
-118.513290
12.0
2015-08-05
8:02
32
20
Bulky Items
Call
10645 W ROUNTREE ROAD, 90064
34.037392
-118.419301
5.0
2015-08-05
14:30
32
21
Bulky Items
Call
6952 N NAGLE AVE, 91605
34.197161
-118.423487
2.0
2015-08-05
8:03
32
22
Metal/Household Appliances
Call
1627 W 261ST ST, 90710
33.786100
-118.305316
15.0
2015-08-05
8:03
32
23
Dead Animal Removal
Call
9835 S WESTERN AVE, 90047
33.945820
-118.309423
8.0
2015-08-05
8:03
32
24
Bulky Items
Call
13506 W DELANO ST, 91401
34.182014
-118.427349
2.0
2015-08-05
14:29
32
25
Bulky Items
Call
11171 N DE HAVEN AVE, 91331
34.273223
-118.412948
7.0
2015-08-05
14:28
32
26
Bulky Items
Call
3736 S WESTWOOD BLVD, 90034
34.018793
-118.411028
5.0
2015-08-05
8:04
32
27
Metal/Household Appliances
Call
10221 N AMBOY AVE, 91331
34.255942
-118.426425
7.0
2015-08-05
8:04
32
28
Bulky Items
Call
4618 W KINGSWELL AVE, 90027
34.102469
-118.290354
4.0
2015-08-05
7:50
32
29
Illegal Dumping Pickup
Call
4398 E HARRIMAN AVE, 90032
34.095404
-118.179368
14.0
2015-08-05
7:49
32
...
...
...
...
...
...
...
...
...
...
2483664
Dead Animal Removal
Call
19406 W GAULT ST, 91335
34.199368
-118.555880
3.0
2018-07-23
8:02
30
2483665
Electronic Waste
Mobile App
824 N OXFORD AVE, 90029
34.085207
-118.307673
13.0
2018-07-23
7:43
30
2483666
Bulky Items
Call
723 S HARVARD BLVD, 90005
34.059036
-118.304475
10.0
2018-07-23
9:11
30
2483667
Bulky Items
Call
5825 N BUCKNELL AVE, 91607
34.176407
-118.392485
2.0
2018-07-23
9:11
30
2483668
Metal/Household Appliances
Call
629 S BURLINGTON AVE, 90057
34.057269
-118.272162
1.0
2018-07-23
9:12
30
2483669
Dead Animal Removal
Call
115TH ST AT STANFORD AVE, 90059
33.930091
-118.262186
15.0
2018-07-23
9:14
30
2483670
Bulky Items
Call
6853 N TEXHOMA AVE, 91406
34.195366
-118.515444
6.0
2018-07-23
9:14
30
2483671
Bulky Items
Mobile App
563 E BROADWAY, 90291
33.994510
-118.468741
11.0
2018-07-23
9:14
30
2483672
Bulky Items
Call
4727 S 6TH AVE, 90043
34.000220
-118.323790
8.0
2018-07-23
7:50
30
2483673
Metal/Household Appliances
Call
4500 S 5TH AVE, 90043
34.002555
-118.322374
8.0
2018-07-23
9:14
30
2483674
Homeless Encampment
Mobile App
109 S LINCOLN BLVD, 90291
34.002352
-118.470359
11.0
2018-07-23
9:13
30
2483675
Bulky Items
Call
12600 N SAN FERNANDO ROAD, 91342
34.298792
-118.457741
7.0
2018-07-23
7:50
30
2483676
Bulky Items
Call
2142 S 3RD AVE, 90018
34.037725
-118.319993
10.0
2018-07-23
9:13
30
2483677
Bulky Items
Call
12749 W STAGG ST, 91605
34.211662
-118.411491
2.0
2018-07-23
7:42
30
2483678
Bulky Items
Call
6853 N TEXHOMA AVE, 91406
34.195366
-118.515444
6.0
2018-07-23
9:13
30
2483679
Bulky Items
Mobile App
564 W 36TH ST, 90731
33.711610
-118.289281
15.0
2018-07-23
7:42
30
2483680
Bulky Items
Call
4500 S 5TH AVE, 90043
34.002555
-118.322374
8.0
2018-07-23
9:13
30
2483681
Bulky Items
Call
1342 W CALUMET AVE, 90026
34.068637
-118.255209
1.0
2018-07-23
9:13
30
2483682
Bulky Items
Call
11040 W HESBY ST, 91601
34.161890
-118.371986
2.0
2018-07-23
9:12
30
2483683
Bulky Items
Mobile App
8027 N TEESDALE AVE, 91605
34.216669
-118.410381
2.0
2018-07-23
7:42
30
2483684
Bulky Items
Call
5127 S 6TH AVE, 90043
33.995969
-118.323783
8.0
2018-07-23
7:41
30
2483685
Bulky Items
Call
12361 W HARTSOOK ST, 91607
34.164073
-118.403056
2.0
2018-07-23
9:12
30
2483686
Dead Animal Removal
Mobile App
6804 N DE SOTO AVE, 91303
34.194110
-118.586945
3.0
2018-07-23
7:19
30
2483687
Bulky Items
Mobile App
13170 N BORDEN AVE, 91342
34.309665
-118.445807
7.0
2018-07-23
7:42
30
2483688
Bulky Items
Mobile App
1615 W MIDDLETON PL, 90062
34.015627
-118.309488
8.0
2018-07-23
7:42
30
2483689
Dead Animal Removal
Self Service
20905 W BASSETT ST, 91303
34.195694
-118.588874
3.0
2018-07-23
7:51
30
2483690
Bulky Items
Call
719 W 77TH ST, 90044
33.969876
-118.286141
8.0
2018-07-23
7:43
30
2483691
Single Streetlight Issue
Email
462 N MANSFIELD AVE, 90036
34.080132
-118.340723
5.0
2018-07-23
9:12
30
2483692
Bulky Items
Mobile App
10704 W STRATHERN ST, 91352
34.215580
-118.364732
2.0
2018-07-23
7:49
30
2483693
Homeless Encampment
Self Service
14475 W VENTURA BLVD, 91423
34.151019
-118.448336
4.0
2018-07-23
10:24
30
2483677 rows × 9 columns
In [23]:
data['Created Date'] = pd.to_datetime(data['Created Date'], errors='coerce')
data['Created Year'] = data['Created Date'].dt.year
In [25]:
data.to_csv('311_parsed.csv', encoding = 'utf-8', index = False)
Content source: datala/311-analysis
Similar notebooks: