Exercise Info
- Application (Classic vs Data Prep Studio): Data Prep Studio
- Level of Difficulty (Beginner, Intermediate, Advanced): Beginner
- Skills/Features Tested: Merge Columns, Show Statistics, Filter, GroupBy, Pivot, Duplicate
- Systems of Record: Not Applicable
- Estimated Time to Solve: 10 mins
- Exercise files required are attached
- Electric_Vehicle_Population_Data.xlsx
Exercise Overview
You are a Research Analyst at an Automotive OEM (Original Equipment Manufacturer; FORD, TOYOTA, BMW etc) and your Manager has asked you to analyze a sample data set of Electric Vehicle Population in Washington State, to answer the following questions:
- What Make & Model is the Most Popular?
- What Make & Model is the Least Popular?
- How many cars across all the OEMs fall into these two categories for Clean Alternative Fuel Vehicle Eligibility?
- Clean Alternative Fuel Vehicle Eligible
- Not eligible due to low battery range
Exercise Answer
Not sure you got the correct answer? No problem. Watch the video below for a demonstration of this exercise from start to finish.