La siguiente tarea busca reforzar tu aprendiza de los temas cubiertos en clase, así como poner en práctica tus habilidades en el manejo de datos masivos.
Resuelve cada uno de los puntos para la base de datos cars.csv No olvides cargar la libreria ´dplyr´antes de iniciar con tu programa
Almacena la información del archivo cars.csv en una variable llamada mis_datos y revisa su estructura con la función str()
library(readxl)
library(MASS)
library(stats)
library(psych)
library(dplyr)
##
## Attaching package: 'dplyr'
## The following object is masked from 'package:MASS':
##
## select
## The following objects are masked from 'package:stats':
##
## filter, lag
## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, union
library(openxlsx)
library(ggplot2)
##
## Attaching package: 'ggplot2'
## The following objects are masked from 'package:psych':
##
## %+%, alpha
mis_datos = read.csv("cars.csv")
str(mis_datos)
## 'data.frame': 428 obs. of 15 variables:
## $ Make : chr "Acura" "Acura" "Acura" "Acura" ...
## $ Model : chr "MDX" "RSX Type S 2dr" "TSX 4dr" "TL 4dr" ...
## $ Type : chr "SUV" "Sedan" "Sedan" "Sedan" ...
## $ Origin : chr "Asia" "Asia" "Asia" "Asia" ...
## $ DriveTrain : chr "All" "Front" "Front" "Front" ...
## $ MSRP : num 36945 23820 26990 33195 43755 ...
## $ Invoice : num 33337 21761 24647 30299 39014 ...
## $ EngineSize : num 3.5 2 2.4 3.2 3.5 3.5 3.2 1.8 1.8 3 ...
## $ Cylinders : int 6 4 4 6 6 6 6 4 4 6 ...
## $ Horsepower : int 265 200 200 270 225 225 290 170 170 220 ...
## $ MPG_City : int 17 24 22 20 18 18 17 22 23 20 ...
## $ MPG_Highway: int 23 31 29 28 24 24 24 31 30 28 ...
## $ Weight : int 4451 2778 3230 NA 3880 3893 3153 3252 3638 3462 ...
## $ Wheelbase : int 106 101 105 108 115 115 100 104 105 104 ...
## $ Length : int 189 172 183 186 197 197 174 179 180 179 ...
Como puedes ver, la base de datos cuenta con 428 observaciones y 15 variables. Las variables incluidas son: - Make = La marca del fabricante del automóvil - Model = El modelo del automóvil - Type = El tipo de automóvil - Origin = En dónde fue fabricado - DriveTrain = Indica el tipo de transmición - MSRP = Es el precio de venta en dólares sugerido por el fabricate - Invoice = Es el valor de la factura del automóvil - EngineSize = Es el tamaño del motor - Cylinders = Indica con cuántos cilindros cuenta - Horsepower = La potencia del automóvil en caballos de fuerza - MPG_City = Millas por galón de combustible en la ciudad - MPG_Highway = Millas por galón de combustible en carretera - Weight = Peso del automóvil en libras - Wheelbase = La distancia que hay entre el eje delantero y el eje trasero en pulgadas - Length = La longitud del automóvil en pulgadas
Revisa si en la variable mis_datos existen missing values, de ser así reemplazalos por la media.
anyNA(mis_datos)
## [1] TRUE
Mis_Datos.Sna = na.omit(mis_datos)
median_EngineS= median(Mis_Datos.Sna$EngineSize)
median_Cylinders= median(Mis_Datos.Sna$Cylinders)
mean_HorseP = mean(Mis_Datos.Sna$Horsepower)
mean_MPGC= mean(Mis_Datos.Sna$MPG_City)
mean_MPGH= mean(Mis_Datos.Sna$MPG_Highway)
mean_w= mean(Mis_Datos.Sna$Weight)
median_WhB= median(Mis_Datos.Sna$Wheelbase)
median_len= median(Mis_Datos.Sna$Length)
mis_datos$EngineSize[is.na(mis_datos$EngineSize)] = median_EngineS
mis_datos$Cylinders[is.na(mis_datos$Cylinders)] = median_Cylinders
mis_datos$Horsepower[is.na(mis_datos$Horsepower)] = mean_HorseP
mis_datos$MPG_City[is.na(mis_datos$MPG_City)]= mean_MPGC
mis_datos$MPG_Highway[is.na(mis_datos$MPG_Highway)]= mean_MPGH
mis_datos$Weight[is.na(mis_datos$Weight)]= mean_w
mis_datos$Wheelbase[is.na(mis_datos$Wheelbase)]= median_WhB
mis_datos$Length[is.na(mis_datos$Length)]= median_len
mis_datos
## Make Model Type Origin
## 1 Acura MDX SUV Asia
## 2 Acura RSX Type S 2dr Sedan Asia
## 3 Acura TSX 4dr Sedan Asia
## 4 Acura TL 4dr Sedan Asia
## 5 Acura 3.5 RL 4dr Sedan Asia
## 6 Acura 3.5 RL w/Navigation 4dr Sedan Asia
## 7 Acura NSX coupe 2dr manual S Sports Asia
## 8 Audi A4 1.8T 4dr Sedan Europe
## 9 Audi A41.8T convertible 2dr Sedan Europe
## 10 Audi A4 3.0 4dr Sedan Europe
## 11 Audi A4 3.0 Quattro 4dr manual Sedan Europe
## 12 Audi A4 3.0 Quattro 4dr auto Sedan Europe
## 13 Audi A6 3.0 4dr Sedan Europe
## 14 Audi A6 3.0 Quattro 4dr Sedan Europe
## 15 Audi A4 3.0 convertible 2dr Sedan Europe
## 16 Audi A4 3.0 Quattro convertible 2dr Sedan Europe
## 17 Audi A6 2.7 Turbo Quattro 4dr Sedan Europe
## 18 Audi A6 4.2 Quattro 4dr Sedan Europe
## 19 Audi A8 L Quattro 4dr Sedan Europe
## 20 Audi S4 Quattro 4dr Sedan Europe
## 21 Audi RS 6 4dr Sports Europe
## 22 Audi TT 1.8 convertible 2dr (coupe) Sports Europe
## 23 Audi TT 1.8 Quattro 2dr (convertible) Sports Europe
## 24 Audi TT 3.2 coupe 2dr (convertible) Sports Europe
## 25 Audi A6 3.0 Avant Quattro Wagon Europe
## 26 Audi S4 Avant Quattro Wagon Europe
## 27 BMW X3 3.0i SUV Europe
## 28 BMW X5 4.4i SUV Europe
## 29 BMW 325i 4dr Sedan Europe
## 30 BMW 325Ci 2dr Sedan Europe
## 31 BMW 325Ci convertible 2dr Sedan Europe
## 32 BMW 325xi 4dr Sedan Europe
## 33 BMW 330i 4dr Sedan Europe
## 34 BMW 330Ci 2dr Sedan Europe
## 35 BMW 330xi 4dr Sedan Europe
## 36 BMW 525i 4dr Sedan Europe
## 37 BMW 330Ci convertible 2dr Sedan Europe
## 38 BMW 530i 4dr Sedan Europe
## 39 BMW 545iA 4dr Sedan Europe
## 40 BMW 745i 4dr Sedan Europe
## 41 BMW 745Li 4dr Sedan Europe
## 42 BMW M3 coupe 2dr Sports Europe
## 43 BMW M3 convertible 2dr Sports Europe
## 44 BMW Z4 convertible 2.5i 2dr Sports Europe
## 45 BMW Z4 convertible 3.0i 2dr Sports Europe
## 46 BMW 325xi Sport Wagon Europe
## 47 Buick Rainier SUV USA
## 48 Buick Rendezvous CX SUV USA
## 49 Buick Century Custom 4dr Sedan USA
## 50 Buick LeSabre Custom 4dr Sedan USA
## 51 Buick Regal LS 4dr Sedan USA
## 52 Buick Regal GS 4dr Sedan USA
## 53 Buick LeSabre Limited 4dr Sedan USA
## 54 Buick Park Avenue 4dr Sedan USA
## 55 Buick Park Avenue Ultra 4dr Sedan USA
## 56 Cadillac Escalade SUV USA
## 57 Cadillac SRX V8 SUV USA
## 58 Cadillac CTS VVT 4dr Sedan USA
## 59 Cadillac Deville 4dr Sedan USA
## 60 Cadillac Deville DTS 4dr Sedan USA
## 61 Cadillac Seville SLS 4dr Sedan USA
## 62 Cadillac XLR convertible 2dr Sports USA
## 63 Cadillac Escalade EXT Truck USA
## 64 Chevrolet Suburban 1500 LT SUV USA
## 65 Chevrolet Tahoe LT SUV USA
## 66 Chevrolet TrailBlazer LT SUV USA
## 67 Chevrolet Tracker SUV USA
## 68 Chevrolet Aveo 4dr Sedan USA
## 69 Chevrolet Aveo LS 4dr hatch Sedan USA
## 70 Chevrolet Cavalier 2dr Sedan USA
## 71 Chevrolet Cavalier 4dr Sedan USA
## 72 Chevrolet Cavalier LS 2dr Sedan USA
## 73 Chevrolet Impala 4dr Sedan USA
## 74 Chevrolet Malibu 4dr Sedan USA
## 75 Chevrolet Malibu LS 4dr Sedan USA
## 76 Chevrolet Monte Carlo LS 2dr Sedan USA
## 77 Chevrolet Impala LS 4dr Sedan USA
## 78 Chevrolet Impala SS 4dr Sedan USA
## 79 Chevrolet Malibu LT 4dr Sedan USA
## 80 Chevrolet Monte Carlo SS 2dr Sedan USA
## 81 Chevrolet Astro Sedan USA
## 82 Chevrolet Venture LS Sedan USA
## 83 Chevrolet Corvette 2dr Sports USA
## 84 Chevrolet Corvette convertible 2dr Sports USA
## 85 Chevrolet Avalanche 1500 Truck USA
## 86 Chevrolet Colorado Z85 Truck USA
## 87 Chevrolet Silverado 1500 Regular Cab Truck USA
## 88 Chevrolet Silverado SS Truck USA
## 89 Chevrolet SSR Truck USA
## 90 Chevrolet Malibu Maxx LS Wagon USA
## 91 Chrysler PT Cruiser 4dr Sedan USA
## 92 Chrysler PT Cruiser Limited 4dr Sedan USA
## 93 Chrysler Sebring 4dr Sedan USA
## 94 Chrysler Sebring Touring 4dr Sedan USA
## 95 Chrysler 300M 4dr Sedan USA
## 96 Chrysler Concorde LX 4dr Sedan USA
## 97 Chrysler Concorde LXi 4dr Sedan USA
## 98 Chrysler PT Cruiser GT 4dr Sedan USA
## 99 Chrysler Sebring convertible 2dr Sedan USA
## 100 Chrysler 300M Special Edition 4dr Sedan USA
## 101 Chrysler Sebring Limited convertible 2dr Sedan USA
## 102 Chrysler Town and Country LX Sedan USA
## 103 Chrysler Town and Country Limited Sedan USA
## 104 Chrysler Crossfire 2dr Sports USA
## 105 Chrysler Pacifica Wagon USA
## 106 Dodge Durango SLT SUV USA
## 107 Dodge Neon SE 4dr Sedan USA
## 108 Dodge Neon SXT 4dr Sedan USA
## 109 Dodge Intrepid SE 4dr Sedan USA
## 110 Dodge Stratus SXT 4dr Sedan USA
## 111 Dodge Stratus SE 4dr Sedan USA
## 112 Dodge Intrepid ES 4dr Sedan USA
## 113 Dodge Caravan SE Sedan USA
## 114 Dodge Grand Caravan SXT Sedan USA
## 115 Dodge Viper SRT-10 convertible 2dr Sports USA
## 116 Dodge Dakota Regular Cab Truck USA
## 117 Dodge Dakota Club Cab Truck USA
## 118 Dodge Ram 1500 Regular Cab ST Truck USA
## 119 Ford Excursion 6.8 XLT SUV USA
## 120 Ford Expedition 4.6 XLT SUV USA
## 121 Ford Explorer XLT V6 SUV USA
## 122 Ford Escape XLS SUV USA
## 123 Ford Focus ZX3 2dr hatch Sedan USA
## 124 Ford Focus LX 4dr Sedan USA
## 125 Ford Focus SE 4dr Sedan USA
## 126 Ford Focus ZX5 5dr Sedan USA
## 127 Ford Focus SVT 2dr Sedan USA
## 128 Ford Taurus LX 4dr Sedan USA
## 129 Ford Taurus SES Duratec 4dr Sedan USA
## 130 Ford Crown Victoria 4dr Sedan USA
## 131 Ford Crown Victoria LX 4dr Sedan USA
## 132 Ford Crown Victoria LX Sport 4dr Sedan USA
## 133 Ford Freestar SE Sedan USA
## 134 Ford Mustang 2dr (convertible) Sports USA
## 135 Ford Mustang GT Premium convertible 2dr Sports USA
## 136 Ford Thunderbird Deluxe convert w/hardtop 2d Sports USA
## 137 Ford F-150 Regular Cab XL Truck USA
## 138 Ford F-150 Supercab Lariat Truck USA
## 139 Ford Ranger 2.3 XL Regular Cab Truck USA
## 140 Ford Focus ZTW Wagon USA
## 141 Ford Taurus SE Wagon USA
## 142 GMC Envoy XUV SLE SUV USA
## 143 GMC Yukon 1500 SLE SUV USA
## 144 GMC Yukon XL 2500 SLT SUV USA
## 145 GMC Safari SLE Sedan USA
## 146 GMC Canyon Z85 SL Regular Cab Truck USA
## 147 GMC Sierra Extended Cab 1500 Truck USA
## 148 GMC Sierra HD 2500 Truck USA
## 149 GMC Sonoma Crew Cab Truck USA
## 150 Honda Civic Hybrid 4dr manual (gas/electric) Hybrid Asia
## 151 Honda Insight 2dr (gas/electric) Hybrid Asia
## 152 Honda Pilot LX SUV Asia
## 153 Honda CR-V LX SUV Asia
## 154 Honda Element LX SUV Asia
## 155 Honda Civic DX 2dr Sedan Asia
## 156 Honda Civic HX 2dr Sedan Asia
## 157 Honda Civic LX 4dr Sedan Asia
## 158 Honda Accord LX 2dr Sedan Asia
## 159 Honda Accord EX 2dr Sedan Asia
## 160 Honda Civic EX 4dr Sedan Asia
## 161 Honda Civic Si 2dr hatch Sedan Asia
## 162 Honda Accord LX V6 4dr Sedan Asia
## 163 Honda Accord EX V6 2dr Sedan Asia
## 164 Honda Odyssey LX Sedan Asia
## 165 Honda Odyssey EX Sedan Asia
## 166 Honda S2000 convertible 2dr Sports Asia
## 167 Hummer H2 SUV USA
## 168 Hyundai Santa Fe GLS SUV Asia
## 169 Hyundai Accent 2dr hatch Sedan Asia
## 170 Hyundai Accent GL 4dr Sedan Asia
## 171 Hyundai Accent GT 2dr hatch Sedan Asia
## 172 Hyundai Elantra GLS 4dr Sedan Asia
## 173 Hyundai Elantra GT 4dr Sedan Asia
## 174 Hyundai Elantra GT 4dr hatch Sedan Asia
## 175 Hyundai Sonata GLS 4dr Sedan Asia
## 176 Hyundai Sonata LX 4dr Sedan Asia
## 177 Hyundai XG350 4dr Sedan Asia
## 178 Hyundai XG350 L 4dr Sedan Asia
## 179 Hyundai Tiburon GT V6 2dr Sports Asia
## 180 Infiniti G35 4dr Sedan Asia
## 181 Infiniti G35 Sport Coupe 2dr Sedan Asia
## 182 Infiniti G35 4dr Sedan Asia
## 183 Infiniti I35 4dr Sedan Asia
## 184 Infiniti M45 4dr Sedan Asia
## 185 Infiniti Q45 Luxury 4dr Sedan Asia
## 186 Infiniti FX35 Wagon Asia
## 187 Infiniti FX45 Wagon Asia
## 188 Isuzu Ascender S SUV Asia
## 189 Isuzu Rodeo S SUV Asia
## 190 Jaguar X-Type 2.5 4dr Sedan Europe
## 191 Jaguar X-Type 3.0 4dr Sedan Europe
## 192 Jaguar S-Type 3.0 4dr Sedan Europe
## 193 Jaguar S-Type 4.2 4dr Sedan Europe
## 194 Jaguar S-Type R 4dr Sedan Europe
## 195 Jaguar Vanden Plas 4dr Sedan Europe
## 196 Jaguar XJ8 4dr Sedan Europe
## 197 Jaguar XJR 4dr Sedan Europe
## 198 Jaguar XK8 coupe 2dr Sports Europe
## 199 Jaguar XK8 convertible 2dr Sports Europe
## 200 Jaguar XKR coupe 2dr Sports Europe
## 201 Jaguar XKR convertible 2dr Sports Europe
## 202 Jeep Grand Cherokee Laredo SUV USA
## 203 Jeep Liberty Sport SUV USA
## 204 Jeep Wrangler Sahara convertible 2dr SUV USA
## 205 Kia Sorento LX SUV Asia
## 206 Kia Optima LX 4dr Sedan Asia
## 207 Kia Rio 4dr manual Sedan Asia
## 208 Kia Rio 4dr auto Sedan Asia
## 209 Kia Spectra 4dr Sedan Asia
## 210 Kia Spectra GS 4dr hatch Sedan Asia
## 211 Kia Spectra GSX 4dr hatch Sedan Asia
## 212 Kia Optima LX V6 4dr Sedan Asia
## 213 Kia Amanti 4dr Sedan Asia
## 214 Kia Sedona LX Sedan Asia
## 215 Kia Rio Cinco Wagon Asia
## 216 Land Rover Range Rover HSE SUV Europe
## 217 Land Rover Discovery SE SUV Europe
## 218 Land Rover Freelander SE SUV Europe
## 219 Lexus GX 470 SUV Asia
## 220 Lexus LX 470 SUV Asia
## 221 Lexus RX 330 SUV Asia
## 222 Lexus ES 330 4dr Sedan Asia
## 223 Lexus IS 300 4dr manual Sedan Asia
## 224 Lexus IS 300 4dr auto Sedan Asia
## 225 Lexus GS 300 4dr Sedan Asia
## 226 Lexus GS 430 4dr Sedan Asia
## 227 Lexus LS 430 4dr Sedan Asia
## 228 Lexus SC 430 convertible 2dr Sports Asia
## 229 Lexus IS 300 SportCross Wagon Asia
## 230 Lincoln Navigator Luxury SUV USA
## 231 Lincoln Aviator Ultimate SUV USA
## 232 Lincoln LS V6 Luxury 4dr Sedan USA
## 233 Lincoln LS V6 Premium 4dr Sedan USA
## 234 Lincoln LS V8 Sport 4dr Sedan USA
## 235 Lincoln LS V8 Ultimate 4dr Sedan USA
## 236 Lincoln Town Car Signature 4dr Sedan USA
## 237 Lincoln Town Car Ultimate 4dr Sedan USA
## 238 Lincoln Town Car Ultimate L 4dr Sedan USA
## 239 MINI Cooper Sedan Europe
## 240 MINI Cooper S Sedan Europe
## 241 Mazda Tribute DX 2.0 SUV Asia
## 242 Mazda Mazda3 i 4dr Sedan Asia
## 243 Mazda Mazda3 s 4dr Sedan Asia
## 244 Mazda Mazda6 i 4dr Sedan Asia
## 245 Mazda MPV ES Sedan Asia
## 246 Mazda MX-5 Miata convertible 2dr Sports Asia
## 247 Mazda MX-5 Miata LS convertible 2dr Sports Asia
## 248 Mazda RX-8 4dr automatic Sports Asia
## 249 Mazda RX-8 4dr manual Sports Asia
## 250 Mazda B2300 SX Regular Cab Truck Asia
## 251 Mazda B4000 SE Cab Plus Truck Asia
## 252 Mercedes-Benz G500 SUV Europe
## 253 Mercedes-Benz ML500 SUV Europe
## 254 Mercedes-Benz C230 Sport 2dr Sedan Europe
## 255 Mercedes-Benz C320 Sport 2dr Sedan Europe
## 256 Mercedes-Benz C240 4dr Sedan Europe
## 257 Mercedes-Benz C240 4dr Sedan Europe
## 258 Mercedes-Benz C320 Sport 4dr Sedan Europe
## 259 Mercedes-Benz C320 4dr Sedan Europe
## 260 Mercedes-Benz C320 4dr Sedan Europe
## 261 Mercedes-Benz C32 AMG 4dr Sedan Europe
## 262 Mercedes-Benz CL500 2dr Sedan Europe
## 263 Mercedes-Benz CL600 2dr Sedan Europe
## 264 Mercedes-Benz CLK320 coupe 2dr (convertible) Sedan Europe
## 265 Mercedes-Benz CLK500 coupe 2dr (convertible) Sedan Europe
## 266 Mercedes-Benz E320 4dr Sedan Europe
## 267 Mercedes-Benz E500 4dr Sedan Europe
## 268 Mercedes-Benz S430 4dr Sedan Europe
## 269 Mercedes-Benz S500 4dr Sedan Europe
## 270 Mercedes-Benz SL500 convertible 2dr Sports Europe
## 271 Mercedes-Benz SL55 AMG 2dr Sports Europe
## 272 Mercedes-Benz SL600 convertible 2dr Sports Europe
## 273 Mercedes-Benz SLK230 convertible 2dr Sports Europe
## 274 Mercedes-Benz SLK32 AMG 2dr Sports Europe
## 275 Mercedes-Benz C240 Wagon Europe
## 276 Mercedes-Benz E320 Wagon Europe
## 277 Mercedes-Benz E500 Wagon Europe
## 278 Mercury Mountaineer SUV USA
## 279 Mercury Sable GS 4dr Sedan USA
## 280 Mercury Grand Marquis GS 4dr Sedan USA
## 281 Mercury Grand Marquis LS Premium 4dr Sedan USA
## 282 Mercury Sable LS Premium 4dr Sedan USA
## 283 Mercury Grand Marquis LS Ultimate 4dr Sedan USA
## 284 Mercury Marauder 4dr Sedan USA
## 285 Mercury Monterey Luxury Sedan USA
## 286 Mercury Sable GS Wagon USA
## 287 Mitsubishi Endeavor XLS SUV Asia
## 288 Mitsubishi Montero XLS SUV Asia
## 289 Mitsubishi Outlander LS SUV Asia
## 290 Mitsubishi Lancer ES 4dr Sedan Asia
## 291 Mitsubishi Lancer LS 4dr Sedan Asia
## 292 Mitsubishi Galant ES 2.4L 4dr Sedan Asia
## 293 Mitsubishi Lancer OZ Rally 4dr auto Sedan Asia
## 294 Mitsubishi Diamante LS 4dr Sedan Asia
## 295 Mitsubishi Galant GTS 4dr Sedan Asia
## 296 Mitsubishi Eclipse GTS 2dr Sports Asia
## 297 Mitsubishi Eclipse Spyder GT convertible 2dr Sports Asia
## 298 Mitsubishi Lancer Evolution 4dr Sports Asia
## 299 Mitsubishi Lancer Sportback LS Wagon Asia
## 300 Nissan Pathfinder Armada SE SUV Asia
## 301 Nissan Pathfinder SE SUV Asia
## 302 Nissan Xterra XE V6 SUV Asia
## 303 Nissan Sentra 1.8 4dr Sedan Asia
## 304 Nissan Sentra 1.8 S 4dr Sedan Asia
## 305 Nissan Altima S 4dr Sedan Asia
## 306 Nissan Sentra SE-R 4dr Sedan Asia
## 307 Nissan Altima SE 4dr Sedan Asia
## 308 Nissan Maxima SE 4dr Sedan Asia
## 309 Nissan Maxima SL 4dr Sedan Asia
## 310 Nissan Quest S Sedan Asia
## 311 Nissan Quest SE Sedan Asia
## 312 Nissan 350Z coupe 2dr Sports Asia
## 313 Nissan 350Z Enthusiast convertible 2dr Sports Asia
## 314 Nissan Frontier King Cab XE V6 Truck Asia
## 315 Nissan Titan King Cab XE Truck Asia
## 316 Nissan Murano SL Wagon Asia
## 317 Oldsmobile Alero GX 2dr Sedan USA
## 318 Oldsmobile Alero GLS 2dr Sedan USA
## 319 Oldsmobile Silhouette GL Sedan USA
## 320 Pontiac Aztekt SUV USA
## 321 Pontiac Sunfire 1SA 2dr Sedan USA
## 322 Pontiac Grand Am GT 2dr Sedan USA
## 323 Pontiac Grand Prix GT1 4dr Sedan USA
## 324 Pontiac Sunfire 1SC 2dr Sedan USA
## 325 Pontiac Grand Prix GT2 4dr Sedan USA
## 326 Pontiac Bonneville GXP 4dr Sedan USA
## 327 Pontiac Montana Sedan USA
## 328 Pontiac Montana EWB Sedan USA
## 329 Pontiac GTO 2dr Sports USA
## 330 Pontiac Vibe Wagon USA
## 331 Porsche Cayenne S SUV Europe
## 332 Porsche 911 Carrera convertible 2dr (coupe) Sports Europe
## 333 Porsche 911 Carrera 4S coupe 2dr (convert) Sports Europe
## 334 Porsche 911 Targa coupe 2dr Sports Europe
## 335 Porsche 911 GT2 2dr Sports Europe
## 336 Porsche Boxster convertible 2dr Sports Europe
## 337 Porsche Boxster S convertible 2dr Sports Europe
## 338 Saab 9-3 Arc Sport 4dr Sedan Europe
## 339 Saab 9-3 Aero 4dr Sedan Europe
## 340 Saab 9-5 Arc 4dr Sedan Europe
## 341 Saab 9-5 Aero 4dr Sedan Europe
## 342 Saab 9-3 Arc convertible 2dr Sedan Europe
## 343 Saab 9-3 Aero convertible 2dr Sedan Europe
## 344 Saab 9-5 Aero Wagon Europe
## 345 Saturn VUE SUV USA
## 346 Saturn Ion1 4dr Sedan USA
## 347 Saturn lon2 4dr Sedan USA
## 348 Saturn lon3 4dr Sedan USA
## 349 Saturn lon2 quad coupe 2dr Sedan USA
## 350 Saturn lon3 quad coupe 2dr Sedan USA
## 351 Saturn L300-2 4dr Sedan USA
## 352 Saturn L300 2 Wagon USA
## 353 Scion xA 4dr hatch Sedan Asia
## 354 Scion xB Wagon Asia
## 355 Subaru Impreza 2.5 RS 4dr Sedan Asia
## 356 Subaru Legacy L 4dr Sedan Asia
## 357 Subaru Legacy GT 4dr Sedan Asia
## 358 Subaru Outback Limited Sedan 4dr Sedan Asia
## 359 Subaru Outback H6 4dr Sedan Asia
## 360 Subaru Outback H-6 VDC 4dr Sedan Asia
## 361 Subaru Impreza WRX 4dr Sports Asia
## 362 Subaru Impreza WRX STi 4dr Sports Asia
## 363 Subaru Baja Truck Asia
## 364 Subaru Forester X Wagon Asia
## 365 Subaru Outback Wagon Asia
## 366 Suzuki XL-7 EX SUV Asia
## 367 Suzuki Vitara LX SUV Asia
## 368 Suzuki Aeno S 4dr Sedan Asia
## 369 Suzuki Aerio LX 4dr Sedan Asia
## 370 Suzuki Forenza S 4dr Sedan Asia
## 371 Suzuki Forenza EX 4dr Sedan Asia
## 372 Suzuki Verona LX 4dr Sedan Asia
## 373 Suzuki Aerio SX Wagon Asia
## 374 Toyota Prius 4dr (gas/electric) Hybrid Asia
## 375 Toyota Sequoia SR5 SUV Asia
## 376 Toyota 4Runner SR5 V6 SUV Asia
## 377 Toyota Highlander V6 SUV Asia
## 378 Toyota Land Cruiser SUV Asia
## 379 Toyota RAV4 SUV Asia
## 380 Toyota Corolla CE 4dr Sedan Asia
## 381 Toyota Corolla S 4dr Sedan Asia
## 382 Toyota Corolla LE 4dr Sedan Asia
## 383 Toyota Echo 2dr manual Sedan Asia
## 384 Toyota Echo 2dr auto Sedan Asia
## 385 Toyota Echo 4dr Sedan Asia
## 386 Toyota Camry LE 4dr Sedan Asia
## 387 Toyota Camry LE V6 4dr Sedan Asia
## 388 Toyota Camry Solara SE 2dr Sedan Asia
## 389 Toyota Camry Solara SE V6 2dr Sedan Asia
## 390 Toyota Avalon XL 4dr Sedan Asia
## 391 Toyota Camry XLE V6 4dr Sedan Asia
## 392 Toyota Camry Solara SLE V6 2dr Sedan Asia
## 393 Toyota Avalon XLS 4dr Sedan Asia
## 394 Toyota Sienna CE Sedan Asia
## 395 Toyota Sienna XLE Limited Sedan Asia
## 396 Toyota Celica GT-S 2dr Sports Asia
## 397 Toyota MR2 Spyder convertible 2dr Sports Asia
## 398 Toyota Tacoma Truck Asia
## 399 Toyota Tundra Regular Cab V6 Truck Asia
## 400 Toyota Tundra Access Cab V6 SR5 Truck Asia
## 401 Toyota Matrix XR Wagon Asia
## 402 Volkswagen Touareg V6 SUV Europe
## 403 Volkswagen Golf GLS 4dr Sedan Europe
## 404 Volkswagen GTI 1.8T 2dr hatch Sedan Europe
## 405 Volkswagen Jetta GLS TDI 4dr Sedan Europe
## 406 Volkswagen New Beetle GLS 1.8T 2dr Sedan Europe
## 407 Volkswagen Jetta GLI VR6 4dr Sedan Europe
## 408 Volkswagen New Beetle GLS convertible 2dr Sedan Europe
## 409 Volkswagen Passat GLS 4dr Sedan Europe
## 410 Volkswagen Passat GLX V6 4MOTION 4dr Sedan Europe
## 411 Volkswagen Passat W8 4MOTION 4dr Sedan Europe
## 412 Volkswagen Phaeton 4dr Sedan Europe
## 413 Volkswagen Phaeton W12 4dr Sedan Europe
## 414 Volkswagen Jetta GL Wagon Europe
## 415 Volkswagen Passat GLS 1.8T Wagon Europe
## 416 Volkswagen Passat W8 Wagon Europe
## 417 Volvo XC90 T6 SUV Europe
## 418 Volvo S40 4dr Sedan Europe
## 419 Volvo S60 2.5 4dr Sedan Europe
## 420 Volvo S60 T5 4dr Sedan Europe
## 421 Volvo S60 R 4dr Sedan Europe
## 422 Volvo S80 2.9 4dr Sedan Europe
## 423 Volvo S80 2.5T 4dr Sedan Europe
## 424 Volvo C70 LPT convertible 2dr Sedan Europe
## 425 Volvo C70 HPT convertible 2dr Sedan Europe
## 426 Volvo S80 T6 4dr Sedan Europe
## 427 Volvo V40 Wagon Europe
## 428 Volvo XC70 Wagon Europe
## DriveTrain MSRP Invoice EngineSize Cylinders Horsepower MPG_City
## 1 All 36945 33337 3.5 6 265.0000 17.00000
## 2 Front 23820 21761 2.0 4 200.0000 24.00000
## 3 Front 26990 24647 2.4 4 200.0000 22.00000
## 4 Front 33195 30299 3.2 6 270.0000 20.00000
## 5 Front 43755 39014 3.5 6 225.0000 18.00000
## 6 Front 46100 41100 3.5 6 225.0000 18.00000
## 7 Rear 89765 79978 3.2 6 290.0000 17.00000
## 8 Front 25940 23508 1.8 4 170.0000 22.00000
## 9 Front 35940 32506 1.8 4 170.0000 23.00000
## 10 Front 31840 28846 3.0 6 220.0000 20.00000
## 11 All 33430 30366 3.0 6 220.0000 17.00000
## 12 All 34480 31388 3.0 6 220.0000 18.00000
## 13 Front 36640 33129 3.0 6 220.0000 20.00000
## 14 All 39640 35992 3.0 6 220.0000 18.00000
## 15 Front 42490 38325 3.0 6 220.0000 20.00000
## 16 All 44240 40075 3.0 6 220.0000 18.00000
## 17 All 42840 38840 2.7 6 250.0000 20.07882
## 18 All 49690 44936 4.2 8 300.0000 17.00000
## 19 All 69190 64740 4.2 8 330.0000 17.00000
## 20 All 48040 43556 4.2 8 340.0000 14.00000
## 21 Front 84600 76417 4.2 8 450.0000 15.00000
## 22 Front 35940 32512 1.8 4 180.0000 20.00000
## 23 All 37390 33891 1.8 4 225.0000 20.00000
## 24 All 40590 36739 3.2 6 250.0000 21.00000
## 25 All 40840 37060 3.0 6 220.0000 18.00000
## 26 All 49090 44446 4.2 8 340.0000 15.00000
## 27 All 37000 33873 3.0 6 225.0000 16.00000
## 28 All 52195 47720 4.4 8 325.0000 16.00000
## 29 Rear 28495 26155 2.5 6 184.0000 20.00000
## 30 Rear 30795 28245 2.5 6 184.0000 20.00000
## 31 Rear 37995 34800 2.5 6 184.0000 19.00000
## 32 All 30245 27745 2.5 6 184.0000 19.00000
## 33 Rear 35495 32525 3.0 6 225.0000 20.00000
## 34 Rear 36995 33890 3.0 6 225.0000 20.00000
## 35 All 37245 34115 3.0 6 225.0000 20.00000
## 36 Rear 39995 36620 2.5 6 184.0000 19.00000
## 37 Rear 44295 40530 3.0 6 225.0000 19.00000
## 38 Rear 44995 41170 3.0 6 215.6084 20.00000
## 39 Rear 54995 50270 4.4 8 325.0000 18.00000
## 40 Rear 69195 63190 4.4 8 325.0000 18.00000
## 41 Rear 73195 66830 4.4 8 325.0000 18.00000
## 42 Rear 48195 44170 3.2 6 333.0000 16.00000
## 43 Rear 56595 51815 3.2 6 333.0000 16.00000
## 44 Rear 33895 31065 2.5 6 184.0000 20.00000
## 45 Rear 41045 37575 3.0 6 225.0000 21.00000
## 46 All 32845 30110 2.5 6 184.0000 19.00000
## 47 All 37895 34357 4.2 6 275.0000 15.00000
## 48 Front 26545 24085 3.4 6 185.0000 19.00000
## 49 Front 22180 20351 3.1 6 175.0000 20.00000
## 50 Front 26470 24282 3.8 6 205.0000 20.00000
## 51 Front 24895 22835 3.8 6 200.0000 20.00000
## 52 Front 28345 26047 3.8 6 240.0000 18.00000
## 53 Front 32245 29566 3.8 6 205.0000 20.00000
## 54 Front 35545 32244 3.8 6 205.0000 20.00000
## 55 Front 40720 36927 3.8 6 240.0000 18.00000
## 56 Front 52795 48377 5.3 8 295.0000 14.00000
## 57 Front 46995 43523 4.6 8 215.6084 16.00000
## 58 Rear 30835 28575 3.6 6 255.0000 18.00000
## 59 Front 45445 41650 4.6 8 275.0000 18.00000
## 60 Front 50595 46362 4.6 8 300.0000 18.00000
## 61 Front 47955 43841 4.6 8 275.0000 18.00000
## 62 Rear 76200 70546 4.6 8 320.0000 17.00000
## 63 All 52975 48541 6.0 8 345.0000 13.00000
## 64 Front 42735 37422 5.3 8 295.0000 14.00000
## 65 All 41465 36287 5.3 8 295.0000 14.00000
## 66 Front 30295 27479 4.2 6 275.0000 16.00000
## 67 Front 20255 19108 2.5 6 165.0000 19.00000
## 68 Front 11690 10965 1.6 4 103.0000 28.00000
## 69 Front 12585 11802 1.6 4 103.0000 28.00000
## 70 Front 14610 13697 2.2 4 140.0000 26.00000
## 71 Front 14810 13884 2.2 4 140.0000 26.00000
## 72 Front 16385 15357 2.2 4 140.0000 26.00000
## 73 Front 21900 20095 3.4 6 180.0000 21.00000
## 74 Front 18995 17434 2.2 4 145.0000 24.00000
## 75 Front 20370 18639 3.5 6 200.0000 22.00000
## 76 Front 21825 20026 3.4 6 180.0000 21.00000
## 77 Front 25000 22931 3.0 6 200.0000 20.00000
## 78 Front 27995 25672 3.8 6 240.0000 18.00000
## 79 Front 23495 21551 3.5 6 200.0000 23.00000
## 80 Front 24225 22222 3.8 6 200.0000 18.00000
## 81 All 26395 23954 4.3 6 190.0000 14.00000
## 82 Front 27020 24518 3.4 6 185.0000 19.00000
## 83 Rear 44535 39068 5.7 8 350.0000 18.00000
## 84 Rear 51535 45193 5.7 8 350.0000 18.00000
## 85 All 36100 31689 5.3 8 295.0000 14.00000
## 86 All 18760 17070 2.8 4 175.0000 18.00000
## 87 Rear 20310 18480 4.3 6 200.0000 15.00000
## 88 All 40340 35399 6.0 8 300.0000 13.00000
## 89 Rear 41995 39306 5.3 8 300.0000 16.00000
## 90 Front 22225 20394 3.5 6 200.0000 22.00000
## 91 Front 17985 16919 2.4 4 150.0000 22.00000
## 92 Front 22000 20573 2.4 4 150.0000 22.00000
## 93 Front 19090 17805 2.4 4 150.0000 22.00000
## 94 Front 21840 20284 2.7 6 200.0000 21.00000
## 95 Front 29865 27797 3.5 6 250.0000 18.00000
## 96 Front 24130 22452 2.7 6 200.0000 21.00000
## 97 Front 26860 24909 3.5 6 232.0000 19.00000
## 98 Front 25955 24172 2.4 4 220.0000 21.00000
## 99 Front 25215 23451 2.4 4 150.0000 22.00000
## 100 Front 33295 30884 3.5 6 255.0000 18.00000
## 101 Front 30950 28613 2.7 6 200.0000 21.00000
## 102 Front 27490 25371 3.3 6 180.0000 19.00000
## 103 Front 38380 35063 3.8 6 215.0000 18.00000
## 104 Rear 34495 32033 3.2 6 215.6084 17.00000
## 105 Rear 31230 28725 3.5 6 250.0000 17.00000
## 106 All 32235 29472 4.7 8 230.0000 15.00000
## 107 Front 13670 12849 2.0 4 132.0000 29.00000
## 108 Front 15040 14086 2.0 4 132.0000 29.00000
## 109 Front 22035 20502 2.7 6 200.0000 21.00000
## 110 Front 18820 17512 2.4 4 150.0000 21.00000
## 111 Front 20220 18821 2.4 4 150.0000 21.00000
## 112 Front 24885 23058 3.5 6 232.0000 18.00000
## 113 Front 21795 20508 2.4 4 150.0000 20.00000
## 114 All 32660 29812 3.8 6 215.0000 18.00000
## 115 Rear 81795 74451 8.3 10 500.0000 12.00000
## 116 Rear 17630 16264 3.7 6 210.0000 16.00000
## 117 Rear 20300 18670 3.7 6 210.0000 16.00000
## 118 Rear 20215 18076 3.7 6 215.0000 16.00000
## 119 All 41475 36494 6.8 10 310.0000 10.00000
## 120 Front 34560 30468 4.6 8 232.0000 15.00000
## 121 All 29670 26983 4.0 6 210.0000 15.00000
## 122 All 22515 20907 3.0 6 201.0000 18.00000
## 123 Front 13270 12482 2.0 4 130.0000 26.00000
## 124 Front 13730 12906 2.0 4 110.0000 27.00000
## 125 Front 15460 14496 2.0 4 130.0000 26.00000
## 126 Front 15580 14607 2.0 4 130.0000 26.00000
## 127 Front 19135 17878 2.0 4 170.0000 21.00000
## 128 Front 20320 18881 3.0 6 155.0000 20.00000
## 129 Front 22735 20857 3.0 6 201.0000 19.00000
## 130 Rear 24345 22856 4.6 8 224.0000 17.00000
## 131 Rear 27370 25105 4.6 8 224.0000 17.00000
## 132 Rear 30315 27756 4.6 8 239.0000 17.00000
## 133 Front 26930 24498 3.9 6 193.0000 17.00000
## 134 Rear 18345 16943 3.8 6 193.0000 20.00000
## 135 Rear 29380 26875 4.6 8 260.0000 17.00000
## 136 Front 37530 34483 3.9 8 280.0000 17.00000
## 137 Rear 22010 19490 4.6 8 231.0000 15.00000
## 138 All 33540 29405 5.4 8 300.0000 14.00000
## 139 Rear 14385 13717 2.3 4 143.0000 24.00000
## 140 Front 17475 16375 2.0 4 130.0000 26.00000
## 141 Front 22290 20457 3.0 6 155.0000 19.00000
## 142 Front 31890 28922 4.2 6 275.0000 15.00000
## 143 Front 35725 31361 4.8 8 285.0000 16.00000
## 144 All 46265 40534 6.0 8 325.0000 13.00000
## 145 Rear 25640 23215 4.3 6 190.0000 16.00000
## 146 Rear 16530 14877 2.8 4 175.0000 18.00000
## 147 Rear 25717 22604 4.8 8 285.0000 17.00000
## 148 All 29322 25759 6.0 8 300.0000 13.00000
## 149 All 25395 23043 4.3 6 190.0000 15.00000
## 150 Front 20140 18451 1.4 4 93.0000 46.00000
## 151 Front 19110 17911 2.0 3 73.0000 60.00000
## 152 All 27560 24843 3.5 6 240.0000 17.00000
## 153 All 19860 18419 2.4 4 160.0000 21.00000
## 154 All 18690 17334 2.4 4 160.0000 21.00000
## 155 Front 13270 12175 1.7 4 115.0000 32.00000
## 156 Front 14170 12996 1.7 4 117.0000 36.00000
## 157 Front 15850 14531 1.7 4 115.0000 32.00000
## 158 Front 19860 17924 2.4 4 160.0000 26.00000
## 159 Front 22260 20080 2.4 4 160.0000 26.00000
## 160 Front 17750 16265 1.7 4 127.0000 32.00000
## 161 Front 19490 17849 2.0 4 160.0000 26.00000
## 162 Front 23760 21428 3.0 6 240.0000 21.00000
## 163 Front 26960 24304 3.0 6 240.0000 21.00000
## 164 Front 24950 22498 3.5 6 240.0000 18.00000
## 165 Front 27450 24744 3.5 6 240.0000 18.00000
## 166 Rear 33260 29965 2.2 4 240.0000 20.00000
## 167 All 49995 45815 6.0 8 316.0000 10.00000
## 168 Front 21589 20201 2.7 6 173.0000 20.00000
## 169 Front 10539 10107 1.6 4 103.0000 29.00000
## 170 Front 11839 11116 1.6 4 103.0000 29.00000
## 171 Front 11939 11209 1.6 4 103.0000 29.00000
## 172 Front 13839 12781 2.0 4 138.0000 26.00000
## 173 Front 15389 14207 2.0 4 138.0000 26.00000
## 174 Front 15389 14207 2.0 4 138.0000 26.00000
## 175 Front 19339 17574 2.7 6 170.0000 19.00000
## 176 Front 20339 18380 2.7 6 170.0000 19.00000
## 177 Front 24589 22055 3.5 6 194.0000 17.00000
## 178 Front 26189 23486 3.5 6 194.0000 17.00000
## 179 Front 18739 17101 2.7 6 172.0000 19.00000
## 180 Rear 28495 26157 3.5 6 260.0000 18.00000
## 181 Rear 29795 27536 3.5 6 280.0000 18.00000
## 182 All 32445 29783 3.5 6 260.0000 18.00000
## 183 Front 31145 28320 3.5 6 255.0000 19.00000
## 184 Rear 42845 38792 4.5 8 340.0000 17.00000
## 185 Rear 52545 47575 4.5 8 340.0000 17.00000
## 186 Rear 34895 31756 3.5 6 215.6084 16.00000
## 187 All 36395 33121 4.5 8 315.0000 15.00000
## 188 All 31849 29977 4.2 6 275.0000 15.00000
## 189 Front 20449 19261 3.2 6 193.0000 17.00000
## 190 All 29995 27355 2.5 6 192.0000 18.00000
## 191 All 33995 30995 3.0 6 227.0000 18.00000
## 192 Rear 43895 40004 3.0 6 235.0000 18.00000
## 193 Rear 49995 45556 4.2 8 294.0000 18.00000
## 194 Rear 63120 57499 4.2 8 390.0000 17.00000
## 195 Rear 68995 62846 4.2 8 294.0000 18.00000
## 196 Rear 59995 54656 4.2 8 294.0000 18.00000
## 197 Rear 74995 68306 4.2 8 390.0000 17.00000
## 198 Rear 69995 63756 4.2 8 294.0000 18.00000
## 199 Rear 74995 68306 4.2 8 294.0000 18.00000
## 200 Rear 81995 74676 4.2 8 390.0000 16.00000
## 201 Rear 86995 79226 4.2 8 390.0000 16.00000
## 202 Front 27905 25686 4.0 6 195.0000 16.00000
## 203 All 20130 18973 2.4 4 150.0000 20.00000
## 204 All 25520 23275 4.0 6 190.0000 16.00000
## 205 Front 19635 18630 3.5 6 192.0000 16.00000
## 206 Front 16040 14910 2.4 4 138.0000 23.00000
## 207 Front 10280 9875 1.6 4 104.0000 26.00000
## 208 Front 11155 10705 1.6 4 104.0000 25.00000
## 209 Front 12360 11630 1.8 4 124.0000 24.00000
## 210 Front 13580 12830 1.8 4 124.0000 24.00000
## 211 Front 14630 13790 1.8 4 124.0000 24.00000
## 212 Front 18435 16850 2.7 6 170.0000 20.00000
## 213 Front 26000 23764 3.5 6 195.0000 17.00000
## 214 Front 20615 19400 3.5 6 195.0000 16.00000
## 215 Front 11905 11410 1.6 4 104.0000 26.00000
## 216 All 72250 65807 4.4 8 282.0000 12.00000
## 217 All 39250 35777 4.6 8 217.0000 12.00000
## 218 All 25995 23969 2.5 6 174.0000 18.00000
## 219 All 45700 39838 4.7 8 235.0000 15.00000
## 220 All 64800 56455 4.7 8 235.0000 13.00000
## 221 All 39195 34576 3.3 6 230.0000 18.00000
## 222 Front 32350 28755 3.3 6 225.0000 20.00000
## 223 Rear 31045 27404 3.0 6 215.0000 18.00000
## 224 Rear 32415 28611 3.0 6 215.0000 18.00000
## 225 Rear 41010 36196 3.0 6 220.0000 18.00000
## 226 Rear 48450 42232 4.3 8 300.0000 18.00000
## 227 Rear 55750 48583 4.3 8 290.0000 18.00000
## 228 Rear 63200 55063 4.3 8 300.0000 18.00000
## 229 Rear 32455 28647 3.0 6 215.0000 18.00000
## 230 All 52775 46360 5.4 8 300.0000 13.00000
## 231 Front 42915 39443 4.6 8 302.0000 13.00000
## 232 Rear 32495 29969 3.0 6 232.0000 20.00000
## 233 Rear 36895 33929 3.0 6 232.0000 20.00000
## 234 Rear 40095 36809 3.9 8 280.0000 17.00000
## 235 Rear 43495 39869 3.9 8 280.0000 17.00000
## 236 Rear 41815 38418 4.6 8 239.0000 17.00000
## 237 Rear 44925 41217 4.6 8 239.0000 17.00000
## 238 Rear 50470 46208 4.6 8 239.0000 17.00000
## 239 Front 16999 15437 1.6 4 115.0000 28.00000
## 240 Front 19999 18137 1.6 4 163.0000 25.00000
## 241 All 21087 19742 2.0 4 130.0000 22.00000
## 242 Front 15500 14525 2.0 4 148.0000 26.00000
## 243 Front 17200 15922 2.3 4 160.0000 25.00000
## 244 Front 19270 17817 2.3 4 160.0000 24.00000
## 245 Front 28750 26600 3.0 6 200.0000 18.00000
## 246 Rear 22388 20701 1.8 4 142.0000 23.00000
## 247 Rear 25193 23285 1.8 4 142.0000 23.00000
## 248 Rear 25700 23794 1.3 6 197.0000 18.00000
## 249 Rear 27200 25179 1.3 6 238.0000 18.00000
## 250 Rear 14840 14070 2.3 4 143.0000 24.00000
## 251 All 22350 20482 4.0 6 207.0000 15.00000
## 252 All 76870 71540 5.0 8 292.0000 13.00000
## 253 All 46470 43268 5.0 8 288.0000 14.00000
## 254 Rear 26060 24249 1.8 4 189.0000 22.00000
## 255 Rear 28370 26435 3.2 6 215.0000 19.00000
## 256 Rear 32280 30071 2.6 6 168.0000 20.00000
## 257 All 33480 31187 2.6 6 168.0000 19.00000
## 258 Rear 35920 33456 3.2 6 215.0000 19.00000
## 259 Rear 37630 35046 3.2 6 215.0000 20.07882
## 260 All 38830 36162 3.2 6 215.0000 19.00000
## 261 Rear 52120 48522 3.2 6 349.0000 16.00000
## 262 Rear 94820 88324 5.0 8 302.0000 16.00000
## 263 Rear 128420 119600 5.5 12 493.0000 13.00000
## 264 Rear 45707 41966 3.2 6 215.0000 20.00000
## 265 Rear 52800 49104 5.0 8 302.0000 17.00000
## 266 Rear 48170 44849 3.2 6 221.0000 19.00000
## 267 Rear 57270 53382 5.0 8 302.0000 16.00000
## 268 Rear 74320 69168 4.3 8 275.0000 18.00000
## 269 All 86970 80939 5.0 8 302.0000 16.00000
## 270 Rear 90520 84325 5.0 8 302.0000 16.00000
## 271 Rear 121770 113388 5.5 8 493.0000 14.00000
## 272 Rear 126670 117854 5.5 12 493.0000 13.00000
## 273 Rear 40320 37548 2.3 4 192.0000 21.00000
## 274 Rear 56170 52289 3.2 6 349.0000 17.00000
## 275 Rear 33780 31466 2.6 6 168.0000 19.00000
## 276 Rear 50670 47174 3.2 6 221.0000 19.00000
## 277 All 60670 56474 5.0 8 302.0000 16.00000
## 278 Front 29995 27317 4.0 6 210.0000 16.00000
## 279 Front 21595 19848 3.0 6 155.0000 20.00000
## 280 Rear 24695 23217 4.6 8 224.0000 17.00000
## 281 Rear 29595 27148 4.6 8 224.0000 17.00000
## 282 Front 23895 21918 3.0 6 201.0000 19.00000
## 283 Rear 30895 28318 4.6 8 224.0000 17.00000
## 284 Rear 34495 31558 4.6 8 302.0000 17.00000
## 285 Front 33995 30846 4.2 6 201.0000 16.00000
## 286 Front 22595 20748 3.0 6 155.0000 19.00000
## 287 All 30492 28330 3.8 6 215.0000 17.00000
## 288 All 33112 30763 3.8 6 215.0000 15.00000
## 289 Front 18892 17569 2.4 4 160.0000 21.00000
## 290 Front 14622 13751 2.0 4 120.0000 25.00000
## 291 Front 16722 15718 2.0 4 120.0000 25.00000
## 292 Front 19312 17957 2.4 4 160.0000 23.00000
## 293 Front 17232 16196 2.0 4 120.0000 25.00000
## 294 Front 29282 27250 3.5 6 205.0000 18.00000
## 295 Front 25700 23883 3.8 6 230.0000 18.00000
## 296 Front 25092 23456 3.0 6 210.0000 21.00000
## 297 Front 26992 25218 3.0 6 210.0000 21.00000
## 298 Front 29562 27466 2.0 4 271.0000 18.00000
## 299 Front 17495 16295 2.4 4 160.0000 25.00000
## 300 Front 33840 30815 5.6 8 305.0000 13.00000
## 301 Front 27339 25972 3.5 6 240.0000 16.00000
## 302 Front 20939 19512 3.3 6 180.0000 17.00000
## 303 Front 12740 12205 1.8 4 126.0000 28.00000
## 304 Front 14740 13747 1.8 4 126.0000 28.00000
## 305 Front 19240 18030 2.5 4 175.0000 21.00000
## 306 Front 17640 16444 2.5 4 165.0000 23.00000
## 307 Front 23290 21580 3.5 6 245.0000 21.00000
## 308 Front 27490 25182 3.5 6 265.0000 20.00000
## 309 Front 29440 26966 3.5 6 265.0000 20.00000
## 310 Front 24780 22958 3.0 6 240.0000 19.00000
## 311 Front 32780 30019 3.5 6 240.0000 18.00000
## 312 Rear 26910 25203 3.5 6 287.0000 20.00000
## 313 Rear 34390 31845 3.5 6 287.0000 20.00000
## 314 All 19479 18253 3.3 6 180.0000 17.00000
## 315 All 26650 24926 5.6 8 305.0000 14.00000
## 316 Rear 28739 27300 3.5 6 245.0000 20.00000
## 317 Front 18825 17642 2.2 4 140.0000 24.00000
## 318 Front 23675 21485 3.4 6 170.0000 20.00000
## 319 Front 28790 26120 3.4 6 185.0000 19.00000
## 320 Front 21595 19810 3.4 6 185.0000 19.00000
## 321 Front 15495 14375 2.2 4 140.0000 24.00000
## 322 Front 22450 20595 3.4 6 175.0000 20.00000
## 323 Front 22395 20545 3.8 6 200.0000 20.00000
## 324 Front 17735 16369 2.2 4 140.0000 24.00000
## 325 Front 24295 22284 3.8 6 200.0000 20.00000
## 326 Front 35995 32997 4.6 8 275.0000 17.00000
## 327 Front 23845 21644 3.4 6 185.0000 19.00000
## 328 All 31370 28454 3.4 6 185.0000 18.00000
## 329 Rear 33500 30710 5.7 8 340.0000 16.00000
## 330 Rear 17045 15973 1.8 4 130.0000 29.00000
## 331 All 56665 49865 4.5 8 340.0000 14.00000
## 332 Rear 79165 69229 3.6 6 315.0000 18.00000
## 333 All 84165 72206 3.6 6 315.0000 17.00000
## 334 Rear 76765 67128 3.6 6 315.0000 18.00000
## 335 Rear 192465 173560 3.6 6 477.0000 17.00000
## 336 Rear 43365 37886 2.7 6 228.0000 20.00000
## 337 Rear 52365 45766 3.2 6 258.0000 18.00000
## 338 Front 30860 29269 2.0 4 210.0000 20.00000
## 339 Front 33360 31562 2.0 4 210.0000 20.00000
## 340 Front 35105 33011 2.3 4 220.0000 21.00000
## 341 Front 39465 37721 2.3 4 250.0000 21.00000
## 342 Front 40670 38520 2.0 4 210.0000 21.00000
## 343 Front 43175 40883 2.0 4 210.0000 21.00000
## 344 Front 40845 38376 2.3 4 250.0000 19.00000
## 345 All 20585 19238 2.2 4 143.0000 21.00000
## 346 Front 10995 10319 2.2 4 140.0000 26.00000
## 347 Front 14300 13393 2.2 4 140.0000 26.00000
## 348 Front 15825 14811 2.2 4 140.0000 26.00000
## 349 Front 14850 13904 2.2 4 140.0000 26.00000
## 350 Front 16350 15299 2.2 4 140.0000 26.00000
## 351 Front 21410 19801 3.0 6 182.0000 20.00000
## 352 Front 23560 21779 2.2 4 140.0000 24.00000
## 353 Front 12965 12340 1.5 4 108.0000 32.00000
## 354 Front 14165 13480 1.5 4 108.0000 31.00000
## 355 All 19945 18399 2.5 4 165.0000 22.00000
## 356 All 20445 18713 2.5 4 165.0000 21.00000
## 357 All 25645 23336 2.5 4 165.0000 21.00000
## 358 All 27145 24687 2.5 4 165.0000 20.00000
## 359 All 29345 26660 3.0 6 212.0000 19.00000
## 360 All 31545 28603 3.0 6 212.0000 19.00000
## 361 All 25045 23022 2.0 4 227.0000 20.00000
## 362 All 31545 29130 2.5 4 300.0000 18.00000
## 363 All 24520 22304 2.5 4 165.0000 21.00000
## 364 All 21445 19646 2.5 4 165.0000 21.00000
## 365 All 23895 21773 2.5 4 165.0000 21.00000
## 366 Front 23699 22307 2.7 6 185.0000 18.00000
## 367 All 17163 16949 2.5 6 165.0000 19.00000
## 368 Front 12884 12719 2.3 4 155.0000 25.00000
## 369 Front 14500 14317 2.3 4 155.0000 25.00000
## 370 Front 12269 12116 2.0 4 119.0000 24.00000
## 371 Front 15568 15378 2.0 4 119.0000 22.00000
## 372 Front 17262 17053 2.5 6 155.0000 20.00000
## 373 All 16497 16291 2.3 4 155.0000 24.00000
## 374 Front 20510 18926 1.5 4 110.0000 59.00000
## 375 All 35695 31827 4.7 8 240.0000 14.00000
## 376 Front 27710 24801 4.0 6 245.0000 18.00000
## 377 All 27930 24915 3.3 6 230.0000 18.00000
## 378 All 54765 47986 4.7 8 325.0000 13.00000
## 379 All 20290 18553 2.4 4 161.0000 22.00000
## 380 Front 14085 13065 1.8 4 130.0000 32.00000
## 381 Front 15030 13650 1.8 4 130.0000 32.00000
## 382 Front 15295 13889 1.8 4 130.0000 32.00000
## 383 Front 10760 10144 1.5 4 108.0000 35.00000
## 384 Front 11560 10896 1.5 4 108.0000 33.00000
## 385 Front 11290 10642 1.5 4 108.0000 35.00000
## 386 Front 19560 17558 2.4 4 157.0000 24.00000
## 387 Front 22775 20325 3.0 6 210.0000 21.00000
## 388 Front 19635 17722 2.4 4 157.0000 24.00000
## 389 Front 21965 19819 3.3 6 225.0000 20.00000
## 390 Front 26560 23693 3.0 6 210.0000 21.00000
## 391 Front 25920 23125 3.0 6 210.0000 21.00000
## 392 Front 26510 23908 3.3 6 225.0000 20.00000
## 393 Front 30920 27271 3.0 6 210.0000 21.00000
## 394 Front 23495 21198 3.3 6 230.0000 19.00000
## 395 Front 28800 25690 3.3 6 230.0000 19.00000
## 396 Front 22570 20363 1.8 4 180.0000 24.00000
## 397 Rear 25130 22787 1.8 4 138.0000 26.00000
## 398 Rear 12800 11879 2.4 4 142.0000 22.00000
## 399 Rear 16495 14978 3.4 6 190.0000 16.00000
## 400 All 25935 23520 3.4 6 190.0000 14.00000
## 401 Front 16695 15156 1.8 6 130.0000 29.00000
## 402 All 35515 32243 3.2 6 220.0000 15.00000
## 403 Front 18715 17478 2.0 4 115.0000 24.00000
## 404 Front 19825 18109 1.8 4 180.0000 24.00000
## 405 Front 21055 19638 1.9 4 100.0000 38.00000
## 406 Front 21055 19638 1.8 4 150.0000 24.00000
## 407 Front 23785 21686 2.8 6 200.0000 21.00000
## 408 Front 23215 21689 2.0 4 115.0000 24.00000
## 409 Front 23955 21898 1.8 4 170.0000 22.00000
## 410 Front 33180 30583 2.8 6 190.0000 19.00000
## 411 Front 39235 36052 4.0 8 270.0000 18.00000
## 412 Front 65000 59912 4.2 8 335.0000 16.00000
## 413 Front 75000 69130 6.0 12 420.0000 12.00000
## 414 Front 19005 17427 2.0 4 115.0000 24.00000
## 415 Front 24955 22801 1.8 4 170.0000 22.00000
## 416 Front 40235 36956 4.0 8 270.0000 18.00000
## 417 All 41250 38851 2.9 6 268.0000 15.00000
## 418 Front 25135 23701 1.9 4 215.6084 22.00000
## 419 All 31745 29916 2.5 5 208.0000 20.00000
## 420 Front 34845 32902 2.3 5 247.0000 20.00000
## 421 All 37560 35382 2.5 5 300.0000 18.00000
## 422 Front 37730 35542 3.0 6 208.0000 20.00000
## 423 All 37885 35688 2.5 5 194.0000 20.00000
## 424 Front 40565 38203 2.4 5 197.0000 21.00000
## 425 Front 42565 40083 2.3 5 242.0000 20.00000
## 426 Front 45210 42573 2.9 6 268.0000 19.00000
## 427 Front 26135 24641 1.9 4 170.0000 22.00000
## 428 All 35145 33112 2.5 5 208.0000 20.00000
## MPG_Highway Weight Wheelbase Length
## 1 23.00000 4451.000 106 189
## 2 31.00000 2778.000 101 172
## 3 29.00000 3230.000 105 183
## 4 28.00000 3585.101 108 186
## 5 24.00000 3880.000 115 197
## 6 24.00000 3893.000 115 197
## 7 24.00000 3153.000 100 174
## 8 31.00000 3252.000 104 179
## 9 30.00000 3638.000 105 180
## 10 28.00000 3462.000 104 179
## 11 26.00000 3583.000 104 179
## 12 25.00000 3627.000 104 179
## 13 27.00000 3561.000 109 192
## 14 25.00000 3880.000 109 192
## 15 27.00000 3814.000 105 180
## 16 25.00000 4013.000 105 180
## 17 25.00000 3836.000 109 192
## 18 24.00000 4024.000 109 193
## 19 24.00000 4399.000 121 204
## 20 20.00000 3825.000 104 179
## 21 22.00000 4024.000 109 191
## 22 28.00000 3131.000 95 159
## 23 28.00000 2921.000 96 159
## 24 29.00000 3351.000 96 159
## 25 25.00000 4035.000 109 192
## 26 21.00000 3936.000 104 179
## 27 23.00000 4023.000 110 180
## 28 22.00000 4824.000 111 184
## 29 29.00000 3219.000 107 176
## 30 29.00000 3197.000 107 177
## 31 27.00000 3560.000 107 177
## 32 27.00000 3461.000 107 176
## 33 30.00000 3285.000 107 176
## 34 30.00000 3285.000 107 176
## 35 29.00000 3483.000 107 176
## 36 28.00000 3428.000 114 191
## 37 28.00000 3616.000 107 177
## 38 30.00000 3472.000 114 191
## 39 26.00000 3814.000 114 191
## 40 26.00000 4376.000 118 198
## 41 26.00000 4464.000 123 204
## 42 24.00000 3415.000 107 177
## 43 23.00000 3781.000 108 177
## 44 28.00000 2932.000 98 161
## 45 29.00000 2998.000 98 161
## 46 26.00000 3594.000 107 176
## 47 21.00000 4600.000 113 193
## 48 26.00000 4024.000 112 187
## 49 30.00000 3353.000 109 195
## 50 29.00000 3567.000 112 200
## 51 30.00000 3461.000 109 196
## 52 28.00000 3536.000 109 196
## 53 29.00000 3591.000 112 200
## 54 29.00000 3778.000 114 207
## 55 28.00000 3909.000 114 207
## 56 18.00000 5367.000 116 199
## 57 21.00000 4302.000 116 195
## 58 25.00000 3694.000 113 190
## 59 26.00000 3984.000 115 207
## 60 26.00000 4044.000 115 207
## 61 26.00000 3992.000 112 201
## 62 25.00000 3647.000 106 178
## 63 17.00000 5879.000 130 221
## 64 18.00000 4947.000 130 219
## 65 18.00000 5050.000 116 197
## 66 21.00000 4425.000 113 192
## 67 22.00000 2866.000 98 163
## 68 34.00000 2370.000 98 167
## 69 34.00000 2348.000 98 153
## 70 37.00000 2617.000 104 183
## 71 37.00000 2676.000 104 183
## 72 37.00000 2617.000 104 183
## 73 32.00000 3465.000 111 200
## 74 34.00000 3174.000 106 188
## 75 30.00000 3297.000 106 188
## 76 32.00000 3340.000 111 198
## 77 30.00000 3476.000 111 200
## 78 28.00000 3606.000 111 200
## 79 32.00000 3315.000 106 188
## 80 28.00000 3434.000 111 198
## 81 17.00000 4605.000 111 190
## 82 26.00000 3699.000 112 187
## 83 25.00000 3246.000 105 180
## 84 25.00000 3248.000 105 180
## 85 18.00000 5678.000 130 222
## 86 23.00000 3623.000 111 192
## 87 21.00000 4142.000 119 206
## 88 17.00000 4804.000 144 238
## 89 19.00000 4760.000 116 191
## 90 30.00000 3458.000 112 188
## 91 29.00000 3101.000 103 169
## 92 29.00000 3105.000 103 169
## 93 30.00000 3173.000 108 191
## 94 28.00000 3222.000 108 191
## 95 27.00000 3581.000 113 198
## 96 29.00000 3479.000 113 208
## 97 27.00000 3548.000 113 208
## 98 27.00000 3217.000 103 169
## 99 30.00000 3357.000 106 194
## 100 27.00000 3650.000 113 198
## 101 28.00000 3448.000 106 194
## 102 26.00000 4068.000 119 201
## 103 25.00000 4331.000 119 201
## 104 25.00000 3060.000 95 160
## 105 23.00000 4675.000 116 199
## 106 21.00000 4987.000 119 201
## 107 36.00000 2581.000 105 174
## 108 36.00000 2626.000 105 174
## 109 29.00000 3469.000 113 204
## 110 28.00000 3182.000 108 191
## 111 28.00000 3175.000 108 191
## 112 27.00000 3487.000 113 204
## 113 26.00000 3862.000 113 189
## 114 25.00000 4440.000 119 201
## 115 20.00000 3410.000 99 176
## 116 22.00000 3714.000 112 193
## 117 22.00000 3829.000 131 219
## 118 21.00000 4542.000 121 208
## 119 13.00000 7190.000 137 227
## 120 19.00000 5000.000 119 206
## 121 20.00000 4463.000 114 190
## 122 23.00000 3346.000 103 173
## 123 33.00000 2612.000 103 168
## 124 36.00000 2606.000 103 168
## 125 33.00000 2606.000 103 168
## 126 33.00000 2691.000 103 168
## 127 28.00000 2750.000 103 168
## 128 27.00000 3306.000 109 198
## 129 26.00000 3313.000 109 198
## 130 25.00000 4057.000 115 212
## 131 25.00000 4057.000 115 212
## 132 25.00000 4057.000 115 212
## 133 23.00000 4275.000 121 201
## 134 29.00000 3290.000 101 183
## 135 25.00000 3347.000 101 183
## 136 24.00000 3780.000 107 186
## 137 19.00000 4788.000 126 211
## 138 18.00000 5464.000 133 218
## 139 29.00000 3028.000 111 188
## 140 33.00000 3585.101 103 178
## 141 26.00000 3497.000 109 198
## 142 19.00000 4945.000 129 208
## 143 19.00000 5042.000 116 199
## 144 17.00000 6133.000 130 219
## 145 20.00000 4309.000 111 190
## 146 25.00000 3351.000 111 192
## 147 20.00000 4548.000 144 230
## 148 18.00000 5440.000 133 222
## 149 19.00000 4083.000 123 208
## 150 51.00000 2732.000 103 175
## 151 66.00000 1850.000 95 155
## 152 22.00000 4387.000 106 188
## 153 25.00000 3258.000 103 179
## 154 24.00000 3468.000 101 167
## 155 38.00000 2432.000 103 175
## 156 44.00000 2500.000 103 175
## 157 38.00000 2513.000 103 175
## 158 34.00000 2994.000 105 188
## 159 34.00000 3047.000 105 188
## 160 37.00000 2601.000 103 175
## 161 30.00000 2782.000 101 166
## 162 30.00000 3585.101 108 190
## 163 30.00000 3294.000 105 188
## 164 25.00000 4310.000 118 201
## 165 25.00000 4365.000 118 201
## 166 25.00000 2835.000 95 162
## 167 12.00000 6400.000 123 190
## 168 26.00000 3549.000 103 177
## 169 33.00000 2255.000 96 167
## 170 33.00000 2290.000 96 167
## 171 33.00000 2339.000 96 167
## 172 34.00000 2635.000 103 178
## 173 34.00000 2635.000 103 178
## 174 34.00000 2698.000 103 178
## 175 27.00000 3217.000 106 187
## 176 27.00000 3217.000 106 187
## 177 26.00000 3651.000 108 192
## 178 26.00000 3651.000 108 192
## 179 26.00000 3023.000 100 173
## 180 26.00000 3336.000 112 187
## 181 26.00000 3416.000 112 182
## 182 26.00000 3677.000 112 187
## 183 26.00000 3306.000 108 194
## 184 23.00000 3851.000 110 197
## 185 23.00000 3977.000 113 200
## 186 22.00000 4056.000 112 189
## 187 19.00000 4309.000 112 189
## 188 20.00000 4967.000 129 208
## 189 21.00000 3836.000 106 178
## 190 26.00000 3428.000 107 184
## 191 25.00000 3516.000 107 184
## 192 26.00000 3777.000 115 192
## 193 28.00000 3874.000 115 192
## 194 24.00000 4046.000 115 192
## 195 28.00000 3803.000 119 200
## 196 28.00000 3803.000 119 200
## 197 24.00000 3948.000 119 200
## 198 26.00000 3779.000 102 187
## 199 26.00000 3980.000 102 187
## 200 23.00000 3865.000 102 187
## 201 23.00000 4042.000 102 187
## 202 21.00000 3790.000 106 181
## 203 24.00000 3826.000 104 174
## 204 19.00000 3575.000 93 150
## 205 19.00000 4112.000 107 180
## 206 30.00000 3281.000 106 186
## 207 33.00000 2403.000 95 167
## 208 32.00000 2458.000 95 167
## 209 32.00000 2661.000 101 178
## 210 32.00000 2686.000 101 178
## 211 32.00000 2697.000 101 178
## 212 27.00000 3279.000 106 186
## 213 25.00000 4021.000 110 196
## 214 22.00000 4802.000 115 194
## 215 33.00000 2447.000 95 167
## 216 16.00000 5379.000 113 195
## 217 16.00000 4576.000 100 185
## 218 21.00000 3577.000 101 175
## 219 19.00000 4740.000 110 188
## 220 17.00000 5590.000 112 193
## 221 26.84975 4065.000 107 186
## 222 29.00000 3460.000 107 191
## 223 25.00000 3255.000 105 177
## 224 24.00000 3285.000 105 177
## 225 25.00000 3649.000 110 189
## 226 23.00000 3715.000 110 189
## 227 25.00000 3990.000 115 197
## 228 23.00000 3840.000 103 178
## 229 24.00000 3410.000 105 177
## 230 18.00000 5969.000 119 206
## 231 18.00000 4834.000 114 193
## 232 26.00000 3681.000 115 194
## 233 26.00000 3681.000 115 194
## 234 24.00000 3768.000 115 194
## 235 24.00000 3768.000 115 194
## 236 25.00000 4369.000 118 215
## 237 25.00000 4369.000 118 215
## 238 25.00000 4474.000 124 221
## 239 37.00000 2524.000 97 143
## 240 34.00000 2678.000 97 144
## 241 25.00000 3091.000 107 173
## 242 34.00000 2696.000 104 178
## 243 31.00000 2762.000 104 179
## 244 32.00000 3042.000 105 187
## 245 25.00000 3812.000 112 188
## 246 28.00000 2387.000 89 156
## 247 28.00000 2387.000 89 156
## 248 25.00000 3053.000 106 174
## 249 24.00000 3029.000 106 174
## 250 29.00000 2960.000 112 188
## 251 19.00000 3571.000 126 203
## 252 14.00000 5423.000 112 186
## 253 17.00000 4874.000 111 183
## 254 30.00000 3250.000 107 178
## 255 26.00000 3430.000 107 178
## 256 25.00000 3360.000 107 178
## 257 25.00000 3360.000 107 178
## 258 26.00000 3430.000 107 178
## 259 26.00000 3450.000 107 178
## 260 27.00000 3450.000 107 178
## 261 21.00000 3540.000 107 178
## 262 24.00000 4085.000 114 196
## 263 19.00000 4473.000 114 196
## 264 26.00000 3770.000 107 183
## 265 22.00000 3585.000 107 183
## 266 27.00000 3635.000 112 190
## 267 20.00000 3815.000 112 190
## 268 26.00000 4160.000 122 203
## 269 24.00000 4390.000 122 203
## 270 23.00000 4065.000 101 179
## 271 21.00000 4235.000 101 179
## 272 19.00000 4429.000 101 179
## 273 29.00000 3055.000 95 158
## 274 22.00000 3220.000 95 158
## 275 25.00000 3470.000 107 179
## 276 27.00000 3966.000 112 190
## 277 24.00000 4230.000 112 190
## 278 21.00000 4374.000 114 190
## 279 27.00000 3308.000 109 200
## 280 25.00000 4052.000 115 212
## 281 25.00000 4052.000 115 212
## 282 26.00000 3315.000 109 200
## 283 25.00000 4052.000 115 212
## 284 23.00000 4195.000 115 212
## 285 23.00000 4340.000 121 202
## 286 26.00000 3488.000 109 198
## 287 21.00000 4134.000 109 190
## 288 19.00000 4718.000 110 190
## 289 27.00000 3240.000 103 179
## 290 31.00000 2656.000 102 181
## 291 31.00000 2795.000 102 181
## 292 30.00000 3351.000 108 191
## 293 31.00000 2744.000 102 181
## 294 25.00000 3549.000 107 194
## 295 26.00000 3649.000 108 191
## 296 28.00000 3241.000 101 177
## 297 28.00000 3296.000 101 177
## 298 26.00000 3263.000 103 179
## 299 31.00000 3020.000 102 181
## 300 19.00000 5013.000 123 207
## 301 21.00000 3871.000 106 183
## 302 20.00000 3760.000 104 178
## 303 35.00000 2513.000 100 178
## 304 35.00000 2581.000 100 178
## 305 26.00000 3039.000 110 192
## 306 28.00000 2761.000 100 178
## 307 26.00000 3197.000 110 192
## 308 28.00000 3473.000 111 194
## 309 28.00000 3476.000 111 194
## 310 26.00000 4012.000 124 204
## 311 25.00000 4175.000 124 204
## 312 26.00000 3188.000 104 169
## 313 26.00000 3428.000 104 169
## 314 20.00000 3932.000 116 191
## 315 18.00000 5287.000 140 224
## 316 25.00000 3801.000 111 188
## 317 32.00000 2946.000 107 187
## 318 29.00000 3085.000 107 187
## 319 26.00000 3948.000 120 201
## 320 26.00000 3779.000 108 182
## 321 33.00000 2771.000 104 182
## 322 29.00000 3118.000 107 186
## 323 30.00000 3477.000 111 198
## 324 33.00000 2771.000 104 182
## 325 30.00000 3484.000 111 198
## 326 20.00000 3790.000 112 203
## 327 26.00000 3803.000 112 187
## 328 24.00000 4431.000 121 201
## 329 20.00000 3725.000 110 190
## 330 36.00000 2701.000 102 172
## 331 18.00000 3585.101 112 188
## 332 26.00000 3135.000 93 175
## 333 24.00000 3240.000 93 175
## 334 26.00000 3119.000 93 175
## 335 24.00000 3131.000 93 175
## 336 29.00000 2811.000 95 170
## 337 26.00000 2911.000 95 170
## 338 28.00000 3175.000 105 183
## 339 28.00000 3175.000 105 183
## 340 29.00000 3470.000 106 190
## 341 29.00000 3470.000 106 190
## 342 29.00000 3480.000 105 182
## 343 30.00000 3700.000 105 182
## 344 29.00000 3620.000 106 190
## 345 26.00000 3381.000 107 181
## 346 35.00000 2692.000 103 185
## 347 35.00000 2692.000 103 185
## 348 35.00000 2692.000 103 185
## 349 35.00000 2751.000 103 185
## 350 35.00000 2751.000 103 185
## 351 28.00000 3585.101 107 190
## 352 34.00000 3109.000 107 190
## 353 38.00000 2340.000 93 154
## 354 35.00000 2425.000 98 155
## 355 28.00000 2965.000 99 174
## 356 28.00000 3285.000 104 184
## 357 28.00000 3395.000 104 184
## 358 27.00000 3495.000 104 184
## 359 26.00000 3610.000 104 184
## 360 26.00000 3630.000 104 184
## 361 27.00000 3085.000 99 174
## 362 24.00000 3263.000 100 174
## 363 28.00000 3485.000 104 193
## 364 28.00000 3090.000 99 175
## 365 28.00000 3430.000 104 187
## 366 22.00000 3682.000 110 187
## 367 22.00000 3020.000 98 163
## 368 31.00000 2676.000 98 171
## 369 31.00000 2676.000 98 171
## 370 26.84975 2701.000 102 177
## 371 30.00000 2756.000 102 177
## 372 27.00000 3380.000 106 188
## 373 29.00000 2932.000 98 167
## 374 51.00000 2890.000 106 175
## 375 17.00000 5270.000 118 204
## 376 21.00000 4035.000 110 189
## 377 24.00000 3935.000 107 185
## 378 17.00000 5390.000 112 193
## 379 27.00000 3119.000 98 167
## 380 40.00000 2502.000 102 178
## 381 40.00000 2524.000 102 178
## 382 40.00000 2524.000 102 178
## 383 43.00000 2035.000 93 163
## 384 39.00000 2085.000 93 163
## 385 43.00000 2055.000 93 163
## 386 33.00000 3086.000 107 189
## 387 29.00000 3296.000 107 189
## 388 33.00000 3175.000 107 193
## 389 29.00000 3417.000 107 193
## 390 29.00000 3417.000 107 192
## 391 29.00000 3362.000 107 189
## 392 29.00000 3439.000 107 193
## 393 29.00000 3439.000 107 192
## 394 27.00000 4120.000 119 200
## 395 27.00000 4165.000 119 200
## 396 33.00000 2500.000 102 171
## 397 32.00000 2195.000 97 153
## 398 27.00000 2750.000 103 191
## 399 18.00000 3925.000 128 218
## 400 17.00000 4435.000 128 218
## 401 36.00000 2679.000 102 171
## 402 20.00000 5086.000 112 187
## 403 31.00000 2897.000 99 165
## 404 31.00000 2934.000 99 168
## 405 46.00000 3003.000 99 172
## 406 31.00000 2820.000 99 161
## 407 30.00000 3179.000 99 172
## 408 30.00000 3082.000 99 161
## 409 31.00000 3241.000 106 185
## 410 26.00000 3721.000 106 185
## 411 25.00000 3953.000 106 185
## 412 22.00000 5194.000 118 204
## 413 19.00000 5399.000 118 204
## 414 30.00000 3034.000 99 174
## 415 31.00000 3338.000 106 184
## 416 25.00000 4067.000 106 184
## 417 20.00000 4638.000 113 189
## 418 29.00000 2767.000 101 187
## 419 27.00000 3903.000 107 180
## 420 28.00000 3766.000 107 180
## 421 25.00000 3571.000 107 181
## 422 28.00000 3576.000 110 190
## 423 27.00000 3691.000 110 190
## 424 28.00000 3450.000 105 186
## 425 26.00000 3450.000 105 186
## 426 26.00000 3653.000 110 190
## 427 29.00000 2822.000 101 180
## 428 27.00000 3823.000 109 186
Utilizando algoritmos con la variable mis_datos, responde las siguientes preguntas:
¿Qué marca produce más vehículos y qué marca produce menos?
vehiculos = group_by(mis_datos, Make) #Variable con la que agruparás los renglones
vehiculos = summarise(vehiculos, cantidad = n())
vehiculos1 = vehiculos[order(-vehiculos$cantidad),]
vehiculos1
## # A tibble: 38 x 2
## Make cantidad
## <chr> <int>
## 1 Toyota 28
## 2 Chevrolet 27
## 3 Mercedes-Benz 26
## 4 Ford 23
## 5 BMW 20
## 6 Audi 19
## 7 Honda 17
## 8 Nissan 17
## 9 Chrysler 15
## 10 Volkswagen 15
## # … with 28 more rows
#max(mis_datos$Make)
#min(mis_datos$Make)
La que más produce es Toyota, la que produce menos es Hummer
¿Cuántos autos se producen por región con transmisión delantera, cuántos con transmisión trasera y cuántos con doble transmisión (All)?
## REVISAR
transmisiones = group_by(mis_datos, Origin, DriveTrain) #Variable con la que agruparás los renglones
transmisiones = summarise(transmisiones, cantidad = n())
## `summarise()` has grouped output by 'Origin'. You can override using the `.groups` argument.
transmisiones
## # A tibble: 9 x 3
## # Groups: Origin [3]
## Origin DriveTrain cantidad
## <chr> <chr> <int>
## 1 Asia All 34
## 2 Asia Front 99
## 3 Asia Rear 25
## 4 Europe All 36
## 5 Europe Front 37
## 6 Europe Rear 50
## 7 USA All 22
## 8 USA Front 90
## 9 USA Rear 35
## mal
Encuentra cuál es el precio sugerido más caro, cuál es el precio sugerido más barato, las millas por galón promedio para ciudad y las millas por galón promedio para carretera
max(mis_datos$MSRP)
## [1] 192465
min(mis_datos$MSRP)
## [1] 10280
mean(mis_datos$MPG_City)
## [1] 20.06579
mean(mis_datos$MPG_Highway)
## [1] 26.84042
Selecciona solo las variables Make, Model, Type, Origin, DriveTrain, MSRP, Weight, Wheelbase y Lenght. Conserva solo las observaciones cuyo DriveTrain sea Front y almacena esta información en una variable llamada mis_nuevos_datos.
Imprime las primeras observaciones de la variable mis_nuevos_datos
mis_nuevos_datos = data.frame(mis_datos %>% filter( DriveTrain== "Front") %>% select(Make , Model, Type, Origin, DriveTrain, MSRP, Weight, Wheelbase, Length))
#mis_nuevos_datos = mis_datos %>% filter( DriveTrain== "Front") %>% select(-Invoice, -EngineSize,-Cylinders, -Horsepower, -MPG_City, -MPG_Highway )
head(mis_nuevos_datos, 5)
## Make Model Type Origin DriveTrain MSRP Weight
## 1 Acura RSX Type S 2dr Sedan Asia Front 23820 2778.000
## 2 Acura TSX 4dr Sedan Asia Front 26990 3230.000
## 3 Acura TL 4dr Sedan Asia Front 33195 3585.101
## 4 Acura 3.5 RL 4dr Sedan Asia Front 43755 3880.000
## 5 Acura 3.5 RL w/Navigation 4dr Sedan Asia Front 46100 3893.000
## Wheelbase Length
## 1 101 172
## 2 105 183
## 3 108 186
## 4 115 197
## 5 115 197
Con la información de la variable mis_nuevos_datos, necesitamos crear 3 nuevas variables, la primera llamada Weight_kilo que indique cuál es el peso del automóvil en kilos, la segunda llamada Wheelbase_cm que muestre el valor de la variable Wheelbase en centímetros, y una última variable llamada Length_cm que indique la longitud del vehículo en centímetros. Almacena toda esta información dentro de la variable mis_nuevos_datos
mis_nuevos_datos <- mis_nuevos_datos %>%
mutate(weight_kilo = Weight*0.454) %>%
mutate(wheelbase_cm = Wheelbase*2.54)%>%
mutate(length_cm = Length*2.54)
mis_nuevos_datos
## Make Model Type Origin DriveTrain
## 1 Acura RSX Type S 2dr Sedan Asia Front
## 2 Acura TSX 4dr Sedan Asia Front
## 3 Acura TL 4dr Sedan Asia Front
## 4 Acura 3.5 RL 4dr Sedan Asia Front
## 5 Acura 3.5 RL w/Navigation 4dr Sedan Asia Front
## 6 Audi A4 1.8T 4dr Sedan Europe Front
## 7 Audi A41.8T convertible 2dr Sedan Europe Front
## 8 Audi A4 3.0 4dr Sedan Europe Front
## 9 Audi A6 3.0 4dr Sedan Europe Front
## 10 Audi A4 3.0 convertible 2dr Sedan Europe Front
## 11 Audi RS 6 4dr Sports Europe Front
## 12 Audi TT 1.8 convertible 2dr (coupe) Sports Europe Front
## 13 Buick Rendezvous CX SUV USA Front
## 14 Buick Century Custom 4dr Sedan USA Front
## 15 Buick LeSabre Custom 4dr Sedan USA Front
## 16 Buick Regal LS 4dr Sedan USA Front
## 17 Buick Regal GS 4dr Sedan USA Front
## 18 Buick LeSabre Limited 4dr Sedan USA Front
## 19 Buick Park Avenue 4dr Sedan USA Front
## 20 Buick Park Avenue Ultra 4dr Sedan USA Front
## 21 Cadillac Escalade SUV USA Front
## 22 Cadillac SRX V8 SUV USA Front
## 23 Cadillac Deville 4dr Sedan USA Front
## 24 Cadillac Deville DTS 4dr Sedan USA Front
## 25 Cadillac Seville SLS 4dr Sedan USA Front
## 26 Chevrolet Suburban 1500 LT SUV USA Front
## 27 Chevrolet TrailBlazer LT SUV USA Front
## 28 Chevrolet Tracker SUV USA Front
## 29 Chevrolet Aveo 4dr Sedan USA Front
## 30 Chevrolet Aveo LS 4dr hatch Sedan USA Front
## 31 Chevrolet Cavalier 2dr Sedan USA Front
## 32 Chevrolet Cavalier 4dr Sedan USA Front
## 33 Chevrolet Cavalier LS 2dr Sedan USA Front
## 34 Chevrolet Impala 4dr Sedan USA Front
## 35 Chevrolet Malibu 4dr Sedan USA Front
## 36 Chevrolet Malibu LS 4dr Sedan USA Front
## 37 Chevrolet Monte Carlo LS 2dr Sedan USA Front
## 38 Chevrolet Impala LS 4dr Sedan USA Front
## 39 Chevrolet Impala SS 4dr Sedan USA Front
## 40 Chevrolet Malibu LT 4dr Sedan USA Front
## 41 Chevrolet Monte Carlo SS 2dr Sedan USA Front
## 42 Chevrolet Venture LS Sedan USA Front
## 43 Chevrolet Malibu Maxx LS Wagon USA Front
## 44 Chrysler PT Cruiser 4dr Sedan USA Front
## 45 Chrysler PT Cruiser Limited 4dr Sedan USA Front
## 46 Chrysler Sebring 4dr Sedan USA Front
## 47 Chrysler Sebring Touring 4dr Sedan USA Front
## 48 Chrysler 300M 4dr Sedan USA Front
## 49 Chrysler Concorde LX 4dr Sedan USA Front
## 50 Chrysler Concorde LXi 4dr Sedan USA Front
## 51 Chrysler PT Cruiser GT 4dr Sedan USA Front
## 52 Chrysler Sebring convertible 2dr Sedan USA Front
## 53 Chrysler 300M Special Edition 4dr Sedan USA Front
## 54 Chrysler Sebring Limited convertible 2dr Sedan USA Front
## 55 Chrysler Town and Country LX Sedan USA Front
## 56 Chrysler Town and Country Limited Sedan USA Front
## 57 Dodge Neon SE 4dr Sedan USA Front
## 58 Dodge Neon SXT 4dr Sedan USA Front
## 59 Dodge Intrepid SE 4dr Sedan USA Front
## 60 Dodge Stratus SXT 4dr Sedan USA Front
## 61 Dodge Stratus SE 4dr Sedan USA Front
## 62 Dodge Intrepid ES 4dr Sedan USA Front
## 63 Dodge Caravan SE Sedan USA Front
## 64 Ford Expedition 4.6 XLT SUV USA Front
## 65 Ford Focus ZX3 2dr hatch Sedan USA Front
## 66 Ford Focus LX 4dr Sedan USA Front
## 67 Ford Focus SE 4dr Sedan USA Front
## 68 Ford Focus ZX5 5dr Sedan USA Front
## 69 Ford Focus SVT 2dr Sedan USA Front
## 70 Ford Taurus LX 4dr Sedan USA Front
## 71 Ford Taurus SES Duratec 4dr Sedan USA Front
## 72 Ford Freestar SE Sedan USA Front
## 73 Ford Thunderbird Deluxe convert w/hardtop 2d Sports USA Front
## 74 Ford Focus ZTW Wagon USA Front
## 75 Ford Taurus SE Wagon USA Front
## 76 GMC Envoy XUV SLE SUV USA Front
## 77 GMC Yukon 1500 SLE SUV USA Front
## 78 Honda Civic Hybrid 4dr manual (gas/electric) Hybrid Asia Front
## 79 Honda Insight 2dr (gas/electric) Hybrid Asia Front
## 80 Honda Civic DX 2dr Sedan Asia Front
## 81 Honda Civic HX 2dr Sedan Asia Front
## 82 Honda Civic LX 4dr Sedan Asia Front
## 83 Honda Accord LX 2dr Sedan Asia Front
## 84 Honda Accord EX 2dr Sedan Asia Front
## 85 Honda Civic EX 4dr Sedan Asia Front
## 86 Honda Civic Si 2dr hatch Sedan Asia Front
## 87 Honda Accord LX V6 4dr Sedan Asia Front
## 88 Honda Accord EX V6 2dr Sedan Asia Front
## 89 Honda Odyssey LX Sedan Asia Front
## 90 Honda Odyssey EX Sedan Asia Front
## 91 Hyundai Santa Fe GLS SUV Asia Front
## 92 Hyundai Accent 2dr hatch Sedan Asia Front
## 93 Hyundai Accent GL 4dr Sedan Asia Front
## 94 Hyundai Accent GT 2dr hatch Sedan Asia Front
## 95 Hyundai Elantra GLS 4dr Sedan Asia Front
## 96 Hyundai Elantra GT 4dr Sedan Asia Front
## 97 Hyundai Elantra GT 4dr hatch Sedan Asia Front
## 98 Hyundai Sonata GLS 4dr Sedan Asia Front
## 99 Hyundai Sonata LX 4dr Sedan Asia Front
## 100 Hyundai XG350 4dr Sedan Asia Front
## 101 Hyundai XG350 L 4dr Sedan Asia Front
## 102 Hyundai Tiburon GT V6 2dr Sports Asia Front
## 103 Infiniti I35 4dr Sedan Asia Front
## 104 Isuzu Rodeo S SUV Asia Front
## 105 Jeep Grand Cherokee Laredo SUV USA Front
## 106 Kia Sorento LX SUV Asia Front
## 107 Kia Optima LX 4dr Sedan Asia Front
## 108 Kia Rio 4dr manual Sedan Asia Front
## 109 Kia Rio 4dr auto Sedan Asia Front
## 110 Kia Spectra 4dr Sedan Asia Front
## 111 Kia Spectra GS 4dr hatch Sedan Asia Front
## 112 Kia Spectra GSX 4dr hatch Sedan Asia Front
## 113 Kia Optima LX V6 4dr Sedan Asia Front
## 114 Kia Amanti 4dr Sedan Asia Front
## 115 Kia Sedona LX Sedan Asia Front
## 116 Kia Rio Cinco Wagon Asia Front
## 117 Lexus ES 330 4dr Sedan Asia Front
## 118 Lincoln Aviator Ultimate SUV USA Front
## 119 MINI Cooper Sedan Europe Front
## 120 MINI Cooper S Sedan Europe Front
## 121 Mazda Mazda3 i 4dr Sedan Asia Front
## 122 Mazda Mazda3 s 4dr Sedan Asia Front
## 123 Mazda Mazda6 i 4dr Sedan Asia Front
## 124 Mazda MPV ES Sedan Asia Front
## 125 Mercury Mountaineer SUV USA Front
## 126 Mercury Sable GS 4dr Sedan USA Front
## 127 Mercury Sable LS Premium 4dr Sedan USA Front
## 128 Mercury Monterey Luxury Sedan USA Front
## 129 Mercury Sable GS Wagon USA Front
## 130 Mitsubishi Outlander LS SUV Asia Front
## 131 Mitsubishi Lancer ES 4dr Sedan Asia Front
## 132 Mitsubishi Lancer LS 4dr Sedan Asia Front
## 133 Mitsubishi Galant ES 2.4L 4dr Sedan Asia Front
## 134 Mitsubishi Lancer OZ Rally 4dr auto Sedan Asia Front
## 135 Mitsubishi Diamante LS 4dr Sedan Asia Front
## 136 Mitsubishi Galant GTS 4dr Sedan Asia Front
## 137 Mitsubishi Eclipse GTS 2dr Sports Asia Front
## 138 Mitsubishi Eclipse Spyder GT convertible 2dr Sports Asia Front
## 139 Mitsubishi Lancer Evolution 4dr Sports Asia Front
## 140 Mitsubishi Lancer Sportback LS Wagon Asia Front
## 141 Nissan Pathfinder Armada SE SUV Asia Front
## 142 Nissan Pathfinder SE SUV Asia Front
## 143 Nissan Xterra XE V6 SUV Asia Front
## 144 Nissan Sentra 1.8 4dr Sedan Asia Front
## 145 Nissan Sentra 1.8 S 4dr Sedan Asia Front
## 146 Nissan Altima S 4dr Sedan Asia Front
## 147 Nissan Sentra SE-R 4dr Sedan Asia Front
## 148 Nissan Altima SE 4dr Sedan Asia Front
## 149 Nissan Maxima SE 4dr Sedan Asia Front
## 150 Nissan Maxima SL 4dr Sedan Asia Front
## 151 Nissan Quest S Sedan Asia Front
## 152 Nissan Quest SE Sedan Asia Front
## 153 Oldsmobile Alero GX 2dr Sedan USA Front
## 154 Oldsmobile Alero GLS 2dr Sedan USA Front
## 155 Oldsmobile Silhouette GL Sedan USA Front
## 156 Pontiac Aztekt SUV USA Front
## 157 Pontiac Sunfire 1SA 2dr Sedan USA Front
## 158 Pontiac Grand Am GT 2dr Sedan USA Front
## 159 Pontiac Grand Prix GT1 4dr Sedan USA Front
## 160 Pontiac Sunfire 1SC 2dr Sedan USA Front
## 161 Pontiac Grand Prix GT2 4dr Sedan USA Front
## 162 Pontiac Bonneville GXP 4dr Sedan USA Front
## 163 Pontiac Montana Sedan USA Front
## 164 Saab 9-3 Arc Sport 4dr Sedan Europe Front
## 165 Saab 9-3 Aero 4dr Sedan Europe Front
## 166 Saab 9-5 Arc 4dr Sedan Europe Front
## 167 Saab 9-5 Aero 4dr Sedan Europe Front
## 168 Saab 9-3 Arc convertible 2dr Sedan Europe Front
## 169 Saab 9-3 Aero convertible 2dr Sedan Europe Front
## 170 Saab 9-5 Aero Wagon Europe Front
## 171 Saturn Ion1 4dr Sedan USA Front
## 172 Saturn lon2 4dr Sedan USA Front
## 173 Saturn lon3 4dr Sedan USA Front
## 174 Saturn lon2 quad coupe 2dr Sedan USA Front
## 175 Saturn lon3 quad coupe 2dr Sedan USA Front
## 176 Saturn L300-2 4dr Sedan USA Front
## 177 Saturn L300 2 Wagon USA Front
## 178 Scion xA 4dr hatch Sedan Asia Front
## 179 Scion xB Wagon Asia Front
## 180 Suzuki XL-7 EX SUV Asia Front
## 181 Suzuki Aeno S 4dr Sedan Asia Front
## 182 Suzuki Aerio LX 4dr Sedan Asia Front
## 183 Suzuki Forenza S 4dr Sedan Asia Front
## 184 Suzuki Forenza EX 4dr Sedan Asia Front
## 185 Suzuki Verona LX 4dr Sedan Asia Front
## 186 Toyota Prius 4dr (gas/electric) Hybrid Asia Front
## 187 Toyota 4Runner SR5 V6 SUV Asia Front
## 188 Toyota Corolla CE 4dr Sedan Asia Front
## 189 Toyota Corolla S 4dr Sedan Asia Front
## 190 Toyota Corolla LE 4dr Sedan Asia Front
## 191 Toyota Echo 2dr manual Sedan Asia Front
## 192 Toyota Echo 2dr auto Sedan Asia Front
## 193 Toyota Echo 4dr Sedan Asia Front
## 194 Toyota Camry LE 4dr Sedan Asia Front
## 195 Toyota Camry LE V6 4dr Sedan Asia Front
## 196 Toyota Camry Solara SE 2dr Sedan Asia Front
## 197 Toyota Camry Solara SE V6 2dr Sedan Asia Front
## 198 Toyota Avalon XL 4dr Sedan Asia Front
## 199 Toyota Camry XLE V6 4dr Sedan Asia Front
## 200 Toyota Camry Solara SLE V6 2dr Sedan Asia Front
## 201 Toyota Avalon XLS 4dr Sedan Asia Front
## 202 Toyota Sienna CE Sedan Asia Front
## 203 Toyota Sienna XLE Limited Sedan Asia Front
## 204 Toyota Celica GT-S 2dr Sports Asia Front
## 205 Toyota Matrix XR Wagon Asia Front
## 206 Volkswagen Golf GLS 4dr Sedan Europe Front
## 207 Volkswagen GTI 1.8T 2dr hatch Sedan Europe Front
## 208 Volkswagen Jetta GLS TDI 4dr Sedan Europe Front
## 209 Volkswagen New Beetle GLS 1.8T 2dr Sedan Europe Front
## 210 Volkswagen Jetta GLI VR6 4dr Sedan Europe Front
## 211 Volkswagen New Beetle GLS convertible 2dr Sedan Europe Front
## 212 Volkswagen Passat GLS 4dr Sedan Europe Front
## 213 Volkswagen Passat GLX V6 4MOTION 4dr Sedan Europe Front
## 214 Volkswagen Passat W8 4MOTION 4dr Sedan Europe Front
## 215 Volkswagen Phaeton 4dr Sedan Europe Front
## 216 Volkswagen Phaeton W12 4dr Sedan Europe Front
## 217 Volkswagen Jetta GL Wagon Europe Front
## 218 Volkswagen Passat GLS 1.8T Wagon Europe Front
## 219 Volkswagen Passat W8 Wagon Europe Front
## 220 Volvo S40 4dr Sedan Europe Front
## 221 Volvo S60 T5 4dr Sedan Europe Front
## 222 Volvo S80 2.9 4dr Sedan Europe Front
## 223 Volvo C70 LPT convertible 2dr Sedan Europe Front
## 224 Volvo C70 HPT convertible 2dr Sedan Europe Front
## 225 Volvo S80 T6 4dr Sedan Europe Front
## 226 Volvo V40 Wagon Europe Front
## MSRP Weight Wheelbase Length weight_kilo wheelbase_cm length_cm
## 1 23820 2778.000 101 172 1261.212 256.54 436.88
## 2 26990 3230.000 105 183 1466.420 266.70 464.82
## 3 33195 3585.101 108 186 1627.636 274.32 472.44
## 4 43755 3880.000 115 197 1761.520 292.10 500.38
## 5 46100 3893.000 115 197 1767.422 292.10 500.38
## 6 25940 3252.000 104 179 1476.408 264.16 454.66
## 7 35940 3638.000 105 180 1651.652 266.70 457.20
## 8 31840 3462.000 104 179 1571.748 264.16 454.66
## 9 36640 3561.000 109 192 1616.694 276.86 487.68
## 10 42490 3814.000 105 180 1731.556 266.70 457.20
## 11 84600 4024.000 109 191 1826.896 276.86 485.14
## 12 35940 3131.000 95 159 1421.474 241.30 403.86
## 13 26545 4024.000 112 187 1826.896 284.48 474.98
## 14 22180 3353.000 109 195 1522.262 276.86 495.30
## 15 26470 3567.000 112 200 1619.418 284.48 508.00
## 16 24895 3461.000 109 196 1571.294 276.86 497.84
## 17 28345 3536.000 109 196 1605.344 276.86 497.84
## 18 32245 3591.000 112 200 1630.314 284.48 508.00
## 19 35545 3778.000 114 207 1715.212 289.56 525.78
## 20 40720 3909.000 114 207 1774.686 289.56 525.78
## 21 52795 5367.000 116 199 2436.618 294.64 505.46
## 22 46995 4302.000 116 195 1953.108 294.64 495.30
## 23 45445 3984.000 115 207 1808.736 292.10 525.78
## 24 50595 4044.000 115 207 1835.976 292.10 525.78
## 25 47955 3992.000 112 201 1812.368 284.48 510.54
## 26 42735 4947.000 130 219 2245.938 330.20 556.26
## 27 30295 4425.000 113 192 2008.950 287.02 487.68
## 28 20255 2866.000 98 163 1301.164 248.92 414.02
## 29 11690 2370.000 98 167 1075.980 248.92 424.18
## 30 12585 2348.000 98 153 1065.992 248.92 388.62
## 31 14610 2617.000 104 183 1188.118 264.16 464.82
## 32 14810 2676.000 104 183 1214.904 264.16 464.82
## 33 16385 2617.000 104 183 1188.118 264.16 464.82
## 34 21900 3465.000 111 200 1573.110 281.94 508.00
## 35 18995 3174.000 106 188 1440.996 269.24 477.52
## 36 20370 3297.000 106 188 1496.838 269.24 477.52
## 37 21825 3340.000 111 198 1516.360 281.94 502.92
## 38 25000 3476.000 111 200 1578.104 281.94 508.00
## 39 27995 3606.000 111 200 1637.124 281.94 508.00
## 40 23495 3315.000 106 188 1505.010 269.24 477.52
## 41 24225 3434.000 111 198 1559.036 281.94 502.92
## 42 27020 3699.000 112 187 1679.346 284.48 474.98
## 43 22225 3458.000 112 188 1569.932 284.48 477.52
## 44 17985 3101.000 103 169 1407.854 261.62 429.26
## 45 22000 3105.000 103 169 1409.670 261.62 429.26
## 46 19090 3173.000 108 191 1440.542 274.32 485.14
## 47 21840 3222.000 108 191 1462.788 274.32 485.14
## 48 29865 3581.000 113 198 1625.774 287.02 502.92
## 49 24130 3479.000 113 208 1579.466 287.02 528.32
## 50 26860 3548.000 113 208 1610.792 287.02 528.32
## 51 25955 3217.000 103 169 1460.518 261.62 429.26
## 52 25215 3357.000 106 194 1524.078 269.24 492.76
## 53 33295 3650.000 113 198 1657.100 287.02 502.92
## 54 30950 3448.000 106 194 1565.392 269.24 492.76
## 55 27490 4068.000 119 201 1846.872 302.26 510.54
## 56 38380 4331.000 119 201 1966.274 302.26 510.54
## 57 13670 2581.000 105 174 1171.774 266.70 441.96
## 58 15040 2626.000 105 174 1192.204 266.70 441.96
## 59 22035 3469.000 113 204 1574.926 287.02 518.16
## 60 18820 3182.000 108 191 1444.628 274.32 485.14
## 61 20220 3175.000 108 191 1441.450 274.32 485.14
## 62 24885 3487.000 113 204 1583.098 287.02 518.16
## 63 21795 3862.000 113 189 1753.348 287.02 480.06
## 64 34560 5000.000 119 206 2270.000 302.26 523.24
## 65 13270 2612.000 103 168 1185.848 261.62 426.72
## 66 13730 2606.000 103 168 1183.124 261.62 426.72
## 67 15460 2606.000 103 168 1183.124 261.62 426.72
## 68 15580 2691.000 103 168 1221.714 261.62 426.72
## 69 19135 2750.000 103 168 1248.500 261.62 426.72
## 70 20320 3306.000 109 198 1500.924 276.86 502.92
## 71 22735 3313.000 109 198 1504.102 276.86 502.92
## 72 26930 4275.000 121 201 1940.850 307.34 510.54
## 73 37530 3780.000 107 186 1716.120 271.78 472.44
## 74 17475 3585.101 103 178 1627.636 261.62 452.12
## 75 22290 3497.000 109 198 1587.638 276.86 502.92
## 76 31890 4945.000 129 208 2245.030 327.66 528.32
## 77 35725 5042.000 116 199 2289.068 294.64 505.46
## 78 20140 2732.000 103 175 1240.328 261.62 444.50
## 79 19110 1850.000 95 155 839.900 241.30 393.70
## 80 13270 2432.000 103 175 1104.128 261.62 444.50
## 81 14170 2500.000 103 175 1135.000 261.62 444.50
## 82 15850 2513.000 103 175 1140.902 261.62 444.50
## 83 19860 2994.000 105 188 1359.276 266.70 477.52
## 84 22260 3047.000 105 188 1383.338 266.70 477.52
## 85 17750 2601.000 103 175 1180.854 261.62 444.50
## 86 19490 2782.000 101 166 1263.028 256.54 421.64
## 87 23760 3585.101 108 190 1627.636 274.32 482.60
## 88 26960 3294.000 105 188 1495.476 266.70 477.52
## 89 24950 4310.000 118 201 1956.740 299.72 510.54
## 90 27450 4365.000 118 201 1981.710 299.72 510.54
## 91 21589 3549.000 103 177 1611.246 261.62 449.58
## 92 10539 2255.000 96 167 1023.770 243.84 424.18
## 93 11839 2290.000 96 167 1039.660 243.84 424.18
## 94 11939 2339.000 96 167 1061.906 243.84 424.18
## 95 13839 2635.000 103 178 1196.290 261.62 452.12
## 96 15389 2635.000 103 178 1196.290 261.62 452.12
## 97 15389 2698.000 103 178 1224.892 261.62 452.12
## 98 19339 3217.000 106 187 1460.518 269.24 474.98
## 99 20339 3217.000 106 187 1460.518 269.24 474.98
## 100 24589 3651.000 108 192 1657.554 274.32 487.68
## 101 26189 3651.000 108 192 1657.554 274.32 487.68
## 102 18739 3023.000 100 173 1372.442 254.00 439.42
## 103 31145 3306.000 108 194 1500.924 274.32 492.76
## 104 20449 3836.000 106 178 1741.544 269.24 452.12
## 105 27905 3790.000 106 181 1720.660 269.24 459.74
## 106 19635 4112.000 107 180 1866.848 271.78 457.20
## 107 16040 3281.000 106 186 1489.574 269.24 472.44
## 108 10280 2403.000 95 167 1090.962 241.30 424.18
## 109 11155 2458.000 95 167 1115.932 241.30 424.18
## 110 12360 2661.000 101 178 1208.094 256.54 452.12
## 111 13580 2686.000 101 178 1219.444 256.54 452.12
## 112 14630 2697.000 101 178 1224.438 256.54 452.12
## 113 18435 3279.000 106 186 1488.666 269.24 472.44
## 114 26000 4021.000 110 196 1825.534 279.40 497.84
## 115 20615 4802.000 115 194 2180.108 292.10 492.76
## 116 11905 2447.000 95 167 1110.938 241.30 424.18
## 117 32350 3460.000 107 191 1570.840 271.78 485.14
## 118 42915 4834.000 114 193 2194.636 289.56 490.22
## 119 16999 2524.000 97 143 1145.896 246.38 363.22
## 120 19999 2678.000 97 144 1215.812 246.38 365.76
## 121 15500 2696.000 104 178 1223.984 264.16 452.12
## 122 17200 2762.000 104 179 1253.948 264.16 454.66
## 123 19270 3042.000 105 187 1381.068 266.70 474.98
## 124 28750 3812.000 112 188 1730.648 284.48 477.52
## 125 29995 4374.000 114 190 1985.796 289.56 482.60
## 126 21595 3308.000 109 200 1501.832 276.86 508.00
## 127 23895 3315.000 109 200 1505.010 276.86 508.00
## 128 33995 4340.000 121 202 1970.360 307.34 513.08
## 129 22595 3488.000 109 198 1583.552 276.86 502.92
## 130 18892 3240.000 103 179 1470.960 261.62 454.66
## 131 14622 2656.000 102 181 1205.824 259.08 459.74
## 132 16722 2795.000 102 181 1268.930 259.08 459.74
## 133 19312 3351.000 108 191 1521.354 274.32 485.14
## 134 17232 2744.000 102 181 1245.776 259.08 459.74
## 135 29282 3549.000 107 194 1611.246 271.78 492.76
## 136 25700 3649.000 108 191 1656.646 274.32 485.14
## 137 25092 3241.000 101 177 1471.414 256.54 449.58
## 138 26992 3296.000 101 177 1496.384 256.54 449.58
## 139 29562 3263.000 103 179 1481.402 261.62 454.66
## 140 17495 3020.000 102 181 1371.080 259.08 459.74
## 141 33840 5013.000 123 207 2275.902 312.42 525.78
## 142 27339 3871.000 106 183 1757.434 269.24 464.82
## 143 20939 3760.000 104 178 1707.040 264.16 452.12
## 144 12740 2513.000 100 178 1140.902 254.00 452.12
## 145 14740 2581.000 100 178 1171.774 254.00 452.12
## 146 19240 3039.000 110 192 1379.706 279.40 487.68
## 147 17640 2761.000 100 178 1253.494 254.00 452.12
## 148 23290 3197.000 110 192 1451.438 279.40 487.68
## 149 27490 3473.000 111 194 1576.742 281.94 492.76
## 150 29440 3476.000 111 194 1578.104 281.94 492.76
## 151 24780 4012.000 124 204 1821.448 314.96 518.16
## 152 32780 4175.000 124 204 1895.450 314.96 518.16
## 153 18825 2946.000 107 187 1337.484 271.78 474.98
## 154 23675 3085.000 107 187 1400.590 271.78 474.98
## 155 28790 3948.000 120 201 1792.392 304.80 510.54
## 156 21595 3779.000 108 182 1715.666 274.32 462.28
## 157 15495 2771.000 104 182 1258.034 264.16 462.28
## 158 22450 3118.000 107 186 1415.572 271.78 472.44
## 159 22395 3477.000 111 198 1578.558 281.94 502.92
## 160 17735 2771.000 104 182 1258.034 264.16 462.28
## 161 24295 3484.000 111 198 1581.736 281.94 502.92
## 162 35995 3790.000 112 203 1720.660 284.48 515.62
## 163 23845 3803.000 112 187 1726.562 284.48 474.98
## 164 30860 3175.000 105 183 1441.450 266.70 464.82
## 165 33360 3175.000 105 183 1441.450 266.70 464.82
## 166 35105 3470.000 106 190 1575.380 269.24 482.60
## 167 39465 3470.000 106 190 1575.380 269.24 482.60
## 168 40670 3480.000 105 182 1579.920 266.70 462.28
## 169 43175 3700.000 105 182 1679.800 266.70 462.28
## 170 40845 3620.000 106 190 1643.480 269.24 482.60
## 171 10995 2692.000 103 185 1222.168 261.62 469.90
## 172 14300 2692.000 103 185 1222.168 261.62 469.90
## 173 15825 2692.000 103 185 1222.168 261.62 469.90
## 174 14850 2751.000 103 185 1248.954 261.62 469.90
## 175 16350 2751.000 103 185 1248.954 261.62 469.90
## 176 21410 3585.101 107 190 1627.636 271.78 482.60
## 177 23560 3109.000 107 190 1411.486 271.78 482.60
## 178 12965 2340.000 93 154 1062.360 236.22 391.16
## 179 14165 2425.000 98 155 1100.950 248.92 393.70
## 180 23699 3682.000 110 187 1671.628 279.40 474.98
## 181 12884 2676.000 98 171 1214.904 248.92 434.34
## 182 14500 2676.000 98 171 1214.904 248.92 434.34
## 183 12269 2701.000 102 177 1226.254 259.08 449.58
## 184 15568 2756.000 102 177 1251.224 259.08 449.58
## 185 17262 3380.000 106 188 1534.520 269.24 477.52
## 186 20510 2890.000 106 175 1312.060 269.24 444.50
## 187 27710 4035.000 110 189 1831.890 279.40 480.06
## 188 14085 2502.000 102 178 1135.908 259.08 452.12
## 189 15030 2524.000 102 178 1145.896 259.08 452.12
## 190 15295 2524.000 102 178 1145.896 259.08 452.12
## 191 10760 2035.000 93 163 923.890 236.22 414.02
## 192 11560 2085.000 93 163 946.590 236.22 414.02
## 193 11290 2055.000 93 163 932.970 236.22 414.02
## 194 19560 3086.000 107 189 1401.044 271.78 480.06
## 195 22775 3296.000 107 189 1496.384 271.78 480.06
## 196 19635 3175.000 107 193 1441.450 271.78 490.22
## 197 21965 3417.000 107 193 1551.318 271.78 490.22
## 198 26560 3417.000 107 192 1551.318 271.78 487.68
## 199 25920 3362.000 107 189 1526.348 271.78 480.06
## 200 26510 3439.000 107 193 1561.306 271.78 490.22
## 201 30920 3439.000 107 192 1561.306 271.78 487.68
## 202 23495 4120.000 119 200 1870.480 302.26 508.00
## 203 28800 4165.000 119 200 1890.910 302.26 508.00
## 204 22570 2500.000 102 171 1135.000 259.08 434.34
## 205 16695 2679.000 102 171 1216.266 259.08 434.34
## 206 18715 2897.000 99 165 1315.238 251.46 419.10
## 207 19825 2934.000 99 168 1332.036 251.46 426.72
## 208 21055 3003.000 99 172 1363.362 251.46 436.88
## 209 21055 2820.000 99 161 1280.280 251.46 408.94
## 210 23785 3179.000 99 172 1443.266 251.46 436.88
## 211 23215 3082.000 99 161 1399.228 251.46 408.94
## 212 23955 3241.000 106 185 1471.414 269.24 469.90
## 213 33180 3721.000 106 185 1689.334 269.24 469.90
## 214 39235 3953.000 106 185 1794.662 269.24 469.90
## 215 65000 5194.000 118 204 2358.076 299.72 518.16
## 216 75000 5399.000 118 204 2451.146 299.72 518.16
## 217 19005 3034.000 99 174 1377.436 251.46 441.96
## 218 24955 3338.000 106 184 1515.452 269.24 467.36
## 219 40235 4067.000 106 184 1846.418 269.24 467.36
## 220 25135 2767.000 101 187 1256.218 256.54 474.98
## 221 34845 3766.000 107 180 1709.764 271.78 457.20
## 222 37730 3576.000 110 190 1623.504 279.40 482.60
## 223 40565 3450.000 105 186 1566.300 266.70 472.44
## 224 42565 3450.000 105 186 1566.300 266.70 472.44
## 225 45210 3653.000 110 190 1658.462 279.40 482.60
## 226 26135 2822.000 101 180 1281.188 256.54 457.20
#mis_nuevos_datos$Wheelbase_cm = mis_datos$Wheelbase %>% filter( DriveTrain== "Front")
#mis_nuevos_datos$Length_cm = mis_datos$Length %>% filter( DriveTrain== "Front")
#head(mis_nuevos_datos,5)
Con la información de la variable mis_nuevos_datos, crea una nueva variable llamada opinion que esté en función del precio sugerido para la venta. Si el precio es mayor a 60,000 el valor de la variable opinion debe ser “Expensive”, si el precio está entre 60,000 y 30,000, la variable opinion debe decir “Normal”. Y si el precio es menor a 30,000 la variable opinion debe sugerir “Unexpensive”. Almacena la información en la variable mis_nuevos_datos
mis_nuevos_datos = mis_nuevos_datos %>% mutate(Opinion_MSRP=if_else(MSRP > 60000, "Expensive",if_else(MSRP < 30000, "Unexpensive", "Normal")))
mis_nuevos_datos
## Make Model Type Origin DriveTrain
## 1 Acura RSX Type S 2dr Sedan Asia Front
## 2 Acura TSX 4dr Sedan Asia Front
## 3 Acura TL 4dr Sedan Asia Front
## 4 Acura 3.5 RL 4dr Sedan Asia Front
## 5 Acura 3.5 RL w/Navigation 4dr Sedan Asia Front
## 6 Audi A4 1.8T 4dr Sedan Europe Front
## 7 Audi A41.8T convertible 2dr Sedan Europe Front
## 8 Audi A4 3.0 4dr Sedan Europe Front
## 9 Audi A6 3.0 4dr Sedan Europe Front
## 10 Audi A4 3.0 convertible 2dr Sedan Europe Front
## 11 Audi RS 6 4dr Sports Europe Front
## 12 Audi TT 1.8 convertible 2dr (coupe) Sports Europe Front
## 13 Buick Rendezvous CX SUV USA Front
## 14 Buick Century Custom 4dr Sedan USA Front
## 15 Buick LeSabre Custom 4dr Sedan USA Front
## 16 Buick Regal LS 4dr Sedan USA Front
## 17 Buick Regal GS 4dr Sedan USA Front
## 18 Buick LeSabre Limited 4dr Sedan USA Front
## 19 Buick Park Avenue 4dr Sedan USA Front
## 20 Buick Park Avenue Ultra 4dr Sedan USA Front
## 21 Cadillac Escalade SUV USA Front
## 22 Cadillac SRX V8 SUV USA Front
## 23 Cadillac Deville 4dr Sedan USA Front
## 24 Cadillac Deville DTS 4dr Sedan USA Front
## 25 Cadillac Seville SLS 4dr Sedan USA Front
## 26 Chevrolet Suburban 1500 LT SUV USA Front
## 27 Chevrolet TrailBlazer LT SUV USA Front
## 28 Chevrolet Tracker SUV USA Front
## 29 Chevrolet Aveo 4dr Sedan USA Front
## 30 Chevrolet Aveo LS 4dr hatch Sedan USA Front
## 31 Chevrolet Cavalier 2dr Sedan USA Front
## 32 Chevrolet Cavalier 4dr Sedan USA Front
## 33 Chevrolet Cavalier LS 2dr Sedan USA Front
## 34 Chevrolet Impala 4dr Sedan USA Front
## 35 Chevrolet Malibu 4dr Sedan USA Front
## 36 Chevrolet Malibu LS 4dr Sedan USA Front
## 37 Chevrolet Monte Carlo LS 2dr Sedan USA Front
## 38 Chevrolet Impala LS 4dr Sedan USA Front
## 39 Chevrolet Impala SS 4dr Sedan USA Front
## 40 Chevrolet Malibu LT 4dr Sedan USA Front
## 41 Chevrolet Monte Carlo SS 2dr Sedan USA Front
## 42 Chevrolet Venture LS Sedan USA Front
## 43 Chevrolet Malibu Maxx LS Wagon USA Front
## 44 Chrysler PT Cruiser 4dr Sedan USA Front
## 45 Chrysler PT Cruiser Limited 4dr Sedan USA Front
## 46 Chrysler Sebring 4dr Sedan USA Front
## 47 Chrysler Sebring Touring 4dr Sedan USA Front
## 48 Chrysler 300M 4dr Sedan USA Front
## 49 Chrysler Concorde LX 4dr Sedan USA Front
## 50 Chrysler Concorde LXi 4dr Sedan USA Front
## 51 Chrysler PT Cruiser GT 4dr Sedan USA Front
## 52 Chrysler Sebring convertible 2dr Sedan USA Front
## 53 Chrysler 300M Special Edition 4dr Sedan USA Front
## 54 Chrysler Sebring Limited convertible 2dr Sedan USA Front
## 55 Chrysler Town and Country LX Sedan USA Front
## 56 Chrysler Town and Country Limited Sedan USA Front
## 57 Dodge Neon SE 4dr Sedan USA Front
## 58 Dodge Neon SXT 4dr Sedan USA Front
## 59 Dodge Intrepid SE 4dr Sedan USA Front
## 60 Dodge Stratus SXT 4dr Sedan USA Front
## 61 Dodge Stratus SE 4dr Sedan USA Front
## 62 Dodge Intrepid ES 4dr Sedan USA Front
## 63 Dodge Caravan SE Sedan USA Front
## 64 Ford Expedition 4.6 XLT SUV USA Front
## 65 Ford Focus ZX3 2dr hatch Sedan USA Front
## 66 Ford Focus LX 4dr Sedan USA Front
## 67 Ford Focus SE 4dr Sedan USA Front
## 68 Ford Focus ZX5 5dr Sedan USA Front
## 69 Ford Focus SVT 2dr Sedan USA Front
## 70 Ford Taurus LX 4dr Sedan USA Front
## 71 Ford Taurus SES Duratec 4dr Sedan USA Front
## 72 Ford Freestar SE Sedan USA Front
## 73 Ford Thunderbird Deluxe convert w/hardtop 2d Sports USA Front
## 74 Ford Focus ZTW Wagon USA Front
## 75 Ford Taurus SE Wagon USA Front
## 76 GMC Envoy XUV SLE SUV USA Front
## 77 GMC Yukon 1500 SLE SUV USA Front
## 78 Honda Civic Hybrid 4dr manual (gas/electric) Hybrid Asia Front
## 79 Honda Insight 2dr (gas/electric) Hybrid Asia Front
## 80 Honda Civic DX 2dr Sedan Asia Front
## 81 Honda Civic HX 2dr Sedan Asia Front
## 82 Honda Civic LX 4dr Sedan Asia Front
## 83 Honda Accord LX 2dr Sedan Asia Front
## 84 Honda Accord EX 2dr Sedan Asia Front
## 85 Honda Civic EX 4dr Sedan Asia Front
## 86 Honda Civic Si 2dr hatch Sedan Asia Front
## 87 Honda Accord LX V6 4dr Sedan Asia Front
## 88 Honda Accord EX V6 2dr Sedan Asia Front
## 89 Honda Odyssey LX Sedan Asia Front
## 90 Honda Odyssey EX Sedan Asia Front
## 91 Hyundai Santa Fe GLS SUV Asia Front
## 92 Hyundai Accent 2dr hatch Sedan Asia Front
## 93 Hyundai Accent GL 4dr Sedan Asia Front
## 94 Hyundai Accent GT 2dr hatch Sedan Asia Front
## 95 Hyundai Elantra GLS 4dr Sedan Asia Front
## 96 Hyundai Elantra GT 4dr Sedan Asia Front
## 97 Hyundai Elantra GT 4dr hatch Sedan Asia Front
## 98 Hyundai Sonata GLS 4dr Sedan Asia Front
## 99 Hyundai Sonata LX 4dr Sedan Asia Front
## 100 Hyundai XG350 4dr Sedan Asia Front
## 101 Hyundai XG350 L 4dr Sedan Asia Front
## 102 Hyundai Tiburon GT V6 2dr Sports Asia Front
## 103 Infiniti I35 4dr Sedan Asia Front
## 104 Isuzu Rodeo S SUV Asia Front
## 105 Jeep Grand Cherokee Laredo SUV USA Front
## 106 Kia Sorento LX SUV Asia Front
## 107 Kia Optima LX 4dr Sedan Asia Front
## 108 Kia Rio 4dr manual Sedan Asia Front
## 109 Kia Rio 4dr auto Sedan Asia Front
## 110 Kia Spectra 4dr Sedan Asia Front
## 111 Kia Spectra GS 4dr hatch Sedan Asia Front
## 112 Kia Spectra GSX 4dr hatch Sedan Asia Front
## 113 Kia Optima LX V6 4dr Sedan Asia Front
## 114 Kia Amanti 4dr Sedan Asia Front
## 115 Kia Sedona LX Sedan Asia Front
## 116 Kia Rio Cinco Wagon Asia Front
## 117 Lexus ES 330 4dr Sedan Asia Front
## 118 Lincoln Aviator Ultimate SUV USA Front
## 119 MINI Cooper Sedan Europe Front
## 120 MINI Cooper S Sedan Europe Front
## 121 Mazda Mazda3 i 4dr Sedan Asia Front
## 122 Mazda Mazda3 s 4dr Sedan Asia Front
## 123 Mazda Mazda6 i 4dr Sedan Asia Front
## 124 Mazda MPV ES Sedan Asia Front
## 125 Mercury Mountaineer SUV USA Front
## 126 Mercury Sable GS 4dr Sedan USA Front
## 127 Mercury Sable LS Premium 4dr Sedan USA Front
## 128 Mercury Monterey Luxury Sedan USA Front
## 129 Mercury Sable GS Wagon USA Front
## 130 Mitsubishi Outlander LS SUV Asia Front
## 131 Mitsubishi Lancer ES 4dr Sedan Asia Front
## 132 Mitsubishi Lancer LS 4dr Sedan Asia Front
## 133 Mitsubishi Galant ES 2.4L 4dr Sedan Asia Front
## 134 Mitsubishi Lancer OZ Rally 4dr auto Sedan Asia Front
## 135 Mitsubishi Diamante LS 4dr Sedan Asia Front
## 136 Mitsubishi Galant GTS 4dr Sedan Asia Front
## 137 Mitsubishi Eclipse GTS 2dr Sports Asia Front
## 138 Mitsubishi Eclipse Spyder GT convertible 2dr Sports Asia Front
## 139 Mitsubishi Lancer Evolution 4dr Sports Asia Front
## 140 Mitsubishi Lancer Sportback LS Wagon Asia Front
## 141 Nissan Pathfinder Armada SE SUV Asia Front
## 142 Nissan Pathfinder SE SUV Asia Front
## 143 Nissan Xterra XE V6 SUV Asia Front
## 144 Nissan Sentra 1.8 4dr Sedan Asia Front
## 145 Nissan Sentra 1.8 S 4dr Sedan Asia Front
## 146 Nissan Altima S 4dr Sedan Asia Front
## 147 Nissan Sentra SE-R 4dr Sedan Asia Front
## 148 Nissan Altima SE 4dr Sedan Asia Front
## 149 Nissan Maxima SE 4dr Sedan Asia Front
## 150 Nissan Maxima SL 4dr Sedan Asia Front
## 151 Nissan Quest S Sedan Asia Front
## 152 Nissan Quest SE Sedan Asia Front
## 153 Oldsmobile Alero GX 2dr Sedan USA Front
## 154 Oldsmobile Alero GLS 2dr Sedan USA Front
## 155 Oldsmobile Silhouette GL Sedan USA Front
## 156 Pontiac Aztekt SUV USA Front
## 157 Pontiac Sunfire 1SA 2dr Sedan USA Front
## 158 Pontiac Grand Am GT 2dr Sedan USA Front
## 159 Pontiac Grand Prix GT1 4dr Sedan USA Front
## 160 Pontiac Sunfire 1SC 2dr Sedan USA Front
## 161 Pontiac Grand Prix GT2 4dr Sedan USA Front
## 162 Pontiac Bonneville GXP 4dr Sedan USA Front
## 163 Pontiac Montana Sedan USA Front
## 164 Saab 9-3 Arc Sport 4dr Sedan Europe Front
## 165 Saab 9-3 Aero 4dr Sedan Europe Front
## 166 Saab 9-5 Arc 4dr Sedan Europe Front
## 167 Saab 9-5 Aero 4dr Sedan Europe Front
## 168 Saab 9-3 Arc convertible 2dr Sedan Europe Front
## 169 Saab 9-3 Aero convertible 2dr Sedan Europe Front
## 170 Saab 9-5 Aero Wagon Europe Front
## 171 Saturn Ion1 4dr Sedan USA Front
## 172 Saturn lon2 4dr Sedan USA Front
## 173 Saturn lon3 4dr Sedan USA Front
## 174 Saturn lon2 quad coupe 2dr Sedan USA Front
## 175 Saturn lon3 quad coupe 2dr Sedan USA Front
## 176 Saturn L300-2 4dr Sedan USA Front
## 177 Saturn L300 2 Wagon USA Front
## 178 Scion xA 4dr hatch Sedan Asia Front
## 179 Scion xB Wagon Asia Front
## 180 Suzuki XL-7 EX SUV Asia Front
## 181 Suzuki Aeno S 4dr Sedan Asia Front
## 182 Suzuki Aerio LX 4dr Sedan Asia Front
## 183 Suzuki Forenza S 4dr Sedan Asia Front
## 184 Suzuki Forenza EX 4dr Sedan Asia Front
## 185 Suzuki Verona LX 4dr Sedan Asia Front
## 186 Toyota Prius 4dr (gas/electric) Hybrid Asia Front
## 187 Toyota 4Runner SR5 V6 SUV Asia Front
## 188 Toyota Corolla CE 4dr Sedan Asia Front
## 189 Toyota Corolla S 4dr Sedan Asia Front
## 190 Toyota Corolla LE 4dr Sedan Asia Front
## 191 Toyota Echo 2dr manual Sedan Asia Front
## 192 Toyota Echo 2dr auto Sedan Asia Front
## 193 Toyota Echo 4dr Sedan Asia Front
## 194 Toyota Camry LE 4dr Sedan Asia Front
## 195 Toyota Camry LE V6 4dr Sedan Asia Front
## 196 Toyota Camry Solara SE 2dr Sedan Asia Front
## 197 Toyota Camry Solara SE V6 2dr Sedan Asia Front
## 198 Toyota Avalon XL 4dr Sedan Asia Front
## 199 Toyota Camry XLE V6 4dr Sedan Asia Front
## 200 Toyota Camry Solara SLE V6 2dr Sedan Asia Front
## 201 Toyota Avalon XLS 4dr Sedan Asia Front
## 202 Toyota Sienna CE Sedan Asia Front
## 203 Toyota Sienna XLE Limited Sedan Asia Front
## 204 Toyota Celica GT-S 2dr Sports Asia Front
## 205 Toyota Matrix XR Wagon Asia Front
## 206 Volkswagen Golf GLS 4dr Sedan Europe Front
## 207 Volkswagen GTI 1.8T 2dr hatch Sedan Europe Front
## 208 Volkswagen Jetta GLS TDI 4dr Sedan Europe Front
## 209 Volkswagen New Beetle GLS 1.8T 2dr Sedan Europe Front
## 210 Volkswagen Jetta GLI VR6 4dr Sedan Europe Front
## 211 Volkswagen New Beetle GLS convertible 2dr Sedan Europe Front
## 212 Volkswagen Passat GLS 4dr Sedan Europe Front
## 213 Volkswagen Passat GLX V6 4MOTION 4dr Sedan Europe Front
## 214 Volkswagen Passat W8 4MOTION 4dr Sedan Europe Front
## 215 Volkswagen Phaeton 4dr Sedan Europe Front
## 216 Volkswagen Phaeton W12 4dr Sedan Europe Front
## 217 Volkswagen Jetta GL Wagon Europe Front
## 218 Volkswagen Passat GLS 1.8T Wagon Europe Front
## 219 Volkswagen Passat W8 Wagon Europe Front
## 220 Volvo S40 4dr Sedan Europe Front
## 221 Volvo S60 T5 4dr Sedan Europe Front
## 222 Volvo S80 2.9 4dr Sedan Europe Front
## 223 Volvo C70 LPT convertible 2dr Sedan Europe Front
## 224 Volvo C70 HPT convertible 2dr Sedan Europe Front
## 225 Volvo S80 T6 4dr Sedan Europe Front
## 226 Volvo V40 Wagon Europe Front
## MSRP Weight Wheelbase Length weight_kilo wheelbase_cm length_cm
## 1 23820 2778.000 101 172 1261.212 256.54 436.88
## 2 26990 3230.000 105 183 1466.420 266.70 464.82
## 3 33195 3585.101 108 186 1627.636 274.32 472.44
## 4 43755 3880.000 115 197 1761.520 292.10 500.38
## 5 46100 3893.000 115 197 1767.422 292.10 500.38
## 6 25940 3252.000 104 179 1476.408 264.16 454.66
## 7 35940 3638.000 105 180 1651.652 266.70 457.20
## 8 31840 3462.000 104 179 1571.748 264.16 454.66
## 9 36640 3561.000 109 192 1616.694 276.86 487.68
## 10 42490 3814.000 105 180 1731.556 266.70 457.20
## 11 84600 4024.000 109 191 1826.896 276.86 485.14
## 12 35940 3131.000 95 159 1421.474 241.30 403.86
## 13 26545 4024.000 112 187 1826.896 284.48 474.98
## 14 22180 3353.000 109 195 1522.262 276.86 495.30
## 15 26470 3567.000 112 200 1619.418 284.48 508.00
## 16 24895 3461.000 109 196 1571.294 276.86 497.84
## 17 28345 3536.000 109 196 1605.344 276.86 497.84
## 18 32245 3591.000 112 200 1630.314 284.48 508.00
## 19 35545 3778.000 114 207 1715.212 289.56 525.78
## 20 40720 3909.000 114 207 1774.686 289.56 525.78
## 21 52795 5367.000 116 199 2436.618 294.64 505.46
## 22 46995 4302.000 116 195 1953.108 294.64 495.30
## 23 45445 3984.000 115 207 1808.736 292.10 525.78
## 24 50595 4044.000 115 207 1835.976 292.10 525.78
## 25 47955 3992.000 112 201 1812.368 284.48 510.54
## 26 42735 4947.000 130 219 2245.938 330.20 556.26
## 27 30295 4425.000 113 192 2008.950 287.02 487.68
## 28 20255 2866.000 98 163 1301.164 248.92 414.02
## 29 11690 2370.000 98 167 1075.980 248.92 424.18
## 30 12585 2348.000 98 153 1065.992 248.92 388.62
## 31 14610 2617.000 104 183 1188.118 264.16 464.82
## 32 14810 2676.000 104 183 1214.904 264.16 464.82
## 33 16385 2617.000 104 183 1188.118 264.16 464.82
## 34 21900 3465.000 111 200 1573.110 281.94 508.00
## 35 18995 3174.000 106 188 1440.996 269.24 477.52
## 36 20370 3297.000 106 188 1496.838 269.24 477.52
## 37 21825 3340.000 111 198 1516.360 281.94 502.92
## 38 25000 3476.000 111 200 1578.104 281.94 508.00
## 39 27995 3606.000 111 200 1637.124 281.94 508.00
## 40 23495 3315.000 106 188 1505.010 269.24 477.52
## 41 24225 3434.000 111 198 1559.036 281.94 502.92
## 42 27020 3699.000 112 187 1679.346 284.48 474.98
## 43 22225 3458.000 112 188 1569.932 284.48 477.52
## 44 17985 3101.000 103 169 1407.854 261.62 429.26
## 45 22000 3105.000 103 169 1409.670 261.62 429.26
## 46 19090 3173.000 108 191 1440.542 274.32 485.14
## 47 21840 3222.000 108 191 1462.788 274.32 485.14
## 48 29865 3581.000 113 198 1625.774 287.02 502.92
## 49 24130 3479.000 113 208 1579.466 287.02 528.32
## 50 26860 3548.000 113 208 1610.792 287.02 528.32
## 51 25955 3217.000 103 169 1460.518 261.62 429.26
## 52 25215 3357.000 106 194 1524.078 269.24 492.76
## 53 33295 3650.000 113 198 1657.100 287.02 502.92
## 54 30950 3448.000 106 194 1565.392 269.24 492.76
## 55 27490 4068.000 119 201 1846.872 302.26 510.54
## 56 38380 4331.000 119 201 1966.274 302.26 510.54
## 57 13670 2581.000 105 174 1171.774 266.70 441.96
## 58 15040 2626.000 105 174 1192.204 266.70 441.96
## 59 22035 3469.000 113 204 1574.926 287.02 518.16
## 60 18820 3182.000 108 191 1444.628 274.32 485.14
## 61 20220 3175.000 108 191 1441.450 274.32 485.14
## 62 24885 3487.000 113 204 1583.098 287.02 518.16
## 63 21795 3862.000 113 189 1753.348 287.02 480.06
## 64 34560 5000.000 119 206 2270.000 302.26 523.24
## 65 13270 2612.000 103 168 1185.848 261.62 426.72
## 66 13730 2606.000 103 168 1183.124 261.62 426.72
## 67 15460 2606.000 103 168 1183.124 261.62 426.72
## 68 15580 2691.000 103 168 1221.714 261.62 426.72
## 69 19135 2750.000 103 168 1248.500 261.62 426.72
## 70 20320 3306.000 109 198 1500.924 276.86 502.92
## 71 22735 3313.000 109 198 1504.102 276.86 502.92
## 72 26930 4275.000 121 201 1940.850 307.34 510.54
## 73 37530 3780.000 107 186 1716.120 271.78 472.44
## 74 17475 3585.101 103 178 1627.636 261.62 452.12
## 75 22290 3497.000 109 198 1587.638 276.86 502.92
## 76 31890 4945.000 129 208 2245.030 327.66 528.32
## 77 35725 5042.000 116 199 2289.068 294.64 505.46
## 78 20140 2732.000 103 175 1240.328 261.62 444.50
## 79 19110 1850.000 95 155 839.900 241.30 393.70
## 80 13270 2432.000 103 175 1104.128 261.62 444.50
## 81 14170 2500.000 103 175 1135.000 261.62 444.50
## 82 15850 2513.000 103 175 1140.902 261.62 444.50
## 83 19860 2994.000 105 188 1359.276 266.70 477.52
## 84 22260 3047.000 105 188 1383.338 266.70 477.52
## 85 17750 2601.000 103 175 1180.854 261.62 444.50
## 86 19490 2782.000 101 166 1263.028 256.54 421.64
## 87 23760 3585.101 108 190 1627.636 274.32 482.60
## 88 26960 3294.000 105 188 1495.476 266.70 477.52
## 89 24950 4310.000 118 201 1956.740 299.72 510.54
## 90 27450 4365.000 118 201 1981.710 299.72 510.54
## 91 21589 3549.000 103 177 1611.246 261.62 449.58
## 92 10539 2255.000 96 167 1023.770 243.84 424.18
## 93 11839 2290.000 96 167 1039.660 243.84 424.18
## 94 11939 2339.000 96 167 1061.906 243.84 424.18
## 95 13839 2635.000 103 178 1196.290 261.62 452.12
## 96 15389 2635.000 103 178 1196.290 261.62 452.12
## 97 15389 2698.000 103 178 1224.892 261.62 452.12
## 98 19339 3217.000 106 187 1460.518 269.24 474.98
## 99 20339 3217.000 106 187 1460.518 269.24 474.98
## 100 24589 3651.000 108 192 1657.554 274.32 487.68
## 101 26189 3651.000 108 192 1657.554 274.32 487.68
## 102 18739 3023.000 100 173 1372.442 254.00 439.42
## 103 31145 3306.000 108 194 1500.924 274.32 492.76
## 104 20449 3836.000 106 178 1741.544 269.24 452.12
## 105 27905 3790.000 106 181 1720.660 269.24 459.74
## 106 19635 4112.000 107 180 1866.848 271.78 457.20
## 107 16040 3281.000 106 186 1489.574 269.24 472.44
## 108 10280 2403.000 95 167 1090.962 241.30 424.18
## 109 11155 2458.000 95 167 1115.932 241.30 424.18
## 110 12360 2661.000 101 178 1208.094 256.54 452.12
## 111 13580 2686.000 101 178 1219.444 256.54 452.12
## 112 14630 2697.000 101 178 1224.438 256.54 452.12
## 113 18435 3279.000 106 186 1488.666 269.24 472.44
## 114 26000 4021.000 110 196 1825.534 279.40 497.84
## 115 20615 4802.000 115 194 2180.108 292.10 492.76
## 116 11905 2447.000 95 167 1110.938 241.30 424.18
## 117 32350 3460.000 107 191 1570.840 271.78 485.14
## 118 42915 4834.000 114 193 2194.636 289.56 490.22
## 119 16999 2524.000 97 143 1145.896 246.38 363.22
## 120 19999 2678.000 97 144 1215.812 246.38 365.76
## 121 15500 2696.000 104 178 1223.984 264.16 452.12
## 122 17200 2762.000 104 179 1253.948 264.16 454.66
## 123 19270 3042.000 105 187 1381.068 266.70 474.98
## 124 28750 3812.000 112 188 1730.648 284.48 477.52
## 125 29995 4374.000 114 190 1985.796 289.56 482.60
## 126 21595 3308.000 109 200 1501.832 276.86 508.00
## 127 23895 3315.000 109 200 1505.010 276.86 508.00
## 128 33995 4340.000 121 202 1970.360 307.34 513.08
## 129 22595 3488.000 109 198 1583.552 276.86 502.92
## 130 18892 3240.000 103 179 1470.960 261.62 454.66
## 131 14622 2656.000 102 181 1205.824 259.08 459.74
## 132 16722 2795.000 102 181 1268.930 259.08 459.74
## 133 19312 3351.000 108 191 1521.354 274.32 485.14
## 134 17232 2744.000 102 181 1245.776 259.08 459.74
## 135 29282 3549.000 107 194 1611.246 271.78 492.76
## 136 25700 3649.000 108 191 1656.646 274.32 485.14
## 137 25092 3241.000 101 177 1471.414 256.54 449.58
## 138 26992 3296.000 101 177 1496.384 256.54 449.58
## 139 29562 3263.000 103 179 1481.402 261.62 454.66
## 140 17495 3020.000 102 181 1371.080 259.08 459.74
## 141 33840 5013.000 123 207 2275.902 312.42 525.78
## 142 27339 3871.000 106 183 1757.434 269.24 464.82
## 143 20939 3760.000 104 178 1707.040 264.16 452.12
## 144 12740 2513.000 100 178 1140.902 254.00 452.12
## 145 14740 2581.000 100 178 1171.774 254.00 452.12
## 146 19240 3039.000 110 192 1379.706 279.40 487.68
## 147 17640 2761.000 100 178 1253.494 254.00 452.12
## 148 23290 3197.000 110 192 1451.438 279.40 487.68
## 149 27490 3473.000 111 194 1576.742 281.94 492.76
## 150 29440 3476.000 111 194 1578.104 281.94 492.76
## 151 24780 4012.000 124 204 1821.448 314.96 518.16
## 152 32780 4175.000 124 204 1895.450 314.96 518.16
## 153 18825 2946.000 107 187 1337.484 271.78 474.98
## 154 23675 3085.000 107 187 1400.590 271.78 474.98
## 155 28790 3948.000 120 201 1792.392 304.80 510.54
## 156 21595 3779.000 108 182 1715.666 274.32 462.28
## 157 15495 2771.000 104 182 1258.034 264.16 462.28
## 158 22450 3118.000 107 186 1415.572 271.78 472.44
## 159 22395 3477.000 111 198 1578.558 281.94 502.92
## 160 17735 2771.000 104 182 1258.034 264.16 462.28
## 161 24295 3484.000 111 198 1581.736 281.94 502.92
## 162 35995 3790.000 112 203 1720.660 284.48 515.62
## 163 23845 3803.000 112 187 1726.562 284.48 474.98
## 164 30860 3175.000 105 183 1441.450 266.70 464.82
## 165 33360 3175.000 105 183 1441.450 266.70 464.82
## 166 35105 3470.000 106 190 1575.380 269.24 482.60
## 167 39465 3470.000 106 190 1575.380 269.24 482.60
## 168 40670 3480.000 105 182 1579.920 266.70 462.28
## 169 43175 3700.000 105 182 1679.800 266.70 462.28
## 170 40845 3620.000 106 190 1643.480 269.24 482.60
## 171 10995 2692.000 103 185 1222.168 261.62 469.90
## 172 14300 2692.000 103 185 1222.168 261.62 469.90
## 173 15825 2692.000 103 185 1222.168 261.62 469.90
## 174 14850 2751.000 103 185 1248.954 261.62 469.90
## 175 16350 2751.000 103 185 1248.954 261.62 469.90
## 176 21410 3585.101 107 190 1627.636 271.78 482.60
## 177 23560 3109.000 107 190 1411.486 271.78 482.60
## 178 12965 2340.000 93 154 1062.360 236.22 391.16
## 179 14165 2425.000 98 155 1100.950 248.92 393.70
## 180 23699 3682.000 110 187 1671.628 279.40 474.98
## 181 12884 2676.000 98 171 1214.904 248.92 434.34
## 182 14500 2676.000 98 171 1214.904 248.92 434.34
## 183 12269 2701.000 102 177 1226.254 259.08 449.58
## 184 15568 2756.000 102 177 1251.224 259.08 449.58
## 185 17262 3380.000 106 188 1534.520 269.24 477.52
## 186 20510 2890.000 106 175 1312.060 269.24 444.50
## 187 27710 4035.000 110 189 1831.890 279.40 480.06
## 188 14085 2502.000 102 178 1135.908 259.08 452.12
## 189 15030 2524.000 102 178 1145.896 259.08 452.12
## 190 15295 2524.000 102 178 1145.896 259.08 452.12
## 191 10760 2035.000 93 163 923.890 236.22 414.02
## 192 11560 2085.000 93 163 946.590 236.22 414.02
## 193 11290 2055.000 93 163 932.970 236.22 414.02
## 194 19560 3086.000 107 189 1401.044 271.78 480.06
## 195 22775 3296.000 107 189 1496.384 271.78 480.06
## 196 19635 3175.000 107 193 1441.450 271.78 490.22
## 197 21965 3417.000 107 193 1551.318 271.78 490.22
## 198 26560 3417.000 107 192 1551.318 271.78 487.68
## 199 25920 3362.000 107 189 1526.348 271.78 480.06
## 200 26510 3439.000 107 193 1561.306 271.78 490.22
## 201 30920 3439.000 107 192 1561.306 271.78 487.68
## 202 23495 4120.000 119 200 1870.480 302.26 508.00
## 203 28800 4165.000 119 200 1890.910 302.26 508.00
## 204 22570 2500.000 102 171 1135.000 259.08 434.34
## 205 16695 2679.000 102 171 1216.266 259.08 434.34
## 206 18715 2897.000 99 165 1315.238 251.46 419.10
## 207 19825 2934.000 99 168 1332.036 251.46 426.72
## 208 21055 3003.000 99 172 1363.362 251.46 436.88
## 209 21055 2820.000 99 161 1280.280 251.46 408.94
## 210 23785 3179.000 99 172 1443.266 251.46 436.88
## 211 23215 3082.000 99 161 1399.228 251.46 408.94
## 212 23955 3241.000 106 185 1471.414 269.24 469.90
## 213 33180 3721.000 106 185 1689.334 269.24 469.90
## 214 39235 3953.000 106 185 1794.662 269.24 469.90
## 215 65000 5194.000 118 204 2358.076 299.72 518.16
## 216 75000 5399.000 118 204 2451.146 299.72 518.16
## 217 19005 3034.000 99 174 1377.436 251.46 441.96
## 218 24955 3338.000 106 184 1515.452 269.24 467.36
## 219 40235 4067.000 106 184 1846.418 269.24 467.36
## 220 25135 2767.000 101 187 1256.218 256.54 474.98
## 221 34845 3766.000 107 180 1709.764 271.78 457.20
## 222 37730 3576.000 110 190 1623.504 279.40 482.60
## 223 40565 3450.000 105 186 1566.300 266.70 472.44
## 224 42565 3450.000 105 186 1566.300 266.70 472.44
## 225 45210 3653.000 110 190 1658.462 279.40 482.60
## 226 26135 2822.000 101 180 1281.188 256.54 457.20
## Opinion_MSRP
## 1 Unexpensive
## 2 Unexpensive
## 3 Normal
## 4 Normal
## 5 Normal
## 6 Unexpensive
## 7 Normal
## 8 Normal
## 9 Normal
## 10 Normal
## 11 Expensive
## 12 Normal
## 13 Unexpensive
## 14 Unexpensive
## 15 Unexpensive
## 16 Unexpensive
## 17 Unexpensive
## 18 Normal
## 19 Normal
## 20 Normal
## 21 Normal
## 22 Normal
## 23 Normal
## 24 Normal
## 25 Normal
## 26 Normal
## 27 Normal
## 28 Unexpensive
## 29 Unexpensive
## 30 Unexpensive
## 31 Unexpensive
## 32 Unexpensive
## 33 Unexpensive
## 34 Unexpensive
## 35 Unexpensive
## 36 Unexpensive
## 37 Unexpensive
## 38 Unexpensive
## 39 Unexpensive
## 40 Unexpensive
## 41 Unexpensive
## 42 Unexpensive
## 43 Unexpensive
## 44 Unexpensive
## 45 Unexpensive
## 46 Unexpensive
## 47 Unexpensive
## 48 Unexpensive
## 49 Unexpensive
## 50 Unexpensive
## 51 Unexpensive
## 52 Unexpensive
## 53 Normal
## 54 Normal
## 55 Unexpensive
## 56 Normal
## 57 Unexpensive
## 58 Unexpensive
## 59 Unexpensive
## 60 Unexpensive
## 61 Unexpensive
## 62 Unexpensive
## 63 Unexpensive
## 64 Normal
## 65 Unexpensive
## 66 Unexpensive
## 67 Unexpensive
## 68 Unexpensive
## 69 Unexpensive
## 70 Unexpensive
## 71 Unexpensive
## 72 Unexpensive
## 73 Normal
## 74 Unexpensive
## 75 Unexpensive
## 76 Normal
## 77 Normal
## 78 Unexpensive
## 79 Unexpensive
## 80 Unexpensive
## 81 Unexpensive
## 82 Unexpensive
## 83 Unexpensive
## 84 Unexpensive
## 85 Unexpensive
## 86 Unexpensive
## 87 Unexpensive
## 88 Unexpensive
## 89 Unexpensive
## 90 Unexpensive
## 91 Unexpensive
## 92 Unexpensive
## 93 Unexpensive
## 94 Unexpensive
## 95 Unexpensive
## 96 Unexpensive
## 97 Unexpensive
## 98 Unexpensive
## 99 Unexpensive
## 100 Unexpensive
## 101 Unexpensive
## 102 Unexpensive
## 103 Normal
## 104 Unexpensive
## 105 Unexpensive
## 106 Unexpensive
## 107 Unexpensive
## 108 Unexpensive
## 109 Unexpensive
## 110 Unexpensive
## 111 Unexpensive
## 112 Unexpensive
## 113 Unexpensive
## 114 Unexpensive
## 115 Unexpensive
## 116 Unexpensive
## 117 Normal
## 118 Normal
## 119 Unexpensive
## 120 Unexpensive
## 121 Unexpensive
## 122 Unexpensive
## 123 Unexpensive
## 124 Unexpensive
## 125 Unexpensive
## 126 Unexpensive
## 127 Unexpensive
## 128 Normal
## 129 Unexpensive
## 130 Unexpensive
## 131 Unexpensive
## 132 Unexpensive
## 133 Unexpensive
## 134 Unexpensive
## 135 Unexpensive
## 136 Unexpensive
## 137 Unexpensive
## 138 Unexpensive
## 139 Unexpensive
## 140 Unexpensive
## 141 Normal
## 142 Unexpensive
## 143 Unexpensive
## 144 Unexpensive
## 145 Unexpensive
## 146 Unexpensive
## 147 Unexpensive
## 148 Unexpensive
## 149 Unexpensive
## 150 Unexpensive
## 151 Unexpensive
## 152 Normal
## 153 Unexpensive
## 154 Unexpensive
## 155 Unexpensive
## 156 Unexpensive
## 157 Unexpensive
## 158 Unexpensive
## 159 Unexpensive
## 160 Unexpensive
## 161 Unexpensive
## 162 Normal
## 163 Unexpensive
## 164 Normal
## 165 Normal
## 166 Normal
## 167 Normal
## 168 Normal
## 169 Normal
## 170 Normal
## 171 Unexpensive
## 172 Unexpensive
## 173 Unexpensive
## 174 Unexpensive
## 175 Unexpensive
## 176 Unexpensive
## 177 Unexpensive
## 178 Unexpensive
## 179 Unexpensive
## 180 Unexpensive
## 181 Unexpensive
## 182 Unexpensive
## 183 Unexpensive
## 184 Unexpensive
## 185 Unexpensive
## 186 Unexpensive
## 187 Unexpensive
## 188 Unexpensive
## 189 Unexpensive
## 190 Unexpensive
## 191 Unexpensive
## 192 Unexpensive
## 193 Unexpensive
## 194 Unexpensive
## 195 Unexpensive
## 196 Unexpensive
## 197 Unexpensive
## 198 Unexpensive
## 199 Unexpensive
## 200 Unexpensive
## 201 Normal
## 202 Unexpensive
## 203 Unexpensive
## 204 Unexpensive
## 205 Unexpensive
## 206 Unexpensive
## 207 Unexpensive
## 208 Unexpensive
## 209 Unexpensive
## 210 Unexpensive
## 211 Unexpensive
## 212 Unexpensive
## 213 Normal
## 214 Normal
## 215 Expensive
## 216 Expensive
## 217 Unexpensive
## 218 Unexpensive
## 219 Normal
## 220 Unexpensive
## 221 Normal
## 222 Normal
## 223 Normal
## 224 Normal
## 225 Normal
## 226 Unexpensive