electricsheepafrica/africa-daily-cross-border-trade-for-malawi-6819

---
annotations_creators:
- no-annotation
language_creators:
- found
language:
- en
license: cc-by-4.0
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
- trade
- mwi
pretty_name: "Malawi Daily FEWS NET Cross Border Trade Data"
dataset_info:
splits:
- name: train
num_examples: 8337
- name: test
num_examples: 2084
---

# Malawi Daily FEWS NET Cross Border Trade Data

**Publisher:** FEWS NET · **Source:** [HDX](https://data.humdata.org/dataset/daily_cross_border_trade_for_malawi_6819) · **License:** `cc-by` · **Updated:** 2026-04-01

---

## Abstract

Malawi Daily cross border trade data collected by FEWS NET since 2018.

Each row in this dataset represents first-level administrative unit observations. Temporal coverage is indicated by the `start_date`, `period_date` column(s). Geographic scope: **MWI**.

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

---

## Dataset Characteristics

| | |
|---|---|
| **Domain** | Humanitarian and development data |
| **Unit of observation** | First-level administrative unit observations |
| **Rows (total)** | 10,422 |
| **Columns** | 42 (9 numeric, 31 categorical, 2 datetime) |
| **Train split** | 8,337 rows |
| **Test split** | 2,084 rows |
| **Geographic scope** | MWI |
| **Publisher** | FEWS NET |
| **HDX last updated** | 2026-04-01 |

---

## Variables

**Geographic** — `reporting_country` (Malawi, Tanzania, United Republic of, Mozambique), `reporting_country_code` (MW, TZ, MZ), `source_country_code` (MW, MZ, TZ), `destination_country_code` (MW, MZ, TZ), `flow_type` and 11 others.

**Temporal** — `start_date`, `period_date`, `value_one_month_ago` (range 0.07–50364.1364), `pct_change_from_one_month_ago` (range -100.0–426963.3397).

**Outcome / Measurement** — `value` (range 0.0–1108011.0).

**Identifier / Metadata** — `source` (Malawi, Mozambique, Tanzania, United Republic of), `indicator_name` (TradeFlowQuantity), `source_organization`, `source_document`, `dataseries_name` and 5 others.

**Other** — `border_point` (Songwe, Mqocha, Muloza), `destination` (Malawi, Mozambique, Tanzania, United Republic of), `cpcv2` (R01122AC, P23161AA, R01701AA), `product` (Maize Grain (White), Rice (Milled), Beans (mixed)), `collection_status` and 6 others.

---

## Quick Start

```python
from datasets import load_dataset

ds = load_dataset("electricsheepafrica/africa-daily-cross-border-trade-for-malawi-6819")
train = ds["train"].to_pandas()
test = ds["test"].to_pandas()

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

---

## Schema

| Column | Type | Null % | Range / Sample Values |
|---|---|---|---|
| `reporting_country` | object | 0.0% | Malawi, Tanzania, United Republic of, Mozambique |
| `reporting_country_code` | object | 0.0% | MW, TZ, MZ |
| `border_point` | object | 36.1% | Songwe, Mqocha, Muloza |
| `source` | object | 0.0% | Malawi, Mozambique, Tanzania, United Republic of |
| `source_country_code` | object | 0.0% | MW, MZ, TZ |
| `destination` | object | 0.0% | Malawi, Mozambique, Tanzania, United Republic of |
| `destination_country_code` | object | 0.0% | MW, MZ, TZ |
| `cpcv2` | object | 0.0% | R01122AC, P23161AA, R01701AA |
| `product` | object | 0.0% | Maize Grain (White), Rice (Milled), Beans (mixed) |
| `indicator_name` | object | 0.0% | TradeFlowQuantity |
| `start_date` | datetime64[ns] | 0.0% | |
| `period_date` | datetime64[ns] | 0.0% | |
| `value` | float64 | 0.0% | 0.0 – 1108011.0 (mean 3124.8085) |
| `flow_type` | object | 0.0% | |
| `trade_type` | object | 0.0% | |
| `collection_status` | object | 0.0% | |
| `source_organization` | object | 0.0% | |
| `source_document` | object | 0.0% | |
| `dataseries_name` | object | 0.0% | |
| `dataseries` | int64 | 0.0% | 27987.0 – 7636338.0 (mean 4214238.1309) |
| `unit` | object | 0.0% | |
| `unit_type` | object | 0.0% | |
| `unit_name` | object | 0.0% | |
| `status` | object | 0.0% | |
| `common_unit` | object | 0.0% | |
| `common_unit_quantity` | float64 | 0.0% | 0.0 – 44841000.0 (mean 176081.107) |
| `reporting_country_geographic_group` | object | 0.0% | |
| `reporting_country_fewsnet_region` | object | 0.0% | |
| `source_geographic_group` | object | 0.0% | |
| `source_fewsnet_region` | object | 0.0% | |
| `destination_geographic_group` | object | 0.0% | |
| `destination_fewsnet_region` | object | 0.0% | |
| `id` | float64 | 71.1% | 1158640.0 – 37980797.0 (mean 5721005.1967) |
| `value_one_month_ago` | float64 | 63.8% | 0.07 – 50364.1364 (mean 624.147) |
| `value_one_year_ago` | float64 | 72.1% | 0.07 – 31579.7333 (mean 541.0893) |
| `value_two_years_ago` | float64 | 77.2% | 0.07 – 31579.7333 (mean 539.9041) |
| `pct_change_from_one_month_ago` | float64 | 63.8% | -100.0 – 426963.3397 (mean 1394.3445) |
| `pct_change_from_one_year_ago` | float64 | 72.1% | -100.0 – 647662.5016 (mean 2942.1423) |
| `collection_schedule` | object | 0.0% | |
| `data_usage_policy` | object | 0.0% | |
| `esa_source` | object | 0.0% | |
| `esa_processed` | object | 0.0% | |

---

## Numeric Summary

| Column | Min | Max | Mean | Median |
|---|---|---|---|---|
| `value` | 0.0 | 1108011.0 | 3124.8085 | 0.0 |
| `dataseries` | 27987.0 | 7636338.0 | 4214238.1309 | 6554350.0 |
| `common_unit_quantity` | 0.0 | 44841000.0 | 176081.107 | 0.0 |
| `id` | 1158640.0 | 37980797.0 | 5721005.1967 | 1161473.0 |
| `value_one_month_ago` | 0.07 | 50364.1364 | 624.147 | 63.4444 |
| `value_one_year_ago` | 0.07 | 31579.7333 | 541.0893 | 64.8462 |
| `value_two_years_ago` | 0.07 | 31579.7333 | 539.9041 | 64.1131 |
| `pct_change_from_one_month_ago` | -100.0 | 426963.3397 | 1394.3445 | 408.6957 |
| `pct_change_from_one_year_ago` | -100.0 | 647662.5016 | 2942.1423 | 451.2475 |

---

## 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`. 6 column(s) with >80% missing values were removed: `value_three_years_ago`, `value_four_years_ago`, `value_five_years_ago`, `two_year_average`, `five_year_average`, `pct_change_from_five_year_average`. 2 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 FEWS NET and has not been independently validated by ESA.
- Automated cleaning cannot correct for misreported values, definitional inconsistencies, or sampling bias in the original collection.
- The following columns have >20% missing values and should be treated with caution in modelling: `border_point`, `id`, `value_one_month_ago`, `value_one_year_ago`, `value_two_years_ago`, `pct_change_from_one_month_ago`, `pct_change_from_one_year_ago`.
- Refer to the [original HDX dataset page](https://data.humdata.org/dataset/daily_cross_border_trade_for_malawi_6819) for the publisher's own methodology notes and caveats.

---

## Citation

```bibtex
@dataset{hdx_africa_daily_cross_border_trade_for_malawi_6819,
title = {Malawi Daily FEWS NET Cross Border Trade Data},
author = {FEWS NET},
year = {2026},
url = {https://data.humdata.org/dataset/daily_cross_border_trade_for_malawi_6819},
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.*