For this final project I would like to work with the 311 Service data, which contains complaints calls data by the agency. this dataset contains around 22 million rows and 41 columns.
data <- read.csv("311_data.csv",nrows=1000)
head(data)## Unique.Key Created.Date Closed.Date Agency
## 1 23618886 07/15/2012 01:19:20 PM 07/15/2012 07:06:25 PM NYPD
## 2 23618887 07/15/2012 07:41:05 PM 07/16/2012 05:07:20 AM NYPD
## 3 23618888 07/15/2012 05:41:19 AM 07/15/2012 07:16:08 AM NYPD
## 4 23618889 07/15/2012 11:21:37 PM 07/16/2012 01:17:38 AM NYPD
## 5 23618890 07/15/2012 09:01:04 PM 07/15/2012 10:09:51 PM NYPD
## 6 23618891 07/15/2012 05:02:29 PM 07/15/2012 06:55:03 PM NYPD
## Agency.Name Complaint.Type Descriptor
## 1 New York City Police Department Blocked Driveway No Access
## 2 New York City Police Department Blocked Driveway Partial Access
## 3 New York City Police Department Blocked Driveway Partial Access
## 4 New York City Police Department Blocked Driveway Partial Access
## 5 New York City Police Department Blocked Driveway Partial Access
## 6 New York City Police Department Blocked Driveway Partial Access
## Location.Type Incident.Zip Incident.Address Street.Name
## 1 Street/Sidewalk 11238 280 PARK PLACE PARK PLACE
## 2 Street/Sidewalk 11213 9 HATTIE JONES PLACE HATTIE JONES PLACE
## 3 Street/Sidewalk 10468 2835 WEBB AVENUE WEBB AVENUE
## 4 Street/Sidewalk 11214 8824 24 AVENUE 24 AVENUE
## 5 Street/Sidewalk 10469 2946 YATES AVENUE YATES AVENUE
## 6 Street/Sidewalk 11235 248 OCEAN VIEW AVENUE OCEAN VIEW AVENUE
## Cross.Street.1 Cross.Street.2 Intersection.Street.1
## 1 VANDERBILT AVENUE UNDERHILL AVENUE
## 2 HERKIMER STREET DEAD END
## 3 WEST 197 STREET RESERVOIR AVENUE
## 4 BATH AVENUE CROPSEY AVENUE
## 5 ARNOW AVENUE ADEE AVENUE
## 6 BRIGHTON 2 STREET BRIGHTON 3 STREET
## Intersection.Street.2 Address.Type City Landmark Facility.Type Status
## 1 ADDRESS BROOKLYN Precinct Closed
## 2 ADDRESS BROOKLYN Precinct Closed
## 3 ADDRESS BRONX Precinct Closed
## 4 ADDRESS BROOKLYN Precinct Closed
## 5 ADDRESS BRONX Precinct Closed
## 6 ADDRESS BROOKLYN Precinct Closed
## Due.Date
## 1 07/15/2012 09:19:20 PM
## 2 07/16/2012 03:41:05 AM
## 3 07/15/2012 01:41:19 PM
## 4 07/16/2012 07:21:37 AM
## 5 07/16/2012 05:01:04 AM
## 6 07/16/2012 01:02:29 AM
## Resolution.Description
## 1 The Police Department responded and upon arrival those responsible for the condition were gone.
## 2 The Police Department responded to the complaint and with the information available observed no evidence of the violation at that time.
## 3 The Police Department responded to the complaint and took action to fix the condition.
## 4 The Police Department responded and upon arrival those responsible for the condition were gone.
## 5 The Police Department responded to the complaint and took action to fix the condition.
## 6 The Police Department responded and upon arrival those responsible for the condition were gone.
## Resolution.Action.Updated.Date Community.Board BBL Borough
## 1 07/15/2012 07:06:13 PM 08 BROOKLYN 3011650014 BROOKLYN
## 2 07/16/2012 04:14:58 AM 03 BROOKLYN 3017060029 BROOKLYN
## 3 07/15/2012 07:15:55 AM 08 BRONX 2032500040 BRONX
## 4 07/16/2012 01:16:37 AM 11 BROOKLYN 3068900057 BROOKLYN
## 5 07/15/2012 10:09:49 PM 11 BRONX 2045590033 BRONX
## 6 07/15/2012 06:54:48 PM 13 BROOKLYN 3086720066 BROOKLYN
## X.Coordinate..State.Plane. Y.Coordinate..State.Plane. Open.Data.Channel.Type
## 1 993035 185781 PHONE
## 2 1002336 186511 PHONE
## 3 1011697 257345 PHONE
## 4 985911 155988 PHONE
## 5 1024452 255741 PHONE
## 6 993831 150173 PHONE
## Park.Facility.Name Park.Borough Vehicle.Type Taxi.Company.Borough
## 1 Unspecified BROOKLYN NA
## 2 Unspecified BROOKLYN NA
## 3 Unspecified BRONX NA
## 4 Unspecified BROOKLYN NA
## 5 Unspecified BRONX NA
## 6 Unspecified BROOKLYN NA
## Taxi.Pick.Up.Location Bridge.Highway.Name Bridge.Highway.Direction Road.Ramp
## 1
## 2
## 3
## 4
## 5
## 6
## Bridge.Highway.Segment Latitude Longitude
## 1 40.67660 -73.96833
## 2 40.67859 -73.93479
## 3 40.87298 -73.90076
## 4 40.59483 -73.99402
## 5 40.86853 -73.85465
## 6 40.57886 -73.96551
## Location
## 1 (40.67659832744785, -73.968328435711)
## 2 (40.678587895407944, -73.93479464529676)
## 3 (40.87298432092539, -73.90075617690101)
## 4 (40.59482709148269, -73.99401911839777)
## 5 (40.868532958588595, -73.85464589664163)
## 6 (40.57886105297987, -73.96550925354674)colnames(data)## [1] "Unique.Key" "Created.Date"
## [3] "Closed.Date" "Agency"
## [5] "Agency.Name" "Complaint.Type"
## [7] "Descriptor" "Location.Type"
## [9] "Incident.Zip" "Incident.Address"
## [11] "Street.Name" "Cross.Street.1"
## [13] "Cross.Street.2" "Intersection.Street.1"
## [15] "Intersection.Street.2" "Address.Type"
## [17] "City" "Landmark"
## [19] "Facility.Type" "Status"
## [21] "Due.Date" "Resolution.Description"
## [23] "Resolution.Action.Updated.Date" "Community.Board"
## [25] "BBL" "Borough"
## [27] "X.Coordinate..State.Plane." "Y.Coordinate..State.Plane."
## [29] "Open.Data.Channel.Type" "Park.Facility.Name"
## [31] "Park.Borough" "Vehicle.Type"
## [33] "Taxi.Company.Borough" "Taxi.Pick.Up.Location"
## [35] "Bridge.Highway.Name" "Bridge.Highway.Direction"
## [37] "Road.Ramp" "Bridge.Highway.Segment"
## [39] "Latitude" "Longitude"
## [41] "Location"For this project, I would like to work with Dash Ploty. I can see this is a big dataset and I feel it will be better to work with Dash that can manage big data interactive projects. I would like to create visualization by city borough, where you maybe can select one of the 5 boroughs and maybe an agency and it will show you the complaints request by count or mean but also a map by zip location. I also can work doing more comparative analysis between some variables and plot them.
This project can very important in showing whats its the most complaints service by agency and location. this can be good to make decision and strategies and in order to provide a better service to the community and also to learn what government agency maybe need more help with the demanding workload.