Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
A solution to last week’s challenge can be found here. 
Unidentified Flying Objects – also known as UFOs are exactly what they sound like. We tend to associate them with extraterrestrial activity but many sightings are attributed to covert military activity, like trying out new planes! Whether you believe they are signs that we aren’t alone or chalk them up to rogue weather balloons, the fact remains that many people around the world report sightings every year.
This week’s challenge includes a dataset with reported sightings across the USA and a second dataset with some details around the cities. Use these datasets to create a map showing the locations of sighting from 2019, and a table with the 25 most active cities over the dataset, including the most active year for each of those cities and the number of sightings that occurred in that active year.
Solution below. I tried splitting off Hawaii and Alaska for slightly better visibility.
Report
Output
