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!
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 Formattab in this documentInput: CSV files with data for each given year
Output: A CSV file with
RESOLUTIONDATEcolumnfeature_id: The ID for the feature, in this case,"311_service_requests_ttr"feature_type: The service code, found in theSERVICECODEcolumn of the 311 datafeature_subtype: NAyear: The ISO-8601 year of the feature value, i.e. the year that the service requests were logged (fromSERVICEORDERDATE)week: The ISO-8601 week number of the feature value, i.e. the week that the service requests were logged (fromSERVICEORDERDATE)census_block_2010: The 2010 Census Block of the feature valuevalue: The value of the feature, i.e. the average number of days between the date listed in theSERVICEORDERDATEandRESOLUTIONDATEcolumns 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!