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
Hi Community members,
A solution to last week’s challenge can be found here.
This two-part challenge was submitted by Guilherme Dias, @3I_ATLAS. Thank you, Guilherme, for your great submission!
In the previous challenge, you have already identified critical production trends and model behaviors for electric vehicles. Now, shift your focus to innovation and decline — two sides of product lifecycle in the EV industry.
In the second part of this challenge, you analyze which years saw surges of new model launches and which saw waves of production extinction.
Reminder: Only include years from 2010 to 2024 in your analysis, as 2025 data is incomplete.
Here are the two tasks you need to accomplish:
- Determine which two years had the most distinct new models launched and from which brands were these models launched.
- Identify the year with the highest number of distinct models that stopped being produced, relative to the prior year. Count each model that was produced in year Y but not in year Y+1 as “extinct,” even if it returns in later years.
You are provided with one dataset (the same dataset from part 1 of this challenge):
Electric Vehicle Data – provides the model year, manufacturer (brand) and car model.
Once you have completed your challenge, include your solution file and a screenshot of your workflow as attachments to your comment.
Good Luck!
The Academy Team
Source:
https://catalog.data.gov/dataset/electric-vehicle-population-data
The new ranking tools are very handy, eliminate the need for Record IDs and Multi-row formulas to rank the data.
