Dataset: Alternative Fueling Station Counts ByState 2007-23

About this Dataset

Alternative Fueling Station Counts ByState 2007-23

The information was obtained from https://afdc.energy.gov/stations/states and downloaded as an excel .xlxs file.

The original excel file was processed and normalized, these were the main tasks performed:

The 'Year' column was added to identify which year the data belongs to.
Replacing NaN values with 0.
Transformation of float64 columns to int64.
Generation of new columns with new data from 2014: Propane_Primary, Propane_Secondary, Propane_Total, Hydrogen_Retail, Hydrogen_Non_Retail, Hydrogen_Total, Electric_station, Electric_outlets, Electric_Level1, Electric_Level2, Electric_DC_Fast.
Elimination of repeated columns: Electric, Hydrogen & Propane.
'Renewable Diesel' columns applied to all years.
Comments were removed.
The rows with the totals ('Total') were also eliminated.
Rows with NaN values were deleted.
Replaced values separated by '/' to '|' to be able to process complementary records.
Thousand separators removed.

Tables

Alternative Fueling Station Counts By State 2007–2023

@kaggle.omanofx_alternative_fueling_station_counts_bystate_2014_23.alternative_fueling_station_counts_by_state_2007_2023

35.74 KB
867 rows
19 columns


CREATE TABLE alternative_fueling_station_counts_by_state_2007_2023 (
  "state" VARCHAR,
  "biodiesel" BIGINT,
  "cng" BIGINT,
  "e85" BIGINT,
  "lng" BIGINT,
  "renewable_diesel" BIGINT,
  "total" BIGINT,
  "year" BIGINT,
  "propane_primary" BIGINT,
  "propane_secondary" BIGINT,
  "propane_total" BIGINT,
  "hydrogen_retail" BIGINT,
  "hydrogen_non_retail" BIGINT,
  "hydrogen_total" BIGINT,
  "electric_stations" BIGINT,
  "electric_outlets" BIGINT,
  "electric_level1" BIGINT,
  "electric_level2" BIGINT,
  "electric_dc_fast" BIGINT
);