Challenge #480: Electric Vehicle Production Insights - Part 1

[AYXAcademy]

 

Hi Community members,

A solution to last week’s challenge can be found here.

This two-part challenge was submitted by Guilherme Dias, @Bennu. 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:

1. Identify the year with the largest increase and the largest decrease in total EV production compared to its previous year.
2. 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.
3. 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:

https://catalog.data.gov/dataset/electric-vehicle-population-data

Download Start File

Download Solution File

[Pilsner]

Thoroughly enjoyed this challenge. I'm sure it's possible to solve with a lot fewer tools than I used, but I got there in the end!

Spoiler

For part 2, I found that the Toyota RAV4 was the model with the longest gap, curious if anyone else finds the same, but other than that all my answers matched.


Time Taken: 00:18:32

Edit: If I connect my part two to the same filter (2010-2024) then all my answers match. I mistook part one to mean task 1, for the date range specified in the question. I've updated the screenshot above

[Kenda]

Spoiler

[DylanBell]

Spoiler

 

[PhilipMannering]

I also got a different answer to Part 2 ¯\_(ツ)_/¯

Edit: Incorrect [Model Year] filtering at the beginning :/

Spoiler

[abacon]

Agreed with @Pilsner, I definitely could have used less tools but a fun one!

Spoiler

[Louie-Horn]

Not the easiest, had to really think about this one - and used a lot of tools....

Spoiler

[JBevan89]

Spoiler

Spoiler

 
Bosh :(

[alexnajm]

Fun one! Fully support electric vehicles as the way of the future :)

Spoiler

[Bennu]

Yeah.. labor intensive but hopefully also interesting.  Wise of the Academy to break it into 2 parts.

Cheers!