thisisbahbah/ng_oil_gas_dashboard

Nigeria crude oil production analytics — trends, shut-in volumes, Brent price correlation. Python · PostgreSQL · Streamlit. # Nigeria Oil & Gas Production Analytics Dashboard A data engineering and analytics project tracking Nigerian crude oil production trends, shut-in volumes, and Brent price correlations using public data from NUPRC, OPEC, and EIA. **Live Demo:** your-app.streamlit.app ← update after deployment **Author:** Oluwafemi — LinkedIn · Medium --- ## What This Dashboard Shows | Chart | What It Answers | |---|---| | Production trend (2010–present) | Is Nigeria hitting its OPEC quota? | | Field-level breakdown | Which fields drive national output? | | Shut-in volume tracker | How much capacity is offline and why? | | Brent price correlation | Does price movement predict production changes? | | Year-on-year delta | How fast is Nigeria's output declining or recovering? | --- ## Data Sources | Source | What | URL | Format | |---|---|---|---| | NUPRC | Monthly crude production by field | nuprc.gov.ng | PDF/CSV | | OPEC | Nigeria production quota & actual | opec.org | CSV | | EIA | Brent crude spot price | eia.gov | API (free key) | | EIA | Nigeria production (barrels/day) | eia.gov | API (free key) | All data is publicly available. No proprietary or confidential data is used. --- ## Tech Stack ``` Data Layer : Python (requests, pandas) → PostgreSQL Transformation : SQL views (production analytics) Dashboard : Streamlit + Plotly Deployment : Streamlit Community Cloud (free) ``` --- ## Project Structure ``` ng_oil_gas_dashboard/ ├── data/ │ ├── raw/ # Downloaded CSVs (gitignored) │ └── processed/ # Cleaned, schema-consistent CSVs ├── sql/ │ ├── schema.sql # Table definitions │ └── views.sql # Analytics views ├── scripts/ │ ├── ingest_eia.py # EIA API ingestion │ ├── ingest_nuprc.py # NUPRC/OPEC CSV ingestion │ ├── clean.py # Cleaning & normalisation │ └── load_db.py # Load processed data to PostgreSQL ├── dashboard/ │ └── app.py # Str …