The dataset of decision matrices including share of alternative fuels in road transport in European countries
Description
The dataset of decision matrices, including data representing a share of 9 alternative types of fuel exploited in road transport collected for 32 European countries for 2013-2020. Data was acquired from Eurostat. Eurostat provides these data in the unit of Thousand tonnes of oil equivalent. In order to assess the sustainable share of alternative fuels in road transportation, datasets were prepared based on the data available in the Eurostat database, containing values for the percentage share of individual alternative fuels in the total volume of all fuels covering both conventional and alternative types. The folder named dane.zip includes 8 XLSX files with decision matrices for each year from 2013 to 2020, an XLSX file with country symbols and names, and a TEX file including LaTeX data format presented in PDF.
Files
Steps to reproduce
The data collection procedure was as follows. First, the original XLSX files were downloaded from the Eurostat database for each of the nine types of alternative fuels, and the total amount of all fuels utilized containing data on fuel consumption by European countries for each year, a total of 10 files. The data were then preprocessed and checked for completeness. Subsequently, separate XLSX files were created for each of the selected years 2013-2020, containing all types of alternative fuels considered in the following columns and the total amount of all fuels in the last column. These files were prepared in an automated process with a Python script, using the pandas library to load, analyze, and work with the data. In the next step, using another Python script, it was calculated what percentage of the total amount of all fuels is represented by each alternative fuel, and files containing these values were created. Eight XLSX files were obtained for the years 2013-2020 containing data on the percentage of 9 alternative fuels in the following columns for the 32 European countries considered in the subsequent rows.
Institutions
Categories
Funding
Narodowe Centrum Nauki
2022/45/B/HS4/02960