Aggregates fuel prices including TVA per month, per year and per region or France in CSV files.
Retrieves all available fuel prices (SP 95, SP 98, super leaded, gasoil, SP E10) on the INSEE website.
Creates 2 CSV files, fuel prices per year, in liter and in hectoliter.
Create 2 CSV files, of the prices of fuels per month, in liter and in hectoliter.
Retrieves all available fuel prices, including VAT, by service station, fuel type (SP 95, SP 98, E85, diesel, SP E10, GPLc) and by day, on the site website prix-carburant.gouv.fr.
Finds the region code of each gas station (using APIs, and starting from the latitude and longitude and/or the postal code, to find the citycode, then the departement code, then the region code).
Creates 2 CSV file, of the aggregated fuel prices by region and by year, in liter and in hectoliter.
Create 2 CSV file, of the fuel prices by region and by month, in liter and in hectoliter.
Create 2 files of aggregated prices at the national level to be able to check the accuracy compared to the data of the INSEE.
git clone https://git.leximpact.dev/leximpact/prix-carburants.git
cd prix-carburantsThese scripts require Python3, Jupyterlab and Pandas and requests.
python3 -m venv .venv
source .venv/bin/activate
pip install jupyterlab
pip install pandas
pip install requestsjupyter-labFor prices by month and year from INSEE, open notebook_insee.prix_carburant.ipynb.
For aggregate prices by region, month, and year, open notebook_gouv.fuel_price.ipyn.
WARNING: It is necessary to create an account on the INSEE APIs catalog website, and create a token to use the API "Metadata - V1" (The token works for 7 days). The token will have to be integrated directly in the notebook.
REMARK: CSV files are available directly without using the code.
LexImpact Fuel Prices is a free software under licence GNU Affero General Public License.
Copyright (c) 2022 French National Assembly
Author : Kendrick Herzberg, [email protected]