-
Notifications
You must be signed in to change notification settings - Fork 13
/
Copy pathEV Data
1 lines (1 loc) · 17.9 KB
/
EV Data
1
{"cells":[{"source":"<a href=\"https://www.kaggle.com/code/dascient/ev-population-data-explo?scriptVersionId=211089830\" target=\"_blank\"><img align=\"left\" alt=\"Kaggle\" title=\"Open in Kaggle\" src=\"https://kaggle.com/static/images/open-in-kaggle.svg\"></a>","metadata":{},"cell_type":"markdown"},{"cell_type":"markdown","id":"5807d57c","metadata":{"papermill":{"duration":0.002736,"end_time":"2024-12-03T23:42:46.537462","exception":false,"start_time":"2024-12-03T23:42:46.534726","status":"completed"},"tags":[]},"source":["# EV Population Data Exploitation"]},{"cell_type":"code","execution_count":1,"id":"69a6f013","metadata":{"_cell_guid":"b1076dfc-b9ad-4769-8c92-a6c4dae69d19","_kg_hide-input":true,"_kg_hide-output":true,"_uuid":"8f2839f25d086af736a60e9eeb907d3b93b6e0e5","execution":{"iopub.execute_input":"2024-12-03T23:42:46.544693Z","iopub.status.busy":"2024-12-03T23:42:46.54339Z","iopub.status.idle":"2024-12-03T23:43:03.332495Z","shell.execute_reply":"2024-12-03T23:43:03.330892Z"},"papermill":{"duration":16.796138,"end_time":"2024-12-03T23:43:03.335764","exception":false,"start_time":"2024-12-03T23:42:46.539626","status":"completed"},"tags":[]},"outputs":[{"name":"stdout","output_type":"stream","text":["Collecting xlrd\r\n"," Downloading xlrd-2.0.1-py2.py3-none-any.whl.metadata (3.4 kB)\r\n","Downloading xlrd-2.0.1-py2.py3-none-any.whl (96 kB)\r\n","\u001b[2K \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m96.5/96.5 kB\u001b[0m \u001b[31m2.8 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\r\n","\u001b[?25hInstalling collected packages: xlrd\r\n","Successfully installed xlrd-2.0.1\r\n","/kaggle/input/electric-vehicle-population-data-data-gov/Electric_Vehicle_Population_Data.csv\n","CPU times: user 2.79 s, sys: 620 ms, total: 3.41 s\n","Wall time: 16.8 s\n"]}],"source":["%%time\n","# for the sake of expeditious analysis\n","!pip install xlrd\n","import warnings\n","warnings.filterwarnings(\"ignore\")\n","from IPython.display import clear_output\n","import numpy as np # linear algebra\n","import pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)\n","from matplotlib import pyplot as plt\n","from shapely.geometry import Point\n","import geopandas as gpd\n","from wordcloud import WordCloud, STOPWORDS, ImageColorGenerator\n","from geopandas import GeoDataFrame\n","import matplotlib.colors as colors\n","import seaborn as sns\n","import random as r\n","\n","import os\n","for dirname, _, filenames in os.walk('/kaggle/input'):\n"," for filename in filenames:\n"," print(os.path.join(dirname, filename))\n"," #print('Files loaded.')\n"," \n","pd.set_option('display.max_colwidth', None)\n","\n","# loading first ev dataframe\n","og_df1 = pd.read_csv('/kaggle/input/electric-vehicle-population-data-data-gov/Electric_Vehicle_Population_Data.csv',header=0)\n","df = og_df1.dropna().copy()\n","#############################################"]},{"cell_type":"code","execution_count":2,"id":"07d2c296","metadata":{"execution":{"iopub.execute_input":"2024-12-03T23:43:03.3429Z","iopub.status.busy":"2024-12-03T23:43:03.34248Z","iopub.status.idle":"2024-12-03T23:43:03.37692Z","shell.execute_reply":"2024-12-03T23:43:03.37581Z"},"papermill":{"duration":0.040728,"end_time":"2024-12-03T23:43:03.379171","exception":false,"start_time":"2024-12-03T23:43:03.338443","status":"completed"},"tags":[]},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n"," .dataframe tbody tr th:only-of-type {\n"," vertical-align: middle;\n"," }\n","\n"," .dataframe tbody tr th {\n"," vertical-align: top;\n"," }\n","\n"," .dataframe thead th {\n"," text-align: right;\n"," }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n"," <thead>\n"," <tr style=\"text-align: right;\">\n"," <th></th>\n"," <th>VIN (1-10)</th>\n"," <th>County</th>\n"," <th>City</th>\n"," <th>State</th>\n"," <th>Postal Code</th>\n"," <th>Model Year</th>\n"," <th>Make</th>\n"," <th>Model</th>\n"," <th>Electric Vehicle Type</th>\n"," <th>Clean Alternative Fuel Vehicle (CAFV) Eligibility</th>\n"," <th>Electric Range</th>\n"," <th>Base MSRP</th>\n"," <th>Legislative District</th>\n"," <th>DOL Vehicle ID</th>\n"," <th>Vehicle Location</th>\n"," <th>Electric Utility</th>\n"," <th>2020 Census Tract</th>\n"," </tr>\n"," </thead>\n"," <tbody>\n"," <tr>\n"," <th>0</th>\n"," <td>1N4AZ0CP8D</td>\n"," <td>King</td>\n"," <td>Shoreline</td>\n"," <td>WA</td>\n"," <td>98177.0</td>\n"," <td>2013</td>\n"," <td>NISSAN</td>\n"," <td>LEAF</td>\n"," <td>Battery Electric Vehicle (BEV)</td>\n"," <td>Clean Alternative Fuel Vehicle Eligible</td>\n"," <td>75.0</td>\n"," <td>0.0</td>\n"," <td>32.0</td>\n"," <td>125450447</td>\n"," <td>POINT (-122.36498 47.72238)</td>\n"," <td>CITY OF SEATTLE - (WA)|CITY OF TACOMA - (WA)</td>\n"," <td>5.303302e+10</td>\n"," </tr>\n"," <tr>\n"," <th>1</th>\n"," <td>5YJSA1E45K</td>\n"," <td>King</td>\n"," <td>Seattle</td>\n"," <td>WA</td>\n"," <td>98112.0</td>\n"," <td>2019</td>\n"," <td>TESLA</td>\n"," <td>MODEL S</td>\n"," <td>Battery Electric Vehicle (BEV)</td>\n"," <td>Clean Alternative Fuel Vehicle Eligible</td>\n"," <td>270.0</td>\n"," <td>0.0</td>\n"," <td>43.0</td>\n"," <td>101662900</td>\n"," <td>POINT (-122.30207 47.64085)</td>\n"," <td>CITY OF SEATTLE - (WA)|CITY OF TACOMA - (WA)</td>\n"," <td>5.303301e+10</td>\n"," </tr>\n"," <tr>\n"," <th>2</th>\n"," <td>WVGUNPE28M</td>\n"," <td>Kitsap</td>\n"," <td>Olalla</td>\n"," <td>WA</td>\n"," <td>98359.0</td>\n"," <td>2021</td>\n"," <td>VOLKSWAGEN</td>\n"," <td>ID.4</td>\n"," <td>Battery Electric Vehicle (BEV)</td>\n"," <td>Eligibility unknown as battery range has not been researched</td>\n"," <td>0.0</td>\n"," <td>0.0</td>\n"," <td>26.0</td>\n"," <td>272118717</td>\n"," <td>POINT (-122.54729 47.42602)</td>\n"," <td>PUGET SOUND ENERGY INC</td>\n"," <td>5.303509e+10</td>\n"," </tr>\n"," <tr>\n"," <th>3</th>\n"," <td>JTDKARFP6H</td>\n"," <td>Thurston</td>\n"," <td>Olympia</td>\n"," <td>WA</td>\n"," <td>98501.0</td>\n"," <td>2017</td>\n"," <td>TOYOTA</td>\n"," <td>PRIUS PRIME</td>\n"," <td>Plug-in Hybrid Electric Vehicle (PHEV)</td>\n"," <td>Not eligible due to low battery range</td>\n"," <td>25.0</td>\n"," <td>0.0</td>\n"," <td>22.0</td>\n"," <td>349372929</td>\n"," <td>POINT (-122.89166 47.03956)</td>\n"," <td>PUGET SOUND ENERGY INC</td>\n"," <td>5.306701e+10</td>\n"," </tr>\n"," <tr>\n"," <th>4</th>\n"," <td>1FADP5CU9G</td>\n"," <td>Thurston</td>\n"," <td>Olympia</td>\n"," <td>WA</td>\n"," <td>98506.0</td>\n"," <td>2016</td>\n"," <td>FORD</td>\n"," <td>C-MAX</td>\n"," <td>Plug-in Hybrid Electric Vehicle (PHEV)</td>\n"," <td>Not eligible due to low battery range</td>\n"," <td>19.0</td>\n"," <td>0.0</td>\n"," <td>22.0</td>\n"," <td>171625653</td>\n"," <td>POINT (-122.87741 47.05997)</td>\n"," <td>PUGET SOUND ENERGY INC</td>\n"," <td>5.306701e+10</td>\n"," </tr>\n"," <tr>\n"," <th>...</th>\n"," <td>...</td>\n"," <td>...</td>\n"," <td>...</td>\n"," <td>...</td>\n"," <td>...</td>\n"," <td>...</td>\n"," <td>...</td>\n"," <td>...</td>\n"," <td>...</td>\n"," <td>...</td>\n"," <td>...</td>\n"," <td>...</td>\n"," <td>...</td>\n"," <td>...</td>\n"," <td>...</td>\n"," <td>...</td>\n"," <td>...</td>\n"," </tr>\n"," <tr>\n"," <th>216767</th>\n"," <td>1G1RB6E44D</td>\n"," <td>Douglas</td>\n"," <td>East Wenatchee</td>\n"," <td>WA</td>\n"," <td>98802.0</td>\n"," <td>2013</td>\n"," <td>CHEVROLET</td>\n"," <td>VOLT</td>\n"," <td>Plug-in Hybrid Electric Vehicle (PHEV)</td>\n"," <td>Clean Alternative Fuel Vehicle Eligible</td>\n"," <td>38.0</td>\n"," <td>0.0</td>\n"," <td>12.0</td>\n"," <td>122822822</td>\n"," <td>POINT (-120.29473 47.41515)</td>\n"," <td>PUD NO 1 OF DOUGLAS COUNTY</td>\n"," <td>5.301795e+10</td>\n"," </tr>\n"," <tr>\n"," <th>216768</th>\n"," <td>KNDCS3LF9R</td>\n"," <td>Whatcom</td>\n"," <td>Bellingham</td>\n"," <td>WA</td>\n"," <td>98229.0</td>\n"," <td>2024</td>\n"," <td>KIA</td>\n"," <td>NIRO</td>\n"," <td>Plug-in Hybrid Electric Vehicle (PHEV)</td>\n"," <td>Clean Alternative Fuel Vehicle Eligible</td>\n"," <td>33.0</td>\n"," <td>0.0</td>\n"," <td>40.0</td>\n"," <td>267143887</td>\n"," <td>POINT (-122.45486 48.7449)</td>\n"," <td>PUGET SOUND ENERGY INC||PUD NO 1 OF WHATCOM COUNTY</td>\n"," <td>5.307300e+10</td>\n"," </tr>\n"," <tr>\n"," <th>216769</th>\n"," <td>7SAYGAEE9R</td>\n"," <td>King</td>\n"," <td>Redmond</td>\n"," <td>WA</td>\n"," <td>98052.0</td>\n"," <td>2024</td>\n"," <td>TESLA</td>\n"," <td>MODEL Y</td>\n"," <td>Battery Electric Vehicle (BEV)</td>\n"," <td>Eligibility unknown as battery range has not been researched</td>\n"," <td>0.0</td>\n"," <td>0.0</td>\n"," <td>48.0</td>\n"," <td>274988388</td>\n"," <td>POINT (-122.13158 47.67858)</td>\n"," <td>PUGET SOUND ENERGY INC||CITY OF TACOMA - (WA)</td>\n"," <td>5.303303e+10</td>\n"," </tr>\n"," <tr>\n"," <th>216770</th>\n"," <td>1G1RB6E49D</td>\n"," <td>Pierce</td>\n"," <td>Gig Harbor</td>\n"," <td>WA</td>\n"," <td>98329.0</td>\n"," <td>2013</td>\n"," <td>CHEVROLET</td>\n"," <td>VOLT</td>\n"," <td>Plug-in Hybrid Electric Vehicle (PHEV)</td>\n"," <td>Clean Alternative Fuel Vehicle Eligible</td>\n"," <td>38.0</td>\n"," <td>0.0</td>\n"," <td>26.0</td>\n"," <td>117353064</td>\n"," <td>POINT (-122.6658 47.38336)</td>\n"," <td>BONNEVILLE POWER ADMINISTRATION||CITY OF TACOMA - (WA)||PENINSULA LIGHT COMPANY</td>\n"," <td>5.305307e+10</td>\n"," </tr>\n"," <tr>\n"," <th>216771</th>\n"," <td>5YJ3E1EA1P</td>\n"," <td>Pierce</td>\n"," <td>Bonney Lake</td>\n"," <td>WA</td>\n"," <td>98391.0</td>\n"," <td>2023</td>\n"," <td>TESLA</td>\n"," <td>MODEL 3</td>\n"," <td>Battery Electric Vehicle (BEV)</td>\n"," <td>Eligibility unknown as battery range has not been researched</td>\n"," <td>0.0</td>\n"," <td>0.0</td>\n"," <td>31.0</td>\n"," <td>240754006</td>\n"," <td>POINT (-122.17144 47.19175)</td>\n"," <td>PUGET SOUND ENERGY INC||CITY OF TACOMA - (WA)</td>\n"," <td>5.305307e+10</td>\n"," </tr>\n"," </tbody>\n","</table>\n","<p>216296 rows × 17 columns</p>\n","</div>"],"text/plain":[" VIN (1-10) County City State Postal Code Model Year \\\n","0 1N4AZ0CP8D King Shoreline WA 98177.0 2013 \n","1 5YJSA1E45K King Seattle WA 98112.0 2019 \n","2 WVGUNPE28M Kitsap Olalla WA 98359.0 2021 \n","3 JTDKARFP6H Thurston Olympia WA 98501.0 2017 \n","4 1FADP5CU9G Thurston Olympia WA 98506.0 2016 \n","... ... ... ... ... ... ... \n","216767 1G1RB6E44D Douglas East Wenatchee WA 98802.0 2013 \n","216768 KNDCS3LF9R Whatcom Bellingham WA 98229.0 2024 \n","216769 7SAYGAEE9R King Redmond WA 98052.0 2024 \n","216770 1G1RB6E49D Pierce Gig Harbor WA 98329.0 2013 \n","216771 5YJ3E1EA1P Pierce Bonney Lake WA 98391.0 2023 \n","\n"," Make Model Electric Vehicle Type \\\n","0 NISSAN LEAF Battery Electric Vehicle (BEV) \n","1 TESLA MODEL S Battery Electric Vehicle (BEV) \n","2 VOLKSWAGEN ID.4 Battery Electric Vehicle (BEV) \n","3 TOYOTA PRIUS PRIME Plug-in Hybrid Electric Vehicle (PHEV) \n","4 FORD C-MAX Plug-in Hybrid Electric Vehicle (PHEV) \n","... ... ... ... \n","216767 CHEVROLET VOLT Plug-in Hybrid Electric Vehicle (PHEV) \n","216768 KIA NIRO Plug-in Hybrid Electric Vehicle (PHEV) \n","216769 TESLA MODEL Y Battery Electric Vehicle (BEV) \n","216770 CHEVROLET VOLT Plug-in Hybrid Electric Vehicle (PHEV) \n","216771 TESLA MODEL 3 Battery Electric Vehicle (BEV) \n","\n"," Clean Alternative Fuel Vehicle (CAFV) Eligibility \\\n","0 Clean Alternative Fuel Vehicle Eligible \n","1 Clean Alternative Fuel Vehicle Eligible \n","2 Eligibility unknown as battery range has not been researched \n","3 Not eligible due to low battery range \n","4 Not eligible due to low battery range \n","... ... \n","216767 Clean Alternative Fuel Vehicle Eligible \n","216768 Clean Alternative Fuel Vehicle Eligible \n","216769 Eligibility unknown as battery range has not been researched \n","216770 Clean Alternative Fuel Vehicle Eligible \n","216771 Eligibility unknown as battery range has not been researched \n","\n"," Electric Range Base MSRP Legislative District DOL Vehicle ID \\\n","0 75.0 0.0 32.0 125450447 \n","1 270.0 0.0 43.0 101662900 \n","2 0.0 0.0 26.0 272118717 \n","3 25.0 0.0 22.0 349372929 \n","4 19.0 0.0 22.0 171625653 \n","... ... ... ... ... \n","216767 38.0 0.0 12.0 122822822 \n","216768 33.0 0.0 40.0 267143887 \n","216769 0.0 0.0 48.0 274988388 \n","216770 38.0 0.0 26.0 117353064 \n","216771 0.0 0.0 31.0 240754006 \n","\n"," Vehicle Location \\\n","0 POINT (-122.36498 47.72238) \n","1 POINT (-122.30207 47.64085) \n","2 POINT (-122.54729 47.42602) \n","3 POINT (-122.89166 47.03956) \n","4 POINT (-122.87741 47.05997) \n","... ... \n","216767 POINT (-120.29473 47.41515) \n","216768 POINT (-122.45486 48.7449) \n","216769 POINT (-122.13158 47.67858) \n","216770 POINT (-122.6658 47.38336) \n","216771 POINT (-122.17144 47.19175) \n","\n"," Electric Utility \\\n","0 CITY OF SEATTLE - (WA)|CITY OF TACOMA - (WA) \n","1 CITY OF SEATTLE - (WA)|CITY OF TACOMA - (WA) \n","2 PUGET SOUND ENERGY INC \n","3 PUGET SOUND ENERGY INC \n","4 PUGET SOUND ENERGY INC \n","... ... \n","216767 PUD NO 1 OF DOUGLAS COUNTY \n","216768 PUGET SOUND ENERGY INC||PUD NO 1 OF WHATCOM COUNTY \n","216769 PUGET SOUND ENERGY INC||CITY OF TACOMA - (WA) \n","216770 BONNEVILLE POWER ADMINISTRATION||CITY OF TACOMA - (WA)||PENINSULA LIGHT COMPANY \n","216771 PUGET SOUND ENERGY INC||CITY OF TACOMA - (WA) \n","\n"," 2020 Census Tract \n","0 5.303302e+10 \n","1 5.303301e+10 \n","2 5.303509e+10 \n","3 5.306701e+10 \n","4 5.306701e+10 \n","... ... \n","216767 5.301795e+10 \n","216768 5.307300e+10 \n","216769 5.303303e+10 \n","216770 5.305307e+10 \n","216771 5.305307e+10 \n","\n","[216296 rows x 17 columns]"]},"execution_count":2,"metadata":{},"output_type":"execute_result"}],"source":["df"]},{"cell_type":"markdown","id":"f895d0c9","metadata":{"papermill":{"duration":0.00255,"end_time":"2024-12-03T23:43:03.384648","exception":false,"start_time":"2024-12-03T23:43:03.382098","status":"completed"},"tags":[]},"source":["## What can these variables help us answer?"]}],"metadata":{"kaggle":{"accelerator":"none","dataSources":[{"datasetId":6223869,"sourceId":10092934,"sourceType":"datasetVersion"}],"dockerImageVersionId":30804,"isGpuEnabled":false,"isInternetEnabled":true,"language":"python","sourceType":"notebook"},"kernelspec":{"display_name":"Python 3","language":"python","name":"python3"},"language_info":{"codemirror_mode":{"name":"ipython","version":3},"file_extension":".py","mimetype":"text/x-python","name":"python","nbconvert_exporter":"python","pygments_lexer":"ipython3","version":"3.10.14"},"papermill":{"default_parameters":{},"duration":20.677287,"end_time":"2024-12-03T23:43:04.11005","environment_variables":{},"exception":null,"input_path":"__notebook__.ipynb","output_path":"__notebook__.ipynb","parameters":{},"start_time":"2024-12-03T23:42:43.432763","version":"2.6.0"}},"nbformat":4,"nbformat_minor":5}