Owner of Hammies, former Jupyter core developer and co-lead of Jupyter Notebook and JupyterLab teams
es-reactLeaflet DemoLeafletReactHandsontable DemoGoogle Auth and Google Sheets TestHandsontable ScrollingGoogle Auth APIGoogle Drive APIJSBarcodeAvery 5160 Barcode Labels TemplateGoogle Sheets with Formulae DemoTable Utilities DemoHyperformula DemoLocal Storage Table DemoLocal Storage TableGoogle Sheet TableTable UtilitiesSystemJSTipTapreact-json-formTailwind ComponentsHyperformulaCodeMirror componentTable DemoReact ComponentsJavascript Temporal APIGoogle Sheets APIGoogle Sheets API DemoFuse.jsList of countriesYahoo FinanceHandsontable for Observable
Grant's Utilities
price = amount => {
const text = amount.toLocaleString('en-US', {
style: 'currency',
currency: 'USD',
minimumFractionDigits: 0,
maximumFractionDigits: 0
});
const element = html`${text}`;
element.value = amount;
return element;
}
percentage = (amount, minimumFractionDigits = 2) => {
const text = amount.toLocaleString('en-US', {
style: 'percent',
minimumFractionDigits
});
const element = html`${text}`;
element.value = amount;
return element;
}
range = number => {
return [...Array(number).keys()].map(i => i + 1);
}
objectToArray = (obj, [keyName, valueName] = ['sku', 'quantity']) =>
Object.entries(obj).map(([key, value]) => ({
[keyName]: key,
[valueName]: value
}))
flattenObject = flatten
function flatten(obj) {
let arr = [];
for (var i in obj) {
if (typeof obj[i] !== 'object' || Array.isArray(obj[i])) {
arr.push(obj[i]);
} else {
arr.push(flatten(obj[i]));
}
}
return arr.flat();
}
queryStringToObject = query => {
if (!query) return {};
return query
.substring(1)
.split('&')
.reduce((result, item) => {
const [key, value] = item.split('=');
try {
return { ...result, [key]: JSON.parse(decodeURIComponent(value)) };
} catch (error) {
return { ...result, [key]: decodeURIComponent(value) };
}
}, {});
}
objectToQueryString = obj => {
return Object.entries(obj).reduce((result, [key, value]) => {
const pair = `${encodeURIComponent(key)}=${encodeURIComponent(value)}`;
if (!value) return result;
if (result === '?') return `${result}${pair}`;
return `${result}&${pair}`;
}, '?');
}
formatPrice = value =>
parseFloat(value).toLocaleString('en-US', {
style: 'currency',
currency: 'USD',
minimumFractionDigits: 2,
maximumFractionDigits: 2
})
formatDate = value => {
const date = new Date(value);
return date.toLocaleDateString('en-US', {
year: 'numeric',
month: '2-digit',
day: '2-digit'
});
}
toPascalCase = (text) =>
text.replace(/(\w)(\w*)/g, function (g0, g1, g2) {
return g1.toUpperCase() + g2.toLowerCase();
})
(String.prototype.toPascalCase = function() {
return this.replace(new RegExp(/[-_]+/, 'g'), ' ')
.replace(new RegExp(/[^\w\s]/, 'g'), '')
.replace(
new RegExp(/\s+(.)(\w+)/, 'g'),
($1, $2, $3) => `${$2.toUpperCase() + $3.toLowerCase()}`
)
.replace(new RegExp(/\s/, 'g'), '')
.replace(new RegExp(/\w/), s => s.toLowerCase());
})
random = (min, max) => Math.floor(Math.random() * (max - min) + min)
searchQuery = queryStringToObject(window.location.search)
parseNotebookUrl = url => {
const [_, user, notebook, search] = url.match(
/https:\/\/observablehq.com\/(\S+)\/([^?\s]+)(\?.*)?/
);
return { user, notebook, query: queryStringToObject(search) };
}
notebookUrl = parseNotebookUrl(document.baseURI)
import { table } from "@gnestor/table"
import {
composeTable,
currencyColumn,
percentageColumn,
numberColumn,
withFormulae,
withCheckbox,
withHtml
} from "@gnestor/table-utilities"
d3 = require('d3')
import { vl } from '@vega/vega-lite-api'
import { copy } from '@mbostock/copy-to-clipboard'
import { localStorage } from '@mbostock/safe-local-storage'
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.
