{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# \"Alternative-fuel\" vehicles in Delaware: Data analysis\n", "Peter Attia, [petermattia.com](http://petermattia.com)\n", "\n", "Last updated November 9, 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 analysis process for this dataset. [Another notebook](http://nbviewer.jupyter.org/github/petermattia/Delaware-EVs/blob/master/Electric%20vehicles%20in%20Delaware%20-%20Data%20analysis.ipynb) shows the data cleaning.\n", "\n", "## Imports and defaults" ] }, { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": true }, "outputs": [], "source": [ "# IMPORTS\n", "import numpy as np\n", "import pandas as pd\n", "from collections import Counter\n", "import matplotlib.pyplot as plt\n", "import seaborn as sns\n", "import folium\n", "import json\n", "\n", "# DEFAULTS\n", "%matplotlib inline\n", "pd.set_option(\"display.max_rows\",10)\n", "pd.set_option(\"display.max_columns\",20)\n", "sns.set(font_scale=2)\n", "sns.set_style(\"dark\")" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Load the cleaned `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", "2015-07-20 | \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", "2015-07-20 | \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", "2015-07-22 | \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", "2015-07-20 | \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", "2015-07-24 | \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", "2016-04-20 | \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", "2016-04-20 | \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", "2016-04-20 | \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", "2016-04-20 | \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", "2016-04-20 | \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", "\n", " | Zip | \n", "Count | \n", "
---|---|---|
0 | \n", "19707 | \n", "14 | \n", "
1 | \n", "19809 | \n", "10 | \n", "
2 | \n", "19810 | \n", "18 | \n", "
3 | \n", "19808 | \n", "27 | \n", "
4 | \n", "19720 | \n", "15 | \n", "
... | \n", "... | \n", "... | \n", "
43 | \n", "19960 | \n", "2 | \n", "
44 | \n", "19731 | \n", "1 | \n", "
45 | \n", "19955 | \n", "1 | \n", "
46 | \n", "19943 | \n", "3 | \n", "
47 | \n", "19902 | \n", "1 | \n", "
48 rows × 2 columns
\n", "\n", " | Zip | \n", "population | \n", "
---|---|---|
0 | \n", "1001 | \n", "16769 | \n", "
1 | \n", "1002 | \n", "29049 | \n", "
2 | \n", "1003 | \n", "10372 | \n", "
3 | \n", "1005 | \n", "5079 | \n", "
4 | \n", "1007 | \n", "14649 | \n", "
... | \n", "... | \n", "... | \n", "
33087 | \n", "99923 | \n", "87 | \n", "
33088 | \n", "99925 | \n", "819 | \n", "
33089 | \n", "99926 | \n", "1460 | \n", "
33090 | \n", "99927 | \n", "94 | \n", "
33091 | \n", "99929 | \n", "2338 | \n", "
33092 rows × 2 columns
\n", "\n", " | Zip | \n", "Count | \n", "population | \n", "count_norm | \n", "
---|---|---|---|---|
0 | \n", "19707 | \n", "14 | \n", "16483 | \n", "0.849360 | \n", "
1 | \n", "19809 | \n", "10 | \n", "14049 | \n", "0.711794 | \n", "
2 | \n", "19810 | \n", "18 | \n", "25011 | \n", "0.719683 | \n", "
3 | \n", "19808 | \n", "27 | \n", "38442 | \n", "0.702357 | \n", "
4 | \n", "19720 | \n", "15 | \n", "59250 | \n", "0.253165 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
43 | \n", "19960 | \n", "2 | \n", "6295 | \n", "0.317712 | \n", "
44 | \n", "19731 | \n", "1 | \n", "252 | \n", "3.968254 | \n", "
45 | \n", "19955 | \n", "1 | \n", "72 | \n", "13.888889 | \n", "
46 | \n", "19943 | \n", "3 | \n", "11425 | \n", "0.262582 | \n", "
47 | \n", "19902 | \n", "1 | \n", "283 | \n", "3.533569 | \n", "
48 rows × 4 columns
\n", "\n", " | Zip | \n", "Count | \n", "population | \n", "count_norm | \n", "
---|---|---|---|---|
0 | \n", "19713 | \n", "2 | \n", "30408 | \n", "0.065772 | \n", "
1 | \n", "19953 | \n", "1 | \n", "4386 | \n", "0.227998 | \n", "
2 | \n", "19901 | \n", "4 | \n", "35055 | \n", "0.114106 | \n", "
3 | \n", "19803 | \n", "6 | \n", "21364 | \n", "0.280846 | \n", "
4 | \n", "19732 | \n", "1 | \n", "25 | \n", "40.000000 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
18 | \n", "19720 | \n", "1 | \n", "59250 | \n", "0.016878 | \n", "
19 | \n", "19977 | \n", "1 | \n", "22984 | \n", "0.043509 | \n", "
20 | \n", "19934 | \n", "1 | \n", "12805 | \n", "0.078094 | \n", "
21 | \n", "19975 | \n", "1 | \n", "8253 | \n", "0.121168 | \n", "
22 | \n", "19904 | \n", "1 | \n", "34132 | \n", "0.029298 | \n", "
23 rows × 4 columns
\n", "\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", "2015-07-20 | \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", "2015-07-20 | \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", "2015-07-22 | \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", "2015-07-20 | \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", "2015-07-24 | \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", "2016-04-20 | \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", "2016-04-20 | \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", "2016-04-20 | \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", "2016-04-20 | \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", "2016-04-20 | \n", "Coach and Equipment/ Coach Bus Sales | \n", "Propane | \n", "Ford | \n", "E-450 Phoenix | \n", "2016 | \n", "No | \n", "NaN | \n", "NaN | \n", "
295 rows × 17 columns
\n", "\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", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
92 | \n", "CVR021695 | \n", "$2200.00 | \n", "Dover | \n", "DE | \n", "Kent | \n", "19904 | \n", "50.0 | \n", "M | \n", "2016-12-31 | \n", "Boulevard Ford | \n", "Plug-in Hybrid | \n", "Ford | \n", "Fusion Energi | \n", "2015 | \n", "Yes | \n", "14815.0 | \n", "6575.0 | \n", "
192 | \n", "CVR0816200 | \n", "$2200.00 | \n", "Wilmington | \n", "DE | \n", "New Castle | \n", "19807 | \n", "79.0 | \n", "M | \n", "2017-08-06 | \n", "Tesla Motors | \n", "Electric | \n", "Tesla | \n", "Model S | \n", "2016 | \n", "No | \n", "14815.0 | \n", "5539.0 | \n", "
267 | \n", "CVR1116275 | \n", "$2200.00 | \n", "Millsboro | \n", "DE | \n", "Sussex | \n", "19966 | \n", "65.0 | \n", "F | \n", "2016-11-01 | \n", "I.G. Burton Chevrolet | \n", "Plug-in Hybrid | \n", "Chevrolet | \n", "Volt | \n", "2017 | \n", "No | \n", "14815.0 | \n", "6575.0 | \n", "
294 | \n", "BEV121602 | \n", "$3500.00 | \n", "Milford | \n", "DE | \n", "Sussex | \n", "19963 | \n", "59.0 | \n", "M | \n", "2016-11-17 | \n", "Porter Nissan | \n", "Electric | \n", "Nissan | \n", "Leaf | \n", "2016 | \n", "Yes | \n", "11435.0 | \n", "5654.0 | \n", "
295 | \n", "BEV011703 | \n", "$1000.00 | \n", "Lewes | \n", "DE | \n", "Sussex | \n", "19958 | \n", "30.0 | \n", "M | \n", "2016-12-14 | \n", "Tesla Motors | \n", "Electric | \n", "Tesla | \n", "Model S | \n", "2017 | \n", "No | \n", "11435.0 | \n", "5654.0 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
503 | \n", "PHEV0917149 | \n", "$1500.00 | \n", "Middletown | \n", "DE | \n", "New Castle | \n", "19709 | \n", "53.0 | \n", "M | \n", "2017-09-18 | \n", "Porter Ford | \n", "Plug-in Hybrid | \n", "Ford | \n", "Fusion Energi | \n", "2017 | \n", "No | \n", "11435.0 | \n", "6866.0 | \n", "
504 | \n", "PHEV0917150 | \n", "$1000.00 | \n", "Wilmington | \n", "DE | \n", "New Castle | \n", "19807 | \n", "59.0 | \n", "F | \n", "2017-06-14 | \n", "Otto's BMW | \n", "Plug-in Hybrid | \n", "BMW | \n", "X5 40E | \n", "2017 | \n", "No | \n", "11435.0 | \n", "6866.0 | \n", "
505 | \n", "PHEV0917151 | \n", "$1500.00 | \n", "Smyrna | \n", "DE | \n", "Kent | \n", "19977 | \n", "70.0 | \n", "M | \n", "2017-09-21 | \n", "Willis Ford | \n", "Plug-in Hybrid | \n", "Ford | \n", "Fusion Energi | \n", "2017 | \n", "No | \n", "11435.0 | \n", "6866.0 | \n", "
506 | \n", "PHEV0917152 | \n", "$1500.00 | \n", "Middletown | \n", "DE | \n", "New Castle | \n", "19709 | \n", "50.0 | \n", "M | \n", "2017-09-22 | \n", "Porter Ford | \n", "Plug-in Hybrid | \n", "Ford | \n", "Fusion Energi | \n", "2017 | \n", "Yes | \n", "11435.0 | \n", "6866.0 | \n", "
507 | \n", "LPG051702 | \n", "$1350.00 | \n", "Dover | \n", "DE | \n", "Kent | \n", "19902 | \n", "NaN | \n", "NaN | \n", "2017-03-01 | \n", "AutoPort Inc | \n", "Propane (bi-fuel) | \n", "Ford | \n", "F150 | \n", "2017 | \n", "No | \n", "NaN | \n", "NaN | \n", "
216 rows × 17 columns
\n", "