Editing Community Data Science Course (Spring 2017)/Day 7 Exercise
From CommunityData
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then publish the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 3: | Line 3: | ||
This data describes economic conditions in each Congressional District. The details can be found at: | This data describes economic conditions in each Congressional District. The details can be found at: | ||
http://proximityone.com/cd11414dp3.htm | http://proximityone.com/cd11414dp3.htm | ||
# Download the data from [http://proximityone.com/countytrends/cd11414dp3.csv here]. | # Download the data from [http://proximityone.com/countytrends/cd11414dp3.csv here]. | ||
# Using the data description above, see if you can figure out which columns contain which rows in the raw data. Identify the columns for construction, manufacturing, and finance workforce. Also, identify columns for median and mean income. | # Using the data description above, see if you can figure out which columns contain which rows in the raw data. Identify the columns for construction, manufacturing, and finance workforce. Also, identify columns for median and mean income. | ||
# Open the file in python, split each line, and read the fields you identified in step 2 into a list. | # Open the file in python, split each line, and read the fields you identified in step 2 into a list. | ||
# Remove Puerto Rico and Washington D.C. | # Remove Puerto Rico and Washington D.C. | ||
# Compute the percent of workers in each of the industries above and add it to the list of data. | # Compute the percent of workers in each of the industries above and add it to the list of data. | ||
# Output the data to a new CSV file. (add a header). | # Output the data to a new CSV file. (add a header). | ||
# Open this data in Excel. Try to identify whether there is a relationship between percent of a district in each industry and median or mean salary. | # Open this data in Excel. Try to identify whether there is a relationship between percent of a district in each industry and median or mean salary. |