2b:null 2c:["$","title",null,{"children":"Toolbelt | Ilyá Belsky | Observable"}] 31:T406,// Note: While using sparkbars, you can sort table only by one value sparkbars = (maxOrExtent, color = "#DDA0DD", format) => { const [min, max] = maxOrExtent?.length ? maxOrExtent : [0, maxOrExtent || 0]; return (values) => htl.html`

${values.map( (x) => htl.html`

` )}

${values // this one to appear above the spark bars .map((x) => (format ? d3.format(format)(x) : x.toLocaleString("ru"))) .join(" / ")}

${values // and this one, non-absolute, is to expand div with with the real content, else it will be zero .map((x) => (format ? d3.format(format)(x) : x.toLocaleString("ru"))) .join(" / ")}

`; }32:T4bb,timeTicksDefault = (domain) => { // default multi-scale tick format logic from // https://github.com/d3/d3-scale/blob/main/src/time.js#L29 // to use in Plot with non-english locales setRuLocale(); const {timeYear, timeMonth, timeWeek, timeDay, timeHour, timeMinute, timeSecond, timeFormat } = d3; const [year, month, week, day, hour, minute, second, format] = [timeYear, timeMonth, timeWeek, timeDay, timeHour, timeMinute, timeSecond, timeFormat] var formatMillisecond = format(".%L"), formatSecond = format(":%S"), formatMinute = format("%I:%M"), formatHour = format("%I %p"), formatDay = format("%a %d"), formatWeek = format("%b %d"), formatMonth = format("%B"), formatYear = format("%Y"); function tickFormat(date) { return (second(date) < date ? formatMillisecond : minute(date) < date ? formatSecond : hour(date) < date ? formatMinute : day(date) < date ? formatHour : month(date) < date ? (week(date) < date ? formatDay : formatWeek) : year(date) < date ? formatMonth : formatYear)(date); } const ticks = d3.timeTicks(domain[0], domain[1], 10); return { ticks, tickFormat }; }33:T81a,// import {pipe} from "@tophtucker/pipe" function pipe(...args) { // this map will go from child to container const containers = new Map(); // set up child containers const container = html`

${args.map(arg => { const node = html`

` containers.set(arg, node) return node })}`; // render children from `index` forward, starting with `value` // (which will be re-set by each next child) function render(index, value) { for (const arg of args.slice(index)) { let node; // if child is a function, call it with the last child's value; // if it's a DOM node, render it; // if it's something else, wrap in a DOM node and render if (typeof arg === "function") { const v = arg(value); if (v instanceof Node) { node = v } else { node = Object.assign(html`${arg.label || "f"}`, {value: v}) } } else if (arg instanceof Node) { node = arg } else { node = html`

${arg}`; } // when a child emits an input event, re-run every child to the right of it with the new value node.addEventListener("input", e => render(args.indexOf(arg) + 1, node.value)); // remove the old version of this child, if any, and add the new one const parent = containers.get(arg) if (parent.firstChild) parent.removeChild(parent.firstChild); parent.append(node); // if this child has some value, pass it along to the next child // if this child doesnt implement value, pass through last value if(node.value !== undefined) value = node.value; } // set final value on root container and dispatch input event, // so that the whole thing can participate in observable dataflow container.dispatchEvent(new CustomEvent("input")); container.value = value; } // initialize render(0) return container }34:[] 2f:{"id":"d959884acd1622a0","slug":"toolbelt","title":"Toolbelt","thumbnail":"754ca34f4324bd6874e9ee5313e0b52af8903ab06f8e780cc3dd9937a7b8d7a8","access_level":"public","create_time":"$D2019-07-31T18:03:06.877Z","update_time":"$D2026-01-06T15:47:41.107Z","view_time":null,"first_public_time":"$D2019-07-31T18:03:58.987Z","fork":false,"stars":2,"starred":false,"owner":{"type":"team","id":"4330efe17d3f85df","login":"oluckyman","name":"Ilyá Belsky","avatar_url":"https://avatars-next.observableusercontent.com/4fd43f90fde77934b5f4caa4453accf60bdeeb2cc01f813bfc0ad738c2b77958","tier":"starter_2024"},"version":1331,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"35030f2775c5ade5","login":"oluckyman","name":"Ilyá Belsky","avatar_url":"https://avatars-next.observableusercontent.com/4fd43f90fde77934b5f4caa4453accf60bdeeb2cc01f813bfc0ad738c2b77958","tier":null}],"members":[{"type":"individual","id":"35030f2775c5ade5","login":"oluckyman","name":"Ilyá Belsky","avatar_url":"https://avatars-next.observableusercontent.com/4fd43f90fde77934b5f4caa4453accf60bdeeb2cc01f813bfc0ad738c2b77958","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"subscribed":null,"forks":1,"collection":{"id":"abe5492d83befb37","slug":"tools","title":"Tools","owner":{"id":"4330efe17d3f85df","login":"oluckyman","name":"Ilyá Belsky"}},"type":"notebook","body":{"title":"Toolbelt","cells":[{"id":0,"value":"md`# Toolbelt`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"md`Collection of useful imports from different authors. I cannot remember all of them so I gather them into this notebook and reimport them like: \n\\`\\`\\`lang=js\nimport { localStorage } from '@oluckyman/toolbelt'\n\\`\\`\\`\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":141,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":51,"value":"import {localStorage} from \"@mbostock/safe-local-storage\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1035,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1037,"value":"import { color, slider, number } from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":145,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":60,"value":"import { observer } from '@mbostock/auralization-of-dom-mutation'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":62,"value":"md`_NOTE: need to create a cell with just \\`observer\\` to make it work_`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":110,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":180,"value":"import {Scrubber} from \"@mbostock/scrubber\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":181,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":736,"value":"A button to help copy snippets of text to the clipboard. To use in your notebook:\n\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":431,"value":"import {Copier} from \"@mbostock/copier\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":433,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":354,"value":"import {beep} from \"@oluckyman/beep\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":351,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":369,"value":"// import { SummaryTable } from \"@observablehq/summary-table\"\nimport {SummaryTable as ST} from \"46a8c365ec916534\" // my fork with ability to scan all columns","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":651,"value":"SummaryTable = (data, opts = {}) => ST(data, { scanColumns: true, ...opts })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":379,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":375,"value":"import {addTooltips} from \"@mkfreeman/plot-tooltip\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":371,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":511,"value":"md`Lodash fp`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":509,"value":"_ = {\n const [_, fp] = await Promise.all([\n require(\"lodash@4\"),\n require(\"https://cdn.jsdelivr.net/gh/lodash/lodash@4/dist/lodash.fp.min.js\")\n ]);\n return fp(_);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":515,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1320,"value":"### SVG text and tspan word wrapping","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1312,"value":"import { wrap_text, wrap_text_nchar } from \"@ben-tanen/svg-text-and-tspan-word-wrapping\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1317,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":329,"value":"## Data Wrangling","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":330,"value":"import {Wrangler} from \"@observablehq/data-wrangler\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":242,"value":"import { aq, op } from \"@uwdata/arquero\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":297,"value":"summary = (dt, options = {}) => {\n const allFields = dt.objects\n ? dt.columnNames()\n : [...new Set(dt.flatMap((d) => Object.keys(d)))];\n\n dt = aq.from(dt, allFields);\n const counter = (field) =>\n dt\n .groupby(field)\n .rollup({ n: (n) => aq.count() })\n .orderby(aq.desc(\"n\"));\n\n const extent = (field) => d3.extent(dt.objects(), (d) => d[field]);\n\n const cols = dt.columnNames().filter((c) => !options.omit?.includes(c));\n const counts = cols\n .map(counter)\n .map((col) => Inputs.table(col, { width: 410, rows: 4 }));\n\n return html`

\n Summary of ${dt}\n

${counts.map(\n (counted, i) =>\n html`

\n \n rows: ${counter(cols[i]).size};\n [${extent(cols[i]).join(\"–\")}]\n \n ${counted}\n

`\n )}

`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":324,"value":"Scans whole array and returns the list of all keys in all rows\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":321,"value":"columns = (arr, { omit = [] } = {}) =>\n [...new Set(arr.flatMap(Object.keys))].filter((c) => !(typeof omit === 'string' ? [omit] : omit).includes(c))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":239,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":290,"value":"import { PlotLatest as Plot } from \"@fil/plot-early-bird\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":292,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":583,"value":"import {DuckDBClient} from \"@cmudig/duckdb\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":595,"value":"```\ndb = DuckDBClient.of({ alphabet, diamonds })\ndb = DuckDBClient.of({ incidents: FileAttachment(\"incidents.csv\") })\n```\nThen, use your new database with the Data Table cell to get an easy to explore view.\nAlso there are [docs](https://observablehq.com/@cmudig/duckdb-client)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":584,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":469,"value":"md`### Sparkbar to use in \\`Inputs.table\\``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":462,"value":"function sparkbar(maxOrExtent, color = \"#DDA0DD\", format) {\n const [min, max] = maxOrExtent?.length ? maxOrExtent : [0, maxOrExtent || 0];\n return (x) => htl.html`

${\n format ? d3.format(format)(x) : x.toLocaleString(\"ru\")\n }`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":465,"value":"sparkbar(100)(42)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1292,"value":"sparkbar([-10, -100])(-90)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":577,"value":"sparkbar(2022)(2012)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":579,"value":"sparkbar([2000, 2022])(2012)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":673,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":677,"value":"sparkbars(100)([70, 42, 10])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":484,"value":"md`### Cell with color marker to use in \\`Inputs.table\\``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":487,"value":"colorCell = (scale, { format = (d) => d } = {}) =>\n (d) =>\n html`█ ${format(d)}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":489,"value":"colorCell(\n d3.scaleOrdinal().domain([\"saratov\", \"la nucia\"]).range(d3.schemeSet3),\n { format: (d) => d.toUpperCase() }\n)(\"saratov\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":523,"value":"// TODO:\n// sparkticks as in 'Users for Newsletter chart'","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":175,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":153,"value":"md`## How to …`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1243,"value":"md`#### How to [run cells on demand](https://observablehq.com/d/8aaaa1f253017d47) \n\\`\\`\\`lang=js\n// cell 1\nviewof button = Inputs.button(\"Click me\", {value: null, reduce: () => new Date})\n// cell 2\n{\n if (!button) return null;\n await new Promise(r => setTimeout(r, 2000));\n return \"Done!\"\n}\n\\`\\`\\`\n---\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":115,"value":"md`#### How to use [@d3/histogram](https://observablehq.com/@d3/histogram) \n\\`\\`\\`lang=js\nimport {chart as myChart} with {myData as data} from \"@d3/histogram\"\n// myData = [1, 2, 3]\n\\`\\`\\`\n---\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":26,"value":"md`#### How to use [@d3/area-chart](https://observablehq.com/@d3/area-chart) \n\\`\\`\\`lang=js\nimport {chart as myChart} with {myData as data} from \"@d3/area-chart\"\n// myData = [{ date, value }]\n\\`\\`\\`\n---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":69,"value":"md`\n#### How to use Tangle\n1. Import\n\\`\\`\\`lang=js\nimport {Tangle} from \"@mbostock/tangle\"\n\\`\\`\\`\n2. Declare value as a view\n\\`\\`\\`lang=js\nviewof tangleValue = Inputs.input(100)\n\\`\\`\\`\n3. Use it in md:\n\\`\\`\\`lang=md\nmd\\`Result: \\${Inputs.bind(Tangle(), viewof tangleValue)}\\`\n\\`\\`\\`\n\n4. Result: ${Inputs.bind(Tangle(), viewof tangleValue)} = ${tangleValue}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":76,"value":"import {Tangle} from \"@mbostock/tangle\" // 1","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":79,"value":"viewof tangleValue = Inputs.input(100) // 2","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":96,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":28,"value":"md`#### How to include multiple d3 libs into one \\`d3\\` namespace: \n\\`\\`\\`lang=js\nd3 = require.alias({\n \"d3\": \"d3@5\",\n \"d3-dispatch\": \"d3\",\n \"d3-drag\": \"d3\",\n \"d3-interpolate\": \"d3\",\n \"d3-selection\": \"d3\",\n \"d3-transition\": \"d3\",\n \"d3-zoom\": \"d3-zoom@^1.8.3\"\n})(\"d3\", \"d3-zoom\")\n\\`\\`\\`\nAnother version (saw in [@mbostock/icelandic-population](https://observablehq.com/@mbostock/icelandic-population-by-age-1850-2000)):\n\\`\\`\\`lang=js\nd3 = require(\"d3@5\", \"d3-array@2\")\n\\`\\`\\`\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":193,"value":"md`---\n### Vega-lite helper\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":204,"value":"md`Converts JS Date to [Date Time](https://vega.github.io/vega-lite/docs/datetime.html)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":198,"value":"vlDate = date => ({\n year: date.getFullYear(),\n month: date.getMonth() + 1,\n date: date.getDate()\n // TODO: rest of the fields:\n /*\n\"year\" - Gregorian calendar years.\n\"quarter\" - Three-month intervals, starting in one of January, April, July, and October.\n\"month\" - Calendar months (January, February, etc.).\n\"date\" - Calendar day of the month (January 1, January 2, etc.).\n\"week\" - Sunday-based weeks. Days before the first Sunday of the year are considered to be in week 0, the first Sunday of the year is the start of week 1, the second Sunday week 2, etc..\n\"day\" - Day of the week (Sunday, Monday, etc.).\n\"dayofyear\" - Day of the year (1, 2, …, 365, etc.).\n\"hours\" - Hours of the day (12:00am, 1:00am, etc.).\n\"minutes\" - Minutes in an hour (12:00, 12:01, etc.).\n\"seconds\" - Seconds in a minute (12:00:00, 12:00:01, etc.).\n\"milliseconds\"\n*/\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":201,"value":"vlDate(new Date())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":218,"value":"md`---\n### JSON → CSV\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":213,"value":"json2csv = {\n const { parse } = await require('json2csv@5.0.6/dist/json2csv.umd.js').catch(\n () => window[\"json2csv\"]\n );\n return parse;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":222,"value":"json2csv([{ name: \"Lol\", age: 88 }, { name: 'Zan', age: 11 }])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":230,"value":"md`☝️ Note, in Observable you can download cell content as CSV from the cell menu`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":383,"value":"### Download CSV button","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":394,"value":"Usage: \n```\ndownload(data, 'fips.csv', showRows = false)\n```","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":832,"value":"download(cars, 'cars.csv', true)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":387,"value":"// Stealed from https://observablehq.com/@jeremiak/download-data-button\ndownload = (data, filename = \"data.csv\", showRows) => {\n if (!data) throw new Error(\"Array of data required as first argument\");\n\n let downloadData;\n if (filename.includes(\".csv\")) {\n downloadData = new Blob([d3.csvFormat(data)], { type: \"text/csv\" });\n } else {\n downloadData = new Blob([JSON.stringify(data, null, 2)], {\n type: \"application/json\"\n });\n }\n\n const size = (downloadData.size / 1024).toFixed(0);\n const button = DOM.download(\n downloadData,\n filename,\n `Download ${filename} (${\n showRows ? `${data.length} rows, ` : ``\n }~${size} KB)`\n );\n return button;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":418,"value":"md`### ru locale for d3`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":423,"value":"ruLocale = ({\n decimal: \",\",\n thousands: \"\\u00a0\",\n grouping: [3],\n currency: [\"\", \"\\u00a0₽\"],\n \"dateTime\": \"%A, %e %B %Y г. %X\",\n \"date\": \"%d.%m.%Y\",\n \"time\": \"%H:%M:%S\",\n \"periods\": [\"AM\", \"PM\"],\n \"days\": [\"воскресенье\", \"понедельник\", \"вторник\", \"среда\", \"четверг\", \"пятница\", \"суббота\"],\n \"shortDays\": [\"вс\", \"пн\", \"вт\", \"ср\", \"чт\", \"пт\", \"сб\"],\n \"shortMonths\": [\"янв\", \"фев\", \"мар\", \"апр\", \"май\", \"июн\", \"июл\", \"авг\", \"сен\", \"окт\", \"ноя\", \"дек\"],\n months: [\n \"Январь\",\n \"Февраль\",\n \"Март\",\n \"Апрель\",\n \"Май\",\n \"Июнь\",\n \"Июль\",\n \"Август\",\n \"Сентябрь\",\n \"Октябрь\",\n \"Ноябрь\",\n \"Декабрь\"\n ],\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":425,"value":"setRuLocale = () => {\n d3.formatDefaultLocale(ruLocale);\n d3.timeFormatDefaultLocale(ruLocale);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1209,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1234,"value":"Usage:\n```js\nimport {timeTicksDefault} from \"@oluckyman/toolbelt\"\n\nconst { ticks, tickFormat } = timeTicksDefault(domain)\nPlot.plot({\n x: { ticks, tickFormat }\n})\n```","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":439,"value":"md`### Input.search with Unicode support (based on [PR #216](https://github.com/observablehq/inputs/pull/216))`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":841,"value":"viewof doesnotwork = Inputs.search([1, 23, \"привет\"], { query: \"пр\" })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":445,"value":"viewof works = search([1, 23, \"привет\"], { query: \"пр\" })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":443,"value":"search = (data, options) =>\n Inputs.search(data, {\n filter:\n options?.columns === undefined\n ? searchFilter\n : columnFilter(options.columns),\n ...options\n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":449,"value":"searchFilter = (query) => {\n function termFilter(term) {\n return new RegExp(`(?:^|[^\\\\p{L}-])${escapeRegExp(term)}`, \"iu\");\n }\n\n function escapeRegExp(text) {\n return text.replace(/[-[\\]{}()*+?.,\\\\^$|#\\s]/g, \"\\\\$&\");\n }\n\n function* valuesof(d) {\n for (const key in d) {\n yield d[key];\n }\n }\n\n const filters = `${query}`\n .split(/\\s+/g)\n .filter((t) => t)\n .map(termFilter);\n return (d) => {\n if (d == null) return false;\n if (typeof d === \"object\") {\n out: for (const filter of filters) {\n for (const value of valuesof(d)) {\n if (filter.test(value)) {\n continue out;\n }\n }\n return false;\n }\n } else {\n for (const filter of filters) {\n if (!filter.test(d)) {\n return false;\n }\n }\n }\n return true;\n };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":497,"value":"columnFilter = (columns) => {\n function termFilter(term) {\n return new RegExp(`(?:^|[^\\\\p{L}-])${escapeRegExp(term)}`, \"iu\");\n }\n\n function escapeRegExp(text) {\n return text.replace(/[-[\\]{}()*+?.,\\\\^$|#\\s]/g, \"\\\\$&\");\n }\n\n return (query) => {\n const filters = `${query}`\n .split(/\\s+/g)\n .filter((t) => t)\n .map(termFilter);\n return (d) => {\n out: for (const filter of filters) {\n for (const column of columns) {\n if (filter.test(d[column])) {\n continue out;\n }\n }\n return false;\n }\n return true;\n };\n };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":602,"value":"### Input.table with search (based on [#222](https://github.com/observablehq/inputs/issues/222))","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":605,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":609,"value":"table = (data, props) =>\n pipe(\n search(data, {\n ...props,\n format: typeof props.format === \"function\" ? props.format : undefined\n }),\n (data) =>\n Inputs.table(data, {\n ...props,\n format: typeof props.format === \"function\" ? undefined : props.format\n })\n )","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":618,"value":"table(cars, { rows: 3, query: 'audi', format: {} })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1254,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1258,"value":"note(\"Note\", \"With `Markdown` body\", { open: true })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1256,"value":"function note(title, body, { open } = {}) {\n return htl.html`

${title}

${md`${body}`}

`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1140,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1141,"value":"#### Import google sheet for public notebooks","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1142,"value":"googleSheetExtractor = (url) =>\n // accepts URL in fromat\n // \"https://docs.google.com/spreadsheets/d/1O2ti0blepvPgrrhuTlkoueGlDqit5vq4wsc2OMiEf40/gviz/tq?tqx=out:json&gid=359769813\"\n // OR\n // \"https://docs.google.com/spreadsheets/d/1pq5D93SkYblepHSVUj1E95X39RVFFfBu\"\n\n fetch(url.includes(\"json\") ? url : `${url}/gviz/tq?tqx=out:json`)\n .then((response) => response.text())\n .then((text) => {\n try {\n return JSON.parse(text.match(/\"table\":(.*)(?=}\\);)/)[1]);\n } catch {\n return {};\n }\n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1156,"value":"---\n#### Fetch heplers","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1158,"value":"pRetry = (await import('https://cdn.skypack.dev/p-retry@5.1.2?min')).default","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":467,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1323,"value":"Module require debugger: \nhttps://observablehq.com/@observablehq/module-require-debugger","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1109,"value":"More toolbelts: https://github.com/observablehq/feedback/issues/377#issuecomment-1312568219","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"}],"files":"$W34","stdlib":"1","titling":"auto"}} 30:"$2f:body"