Documentation of Used Vehicles application | Sprint 6 Project | TripleTen

Hosted on: https://used-vehicles.onrender.com

Please refer to this Github repository: https://github.com/peachykeenani/sprint_6_app

This web application explores the dataset vehicles_us.csv. This project contains the following visualizations:

• Data viewer
• Vehicle condition by manufacturer
• Sum of sales by vehicle condition
• Vehicle price and condition comparison
• Price distribution of fuel type by transmission
• Price distribution of 4WD vs. non-4WD by transmission
• Price and days listed distribution

Data Preprocessing: Filled in missing values for the following columns:

• model_year
  • grouped by 'model'
  • missing values replaced with median of year (2011)
• cylinders
  • grouped by 'model'
  • missing values replaced with median of cylinders (6)
• odometer
  • grouped by 'model_year' and 'model'
  • missing values replaced with mean of odometer as an integer (115,553)

Note Regarding scatter plots:

• Trendline is set to expanding mean trend.
• Trendline scope is set to overall.

Summary and Analysis

• The top two manufacturers with the most sales were Ford and Chevrolet (histograms: Vehicle types by manufacturer and Vehicle condtion by manufacturer)
• The conditions with the most sales came from excellent and good vehicles (Total sales by vehicle condition histogram).
• 2013 models sold the most (Histogram of condition vs model_year).
• There is an inverse correlation between the vehicle price and days listed.