Hi Maveryx, A solution to last week’s challenge can be found here. In April, we celebrate Earth Month, a time dedicated to raising awareness and taking action for environmental conservation and sustainability. This weekly challenge delves into temperatures, highlighting their crucial role in our planet's health. The dataset presents comprehensive information on global temperature records, covering various countries worldwide. It includes average temperature records in Celsius for major cities from 1743 to 2013. To solve this challenge, we will be concentrating on the data from 1950 onwards. Your tasks are as follows: * Determine which cities have average temperatures greater than or equal to 25 degrees. * Among the cities identified in the previous task, identify the country with the highest number of such cities. * Examining all countries within the dataset, pinpoint the year with the highest average temperature and the year with the lowest average temperature across the globe. Need a refresher? Review these lessons in Academy to gear up: * Sorting Data * Separating Data into Columns and Rows * Summarizing Data Source: https://www.kaggle.com/datasets/maso0dahmed/global-temperature-records-1850-2022 Good luck! Challenge_422_start_file.yxzp Challenge_422_solution_file.yxzp

Spoiler Challenge_422_solutionJY.yxmd

Challenge #422: Investigating Historical Temperature Records

Hi Maveryx,

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

In April, we celebrate Earth Month, a time dedicated to raising awareness and taking action for environmental conservation and sustainability.

This weekly challenge delves into temperatures, highlighting their crucial role in our planet's health. The dataset presents comprehensive information on global temperature records, covering various countries worldwide. It includes average temperature records in Celsius for major cities from 1743 to 2013.

To solve this challenge, we will be concentrating on the data from 1950 onwards.

Your tasks are as follows:

Determine which cities have average temperatures greater than or equal to 25 degrees.
Among the cities identified in the previous task, identify the country with the highest number of such cities.
Examining all countries within the dataset, pinpoint the year with the highest average temperature and the year with the lowest average temperature across the globe.

Need a refresher? Review these lessons in Academy to gear up:

Source: https://www.kaggle.com/datasets/maso0dahmed/global-temperature-records-1850-2022

Good luck!

AYX-Maveryx_Micro Identity-Maveryx Academy_wordmark.png

Challenge_422_start_file.yxzp

Challenge_422_solution_file.yxzp

Data Analysis

Core

Basic

Accepted answers

All comments

mmontgomery

C422

Spoiler

c422.yxzp

bgreedy

Got a bit confused with some of the wording, took me a minute to realize it wanted data from after 1950, not data from 1950 only 😖

Spoiler

Challenge_422_BG.yxmd

RolandSchubert

Spoiler

Challenge_422_solution_rsc.yxmd

aatalai

C422

aatalaiChallenge_422_solution.yxzp

JAKupchik

Attached is my proposed solution. Thanks! JAK

422_JAK_Solution.yxzp

JAKupchik

I interpreted it the same way, i.e. literally 1950, and made my solution accordingly.

jeprime

I noticed a few things in the solutions provided:
1) in the solution for cities equal to or greater than 25 C, the column title included one of the cities and it's avg. temps. I corrected this.
2) in the solution for years with max and min temperatures, it fails to show the year for the minimum temperature year. I corrected this.

This was a good challenge.