Challenge #160: Diamonds R Forever

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

Happiest of birthdays to those of you born in the month of April! Did you know that the diamond is this month's birthstone? To celebrate, analyze a dataset to count the number of diamonds that fall within a range of carat weights.

The zip file below contains the file BigDiamonds.rda. Use the R tool to read in the data to use in Designer. You may find this article helpful for this challenge!

Note: Make sure you have your Predictive tools installed!

Happy Birthday from the shiniest of diamonds...Neil Diamond.

BigDiamonds.zip

challenge_160_start_file.yxmd

challenge_160_solution.yxmd

Join

Preparation

Data Preparation

Transform

Predictive

Difficult

Accepted answers

All comments

patrick_digan

Spoiler

unzip("%Engine.WorkflowDirectory%BigDiamonds.zip", exdir="%Engine.WorkflowDirectory%Data")
load("%Engine.WorkflowDirectory%Data\\BigDiamonds.Rda")
write.Alteryx(diamondsbig,1)

challenge_160_start_file.yxmd

pasccout

Took me some time to figure out how to read the actual content of the output and not just the name of the file but here it is!

challenge_160_my_solution.yxmd

nwhaley

Spoiler

Solution attached. Also quickly explored how avg. price varies between certification agencies...wow.

challenge_160_nwhaley.yxmd

philipmannering

I'm forever the R-soul.

Spoiler

challenge_160_start_file.yxzp

kat

Challenging!

Spoiler

Challenge #160.yxmd

estherb47

The R tool was very frustrating, until I realized that my slashes were in the wrong direction. User error strikes again!

Then just wanted to group the carats like I found in the diamond charts, so my formula tool differs a bit from others

Not entirely sure I understand what I did with the R tool, other than get it to function, so something new to learn just dropped!!!

challenge_160_EHB_completed.yxmd

RolandSchubert

First-time used the R tool and finally managed to bring the data to the workflow. Afterwards it seems easy and straightforward ...

challenge_160_solution_rsc.yxmd

danilang

24 diamonds above 8 carats. Sweet Caroline, indeed!

Spoiler

Dan

challenge_160_solution_dl.yxmd

cgoodman

Spoiler

challenge_160_solution.yxmd

sprodger

my solution:

Spoiler

challenge_159_solution_SP.yxmd

mpennington

Wanted to try and join a lookup table to work like an approximate VLOOKUP, but struggled with it. Ended up with a formula based solution, but definitely curious if anyone finds a way to accomplish it via a similar method.

Spoiler

Challenge 160 MP.yxmd

RichoBsJ

Hi! Here my solution

challenge_160_richobsj.yxmd

cplewis90

Fun challenge! I have used the R tool with an input tool, but not without an input.

Spoiler

The R code I used (I had already unzipped the file):
load("C:/Users/Christopher.Lewis/Save Location/Alteryx Challenges/Big Diamonds/BigDiamonds.Rda")
write.Alteryx(diamondsbig, 1)

challenge_160_CL.yxmd

T_Willins

Took a little bit of time to read and comprehend the link to using the R tool. Learning R and Python coding are on my list.

Spoiler

challenge_160_solution.yxmd

Verakso

I got to show this to the wife, since she is a gemologist and diamond grader 😊

It took me some serious time to solve this one.
Struggled with the reading of the rda file, seem I was not the only one who quite didn't get how to use slashes properly.

Second was the grouping. At first I hadn't seen the provided Output, so I just went for the quick and easy Smart Tile.
But just before I was to submit the answer I noticed the Output, and found out, that it was not that easy after all 😉

Spoiler

After I did manage to read the data, I could the use the formula tool to create the Range, and the group on that and count on carats

The WorkflowBut here is a small tip (if you did not know this already)

In order to save some time, and avoid to read the data from the rda file, every time the workflow is run, then I simply added a Select tool and choose »Cache and Run Workflow«

Cache and Run Worklow
The on all the subsequent runs, the workflow would run a little bit faster 😉

Use the Cache

Still Climbing

/Verakso

challenge_160_verakso_solution.yxmd

Tanyamin

It was fun to learn the R tool

challenge_160_start_TanyaMinn.yxmd

ggruccio

Can't skip this one since I'm in the jewelry industry!

challenge_160_gg_finish.yxmd

Reesetrain2

My submission!

Challenge_160_Matt_Reese.yxzp

kelly_gilbert

Had to dust off some long-unused R syntax for this one!

Spoiler

It would have been much easier to perform the grouping/counting in Alteryx, but I wanted to challenge myself to do it all within R!

challenge_160_solution_klg.yxmd

JosephSerpis

Challenge Completed

challenge_160_Joe_Serpis.yxmd

NicoleJohnson

One tool solution!!!

Spoiler

Took me a while to find the right code (thank you once again, StackOverflow!!), but I managed to find my solution using only the R tool, rather than just loading the data and then using regular Alteryx tools.

Definitely not the most intuitive programming language to dive headfirst into (having had exactly 1 experience in Python and 1 in R, I'd currently vote for Python... though clearly this sample size is lacking haha), but it at least started making more sense by the end.

Note: Thanks to @patrick_digan for unwittingly helping with my solution - I definitely took a shortcut and just "borrowed" your logic for determining the lower & upper bounds of each carat range

Cheers!

challenge_160_NicoleJohnson.yxmd

jasperlch

Solution attached

challenge_160_JL.yxmd

Kenda

Spoiler

Got tripped up and couldn't figure out why my R tool wouldn't bring in the data. Turned out being something super simple again.. I was using backslashes when the tool needed forward slashes!

challenge_160_start_file.yxmd

jamielaird

Here's my solution

Spoiler

challenge_160_solution_JL.yxmd

KaleyVolk1

Still pretty new at this so it took a minute to figure out the R tool

Spoiler

challenge_160_solution_KV.yxmd

KevinH1992

Spoiler

Fun little challenge with some R.

challenge_160_start_file.yxmd

LordNeilLord

Spoiler

challenge_160_LNL.yxmd

RWvanLeeuwen

any tips on how to make this file path relative to the workflow would be appreciated

Spoiler

challenge_160_start_file - RWvL.yxmd

TimHuff

Fun challenge! My solution attached.

Spoiler

challenge_160_start_file.yxmd

ZenonH

I had some fun learning about how diamonds are graded/priced, as well as learning about some of the rarest/most expensive diamonds. I tried to build a regression model to predict the prices of the diamonds missing that value, but couldn't quite get things working. To feel accomplished I figured out how many Paragon diamonds we could make by 'gluing' the diamonds in the list together (4648.5) shame it doesn't work that way in real life : P😛

Spoiler

challenge_160_ZH_SOL_FailedPredictions.yxmd

SeanAdams

Nice to use these R Functions

Spoiler

challenge_160_SeanAdams_Solution.yxmd

TimothyManning

Spoiler

Seems to have been the same problem others were having trying to just pull the data in! I'm glad I've done this challenge though as I learned a tiny bit about R. Thanks to your spoiler @patrick_digan, I realised I was missing the load function and from then on it was easy enough

160. Data Analysis.yxzp

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703