Project_CarDekho-Data-Analysis

Python Project

• Project Name : Data Analysis of Used Cars from CarDekho

• Table of Content: 1] Reason to take this DataSet, 2] Workdone, 3]Conclusion, 4]Result.

• Reasons to use this Data Set:

1. The auto industry is changing rapidly and car prices are only going up. So to speak, new cars are getting costlier each year, making them a very high value purchase for the common man. And quite ironically, the average life span of a car is going down despite the steady rise in prices, which brings in good news for potential used car buyers.
2. In 2018-19, while new car sales were recorded at 3.6 million units, 4 million second-hand cars were bought and sold, according to a recent report on India’s pre-owned car market by IndianBlueBook, a used car pricing guide by Mahindra First Choice Wheels. In many cases, a three-year-old vehicle is as good as a new one, which encourages the buyer to go for a used car.
3. As coming to Indian economy 6.7% people are under poverty ratio and they cant afford to buy new cars as this data can give idea or knowledge to the people about which car brand and car models is suitable to them.

• Workdone:

1. Reading & cleaning of data and formatting it properly.
2. Finding the total count of brand which brand has more demand in resale market.
3. How many cars have been sold respected to their brand.
4. Which are the top five used car sold in the market and how many units are sold
5. How many car has been sold with respect to fuel type.
6. How many seller type are selling car in CarDekho.
7. Comparing the selling price of car with respect to its actual cost and vehicle age .
8. Which cars has maximum and minimum mileage.
9. Which car is best in seating range.
10. How many cars have been sold according to its age.
11. Plotting graph using Seaborn.
12. Finding top used cars which is 4 years old.
13. Searching cars, budget from 10 thousand to 9 lakhs .
14. Overall view of cars in CarDekho price range from 10K to 4Cr.
15. Finding the correlation.
16. Using pair plot to show the relation between all variable.

• Conclusion:

Note: The dataset used is from year 2019-20.So it will not match with current market scenario

1. Brand having more demand in resale market are: Maruti,Hyundai,Honda,Mahindra,Toyota
2. Car with highest count in market are: Hyundai i20
3. Seller Type in market: Dealer(61.9%),Individual(37.0%),Trustmark dealer(11%)
4. Car power to price relation as power increace the price increase
5. Maruti Cars has best mileage and maintainance is low
6. 5 seater cars are in more demand than that of 7 seaters
7. Top three best car to buy with respect to each and every variable: a) Maruti Wagon R : Fuel type = CNG, Market price = 691769.09 Rs, Selling Price = 450000 Rs, Mileage = 33.54,Age = 4 b) Maruti Swift Dzire or Maruti Swift: Fuel type = Petrol ,Market Price = 900000 ,Selling Price = 750000 Rs ,Mileage = 28.40 ,Age = 4 c) Hyundai i20 : Fuel type = Petrol ,Market Price = 800000 ,Selling Price = 215000 , Mileage = 17 ,Age = 4

• Result:

1. As per my analysis cars of Maruti and Hyundai are most trusted and has better mileage along with low maintainance compared to the other brands.
2. Also as per the data analysis we have gone through the resale value of Maruti,Hyundai and Toyota are best but according to the budget and mileage point of view Maruti and Hyundai cars are leading ahead.

THANK YOU