Cleaned Vehicle Dataset
A data cleaning project
@kaggle.bryanmbravo_cleaned_vehicle_dataset
Loading...
Loading...
Loading...
Loading...
About this Dataset
Cleaned Vehicle Dataset
The original dataset, "Vehicle Dataset 2024," was found through Kaggle.com and is available under the ODC Attribution License. https://www.kaggle.com/datasets/kanchana1990/vehicle-dataset-2024
This is the final result of a data-cleaning project. Link to data cleaning source code: https://www.kaggle.com/code/bryanmbravo/vehicle-cleaning-project/notebook
Dataset Variables
| Variable Name | Data Type | Description | Variable Example |
|---|---|---|---|
| name | Text | The vehicle's full name, including make, model, and trim. | "2024 Jeep Wagoneer Series II" |
| make | Categorical | The vehicle manufacturer (Ford, Toyota, BMW). | "Jeep" |
| model | Categorical | The model name of the vehicle. | "Wagoneer" |
| type | Categorical | The type of vehicle (New, Used). | "New" |
| year | Continuous | The year the vehicle was manufactured. | 2024 |
| price | Discrete | The price of the vehicles in USD. | 74600.0 |
| engine | Text | Details about the engine, including type and specifications | "24V GDI DOHC Twin Turbo" |
| cylinders | Discrete | The number of cylinders in a vehicle's engine. | 6.0 |
| fuel | Categorical | The vehicle's fuel type. (Gasoline, Diesel, Electric) | "Gasoline" |
| mileage | Continuous | The vehicle's mileage. | 32.0 |
| transmission | Categorical | The transmission type. (Automatic, Manual) | "8-Speed Automatic" |
| trim | Categorical | The trim level of the vehicle, indicating different feature sets or packages | "Series II" |
| body | Categorical | The vehicle's body style. (SUV, Sedan, Pickup Truck) | "SUV" |
| doors | Discrete | The number of doors on the vehicle | 4.0 |
| exterior_color | Categorical | The exterior color of the vehicle | "White" |
| interior_color | Categorical | The interior color of the vehicle | "Global Black" |
| drivetrain | Categorical | The vehicle's drivetrain. (All-wheel Drive, Front-wheel Drive) | "Four-wheel Drive" |
Tables
Vehicle Cleaned
@kaggle.bryanmbravo_cleaned_vehicle_dataset.vehicle_cleaned
- 49.44 kB
- 861 rows
- 19 columns
Loading...
Loading...
CREATE TABLE vehicle_cleaned (
"unnamed_0" BIGINT -- Unnamed: 0,
"name" VARCHAR,
"make" VARCHAR,
"model" VARCHAR,
"type" VARCHAR,
"year" BIGINT,
"price" DOUBLE,
"engine" VARCHAR,
"cylinders" DOUBLE,
"fuel" VARCHAR,
"mileage" DOUBLE,
"transmission" VARCHAR,
"trim" VARCHAR,
"body" VARCHAR,
"doors" DOUBLE,
"exterior_color" VARCHAR,
"interior_color" VARCHAR,
"drivetrain" VARCHAR,
"price_log" DOUBLE
);