Hi Maveryx, A solution to last week’s challenge can be found here. In this week’s challenge, you want to uncover key statistics about countries that use nuclear power. However, the data files you were provided are raw and unprepared. Your goal is to clean them up and then answer the following questions: * Which country experienced the most significant decrease in nuclear capacity from one noted year to the next adjacent noted year? * Which country saw the most significant drop in nuclear units from 1995 to 2022? * Which country has the highest average percentage use of nuclear power? Data source: https://www.iaea.org/publications/15485/nuclear-power-reactors-in-the-world Good luck! Challenge_439_start_file.yxzp Challenge_439_solution_file.yxzp

Spoiler Challenge_439_EHB_completed.yxzp

bonsoir; cette fois-ci je suis complètement coincée avec la tool Sélectionner des enregistrements ou Select Records Tool, je ne peux pas avancer, désolée 🙏

I think Question 1 is not phrased correctly -- the answer shown is the greatest INCREASE, not the greatest decrease. Anyway, here's mine! Challenge_439_solution.yxzp

Challenge #439: Nuclear Power Around the World

AYXAcademy

Hi Maveryx,

A solution to last week’s challenge can be found here.

In this week’s challenge, you want to uncover key statistics about countries that use nuclear power. However, the data files you were provided are raw and unprepared. Your goal is to clean them up and then answer the following questions:

Which country experienced the most significant decrease in nuclear capacity from one noted year to the next adjacent noted year?

Which country saw the most significant drop in nuclear units from 1995 to 2022?
Which country has the highest average percentage use of nuclear power?

Data source: https://www.iaea.org/publications/15485/nuclear-power-reactors-in-the-world

Good luck!

Challenge_439_start_file.yxzp

Challenge_439_solution_file.yxzp

Core

Basic

Data Cleansing

Accepted answers

All comments

mmontgomery

C439

Spoiler

Wasn't able to match Q3 answer but will keep looking to see if I'm missing something

c439.yxzp

Kenda

Spoiler

I also got an answer that varied for part 3. Also, it looks like "TOTAL" was included instead of Argentina in the provided solution

Challenge_439_ks.yxzp

olga_strubbe

This was a tricky one. I liked the solution offered by @mmontgomery using 'Arrange' tool. I tried to use other data wrangling but concluded the 'Arrange' tool did a better job in re-arranging the data. Thank you, @mmontgomery for the tip on this!

Please note I've excluded 'Total' rows from the 'Country' field - my result is, therefore, slightly different as I am only comparing countries themselves.

Challenge 439_OS.yxmd

TurboToad

Noticed some issues with the provided output but think I got the idea.

Spoiler

TT_Challenge_439_solution_file.yxzp

Qiu

I have excluded the "TOTAL" from result and the data for "Argentina" is missing in all 3 questions in the provided solution.

Spoiler

Challenge_439_start_file-Qiu.yxzp

halithe

439

Challenge_439_solution_file.yxzp

イアン

Not the most elegant solution, but it works 😶

Spoiler

Challenge_439_start_file.yxmd

ed_hayter

Spoiler

Not particularly pretty (although should be dynamic to changing source files) could also have put it in a macro if i wasn't trying to complete as quickly as possible. Noticed some weirdness in the expected outputs like including total in a country analysis output. I cannot understand Belarus' most significant capacity decrease being the only capacity value its ever reported this is not a decrease.

Challenge_439_start_file.yxzp

RolandSchubert

Spoiler

Challenge_439_solution_rsc.yxzp

DaisukeTsuchiya

I got the different answer for Q3.

Spoiler

Challenge_439_start_file_DT.yxmd

Tofel

I think I played a bit too much trying to dynamically assign columns.

Also I noticed couple of issues with outputs:

Task 1 - The question is on most significant decrease, but output shows increase.

Task 2 - 'TOTAL' is included as a country

Task 3 - I do not think you can average the percentage. Average of 10% of 1000 and 20% of 100 is not 15%.

Spoiler

Challenge_439_Dom.yxzp

AkimasaKajitani

My solution. Actually, I think the Arrange tool is better solution. But I go to another way at this time.

Spoiler

And also some answer are not the same.

Challenge_439_start_file_AK.yxzp

AYXAcademy

Good catch, @Qiu ! We'll update the results to include Argentina. Thanks for your feedback.

BSilverblatt

Thanks for the challenge! Here's my solution:

Challenge 439_BS.yxzp

balajilolla2

Spoiler

Solution Attached
Screenshot 2024-08-27 083942.jpg

Challenge_439_start_file.yxmd

ggruccio

A bit less efficient than I usually like to build! As others as mentioned, I wasn't able to tie to the expected answer for #3 exactly.

Spoiler

Challenge_439_gg_finish.yxzp

ARussell34

It took some practice with the Arrange tool to organize, but eventually found the solution!

AR_Challenge439_sol.yxmd

Caramel8

2024-08-27 16_35_17-Alteryx Designer x64 - Challenge_439_start_file.yxmd_.png

Challenge_439_solution.yxmd

Yoshiro_Fujimori

My solution.

Spoiler

Comment
Overall: As the question is to find "the most" "the highest" country, I picked one record as an answer for each question.
Q1: "most significant decrease" does not match the expected result. It is "most significant increase".
Q3: The average value does not match with the expected result. Some special rounding is applied?

Workflow for cleansing

Workflow for analysis

Challenge_439_YFujimori.yxzp

aatalai

C439

aatalaiChallenge_439_solution.yxzp

alacoume

A solution

Challenge_439_start_file.yxmd

kapil_cgi

For Question 3, I am getting slight mismatch due to the precision .

sol439.yxmd

wbasuki

Here is my solution.

There is something weird in the output of the start file, Argentina is missing and Total is listed under n the country column.

Spoiler

VMOULIN

My Solution

Challenge_439_VMO.yxzp

RashedDS

First, I arranged the data in the proper datasheet and then worked on the tasks.

Arranged data- MWe.JPG

Arranged data- Total.JPG

Challenge_439_RashedDS.yxzp

Reesetrain2

All,

My solution!

Spoiler

Challenge_439_Reesetrain2.yxzp

ahsanaali

Spoiler

Challenge_439_Solution_AAA.yxmd

lauramaestuvazquez

Not great in terms of performance, as it is redundant and deviates from my usual builds. However, I currently stand by this solution and will explore alternatives to enhance it and learn from others