The avatar for @jzavala-gonzalez
José M. Zavala González
Public
Edited
Jan 26, 2024
1
Insert cell
Insert cell
pan_beneficios = {
let data = await FileAttachment("PAN_Beneficios__DATA.csv").csv({typed: true})

return data
}
Insert cell
pan_beneficios
with initial as (
select *
from pan_beneficios
where PROGRAMA = 'PAN'
AND YEAR = 2013
)

select
year, municipio, programa,
sum(beneficiootorgado) as beneficios,
sum(participantes), sum(hogares), sum(casos),
from initial
group by year, municipio, programa
order by year, municipio, programa
Insert cell
pan_beneficios
with initial as (
select *
from pan_beneficios
where PROGRAMA = 'PAN'
AND YEAR = 2013
AND municipio = 'CULEBRA'
AND servicio = 'PAN'
)

select *
from initial
Insert cell
pan_beneficios
describe pan_beneficios;
Insert cell
pan_beneficios
from pan_beneficios limit 5;
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