Car Trends: Insights from Car Dekho Dataset
This project involves an in-depth analysis of the Car Dekho dataset using SQL. The dataset comprises information about various cars, including their names, years, and fuel types. The project aims to uncover trends and patterns in car availability over the years, categorize cars based on fuel types, and examine the availability of cars in specific years. The analysis provides valuable insights into the car market, helping understand the distribution of cars over time and fuel preferences.
Key Findings:
Total Number of Cars: The dataset contains a diverse collection of cars, with a total count derived from the dataset.
Cars Available in 2023: The analysis shows the number of cars available in the year 2023.
Yearly Car Availability: The availability of cars in the years 2020, 2021, and 2022 is examined, providing a comparison across these years.
Yearly Car Distribution: A yearly breakdown of the total number of cars, highlighting trends over the years.
Fuel Type Distribution in 2020: Specific analysis of the number of diesel and petrol cars available in the year 2020.
Fuel Type Trends Over the Years: A comprehensive overview of the distribution of petrol, diesel, and CNG cars across different years.
Years with High Car Availability: Identification of years with more than 100 cars, indicating periods of high availability.
Car Counts Between 2015 and 2023: Total count and detailed breakdown of cars available between the years 2015 and 2023.
Detailed Car Information: Complete details of cars available between 2015 and 2023, offering a granular view of the dataset.
Parth Arora