If you’re looking to start the Mushroom for Improvement challenge on Alteryx, I’ve got you covered. This, according to trainer Ross, is a “tricky one”. So, after a false start last week, this is something I wanted to revisit. In this post, I’ll take you through step-by-step instructions on how to solve this challenge using Alteryx.

We’ll kick off with the Attribute Info data set. Here’s what you’ll need to do:

Step 1: Use the Parse tool with : as the delimiter to split the data in the “Description” field into two columns.

Step 2: Next, use the Parse tool again with , as the delimiter to split the data in the “Description” field into two rows.

Step 3: Now, use the Parse tool one more time with = as the delimiter to split the data in the “Description” field into two columns.

Step 4: Use the Data Cleansing tool to get rid of white spaces in the data. You’ll want to use the Select tool to remove any unwanted columns.

Now let’s move on to the Mushroom Data set:

Step 1: Create a Record ID by using the Record ID tool. This will help us to filter the data later on.

Step 2: Use the Transpose tool to keep the Record ID and bring all attributes into one column (sounds like a backwards step, but it’s important!)

Step 3: Use the Data Cleansing tool to get rid of any white spaces.

Now that you’ve cleaned up both data sets, it’s time to join them together! Here’s what you’ll need to do:

Step 1: Join both data sets based on the fields ‘letter’ and ‘attribute’.

Step 2: Use the Crosstab tool to bring the columns to the horizontal line.

Step 3: Use an IF statement with the Formula tool to assign “poisonous” and “edible” to values p and e, respectively.

Step 4: Join the data again on “Record ID” and drag a Browse tool to see your connected data.

You’ve solved the Mushroom for Improvement challenge on Alteryx! Admittedly there are other easier ways to do this, but for someone who is still learning the ropes, I’ve stuck with the tools we’ve just become familiar with in week 2 of the Data School. Here’s my Alteryx workflow. Remember to document your steps! 

 

 

The Data School
Author: The Data School