28:null 29:["$","title",null,{"children":"Лабораторная работа №3 | qellex | Observable"}] 2f:[{"id":"87c96bf4213f6b57f90ba0305066169d5a84b464fc01a0c864fc5af24622dd024ef95bc296a9da445b6772b9aa5dab8b26b1e0a5c54afbe3e5f6fddccdf90677","href":"https://static.observableusercontent.com/files/87c96bf4213f6b57f90ba0305066169d5a84b464fc01a0c864fc5af24622dd024ef95bc296a9da445b6772b9aa5dab8b26b1e0a5c54afbe3e5f6fddccdf90677","name":"data.csv","type":"text/csv","lastModified":1729654107395.435,"size":1475504},{"id":"5c91bafd8f7707727d45e78448ceffe839689efaa2f4a4c8b001551b0b7298fa7e2b0b329d3e968c758c1e5f409a97e91b1aff5ac8f91f63573b1187e85d302b","href":"https://static.observableusercontent.com/files/5c91bafd8f7707727d45e78448ceffe839689efaa2f4a4c8b001551b0b7298fa7e2b0b329d3e968c758c1e5f409a97e91b1aff5ac8f91f63573b1187e85d302b","name":"comp_new.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1729662521066.64,"size":16545}] 2c:{"id":"4858278ef7feea14","slug":null,"title":"Лабораторная работа №3","thumbnail":"49e3b8e7b5c25c76853ac31b4ed41e895e2facb91573182f4e68e995d0ccb899","access_level":"public","create_time":"$D2024-10-23T03:28:27.395Z","update_time":"$D2024-10-23T06:13:00.842Z","view_time":null,"first_public_time":"$D2024-10-23T03:28:27.395Z","fork":{"id":"aef2743559c463ee","slug":null,"title":"Лабораторная работа №2","owner":{"id":"397eb612fd309cf3","login":"qellex","name":"qellex"}},"stars":0,"starred":false,"owner":{"type":"team","id":"397eb612fd309cf3","login":"qellex","name":"qellex","avatar_url":"https://avatars-next.observableusercontent.com/edb4c7906570b191c0aab1bff629a48e075858b53a856a047a145d6012fd6621","tier":"starter_2024"},"version":556,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"ab2fef5eab69b2ad","login":"qellex","name":"qellex","avatar_url":"https://avatars-next.observableusercontent.com/86772708464dfcd84dc190250dc431b74bcf60adfa6f283f1cd658fb4aac545e","tier":null}],"members":[{"type":"team","id":"397eb612fd309cf3","login":"qellex","name":"qellex","avatar_url":"https://avatars-next.observableusercontent.com/edb4c7906570b191c0aab1bff629a48e075858b53a856a047a145d6012fd6621","tier":"starter_2024","role":"editor"},{"type":"individual","id":"ab2fef5eab69b2ad","login":"qellex","name":"qellex","avatar_url":"https://avatars-next.observableusercontent.com/86772708464dfcd84dc190250dc431b74bcf60adfa6f283f1cd658fb4aac545e","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"title":"Лабораторная работа №3","cells":[{"id":0,"value":"# Лабораторная работа №3","pinned":false,"hidden":false,"mode":"md"},{"id":18,"value":"Первоисточник: https://www.kaggle.com/datasets/rupindersinghrana/car-features-and-prices-dataset/data?select=data.csv","pinned":false,"hidden":false,"mode":"md"},{"id":41,"value":"Make: Марка
\nModel: Модель
\nYear: Год
\nEngine Fuel Type: Тип топлива двигателя
\nEngine HP: Мощность двигателя л.с.
\nEngine Cylinders: Цилиндры двигателя
\nTransmission Type: Тип трансмиссии
\nDriven_Wheels: Ведущие колеса
\nNumber of Doors: Количество дверей
\nMarket Category: Категория рынка
\nVehicle Size: Размер автомобиля
\nVehicle Style: Стиль автомобиля
\nhighway MPG: Расход по шоссе
\ncity mpg: Расход по городу
\nPopularity: Популярность
\nMSRP: Рекомендованная цена
","pinned":false,"hidden":false,"mode":"md"},{"id":12,"value":"cars = FileAttachment(\"data.csv\").csv()","pinned":true,"hidden":false,"mode":"ojs"},{"id":37,"value":"select * from cars","pinned":true,"hidden":false,"mode":"sql","output":"","database":"var:cars"},{"id":47,"value":"cars.columns","pinned":true,"hidden":false,"mode":"ojs"},{"id":228,"value":"Plot.plot({\n marks: [\n \n Plot.barX(cars, Plot.groupY({x: \"count\"}, {y:\"Vehicle Style\", fill:\"#aabfab\", sort: {y: \"x\", reverse: true}}),\n Plot.ruleX([0], {fill:\"#aaaaaa\"}))],\n \n color: { legend: true },\n marginLeft: 150,\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":292,"value":"Plot.plot({\n marks: [\n Plot.barX(cars.slice(10,1000).filter(d=>d['Make']=='BMW'), {y: \"Model\", x: \"MSRP\", fill:\"Model\", sort: {x: \"x\", reverse: true}}),\n Plot.ruleX([0, 200000, 700000])\n ],\n color: { legend: true },\n marginLeft: 200\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":530,"value":"function select_t(object) {\n return object[\"Время выполнения\"].slice(0, 3);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":527,"value":"function mark(object) {\n if (\n 0 < parseInt(object[\"Время выполнения\"].slice(0, -2)) &&\n parseInt(object[\"Время выполнения\"].slice(0, -2)) <= 99\n )\n return \"быстро\";\n if (\n 99 < parseInt(object[\"Время выполнения\"].slice(0, -2)) &&\n parseInt(object[\"Время выполнения\"].slice(0, -2)) <= 200\n )\n return \"средне\";\n if (\n 200 <= parseInt(object[\"Время выполнения\"].slice(0, -2))\n )\n return \"медленно\";\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":405,"value":"---CREATE TABLE IF NOT EXISTS cars_make_min_max AS\nSELECT Make, COUNT(Make) as Makes, \n MIN(MSRP) AS minimum_price, \n MAX(MSRP) AS maximum_price\nFROM cars\nGROUP BY \n Make\norder by maximum_price desc;\n","pinned":true,"hidden":false,"mode":"sql","output":"data2","database":"var:cars"},{"id":68,"value":"Plot.rectX(data2.slice(0, 5), {x1:0, x2:\"Makes\", y1:\"minimum_price\", y2:\"maximum_price\", fill:\"Make\"}).plot\n (\n {color: { legend: true },\n margin: 50,\n width: 400,\n height: 250,\n marks: [Plot.ruleY([50000, 100000])]\n }\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":498,"value":"comp_new = FileAttachment(\"comp_new.xlsx\").xlsx()","pinned":false,"hidden":false,"mode":"ojs"},{"id":508,"value":"\ncomps = comp_new.sheet(0, { headers: true })","pinned":false,"hidden":false,"mode":"ojs"},{"id":511,"value":"comp = comps.sort((a, b) => {\n if (\n a[\"Время выполнения\"].slice(0, 3).length !==\n b[\"Время выполнения\"].slice(0, 3).length\n ) {\n return (\n a[\"Время выполнения\"].slice(0, 3).length -\n b[\"Время выполнения\"].slice(0, 3).length\n );\n }\n return a[\"Время выполнения\"]\n .slice(0, 3)\n .localeCompare(b[\"Время выполнения\"].slice(0, 3));\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":489,"value":"Plot.plot({\n width: 1200,\n height: 300,\n marks: [\n Plot.areaY(comp.slice(30,40), {\n x: \"Время выполнения\",\n y: \"Баллы\",\n curve: \"linear\",\n fill: \"#88bbbb\"\n }),\n Plot.lineY(comp.slice(30,40), {\n x: \"Время выполнения\",\n y: \"Баллы\",\n curve: \"linear\",\n strokeWidth: 10\n }),\n Plot.ruleY([0])\n ]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":522,"value":"Plot.plot({\n width: 1500,\n height: 750,\n grid: true,\n y: {\n domain: [0, 3.1],\n ticks: 10\n },\n facet: {\n data: comp,\n y: (d) => mark(d),\n margin: 50\n },\n marks: [\n Plot.areaY(comp, {\n x: (d) => select_t(d),\n y: \"Баллы\",\n curve: \"linear\",\n fill: \"#88bbbb\"\n }),\n Plot.ruleY([0, 1, 2, 3]),\n Plot.frame()\n ],\n marginRight: 100\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":554,"value":"Plot.plot({\n marks: [\n Plot.cell(comp, {\n x: (d) => d[\"Время отправки\"].getDate(),\n fill: \"Баллы\"\n })\n ],\n color: { legend: true, range: [\"yellow\", \"brown\"] }\n})","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W2f","stdlib":"1","titling":"auto"}} 2d:"$2c:body"