Challenge #224: Mushroom for Improvement

A solution to last week’s challenge can be found here. Source: https://snaped.fns.usda.gov/seasonal-produce-guide/mushrooms

This week's challenge focuses on a dataset describing mushrooms which has been encoded. In the 23 columns describing each mushroom observed, the values are represented by a single character. Use the Attribute Info table to replace the coded information with the values they represent.

challenge_224_start_file.yxzp

challenge_224_solution.yxzp

Intermediate

Data Preparation

Core

Accepted answers

All comments

johnemery

Here's my mushroom solution:

Spoiler

View my solution video here:

Spoiler

Challenge 224 Solution jemery.yxzp

Jean-Balteryx

Here is my solution !

challenge_224_workflow.yxzp

Blake

What does a mushroom car say?

Spoiler

shroom shroom!

Spoiler

Check out my video solution :

challenge_224_start_fileBH.yxzp

dsmdavid

A nice chance to use the dynamic replace. Probably not as performant as transposing, but that time is saved as it respects the order!

Spoiler

david_224.yxzp

atcodedog05

Cant wait for 225th challenge and hopefully a new badge @AYXAcademy 🙂

Spoiler

Cheers and Happy Analyzing : )🙂

challenge_224_atcodedog05_Solution.yxzp

Greg_Murray

Solution attached!

Challenge_224_solution GM.yxzp

Aaron_Harter

Fun challenge for a fun guy!

Spoiler

challenge_224_AB Data_Aaron.yxzp

patrick_digan

Spoiler

I love using the dynamic replace!

challenge_224_start_file.yxmd

jatterberry

Spoiler

challenge_224_JA_complete.yxzp

RolandSchubert

My solution.

Spoiler

challenge_224_solution_rsc.yxzp

George_Walker

mushroom goodness

challenge_224_start_file.yxmd

LordNeilLord

Spoiler

challenge_224_LNL.yxmd

phottovy

Spoiler

I feel like there has to be a better way to reorder columns after a Cross Tab tool:

challenge_224_ph_solution.yxmd

luisalfonsoperez

Here is my solution to the challenge:

Spoiler

challenge_224_workflow.yxmd

jasperlch

Spoiler

challenge_224_JL.yxmd

LittleE

There must be a more efficient route than the one I took!

Spoiler

challenge_224_LittleE.yxmd

sonyakasenkramer

Spoiler

T_Willins

Fun(gi) to look at other solutions. One more week to the next level of Everest! Enjoy the climb!

Spoiler

challenge_224_solution.yxmd

Kenda

Spoiler

224ks.yxzp

bsanders2009

This is a great example of one of those problems that conceptually is easy to pick up and a little trickier (for me at least) to solve!

Spoiler

challenge_224_finished.yxzp

TonyA

I feel like I could have done this with less tools. I did add a bit to make sure the column names matched the original format rather than forced to underlines.

Spoiler

challenge_224_TonyA.yxmd

bjkay30

A similar approach to most of the others.

Spoiler

challenge_224_Solution-BK.yxzp

ggruccio

I always think I will use find and replace, but often use join for these kinds of exercises....The 'missing' threw me for a minute!!!

Spoiler

challenge_224_gg_finish.yxzp

LHolmes

This was a great exercise in foraging for parsing tools, configurations, and formulas.

***UPDATE*** After posting my solution and browsing through others I came across one with a tool I have not used before - so decided to dig in, looked at the Alteryx embedded examples, and !POOF! a new solution. Tool reveal and updated (slightly more elegant) visual in spoiler, along with new .yxzp.

🙂

Spoiler

Workflow

Discovering the Dynamic Replace tool... so cool! Mushroom data set needs no transformation, only need to create a boolean field for the replace ([_CurrentField_]='[code field]'. Field Name Field uses the parsed field names from second input as the index, with boolean logic, to replace with description.

With alternate Dyanamic Replace solution.

challenge_224_solution_lmh.yxzp

DaisukeTsuchiya

It was fun challenge!

Spoiler

challenge_224_start_file_DT.yxzp

JustinBabbitt

Fun Challenge! Not my best documentation this time, but... I'm on vacation. 😃

challenge_224_Complete_MISSIONBI.yxzp

unknown

This is a bit of challenging for me.

Spoiler

challenge_224_start_file-Qiu.yxmd

AkimasaKajitani

My Solution.

Spoiler

challenge_224_start_file_kajitani.yxzp

szade1

Here's my solution... Bit messy but got the results.

challenge_224_Output_szade1.yxzp

grazitti_sapna

Hi , Solution to Challenge 224.

challenge_224_solution_GS.yxzp

dsmdavid

I find it's a very useful tool, and one I keep forgetting about (and not the easiest to explain in handover), so the challenges are nice change to use them 🙂

dsmdavid

@Kenda

👀

Spoiler

Interesting!

ehughes

Spoiler

1st time using dynamic replace 👍
Img 224.png

challenge_224_start_file.yxmd

sidjainudr

Here is my solution. I think the trick is to clean first, then union and join the data. Also if you know pivot functions then it would be very smooth for you.

Siddharth challenge_224 Sol.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703