Introduction
Have you ever been in a situation where you know you have questions, but you don’t even know what questions to ask? Feature importance is one of those things that helps get you started on finding those questions. Feature importance is the weight of which each feature of a dataset impacts a target variable. You can think of “feature” and “variable” as columns of your dataset. For example, if you took all of the hot dog restaurants in Chicago and got all of their ratings, and then got all of the data about each restaurant’s ingredients to make their hot dogs, you could, in theory, determine which ingredient matters the most in a Chicago hot dog.
In this case, the rating score would be the target variable, and each ingredient would be a feature. (In case you don’t know, Chicago hot dogs have 9 ingredients). Therefore, you could set up a model with the dataset and feature importance could tell you that the type of frank used in a hot dog is the most important feature for the target variable of the rating. Or perhaps it’s the type of bun, or for some reason the type of mustard. That’s feature importance! Thanks for reading my blog post!
Alright so it’s not quite that simple. Mostly because in reality, there are tons of other factors that would determine restaurant ratings. Cleanliness of the restaurant, service, aesthetics, and of course the food. However, if you did have all of those data points in some magical dataset, you could use feature importance to determine the most important features that contribute to positive dining experiences, and therefore reviews. My goal with this blog post is to show an end-to-end example of how you can actually use this tool, rather than just explain the theory or generate fake data.
It’s also worth noting that feature importance is generally used as one step in a larger machine learning project by data scientists and machine learning engineers. In this case, I’m showing just an end-to-end example of the feature importance without a larger model training project.
The Dataset
In searching for a dataset for this post, I found that it was a lot harder to find a suitable dataset than I expected. When I did find a dataset, I had to do quite a bit of cleanup before it was in a good place to run it through a model.
My initial idea was actually to use some kind of review dataset. I figured if I had a “score” (or user review) as the target variable, I could use some other categorical and continuous variables as features for feature importance. I searched for restaurant reviews, movie reviews, book reviews, game reviews, even recipe reviews. For each one I found that the API was very limited, charged for use, or didn’t have much data besides the ratings (so no features to work with). Discouraging, but it makes sense that companies with review data want to keep that data to themselves or monetize it. Oh well.
Ultimately I found this used car sales dataset on Kaggle. It has columns like year sold, year made, make, model, trim, mileage, engine, drive type, body type, and price. Ah! Price is a perfect target variable! It’s a perfect target variable because it can go up or down depending on other factors that are also included in the dataset. Mileage is a continuous variable and make, body type, and year made are categorical variables. Sounds good to me.
Follow along using my repo.
Data Cleaning
I’ll be doing some data cleaning and preprocessing here. Skip to the end for the feature importance if you’d like.
Let’s load up the dataset from the CSV and see what we’re working with:
import pandas as pd
ucs_df = pd.read_csv('used_car_sales.csv')
ucs_dfOutput:
| ID | pricesold | yearsold | zipcode | Mileage | Make | Model | Year | Trim | Engine | BodyType | NumCylinders | DriveType | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 137178 | 7500 | 2020 | 786** | 84430 | Ford | Mustang | 1988 | LX | 5.0L Gas V8 | Sedan | 0 | RWD |
| 1 | 96705 | 15000 | 2019 | 81006 | 0 | Replica/Kit Makes | Jaguar Beck Lister | 1958 | nan | 383 Fuel injected | Convertible | 8 | RWD |
| 2 | 119660 | 8750 | 2020 | 33449 | 55000 | Jaguar | XJS | 1995 | 2+2 Cabriolet | 4.0L In-Line 6 Cylinder | Convertible | 6 | RWD |
| 3 | 80773 | 11600 | 2019 | 07852 | 97200 | Ford | Mustang | 1968 | Stock | 289 cu. in. V8 | Coupe | 8 | RWD |
| 4 | 64287 | 44000 | 2019 | 07728 | 40703 | Porsche | 911 | 2002 | Turbo X-50 | 3.6L | Coupe | 6 | AWD |
| 5 | 132695 | 950 | 2020 | 462** | 71300 | Mercury | Montclair | 1965 | nan | NO ENGINE | Sedan | 0 | RWD |
| 6 | 132829 | 950 | 2020 | 105** | 71300 | Mercury | Montclair | 1965 | nan | nan | Sedan | 0 | nan |
| 7 | 5250 | 70000 | 2019 | 07627 | 6500 | Land Rover | Defender | 1997 | nan | 4.0 Liter Fuel Injected V8 | nan | 0 | 4WD |
| 8 | 29023 | 1330 | 2019 | 07043 | 167000 | Honda | Civic | 2001 | EX | nan | Coupe | 4 | FWD |
| 9 | 80293 | 25200 | 2019 | 33759 | 15000 | Pontiac | GTO | 1970 | nan | nan | nan | 0 | nan |
| 10 | 158271 | 20000 | 2020 | 333** | 51674 | Jeep | Wrangler | 2015 | SPORT | 3.6L Flexible V6 | SUV | 6 | 4WD |
| 11 | 72418 | 14100 | 2019 | 07014 | 109500 | Jeep | Wrangler | 2012 | Unlimited | 3.6L | SUV | 6 | 4WD |
| 12 | 91661 | 5700 | 2020 | 76051 | 1000000 | Ford | F-100 | 1949 | nan | nan | Standard Cab Pickup | 8 | RWD |
| 13 | 119358 | 6000 | 2020 | 384** | 101501 | Toyota | Prius | 2009 | nan | 1.5L Electric and Gas Hybrid I4 | 4 door/hatchback | 4 | FWD |
| 14 | 131969 | 4000 | 2020 | 027** | 118513 | Toyota | Celica | 1985 | nan | 2.8L Gas I6 | Hatchback | 0 | RWD |
| 15 | 84062 | 3820 | 2019 | V1W 5L6 | 377000 | Jeep | Wrangler | 1997 | nan | 4.0 | nan | 6 | AWD |
| 16 | 144540 | 3330 | 2020 | 856** | 47692 | Buick | LeSabre | 2004 | CUSTOM | 3.8L Gas V6 | Sedan | 6 | FWD |
| 17 | 142951 | 650 | 2020 | 628** | 99999 | Austin | nan | 1970 | nan | nan | nan | 0 | nan |
| 18 | 142336 | 1480 | 2020 | 601** | 166000 | Nissan | Altima | 2006 | nan | nan | Sedan | 6 | nan |
| 19 | 59728 | 18550 | 2019 | 60448 | 6714 | Chevrolet | Camaro | 2002 | Z28,SS,SLP | 5.7 liter v8 | Coupe | 8 | RWD |
| 20 | 74813 | 4300 | 2019 | 76705 | 140309 | Ford | F-100 | 1960 | nan | 223 | Standard Cab Pickup | 6 | RWD |
| 21 | 74812 | 4750 | 2019 | 76705 | 151361 | Ford | F-250 | 1978 | Ranger XLT | 460 | Standard Cab Pickup | 8 | RWD |
| 22 | 78263 | 3050 | 2020 | 07840 | 95600 | Nissan | Maxima | 2004 | SE | 3.5L | Sedan | 6 | FWD |
| 23 | 78272 | 4050 | 2020 | 07840 | 100427 | Nissan | Altima | 2009 | Hybrid | 2.5L DOHC | Sedan | 4 | FWD |
| 24 | 45651 | 5390 | 2019 | 07840 | 134000 | Chrysler | 300 Series | 2009 | nan | 5.7L HEMI | nan | 8 | AWD |
| 25 | 136843 | 4050 | 2020 | 078** | 82301 | Toyota | Corolla | 2008 | nan | nan | Sedan | 4 | FWD |
| 26 | 136599 | 5000 | 2020 | 078** | 92605 | Toyota | Tacoma | 2002 | nan | nan | Standard Cab Pickup | 4 | RWD |
| 27 | 136841 | 3550 | 2020 | 078** | 87201 | Subaru | Impreza | 2008 | nan | nan | Sedan | 4 | AWD |
| 28 | 77898 | 3500 | 2019 | 07840 | 144868 | Honda | CR-V | 2006 | LX | 2.4L VTECH | SUV | 4 | FWD |
| 29 | 77900 | 2550 | 2019 | 07840 | 174102 | Toyota | Yaris | 2009 | nan | 1.5L DOHC 16V | nan | 4 | FWD |
I can tell you after wrangling with this dataset that we are not going to work with a lot of these columns, and that we are going to do pre-processing on the rest.
Let’s cut it down to price, year sold, mileage, make, year, and body type:
ucs_df = ucs_df[["pricesold", "yearsold", "Mileage", "Make", "Year", "BodyType"]]Let’s do some work on these columns. Let’s see how the mileage distribution looks:
ucs_df['Mileage'].hist()
Oof. We have some outliers.
ucs_df['Mileage'].max()Output: 1235668876
Alright so perhaps we don’t include cars that have a billion miles on them. Seems fair. Let’s say the max mileage we will allow is 400k. Still a bit ridiculous for a used car but better.
# remove cars with more than 400k miles
ucs_df = ucs_df[ucs_df['Mileage'] < 400000]If we look at the distribution again, it looks much better.
ucs_df['Mileage'].hist()
I did the same thing with the Year of the cars and eliminated cars before the 20th century and from the future.
ucs_df = ucs_df[(ucs_df['Year'] < 2024) & (ucs_df['Year'] > 1910)]Let’s clean up our Makes now. Let’s see what we’re working with by seeing all the unique values of the column. For makes, we are essentially looking for the brand, e.g. Buick, Toyota, Mercedes-Benz.
unique_makes = list(ucs_df['Make'].unique())
print(len(unique_makes))
# prints sorted list separated by new lines so it prints vertically - good for notebooks
print(*sorted(unique_makes), sep = "\n")Output
450
1964 International
2101
300
AC
AC Cobra
AM General
AMC
AMC / Rambler
ASVE
AUSTIN HEALEY
Acura
Aerodeck
Alfa Romeo
Alpine
Amercan
American Bantam
American Electric Vehicle
American LaFrance
American Motors
Amphicar
Ariel
Arnolt-MG
Aston Martin
Auburn
Audi
Austin
Austin Healey
Austin Princess
Austin-Healey
Autobianchi
Autocar
Avanti
Avanti II
BAW
BISCUTER
BMW
BMW 3 Series
BMW 335i
BMW 530 Sport Pkg
BMW 535i xDrive AWD
BMW 750Li xDrive
Beardmore
Bedford
Bentley
Bertone
Blue Bird
Bmw
Borgward
Bricklin
Bugatti
Buick
Buick LeSabre
Buick Only 88k 5.7L
CADILLAC
CHARIOT
CHEVROLET
CHEVROLET ASTRO CARGO VAN
CHEVROLET ASTRO ONLY 77k
CHEVROLET AVALANCHE
CHEVROLET EXPRESS 3500
CHRYSLER
CITROEN DS19
CLASSIC MOTOR CARRIAGES
CRHYSLER
Cadillac
Cadillac DeVille
Cadillac One Owner
Cadillac Only 59k
Cadillac Only 80k
Cadillac Only 82k
Camuta
Checker
Cheverolet
Chevrolet
Chevrolet 2500 Only 65k
Chevrolet 3500 Handicap
Chevrolet Astro Cargo Van
Chevrolet Colorado
Chevrolet Express
Chevrolet HHR LS PANEL
Chevrolet One Owner
Chevrolet Only 38K
Chevrolet Only 56k
Chevrolet Only 79k
Chevrolet Venture
Chevy
Chrylser
Chrysler
Chrysler Windsor
Citroen
Citroën
Coda
Comuta-Car
Comuta-Car (CitiCar)
Continental
Corbin
Cord
Crosley
Cushman
DATSUN
DIAMOND T
DIVCO
DKW
DODGE
DODGE GRAND CARAVAN SXT
DUTTON AMPHIBIOUS
Daewoo
Daihatsu
Daihatsu Trimobile
Daimler
Datsun
Datsun 510
De Tomaso
DeLorean
DeSoto
Desoto
Diamond
Diamond T
Diamond t
DiamondT Diamond T
Divco
Divco Model 12
Dodge
Dodge Brothers
Dodge Cargo Van
Dodge One Owner
Dodge Only 36k
Dodge Only 71k
Dodge brothers
Dort
Eagle
Edsel
El Dorado
Electric
Escape
Excalibur
Excalibur Series II Other
Exomotive
FIAT
FORD
FORD EXPLORER XLT 4X4
FREIGHTLINER
FREIGHTLNR
Factory Five
Factory Five Racing
Federal Motors
Ferrari
Fiat
Fiberfab
Fiberfab Avenger GT40
Fisker
Ford
Ford 4X4
Ford Carfax Accident Free
Ford E-250 One Owner
Ford E-350
Ford E150 Only 70k
Ford E350
Ford E350 DIESEL
Ford F-150 XLT 4X$
Ford Handicap
Ford NAV 3rd Row
Ford One Owner
Ford Only 60k
Ford Passenger Van
Frazer
Frazier
Freightliner
Fuldamobil
GAZ
GEM
GIOVANNI CASALINI
GL550
GMC
GMC AKA Chevy Express
GMC AWD
GRUMMAN OLSON
Genesis
Geo
Geo - Solectria Force
Glas Goggomobil
Gmc
Goggomobil
Gogomobil
Graham
Graham-Paige
HUMMER H-1
HYUNDAI
HYUSUNG GT650
Harley Davidson
Harley-Davidson
Haulmark
Healey
Henney
Hillman
Hino
Honda
Honda 6 Speed Manual
Honda CIVIC EX
Honda ODYSSEY
Honda Only 89k
Hudson
Hummer
Hummer h1
Hupmobile
Hyundai
Hyundai Santa Fe GLS
IMMACULATE DODGE
INTERNATIONAL
INTERNATONAL
Indiana
Infiniti
International
International Harvester
Isuzu
J. I. Case
JAGUAR
JENSEN CARS
Jaguar
Jaguar Only 49k
Jaguar XJ8
Jeep
Jeep 4X4
Jeep One Owner
Jeep Only 68k
Jensen
Jensen Healey
Jensen-Healey
KAUFMAN
KIA
Kaiser
Kaiser CUSTOM CRUISER
Kandi
Kawasaki
Kenworth
Kia
King Midget
LAFORZA
LARK
LEXUS
LTI
LaSalle
Lada
Laforza
Lamborghini
Lancia
Land Rover
Land Rover 4WD
Lasalle
Lexus
Lexus ES330
Lincoln
Lincoln Only 49k
Lincoln Only 96k
Lotus
MAZDA MX-5 MIATA
MERCEDES BENZ
MERCEDES-B
MERCEDES-BENZ
MERCURY
MG
MOCHET
MOKE
Marathon
Marcos
Maserati
Maxim
Maxwell
Maybach
Mazda
Mazda 5 Speed Manual
McLaren
Meccanica
Mercedes
Mercedes Benz
Mercedes-Benz
Mercedes-Benz DIESEL
Mercedes-Benz Only 22k
Mercury
Merkur
Messerschmitt
Metz
Meyers
Meyers Manx
Miles
Mini
Mini Cooper Clubman
Mitsubishi
Mitsubishi Fuso
Morgan
Morris
Morris Minor
Mosler
Msv mauck
NISSAN
NSU
Nash
Nissan
Nissan Datsun
OPEL MANTA
Oldsmobile
Oldsmobile 1967 442
Oliver
Olson Kurb Side by Grumman
Opel
Oreion
Other Makes
Other Makes early LOTUS 7 with IRS
Other Makes- Diamond T Truck
PANHARD
PIymouth
PMAG Burning Man
POLARIS
PONTlAC
Packard
Pagoda
Peterbilt
Peugeot
Pierce Arrow
Pierce-Arrow
Plymouth
Polaris
Pontiac
Pontiac VIBE
Porsche
Puma
Qvale
REO
REO Speedwagon
Railton Fairmale
Ram
Ram Dodge C/V
Rambler
Rat Rod
Reliant
Renault
Replica/Kit Makes
Riley
Rolls Royce
Rolls-Royce
Rover
Rover Range Rover
SATURN VUE HYBRID
SMITH ELECTRIC
SOLAR CAR - Solectria Force Electric Car With Solar
SUBARU FORESTER AWD
SUZUKI
Saab
Saab Only 73k
Saturn
Scion
Scooby Doo Mystery Machine Japanese Mini Truck
Seagrave Fire Apparatus
Shelby
Siata
Singer
Smart
Speedster
Star
Sterling
Steyr Puch
Studabaker
Studebaker
Stutz
Subaru
Subaru 6 Speed Manual
Subaru AWD Wagon
Subaru Forester AWD
Suburu
Sunbeam
Super 88
Superformance
Suzuki
Suzuki Only 27k
TESLA
TOYOTA
TRIUMPH
TVR
Tesla
Think
Thoroughbred
Tiger
Tomberlin
Toyota
Toyota 4Runner SR5 4WD
Toyota Highlander Hybrid
Toyota NAV
Toyota One Owner
Toyota Only 97k
Toyota Rear Diff Lock
Toyota Sienna
Triumph
Triumph TR6
Tucson
UHAUL
Unimog
VOLVO
VOLVO V70
VPG
VW
Valiant
Vanguard
Vega
Vespa
Vintage Sprint
Volkswagen
Volkswagen Jetta GLS
Volkswagen Only 77k
Volkswagen PASSAT 47k GL
Volkswagon
Volvo
Volvo One Owner
Volvo Only 64k
Volvo Only 84k
Vw
WHEEGO
WHEEGO WHIP ELECTRA CAR
Whippet
White
White/GMC
Willys
Willys-Overland
Yamaha
Yugo
ZIMMER GOLDEN SPIRIT
Zimmer
Zimmer Golden Spirit Coupe
chevy
chrysler
coda
crofton / steyr puch haflinger
datsun
divco
ford anglia
gmc
infinity
jaguar
jeep
landrover
lincoln
mazda
mercedes
mercedes benz
nsu
oldsmobile
ponitac
rambler
renault
smart
willy's jeepWith this output we see that we have 450 unique values for makes, and that they are not very clean. We see some clear examples of mistakes or typos, as well as unnecessary added words. For example we see TOYOTA, Toyota, Toyota 4Runner SR5 4WD, Toyota Highlander Hybrid, etc. when all of these should just be Toyota. Since our model is going to look at the category of “make” to see if it is impactful to the price, it is very important that the categories are cohesive and that a Toyota is a Toyota.
Let’s check the 80 most common makes:
list(ucs_df['Make'].value_counts().index[0:80])Output
['Ford',
'Chevrolet',
'Toyota',
'Mercedes-Benz',
'Dodge',
'BMW',
'Jeep',
'Cadillac',
'Volkswagen',
'Honda',
'Pontiac',
'Nissan',
'GMC',
'Porsche',
'Lincoln',
'Buick',
'Audi',
'Chrysler',
'Jaguar',
'Subaru',
'Lexus',
'Land Rover',
'Volvo',
'Plymouth',
'Oldsmobile',
'Mazda',
'Mercury',
'Hyundai',
'Acura',
'Mini',
'MG',
'Infiniti',
'Mitsubishi',
'Hummer',
'International Harvester',
'Datsun',
'Saab',
'Triumph',
'Kia',
'Fiat',
'Ram',
'Tesla',
'AMC',
'Alfa Romeo',
'Saturn',
'Studebaker',
'Other Makes',
'Maserati',
'Replica/Kit Makes',
'Bentley',
'Rolls-Royce',
'Ferrari',
'Suzuki',
'Willys',
'Isuzu',
'Scion',
'Austin Healey',
'Smart',
'Packard',
'Lotus',
'Shelby',
'Nash',
'Aston Martin',
'Lamborghini',
'Hudson',
'Geo',
'Opel',
'DeLorean',
'Austin',
'Citroën',
'DeSoto',
'Sunbeam',
'Lancia',
'Edsel',
'International',
'Renault',
'Eagle',
'McLaren',
'Freightliner',
'Fisker']I verified manually that all of these are fine, and concluded that the rest of the problematic makes are generally supposed to fall into these makes. Next, I used the following function to check for string fragments that would identify a make and allow me to group problematic names into the correct make.
all_makes = list(ucs_df['Make'].unique())
for make in all_makes:
if 'pon' in make.lower():
print(make)Pontiac
PONTlAC
Pontiac VIBE
ponitacYou can see that just using “pontiac” wouldn’t work in this case because PONTlAC uses an L instead of an I.
I ran through this many times, going back and forth between the above function and the unique values of the makes to ensure I was getting all of them. Ultimately I came up with this map and function, which checks if the make is in the list of the top makes, if it contains one of the strings in the keys of the map, and if neither of those are true, fills in the make as “Other Makes”.
good_makes = list(ucs_df['Make'].value_counts().index[0:80])
make_cleanup_map = {'austin': 'Austin',
'bmw': 'BMW',
'chev': 'Chevrolet',
'chry': 'Chrysler',
'diamond': 'Diamond T',
'dodge': 'Ram',
'fiat': 'Fiat',
'ford': 'Ford',
'gmc': 'GMC',
'honda': 'Honda',
'hummer': 'Hummer',
'jaguar': 'Jaguar',
'jeep': 'Jeep',
'lexus': 'Lexus',
'lincoln': 'Lincoln',
'lotus': 'Lotus',
'mazda': 'Mazda',
'mercedes': 'Mercedes-Benz',
'mouth': 'Chrysler',
'nissan': 'Nissan',
'olds': 'Oldsmobile',
'pon': 'Pontiac',
'ram': 'Ram',
'rambler': 'AMC',
'rover': 'Land Rover',
'saturn': 'Saturn',
'subaru': 'Subaru',
'suburu': 'Subaru',
'tesla': 'Tesla',
'toyota': 'Toyota',
'volks': 'Volkswagen',
'volvo': 'Volvo',
'vw': 'Volkswagen'
}
def make_cleanup(orig_make):
make_lower = orig_make.lower()
if orig_make in good_makes:
return orig_make
else:
for key in make_cleanup_map.keys():
if key in make_lower:
return make_cleanup_map[key]
return 'Other Makes'
ucs_df['clean_make'] = ucs_df['Make'].apply(lambda x: make_cleanup(x))Let’s see how our clean_makes column is stacking up.
ucs_df['clean_make'].value_counts()Output:
clean_make
Ford 21483
Chevrolet 20488
Toyota 6646
Mercedes-Benz 6218
Dodge 5722
BMW 5111
Jeep 4494
Cadillac 3626
Volkswagen 3513
Honda 3438
Pontiac 2631
Nissan 2508
GMC 2498
Porsche 2210
Lincoln 1833
Buick 1784
Audi 1517
Chrysler 1476
Jaguar 1315
Subaru 1313
Lexus 1294
Land Rover 1250
Volvo 1083
Plymouth 1052
Oldsmobile 995
Mazda 977
Mercury 828
Other Makes 694
Hyundai 686
Acura 654
Mini 639
MG 574
Infiniti 559
Mitsubishi 496
Hummer 485
International Harvester 478
Datsun 443
Saab 436
Triumph 413
Kia 398
Ram 380
Fiat 376
Tesla 333
AMC 289
Alfa Romeo 278
Saturn 276
Studebaker 249
Maserati 240
Replica/Kit Makes 236
Bentley 230
Ferrari 218
Rolls-Royce 218
Suzuki 200
Willys 198
Isuzu 149
Scion 143
Austin Healey 138
Smart 107
Packard 102
Lotus 101
Shelby 95
Nash 92
Aston Martin 80
Lamborghini 74
Hudson 66
Geo 62
Opel 56
DeLorean 55
Austin 54
Citroën 43
DeSoto 42
Sunbeam 39
Edsel 37
Lancia 37
International 36
Renault 24
Eagle 21
McLaren 20
Freightliner 19
Fisker 18
Diamond T 14After doing this cleanup, we are down to 81 unique values for makes. Much better than 450. Now onto body type! This column is even more messy, and is a bit more difficult to work with since body types don’t have proper groupings that you can look up like car brands. Let’s start by looking at the unique values, similar to what we did with the makes.
ucs_df['BodyType'] = ucs_df['BodyType'].astype(str)
unique_bodies = list(ucs_df['BodyType'].unique())
print(len(unique_bodies))
# print(*sorted(unique_bodies), sep = "\n")Output: 2290
So we have 2290 unique body types and oh boy are they messy. Instead of grouping them by more common and well known types like we did with the makes, let’s use some machine learning to help us with this problem.
Here I used KMeans Clustering, which is a machine learning algorithm that groups items into clusters based on similarity. For K Means clustering, you provide the number of clusters you want to have, and the algorithm will find that number of groups for your data and assign the appropriate cluster to each data point.
We are not using the clustering to assign categories to the data; just to help us explore the data so we can assign groups ourselves.
from sklearn.feature_extraction.text import TfidfVectorizer
from sklearn.cluster import KMeans
# Set a random seed for reproducibility
np.random.seed(42)
# TF-IDF vectorization
vectorizer = TfidfVectorizer()
X = vectorizer.fit_transform(ucs_df['BodyType'])
# Initialize KMeans with random_state set
kmeans = KMeans(n_clusters=6, random_state=42)
# Fit KMeans to the data
kmeans.fit(X)
# create a new DF from BodyType and add the cluster labels
body_df = ucs_df[['BodyType']].copy()
body_df['cluster'] = kmeans.labels_Let’s view our new dataframe, and see what kind of data fit into each cluster. This first line is just there to remove display limits.
with pd.option_context('display.max_rows', None, 'display.max_columns', None):
for i in range(8):
print(body_df[body_df['cluster'] == i].head(500))Output:
BodyType cluster
36 Wagon 0
37 Wagon 0
49 Wagon 0
50 Wagon 0
59 Wagon 0
71 Wagon 0
250 Wagon 0
279 Wagon 0
313 station wagon 0
463 station wagon 0
537 Wagon 0
691 Wagon 0
692 Wagon 0
732 Wagon 0
741 Wagon 0
892 Wagon 0
911 Wagon 0
943 Wagon 0
1000 Wagon 0
1065 Wagon 0
1071 Wagon 0
1120 Wagon 0
1172 Wagon 0
1215 Wagon 0
1218 Wagon 0
1259 Wagon 0
1351 Wagon 0
1365 station wagon 0
1381 STATION WAGON 0
1400 Wagon 0
1405 Wagon 0
1508 Wagon 0
1522 Wagon 0
1531 Wagon 0
1532 Wagon 0
1533 Wagon 0
1574 Wagon 0
1581 Wagon 0
1582 Wagon 0
1711 Wagon 0
1789 Wagon 0
1831 Wagon 0
1932 Wagon 0
1946 Wagon 0
1966 Wagon 0
2002 Wagon 0
2036 Wagon 0
2049 Wagon 0
2091 Wagon 0
2104 Wagon 0
2197 Station Wagon 0
2234 Wagon 0
2281 Wagon 0
2284 Wagon 0
2428 Wagon 0
2446 Wagon 0
2520 Wagon 0
2521 Wagon 0
2575 station wagon 0
2623 Wagon 0
2627 Wagon 0
2638 Wagon 0
2657 Wagon 0
2748 Wagon 0
2828 Wagon 0
2870 Wagon 0
2981 Wagon 0
2988 Wagon 0
3009 Wagon 0
3078 Wagon 0
3111 Wagon 0
3166 Wagon 0
3176 Wagon 0
3202 wagon 0
3282 Wagon 0
3287 Wagon 0
3354 Wagon 0
3356 Wagon 0
3357 Wagon 0
3410 Wagon 0
3511 Wagon 0
3512 Wagon 0
3585 Wagon 0
3609 Wagon 0
3650 Wagon 0
3746 Wagon 0
3811 Wagon 0
3819 Wagon 0
4099 Wagon 0
4147 Wagon 0
4263 Wagon 0
4284 Wagon 0
4305 Wagon 0
4383 Wagon 0
4385 Wagon 0
4443 Wagon 0
4527 Wagon 0
4533 Wagon 0
4634 Wagon 0
4637 Wagon 0
4639 Wagon 0
4706 Wagon 0
4802 Wagon 0
4855 Wagon 0
4863 Wagon 0
5005 Station Wagon 0
5109 Wagon 0
5122 Wagon 0
5129 Wagon 0
5136 Wagon 0
5144 Wagon 0
5146 Wagon 0
5147 Wagon 0
5160 Wagon 0
5195 2 dr wagon 0
5232 Wagon 0
5244 Wagon 0
5253 station wagon/van 0
5268 Wagon 0
5269 Wagon 0
5270 Wagon 0
5271 Wagon 0
5272 Wagon 0
5276 Wagon 0
5277 Wagon 0
5288 Wagon 0
5294 Wagon 0
5389 Wagon 0
5394 Wagon 0
5483 Station Wagon 0
5490 Wagon 0
5557 Wagon 0
5561 Wagon 0
5679 Wagon 0
5721 Wagon 0
5755 Wagon 0
5758 Wagon 0
5763 Wagon 0
5897 Wagon 0
6033 Wagon 0
6044 wagon 0
6085 Wagon 0
6089 Wagon 0
6097 Wagon 0
6190 Wagon 0
6206 Wagon 0
6259 Wagon 0
6302 Wagon 0
6324 Wagon 0
6343 Wagon 0
6352 Wagon 0
6436 Wagon 0
6486 Wagon 0
6487 Wagon 0
6488 Wagon 0
6489 Wagon 0
6492 Wagon 0
6536 Wagon 0
6554 Wagon 0
6618 Wagon 0
6635 Wagon 0
6667 Wagon 0
6803 Wagon 0
6850 Wagon 0
7002 Wagon 0
7025 Wagon 0
7027 Wagon 0
7062 Wagon 0
7122 Wagon 0
7123 Wagon 0
7152 Wagon 0
7158 Wagon 0
7234 Wagon 0
7384 Wagon 0
7436 Wagon 0
7588 Wagon 0
7622 Wagon 0
7627 Wagon 0
7725 Wagon 0
7744 Wagon 0
7773 Wagon 0
7796 Wagon 0
7858 Wagon 0
7895 Wagon 0
8071 Wagon 0
8083 Wagon 0
8145 Wagon 0
8206 Wagon 0
8333 Wagon 0
8334 Wagon 0
8335 Wagon 0
8336 Wagon 0
8337 Wagon 0
8338 Wagon 0
8352 Wagon 0
8391 Wagon 0
8476 Wagon 0
8526 Wagon 0
8599 Wagon 0
8672 Wagon 0
8720 Wagon 0
8731 Wagon 0
8751 Wagon 0
8831 Wagon 0
8906 Wagon 0
8952 Wagon 0
8953 Wagon 0
8954 5 door wagon 0
8955 Wagon 0
9073 Wagon 0
9262 Wagon 0
9296 Wagon 0
9348 Wagon 0
9458 Wagon 0
9568 Wagon 0
9598 Wagon 0
9611 Wagon 0
9612 Wagon 0
9613 Wagon 0
9614 Wagon 0
9615 Wagon 0
9616 Wagon 0
9617 Wagon 0
9619 Wagon 0
9642 Wagon 0
9652 Wagon 0
9688 Wagon 0
9942 Wagon 0
9973 Wagon 0
10065 Wagon 0
10076 Wagon 0
10111 Wagon 0
10125 Wagon 0
10185 Wagon 0
10207 Wagon 0
10232 Wagon 0
10260 Wagon 0
10399 Wagon 0
10417 Station Wagon 0
10482 Wagon 0
10489 Wagon 0
10503 Wagon 0
10544 Wagon 0
10617 Wagon 0
10633 Wagon 0
10646 Wagon 0
10647 Wagon 0
10701 Wagon 0
10702 Wagon 0
10705 Wagon 0
10727 Wagon 0
10754 Station Wagon 0
10763 Station Wagon 0
10764 Station Wagon 0
10765 Station Wagon 0
10767 Station Wagon 0
10769 Station Wagon 0
10778 Station Wagon 0
10785 Station Wagon 0
10786 Station Wagon 0
10787 Station Wagon 0
10831 Wagon 0
10914 Wagon 0
10972 Wagon 0
11134 Station Wagon 0
11135 Station Wagon 0
11174 Station Wagon 0
11293 Wagon 0
11561 Wagon 0
11615 Wagon 0
11620 Wagon 0
11644 Wagon 0
11717 Wagon 0
11857 Wagon 0
12215 Wagon 0
12326 Wagon 0
12342 Wagon 0
12429 Wagon 0
12446 Wagon 0
12627 Wagon 0
12689 Wagon 0
12699 Wagon 0
12765 Wagon 0
12849 Wagon 0
12887 Wagon 0
12894 STATION WAGON 0
12895 Wagon 0
12938 Wagon 0
12949 Wagon 0
12997 Wagon 0
13011 Wagon 0
13150 Wagon 0
13264 Wagon 0
13309 Wagon 0
13353 Wagon 0
13359 Wagon 0
13411 Wagon 0
13566 Wagon 0
13619 Wagon 0
13627 Wagon 0
13655 Wagon 0
13699 Wagon 0
13808 Wagon 0
13809 Wagon 0
13875 Wagon 0
13878 Wagon 0
13926 Station Wagon 0
13927 Station Wagon 0
13945 Station Wagon 0
13959 Station Wagon 0
13991 Station Wagon 0
13992 Station Wagon 0
13995 Station Wagon 0
14008 Station Wagon 0
14032 Station Wagon 0
14036 Station Wagon 0
14067 Wagon 0
14128 Wagon 0
14138 Wagon 0
14143 Wagon 0
14150 Wagon 0
14189 Wagon 0
14225 Wagon 0
14264 Wagon 0
14265 Wagon 0
14266 Wagon 0
14302 Station Wagon 0
14303 Station Wagon 0
15303 Wagon 0
15370 Wagon 0
15440 Wagon 0
15454 Wagon 0
15461 Wagon 0
15464 Wagon 0
15678 Wagon 0
15729 Wagon 0
15808 Wagon 0
15884 Wagon 0
15957 Wagon 0
16025 Wagon 0
16031 Wagon 0
16046 Wagon 0
16100 Wagon 0
16107 Wagon 0
16131 Wagon 0
16201 Wagon 0
16258 Wagon 0
16279 Wagon 0
16286 Wagon 0
16324 Wagon 0
16328 Wagon 0
16382 Wagon 0
16460 Wagon 0
16461 Station Wagon 0
16518 Wagon 0
16562 Wagon 0
16568 Wagon 0
16582 Wagon 0
16630 Wagon 0
16671 Wagon 0
16682 Station Wagon 0
16724 Wagon 0
16780 Wagon 0
16841 Station Wagon 0
16872 Wagon 0
16895 Wagon 0
16919 Wagon 0
16927 Wagon 0
17064 Wagon 0
17079 Wagon 0
17104 Wagon 0
17150 Wagon 0
17152 Wagon 0
17260 Wagon 0
17261 Wagon 0
17281 Wagon 0
17282 Wagon 0
17285 Wagon 0
17312 Wagon 0
17332 Wagon 0
17399 Wagon 0
17409 Wagon 0
17481 Wagon 0
17545 Wagon 0
17562 Wagon 0
17575 Wagon 0
17673 Wagon 0
17688 Wagon 0
17699 Wagon 0
17707 Wagon 0
17724 Station Wagon 0
17738 Wagon 0
17858 Wagon 0
17916 Wagon 0
17929 Wagon 0
17930 Wagon 0
17933 Wagon 0
17943 Wagon 0
17953 Wagon 0
17962 Wagon 0
17963 Wagon 0
17967 Wagon 0
17968 Wagon 0
17969 Wagon 0
17974 Wagon 0
17978 Wagon 0
17979 Wagon 0
17980 Wagon 0
18058 Wagon 0
18209 Wagon 0
18225 Wagon 0
18243 Wagon 0
18310 Wagon 0
18336 Station Wagon 0
18352 Wagon 0
18373 Wagon 0
18387 Wagon 0
18397 Wagon 0
18546 Wagon 0
18593 Wagon 0
18609 Wagon 4 Dr. 0
18613 Wagon 4 Dr. 0
18632 Wagon 0
18678 Wagon 0
18679 Wagon 0
18717 Wagon 0
18761 Wagon 0
18762 Wagon 0
18798 SUV / Wagon 0
18845 Wagon 0
18855 Wagon 0
18862 Wagon 0
18885 Wagon 0
18894 Wagon 0
18935 Wagon 0
19112 Wagon 0
19137 Wagon 0
19152 Wagon 0
19329 Wagon 0
19335 Wagon 0
19341 Wagon 0
19410 Wagon 0
19522 Wagon 0
19542 Wagon 0
19676 Station Wagon 0
19677 Station Wagon 0
19680 Station Wagon 0
19681 Station Wagon 0
19685 Station Wagon 0
19686 Wagon 0
19687 Station Wagon 0
19696 Station Wagon 0
19698 Station Wagon 0
19699 Station Wagon 0
19700 Station Wagon 0
19701 Station Wagon 0
19702 Station Wagon 0
19703 Station Wagon 0
19704 Station Wagon 0
19705 Station Wagon 0
19738 Station Wagon 0
19757 Wagon 0
19791 Station Wagon 0
19836 Station Wagon 0
19842 Station Wagon 0
19843 Station Wagon 0
19878 Wagon 0
19882 Wagon 0
20059 Wagon 0
20065 Wagon 0
20097 Wagon 0
20149 Wagon 0
20155 Wagon 0
20179 Wagon 0
20195 Wagon 0
20196 Wagon 0
20199 Wagon 0
20210 Wagon 0
20237 Wagon 0
20238 Wagon 0
20239 Wagon 0
20241 Wagon 0
20252 Wagon 0
20260 Wagon 0
20284 Wagon 0
20316 Wagon 0
20438 Wagon 0
20541 Wagon 0
20596 Wagon 0
20607 Wagon/SUV 0
20625 Wagon 0
20639 Wagon 0
20701 Wagon 0
20702 Wagon 0
20706 Wagon 0
20792 Wagon 0
20806 Station Wagon 0
21020 Wagon 0
21021 Wagon 0
21091 Wagon 0
BodyType cluster
7 nan 1
9 nan 1
15 nan 1
17 nan 1
24 nan 1
29 nan 1
30 nan 1
31 nan 1
39 nan 1
41 nan 1
45 nan 1
46 nan 1
48 nan 1
52 nan 1
54 nan 1
62 nan 1
64 nan 1
73 nan 1
87 nan 1
89 nan 1
103 nan 1
105 nan 1
108 nan 1
120 nan 1
122 nan 1
126 nan 1
127 nan 1
129 nan 1
147 nan 1
150 nan 1
151 nan 1
152 nan 1
153 nan 1
166 nan 1
170 nan 1
172 nan 1
173 nan 1
174 nan 1
182 nan 1
183 nan 1
184 nan 1
187 nan 1
191 nan 1
194 nan 1
202 nan 1
208 nan 1
214 nan 1
216 nan 1
217 nan 1
232 nan 1
235 nan 1
237 nan 1
240 nan 1
241 nan 1
244 nan 1
245 nan 1
248 nan 1
249 nan 1
259 nan 1
260 nan 1
261 nan 1
262 nan 1
269 nan 1
270 nan 1
276 nan 1
277 nan 1
282 nan 1
286 nan 1
287 nan 1
293 nan 1
297 nan 1
299 nan 1
302 nan 1
304 nan 1
309 nan 1
311 nan 1
314 nan 1
317 nan 1
329 nan 1
334 nan 1
335 nan 1
337 nan 1
341 nan 1
347 nan 1
348 nan 1
354 nan 1
358 nan 1
361 nan 1
364 nan 1
365 nan 1
369 nan 1
370 nan 1
371 nan 1
372 nan 1
374 nan 1
375 nan 1
379 nan 1
380 nan 1
384 nan 1
387 nan 1
390 nan 1
391 nan 1
395 nan 1
396 nan 1
397 nan 1
398 nan 1
399 nan 1
404 nan 1
417 nan 1
420 nan 1
421 nan 1
425 nan 1
427 nan 1
428 nan 1
436 nan 1
447 nan 1
450 nan 1
452 nan 1
455 nan 1
458 nan 1
462 nan 1
464 nan 1
466 nan 1
469 nan 1
477 nan 1
504 nan 1
506 nan 1
511 nan 1
512 nan 1
513 nan 1
515 nan 1
517 nan 1
529 nan 1
536 nan 1
558 nan 1
595 nan 1
599 nan 1
601 nan 1
602 nan 1
622 nan 1
642 nan 1
646 nan 1
650 nan 1
660 nan 1
661 nan 1
667 nan 1
671 nan 1
672 nan 1
676 nan 1
677 nan 1
678 nan 1
679 nan 1
680 nan 1
681 nan 1
682 nan 1
700 nan 1
702 nan 1
707 nan 1
719 nan 1
723 nan 1
724 nan 1
725 nan 1
733 nan 1
736 nan 1
754 nan 1
755 nan 1
756 nan 1
759 nan 1
760 nan 1
761 nan 1
777 nan 1
786 nan 1
788 nan 1
790 nan 1
803 nan 1
808 nan 1
809 nan 1
810 nan 1
811 nan 1
812 nan 1
813 nan 1
814 nan 1
815 nan 1
816 nan 1
819 nan 1
820 nan 1
823 nan 1
825 nan 1
846 nan 1
847 nan 1
849 nan 1
850 nan 1
857 nan 1
858 nan 1
861 nan 1
863 nan 1
873 nan 1
878 nan 1
887 nan 1
895 nan 1
907 nan 1
918 nan 1
924 nan 1
930 nan 1
944 nan 1
951 nan 1
953 nan 1
959 nan 1
960 nan 1
962 nan 1
975 nan 1
977 nan 1
978 nan 1
980 nan 1
983 nan 1
993 nan 1
1006 nan 1
1035 nan 1
1045 nan 1
1046 nan 1
1057 nan 1
1061 nan 1
1066 nan 1
1079 nan 1
1081 nan 1
1082 nan 1
1083 nan 1
1088 nan 1
1089 nan 1
1093 nan 1
1096 nan 1
1102 nan 1
1104 nan 1
1105 nan 1
1106 nan 1
1108 nan 1
1110 nan 1
1117 nan 1
1119 nan 1
1122 nan 1
1123 nan 1
1124 nan 1
1126 nan 1
1129 nan 1
1130 nan 1
1136 nan 1
1169 nan 1
1170 nan 1
1177 nan 1
1183 nan 1
1186 nan 1
1190 nan 1
1193 nan 1
1194 nan 1
1196 nan 1
1198 nan 1
1203 nan 1
1208 nan 1
1209 nan 1
1211 nan 1
1220 nan 1
1221 nan 1
1223 nan 1
1224 nan 1
1226 nan 1
1228 nan 1
1233 nan 1
1245 nan 1
1262 nan 1
1281 nan 1
1286 nan 1
1298 nan 1
1329 nan 1
1397 nan 1
1401 nan 1
1404 nan 1
1406 nan 1
1410 nan 1
1413 nan 1
1416 nan 1
1419 nan 1
1421 nan 1
1446 nan 1
1459 nan 1
1476 nan 1
1477 nan 1
1480 nan 1
1482 nan 1
1484 nan 1
1488 nan 1
1511 nan 1
1516 nan 1
1519 nan 1
1527 nan 1
1529 nan 1
1530 nan 1
1551 nan 1
1556 nan 1
1557 nan 1
1562 nan 1
1566 nan 1
1567 nan 1
1575 nan 1
1583 nan 1
1594 nan 1
1595 nan 1
1597 nan 1
1600 nan 1
1601 nan 1
1603 nan 1
1606 nan 1
1607 nan 1
1610 nan 1
1613 nan 1
1618 nan 1
1619 nan 1
1620 nan 1
1621 nan 1
1622 nan 1
1623 nan 1
1646 nan 1
1652 nan 1
1653 nan 1
1662 nan 1
1664 nan 1
1666 nan 1
1669 nan 1
1670 nan 1
1674 nan 1
1676 nan 1
1677 nan 1
1678 nan 1
1680 nan 1
1681 nan 1
1690 nan 1
1709 nan 1
1719 nan 1
1724 nan 1
1725 nan 1
1726 nan 1
1727 nan 1
1728 nan 1
1729 nan 1
1730 nan 1
1731 nan 1
1732 nan 1
1733 nan 1
1734 nan 1
1735 nan 1
1736 nan 1
1737 nan 1
1738 nan 1
1739 nan 1
1740 nan 1
1741 nan 1
1742 nan 1
1743 nan 1
1744 nan 1
1745 nan 1
1746 nan 1
1747 nan 1
1748 nan 1
1749 nan 1
1750 nan 1
1752 nan 1
1753 nan 1
1762 nan 1
1768 nan 1
1769 nan 1
1770 nan 1
1772 nan 1
1773 nan 1
1776 nan 1
1778 nan 1
1780 nan 1
1782 nan 1
1787 nan 1
1790 nan 1
1793 nan 1
1802 nan 1
1806 nan 1
1810 nan 1
1811 nan 1
1823 nan 1
1824 nan 1
1826 nan 1
1832 nan 1
1845 nan 1
1847 nan 1
1848 nan 1
1849 nan 1
1857 nan 1
1871 nan 1
1872 nan 1
1877 nan 1
1879 nan 1
1880 nan 1
1884 nan 1
1889 nan 1
1890 nan 1
1891 nan 1
1892 nan 1
1894 nan 1
1899 nan 1
1901 nan 1
1918 nan 1
1919 nan 1
1927 nan 1
1928 nan 1
1933 nan 1
1937 nan 1
1940 nan 1
1945 nan 1
1947 nan 1
1953 nan 1
1954 nan 1
1956 nan 1
1964 nan 1
1967 nan 1
1974 nan 1
1975 nan 1
1976 nan 1
1980 nan 1
1982 nan 1
1985 nan 1
1995 nan 1
1997 nan 1
2000 nan 1
2004 nan 1
2008 nan 1
2019 nan 1
2020 nan 1
2022 nan 1
2028 nan 1
2034 nan 1
2040 nan 1
2045 nan 1
2046 nan 1
2055 nan 1
2062 nan 1
2070 nan 1
2079 nan 1
2086 nan 1
2093 nan 1
2094 nan 1
2095 nan 1
2096 nan 1
2097 nan 1
2112 nan 1
2114 nan 1
2122 nan 1
2127 nan 1
2128 nan 1
2129 nan 1
2133 nan 1
2140 nan 1
2153 nan 1
2155 nan 1
2161 nan 1
2168 nan 1
2171 nan 1
2181 nan 1
2182 nan 1
2183 nan 1
2191 nan 1
2220 nan 1
2224 nan 1
2240 nan 1
2241 nan 1
2250 nan 1
2266 nan 1
2267 nan 1
2268 nan 1
2269 nan 1
2283 nan 1
2285 nan 1
2286 nan 1
2287 nan 1
2288 nan 1
2289 nan 1
2295 nan 1
2296 nan 1
2297 nan 1
2306 nan 1
2328 nan 1
2330 nan 1
2331 nan 1
2332 nan 1
2339 nan 1
2345 nan 1
2349 nan 1
2364 nan 1
2365 nan 1
2369 nan 1
2370 nan 1
2372 nan 1
2376 nan 1
2379 nan 1
2380 nan 1
2384 nan 1
BodyType cluster
3 Coupe 2
4 Coupe 2
8 Coupe 2
19 Coupe 2
35 Coupe 2
38 Coupe 2
42 Coupe 2
43 Coupe 2
56 Coupe 2
57 Coupe 2
66 Coupe 2
74 Coupe 2
77 Coupe 2
79 Coupe 2
81 Coupe 2
84 Coupe 2
97 Coupe 2
100 Coupe 2
104 Coupe 2
112 Coupe 2
123 Coupe 2
131 Coupe 2
134 Coupe 2
135 Coupe 2
136 Coupe 2
137 Coupe 2
143 Coupe 2
156 Coupe 2
163 Coupe 2
169 Coupe 2
171 Coupe 2
176 Coupe 2
178 Coupe 2
188 Coupe 2
190 Coupe 2
196 Coupe 2
197 Coupe 2
203 Coupe 2
205 Coupe 2
206 Coupe 2
213 Coupe 2
221 Coupe 2
224 Coupe 2
230 Coupe 2
231 Coupe 2
233 Coupe 2
236 Coupe 2
242 Coupe 2
271 Coupe 2
274 Coupe 2
280 Coupe 2
305 Coupe 2
306 Coupe 2
321 Coupe 2
333 Coupe 2
351 Coupe 2
352 Coupe 2
353 Coupe 2
355 Coupe 2
356 Coupe 2
359 Coupe 2
363 Coupe 2
373 Coupe 2
377 Coupe 2
386 Coupe 2
389 Coupe 2
392 Coupe 2
393 Coupe 2
410 Coupe 2
411 Coupe 2
415 Coupe 2
424 Coupe 2
431 Coupe 2
434 Coupe 2
439 Coupe 2
444 Coupe 2
446 Coupe 2
448 Coupe 2
465 Coupe 2
478 Coupe 2
479 Coupe 2
481 Coupe 2
489 Coupe 2
495 Coupe 2
496 Coupe 2
499 Coupe 2
500 Coupe 2
503 Coupe 2
514 Coupe 2
519 Coupe 2
520 Coupe 2
522 Coupe 2
523 Coupe 2
527 Coupe 2
550 Coupe 2
552 Coupe 2
554 Coupe 2
564 Coupe 2
583 Coupe 2
592 COUPE 2
609 Coupe 2
631 Coupe 2
632 Coupe 2
634 Coupe 2
638 Coupe 2
639 Coupe 2
643 Coupe 2
644 Coupe 2
645 Coupe 2
647 Coupe 2
649 Coupe 2
659 Coupe 2
664 Coupe 2
674 Coupe 2
675 Coupe 2
684 Coupe 2
688 Coupe 2
689 Coupe 2
690 Coupe 2
701 Coupe 2
710 Coupe 2
711 Coupe 2
720 Coupe 2
728 Coupe 2
731 Coupe 2
734 Coupe 2
740 Coupe 2
748 Coupe 2
752 Coupe 2
757 Coupe 2
763 Coupe 2
767 Coupe 2
768 Coupe 2
769 Coupe 2
770 Coupe 2
775 Coupe 2
778 Coupe 2
783 Coupe 2
787 Coupe 2
789 Coupe 2
791 Coupe 2
793 Coupe 2
798 Coupe 2
799 Coupe 2
806 Coupe 2
831 Coupe 2
833 Coupe 2
838 Coupe 2
841 Coupe 2
845 Coupe 2
865 Coupe 2
866 Coupe 2
868 Coupe 2
880 Coupe 2
893 Coupe 2
901 Coupe 2
910 Coupe 2
914 Coupe 2
915 Coupe 2
916 Coupe 2
919 Coupe 2
923 Coupe 2
926 Coupe 2
927 Coupe 2
928 Coupe 2
929 Coupe 2
931 Coupe 2
932 Coupe 2
936 Coupe 2
937 Coupe 2
940 Coupe 2
946 Coupe 2
948 Coupe 2
958 Coupe 2
963 Coupe 2
966 Coupe 2
986 Coupe 2
988 Coupe 2
992 Coupe 2
994 Coupe 2
997 Coupe 2
999 Coupe 2
1003 Coupe 2
1007 Coupe 2
1016 Coupe 2
1021 Coupe 2
1022 Coupe 2
1023 Coupe 2
1033 Coupe 2
1034 Coupe 2
1036 Coupe 2
1037 Coupe 2
1039 Coupe 2
1040 Coupe 2
1051 Coupe 2
1052 Coupe 2
1056 Coupe 2
1058 Coupe 2
1063 Coupe 2
1070 Coupe 2
1073 Coupe 2
1101 Coupe 2
1115 Coupe 2
1118 Coupe 2
1128 Coupe 2
1131 Coupe 2
1133 Coupe 2
1135 Coupe 2
1137 Coupe 2
1143 Coupe 2
1144 Coupe 2
1145 Coupe 2
1146 Coupe 2
1147 Coupe 2
1148 Coupe 2
1149 Coupe 2
1150 Coupe 2
1151 Coupe 2
1152 Coupe 2
1153 Coupe 2
1154 Coupe 2
1155 Coupe 2
1156 Coupe 2
1157 Coupe 2
1158 Coupe 2
1159 Coupe 2
1162 Coupe 2
1180 Coupe 2
1181 Coupe 2
1185 Coupe 2
1188 Coupe 2
1195 Coupe 2
1199 Coupe 2
1214 Coupe 2
1219 Coupe 2
1222 Coupe 2
1225 Coupe 2
1229 Coupe 2
1230 Coupe 2
1231 Coupe 2
1236 Coupe 2
1241 Coupe 2
1244 Coupe 2
1247 Coupe 2
1257 Coupe 2
1261 Coupe 2
1266 Coupe 2
1268 Coupe 2
1274 Coupe 2
1282 Coupe 2
1288 Coupe 2
1308 Coupe 2
1310 Coupe 2
1311 Coupe 2
1317 COUPE 2
1319 COUPE 2
1320 coupe 2
1321 COUPE 2
1325 COUPE 2
1336 COUPE 2
1339 COUPE 2
1344 COUPE 2
1347 COUPE 2
1348 COUPE 2
1355 COUPE 2
1356 COUPE 2
1360 Coupe 2
1361 COUPE 2
1363 COUPE 2
1370 COUPE 2
1378 COUPE 2
1379 COUPE 2
1382 Coupe 2
1383 Coupe 2
1386 Coupe 2
1390 Coupe 2
1395 Coupe 2
1407 Coupe 2
1422 Coupe 2
1423 Coupe 2
1424 Coupe 2
1431 Coupe 2
1435 Coupe 2
1436 Coupe 2
1441 Coupe 2
1472 Coupe 2
1474 Coupe 2
1485 Coupe 2
1494 Coupe 2
1495 Coupe 2
1506 Coupe 2
1524 Coupe 2
1534 Coupe 2
1538 Coupe 2
1539 Coupe 2
1541 Coupe 2
1547 Coupe 2
1548 Coupe 2
1552 Coupe 2
1553 Coupe 2
1568 Coupe 2
1571 Coupe 2
1578 Coupe 2
1579 Coupe 2
1580 Coupe 2
1598 Coupe 2
1602 Coupe 2
1614 Coupe 2
1615 Coupe 2
1616 Coupe 2
1617 Coupe 2
1635 Coupe 2
1639 Coupe 2
1643 Coupe 2
1650 Coupe 2
1651 Coupe 2
1656 Coupe 2
1657 Coupe 2
1658 Coupe 2
1663 Coupe 2
1675 Coupe 2
1685 Coupe 2
1686 Coupe 2
1688 Coupe 2
1696 Coupe 2
1697 Coupe 2
1712 Coupe 2
1715 Coupe 2
1716 Coupe 2
1722 Coupe 2
1763 Coupe 2
1764 Coupe 2
1774 Coupe 2
1791 Coupe 2
1792 Coupe 2
1797 Coupe 2
1801 Coupe 2
1804 Coupe 2
1809 Coupe 2
1839 Coupe 2
1850 Coupe 2
1853 Coupe 2
1854 Coupe 2
1855 Coupe 2
1856 Coupe 2
1869 COUPE 2
1881 Coupe 2
1883 Coupe 2
1887 Coupe 2
1893 Coupe 2
1902 Coupe 2
1903 Coupe 2
1923 Coupe 2
1926 Coupe 2
1935 Coupe 2
1936 Coupe 2
1948 Coupe 2
1952 Coupe 2
1960 Coupe 2
1961 Coupe 2
1962 Coupe 2
1968 Coupe 2
1973 Coupe 2
1981 Coupe 2
1986 Coupe 2
1992 Coupe 2
1994 Coupe 2
1999 Coupe 2
2005 Coupe 2
2010 Coupe 2
2031 Coupe 2
2035 Coupe 2
2047 Coupe 2
2050 Coupe 2
2058 Coupe 2
2063 Coupe 2
2066 Coupe 2
2069 Coupe 2
2103 Coupe 2
2105 Coupe 2
2106 Coupe 2
2113 Coupe 2
2121 Coupe 2
2125 Coupe 2
2143 Coupe 2
2145 Coupe 2
2148 Coupe 2
2157 Coupe 2
2165 Coupe 2
2167 Coupe 2
2176 Coupe 2
2178 Coupe 2
2186 Coupe 2
2187 Coupe 2
2192 Coupe 2
2194 Coupe 2
2201 Coupe 2
2218 Coupe 2
2235 Coupe 2
2238 Coupe 2
2243 Coupe 2
2244 Coupe 2
2245 Coupe 2
2246 Coupe 2
2264 Coupe 2
2272 Coupe 2
2275 Coupe 2
2278 Coupe 2
2279 Coupe 2
2280 Coupe 2
2282 Coupe 2
2294 Coupe 2
2301 Coupe 2
2302 Coupe 2
2303 Coupe 2
2313 Coupe 2
2319 Coupe 2
2321 Coupe 2
2334 Coupe 2
2335 Coupe 2
2338 Coupe 2
2346 Coupe 2
2348 Coupe 2
2353 Coupe 2
2357 Coupe 2
2367 Coupe 2
2375 Coupe 2
2377 Coupe 2
2383 Coupe 2
2386 Coupe 2
2393 Coupe 2
2396 Coupe 2
2398 Coupe 2
2409 Coupe 2
2413 Coupe 2
2416 Coupe 2
2418 Coupe 2
2420 Coupe 2
2442 Coupe 2
2447 Coupe 2
2448 Coupe 2
2451 Coupe 2
2453 Coupe 2
2455 Coupe 2
2457 Coupe 2
2459 Coupe 2
2485 COUPE 2
2487 Coupe 2
2488 Coupe 2
2490 Coupe 2
2504 Coupe 2
2505 Coupe 2
2510 Coupe 2
2526 Coupe 2
2529 Coupe 2
2533 Coupe 2
2535 Coupe 2
2537 Coupe 2
2542 Coupe 2
2545 Coupe 2
2546 Coupe 2
2549 Coupe 2
2556 Coupe 2
2567 Coupe 2
2568 Coupe 2
2585 Coupe 2
2590 Coupe 2
2593 Coupe 2
2596 Coupe 2
2598 Coupe 2
2603 Coupe 2
2607 Coupe 2
2608 Coupe 2
2609 Coupe 2
2615 Coupe 2
2624 Coupe 2
2628 Coupe 2
2632 Coupe 2
2659 Coupe 2
2660 Coupe 2
2662 Coupe 2
2663 Coupe 2
2664 Coupe 2
2665 Coupe 2
2669 Coupe 2
2674 Coupe 2
2675 Coupe 2
2676 Coupe 2
2681 Coupe 2
2689 Coupe 2
2695 Coupe 2
2696 Coupe 2
2699 Coupe 2
2701 Coupe 2
2715 Coupe 2
2720 Coupe 2
2721 Coupe 2
2722 Coupe 2
2723 Coupe 2
2725 Coupe 2
BodyType cluster
10 SUV 3
11 SUV 3
28 SUV 3
33 SUV 3
86 SUV 3
93 SUV 3
144 SUV 3
162 SUV 3
177 SUV 3
199 SUV 3
209 SUV 3
215 SUV 3
222 SUV 3
256 SUV 3
278 SUV 3
290 SUV 3
307 SUV 3
315 SUV 3
318 SUV 3
320 SUV 3
322 SUV 3
328 SUV 3
339 SUV 3
340 SUV 3
376 SUV 3
383 SUV 3
406 SUV 3
412 SUV 3
416 SUV 3
422 SUV 3
429 SUV 3
435 SUV 3
443 SUV 3
467 SUV 3
474 SUV 3
488 SUV 3
505 SUV 3
532 SUV 3
561 SUV 3
606 SUV 3
611 SUV 3
612 SUV 3
613 SUV 3
614 SUV 3
615 SUV 3
616 SUV 3
618 SUV 3
619 SUV 3
621 SUV 3
623 SUV 3
636 SUV 3
641 SUV 3
657 SUV 3
685 SUV 3
699 SUV 3
749 SUV 3
765 SUV 3
785 SUV 3
801 SUV 3
807 SUV 3
817 SUV 3
818 SUV 3
829 SUV 3
830 SUV 3
842 SUV 3
852 SUV 3
862 SUV 3
875 SUV 3
876 SUV 3
877 SUV 3
884 SUV 3
885 SUV 3
886 SUV 3
888 SUV 3
890 SUV 3
897 SUV 3
900 SUV 3
908 SUV 3
909 SUV 3
938 SUV 3
945 SUV 3
949 SUV 3
964 SUV 3
996 SUV 3
1004 SUV 3
1025 SUV 3
1032 SUV 3
1053 SUV 3
1069 SUV 3
1077 SUV 3
1090 SUV 3
1097 SUV 3
1112 SUV 3
1138 SUV 3
1139 SUV 3
1182 SUV 3
1192 SUV 3
1216 SUV 3
1232 SUV 3
1263 SUV 3
1264 SUV 3
1270 SUV 3
1297 SUV 3
1333 SUV 3
1342 SUV 3
1345 SUV 3
1349 SUV 3
1384 SUV 3
1409 SUV 3
1414 SUV 3
1432 SUV 3
1433 SUV 3
1438 SUV 3
1449 SUV 3
1450 SUV 3
1452 SUV 3
1453 SUV 3
1454 SUV 3
1455 SUV 3
1463 SUV 3
1464 SUV 3
1465 SUV 3
1473 SUV 3
1481 SUV 3
1492 SUV 3
1501 SUV 3
1504 SUV 3
1505 SUV 3
1507 SUV 3
1512 SUV 3
1515 SUV 3
1540 SUV 3
1542 SUV 3
1572 SUV 3
1593 SUV 3
1596 SUV 3
1629 SUV 3
1634 SUV 3
1638 SUV 3
1649 SUV 3
1654 SUV 3
1661 SUV 3
1684 SUV 3
1692 SUV 3
1702 SUV 3
1759 SUV 3
1761 SUV 3
1767 SUV 3
1786 SUV 3
1795 SUV 3
1798 SUV 3
1807 SUV 3
1812 SUV 3
1815 SUV 3
1821 SUV 3
1822 SUV 3
1827 SUV 3
1836 SUV 3
1840 SUV 3
1841 SUV 3
1861 SUV 3
1863 SUV 3
1864 SUV 3
1898 SUV 3
1909 SUV 3
1912 SUV 3
1913 SUV 3
1915 SUV 3
1916 SUV 3
1950 SUV 3
1951 SUV 3
1972 SUV 3
1991 SUV 3
1998 SUV 3
2001 SUV 3
2015 SUV 3
2017 SUV 3
2023 SUV 3
2027 SUV 3
2041 SUV 3
2044 SUV 3
2052 SUV 3
2054 SUV 3
2057 SUV 3
2081 SUV 3
2098 SUV 3
2146 SUV 3
2152 SUV 3
2159 SUV 3
2172 SUV 3
2204 SUV 3
2205 SUV 3
2206 SUV 3
2207 SUV 3
2208 SUV 3
2219 SUV 3
2223 SUV 3
2225 SUV 3
2226 SUV 3
2227 suv 3
2228 SUV 3
2229 SUV 3
2230 SUV 3
2247 SUV 3
2249 SUV 3
2255 SUV 3
2259 SUV 3
2299 SUV 3
2307 SUV 3
2308 SUV 3
2309 SUV 3
2312 SUV 3
2316 SUV 3
2342 SUV 3
2343 SUV 3
2385 SUV 3
2406 SUV 3
2407 SUV 3
2422 SUV 3
2423 SUV 3
2437 SUV 3
2444 SUV 3
2452 SUV 3
2456 SUV 3
2484 SUV 3
2498 SUV 3
2547 SUV 3
2611 SUV 3
2630 SUV 3
2641 SUV 3
2644 SUV 3
2645 SUV 3
2647 SUV 3
2656 SUV 3
2691 SUV 3
2692 SUV 3
2729 SUV 3
2753 SUV 3
2766 SUV 3
2772 SUV 3
2783 SUV 3
2797 SUV 3
2809 SUV 3
2811 SUV 3
2812 SUV 3
2815 SUV 3
2822 SUV 3
2832 SUV 3
2835 SUV 3
2838 SUV 3
2873 SUV 3
2877 SUV 3
2878 SUV 3
2950 SUV 3
2970 SUV 3
2995 SUV 3
3017 SUV 3
3071 SUV 3
3081 SUV 3
3082 SUV 3
3104 SUV 3
3124 SUV 3
3153 SUV 3
3154 SUV 3
3179 SUV 3
3191 SUV 3
3192 SUV 3
3197 SUV 3
3226 SUV 3
3252 SUV 3
3265 SUV 3
3275 SUV 3
3280 SUV 3
3285 SUV 3
3314 SUV 3
3320 SUV 3
3330 SUV 3
3366 SUV 3
3397 SUV 3
3418 SUV 3
3423 SUV 3
3436 SUV 3
3465 SUV 3
3466 SUV 3
3468 SUV 3
3469 SUV 3
3470 SUV 3
3471 SUV 3
3472 SUV 3
3491 SUV 3
3517 SUV 3
3537 SUV 3
3556 SUV 3
3562 suv 3
3563 SUV 3
3578 SUV 3
3582 SUV 3
3595 SUV 3
3611 SUV 3
3615 SUV 3
3618 SUV 3
3657 SUV 3
3663 SUV 3
3680 SUV 3
3716 SUV 3
3741 SUV 3
3744 SUV 3
3814 SUV 3
3834 SUV 3
3835 SUV 3
3836 SUV 3
3837 SUV 3
3838 SUV 3
3839 SUV 3
3845 SUV 3
3860 SUV 3
3861 SUV 3
3862 SUV 3
3863 SUV 3
3864 SUV 3
3865 SUV 3
3938 SUV 3
3939 SUV 3
3942 SUV 3
3943 SUV 3
3944 SUV 3
3945 SUV 3
3946 SUV 3
3947 SUV 3
3948 SUV 3
3949 SUV 3
3952 SUV 3
3953 SUV 3
3955 SUV 3
3956 SUV 3
3957 SUV 3
3992 SUV 3
3993 SUV 3
3994 SUV 3
3995 SUV 3
3998 SUV 3
4003 SUV 3
4031 SUV 3
4032 SUV 3
4033 SUV 3
4039 SUV 3
4040 SUV 3
4046 SUV 3
4050 SUV 3
4051 SUV 3
4052 SUV 3
4053 SUV 3
4054 SUV 3
4060 SUV 3
4064 SUV 3
4068 SUV 3
4076 SUV 3
4080 SUV 3
4081 SUV 3
4087 SUV 3
4095 SUV 3
4111 SUV 3
4118 SUV 3
4135 SUV 3
4150 SUV 3
4166 SUV 3
4243 SUV 3
4252 SUV 3
4288 SUV 3
4290 SUV 3
4291 SUV 3
4303 SUV 3
4320 SUV 3
4324 SUV 3
4325 SUV 3
4326 SUV 3
4327 SUV 3
4351 SUV 3
4359 SUV 3
4360 SUV 3
4402 SUV 3
4403 SUV 3
4405 SUV 3
4406 SUV 3
4442 SUV 3
4451 SUV 3
4452 SUV 3
4459 SUV 3
4461 SUV 3
4478 SUV 3
4489 SUV 3
4505 SUV 3
4536 SUV 3
4552 SUV 3
4557 SUV 3
4567 SUV 3
4589 SUV 3
4597 SUV 3
4598 SUV 3
4603 SUV 3
4616 SUV 3
4633 SUV 3
4652 SUV 3
4661 SUV 3
4674 SUV 3
4683 SUV 3
4684 SUV 3
4693 SUV 3
4702 SUV 3
4703 SUV 3
4712 SUV 3
4713 SUV 3
4723 SUV 3
4749 SUV 3
4750 SUV 3
4760 SUV 3
4778 SUV 3
4793 SUV 3
4837 SUV 3
4851 SUV 3
4852 SUV 3
4854 SUV 3
4856 SUV 3
4857 SUV 3
4858 SUV 3
4859 SUV 3
4867 SUV 3
4891 SUV 3
4895 SUV 3
4908 SUV 3
4924 SUV 3
4929 SUV 3
4933 SUV 3
4935 SUV 3
4936 SUV 3
4937 SUV 3
4938 SUV 3
4939 SUV 3
4940 SUV 3
4952 SUV 3
4953 SUV 3
4959 SUV 3
4960 SUV 3
4961 SUV 3
4962 SUV 3
4963 SUV 3
4964 SUV 3
4965 SUV 3
4966 SUV 3
4969 SUV 3
4970 SUV 3
4971 SUV 3
4973 SUV 3
4974 SUV 3
4975 SUV 3
4983 SUV 3
4989 SUV 3
4993 SUV 3
5000 SUV 3
5011 SUV 3
5037 SUV 3
5038 SUV 3
5039 SUV 3
5040 SUV 3
5041 SUV 3
5042 SUV 3
5043 SUV 3
5044 SUV 3
5045 SUV 3
5047 SUV 3
5095 SUV 3
5097 SUV 3
5117 SUV 3
5118 SUV 3
5126 SUV 3
5127 SUV 3
5128 SUV 3
5132 SUV 3
5135 SUV 3
5137 SUV 3
5138 SUV 3
5139 SUV 3
5140 SUV 3
5142 SUV 3
5143 SUV 3
5145 SUV 3
5148 SUV 3
5153 SUV 3
5164 SUV 3
5165 SUV 3
5171 SUV 3
5176 SUV 3
5183 SUV 3
5194 SUV 3
5231 SUV 3
5249 SUV 3
5251 SUV 3
5254 SUV 3
5255 SUV 3
5256 SUV 3
BodyType cluster
0 Sedan 4
5 Sedan 4
6 Sedan 4
16 Sedan 4
18 Sedan 4
22 Sedan 4
23 Sedan 4
25 Sedan 4
27 Sedan 4
34 Sedan 4
44 Sedan 4
53 Sedan 4
55 Sedan 4
60 Sedan 4
61 Sedan 4
63 Sedan 4
65 Sedan 4
67 Sedan 4
75 Sedan 4
76 Sedan 4
83 Sedan 4
91 Sedan 4
107 Sedan 4
110 Sedan 4
113 Sedan 4
115 Sedan 4
125 Sedan 4
159 Sedan 4
161 Sedan 4
185 Sedan 4
189 Sedan 4
192 Sedan 4
198 Sedan 4
204 Sedan 4
210 Sedan 4
211 Sedan 4
223 Sedan 4
225 SEDAN 4
227 Sedan 4
257 Sedan 4
263 Sedan 4
264 Sedan 4
265 Sedan 4
266 Sedan 4
281 Sedan 4
289 Sedan 4
303 Sedan 4
308 Sedan 4
310 Sedan 4
327 Sedan 4
336 Sedan 4
342 Sedan 4
343 Sedan 4
360 Sedan 4
381 Sedan 4
382 Sedan 4
401 Sedan 4
402 Sedan 4
405 Sedan 4
408 Sedan 4
414 Sedan 4
419 Sedan 4
442 Sedan 4
476 Sedan 4
497 Sedan 4
510 Sedan 4
521 Sedan 4
531 Sedan 4
545 SEDAN 4
546 SEDAN 4
568 Sedan 4
586 Sedan 4
596 Sedan 4
597 SEDAN 4
624 Sedan 4
625 Sedan 4
627 Sedan 4
630 Sedan 4
652 Sedan 4
653 Sedan 4
662 Sedan 4
663 Sedan 4
665 Sedan 4
668 Sedan 4
669 Sedan 4
670 Sedan 4
683 Sedan 4
693 Sedan 4
695 Sedan 4
697 Sedan 4
703 Sedan 4
709 Sedan 4
712 Sedan 4
715 Sedan 4
730 Sedan 4
742 Sedan 4
745 Sedan 4
746 Sedan 4
753 Sedan 4
779 Sedan 4
781 Sedan 4
782 Sedan 4
802 Sedan 4
804 Sedan 4
824 Sedan 4
834 Sedan 4
835 Sedan 4
836 Sedan 4
840 Sedan 4
894 Sedan 4
902 Sedan 4
903 Sedan 4
904 Sedan 4
905 Sedan 4
913 Sedan 4
925 Sedan 4
947 Sedan 4
965 Sedan 4
989 Sedan 4
990 Sedan 4
1014 Sedan 4
1015 Sedan 4
1028 Sedan 4
1029 Sedan 4
1030 Sedan 4
1031 Sedan 4
1047 Sedan 4
1049 Sedan 4
1060 Sedan 4
1062 Sedan 4
1091 Sedan 4
1092 Sedan 4
1094 Sedan 4
1095 Sedan 4
1100 Sedan 4
1103 Sedan 4
1125 Sedan 4
1127 Sedan 4
1134 Sedan 4
1140 Sedan 4
1141 Sedan 4
1171 Sedan 4
1176 Sedan 4
1178 Sedan 4
1187 Sedan 4
1189 Sedan 4
1227 Sedan 4
1237 Sedan 4
1242 Sedan 4
1243 Sedan 4
1249 Sedan 4
1254 Sedan 4
1258 Sedan 4
1265 Sedan 4
1278 Sedan 4
1285 Sedan 4
1290 Sedan 4
1292 Sedan 4
1296 Sedan 4
1299 Sedan 4
1300 Sedan 4
1318 SEDAN 4
1326 SEDAN 4
1335 SEDAN 4
1350 Sedan 4
1353 SEDAN 4
1357 SEDAN 4
1358 SEDAN 4
1359 Sedan 4
1362 Sedan 4
1364 SEDAN 4
1368 Sedan 4
1374 Sedan 4
1375 sedan 4
1376 SEDAN 4
1380 SEDAN 4
1388 Sedan 4
1389 Sedan 4
1391 Sedan 4
1392 Sedan 4
1394 Sedan 4
1396 Sedan 4
1398 Sedan 4
1402 Sedan 4
1427 Sedan 4
1429 Sedan 4
1437 Sedan 4
1442 Sedan 4
1443 Sedan 4
1451 Sedan 4
1456 Sedan 4
1457 Sedan 4
1458 Sedan 4
1460 Sedan 4
1461 Sedan 4
1462 Sedan 4
1467 Sedan 4
1468 Sedan 4
1475 Sedan 4
1478 Sedan 4
1479 Sedan 4
1487 Sedan 4
1493 Sedan 4
1498 Sedan 4
1509 Sedan 4
1517 Sedan 4
1518 Sedan 4
1520 Sedan 4
1521 Sedan 4
1528 Sedan 4
1536 Sedan 4
1559 Sedan 4
1584 Sedan 4
1612 Sedan 4
1625 Sedan 4
1628 Sedan 4
1631 Sedan 4
1633 Sedan 4
1636 Sedan 4
1637 Sedan 4
1642 Sedan 4
1648 Sedan 4
1671 Sedan 4
1683 Sedan 4
1687 Sedan 4
1691 Sedan 4
1698 Sedan 4
1705 Sedan 4
1714 Sedan 4
1751 Sedan 4
1771 Sedan 4
1781 Sedan 4
1785 Sedan 4
1799 Sedan 4
1851 Sedan 4
1858 Sedan 4
1859 Sedan 4
1867 SEDAN 4
1876 Sedan 4
1878 Sedan 4
1885 Sedan 4
1895 Sedan 4
1917 Sedan 4
1941 Sedan 4
1944 Sedan 4
1958 Sedan 4
1959 Sedan 4
1977 Sedan 4
1989 Sedan 4
1993 Sedan 4
2003 Sedan 4
2007 Sedan 4
2024 Sedan 4
2025 Sedan 4
2030 Sedan 4
2038 Sedan 4
2043 Sedan 4
2056 Sedan 4
2068 Sedan 4
2078 Sedan 4
2090 Sedan 4
2101 Sedan 4
2107 Sedan 4
2108 Sedan 4
2109 Sedan 4
2120 Sedan 4
2123 Sedan 4
2134 Sedan 4
2144 Sedan 4
2147 Sedan 4
2149 Sedan 4
2150 Sedan 4
2151 Sedan 4
2158 Sedan 4
2173 Sedan 4
2175 Sedan 4
2189 Sedan 4
2190 Sedan 4
2196 Sedan 4
2217 Sedan 4
2265 Sedan 4
2274 Sedan 4
2277 Sedan 4
2292 Sedan 4
2318 Sedan 4
2329 Sedan 4
2344 Sedan 4
2351 Sedan 4
2354 Sedan 4
2363 Sedan 4
2382 Sedan 4
2387 Sedan 4
2389 Sedan 4
2401 Sedan 4
2405 Sedan 4
2414 Sedan 4
2454 Sedan 4
2460 Sedan 4
2462 Sedan 4
2478 Sedan 4
2499 Sedan 4
2502 Sedan 4
2536 Sedan 4
2565 Sedan 4
2573 Sedan 4
2594 Sedan 4
2605 Sedan 4
2621 Sedan 4
2634 Sedan 4
2648 Sedan 4
2688 Sedan 4
2702 Sedan 4
2705 Sedan 4
2716 Sedan 4
2717 Sedan 4
2731 Sedan 4
2742 Sedan 4
2744 Sedan 4
2750 Sedan 4
2767 Sedan 4
2769 Sedan 4
2773 Sedan 4
2778 Sedan 4
2781 Sedan 4
2796 Sedan 4
2805 Sedan 4
2830 Sedan 4
2856 Sedan 4
2872 Sedan 4
2896 Sedan 4
2918 Sedan 4
2919 Sedan 4
2944 Sedan 4
2945 Sedan 4
2949 Sedan 4
2952 Sedan 4
2953 Sedan 4
2955 Sedan 4
2958 Sedan 4
2966 Sedan 4
2972 Sedan 4
2984 Sedan 4
2986 Sedan 4
3010 Sedan 4
3031 Sedan 4
3043 Sedan 4
3057 Sedan 4
3076 Sedan 4
3092 Sedan 4
3100 Sedan 4
3109 Sedan 4
3189 Sedan 4
3190 Sedan 4
3193 Sedan 4
3194 Sedan 4
3196 Sedan 4
3224 Sedan 4
3228 Sedan 4
3242 Sedan 4
3243 Sedan 4
3246 Sedan 4
3268 Sedan 4
3278 Sedan 4
3283 Sedan 4
3284 Sedan 4
3291 Sedan 4
3292 Sedan 4
3293 Sedan 4
3294 Sedan 4
3302 Sedan 4
3308 Sedan 4
3333 Sedan 4
3334 Sedan 4
3337 Sedan 4
3340 Sedan 4
3349 Sedan 4
3351 Sedan 4
3359 Sedan 4
3365 Sedan 4
3399 Sedan 4
3421 Sedan 4
3433 Sedan 4
3440 Sedan 4
3441 Sedan 4
3446 Sedan 4
3455 Sedan 4
3458 Sedan 4
3460 Sedan 4
3475 Sedan 4
3492 Sedan 4
3497 Sedan 4
3498 Sedan 4
3500 Sedan 4
3532 Sedan 4
3560 Sedan 4
3593 Sedan 4
3624 Sedan 4
3665 Sedan 4
3670 Sedan 4
3684 Sedan 4
3710 Sedan 4
3718 Sedan 4
3737 Sedan 4
3740 Sedan 4
3748 Sedan 4
3750 Sedan 4
3754 Sedan 4
3802 Sedan 4
3815 Sedan 4
3817 Sedan 4
3826 Sedan 4
3848 Sedan 4
3854 Sedan 4
3856 Sedan 4
3857 Sedan 4
3858 Sedan 4
3910 Sedan 4
3911 Sedan 4
3912 Sedan 4
3913 Sedan 4
3914 Sedan 4
3915 Sedan 4
3916 Sedan 4
3917 Sedan 4
3958 Sedan 4
3959 Sedan 4
3960 Sedan 4
3961 Sedan 4
3964 Sedan 4
3970 Sedan 4
3971 Sedan 4
3972 Sedan 4
3973 Sedan 4
3974 Sedan 4
3975 Sedan 4
3976 Sedan 4
3979 Sedan 4
3980 Sedan 4
3981 Sedan 4
3982 Sedan 4
3997 Sedan 4
4005 Sedan 4
4041 Sedan 4
4043 Sedan 4
4047 Sedan 4
4048 Sedan 4
4055 Sedan 4
4062 Sedan 4
4063 Sedan 4
4067 Sedan 4
4073 Sedan 4
4074 Sedan 4
4075 Sedan 4
4078 Sedan 4
4079 Sedan 4
4085 Sedan 4
4109 Sedan 4
4115 Sedan 4
4116 Sedan 4
4122 Sedan 4
4125 Sedan 4
4126 Sedan 4
4127 Sedan 4
4131 Sedan 4
4134 Sedan 4
4140 Sedan 4
4143 Sedan 4
4144 Sedan 4
4145 Sedan 4
4161 Sedan 4
4174 Sedan 4
4187 Sedan 4
4190 Sedan 4
4193 Sedan 4
4212 Sedan 4
4224 Sedan 4
4232 Sedan 4
4254 Sedan 4
4273 Sedan 4
4277 Sedan 4
4304 Sedan 4
4330 Sedan 4
4331 Sedan 4
4352 Sedan 4
4370 Sedan 4
4372 Sedan 4
4384 Sedan 4
4396 Sedan 4
4424 Sedan 4
4425 Sedan 4
4429 Sedan 4
4439 Sedan 4
4458 Sedan 4
4469 Sedan 4
4471 Sedan 4
4483 Sedan 4
4495 Sedan 4
4499 Sedan 4
4501 Sedan 4
4520 Sedan 4
BodyType cluster
1 Convertible 5
2 Convertible 5
47 Convertible 5
68 Convertible 5
69 Convertible 5
70 Convertible 5
80 Convertible 5
85 Convertible 5
94 Convertible 5
96 Convertible 5
98 Convertible 5
99 Convertible 5
101 Convertible 5
106 Convertible 5
109 Convertible 5
132 Convertible 5
133 Convertible 5
139 Convertible 5
140 Convertible 5
145 Convertible 5
146 Convertible 5
154 Convertible 5
157 Convertible 5
165 Convertible 5
167 Convertible 5
181 Convertible 5
193 Convertible 5
207 Convertible 5
219 Convertible 5
239 Convertible 5
255 Convertible 5
258 Convertible 5
267 Convertible 5
288 2 door convertible 5
312 Convertible 5
330 Convertible 5
338 Convertible 5
344 Convertible 5
346 Convertible 5
349 Convertible 5
350 Convertible 5
385 Convertible 5
388 Convertible 5
394 Convertible 5
400 Convertible 5
418 Convertible 5
423 Convertible 5
437 Convertible 5
440 Convertible 5
459 Convertible 5
460 Convertible 5
490 Convertible 5
491 Convertible 5
502 Convertible 5
508 Convertible 5
518 Convertible 5
524 Convertible 5
530 Convertible 5
538 CONVERTIBLE 5
544 CONVERTIBLE 5
547 CONVERTIBLE 5
549 CONVERTIBLE 5
551 CONVERTIBLE 5
557 CONVERTIBLE 5
566 CONVERTIBLE 5
567 CONVERTIBLE 5
570 CONVERTIBLE 5
571 CONVERTIBLE 5
572 CONVERTIBLE 5
578 CONVERTIBLE 5
579 CONVERTIBLE 5
585 CONVERTIBLE 5
587 Convertible 5
588 CONVERTIBLE 5
589 CONVERTIBLE 5
591 CONVERTIBLE 5
600 Convertible 5
604 Convertible 5
605 Convertible 5
626 Convertible 5
629 Convertible 5
640 Convertible 5
655 Convertible 5
656 Convertible 5
658 Convertible 5
673 Convertible 5
686 Convertible 5
687 Convertible 5
705 Convertible 5
708 Convertible 5
716 Convertible 5
726 2 door convertible 5
727 Convertible 5
738 Convertible 5
739 Convertible 5
743 Convertible 5
744 Convertible 5
747 Convertible 5
751 Convertible 5
764 Convertible 5
773 Convertible 5
774 Convertible 5
832 Convertible 5
844 Convertible 5
848 Convertible 5
853 Convertible 5
864 Convertible 5
870 Convertible 5
872 Convertible 5
879 Convertible 5
882 Convertible 5
912 Convertible 5
920 Convertible 5
922 Convertible 5
934 Convertible 5
935 Convertible 5
939 Convertible 5
941 Convertible 5
942 Convertible 5
967 Convertible 5
968 Convertible 5
969 Convertible 5
970 Convertible 5
971 Convertible 5
972 Convertible 5
973 Convertible 5
974 Convertible 5
976 Convertible 5
982 Convertible 5
984 Convertible 5
985 Convertible 5
995 Convertible 5
998 Convertible 5
1001 Convertible 5
1005 Convertible 5
1009 Convertible 5
1010 Convertible 5
1020 Convertible 5
1024 Convertible 5
1044 Convertible 5
1048 Convertible 5
1064 Convertible 5
1074 4dr convertible 5
1084 Convertible 5
1087 Convertible 5
1109 Convertible 5
1116 Convertible 5
1121 Convertible 5
1132 Convertible 5
1142 Convertible 5
1160 Convertible 5
1161 Convertible 5
1163 Convertible 5
1164 Convertible 5
1165 Convertible 5
1166 Convertible 5
1167 Convertible 5
1168 Convertible 5
1173 Convertible 5
1175 Convertible 5
1191 Convertible 5
1197 Convertible 5
1234 Convertible 5
1238 Convertible 5
1246 Convertible 5
1271 Convertible 5
1273 Convertible 5
1275 Convertible 5
1276 Convertible 5
1277 Convertible 5
1279 Convertible 5
1309 Convertible 5
1312 Convertible 5
1313 Convertible 5
1314 Convertible 5
1315 Convertible 5
1316 convertible 5
1334 CONVERTIBLE 5
1337 CONVERTIBLE 5
1338 CONVERTIBLE 5
1354 CONVERTIBLE 5
1366 CONVERTIBLE 5
1367 Convertible 5
1371 CONVERTIBLE 5
1373 Convertible 5
1377 convertible 5
1411 Convertible 5
1418 Convertible 5
1470 Convertible 5
1486 Convertible 5
1490 Convertible 5
1500 Convertible 5
1502 Convertible 5
1503 Convertible 5
1510 Convertible 5
1514 Convertible 5
1523 Convertible 5
1549 Convertible 5
1561 Convertible 5
1569 Convertible 5
1573 Convertible 5
1577 Convertible 5
1605 Convertible 5
1611 Convertible 5
1624 Convertible 5
1627 Convertible 5
1632 Convertible 5
1640 Convertible 5
1641 Convertible 5
1660 Convertible 5
1667 Convertible 5
1679 Convertible 5
1682 Convertible 5
1699 Convertible 5
1720 Convertible 5
1721 Convertible 5
1723 Convertible 5
1757 Convertible 5
1765 Convertible 5
1766 Convertible 5
1775 Convertible 5
1788 Convertible 5
1803 Convertible 5
1865 Convertible 5
1874 Convertible 5
1888 Convertible 5
1896 Convertible 5
1904 Convertible 5
1934 Convertible 5
1938 Convertible 5
1939 Convertible 5
1942 Convertible 5
1955 Convertible 5
1957 Convertible 5
1963 Convertible 5
1996 Convertible 5
2011 Convertible 5
2012 Convertible 5
2013 Convertible 5
2021 Convertible 5
2037 Convertible 5
2048 Convertible 5
2061 Convertible 5
2071 Convertible 5
2077 Convertible 5
2083 Convertible 5
2100 Convertible 5
2116 Convertible 5
2119 Convertible 5
2126 Convertible 5
2136 Convertible 5
2137 Convertible 5
2138 Convertible 5
2139 Convertible 5
2156 Convertible 5
2160 Convertible 5
2163 Convertible 5
2164 Convertible 5
2177 Convertible 5
2179 Convertible 5
2188 Convertible 5
2193 Convertible 5
2195 Convertible 5
2199 Convertible 5
2260 Convertible 5
2261 Convertible 5
2263 Convertible 5
2273 Convertible 5
2276 Convertible 5
2290 Convertible 5
2298 Convertible 5
2325 Convertible 5
2327 Convertible 5
2337 Convertible 5
2350 Convertible 5
2352 Convertible 5
2378 Convertible 5
2381 Convertible 5
2395 Convertible 5
2397 Convertible 5
2399 Convertible 5
2404 Convertible 5
2417 Convertible 5
2427 Convertible 5
2450 Convertible 5
2458 Convertible 5
2476 Convertible 5
2497 Convertible 5
2506 Convertible 5
2507 Convertible 5
2509 Convertible 5
2511 Convertible 5
2514 Convertible 5
2523 Convertible 5
2539 Convertible 5
2548 Convertible 5
2553 convertible 5
2554 Convertible 5
2576 Convertible 5
2604 Convertible 5
2606 Convertible 5
2614 Convertible 5
2622 Convertible 5
2625 Convertible 5
2626 Convertible 5
2629 Convertible 5
2658 Convertible 5
2677 Convertible 5
2678 Convertible 5
2694 Convertible 5
2704 Convertible 5
2730 Convertible 5
2768 Convertible 5
2776 Convertible 5
2779 Convertible 5
2793 Convertible 5
2801 Convertible 5
2802 Convertible 5
2818 Convertible 5
2840 Convertible 5
2888 Convertible 5
2893 Convertible 5
2906 Convertible 5
2915 Convertible 5
2927 Convertible 5
2937 Convertible 5
2940 Convertible 5
2948 Convertible 5
2954 Convertible 5
2956 Convertible 5
2962 Convertible 5
2994 Convertible 5
3016 Convertible 5
3044 Convertible 5
3052 Convertible 5
3061 Convertible 5
3062 Convertible 5
3066 Convertible 5
3067 Convertible 5
3073 Convertible 5
3094 Convertible 5
3103 Convertible 5
3112 Convertible 5
3114 Convertible 5
3165 Convertible 5
3173 Convertible 5
3212 Convertible 5
3239 Convertible 5
3253 Convertible 5
3254 Convertible 5
3255 Convertible 5
3257 Convertible 5
3290 Convertible 5
3295 Convertible 5
3298 Convertible 5
3299 Convertible 5
3317 Convertible 5
3318 Convertible 5
3327 Convertible 5
3353 Convertible 5
3368 Convertible 5
3373 Convertible 5
3374 Convertible 5
3376 Convertible 5
3380 Convertible 5
3387 Convertible 5
3391 Convertible 5
3409 Convertible 5
3414 Convertible 5
3432 Convertible 5
3438 Convertible 5
3443 Convertible 5
3448 Convertible 5
3473 Convertible 5
3479 Convertible 5
3486 Convertible 5
3495 Convertible 5
3501 Convertible 5
3503 Convertible 5
3504 Convertible 5
3514 Convertible 5
3516 Convertible 5
3530 Convertible 5
3540 Convertible 5
3550 Convertible 5
3552 Convertible 5
3553 Convertible 5
3554 Convertible 5
3558 Convertible 5
3572 Convertible 5
3573 Convertible 5
3598 Convertible 5
3599 Convertible 5
3619 Convertible 5
3653 Convertible 5
3671 Convertible 5
3681 Convertible 5
3713 Convertible 5
3715 Convertible 5
3720 Convertible 5
3723 Convertible 5
3752 Convertible 5
3753 Convertible 5
3757 Convertible 5
3758 Convertible 5
3799 Convertible 5
3803 Convertible 5
3808 Convertible 5
3809 Convertible 5
3812 Convertible 5
3822 Convertible 5
3832 Convertible 5
3967 Convertible 5
3968 Convertible 5
4070 Convertible 5
4083 Convertible 5
4084 Convertible 5
4091 Convertible 5
4103 Convertible 5
4123 Convertible 5
4124 Convertible 5
4139 Convertible 5
4141 Convertible 5
4153 Convertible 5
4163 Convertible 5
4167 Convertible 5
4182 Convertible 5
4216 Convertible 5
4226 Convertible 5
4227 Convertible 5
4247 Convertible 5
4250 Convertible 5
4257 Convertible 5
4258 Convertible 5
4259 Convertible 5
4285 Convertible 5
4286 Convertible 5
4292 Convertible 5
4293 Convertible 5
4296 Convertible 5
4297 Convertible 5
4301 Convertible 5
4302 Convertible 5
4349 Convertible 5
4362 Convertible 5
4368 Convertible 5
4376 Convertible 5
4382 Convertible 5
4388 Convertible 5
4392 Convertible 5
4395 Convertible 5
4398 Convertible 5
4399 Convertible 5
4420 Convertible 5
4422 Convertible 5
4433 Convertible 5
4444 Convertible 5
4449 Convertible 5
4457 Convertible 5
4460 Convertible 5
4477 Convertible 5
4485 Convertible 5
4486 Convertible 5
4496 Convertible 5
4507 Convertible 5
4511 Convertible 5
4512 Convertible 5
4541 Convertible 5
4545 Convertible 5
4554 Convertible 5
4558 Convertible 5
4559 Convertible 5
4579 Convertible 5
4601 Convertible 5
4620 Convertible 5
4623 Convertible 5
4638 Convertible 5
4640 Convertible 5
4643 Convertible 5
4644 Convertible 5
4676 Convertible 5
4677 Convertible 5
4680 Convertible 5
4689 Convertible 5
4700 Convertible 5
4714 Convertible 5
4737 Convertible 5
4738 Convertible 5
4739 Convertible 5
4740 Convertible 5
4744 Convertible 5
4754 Convertible 5
4757 Convertible 5
4771 Convertible 5
4788 Convertible 5
4789 Convertible 5
4801 Convertible 5
4805 Convertible 5
4807 Convertible 5
4823 Convertible 5
BodyType cluster
13 4 door/hatchback 6
14 Hatchback 6
32 2 Door Hard Top 6
40 Standard Cargo Van 6
51 2-seater convertible 6
58 LL 6
72 Cargo Van 6
102 Truck 6
111 Fastback 6
114 Fastback 6
124 Limousine 6
128 cpe 6
130 fast back 6
149 2dr Car 6
155 Fastback 6
168 barchetta 6
179 Hatchback 6
180 Limousine 6
195 Fastback 6
212 Minivan 6
228 TRUCK 6
234 Pickup Truck 6
243 Truck 4x4 6
246 CARGO VAN 6
247 Extended Passenger Van 6
253 VAN 6
275 2 Door Hardtop Coupe 6
291 2dr pickup 6
292 pickup truck club cab 6
294 4 dr sedan 6
296 Mach 1 6
298 Hardtop 6
300 Tanker 6
301 Pickup Truck 6
316 Hatchback 6
319 Extended Passenger Van 6
362 GT 6
366 Fiberglass 6
378 Jeep 6
409 Hatchback 6
426 Cab & Chassis 6
432 Limousine 6
441 Trike 6
445 Extended Passenger Van 6
451 Hatchback 6
453 Van Camper 6
456 Roadster Pickup 6
457 Fastback 6
461 Hatchback w/ Targa Top 6
470 Hearse 6
471 Hearse 6
472 Hearse 6
473 Hearse 6
475 Minivan 6
480 Van Camper 6
482 Standard Cargo Van 6
483 Van Camper 6
484 Van Camper 6
486 Extended Passenger Van 6
492 Standard Passenger Van 6
507 Minivan 6
516 Conversion Van 6
526 4 door 6
533 Hearse 6
534 Limousine 6
535 Hearse 6
539 FOUR DOOR SEDAN 6
540 ROADSTER CONVERTIBLE 6
541 SPORT GULL WING COUPE 6
542 CONVERTIBLE ROADSTER 6
543 CONVERTIBLE ROADSTER 6
548 SHORT BED PICK UP 6
553 JEEP 6
555 TWO DOOR COUPE 6
556 HEAVY DUTY PICK UP 6
559 TARGA TOP ROADSTER 6
560 HARD TOP 6
562 TWO DOOR HARD TOP 6
563 SPORT UTILITY VEHICLE 6
565 PICK UP 6
569 SPORT COUPE 6
573 GULLWING COUPE 6
574 CONVERTIBLE ROADSTER 6
575 CONVERTIBLE AND HARD TOP 6
576 SPORT COUPE 6
577 SPORT COUPE 6
580 SPORT UTILITY VEHICLE 6
581 LUXURY SEDAN 6
582 LUXURY SEDAN 6
584 SPORT COUPE 6
590 ROADSTER CONVERTIBLE 6
593 CROUWN COUPE 6
594 FOUR DOOR LUXURY SEDAN 6
598 CONVERTIBLES 6
603 Fastback 6
628 2dr Car 6
713 Hatchback 6
714 van 6
717 COUNTRY SQUIRE WAGON 6
721 Bubbletop 6
722 Minivan 6
750 Fastback 6
758 Cab & Chassis 6
766 Standard Cargo Van 6
772 Cab & Chassis 6
784 2 Door 6
795 4dr Car 6
797 Truck 6
821 RM23 Hardtop 6
826 flatbed 6
828 Straight Truck - Medium Conventional 6
837 4 DOOR SEDAN 6
839 2DR Sedan 6
854 2 door 6
855 Tin Woody station wagon 6
856 2 door hardtop Bel Air 6
859 Hatchback 6
867 single cab long bed 6
883 Hardtop Sedan 6
906 Minivan 6
917 Other 6
921 Other 6
933 Other 6
950 Pick up 6
957 Hatchback 6
961 Extended Passenger Van 6
979 Cab & Chassis 6
1002 Hatchback 6
1008 4door 6
1011 2DR 6
1012 4door 6
1013 Hatchback 6
1017 T Top 6
1018 Aluminum 6
1019 2dr Car 6
1027 Pick up 6
1038 Standard Passenger Van 6
1041 Fastback 6
1042 Hatchback 6
1043 Pick up truck 6
1050 h2 6
1054 PANEL 6
1059 Hatchback 6
1086 Hatchback 6
1107 Hatchback 6
1111 Minivan 6
1113 Video in listing 6
1114 Hatchback 6
1174 reg cab 6
1179 Hatchback 6
1202 pick up truck 6
1213 Hatchback 6
1217 Turbo 6
1240 4 Door 6
1260 Buggy 6
1267 Fastback 6
1272 2dr Car 6
1280 4 door 6
1283 Hatchback 6
1284 Van Camper 6
1289 Hatchback 6
1294 Hatchback 6
1295 Hatchback 6
1306 Targa 6
1322 PICKUP TRUCK 6
1323 pickup truck 6
1327 HARDTOP CONVERTIBLE 6
1328 Stepside Pickup 6
1330 auto/pickup 6
1332 TARGA 6
1340 PICKUP TRUCK 6
1341 hatchback 6
1343 5 door hatchback 6
1352 TWO DOOR SEDAN 6
1372 ROADSTER 6
1385 Van Camper 6
1387 Extended Passenger Van 6
1393 Hatchback 6
1408 EL CAMINO 6
1425 Fastback 6
1426 Limousine 6
1428 Standard Passenger Van 6
1444 Hatchback 6
1445 Hatchback 6
1447 Hatchback 6
1448 Hatchback 6
1466 Hatchback 6
1469 2d : 2 Door Hard TOP 6
1489 Truck 6
1496 Riviera 6
1537 2dr Car 6
1554 Fastback 6
1560 Hatchback 6
1564 4dr Car 6
1576 2 Door Hard Top 6
1585 Truck 6
1586 2dr Car 6
1587 2dr Car 6
1588 4dr Coupe 6
1590 Hatchback 6
1591 2D SDN 6
1592 Hatchback 6
1608 Roadster 6
1609 Pick up truck 6
1626 Limousine 6
1645 Hatchback 6
1659 Hatchback 6
1689 4dr Car 6
1693 Hatchback 6
1694 Hatchback 6
1701 Hard Top 6
1708 4dr Car 6
1710 Hatchback 6
1713 Extended Passenger Van 6
1717 -- 6
1718 Flatbed 6
1754 Hatchback 6
1755 Hatchback 6
1783 Crossover 6
1794 Hatchback 6
1800 2 dr. hdtp 6
1830 camper-van 6
1834 regular cab truck 6
1842 Extra cab truck 6
1846 Van Camper 6
1860 t tops 6
1868 TRUCK 6
1873 Cab & Chassis 6
1875 Pickup Truck 6
1882 Hatchback 6
1900 Hatchback 6
1920 Flatbed 6
1921 Tudor 6
1922 Minivan 6
1925 Cab & Chassis 6
1943 4 DOOR SEDAN 6
1978 Limousine 6
1984 Hatchback 6
2006 Acces Cab 6
2018 Hatchback 6
2032 Truck 6
2033 Fastback 6
2042 Sports car 6
2059 Hatchback 6
2065 Minivan 6
2073 2dr 6
2075 2 dr 6
2076 2DR SEDAN 6
2084 Pickup Truck 6
2087 Hatchback 6
2092 Dump Bed 6
2115 Fastback 6
2117 CONV 6
2130 Fastback 6
2132 4 Door Limited 6
2135 Standard Passenger Van 6
2154 Hatchback 6
2166 Square body 6
2174 2 Door 6
2185 4 door pickup 6
2257 Van Camper 6
2262 Van Camper 6
2271 Hatchback 6
2300 Fastback 6
2314 Van Camper 6
2317 4dr Car 6
2320 Targa 6
2322 Truck 6
2324 Single cab 6
2326 2 Door Coupe 6
2336 Step Side 6
2341 Fleetside truck 6
2347 ConvertibleK 6
2355 Cab & Chassis 6
2368 Cab & Chassis 6
2388 Minivan 6
2391 Hatchback 6
2400 Extended Passenger Van 6
2412 Extended Cargo Van 6
2419 Utility 6
2421 Limousine 6
2441 Fastback 6
2463 4dr Car 6
2464 4dr Car 6
2465 Sport Utility 6
2466 Sport Utility 6
2468 2dr Car 6
2469 Sport Utility 6
2472 Fastback 6
2477 Fastback 6
2479 Fastback 6
2481 2 DOOR 6
2482 roadster 6
2489 Fastback 6
2491 Hatchback 6
2492 Targa 6
2493 safari 6
2496 4 door HT 6
2503 Two Hardtop 6
2508 Scout Half-Cab 4X4 6
2524 2 door coupe 6
2525 4 DOOR SUV 6
2538 Hatchback 6
2581 Fastback 6
2582 Fastback 6
2587 Fastback 6
2595 Sportsroof 6
2599 Hardtop 6
2613 Hatchback 6
2619 Hatchback 6
2633 Minivan 6
2636 2 door 6
2637 Single Cab 6
2640 Cab & Chassis 6
2652 2 door 6
2661 pick up 1/2 ton 6
2666 pick up 1/2 ton 6
2670 Fastback 6
2673 Roadster 6
2683 Full Size 6
2700 roadster 6
2707 Cab & Chassis 6
2728 Sedan 2-door 6
2751 Poptop Camper 6
2780 VAN TRUCK CONVERSION 6
2784 SEDAN-PREMIUM 6
2785 Premium Sports Sedan 6
2790 Hatchback 6
2794 Minivan 6
2795 Sedan Deville Hardtop 6
2798 Hatchback 6
2799 GT-S Hatchback 6
2800 Hatchback 6
2803 Premium Ultra Luxury Sedan 6
2806 LUXURY SEDAN 6
2807 Minivan 6
2808 Sports Sedan 6
2813 Roadster 6
2827 Fastback 6
2834 5 Window Coupe 6
2837 BOX TRUCK 6
2844 Hatchback 6
2845 Standard Passenger Van 6
2848 Van 6
2849 Extended Passenger Van 6
2852 SPORT SEDAN 6
2858 hardtop 6
2859 Hatchback 6
2861 E Body Coupe 6
2863 Hatchback 6
2868 Standard Passenger Van 6
2875 Standard Passenger Van 6
2876 Hatchback 6
2881 ranchero 6
2884 Pickup Truck 6
2895 Extended Passenger Van 6
2899 ht 6
2901 Other 6
2914 2 Dr. HT 6
2921 CLASSIC CARS 6
2929 Extended Passenger Van 6
2933 Minivan 6
2946 Hatchback 6
2957 Short Bed 6
2967 Van Camper 6
2971 Van Camper 6
2976 ROADSTER 6
3015 2door hard top 6
3018 Limousine 6
3027 Open Cockpit 6
3029 -- 6
3033 Cab & Chassis 6
3054 Van 6
3069 2 DOOR TRUCK 6
3096 Extended Passenger Van 6
3113 chopped 6
3115 Fastback 6
3116 Roadster 6
3117 2dr Car 6
3118 4dr Car 6
3119 Sport Utility 6
3120 Sport Utility 6
3121 Sport Utility 6
3122 Sport Utility 6
3123 Sport Utility 6
3125 4dr Car 6
3126 4dr Car 6
3127 4dr Car 6
3128 Sport Utility 6
3129 Sport Utility 6
3130 Sport Utility 6
3131 Sport Utility 6
3132 Sport Utility 6
3133 Sport Utility 6
3134 Sport Utility 6
3135 Sport Utility 6
3136 Sport Utility 6
3137 Sport Utility 6
3138 Sport Utility 6
3139 Sport Utility 6
3140 Sport Utility 6
3141 Sport Utility 6
3142 Sport Utility 6
3143 Sport Utility 6
3144 Sport Utility 6
3145 Sport Utility 6
3146 Sport Utility 6
3147 4dr Car 6
3148 4dr Car 6
3149 4dr Car 6
3150 2dr Car 6
3151 4dr Car 6
3152 4dr Car 6
3158 T-Top 6
3164 Van Camper 6
3168 Cab & Chassis 6
3177 Sedan / Ragtop 6
3178 Van Camper 6
3182 2 door HT 6
3184 Cab & Chassis - Conventional 6
3185 Hatchback 6
3186 Dump Truck 6
3198 4dr Car 6
3203 Fastback 6
3209 Sports car 6
3258 Van Camper 6
3260 Van Camper 6
3262 Sports car 6
3267 2Dr Hardtop 6
3270 2 door coupe 6
3274 Hearse 6
3289 Limousine 6
3300 2 door 6
3307 2 DOOR HARDTOP 6
3311 Van 6
3332 Sedan W/Moonroof 6
3336 Moonroof / Sedan 6
3338 Moonroof Coupe 6
3339 Moon Roof Coupe 6
3341 Carriage Top Sedan 6
3342 Coupe W/Moonroof 6
3343 Moonroof Coupe 6
3344 Hard Top Coupe 6
3345 Coupe W/Moonroof 6
3346 Carriage Top Sedan 6
3347 Carriage Top Sedan 6
3348 Moonroof Sedan 6
3350 Carriage Top Sedan 6
3352 Sedan W/Moonroof 6
3355 Four Door Sedan 6
3358 Sedan W/Moonroof 6
3361 Moonroof Sedan 6
3362 Hard Top Sedan 6
3363 Four Door Sedan 6
3364 Sport Coupe W/Moonroof 6
3367 Four Door Sedan W/Sunroof 6
3369 Four Door Sedan 6
3377 Pickup truck 6
3379 Standard Passenger Van 6
3383 2DR HT 6
3384 Van Camper 6
3390 Jeep 6
3395 Hatchback 6
3402 Extended Passenger Van 6
3404 Seden 6
3429 2DR 6
3430 Fastback 6
3445 Hatchback 6
3449 Extended Passenger Van 6
3474 Sports car 6
3476 Fastback 6
3480 Mini Passenger Van 6
3483 Fury 6
3484 Hard top 6
3485 Limousine 6
3489 Van Camper 6
3506 Roadster 6
3507 Hardtop 6
3513 Hatchback 6
3529 Jeep 6
3538 Cargo Van 6
3539 Passenger Van 6
3557 Sports car 6
3559 Hatchback 6
3570 Truck 6
3579 Fastback 6
3608 Cruiser 6
3622 Sports car 6
3642 Hatchback 6
3647 cargo van 6
3651 Fastback 6
3667 Camper bus weekender 6
3675 2door 6
3685 Fastback 6
3691 Fastback 6
3704 Fastback 6
3709 Sport Utility 6
3711 Cab & Chassis 6
3714 Sports car 6
3721 Van Camper 6
BodyType cluster
20 Standard Cab Pickup 7
21 Standard Cab Pickup 7
26 Standard Cab Pickup 7
78 Crew Cab Pickup 7
82 Extended Cab Pickup 7
88 Crew Cab Pickup 7
90 Standard Cab Pickup 7
92 Standard Cab Pickup 7
116 Crew Cab Pickup 7
118 Standard Cab Pickup 7
119 Standard Cab Pickup 7
121 Crew Cab Pickup 7
138 Extended Cab Pickup 7
141 Standard Cab Pickup 7
142 Pickup 7
148 Standard Cab Pickup 7
158 Extended Cab Pickup 7
160 Standard Cab Pickup 7
164 Crew Cab Pickup 7
175 Standard Cab Pickup 7
200 Pickup 7
201 Crew Cab Pickup 7
218 Extended Crew Cab Pickup 7
220 Crew Cab Pickup 7
226 Standard Cab Pickup 7
229 Crew Cab Pickup 7
251 Standard Cab Pickup 7
252 Standard Cab Pickup 7
254 Extended Cab Pickup 7
268 Pickup 7
272 Extended Cab Pickup 7
295 Extended Cab Pickup 7
323 Crew Cab Pickup 7
324 Crew Cab Pickup 7
325 Crew Cab Pickup 7
326 Extended Cab Pickup 7
331 Standard Cab Pickup 7
332 Standard Cab Pickup 7
357 Standard Cab Pickup 7
368 Extended Cab Pickup 7
403 Extended Cab Pickup 7
407 Standard Cab Pickup 7
433 Standard Cab Pickup 7
438 Crew Cab Pickup 7
449 Regular Cab Pickup 7
468 Standard Cab Pickup 7
485 Crew Cab Pickup 7
487 Extended Crew Cab Pickup 7
493 Standard Cab Pickup 7
494 Standard Cab Pickup 7
498 Standard Cab Pickup 7
501 Standard Cab Pickup 7
509 Crew Cab Pickup 7
607 Crew Cab Pickup 7
608 Crew Cab Pickup 7
610 Extended Cab Pickup 7
617 Extended Cab Pickup 7
620 Crew Cab Pickup 7
633 Standard Cab Pickup 7
635 Crew Cab Pickup 7
654 Standard Cab Pickup 7
666 Extended Cab Pickup 7
694 Pickup 7
698 Crew Cab Pickup 7
704 Pickup 7
729 Crew Cab Pickup 7
735 Extended Cab Pickup 7
737 Standard Cab Pickup 7
762 Crew Cab Pickup 7
771 Crew Cab Pickup 7
776 Pickup 7
780 Extended Cab Pickup 7
796 Pickup 7
800 Standard Cab Pickup 7
805 Crew Cab Pickup 7
827 Pickup 7
843 Pickup 7
851 Crew Cab Pickup 7
860 Standard Cab Pickup 7
869 Crew Cab Pickup 7
871 Standard Cab Pickup 7
874 Standard Cab Pickup 7
881 Extended Cab Pickup 7
889 Standard Cab Pickup 7
891 Standard Cab Pickup 7
896 Extended Cab Pickup 7
898 Standard Cab Pickup 7
899 Standard Cab Pickup 7
952 Extended Cab Pickup 7
954 Extended Cab Pickup 7
955 Extended Cab Pickup 7
956 Standard Cab Pickup 7
981 Crew Cab Pickup 7
991 Extended Crew Cab Pickup 7
1026 Standard Cab Pickup 7
1055 Standard Cab Pickup 7
1067 Extended Cab Pickup 7
1068 Crew Cab Chassis-Cab 7
1075 Standard Cab Pickup 7
1076 Standard Cab Pickup 7
1078 Pickup 7
1080 Standard Cab Pickup 7
1085 Standard Cab Pickup 7
1098 Extended Cab Pickup 7
1099 Extended Cab Pickup 7
1200 Standard Cab Pickup 7
1204 Standard Cab Pickup 7
1205 Standard Cab Pickup 7
1206 Standard Cab Pickup 7
1207 Standard Cab Pickup 7
1212 Extended Cab Pickup 7
1235 Standard Cab Pickup 7
1239 PICKUP 7
1248 Pickup 7
1250 Standard Cab Pickup 7
1251 Extended Cab Pickup 7
1252 Extended Crew Cab Pickup 7
1253 Standard Cab Pickup 7
1255 Standard Cab Pickup 7
1256 Standard Cab Pickup 7
1269 Standard Cab Pickup 7
1287 Extended Cab Pickup 7
1291 Pickup 7
1293 Crew Cab Pickup 7
1307 Standard Cab Pickup 7
1324 Crew Cab Pickup 7
1331 pickup 7
1346 Crew Cab Pickup 7
1399 Crew Cab Pickup 7
1403 Crew Cab Pickup 7
1412 Standard Cab Pickup 7
1417 Single Cab Pickup 7
1420 Standard Cab Pickup 7
1430 Crew Cab Pickup 7
1439 Standard Cab Pickup 7
1440 Pickup 7
1471 Extended Cab Pickup 7
1483 Crew Cab Pickup 7
1497 Pickup 7
1499 Standard Cab Pickup 7
1513 Pickup 7
1525 Pickup 7
1543 Extended Cab Pickup 7
1544 Extended Cab Pickup 7
1545 Standard Cab Pickup 7
1546 Standard Cab Pickup 7
1550 Extended Crew Cab Pickup 7
1555 Standard Cab Pickup 7
1558 Extended Cab Pickup 7
1563 Standard Cab Pickup 7
1565 Extended Cab Pickup 7
1570 Extended Cab Pickup 7
1599 Pickup 7
1604 Standard Cab Pickup 7
1644 Crew Cab Pickup 7
1647 Crew Cab Pickup 7
1655 Standard Cab Pickup 7
1665 Extended Cab Pickup 7
1668 Extended Cab Pickup 7
1700 Extended Cab Pickup 7
1703 Standard Cab Pickup 7
1704 Crew Cab Pickup 7
1706 Crew Cab Pickup 7
1758 Standard Cab Pickup 7
1760 Pickup 7
1779 Standard Cab Pickup 7
1784 Standard Cab Pickup 7
1796 Standard Cab Pickup 7
1805 Standard Cab Pickup 7
1808 Standard Cab Pickup 7
1813 standard Cab Pickup 7
1814 Standard Cab Pickup 7
1816 Standard Cab Pickup 7
1817 Standard Cab Pickup 7
1818 Extended Cab Pickup 7
1819 Extended Cab Pickup 7
1820 Crew Cab Pickup 7
1825 Pickup 7
1828 Extended Cab Pickup 7
1829 Standard Cab Pickup 7
1833 Extended Cab Pickup 7
1835 Standard Cab Pickup 7
1837 Standard Cab Pickup 7
1838 Standard Cab Pickup 7
1843 Standard Cab Pickup 7
1844 Standard Cab Pickup 7
1852 Extended Cab Pickup 7
1862 Pickup 7
1870 STANDARD CAB PICKUP 7
1886 Standard Cab Pickup 7
1897 Crew Cab Pickup 7
1905 Crew Cab Pickup 7
1906 Extended Cab Pickup 7
1907 Standard Cab Pickup 7
1908 Standard Cab Pickup 7
1910 Standard Cab Pickup 7
1911 Extended Cab Pickup 7
1914 Standard Cab Pickup 7
1924 Standard Cab Pickup 7
1929 Extended Cab Pickup 7
1930 Crew Cab Pickup 7
1931 Crew Cab Pickup 7
1949 Extended Cab Pickup 7
1969 Crew Cab Pickup 7
1970 Standard Cab Pickup 7
1971 Standard Cab Pickup 7
1979 Standard Cab Pickup 7
1983 Pickup 7
1987 Crew Cab Pickup 7
1988 Crew Cab Pickup 7
1990 Crew Cab Pickup 7
2014 Pickup 7
2016 Pickup 7
2029 Standard Cab Pickup 7
2039 Standard Cab Pickup 7
2051 Standard Cab Pickup 7
2053 Crew Cab Pickup 7
2060 Standard Cab Pickup 7
2064 Standard Cab Pickup 7
2067 Standard Cab Pickup 7
2072 Standard Cab Pickup 7
2080 Crew Cab Pickup 7
2082 Standard Cab Pickup 7
2085 Crew Cab Pickup 7
2088 Standard Cab Pickup 7
2089 Standard Cab Pickup 7
2099 Standard Cab Pickup 7
2102 Extended Cab Pickup 7
2110 Crew Cab Pickup 7
2111 Extended Cab Pickup 7
2118 Crew Cab Pickup 7
2124 Extended Cab Pickup 7
2141 Pickup 7
2142 Crew Cab Pickup 7
2162 Extended Cab Pickup 7
2169 Crew Cab Pickup 7
2180 Extended Cab Pickup 7
2184 Standard Cab Pickup 7
2198 Standard Cab Pickup 7
2200 Standard Cab Pickup 7
2202 Standard Cab Pickup 7
2203 Standard Cab Pickup 7
2209 Standard Cab Pickup 7
2210 Extended Cab Pickup 7
2211 Extended Cab Pickup 7
2212 Extended Cab Pickup 7
2213 Extended Cab Pickup 7
2214 Crew Cab Pickup 7
2215 Extended Cab Pickup 7
2216 Extended Cab Pickup 7
2221 Standard Cab Pickup 7
2222 Crew Cab Pickup 7
2231 Standard Cab Pickup 7
2232 Standard Cab Pickup 7
2233 Standard Cab Pickup 7
2236 Standard Cab Pickup 7
2237 Crew Cab Pickup 7
2239 Extended Cab Pickup 7
2242 Extended Cab Pickup 7
2248 Standard Cab Pickup 7
2251 Standard Cab Pickup 7
2252 Standard Cab Pickup 7
2253 Standard Cab Pickup 7
2254 Standard Cab Pickup 7
2256 Standard Cab Pickup 7
2258 Standard Cab Pickup 7
2270 Crew Cab Pickup 7
2291 Standard Cab Pickup 7
2304 Crew Cab Pickup 7
2310 Crew Cab Pickup 7
2311 Standard Cab Pickup 7
2315 Crew Cab Pickup 7
2323 Pickup 7
2340 Standard Cab Pickup 7
2358 Standard Cab Pickup 7
2359 Standard Cab Pickup 7
2360 Standard Cab Pickup 7
2366 Standard Cab Pickup 7
2373 Pickup 7
2374 Pickup 7
2392 Crew Cab Pickup 7
2394 Standard Cab Pickup 7
2408 Standard Cab Pickup 7
2410 Standard Cab Pickup 7
2426 Pickup 7
2432 Standard Cab Pickup 7
2433 Extended Cab Pickup 7
2445 Crew Cab Pickup 7
2461 Crew Cab Pickup 7
2467 Extended Cab Pickup 7
2483 Crew Cab Pickup 7
2500 Extended Crew Cab Pickup 7
2512 Crew Cab Pickup 7
2519 Crew Cab Pickup 7
2527 Extended Cab Pickup 7
2528 Standard Cab Pickup 7
2530 Standard Cab Pickup 7
2534 Standard Cab Pickup 7
2543 Standard Cab Pickup 7
2557 Standard Cab Pickup 7
2561 Standard Cab Pickup 7
2566 Standard Cab Pickup 7
2579 Standard Cab Pickup 7
2631 Crew Cab Pickup 7
2635 Standard Cab Pickup 7
2649 Pickup 7
2654 Standard Cab Pickup 7
2672 Standard Cab Pickup 7
2680 Standard Cab Pickup 7
2687 Crew Cab Pickup 7
2693 Pickup 7
2697 Standard Cab Pickup 7
2706 Standard Cab Pickup 7
2712 Crew Cab Pickup 7
2714 Standard Cab Pickup 7
2718 Extended Cab Pickup 7
2726 Crew Cab Pickup 7
2733 Crew Cab Pickup 7
2735 Extended Cab Pickup 7
2736 Extended Cab Pickup 7
2737 Extended Crew Cab Pickup 7
2740 PICKUP 7
2741 Standard Cab Pickup 7
2745 Pickup 7
2746 Crew Cab Pickup 7
2749 Extended Cab Pickup 7
2757 Crew Cab Pickup / 4 Door 7
2764 Crew Cab Pickup 7
2770 Standard Cab Pickup 7
2771 Standard Cab Pickup 7
2786 Crew Cab Pickup 7
2787 Crew Cab Pickup 7
2789 Crew Cab Pickup 7
2791 Crew Cab Pickup 7
2792 Crew Cab Pickup 7
2817 Standard Cab Pickup 7
2823 Extended Cab Pickup 7
2824 Extended Cab Pickup 7
2825 Standard Cab Pickup 7
2839 Extended Cab Pickup 7
2843 Standard Cab Pickup 7
2850 Extended Cab Pickup 7
2854 Crew Cab Pickup 7
2864 Extended Cab Pickup 7
2871 Extended Cab Pickup 7
2882 Extended Cab Pickup 7
2903 Standard Cab Pickup 7
2916 Crew Cab Pickup 7
2924 Pickup 7
2925 Pickup 7
2926 Standard Cab Pickup 7
2928 Pickup 7
2931 Crew Cab Pickup 7
2932 Standard Cab Pickup 7
2938 Crew Cab Pickup 7
2942 Extended Cab Pickup 7
2947 Extended Cab Pickup 7
2963 Standard Cab Pickup 7
2964 Standard Cab Pickup 7
2965 Standard Cab Pickup 7
2968 Crew Cab Pickup 7
2983 Standard Cab Pickup 7
2990 Standard Cab Pickup 7
2991 Standard Cab Pickup 7
2992 Standard Cab Pickup 7
2993 Standard Cab Pickup 7
2999 Crew Cab Pickup 7
3013 Pickup 7
3032 Pickup 7
3036 Standard Cab Pickup 7
3037 Extended Crew Cab Pickup 7
3038 Standard Cab Pickup 7
3039 Standard Cab Pickup 7
3040 Standard Cab Pickup 7
3049 Pickup 7
3055 Standard Cab Pickup 7
3075 Crew Cab Pickup 7
3080 Standard Cab Pickup 7
3102 Extended Cab Pickup 7
3188 Crew Cab Pickup 7
3195 Extended Cab Pickup 7
3200 Extended Cab Pickup 7
3217 Crew Cab Pickup 7
3219 Crew Cab Pickup 7
3227 Standard Cab Pickup 7
3229 Standard Cab Pickup 7
3230 Standard Cab Pickup 7
3231 Standard Cab Pickup 7
3232 Standard Cab Pickup 7
3233 Standard Cab Pickup 7
3237 Standard Cab Pickup 7
3240 Standard Cab Pickup 7
3241 Standard Cab Pickup 7
3244 Standard Cab Pickup 7
3279 Extended Crew Cab Pickup 7
3310 Standard Cab Pickup 7
3316 Standard Cab Pickup 7
3319 Standard Cab Pickup 7
3322 Crew Cab Pickup 7
3326 Standard Cab Pickup 7
3328 Standard Cab Pickup 7
3331 Standard Cab Pickup 7
3375 Standard Cab Pickup 7
3381 Standard Cab Pickup 7
3392 Standard Cab Pickup 7
3394 Pickup 7
3403 Crew Cab Pickup 7
3406 Pickup 7
3408 Crew Cab Pickup 7
3412 Standard Cab Pickup 7
3419 Standard Cab Pickup 7
3424 Standard Cab Pickup 7
3427 Extended Cab Pickup 7
3447 Standard Cab Pickup 7
3450 Standard Cab Pickup 7
3452 Standard Cab Pickup 7
3454 Crew Cab Pickup 7
3463 Extended Cab Pickup 7
3464 Standard Cab Pickup 7
3481 Standard Cab Pickup 7
3488 Extended Cab Pickup 7
3490 Standard Cab Pickup 7
3494 Extended Cab Pickup 7
3496 Standard Cab Pickup 7
3510 Standard Cab Pickup 7
3522 Extended Cab Pickup 7
3523 Extended Cab Pickup 7
3533 Crew Cab Pickup 7
3534 Extended Cab Pickup 7
3555 Standard Cab Pickup 7
3561 Pickup 7
3565 Standard Cab Pickup 7
3566 Extended Cab Pickup 7
3568 Pickup 7
3571 Crew Cab Pickup 7
3576 Standard Cab Pickup 7
3605 Pickup 7
3614 Standard Cab Pickup 7
3625 Standard Cab Pickup 7
3640 Standard Cab Pickup 7
3645 Crew Cab Pickup 7
3662 Standard Cab Pickup 7
3669 Crew Cab Pickup 7
3672 Crew Cab Pickup 7
3673 Crew Cab Pickup 7
3677 Standard Cab Pickup 7
3678 Standard Cab Pickup 7
3679 Standard Cab Pickup 7
3696 Standard Cab Pickup 7
3700 Standard Cab Pickup 7
3701 Extended Cab Pickup 7
3722 Standard Cab Pickup 7
3727 pickup 7
3735 Pickup 7
3742 Extended Cab Pickup 7
3765 Crew Cab Pickup 7
3774 Standard Cab Pickup 7
3777 Crew Cab Pickup 7
3816 Standard Cab Pickup 7
3818 Standard Cab Pickup 7
3820 Standard Cab Pickup 7
3840 Extended Cab Pickup 7
3841 Crew Cab Pickup 7
3842 Crew Cab Pickup 7
3843 Crew Cab Pickup 7
3846 Extended Cab Pickup 7
3847 Extended Cab Pickup 7
3855 Crew Cab Pickup 7
3859 Crew Cab Pickup 7
3866 Crew Cab Pickup 7
3867 Crew Cab Pickup 7
3868 Crew Cab Pickup 7
3869 Extended Cab Pickup 7
3870 Extended Cab Pickup 7
3871 Crew Cab Pickup 7
3872 Crew Cab Pickup 7
3873 Crew Cab Pickup 7
3874 Crew Cab Pickup 7
3875 Crew Cab Pickup 7
3876 Crew Cab Pickup 7
3877 Crew Cab Pickup 7
3878 Crew Cab Pickup 7
3879 Crew Cab Pickup 7
3880 Crew Cab Pickup 7
3881 Crew Cab Pickup 7
3882 Crew Cab Pickup 7
3883 Crew Cab Pickup 7
3884 Extended Cab Pickup 7
3885 Extended Cab Pickup 7
3886 Crew Cab Pickup 7
3887 Crew Cab Pickup 7
3888 Crew Cab Pickup 7
3889 Crew Cab Pickup 7
3890 Crew Cab Pickup 7
3891 Crew Cab Pickup 7
3892 Crew Cab Pickup 7
3893 Crew Cab Pickup 7
3894 Crew Cab Pickup 7
3895 Extended Cab Pickup 7
3896 Extended Cab Pickup 7We see some pretty defined categories (wagon, pickup, SUV). These categories show that the clustering algorithm saw enough of one value in the dataset to make it confident enough to make it a whole category. We also see some less defined categories, for example, one category with “2 door truck” and “4 door sedan”. Perhaps the algorithm created a bit of an “other” category, which is not as helpful to us.
After running clustering a few times, I came up with some rules to group body types into categories. I use key words (”cab”, “bed”) for pickup trucks, group “2 door” as coupes, “4 door” as sedans, and search for key words that fit the categories for the rest.
body_cleanup_map = {
'van': 'Van',
'pickup': 'Pickup',
'cab': 'Pickup',
'bed': 'Pickup',
'truck': 'Pickup',
'coupe': 'Coupe',
'2door': 'Coupe',
'2dr': 'Coupe',
'sedan': 'Sedan',
'4door': 'Sedan',
'4dr': 'Sedan',
'suv' : 'SUV',
'jeep': 'SUV',
'sportutil': 'SUV',
'convertible': 'Convertible',
'wagon': 'Wagon',
'hatchback': 'Hatchback',
'fastback': 'Fastback'
}
def body_cleanup(orig_body):
body_stripped = ''.join(e for e in orig_body if e.isalnum()).lower()
for key in body_cleanup_map.keys():
if key in body_stripped:
return body_cleanup_map[key]
return 'Other Bodies'
ucs_df['clean_body'] = ucs_df['BodyType'].apply(lambda x: body_cleanup(x))Let’s check out our distribution after that categorization:
# Count occurrences of each category
counts = ucs_df['clean_body'].value_counts()
# Plotting
counts.plot(kind='bar', color='blue')
# Remove grid
plt.grid(False)
# Hide borders around the bars
plt.gca().spines['top'].set_visible(False)
plt.gca().spines['right'].set_visible(False)
plt.gca().spines['left'].set_visible(False)
plt.gca().spines['bottom'].set_visible(False)
# Rotate x-axis labels
plt.xticks(rotation=90)
# Show plot
plt.show()
I’ll admit it’s not the best result to have “other” as the leading category, but we had quite a bit of NaN values in our BodyType column, and this is the furthest we’re going to go with our data cleaning.
Feature Importance
Now for the fun part: the actual feature importance!
We need to label the categorical columns as categorical and fill null values with the mode of each column. Labeling columns as categories tells pandas to keep track of all unique values of a column. This normalizes the data and prepares us for feature importance.
modes = ucs_df.mode().iloc[0]
def proc_data(df):
df['CleanMake'] = pd.Categorical(df.clean_make)
df['CleanBody'] = pd.Categorical(df.clean_body)
df['YearMade'] = pd.Categorical(df.Year)
df['YearSold'] = pd.Categorical(df.yearsold)
df.fillna(modes, inplace=True)
proc_data(ucs_df)Let’s consolidate our dataframe to just the columns we want for feature importance (using our newly created columns with cleaner data).
cons_df = ucs_df[['pricesold', 'YearSold', 'Mileage', 'YearMade', 'CleanMake', 'CleanBody']]We need to use a Label Encoder to transform the categorical values into numbers, since Random Forest models only work with numerical data (like most ML models). This is taking all of those categories from the categorical columns, and assigning each unique value a number. It then replaces the value in each row with the corresponding number for its category. If you actually look at the values in the dataframe after this step, instead of seeing the years, makes, and models, you will only see numbers.
from sklearn.preprocessing import LabelEncoder
categorical_cols = ['YearSold', 'YearMade', 'CleanMake', 'CleanBody']
le = LabelEncoder()
cons_df[categorical_cols] = cons_df[categorical_cols].apply(lambda col: le.fit_transform(col))Let’s separate our target variable from our features.
Normally with other models we would create a test and training dataset in this step, but to create a model with Random Forests, we actually don’t need test-train splits!
from sklearn.ensemble import RandomForestRegressor
X = cons_df.drop(columns=['pricesold'])
pricesold_column = cons_df.loc[:, 'pricesold']
y = pricesold_column.valuesAnd then we fit the Random Forest Regressor!
rf = RandomForestRegressor(n_estimators=300)
rf.fit(X, y)Now we can see the weights of each feature importance based on the trained Random Forest model:
rf.feature_importances_Output:
array([0.02783746, 0.46128208, 0.20769629, 0.20769086, 0.09549331])We can then plot them with the columns from our feature data:
plt.barh(X.columns, rf.feature_importances_)
Conclusion
Based on all of that work we did, we can see here that mileage has the biggest impact on price, followed by a near identical importance between the make of the car, and year made.
To summarize what we did here, we:
- Identified what data we were going to use as features and target variable
- Cleaned up our variables to remove outliers and consolidate categories
- Prepared our data for machine learning by label-encoding our categorical data
- Separated our feature data from our target data
- Trained a Random Forest Regressor on our feature and target data
- Pulled out feature importance from our trained model
In this article I have showed you how to use feature importance without the context of further developing a machine learning model. Feature importance is an amazing tool all by itself that anyone who works with data can use to further understand their data. It is also used by data scientists and machine learning engineers as a critical part of the model development process. When creating a machine learning model, feature importance can tell you what to focus on moving forward, what is actually driving the predictions and decisions your model will make, as well as what you can ignore or delete from your dataset.
I hope you enjoyed this blog post and that you go find some feature importance in your own datasets!