electricsheepafrica/africa-ports-madagascar

---
annotations_creators:
- no-annotation
language_creators:
- found
language:
- en
license: other
multilinguality:
- monolingual
size_categories:
- 10K<n<100K
source_datasets:
- original
task_categories:
- tabular-classification
- tabular-regression
task_ids: []
tags:
- africa
- humanitarian
- hdx
- electric-sheep-africa
- ports
- trade
- mdg
pretty_name: "Madagascar: Daily Port Activity Data and Shipment Estimates"
dataset_info:
splits:
- name: train
num_examples: 12787
- name: test
num_examples: 3196
---

# Madagascar: Daily Port Activity Data and Shipment Estimates

**Publisher:** PortWatch · **Source:** [HDX](https://data.humdata.org/dataset/madagascar-daily-port-activity-data-and-shipment-estimates) · **License:** `hdx-other` · **Updated:** 2026-04-21

---

## Abstract

Daily count of port calls, estimates of incoming shipment volumes and outgoing shipment volumes (in metric tons) for ports in Madagascar.

Each row in this dataset represents country-level aggregates. Data was last updated on HDX on 2026-04-21. Geographic scope: **MDG**.

*Curated into ML-ready Parquet format by [Electric Sheep Africa](https://huggingface.co/electricsheepafrica).*

---

## Dataset Characteristics

| | |
|---|---|
| **Domain** | Humanitarian and development data |
| **Unit of observation** | Country-level aggregates |
| **Rows (total)** | 15,984 |
| **Columns** | 31 (24 numeric, 6 categorical, 0 datetime) |
| **Train split** | 12,787 rows |
| **Test split** | 3,196 rows |
| **Geographic scope** | MDG |
| **Publisher** | PortWatch |
| **HDX last updated** | 2026-04-21 |

---

## Variables

**Geographic** — `year` (range 2019.0–2026.0), `day` (range 1.0–31.0), `country` (Madagascar), `iso3` (MDG), `portcalls_dry_bulk` (range 0.0–4.0) and 8 others.

**Temporal** — `date`, `month` (range 1.0–12.0).

**Identifier / Metadata** — `portid` (port50, port55, port340), `portname` (Andoany, Antsiranana (Diego Suarez), Ehoala), `esa_source` (HDX), `esa_processed` (2026-04-26).

**Other** — `portcalls_container` (range 0.0–3.0), `portcalls_general_cargo` (range 0.0–3.0), `portcalls_roro` (range 0.0–2.0), `portcalls_tanker` (range 0.0–2.0), `portcalls_cargo` (range 0.0–8.0) and 7 others.

---

## Quick Start

```python
from datasets import load_dataset

ds = load_dataset("electricsheepafrica/africa-ports-madagascar")
train = ds["train"].to_pandas()
test = ds["test"].to_pandas()

print(train.shape)
train.head()
```

---

## Schema

| Column | Type | Null % | Range / Sample Values |
|---|---|---|---|
| `date` | datetime64[ns, UTC] | 0.0% | |
| `year` | int64 | 0.0% | 2019.0 – 2026.0 (mean 2022.1607) |
| `month` | int64 | 0.0% | 1.0 – 12.0 (mean 6.3536) |
| `day` | int64 | 0.0% | 1.0 – 31.0 (mean 15.6813) |
| `portid` | object | 0.0% | port50, port55, port340 |
| `portname` | object | 0.0% | Andoany, Antsiranana (Diego Suarez), Ehoala |
| `country` | object | 0.0% | Madagascar |
| `iso3` | object | 0.0% | MDG |
| `portcalls_container` | int64 | 0.0% | 0.0 – 3.0 (mean 0.0775) |
| `portcalls_dry_bulk` | int64 | 0.0% | 0.0 – 4.0 (mean 0.0621) |
| `portcalls_general_cargo` | int64 | 0.0% | 0.0 – 3.0 (mean 0.0713) |
| `portcalls_roro` | int64 | 0.0% | 0.0 – 2.0 (mean 0.0111) |
| `portcalls_tanker` | int64 | 0.0% | 0.0 – 2.0 (mean 0.0973) |
| `portcalls_cargo` | int64 | 0.0% | 0.0 – 8.0 (mean 0.222) |
| `portcalls` | int64 | 0.0% | 0.0 – 9.0 (mean 0.3193) |
| `import_container` | int64 | 0.0% | 0.0 – 21056.0 (mean 321.1673) |
| `import_dry_bulk` | int64 | 0.0% | 0.0 – 149427.0 (mean 1444.267) |
| `import_general_cargo` | int64 | 0.0% | 0.0 – 17379.0 (mean 64.9492) |
| `import_roro` | int64 | 0.0% | 0.0 – 5571.0 (mean 10.5243) |
| `import_tanker` | int64 | 0.0% | 0.0 – 72912.0 (mean 541.2482) |
| `import_cargo` | int64 | 0.0% | 0.0 – 149427.0 (mean 1840.9187) |
| `import` | int64 | 0.0% | 0.0 – 165344.0 (mean 2382.1728) |
| `export_container` | int64 | 0.0% | 0.0 – 12614.0 (mean 31.2232) |
| `export_dry_bulk` | int64 | 0.0% | 0.0 – 56925.0 (mean 252.0066) |
| `export_general_cargo` | int64 | 0.0% | 0.0 – 16506.0 (mean 39.1181) |
| `export_roro` | int64 | 0.0% | |
| `export_tanker` | int64 | 0.0% | |
| `export_cargo` | int64 | 0.0% | |
| `export` | int64 | 0.0% | |
| `esa_source` | object | 0.0% | HDX |
| `esa_processed` | object | 0.0% | 2026-04-26 |

---

## Numeric Summary

| Column | Min | Max | Mean | Median |
|---|---|---|---|---|
| `year` | 2019.0 | 2026.0 | 2022.1607 | 2022.0 |
| `month` | 1.0 | 12.0 | 6.3536 | 6.0 |
| `day` | 1.0 | 31.0 | 15.6813 | 16.0 |
| `portcalls_container` | 0.0 | 3.0 | 0.0775 | 0.0 |
| `portcalls_dry_bulk` | 0.0 | 4.0 | 0.0621 | 0.0 |
| `portcalls_general_cargo` | 0.0 | 3.0 | 0.0713 | 0.0 |
| `portcalls_roro` | 0.0 | 2.0 | 0.0111 | 0.0 |
| `portcalls_tanker` | 0.0 | 2.0 | 0.0973 | 0.0 |
| `portcalls_cargo` | 0.0 | 8.0 | 0.222 | 0.0 |
| `portcalls` | 0.0 | 9.0 | 0.3193 | 0.0 |
| `import_container` | 0.0 | 21056.0 | 321.1673 | 0.0 |
| `import_dry_bulk` | 0.0 | 149427.0 | 1444.267 | 0.0 |
| `import_general_cargo` | 0.0 | 17379.0 | 64.9492 | 0.0 |
| `import_roro` | 0.0 | 5571.0 | 10.5243 | 0.0 |
| `import_tanker` | 0.0 | 72912.0 | 541.2482 | 0.0 |

---

## Curation

Raw data was downloaded from HDX via the CKAN API and converted to Parquet. Column names were lowercased and standardised to snake_case. Common missing-value markers (`N/A`, `null`, `none`, `-`, `unknown`, `no data`, `#N/A`) were unified to `NaN`. 1 column(s) were cast from string to numeric or datetime based on parse-success rate (>85% threshold). The dataset was split 80/20 into train and test partitions using a fixed random seed (42) and saved as Snappy-compressed Parquet.

---

## Limitations

- Data originates from PortWatch and has not been independently validated by ESA.
- Automated cleaning cannot correct for misreported values, definitional inconsistencies, or sampling bias in the original collection.
- Refer to the [original HDX dataset page](https://data.humdata.org/dataset/madagascar-daily-port-activity-data-and-shipment-estimates) for the publisher's own methodology notes and caveats.

---

## Citation

```bibtex
@dataset{hdx_africa_ports_madagascar,
title = {Madagascar: Daily Port Activity Data and Shipment Estimates},
author = {PortWatch},
year = {2026},
url = {https://data.humdata.org/dataset/madagascar-daily-port-activity-data-and-shipment-estimates},
note = {Repackaged for machine learning by Electric Sheep Africa (https://huggingface.co/electricsheepafrica)}
}
```

---

*[Electric Sheep Africa](https://huggingface.co/electricsheepafrica) — Africa's ML dataset infrastructure. Lagos, Nigeria.*