Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #69: Web Stock Data

Computernerd
8 - Asteroid

Here is my solution

TobiasFitschen
8 - Asteroid
Spoiler
Challenge_69.png

lwolfie
11 - Bolide

Solved.  Used a different site, as the one in the starter returned an error.

dwstada
11 - Bolide

used the link provided in an earlier comment

https://datahub.io/machine-learning/mushroom/r/mushroom.csv

 

Spoiler
c69.PNG

GabrielaTudor
8 - Asteroid

You're welcome @Carolyn. I actually went through the same and had some hard time to figure it out. Eventually other people's posts helped me as well.

DaisukeTsuchiya
14 - Magnetar
Spoiler
スクリーンショット 2023-11-20 175720.png

Tgigs
8 - Asteroid

My solution attached.

 

1) used download tool to download the data from the URL

2) used text to columns tool to split data into rows

3) used text to columns tool to split data into columns

4) renamed the columns to their appropriate column names

 

Spoiler.PNG

Rob-Silk
8 - Asteroid

My solution below - I also used the shared updated URL:

 

https://datahub.io/machine-learning/mushroom/r/mushroom.csv

 

Spoiler
challenge_69_RS_screencap.PNG
Archie_bos
8 - Asteroid

here is my solution

asultanov
8 - Asteroid

Did this a horrible long way before I double checked the returned data and saw there were embedded newlines... Also reposting the correct URL because the start file isn't updated with it: https://datahub.io/machine-learning/mushroom/r/mushroom.csv