Challenge #285: Around the world

[AYXAcademy]

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

This data set provides information that includes rankings and scorings of countries based on happiness, economy, health, family, freedom, generosity, etc. The countries are also categorized into 10 regions.

For this challenge, your goal is to find for each region:
- The country ranking the best for happiness
- And the country with the highest-scoring for Health (Life Expectancy)

Then create two reports (tables) to showcase your findings. Each report must include the country, region, and rank or scoring.

*The start file was updated to correct an error on 9/14/2021.

[Aaron_Harter]

great challenge!

Spoiler

[Kenda]

Spoiler

I think the answer provided may have the healthiest countries a little backwards...

[AkimasaKajitani]

My solution.

Spoiler

But the sample output is strange.
Is the lower value of Life Expectancy higher score?

[Blake]

Demonstrated 2 methods for finding the first in the list. 

Spoiler

Summarize and Sample

[DaisukeTsuchiya]

The results of 2nd Output becomes different. 

Spoiler

 

 

2nd Outputs shows worst10 not top10. It should be below.  

[clmc9601]

Thanks for the challenge!

Seems to me that finding lowest "Health" score is not necessarily the "highest-scoring". See spoiler for more details.

Spoiler

@AYXAcademy this column according to the Kaggle dataset is how Health contributes to Happiness. That could be good or bad. Furthermore, if it were a health score, wouldn't higher be better? Looks like the answers were calculated sorting by Health ascending.

Spoiler

[RolandSchubert]

My solution

Spoiler

[DeanWest]

Happy to start off the week with this challenge!

Spoiler

[JasonHu]

Here is my submission.

Spoiler