{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# \"Alternative-fuel\" vehicles in Delaware: Data cleaning\n", "Peter Attia, [petermattia.com](http://petermattia.com)\n", "\n", "Last updated November 8, 2017\n", "\n", "This notebook investigates alternative-fuel vehicle purchases in Delaware. Alternative-fuel vehicles include:\n", "- Battery electric vehicles (BEVs)\n", "- Plug-in hybrid electric vehicles (PHEVs)\n", "- Propane or natural gas vehicles\n", "\n", "Rebates data downloaded on October 22, 2017 (data last updated October 2, 2017) from [this link](https://data.delaware.gov/Energy-and-Environment/State-Rebates-for-Alternative-Fuel-Vehicles/8z8z-di7f)\n", "\n", "More information about the program:\n", "- http://dnrec.alpha.delaware.gov/energy-climate/clean-transportation/vehicle-rebates/\n", "- http://www.dnrec.delaware.gov/energy/Pages/The-Delaware-Clean-Vehicle-Rebate-Program.aspx\n", "- http://www.dnrec.delaware.gov/energy/Pages/Clean-Transportation-Incentives-Home.aspx\n", "- http://www.dnrec.delaware.gov/energy/Pages/Clean-Transportation-July2015-October2016.aspx\n", "\n", "This notebook contains the data cleaning process for this dataset. [Another notebook](http://nbviewer.jupyter.org/github/petermattia/Delaware-EVs/blob/master/Electric%20vehicles%20in%20Delaware%20-%20Data%20cleaning.ipynb) shows the data analysis.\n", "\n", "## Imports and defaults" ] }, { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": true }, "outputs": [], "source": [ "# IMPORTS\n", "import pandas as pd\n", "from collections import Counter\n", "\n", "# DEFAULTS\n", "pd.set_option(\"display.max_rows\",10)\n", "pd.set_option(\"display.max_columns\",20)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Load the `rebates` dataset" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | Award_Number | \n", "Rebate_Amount | \n", "City | \n", "State | \n", "County | \n", "Zip | \n", "Age | \n", "Gender | \n", "Date_of_Purchase | \n", "Dealership | \n", "Vehicle_Type | \n", "Make | \n", "Model | \n", "Year | \n", "Lease? | \n", "Gasoline_Emissions | \n", "Alt-Fuel_Emissions | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "CVR071501 | \n", "$2200.00 | \n", "Hockessin | \n", "DE | \n", "New Castle | \n", "19707 | \n", "81.0 | \n", "M | \n", "07/20/2015 | \n", "Sheridan Ford | \n", "Plug-in Hybrid | \n", "Ford | \n", "Fusion Energi | \n", "2016 | \n", "No | \n", "14815.0 | \n", "6575.0 | \n", "
1 | \n", "CVR071502 | \n", "$2200.00 | \n", "Wilmington | \n", "DE | \n", "New Castle | \n", "19809 | \n", "47.0 | \n", "M | \n", "07/20/2015 | \n", "Porter Ford | \n", "Plug-in Hybrid | \n", "Ford | \n", "C-Max Energi | \n", "2015 | \n", "Yes | \n", "14815.0 | \n", "6575.0 | \n", "
2 | \n", "CVR071503 | \n", "$2200.00 | \n", "Wilmington | \n", "DE | \n", "New Castle | \n", "19810 | \n", "47.0 | \n", "M | \n", "07/22/2015 | \n", "Darcars of Lanham Severn. Inc. | \n", "Electric | \n", "Ford | \n", "Focus Electric | \n", "2015 | \n", "Yes | \n", "14815.0 | \n", "5539.0 | \n", "
3 | \n", "CVR071504 | \n", "$2200.00 | \n", "Wilmington | \n", "DE | \n", "New Castle | \n", "19808 | \n", "66.0 | \n", "M | \n", "07/20/2015 | \n", "Sheridan Ford | \n", "Plug-in Hybrid | \n", "Ford | \n", "C-Max Energi | \n", "2015 | \n", "Yes | \n", "14815.0 | \n", "6575.0 | \n", "
4 | \n", "CVR071505 | \n", "$2200.00 | \n", "New Castle | \n", "DE | \n", "New Castle | \n", "19720 | \n", "51.0 | \n", "M | \n", "07/24/2015 | \n", "Sheridan Ford | \n", "Plug-in Hybrid | \n", "Ford | \n", "Fusion Energi | \n", "2015 | \n", "Yes | \n", "14815.0 | \n", "6575.0 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
510 | \n", "CVR0616147 | \n", "$1100.00 | \n", "Dover | \n", "DE | \n", "Kent | \n", "19901 | \n", "NaN | \n", "NaN | \n", "04/20/2016 | \n", "Coach and Equipment/ Coach Bus Sales | \n", "Propane | \n", "Ford | \n", "E-450 Phoenix | \n", "2016 | \n", "No | \n", "NaN | \n", "NaN | \n", "
511 | \n", "CVR0616148 | \n", "$1100.00 | \n", "Dover | \n", "DE | \n", "Kent | \n", "19901 | \n", "NaN | \n", "NaN | \n", "04/20/2016 | \n", "Coach and Equipment/ Coach Bus Sales | \n", "Propane | \n", "Ford | \n", "E-450 Phoenix | \n", "2016 | \n", "No | \n", "NaN | \n", "NaN | \n", "
512 | \n", "CVR0616149 | \n", "$1100.00 | \n", "Dover | \n", "DE | \n", "Kent | \n", "19901 | \n", "NaN | \n", "NaN | \n", "04/20/2016 | \n", "Coach and Equipment/ Coach Bus Sales | \n", "Propane | \n", "Ford | \n", "E-450 Phoenix | \n", "2016 | \n", "No | \n", "NaN | \n", "NaN | \n", "
513 | \n", "CVR0616150 | \n", "$1100.00 | \n", "Dover | \n", "DE | \n", "Kent | \n", "19901 | \n", "NaN | \n", "NaN | \n", "04/20/2016 | \n", "Coach and Equipment/ Coach Bus Sales | \n", "Propane | \n", "Ford | \n", "E-450 Phoenix | \n", "2016 | \n", "No | \n", "NaN | \n", "NaN | \n", "
514 | \n", "CVR0616151 | \n", "$1100.00 | \n", "Dover | \n", "DE | \n", "Kent | \n", "19901 | \n", "NaN | \n", "NaN | \n", "04/20/2016 | \n", "Coach and Equipment/ Coach Bus Sales | \n", "Propane | \n", "Ford | \n", "E-450 Phoenix | \n", "2016 | \n", "No | \n", "NaN | \n", "NaN | \n", "
515 rows × 17 columns
\n", "