Converting raw datasets into one .csv file with standard columns and units

[TheYuanLiao]

Applicable for the datasets downloaded from apps.kapsarc.org/. IK2 Open Data API. 1 electricity-consumption-by-industry-transport-activities-and-householdsservices-.csv 2 final-energy-consumption-by-product.csv 3 freight-transport.csv 4 goods-road-vehicle-fleet-by-vehicle-category-and-permissible-maximum-gross-weigh.csv 5 goods-transport-by-rail.csv 6 modal-split-of-freight-transport.csv 7 modal-split-of-passenger-transport.csv 8 new-goods-road-vehicles-registered-by-vehicle-category-and-permissible-maximum-g.csv 9 new-passenger-car-registrations-by-fuel-type.csv 10 new-road-vehicle-registrations-by-vehicle-category-and-fuel-type.csv 11 passenger-road-vehicle-fleet-and-rate-per-thousand-inhabitants-by-vehicle-catego.csv 12 passenger-transport.csv 13 rail-transport-of-passengers.csv 14 road-vehicle-fleet-by-vehicle-category-and-fuel-type.csv 15 volume-of-passenger-transport-relative-to-gdp.csv