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!
Electric vehicle (EV) production data offers powerful insights into innovation, market trends, and manufacturer behavior. As researchers dig into the data, your task is to help uncover major production shifts and unique behaviors in EV model lifecycles.
For part 1 of this challenge, your analysis should only include data from 2010 to 2024. Exclude data from the year 2025, as it contains only partial records. Here are the three tasks you need to accomplish:
- Identify the year with the largest increase and the largest decrease in total EV production compared to its previous year.
- Find the top 3 EV models that had the longest production pause (in years) before resuming production again. Only consider models that had a production gap followed by a confirmed comeback.
- In the most recent full year of data, determine which manufacturer introduced the most units of never-before-seen models. Ensure that your logic dynamically adjusts to the latest year, without hardcoded values.
You are provided with one dataset:
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.
Stay tuned for part two of this challenge!
Good Luck!
The Academy Team
Source:
