The solution to last week's challenge can be found here.
How much could a woodchuck chuck if a woodchuck could chuck wood?
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.
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.
There is an error in one of the rows within the Burrow Input Text data.
The row doesn't add up to 100 %. Also, what does the Cubit Foot Dried (lbs) mean exactly?
Does this mean lbs per cubic foot? or ft^3 per pound (lb)?
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%
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.
I got rid of the % by changing the field to Double.