Homework 1#
General assignment information
Coding: Exploring Trends in How People Submit 311 Requests#
Use this zipped copy of the cleaned data created in the lecture to complete the homework. Read it in from:
https://storage.googleapis.com/python-public-policy2/data/311_requests_2018-19_sample_clean.csv.zip
You will get a DtypeWarning - don’t worry about that for now.
# your code here
Step 0#
Which complaint submission method (Open Data Channel Type) is used most frequently, according to this dataset? Provide the count of each for comparison.
# your code here
Step 1#
Get the count of each submission method per complaint type, sorted by complaint type.
# your code here
Review the results and share a sentence or two with your observations.
YOUR RESPONSE HERE
Step 2#
Provide a simplified table that only lists the most common request submission method for each complaint type. There should be one row per complaint type, capturing the most common submission method for that complaint type.
# your code here
Can you provide a potential explaination for why some complaints are more frequently made via phone and mobile versus on the website?
YOUR RESPONSE HERE
Tutorials#
Read The Joys (and Woes) of the Craft of Software Engineering
Note not everything in there is applicable to data analysis
Filtering/indexing
DataFramesLearn about functions
Coding Style Guides - Please skim these; I don’t expect you to understand and follow everything in them. The most important guidelines to pay attention to are indentation and keeping each statement on its own line.
Optional#
Glance through pandas’ comparison with other tools for any you are familiar with
More on indexing:
Participation#
Reminder about the between-class participation requirement.