2c:null 2d:["$","title",null,{"children":"2 Лабораторная работа | Никита Лысенко | Observable"}] 32:[{"id":"a0f0f9469cb01b537599e31489bba2f73f3f2ed0f2bb294b3b306b9f32789a532919d2a25dcafe2674e9d66c18cc4a714c96fcc14b08e76b4fd4bc6a2e711550","href":"https://static.observableusercontent.com/files/a0f0f9469cb01b537599e31489bba2f73f3f2ed0f2bb294b3b306b9f32789a532919d2a25dcafe2674e9d66c18cc4a714c96fcc14b08e76b4fd4bc6a2e711550","name":"sport_world.csv","type":"text/csv","lastModified":1791174516151,"size":15029}] 30:{"id":"0c7f66742f2a6d99","slug":"2-laboratornaya-rabota","title":"2 Лабораторная работа","thumbnail":"5a8e5e21e0089ed9af1b5a71ad6052f90e3503f69ca69b44b6528ca755a77f4d","access_level":"public","create_time":"$D2026-10-05T04:39:10.848Z","update_time":"$D2026-10-05T09:54:20.412Z","view_time":null,"first_public_time":"$D2026-10-05T09:47:36.030Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"c0bdafe769f7c00d","login":"nikitalysenko","name":"Никита Лысенко","avatar_url":"https://avatars-next.observableusercontent.com/80bcafefb8d04b01cb0e4b6e492aeea97529fe8bb9028ce5df163b553a9be83b","tier":"free_2026"},"version":210,"publish_version":210,"role":null,"authored":false,"authors":[{"type":"individual","id":"403e02be67b5878a","login":"nikitalysenko","name":"Никита Лысенко","avatar_url":"https://avatars-next.observableusercontent.com/80bcafefb8d04b01cb0e4b6e492aeea97529fe8bb9028ce5df163b553a9be83b","tier":null}],"members":[{"type":"team","id":"c0bdafe769f7c00d","login":"nikitalysenko","name":"Никита Лысенко","avatar_url":"https://avatars-next.observableusercontent.com/80bcafefb8d04b01cb0e4b6e492aeea97529fe8bb9028ce5df163b553a9be83b","tier":"free_2026","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"2 Лабораторная работа","cells":[{"id":1,"value":"# 2 Лабораторная работа","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":31,"value":"Вывод табличных данных","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2,"value":"data = FileAttachment(\"sport_world.csv\").csv({typed: true})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3,"value":"table = Inputs.table(data)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":32,"value":"Вывод данных по выбранным полям","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"viewof sortTable = Inputs.table(data, {\n columns: [\n \"Наименование соревнования\",\n \"Сроки проведения\",\n \"Место проведения\"\n ],\n header: {\n \"Наименование соревнования\": \"Соревнование\",\n \"Сроки проведения\": \"Месяц\",\n \"Место проведения\": \"Место\"},\n sort: \"Сроки проведения\", reverse:false, required: false})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"sortTable","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":33,"value":"Вывод данных с помощью таблицы html","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"\n \n \n \n \n \n \n \n \n ${data.map(d => htl.html`\n \n \n \n `)}\n \n

Соревнование	Месяц	Место
${d[\"Наименование соревнования\"]}	${d[\"Сроки проведения\"]}	${d[\"Место проведения\"]}

","pinned":true,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":39,"value":"Вывод мест проведения соревнований и кол-ва участников в них","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":17,"value":"Plot.plot({\n marks: [\n Plot.barX(data, {x: \"Ориентировочное число участников\", y: \"Место проведения\", fill: \"#345678\", sort: {y: \"y\", reverse: true}}),\n Plot.ruleX([0, 10000]),\n ], marginLeft: 300\n\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":8,"value":"найдем соревнования в августе","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"august = data.filter((x) => \"август\" == x[\"Сроки проведения\"])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":10,"value":"viewof table_august = Inputs.table(august, {\n columns: [\n \"Наименование соревнования\",\n \"Место проведения\",\n \"Ориентировочное число участников\"\n ],\n header: {\n \"Наименование соревнования\": \"Cоревнование\",\n \"Место проведения\": \"Место\",\n \"Ориентировочное число участников\": \"Число участников\"},\n\n width: {\n \"Наименование соревнования\": 500,\n \"Место проведения\": 200,\n \"Ориентировочное число участников\": 200\n },\n align: {\n \"Наименование соревнования\": \"left\",\n \"Место проведения\": \"left\",\n \"Ориентировочное число участников\": \"center\"\n },\n maxWidth: 1000, sort: \"Ориентировочное число участников\", maxHeight: 300, reverse:false, required: false})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"# Фильтрация","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"## Текст","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":34,"value":"поиск соревнований по месяцу проведения","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":13,"value":"viewof text = Inputs.text({label: \"Месяц\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"copmetitions_by_mounth = data.filter( (x)=> String(x[\"Сроки проведения\"]).indexOf(text.trim()) > -1)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":15,"value":"viewof table_copmetitions_by_mounth = Inputs.table(copmetitions_by_mounth, {\n columns: [\n \"Наименование соревнования\",\n \"Место проведения\",\n \"Ориентировочное число участников\"\n ],\n header: {\n \"Наименование соревнования\": \"Cоревнование\",\n \"Место проведения\": \"Место\",\n \"Ориентировочное число участников\": \"Число участников\"},\n\n width: {\n \"Наименование соревнования\": 500,\n \"Место проведения\": 200,\n \"Ориентировочное число участников\": 100\n },\n align: {\n \"Наименование соревнования\": \"left\",\n \"Место проведения\": \"left\",\n \"Ориентировочное число участников\": \"center\"\n },\n maxWidth: 1000, sort: \"Ориентировочное число участников\", maxHeight: 300, reverse:false, required: false})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":16,"value":"## Select","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":35,"value":"поиск соревнований по месяцам проведения","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":19,"value":"mounths = [... new Set(data.map((x) => x[\"Сроки проведения\"]).filter((x) => x != null))]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":18,"value":"viewof selected_mounth = Inputs.select(mounths, {label: \"Выберите месяц проведения соревнования: \", multiple: true, width:150})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":20,"value":"Inputs.table(data.filter((x) => selected_mounth.includes(x[\"Сроки проведения\"])),\n{\n columns: [\n \"Наименование соревнования\",\n \"Место проведения\",\n \"Ориентировочное число участников\"\n ],\n header: {\n \"Наименование соревнования\": \"Cоревнование\",\n \"Место проведения\": \"Место\",\n \"Ориентировочное число участников\": \"Число участников\"},\n\n width: {\n \"Наименование соревнования\": 500,\n \"Место проведения\": 200,\n \"Ориентировочное число участников\": 150\n },\n align: {\n \"Наименование соревнования\": \"left\",\n \"Место проведения\": \"left\",\n \"Ориентировочное число участников\": \"center\"\n },\n maxWidth: 1000, sort: \"Ориентировочное число участников\", maxHeight: 300, reverse:false})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":22,"value":"## Range","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":36,"value":"Поиск мест проведения соревнований по количеству участников","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":37,"value":"Задание 1\nРеализация метода по поиску мин и макс значений через список плоха тем, что создается лишний массив, при большом объеме данных, данная сортировка будет крайне нагружена.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":23,"value":"min_max = d3.extent(data, d => +d[\"Ориентировочное число участников\"])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":24,"value":"viewof minA = Inputs.range([min_max[0], min_max[1]], {\n label: \"Мин. участников\",\n value: min_max[0],\n step: 10,\n width: 400\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":25,"value":"viewof maxA = Inputs.range([min_max[0], min_max[1]], {\n label: \"Макс. участников\",\n value: min_max[1],\n step: 10,\n width: 400\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":26,"value":"filtered = data.filter(d => {\n const n = +d[\"Ориентировочное число участников\"];\n return n >= minA && n <= maxA;\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":38,"value":"Задание 2","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":27,"value":"search_len = filtered.length","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":29,"value":"max_len = data.length","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":28,"value":"canvas = {\n const context = DOM.context2d(700, 50);\n context.fillStyle = \"hsl(216deg 100% 13%)\";\n context.fillRect(0, 0, search_len*(700/max_len), 50);\n context.canvas.style.background = \"hsl(216deg 25% 90%)\";\n return context.canvas;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":30,"value":"Plot.plot({\n marks: [\n Plot.barX(filtered, {x: \"Ориентировочное число участников\", y: \"Место проведения\", fill: \"#345678\", sort: {y: \"y\", reverse: true}}),\n Plot.ruleX([0, 10000]),\n ], marginLeft: 300\n\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W32","stdlib":"2"}} 31:"$30:body"