
Exploratory Data Analysis for Mercedes Benz Car Models
Last Updated on January 7, 2023 by Editorial Team
Author(s): Sarvesh Talele
Originally published on Towards AI the World’s Leading AI and Technology News and Media Company. If you are building an AI-related product or service, we invite you to consider becoming an AI sponsor. At Towards AI, we help scale AI and technology startups. Let us help you unleash your technology to the masses.
Exploratory Data Analysis on Mercedes Benz Carย Models
Analysis of Mercedes Benz Models and some additional insights which assist in making business decisions.

This article will analyze the important variables which go into determining a Mercedes Benz model automobile. The Exploratory Data Analysis of the Mercedes Benz Car Models dataset will be the focus of this article. As the name implies, EDA allows us to gain a better understanding of the data. We will study the statistical features of this data, generate visualizations, and test hypotheses throughout this stage. The article will try to answer the following questions from the dataset provided onย Kaggle.
- What is each variableโs distribution?
- Are there any noticeable outliers?
- Are the maximum and minimum values for the variables reasonable? Do you see any values that appear to beย invalid?
- The necessary statistics for analyzing a dataset visually, using python and its libraries.
- How to extract vital suggestions to address the business challenge from visuals using an in-depth analysis ofย metrics.
- Which Mercedes Benz car models are efficient based on Mileage, Miles/gallon (mpg), and prices (inย Euros)
- What are the tax ratings for each Mercedes Benz Carย model?
- Which car model would be a better choice based on fuel type andย mileage.
Step 0: Install Libraries
In this step, we will be installing the required libraries for better comprehension of our dataset. The Exploratory Data Analysis has been performed with the help of the Sweetviz library. Sweetviz is an open-source Python package that creates elegant, high-density visuals with just two lines of code to jumpstart EDA (Exploratory Data Analysis). Output is a completely self-contained HTML application.
Step 1: Import Libraries
Importing libraries that are required to analyze desired data deductions, visualizations, and implementation of data-driven decisions for generating effective businessย models.
Step 2: Read Mercedes Used Car Listingย Dataset
Step 3: Analyze Mercedes Used Car Listingย Dataset
1) An Overview of Mercedes Used Car Listing Dataset using Sweetvizย library
The sub-step incorporates a short overview of the dataset. This specifies specific visuals and statistics to swiftly comprehend data and make efficient data-driven decisions. For Overview Analysis clickย here
2) The Deduction show
This is an important step in exploratory data analysis; this step can retrieve the most innovative and intriguing deductions to make data-driven decisions.
Visualizations andย Analysis
A) Model v/s Miles perย gallon

Insights
The objective of using the mean of all data is to show the overall performance of automobile models in terms of miles per gallon. We may derive the following assertions from the data provided:
- There are about 15 automobile models that get higher miles per gallon than theย average.
- In terms of miles per gallon, the E-class vehicle outperforms the G-class model by more than 5.4ย percent.
- When the miles/gallon mean value is greater, the automobile can drive further than when the mean value isย lower.
- It may also be deduced that the Mercedes automobile models which are above average values, emit less carbon dioxide when compared to otherย models.
B) Model v/sย Mileage

Insights
- According to the median of the statistics, more than 11 Mercedes model automobiles had better mileage performance.
- However, when compared to the median value of our data, the Mercedes CLK model has approximately 12.51% higher miles, and altogether, the CLK model delivers 15.67% more mileage to theย dataset.
- Subsequently, the overall fuel consumption of the CLK model is 3265.30 gallons at 33.6 miles perย gallon.
- Hence, we can deduce that car models with higher mpg values have the following applications.
- Fuel consumption isย reduced.
- Lower Maintenance Costs
C) Model v/sย Price

D) Year v/sย Price

Insights
- The price graph follows the trend line y = 1.3 + 2.5x ( x $10โธ$).
The Least Square Method was used to estimate the trend line. This approach may be used to forecast future prices and provide a quick overview of historical sales as well as development opportunities. - The slope of the trend line is (m) = 2.5. With a positive slope, sales are growing from left toย right.
- From left to right, sales are growing. However, a price reduction from 2019 to 2020 has a greater influence on company profit margins, since sales of motor manufacturers were halted owing to the pandemic, resulting in a price drop.
(Mercedes stocks are owned by Daimlerย AG) - The firm was in a loss of -2.53 % with a volume of 13M to 24M during the severe pandemic, i.e., from 10th January 2020 to 6th Novemberย 2020.
E) Mileage v/s Transmission

Insights
- Manual Transmission has the most mileage of the three most recent transmission systems when compared to the other transmission systems.
- Manual transmissions include more gears and a simpler design, resulting in a lighter transmission system.
- A simpler design decreases the carโs annual fuel consumption and, as a result, the cost of maintenance.
2. The other category may include the following transmission systems (these are some of the examples of transmission systems)
- Tiptronic Transmission: A Tiptronic is a type of automatic transmission that allows for fully automatic gear shifting or manual gear shifting by the driver. Tiptronic uses a torque converter rather than aย clutch.
- Dual Clutch Transmission (DCT): A dual-clutch transmission has two gear shafts with a clutch for each. The dual system allows for faster and smoother gearย changes.
F) Model v/sย Tax

Insights
Road Tax Description:
- It is a tax that must be paid by anybody who purchases a car. The Road Tax is a state-level tax, meaning that it is imposed at the state level by the governments of severalย states.
- For charging road taxes, each state has its own set of rules and regulations. The amount of tax varies due to the varied percentages charged by different states. According to the Central Motor Vehicles Act, if a vehicle is operated for more than a year, the entire amount of road tax must be paid atย once.
- Individuals purchasing a vehicle pay the road tax which is based on the ex-showroom price of the vehicle. The calculation of road tax depends on the following things:
a. Seating capacity of the vehicle
b. The engine capacity of the vehicle
c. Age of the vehicle
d. Weight of the Vehicle
Note: This is according to Indian Rules and Regulations
Analysis
- Although the Mercedes C class has more advanced built-in technology, making the C class interface more user-friendly, it has a far higher road tax than the Mercedes A-class, by 9.29ย percent.
- When it comes to miles per gallon and price, an A-class vehicle would be a better choice than a C-classย model.
G) Fuel-type v/sย Mileage

Insights
- For long-distance travel, diesel engines are recommended. For those who are Hodophile, Mercedes automobile models with Diesel engines have a 79 percent probability of being their first preference.
- Diesel engines are limited for vehicles that have a high frequency of travel, such as trucks, buses, and off-road vehicles, despite having higher efficiency and lower costs than petroleum. Because of the increased greenhouse gases, diesel engines are limited for vehicles that have a high frequency of travel, such as trucks, buses, and off-road vehicles.
Conclusion
The deduction and statistical analysis were determined with the full consideration of metrics of Mercedes Model cars using the dataset. The notebook has explored Transmission, Miles/gallon, Mileage, and road tax metrics for better comprehension of ourย dataset.
- For those who want to buy a car for travel or daily use, the miles per gallon number should be greater than 30ย mpg.
- Mileage is another element that influences a vehicleโs fuel usage. The cost of maintaining a car is determined by itsย mileage.
- Manual transmissions have more gears and a simpler design, making themย lighter.
- Diesel engines are restricted for vehicles that travel often, such as trucks, buses, and off-road vehicles, due to higher greenhouse gas emissions
Social Accounts:
Exploratory Data Analysis for Mercedes Benz Car Models was originally published in Towards AI on Medium, where people are continuing the conversation by highlighting and responding to this story.
Join thousands of data leaders on the AI newsletter. Itโs free, we donโt spam, and we never share your email address. Keep up to date with the latest work in AI. From research to projects and ideas. If you are building an AI startup, an AI-related product, or a service, we invite you to consider becoming aย sponsor.
Published via Towards AI