2c:null 2d:["$","title",null,{"children":"Data Utilities | UW Interactive Data Lab | Observable"}] 32:T46f,function printTable(data, header, maxWidth) { const Align = { l: 'left', c: 'center', r: 'right' }; const cellStyle = 'padding: 1px 3px; white-space: nowrap;'; header = header || (data[0] && Object.keys(data[0])); if (!header) return ''; const fields = header.map(h => (h && h.field || h) + ''); const styles = header.map(h => { return `style="text-align:${h && Align[h.align] || Align.l}; ${cellStyle}"`; }); const lines = []; const maxw = maxWidth || maxWidth === undefined ? ` style="max-width:${+maxWidth || width}px"` : ''; lines.push(``); // header row lines.push(''); header.forEach((h, i) => { lines.push(`${h && h.title || h}`); }); lines.push(''); // data rows lines.push(''); data.forEach(d => { lines.push(''); fields.map((f, i) => { lines.push(`${printValue(d[f])}`); }); lines.push(''); }); lines.push(''); lines.push(''); return html`

${lines.join('')}

`; }33:[] 30:{"id":"a2166040e5fb39a6","slug":"data-utilities","title":"Data Utilities","thumbnail":"16bd0475b6d0a02ec0715c187bb943aa539c8dab0b0cf83f9da1bd37e0f6155a","access_level":"public","create_time":"$D2019-03-26T21:30:06.649Z","update_time":"$D2020-09-23T18:31:43.559Z","view_time":null,"first_public_time":"$D2019-03-26T21:50:20.782Z","has_unpublished_edits":null,"fork":false,"stars":52,"starred":false,"owner":{"type":"team","id":"33e135341fd39b6b","login":"uwdata","name":"UW Interactive Data Lab","avatar_url":"https://avatars-next.observableusercontent.com/3edc7fd13a27b85983daf26162ae9b524d571436d583c3093ebf9cddee4c1ff9","tier":"starter_2024"},"version":229,"publish_version":229,"role":null,"authored":false,"authors":[{"type":"individual","id":"ecf15dc33ed8cd37","login":"jheer","name":"Jeffrey Heer","avatar_url":"https://avatars-next.observableusercontent.com/230cea705fbda819b9f6b8bc87e05ebecf06d314098901fbd9946af2cdc51be4","tier":null}],"members":[{"type":"team","id":"33e135341fd39b6b","login":"uwdata","name":"UW Interactive Data Lab","avatar_url":"https://avatars-next.observableusercontent.com/3edc7fd13a27b85983daf26162ae9b524d571436d583c3093ebf9cddee4c1ff9","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":27,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Data Utilities","cells":[{"id":0,"value":"md`# Data Utilities`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":61,"value":"md`\nMiscellaneous data utilities for Observable notebooks.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":121,"value":"md`\n## printTable(_data[, header, width]_)\n\nPrint an array of _data_ objects as an HTML-formatted table.\n\nThe optional _header_ array indicates which fields to include and in what order. The _header_ array values can be either a property name string or an object with the following properties:\n\n- \\`field\\` - object property name\n- \\`title\\` - [optional] column title to display\n- \\`align\\` - [optional] alignment, one of \\`'l'\\`, \\`'c'\\`, or \\`'r'\\` (left, center, or right).\n\nThe optional _width_ parameter specifies the maximum width of the table, in pixels. If \\`null\\` or zero, the maximum width will be inherited from CSS. If \\`undefined\\` or not a number, Observable's \\`width\\` value will be used.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":189,"value":"function printValue(v) {\n if (v instanceof Date) {\n if (v.getHours() === 0 &&\n v.getMinutes() === 0 &&\n v.getSeconds() === 0 &&\n v.getMilliseconds() === 0)\n {\n return dateString(v.getFullYear(), v.getMonth()+1, v.getDate());\n } else if (v.getUTCHours() === 0 &&\n v.getUTCMinutes() === 0 &&\n v.getUTCSeconds() === 0 &&\n v.getUTCMilliseconds() === 0)\n {\n return dateString(v.getUTCFullYear(), v.getUTCMonth()+1, v.getUTCDate());\n } else {\n return v.toISOString();\n }\n } else {\n return JSON.stringify(v);\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":196,"value":"function dateString(year, month, date) {\n return `${year}-${(month < 10 ? '0' : '') + month}-${(date < 10 ? '0' : '') + date}`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":63,"value":"md`### Tests`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":40,"value":"testData = [\n {foo: 'a', bar: 1, baz: true, date: new Date(2010, 0, 1)},\n {foo: 'b', bar: 2, baz: false, date: new Date(2010, 5, 15)},\n {foo: 'c', bar: -1, baz: null, date: new Date(2010, 9, 31)},\n {foo: 'd', bar: NaN, date: new Date(2010, 2, 10, 13, 45, 23)}\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"printTable(testData)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":43,"value":"printTable(testData, [\n {field: 'foo', title: 'Foo', align: 'l'},\n {field: 'bar', title: 'Bar', align: 'c'},\n {field: 'baz', title: 'Baz', align: 'r'}\n])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":27,"value":"printTable(testData.slice().reverse(), ['baz', 'bar'], '*');","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":164,"value":"printTable(['ABCDEFGHIJKLMNOPQRSTUVWXYZ'.split('').reduce((o,c) => {\n o['column' + c] = 1;\n return o;\n}, {})])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":182,"value":"printTable([{\n text: \"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Mauris imperdiet diam quam, in molestie nibh tempor vitae. Proin finibus eget nunc et aliquam. Mauris vulputate et ante id egestas. Praesent finibus metus sed interdum accumsan. Praesent a luctus leo, at vulputate orci. Vivamus sit amet ligula efficitur, gravida nulla eget, pharetra sem. Suspendisse erat nunc, sollicitudin quis rhoncus in, maximus vitae elit. Proin sodales hendrerit cursus.\",\n value: 5\n}])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":47,"value":"md`\n## mdTable(_data[, header]_)\n\nPrint an array of _data_ objects as an HTML-formatted table that uses the width allotted for Markdown output.\n\nThe optional _header_ array indicates which fields to include and in what order. The _header_ array values can be either a property name string or an object with the following properties:\n\n- \\`field\\` - object property name\n- \\`title\\` - [optional] column title to display\n- \\`align\\` - [optional] alignment, one of \\`'l'\\`, \\`'c'\\`, or \\`'r'\\` (left, center, or right).\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":109,"value":"function mdTable(data, header) {\n return printTable(data, header, null);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":70,"value":"md`\n## fromColumns(_vectors_)\nGenerate an array of data objects given input _column_ vectors.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":73,"value":"function fromColumns(vectors) {\n const fields = Object.keys(vectors),\n nrows = d3.max(fields, _ => vectors[_].length),\n data = Array(nrows);\n \n for (let i=0; i (o[_] = vectors[_][i], o), {});\n }\n \n return data;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":81,"value":"md`### Tests`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":83,"value":"mdTable(fromColumns({\n u: 'abcdefgh',\n v: [2, 8, 3, 7, 5, 4, 6, 1]\n}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":150,"value":"md`\n## downloadLink(_linkText, file, content[, mimeType]_)\nGenerate an \\`a\\` link with a _linkText_ label that downloads _content_ to the _file_ name. The optional _mimeType_ specifies the [MIME type](https://developer.mozilla.org/en-US/docs/Web/HTTP/Basics_of_HTTP/MIME_types/Complete_list_of_MIME_types), which defaults to \\`\"text/plain\"\\`.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":142,"value":"function downloadLink(label, fileName, content, mimeType) {\n // first, create a content blob\n const blob = new Blob([content], {type: mimeType || 'text/plain'});\n const url = URL.createObjectURL(blob);\n \n // second, create a download link for that blob\n return html`${label}`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":160,"value":"md`### Tests`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":146,"value":"downloadLink('Download Dummy Text!', 'dummy.txt', 'dummy')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":209,"value":"md`\n## unique(_data[, accessor]_)\nReturn a list of unique values in the _data_ array, optionally applying a provided _accessor_ function to extract values first.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":201,"value":"function unique(data, accessor) {\n return Array.from(new Set(accessor ? data.map(accessor) : data));\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":203,"value":"md`### Tests`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":205,"value":"unique([1, 2, 1, 2, 3, 3])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":207,"value":"unique([{k:'a'}, {k:'b'}, {k:'c'}, {k:'c'}, {k:'a'}], d => d.k)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":215,"value":"md`\n## uniqueValid(_data[, accessor]_)\nReturn a sorted list of unique values in the _data_ array, optionally applying a provided _accessor_ function to extract values first. Removes any \\`null\\`, \\`undefined\\`, or \\`NaN\\` values from the unique value set.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":212,"value":"function uniqueValid(data, accessor) {\n return unique(data, accessor)\n .filter(d => d != null && d === d)\n .sort((a, b) => a < b ? -1 : a > b ? 1 : 0);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":220,"value":"md`### Tests`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":222,"value":"uniqueValid([3, 1, 2, null, undefined, NaN, 1, 2, 3])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":86,"value":"md`## Imports`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":76,"value":"d3 = require('d3-array')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W33","stdlib":"1"}} 31:"$30:body"