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
