# Fleet Registration Summary Methodology

Generated: 2026-06-18

## Scope
This dataset aggregates publicly available Nigerian road-transport and automotive-industry statistics relevant to fleet estimation. It is named "fleet_registration_summary" because it is intended to support fleet modelling, but the underlying inputs are heterogeneous and include number-plate production, road-traffic-crash vehicle categories, drivers-license issuance, fleet-operator registration, and automotive policy targets.

## Sources processed

### NBS Road Transport Excel files
- `NBS_Road_Transport_Data_Q4_2023.xlsx`
- `NBS_Road_Transport_Data_Q2_2024.xlsx`
- `NBS_Road_Transport_Data_Q3_2024.xlsx`
- `NBS_Road_Transport_Q4_2024_Q1_Q2_2025.zip` (contains `Road Transport Data Q4_2024.xlsx`, `Road Transport Data Q1_2025.xlsx`, `Road Transport Data Q2_2025.xlsx`, plus PDFs)

All NBS Excel workbooks contain a single sheet `Sheet1`. The relevant table is titled **"NUMBER OF VEHICLES INVOLVED IN ROAD TRAFFIC CRASHES"** (rows ~70-85). It lists vehicle categories with absolute counts and percentage shares.

**Important caveat:** These values are **vehicles involved in road traffic crashes**, not registered fleet totals. They are included because they are the only vehicle-category breakdown available in the supplied NBS transport datasets.

### FRSC Statistical Digests
- `FRSC_Stats_Digest_Q1_2024.md`
- `FRSC_Stats_Digest_Q2_2023.md`

Extracted:
- Number-plate production by category (Table 9, Motor Vehicle Administration)
- National Drivers License totals (Table 10)
- Fleet operators registered (Table 25, Corps Transport and Standardization Office)

### NADDC NAIDP 2023
- `NADDC_NAIDP_2023.md`

Extracted production, import, capacity, and policy-target figures with years.

## Normalization rules

| Raw category | Normalized vehicle_type | Rationale |
|---|---|---|
| car | car | Direct match |
| minibus, luxury bus, bus | bus | All passenger-carrying vehicles with 9+ seats or small commercial people-movers |
| motorcycle | motorcycle | Direct match |
| tricycle | tricycle | Direct match |
| truck, lorry | light_truck | Light goods/commercial vehicles |
| tanker, trailer | heavy_truck | Heavy goods vehicles / articulated freight |
| total, grand total | total | Aggregate rows |

Taxi is not present in any source; no rows were generated for it.

## Data quality flags

| Flag | Meaning |
|---|---|
| high | Exact numeric value taken directly from a labelled table |
| medium | Value requires interpretation, aggregation, or is approximate language in source (e.g. "about", "over") |

## Skipped sources

| Source | Reason |
|---|---|
| `NBS_Road_Transport_Data_Q2_2024.xlsx` | Duplicate vehicle-category table; identical to first NBS Excel processed |
| `NBS_Road_Transport_Data_Q3_2024.xlsx` | Duplicate vehicle-category table; identical to first NBS Excel processed |
| `Road_Transport _Q2_2025.pdf (in NBS_Road_Transport_Q4_2024_Q1_Q2_2025.zip)` | PDF format; not parsed (task requested Excel data extraction) |
| `Road_Transport__Q1_2025.pdf (in NBS_Road_Transport_Q4_2024_Q1_Q2_2025.zip)` | PDF format; not parsed (task requested Excel data extraction) |
| `Road_Transport _Q4_2024.pdf (in NBS_Road_Transport_Q4_2024_Q1_Q2_2025.zip)` | PDF format; not parsed (task requested Excel data extraction) |
| `Road Transport Data Q2_2025.xlsx (in NBS_Road_Transport_Q4_2024_Q1_Q2_2025.zip)` | Duplicate vehicle-category table; identical to NBS_Road_Transport_Data_Q4_2023.xlsx |
| `Road Transport Data Q1_2025.xlsx (in NBS_Road_Transport_Q4_2024_Q1_Q2_2025.zip)` | Duplicate vehicle-category table; identical to NBS_Road_Transport_Data_Q4_2023.xlsx |
| `Road Transport Data Q4_2024.xlsx (in NBS_Road_Transport_Q4_2024_Q1_Q2_2025.zip)` | Duplicate vehicle-category table; identical to NBS_Road_Transport_Data_Q4_2023.xlsx |

## Output
- `fleet_registration_summary.csv`: one row per extracted metric.
- `fleet_registration_summary_methodology.md`: this file.