Learn Programming

Data set 1 is collected with the ELM327 module with raw sensor data and calculated values that are collected with Car Scanner (App) from the OBD-II codes through a Bluetooth connection. Data set 2 is collected with an OBDLink MX+ OBD-II module through a Bluetooth connection.

The purpose of this exercise is to demonstrate the use of Pandas DataFrames to import, cleanse, and view data. Automotive data is available from OBD-II codes that are standard for engine monitoring of light duty vehicles (passenger cars) starting in year 1996. Newer vehicles may include additional sensors from other electronic systems such as the brake system, tire pressure, climate control, and transmission. Data is processed with on-board computers to monitor the health of the vehicle systems and provide warning diagnostics when there is an indication of malfunction.

Data: Data is collected from a 2014 Ford Focus (manual transmission) and a 2021 Chrysler Pacifica minivan with city and freeway driving:

1. Provo to St. George, Utah (~8 hrs), 40 columns, 2014 Ford
2. Des Moines to Pella, Iowa (~1 hr), 46 columns, 2021 Chrysler

<iframe width="560" height="315" src="https://www.youtube.com/embed/GSSOe9I7roo" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>

1. Provo to St. George, Utah (~8 hrs), 40 columns, 2014 Ford
2. Des Moines to Pella, Iowa (~1 hr), 46 columns, 2021 Chrysler

Geographic Information Systems (GIS) are used to create, manage, analyze, and map data. GPS is used to identify the location of the vehicle. Car data and location data are in a single data file. This exercise demonstrates the use of Pandas DataFrames to import, cleanse, and view data.

(:title Pandas with Automotive Data:) (:keywords automobile, python, pandas, fuel, economy, efficiency, OBD2, data:) (:description Visualize automotive data by first importing as a Pandas DataFrame. Data includes travel distance, time, fuel rate, air flow, oxygen ratio, and other parameters available from an OBD2 interface.:)

(:html:) <iframe width="560" height="315" src="https://www.youtube.com/embed/gWQnYZrVjs8" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe> (:htmlend:)

Background: Automotive data is available from OBD-II codes that are standard for engine monitoring of light duty vehicles (passenger cars) starting in year 1996. Newer vehicles may include additional sensors from other electronic systems such as the brake system, tire pressure, climate control, and transmission. Data is processed with on-board computers to monitor the health of the vehicle systems and provide warning diagnostics when there is an indication of malfunction. The purpose of this exercise is to demonstrate the use of Pandas DataFrames to import, cleanse, and view data.

Attach:ford_focus.png Δ

Data: Data is collected from a 2014 Ford Focus (manual transmission) and a 2021 Chrysler Pacifica minivan with city and freeway driving:

1. Provo to St. George, Utah (~8 hrs), 40 columns, 2014 Ford Δ
2. Des Moines to Pella, Iowa (~1 hr), 46 columns, 2021 Chrysler Δ

(:html:) <iframe width="560" height="315" src="https://www.youtube.com/embed/GSSOe9I7roo" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe> (:htmlend:)

Data sets 1 is collected with the ELM327 module with raw sensor data and calculated values that are collected with Car Scanner (App) from the OBD-II codes through a Bluetooth connection. Data set 2 is collected with an OBDLink MX+ OBD-II module through a Bluetooth connection.

Attach:obd2_connection.png Δ

Case Study: GIS Map Visualization

Objective: Import automotive data as a Pandas DataFrame. View the route on a map with the speed and elevation.

Geographic Information Systems (GIS) are used to create, manage, analyze, and map data. GPS is used to identify the location of the vehicle. Car data and location data are in a single data file.

Attach:Automotive_map_GPS.png Δ

This exercise demonstrates mapping capabilities in Python with three options to create a map and display speed and elevation on the map.

Automotive Mapping Notebook

Jupyter Notebook in Google Colab