Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. Read in the Industry.csv file, which details the number of workers in each county in Maine within each industry in a given year 2.
1. Read in the Industry.csv file, which details the number of workers in each county in Maine within each industry in a given year 2. Strip out the workforce total rows and the year column 3. Subset this data into 2D arrays representing each year (rows: industry, columns: county) 4. Subset this data into 2D arrays representing each county (rows: industry, columns: year) 5. For the output of \#3, construct a 3D array where each layer is the next timestamp sequentially a. This represents in effect a space-time cube 6. Use the spacetime cube from \#5 to answer the following using appropriate methodology a. The total number of workers in the state per industry per given year i. Example: 2000 Maine workers in Education in 1999 (these are not the right numbers, but that's an example of what you are after) b. The average number of workers in the county per industry over the 12 year period i. Example: An average of 3000 workers in Construction in Cumberland County from 2010-2021 7. Choose a color combination ( 0 or 255 on a combination of scales). Take Cumberland County and a rural county of your choice and do the following using the data from \#4: a. Calculate the percentage of the labor force in that county by year that is in a particular industry b. Find the minimum and maximum by industry c. "Center" the field by placing it along the scale from its minimum to maximum d. Use that centered value to then shift the scale in one color dimension from 0 to 255. e. Display the colors on an array grid f. Do you notice any stark differences between the two counties? 8. Using Boolean masking, identify any industries in the space time cube from \#5 that are above the expected share of the workforce (namely, they exceed 1/14th of the workforce in their year)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started