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 #7: Download Data and Parse JSON

DriveMyData
7 - Meteor
Spoiler
Week 7.PNG
FabianS_dup_107
7 - Meteor

My solution to the challenge ;-)

 

 

MarMu
8 - Asteroid

 

Pretty neat challenge. Quandl is great service, loads of great data.

 

Spoiler
challenge_7_start_file_MarMu.png
MarMu
8 - Asteroid

 

Pretty neat challenge. Quandl is great service, loads of great data.

 

Spoiler
challenge_7_start_file_MarMu.png
kat
12 - Quasar
Spoiler
Challenge #7.PNG
tammybrown_tds
8 - Asteroid

My solution.  Slightly different approach than the one given, but yields the same exact results.

 

pmwillen
7 - Meteor
Spoiler
2018-08-09_16-46-02.png

This was a good one! Solution attached. 

myastarling
10 - Fireball

here's my solution. This was a great opportunity to learn how to use the Download and JSON Parse tools! I've never used them before, and I know I will need to use them in the future.

danilang
19 - Altair
19 - Altair

Similar to most.  

 

Spoiler
Process the header and data rows separately then union and dynamic rename for the columns.  Possible difference is that mine selects the header and data rows based on JSON names as opposed to positions.  Solution should tolerate adding and removing fields and records

Edit:  After looking at the later solutions, I see that most solutions use the JSON names as opposed to record positions.  No "Look at me...I'm special" badge for me today.

Nothing to see here, folks.  Move along!

Solution 7.png

 

Dan

OllieClarke
15 - Aurora
15 - Aurora

Here's my solution:

Spoiler
challenge 7.PNG