25:["$","title",null,{"children":"Работа с таблицами | Никита Сопов | Observable"}] 4b:[{"id":"a0f0f9469cb01b537599e31489bba2f73f3f2ed0f2bb294b3b306b9f32789a532919d2a25dcafe2674e9d66c18cc4a714c96fcc14b08e76b4fd4bc6a2e711550","href":"https://static.observableusercontent.com/files/a0f0f9469cb01b537599e31489bba2f73f3f2ed0f2bb294b3b306b9f32789a532919d2a25dcafe2674e9d66c18cc4a714c96fcc14b08e76b4fd4bc6a2e711550","name":"sport_world.csv","type":"text/csv","lastModified":1791720308325,"size":15029},{"id":"5652843819ee0cb301be3b4e9627c224491caf5782b1ac221bf5d1c0d703baab30360a38073caaf23b0a23df563ec662cb6f46ed2b21ed9d43db4465a264d8c8","href":"https://static.observableusercontent.com/files/5652843819ee0cb301be3b4e9627c224491caf5782b1ac221bf5d1c0d703baab30360a38073caaf23b0a23df563ec662cb6f46ed2b21ed9d43db4465a264d8c8","name":"image@1.png","type":"image/png","lastModified":1791816160730,"size":2550}] 47:{"id":"8ebf6492c1914f0d","slug":"rabota-s-tablitsami","title":"Работа с таблицами","thumbnail":"acbc2d222edf0cedcc2ba9061ee78c864a546e51594df622dca504f6489b2c7f","access_level":"public","create_time":"$D2026-09-19T07:52:48.685Z","update_time":"$D2026-10-17T06:50:40.324Z","view_time":null,"first_public_time":"$D2026-10-28T13:28:58.374Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"4d003d33bfffa7d1","login":"dfgdf","name":"Никита Сопов","avatar_url":"https://avatars-next.observableusercontent.com/cc046697ecfdf967aecf311ecc1cce926d5daf88eb10fd9ed070d6f37effa26c","tier":"free_2026","bio":"","followed_by_you":false,"follows_you":false},"version":278,"publish_version":278,"role":null,"authored":false,"authors":[{"type":"individual","id":"07b44715b40521b0","login":"dfgdf","name":"Никита Сопов","avatar_url":"https://avatars-next.observableusercontent.com/cc046697ecfdf967aecf311ecc1cce926d5daf88eb10fd9ed070d6f37effa26c","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"team","id":"4d003d33bfffa7d1","login":"dfgdf","name":"Никита Сопов","avatar_url":"https://avatars-next.observableusercontent.com/cc046697ecfdf967aecf311ecc1cce926d5daf88eb10fd9ed070d6f37effa26c","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":"Работа с таблицами","cells":[{"id":1,"value":"# Работа с таблицами","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"sport_world= FileAttachment(\"sport_world.csv\").csv({typed: true})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"viewof table = Inputs.table(sport_world)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"Object.keys(sport_world[0])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"viewof table1 = Inputs.table(sport_world, {\n columns: [\n \"Наименование соревнования\",\n \"Сроки проведения\",\n \"Место проведения\",\n \"Ориентировочное число участников\"\n ],\n header: {\n \"Наименование соревнования\": \"Соревнование\",\n \"Сроки проведения\": \"Месяц\",\n \"Место проведения\": \"Город\",\n \"Ориентировочное число участников\": \"Участников\"\n },\n sort: \"Ориентировочное число участников\",\n reverse: true,\n required: false\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"Можно использовать выбранные строки таблицы для построения других таблиц, диаграмм, графиков и т.д. (т.е. работать как с подмножеством данных).\n\nВыберите несколько строк, чтобы посмотреть пример работы с подмножеством данных.\n\nНазвание подмножества: имя объекта viewof. В нашем примере это: table1.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"table1","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":35,"value":"html`\n \n \n \n \n \n \n \n \n \n \n ${sport_world.map(d => html`\n \n \n \n \n \n `)}\n \n

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

`","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"Plot.plot({\n marks: [\n Plot.barX(table, {\n x: \"Ориентировочное число участников\",\n y: \"Наименование соревнования\",\n fill: \"#345678\",\n sort: { x: \"x\", reverse: true }\n }),\n Plot.ruleY([0]),\n Plot.ruleX([0, 1500]),\n ],\n marginLeft: 300\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":13,"value":"Можно управлять шириной столбцов (width): с помощью параметра ширины в пикселях.\nПараметр align (выравнивание) позволяет изменить выравнивание текста ячеек: справа, слева, по центру (по умолчанию он справа для числовых столбцов и слева для всего остального).\nПараметр rows (строки) указывает количество отображаемых строк (по умолчанию 11).\nПараметры: maxWidth, height и maxHeight соответственно задают максимальную ширину, высоту и максимальную высоту таблицы в пикселях.\nПараметр: required - показывает, какие данные будут возвращены в качестве результата. Если этот параметр: true, значит результатом будет вся таблица, если - false, то результатом будут только выбранные строки.\nПараметр: multiple - устанавливает возможность выбора нескольких строк (по умолчанию: true).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":15,"value":"{var a = sport_world.filter(x => x[\"Ориентировочное число участников\"] > 1000);\n return `Количество крупных соревнований ${a.length}, всего соревнований ${sport_world.length}`;}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":16,"value":"# Фильтрация по диапазону значений","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":17,"value":"### Инструменты формы для ввода/вывода данных\nИнструмент Text: Inputs.text(options)\n\n![image@1.png](${await FileAttachment(\"image@1.png\").url()})","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":18,"value":"viewof text = Inputs.text({label: \"Наименование соревнования\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":19,"value":"sport_world_by_search = sport_world.filter(x =>\n String(x[\"Наименование соревнования\"]).toLowerCase().includes(text.toLowerCase().trim())\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":23,"value":"view(Inputs.table(sport_world_by_search, {\n columns: [\n \"Наименование соревнования\",\n \"Сроки проведения\",\n \"Место проведения\",\n \"Ориентировочное число участников\"\n ],\n header: {\n \"Наименование соревнования\": \"Соревнование\",\n \"Сроки проведения\": \"Месяц\",\n \"Место проведения\": \"Город\",\n \"Ориентировочное число участников\": \"Участников\"\n }\n}))","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":24,"value":"Инструмент Select: Inputs.select(options)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":25,"value":"competitions = sport_world\n .map(d => d[\"Место проведения\"])\n .filter((v, i, a) => a.indexOf(v) === i)\n .sort()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":26,"value":"viewof select = Inputs.select(competitions, {label: \"Укажите место:\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":27,"value":"sport_world_short = sport_world.filter(d => d[\"Место проведения\"] === select)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":28,"value":"view(Inputs.table(sport_world_short, {\n columns: [\n \"Наименование соревнования\",\n \"Сроки проведения\",\n \"Место проведения\",\n \"Ориентировочное число участников\"\n ],\n header: {\n \"Наименование соревнования\": \"Соревнование\",\n \"Сроки проведения\": \"Месяц\",\n \"Место проведения\": \"Город\",\n \"Ориентировочное число участников\": \"Участников\"\n },\n sort: \"Ориентировочное число участников\",\n reverse: true\n}))","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":29,"value":"Инструмент Range: Inputs.range(options)","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":30,"value":"viewof select_mult = Inputs.select(competitions, {label: \"Укажите места:\", multiple: true, width: 300})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":31,"value":"sport_world_multi = sport_world.filter(d => select_mult.includes(d[\"Место проведения\"]))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":32,"value":"view(Inputs.table(sport_world_multi, {\n columns: [\n \"Наименование соревнования\",\n \"Сроки проведения\",\n \"Место проведения\",\n \"Ориентировочное число участников\"\n ],\n header: {\n \"Наименование соревнования\": \"Соревнование\",\n \"Сроки проведения\": \"Месяц\",\n \"Место проведения\": \"Город\",\n \"Ориентировочное число участников\": \"Участников\"\n },\n sort: \"Ориентировочное число участников\",\n reverse: true\n}))","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":33,"value":"Plot.plot({\n marks: [\n Plot.barX(sport_world_multi, {\n x: \"Ориентировочное число участников\",\n y: \"Наименование соревнования\",\n fill: \"#345678\",\n sort: { y: \"x\", reverse: true }\n }),\n Plot.ruleX([0])\n ],\n marginLeft: 300\n})","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":34,"value":"!!!! Задание Придумать другой способ без построения массива (Этот способ плохой! Почему?)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":36,"value":"viewof range_A = Inputs.range(\n [\n d3.min(sport_world, d => d[\"Ориентировочное число участников\"]),\n d3.max(sport_world, d => d[\"Ориентировочное число участников\"])\n ],\n {\n label: \"участников от:\",\n value: d3.min(sport_world, d => d[\"Ориентировочное число участников\"]),\n step: 10,\n width: 400\n }\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":45,"value":"range_B = Inputs.range(\n [\n d3.min(sport_world, d => d[\"Ориентировочное число участников\"]),\n d3.max(sport_world, d => d[\"Ориентировочное число участников\"])\n ],\n {\n label: \"участников до:\",\n value: d3.max(sport_world, d => d[\"Ориентировочное число участников\"]),\n step: 10,\n width: 400\n }\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":57,"value":"Способ с построением массива затратный, что бы найти минимум и максимум создаётся новый \"промежуточный\" массив, а затем он сортируется","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":37,"value":"!!!!! Задание Показать с помощью bar-объекта (canvas) количество субъектов, удовлетворяющих условию (Соревнования по интералу количество участников)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":38,"value":"max_count_sport = sport_world.length\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":39,"value":"width = 700\n\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":40,"value":"height = 50","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":52,"value":"viewof min_part = Inputs.range(\n [0, d3.max(sport_world, d => +d[\"Ориентировочное число участников\"])],\n {\n label: \"участников от:\",\n value: 0,\n step: 10,\n width: 400\n }\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":47,"value":"viewof max_part = Inputs.range(\n [0, d3.max(sport_world, d => +d[\"Ориентировочное число участников\"])],\n {\n label: \"участников до:\",\n value: d3.max(sport_world, d => +d[\"Ориентировочное число участников\"]),\n step: 10,\n width: 400\n }\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":56,"value":"Inputs.table(\n sport_world.filter(d => {\n const val = +d[\"Ориентировочное число участников\"];\n return val >= min_part && val <= max_part;\n }),\n {\n columns: [\n \"Наименование соревнования\",\n \"Сроки проведения\",\n \"Место проведения\",\n \"Ориентировочное число участников\"\n ],\n header: {\n \"Наименование соревнования\": \"Соревнование\",\n \"Ориентировочное число участников\": \"Участников\"\n },\n width: {\n \"Наименование соревнования\": 250,\n \"Ориентировочное число участников\": 100\n },\n sort: \"Ориентировочное число участников\",\n reverse: true\n }\n)","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":48,"value":"canvas = {\n const count = sport_world.reduce((acc, d) => {\n const val = +d[\"Ориентировочное число участников\"];\n if (val >= min_part && val <= max_part) {\n return acc + 1;\n }\n return acc;\n }, 0);\n const context = DOM.context2d(width, height);\n context.fillStyle = \"hsl(216deg 25% 90%)\";\n context.fillRect(0, 0, width, height);\n context.fillStyle = \"hsl(216deg 100% 13%)\";\n const barWidth = (count / max_count_sport) * width;\n context.fillRect(0, 0, barWidth, height);\n return context.canvas;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":50,"value":"Plot.plot({\n width: 800,\n height: 300,\n marginLeft: 60,\n marginBottom: 40,\n x: {\n ticks: null\n },\n y: {\n grid: true,\n label: \"Участников\"\n },\n marks: [\n Plot.barY(\n sport_world.filter(d => {\n const val = +d[\"Ориентировочное число участников\"];\n return val >= min_part && val <= max_part;\n }),\n {\n x: \"Наименование соревнования\",\n y: \"Ориентировочное число участников\",\n fill: \"#345678\",\n sort: { x: \"y\", reverse: true }\n }\n ),\n Plot.ruleY([0])\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4b","stdlib":"2"}} 24:null