Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Database Management Systems

Authors: Mark L. Gillenson

2nd Edition

0470624701, 978-0470624708

More Books

Students also viewed these Databases questions

Question

What are Decision Trees?

Answered: 1 week ago

Question

What is meant by the Term Glass Ceiling?

Answered: 1 week ago