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
Hello, Community Members!
A solution to last week’s challenge can be found here.
This challenge was submitted by Patrick Digan (@patrick_digan). Thank you, Patrick, for yet another excellent contribution!
You are provided with a folder (Cryptocurrency_Datasets.zip) of 24 monthly files (formatted as InputDataByMonthYYYYMM) containing data related to bitcoin mining and its environmental impact—specifically carbon emissions (CO2) and energy consumption (kWh).
Each file includes a Date field (YYYYMMDD) along with four concatenated columns in the DownloadData field: 24hr_kWh, 24hr_kgCO2, Output_kWh, and Output_kgCO2.
For each of the 24 months, calculate the average for the 24-hour power consumption (24hr_kWh column) and CO2 emissions (24hr_kgCO2 column). Using these averages, find the median for both fields.
Hint: If you use Regex, your numbers may vary slightly. Alternatively, use the Parse JSON tool for this type of data in a name/value pair format, similar to JavaScript.
Need a refresher? Review the following lessons in Academy to gear up:
Happy solving!
The Academy Team
I had fun with this one! I didn't do any fancy parsing and I struggled with the datetime functions, so had to use two datetime tools in a row instead of a formula tool. Oh well. Still pleased with knocking it out this Monday morning!
Thank you, Patrick, this was fun. I am still exploring Parse JSON tool, so this was a good practice for me.
