40:null 41:["$","title",null,{"children":"Untitled | Dm Dm's Workspace | Observable"}] 47:Tc69,Датасет содержит данные по управлению туризмом с акцентом на распределение ресурсов и предоставление услуг в различных туристических направлениях. Данные были собраны с использованием ряда технологий в течение шести месяцев. Набор данных включает информацию о потоке посетителей, факторах окружающей среды, использовании ресурсов и других ключевых показателях, которые влияют на туристический опыт и эффективность работы. Основные характеристики: Метка времени: дата и время сбора данных. Идентификатор местоположения: уникальный идентификатор туристического направления или местоположения. Количество посетителей: количество посетителей в месте назначения в указанную временную метку. Средняя продолжительность пребывания: средняя продолжительность (в минутах), которую туристы проводят в месте. Пиковое количество посетителей: двоичный индикатор, показывающий, превысило ли количество посетителей пороговое значение (например, переполнено, если 1). Температура: температура в месте по Цельсию. Влажность: относительная влажность в процентах в месте. Качество воздуха: индекс качества воздуха (AQI) в месте, указывающий уровень загрязнения. Погодные условия: текущие погодные условия (например, солнечно, облачно, дождливо). Тип ресурса: тип отслеживаемого ресурса (например, туалет, продуктовый киоск, место для парковки). Доступные ресурсы: количество ресурсов, доступных в месте (например, доступные туалеты или парковочные места). Спрос на ресурсы: текущий спрос на определенный ресурс. Мощность ресурса: общая мощность ресурсов, доступных в месте. Переполненность: двоичный целевой столбец, где 1 указывает на переполненность, а 0 — на отсутствие переполненности, на основе количества посетителей и доступных ресурсов.48:T4fc,viewof dsT = Inputs.table(updatedData, { columns: [ "timestamp", "location_id", "visitor_count", "avg_stay_duration", "peak_visitors", "temperature", "humidity", "air_quality", "weather_condition", "resource_type", "available_resources", "resource_demand", "resource_capacity", "overcrowded", ], header: { "timestamp": "Метка времени", "location_id": "Идентификатор местоположения", "visitor_count": "Количество посетителей", "avg_stay_duration": "Средняя продолжительность пребывания (мин.)", "peak_visitors": "Пиковое количество посетителей", "temperature": "Температура", "humidity": "Влажность", "air_quality": "Качество воздуха", "weather_condition": "Погодные условия", "resource_type": "Тип ресурса", "available_resources": "Доступные ресурсы", "resource_demand": "Спрос на ресурсы", "resource_capacity": "Мощность ресурса", "overcrowded": "переполненный", }, sort: "", reverse:false, required: false})49:[{"id":"3de668a8a0e197111c488fd85ffd5d0562f1c9a2f07b855ef94ec8bc0f6977bef0258c2f07c566bfa6ab90e301175cc027276309dc24d40908f6fa7353a18c8f","href":"https://static.observableusercontent.com/files/3de668a8a0e197111c488fd85ffd5d0562f1c9a2f07b855ef94ec8bc0f6977bef0258c2f07c566bfa6ab90e301175cc027276309dc24d40908f6fa7353a18c8f","name":"tourism_management_dataset.csv","type":"text/csv","lastModified":1740416729433.878,"size":100052}] 45:{"id":"929da9b5d86e2cfc","slug":null,"title":"","thumbnail":"387ea5b1c478329c70e040789624413496d13fb061427d68255e5c4c977fd6a8","access_level":"public","create_time":"$D2025-02-24T17:04:52.124Z","update_time":"$D2025-02-27T09:43:28.618Z","view_time":null,"first_public_time":"$D2025-02-27T06:46:48.469Z","has_unpublished_edits":null,"fork":false,"stars":0,"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":539,"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":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"","cells":[{"id":497,"value":"## Тестовое задание. Стажировка 2025 Катаев Д.Н.\n## Работа на тему \"Туризм\". \n## Выполнил Катаев Дмитрий, АГУ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":23,"value":"$47","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":0,"value":"ds = FileAttachment(\"tourism_management_dataset.csv\").csv({typed: true})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":19,"value":"updatedData = ds.map(row => ({\n timestamp: row.timestamp,\n location_id: row.location_id,\n visitor_count: row.visitor_count,\n avg_stay_duration: row.avg_stay_duration,\n peak_visitors: row.peak_visitors,\n temperature: row.temperature,\n humidity: row.humidity,\n air_quality: row.air_quality,\n weather_condition: row.weather_condition,\n resource_type: row.resource_type,\n available_resources: row.available_resources,\n resource_demand: row.resource_demand,\n resource_capacity: row.resource_capacity,\n overcrowded: row.overcrowded,\n}));","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"$48","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":44,"value":"data_w = Object.keys(v_Count).map(type => ({\n Job: type,\n Count: v_Count[type]\n}));","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":433,"value":"### Рассмотрим распределение количества посетителей в зависимости от погодных условий","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":32,"value":"chart = PieChart(data_w.filter(job => job.Count > 10), {\n name: d => d.Job,\n value: d => d.Count,\n width,\n height: 500\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":36,"value":"ds_w = updatedData.map(d => d.weather_condition)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":34,"value":"v_Count = ds_w.reduce((acc, type) => {\nacc[type] = (acc[type] || 0) + 1;\nreturn acc;\n}, {});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":40,"value":"import {PieChart} from \"@d3/pie-chart\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":75,"value":"### Узнаем максимальное, минимальное, среднее количество посещений в месте положения по выбранному погодному условию ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":79,"value":"viewof selectType = Inputs.select(new Set(updatedData.map(d => d[\"weather_condition\"])), {label: \"Погода:\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":82,"value":"viewof dsS = Inputs.table(visitorData, {\n columns: [\n \"location_id\",\n \"min_visitor_count\",\n \"max_visitor_count\",\n \"average_visitor_count\",\n ],\n header: {\n \"location_id\": \"Идентификатор местоположения\",\n \"min_visitor_count\": \"Мин. количество посетителей\",\n \"max_visitor_count\": \"МаксКоличество посетителей\",\n \"average_visitor_count\": \"Средняя Количество посетителей\",\n }, \n sort: \"\", reverse:false, required: false})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":88,"value":"visitorData = Object.values(updatedData.reduce((acc, cur) => {\n if (cur.weather_condition === selectType) {\n if (!acc[cur.location_id]) {\n acc[cur.location_id] = { \n location_id: cur.location_id, \n min_visitor_count: cur.visitor_count, \n max_visitor_count: cur.visitor_count, \n total_visitor_count: cur.visitor_count, \n count: 1,\n average_visitor_count: cur.visitor_count\n };\n } else {\n acc[cur.location_id].min_visitor_count = Math.min(acc[cur.location_id].min_visitor_count, cur.visitor_count);\n acc[cur.location_id].max_visitor_count = Math.max(acc[cur.location_id].max_visitor_count, cur.visitor_count);\n acc[cur.location_id].total_visitor_count += cur.visitor_count;\n acc[cur.location_id].count++;\n acc[cur.location_id].average_visitor_count = acc[cur.location_id].total_visitor_count / acc[cur.location_id].count;\n }\n }\n return acc;\n}, {}));\n","pinned":false,"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":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":348,"value":"viewof selectType1 = Inputs.select(new Set(updatedData.map(d => d[\"resource_type\"])), {label: \"Тип ресурса:\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":123,"value":"Plot.plot({\n width: 1000,\n color: { legend: true, range: [\"red\", \"grey\"] },\n x: { label: 'Доступность ресурса' },\n y: {\n grid: true,\n label: 'Количество посетителей',\n domain: [0, 350], // Добавляем ограничение по оси Y\n },\n marginLeft: 50,\n marginBottom: 30,\n marks: [\n Plot.barY(\n vis_Data,\n Plot.groupX(\n { y: \"mean\" },\n { x: \"resource_demand\", y: \"min_visitor_count\", fill: \"min_visitor_count\", fillOpacity: 0.4, rx: 20 }\n )\n ),\n Plot.barY(\n vis_Data,\n Plot.groupX(\n { y: \"mean\" },\n { x: \"available_resources\", y: \"max_visitor_count\", fill: \"max_visitor_count\", fillOpacity: 0.4, rx: 2 }\n )\n ),\n Plot.barY(\n vis_Data,\n Plot.groupX(\n { y: \"mean\" },\n { x: \"available_resources\", y: \"average_visitor_count\", fill: \"average_visitor_count\", fillOpacity: 0.4, rx: 2 }\n )\n ),\n Plot.ruleY([0]),\n ],\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":297,"value":"vis_Data = Object.values(updatedData.reduce((acc, cur) => {\n if (cur.resource_type === selectType1) {\n if (!acc[cur.available_resources]) {\n acc[cur.available_resources] = { \n available_resources: cur.available_resources, \n min_visitor_count: cur.visitor_count, \n max_visitor_count: cur.visitor_count, \n total_salary: cur.visitor_count, \n count: 1,\n average_visitor_count: cur.visitor_count\n };\n } else {\n acc[cur.available_resources].min_visitor_count = Math.min(acc[cur.available_resources].min_visitor_count, cur.visitor_count);\n acc[cur.available_resources].max_visitor_count = Math.max(acc[cur.available_resources].max_visitor_count, cur.visitor_count);\n acc[cur.available_resources].total_salary += cur.visitor_count;\n acc[cur.available_resources].count++;\n acc[cur.available_resources].average_visitor_count = acc[cur.available_resources].total_salary / acc[cur.available_resources].count;\n }\n }\n return acc;\n}, {}));","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":134,"value":"### Сегмент среднего количества посетителей при выбранных условиях","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":136,"value":"Plot.plot({\n height: 200,\n marks: [\n Plot.dot(vis_Data, Plot.dodgeY({x: \"average_visitor_count\",fill: \"average_visitor_count\" }))\n ],\n color: {\n legend: true\n },\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":216,"value":"data = FileAttachment(\"tourism_management_dataset.csv\").csv({typed: true})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":189,"value":"

\n\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":502,"value":"## - - - - - - T - - - - -","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":185,"value":"

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":187,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"}],"files":"$W49","stdlib":"1"}} 46:"$45:body"