A solution to last week’s challenge can be found here.
To solve this week’s challenge, use Designer Desktop.
This challenge comes to us from @Pawel_Paleczny
. Thank you for your contribution.
Let’s take some data from the FIFA World Cup that took place in Qatar and perform analyses on the location.
The dataset contains information about the stadiums: stadium name, city, capacity, latitude, and longitude.
For this challenge:
1. Find all the host cities of the World Cup on the map.
2. Rank the distance of the stadiums starting from the farthest from Doha, the capital of Qatar. The distance should be measured in miles. For the geographic data of the stadiums, let's use the geographic coordinates of the cities.
Data Source: https://www.kaggle.com/datasets/palecznypawel/worldcup2022-fixture