Question No$.3$: Data Summaries and Visualization

For this question, the provided dataset contains information about cars sold through dubizzle in April $2024.$ Each data row$/$observation represents a car being sold. Since this is real data, all elements about customer identification were deleted due to privacy concerns. Descriptions for the data attributes are shown in the table below.

You are required to load the data into Python and answer the following items:

a$.$ How many attributes and observations are there in the provided dataset?

b$.$ Construct a pie chart based on the car brand. Which brand has the most sold cars?

c$.$ Calculate the mean and the five$-$number summary of the car prices.

d$.$ Build a bar chart for the car fuel type. Which fuel types have the highest and lowest number of cars?

e$.$ Plot a histogram of the car prices. Describe the histogram.

f$.$ Construct a box plot of the car age. Are there outliers?

g$.$ Filter the data for the "Toyota" brand, then show a bar plot of the seller type.

h$.$ Filter the data for the "Nissan" brand, then construct a pie chart for the seating capacity. What is the seating capacity of the most sold Nissan cars?

i$.$ Show a heatmap of correlations between numerical variables present in the data. Are there any significant correlations? Explain.

Hint: For importing a sheet from an excel file in pandas, use the following syntax:

$df=$

pd$.$read$\_$excel$(\text{'}$filename$.$xlsx$\text{'},$'sheetname'$)$

$\backslash$table$[[$Attribute$,$Type,Description$],[$price$,$Numeric,The price of the car was sold at$.],[$brand$,$Categorical,The car brand.$],[$model$,$Categorical,The car model.$],[$trim$,$Categorical,The specific trim of the car model.$],[$kilometers$,$Numeric,The car mileage.$],[$year$,$Numeric,The year the car was manufactured.$],[$vehicle$\_$age$\_$years,Numeric,The car age.$],[$regional$\_$specs,Categorical,The car regional specification.$],[$doors$,$Categorical,The number of doors in the car.$],[$body$\_$type,Categorical,The car body type.$],[$fuel$\_$type,Categorical,The type of fuel used by the car.$],[$seating$\_$capacity,Numeric,The number of passengers the car can accommodate.$],[$transmission$\_$type,Categorical,The type of car transmission $($automatic or manual$).],[$engine$\_$capacity$\_$cc$,$Categorical,The engine capacity $($if information is available$).],[$horsepower$,$Categorical,The range of horsepower for the car.$],[$no$\_$of$\_$cylinders,Numeric,The number of cylinders in the car engine.$],[$exterior$\_$color,Categorical,The color of the car body.$],[$interior$\_$color,Categorical,The color of the car interior.$],[$warranty$,$Categorical,The car warranty type.$],[$city$,$Categorical,The car location by city.$],[$area$\_$name,Categorical,The car location by area in a city.$],[$seller$\_$type,Categorical,The type of seller through which the car was sold.$]]$

PLEASE CREATE THE DATA FILE WITH CODE INPUT AND OUTPUT DONT USE CHATGPT PLEASE