40:null 41:["$","title",null,{"children":"Практическая работа №2 | Dm Dm's Workspace | Observable"}] 47:[{"id":"ce12fd7933973e0a17e13c7142b3e3d9b299fc3be477cd3e82053021c63a7161db8ebe58c4a2478eb0760c74a35b481cbdc48a7df2d1a40675eaa685c6779c5a","href":"https://static.observableusercontent.com/files/ce12fd7933973e0a17e13c7142b3e3d9b299fc3be477cd3e82053021c63a7161db8ebe58c4a2478eb0760c74a35b481cbdc48a7df2d1a40675eaa685c6779c5a","name":"sport_world.csv","type":"text/csv","lastModified":1696868915088.909,"size":15029}] 45:{"id":"dcdd7262d8ba4284","slug":null,"title":"Практическая работа №2","thumbnail":"ecb5ce4ed5898e98dd45b8cde1c2fadf274a5909ab81e172214705f3f3dc92c6","access_level":"public","create_time":"$D2023-10-09T16:27:49.366Z","update_time":"$D2023-10-15T15:11:07.852Z","view_time":null,"first_public_time":"$D2023-10-13T07:22:17.002Z","has_unpublished_edits":null,"fork":{"id":"ee9e4fb45c009de1","slug":"search-table","title":"Search + Table","owner":{"id":"f35c755083683fe5","login":"observablehq","name":"Observable"}},"stars":1,"starred":false,"owner":{"type":"team","id":"5f66419d05d68b0b","login":"dm-dm-ws","name":"Dm Dm's Workspace","avatar_url":"https://avatars-next.observableusercontent.com/f1dddf80f7adf600a449d4ba25a94bea6439231bd3e332811860c8fa5a5362fa","tier":"starter_2024","bio":"","following":false},"version":469,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"165b111f314153b1","login":"dm-dm","name":"Dm Dm","avatar_url":"https://avatars-next.observableusercontent.com/65215c1bdba748046abc32c2f95524a29666da2cfcd0b87a11039bb3cddcf9e6","tier":null,"bio":"","following":false}],"members":[{"type":"individual","id":"165b111f314153b1","login":"dm-dm","name":"Dm Dm","avatar_url":"https://avatars-next.observableusercontent.com/65215c1bdba748046abc32c2f95524a29666da2cfcd0b87a11039bb3cddcf9e6","tier":null,"role":"editor"},{"type":"team","id":"5f66419d05d68b0b","login":"dm-dm-ws","name":"Dm Dm's Workspace","avatar_url":"https://avatars-next.observableusercontent.com/f1dddf80f7adf600a449d4ba25a94bea6439231bd3e332811860c8fa5a5362fa","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Практическая работа №2","cells":[{"id":4,"value":"# Практическая работа №2\nКатаев Дмитрий Николаевич","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":5,"value":"sport_world_data = 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":6,"value":"viewof search = Inputs.search(sport_world_data)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"Inputs.table(search, {\n format: {\n Year: d3.format(\"d\") \n }\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":25,"value":"\"Всего записей о соревнованиях: \" +`${sport_world_data.length}`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":31,"value":"Вывод столбцов \"Наименование соревнования\", \"Место проведения\", \"Ориентировочное число участников\" изменили названия столбцов и порядок","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":34,"value":"viewof table1 = Inputs.table(sport_world_data, {\n columns: [\n \"Наименование соревнования\",\n \"Место проведения\",\n \"Ориентировочное число участников\"\n \n ],\n header: {\n \"Наименование соревнования\": \"Vidsport\",\n \"Место проведения\": \"Mesto\",\n \"Ориентировочное число участников\": \"Count\"\n }, \n sort: \"Ориентировочное число участников\", reverse:true, required: false})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":91,"value":"table1","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":185,"value":"\n \n \n \n \n \n \n \n \n ${table1.map(d => htl.html`\n \n \n \n `)}\n \n

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

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":50,"value":"\nPlot.plot({\n marks: [\n Plot.barX(table1, {x: \"count\", y: \"mesto\", fill: \"#345678\", sort: {x: \"x\", reverse: true}}),\n Plot.ruleY([0]),\n Plot.ruleX([0, 200000]),\n ], marginLeft: 250\n\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":294,"value":"Изменим таблицу, выведем данные \"Место\", Наименование\" , \"к-во участников\". ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":179,"value":"viewof table2 = Inputs.table(sport_world_data, {\n columns: [\n \"Место проведения\",\n \"Наименование соревнования\",\n \"Ориентировочное число участников\"\n ],\n header: {\n \"Наименование соревнования\": \"Наименование\",\n \"Место проведения\": \"Место\",\n \"Ориентировочное число участников\": \"к-во участников\"}, \n \n width: {\n \"Наименование соревнования\": 1400,\n \"Место проведения\": 170,\n \"Ориентировочное число участников\": 150\n },\n \n align: {\n \"Наименование соревнования\": \"left\",\n \"Место проведения\": \"left\",\n \"Ориентировочное число участников\": \"left\"\n },\n rows: 80, maxWidth: 1800, maxHeight: 400, sort: \"Ориентировочное число участников\", reverse:true, required: false})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":243,"value":"Построение фильтров для табличных данных на основе инструментов: select (multy), text, range;\n\nНайдем в каких городах в какие строки(месяц) пройдут соревнования","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":245,"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":253,"value":"search_month = sport_world_data.filter( (m)=> String(m[\"Сроки проведения\"]).indexOf(text.trim()) > -1)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":258,"value":"function new_creat_table(name1,name2){\n return Inputs.table(search_month, {\n columns: [\n name1,\n name2,],\n header: {\n name1: name1,\n name2: name2,\n }, \n rows: 60, maxWidth: 600, sort: \"name3\", maxHeight: 200, reverse:true, required: false})\n }","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":261,"value":"new_creat_table(\"Сроки проведения\",\"Место проведения\", search_month)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":303,"value":"Вывод таблицы для конкретного города (выбранного) или нескольких городов","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":307,"value":"regions = sport_world_data.map(d => d[\"Место проведения\"])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":305,"value":"viewof select_mult = Inputs.select(regions, {label: \"Укажите город:\", multiple: true, width:400})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":310,"value":"Inputs.table(sport_world_data.filter((x)=>select_mult.includes(String(x[\"Место проведения\"]) ) ), \n {\n columns: [\n \"Сроки проведения\",\n \"Наименование соревнования\",\n \"Ориентировочное число участников\"\n ],\n header: {\n \"Сроки проведения\": \"месяц\",\n \"Наименование соревнования\": \"вид спрота\",\n \"Ориентировочное число участников\": \"к-во участников\"}, \n \n width: {\n \"Сроки проведения\": 50,\n \"Наименование соревнования\": 400,\n \"Ориентировочное число участников\": 100\n },\n rows: 60, maxWidth: 1000, sort: \"всего 2021\", maxHeight: 400, reverse:true, required: false}) ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":442,"value":"!!!!! Задание Придумать другой способ без построения массива (Этот способ плохой! Почему?)","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":447,"value":"Ответ: т.к. массив может состоять из повторяющихся элементов (индекс первого и последнего элемента может не соответствовать фактическому значению), что может привести к ошибке при поиск max и min","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":334,"value":"m = sport_world_data.map( (x)=> Number(x[\"Ориентировочное число участников\"])).sort((a,b)=>(a-b))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":467,"value":"Используем Math","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":332,"value":"viewof range_A = Inputs.range([Math.min.apply(null,m), Math.max.apply(null,m)], {label: \"К-во участников от:\", value:Math.min.apply(null,m), step: 10, width: 300})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":342,"value":"viewof range_B = Inputs.range([range_A, Math.max.apply(null,m)], {label: \"К-во участников до:\", value: Math.max.apply(null,m), step: 10, width: 300})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":346,"value":"!!!!! Задание Показать с помощью bar-объекта (canvas) количество субъектов, отфильтрованных по количеству участников","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":348,"value":"canvas = {\n var width = 800;\n var height = 30;\n var max_count = sport_world_data.length;\n const context = DOM.context2d(width, height);\n context.fillStyle = \"hsl(216deg 10% 13%)\";\n context.fillRect(range_A*(width/Math.max.apply(null,m)), 0, range_B*(width/Math.max.apply(null,m)), height);\n context.canvas.style.background = \"hsl(216deg 100% 90%)\";\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":367,"value":"sport_world_data.columns","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":369,"value":"s_w_mult = sport_world_data.filter( (x)=> Number(x[\"Ориентировочное число участников\"]) >= range_A && Number(x[\"Ориентировочное число участников\"])<= range_B)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":372,"value":"Inputs.table(s_w_mult)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":454,"value":"Построим диаграмму субъектов, отфильтрованных по условию","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":456,"value":"Соревнования в Санкт-Петербурге","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":458,"value":"piter_sport = sport_world_data.filter((x)=> String(x[\"Место проведения\"]).indexOf(\"Санкт-Петербург\") > -1)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":460,"value":"viewof table = Inputs.table(piter_sport)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":462,"value":"Plot.plot({\n width:1000,\n marks: [\n Plot.barY(piter_sport, {y: \"Ориентировочное число участников\", x: \"Наименование соревнования\", fill: \"Сроки проведения\", sort: {x: \"y\", reverse: true}}),\n Plot.ruleX([0]),\n Plot.ruleY([0, 1600]),\n ], color: { legend: true },\n marginLeft: 50\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W47","stdlib":"1"}} 46:"$45:body"