jasonasher / dc_doh_hackathon

Repository for the DC DOH Hackathon on September 23rd, 2017
5 stars 28 forks source link

Extract Features from Occupancy Permit Data #10

Open jasonasher opened 6 years ago

jasonasher commented 6 years ago

Start with the Occupancy Permit data in the /Data Sets/Occupancy Permits/ folder in Dropbox. Write a script that uses this data to produce a feature data table for the number of new occupancy permits issued in the last 4 weeks.

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

feature_id: The ID for the feature, in this case, "occupancy_permits_issued_last_4_weeks" feature_type: Occupancy permit type, found in the EVENTTYPESCODEDESC column of the source data feature_subtype: Left blank year: The ISO-8601 year of the feature value week: The ISO-8601 week number of the feature value census_block_2010: The 2010 Census Block of the feature value value: The value of the feature, i.e. the number of new occupancy permits of the specified types issued in the given census block during the previous 4 weeks starting from the year and week above.

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!

jasonasher commented 6 years ago

Look at the issue #3 solution for helpful inspiration!

eclee25 commented 6 years ago

Migrated open issue to codefordc/the-rat-hack repository as issue_11.