30:T99f,draw = function ({actual, observed}, {r=10, padding=20, fontSize="18px"}={}) { const height = actual.length * (2*r + padding) const datePos = 300 const estimatedIdxPos = datePos + 30 const estimatedCirclePos = estimatedIdxPos + 15 const observedCirclePos = estimatedCirclePos + 100 const observedIdxPos = observedCirclePos + 25 const yScale = d3.scaleUtc() .domain(d3.extent(actual)) .range([margin.top, height - margin.bottom]) const observedWithIdx = observed.map((date,idx) => ({date, idx})) console.log(observedWithIdx) const observedGrouped = d3.flatGroup(observedWithIdx,d => d.date).map(([date, group]) => ({date, idx: group[0].idx, n: group.length})) const observedCircles = observedGrouped.map(({date,n}) => Array.from({length:n}).map((_,i) => htl.svg``)).flat() const observedText = observedGrouped.map(({date,idx,n}) => { const idxStr = n > 1 ? `[${idx}..${idx+n-1}]` : `[${idx}]` return htl.svg`${idxStr}`}) return htl.html`

${Copier("Copy Data", {value: JSON.stringify(observed, null, 2)})}

` }31:[] 2e:{"title":"Datetime Inference","cells":[{"id":0,"value":"# Datetime Inference","pinned":false,"hidden":false,"mode":"md"},{"id":68,"value":"## Missing Values","pinned":false,"hidden":false,"mode":"md"},{"id":52,"value":"{\n const baseDate = '2005-01-01'\n const observed = [\n \"00:00:00\",\n \"01:00:00\",\n \"02:00:00\",\n // \"04:00:00\",\n \"05:00:00\"\n ].map(time => new Date(`${baseDate}T${time}Z`))\n\n const min = observed[0]\n const max = observed[observed.length-1]\n const actual = d3.timeHour.range(min, max).concat(max)\n\n return draw({actual, observed})\n}\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":98,"value":"## Duplicate Values","pinned":false,"hidden":false,"mode":"md"},{"id":79,"value":"{\n const baseDate = '2005-01-01'\n const observed = [\n \"00:00:00\",\n \"01:00:00\",\n \"02:00:00\",\n \"03:00:00\",\n \"03:00:00\",\n \"03:00:00\",\n \"04:00:00\",\n \"05:00:00\",\n ].map(time => new Date(`${baseDate}T${time}Z`))\n\n const min = observed[0]\n const max = observed[observed.length-1]\n const actual = d3.timeHour.range(min, max).concat(max)\n\n return draw({actual, observed})\n}\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":110,"value":"## Extra Values","pinned":false,"hidden":false,"mode":"md"},{"id":102,"value":"{\n const baseDate = '2005-01-01'\n const observed = [\n \"00:00:00\",\n \"01:00:00\",\n \"02:00:00\",\n \"03:00:00\",\n \"03:10:00\",\n \"04:00:00\",\n \"05:00:00\",\n ].map(time => new Date(`${baseDate}T${time}Z`))\n\n const min = observed[0]\n const max = observed[observed.length-1]\n const actual = d3.timeHour.range(min, max).concat(max)\n\n return draw({actual, observed})\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":188,"value":"## Misaligned Values (Simple)","pinned":false,"hidden":false,"mode":"md"},{"id":114,"value":"{\n const baseDate = '2005-01-01'\n const observed = [\n \"00:00:00\",\n \"01:00:00\",\n \"02:00:00\",\n \"03:10:00\",\n \"04:00:00\",\n \"05:00:00\",\n ].map(time => new Date(`${baseDate}T${time}Z`))\n\n const min = observed[0]\n const max = observed[observed.length-1]\n const actual = d3.timeHour.range(min, max).concat(max)\n\n return draw({actual, observed})\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":390,"value":"## Misaligned Values (Complex)","pinned":false,"hidden":false,"mode":"md"},{"id":201,"value":"{\n const baseDate = '2005-01-01'\n const observed = [\n \"00:00:00\",\n \"01:00:00\",\n \"01:30:00\",\n \"02:50:00\",\n \"03:10:00\",\n \"04:00:00\",\n \"05:00:00\",\n ].map(time => new Date(`${baseDate}T${time}Z`))\n\n const min = observed[0]\n const max = observed[observed.length-1]\n const actual = d3.timeHour.range(min, max).concat(max)\n\n return draw({actual, observed})\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":400,"value":"## Bad Start","pinned":false,"hidden":false,"mode":"md"},{"id":211,"value":"{\n const baseDate = '2005-01-01'\n const observed = [\n \"00:50:00\",\n \"02:00:00\",\n \"03:00:00\",\n \"04:00:00\",\n \"05:00:00\",\n \"06:00:00\",\n ].map(time => new Date(`${baseDate}T${time}Z`))\n\n const min = new Date(`${baseDate}T01:00:00Z`)\n const max = observed[observed.length-1]\n const actual = d3.timeHour.range(min, max).concat(max)\n\n return draw({actual, observed})\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":221,"value":"big_range = {\n const a = d3.timeHour.range(new Date(2005, 0, 1,0,0,0), new Date(2005, 0, 1, 8,0,0))\n const b = d3.timeHour.range(new Date(2005, 0, 1,9,0,0), new Date(2005, 0, 1, 11,0,0))\n const c = d3.timeHour.range(new Date(2005, 0, 1,17,0,0), new Date(2005, 0, 2, 0,0,0))\n\n const actual = d3.timeHour.range(new Date(2005, 0, 1,0,0,0), new Date(2005, 0, 2, 0,0,0))\n\n const observed = [...a, ...b, ...c]\n return draw({actual, observed})\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":418,"value":"{\n const baseDate = '2005-01-01'\n const observed = [\n \"00:00:00\",\n \"01:00:00\",\n \"01:00:00\",\n \"01:00:00\",\n \"02:00:00\",\n \"03:00:00\",\n // \"04:00:00\",\n \"05:00:00\",\n \"06:00:00\",\n \"06:20:00\",\n \"07:00:00\",\n \"08:00:00\",\n ].map(time => new Date(`${baseDate}T${time}Z`))\n\n const min = new Date(`${baseDate}T00:00:00Z`)\n const max = observed[observed.length-1]\n const actual = d3.timeHour.range(min, max).concat(max)\n\n return draw({actual, observed})\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":535,"value":"{\n const baseDate = '2005-01-01'\n const observed = [\n \"00:00:00\",\n \"01:00:00\",\n \"02:00:00\",\n \"03:10:00\",\n \"03:20:00\",\n \"04:20:00\",\n \"05:00:00\",\n \"06:00:00\",\n \"06:20:00\",\n \"07:00:00\",\n \"08:00:00\",\n ].map(time => new Date(`${baseDate}T${time}Z`))\n\n const min = new Date(`${baseDate}T00:00:00Z`)\n const max = observed[observed.length-1]\n const actual = d3.timeHour.range(min, max).concat(max)\n\n return draw({actual, observed})\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":226,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":42,"value":"formatTime = (d) => d3.timeFormat(\"%H:%M:%S\")(new Date(d.toLocaleString('en-US', {timeZone: \"UTC\"})));","pinned":false,"hidden":false,"mode":"ojs"},{"id":17,"value":"margin = ({top: 50, right: 30, bottom: 30, left: 40})","pinned":false,"hidden":false,"mode":"ojs"},{"id":506,"value":"import {Copier} from \"@mbostock/copier\"","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}