For a Chemistry student there is something compelling about how liquid energy markets actually are, and I don’t just mean the NGLs! When I came across the UK government's Supply and Use of Crude Oil and Natural Gas Liquids dataset, it struck me as a good opportunity to apply my data skills.
My analysis focused on uncovering patterns in four key areas:
- Domestic production trends
- Import/export dynamics
- Stock level variations
- Seasonal consumption behaviours
This project was a good intro project into handling real-world energy data, from restructuring spreadsheet data to creating visualisations that tell a story.
It involved:
- Conducting full EDA using Python (Pandas/Matplotlib)
- Developing custom time-series analysis for seasonal adjustments
- Creating visualisation for stakeholder perspectives
For those interested, feel free to check out the full Jupyter notebook on GitHub: UK Energy Analysis Repo