2c:null 2d:["$","title",null,{"children":"Table | anndawn | Observable"}] 32:Tc1c,format={return html` ${result}`}33:T1323,table = async function*(dataPromise, options = {}) { yield loader; const dataO = await Promise.resolve(dataPromise); let filter = () => true; const data = Array.isArray(dataO) ? dataO : Object.entries(dataO).map(([key, v]) => Object.assign({ key }, v)); let { humanize, nully, limit, columns, enableFilter, enableCSVDownload, maxHeight } = Object.assign( { humanize: defaultHumanize, nully: () => '-', limit: 250, columns: Object.keys(data[0]), enableFilter: data.length > 50, enableCSVDownload: true, maxHeight: max_height }, options || {} ); if (typeof maxHeight === 'number') maxHeight = `${maxHeight}px`; columns = columns.map(column => { let key; if (typeof column == 'string') { key = column; column = { key }; } else { key = column.key; } const decimalNumber = data.reduce((memo, d) => { if (typeof d[key] === 'number') { let frac = (d[key] || '').toString().split('.')[1]; if (frac) return Math.max(memo, frac.length); } return memo; }, 0); return Object.assign( { name: humanize(key), type: typeof data[0][key], accessor: row => row[key], render: val => { if (decimalNumber && typeof val === 'number') { return val.toFixed(decimalNumber); } if (val == null || val == undefined) { return nully(val); } return val; } }, column ); }); const renderTable = () => { return `${data .filter(filter) .slice(0, limit) .map( datum => ` ${columns .map(c => { return `${c.render(c.accessor(datum))}`; }) .join('')} ` ) .join('')}`; }; const output = html`

${columns .map( c => `` ) .join('')} ${renderTable()}

${c.name}

${ data.filter(filter).length > limit ? `

This table has been truncated from ${data.length} rows to ${limit}

` : '' }

${ enableFilter ? '

🔎

' : '' }

`; output.value = dataO; yield output; output.querySelectorAll('th').forEach(th => th.addEventListener('click', () => { const key = th.dataset.key; const order = th.dataset.order === 'ascending' ? -1 : 1; data.sort((a, b) => a[key] > b[key] ? order : b[key] > a[key] ? -order : 0 ); output.querySelector('tbody').innerHTML = renderTable(); th.dataset.order = order === -1 ? 'descending' : 'ascending'; }) ); if (enableFilter) { const search = output.querySelector('input[type=search]'); search.addEventListener('input', e => { filter = parseQuery(search.value, columns); output.querySelector('tbody').innerHTML = renderTable(); }); } if (enableCSVDownload) { output.appendChild( DOM.download( new Blob( [ CSV(data, { fields: columns.map(c => ({ label: c.name, value: c.key })) }) ], { type: "application/json" } ), 'data.csv', '⬇' ) ); } }34:T745,loader = html` Loading...`35:T498,sty=html``36:[{"id":"48a6bfe749ed0543d6144ff03bcf5b10f18e1255278b2462295fd5fe293ba4e70d0ac7b269b11144f0b8620528330df827959c7c34d36e3789b9f4f0a933a644","href":"https://static.observableusercontent.com/files/48a6bfe749ed0543d6144ff03bcf5b10f18e1255278b2462295fd5fe293ba4e70d0ac7b269b11144f0b8620528330df827959c7c34d36e3789b9f4f0a933a644","name":"defence_wrong.csv","type":"text/csv","lastModified":1631859872273.028,"size":94574}] 30:{"id":"aba5571c6b9985e1","slug":"table","title":"Table","thumbnail":"4cf78a967b2625f41fb14daba28578bf384b953a8675f69c5b89125c53412867","access_level":"public","create_time":"$D2021-08-12T15:24:15.899Z","update_time":"$D2023-04-20T18:05:02.991Z","view_time":null,"first_public_time":"$D2021-08-12T15:25:12.668Z","has_unpublished_edits":null,"fork":{"id":"715b4c45cc45c3b3","slug":"table","title":"Table","owner":{"id":"a2f700b6ce27b844","login":"gampleman","name":"Jakub Hampl"}},"stars":0,"starred":false,"owner":{"type":"team","id":"08b25cc9d2cc09a6","login":"anndawn","name":"","avatar_url":"https://avatars-next.observableusercontent.com/a9bef462081f7a77e161e2b21c48a5ea6a7153836b0db2eb8a565396dcfc57c5","tier":"starter_2024"},"version":272,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"b0fc265f2fad2840","login":"anndawn","name":"","avatar_url":"https://avatars-next.observableusercontent.com/a9bef462081f7a77e161e2b21c48a5ea6a7153836b0db2eb8a565396dcfc57c5","tier":null}],"members":[{"type":"individual","id":"b0fc265f2fad2840","login":"anndawn","name":"","avatar_url":"https://avatars-next.observableusercontent.com/a9bef462081f7a77e161e2b21c48a5ea6a7153836b0db2eb8a565396dcfc57c5","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"title":"Table","cells":[{"id":0,"value":"md`# Table\n\nThis is an extension of [Fancy Tables](https://beta.observablehq.com/@tmcw/fancy-tables) by @tmcw.\n\nThe main advantage here is that:\n\n1. This can be used without creating a cell. Simply by passing in data and then creating a variable with \\`viewof\\` one can get both a nice view of the data and the data as a variable.\n2. Because of this, if the data is a promise (i.e. a fetch), a loading animation will be rendered. Support for streaming data may come in the future.\n3. The data can be sorted by clicking the table headers.\n4. The styling is designed for overflow scrolling.\n\n## Usage\n\nFirst import this into your notebook:\n\n~~~javascript\nimport { table } from \"@gampleman/table\"\n~~~\n\nThe simplest usage is to simply pass in an array of objects:\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":78,"value":"result=table([\n {first_name: 'John', last_name: 'Doe'},\n {first_name: 'Martin', last_name: 'Smith'}\n]) ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":229,"value":"$32","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":82,"value":"md`You can also pass in something that produces a promise:`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":85,"value":"table(\n fetch(json_url).then(d => d.json())\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":95,"value":"md`If you use \\`viewof\\`, you can also assign the data produced by the first argument in the same cell:`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":10,"value":"viewof data = table(\n defence_filter,\n {\n nully: () => 'No data',\n limit: 500,\n enableFilter: true,\n enableCSVDownload: true,\n columns: [\n 'Supplier_name',\n 'Quantity', \n 'UOM',\n 'Unit_price',\n 'Order_amount',\n 'Payments',\n {\n key: 'Date_order2', \n name: 'Order Date'\n },\n {\n key:\"Date_payments2\",\n name:\"Payments Date\"\n }]\n }\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":35,"value":"data","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":99,"value":"md`Finally, you can use the second argument to customize the output:`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":101,"value":"x=table(\n fetch(json_url).then(d => d.json()),\n {\n nully: () => 'No data',\n limit: 500,\n enableFilter: false,\n enableCSVDownload: true,\n columns: [{ \n key: 'key',\n name: 'Station ID',\n render: val => `${val}`\n }, \n 'last1hrf', \n 'rainfall',\n 'rainfallmsg', \n {\n key: 'rfstationstatus', \n name: 'RF Status'\n }]\n }\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":107,"value":"parseQuery = (q, headers) => {\n if (q == '') {\n return () => true;\n } else if (q.match(/[=<>]/)) {\n try {\n const code = headers.reduce((q, {key, name}) => q.replace(new RegExp(`\\\\b(${key}|${name})\\\\b`, 'g'), `data['${key}']`), q).replace(/([^=<>!])=([^=<>!]|$)/g, '$1===$2');\n return new Function('data', `try { return ${code} } catch(e) { return false; }` );\n } catch (e) {\n return () => true;\n }\n } else {\n const re = new RegExp(q, 'i');\n \treturn data => headers.some(({key}) => (data[key] || '').toString().match(re))\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":58,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"defaultHumanize = str => str.replace(/[-_]/g, ' ')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":89,"value":"json_url = 'https://gist.githubusercontent.com/gampleman/0903af7279c6c60e6d5c85ca33361960/raw/b21a86ceb808307208970b24045cfe9bc9a6f744/rainlevels.json'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":176,"value":"CSV = require('json2csv@4.0.0').then(a => a.parse)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":224,"value":"max_height=400","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":235,"value":"$35","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":242,"value":"defence=FileAttachment(\"defence_wrong.csv\").csv({typed:true})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":245,"value":"defence_filter={\n let filtered=defence.filter(d=>(d.Quantity==60000)&(d.status==\"wrong\"))\n filtered.map(d=>d.Date_order2=dateformat(d.Date_order))\n filtered.map(d=>d.Date_payments2=dateformat(d.Date_payments))\n return filtered\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":251,"value":"dateformat=d3.utcFormat(\"%Y-%m-%d\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":253,"value":"dateformat(defence[0].Date_order)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W36","stdlib":"1","titling":"auto"}} 31:"$30:body"