Owner of Hammies, former Jupyter core developer and co-lead of Jupyter Notebook and JupyterLab teams
table(data, {
colHeaders: true,
rowHeaders: true,
formulas: {
engine: hf,
sheetName: "Sheet1"
}
})
runFormula = (formula) => {
// // Using a separate sheet
// if (hf.countSheets() < 2) {
// hf.addSheet('Queries');
// }
// hf.setCellContents({ sheet: 1, col: 0, row: 0 }, [[formula]]);
// return hf.getCellValue({ sheet: 1, col: 0, row: 0 });
// // Using named expression
// if (hf.listNamedExpressions().includes('Query')) {
// hf.changeNamedExpression('Query', formula);
// } else {
// hf.addNamedExpression('Query', formula);
// }
// return hf.getNamedExpressionValue('Query');
return hf.calculateFormula(formula, 0);
}
FormulaEditor = async (doc = '', extensions = []) => {
// https://github.com/codemirror/legacy-modes
// const { StreamLanguage } = await skypack('@codemirror/stream-parser');
// const { mathematica } = await skypack(
// '@codemirror/legacy-modes/mode/mathematica'
// );
return CodeMirror(doc, [
// StreamLanguage.define(mathematica),
...extensions
]);
}
data = {
const response = await fetch(
"//raw.githubusercontent.com/vega/vega/master/docs/data/cars.json"
);
return response.json();
}
// hf = {
// const hf = HyperFormula.buildFromArray(
// viewof dataTable.hot.getSourceDataArray(),
// {
// precisionRounding: 4,
// licenseKey: 'gpl-v3'
// }
// );
// Object.keys(data[0]).forEach((column, index) => {
// const a1 = hf
// .simpleCellAddressToString({ sheet: 0, col: index, row: 0 })
// .replace(/Sheet1!([A-Z])\d/, '$1');
// hf.addNamedExpression(column, `${a1}:${a1}`);
// });
// return hf;
// }
// hf = HyperFormula.buildFromArray(viewof dataTable.hot.getSourceDataArray(), {
// precisionRounding: 4,
// licenseKey: "gpl-v3"
// })
hf = HyperFormula.buildEmpty()
import { table } from "@gnestor/table"
import { CodeMirror, skypack } from '@gnestor/codemirror'
import { HyperFormula } from "@gnestor/hyperformula"
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.
