Challenge #422: Investigating Historical Temperature Records

[AYXAcademy]

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:

1. Determine which cities have average temperatures greater than or equal to 25 degrees.
2. Among the cities identified in the previous task, identify the country with the highest number of such cities.
3. 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!

[mmontgomery]

C422

Spoiler

[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

[RolandSchubert]

Spoiler

[aatalai]

C422

[JAKupchik]

Attached is my proposed solution.  Thanks!  JAK

[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.

[alacoume]

My solution

Spoiler

 

[AkimasaKajitani]

My Solution!! 

Spoiler