3e:null 3f:["$","title",null,{"children":"Data Vis Course Assignment | edenchiang | Observable"}] 45:T5ba,function addRegression(Plot) { Plot.regression = function ({ x, y, type, bandwidth, order, ...options }) { type = String(type).toLowerCase(); const regressor = type === "quad" ? reg.regressionQuad() : type === "poly" ? reg.regressionPoly() : type === "pow" ? reg.regressionPow() : type === "exp" ? reg.regressionExp() : type === "log" ? reg.regressionLog() : type === "loess" ? reg.regressionLoess() : reg.regressionLinear(); if (bandwidth && regressor.bandwidth) regressor.bandwidth(bandwidth); if (order && regressor.order) regressor.order(order); const z = options.z || options.stroke; // maybeZ return Plot.transform(options, function (data, facets) { const X = Plot.valueof(data, x); const Y = Plot.valueof(data, y); const Z = Plot.valueof(data, z); regressor.x((i) => X[i]).y((i) => Y[i]); const regFacets = []; const points = []; for (const facet of facets) { const regFacet = []; for (const I of Z ? d3.group(facet, (i) => Z[i]).values() : [facet]) { const reg = regressor(I); for (const d of reg) { const j = points.push(d) - 1; if (z) d[z] = Z[I[0]]; regFacet.push(j); } } regFacets.push(regFacet); } return { data: points, facets: regFacets }; }); }; return Plot; }46:[] 43:{"id":"913f8c93698de860","slug":null,"title":"Data Vis Course Assignment","thumbnail":"a20f1104dc5d29ca0563c9059f0d477f87dbbdfe6b8ba3b8c38a8ecda1c0c860","access_level":"public","create_time":"$D2023-04-11T08:26:16.172Z","update_time":"$D2023-04-14T10:02:11.834Z","view_time":null,"first_public_time":"$D2023-04-11T08:26:16.172Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"d6ab968f7e25da31","login":"edenchiang","name":"","avatar_url":"https://avatars-next.observableusercontent.com/a2c84c4bc1caecd3bff67953320715d40334a3b7d62c50d93f5f294a0c4152d4","tier":"starter_2024","bio":"","following":false},"version":1149,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"e4fc989e3149cad3","login":"edenchiang","name":"","avatar_url":"https://avatars-next.observableusercontent.com/a2c84c4bc1caecd3bff67953320715d40334a3b7d62c50d93f5f294a0c4152d4","tier":null,"bio":"","following":false}],"members":[{"type":"individual","id":"e4fc989e3149cad3","login":"edenchiang","name":"","avatar_url":"https://avatars-next.observableusercontent.com/a2c84c4bc1caecd3bff67953320715d40334a3b7d62c50d93f5f294a0c4152d4","tier":null,"role":"editor"}],"comments":[{"id":"94d5f0b45aa5d648","reply_to_id":null,"content":"Good analysis, well done!","create_time":"$D2023-04-18T23:42:39.070Z","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}}],"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":23,"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":30,"value":"## Reference data:
Pizza orders from Jan, 2022 to Jan, 2023","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":71,"value":"viewof pizzas = Inputs.table(pizzaorders)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":744,"value":"Inputs.table(totalCostByState)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":442,"value":"## Explore 1\nPeople in CA looks spend much more than people in NV for pizzas.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":373,"value":"### Facts: \n- Population of NV in 2022: [3177772](https://www.macrotrends.net/states/nevada/population)\n- Population of CA in 2022: [39029342](https://www.macrotrends.net/states/california/population)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":395,"value":"// summary total cost by state\ntotalCostByState = tidy(\n pizzaorders,\n groupBy(\n \"state\",\n summarize({ totalCost: sum(\"total\") })\n )\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":398,"value":"// CA\ncostPPCA = 14520984 / 39029342","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":407,"value":"// NV\ncostPPNV = 5128627 / 3177772","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":419,"value":"// cost per person\ncostPP = [\n { state: \"CA\", population: 39029342, totalCost: 14520984 },\n { state: \"NV\", population: 3177772, totalCost: 5128627 }\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":378,"value":"// total cost per person for the whole year\nPlot.plot({\n color: {\n legend: true\n },\n x:{label:\"state\"},\n y: {\n grid: true, label: \"Cost per person\", labelAnchor: \"center\"\n },\n marks: [\n Plot.barY(\n costPP,\n {\n x: \"state\",\n y: (d) => d.totalCost / d.population,\n fill: \"state\"\n },\n Plot.ruleY([0])\n )\n ],\n\n height: 300,\n width: 480,\n marginLeft: 60,\n marginBottom: 50\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":417,"value":"### Finding 1\nAccording to the cost per person by state, in 2022, people in Nevada spent lots more than people in California for pizzas!! This is totally different from the exploration!","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":21,"value":"
\n
\n## Explore 2","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":100,"value":"### Orders by names","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":680,"value":"viewof totalOrders = Inputs.range([0, 320], {\n label: \"Orders\",\n step: 20,\n value: 0\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":64,"value":"Plot.plot({\n x: {\n tickRotate: 60\n },\n y: {\n grid: true\n },\n marks: [\n // Plot.barY([1 / 27], { fill: \"orange\", fillOpacity: 0.4 }),\n Plot.barY(\n pizzas.filter((d) => d.state == \"CA\"),\n Plot.groupX(\n { y: \"max\" },\n {\n x: \"name\",\n y: \"orders\",\n title: \"orders\",\n fill: (d) => (d.orders >= totalOrders ? \"steelblue\" : \"lightgray\")\n }\n )\n ),\n Plot.barY(\n pizzas.filter((d) => d.state == \"NV\"),\n Plot.groupX(\n { y: \"max\" },\n {\n x: \"name\",\n y: \"orders\",\n title: \"orders\",\n fill: (d) => (d.orders >= totalOrders ? \"orange\" : \"lightgray\")\n }\n )\n )\n ],\n height: 540,\n width: 960,\n marginLeft: 40,\n marginBottom: 180\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":371,"value":"It looks that the Hawaiian, Pepperoni, and Meat Lover's are the top 3 popular pizzas.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":313,"value":"
\n### Top 7 orders","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":263,"value":"Plot.plot({\n color: {\n scheme: \"brbg\",\n },\n x: {\n tickRotate: 60,\n label: \"Top 7 orders\"\n },\n y: {\n grid: true\n },\n facet: {\n data: pizzaorders,\n x: \"state\"\n },\n marks: [\n Plot.barY(\n pizzaorders,\n Plot.groupX(\n { y: \"sum\" },\n {\n x: \"name\",\n y: \"orders\",\n title: \"y\",\n sort: { x: \"y\", reverse: true, limit: 7 },\n fill: \"name\"\n }\n )\n )\n ],\n height: 540,\n width: 960,\n marginLeft: 80,\n marginBottom: 150\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":468,"value":"It looks like people in these two states have similar tastes! And as what I noticed by last chart, the Hawaiian Pizzas has three places in top 7 orders in both states!
\nTwo interesting things, first, Meat Lover's Pizza are usually order for extra large size and small size. Second, the Hawaiian Pizzas are so popular which is quite surprised me because it's something would make Italians angry about :D
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":482,"value":"
\n### Top 7 cost products","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":162,"value":"viewof items = Inputs.table(\n pizzaorders.map((p) => {\n return {\n name: p.name,\n state: p.state,\n item: p.name.split(\" Pizza \")[0],\n total: p.total\n };\n })\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":581,"value":"Plot.plot({\n color: {\n scheme: \"brbg\",\n },\n x: {\n label: \"Product\",\n nice: true\n },\n y: {\n grid: true,\n label: \"← NV : ORDER : CA →\",\n labelAnchor: \"center\",\n tickFormat: Math.abs\n },\n marks: [\n Plot.barY(\n dailyOrders.filter((d) => d.state == \"CA\"),\n Plot.groupX(\n { y: \"sum\" },\n {\n x: (d) => d.item,\n y: (d) => d.order,\n fill: (d) => d.item,\n sort: { x: \"y\", reverse: true},\n }\n )\n ),\n Plot.barY(\n dailyOrders.filter((d) => d.state == \"NV\"),\n Plot.groupX(\n { y: \"sum\" },\n {\n x: (d) => d.item,\n y: (d) => -d.order,\n fill: (d) => d.item,\n sort: { x: \"y\", reverse: true},\n }\n )\n ),\n Plot.ruleY([0])\n ],\n width: 960,\n height: 540,\n marginBottom: 70,\n marginLeft: 90\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":478,"value":"Plot.plot({\n color: {\n scheme: \"brbg\",\n },\n x: {\n tickRotate: 60\n },\n y: {\n grid: true\n },\n facet: {\n data: pizzaorders,\n x: \"state\"\n },\n marks: [\n Plot.barY(\n items,\n Plot.groupX(\n { y: \"sum\" },\n {\n x: \"item\",\n y: \"total\",\n title: \"y\",\n sort: { x: \"y\", reverse: true, limit: 7 },\n fill: \"item\"\n }\n )\n )\n ],\n height: 540,\n width: 960,\n marginLeft: 50,\n marginBottom: 100\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":484,"value":"### Finding 2\nIt's confirmed that the Hawaiian, Meat Lover's, and Pepperoni pizzas are the top 3 popular ones. The Hawaiian looks like has the most orders, but it's not the real No.1 for making money most, the Meat Lover's is!! They are quite close, though, but they are not so close by the orders. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":256,"value":"
\n## Explore 3\n
\n### Orders by week days","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":509,"value":"Plot.plot({\n color: {\n legend: true\n },\n x:{labelAnchor: \"center\"},\n y: {\n grid: true\n },\n marks: [\n Plot.areaY(\n pizzaorders.filter((d) => d.state == \"CA\"),\n Plot.groupX(\n { y2: \"sum\" },\n {\n x: \"day_of_week\",\n y2: \"orders\",\n fill: \"state\",\n mixBlendMode: \"normal\",\n title: \"orders\"\n }\n )\n ),\n Plot.areaY(\n pizzaorders.filter((d) => d.state == \"NV\"),\n Plot.groupX(\n { y2: \"sum\" },\n {\n x: \"day_of_week\",\n y2: \"orders\",\n fill: \"state\",\n mixBlendMode: \"normal\",\n title: \"orders\"\n }\n )\n ),\n Plot.ruleY([0])\n ],\n marginLeft: 40,\n marginBottom:40\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":527,"value":"### Finding 3.1\nI think there is no big difference of orders during weekdays, but people more like to order pizzas on weekends, especially on Saturdays. The following two charts also show this fact, the orders around / above 2800 are mostly happened on Saturdays.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":43,"value":"
\n### Order by dates","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":622,"value":"viewof groupedBy = Inputs.radio([\"CA\", \"NV\"], {\n label: \"Group by\",\n value: \"CA\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":584,"value":"Plot.plot({\n color: {\n legend: true,\n scheme: \"brbg\"\n },\n x: {label: \"Time\", labelAnchor: \"center\"},\n y: {\n grid: true,\n label: \"All orders\",\n labelAnchor: \"center\"\n },\n marks: [\n Plot.dot(\n pizzaorders.filter((d) => d.state == \"CA\"),\n {\n x: \"orderDate\",\n y: \"orders\",\n fill: (d) => (groupedBy == \"CA\" ? \"CA\" : \"gray\"),\n title: (n) => n.name + \" : \" + n.orders\n }\n ),\n Plot.dot(\n pizzaorders.filter((d) => d.state == \"NV\"),\n {\n x: \"orderDate\",\n y: \"orders\",\n fill: (d) => (groupedBy == \"NV\" ? \"NV\" : \"gray\")\n }\n ),\n // Plot.line(\n // pizzaorders,\n // Plot.regression({\n // x: (d) => d.orderDate,\n // y: d => d.orders,\n // stroke: (d) => d.name,\n // label: (d) => d.name\n // })\n // ),\n Plot.ruleY([0])\n ],\n\n marginLeft: 50,\n marginBottom: 50,\n width: 960,\n height: 480\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":640,"value":"Plot.plot({\n color: {\n legend: true,\n scheme: \"brbg\"\n },\n x: {label: \"Order date\", labelAnchor: \"center\"},\n y: {\n grid: true,\n label: \"Orders\"\n },\n marks: [\n Plot.dot(\n pizzaorders.filter((d) => d.state == \"CA\"),\n Plot.groupX(\n { y: \"sum\" },\n {\n x: \"orderDate\",\n y: \"orders\",\n fill: \"state\",\n title: (t) => t.orderDate\n }\n )\n ),\n Plot.dot(\n pizzaorders.filter((d) => d.state == \"NV\"),\n Plot.groupX(\n { y: \"sum\" },\n {\n x: \"orderDate\",\n y: \"orders\",\n fill: \"state\",\n title: (t) => t.orderDate\n }\n )\n )\n ],\n\n marginLeft: 80,\n marginBottom: 50,\n width: 960,\n height: 480\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":699,"value":"### Order by flavor","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":339,"value":"viewof dailyOrders = Inputs.table(\n pizzaorders.map((p) => {\n return {\n name: p.name,\n state: p.state,\n item: p.name.split(\" Pizza \")[0],\n date: p.orderDate,\n order: p.orders,\n price: p.unit_price,\n total: p.total\n };\n })\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":701,"value":"Check all the unit prices: ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":718,"value":"viewof selectedItem = Inputs.select(\n d3.group(dailyOrders, (d) => d.item),\n { label: \"Select a pizza\" }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":662,"value":"Plot.plot({\n x: { label: \"Month\", labelAnchor: \"center\" },\n y: { label: \"Daily total\", grid: true, labelAnchor: \"center\" },\n marks: [\n Plot.lineY(\n dailyOrders,\n Plot.groupX(\n { y: \"sum\" },\n {\n x: (d) => d.date,\n y: (d) => d.total,\n z: (d) => d.item,\n stroke: \"lightgray\",\n strokeOpacity: 0.5,\n title: \"name\"\n }\n )\n ),\n Plot.lineY(\n selectedItem,\n Plot.groupX(\n { y: \"sum\" },\n {\n x: (d) => d.date,\n y: (d) => d.total,\n z: (d) => d.item,\n stroke: \"brown\",\n title: \"name\"\n }\n )\n ),\n Plot.ruleY([0])\n ],\n height: 540,\n width: 960,\n marginLeft: 80,\n marginBottom: 50\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":790,"value":"viewof searchItem = Inputs.search(dailyOrders, {\n datalist: d => d.name, \n placeholder: \"Search and filter pizza product\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":792,"value":"Plot.plot({\n marks: [\n Plot.ruleY([0]),\n Plot.lineY(searchItem, Plot.groupX({y: \"sum\"}, {x: \"date\", y: \"total\", stroke: \"item\"})),\n Plot.linearRegressionY(\n searchItem,\n Plot.groupX(\n { y: \"sum\" },\n { x: \"date\", y: \"total\", stroke: \"state\", ci: 0.95 }\n )\n ),\n ],\n color: {\n scheme: \"viridis\",\n legend: true\n },\n width: 960,\n marginLeft: 50,\n marginBottom: 30\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":801,"value":"
\n### Finding 3.2\nGrowing orders: BBQ Chicken, Meat Lover's, Oxtail, and Veggi; Margherita and Sicillian got less and less order as the time going, maybe it would be a good timing to provide new flavors\n

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":839,"value":"viewof pizzaBySize = Inputs.table(\n pizzaorders.map((p) => {\n return {\n name: p.name,\n state: p.state,\n size: p.name.split(\" Pizza \")[1],\n date: p.orderDate,\n order: p.orders,\n price: p.unit_price,\n total: p.total\n };\n })\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":844,"value":"totalBySize = tidy(\n pizzaBySize,\n groupBy('size', [\n summarize({ total: sum('total') }),\n ])\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":107,"value":"chart = PieChart(totalBySize, {\n name: d => d.size,\n value: d => d.total,\n width,\n height: 500\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":703,"value":"Plot.plot({\n marks: [\n Plot.barX(\n pizzaorders,\n Plot.groupY(\n { x: \"max\" },\n {\n y: (d) => d.name,\n x: (d) => d.unit_price,\n sort: { y: \"x\", reverse: true },\n title: \"name\",\n fill: \"name\"\n }\n )\n )\n ],\n marginLeft: 200,\n height: 600,\n width: 960\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":866,"value":"Plot.plot({\n color: {\n scheme: \"brbg\",\n },\n x: {\n label: \"Size\",\n nice: true\n },\n y: {\n grid: true,\n label: \"← Order : Total →\",\n labelAnchor: \"center\",\n tickFormat: Math.abs\n },\n marks: [\n Plot.barY(\n pizzaBySize,\n Plot.groupX(\n { y: \"sum\" },\n {\n x: \"size\",\n y: \"total\",\n fill: \"size\",\n }\n )\n ),\n Plot.barY(\n pizzaBySize,\n Plot.groupX(\n { y: \"sum\"},\n {\n x: \"size\",\n y: o => -o.order,\n fill: \"size\",\n }\n )\n ),\n Plot.ruleY([0])\n ],\n width: 600,\n height: 960,\n marginBottom: 70,\n marginLeft: 90\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":908,"value":"### Finding 3.3\nWell, medium size pizzas has the most orders, but still earn less money than large and extra large size pizzas! Especially the extra large pizzas, which had the least orders but made the most money!!! Which means, the unit price does matter!! Although it's the differences for few dollars, but if we switch the view to percentage, then everything changes!!! For example, pizzas of $15 and $25, $25 pizzas cost 66% more than $15 ones, and that's A LOT!! So, be careful of the unit prices!","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1122,"value":"

\n## Appendix","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":18,"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":127,"value":"import {\n distinct,\n filter,\n groupBy,\n map,\n mutate,\n mutateWithSummary,\n select,\n summarize,\n sum,\n tidy\n} from \"@pbeshai/tidyjs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":505,"value":"import {DonutChart} from \"@d3/donut-chart\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":348,"value":"d3 = require(\"d3@^6.1\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":740,"value":"reg = require(\"d3-regression@1\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":750,"value":"$45","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":748,"value":"Plot = addRegression(await require(\"@observablehq/plot@0.6\"))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":832,"value":"import {PieChart} from \"@d3/pie-chart\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":82,"value":"pizzaorders","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W46","stdlib":"1"}} 44:"$43:body"