Extract Time-to-Resolution features from 311 Data

[eclee25]

Start with the 311 Service Request data in the /Data Sets/311 Service Requests/ folder in Dropbox.
Write a script that uses this data to produce a feature data table for the average time to service request resolution for all service request types.

You can find the data format and examples on the Feature Dataset Format tab in this document

Input:
CSV files with data for each given year

Output:
A CSV file with

• 1 row for each service code, week, year, and census block
• Ignore records that have NA posted in the RESOLUTIONDATE column
• The dataset should include the following columns:

feature_id: The ID for the feature, in this case, "311_service_requests_ttr"
feature_type: The service code, found in the SERVICECODE column of the 311 data
feature_subtype: NA
year: The ISO-8601 year of the feature value, i.e. the year that the service requests were logged (from SERVICEORDERDATE)
week: The ISO-8601 week number of the feature value, i.e. the week that the service requests were logged (from SERVICEORDERDATE)
census_block_2010: The 2010 Census Block of the feature value
value: The value of the feature, i.e. the average number of days between the date listed in the SERVICEORDERDATE and RESOLUTIONDATE columns for all requests in that week, of that service type, in that census block.

When you are finished
Submit a pull request on GitHub (or upload your scripts)
Upload any files to Dropbox

Need more information?
Flag Jason or Elizabeth, or ask your question in the comments below and we'll respond as soon as we can!