d2cml-ai/data-science-python/datosabiertos-dashboard

datosabiertos-dashboard — Panel Salud y Educación

Fetch live data from the datosabiertos MCP server, embed parsed data in dashboard.py, and launch Streamlit.

Steps

1. Fetch data — call get_health_edu_snapshot(200) on MCP server datosabiertos.

Returns health_establishments and education_enrollment with records, fields, total, chart_hints.

1. Parse records — each dataset has records: [{col: val, ...}, ...].

• Skip rows where key grouping fields are null/empty.
• Use chart_hints and inspect fields to find columns:
• Health: Departamento, Tipo / Clasificación
• Education: Año Matrícula, Departamento\nColegio, Género
• For charts, aggregate with Counter or pandas value_counts (top 12–15 categories).

1. Overwrite `dashboard.py` — full file rewrite with:

• Embedded HEALTH_RECORDS, EDU_RECORDS as Python lists of dicts (from snapshot, max 200 rows each).
• Embedded FETCHED_AT, HEALTH_META, EDU_META dicts.
• No runtime API or MCP calls in Streamlit.
• Layout:
• Title: Panel Datos Abiertos — Salud y Educación (Perú)
• Subtitle: Fuente: datosabiertos.gob.pe | Actualizado: <fetched_at>
• Row 1: barras por departamento (salud) | barras por tipo (salud)
• Row 2: línea/barras matrícula por año | barras por departamento colegio
• Row 3: markdown con enlaces a datasets + expanders con preview tabular
• Footer metrics: totales muestra y totales portal
• Colors: #C8102E (red), #003087 (navy); st.set_page_config(layout="wide"); Spanish labels; x-axis 45°.

1. Launch Streamlit (background):

.\.venv\Scripts\streamlit run dashboard.py

1. Report — tell the user: Dashboard actualizado y lanzado en http://localhost:8501

Error handling

• If a dataset has errors[key] or empty records, show st.warning("No disponible: <name>") in that panel.
• If all datasets fail, write dashboard.py with only st.error() explaining the API is unreachable; still launch Streamlit.

MCP tools reference

Notes

• DataStore API may return HTML errors; MCP falls back to CSV download for curated resources.
• Workspace root must be DatosAbiertos/ so .cursor/mcp.json resolves paths.