{ "cells": [ { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "%pip install -q folium\n", "%pip install -q matplotlib\n", "%pip install -q pandas\n", "%pip install -q requests\n", "%pip install -q seaborn" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Modules are imported.\n" ] } ], "source": [ "import pandas as pd\n", "import matplotlib.pyplot as plt\n", "%matplotlib inline\n", "plt.style.use('seaborn')\n", "\n", "print('Modules are imported.')" ] }, { "cell_type": "code", "execution_count": 12, "metadata": {}, "outputs": [], "source": [ "df = pd.read_json('./data/moatsystems_ev_charging_station.json')" ] }, { "cell_type": "code", "execution_count": 13, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
| \n", " | id | \n", "chargeDeviceID | \n", "reference | \n", "name | \n", "latitude | \n", "longitude | \n", "subBuildingName | \n", "buildingName | \n", "buildingNumber | \n", "thoroughfare | \n", "... | \n", "connector8Type | \n", "connector8RatedOutputKW | \n", "connector8OutputCurrent | \n", "connector8RatedVoltage | \n", "connector8ChargeMethod | \n", "connector8ChargeMode | \n", "connector8TetheredCable | \n", "connector8Status | \n", "connector8Description | \n", "connector8Validated | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "7db2224a-8fef-468a-897e-6f92efe023fe | \n", "9c8661befae6dbcd08304dbf4dcaf0db | \n", "SC22 | \n", "Little Victoria St Car Park - Socket 2 | \n", "54.592703 | \n", "-5.933430 | \n", "None | \n", "DRD Roads Service Car Park | \n", "4 | \n", "Downshire Place | \n", "... | \n", "None | \n", "NaN | \n", "NaN | \n", "NaN | \n", "None | \n", "NaN | \n", "NaN | \n", "None | \n", "NaN | \n", "NaN | \n", "
| 1 | \n", "553542b8-e033-465c-bdfd-f19b0f7c31b7 | \n", "52b738b303d90a884137546353e09ebb | \n", "SC23 | \n", "Little Donegall Street, Belfast (Socket | \n", "54.604646 | \n", "-5.931866 | \n", "None | \n", "None | \n", "128 | \n", "Little Donegall Street | \n", "... | \n", "None | \n", "NaN | \n", "NaN | \n", "NaN | \n", "None | \n", "NaN | \n", "NaN | \n", "None | \n", "NaN | \n", "NaN | \n", "
| 2 | \n", "ab00a4df-215b-44ce-a84d-93b1fef6f043 | \n", "b58ac8403eb9cf17fae1dcd16df71fde | \n", "SC33 | \n", "Cromac Street Car Park (Socket 2) | \n", "54.594109 | \n", "-5.924292 | \n", "None | \n", "None | \n", "89-97 | \n", "Cromac Street | \n", "... | \n", "None | \n", "NaN | \n", "NaN | \n", "NaN | \n", "None | \n", "NaN | \n", "NaN | \n", "None | \n", "NaN | \n", "NaN | \n", "
| 3 | \n", "5e56086e-a688-4c2c-ae2e-7fe732d20123 | \n", "fd8c07a31f8a85910ad8476f5f7efb27 | \n", "SC03 | \n", "Hope Street Car Park, Belfast (Socket 2) | \n", "54.593365 | \n", "-5.935574 | \n", "None | \n", "None | \n", "205 | \n", "Sandy Row | \n", "... | \n", "None | \n", "NaN | \n", "NaN | \n", "NaN | \n", "None | \n", "NaN | \n", "NaN | \n", "None | \n", "NaN | \n", "NaN | \n", "
| 4 | \n", "9eac95d8-d27d-47f5-85df-2d6de4e5c0c8 | \n", "f507783927f2ec2737ba40afbd17efb5 | \n", "SC19 | \n", "Adelaide Street, Belfast (Socket 2) | \n", "54.594342 | \n", "-5.928256 | \n", "None | \n", "None | \n", "23-91 | \n", "Adelaide Street | \n", "... | \n", "None | \n", "NaN | \n", "NaN | \n", "NaN | \n", "None | \n", "NaN | \n", "NaN | \n", "None | \n", "NaN | \n", "NaN | \n", "
5 rows × 159 columns
\n", "| \n", " | latitude | \n", "longitude | \n", "deviceOwnerContactName | \n", "deviceControllerContactName | \n", "deviceValidated | \n", "dateDeleted | \n", "paymentRequired | \n", "subscriptionRequired | \n", "parkingFeesFlag | \n", "accessRestrictionFlag | \n", "... | \n", "connector7Description | \n", "connector7Validated | \n", "connector8ID | \n", "connector8RatedOutputKW | \n", "connector8OutputCurrent | \n", "connector8RatedVoltage | \n", "connector8ChargeMode | \n", "connector8TetheredCable | \n", "connector8Description | \n", "connector8Validated | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| count | \n", "23838.000000 | \n", "23840.000000 | \n", "2.0 | \n", "2.0 | \n", "23840.000000 | \n", "2.0 | \n", "23654.000000 | \n", "23838.000000 | \n", "23838.000000 | \n", "23838.000000 | \n", "... | \n", "0.0 | \n", "14.0 | \n", "12.000000 | \n", "12.000000 | \n", "12.000000 | \n", "12.000000 | \n", "12.000000 | \n", "12.000000 | \n", "0.0 | \n", "12.0 | \n", "
| mean | \n", "52.229395 | \n", "-1.151391 | \n", "3.0 | \n", "0.0 | \n", "0.002685 | \n", "0.0 | \n", "0.385601 | \n", "0.355651 | \n", "0.099631 | \n", "0.027645 | \n", "... | \n", "NaN | \n", "0.0 | \n", "164415.000000 | \n", "77.450000 | \n", "168.250000 | \n", "564.166667 | \n", "3.416667 | \n", "0.416667 | \n", "NaN | \n", "0.0 | \n", "
| std | \n", "1.721908 | \n", "1.487102 | \n", "0.0 | \n", "0.0 | \n", "0.293091 | \n", "0.0 | \n", "0.486747 | \n", "0.478720 | \n", "0.299513 | \n", "0.163957 | \n", "... | \n", "NaN | \n", "0.0 | \n", "1119.781878 | \n", "86.145411 | \n", "182.596488 | \n", "329.833521 | \n", "0.514929 | \n", "0.514929 | \n", "NaN | \n", "0.0 | \n", "
| min | \n", "0.000000 | \n", "-60.953945 | \n", "3.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "NaN | \n", "0.0 | \n", "163613.000000 | \n", "3.700000 | \n", "16.000000 | \n", "230.000000 | \n", "3.000000 | \n", "0.000000 | \n", "NaN | \n", "0.0 | \n", "
| 25% | \n", "51.459551 | \n", "-1.774669 | \n", "3.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "NaN | \n", "0.0 | \n", "163660.000000 | \n", "7.000000 | \n", "16.000000 | \n", "230.000000 | \n", "3.000000 | \n", "0.000000 | \n", "NaN | \n", "0.0 | \n", "
| 50% | \n", "51.536220 | \n", "-0.710762 | \n", "3.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "NaN | \n", "0.0 | \n", "163935.000000 | \n", "11.000000 | \n", "32.000000 | \n", "400.000000 | \n", "3.000000 | \n", "0.000000 | \n", "NaN | \n", "0.0 | \n", "
| 75% | \n", "52.910899 | \n", "-0.178640 | \n", "3.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "1.000000 | \n", "1.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "NaN | \n", "0.0 | \n", "164432.750000 | \n", "175.000000 | \n", "375.000000 | \n", "930.000000 | \n", "4.000000 | \n", "1.000000 | \n", "NaN | \n", "0.0 | \n", "
| max | \n", "60.759109 | \n", "51.595946 | \n", "3.0 | \n", "0.0 | \n", "32.000000 | \n", "0.0 | \n", "1.000000 | \n", "1.000000 | \n", "1.000000 | \n", "1.000000 | \n", "... | \n", "NaN | \n", "0.0 | \n", "166441.000000 | \n", "175.000000 | \n", "375.000000 | \n", "930.000000 | \n", "4.000000 | \n", "1.000000 | \n", "NaN | \n", "0.0 | \n", "
8 rows × 71 columns
\n", "