Data sources
Yu Liu is interested in clean energy and would like to do a project related to it. Other group members agreed since sustainable lifestyle is a trending topic, and it is a responsibility for data scientists to utilize data for good. After searching on the internet, we decided to focus on electric vehicles (EVs).
We scheduled zoom meetings to collect the data together. When collecting data, we also considered to do a solar electric program based on this data source (https://data.ny.gov/Energy-Environment/Solar-Electric-Programs-Reported-by-NYSERDA-Beginn/3x8r-34rs) since this data source has more rows. However,in the end, we believe electric cars are more popular in recent years, and this theme seems to be more attractive than solar electric.
We hope that people can pay more attention to clean energy and environmental protection. Using a popular topic can attract people’s attention more easily. Obviously, cars are much more popular than solar energy. Therefore,in the end we choose electric vehicles as our project theme. Related EV datasets are downloaded from this website (https://www.nyserda.ny.gov/All-Programs/Programs/ChargeNY/Support-Electric/Data-on-Electric-Vehicles-and-Charging-Stations). We may use the EV registration map and EV charging station map.
There are 31 columns in the charging stations dataset, including station zipcode, name, fuel type, payment methods, EV connector types and many other metrics specific to EVs. Except for columns like zipcode and phone number, the majority of variables are either categorical or numerical. The data set includes 1865 rows. Many columns have missing values.
EV registration map dataset contains 46842 registrations records and 6 sub charts, i.e. 6 ways of categorization: current registration by utility, by zipcode, by make-model, by country, original by make and original by time. This datafile does not have any missing values.
There are also some issues here. Firstly, registration map is in .xlsx, and requires additional processing to get desired format. Secondly, the location details in the charging station dataset are subject to change. It’s better to call the stations to verify a station’s information, such as open time, hours of operation, availability to the public, and if has the desired alternative fuel prior to making a trip to that location.
EV charging stations data
Table continues below
ELEC |
Sky Zone Trampoline Park |
33 LeCount Pl |
ELEC |
Village of Montour Falls |
300 W Main St |
ELEC |
24 STATE STREET |
35 Lincoln Ave |
ELEC |
BMW FREEPORT |
100 Cleveland Ave |
ELEC |
HATCHET HARDWARE |
42 SARATOGA AVE |
ELEC |
Icon Liberty View Parking -
Tesla Destination |
400 Murray St |
Table continues below
|
New Rochelle |
NY |
10801 |
NA |
Behind Main Street Park |
Montour Falls |
NY |
14865 |
NA |
SPIEGEL CENTER |
Pittsford |
NY |
14534 |
NA |
STATION 01; - |
Freeport |
NY |
11520 |
NA |
|
WATERFORD |
NY |
12188 |
NA |
|
New York |
NY |
10016 |
NA |
Table continues below
866-816-7584 |
E |
NA |
607-535-7367 866-816-7584 |
E |
NA |
888-758-4389 |
E |
NA |
888-758-4389 |
E |
NA |
888-356-8911 |
E |
NA |
212-842-2305 877-798-3752 |
E |
NA |
Table continues below
Public |
Business hours |
|
Public |
24 hours daily |
|
Public |
24 hours daily |
|
Public |
24 hours daily |
|
Public |
24 hours daily |
|
Public |
24 hours daily; see valet for
access |
|
Table continues below
NA |
4 |
NA |
NA |
NA |
2 |
NA |
NA |
NA |
2 |
NA |
NA |
NA |
2 |
NA |
NA |
NA |
2 |
NA |
NA |
NA |
3 |
NA |
NA |
Table continues below
200-9 |
40.91 |
-73.78 |
04/08/2020 |
94853 |
GPS |
42.35 |
-76.85 |
06/09/2020 |
121285 |
GPS |
43.09 |
-77.52 |
12/16/2020 |
147217 |
GPS |
40.65 |
-73.57 |
12/16/2020 |
162449 |
200-9 |
42.78 |
-73.7 |
12/16/2020 |
165117 |
GPS |
40.72 |
-74.02 |
11/03/2020 |
115121 |
Table continues below
2020-04-08 12:29:55 |
P |
NA |
2020-06-09 16:47:26 |
LG |
NA |
2020-12-16 00:24:35 |
|
NA |
2020-12-16 00:24:35 |
|
NA |
2020-12-16 01:29:55 |
|
NA |
2020-11-18 00:06:10 |
P |
NA |
|
03/28/2016 |
J1772 |
|
04/01/2018 |
J1772 |
|
|
J1772 |
|
|
J1772 |
|
|
J1772 |
|
09/01/2017 |
J1772 TESLA |
EV Registration data: Current by utility
Steuben Rural Elec Coop, Inc |
53 |
24 |
77 |
Rochester Gas & Electric Corp |
1901 |
983 |
2884 |
Orange & Rockland Utils Inc |
778 |
769 |
1547 |
Village of Rouses Point - (NY) |
1 |
0 |
1 |
Village of Rockville Centre -
(NY) |
53 |
53 |
106 |
Village of Freeport - (NY) |
42 |
24 |
66 |
EV Registration data: Current by zipcode
13244 |
0 |
1 |
1 |
13301 |
1 |
0 |
1 |
13302 |
1 |
0 |
1 |
13219 |
18 |
7 |
25 |
13220 |
0 |
1 |
1 |
13224 |
28 |
7 |
35 |
EV Registration data: Current by make-model
Tesla |
Model 3 |
7080 |
Toyota |
Prius Prime |
6483 |
Tesla |
Model S |
4266 |
Chevrolet |
Volt |
4222 |
Ford |
Fusion Energi |
3427 |
Tesla |
Model X |
2802 |
EV Registration data: Current by county
Richmond County |
539 |
351 |
890 |
Rensselaer County |
258 |
154 |
412 |
Queens County |
1811 |
1473 |
3284 |
Rockland County |
436 |
523 |
959 |
Schoharie County |
44 |
17 |
61 |
Schenectady County |
384 |
208 |
592 |
EV Registration data: Original over time
2011 |
December |
90 |
71 |
161 |
2012 |
December |
2881 |
576 |
3457 |
2013 |
December |
3323 |
1209 |
4532 |
2014 |
December |
3447 |
1197 |
4644 |
2015 |
December |
2398 |
1347 |
3745 |
2016 |
January |
220 |
77 |
297 |
EV Registration data: Original by make
2011 |
4 |
Smart |
0 |
10 |
10 |
2011 |
4 |
Smith |
0 |
7 |
7 |
2011 |
4 |
Tesla |
0 |
37 |
37 |
2011 |
4 |
Porsche |
35 |
0 |
35 |
2011 |
4 |
Azure |
0 |
2 |
2 |
2011 |
4 |
Chevrolet |
55 |
0 |
55 |