community
cancel
Showing results for 
Search instead for 
Did you mean: 

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #160: Diamonds R Forever

Asteroid

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
ZHSOL.PNG

  

Nebula
Nebula

Nice to use these R Functions

 

Spoiler
Flow.pngRCode.png
Alteryx Partner
Spoiler
160. Data Analysis.PNG
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
Alteryx
Alteryx

Here's my solution.

Asteroid

Nice challenge! Surprisingly I got quite stuck on the analysis part as many values were dropping out of my joins...

 

Spoiler
image.png
Alteryx Certified Partner

Definitely not the most efficient solution, but it's solved!

 

Spoiler
Challenge 160.PNG

 

 

Alteryx Partner

Always struggle with R

Spoiler
Challenge 160.png
Alteryx Partner
Spoiler
キャプチャ.JPG

Thought that Tile Tool is the fastest and simplest method for this until I checked some other answers and learned the Cell function and Floor function. 

Alteryx Certified Partner

My solution

 

Spoiler
challenge_160.PNG
Asteroid
Spoiler
2020-01-05 13_03_22-Greenshot.pngInteresting there's no range for 8.26-8.75 carat diamonds