31:[{"id":"8b90027dd0dde5a4675bc268f1913bf068c15e98f69928f5e3b023b9f69fdd66a8c949358c6949d96065f492183b91a8045a53b7aae295d067dea731b102131f","href":"https://static.observableusercontent.com/files/8b90027dd0dde5a4675bc268f1913bf068c15e98f69928f5e3b023b9f69fdd66a8c949358c6949d96065f492183b91a8045a53b7aae295d067dea731b102131f","name":"just-eat All Cities.csv","type":"text/csv","lastModified":1688389838340.945,"size":19720724},{"id":"c2e5ecb9e989c6e6840f304f72071476eca07ef80fec6ea7ebc3718929e800184bd5fb4c04f1b64e6e04a3cdfd94ab5e4e8a5be0a394083cd6829f774959b692","href":"https://static.observableusercontent.com/files/c2e5ecb9e989c6e6840f304f72071476eca07ef80fec6ea7ebc3718929e800184bd5fb4c04f1b64e6e04a3cdfd94ab5e4e8a5be0a394083cd6829f774959b692","name":"just-eat All Cities manual overwrite.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1689156456125.704,"size":8913035},{"id":"09bab3c5b3bfc59ddb9863a9d6ad1b8afdce58c5944aec39ac096fddf519084f5688031cb954ec626cf978258a06d9d8cb74fa2d4e9974ccaf79ddecb91d891d","href":"https://static.observableusercontent.com/files/09bab3c5b3bfc59ddb9863a9d6ad1b8afdce58c5944aec39ac096fddf519084f5688031cb954ec626cf978258a06d9d8cb74fa2d4e9974ccaf79ddecb91d891d","name":"just-eat classified.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1690203347310.89,"size":6900108},{"id":"6781d30e11b147141a25e915679f54d5fed0105eeeb8b57cc6b2d8f4530cfcf5ba9ee21ccaa96f1d4156b6fd0f7f1842c9f490e537d20db2c21469258b01652b","href":"https://static.observableusercontent.com/files/6781d30e11b147141a25e915679f54d5fed0105eeeb8b57cc6b2d8f4530cfcf5ba9ee21ccaa96f1d4156b6fd0f7f1842c9f490e537d20db2c21469258b01652b","name":"just-eat classified with cities.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1690203665155.349,"size":8878780},{"id":"6f8ecc69c98aa088d15c4fef320614a4f6a44578b6cc3db79b509c4192ff9a06929d613e8bc9f857b7b2517c259aef8e53c98973fda4b86aa0039ba84e339692","href":"https://static.observableusercontent.com/files/6f8ecc69c98aa088d15c4fef320614a4f6a44578b6cc3db79b509c4192ff9a06929d613e8bc9f857b7b2517c259aef8e53c98973fda4b86aa0039ba84e339692","name":"leaf_small.png","type":"image/png","lastModified":1690205784770.848,"size":3259},{"id":"4a0cb1624810bacbc90246e29b3335c8a751db267f48752948cbcffdce2f19463e7fbbcc7115d5b98269ad32f4613d3939af31a68bf1b94c0a17563b840da856","href":"https://static.observableusercontent.com/files/4a0cb1624810bacbc90246e29b3335c8a751db267f48752948cbcffdce2f19463e7fbbcc7115d5b98269ad32f4613d3939af31a68bf1b94c0a17563b840da856","name":"just-eat classified with cities@1.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1690380121601.308,"size":8887096},{"id":"229d076cdbf1828f68eb02dfd6c4bce9d23b781ca1daf06f266a226051f1a59f07c266fdbecec6eda6ec9d3618bfc880e7ea45b367dab2c1567e82a0e5fcb6f1","href":"https://static.observableusercontent.com/files/229d076cdbf1828f68eb02dfd6c4bce9d23b781ca1daf06f266a226051f1a59f07c266fdbecec6eda6ec9d3618bfc880e7ea45b367dab2c1567e82a0e5fcb6f1","name":"just-eat classified with cities@2.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1690380408574.986,"size":8887344},{"id":"49d2dc4024a499f388c5bffcd029cfd04d6180211af47a7bf3c2a9590f6cd095274f7ba69ba4aba09138a5b9f8367576494b6ea17c6c7491e072de7ec00529b3","href":"https://static.observableusercontent.com/files/49d2dc4024a499f388c5bffcd029cfd04d6180211af47a7bf3c2a9590f6cd095274f7ba69ba4aba09138a5b9f8367576494b6ea17c6c7491e072de7ec00529b3","name":"just-eat classified with cities@3.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1690386457219.497,"size":8888229},{"id":"f3906cfcd59f8cbb04607c30f007dd4f146b272b5dcbd86b4db341dc1a2bb9fc99dcc623349afbb4f2548d71fd89c8ac2040a5a6c927ff32c8d17810874d5576","href":"https://static.observableusercontent.com/files/f3906cfcd59f8cbb04607c30f007dd4f146b272b5dcbd86b4db341dc1a2bb9fc99dcc623349afbb4f2548d71fd89c8ac2040a5a6c927ff32c8d17810874d5576","name":"just-eat classified with cities@4.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1690448885653.115,"size":8892250},{"id":"4f81ed1aa87013b5ac6e71b99ceae9a204ad4e8f73346a25293d95a63a9f75ba5ef6e926364e7564534d1c49f463a69d73c45ba690a0fc60de8649b128542395","href":"https://static.observableusercontent.com/files/4f81ed1aa87013b5ac6e71b99ceae9a204ad4e8f73346a25293d95a63a9f75ba5ef6e926364e7564534d1c49f463a69d73c45ba690a0fc60de8649b128542395","name":"just-eat classified with cities@5.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1690454349094.072,"size":8893079}] 2f:{"title":"Vegi-Rating der Restaurants","cells":[{"id":4,"value":"# Vegi-Rating der Restaurants","pinned":false,"hidden":false,"mode":"md"},{"id":266,"value":"Daten zur Beobachter-Auswertung über just-eat.ch, erhoben im Juli 2023. Weiterverwendung nur mit Genehmigung des Autors.","pinned":false,"hidden":false,"mode":"md"},{"id":6,"value":"viewof city = Inputs.select(cities, { label: \"City:\", width: 200 })","pinned":false,"hidden":false,"mode":"ojs"},{"id":61,"value":"viewof name = Inputs.select(cityRestaurants, {\n label: \"Restaurant:\",\n width: 400\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":119,"value":"","pinned":false,"hidden":false,"mode":"html"},{"id":203,"value":"### Rating","pinned":false,"hidden":false,"mode":"md"},{"id":194,"value":"{\n let data = restaurantData.filter((d) =>\n [\"Hauptgang\", \"Vorspeise\"].includes(d.type)\n );\n\n let nTotal = data.length;\n let nMeat = data.filter((d) => d.class == \"meat\").length;\n let nVegi = nTotal - nMeat;\n let pVegi = nVegi / nTotal;\n\n let rating = Math.ceil(pVegi * 5);\n\n let ratingHTML = \"\";\n\n for (let i = 0; i < rating; i++) {\n ratingHTML += '

';\n }\n\n return html`

${ratingHTML}
${nVegi} von ${nTotal} Gerichten (${Math.round(\n pVegi * 100\n )}%) sind vegetarisch.

`;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":79,"value":"### Vorspeisen","pinned":false,"hidden":false,"mode":"md"},{"id":49,"value":"viewof tableStarter = Inputs.table(\n restaurantData\n .filter((d) => d.type == \"Vorspeise\")\n .sort((a, b) => a.course > b.course),\n {\n columns: [\n \"course\",\n \"dish\",\n \"description\",\n \"choice\",\n \"price\",\n \"class\",\n \"classBy\"\n ],\n rows: 50,\n width: {\n course: 100,\n dish: 200,\n description: 250,\n choice: 300,\n price: 40,\n class: 50,\n classBy: 80\n },\n multiple: false,\n format: {\n class: (x) => colorClass(x)\n }\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":133,"value":"{\n let dishDetail = `

`;\n\n if (tableStarter != null) {\n dishDetail += `${tableStarter.course}: ${tableStarter.dish} (${\n tableStarter.price\n } Fr.)
\n ${tableStarter.description ? tableStarter.description + \"
\" : \"\"}\n ${tableStarter.choice ? tableStarter.choice + \"
\" : \"\"}\n classified as ${tableStarter.class} by ${\n tableStarter.classBy\n }
\n `;\n }\n\n dishDetail += `

`;\n dishDetail = html`${dishDetail}`;\n\n return dishDetail;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":101,"value":"### Hauptgänge","pinned":false,"hidden":false,"mode":"md"},{"id":98,"value":"viewof tableMain = Inputs.table(\n restaurantData\n .filter((d) => d.type == \"Hauptgang\")\n .sort((a, b) => a.course > b.course),\n {\n columns: [\n \"course\",\n \"dish\",\n \"description\",\n \"choice\",\n \"price\",\n \"class\",\n \"classBy\"\n ],\n rows: 100,\n width: {\n course: 100,\n dish: 200,\n description: 250,\n choice: 300,\n price: 40,\n class: 50,\n classBy: 80\n },\n multiple: false,\n format: {\n class: x => colorClass(x)\n }\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":164,"value":"{\n let dishDetail = `

`;\n\n if (tableMain != null) {\n dishDetail += `${tableMain.course}: ${tableMain.dish} (${\n tableMain.price\n } Fr.)
\n ${tableMain.description ? tableMain.description + \"
\" : \"\"}\n ${tableMain.choice ? tableMain.choice + \"
\" : \"\"}\n classified as ${tableMain.class} by ${tableMain.classBy}
\n `;\n }\n\n dishDetail += `

`;\n dishDetail = html`${dishDetail}`;\n\n return dishDetail;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":77,"value":"## Appendix","pinned":false,"hidden":false,"mode":"md"},{"id":66,"value":"restaurantData = cityData.filter((d) => d.name == name)","pinned":false,"hidden":false,"mode":"ojs"},{"id":58,"value":"cityRestaurants = d3.sort(new Set(cityData.map((d) => d.name)))","pinned":false,"hidden":false,"mode":"ojs"},{"id":46,"value":"cityData = data\n .filter((d) => d.city == city)\n .map((d) => ({\n name: d[\"restaurant-name\"],\n course: d[\"course-name\"],\n dish: d[\"dish-name\"],\n description: d[\"dish-description\"],\n choice: d[\"dish-extrachoice\"],\n price: d[\"dish-price\"],\n type: d[\"course-type\"],\n typeBy: d[\"course-type-by\"],\n class: d[\"dish-class\"],\n classBy: d[\"dish-class-by\"]\n }))","pinned":false,"hidden":false,"mode":"ojs"},{"id":39,"value":"cities = d3.sort(new Set(data.map((d) => d.city)))","pinned":false,"hidden":false,"mode":"ojs"},{"id":105,"value":"datasheet = FileAttachment(\"just-eat classified with cities@5.xlsx\").xlsx()","pinned":false,"hidden":false,"mode":"ojs"},{"id":111,"value":"data = datasheet.sheet(0, { headers: true })","pinned":false,"hidden":false,"mode":"ojs"},{"id":144,"value":"","pinned":false,"hidden":false,"mode":"html"},{"id":212,"value":"leaf_small = FileAttachment(\"leaf_small.png\").url()","pinned":true,"hidden":false,"mode":"ojs"},{"id":231,"value":"vegiScale = d3\n .scaleOrdinal()\n .domain([\"meat\", \"vegi\", \"both vegi\", \"vegan\", \"both vegan\"])\n .range([\"#858585\", \"#0066ff\", \"#33ccff\", \"#2d872c\", \"#a3de30\"])","pinned":false,"hidden":false,"mode":"ojs"},{"id":237,"value":"function colorClass(x) {\n let color = vegiScale(x);\n\n return htl.html`${x}`;\n}","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}