Pandas with Automotive Data

Main.PythonAuto History

Show minor edits - Show changes to output

May 18, 2022, at 02:02 PM by 136.36.4.38 -
Changed line 16 from:
Data sets 1 is collected with the ELM327 module with raw sensor data and calculated values that are collected with [[https://play.google.com/store/apps/details?id=com.ovz.carscanner|Car Scanner (App)]] from the OBD-II codes through a Bluetooth connection. Data set 2 is collected with an [[https://www.obdlink.com/products/obdlink-mxp/|OBDLink MX+ OBD-II]] module through a Bluetooth connection.
to:
Data set 1 is collected with the ELM327 module with raw sensor data and calculated values that are collected with [[https://play.google.com/store/apps/details?id=com.ovz.carscanner|Car Scanner (App)]] from the OBD-II codes through a Bluetooth connection. Data set 2 is collected with an [[https://www.obdlink.com/products/obdlink-mxp/|OBDLink MX+ OBD-II]] module through a Bluetooth connection.
May 17, 2022, at 01:44 PM by 10.35.117.248 -
Added lines 5-11:
The purpose of this exercise is to demonstrate the use of Pandas DataFrames to import, cleanse, and view data. Automotive data is available from [[https://en.wikipedia.org/wiki/OBD-II_PIDs|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.

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

# [[https://apmonitor.com/pds/uploads/Main/auto_trip.zip|Provo to St. George, Utah (~8 hrs), 40 columns, 2014 Ford]]
# [[https://apmonitor.com/pds/uploads/Main/auto_iowa.txt|Des Moines to Pella, Iowa (~1 hr), 46 columns, 2021 Chrysler]]

Changed line 13 from:
<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>
to:
<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>
Deleted lines 15-25:
'''Background:''' Automotive data is available from [[https://en.wikipedia.org/wiki/OBD-II_PIDs|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:download.png '''Data:''' Data is collected from a 2014 Ford Focus (manual transmission) and a 2021 Chrysler Pacifica minivan with city and freeway driving:

# [[https://apmonitor.com/pds/uploads/Main/auto_trip.zip|Provo to St. George, Utah (~8 hrs), 40 columns, 2014 Ford]]
# [[https://apmonitor.com/pds/uploads/Main/auto_iowa.txt|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:)

Changed line 28 from:
%width=300px%Attach:utah_map.png
to:
%width=400px%Attach:utah_map.png
May 17, 2022, at 01:43 PM by 10.35.117.248 -
Added lines 31-32:

%width=300px%Attach:utah_map.png
May 17, 2022, at 01:40 PM by 10.35.117.248 -
Changed lines 28-30 from:
%width=30px%Attach:github.png [[https://github.com/APMonitor/learn_python/blob/main/Automotive_data.ipynb|Automotive Mapping Notebook]]

%width=50px%Attach:colab.png [[https://colab.research.google.com/github/APMonitor/learn_python/blob/main/Automotive_data.ipynb|Jupyter Notebook in Google Colab]]
to:
%width=30px%Attach:github.png [[https://github.com/APMonitor/learn_python/blob/master/Automotive_data.ipynb|Automotive Mapping Notebook]]

%width=50px%Attach:colab.png [[https://colab.research.google.com/github/APMonitor/learn_python/blob/master/Automotive_data.ipynb|Jupyter Notebook in Google Colab]]
May 17, 2022, at 01:39 PM by 10.35.117.248 -
Changed lines 13-14 from:
# [[Attach:https://apmonitor.com/pds/uploads/Main/auto_trip.zip|Provo to St. George, Utah (~8 hrs), 40 columns, 2014 Ford]]
# [[Attach:https://apmonitor.com/pds/uploads/Main/auto_iowa.txt|Des Moines to Pella, Iowa (~1 hr), 46 columns, 2021 Chrysler]]
to:
# [[https://apmonitor.com/pds/uploads/Main/auto_trip.zip|Provo to St. George, Utah (~8 hrs), 40 columns, 2014 Ford]]
# [[https://apmonitor.com/pds/uploads/Main/auto_iowa.txt|Des Moines to Pella, Iowa (~1 hr), 46 columns, 2021 Chrysler]]
May 17, 2022, at 01:38 PM by 10.35.117.248 -
Deleted lines 10-11:
%width=200px%Attach:ford_focus.png
Deleted lines 21-22:
%width=200px%Attach:obd2_connection.png
Changed lines 26-30 from:
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.

%width=300px%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.
to:
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.
May 17, 2022, at 01:36 PM by 10.35.117.248 -
Added lines 1-38:
(: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 [[https://en.wikipedia.org/wiki/OBD-II_PIDs|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.

%width=200px%Attach:ford_focus.png

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

# [[Attach:https://apmonitor.com/pds/uploads/Main/auto_trip.zip|Provo to St. George, Utah (~8 hrs), 40 columns, 2014 Ford]]
# [[Attach:https://apmonitor.com/pds/uploads/Main/auto_iowa.txt|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 [[https://play.google.com/store/apps/details?id=com.ovz.carscanner|Car Scanner (App)]] from the OBD-II codes through a Bluetooth connection. Data set 2 is collected with an [[https://www.obdlink.com/products/obdlink-mxp/|OBDLink MX+ OBD-II]] module through a Bluetooth connection.

%width=200px%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.

%width=300px%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.

%width=30px%Attach:github.png [[https://github.com/APMonitor/learn_python/blob/main/Automotive_data.ipynb|Automotive Mapping Notebook]]

%width=50px%Attach:colab.png [[https://colab.research.google.com/github/APMonitor/learn_python/blob/main/Automotive_data.ipynb|Jupyter Notebook in Google Colab]]