CoolFace
Datasetpublic

electricsheepafrica/africa-egypt-capmas-input-output-tables-12727a51

Input Output Tables | Africa (CAPMAS Egypt Open Data) 1,137 rows - 1 Africa country/area - 2011-2018 - 15 indicators - Engineered by Electric Sheep Africa TL;DR This dataset contains 1,137 rows from CAPMAS Egypt Open Data, covering Input Output Tables. It is published as ML-ready Parquet with consistent Hugging Face metadata, source provenance, and analysis-friendly loading examples. What This Dataset Measures Official statistics datasets help… See the full description on the dataset page: https://huggingface.co/datasets/electricsheepafrica/africa-egypt-capmas-input-output-tables-12727a51.

sourceHugging Faceotherupdated 2mo agoView on Hugging Face
0likes26downloads
Dataset Card

Input Output Tables | Africa (CAPMAS Egypt Open Data)

1,137 rows - 1 Africa country/area - 2011-2018 - 15 indicators - Engineered by [Electric Sheep Africa](https://huggingface.co/electricsheepafrica)

rows countries period indicators license

TL;DR

This dataset contains 1,137 rows from CAPMAS Egypt Open Data, covering Input Output Tables. It is published as ML-ready Parquet with consistent Hugging Face metadata, source provenance, and analysis-friendly loading examples.

What This Dataset Measures

Official statistics datasets help analysts inspect public data as published by governments, national statistical systems, and regional data portals.

This dataset covers Input Output Tables from CAPMAS Egypt Open Data. Use the source and schema sections below to confirm definitions, units, and collection methodology before sensitive analytical use.

How To Read This Dataset

  • —One row means: one indicator observation for one geography, time period, and optional source dimensions.
  • —Primary geography column: source metadata (EGY).
  • —Best time column: year.
  • —Time coverage basis: year.
  • —Recommended join keys: year, indicator_id, plus source-specific dimension columns.

Coverage

DimensionValue
Rows1,137
Countries/areas1
First period2011
Last period2018
Indicators15
Columns12
Source formatPARQUET

Geographic Coverage

Top areas shown below, sorted by row count when available:

AreaRowsFirst yearLast yearName
EGY1,13720112018Egypt

Indicators, Variables, Or Resource Contents

  • —8960 - Total Final Consumption Expenditure for Aggregate Inputs and Outputs According to Inputs(By 1000 L.E)
  • —8961 - Total Capital Formation of Input-Output Aggregate According to Inputs(By 1000 L.E)
  • —1140 - Total Final Demand for Aggregate Outputs at Basic Prices According to Inputs(By 1000 L.E)
  • —8966 - Gross value added at basic prices for input-output aggregates(By 1000 L.E)
  • —8965 - Total Primary Inputs at Buyer Prices for Aggregate Input-Output(By 1000 L.E)
  • —8964 - Total Primary Inputs for Aggregate Inputs and Outputs at Basic Prices(By 1000 L.E)
  • —8963 - Total Imports for Aggregate Input-Output According to Inputs(By 1000 L.E)
  • —8962 - Total Exports for Aggregate Outputs at Basic Prices According to Inputs(By 1000 L.E)
  • —8967 - Total Inputs at Basic Prices for Aggregate Input-Output(By 1000 L.E)
  • —8968 - Total primary inputs at basic prices for the matrix of aggregate technical transactions for intermediate demand according to outputs(By 1000 L.E)
  • —639 - Total Inputs for Aggregate Technical Transactions of Intermediate Demand According to Outputs(By 1000 L.E)
  • —1155 - Total primary inputs at buyer prices for aggregate technical transactions of intermediate demand according to outputs(By 1000 L.E)
  • —8969 - Aggregate Fixed Capital Formation at Buyers' Prices According to Outputs(By 1000 L.E)
  • —1135 - Total Intermediate Demand for Aggregate Outputs at Basic Prices According to Inputs(By 1000 L.E)
  • —1158 - Value Added at Basic Prices for Aggregate Technical Transactions of Intermediate Demand According to Outputs(By 1000 L.E)

Schema

ColumnTypeDescriptionExample
filter_idstringSource column from the original resource.146
filter_arstringSource column from the original resource.التعليم
filter_enstringSource column from the original resource.EDUCATION
valuedoubleNumeric observation value.168786480.72
yearint64Observation year.2018
quarternullSource column from the original resource.``
monthnullSource column from the original resource.``
indicator_idstringStable source or Electric Sheep Africa indicator identifier.8960
indicator_namestringHuman-readable indicator name.Total Final Consumption Expenditure for Aggregate Inputs and Outputs ...
indicator_name_arstringSource column from the original resource.إجمالى الإنفاق الاستهلاكي النهائي للمدخلات والمخرجات التجميعي طبقا لل...
unitstringMeasurement unit, when supplied by the source.By 1000 L.E
periodicitystringSource column from the original resource.Bi-Annually

Usage

python
from datasets import load_dataset

ds = load_dataset("electricsheepafrica/africa-egypt-capmas-input-output-tables-12727a51")
df = ds["train"].to_pandas()
print(df.head())

Inspect Columns

python
print(df.info())
print(df.head())

Filter By Geography

python
# This dataset is scoped to Egypt in source metadata.
sample = df.copy()

Time-Series Pattern

python
if "value" in df.columns and "year" in df.columns:
    trend = df.sort_values("year")

Pivot For Analysis

python
if {"indicator_id", "year", "value"}.issubset(df.columns):
    matrix = df.pivot_table(index="year", columns="indicator_id", values="value")
    print(matrix.tail())

Data Quality Notes

  • —Canonical time field: year.
  • —Missing values are preserved rather than silently imputed.
  • —Column names are standardized for machine use; source meanings are preserved where known.
  • —Always confirm source methodology, units, and collection definitions before policy, production, or redistribution-sensitive use.

Source And Provenance

Transformations Applied

  • —Converted the source table to Parquet for efficient analytics and ML workflows.
  • —Added or preserved source provenance columns where available.
  • —Standardized README metadata, dataset loading configuration, schema documentation, and citation format.
  • —Preserved source-reported values without analytical imputation.

Suggested Analyses

  • —Profile the distribution of values
  • —Compare categories or geographies
  • —Join with complementary public datasets
  • —Build time-series views and period-over-period comparisons
  • —Pivot to indicator x period matrices
  • —Check missingness before modeling
  • —Use source or repo metadata for country scope when a geography column is not present

Citation

bibtex
@misc{electric_sheep_africa_africa_egypt_capmas_input_output_tables_12727a51_2018,
  title        = {Input Output Tables | Africa (CAPMAS Egypt Open Data)},
  author       = {Central Agency for Public Mobilisation and Statistics (CAPMAS), Egypt},
  year         = {2018},
  url          = {https://www.capmas.gov.eg},
  publisher    = {Hugging Face Datasets, engineered by Electric Sheep Africa},
  howpublished = {\url{https://huggingface.co/datasets/electricsheepafrica/africa-egypt-capmas-input-output-tables-12727a51}}
}

License

Released under Source-specific or other license.

Original data is published by Central Agency for Public Mobilisation and Statistics (CAPMAS), Egypt. Electric Sheep Africa engineering standardizes the data for discovery, loading, and analysis on Hugging Face. Cite both the original source and this ML-ready dataset when used.

About Electric Sheep Africa

Electric Sheep Africa publishes ML-ready African public datasets on Hugging Face.


Provenance: README standardized 2026-08-11 by the Electric Sheep Africa README system. Source URL: https://www.capmas.gov.eg