3e:null 3f:["$","title",null,{"children":"Data Vis Course Assignment | Hermes Carretero | Observable"}] 45:[] 43:{"id":"ba65325fd25452c5","slug":null,"title":"Data Vis Course Assignment","thumbnail":"8d80530a92bb979d726bffb4057c96b9c252b856374b94ad7155cf9e1a7305a8","access_level":"public","create_time":"$D2023-03-14T17:18:57.456Z","update_time":"$D2023-04-03T11:00:21.934Z","view_time":null,"first_public_time":"$D2023-03-14T17:18:57.456Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"0d2d6cef1b359280","login":"bb8615570a063daf","name":"Hermes Carretero","avatar_url":"https://avatars-next.observableusercontent.com/16487817d192f485c8aab45749f2464b98619caa26451a1ba2fcabd2a979332c","tier":"starter_2024","bio":"","following":false},"version":1893,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"bb8615570a063daf","login":"bb8615570a063daf","name":"Hermes Carretero","avatar_url":"https://avatars-next.observableusercontent.com/16487817d192f485c8aab45749f2464b98619caa26451a1ba2fcabd2a979332c","tier":null,"bio":"","following":false}],"members":[{"type":"individual","id":"bb8615570a063daf","login":"bb8615570a063daf","name":"Hermes Carretero","avatar_url":"https://avatars-next.observableusercontent.com/16487817d192f485c8aab45749f2464b98619caa26451a1ba2fcabd2a979332c","tier":null,"role":"editor"}],"comments":[{"id":"ee727608a105a071","reply_to_id":null,"content":"Good use of smoothing! Nicely done!","create_time":"$D2023-04-18T16:00:07.425Z","update_time":null,"resolved":false,"user":{"type":"individual","id":"ce771552211c04ab","login":"rkosara","name":"Robert Kosara","avatar_url":"https://avatars-next.observableusercontent.com/105903f7d3ac285a1489b547eecce8f57bd15052862a307c4c2242f847d44a67","tier":null}},{"id":"3c169823d05613ea","reply_to_id":"ee727608a105a071","content":"Thank you!","create_time":"$D2023-04-19T07:49:35.845Z","update_time":null,"resolved":false,"user":{"type":"individual","id":"bb8615570a063daf","login":"bb8615570a063daf","name":"Hermes Carretero","avatar_url":"https://avatars-next.observableusercontent.com/16487817d192f485c8aab45749f2464b98619caa26451a1ba2fcabd2a979332c","tier":null}}],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Data Vis Course Assignment","cells":[{"id":0,"value":"# Data Vis Course Assignment","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1520,"value":"## Exploration\n### Daily pizza orders","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":215,"value":"viewof reducer = Inputs.select([\"mean\", \"median\", \"min\", \"max\"], {label: \"Reducer\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":195,"value":"viewof k = Inputs.range([1, 7], {label: \"Smoothing\", step: 1, value: 1})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":168,"value":"Plot.plot({\n marks: [\n Plot.ruleY([0]),\n Plot.lineY(dataFlatGroupSorted, \n Plot.windowY({\n x: d => d[0], // orderDate\n y: d => d3.sum(d[2], o => o['orders']), // array of objects\n z: d => d[1], // state\n // title: d => d[0] + ' - ' + d3.sum(d[2], o => o['orders']), \n title: d => d[1],\n stroke: d => d[1],\n reduce: reducer,\n k: k,\n })\n ),\n Plot.axisX({ticks: \"month\", tickSize: 16, tickPadding: -11, tickFormat: \" %b\", textAnchor: \"start\"}),\n Plot.gridX({ticks: \"week\", stroke: \"#CCC\", strokeOpacity: 1, insetBottom: -0.5}),\n\n ],\n color: {\n domain: [\"CA\", \"NV\"],\n legend: true,\n \n },\n y: {\n grid: true,\n label: \"2022 total orders\",\n },\n width: width,\n height: 240,\n marginLeft: 50\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":459,"value":"Plot.plot({\n marks: [\n // Plot.ruleY([0]),\n Plot.lineY(dataFlatGroupSorted,\n Plot.normalizeY(Plot.windowY({x: d => d[0], y: d => d3.sum(d[2], o => o['orders']), stroke: d => d[1], reduce: reducer,\n k: k, title: d => d[1]}))),\n Plot.axisX({ticks: \"month\", tickSize: 16, tickPadding: -11, tickFormat: \" %b\", textAnchor: \"start\"}),\n Plot.gridX({ticks: \"week\", stroke: \"#CCC\", strokeOpacity: 1, insetBottom: -0.5}),\n ],\n y: {\n type: \"log\",\n grid: true,\n label: \"↑ Change in Total orders (%)\",\n tickFormat: (f => x => f((x - 1) * 100))(d3.format(\"+d\"))\n },\n width: width,\n height: 200,\n marginLeft: 50\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1696,"value":"### Ranking by pizza name","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":888,"value":"viewof radiosNamesStates = Inputs.radio([\"Total orders\", \"Total $\"], {label: \"Select one\", value: \"Total orders\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1309,"value":"Plot.plot({\n\n marks: [\n Plot.frame(),\n // Plot.dot(dayByStateByNameTotals, Plot.normalizeX({x: radiosNamesStates, y: \"day\", stroke: \"name\", title: \"name\"})),\n // Plot.dot(dayByStateByNameTotals, {x: radiosNamesStates, y: \"day\", stroke: \"name\", title: \"name\"}),\n Plot.barX(dayByStateByNameTotals, {\n y: \"name\",\n x: radiosNamesStates,\n fill: \"name\",\n sort: {y: \"x\", reverse: true},\n // title: radiosNamesStates\n }),\n Plot.ruleY([0])\n ],\n width: width,\n marginLeft: 120,\n grid: true,\n color: {\n legend: true\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1523,"value":"#### By day of the week","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":731,"value":"Plot.plot({\n y: {\n padding: 0.1,\n tickFormat: Plot.formatWeekday(\"en\", \"narrow\"),\n tickSize: 0,\n ticks: 7,\n domain: [1,2,3,4,5,6,0],\n axis: \"left\",\n },\n facet: {\n data: dayByStateByNameTotals,\n x: \"category\",\n y: \"state\",\n sort: \"category\"\n },\n marks: [\n Plot.frame(),\n // Plot.dot(dayByStateByNameTotals, Plot.normalizeX({x: \"orders\", y: \"day\", stroke: \"name\", title: \"name\"})),\n // Plot.dot(dayByNameTotals, {x: \"day\", y: radios, stroke: \"name\", title: \"name\"}),\n Plot.barX(\n // _.filter(dayByStateByNameTotals, obj => obj['state'] === 'CA'), \n dayByStateByNameTotals,\n {\n y: d => new Date(d[\"sampleDate\"]).getUTCDay(), \n x: radiosNamesStates, \n fill: \"name\", \n title: \"name\", \n sort: radiosNamesStates,\n reverse: true,\n }\n )\n ],\n width: width,\n // marginLeft: marginLeft / 2,\n // height: 250,\n grid: true\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1712,"value":"## Explanation\n### Calendar Heat map: total orders and by pizza name\n#### Explore the different date order patterns during 2022 for each name of pizza\n- *More orders day*: March the 13rd, Sunday. Daylight Saving Time\n- *Monday outlier*: February the 14th, Monday. San Valentin's day\n- *Weekends*: Saturday is the day with more aggregated orders but is on Sunday when the top days of orders are\n- *States*: The pattern for both states is quite similar","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":208,"value":"viewof pizzaNamesSelector = Inputs.select(pizzaNameOptions, {label: \"Name of pizza\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1801,"value":"#### NV state","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":310,"value":"Calendar(_.filter(calendarData, day => day['state'] === \"NV\"), {\n x: d => d['date'],\n y: d => -d[pizzaNamesSelector],\n // y: (d, i, data) => i > 0 ? (d.orders - data[i - 1].orders) / data[i - 1].orders : NaN, // relative change\n // yFormat: \"+%\", // show percent change on hover\n title: d => formatTime(d['date']) + ' - ' + d[pizzaNamesSelector],\n width: 1000\n // colors: d3.interpolatePuRd\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1803,"value":"#### CA state","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":325,"value":"Calendar(_.filter(calendarData, day => day['state'] === \"CA\"), {\n x: d => d['date'],\n y: d => d[pizzaNamesSelector],\n title: d => formatTime(d['date']) + ' - ' + d[pizzaNamesSelector],\n width: 1000\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1724,"value":"

\n \n \n \n \n \n \n \n \n ${_.orderBy(_.filter(calendarData, d => d['state'] === 'NV'), pizzaNamesSelector, \"desc\").slice(0, 5).map(day => htl.html`\n \n \n \n `)}\n \n

NV - ranking days	${pizzaNamesSelector}
${day[\"date\"]}	${day[pizzaNamesSelector]}

\n \n \n \n \n \n \n \n \n ${_.orderBy(_.filter(calendarData, d => d['state'] === 'CA'), pizzaNamesSelector, \"desc\").slice(0, 5).map(day => htl.html`\n \n \n \n `)}\n \n

CA - ranking days	${pizzaNamesSelector}
${day[\"date\"]}	${day[pizzaNamesSelector]}

\n\n

\n \n \n \n \n \n \n \n \n ${_.orderBy(calendarDifferences, calendarRadios, \"asc\").slice(0, 5).map(day => htl.html`\n \n \n \n `)}\n \n

NV - ranking days by difference	${calendarRadios}
${day[\"date\"]}	${day[calendarRadios]}

\n \n \n \n \n \n \n \n \n ${_.orderBy(calendarDifferences, calendarRadios, \"desc\").slice(0, 5).map(day => htl.html`\n \n \n \n `)}\n \n

CA - ranking days	${calendarRadios}
${day[\"date\"]}	${day[calendarRadios]}

\n\n

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1887,"value":"## Appendix","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":7,"value":"pizzaorders","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1754,"value":"html`\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":657,"value":"dayByStateByNameTotals = _.sortBy(_.map(dayByStateByName, arr => {\n\n const ordersTotal = d3.sum(arr[3], o => o['orders']);\n const priceTotal = d3.sum(arr[3], o => o['total'])\n const normValue = arr[3] === 'NV' ? scaleNVOrders(d3.sum(arr[3], o => o['orders'])) : scaleCAOrders(d3.sum(arr[3], o => o['orders']));\n \n const newObj = {};\n newObj['sort'] = arr[0] === 0 ? 7 : arr[0];\n newObj['day'] = arr[0] === 0 ? 7 : arr[0];\n newObj['sampleDate'] = arr[3][0]['orderDate']\n newObj['state'] = arr[1];\n newObj['name'] = arr[2];\n newObj['Total orders'] = ordersTotal;\n newObj['Total $'] = priceTotal;\n newObj['category'] = arr[3][0]['category']\n newObj['Normalised value'] = normValue;\n return newObj;\n}), 'sort')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":273,"value":"### Utils","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":277,"value":"paintValues = (date, state) => {\n\n console.log(\"DATE\", date);\n console.log(\"STATE\", state);\n // if it's max for CA\n \n if (state === \"CA\") {\n if (maxOrdersDayCA.includes(date)) {\n return 1;\n }\n } else {\n if (maxOrdersDayNV.includes(date)) {\n return 1;\n }\n }\n \n \n\n \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":377,"value":"formatTime = d3.timeFormat(\"%B %d, %Y\");","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":66,"value":"### Prepare data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":519,"value":"### Process pizzaorders","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":521,"value":"pizzaordersEnrichment = _.map(pizzaorders, obj => {\n\n let splitName = obj.name.split(\"Pizza\");\n splitName = _.map(splitName, word => word.trim());\n \n obj.simpleName = splitName[0] + \" Pizza\";\n obj.size = splitName[1]\n \n return obj;\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":621,"value":"pizzaSizes = [\"Extra Large\", \"Large\", \"Medium\", \"Small\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":836,"value":"pizzaNames = [...new Set(_.map(pizzaordersEnrichment, order => order['simpleName']))]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":851,"value":"pizzaNameOptions = ['orders'].concat(pizzaNames)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":899,"value":"#### Total aggregates","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":901,"value":"totals = (\n {\n 'Total orders': d3.sum(pizzaordersEnrichment, d => d['orders']),\n 'Total $': d3.sum(pizzaordersEnrichment, d => d['total'])\n }\n)\n\n\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":127,"value":"### Function for summing orders by day","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":129,"value":"sumOrders = (date) => {\n // console.log(\"DATE\", date.getTime());\n const currentArrayOfValues = _.filter(pizzaorders, order => order['orderDate'].getTime() === date.getTime());\n // console.log(\"currentArrayOfValues\", currentArrayOfValues)\n // return 1;\n return d3.sum(currentArrayOfValues, d => d['orders'])\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":160,"value":"dataGroupedByDate = d3.group(pizzaorders, d => d['orderDate'], d => d['state'])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":162,"value":"dataRollUpCount = d3.rollup(pizzaorders, v => v.length, d => new Date(d['orderDate']));","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":166,"value":"dataRollUpSum = d3.rollup(pizzaorders, v => d3.sum(v, d => d['orders']), d => d['orderDate'])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":397,"value":"daysUniqList = [...dataRollUpSum.keys()].sort(function(a,b){\n // Turn your strings into dates, and then subtract them\n // to get a value that is either negative, positive, or zero.\n return new Date(a) - new Date(b);\n})\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":174,"value":"dataFlatGroup = d3.flatGroup(pizzaorders, d => d['orderDate'], d => d['state'])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":186,"value":"dataFlatGroupSorted = dataFlatGroup.sort((a, b) => d3.ascending(a[0], b[0]))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":530,"value":"### Calendar data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":331,"value":"calendarData = _.map(dataFlatGroupSorted, arr => {\n const newObj = {};\n newObj['date'] = new Date(arr[0]);\n newObj['state'] = arr[1];\n newObj['orders'] = d3.sum(arr[2], o => o['orders']);\n newObj['price'] = d3.sum(arr[2], o => o['total']);\n _.map(pizzaNames, name => {\n newObj[name] = d3.sum(_.filter(arr[2], row => row['simpleName'] === name), o => o['orders'])\n })\n return newObj;\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":560,"value":"scaleNVOrders = d3.scaleLinear()\n .domain(NVExtent)\n .range([0,1])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":800,"value":"scaleNVPrice = d3.scaleLinear()\n .domain(NVPriceExtent)\n .range([0,1])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":564,"value":"scaleCAOrders = d3.scaleLinear()\n .domain(CAExtent)\n .range([0,1])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":803,"value":"scaleCAPrice = d3.scaleLinear()\n .domain(CAPriceExtent)\n .range([0,1])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":555,"value":"NVExtent = d3.extent(_.filter(calendarData, obj => obj['state'] === \"NV\"), d => d.orders)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":789,"value":"NVPriceExtent = d3.extent(_.filter(calendarData, obj => obj['state'] === \"NV\"), d => d.price)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":558,"value":"CAExtent = d3.extent(_.filter(calendarData, obj => obj['state'] === \"CA\"), d => d.orders)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":792,"value":"CAPriceExtent = d3.extent(_.filter(calendarData, obj => obj['state'] === \"CA\"), d => d.price)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":796,"value":"#### Process norm values for orders and prices","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":566,"value":"normCalendarValues = _.map(calendarData, obj => {\n //1xe3e1iedz1a.skz<ºñp8-`s3´f x8ud\n obj['ordersNormValue'] = obj['state'] === 'NV' ? scaleNVOrders(obj['orders']) : scaleCAOrders(obj['orders']);\n obj['priceNormValue'] = obj['state'] === 'NV' ? scaleNVPrice(obj['price']) : scaleCAPrice(obj['price']);\n return obj;\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":574,"value":"calendarDifferences = _.map(daysUniqList, day => {\n\n let dayData = _.filter(normCalendarValues, obj => obj['date'].toString() === day.toString());\n dayData = _.sortBy(dayData, \"state\")\n\n console.log(dayData)\n \n const newObj = {};\n newObj['date'] = day;\n newObj['Total orders'] = dayData[0]['ordersNormValue'] - dayData[1]['ordersNormValue']; // ordersDifference\n newObj['Total $'] = dayData[0]['priceNormValue'] - dayData[1]['priceNormValue']; // priceDifference\n \n return newObj;\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":562,"value":"### Get some max and mins","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":236,"value":"maxOrdersDay = d3.least(d3.rollup(pizzaorders, v => d3.sum(v, d => d['orders']), d => d['orderDate']), ([, sum]) => -sum)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":244,"value":"minOrdersDay = d3.least(d3.rollup(pizzaorders, v => d3.sum(v, d => d['orders']), d => d['orderDate']), ([, sum]) => sum)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":239,"value":"maxOrdersDayNV = d3.least(d3.rollup(_.filter(pizzaorders, order => order['state'] === 'NV'), v => d3.sum(v, d => d['orders']), d => d['orderDate']), ([, sum]) => -sum)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":247,"value":"minOrdersDayNV = d3.least(d3.rollup(_.filter(pizzaorders, order => order['state'] === 'NV'), v => d3.sum(v, d => d['orders']), d => d['orderDate']), ([, sum]) => sum)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":242,"value":"maxOrdersDayCA = d3.least(d3.rollup(_.filter(pizzaorders, order => order['state'] === 'CA'), v => d3.sum(v, d => d['orders']), d => d['orderDate']), ([, sum]) => -sum)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":249,"value":"minOrdersDayCA = d3.least(d3.rollup(_.filter(pizzaorders, order => order['state'] === 'CA'), v => d3.sum(v, d => d['orders']), d => d['orderDate']), ([, sum]) => sum)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":348,"value":"### Group data by week","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":350,"value":"pizzaWeeks = dataFlatGroupSorted.reduce((acc, date) => {\n\n // create a composed key: 'year-week' \n const yearWeek = `${moment(date[0]).year()}-${moment(date[0]).week()}`;\n \n // add this key as a property to the result object\n if (!acc[yearWeek]) {\n acc[yearWeek] = [];\n }\n \n // push the current date that belongs to the year-week calculated befor\n acc[yearWeek].push(date);\n\n return acc;\n\n}, {});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":653,"value":"### Group data by day of the week","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":655,"value":"dayByStateByName = d3.flatGroup(pizzaordersEnrichment, d => d['day_of_week'], d => d['state'], d => d['simpleName'])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":725,"value":"dayByName = d3.flatGroup(pizzaordersEnrichment, d => d['day_of_week'], d => d['simpleName'])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":728,"value":"dayByNameTotals = _.orderBy(_.map(dayByName, arr => {\n\n const ordersTotal = d3.sum(arr[2], o => o['orders']);\n const priceTotal = d3.sum(arr[2], o => o['total'])\n // obj['normValue'] = obj['state'] === 'NV' ? scaleNVOrders(obj['orders']) : scaleCAOrders(obj['orders']);\n \n const newObj = {};\n newObj['sort'] = arr[0] === 0 ? 7 : arr[0];\n newObj['day'] = arr[0];\n newObj['sampleDate'] = arr[2][0]['orderDate']\n newObj['name'] = arr[1];\n newObj['Total orders'] = ordersTotal;\n newObj['Total $'] = priceTotal;\n newObj['category'] = arr[2][0]['category']\n return newObj;\n}), \"sort\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":692,"value":"dayCAExtent = d3.extent(_.filter(dayByStateByNameTotals, o => o['state'] === 'CA'), d => d['orders'])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":699,"value":"dayNVExtent = d3.extent(_.filter(dayByStateByNameTotals, o => o['state'] === 'NV'), d => d['orders'])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":701,"value":"dayCAScaleNorm = d3.scaleLinear()\n .domain(dayCAExtent)\n .range([0,1])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":705,"value":"dayNVScaleNorm = d3.scaleLinear()\n .domain(dayNVExtent)\n .range([0,1])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":707,"value":"normStateCalendarData = _.map(dayByStateByNameTotals, obj => {\n obj['normOrders'] = obj['state'] === 'NV' ? dayNVScaleNorm(obj['orders']) : dayCAScaleNorm(obj['orders']);\n return obj;\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":475,"value":"### Data by category -> name","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":478,"value":"categoryNameFlatGroup = d3.flatGroup(pizzaordersEnrichment, d => d['category'], d => d['simpleName'], d => d['size'])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":923,"value":"#### Group by Name","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":925,"value":"nameFlatGroup = d3.flatGroup(pizzaordersEnrichment, d => d['simpleName'])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":928,"value":"nameTotals = _.map(nameFlatGroup, name => {\n const newObj = {};\n newObj['name'] = name[0];\n newObj['Total orders'] = d3.sum(name[1], d => d['orders']);\n newObj['Total $'] = d3.sum(name[1], d => d['total']);\n return newObj;\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":946,"value":"totalExtentOrders = d3.extent(nameTotals, d => d['Total orders']);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":948,"value":"totalExtentPrice = d3.extent(nameTotals, d => d['Total $']);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":950,"value":"nameTotalsEnrichment = _.map(nameTotals, name => {\n \n name['normOrders'] = scaleOrders(name['Total orders']);\n name['normPrice'] = scalePrice(name['Total $']);\n return name;\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":958,"value":"scaleOrders = d3.scaleLinear().domain(totalExtentOrders).range([0,1]);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":963,"value":"scalePrice = d3.scaleLinear().domain(totalExtentPrice).range([0,1]);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1020,"value":"#### Total by name and size","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1024,"value":"nameSizeFlatGroup = d3.flatGroup(pizzaordersEnrichment, d => d['simpleName'], d => d['size'])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1022,"value":"nameSizeTotals = _.sortBy(_.map(nameSizeFlatGroup, name => {\n \n const newObj = {};\n newObj['name'] = name[0];\n newObj['size'] = name[1];\n newObj['Total orders'] = d3.sum(name[2], d => d['orders']);\n newObj['Total $'] = d3.sum(name[2], d => d['total']);\n return newObj;\n}), \"Total orders\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1059,"value":"nameSizeTotalsEnrichment = _.map(nameSizeTotals, obj => {\n obj['normOrders'] = obj['Total orders'] / d3.sum(_.filter(nameSizeTotals, d => d['name'] === obj['name']), d => d['Total orders']);\n obj['normPrice'] = obj['Total $'] / d3.sum(_.filter(nameSizeTotals, d => d['name'] === obj['name']), d => d['Total $']);\n return obj;\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1052,"value":"nameSizeOrdersExtent = d3.extent(nameSizeTotals, d => d['Total orders'])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1057,"value":"nameSizePriceExtent = d3.extent(nameSizeTotals, d => d['Total $'])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1378,"value":"### Ranking of pizza orders","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1367,"value":"width = 1000","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1371,"value":"marginLeft = 120","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":346,"value":"### Imports","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":304,"value":"import {Calendar} from \"@d3/calendar\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":68,"value":"import {Plot} from \"@mkfreeman/plot-tooltip\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":36,"value":"import {pizzaorders} from \"@observablehq/data-vis-course-assignment\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":60,"value":"_ = require(\"lodash@4\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":251,"value":"import {key} from \"@two-n/calendar-heatmap\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":352,"value":"moment = require(\"moment\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W45","stdlib":"1"}} 44:"$43:body"