community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

Challenge #178: Chuck Like a Woodchuck

Meteor

The solution to last week's challenge can be found here.

 

How much could a woodchuck chuck if a woodchuck could chuck wood?woodchuck.gif

 

Today we are ready to answer an age-old question that has been left unanswered: How much could a woodchuck chuck if a woodchuck could chuck wood?

 

To best calculate this, we need to make the following assumptions:
1. First off, a point of clarification that woodchucks do not chuck wood. But what if a woodchuck could chuck wood? As a burrowing creature, the best information we have is to understand the amount of soil excavated during burrowing. We can use the weight of soil excavated to equate it to the weight of wood.
2. All soil is not created equal. Per cubic foot of type of soil, moisture, density and make-up can vary.
3. All wood is not created equal; density of wood can largely affect the cubic foot weight.

 

The challenge:
1. We have provided a sampling of three different woodchuck burrows excavated over a 7 day period. Within a burrow there can be rooms and tunnels that makeup a burrow. Dimensions of the rooms and tunnels have been provided in addition to the soil composition of the excavation site. Using this data set, determine the cubic feet of soil excavated and, ultimately the weight of soil excavated from each burrow.
2. Take the average weight of soil 'chucked' from each burrow.
3. From the average weight of wood across 10 tree species, figure out how many cubic feet of wood would have been chucked if a woodchuck could chuck the wood.

Spoiler
Annotation 2019-08-26 124836.jpg
Meteor

There is an error in one of the rows within the Burrow Input Text data. 

clipboard_image_0.png

The row doesn't add up to 100 %. Also, what does the Cubit Foot Dried (lbs) mean exactly?

clipboard_image_1.png

Does this mean lbs per cubic foot? or ft^3 per pound (lb)?

 

 

Quasar

Fun one!

 

Spoiler
Capture.JPG
Asteroid

I also noticed that error not matching 100% that @LifebloomX mentioned.

 

I used Regex to parse out the two fields--(Soil & Percent), but the following line always came out with extra spaces; I ended up using an extra data cleansing tool to get rid of the trailing space.

 

I love Regex tool, but sometimes it makes me struggle.

Sand, wet - 90%

\s*(.*)\s{1,2}-\s(\d{2})%

 

Spoiler
2019-08-26_10-21-54.jpg

 

 

Comet

I also saw the less than 100% error.  Data collection workflow needs validations built in?  Now if a woodchuck sells seashells to make batter bitter was he fuzzy?

 

Spoiler
Workflow 178.GIF

 

 

 

Alteryx Certified Partner

 

Spoiler
26-08-_2019_19-30-29.png
Meteor

I also didn't like the fact that we are told to take the average of the wood without knowing the ratio of the wood woodchucks use. The ratio of wood should've been provided just like the soil.

 

Spoiler
clipboard_image_0.png

I got rid of the % by changing the field to Double.

Asteroid
Spoiler
178.PNG
Asteroid

My Solution! groundhog.jpg

Spoiler
Challenge_178_Spoiler.JPG