28:null 29:["$","title",null,{"children":"Лабораторная работа №2 | qellex | Observable"}] 2f:[{"id":"87c96bf4213f6b57f90ba0305066169d5a84b464fc01a0c864fc5af24622dd024ef95bc296a9da445b6772b9aa5dab8b26b1e0a5c54afbe3e5f6fddccdf90677","href":"https://static.observableusercontent.com/files/87c96bf4213f6b57f90ba0305066169d5a84b464fc01a0c864fc5af24622dd024ef95bc296a9da445b6772b9aa5dab8b26b1e0a5c54afbe3e5f6fddccdf90677","name":"data.csv","type":"text/csv","lastModified":1725871529186.441,"size":1475504}] 2c:{"id":"aef2743559c463ee","slug":null,"title":"Лабораторная работа №2","thumbnail":"49e3b8e7b5c25c76853ac31b4ed41e895e2facb91573182f4e68e995d0ccb899","access_level":"public","create_time":"$D2024-09-09T08:45:29.186Z","update_time":"$D2024-12-23T03:13:58.774Z","view_time":null,"first_public_time":"$D2024-09-09T08:45:29.186Z","fork":{"id":"4ed3240395dd7cbf","slug":null,"title":"Лабораторная работа №1","owner":{"id":"397eb612fd309cf3","login":"qellex","name":"qellex"}},"stars":1,"starred":false,"owner":{"type":"team","id":"397eb612fd309cf3","login":"qellex","name":"qellex","avatar_url":"https://avatars-next.observableusercontent.com/edb4c7906570b191c0aab1bff629a48e075858b53a856a047a145d6012fd6621","tier":"starter_2024"},"version":344,"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":"Лабораторная работа №2","cells":[{"id":0,"value":"# Лабораторная работа №2","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":184,"value":"Смотрим сколько каких машин, с каким приводом.\n","pinned":false,"hidden":false,"mode":"md"},{"id":237,"value":"privod_1 = cars.filter((value, index, self) =>\n index === self.findIndex((t) => (\n t[\"Driven_Wheels\"] === value[\"Driven_Wheels\"]\n ))\n);","pinned":true,"hidden":false,"mode":"ojs"},{"id":249,"value":"privod = privod_1.map(d=>d[\"Driven_Wheels\"]);","pinned":true,"hidden":false,"mode":"ojs"},{"id":228,"value":"viewof select = Inputs.select(privod, {label: \"Driven_Wheels:\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":292,"value":"privod12 = cars.filter( (x)=> String(x[\"Driven_Wheels\"])==select)","pinned":true,"hidden":false,"mode":"ojs"},{"id":68,"value":"Plot.plot({\n marks: [\n \n Plot.barY(privod12, Plot.groupX({y: \"count\"}, {x:\"Driven_Wheels\", fill:\"#aabfab\", sort: {y: \"x\", reverse: true}}),\n Plot.ruleX([0], {fill:\"#aaaaaa\"}))],\n \n color: { legend: true },\n marginLeft: 100,\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":186,"value":"Смотрим, в каком кузове выпускались машины.\n","pinned":false,"hidden":false,"mode":"md"},{"id":220,"value":"// Создаем объект для подсчета количества каждого типа кузова\nvehicleCounts = cars.reduce((acc, car) => {\n const style = car[\"Vehicle Style\"];\n if (acc[style]) {\n acc[style]++;\n } else {\n acc[style] = 1;\n }\n return acc;\n}, {});","pinned":false,"hidden":false,"mode":"ojs"},{"id":212,"value":"uniqueCars = Object.keys(vehicleCounts).map(style => ({\n \"Vehicle Style\": style,\n \"Count\": vehicleCounts[style]/3\n}));","pinned":true,"hidden":false,"mode":"ojs"},{"id":201,"value":"viewof table1 = Inputs.table(uniqueCars, {\n columns: [\"Vehicle Style\", \"Count\"],\n header: { \n \"Vehicle Style\": \"Модель кузова\",\n \"Count\": \"Количество\"\n }\n});","pinned":true,"hidden":false,"mode":"ojs"},{"id":74,"value":"Plot.plot({\n marks: [\n \n Plot.barX(table1, {y:\"Vehicle Style\", x: \"Count\", fill:\"#aabfab\", sort: {y: \"x\", reverse: true}},\n Plot.ruleX([0], {fill:\"#aaaaaa\"}))],\n \n color: { legend: true },\n marginLeft: 150,\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":272,"value":"viewof text = Inputs.text({label: \"Марка\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":282,"value":"cars_search = cars.filter( (x)=> String(x[\"Make\"]).indexOf(text.trim()) > -1)","pinned":true,"hidden":false,"mode":"ojs"},{"id":284,"value":"Inputs.table(cars_search, \n {\n columns: [\n \"Make\",\n \"Model\",\n ],\n header: { \n \"Make\": \"Марка\",\n \"Model\": \"Модель\"\n },\n width: {\n \"Марка\": 250,\n \"Модель\": 250,\n },\n sort: \"Модель\", maxHeight: 150, maxWidth: 550, reverse:true})","pinned":true,"hidden":false,"mode":"ojs"},{"id":298,"value":"viewof range_A = Inputs.range(\n [\n d3.min(cars, (d) => d[\"Year\"]),\n d3.max(cars, (d) => d[\"Year\"])\n ],\n { \n label: \"Цена от:\",\n value: d3.min(cars, (d) => d[\"Year\"]),\n step: 1\n }\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":301,"value":"viewof range_B = Inputs.range(\n [range_A, d3.max(cars, (d) => d[\"Year\"])],\n {\n label: \"до:\",\n value: d3.max(cars, (d) => d[\"Year\"]),\n step: 1\n }\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":310,"value":"count = cars.filter(\n (x) =>\n x[\"Year\"] >= range_A &&\n x[\"Year\"] <= range_B\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":313,"value":"canvas = {\n const context = DOM.context2d(700, 50);\n context.fillStyle = \"hsl(216deg 100% 13%)\";\n context.fillRect(0, 0, count.length * (700 / cars.length), 50);\n context.canvas.style.background = \"hsl(216deg 25% 90%)\";\n return context.canvas;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":316,"value":"Inputs.table(\n cars.filter(\n (x) =>\n x[\"Year\"] >= range_A &&\n x[\"Year\"] <= range_B\n ),\n {\n columns: [\n \"Make\",\n \"Model\",\n \"Year\"\n ],\n width: {\n \"Make\": 50,\n \"Model\": 50,\n \"Year\": 20\n },\n sort: \"Year\",\n reverse: true\n }\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":321,"value":"Plot.plot({\n marks: [ \n Plot.barY(cars.filter(\n (x) =>\n x[\"Year\"] >= range_A &&\n x[\"Year\"] <= range_B\n ), Plot.groupX({y: \"count\"}, {x:\"Driven_Wheels\", fill:\"#aabfab\", sort: {y: \"x\", reverse: true}}),\n Plot.ruleX([0], {fill:\"#aaaaaa\"}))\n ],\n marginLeft: 100,\n width: 2000,\n height: 1000\n})","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W2f","stdlib":"1","titling":"auto"}} 2d:"$2c:body"