The avatar for @tommeagher
Tom Meagher
Public
Edited
Apr 12, 2023
Fork of Welcome to Arquero
4
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
my_sheet = excel_file.sheet("DataExport", {headers: true})
Insert cell
Insert cell
Insert cell
Insert cell
flutable = aq.from(my_sheet)
Insert cell
Insert cell
flutable.view()
Insert cell
Insert cell
flutable.select('COUNTRY_CODE','ISO_WEEK','SPEC_RECEIVED_NB').view()
Insert cell
Insert cell
flutable
.groupby('COUNTRY_CODE')
.count('INF_ALL')
.orderby(aq.desc("count"))
.view()

Insert cell
Insert cell
flutable
.groupby('COUNTRY_CODE')
.rollup({ sum: op.sum('INF_ALL') })
.orderby(aq.desc("sum"))
.view()
Insert cell
Insert cell
Insert cell
//
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
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