The avatar for @elaval
Ernesto Laval
Public
Edited
Jun 8, 2024
1 fork
3
Insert cell
Insert cell
Insert cell
Insert cell
20230906_Matrícula_unica_2023_20230430_WEB.parquet
SELECT COD_GRADO2 as nivel, count(*) as estudiantes
FROM "20230906_Matrícula_unica_2023_20230430_WEB"
WHERE COD_ENSE3 = 2
GROUP BY COD_GRADO2
Insert cell
Insert cell
20230906_Matrícula_unica_2023_20230430_WEB.parquet
SELECT COD_DEPE2 as nivel, count(*) as estudiantes
FROM "20230906_Matrícula_unica_2023_20230430_WEB"
GROUP BY COD_DEPE2
Insert cell
Insert cell
20230906_Matrícula_unica_2023_20230430_WEB.parquet
WITH estudientesPorCurso as (SELECT RBD, LET_CUR, COD_JOR,COD_DEPE2, count(*) as estudiantes
FROM "20230906_Matrícula_unica_2023_20230430_WEB"
WHERE COD_ENSE3 = 2 AND COD_GRADO2 = 1 AND RURAL_RBD = 0
GROUP BY RBD, LET_CUR, COD_JOR, COD_DEPE2)

SELECT COD_DEPE2 as dependencia, estudiantes as tamañoCurso, count(*) as numeroCursos
FROM estudientesPorCurso
GROUP BY COD_DEPE2, estudiantes
ORDER BY COD_DEPE2, estudiantes
Insert cell
Insert cell
{
const dependencias = [
"",
"Municipal",
"Particular Subvencionado",
"Particular Privado",
"Adm. Delegada",
"SLEP"
];

return Plot.plot({
width: width,
marginRight: 200,
color: { legend: true, domain: dependencias.slice(1, 6) },
fy: { tickFormat: (d) => dependencias[d] },
facet: {
data: datosCursosPorTamañoYDependencia,
y: "dependencia"
},
marks: [
Plot.barY(datosCursosPorTamañoYDependencia, {
x: "tamañoCurso",
y: "numeroCursos",
fill: (d) => dependencias[d["dependencia"]]
})
]
});
}
Insert cell

Purpose-built for displays of data

Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
Learn more