The avatar for @class
class
Unlisted
Edited
Dec 8, 2023
2
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
dictWorkbook = FileAttachment("TheUncertaintyProject_DataDictionary_2023-08-13.xlsx").xlsx()
Insert cell
dictWorkbook.sheetNames
Insert cell
dictData = dictWorkbook.sheet(0, {
headers: true,
// range: "A1:J10"
})
Insert cell
dictData
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
workbook = FileAttachment("Uncertainty project 8-13-2023.xlsx").xlsx()
Insert cell
workbook.sheetNames
Insert cell
data = workbook.sheet(0, {
headers: true,
// range: "A1:J10"
})
Insert cell
form1Data = data.filter(d => d["redcap_repeat_instrument"] === "form_1")
Insert cell
form1Data
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
tmp = {
const fieldName = selectedQuestion["Variable / Field Name"];
return d3.rollup(
form1Data,
dd => 100 * dd.length/form1Data.length,
d => d[fieldName],
)
}
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