Skip to content

MoonmoonSamal/Cars24

Repository files navigation

Cars24

Our dataset provides comprehensive information on various aspects of cars, including selling price, mileage, engine specifications, and more.

Dataset Description / META DATA: The dataset contains the following columns:

  1. name: The name or model of the car.
  2. year: The manufacturing year of the car.
  3. selling_price: The price at which the car was sold.
  4. km_driven: The number of kilometers driven by the car.
  5. fuel: The type of fuel the car uses.
  6. seller_type: The type of seller (individual, dealer, or Trustmark dealer).
  7. transmission: The type of transmission (manual or automatic).
  8. owner: The number of previous owners of the car.
  9. mileage: The mileage of the car in kilometers per liter.
  10. engine [CC]: The engine displacement in cubic centimeters (CC).
  11. max_power: The maximum power output of the car's engine.
  12. seats: The number of seats in the car.

Key Insights:

Reading the whole table counting the total number cars present in the data set unique fuel types in this table Average kilometer driven by cars Average selling price of different car models 10 car model driven the most on average Top 10 popular car model Numbers of cars sold by each seller type Car with the highest mileage Car with the lowest mileage Cars sold by each transmission type with lower than 12000 km driven Kilometers driven for cars sold by individual sellers compared to dealers car models with consistently low mileage across different years

About

Advanced SQL Analysis for Cars24 Sales Insights

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published