A simple dashboard showing how fuel prices have evolved in Brazil since 2004 until 2018. Just a set of plots organized by time and brazillian regions. Results discussion is left to the reader.
Photo by Austrian National Library
The dataset behind the plots is provided by the brazillian government through ANP (Agência Nacional do Petróleo, Gás Natural e Biocombustíveis).
Fuel prices in Brazil
The dashboard tries to address three questions:
- How do fuel prices vary, in average, among distributors?
- How do fuel prices vary, in average, between states?
- What is the average profit margin by state?
The dataset is modestly sized, with information about 554 municipalities, 252 distributors, 25459 fuel stations, and for a period between 2004 and 2018.
ℹ️ Note: Some of the plots regarding NGV fuel may seem incomplete for different states. I can only suspect that either these states have not sold NGV in the past, or the dataset provided by ANP is missing data. Also, and since DIESEL S10 was only introduced in 2013, the respective plots only show data for the period between 2013 and 2018.
The dashboard was written in Python, powered by Pandas and Bokeh, and rendered with Jinja into a Bootstrap" styled single HTML file.