DATA607_Project2
John Ferrara
2024-10-05
Project 2
Your task is to:
(1) Choose any three of the “wide” datasets identified in the Week 6 Discussion items. (You may use your own dataset; please don’t use my Sample Post dataset, since that was used in your Week 6 assignment!) For each of the three chosen datasets: - Create a .CSV file (or optionally, a MySQL database!) that includes all of the information included in the dataset. You’re encouraged to use a “wide” structure similar to how the information appears in the discussion item, so that you can practice tidying and transformations as described below. - Read the information from your .CSV file into R, and use tidyr and dplyr as needed to tidy and transform your data. [Most of your grade will be based on this step!] - Perform the analysis requested in the discussion item. - Your code should be in an R Markdown file, posted to rpubs.com, and should include narrative descriptions of your data cleanup work, analysis, and conclusions. (2) Please include in your homework submission, for each of the three chosen datasets: - The URL to the .Rmd file in your GitHub repository, and - The URL for your rpubs.com web page
Working with Dataset Number 1: Car Comparisons
DATA SOURCE: https://brightspace.cuny.edu/d2l/le/437179/discussions/threads/492562/View
Discussion Post:
The dataset I am referencing can be found here: https://fueleconomy.gov/feg/download.shtml. This data set has data from a myriad of different makes and models, including gas powered and electric cars. This leads to many unfilled columns where the specs for an electric car would go in rows describing gas powered cars. A good way to tidy this data would be to separate these types of cars, so that we have multiple tables with all of their columns filled. (https://brightspace.cuny.edu/d2l/le/437179/discussions/threads/492562/View)
Working Notes
Unllike the post alludes to the data was in an excel file with three different tabs for different car types. Rather than parsing out three different car types (EV, Plug-in Hybrid EVs, and ICE Cars), I will take a limited number of rows from each of the initial tabs and place them in one coherent table to plot and analize. The three excel tabs, i Manually parsed out into three different CSV files for the sake of this exercise.
Reading in and Cleaning EV data
## Dealing with Reading in each of the raw files.
ev_cars_raw <- read.csv("https://raw.githubusercontent.com/jhnboyy/CUNYSPS_DATA607/refs/heads/main/Project2/dataset1/EV_Cars_24.csv",header=FALSE,sep=',')
## Cleaning and keeping limited info from each df.
## UNKLIST CITATION: https://www.spsanderson.com/steveondata/posts/2023-08-02/index.html#:~:text=The%20unlist()%20function%20in%20R%20does%20exactly%20what%20its,it%20into%20a%20single%20vector.
#AS VECTOR CITATION: https://www.rdocumentation.org/packages/pbdDMAT/versions/0.5-1/topics/as.vector
colnames <- as.vector(unlist(ev_cars_raw[3,]))
ev_cars_raw_lim<-ev_cars_raw[-c(1,2,3,4),]
## Cleaning the column names for the df
## Make Names Citation: https://www.rdocumentation.org/packages/base/versions/3.6.2/topics/make.names
## Trimming White space: https://www.rdocumentation.org/packages/base/versions/3.6.2/topics/trimws
colnames(ev_cars_raw_lim) <-make.names(trimws(colnames), unique=TRUE)
## Removing those that dont have values for model year, proxy for the rows i want.
ev_cars_raw_lim <- ev_cars_raw_lim %>%filter(Model.Yr!="")
## Keeping the columns I want for simple analysis, dropping others. Renaming the ones i want to keep.
## No real metadata key on website, so just making assumptions about contents
ev_cars_raw_lim <- ev_cars_raw_lim %>% select(Mfr.Name,
Division,
Fuel.Usage....Conventional.Fuel,
Fuel.Usage.Desc...Conventional.Fuel,
Fuel.Unit...Conventional.Fuel,
Fuel.Unit.Desc...Conventional.Fuel,
Annual.Fuel1.Cost...Conventional.Fuel,
EPA.Calculated.Annual.Fuel.Cost...Conventional.Fuel........Annual.fuel.cost.error..Please.revise.Verify.,
Fuel2.Usage...Alternative.Fuel,
Fuel2.Usage.Desc...Alternative.Fuel,
Fuel2.Unit...Alternative.Fuel,
Fuel2.Unit.Desc...Alternative.Fuel,
Fuel2.Annual.Fuel.Cost...Alternative.Fuel,
Fuel2.EPA.Calculated.Annual.Fuel.Cost...Alternative.Fuel,
City.Range..miles.,
Hwy.Range..miles.)
## Dropping those columns that have no values. (Checking that they do actually have no values)
print(unique(ev_cars_raw_lim$Fuel2.Usage...Alternative.Fuel))## [1] ""print(unique(ev_cars_raw_lim$Fuel2.Usage.Desc...Alternative.Fuel))## [1] ""print(unique(ev_cars_raw_lim$Fuel2.Unit...Alternative.Fuel))## [1] ""print(unique(ev_cars_raw_lim$Fuel2.Unit...Alternative.Fuel))## [1] ""print(unique(ev_cars_raw_lim$Fuel2.Unit.Desc...Alternative.Fuel))## [1] ""print(unique(ev_cars_raw_lim$Fuel2.Annual.Fuel.Cost...Alternative.Fuel))## [1] ""print(unique(ev_cars_raw_lim$Fuel2.EPA.Calculated.Annual.Fuel.Cost...Alternative.Fuel))## [1] ""#Further Limiting and renaming
ev_cars_semi_final <- ev_cars_raw_lim %>% select(Mfr.Name,
Division,
Fuel.Usage....Conventional.Fuel,
Fuel.Usage.Desc...Conventional.Fuel,
Fuel.Unit...Conventional.Fuel,
Fuel.Unit.Desc...Conventional.Fuel,
Annual.Fuel1.Cost...Conventional.Fuel,
EPA.Calculated.Annual.Fuel.Cost...Conventional.Fuel........Annual.fuel.cost.error..Please.revise.Verify.,
#Decided to not use these
# City.Range..miles.,
# Hwy.Range..miles.
) %>%
rename(
manufacturer = Mfr.Name,
division = Division,
fuel_type_abrv = Fuel.Usage....Conventional.Fuel,
fuel_type_desc = Fuel.Usage.Desc...Conventional.Fuel,
fuel_unit_abrv = Fuel.Unit...Conventional.Fuel,
fuel_unit_desc = Fuel.Unit.Desc...Conventional.Fuel,
fuel_annual_cost = Annual.Fuel1.Cost...Conventional.Fuel,
epa_calc_fuel_annual_cost = EPA.Calculated.Annual.Fuel.Cost...Conventional.Fuel........Annual.fuel.cost.error..Please.revise.Verify.,
## DECIDED TO NOT USE THSE
# miles_range_city = City.Range..miles.,
# miles_range_hwy = Hwy.Range..miles.
)
## Checking the product
ev_cars_semi_final$fuel_annual_cost<- as.integer(ev_cars_semi_final$fuel_annual_cost)
### Repalcing "Group of" text in those Manufacturer cells that have it
unique(ev_cars_semi_final$manufacturer)## [1] "Honda" "Volkswagen Group of" "BMW"
## [4] "Bugatti Rimac LLC" "General Motors" "FCA US LLC"
## [7] "Fisker Group Inc." "Ford Motor Company" "Hyundai"
## [10] "Jaguar Land Rover L" "Kia" "Toyota"
## [13] "Lucid USA, Inc" "Maserati" "Mercedes-Benz"
## [16] "Nissan" "Volvo" "Porsche"
## [19] "Rivian Automotive L" "Rolls-Royce" "Subaru"
## [22] "Tesla" "Vinfast"ev_cars_semi_final$manufacturer<- sub("\\sGroup\\sof$", "", ev_cars_semi_final$manufacturer)
#Adding source column
ev_cars_semi_final$source = "EV"Reading in and Cleaning PHEV data
phev_cars_raw <- read.csv("https://raw.githubusercontent.com/jhnboyy/CUNYSPS_DATA607/refs/heads/main/Project2/dataset1/PHEV_Cars_24.csv", header=FALSE,sep=',')
colnames <- as.vector(unlist(phev_cars_raw[4,]))
phev_cars_raw_lim<-phev_cars_raw[-c(1,2,3,4,5,6),]
colnames(phev_cars_raw_lim) <-make.names(trimws(colnames), unique=TRUE)
## Droppping the blanks, ignoring the color details in col name for this analysis.
phev_cars_raw_lim <- phev_cars_raw_lim %>%filter(Model.Yr...gold.fill.means.release.date.is.after.today.s.date.!="")
phev_cars_raw_lim <- phev_cars_raw_lim %>% select(Mfr.Name,
Division,
Fuel.Usage....Conventional.Fuel,
Fuel.Usage.Desc...Conventional.Fuel,
Fuel.Unit...Conventional.Fuel,
Fuel.Unit.Desc...Conventional.Fuel,
Annual.Fuel1.Cost...Conventional.Fuel,
EPA.Calculated.Annual.Fuel.Cost...Conventional.Fuel........Annual.fuel.cost.error..Please.revise.Verify.,
Fuel2.Usage...Alternative.Fuel,
Fuel2.Usage.Desc...Alternative.Fuel,
Fuel2.Unit...Alternative.Fuel,
Fuel2.Unit.Desc...Alternative.Fuel,
Fuel2.Annual.Fuel.Cost...Alternative.Fuel,
Fuel2.EPA.Calculated.Annual.Fuel.Cost...Alternative.Fuel)
## Blank checks for columns to drop (only the one column)
print(unique(phev_cars_raw_lim$Fuel2.EPA.Calculated.Annual.Fuel.Cost...Alternative.Fuel))## [1] ""phev_cars_semi_final <- phev_cars_raw_lim %>% select(Mfr.Name,
Division,
Fuel.Usage....Conventional.Fuel,
Fuel.Usage.Desc...Conventional.Fuel,
Fuel.Unit...Conventional.Fuel,
Fuel.Unit.Desc...Conventional.Fuel,
Annual.Fuel1.Cost...Conventional.Fuel,
EPA.Calculated.Annual.Fuel.Cost...Conventional.Fuel........Annual.fuel.cost.error..Please.revise.Verify.,
Fuel2.Usage...Alternative.Fuel,
Fuel2.Usage.Desc...Alternative.Fuel,
Fuel2.Unit...Alternative.Fuel,
Fuel2.Unit.Desc...Alternative.Fuel,
Fuel2.Annual.Fuel.Cost...Alternative.Fuel) %>%
rename (manufacturer = Mfr.Name,
division =Division,
fuel_type_abrv = Fuel.Usage....Conventional.Fuel,
fuel_type_desc = Fuel.Usage.Desc...Conventional.Fuel,
fuel_unit_abrv = Fuel.Unit...Conventional.Fuel,
fuel_unit_desc = Fuel.Unit.Desc...Conventional.Fuel,
fuel_annual_cost1 = Annual.Fuel1.Cost...Conventional.Fuel,
epa_calc_fuel_annual_cost = EPA.Calculated.Annual.Fuel.Cost...Conventional.Fuel........Annual.fuel.cost.error..Please.revise.Verify.,
fuel_type_abrv2 = Fuel2.Usage...Alternative.Fuel,
fuel_type_desc2 = Fuel2.Usage.Desc...Alternative.Fuel,
fuel_unit_abrv2 = Fuel2.Unit...Alternative.Fuel,
fuel_unit_desc2 = Fuel2.Unit.Desc...Alternative.Fuel,
fuel_annual_cost2 = Fuel2.Annual.Fuel.Cost...Alternative.Fuel)
## Cleaning the values here so that inline with single fuel source cars.
## Making the assumption that for hybrid cars the fuel cost annually would be the sum of the two different fuel options.
#Using Regex to replace empty strings with 0
phev_cars_semi_final$fuel_annual_cost1 <- sub("^$", "0", phev_cars_semi_final$fuel_annual_cost1)
phev_cars_semi_final$fuel_annual_cost2 <- sub("^$", "0", phev_cars_semi_final$fuel_annual_cost2)
#Converting to integers
phev_cars_semi_final$fuel_annual_cost1 <- as.integer(phev_cars_semi_final$fuel_annual_cost1)
phev_cars_semi_final$fuel_annual_cost2 <- as.integer(phev_cars_semi_final$fuel_annual_cost2)
phev_cars_semi_final$fuel_annual_cost <-phev_cars_semi_final$fuel_annual_cost1 + phev_cars_semi_final$fuel_annual_cost2
# Cehcking the work
phev_cars_semi_final %>% select(fuel_annual_cost1,fuel_annual_cost2,fuel_annual_cost)## fuel_annual_cost1 fuel_annual_cost2 fuel_annual_cost
## 1 2550 0 2550
## 2 2550 0 2550
## 3 1700 50 1750
## 4 1700 50 1750
## 5 1850 50 1900
## 6 1850 50 1900
## 7 2850 2550 5400
## 8 2850 2550 5400
## 9 1350 1350 2700
## 10 1350 1350 2700
## 11 1300 1300 2600
## 12 1300 1300 2600
## 13 1350 1350 2700
## 14 1350 1350 2700
## 15 3300 0 3300
## 16 3300 0 3300
## 17 3150 1400 4550
## 18 3150 1400 4550
## 19 1150 1150 2300
## 20 1150 1150 2300
## 21 1750 1750 3500
## 22 1750 1750 3500
## 23 2100 2100 4200
## 24 2100 2100 4200
## 25 1200 50 1250
## 26 1200 50 1250
## 27 1150 850 2000
## 28 1150 850 2000
## 29 1200 1200 2400
## 30 1200 1200 2400
## 31 1500 50 1550
## 32 1500 50 1550
## 33 800 0 800
## 34 800 0 800
## 35 700 550 1250
## 36 700 550 1250
## 37 1000 0 1000
## 38 1000 0 1000
## 39 1350 1200 2550
## 40 1350 1200 2550
## 41 1550 1400 2950
## 42 1550 1400 2950
## 43 1700 1500 3200
## 44 1700 1500 3200## Issues with the manufacturer values here because of original formatting
phev_cars_semi_final## manufacturer
## 1 Volkswagen Group of
## 2 Blended PHEV; tested in default "Drive-mode” and the normal default "Hybrid" mode (not the Hold or EV modes)
## 3 BMW
## 4 BMW
## 5 BMW
## 6 BMW
## 7 BMW
## 8 BMW
## 9 FCA US LLC
## 10 FCA US LLC
## 11 FCA US LLC
## 12 FCA US LLC
## 13 FCA US LLC
## 14 FCA US LLC
## 15 Ferrari
## 16 Ferrari
## 17 Ferrari
## 18 Ferrari
## 19 Hyundai
## 20 (Blended PHEV; tested in the Eco (default) mode---not the sport mode)
## 21 FCA US LLC
## 22 FCA US LLC
## 23 FCA US LLC
## 24 FCA US LLC
## 25 Kia
## 26 Kia
## 27 Kia
## 28 Kia
## 29 Toyota
## 30 (Blended PHEV; tested in the Sport and Eco modes (CS) and Normal (default) mode (CD)--only Normal, Sport & Eco modes are available);
## 31 Mitsubishi Motors Co
## 32 Mitsubishi Motors Co
## 33 Toyota
## 34 Toyota
## 35 Toyota
## 36 Toyota
## 37 Toyota
## 38 Toyota
## 39 Volvo
## 40 Volvo
## 41 Volvo
## 42 Volvo
## 43 Volvo
## 44 Volvo
## division fuel_type_abrv
## 1 Bentley GP
## 2 GP
## 3 BMW GP
## 4 BMW GP
## 5 BMW GP
## 6 BMW GP
## 7 BMW GPR
## 8 BMW GPR
## 9 ALFA ROMEO G
## 10 ALFA ROMEO G
## 11 Chrysler G
## 12 Chrysler G
## 13 Dodge G
## 14 Dodge G
## 15 Ferrari North America, Inc. GPR
## 16 Ferrari North America, Inc. GPR
## 17 Ferrari North America, Inc. GPR
## 18 Ferrari North America, Inc. GPR
## 19 HYUNDAI MOTOR COMPANY G
## 20 G
## 21 Jeep G
## 22 Jeep G
## 23 Jeep G
## 24 Jeep G
## 25 KIA G
## 26 KIA G
## 27 KIA G
## 28 KIA G
## 29 LEXUS GP
## 30 GP
## 31 Mitsubishi Motors Corporation G
## 32 Mitsubishi Motors Corporation G
## 33 TOYOTA G
## 34 TOYOTA G
## 35 TOYOTA G
## 36 TOYOTA G
## 37 TOYOTA G
## 38 TOYOTA G
## 39 Volvo Cars of North America, LLC GPR
## 40 Volvo Cars of North America, LLC GPR
## 41 Volvo Cars of North America, LLC GPR
## 42 Volvo Cars of North America, LLC GPR
## 43 Volvo Cars of North America, LLC GPR
## 44 Volvo Cars of North America, LLC GPR
## fuel_type_desc fuel_unit_abrv fuel_unit_desc
## 1 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 2 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 3 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 4 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 5 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 6 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 7 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 8 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 9 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 10 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 11 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 12 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 13 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 14 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 15 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 16 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 17 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 18 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 19 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 20 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 21 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 22 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 23 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 24 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 25 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 26 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 27 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 28 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 29 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 30 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 31 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 32 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 33 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 34 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 35 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 36 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 37 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 38 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 39 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 40 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 41 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 42 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 43 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 44 Gasoline (Premium Unleaded Required) MPG miles per gallon
## fuel_annual_cost1 epa_calc_fuel_annual_cost fuel_type_abrv2 fuel_type_desc2
## 1 2550 2550 EL Electricity
## 2 2550 2550 EL Electricity
## 3 1700 1700 EL Electricity
## 4 1700 1700 EL Electricity
## 5 1850 1850 EL Electricity
## 6 1850 1850 EL Electricity
## 7 2850 2850 TC Electricity
## 8 2850 2850 EL Electricity
## 9 1350 1350 EL Electricity
## 10 1350 1350 EL Electricity
## 11 1300 1300 EL Electricity
## 12 1300 1300 EL Electricity
## 13 1350 1350 EL Electricity
## 14 1350 1350 EL Electricity
## 15 3300 3300 EL Electricity
## 16 3300 3300 EL Electricity
## 17 3150 3150 EL Electricity
## 18 3150 3150 EL Electricity
## 19 1150 1150 EL Electricity
## 20 1150 1150 EL Electricity
## 21 1750 1750 EL Electricity
## 22 1750 1750 EL Electricity
## 23 2100 2100 EL Electricity
## 24 2100 2100 EL Electricity
## 25 1200 1200 EL Electricity
## 26 1200 1200 EL Electricity
## 27 1150 1150 EL Electricity
## 28 1150 1150 EL Electricity
## 29 1200 1200 EL Electricity
## 30 1200 1200 EL Electricity
## 31 1500 1500 EL Electricity
## 32 1500 1500 EL Electricity
## 33 800 800 EL Electricity
## 34 800 800 EL Electricity
## 35 700 700 EL Electricity
## 36 700 700 EL Electricity
## 37 1000 1000 EL Electricity
## 38 1000 1000 EL Electricity
## 39 1350 1350
## 40 1350 1350 EL Electricity
## 41 1550 1550
## 42 1550 1550 EL Electricity
## 43 1700 1700
## 44 1700 1700 EL Electricity
## fuel_unit_abrv2 fuel_unit_desc2 fuel_annual_cost2
## 1 KW-HR/100Miles kilowatt-hour per 100 miles 0
## 2 MPG miles per gallon 0
## 3 KW-HR/100Miles kilowatt-hour per 100 miles 50
## 4 MPG miles per gallon 50
## 5 KW-HR/100Miles kilowatt-hour per 100 miles 50
## 6 MPG miles per gallon 50
## 7 KW-HR/100Miles kilowatt-hour per 100 miles 2550
## 8 MPG miles per gallon 2550
## 9 KW-HR/100Miles kilowatt-hour per 100 miles 1350
## 10 MPG miles per gallon 1350
## 11 KW-HR/100Miles kilowatt-hour per 100 miles 1300
## 12 MPG miles per gallon 1300
## 13 KW-HR/100Miles kilowatt-hour per 100 miles 1350
## 14 MPG miles per gallon 1350
## 15 KW-HR/100Miles kilowatt-hour per 100 miles 0
## 16 MPG miles per gallon 0
## 17 KW-HR/100Miles kilowatt-hour per 100 miles 1400
## 18 MPG miles per gallon 1400
## 19 KW-HR/100Miles kilowatt-hour per 100 miles 1150
## 20 MPG miles per gallon 1150
## 21 KW-HR/100Miles kilowatt-hour per 100 miles 1750
## 22 MPG miles per gallon 1750
## 23 KW-HR/100Miles kilowatt-hour per 100 miles 2100
## 24 MPG miles per gallon 2100
## 25 KW-HR/100Miles kilowatt-hour per 100 miles 50
## 26 MPG miles per gallon 50
## 27 KW-HR/100Miles kilowatt-hour per 100 miles 850
## 28 MPG miles per gallon 850
## 29 KW-HR/100Miles kilowatt-hour per 100 miles 1200
## 30 MPG miles per gallon 1200
## 31 KW-HR/100Miles kilowatt-hour per 100 miles 50
## 32 MPG miles per gallon 50
## 33 KW-HR/100Miles kilowatt-hour per 100 miles 0
## 34 MPG miles per gallon 0
## 35 KW-HR/100Miles kilowatt-hour per 100 miles 550
## 36 MPG miles per gallon 550
## 37 KW-HR/100Miles kilowatt-hour per 100 miles 0
## 38 MPG miles per gallon 0
## 39 1200
## 40 MPG miles per gallon 1200
## 41 1400
## 42 MPG miles per gallon 1400
## 43 1500
## 44 MPG miles per gallon 1500
## fuel_annual_cost
## 1 2550
## 2 2550
## 3 1750
## 4 1750
## 5 1900
## 6 1900
## 7 5400
## 8 5400
## 9 2700
## 10 2700
## 11 2600
## 12 2600
## 13 2700
## 14 2700
## 15 3300
## 16 3300
## 17 4550
## 18 4550
## 19 2300
## 20 2300
## 21 3500
## 22 3500
## 23 4200
## 24 4200
## 25 1250
## 26 1250
## 27 2000
## 28 2000
## 29 2400
## 30 2400
## 31 1550
## 32 1550
## 33 800
## 34 800
## 35 1250
## 36 1250
## 37 1000
## 38 1000
## 39 2550
## 40 2550
## 41 2950
## 42 2950
## 43 3200
## 44 3200### Using window function and regex to deal with unwanted values in the Manufacturer column. B/c of how it was grouped in original
### data the manufacuter wasnt mentioned in the instances where there was a description containing a parenthesis. Filled in those values with the previous value in the manufacturer column. For this code i used a combination of various website soruces and ai to help correct where i was getting an error for nuanced r syntax
phev_cars_semi_final <- phev_cars_semi_final %>%
mutate(manufacturer = ifelse(grepl("(\\()", manufacturer), lag(manufacturer), manufacturer))
### Repalcing "Group of" text in those Manufacturer cells that have it
phev_cars_semi_final$manufacturer<- sub("\\sGroup\\sof$", "", phev_cars_semi_final$manufacturer)
phev_cars_semi_final## manufacturer division fuel_type_abrv
## 1 Volkswagen Bentley GP
## 2 Volkswagen GP
## 3 BMW BMW GP
## 4 BMW BMW GP
## 5 BMW BMW GP
## 6 BMW BMW GP
## 7 BMW BMW GPR
## 8 BMW BMW GPR
## 9 FCA US LLC ALFA ROMEO G
## 10 FCA US LLC ALFA ROMEO G
## 11 FCA US LLC Chrysler G
## 12 FCA US LLC Chrysler G
## 13 FCA US LLC Dodge G
## 14 FCA US LLC Dodge G
## 15 Ferrari Ferrari North America, Inc. GPR
## 16 Ferrari Ferrari North America, Inc. GPR
## 17 Ferrari Ferrari North America, Inc. GPR
## 18 Ferrari Ferrari North America, Inc. GPR
## 19 Hyundai HYUNDAI MOTOR COMPANY G
## 20 Hyundai G
## 21 FCA US LLC Jeep G
## 22 FCA US LLC Jeep G
## 23 FCA US LLC Jeep G
## 24 FCA US LLC Jeep G
## 25 Kia KIA G
## 26 Kia KIA G
## 27 Kia KIA G
## 28 Kia KIA G
## 29 Toyota LEXUS GP
## 30 Toyota GP
## 31 Mitsubishi Motors Co Mitsubishi Motors Corporation G
## 32 Mitsubishi Motors Co Mitsubishi Motors Corporation G
## 33 Toyota TOYOTA G
## 34 Toyota TOYOTA G
## 35 Toyota TOYOTA G
## 36 Toyota TOYOTA G
## 37 Toyota TOYOTA G
## 38 Toyota TOYOTA G
## 39 Volvo Volvo Cars of North America, LLC GPR
## 40 Volvo Volvo Cars of North America, LLC GPR
## 41 Volvo Volvo Cars of North America, LLC GPR
## 42 Volvo Volvo Cars of North America, LLC GPR
## 43 Volvo Volvo Cars of North America, LLC GPR
## 44 Volvo Volvo Cars of North America, LLC GPR
## fuel_type_desc fuel_unit_abrv fuel_unit_desc
## 1 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 2 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 3 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 4 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 5 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 6 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 7 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 8 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 9 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 10 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 11 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 12 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 13 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 14 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 15 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 16 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 17 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 18 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 19 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 20 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 21 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 22 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 23 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 24 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 25 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 26 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 27 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 28 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 29 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 30 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 31 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 32 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 33 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 34 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 35 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 36 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 37 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 38 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 39 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 40 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 41 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 42 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 43 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 44 Gasoline (Premium Unleaded Required) MPG miles per gallon
## fuel_annual_cost1 epa_calc_fuel_annual_cost fuel_type_abrv2 fuel_type_desc2
## 1 2550 2550 EL Electricity
## 2 2550 2550 EL Electricity
## 3 1700 1700 EL Electricity
## 4 1700 1700 EL Electricity
## 5 1850 1850 EL Electricity
## 6 1850 1850 EL Electricity
## 7 2850 2850 TC Electricity
## 8 2850 2850 EL Electricity
## 9 1350 1350 EL Electricity
## 10 1350 1350 EL Electricity
## 11 1300 1300 EL Electricity
## 12 1300 1300 EL Electricity
## 13 1350 1350 EL Electricity
## 14 1350 1350 EL Electricity
## 15 3300 3300 EL Electricity
## 16 3300 3300 EL Electricity
## 17 3150 3150 EL Electricity
## 18 3150 3150 EL Electricity
## 19 1150 1150 EL Electricity
## 20 1150 1150 EL Electricity
## 21 1750 1750 EL Electricity
## 22 1750 1750 EL Electricity
## 23 2100 2100 EL Electricity
## 24 2100 2100 EL Electricity
## 25 1200 1200 EL Electricity
## 26 1200 1200 EL Electricity
## 27 1150 1150 EL Electricity
## 28 1150 1150 EL Electricity
## 29 1200 1200 EL Electricity
## 30 1200 1200 EL Electricity
## 31 1500 1500 EL Electricity
## 32 1500 1500 EL Electricity
## 33 800 800 EL Electricity
## 34 800 800 EL Electricity
## 35 700 700 EL Electricity
## 36 700 700 EL Electricity
## 37 1000 1000 EL Electricity
## 38 1000 1000 EL Electricity
## 39 1350 1350
## 40 1350 1350 EL Electricity
## 41 1550 1550
## 42 1550 1550 EL Electricity
## 43 1700 1700
## 44 1700 1700 EL Electricity
## fuel_unit_abrv2 fuel_unit_desc2 fuel_annual_cost2
## 1 KW-HR/100Miles kilowatt-hour per 100 miles 0
## 2 MPG miles per gallon 0
## 3 KW-HR/100Miles kilowatt-hour per 100 miles 50
## 4 MPG miles per gallon 50
## 5 KW-HR/100Miles kilowatt-hour per 100 miles 50
## 6 MPG miles per gallon 50
## 7 KW-HR/100Miles kilowatt-hour per 100 miles 2550
## 8 MPG miles per gallon 2550
## 9 KW-HR/100Miles kilowatt-hour per 100 miles 1350
## 10 MPG miles per gallon 1350
## 11 KW-HR/100Miles kilowatt-hour per 100 miles 1300
## 12 MPG miles per gallon 1300
## 13 KW-HR/100Miles kilowatt-hour per 100 miles 1350
## 14 MPG miles per gallon 1350
## 15 KW-HR/100Miles kilowatt-hour per 100 miles 0
## 16 MPG miles per gallon 0
## 17 KW-HR/100Miles kilowatt-hour per 100 miles 1400
## 18 MPG miles per gallon 1400
## 19 KW-HR/100Miles kilowatt-hour per 100 miles 1150
## 20 MPG miles per gallon 1150
## 21 KW-HR/100Miles kilowatt-hour per 100 miles 1750
## 22 MPG miles per gallon 1750
## 23 KW-HR/100Miles kilowatt-hour per 100 miles 2100
## 24 MPG miles per gallon 2100
## 25 KW-HR/100Miles kilowatt-hour per 100 miles 50
## 26 MPG miles per gallon 50
## 27 KW-HR/100Miles kilowatt-hour per 100 miles 850
## 28 MPG miles per gallon 850
## 29 KW-HR/100Miles kilowatt-hour per 100 miles 1200
## 30 MPG miles per gallon 1200
## 31 KW-HR/100Miles kilowatt-hour per 100 miles 50
## 32 MPG miles per gallon 50
## 33 KW-HR/100Miles kilowatt-hour per 100 miles 0
## 34 MPG miles per gallon 0
## 35 KW-HR/100Miles kilowatt-hour per 100 miles 550
## 36 MPG miles per gallon 550
## 37 KW-HR/100Miles kilowatt-hour per 100 miles 0
## 38 MPG miles per gallon 0
## 39 1200
## 40 MPG miles per gallon 1200
## 41 1400
## 42 MPG miles per gallon 1400
## 43 1500
## 44 MPG miles per gallon 1500
## fuel_annual_cost
## 1 2550
## 2 2550
## 3 1750
## 4 1750
## 5 1900
## 6 1900
## 7 5400
## 8 5400
## 9 2700
## 10 2700
## 11 2600
## 12 2600
## 13 2700
## 14 2700
## 15 3300
## 16 3300
## 17 4550
## 18 4550
## 19 2300
## 20 2300
## 21 3500
## 22 3500
## 23 4200
## 24 4200
## 25 1250
## 26 1250
## 27 2000
## 28 2000
## 29 2400
## 30 2400
## 31 1550
## 32 1550
## 33 800
## 34 800
## 35 1250
## 36 1250
## 37 1000
## 38 1000
## 39 2550
## 40 2550
## 41 2950
## 42 2950
## 43 3200
## 44 3200#Adding source column
phev_cars_semi_final$source = "PHEV"ice_cars_raw <-read.csv("https://raw.githubusercontent.com/jhnboyy/CUNYSPS_DATA607/refs/heads/main/Project2/dataset1/ICE_Cars_24.csv", header=FALSE,sep=',')
colnames <- as.vector(unlist(ice_cars_raw[1,]))
ice_cars_raw_lim<-ice_cars_raw[-c(1),]
colnames(ice_cars_raw_lim) <-make.names(trimws(colnames), unique=TRUE)
## Keeping the columns i want
ice_cars_raw_lim <- ice_cars_raw_lim %>% select(Mfr.Name,
Division,
Fuel.Usage....Conventional.Fuel,
Fuel.Usage.Desc...Conventional.Fuel,
Fuel.Unit...Conventional.Fuel,
Fuel.Unit.Desc...Conventional.Fuel,
Annual.Fuel1.Cost...Conventional.Fuel,
EPA.Calculated.Annual.Fuel.Cost...Conventional.Fuel........Annual.fuel.cost.error..Please.revise.Verify.,
Fuel2.Usage...Alternative.Fuel,
Fuel2.Usage.Desc...Alternative.Fuel,
Fuel2.Unit...Alternative.Fuel,
Fuel2.Unit.Desc...Alternative.Fuel,
Fuel2.Annual.Fuel.Cost...Alternative.Fuel,
Fuel2.EPA.Calculated.Annual.Fuel.Cost...Alternative.Fuel)
## Checking to see if empty vefore dropping
print(unique(ice_cars_raw_lim$Fuel2.Usage...Alternative.Fuel))## [1] "" "E"print(unique(ice_cars_raw_lim$Fuel2.Usage.Desc...Alternative.Fuel))## [1] "" "Ethanol (E85)"print(unique(ice_cars_raw_lim$Fuel2.Unit...Alternative.Fuel))## [1] "" "MPG"print(unique(ice_cars_raw_lim$Fuel2.Unit...Alternative.Fuel))## [1] "" "MPG"print(unique(ice_cars_raw_lim$Fuel2.Unit.Desc...Alternative.Fuel))## [1] "" "miles per gallon"print(unique(ice_cars_raw_lim$Fuel2.Annual.Fuel.Cost...Alternative.Fuel))## [1] "" "3650" "3950" "3150"print(unique(ice_cars_raw_lim$Fuel2.EPA.Calculated.Annual.Fuel.Cost...Alternative.Fuel))## [1] "" "3650" "3950" "3150"## All are not empty, so need to keep them, moving on to renamign the columns
ice_cars_semi_final <- ice_cars_raw_lim %>% rename(manufacturer = Mfr.Name,
division =Division,
fuel_type_abrv = Fuel.Usage....Conventional.Fuel,
fuel_type_desc = Fuel.Usage.Desc...Conventional.Fuel,
fuel_unit_abrv = Fuel.Unit...Conventional.Fuel,
fuel_unit_desc = Fuel.Unit.Desc...Conventional.Fuel,
fuel_annual_cost1 = Annual.Fuel1.Cost...Conventional.Fuel,
epa_calc_fuel_annual_cost = EPA.Calculated.Annual.Fuel.Cost...Conventional.Fuel........Annual.fuel.cost.error..Please.revise.Verify.,
fuel_type_abrv2 = Fuel2.Usage...Alternative.Fuel,
fuel_type_desc2 = Fuel2.Usage.Desc...Alternative.Fuel,
fuel_unit_abrv2 = Fuel2.Unit...Alternative.Fuel,
fuel_unit_desc2 = Fuel2.Unit.Desc...Alternative.Fuel,
fuel_annual_cost2 = Fuel2.Annual.Fuel.Cost...Alternative.Fuel,
epa_calc_fuel_annual_cost2 = Fuel2.EPA.Calculated.Annual.Fuel.Cost...Alternative.Fuel)
### Dealing with additional values for annual costs as i did with the PHEV data
#Using Regex to replace empty strings with 0
ice_cars_semi_final$fuel_annual_cost1 <- sub("^$", "0", ice_cars_semi_final$fuel_annual_cost1)
ice_cars_semi_final$fuel_annual_cost2 <- sub("^$", "0", ice_cars_semi_final$fuel_annual_cost2)
#Converting to integers
ice_cars_semi_final$fuel_annual_cost1 <- as.integer(ice_cars_semi_final$fuel_annual_cost1)
ice_cars_semi_final$fuel_annual_cost2 <- as.integer(ice_cars_semi_final$fuel_annual_cost2)
ice_cars_semi_final$fuel_annual_cost <-ice_cars_semi_final$fuel_annual_cost1 + ice_cars_semi_final$fuel_annual_cost2
# Cehcking the work
ice_cars_semi_final %>% select(fuel_annual_cost1,fuel_annual_cost2,fuel_annual_cost)## fuel_annual_cost1 fuel_annual_cost2 fuel_annual_cost
## 2 4600 0 4600
## 3 2500 0 2500
## 4 2300 0 2300
## 5 7150 0 7150
## 6 3400 0 3400
## 7 3400 0 3400
## 8 4300 0 4300
## 9 4600 0 4600
## 10 4600 0 4600
## 11 4600 0 4600
## 12 4950 0 4950
## 13 3600 0 3600
## 14 3600 0 3600
## 15 3400 0 3400
## 16 3400 0 3400
## 17 3600 0 3600
## 18 3600 0 3600
## 19 4300 0 4300
## 20 4300 0 4300
## 21 4300 0 4300
## 22 2550 0 2550
## 23 2850 0 2850
## 24 3600 0 3600
## 25 3600 0 3600
## 26 2200 0 2200
## 27 2200 0 2200
## 28 4050 0 4050
## 29 4050 0 4050
## 30 2950 0 2950
## 31 2950 0 2950
## 32 3200 0 3200
## 33 3400 0 3400
## 34 2700 0 2700
## 35 2950 0 2950
## 36 3050 0 3050
## 37 3400 0 3400
## 38 2950 0 2950
## 39 3050 0 3050
## 40 2700 0 2700
## 41 2950 0 2950
## 42 3050 0 3050
## 43 3400 0 3400
## 44 2950 0 2950
## 45 3050 0 3050
## 46 4050 0 4050
## 47 4050 0 4050
## 48 4050 0 4050
## 49 4300 0 4300
## 50 4050 0 4050
## 51 4050 0 4050
## 52 4300 0 4300
## 53 4300 0 4300
## 54 2400 0 2400
## 55 2500 0 2500
## 56 3050 0 3050
## 57 3800 0 3800
## 58 4050 0 4050
## 59 4600 0 4600
## 60 3400 0 3400
## 61 3600 0 3600
## 62 4050 0 4050
## 63 4050 0 4050
## 64 2000 0 2000
## 65 2100 0 2100
## 66 2150 0 2150
## 67 2400 0 2400
## 68 2300 0 2300
## 69 3200 0 3200
## 70 3200 0 3200
## 71 3200 0 3200
## 72 3400 0 3400
## 73 3400 0 3400
## 74 3400 0 3400
## 75 3400 0 3400
## 76 3200 0 3200
## 77 3200 0 3200
## 78 3200 0 3200
## 79 3200 0 3200
## 80 3200 0 3200
## 81 3400 0 3400
## 82 3200 0 3200
## 83 3400 0 3400
## 84 3200 0 3200
## 85 3200 0 3200
## 86 3050 0 3050
## 87 3200 0 3200
## 88 3200 0 3200
## 89 3200 0 3200
## 90 3200 0 3200
## 91 3400 0 3400
## 92 3200 0 3200
## 93 3400 0 3400
## 94 3400 0 3400
## 95 3200 0 3200
## 96 3200 0 3200
## 97 3800 0 3800
## 98 4050 0 4050
## 99 4050 0 4050
## 100 4050 0 4050
## 101 2600 0 2600
## 102 2950 0 2950
## 103 2700 0 2700
## 104 2950 0 2950
## 105 1700 0 1700
## 106 1800 0 1800
## 107 2400 0 2400
## 108 2400 0 2400
## 109 2800 0 2800
## 110 3050 0 3050
## 111 2500 0 2500
## 112 2950 0 2950
## 113 2700 0 2700
## 114 3800 0 3800
## 115 4300 0 4300
## 116 2150 0 2150
## 117 2300 0 2300
## 118 2300 0 2300
## 119 2300 0 2300
## 120 2400 0 2400
## 121 2400 0 2400
## 122 2700 0 2700
## 123 2700 0 2700
## 124 2700 0 2700
## 125 2700 0 2700
## 126 3400 0 3400
## 127 3400 0 3400
## 128 2500 0 2500
## 129 2500 0 2500
## 130 3400 0 3400
## 131 3600 0 3600
## 132 3400 0 3400
## 133 2500 0 2500
## 134 2400 0 2400
## 135 2600 0 2600
## 136 2600 0 2600
## 137 3600 0 3600
## 138 3800 0 3800
## 139 3800 0 3800
## 140 3400 0 3400
## 141 3400 0 3400
## 142 2450 0 2450
## 143 2700 0 2700
## 144 4050 0 4050
## 145 3200 0 3200
## 146 3400 0 3400
## 147 4050 0 4050
## 148 3400 0 3400
## 149 2100 0 2100
## 150 2850 0 2850
## 151 3000 0 3000
## 152 3000 0 3000
## 153 3200 0 3200
## 154 3200 0 3200
## 155 3200 0 3200
## 156 2250 0 2250
## 157 3600 0 3600
## 158 2200 0 2200
## 159 2600 0 2600
## 160 2950 0 2950
## 161 2800 0 2800
## 162 2950 0 2950
## 163 3400 0 3400
## 164 3200 0 3200
## 165 3050 0 3050
## 166 3050 0 3050
## 167 2800 0 2800
## 168 2500 0 2500
## 169 2300 0 2300
## 170 2500 0 2500
## 171 2500 0 2500
## 172 2000 0 2000
## 173 2100 0 2100
## 174 2000 0 2000
## 175 2100 0 2100
## 176 2100 0 2100
## 177 2400 0 2400
## 178 2100 0 2100
## 179 2400 0 2400
## 180 2200 0 2200
## 181 2500 0 2500
## 182 3600 0 3600
## 183 2700 0 2700
## 184 2700 0 2700
## 185 2600 0 2600
## 186 3050 0 3050
## 187 2150 0 2150
## 188 2400 0 2400
## 189 2700 0 2700
## 190 2300 0 2300
## 191 2400 0 2400
## 192 2200 0 2200
## 193 2400 0 2400
## 194 2300 0 2300
## 195 2400 0 2400
## 196 2400 0 2400
## 197 3600 0 3600
## 198 3400 0 3400
## 199 3600 0 3600
## 200 3400 0 3400
## 201 2500 0 2500
## 202 2500 0 2500
## 203 2400 0 2400
## 204 2600 0 2600
## 205 2500 0 2500
## 206 2600 0 2600
## 207 2600 0 2600
## 208 2700 0 2700
## 209 2800 0 2800
## 210 3400 0 3400
## 211 3600 0 3600
## 212 2800 0 2800
## 213 2800 0 2800
## 214 2700 0 2700
## 215 2600 0 2600
## 216 2950 0 2950
## 217 2800 0 2800
## 218 2950 0 2950
## 219 3200 0 3200
## 220 1300 0 1300
## 221 1300 0 1300
## 222 1400 0 1400
## 223 1400 0 1400
## 224 1750 0 1750
## 225 2000 0 2000
## 226 1800 0 1800
## 227 2800 0 2800
## 228 2600 0 2600
## 229 2800 0 2800
## 230 3050 0 3050
## 231 3050 0 3050
## 232 3800 0 3800
## 233 2150 0 2150
## 234 2400 0 2400
## 235 2150 0 2150
## 236 2300 0 2300
## 237 1400 0 1400
## 238 1450 0 1450
## 239 1550 0 1550
## 240 1800 0 1800
## 241 1600 0 1600
## 242 1550 0 1550
## 243 1550 0 1550
## 244 1650 0 1650
## 245 1150 0 1150
## 246 1100 0 1100
## 247 1250 0 1250
## 248 1100 0 1100
## 249 1550 0 1550
## 250 1950 0 1950
## 251 2600 0 2600
## 252 2800 0 2800
## 253 2000 0 2000
## 254 2000 0 2000
## 255 1600 0 1600
## 256 1600 0 1600
## 257 1650 0 1650
## 258 2150 0 2150
## 259 2300 0 2300
## 260 2400 0 2400
## 261 3200 0 3200
## 262 2500 0 2500
## 263 2150 0 2150
## 264 2400 0 2400
## 265 2500 0 2500
## 266 2600 0 2600
## 267 2600 0 2600
## 268 3200 0 3200
## 269 3800 0 3800
## 270 2800 0 2800
## 271 2950 0 2950
## 272 2950 0 2950
## 273 3800 0 3800
## 274 4300 0 4300
## 275 2150 0 2150
## 276 2150 0 2150
## 277 2300 0 2300
## 278 2700 0 2700
## 279 2700 0 2700
## 280 3400 0 3400
## 281 3800 0 3800
## 282 3400 0 3400
## 283 2400 0 2400
## 284 2950 0 2950
## 285 2600 0 2600
## 286 3050 0 3050
## 287 3050 0 3050
## 288 4050 0 4050
## 289 4300 0 4300
## 290 3050 0 3050
## 291 1750 0 1750
## 292 1250 0 1250
## 293 1500 0 1500
## 294 1600 0 1600
## 295 2100 0 2100
## 296 1550 0 1550
## 297 1650 0 1650
## 298 1750 0 1750
## 299 1500 0 1500
## 300 1600 0 1600
## 301 1100 0 1100
## 302 1000 0 1000
## 303 2800 0 2800
## 304 2700 0 2700
## 305 2800 0 2800
## 306 2950 0 2950
## 307 2950 0 2950
## 308 2950 0 2950
## 309 2500 0 2500
## 310 2700 0 2700
## 311 1800 0 1800
## 312 2100 0 2100
## 313 1700 0 1700
## 314 1600 0 1600
## 315 1950 0 1950
## 316 1250 0 1250
## 317 2100 0 2100
## 318 2150 0 2150
## 319 2950 0 2950
## 320 3050 0 3050
## 321 2600 0 2600
## 322 2600 0 2600
## 323 3200 0 3200
## 324 3200 0 3200
## 325 3200 0 3200
## 326 4050 0 4050
## 327 1800 0 1800
## 328 1800 0 1800
## 329 2100 0 2100
## 330 1850 0 1850
## 331 2400 0 2400
## 332 2600 0 2600
## 333 2300 0 2300
## 334 2500 0 2500
## 335 2200 0 2200
## 336 2600 0 2600
## 337 2400 0 2400
## 338 2300 0 2300
## 339 2500 0 2500
## 340 2500 0 2500
## 341 2500 0 2500
## 342 1700 0 1700
## 343 1800 0 1800
## 344 1750 0 1750
## 345 1850 0 1850
## 346 1650 0 1650
## 347 1600 0 1600
## 348 1650 0 1650
## 349 2100 0 2100
## 350 1800 0 1800
## 351 3050 0 3050
## 352 2950 0 2950
## 353 2100 0 2100
## 354 1850 0 1850
## 355 1950 0 1950
## 356 1050 0 1050
## 357 1150 0 1150
## 358 1700 0 1700
## 359 2150 0 2150
## 360 1750 0 1750
## 361 2100 0 2100
## 362 950 0 950
## 363 1000 0 1000
## 364 1100 0 1100
## 365 1050 0 1050
## 366 1800 0 1800
## 367 1300 0 1300
## 368 2600 0 2600
## 369 1950 0 1950
## 370 2700 0 2700
## 371 2000 0 2000
## 372 2150 0 2150
## 373 2950 0 2950
## 374 3600 0 3600
## 375 2300 0 2300
## 376 2400 0 2400
## 377 3200 0 3200
## 378 2600 0 2600
## 379 3400 0 3400
## 380 3050 0 3050
## 381 3200 0 3200
## 382 1700 0 1700
## 383 1100 0 1100
## 384 1550 0 1550
## 385 1650 0 1650
## 386 1750 0 1750
## 387 1650 0 1650
## 388 1700 0 1700
## 389 1850 0 1850
## 390 2700 0 2700
## 391 1950 0 1950
## 392 2000 0 2000
## 393 1850 0 1850
## 394 1150 0 1150
## 395 1750 0 1750
## 396 2000 0 2000
## 397 1950 0 1950
## 398 3400 0 3400
## 399 3200 0 3200
## 400 3400 0 3400
## 401 4050 0 4050
## 402 4300 0 4300
## 403 2700 0 2700
## 404 3050 0 3050
## 405 3050 0 3050
## 406 3050 0 3050
## 407 3050 0 3050
## 408 4600 0 4600
## 409 4600 0 4600
## 410 4600 0 4600
## 411 4600 0 4600
## 412 4600 0 4600
## 413 2600 0 2600
## 414 2500 0 2500
## 415 1800 0 1800
## 416 1800 0 1800
## 417 2000 0 2000
## 418 1950 0 1950
## 419 1800 0 1800
## 420 1750 0 1750
## 421 4050 0 4050
## 422 2700 0 2700
## 423 1800 0 1800
## 424 1850 0 1850
## 425 2400 0 2400
## 426 2600 0 2600
## 427 3800 0 3800
## 428 2800 0 2800
## 429 2600 0 2600
## 430 2350 0 2350
## 431 2350 0 2350
## 432 4600 0 4600
## 433 4600 0 4600
## 434 2600 0 2600
## 435 2450 0 2450
## 436 2550 0 2550
## 437 2100 0 2100
## 438 1450 0 1450
## 439 2700 0 2700
## 440 2350 0 2350
## 441 2350 0 2350
## 442 2450 0 2450
## 443 2700 0 2700
## 444 2700 0 2700
## 445 3000 0 3000
## 446 3200 0 3200
## 447 3400 0 3400
## 448 2150 0 2150
## 449 2550 0 2550
## 450 2850 0 2850
## 451 3000 0 3000
## 452 3200 0 3200
## 453 3400 0 3400
## 454 2550 0 2550
## 455 2700 0 2700
## 456 2550 0 2550
## 457 2550 0 2550
## 458 2550 0 2550
## 459 2850 0 2850
## 460 2700 0 2700
## 461 2550 0 2550
## 462 3000 0 3000
## 463 3400 0 3400
## 464 3000 0 3000
## 465 3000 3650 6650
## 466 2550 0 2550
## 467 2700 0 2700
## 468 2850 0 2850
## 469 2450 0 2450
## 470 2850 0 2850
## 471 2700 0 2700
## 472 2650 0 2650
## 473 3000 0 3000
## 474 3400 0 3400
## 475 3000 0 3000
## 476 3000 3650 6650
## 477 2550 0 2550
## 478 3800 0 3800
## 479 2450 0 2450
## 480 3050 0 3050
## 481 2700 0 2700
## 482 3550 0 3550
## 483 2350 0 2350
## 484 2700 0 2700
## 485 2700 0 2700
## 486 2450 0 2450
## 487 2950 0 2950
## 488 3200 0 3200
## 489 3200 0 3200
## 490 3000 0 3000
## 491 2850 0 2850
## 492 2750 0 2750
## 493 2850 0 2850
## 494 3200 0 3200
## 495 3200 0 3200
## 496 3400 0 3400
## 497 3200 3950 7150
## 498 3800 0 3800
## 499 3200 0 3200
## 500 3400 0 3400
## 501 3000 0 3000
## 502 3000 0 3000
## 503 3400 0 3400
## 504 3400 0 3400
## 505 3400 0 3400
## 506 3200 3950 7150
## 507 4300 0 4300
## 508 3150 0 3150
## 509 4300 0 4300
## 510 2700 0 2700
## 511 2850 0 2850
## 512 2850 0 2850
## 513 2350 0 2350
## 514 3000 0 3000
## 515 3200 0 3200
## 516 3400 0 3400
## 517 4500 0 4500
## 518 2450 0 2450
## 519 2700 0 2700
## 520 3200 0 3200
## 521 3200 0 3200
## 522 3000 0 3000
## 523 2750 0 2750
## 524 3200 0 3200
## 525 3200 0 3200
## 526 3400 0 3400
## 527 3200 3950 7150
## 528 4050 0 4050
## 529 3450 0 3450
## 530 4300 0 4300
## 531 3400 0 3400
## 532 3000 0 3000
## 533 3400 0 3400
## 534 3400 0 3400
## 535 3400 0 3400
## 536 3200 3950 7150
## 537 4300 0 4300
## 538 2550 0 2550
## 539 2700 0 2700
## 540 2850 0 2850
## 541 3000 0 3000
## 542 2700 0 2700
## 543 2850 0 2850
## 544 3800 0 3800
## 545 4050 0 4050
## 546 2550 0 2550
## 547 3200 0 3200
## 548 2850 0 2850
## 549 3550 0 3550
## 550 5400 0 5400
## 551 2350 0 2350
## 552 2250 0 2250
## 553 2850 0 2850
## 554 2850 0 2850
## 555 2700 0 2700
## 556 3400 0 3400
## 557 3200 0 3200
## 558 2850 0 2850
## 559 3400 0 3400
## 560 3050 0 3050
## 561 3050 0 3050
## 562 2300 0 2300
## 563 2300 0 2300
## 564 3050 0 3050
## 565 3050 0 3050
## 566 3400 0 3400
## 567 3600 0 3600
## 568 3600 0 3600
## 569 3600 0 3600
## 570 2450 0 2450
## 571 2450 0 2450
## 572 2450 0 2450
## 573 2450 0 2450
## 574 1500 0 1500
## 575 2700 0 2700
## 576 1550 0 1550
## 577 2950 0 2950
## 578 2600 0 2600
## 579 2600 0 2600
## 580 1800 0 1800
## 581 1800 0 1800
## 582 2500 0 2500
## 583 2700 0 2700
## 584 2550 0 2550
## 585 2800 0 2800
## 586 2550 0 2550
## 587 2150 0 2150
## 588 2450 0 2450
## 589 1950 0 1950
## 590 1750 0 1750
## 591 1800 0 1800
## 592 1400 0 1400
## 593 2100 0 2100
## 594 1800 0 1800
## 595 1350 0 1350
## 596 2450 0 2450
## 597 1950 0 1950
## 598 1750 0 1750
## 599 1750 0 1750
## 600 2450 0 2450
## 601 2350 0 2350
## 602 2250 0 2250
## 603 1500 0 1500
## 604 1950 0 1950
## 605 1750 0 1750
## 606 2500 0 2500
## 607 1100 0 1100
## 608 1000 0 1000
## 609 1750 0 1750
## 610 2350 0 2350
## 611 2100 0 2100
## 612 1450 0 1450
## 613 1950 0 1950
## 614 2450 0 2450
## 615 1950 0 1950
## 616 2600 0 2600
## 617 2150 0 2150
## 618 2400 0 2400
## 619 2000 0 2000
## 620 2100 0 2100
## 621 2000 0 2000
## 622 2350 0 2350
## 623 1650 0 1650
## 624 1700 0 1700
## 625 1700 0 1700
## 626 2150 0 2150
## 627 2250 0 2250
## 628 1500 0 1500
## 629 1800 0 1800
## 630 2350 0 2350
## 631 2350 0 2350
## 632 1750 0 1750
## 633 2100 0 2100
## 634 2000 0 2000
## 635 3050 0 3050
## 636 2800 0 2800
## 637 2800 0 2800
## 638 2700 0 2700
## 639 3400 0 3400
## 640 2150 0 2150
## 641 2350 0 2350
## 642 2500 0 2500
## 643 2700 0 2700
## 644 2700 0 2700
## 645 3050 0 3050
## 646 3050 0 3050
## 647 2500 0 2500
## 648 2300 0 2300
## 649 2500 0 2500
## 650 2300 0 2300
## 651 3800 0 3800
## 652 3800 0 3800
## 653 2800 0 2800
## 654 2700 0 2700
## 655 3800 0 3800
## 656 3800 0 3800
## 657 2800 0 2800
## 658 2700 0 2700
## 659 2000 0 2000
## 660 2250 0 2250
## 661 2600 0 2600
## 662 2800 0 2800
## 663 2550 0 2550
## 664 2800 0 2800
## 665 2550 0 2550
## 666 2250 0 2250
## 667 2550 0 2550
## 668 2100 0 2100
## 669 2000 0 2000
## 670 2250 0 2250
## 671 2700 0 2700
## 672 2700 0 2700
## 673 2700 0 2700
## 674 3200 0 3200
## 675 3200 0 3200
## 676 3000 0 3000
## 677 3200 0 3200
## 678 3000 0 3000
## 679 3000 0 3000
## 680 3200 0 3200
## 681 3200 0 3200
## 682 2100 0 2100
## 683 2350 0 2350
## 684 2350 0 2350
## 685 2350 0 2350
## 686 2550 0 2550
## 687 1950 0 1950
## 688 2100 0 2100
## 689 1400 0 1400
## 690 2700 0 2700
## 691 2950 0 2950
## 692 3200 0 3200
## 693 2150 0 2150
## 694 1850 0 1850
## 695 1450 0 1450
## 696 2550 0 2550
## 697 2100 0 2100
## 698 2000 0 2000
## 699 1950 0 1950
## 700 2550 0 2550
## 701 2450 0 2450
## 702 2350 0 2350
## 703 2350 0 2350
## 704 2450 0 2450
## 705 1600 0 1600
## 706 2150 0 2150
## 707 1450 0 1450
## 708 1400 0 1400
## 709 2600 0 2600
## 710 2600 0 2600
## 711 2800 0 2800
## 712 2700 0 2700
## 713 3050 0 3050
## 714 3800 0 3800
## 715 2000 0 2000
## 716 2550 0 2550
## 717 2700 0 2700
## 718 2850 0 2850
## 719 2550 0 2550
## 720 2700 0 2700
## 721 2850 0 2850
## 722 4600 0 4600
## 723 3000 0 3000
## 724 3200 0 3200
## 725 2100 0 2100
## 726 1850 0 1850
## 727 2350 0 2350
## 728 2150 0 2150
## 729 1600 0 1600
## 730 2150 0 2150
## 731 1400 0 1400
## 732 1250 0 1250
## 733 2100 0 2100
## 734 2700 0 2700
## 735 3200 0 3200
## 736 2950 0 2950
## 737 2800 0 2800
## 738 2950 0 2950
## 739 3050 0 3050
## 740 1950 0 1950
## 741 2700 0 2700
## 742 2700 0 2700
## 743 1650 0 1650
## 744 1650 0 1650
## 745 2700 0 2700
## 746 1800 0 1800
## 747 2400 0 2400
## 748 2250 0 2250
## 749 2250 0 2250
## 750 1800 0 1800
## 751 2600 0 2600
## 752 2600 0 2600
## 753 3200 0 3200
## 754 2150 0 2150
## 755 1850 0 1850
## 756 2150 0 2150
## 757 1950 0 1950
## 758 2250 0 2250
## 759 2150 0 2150
## 760 2000 0 2000
## 761 3050 0 3050
## 762 3050 0 3050
## 763 2400 0 2400
## 764 2400 0 2400
## 765 2400 0 2400
## 766 2500 0 2500
## 767 2700 0 2700
## 768 2800 0 2800
## 769 2100 0 2100
## 770 2150 0 2150
## 771 2100 0 2100
## 772 2100 0 2100
## 773 2150 0 2150
## 774 2350 0 2350
## 775 3050 0 3050
## 776 1750 0 1750
## 777 1750 0 1750
## 778 3050 0 3050
## 779 3400 0 3400
## 780 3400 0 3400
## 781 3050 0 3050
## 782 1850 0 1850
## 783 1850 0 1850
## 784 2000 0 2000
## 785 1850 0 1850
## 786 2100 0 2100
## 787 2150 0 2150
## 788 1950 0 1950
## 789 2350 0 2350
## 790 1800 0 1800
## 791 1300 0 1300
## 792 2250 0 2250
## 793 1950 0 1950
## 794 1850 0 1850
## 795 1800 0 1800
## 796 1950 0 1950
## 797 1400 0 1400
## 798 1450 0 1450
## 799 1400 0 1400
## 800 2700 0 2700
## 801 2450 0 2450
## 802 2450 0 2450
## 803 2550 0 2550
## 804 2000 0 2000
## 805 2150 0 2150
## 806 2250 0 2250
## 807 2500 0 2500
## 808 2600 0 2600
## 809 2600 0 2600
## 810 2550 0 2550
## 811 2850 0 2850
## 812 4050 0 4050
## 813 2850 0 2850
## 814 3200 0 3200
## 815 4050 0 4050
## 816 2750 0 2750
## 817 3200 0 3200
## 818 4050 0 4050
## 819 2350 0 2350
## 820 2550 0 2550
## 821 2550 0 2550
## 822 3550 0 3550
## 823 2850 0 2850
## 824 2250 0 2250
## 825 2550 0 2550
## 826 2700 0 2700
## 827 2350 0 2350
## 828 2850 0 2850
## 829 3200 0 3200
## 830 4050 0 4050
## 831 2850 0 2850
## 832 3200 0 3200
## 833 4050 0 4050
## 834 2800 0 2800
## 835 4050 0 4050
## 836 2450 0 2450
## 837 2550 0 2550
## 838 2700 0 2700
## 839 2700 0 2700
## 840 2800 0 2800
## 841 2550 0 2550
## 842 4050 0 4050
## 843 3200 0 3200
## 844 1500 0 1500
## 845 1600 0 1600
## 846 2250 0 2250
## 847 2250 0 2250
## 848 2450 0 2450
## 849 3400 0 3400
## 850 3800 0 3800
## 851 4050 0 4050
## 852 3050 0 3050
## 853 3050 0 3050
## 854 3400 0 3400
## 855 4300 0 4300
## 856 3800 0 3800
## 857 3800 0 3800
## 858 4050 0 4050
## 859 4050 0 4050
## 860 3800 0 3800
## 861 4300 0 4300
## 862 3400 0 3400
## 863 2600 0 2600
## 864 4300 0 4300
## 865 3400 0 3400
## 866 2700 0 2700
## 867 3600 0 3600
## 868 2950 0 2950
## 869 2700 0 2700
## 870 3000 0 3000
## 871 4050 0 4050
## 872 4950 0 4950
## 873 3000 0 3000
## 874 3400 0 3400
## 875 4050 0 4050
## 876 3000 0 3000
## 877 3200 0 3200
## 878 3400 0 3400
## 879 4050 0 4050
## 880 2550 0 2550
## 881 2700 0 2700
## 882 2550 0 2550
## 883 3550 0 3550
## 884 4950 0 4950
## 885 4300 0 4300
## 886 5400 0 5400
## 887 3600 0 3600
## 888 3000 0 3000
## 889 3200 0 3200
## 890 2350 0 2350
## 891 2700 0 2700
## 892 2700 0 2700
## 893 2700 3150 5850
## 894 2550 0 2550
## 895 2950 0 2950
## 896 3200 0 3200
## 897 2550 0 2550
## 898 3000 0 3000
## 899 3200 0 3200
## 900 4050 0 4050
## 901 3000 0 3000
## 902 3400 0 3400
## 903 4050 0 4050
## 904 2550 0 2550
## 905 2550 0 2550
## 906 2700 0 2700
## 907 4300 0 4300
## 908 4600 0 4600
## 909 2950 0 2950
## 910 4300 0 4300
## 911 2450 0 2450
## 912 2550 0 2550
## 913 3550 0 3550
## 914 3800 0 3800
## 915 4300 0 4300
## 916 3800 0 3800
## 917 2850 0 2850
## 918 2850 0 2850
## 919 4050 0 4050
## 920 3400 0 3400
## 921 4050 0 4050
## 922 3600 0 3600
## 923 3800 0 3800
## 924 3600 0 3600
## 925 3600 0 3600
## 926 3400 0 3400
## 927 4050 0 4050
## 928 3200 0 3200
## 929 3050 0 3050
## 930 3400 0 3400
## 931 3600 0 3600
## 932 3400 0 3400
## 933 3200 0 3200
## 934 3200 0 3200
## 935 3200 0 3200
## 936 3200 0 3200
## 937 3400 0 3400
## 938 3050 0 3050
## 939 3050 0 3050
## 940 3600 0 3600
## 941 3600 0 3600
## 942 3600 0 3600
## 943 3800 0 3800
## 944 3400 0 3400
## 945 2800 0 2800
## 946 2400 0 2400
## 947 2700 0 2700
## 948 3000 0 3000
## 949 3600 0 3600
## 950 3600 0 3600
## 951 4050 0 4050
## 952 4050 0 4050
## 953 2150 0 2150
## 954 2600 0 2600
## 955 4600 0 4600
## 956 5850 0 5850
## 957 3200 0 3200
## 958 3200 0 3200
## 959 4050 0 4050
## 960 4050 0 4050
## 961 4050 0 4050
## 962 4600 0 4600
## 963 2950 0 2950
## 964 3800 0 3800
## 965 3050 0 3050
## 966 4050 0 4050
## 967 4050 0 4050
## 968 4300 0 4300
## 969 2450 0 2450
## 970 3400 0 3400
## 971 3400 0 3400
## 972 3800 0 3800
## 973 3800 0 3800
## 974 2450 0 2450
## 975 2550 0 2550
## 976 3200 0 3200
## 977 3200 0 3200
## 978 2350 0 2350
## 979 2450 0 2450
## 980 2000 0 2000
## 981 1600 0 1600
## 982 1550 0 1550
## 983 1550 0 1550
## 984 2800 0 2800
## 985 2700 0 2700
## 986 2700 0 2700
## 987 2800 0 2800### Repalcing "Group of" text in those Manufacturer cells that have it
ice_cars_semi_final$manufacturer<- sub("\\sGroup\\sof$", "", ice_cars_semi_final$manufacturer)
ice_cars_semi_final## manufacturer division fuel_type_abrv
## 2 aston martin Aston Martin Lagonda Ltd GP
## 3 BMW BMW GP
## 4 BMW BMW GP
## 5 Volkswagen Bugatti GPR
## 6 General Motors Chevrolet GPR
## 7 General Motors Chevrolet GPR
## 8 General Motors Chevrolet GPR
## 9 General Motors Chevrolet GPR
## 10 Ferrari Ferrari North America, Inc. GPR
## 11 Ferrari Ferrari North America, Inc. GPR
## 12 Ferrari Ferrari North America, Inc. GPR
## 13 Jaguar Land Rover L Jaguar GP
## 14 Jaguar Land Rover L Jaguar GP
## 15 Jaguar Land Rover L Jaguar GP
## 16 Jaguar Land Rover L Jaguar GP
## 17 Jaguar Land Rover L Jaguar GP
## 18 Jaguar Land Rover L Jaguar GP
## 19 Volkswagen Lamborghini GPR
## 20 Volkswagen Lamborghini GPR
## 21 Volkswagen Lamborghini GPR
## 22 Lotus Lotus Cars Ltd G
## 23 Lotus Lotus Cars Ltd G
## 24 Maserati MASERATI GPR
## 25 Maserati MASERATI GPR
## 26 MAZDA MAZDA GP
## 27 MAZDA MAZDA GP
## 28 Mercedes-Benz Mercedes-Benz GPR
## 29 Mercedes-Benz Mercedes-Benz GPR
## 30 Mercedes-Benz Mercedes-Benz GPR
## 31 Nissan NISSAN GPR
## 32 Nissan NISSAN GPR
## 33 Nissan NISSAN GPR
## 34 Porsche Porsche GPR
## 35 Porsche Porsche GPR
## 36 Porsche Porsche GPR
## 37 Porsche Porsche GPR
## 38 Porsche Porsche GPR
## 39 Porsche Porsche GPR
## 40 Porsche Porsche GPR
## 41 Porsche Porsche GPR
## 42 Porsche Porsche GPR
## 43 Porsche Porsche GPR
## 44 Porsche Porsche GPR
## 45 Porsche Porsche GPR
## 46 Porsche Porsche GPR
## 47 Porsche Porsche GPR
## 48 Porsche Porsche GPR
## 49 Porsche Porsche GPR
## 50 Porsche Porsche GPR
## 51 Porsche Porsche GPR
## 52 Porsche Porsche GPR
## 53 Porsche Porsche GPR
## 54 BMW TOYOTA GP
## 55 BMW TOYOTA GP
## 56 BMW TOYOTA GP
## 57 aston martin Aston Martin Lagonda Ltd GP
## 58 Volkswagen Bentley GPR
## 59 Volkswagen Bentley GP
## 60 Ferrari Ferrari North America, Inc. GPR
## 61 Toyota LEXUS GPR
## 62 Mercedes-Benz Mercedes-Benz GPR
## 63 Mercedes-Benz Mercedes-Benz GPR
## 64 BMW Mini GP
## 65 BMW Mini GP
## 66 BMW Mini GP
## 67 BMW Mini GP
## 68 BMW Mini GP
## 69 Porsche Porsche GPR
## 70 Porsche Porsche GPR
## 71 Porsche Porsche GPR
## 72 Porsche Porsche GPR
## 73 Porsche Porsche GPR
## 74 Porsche Porsche GPR
## 75 Porsche Porsche GPR
## 76 Porsche Porsche GPR
## 77 Porsche Porsche GPR
## 78 Porsche Porsche GPR
## 79 Porsche Porsche GPR
## 80 Porsche Porsche GPR
## 81 Porsche Porsche GPR
## 82 Porsche Porsche GPR
## 83 Porsche Porsche GPR
## 84 Porsche Porsche GPR
## 85 Porsche Porsche GPR
## 86 Porsche Porsche GPR
## 87 Porsche Porsche GPR
## 88 Porsche Porsche GPR
## 89 Porsche Porsche GPR
## 90 Porsche Porsche GPR
## 91 Porsche Porsche GPR
## 92 Porsche Porsche GPR
## 93 Porsche Porsche GPR
## 94 Porsche Porsche GPR
## 95 Porsche Porsche GPR
## 96 Porsche Porsche GPR
## 97 Porsche Porsche GPR
## 98 Porsche Porsche GPR
## 99 Porsche Porsche GPR
## 100 Porsche Porsche GPR
## 101 Subaru Subaru GPR
## 102 Subaru Subaru GPR
## 103 Toyota TOYOTA GPR
## 104 Toyota TOYOTA GPR
## 105 Volkswagen Audi G
## 106 Volkswagen Audi G
## 107 Volkswagen Audi GP
## 108 Volkswagen Audi GP
## 109 Volkswagen Audi GP
## 110 Volkswagen Audi GP
## 111 Volkswagen Audi GP
## 112 Volkswagen Audi GP
## 113 Volkswagen Audi GP
## 114 Volkswagen Bentley GPR
## 115 Volkswagen Bentley GP
## 116 BMW BMW GP
## 117 BMW BMW GP
## 118 BMW BMW GP
## 119 BMW BMW GP
## 120 BMW BMW GP
## 121 BMW BMW GP
## 122 BMW BMW GP
## 123 BMW BMW GP
## 124 BMW BMW GP
## 125 BMW BMW GP
## 126 BMW BMW GPR
## 127 BMW BMW GPR
## 128 BMW BMW GP
## 129 BMW BMW GP
## 130 BMW BMW GPR
## 131 BMW BMW GPR
## 132 BMW BMW GPR
## 133 BMW BMW GP
## 134 BMW BMW GP
## 135 BMW BMW GP
## 136 BMW BMW GP
## 137 BMW BMW GPR
## 138 BMW BMW GPR
## 139 BMW BMW GPR
## 140 BMW BMW GP
## 141 BMW BMW GP
## 142 General Motors Chevrolet G
## 143 General Motors Chevrolet G
## 144 General Motors Chevrolet GPR
## 145 General Motors Chevrolet GPR
## 146 General Motors Chevrolet GPR
## 147 General Motors Chevrolet GPR
## 148 Ferrari Ferrari North America, Inc. GPR
## 149 Ford Motor Company Ford G
## 150 Ford Motor Company Ford G
## 151 Ford Motor Company Ford G
## 152 Ford Motor Company Ford G
## 153 Ford Motor Company Ford G
## 154 Ford Motor Company Ford G
## 155 Ford Motor Company Ford G
## 156 Ford Motor Company Ford G
## 157 Toyota LEXUS GPR
## 158 Toyota LEXUS GPR
## 159 Toyota LEXUS GPR
## 160 Toyota LEXUS GPR
## 161 Toyota LEXUS GPR
## 162 Toyota LEXUS GPR
## 163 Toyota LEXUS GPR
## 164 Maserati MASERATI GPR
## 165 Maserati MASERATI GPR
## 166 Maserati MASERATI GPR
## 167 Mercedes-Benz Mercedes-Benz GPR
## 168 Mercedes-Benz Mercedes-Benz GPR
## 169 Mercedes-Benz Mercedes-Benz GPR
## 170 Mercedes-Benz Mercedes-Benz GPR
## 171 Mercedes-Benz Mercedes-Benz GPR
## 172 BMW Mini GP
## 173 BMW Mini GP
## 174 BMW Mini GP
## 175 BMW Mini GP
## 176 BMW Mini GP
## 177 BMW Mini GP
## 178 BMW Mini GP
## 179 BMW Mini GP
## 180 BMW Mini GP
## 181 BMW Mini GP
## 182 Nissan NISSAN GPR
## 183 Toyota TOYOTA GPR
## 184 Honda Acura GP
## 185 Honda Acura GP
## 186 Honda Acura GP
## 187 Volkswagen Audi GP
## 188 Volkswagen Audi GP
## 189 Volkswagen Audi GP
## 190 BMW BMW GP
## 191 BMW BMW GP
## 192 BMW BMW GP
## 193 BMW BMW GP
## 194 BMW BMW GP
## 195 BMW BMW GP
## 196 BMW BMW GP
## 197 BMW BMW GPR
## 198 BMW BMW GPR
## 199 BMW BMW GPR
## 200 BMW BMW GPR
## 201 BMW BMW GP
## 202 BMW BMW GP
## 203 BMW BMW GP
## 204 BMW BMW GP
## 205 General Motors Cadillac GPR
## 206 General Motors Cadillac GPR
## 207 General Motors Cadillac GPR
## 208 General Motors Cadillac GPR
## 209 General Motors Cadillac GPR
## 210 General Motors Cadillac GPR
## 211 General Motors Cadillac GPR
## 212 General Motors Cadillac GPR
## 213 Hyundai GENESIS GP
## 214 Hyundai GENESIS GP
## 215 Toyota LEXUS GPR
## 216 Toyota LEXUS GPR
## 217 Toyota LEXUS GPR
## 218 Toyota LEXUS GPR
## 219 Toyota LEXUS GPR
## 220 Toyota LEXUS G
## 221 Toyota LEXUS G
## 222 Toyota LEXUS G
## 223 Toyota LEXUS G
## 224 MAZDA MAZDA G
## 225 MAZDA MAZDA G
## 226 MAZDA MAZDA G
## 227 Mercedes-Benz Mercedes-Benz GPR
## 228 Mercedes-Benz Mercedes-Benz GPR
## 229 Mercedes-Benz Mercedes-Benz GPR
## 230 Mercedes-Benz Mercedes-Benz GPR
## 231 Mercedes-Benz Mercedes-Benz GPR
## 232 Mercedes-Benz Mercedes-Benz GPR
## 233 Mercedes-Benz Mercedes-Benz GPR
## 234 Mercedes-Benz Mercedes-Benz GPR
## 235 Mercedes-Benz Mercedes-Benz GPR
## 236 Mercedes-Benz Mercedes-Benz GPR
## 237 Mitsubishi Motors Co Mitsubishi Motors Corporation G
## 238 Mitsubishi Motors Co Mitsubishi Motors Corporation G
## 239 Nissan NISSAN G
## 240 Nissan NISSAN G
## 241 Toyota TOYOTA G
## 242 Toyota TOYOTA G
## 243 Toyota TOYOTA G
## 244 Toyota TOYOTA G
## 245 Toyota TOYOTA G
## 246 Toyota TOYOTA G
## 247 Toyota TOYOTA G
## 248 Toyota TOYOTA G
## 249 Volkswagen Volkswagen G
## 250 Volkswagen Volkswagen G
## 251 Volkswagen Volkswagen GP
## 252 Volkswagen Volkswagen GP
## 253 Volkswagen Volkswagen G
## 254 Volkswagen Volkswagen G
## 255 Volkswagen Volkswagen G
## 256 Volkswagen Volkswagen G
## 257 Volkswagen Volkswagen G
## 258 Volvo Volvo Cars of North America, LLC GPR
## 259 Volvo Volvo Cars of North America, LLC GPR
## 260 FCA US LLC ALFA ROMEO GP
## 261 FCA US LLC ALFA ROMEO GP
## 262 FCA US LLC ALFA ROMEO GP
## 263 Volkswagen Audi GP
## 264 Volkswagen Audi GP
## 265 Volkswagen Audi GP
## 266 Volkswagen Audi GP
## 267 Volkswagen Audi GP
## 268 Volkswagen Audi GP
## 269 Volkswagen Audi GP
## 270 Volkswagen Audi GP
## 271 Volkswagen Audi GP
## 272 Volkswagen Audi GP
## 273 Volkswagen Bentley GPR
## 274 Volkswagen Bentley GP
## 275 BMW BMW GP
## 276 BMW BMW GP
## 277 BMW BMW GP
## 278 BMW BMW GP
## 279 BMW BMW GP
## 280 BMW BMW GP
## 281 BMW BMW GPR
## 282 BMW BMW GP
## 283 General Motors Cadillac GPR
## 284 General Motors Cadillac GPR
## 285 General Motors Cadillac GPR
## 286 General Motors Cadillac GPR
## 287 General Motors Cadillac GPR
## 288 General Motors Cadillac GPR
## 289 General Motors Cadillac GPR
## 290 General Motors Cadillac GPR
## 291 General Motors Chevrolet G
## 292 Honda Honda G
## 293 Honda Honda G
## 294 Honda Honda G
## 295 Honda Honda GP
## 296 Honda Honda G
## 297 Honda Honda G
## 298 Hyundai HYUNDAI MOTOR COMPANY G
## 299 Hyundai HYUNDAI MOTOR COMPANY G
## 300 Hyundai HYUNDAI MOTOR COMPANY G
## 301 Hyundai HYUNDAI MOTOR COMPANY G
## 302 Hyundai HYUNDAI MOTOR COMPANY G
## 303 Hyundai HYUNDAI MOTOR COMPANY GP
## 304 Hyundai HYUNDAI MOTOR COMPANY GP
## 305 Nissan INFINITI GPR
## 306 Nissan INFINITI GPR
## 307 Nissan INFINITI GPR
## 308 Nissan INFINITI GPR
## 309 Jaguar Land Rover L Jaguar GP
## 310 Jaguar Land Rover L Jaguar GP
## 311 Kia KIA G
## 312 Kia KIA G
## 313 Kia KIA G
## 314 Kia KIA G
## 315 Toyota LEXUS G
## 316 Toyota LEXUS G
## 317 Toyota LEXUS G
## 318 Toyota LEXUS G
## 319 Toyota LEXUS GPR
## 320 Toyota LEXUS GPR
## 321 Toyota LEXUS GPR
## 322 Toyota LEXUS GPR
## 323 Maserati MASERATI GPR
## 324 Maserati MASERATI GPR
## 325 Maserati MASERATI GPR
## 326 Maserati MASERATI GPR
## 327 MAZDA MAZDA G
## 328 MAZDA MAZDA G
## 329 MAZDA MAZDA G
## 330 MAZDA MAZDA G
## 331 Mercedes-Benz Mercedes-Benz GPR
## 332 Mercedes-Benz Mercedes-Benz GPR
## 333 BMW Mini GP
## 334 BMW Mini GP
## 335 BMW Mini GP
## 336 BMW Mini GP
## 337 BMW Mini GP
## 338 BMW Mini GP
## 339 BMW Mini GP
## 340 BMW Mini GP
## 341 BMW Mini GP
## 342 Nissan NISSAN G
## 343 Nissan NISSAN G
## 344 Nissan NISSAN G
## 345 Nissan NISSAN G
## 346 Nissan NISSAN G
## 347 Nissan NISSAN G
## 348 Nissan NISSAN G
## 349 Subaru Subaru G
## 350 Subaru Subaru G
## 351 Subaru Subaru GP
## 352 Subaru Subaru GP
## 353 Toyota TOYOTA G
## 354 Toyota TOYOTA G
## 355 Toyota TOYOTA G
## 356 Toyota TOYOTA G
## 357 Toyota TOYOTA G
## 358 Toyota TOYOTA G
## 359 Toyota TOYOTA G
## 360 Toyota TOYOTA G
## 361 Toyota TOYOTA G
## 362 Toyota TOYOTA G
## 363 Toyota TOYOTA G
## 364 Toyota TOYOTA G
## 365 Toyota TOYOTA G
## 366 Toyota TOYOTA G
## 367 Toyota TOYOTA G
## 368 Volvo Volvo Cars of North America, LLC GPR
## 369 Honda Acura GP
## 370 Honda Acura GP
## 371 Honda Acura GP
## 372 Honda Acura GP
## 373 Volkswagen Audi GP
## 374 Volkswagen Audi GP
## 375 BMW BMW GP
## 376 BMW BMW GP
## 377 BMW BMW GP
## 378 Hyundai GENESIS GP
## 379 Hyundai GENESIS GP
## 380 Hyundai GENESIS GP
## 381 Hyundai GENESIS GP
## 382 Honda Honda G
## 383 Honda Honda G
## 384 Honda Honda G
## 385 Honda Honda G
## 386 Honda Honda G
## 387 Honda Honda G
## 388 Honda Honda G
## 389 Honda Honda G
## 390 Honda Honda GP
## 391 Hyundai HYUNDAI MOTOR COMPANY G
## 392 Hyundai HYUNDAI MOTOR COMPANY G
## 393 Hyundai HYUNDAI MOTOR COMPANY G
## 394 Hyundai HYUNDAI MOTOR COMPANY G
## 395 Kia KIA G
## 396 Kia KIA G
## 397 Kia KIA G
## 398 Maserati MASERATI GPR
## 399 Maserati MASERATI GPR
## 400 Maserati MASERATI GPR
## 401 Maserati MASERATI GPR
## 402 Mercedes-Benz Mercedes-Benz GPR
## 403 Mercedes-Benz Mercedes-Benz GPR
## 404 Mercedes-Benz Mercedes-Benz GPR
## 405 Mercedes-Benz Mercedes-Benz GPR
## 406 Porsche Porsche GPR
## 407 Porsche Porsche GPR
## 408 Rolls-Royce Rolls-Royce Motor Cars Limited GP
## 409 Rolls-Royce Rolls-Royce Motor Cars Limited GP
## 410 Rolls-Royce Rolls-Royce Motor Cars Limited GP
## 411 Rolls-Royce Rolls-Royce Motor Cars Limited GP
## 412 Rolls-Royce Rolls-Royce Motor Cars Limited GP
## 413 Volkswagen Volkswagen GP
## 414 Volkswagen Audi GP
## 415 General Motors Buick G
## 416 General Motors Chevrolet G
## 417 Honda Honda G
## 418 Honda Honda G
## 419 Kia KIA G
## 420 Kia KIA G
## 421 Volkswagen Lamborghini GP
## 422 Mercedes-Benz Mercedes-Benz GPR
## 423 Subaru Subaru G
## 424 Subaru Subaru G
## 425 Volvo Volvo Cars of North America, LLC GPR
## 426 Volkswagen Audi GP
## 427 Volkswagen Audi GP
## 428 Mercedes-Benz Mercedes-Benz GPR
## 429 Mercedes-Benz Mercedes-Benz GPR
## 430 Nissan NISSAN G
## 431 Nissan NISSAN G
## 432 Rolls-Royce Rolls-Royce Motor Cars Limited GP
## 433 Rolls-Royce Rolls-Royce Motor Cars Limited GP
## 434 Volvo Volvo Cars of North America, LLC GPR
## 435 General Motors Chevrolet G
## 436 General Motors Chevrolet G
## 437 Ford Motor Company Ford G
## 438 Ford Motor Company Ford G
## 439 General Motors GMC G
## 440 Toyota TOYOTA G
## 441 Toyota TOYOTA G
## 442 Toyota TOYOTA G
## 443 General Motors Chevrolet G
## 444 General Motors Chevrolet G
## 445 General Motors Chevrolet G
## 446 General Motors Chevrolet G
## 447 General Motors Chevrolet G
## 448 Ford Motor Company Ford G
## 449 Ford Motor Company Ford G
## 450 General Motors GMC G
## 451 General Motors GMC G
## 452 General Motors GMC G
## 453 General Motors GMC G
## 454 Toyota TOYOTA G
## 455 Toyota TOYOTA G
## 456 Toyota TOYOTA G
## 457 Toyota TOYOTA G
## 458 Toyota TOYOTA G
## 459 General Motors Chevrolet G
## 460 General Motors Chevrolet G
## 461 General Motors Chevrolet DU
## 462 General Motors Chevrolet G
## 463 General Motors Chevrolet G
## 464 General Motors Chevrolet G
## 465 General Motors Chevrolet G
## 466 Ford Motor Company Ford G
## 467 Ford Motor Company Ford G
## 468 Ford Motor Company Ford G
## 469 Ford Motor Company Ford G
## 470 General Motors GMC G
## 471 General Motors GMC G
## 472 General Motors GMC DU
## 473 General Motors GMC G
## 474 General Motors GMC G
## 475 General Motors GMC G
## 476 General Motors GMC G
## 477 Nissan NISSAN G
## 478 Nissan NISSAN GP
## 479 FCA US LLC RAM G
## 480 FCA US LLC RAM GM
## 481 FCA US LLC RAM G
## 482 FCA US LLC RAM GM
## 483 FCA US LLC RAM G
## 484 Toyota TOYOTA G
## 485 Toyota TOYOTA G
## 486 Toyota TOYOTA G
## 487 Toyota TOYOTA GPR
## 488 Toyota TOYOTA GPR
## 489 Toyota TOYOTA GPR
## 490 General Motors Chevrolet G
## 491 General Motors Chevrolet G
## 492 General Motors Chevrolet DU
## 493 General Motors Chevrolet DU
## 494 General Motors Chevrolet G
## 495 General Motors Chevrolet G
## 496 General Motors Chevrolet G
## 497 General Motors Chevrolet G
## 498 General Motors Chevrolet GP
## 499 General Motors Chevrolet G
## 500 General Motors Chevrolet G
## 501 General Motors Chevrolet DU
## 502 General Motors Chevrolet DU
## 503 General Motors Chevrolet G
## 504 General Motors Chevrolet G
## 505 General Motors Chevrolet G
## 506 General Motors Chevrolet G
## 507 General Motors Chevrolet GP
## 508 General Motors Chevrolet DU
## 509 General Motors Chevrolet GP
## 510 Ford Motor Company Ford G
## 511 Ford Motor Company Ford G
## 512 Ford Motor Company Ford G
## 513 Ford Motor Company Ford G
## 514 Ford Motor Company Ford G
## 515 Ford Motor Company Ford G
## 516 Ford Motor Company Ford G
## 517 Ford Motor Company Ford G
## 518 Ford Motor Company Ford G
## 519 Ford Motor Company Ford G
## 520 Ford Motor Company Ford G
## 521 General Motors GMC G
## 522 General Motors GMC G
## 523 General Motors GMC DU
## 524 General Motors GMC G
## 525 General Motors GMC G
## 526 General Motors GMC G
## 527 General Motors GMC G
## 528 General Motors GMC GP
## 529 General Motors GMC DU
## 530 General Motors GMC GP
## 531 General Motors GMC G
## 532 General Motors GMC DU
## 533 General Motors GMC G
## 534 General Motors GMC G
## 535 General Motors GMC G
## 536 General Motors GMC G
## 537 General Motors GMC GP
## 538 Honda Honda G
## 539 Honda Honda G
## 540 FCA US LLC Jeep G
## 541 FCA US LLC Jeep G
## 542 Nissan NISSAN G
## 543 Nissan NISSAN G
## 544 Nissan NISSAN GP
## 545 Nissan NISSAN GP
## 546 FCA US LLC RAM G
## 547 FCA US LLC RAM GM
## 548 FCA US LLC RAM G
## 549 FCA US LLC RAM GM
## 550 FCA US LLC RAM GP
## 551 Toyota TOYOTA G
## 552 Toyota TOYOTA G
## 553 Toyota TOYOTA G
## 554 Toyota TOYOTA G
## 555 Toyota TOYOTA G
## 556 Toyota TOYOTA GPR
## 557 Toyota TOYOTA GPR
## 558 Toyota TOYOTA G
## 559 Toyota TOYOTA GPR
## 560 General Motors Cadillac GPR
## 561 General Motors Cadillac GPR
## 562 Mercedes-Benz Mercedes-Benz GPR
## 563 Mercedes-Benz Mercedes-Benz GPR
## 564 General Motors Cadillac GPR
## 565 General Motors Cadillac GPR
## 566 General Motors Chevrolet G
## 567 General Motors Chevrolet G
## 568 General Motors GMC G
## 569 General Motors GMC G
## 570 FCA US LLC Chrysler G
## 571 FCA US LLC Chrysler G
## 572 Honda Honda G
## 573 Kia KIA G
## 574 Toyota TOYOTA G
## 575 FCA US LLC Chrysler G
## 576 Toyota TOYOTA G
## 577 Honda Acura GP
## 578 FCA US LLC ALFA ROMEO GP
## 579 BMW BMW GP
## 580 General Motors Buick G
## 581 General Motors Buick G
## 582 General Motors Cadillac GPR
## 583 General Motors Cadillac GPR
## 584 General Motors Cadillac G
## 585 General Motors Cadillac GPR
## 586 General Motors Cadillac G
## 587 General Motors Chevrolet G
## 588 General Motors Chevrolet G
## 589 General Motors Chevrolet G
## 590 General Motors Chevrolet G
## 591 Ford Motor Company Ford G
## 592 Ford Motor Company Ford G
## 593 General Motors GMC G
## 594 Honda Honda G
## 595 Honda Honda G
## 596 Honda Honda G
## 597 Hyundai HYUNDAI MOTOR COMPANY G
## 598 Hyundai HYUNDAI MOTOR COMPANY G
## 599 Hyundai HYUNDAI MOTOR COMPANY G
## 600 Hyundai HYUNDAI MOTOR COMPANY G
## 601 Hyundai HYUNDAI MOTOR COMPANY G
## 602 Hyundai HYUNDAI MOTOR COMPANY G
## 603 Hyundai HYUNDAI MOTOR COMPANY G
## 604 Hyundai HYUNDAI MOTOR COMPANY G
## 605 Hyundai HYUNDAI MOTOR COMPANY G
## 606 Nissan INFINITI GPR
## 607 Kia KIA G
## 608 Kia KIA G
## 609 Kia KIA G
## 610 Kia KIA G
## 611 Kia KIA G
## 612 Kia KIA G
## 613 Kia KIA G
## 614 Kia KIA G
## 615 Toyota LEXUS G
## 616 Toyota LEXUS GPR
## 617 Ford Motor Company Lincoln G
## 618 Mercedes-Benz Mercedes-Benz GPR
## 619 Nissan MITSUBISHI MOTORS G
## 620 Mitsubishi Motors Co Mitsubishi Motors Corporation G
## 621 Mitsubishi Motors Co Mitsubishi Motors Corporation G
## 622 Nissan NISSAN G
## 623 Nissan NISSAN G
## 624 Nissan NISSAN G
## 625 Toyota TOYOTA G
## 626 Toyota TOYOTA G
## 627 Toyota TOYOTA G
## 628 Toyota TOYOTA G
## 629 Toyota TOYOTA G
## 630 Volkswagen Volkswagen G
## 631 Volkswagen Volkswagen G
## 632 Volkswagen Volkswagen G
## 633 Volkswagen Volkswagen G
## 634 Volkswagen Volkswagen G
## 635 Honda Acura GP
## 636 Honda Acura GP
## 637 Honda Acura GP
## 638 FCA US LLC ALFA ROMEO GP
## 639 FCA US LLC ALFA ROMEO GP
## 640 Volkswagen Audi G
## 641 Volkswagen Audi G
## 642 Volkswagen Audi GP
## 643 Volkswagen Audi GP
## 644 Volkswagen Audi GP
## 645 Volkswagen Audi GP
## 646 Volkswagen Audi GP
## 647 BMW BMW GP
## 648 BMW BMW GP
## 649 BMW BMW GP
## 650 BMW BMW GP
## 651 BMW BMW GP
## 652 BMW BMW GP
## 653 BMW BMW GP
## 654 BMW BMW GP
## 655 BMW BMW GP
## 656 BMW BMW GP
## 657 BMW BMW GP
## 658 BMW BMW GP
## 659 General Motors Buick G
## 660 General Motors Buick G
## 661 General Motors Cadillac GPR
## 662 General Motors Cadillac GPR
## 663 General Motors Cadillac G
## 664 General Motors Cadillac GPR
## 665 General Motors Cadillac G
## 666 General Motors Chevrolet G
## 667 General Motors Chevrolet G
## 668 General Motors Chevrolet G
## 669 General Motors Chevrolet G
## 670 FCA US LLC Dodge G
## 671 Ford Motor Company Ford G
## 672 Ford Motor Company Ford G
## 673 Ford Motor Company Ford G
## 674 Ford Motor Company Ford G
## 675 Ford Motor Company Ford G
## 676 Ford Motor Company Ford G
## 677 Ford Motor Company Ford G
## 678 Ford Motor Company Ford G
## 679 Ford Motor Company Ford G
## 680 Ford Motor Company Ford G
## 681 Ford Motor Company Ford G
## 682 Ford Motor Company Ford G
## 683 Ford Motor Company Ford G
## 684 Ford Motor Company Ford G
## 685 Ford Motor Company Ford G
## 686 Ford Motor Company Ford G
## 687 Ford Motor Company Ford G
## 688 Ford Motor Company Ford G
## 689 Ford Motor Company Ford G
## 690 Hyundai GENESIS GP
## 691 Hyundai GENESIS GP
## 692 Hyundai GENESIS GP
## 693 General Motors GMC G
## 694 Honda Honda G
## 695 Honda Honda G
## 696 Honda Honda G
## 697 Hyundai HYUNDAI MOTOR COMPANY G
## 698 Hyundai HYUNDAI MOTOR COMPANY G
## 699 Hyundai HYUNDAI MOTOR COMPANY G
## 700 Hyundai HYUNDAI MOTOR COMPANY G
## 701 Hyundai HYUNDAI MOTOR COMPANY G
## 702 Hyundai HYUNDAI MOTOR COMPANY G
## 703 Hyundai HYUNDAI MOTOR COMPANY G
## 704 Hyundai HYUNDAI MOTOR COMPANY G
## 705 Hyundai HYUNDAI MOTOR COMPANY G
## 706 Hyundai HYUNDAI MOTOR COMPANY G
## 707 Hyundai HYUNDAI MOTOR COMPANY G
## 708 Hyundai HYUNDAI MOTOR COMPANY G
## 709 Nissan INFINITI GPR
## 710 Nissan INFINITI GPR
## 711 Jaguar Land Rover L Jaguar GP
## 712 Jaguar Land Rover L Jaguar GP
## 713 Jaguar Land Rover L Jaguar GP
## 714 Jaguar Land Rover L Jaguar GP
## 715 FCA US LLC Jeep G
## 716 FCA US LLC Jeep G
## 717 FCA US LLC Jeep G
## 718 FCA US LLC Jeep G
## 719 FCA US LLC Jeep G
## 720 FCA US LLC Jeep G
## 721 FCA US LLC Jeep G
## 722 FCA US LLC Jeep GP
## 723 FCA US LLC Jeep G
## 724 FCA US LLC Jeep G
## 725 Kia KIA G
## 726 Kia KIA G
## 727 Kia KIA G
## 728 Kia KIA G
## 729 Kia KIA G
## 730 Kia KIA G
## 731 Kia KIA G
## 732 Kia KIA G
## 733 Kia KIA G
## 734 Kia KIA G
## 735 Jaguar Land Rover L Land Rover GP
## 736 Jaguar Land Rover L Land Rover GP
## 737 Jaguar Land Rover L Land Rover GP
## 738 Jaguar Land Rover L Land Rover GP
## 739 Jaguar Land Rover L Land Rover GP
## 740 Toyota LEXUS G
## 741 Toyota LEXUS GPR
## 742 Toyota LEXUS GPR
## 743 Toyota LEXUS GP
## 744 Toyota LEXUS GP
## 745 Toyota LEXUS GPR
## 746 Toyota LEXUS GP
## 747 Toyota LEXUS GPR
## 748 Ford Motor Company Lincoln G
## 749 Ford Motor Company Lincoln G
## 750 Ford Motor Company Lincoln G
## 751 Maserati MASERATI GP
## 752 Maserati MASERATI GP
## 753 Maserati MASERATI GPR
## 754 MAZDA MAZDA G
## 755 MAZDA MAZDA G
## 756 MAZDA MAZDA G
## 757 MAZDA MAZDA G
## 758 MAZDA MAZDA G
## 759 MAZDA MAZDA G
## 760 MAZDA MAZDA G
## 761 Mercedes-Benz Mercedes-Benz GPR
## 762 Mercedes-Benz Mercedes-Benz GPR
## 763 Mercedes-Benz Mercedes-Benz GPR
## 764 Mercedes-Benz Mercedes-Benz GPR
## 765 Mercedes-Benz Mercedes-Benz GPR
## 766 Mercedes-Benz Mercedes-Benz GPR
## 767 Mercedes-Benz Mercedes-Benz GPR
## 768 Mercedes-Benz Mercedes-Benz GPR
## 769 Nissan MITSUBISHI MOTORS G
## 770 Mitsubishi Motors Co Mitsubishi Motors Corporation G
## 771 Mitsubishi Motors Co Mitsubishi Motors Corporation G
## 772 Mitsubishi Motors Co Mitsubishi Motors Corporation G
## 773 Mitsubishi Motors Co Mitsubishi Motors Corporation G
## 774 Nissan NISSAN G
## 775 Nissan NISSAN GP
## 776 Nissan NISSAN G
## 777 Nissan NISSAN G
## 778 Porsche Porsche GPR
## 779 Porsche Porsche GPR
## 780 Porsche Porsche GPR
## 781 Porsche Porsche GPR
## 782 Subaru Subaru G
## 783 Subaru Subaru G
## 784 Subaru Subaru G
## 785 Subaru Subaru G
## 786 Subaru Subaru G
## 787 Subaru Subaru G
## 788 Subaru Subaru G
## 789 Subaru Subaru G
## 790 Toyota TOYOTA G
## 791 Toyota TOYOTA G
## 792 Toyota TOYOTA G
## 793 Toyota TOYOTA G
## 794 Toyota TOYOTA G
## 795 Toyota TOYOTA G
## 796 Toyota TOYOTA G
## 797 Toyota TOYOTA G
## 798 Toyota TOYOTA G
## 799 Toyota TOYOTA G
## 800 Volkswagen Volkswagen G
## 801 Volkswagen Volkswagen G
## 802 Volkswagen Volkswagen G
## 803 Volkswagen Volkswagen G
## 804 Volkswagen Volkswagen G
## 805 Volkswagen Volkswagen G
## 806 Volkswagen Volkswagen G
## 807 Volvo Volvo Cars of North America, LLC GPR
## 808 Volvo Volvo Cars of North America, LLC GPR
## 809 BMW BMW GP
## 810 General Motors Buick G
## 811 General Motors Cadillac DU
## 812 General Motors Cadillac GPR
## 813 General Motors Chevrolet DU
## 814 General Motors Chevrolet G
## 815 General Motors Chevrolet GPR
## 816 General Motors Chevrolet DU
## 817 General Motors Chevrolet G
## 818 General Motors Chevrolet GPR
## 819 General Motors Chevrolet G
## 820 General Motors Chevrolet G
## 821 FCA US LLC Dodge G
## 822 FCA US LLC Dodge GM
## 823 Ford Motor Company Ford G
## 824 Ford Motor Company Ford G
## 825 Ford Motor Company Ford G
## 826 Ford Motor Company Ford G
## 827 General Motors GMC G
## 828 General Motors GMC DU
## 829 General Motors GMC G
## 830 General Motors GMC GPR
## 831 General Motors GMC DU
## 832 General Motors GMC G
## 833 General Motors GMC GPR
## 834 Nissan INFINITI GP
## 835 Nissan INFINITI GP
## 836 FCA US LLC Jeep G
## 837 FCA US LLC Jeep G
## 838 FCA US LLC Jeep G
## 839 FCA US LLC Jeep G
## 840 Toyota LEXUS GPR
## 841 Ford Motor Company Lincoln G
## 842 Nissan NISSAN GP
## 843 Toyota TOYOTA G
## 844 Toyota TOYOTA G
## 845 Toyota TOYOTA G
## 846 Toyota TOYOTA G
## 847 Toyota TOYOTA G
## 848 Toyota TOYOTA G
## 849 Honda Acura GP
## 850 aston martin Aston Martin Lagonda Ltd GP
## 851 aston martin Aston Martin Lagonda Ltd GP
## 852 Volkswagen Audi GP
## 853 Volkswagen Audi GP
## 854 Volkswagen Audi GP
## 855 Volkswagen Audi GP
## 856 Volkswagen Audi GP
## 857 Volkswagen Audi GP
## 858 Volkswagen Bentley GP
## 859 Volkswagen Bentley GP
## 860 BMW BMW GP
## 861 BMW BMW GPR
## 862 BMW BMW GP
## 863 BMW BMW GP
## 864 BMW BMW GPR
## 865 BMW BMW GP
## 866 BMW BMW GP
## 867 BMW BMW GP
## 868 BMW BMW GP
## 869 General Motors Buick G
## 870 General Motors Cadillac DU
## 871 General Motors Cadillac GPR
## 872 General Motors Cadillac GPR
## 873 General Motors Chevrolet DU
## 874 General Motors Chevrolet G
## 875 General Motors Chevrolet GPR
## 876 General Motors Chevrolet DU
## 877 General Motors Chevrolet G
## 878 General Motors Chevrolet G
## 879 General Motors Chevrolet GPR
## 880 General Motors Chevrolet G
## 881 General Motors Chevrolet G
## 882 FCA US LLC Dodge G
## 883 FCA US LLC Dodge GM
## 884 FCA US LLC Dodge GP
## 885 FCA US LLC Dodge GP
## 886 Ferrari Ferrari North America, Inc. GPR
## 887 Ford Motor Company Ford G
## 888 Ford Motor Company Ford G
## 889 Ford Motor Company Ford G
## 890 Ford Motor Company Ford G
## 891 Ford Motor Company Ford G
## 892 Ford Motor Company Ford G
## 893 Ford Motor Company Ford G
## 894 Ford Motor Company Ford G
## 895 Hyundai GENESIS GP
## 896 Hyundai GENESIS GP
## 897 General Motors GMC G
## 898 General Motors GMC DU
## 899 General Motors GMC G
## 900 General Motors GMC GPR
## 901 General Motors GMC DU
## 902 General Motors GMC G
## 903 General Motors GMC GPR
## 904 Honda Honda G
## 905 Honda Honda G
## 906 Honda Honda G
## 907 Ineos Automotive Li INEOS Automotive Limited GP
## 908 Ineos Automotive Li INEOS Automotive Limited GP
## 909 Nissan INFINITI GP
## 910 Nissan INFINITI GP
## 911 FCA US LLC Jeep G
## 912 FCA US LLC Jeep G
## 913 FCA US LLC Jeep GM
## 914 FCA US LLC Jeep GP
## 915 FCA US LLC Jeep GP
## 916 FCA US LLC Jeep GP
## 917 FCA US LLC Jeep G
## 918 FCA US LLC Jeep G
## 919 Volkswagen Lamborghini GP
## 920 Jaguar Land Rover L Land Rover GP
## 921 Jaguar Land Rover L Land Rover GP
## 922 Jaguar Land Rover L Land Rover GP
## 923 Jaguar Land Rover L Land Rover GPR
## 924 Jaguar Land Rover L Land Rover GP
## 925 Jaguar Land Rover L Land Rover GP
## 926 Jaguar Land Rover L Land Rover GP
## 927 Jaguar Land Rover L Land Rover GP
## 928 Jaguar Land Rover L Land Rover GP
## 929 Jaguar Land Rover L Land Rover GP
## 930 Jaguar Land Rover L Land Rover GP
## 931 Jaguar Land Rover L Land Rover GP
## 932 Jaguar Land Rover L Land Rover GP
## 933 Jaguar Land Rover L Land Rover GP
## 934 Jaguar Land Rover L Land Rover GP
## 935 Jaguar Land Rover L Land Rover GP
## 936 Jaguar Land Rover L Land Rover GP
## 937 Jaguar Land Rover L Land Rover GP
## 938 Jaguar Land Rover L Land Rover GP
## 939 Jaguar Land Rover L Land Rover GP
## 940 Jaguar Land Rover L Land Rover GP
## 941 Jaguar Land Rover L Land Rover GP
## 942 Jaguar Land Rover L Land Rover GP
## 943 Toyota LEXUS GPR
## 944 Toyota LEXUS GPR
## 945 Toyota LEXUS GPR
## 946 Toyota LEXUS GPR
## 947 Ford Motor Company Lincoln G
## 948 Ford Motor Company Lincoln G
## 949 Maserati MASERATI GPR
## 950 Maserati MASERATI GPR
## 951 Maserati MASERATI GPR
## 952 Maserati MASERATI GPR
## 953 MAZDA MAZDA G
## 954 MAZDA MAZDA GP
## 955 Mercedes-Benz Mercedes-Benz GPR
## 956 Mercedes-Benz Mercedes-Benz GPR
## 957 Mercedes-Benz Mercedes-Benz GPR
## 958 Mercedes-Benz Mercedes-Benz GPR
## 959 Mercedes-Benz Mercedes-Benz GPR
## 960 Mercedes-Benz Mercedes-Benz GPR
## 961 Mercedes-Benz Mercedes-Benz GPR
## 962 Mercedes-Benz Mercedes-Benz GPR
## 963 Mercedes-Benz Mercedes-Benz GPR
## 964 Mercedes-Benz Mercedes-Benz GPR
## 965 Mercedes-Benz Mercedes-Benz GPR
## 966 Mercedes-Benz Mercedes-Benz GPR
## 967 Mercedes-Benz Mercedes-Benz GPR
## 968 Nissan NISSAN GP
## 969 Nissan NISSAN G
## 970 Porsche Porsche GPR
## 971 Porsche Porsche GPR
## 972 Porsche Porsche GPR
## 973 Porsche Porsche GPR
## 974 Subaru Subaru G
## 975 Subaru Subaru G
## 976 Toyota TOYOTA G
## 977 Toyota TOYOTA G
## 978 Toyota TOYOTA G
## 979 Toyota TOYOTA G
## 980 Toyota TOYOTA G
## 981 Toyota TOYOTA G
## 982 Toyota TOYOTA G
## 983 Toyota TOYOTA G
## 984 Toyota TOYOTA GPR
## 985 Toyota TOYOTA G
## 986 Volvo Volvo Cars of North America, LLC GPR
## 987 Volvo Volvo Cars of North America, LLC GPR
## fuel_type_desc fuel_unit_abrv fuel_unit_desc
## 2 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 3 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 4 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 5 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 6 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 7 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 8 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 9 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 10 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 11 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 12 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 13 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 14 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 15 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 16 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 17 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 18 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 19 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 20 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 21 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 22 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 23 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 24 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 25 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 26 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 27 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 28 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 29 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 30 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 31 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 32 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 33 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 34 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 35 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 36 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 37 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 38 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 39 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 40 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 41 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 42 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 43 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 44 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 45 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 46 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 47 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 48 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 49 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 50 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 51 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 52 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 53 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 54 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 55 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 56 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 57 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 58 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 59 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 60 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 61 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 62 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 63 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 64 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 65 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 66 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 67 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 68 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 69 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 70 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 71 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 72 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 73 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 74 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 75 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 76 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 77 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 78 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 79 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 80 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 81 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 82 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 83 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 84 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 85 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 86 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 87 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 88 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 89 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 90 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 91 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 92 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 93 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 94 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 95 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 96 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 97 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 98 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 99 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 100 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 101 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 102 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 103 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 104 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 105 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 106 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 107 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 108 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 109 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 110 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 111 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 112 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 113 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 114 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 115 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 116 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 117 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 118 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 119 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 120 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 121 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 122 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 123 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 124 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 125 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 126 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 127 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 128 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 129 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 130 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 131 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 132 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 133 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 134 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 135 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 136 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 137 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 138 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 139 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 140 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 141 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 142 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 143 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 144 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 145 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 146 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 147 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 148 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 149 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 150 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 151 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 152 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 153 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 154 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 155 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 156 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 157 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 158 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 159 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 160 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 161 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 162 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 163 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 164 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 165 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 166 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 167 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 168 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 169 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 170 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 171 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 172 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 173 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 174 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 175 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 176 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 177 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 178 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 179 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 180 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 181 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 182 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 183 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 184 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 185 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 186 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 187 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 188 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 189 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 190 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 191 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 192 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 193 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 194 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 195 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 196 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 197 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 198 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 199 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 200 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 201 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 202 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 203 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 204 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 205 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 206 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 207 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 208 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 209 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 210 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 211 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 212 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 213 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 214 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 215 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 216 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 217 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 218 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 219 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 220 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 221 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 222 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 223 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 224 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 225 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 226 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 227 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 228 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 229 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 230 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 231 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 232 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 233 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 234 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 235 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 236 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 237 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 238 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 239 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 240 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 241 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 242 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 243 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 244 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 245 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 246 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 247 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 248 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 249 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 250 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 251 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 252 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 253 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 254 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 255 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 256 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 257 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 258 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 259 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 260 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 261 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 262 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 263 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 264 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 265 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 266 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 267 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 268 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 269 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 270 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 271 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 272 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 273 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 274 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 275 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 276 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 277 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 278 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 279 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 280 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 281 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 282 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 283 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 284 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 285 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 286 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 287 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 288 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 289 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 290 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 291 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 292 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 293 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 294 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 295 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 296 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 297 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 298 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 299 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 300 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 301 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 302 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 303 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 304 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 305 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 306 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 307 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 308 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 309 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 310 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 311 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 312 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 313 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 314 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 315 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 316 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 317 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 318 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 319 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 320 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 321 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 322 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 323 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 324 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 325 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 326 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 327 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 328 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 329 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 330 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 331 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 332 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 333 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 334 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 335 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 336 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 337 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 338 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 339 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 340 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 341 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 342 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 343 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 344 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 345 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 346 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 347 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 348 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 349 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 350 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 351 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 352 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 353 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 354 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 355 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 356 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 357 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 358 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 359 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 360 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 361 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 362 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 363 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 364 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 365 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 366 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 367 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 368 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 369 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 370 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 371 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 372 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 373 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 374 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 375 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 376 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 377 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 378 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 379 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 380 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 381 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 382 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 383 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 384 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 385 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 386 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 387 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 388 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 389 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 390 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 391 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 392 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 393 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 394 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 395 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 396 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 397 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 398 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 399 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 400 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 401 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 402 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 403 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 404 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 405 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 406 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 407 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 408 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 409 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 410 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 411 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 412 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 413 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 414 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 415 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 416 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 417 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 418 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 419 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 420 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 421 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 422 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 423 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 424 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 425 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 426 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 427 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 428 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 429 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 430 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 431 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 432 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 433 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 434 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 435 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 436 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 437 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 438 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 439 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 440 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 441 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 442 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 443 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 444 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 445 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 446 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 447 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 448 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 449 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 450 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 451 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 452 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 453 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 454 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 455 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 456 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 457 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 458 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 459 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 460 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 461 Diesel, ultra low sulfur (15 ppm, maximum) MPG miles per gallon
## 462 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 463 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 464 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 465 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 466 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 467 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 468 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 469 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 470 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 471 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 472 Diesel, ultra low sulfur (15 ppm, maximum) MPG miles per gallon
## 473 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 474 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 475 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 476 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 477 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 478 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 479 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 480 Gasoline (Mid Grade Unleaded Recommended) MPG miles per gallon
## 481 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 482 Gasoline (Mid Grade Unleaded Recommended) MPG miles per gallon
## 483 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 484 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 485 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 486 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 487 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 488 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 489 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 490 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 491 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 492 Diesel, ultra low sulfur (15 ppm, maximum) MPG miles per gallon
## 493 Diesel, ultra low sulfur (15 ppm, maximum) MPG miles per gallon
## 494 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 495 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 496 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 497 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 498 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 499 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 500 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 501 Diesel, ultra low sulfur (15 ppm, maximum) MPG miles per gallon
## 502 Diesel, ultra low sulfur (15 ppm, maximum) MPG miles per gallon
## 503 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 504 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 505 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 506 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 507 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 508 Diesel, ultra low sulfur (15 ppm, maximum) MPG miles per gallon
## 509 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 510 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 511 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 512 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 513 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 514 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 515 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 516 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 517 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 518 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 519 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 520 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 521 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 522 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 523 Diesel, ultra low sulfur (15 ppm, maximum) MPG miles per gallon
## 524 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 525 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 526 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 527 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 528 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 529 Diesel, ultra low sulfur (15 ppm, maximum) MPG miles per gallon
## 530 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 531 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 532 Diesel, ultra low sulfur (15 ppm, maximum) MPG miles per gallon
## 533 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 534 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 535 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 536 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 537 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 538 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 539 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 540 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 541 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 542 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 543 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 544 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 545 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 546 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 547 Gasoline (Mid Grade Unleaded Recommended) MPG miles per gallon
## 548 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 549 Gasoline (Mid Grade Unleaded Recommended) MPG miles per gallon
## 550 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 551 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 552 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 553 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 554 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 555 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 556 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 557 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 558 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 559 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 560 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 561 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 562 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 563 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 564 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 565 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 566 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 567 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 568 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 569 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 570 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 571 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 572 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 573 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 574 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 575 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 576 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 577 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 578 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 579 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 580 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 581 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 582 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 583 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 584 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 585 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 586 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 587 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 588 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 589 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 590 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 591 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 592 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 593 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 594 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 595 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 596 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 597 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 598 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 599 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 600 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 601 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 602 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 603 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 604 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 605 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 606 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 607 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 608 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 609 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 610 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 611 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 612 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 613 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 614 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 615 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 616 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 617 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 618 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 619 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 620 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 621 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 622 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 623 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 624 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 625 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 626 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 627 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 628 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 629 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 630 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 631 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 632 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 633 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 634 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 635 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 636 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 637 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 638 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 639 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 640 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 641 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 642 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 643 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 644 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 645 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 646 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 647 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 648 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 649 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 650 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 651 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 652 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 653 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 654 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 655 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 656 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 657 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 658 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 659 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 660 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 661 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 662 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 663 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 664 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 665 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 666 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 667 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 668 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 669 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 670 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 671 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 672 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 673 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 674 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 675 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 676 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 677 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 678 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 679 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 680 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 681 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 682 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 683 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 684 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 685 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 686 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 687 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 688 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 689 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 690 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 691 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 692 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 693 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 694 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 695 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 696 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 697 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 698 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 699 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 700 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 701 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 702 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 703 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 704 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 705 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 706 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 707 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 708 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 709 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 710 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 711 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 712 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 713 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 714 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 715 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 716 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 717 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 718 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 719 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 720 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 721 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 722 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 723 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 724 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 725 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 726 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 727 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 728 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 729 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 730 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 731 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 732 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 733 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 734 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 735 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 736 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 737 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 738 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 739 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 740 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 741 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 742 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 743 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 744 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 745 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 746 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 747 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 748 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 749 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 750 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 751 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 752 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 753 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 754 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 755 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 756 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 757 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 758 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 759 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 760 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 761 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 762 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 763 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 764 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 765 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 766 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 767 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 768 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 769 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 770 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 771 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 772 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 773 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 774 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 775 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 776 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 777 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 778 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 779 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 780 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 781 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 782 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 783 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 784 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 785 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 786 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 787 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 788 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 789 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 790 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 791 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 792 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 793 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 794 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 795 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 796 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 797 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 798 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 799 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 800 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 801 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 802 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 803 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 804 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 805 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 806 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 807 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 808 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 809 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 810 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 811 Diesel, ultra low sulfur (15 ppm, maximum) MPG miles per gallon
## 812 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 813 Diesel, ultra low sulfur (15 ppm, maximum) MPG miles per gallon
## 814 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 815 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 816 Diesel, ultra low sulfur (15 ppm, maximum) MPG miles per gallon
## 817 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 818 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 819 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 820 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 821 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 822 Gasoline (Mid Grade Unleaded Recommended) MPG miles per gallon
## 823 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 824 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 825 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 826 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 827 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 828 Diesel, ultra low sulfur (15 ppm, maximum) MPG miles per gallon
## 829 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 830 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 831 Diesel, ultra low sulfur (15 ppm, maximum) MPG miles per gallon
## 832 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 833 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 834 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 835 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 836 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 837 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 838 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 839 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 840 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 841 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 842 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 843 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 844 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 845 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 846 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 847 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 848 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 849 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 850 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 851 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 852 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 853 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 854 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 855 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 856 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 857 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 858 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 859 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 860 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 861 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 862 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 863 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 864 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 865 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 866 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 867 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 868 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 869 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 870 Diesel, ultra low sulfur (15 ppm, maximum) MPG miles per gallon
## 871 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 872 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 873 Diesel, ultra low sulfur (15 ppm, maximum) MPG miles per gallon
## 874 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 875 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 876 Diesel, ultra low sulfur (15 ppm, maximum) MPG miles per gallon
## 877 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 878 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 879 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 880 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 881 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 882 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 883 Gasoline (Mid Grade Unleaded Recommended) MPG miles per gallon
## 884 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 885 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 886 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 887 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 888 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 889 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 890 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 891 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 892 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 893 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 894 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 895 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 896 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 897 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 898 Diesel, ultra low sulfur (15 ppm, maximum) MPG miles per gallon
## 899 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 900 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 901 Diesel, ultra low sulfur (15 ppm, maximum) MPG miles per gallon
## 902 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 903 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 904 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 905 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 906 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 907 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 908 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 909 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 910 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 911 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 912 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 913 Gasoline (Mid Grade Unleaded Recommended) MPG miles per gallon
## 914 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 915 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 916 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 917 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 918 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 919 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 920 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 921 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 922 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 923 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 924 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 925 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 926 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 927 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 928 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 929 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 930 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 931 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 932 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 933 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 934 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 935 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 936 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 937 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 938 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 939 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 940 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 941 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 942 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 943 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 944 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 945 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 946 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 947 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 948 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 949 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 950 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 951 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 952 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 953 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 954 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 955 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 956 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 957 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 958 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 959 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 960 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 961 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 962 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 963 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 964 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 965 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 966 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 967 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 968 Gasoline (Premium Unleaded Recommended) MPG miles per gallon
## 969 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 970 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 971 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 972 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 973 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 974 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 975 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 976 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 977 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 978 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 979 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 980 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 981 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 982 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 983 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 984 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 985 Gasoline (Regular Unleaded Recommended) MPG miles per gallon
## 986 Gasoline (Premium Unleaded Required) MPG miles per gallon
## 987 Gasoline (Premium Unleaded Required) MPG miles per gallon
## fuel_annual_cost1 epa_calc_fuel_annual_cost fuel_type_abrv2 fuel_type_desc2
## 2 4600 4600
## 3 2500 2500
## 4 2300 2300
## 5 7150 7150
## 6 3400 3400
## 7 3400 3400
## 8 4300 4300
## 9 4600 4600
## 10 4600 4600
## 11 4600 4600
## 12 4950 4950
## 13 3600 3600
## 14 3600 3600
## 15 3400 3400
## 16 3400 3400
## 17 3600 3600
## 18 3600 3600
## 19 4300 4300
## 20 4300 4300
## 21 4300 4300
## 22 2550 2550
## 23 2850 2850
## 24 3600 3600
## 25 3600 3600
## 26 2200 2200
## 27 2200 2200
## 28 4050 4050
## 29 4050 4050
## 30 2950 2950
## 31 2950 2950
## 32 3200 3200
## 33 3400 3400
## 34 2700 2700
## 35 2950 2950
## 36 3050 3050
## 37 3400 3400
## 38 2950 2950
## 39 3050 3050
## 40 2700 2700
## 41 2950 2950
## 42 3050 3050
## 43 3400 3400
## 44 2950 2950
## 45 3050 3050
## 46 4050 4050
## 47 4050 4050
## 48 4050 4050
## 49 4300 4300
## 50 4050 4050
## 51 4050 4050
## 52 4300 4300
## 53 4300 4300
## 54 2400 2400
## 55 2500 2500
## 56 3050 3050
## 57 3800 3800
## 58 4050 4050
## 59 4600 4600
## 60 3400 3400
## 61 3600 3600
## 62 4050 4050
## 63 4050 4050
## 64 2000 2000
## 65 2100 2100
## 66 2150 2150
## 67 2400 2400
## 68 2300 2300
## 69 3200 3200
## 70 3200 3200
## 71 3200 3200
## 72 3400 3400
## 73 3400 3400
## 74 3400 3400
## 75 3400 3400
## 76 3200 3200
## 77 3200 3200
## 78 3200 3200
## 79 3200 3200
## 80 3200 3200
## 81 3400 3400
## 82 3200 3200
## 83 3400 3400
## 84 3200 3200
## 85 3200 3200
## 86 3050 3050
## 87 3200 3200
## 88 3200 3200
## 89 3200 3200
## 90 3200 3200
## 91 3400 3400
## 92 3200 3200
## 93 3400 3400
## 94 3400 3400
## 95 3200 3200
## 96 3200 3200
## 97 3800 3800
## 98 4050 4050
## 99 4050 4050
## 100 4050 4050
## 101 2600 2600
## 102 2950 2950
## 103 2700 2700
## 104 2950 2950
## 105 1700 1700
## 106 1800 1800
## 107 2400 2400
## 108 2400 2400
## 109 2800 2800
## 110 3050 3050
## 111 2500 2500
## 112 2950 2950
## 113 2700 2700
## 114 3800 3800
## 115 4300 4300
## 116 2150 2150
## 117 2300 2300
## 118 2300 2300
## 119 2300 2300
## 120 2400 2400
## 121 2400 2400
## 122 2700 2700
## 123 2700 2700
## 124 2700 2700
## 125 2700 2700
## 126 3400 3400
## 127 3400 3400
## 128 2500 2500
## 129 2500 2500
## 130 3400 3400
## 131 3600 3600
## 132 3400 3400
## 133 2500 2500
## 134 2400 2400
## 135 2600 2600
## 136 2600 2600
## 137 3600 3600
## 138 3800 3800
## 139 3800 3800
## 140 3400 3400
## 141 3400 3400
## 142 2450 2450
## 143 2700 2700
## 144 4050 4050
## 145 3200 3200
## 146 3400 3400
## 147 4050 4050
## 148 3400 3400
## 149 2100 2100
## 150 2850 2850
## 151 3000 3000
## 152 3000 3000
## 153 3200 3200
## 154 3200 3200
## 155 3200 3200
## 156 2250 2250
## 157 3600 3600
## 158 2200 2200
## 159 2600 2600
## 160 2950 2950
## 161 2800 2800
## 162 2950 2950
## 163 3400 3400
## 164 3200 3200
## 165 3050 3050
## 166 3050 3050
## 167 2800 2800
## 168 2500 2500
## 169 2300 2300
## 170 2500 2500
## 171 2500 2500
## 172 2000 2000
## 173 2100 2100
## 174 2000 2000
## 175 2100 2100
## 176 2100 2100
## 177 2400 2400
## 178 2100 2100
## 179 2400 2400
## 180 2200 2200
## 181 2500 2500
## 182 3600 3600
## 183 2700 2700
## 184 2700 2700
## 185 2600 2600
## 186 3050 3050
## 187 2150 2150
## 188 2400 2400
## 189 2700 2700
## 190 2300 2300
## 191 2400 2400
## 192 2200 2200
## 193 2400 2400
## 194 2300 2300
## 195 2400 2400
## 196 2400 2400
## 197 3600 3600
## 198 3400 3400
## 199 3600 3600
## 200 3400 3400
## 201 2500 2500
## 202 2500 2500
## 203 2400 2400
## 204 2600 2600
## 205 2500 2500
## 206 2600 2600
## 207 2600 2600
## 208 2700 2700
## 209 2800 2800
## 210 3400 3400
## 211 3600 3600
## 212 2800 2800
## 213 2800 2800
## 214 2700 2700
## 215 2600 2600
## 216 2950 2950
## 217 2800 2800
## 218 2950 2950
## 219 3200 3200
## 220 1300 1300
## 221 1300 1300
## 222 1400 1400
## 223 1400 1400
## 224 1750 1750
## 225 2000 2000
## 226 1800 1800
## 227 2800 2800
## 228 2600 2600
## 229 2800 2800
## 230 3050 3050
## 231 3050 3050
## 232 3800 3800
## 233 2150 2150
## 234 2400 2400
## 235 2150 2150
## 236 2300 2300
## 237 1400 1400
## 238 1450 1450
## 239 1550 1550
## 240 1800 1800
## 241 1600 1600
## 242 1550 1550
## 243 1550 1550
## 244 1650 1650
## 245 1150 1150
## 246 1100 1100
## 247 1250 1250
## 248 1100 1100
## 249 1550 1800
## 250 1950 1950
## 251 2600 2600
## 252 2800 2800
## 253 2000 2000
## 254 2000 2000
## 255 1600 1600
## 256 1600 1600
## 257 1650 1650
## 258 2150 2150
## 259 2300 2300
## 260 2400 2400
## 261 3200 3200
## 262 2500 2500
## 263 2150 2150
## 264 2400 2400
## 265 2500 2500
## 266 2600 2600
## 267 2600 2600
## 268 3200 3200
## 269 3800 3800
## 270 2800 2800
## 271 2950 2950
## 272 2950 2950
## 273 3800 3800
## 274 4300 4300
## 275 2150 2150
## 276 2150 2150
## 277 2300 2300
## 278 2700 2700
## 279 2700 2700
## 280 3400 3400
## 281 3800 3800
## 282 3400 3400
## 283 2400 2400
## 284 2950 2950
## 285 2600 2600
## 286 3050 3050
## 287 3050 3050
## 288 4050 4050
## 289 4300 4300
## 290 3050 3050
## 291 1750 1750
## 292 1250 1250
## 293 1500 1500
## 294 1600 1600
## 295 2100 2100
## 296 1550 1550
## 297 1650 1650
## 298 1750 1750
## 299 1500 1500
## 300 1600 1600
## 301 1100 1100
## 302 1000 1000
## 303 2800 2800
## 304 2700 2700
## 305 2800 2800
## 306 2950 2950
## 307 2950 2950
## 308 2950 2950
## 309 2500 2500
## 310 2700 2700
## 311 1800 1800
## 312 2100 2100
## 313 1700 1700
## 314 1600 1600
## 315 1950 1950
## 316 1250 1250
## 317 2100 2100
## 318 2150 2150
## 319 2950 2950
## 320 3050 3050
## 321 2600 2600
## 322 2600 2600
## 323 3200 3200
## 324 3200 3200
## 325 3200 3200
## 326 4050 4050
## 327 1800 1800
## 328 1800 1800
## 329 2100 2100
## 330 1850 1850
## 331 2400 2400
## 332 2600 2600
## 333 2300 2300
## 334 2500 2500
## 335 2200 2200
## 336 2600 2600
## 337 2400 2400
## 338 2300 2300
## 339 2500 2500
## 340 2500 2500
## 341 2500 2500
## 342 1700 1700
## 343 1800 1800
## 344 1750 1750
## 345 1850 1850
## 346 1650 1650
## 347 1600 1600
## 348 1650 1650
## 349 2100 2100
## 350 1800 1800
## 351 3050 3050
## 352 2950 2950
## 353 2100 2100
## 354 1850 1850
## 355 1950 1950
## 356 1050 1050
## 357 1150 1150
## 358 1700 1700
## 359 2150 2150
## 360 1750 1750
## 361 2100 2100
## 362 950 950
## 363 1000 1000
## 364 1100 1100
## 365 1050 1050
## 366 1800 1800
## 367 1300 1300
## 368 2600 2600
## 369 1950 1950
## 370 2700 2700
## 371 2000 2000
## 372 2150 2150
## 373 2950 2950
## 374 3600 3600
## 375 2300 2300
## 376 2400 2400
## 377 3200 3200
## 378 2600 2600
## 379 3400 3400
## 380 3050 3050
## 381 3200 3200
## 382 1700 1700
## 383 1100 1100
## 384 1550 1550
## 385 1650 1650
## 386 1750 1750
## 387 1650 1650
## 388 1700 1700
## 389 1850 1850
## 390 2700 2700
## 391 1950 1950
## 392 2000 2000
## 393 1850 1850
## 394 1150 1150
## 395 1750 1750
## 396 2000 2000
## 397 1950 1950
## 398 3400 3400
## 399 3200 3200
## 400 3400 3400
## 401 4050 4050
## 402 4300 4300
## 403 2700 2700
## 404 3050 3050
## 405 3050 3050
## 406 3050 3050
## 407 3050 3050
## 408 4600 4600
## 409 4600 4600
## 410 4600 4600
## 411 4600 4600
## 412 4600 4600
## 413 2600 2600
## 414 2500 2500
## 415 1800 1800
## 416 1800 1800
## 417 2000 2000
## 418 1950 1950
## 419 1800 1800
## 420 1750 1750
## 421 4050 4050
## 422 2700 2700
## 423 1800 1800
## 424 1850 1850
## 425 2400 2400
## 426 2600 2600
## 427 3800 3800
## 428 2800 2800
## 429 2600 2600
## 430 2350 2350
## 431 2350 2350
## 432 4600 4600
## 433 4600 4600
## 434 2600 2600
## 435 2450 2450
## 436 2550 2550
## 437 2100 2100
## 438 1450 1450
## 439 2700 2700
## 440 2350 2350
## 441 2350 2350
## 442 2450 2450
## 443 2700 2700
## 444 2700 2700
## 445 3000 3000
## 446 3200 3200
## 447 3400 3400
## 448 2150 2150
## 449 2550 2550
## 450 2850 2850
## 451 3000 3000
## 452 3200 3200
## 453 3400 3400
## 454 2550 2550
## 455 2700 2700
## 456 2550 2550
## 457 2550 2550
## 458 2550 2550
## 459 2850 2850
## 460 2700 2700
## 461 2550 2550
## 462 3000 3000
## 463 3400 3400
## 464 3000 3000
## 465 3000 3000 E Ethanol (E85)
## 466 2550 2550
## 467 2700 2700
## 468 2850 2850
## 469 2450 2450
## 470 2850 2850
## 471 2700 2700
## 472 2650 2650
## 473 3000 3000
## 474 3400 3400
## 475 3000 3000
## 476 3000 3000 E Ethanol (E85)
## 477 2550 2550
## 478 3800 3800
## 479 2450 2450
## 480 3050 3050
## 481 2700 2700
## 482 3550 3550
## 483 2350 2350
## 484 2700 2700
## 485 2700 2700
## 486 2450 2450
## 487 2950 2950
## 488 3200 3200
## 489 3200 3200
## 490 3000 3000
## 491 2850 2850
## 492 2750 2750
## 493 2850 2850
## 494 3200 3200
## 495 3200 3200
## 496 3400 3400
## 497 3200 3200 E Ethanol (E85)
## 498 3800 3800
## 499 3200 3200
## 500 3400 3400
## 501 3000 3000
## 502 3000 3000
## 503 3400 3400
## 504 3400 3400
## 505 3400 3400
## 506 3200 3200 E Ethanol (E85)
## 507 4300 4300
## 508 3150 3150
## 509 4300 4300
## 510 2700 2700
## 511 2850 2850
## 512 2850 2850
## 513 2350 2350
## 514 3000 3000
## 515 3200 3200
## 516 3400 3400
## 517 4500 4500
## 518 2450 2450
## 519 2700 2700
## 520 3200 3200
## 521 3200 3200
## 522 3000 3000
## 523 2750 2750
## 524 3200 3200
## 525 3200 3200
## 526 3400 3400
## 527 3200 3200 E Ethanol (E85)
## 528 4050 4050
## 529 3450 3450
## 530 4300 4300
## 531 3400 3400
## 532 3000 3000
## 533 3400 3400
## 534 3400 3400
## 535 3400 3400
## 536 3200 3200 E Ethanol (E85)
## 537 4300 4300
## 538 2550 2550
## 539 2700 2700
## 540 2850 2850
## 541 3000 3000
## 542 2700 2700
## 543 2850 2850
## 544 3800 3800
## 545 4050 4050
## 546 2550 2550
## 547 3200 3200
## 548 2850 2850
## 549 3550 3550
## 550 5400 5400
## 551 2350 2350
## 552 2250 2250
## 553 2850 2850
## 554 2850 2850
## 555 2700 2700
## 556 3400 3400
## 557 3200 3200
## 558 2850 2850
## 559 3400 3400
## 560 3050 3050
## 561 3050 3050
## 562 2300 2300
## 563 2300 2300
## 564 3050 3050
## 565 3050 3050
## 566 3400 3400
## 567 3600 3600
## 568 3600 3600
## 569 3600 3600
## 570 2450 2450
## 571 2450 2450
## 572 2450 2450
## 573 2450 2450
## 574 1500 1500
## 575 2700 2700
## 576 1550 1550
## 577 2950 2950
## 578 2600 2600
## 579 2600 2600
## 580 1800 1800
## 581 1800 1800
## 582 2500 2500
## 583 2700 2700
## 584 2550 2550
## 585 2800 2800
## 586 2550 2550
## 587 2150 2150
## 588 2450 2450
## 589 1950 1950
## 590 1750 1750
## 591 1800 1800
## 592 1400 1400
## 593 2100 2100
## 594 1800 1800
## 595 1350 1350
## 596 2450 2450
## 597 1950 1950
## 598 1750 1750
## 599 1750 1750
## 600 2450 2450
## 601 2350 2350
## 602 2250 2250
## 603 1500 1500
## 604 1950 1950
## 605 1750 1750
## 606 2500 2500
## 607 1100 1100
## 608 1000 1000
## 609 1750 1750
## 610 2350 2350
## 611 2100 2100
## 612 1450 1450
## 613 1950 1950
## 614 2450 2450
## 615 1950 1950
## 616 2600 2600
## 617 2150 2150
## 618 2400 2400
## 619 2000 2000
## 620 2100 2100
## 621 2000 2000
## 622 2350 2350
## 623 1650 1650
## 624 1700 1700
## 625 1700 1700
## 626 2150 2150
## 627 2250 2250
## 628 1500 1500
## 629 1800 1800
## 630 2350 2350
## 631 2350 2350
## 632 1750 1750
## 633 2100 2100
## 634 2000 2000
## 635 3050 3050
## 636 2800 2800
## 637 2800 2800
## 638 2700 2700
## 639 3400 3400
## 640 2150 2150
## 641 2350 2350
## 642 2500 2500
## 643 2700 2700
## 644 2700 2700
## 645 3050 3050
## 646 3050 3050
## 647 2500 2500
## 648 2300 2300
## 649 2500 2500
## 650 2300 2300
## 651 3800 3800
## 652 3800 3800
## 653 2800 2800
## 654 2700 2700
## 655 3800 3800
## 656 3800 3800
## 657 2800 2800
## 658 2700 2700
## 659 2000 2000
## 660 2250 2250
## 661 2600 2600
## 662 2800 2800
## 663 2550 2550
## 664 2800 2800
## 665 2550 2550
## 666 2250 2250
## 667 2550 2550
## 668 2100 2100
## 669 2000 2000
## 670 2250 2250
## 671 2700 2700
## 672 2700 2700
## 673 2700 2700
## 674 3200 3200
## 675 3200 3200
## 676 3000 3000
## 677 3200 3200
## 678 3000 3000
## 679 3000 3000
## 680 3200 3200
## 681 3200 3200
## 682 2100 2100
## 683 2350 2350
## 684 2350 2350
## 685 2350 2350
## 686 2550 2550
## 687 1950 1950
## 688 2100 2100
## 689 1400 1400
## 690 2700 2700
## 691 2950 2950
## 692 3200 3200
## 693 2150 2150
## 694 1850 1850
## 695 1450 1450
## 696 2550 2550
## 697 2100 2100
## 698 2000 2000
## 699 1950 1950
## 700 2550 2550
## 701 2450 2450
## 702 2350 2350
## 703 2350 2350
## 704 2450 2450
## 705 1600 1600
## 706 2150 2150
## 707 1450 1450
## 708 1400 1400
## 709 2600 2600
## 710 2600 2600
## 711 2800 2800
## 712 2700 2700
## 713 3050 3050
## 714 3800 3800
## 715 2000 2000
## 716 2550 2550
## 717 2700 2700
## 718 2850 2850
## 719 2550 2550
## 720 2700 2700
## 721 2850 2850
## 722 4600 4600
## 723 3000 3000
## 724 3200 3200
## 725 2100 2100
## 726 1850 1850
## 727 2350 2350
## 728 2150 2150
## 729 1600 1600
## 730 2150 2150
## 731 1400 1400
## 732 1250 1250
## 733 2100 2100
## 734 2700 2700
## 735 3200 3200
## 736 2950 2950
## 737 2800 2800
## 738 2950 2950
## 739 3050 3050
## 740 1950 1950
## 741 2700 2700
## 742 2700 2700
## 743 1650 1650
## 744 1650 1650
## 745 2700 2700
## 746 1800 1800
## 747 2400 2400
## 748 2250 2250
## 749 2250 2250
## 750 1800 1800
## 751 2600 2600
## 752 2600 2600
## 753 3200 3200
## 754 2150 2150
## 755 1850 1850
## 756 2150 2150
## 757 1950 1950
## 758 2250 2250
## 759 2150 2150
## 760 2000 2000
## 761 3050 3050
## 762 3050 3050
## 763 2400 2400
## 764 2400 2400
## 765 2400 2400
## 766 2500 2500
## 767 2700 2700
## 768 2800 2800
## 769 2100 2100
## 770 2150 2150
## 771 2100 2100
## 772 2100 2100
## 773 2150 2150
## 774 2350 2350
## 775 3050 3050
## 776 1750 1750
## 777 1750 1750
## 778 3050 3050
## 779 3400 3400
## 780 3400 3400
## 781 3050 3050
## 782 1850 1850
## 783 1850 1850
## 784 2000 2000
## 785 1850 1850
## 786 2100 2100
## 787 2150 2150
## 788 1950 1950
## 789 2350 2350
## 790 1800 1800
## 791 1300 1300
## 792 2250 2250
## 793 1950 1950
## 794 1850 1850
## 795 1800 1800
## 796 1950 1950
## 797 1400 1400
## 798 1450 1450
## 799 1400 1400
## 800 2700 2700
## 801 2450 2450
## 802 2450 2450
## 803 2550 2550
## 804 2000 2000
## 805 2150 2150
## 806 2250 2250
## 807 2500 2500
## 808 2600 2600
## 809 2600 2600
## 810 2550 2550
## 811 2850 2850
## 812 4050 4050
## 813 2850 2850
## 814 3200 3200
## 815 4050 4050
## 816 2750 2750
## 817 3200 3200
## 818 4050 4050
## 819 2350 2350
## 820 2550 2550
## 821 2550 2550
## 822 3550 3550
## 823 2850 2850
## 824 2250 2250
## 825 2550 2550
## 826 2700 2700
## 827 2350 2350
## 828 2850 2850
## 829 3200 3200
## 830 4050 4050
## 831 2850 2850
## 832 3200 3200
## 833 4050 4050
## 834 2800 2800
## 835 4050 4050
## 836 2450 2450
## 837 2550 2550
## 838 2700 2700
## 839 2700 2700
## 840 2800 2800
## 841 2550 2550
## 842 4050 4050
## 843 3200 3200
## 844 1500 1500
## 845 1600 1600
## 846 2250 2250
## 847 2250 2250
## 848 2450 2450
## 849 3400 3400
## 850 3800 3800
## 851 4050 4050
## 852 3050 3050
## 853 3050 3050
## 854 3400 3400
## 855 4300 4300
## 856 3800 3800
## 857 3800 3800
## 858 4050 4050
## 859 4050 4050
## 860 3800 3800
## 861 4300 4300
## 862 3400 3400
## 863 2600 2600
## 864 4300 4300
## 865 3400 3400
## 866 2700 2700
## 867 3600 3600
## 868 2950 2950
## 869 2700 2700
## 870 3000 3000
## 871 4050 4050
## 872 4950 4950
## 873 3000 3000
## 874 3400 3400
## 875 4050 4050
## 876 3000 3000
## 877 3200 3200
## 878 3400 3400
## 879 4050 4050
## 880 2550 2550
## 881 2700 2700
## 882 2550 2550
## 883 3550 3550
## 884 4950 4950
## 885 4300 4300
## 886 5400 5400
## 887 3600 3600
## 888 3000 3000
## 889 3200 3200
## 890 2350 2350
## 891 2700 2700
## 892 2700 2700
## 893 2700 2700 E Ethanol (E85)
## 894 2550 2550
## 895 2950 2950
## 896 3200 3200
## 897 2550 2550
## 898 3000 3000
## 899 3200 3200
## 900 4050 4050
## 901 3000 3000
## 902 3400 3400
## 903 4050 4050
## 904 2550 2550
## 905 2550 2550
## 906 2700 2700
## 907 4300 4300
## 908 4600 4600
## 909 2950 2950
## 910 4300 4300
## 911 2450 2450
## 912 2550 2550
## 913 3550 3550
## 914 3800 3800
## 915 4300 4300
## 916 3800 3800
## 917 2850 2850
## 918 2850 2850
## 919 4050 4050
## 920 3400 3400
## 921 4050 4050
## 922 3600 3600
## 923 3800 3800
## 924 3600 3600
## 925 3600 3600
## 926 3400 3400
## 927 4050 4050
## 928 3200 3200
## 929 3050 3050
## 930 3400 3400
## 931 3600 3600
## 932 3400 3400
## 933 3200 3200
## 934 3200 3200
## 935 3200 3200
## 936 3200 3200
## 937 3400 3400
## 938 3050 3050
## 939 3050 3050
## 940 3600 3600
## 941 3600 3600
## 942 3600 3600
## 943 3800 3800
## 944 3400 3400
## 945 2800 2800
## 946 2400 2400
## 947 2700 2700
## 948 3000 3000
## 949 3600 3600
## 950 3600 3600
## 951 4050 4050
## 952 4050 4050
## 953 2150 2150
## 954 2600 2600
## 955 4600 4600
## 956 5850 5850
## 957 3200 3200
## 958 3200 3200
## 959 4050 4050
## 960 4050 4050
## 961 4050 4050
## 962 4600 4600
## 963 2950 2950
## 964 3800 3800
## 965 3050 3050
## 966 4050 4050
## 967 4050 4050
## 968 4300 4300
## 969 2450 2450
## 970 3400 3400
## 971 3400 3400
## 972 3800 3800
## 973 3800 3800
## 974 2450 2450
## 975 2550 2550
## 976 3200 3200
## 977 3200 3200
## 978 2350 2350
## 979 2450 2450
## 980 2000 2000
## 981 1600 1600
## 982 1550 1550
## 983 1550 1550
## 984 2800 2800
## 985 2700 2700
## 986 2700 2700
## 987 2800 2800
## fuel_unit_abrv2 fuel_unit_desc2 fuel_annual_cost2
## 2 0
## 3 0
## 4 0
## 5 0
## 6 0
## 7 0
## 8 0
## 9 0
## 10 0
## 11 0
## 12 0
## 13 0
## 14 0
## 15 0
## 16 0
## 17 0
## 18 0
## 19 0
## 20 0
## 21 0
## 22 0
## 23 0
## 24 0
## 25 0
## 26 0
## 27 0
## 28 0
## 29 0
## 30 0
## 31 0
## 32 0
## 33 0
## 34 0
## 35 0
## 36 0
## 37 0
## 38 0
## 39 0
## 40 0
## 41 0
## 42 0
## 43 0
## 44 0
## 45 0
## 46 0
## 47 0
## 48 0
## 49 0
## 50 0
## 51 0
## 52 0
## 53 0
## 54 0
## 55 0
## 56 0
## 57 0
## 58 0
## 59 0
## 60 0
## 61 0
## 62 0
## 63 0
## 64 0
## 65 0
## 66 0
## 67 0
## 68 0
## 69 0
## 70 0
## 71 0
## 72 0
## 73 0
## 74 0
## 75 0
## 76 0
## 77 0
## 78 0
## 79 0
## 80 0
## 81 0
## 82 0
## 83 0
## 84 0
## 85 0
## 86 0
## 87 0
## 88 0
## 89 0
## 90 0
## 91 0
## 92 0
## 93 0
## 94 0
## 95 0
## 96 0
## 97 0
## 98 0
## 99 0
## 100 0
## 101 0
## 102 0
## 103 0
## 104 0
## 105 0
## 106 0
## 107 0
## 108 0
## 109 0
## 110 0
## 111 0
## 112 0
## 113 0
## 114 0
## 115 0
## 116 0
## 117 0
## 118 0
## 119 0
## 120 0
## 121 0
## 122 0
## 123 0
## 124 0
## 125 0
## 126 0
## 127 0
## 128 0
## 129 0
## 130 0
## 131 0
## 132 0
## 133 0
## 134 0
## 135 0
## 136 0
## 137 0
## 138 0
## 139 0
## 140 0
## 141 0
## 142 0
## 143 0
## 144 0
## 145 0
## 146 0
## 147 0
## 148 0
## 149 0
## 150 0
## 151 0
## 152 0
## 153 0
## 154 0
## 155 0
## 156 0
## 157 0
## 158 0
## 159 0
## 160 0
## 161 0
## 162 0
## 163 0
## 164 0
## 165 0
## 166 0
## 167 0
## 168 0
## 169 0
## 170 0
## 171 0
## 172 0
## 173 0
## 174 0
## 175 0
## 176 0
## 177 0
## 178 0
## 179 0
## 180 0
## 181 0
## 182 0
## 183 0
## 184 0
## 185 0
## 186 0
## 187 0
## 188 0
## 189 0
## 190 0
## 191 0
## 192 0
## 193 0
## 194 0
## 195 0
## 196 0
## 197 0
## 198 0
## 199 0
## 200 0
## 201 0
## 202 0
## 203 0
## 204 0
## 205 0
## 206 0
## 207 0
## 208 0
## 209 0
## 210 0
## 211 0
## 212 0
## 213 0
## 214 0
## 215 0
## 216 0
## 217 0
## 218 0
## 219 0
## 220 0
## 221 0
## 222 0
## 223 0
## 224 0
## 225 0
## 226 0
## 227 0
## 228 0
## 229 0
## 230 0
## 231 0
## 232 0
## 233 0
## 234 0
## 235 0
## 236 0
## 237 0
## 238 0
## 239 0
## 240 0
## 241 0
## 242 0
## 243 0
## 244 0
## 245 0
## 246 0
## 247 0
## 248 0
## 249 0
## 250 0
## 251 0
## 252 0
## 253 0
## 254 0
## 255 0
## 256 0
## 257 0
## 258 0
## 259 0
## 260 0
## 261 0
## 262 0
## 263 0
## 264 0
## 265 0
## 266 0
## 267 0
## 268 0
## 269 0
## 270 0
## 271 0
## 272 0
## 273 0
## 274 0
## 275 0
## 276 0
## 277 0
## 278 0
## 279 0
## 280 0
## 281 0
## 282 0
## 283 0
## 284 0
## 285 0
## 286 0
## 287 0
## 288 0
## 289 0
## 290 0
## 291 0
## 292 0
## 293 0
## 294 0
## 295 0
## 296 0
## 297 0
## 298 0
## 299 0
## 300 0
## 301 0
## 302 0
## 303 0
## 304 0
## 305 0
## 306 0
## 307 0
## 308 0
## 309 0
## 310 0
## 311 0
## 312 0
## 313 0
## 314 0
## 315 0
## 316 0
## 317 0
## 318 0
## 319 0
## 320 0
## 321 0
## 322 0
## 323 0
## 324 0
## 325 0
## 326 0
## 327 0
## 328 0
## 329 0
## 330 0
## 331 0
## 332 0
## 333 0
## 334 0
## 335 0
## 336 0
## 337 0
## 338 0
## 339 0
## 340 0
## 341 0
## 342 0
## 343 0
## 344 0
## 345 0
## 346 0
## 347 0
## 348 0
## 349 0
## 350 0
## 351 0
## 352 0
## 353 0
## 354 0
## 355 0
## 356 0
## 357 0
## 358 0
## 359 0
## 360 0
## 361 0
## 362 0
## 363 0
## 364 0
## 365 0
## 366 0
## 367 0
## 368 0
## 369 0
## 370 0
## 371 0
## 372 0
## 373 0
## 374 0
## 375 0
## 376 0
## 377 0
## 378 0
## 379 0
## 380 0
## 381 0
## 382 0
## 383 0
## 384 0
## 385 0
## 386 0
## 387 0
## 388 0
## 389 0
## 390 0
## 391 0
## 392 0
## 393 0
## 394 0
## 395 0
## 396 0
## 397 0
## 398 0
## 399 0
## 400 0
## 401 0
## 402 0
## 403 0
## 404 0
## 405 0
## 406 0
## 407 0
## 408 0
## 409 0
## 410 0
## 411 0
## 412 0
## 413 0
## 414 0
## 415 0
## 416 0
## 417 0
## 418 0
## 419 0
## 420 0
## 421 0
## 422 0
## 423 0
## 424 0
## 425 0
## 426 0
## 427 0
## 428 0
## 429 0
## 430 0
## 431 0
## 432 0
## 433 0
## 434 0
## 435 0
## 436 0
## 437 0
## 438 0
## 439 0
## 440 0
## 441 0
## 442 0
## 443 0
## 444 0
## 445 0
## 446 0
## 447 0
## 448 0
## 449 0
## 450 0
## 451 0
## 452 0
## 453 0
## 454 0
## 455 0
## 456 0
## 457 0
## 458 0
## 459 0
## 460 0
## 461 0
## 462 0
## 463 0
## 464 0
## 465 MPG miles per gallon 3650
## 466 0
## 467 0
## 468 0
## 469 0
## 470 0
## 471 0
## 472 0
## 473 0
## 474 0
## 475 0
## 476 MPG miles per gallon 3650
## 477 0
## 478 0
## 479 0
## 480 0
## 481 0
## 482 0
## 483 0
## 484 0
## 485 0
## 486 0
## 487 0
## 488 0
## 489 0
## 490 0
## 491 0
## 492 0
## 493 0
## 494 0
## 495 0
## 496 0
## 497 MPG miles per gallon 3950
## 498 0
## 499 0
## 500 0
## 501 0
## 502 0
## 503 0
## 504 0
## 505 0
## 506 MPG miles per gallon 3950
## 507 0
## 508 0
## 509 0
## 510 0
## 511 0
## 512 0
## 513 0
## 514 0
## 515 0
## 516 0
## 517 0
## 518 0
## 519 0
## 520 0
## 521 0
## 522 0
## 523 0
## 524 0
## 525 0
## 526 0
## 527 MPG miles per gallon 3950
## 528 0
## 529 0
## 530 0
## 531 0
## 532 0
## 533 0
## 534 0
## 535 0
## 536 MPG miles per gallon 3950
## 537 0
## 538 0
## 539 0
## 540 0
## 541 0
## 542 0
## 543 0
## 544 0
## 545 0
## 546 0
## 547 0
## 548 0
## 549 0
## 550 0
## 551 0
## 552 0
## 553 0
## 554 0
## 555 0
## 556 0
## 557 0
## 558 0
## 559 0
## 560 0
## 561 0
## 562 0
## 563 0
## 564 0
## 565 0
## 566 0
## 567 0
## 568 0
## 569 0
## 570 0
## 571 0
## 572 0
## 573 0
## 574 0
## 575 0
## 576 0
## 577 0
## 578 0
## 579 0
## 580 0
## 581 0
## 582 0
## 583 0
## 584 0
## 585 0
## 586 0
## 587 0
## 588 0
## 589 0
## 590 0
## 591 0
## 592 0
## 593 0
## 594 0
## 595 0
## 596 0
## 597 0
## 598 0
## 599 0
## 600 0
## 601 0
## 602 0
## 603 0
## 604 0
## 605 0
## 606 0
## 607 0
## 608 0
## 609 0
## 610 0
## 611 0
## 612 0
## 613 0
## 614 0
## 615 0
## 616 0
## 617 0
## 618 0
## 619 0
## 620 0
## 621 0
## 622 0
## 623 0
## 624 0
## 625 0
## 626 0
## 627 0
## 628 0
## 629 0
## 630 0
## 631 0
## 632 0
## 633 0
## 634 0
## 635 0
## 636 0
## 637 0
## 638 0
## 639 0
## 640 0
## 641 0
## 642 0
## 643 0
## 644 0
## 645 0
## 646 0
## 647 0
## 648 0
## 649 0
## 650 0
## 651 0
## 652 0
## 653 0
## 654 0
## 655 0
## 656 0
## 657 0
## 658 0
## 659 0
## 660 0
## 661 0
## 662 0
## 663 0
## 664 0
## 665 0
## 666 0
## 667 0
## 668 0
## 669 0
## 670 0
## 671 0
## 672 0
## 673 0
## 674 0
## 675 0
## 676 0
## 677 0
## 678 0
## 679 0
## 680 0
## 681 0
## 682 0
## 683 0
## 684 0
## 685 0
## 686 0
## 687 0
## 688 0
## 689 0
## 690 0
## 691 0
## 692 0
## 693 0
## 694 0
## 695 0
## 696 0
## 697 0
## 698 0
## 699 0
## 700 0
## 701 0
## 702 0
## 703 0
## 704 0
## 705 0
## 706 0
## 707 0
## 708 0
## 709 0
## 710 0
## 711 0
## 712 0
## 713 0
## 714 0
## 715 0
## 716 0
## 717 0
## 718 0
## 719 0
## 720 0
## 721 0
## 722 0
## 723 0
## 724 0
## 725 0
## 726 0
## 727 0
## 728 0
## 729 0
## 730 0
## 731 0
## 732 0
## 733 0
## 734 0
## 735 0
## 736 0
## 737 0
## 738 0
## 739 0
## 740 0
## 741 0
## 742 0
## 743 0
## 744 0
## 745 0
## 746 0
## 747 0
## 748 0
## 749 0
## 750 0
## 751 0
## 752 0
## 753 0
## 754 0
## 755 0
## 756 0
## 757 0
## 758 0
## 759 0
## 760 0
## 761 0
## 762 0
## 763 0
## 764 0
## 765 0
## 766 0
## 767 0
## 768 0
## 769 0
## 770 0
## 771 0
## 772 0
## 773 0
## 774 0
## 775 0
## 776 0
## 777 0
## 778 0
## 779 0
## 780 0
## 781 0
## 782 0
## 783 0
## 784 0
## 785 0
## 786 0
## 787 0
## 788 0
## 789 0
## 790 0
## 791 0
## 792 0
## 793 0
## 794 0
## 795 0
## 796 0
## 797 0
## 798 0
## 799 0
## 800 0
## 801 0
## 802 0
## 803 0
## 804 0
## 805 0
## 806 0
## 807 0
## 808 0
## 809 0
## 810 0
## 811 0
## 812 0
## 813 0
## 814 0
## 815 0
## 816 0
## 817 0
## 818 0
## 819 0
## 820 0
## 821 0
## 822 0
## 823 0
## 824 0
## 825 0
## 826 0
## 827 0
## 828 0
## 829 0
## 830 0
## 831 0
## 832 0
## 833 0
## 834 0
## 835 0
## 836 0
## 837 0
## 838 0
## 839 0
## 840 0
## 841 0
## 842 0
## 843 0
## 844 0
## 845 0
## 846 0
## 847 0
## 848 0
## 849 0
## 850 0
## 851 0
## 852 0
## 853 0
## 854 0
## 855 0
## 856 0
## 857 0
## 858 0
## 859 0
## 860 0
## 861 0
## 862 0
## 863 0
## 864 0
## 865 0
## 866 0
## 867 0
## 868 0
## 869 0
## 870 0
## 871 0
## 872 0
## 873 0
## 874 0
## 875 0
## 876 0
## 877 0
## 878 0
## 879 0
## 880 0
## 881 0
## 882 0
## 883 0
## 884 0
## 885 0
## 886 0
## 887 0
## 888 0
## 889 0
## 890 0
## 891 0
## 892 0
## 893 MPG miles per gallon 3150
## 894 0
## 895 0
## 896 0
## 897 0
## 898 0
## 899 0
## 900 0
## 901 0
## 902 0
## 903 0
## 904 0
## 905 0
## 906 0
## 907 0
## 908 0
## 909 0
## 910 0
## 911 0
## 912 0
## 913 0
## 914 0
## 915 0
## 916 0
## 917 0
## 918 0
## 919 0
## 920 0
## 921 0
## 922 0
## 923 0
## 924 0
## 925 0
## 926 0
## 927 0
## 928 0
## 929 0
## 930 0
## 931 0
## 932 0
## 933 0
## 934 0
## 935 0
## 936 0
## 937 0
## 938 0
## 939 0
## 940 0
## 941 0
## 942 0
## 943 0
## 944 0
## 945 0
## 946 0
## 947 0
## 948 0
## 949 0
## 950 0
## 951 0
## 952 0
## 953 0
## 954 0
## 955 0
## 956 0
## 957 0
## 958 0
## 959 0
## 960 0
## 961 0
## 962 0
## 963 0
## 964 0
## 965 0
## 966 0
## 967 0
## 968 0
## 969 0
## 970 0
## 971 0
## 972 0
## 973 0
## 974 0
## 975 0
## 976 0
## 977 0
## 978 0
## 979 0
## 980 0
## 981 0
## 982 0
## 983 0
## 984 0
## 985 0
## 986 0
## 987 0
## epa_calc_fuel_annual_cost2 fuel_annual_cost
## 2 4600
## 3 2500
## 4 2300
## 5 7150
## 6 3400
## 7 3400
## 8 4300
## 9 4600
## 10 4600
## 11 4600
## 12 4950
## 13 3600
## 14 3600
## 15 3400
## 16 3400
## 17 3600
## 18 3600
## 19 4300
## 20 4300
## 21 4300
## 22 2550
## 23 2850
## 24 3600
## 25 3600
## 26 2200
## 27 2200
## 28 4050
## 29 4050
## 30 2950
## 31 2950
## 32 3200
## 33 3400
## 34 2700
## 35 2950
## 36 3050
## 37 3400
## 38 2950
## 39 3050
## 40 2700
## 41 2950
## 42 3050
## 43 3400
## 44 2950
## 45 3050
## 46 4050
## 47 4050
## 48 4050
## 49 4300
## 50 4050
## 51 4050
## 52 4300
## 53 4300
## 54 2400
## 55 2500
## 56 3050
## 57 3800
## 58 4050
## 59 4600
## 60 3400
## 61 3600
## 62 4050
## 63 4050
## 64 2000
## 65 2100
## 66 2150
## 67 2400
## 68 2300
## 69 3200
## 70 3200
## 71 3200
## 72 3400
## 73 3400
## 74 3400
## 75 3400
## 76 3200
## 77 3200
## 78 3200
## 79 3200
## 80 3200
## 81 3400
## 82 3200
## 83 3400
## 84 3200
## 85 3200
## 86 3050
## 87 3200
## 88 3200
## 89 3200
## 90 3200
## 91 3400
## 92 3200
## 93 3400
## 94 3400
## 95 3200
## 96 3200
## 97 3800
## 98 4050
## 99 4050
## 100 4050
## 101 2600
## 102 2950
## 103 2700
## 104 2950
## 105 1700
## 106 1800
## 107 2400
## 108 2400
## 109 2800
## 110 3050
## 111 2500
## 112 2950
## 113 2700
## 114 3800
## 115 4300
## 116 2150
## 117 2300
## 118 2300
## 119 2300
## 120 2400
## 121 2400
## 122 2700
## 123 2700
## 124 2700
## 125 2700
## 126 3400
## 127 3400
## 128 2500
## 129 2500
## 130 3400
## 131 3600
## 132 3400
## 133 2500
## 134 2400
## 135 2600
## 136 2600
## 137 3600
## 138 3800
## 139 3800
## 140 3400
## 141 3400
## 142 2450
## 143 2700
## 144 4050
## 145 3200
## 146 3400
## 147 4050
## 148 3400
## 149 2100
## 150 2850
## 151 3000
## 152 3000
## 153 3200
## 154 3200
## 155 3200
## 156 2250
## 157 3600
## 158 2200
## 159 2600
## 160 2950
## 161 2800
## 162 2950
## 163 3400
## 164 3200
## 165 3050
## 166 3050
## 167 2800
## 168 2500
## 169 2300
## 170 2500
## 171 2500
## 172 2000
## 173 2100
## 174 2000
## 175 2100
## 176 2100
## 177 2400
## 178 2100
## 179 2400
## 180 2200
## 181 2500
## 182 3600
## 183 2700
## 184 2700
## 185 2600
## 186 3050
## 187 2150
## 188 2400
## 189 2700
## 190 2300
## 191 2400
## 192 2200
## 193 2400
## 194 2300
## 195 2400
## 196 2400
## 197 3600
## 198 3400
## 199 3600
## 200 3400
## 201 2500
## 202 2500
## 203 2400
## 204 2600
## 205 2500
## 206 2600
## 207 2600
## 208 2700
## 209 2800
## 210 3400
## 211 3600
## 212 2800
## 213 2800
## 214 2700
## 215 2600
## 216 2950
## 217 2800
## 218 2950
## 219 3200
## 220 1300
## 221 1300
## 222 1400
## 223 1400
## 224 1750
## 225 2000
## 226 1800
## 227 2800
## 228 2600
## 229 2800
## 230 3050
## 231 3050
## 232 3800
## 233 2150
## 234 2400
## 235 2150
## 236 2300
## 237 1400
## 238 1450
## 239 1550
## 240 1800
## 241 1600
## 242 1550
## 243 1550
## 244 1650
## 245 1150
## 246 1100
## 247 1250
## 248 1100
## 249 1550
## 250 1950
## 251 2600
## 252 2800
## 253 2000
## 254 2000
## 255 1600
## 256 1600
## 257 1650
## 258 2150
## 259 2300
## 260 2400
## 261 3200
## 262 2500
## 263 2150
## 264 2400
## 265 2500
## 266 2600
## 267 2600
## 268 3200
## 269 3800
## 270 2800
## 271 2950
## 272 2950
## 273 3800
## 274 4300
## 275 2150
## 276 2150
## 277 2300
## 278 2700
## 279 2700
## 280 3400
## 281 3800
## 282 3400
## 283 2400
## 284 2950
## 285 2600
## 286 3050
## 287 3050
## 288 4050
## 289 4300
## 290 3050
## 291 1750
## 292 1250
## 293 1500
## 294 1600
## 295 2100
## 296 1550
## 297 1650
## 298 1750
## 299 1500
## 300 1600
## 301 1100
## 302 1000
## 303 2800
## 304 2700
## 305 2800
## 306 2950
## 307 2950
## 308 2950
## 309 2500
## 310 2700
## 311 1800
## 312 2100
## 313 1700
## 314 1600
## 315 1950
## 316 1250
## 317 2100
## 318 2150
## 319 2950
## 320 3050
## 321 2600
## 322 2600
## 323 3200
## 324 3200
## 325 3200
## 326 4050
## 327 1800
## 328 1800
## 329 2100
## 330 1850
## 331 2400
## 332 2600
## 333 2300
## 334 2500
## 335 2200
## 336 2600
## 337 2400
## 338 2300
## 339 2500
## 340 2500
## 341 2500
## 342 1700
## 343 1800
## 344 1750
## 345 1850
## 346 1650
## 347 1600
## 348 1650
## 349 2100
## 350 1800
## 351 3050
## 352 2950
## 353 2100
## 354 1850
## 355 1950
## 356 1050
## 357 1150
## 358 1700
## 359 2150
## 360 1750
## 361 2100
## 362 950
## 363 1000
## 364 1100
## 365 1050
## 366 1800
## 367 1300
## 368 2600
## 369 1950
## 370 2700
## 371 2000
## 372 2150
## 373 2950
## 374 3600
## 375 2300
## 376 2400
## 377 3200
## 378 2600
## 379 3400
## 380 3050
## 381 3200
## 382 1700
## 383 1100
## 384 1550
## 385 1650
## 386 1750
## 387 1650
## 388 1700
## 389 1850
## 390 2700
## 391 1950
## 392 2000
## 393 1850
## 394 1150
## 395 1750
## 396 2000
## 397 1950
## 398 3400
## 399 3200
## 400 3400
## 401 4050
## 402 4300
## 403 2700
## 404 3050
## 405 3050
## 406 3050
## 407 3050
## 408 4600
## 409 4600
## 410 4600
## 411 4600
## 412 4600
## 413 2600
## 414 2500
## 415 1800
## 416 1800
## 417 2000
## 418 1950
## 419 1800
## 420 1750
## 421 4050
## 422 2700
## 423 1800
## 424 1850
## 425 2400
## 426 2600
## 427 3800
## 428 2800
## 429 2600
## 430 2350
## 431 2350
## 432 4600
## 433 4600
## 434 2600
## 435 2450
## 436 2550
## 437 2100
## 438 1450
## 439 2700
## 440 2350
## 441 2350
## 442 2450
## 443 2700
## 444 2700
## 445 3000
## 446 3200
## 447 3400
## 448 2150
## 449 2550
## 450 2850
## 451 3000
## 452 3200
## 453 3400
## 454 2550
## 455 2700
## 456 2550
## 457 2550
## 458 2550
## 459 2850
## 460 2700
## 461 2550
## 462 3000
## 463 3400
## 464 3000
## 465 3650 6650
## 466 2550
## 467 2700
## 468 2850
## 469 2450
## 470 2850
## 471 2700
## 472 2650
## 473 3000
## 474 3400
## 475 3000
## 476 3650 6650
## 477 2550
## 478 3800
## 479 2450
## 480 3050
## 481 2700
## 482 3550
## 483 2350
## 484 2700
## 485 2700
## 486 2450
## 487 2950
## 488 3200
## 489 3200
## 490 3000
## 491 2850
## 492 2750
## 493 2850
## 494 3200
## 495 3200
## 496 3400
## 497 3950 7150
## 498 3800
## 499 3200
## 500 3400
## 501 3000
## 502 3000
## 503 3400
## 504 3400
## 505 3400
## 506 3950 7150
## 507 4300
## 508 3150
## 509 4300
## 510 2700
## 511 2850
## 512 2850
## 513 2350
## 514 3000
## 515 3200
## 516 3400
## 517 4500
## 518 2450
## 519 2700
## 520 3200
## 521 3200
## 522 3000
## 523 2750
## 524 3200
## 525 3200
## 526 3400
## 527 3950 7150
## 528 4050
## 529 3450
## 530 4300
## 531 3400
## 532 3000
## 533 3400
## 534 3400
## 535 3400
## 536 3950 7150
## 537 4300
## 538 2550
## 539 2700
## 540 2850
## 541 3000
## 542 2700
## 543 2850
## 544 3800
## 545 4050
## 546 2550
## 547 3200
## 548 2850
## 549 3550
## 550 5400
## 551 2350
## 552 2250
## 553 2850
## 554 2850
## 555 2700
## 556 3400
## 557 3200
## 558 2850
## 559 3400
## 560 3050
## 561 3050
## 562 2300
## 563 2300
## 564 3050
## 565 3050
## 566 3400
## 567 3600
## 568 3600
## 569 3600
## 570 2450
## 571 2450
## 572 2450
## 573 2450
## 574 1500
## 575 2700
## 576 1550
## 577 2950
## 578 2600
## 579 2600
## 580 1800
## 581 1800
## 582 2500
## 583 2700
## 584 2550
## 585 2800
## 586 2550
## 587 2150
## 588 2450
## 589 1950
## 590 1750
## 591 1800
## 592 1400
## 593 2100
## 594 1800
## 595 1350
## 596 2450
## 597 1950
## 598 1750
## 599 1750
## 600 2450
## 601 2350
## 602 2250
## 603 1500
## 604 1950
## 605 1750
## 606 2500
## 607 1100
## 608 1000
## 609 1750
## 610 2350
## 611 2100
## 612 1450
## 613 1950
## 614 2450
## 615 1950
## 616 2600
## 617 2150
## 618 2400
## 619 2000
## 620 2100
## 621 2000
## 622 2350
## 623 1650
## 624 1700
## 625 1700
## 626 2150
## 627 2250
## 628 1500
## 629 1800
## 630 2350
## 631 2350
## 632 1750
## 633 2100
## 634 2000
## 635 3050
## 636 2800
## 637 2800
## 638 2700
## 639 3400
## 640 2150
## 641 2350
## 642 2500
## 643 2700
## 644 2700
## 645 3050
## 646 3050
## 647 2500
## 648 2300
## 649 2500
## 650 2300
## 651 3800
## 652 3800
## 653 2800
## 654 2700
## 655 3800
## 656 3800
## 657 2800
## 658 2700
## 659 2000
## 660 2250
## 661 2600
## 662 2800
## 663 2550
## 664 2800
## 665 2550
## 666 2250
## 667 2550
## 668 2100
## 669 2000
## 670 2250
## 671 2700
## 672 2700
## 673 2700
## 674 3200
## 675 3200
## 676 3000
## 677 3200
## 678 3000
## 679 3000
## 680 3200
## 681 3200
## 682 2100
## 683 2350
## 684 2350
## 685 2350
## 686 2550
## 687 1950
## 688 2100
## 689 1400
## 690 2700
## 691 2950
## 692 3200
## 693 2150
## 694 1850
## 695 1450
## 696 2550
## 697 2100
## 698 2000
## 699 1950
## 700 2550
## 701 2450
## 702 2350
## 703 2350
## 704 2450
## 705 1600
## 706 2150
## 707 1450
## 708 1400
## 709 2600
## 710 2600
## 711 2800
## 712 2700
## 713 3050
## 714 3800
## 715 2000
## 716 2550
## 717 2700
## 718 2850
## 719 2550
## 720 2700
## 721 2850
## 722 4600
## 723 3000
## 724 3200
## 725 2100
## 726 1850
## 727 2350
## 728 2150
## 729 1600
## 730 2150
## 731 1400
## 732 1250
## 733 2100
## 734 2700
## 735 3200
## 736 2950
## 737 2800
## 738 2950
## 739 3050
## 740 1950
## 741 2700
## 742 2700
## 743 1650
## 744 1650
## 745 2700
## 746 1800
## 747 2400
## 748 2250
## 749 2250
## 750 1800
## 751 2600
## 752 2600
## 753 3200
## 754 2150
## 755 1850
## 756 2150
## 757 1950
## 758 2250
## 759 2150
## 760 2000
## 761 3050
## 762 3050
## 763 2400
## 764 2400
## 765 2400
## 766 2500
## 767 2700
## 768 2800
## 769 2100
## 770 2150
## 771 2100
## 772 2100
## 773 2150
## 774 2350
## 775 3050
## 776 1750
## 777 1750
## 778 3050
## 779 3400
## 780 3400
## 781 3050
## 782 1850
## 783 1850
## 784 2000
## 785 1850
## 786 2100
## 787 2150
## 788 1950
## 789 2350
## 790 1800
## 791 1300
## 792 2250
## 793 1950
## 794 1850
## 795 1800
## 796 1950
## 797 1400
## 798 1450
## 799 1400
## 800 2700
## 801 2450
## 802 2450
## 803 2550
## 804 2000
## 805 2150
## 806 2250
## 807 2500
## 808 2600
## 809 2600
## 810 2550
## 811 2850
## 812 4050
## 813 2850
## 814 3200
## 815 4050
## 816 2750
## 817 3200
## 818 4050
## 819 2350
## 820 2550
## 821 2550
## 822 3550
## 823 2850
## 824 2250
## 825 2550
## 826 2700
## 827 2350
## 828 2850
## 829 3200
## 830 4050
## 831 2850
## 832 3200
## 833 4050
## 834 2800
## 835 4050
## 836 2450
## 837 2550
## 838 2700
## 839 2700
## 840 2800
## 841 2550
## 842 4050
## 843 3200
## 844 1500
## 845 1600
## 846 2250
## 847 2250
## 848 2450
## 849 3400
## 850 3800
## 851 4050
## 852 3050
## 853 3050
## 854 3400
## 855 4300
## 856 3800
## 857 3800
## 858 4050
## 859 4050
## 860 3800
## 861 4300
## 862 3400
## 863 2600
## 864 4300
## 865 3400
## 866 2700
## 867 3600
## 868 2950
## 869 2700
## 870 3000
## 871 4050
## 872 4950
## 873 3000
## 874 3400
## 875 4050
## 876 3000
## 877 3200
## 878 3400
## 879 4050
## 880 2550
## 881 2700
## 882 2550
## 883 3550
## 884 4950
## 885 4300
## 886 5400
## 887 3600
## 888 3000
## 889 3200
## 890 2350
## 891 2700
## 892 2700
## 893 3150 5850
## 894 2550
## 895 2950
## 896 3200
## 897 2550
## 898 3000
## 899 3200
## 900 4050
## 901 3000
## 902 3400
## 903 4050
## 904 2550
## 905 2550
## 906 2700
## 907 4300
## 908 4600
## 909 2950
## 910 4300
## 911 2450
## 912 2550
## 913 3550
## 914 3800
## 915 4300
## 916 3800
## 917 2850
## 918 2850
## 919 4050
## 920 3400
## 921 4050
## 922 3600
## 923 3800
## 924 3600
## 925 3600
## 926 3400
## 927 4050
## 928 3200
## 929 3050
## 930 3400
## 931 3600
## 932 3400
## 933 3200
## 934 3200
## 935 3200
## 936 3200
## 937 3400
## 938 3050
## 939 3050
## 940 3600
## 941 3600
## 942 3600
## 943 3800
## 944 3400
## 945 2800
## 946 2400
## 947 2700
## 948 3000
## 949 3600
## 950 3600
## 951 4050
## 952 4050
## 953 2150
## 954 2600
## 955 4600
## 956 5850
## 957 3200
## 958 3200
## 959 4050
## 960 4050
## 961 4050
## 962 4600
## 963 2950
## 964 3800
## 965 3050
## 966 4050
## 967 4050
## 968 4300
## 969 2450
## 970 3400
## 971 3400
## 972 3800
## 973 3800
## 974 2450
## 975 2550
## 976 3200
## 977 3200
## 978 2350
## 979 2450
## 980 2000
## 981 1600
## 982 1550
## 983 1550
## 984 2800
## 985 2700
## 986 2700
## 987 2800## Adding a soruce column
ice_cars_semi_final$source = "ICE"## Putting them all togeher and plotting with analysis.
## Limiting to the core columsn i want for annual cost
ev_final<- ev_cars_semi_final%>% select(manufacturer,division,source, fuel_annual_cost)
phev_final<-phev_cars_semi_final%>% select(manufacturer,division,source, fuel_annual_cost)
ice_final<- ice_cars_semi_final %>% select(manufacturer,division,source, fuel_annual_cost)
# Concatenating mutlple dfs
#Citation: https://stackoverflow.com/questions/8169323/r-concatenate-two-dataframes
car_data <- rbind(ev_final, phev_final, ice_final)
## Group by source (car type) and Manufacturer
## Citation: https://stackoverflow.com/questions/62140483/how-to-interpret-dplyr-message-summarise-regrouping-output-by-x-override
car_data_grouped <- car_data %>% group_by(manufacturer,source) %>% summarise(mean_annual_cost = mean(fuel_annual_cost),.groups = 'drop')
# Plotting so that the resultscazn
#Chacking Manufactuers
unique(ice_final$manufacturer)## [1] "aston martin" "BMW" "Volkswagen"
## [4] "General Motors" "Ferrari" "Jaguar Land Rover L"
## [7] "Lotus" "Maserati" "MAZDA"
## [10] "Mercedes-Benz" "Nissan" "Porsche"
## [13] "Toyota" "Subaru" "Ford Motor Company"
## [16] "Honda" "Hyundai" "Mitsubishi Motors Co"
## [19] "Volvo" "FCA US LLC" "Kia"
## [22] "Rolls-Royce" "Ineos Automotive Li"Analysis
What you can see in the charts below is that the annual cost for fuel is greatest for EV’s, highest for Internal Combustion Engine vehicles, and then in the middle for Plug in Hybrid cars. The overal numbers can be seen in chart 1, while the average total fuel cost by manufacturer can be seen in the second chart. This number is going to vary based on the types of cars a manufacturer makes. If one was purchasing a car it may be best to look at the third chart, where, despite being a bit messy, one can see which costs for car type and manufacturer are lowest and highest.
## Plotting
#Clatation: https://r-graph-gallery.com/48-grouped-barplot-with-ggplot2.html
# https://www.andrewheiss.com/blog/2022/06/23/long-labels-ggplot/
## Fristly looking at the overal different in annual fuel cost for ICE, PHEV, and EV
ggplot(car_data_grouped, aes(fill=source, y=mean_annual_cost, x=source)) +
geom_bar(position="dodge", stat="identity")
## Second looking at the annual cost for fuel by manufactuers
ggplot(car_data_grouped, aes( y=mean_annual_cost, x=manufacturer)) +
geom_bar(position="dodge", stat="identity", width=.5)+
theme(axis.text.x = element_text(angle = 90, hjust = 1, vjust = 0.5))
## Third attempting to show it all in one chart, looks a bit messy
## The bar width seems to vary even though im setting it. Probably because not all manufacturers have each type of car. When a manufacturer only has one, the single bar is the width of all three bars for a manufacture that has all three types of cars
ggplot(car_data_grouped, aes(fill=source, y=mean_annual_cost, x=manufacturer)) +
geom_bar(position="dodge", stat="identity", width=.8)+
theme(axis.text.x = element_text(angle = 90, hjust = 1, vjust = 0.5))
Working with Dataset Number 2: Buffalo Blizzards
DATA SOURCE: https://brightspace.cuny.edu/d2l/le/437179/discussions/threads/443928/View
Discussion Post:
So I’m actually based in Buffalo and we have a bit of a reputation for snow. Below is an (untidy) data set of recorded snowfall from the National Weather Association. We’ve made national headlines a few times for record snowfall - see if you can find the worst storms!
storms <-read.csv("https://raw.githubusercontent.com/jhnboyy/CUNYSPS_DATA607/refs/heads/main/Project2/dataset2/buffalo_weather.csv.csv", header=FALSE,sep=',')
### Getting the index numbers where the column names are
columns <-storms[1,]
## Column headers are every 11 rows after the first row
#citation:https://www.rdocumentation.org/packages/base/versions/3.6.2/topics/seq
subheaders <- seq(1,by=11,length.out = nrow(storms))
storms_lim <- storms[-subheaders,]
colnames(storms_lim)<-columns
## Masking the Season Value a date
## Citation
# as.Date()
### Assuming the data is in inches (convertting to double)
storms_lim$JUL<-as.double(storms_lim$JUL)
storms_lim$AUG<- as.double(storms_lim$AUG)
storms_lim$SEP<- as.double(storms_lim$SEP)## Warning: NAs introduced by coercionstorms_lim$OCT<- as.double(storms_lim$OCT)## Warning: NAs introduced by coercionstorms_lim$NOV<- as.double(storms_lim$NOV)## Warning: NAs introduced by coercionstorms_lim$DEC<- as.double(storms_lim$DEC)
storms_lim$JAN<- as.double(storms_lim$JAN)
storms_lim$FEB<- as.double(storms_lim$FEB)
storms_lim$MAR <- as.double(storms_lim$MAR)## Warning: NAs introduced by coercionstorms_lim$APR <-as.double(storms_lim$APR)## Warning: NAs introduced by coercionstorms_lim$MAY <- as.double(storms_lim$MAY)## Warning: NAs introduced by coercionstorms_lim$JUN <- as.double(storms_lim$JUN)
storms_lim$ANNUAL <-as.double(storms_lim$ANNUAL)
#FIlling Nulls with zero
#Ciation: https://stackoverflow.com/questions/8161836/how-do-i-replace-na-values-with-zeros-in-an-r-dataframe
storms_lim[is.na(storms_lim)] <- 0
#CITATION: https://stackoverflow.com/questions/61004387/is-there-an-r-function-for-taking-the-first-four-characters-in-a-column-and-putt
storms_lim$year<- substr(storms_lim$SEASON, 1, 4)
#limiting to 2023 and before
storms_lim<- storms_lim %>% filter(storms_lim$year<=2023)
## Pivoting long form for monthly plot
storm_for_piv <-storms_lim %>%
select("JUL","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN",'year')
storms_month_long <- pivot_longer(storm_for_piv,
cols = c("JUL","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN"),
names_to = "month",
values_to ="inches")
monthly_smmry <- storms_month_long %>% group_by(month) %>% summarise(mean_inches = mean(inches),.groups = 'drop')
## Reordering
monthly_smmry<-monthly_smmry[c(5,4,8,1,9,7,6,2,12,11,10,3),]
## Limited Annual table for yearly data
storms_lim$year<- as.numeric(storms_lim$year)Analysis
Overall, the year on record as having the most snow fall in Buffalo, NY is 1976, with 200 having the second highest number of inches for annual snopwfall. When looking at the snow fall by month, over all of the years, the month that has has the highest average snow fall for the years in the data is January. December is the second highest. The months with no snowfall at all for the years within the data are June July August and Septwember.
### PLotting different parts of data
## Years with most inches of snow
ggplot(storms_lim, aes(x=year, y=ANNUAL))+
geom_line()+
geom_point()+
scale_x_continuous(n.breaks=25)
## Months with most inches of snow
## CITATION for factor feature: https://stackoverflow.com/questions/26469612/how-do-i-set-factor-levels-to-the-order-they-appear-in-a
ggplot(monthly_smmry, aes(y=mean_inches, x=factor(month, levels = unique(month)))) +
geom_bar(stat="identity")
theme(axis.text.x = element_text(angle = 90, hjust = 1, vjust = 0.5))## List of 1
## $ axis.text.x:List of 11
## ..$ family : NULL
## ..$ face : NULL
## ..$ colour : NULL
## ..$ size : NULL
## ..$ hjust : num 1
## ..$ vjust : num 0.5
## ..$ angle : num 90
## ..$ lineheight : NULL
## ..$ margin : NULL
## ..$ debug : NULL
## ..$ inherit.blank: logi FALSE
## ..- attr(*, "class")= chr [1:2] "element_text" "element"
## - attr(*, "class")= chr [1:2] "theme" "gg"
## - attr(*, "complete")= logi FALSE
## - attr(*, "validate")= logi TRUEWorking with Dataset Number 2: NYC Car Accident Data
DATA SOURCE: https://brightspace.cuny.edu/d2l/le/437179/discussions/threads/502453/View
Discussion Post:
While structured, I went ahead and decided on NYC vehicular collision data. These accidents are those incidents that took place and yielded $1,000 or more in damages. While the data is structured, it is a decently sized one, and is also a wide-type of format, it can most definitely be flattened in some aspects in order to more readily analyze. The link to the data set is here: https://data.cityofnewyork.us/Public-Safety/Motor-Vehicle-Collisions-Crashes/h9gi-nx95/about_data
I would be curious to analyze which boroughs had the most accidents, along with if any days of the year tend to be worse than others. I would also like to plot the locations of these accidents and so some geographic analysis on the problem spots in the city, and how these areas improved or got worse overtime. Lastly, for fun, I would also like to do some exploratory work to see if people that drive certain types of cars tend to be in more accidents than others
Working Notes
Due to the size of this data set the raw bulk data is not on github. For the sake of this analysis and excercise i will limit the accidents to one year with the hopes of limiting the size, and placing that subset of the data on github. For ingestion and cleaning.
collisions_2023_raw <-read.csv("https://raw.githubusercontent.com/jhnboyy/CUNYSPS_DATA607/refs/heads/main/Project2/dataset3_subset/nyc_collisions_2023.csv", header=FALSE,sep=',')
colnames(collisions_2023_raw)<-collisions_2023_raw[1,]
collisions_2023_raw<-collisions_2023_raw[-c(1),]
## I dont know how to geocode / do overlap intersection with shape files in r using Lat Long, so dropping the nulls in the borough columns. This will impact final numbers.
collisions_2023_raw_lim <-collisions_2023_raw %>% filter(BOROUGH!="")
colnames(collisions_2023_raw_lim) <-make.names(trimws(colnames(collisions_2023_raw_lim)), unique=TRUE)
### keeping the columns we want for deadliest boroughs, and times of year
collisions_core_columns <- collisions_2023_raw_lim %>% select(
"CRASH.DATE","BOROUGH","NUMBER.OF.PERSONS.INJURED", "NUMBER.OF.PERSONS.KILLED")
#Converting data types
collisions_core_columns$NUMBER.OF.PERSONS.INJURED<- as.integer(collisions_core_columns$NUMBER.OF.PERSONS.INJURED)
collisions_core_columns$NUMBER.OF.PERSONS.KILLED<- as.integer(collisions_core_columns$NUMBER.OF.PERSONS.KILLED)
#parsing month out of the date
#Citation: https://stackoverflow.com/questions/52672853/how-to-convert-full-date-character-into-mm-dd-yyyy-in-r
library(lubridate)
collisions_core_columns$CRASH.DATE <-format(mdy(collisions_core_columns$CRASH.DATE), "%m-%d-%Y")
# Grouping to get counts and sums per month and borough
boro_summary_collisions<-collisions_core_columns %>% group_by(BOROUGH) %>% summarise(total_injured = sum(NUMBER.OF.PERSONS.INJURED),
total_killed = sum(NUMBER.OF.PERSONS.KILLED),
total_collisions = n()
,.groups = 'drop')
## Group by and summarize for months
## Citation :https://stackoverflow.com/questions/22603847/how-to-extract-month-from-date-in-r
collisions_core_columns$month<-month(as.numeric(substr(collisions_core_columns$CRASH.DATE,1,2)),label=TRUE)
month_summary_collisions<-collisions_core_columns %>% group_by(month) %>% summarise(total_injured = sum(NUMBER.OF.PERSONS.INJURED),
total_killed = sum(NUMBER.OF.PERSONS.KILLED),
total_collisions = n()
,.groups = 'drop')Analysis
After removing the null values for borough, and workuing with the data that remained. We then looked at the totla number of vehicular collisions and resulting injuries for each borough. We also took a look at the same stats for each month of the year. Remember that this data is for the year 2023. The data shows that the borough with the most number of people injured in vehicle accidents was brooklyn, brooklyn also had the highest number of accidents too. The safest borough in 2023 was staten island with hte lowest number of accidents and injuries. The second highest numbers for injuries was the bronx, while queens had the second highest number of collisions. When looking to different times of the year, December was the month with the highest number of collisions with July coming in second place. Both of these months were much higher than the other months of the year. When looking at the number of injuries from collisions, July was the month with the most injured, followed by December.
boro_summary_collisions## # A tibble: 5 × 4
## BOROUGH total_injured total_killed total_collisions
## <chr> <int> <int> <int>
## 1 BRONX 18 0 17
## 2 BROOKLYN 20 0 39
## 3 MANHATTAN 10 0 24
## 4 QUEENS 17 0 30
## 5 STATEN ISLAND 1 0 4## Plotting injuries by borogh
### No one was killed in vehicle collisions in 2023, based on the data that had a borough values So just plotting injuries
ggplot(boro_summary_collisions, aes(y=total_injured, x=BOROUGH, fill=BOROUGH)) +
geom_bar(stat="identity")
## Total collisions by borough
ggplot(boro_summary_collisions, aes(y=total_collisions, x=BOROUGH, fill=BOROUGH)) +
geom_bar(stat="identity")
## Finding the most dangerous Month of the year 2023
ggplot(month_summary_collisions, aes(y=total_collisions, x=month, fill=month)) +
geom_bar(stat="identity")
ggplot(month_summary_collisions, aes(y=total_injured, x=month, fill=month)) +
geom_bar(stat="identity")