Trying to do things.
Published
Edited
Feb 23, 2021
Importers
2 stars
get_columns_set(data, ["y", /^x/])
get_columns_set(tab, ["y", /^x/])
recode = function(value, options) {
if (options.recoding.has(value)) return options.recoding.get(value);
if (options.hasOwnProperty("other")) return options.other;
return value;
}
{
let x = ["foo", "bar", 2, null];
let recoding = new Map([["foo", "yolo"], [2, 12], [null, "N/A"]]);
return x.map(v => recode(v, { recoding: recoding, other: "other" }));
}
batch_derive = function(table, options) {
let columns = get_columns_set(table, options.columns);
let derives = {};
columns.forEach(col => {
let new_name = col;
if (options.prefix) new_name = options.prefix + new_name;
if (options.suffix) new_name = new_name + options.suffix;
derives[new_name] = options.f(col);
});
return table.params(options).derive(derives);
}
batch_derive(tab, {
columns: [/^x/],
f: v => `d => op.upper(d['${v}'])`,
suffix: "_rec"
}).view()
batch_recode = function(table, options) {
let columns = get_columns_set(table, options.columns);
let recode_options = "$.recoding";
if (options.hasOwnProperty("fallback")) {
recode_options = "$.recoding, $.fallback";
}
let derives = {};
columns.forEach(col => {
let new_name = col;
if (options.prefix) new_name = options.prefix + new_name;
if (options.suffix) new_name = new_name + options.suffix;
derives[new_name] = (v =>
`(d,$) => op.recode(d['${v}'], ${recode_options})`)(col);
});
return table.params(options).derive(derives);
}
batch_recode(tab, {
columns: [/^x/, "y"],
recoding: new Map([["foo", "yolo"], [2, 12], ["bye", null]])
}).view()
tab
.batch_derive({
columns: [/^x/],
f: v => `d => op.upper(d['${v}'])`,
prefix: "rec_"
})
.batch_recode({
columns: /^rec/,
recoding: new Map([["FOO", "RECODED"], ["BYE", 42]])
})
.view()
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.
