30:T4a4,function printTable(data, header, maxWidth, printStringsWithQuotes=true) { 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], printStringsWithQuotes)}`); }); lines.push(''); }); lines.push(''); lines.push(''); return html`

${lines.join('')}

`; }31:T417,/** * Returns the types in the table. Assumes header row. By default uses row 1 for type values. * * @param {Array} data the data table * @param {number} useRowIndex the index to use for type inference */ function printTableTypes(data, verticalOrientation = true, useRowIndex = 1, maxWidth = 250){ //debugger; const header = (data[0] && Object.keys(data[0])); if(useRowIndex < data.length){ const row = (data[useRowIndex] && Object.values(data[useRowIndex])); let types = {}; for(let i = 0; i < row.length; i++){ if(row[i] instanceof Date){ types[header[i]] = "date"; }else{ types[header[i]] = typeof(row[i]); } } if(verticalOrientation){ let listOfFieldsAndTypes = []; for(let type in types){ listOfFieldsAndTypes.push({'field' : type, 'data type' : types[type]}); console.log(type); } return printTable(listOfFieldsAndTypes, undefined, maxWidth, false); }else{ return printTable([types], undefined, undefined, false); } } }32:[] 2e:{"title":"Data Utilities","cells":[{"id":0,"value":"md`# Data Utilities`","pinned":false,"hidden":false,"mode":"ojs"},{"id":61,"value":"Miscellaneous data utilities for Observable notebooks. This is a fork of the UW Interactive Lab's [Data Utilities](https://observablehq.com/@uwdata/data-utilities) with the following additions:\n* Added [*printTableTypes*](#printTableTypes) to print data types\n* Added [_countOccurrences_](https://observablehq.com/@jonfroehlich/data-utilities#cell-267) to count occurrences of properties\n* Added simple statistics like median, mean, and standard deviation","pinned":false,"hidden":false,"mode":"md"},{"id":121,"value":"printTableHeader = 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\nTODO:\n* add in formatting array\n* add in auto-sum bottom row (that is bolded)\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":4,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":189,"value":"function printValue(v, printStringsWithQuotes=true) {\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 if((typeof v === 'string' || v instanceof String) && printStringsWithQuotes){\n return JSON.stringify(v);\n }\n return String(v);\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"id":63,"value":"md`### Tests`","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"id":5,"value":"printTable(testData)","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"id":27,"value":"printTable(testData.slice().reverse(), ['baz', 'bar'], '*');","pinned":false,"hidden":false,"mode":"ojs"},{"id":164,"value":"printTable(['ABCDEFGHIJKLMNOPQRSTUVWXYZ'.split('').reduce((o,c) => {\n o['column' + c] = 1;\n return o;\n}, {})])","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"id":232,"value":"## printTableTypes","pinned":false,"hidden":false,"mode":"md"},{"id":230,"value":"$31","pinned":true,"hidden":false,"mode":"ojs"},{"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"},{"id":109,"value":"function mdTable(data, header) {\n return printTable(data, header, null);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":70,"value":"md`\n## fromColumns(_vectors_)\nGenerate an array of data objects given input _column_ vectors.\n`","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"id":81,"value":"md`### Tests`","pinned":false,"hidden":false,"mode":"ojs"},{"id":83,"value":"mdTable(fromColumns({\n u: 'abcdefgh',\n v: [2, 8, 3, 7, 5, 4, 6, 1]\n}))","pinned":true,"hidden":false,"mode":"ojs"},{"id":275,"value":"## mean(data, field)","pinned":false,"hidden":false,"mode":"md"},{"id":289,"value":"function mean(data, field) {\n // Alternatively, we could use d3's simple stats: https://observablehq.com/@d3/d3-mean-d3-median-and-friends\n // or this lovely simple stats package: http://simple-statistics.github.io/\n // But trying to reduce external dependencies\n const rawNumbers = data.map(item => item[field]);\n const total = rawNumbers.reduce((accumulator, curVal) => accumulator + curVal);\n return total / rawNumbers.length;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":285,"value":"## median(data, field)","pinned":false,"hidden":false,"mode":"md"},{"id":287,"value":"function median(data, field) {\n // Alternatively, we could use d3's simple stats: https://observablehq.com/@d3/d3-mean-d3-median-and-friends\n // or this lovely simple stats package: http://simple-statistics.github.io/\n // But trying to reduce external dependencies\n \n // Modified from https://stackoverflow.com/a/53660837\n const rawNumbers = data.map(item => item[field]);\n const sortedNumbers = Array.from(rawNumbers).sort((a, b) => a - b);\n const middleIndex = Math.floor(sortedNumbers.length / 2);\n\n if (sortedNumbers.length % 2 === 0) {\n return (sortedNumbers[middleIndex - 1] + sortedNumbers[middleIndex]) / 2;\n }\n\n return sortedNumbers[middleIndex];\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":281,"value":"## standardDeviation(data, field)","pinned":false,"hidden":false,"mode":"md"},{"id":277,"value":"function standardDeviation(data, field) {\n // Alternatively, we could use d3's simple stats: https://observablehq.com/@d3/d3-mean-d3-median-and-friends\n // or this lovely simple stats package: http://simple-statistics.github.io/\n // But trying to reduce external dependencies\n \n // Modified from https://stackoverflow.com/a/53577159\n const rawNumbers = data.map(item => item[field]);\n const n = rawNumbers.length\n const mean = rawNumbers.reduce((a, b) => a + b) / n\n return Math.sqrt(rawNumbers.map(x => Math.pow(x - mean, 2)).reduce((a, b) => a + b) / n)\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":291,"value":"## countOccurrencesMap(array, field)","pinned":false,"hidden":false,"mode":"md"},{"id":293,"value":"// Counts occurrences of a given property in an array\n// Returns a sorted count of occurrences as an array of [{k:'a'}, {k:'b'}, {k:'c'}, {k:'c'}, {k:'a'}]\n// Author: Jon E. Froehlich\nfunction countOccurrencesMap(arr, prop){\n const mapItemToCount = new Map();\n for(const item of arr){\n const key = item[prop];\n if(!mapItemToCount.has(key)){\n mapItemToCount.set(key, 1);\n }else{\n mapItemToCount.set(key, mapItemToCount.get(key) + 1);\n }\n }\n\n // Sort hashmap by count https://stackoverflow.com/a/61957932/388117\n const sortedMap = new Map([...mapItemToCount.entries()].sort((a,b) => b[1] - a[1]));\n return sortedMap;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":267,"value":"## countOccurrences(array, field)\nCounts the occurrences of values for a given field in an object array and returns a sorted count as an array with format: `[{k:'a'}, {k:'b'}, {k:'c'}, {k:'c'}, {k:'a'}]`","pinned":false,"hidden":false,"mode":"md"},{"id":261,"value":"// Counts occurrences of a given property in an array\n// Returns a sorted count of occurrences as an array of [{k:'a'}, {k:'b'}, {k:'c'}, {k:'c'}, {k:'a'}]\n// Author: Jon E. Froehlich\nfunction countOccurrences(arr, prop){\n // Sort hashmap by count https://stackoverflow.com/a/61957932/388117\n const sortedMap = countOccurrencesMap(arr, prop);\n let sortedArryCnts = new Array();\n for(const [key, value] of sortedMap.entries()){\n // Use computed property name: https://stackoverflow.com/a/3153983/388117\n sortedArryCnts.push({[prop]: key, count: value});\n }\n return sortedArryCnts;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":263,"value":"### Tests","pinned":false,"hidden":false,"mode":"md"},{"id":265,"value":"countOccurrences([{k:'a'}, {k:'b'}, {k:'c'}, {k:'c'}, {k:'a'}], 'k')","pinned":true,"hidden":false,"mode":"ojs"},{"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"},{"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"},{"id":160,"value":"md`### Tests`","pinned":false,"hidden":false,"mode":"ojs"},{"id":146,"value":"downloadLink('Download Dummy Text!', 'dummy.txt', 'dummy')","pinned":true,"hidden":false,"mode":"ojs"},{"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"},{"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"},{"id":203,"value":"md`### Tests`","pinned":false,"hidden":false,"mode":"ojs"},{"id":205,"value":"unique([1, 2, 1, 2, 3, 3])","pinned":true,"hidden":false,"mode":"ojs"},{"id":207,"value":"unique([{k:'a'}, {k:'b'}, {k:'c'}, {k:'c'}, {k:'a'}], d => d.k)","pinned":true,"hidden":false,"mode":"ojs"},{"id":215,"value":"## uniqueValid(_data[, accessor, insertNull=false]_)\nReturn a sorted list of unique values in the _data_ array, optionally applying a provided _accessor_ function to extract values first. By default, removes any `null`, `undefined`, or `NaN` values from the unique value set.\n\nIf you set _insertNull_ to true, inserts a `null` value into the beginning of the array.\n","pinned":false,"hidden":false,"mode":"md"},{"id":212,"value":"function uniqueValid(data, accessor, insertNull=false) {\n let newData = unique(data, accessor)\n .filter(d => d != null && d === d)\n .sort((a, b) => a < b ? -1 : a > b ? 1 : 0);\n\n if(insertNull){\n newData.unshift(null); // add null to beginning of array \n }\n return newData;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":220,"value":"md`### Tests`","pinned":false,"hidden":false,"mode":"ojs"},{"id":222,"value":"uniqueValid([3, 1, 2, null, undefined, NaN, 1, 2, 3])","pinned":true,"hidden":false,"mode":"ojs"},{"id":86,"value":"md`## Imports`","pinned":false,"hidden":false,"mode":"ojs"},{"id":76,"value":"d3 = require('d3-array')","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W32","stdlib":"1","titling":"auto"}