2f:[{"id":"284bf0f9f9e0bc2b6415d606a7c92bf69f9ea4bc5e0ab6c60fbefc40c9d80aa11c8adaf8b7f0a390d8c6aee7b0f16941cb8cccc19764dec2928da2a753ea9904","href":"https://static.observableusercontent.com/files/284bf0f9f9e0bc2b6415d606a7c92bf69f9ea4bc5e0ab6c60fbefc40c9d80aa11c8adaf8b7f0a390d8c6aee7b0f16941cb8cccc19764dec2928da2a753ea9904","name":"Алкогольный виз - regions_years.csv","type":"text/csv","lastModified":1655252140682.696,"size":469742},{"id":"6dd3281734eb77d3b06b9d9dec06b0fa7d716fe6a0da86042cf3ff41f3ef1b542dbbc878dff4bf7f396c306fb500bd46cd510fadd6c8f49cc11eb65d08cf190d","href":"https://static.observableusercontent.com/files/6dd3281734eb77d3b06b9d9dec06b0fa7d716fe6a0da86042cf3ff41f3ef1b542dbbc878dff4bf7f396c306fb500bd46cd510fadd6c8f49cc11eb65d08cf190d","name":"Алкогольный виз - russia_years.csv","type":"text/csv","lastModified":1655253470433.431,"size":3061},{"id":"b8e4b17563ff1e42b456a75787dda3743b8c9799ed276e88db7bed9ae7c64c3b1e92ce20a11afa9bb8ea1e34b14eb5c303734401f93293f6135ca485c6fd9302","href":"https://static.observableusercontent.com/files/b8e4b17563ff1e42b456a75787dda3743b8c9799ed276e88db7bed9ae7c64c3b1e92ce20a11afa9bb8ea1e34b14eb5c303734401f93293f6135ca485c6fd9302","name":"Алкогольный виз - regions 2021.csv","type":"text/csv","lastModified":1655253595262.625,"size":86757}] 2d:{"title":" Продажа алкоголя в России ","cells":[{"id":0,"value":"# **Продажа алкоголя в России** ","pinned":false,"hidden":false,"mode":"md"},{"id":68,"value":"Проект на основе данных о розничных продажах алкогольной продукции Федеральной службы по регулированию алкогольного рынка, опубликованных на ЕМИСС.\n","pinned":false,"hidden":false,"mode":"md"},{"id":170,"value":"
","pinned":false,"hidden":false,"mode":"md"},{"id":100,"value":"**Объемы продаж алкогольной продукции в 2017–2021 годах**","pinned":false,"hidden":false,"mode":"md"},{"id":96,"value":"Несмотря на то, что общие показатели остались на прежнем уровне, изменились предпочтения по отдельным напиткам.\n

_Чтобы узнать, как изменился спрос на вино, пиво и другой алкоголь, воспользуйся меню._","pinned":false,"hidden":false,"mode":"md"},{"id":24,"value":"viewof select = Inputs.select(select_for_Bars, {label: 'Выберите напиток', fontFamily: 'PT Sans'})","pinned":false,"hidden":false,"mode":"ojs"},{"id":109,"value":"viz = {\n\nconst lineGraph = vl.markLine({strokeWidth: 5, opacity: 0.3, interpolate: 'monotone'})\n .data(filterdBars)\n .width(800)\n .height(300)\n .encode(\n vl.x().fieldO('year').title(false).axis({labelAngle: 0, labelFont: 'PT Sans', labelFontSize: 12, ticks: false, labelPadding: 8}),\n vl.y().fieldQ('value').title('Тысяча декалитров').axis({format: 'f', tickCount: 4, labelFont: 'PT Sans', labelFontSize: 12, ticks: false, labelPadding: 8}),\n vl.color().fieldN('type_drink').title('Алкоголь'),\n vl.tooltip(['type_drink','value']),\n )\n \nreturn vl.layer(lineGraph)\n \n\n .render()\n\n}\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":168,"value":"
","pinned":false,"hidden":false,"mode":"md"},{"id":289,"value":"**Рейтинг регионов по объему продаж**","pinned":false,"hidden":false,"mode":"md"},{"id":295,"value":"В 2020 и 2021 годах Московская область обогнала столицу","pinned":false,"hidden":false,"mode":"md"},{"id":240,"value":"viewof select_2 = Inputs.select(select_for_Bars_2, {label: 'Выберите год', fontFamily: 'PT Sans'})","pinned":false,"hidden":false,"mode":"ojs"},{"id":203,"value":"viz_2 = {\n const attr_reg = vl.markBar()\n .title({ text: 'Топ регионов по объему продаж', anchor: 'start', fontSize: 16, fontFamily: 'PT Sans' })\n .data(filterdBars_2)\n .width(300)\n .encode(\n vl.y().fieldN('region').sort('-x').axis({labelFont: 'PT Sans', labelFontSize: 10, ticks: false, labelPadding: 8}).title(false),\n vl.x().sum('value').title('Тысяча декалитров').axis({format: 'f', labelFont: 'PT Sans', labelFontSize: 10, ticks: false, labelPadding: 8}),\n vl.color().fieldN('year').scale({range: ['#F5E7E4', '#049CB3']}),\n vl.tooltip(['value']),\n );\n \nreturn vl.layer(attr_reg)\n \n\n .render()\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":302,"value":"

","pinned":false,"hidden":false,"mode":"html"},{"id":148,"value":"**Розничные продажи по регионам в 2021 году**","pinned":false,"hidden":false,"mode":"md"},{"id":150,"value":"Пиво лидирует во всех регионах по объему розничных продаж. А больше всего покупают алкоголя в Москве","pinned":false,"hidden":false,"mode":"md"},{"id":38,"value":"vl.markBar()\n .data(regions2021)\n .encode(\n vl.x().fieldN('type_drink').axis({labelFont: 'PT Sans', labelFontSize: 10, ticks: false, labelPadding: 8, labelAngle: -30}).title(false),\n vl.y().fieldN('region').axis({labelFont: 'PT Sans', labelFontSize: 10, ticks: false, labelPadding: 8}).title(false),\n vl.tooltip(['region', 'value']),\n vl.color().fieldQ('value').scale({range: ['#F5E7E4', '#049CB3']}).title('Объем продаж в тысячах декалитров'),\n )\n .width(900)\n .height(1600)\n .render()","pinned":false,"hidden":false,"mode":"ojs"},{"id":190,"value":"
","pinned":false,"hidden":false,"mode":"md"},{"id":283,"value":"
","pinned":false,"hidden":false,"mode":"md"},{"id":70,"value":"**Источники**\n\n","pinned":false,"hidden":false,"mode":"md"},{"id":77,"value":" [Розничная продажа алкогольной продукции в натуральном выражении](https://www.fedstat.ru/indicator/57614)","pinned":false,"hidden":false,"mode":"md"},{"id":88,"value":" [Розничная продажа пива, пивных напитков, сидра, пуаре и медовухи в натуральном выражении](https://www.fedstat.ru/indicator/57961)","pinned":false,"hidden":false,"mode":"md"},{"id":27,"value":"filterdBars = russia_years_new.filter(item => item.type_drink === select)","pinned":false,"hidden":false,"mode":"ojs"},{"id":46,"value":"select_for_Bars = [\"Все\", ...new Set(russia_years.map(item => item.type_drink))]","pinned":false,"hidden":false,"mode":"ojs"},{"id":230,"value":"select_for_Bars_2 = [\"Все\", ...new Set(regions_years.map(item => item.year))]","pinned":false,"hidden":false,"mode":"ojs"},{"id":233,"value":"filterdBars_2 = select_2 !== \"Все\" ? regions_years.filter(item => item.year === select_2) : regions_years","pinned":false,"hidden":false,"mode":"ojs"},{"id":8,"value":"regions_years = FileAttachment(\"Алкогольный виз - regions_years.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs"},{"id":272,"value":"russia_years_new= {\n const allYears = [...new Set(russia_years.map(({ year }) => year))]\n const bars = allYears.map(year => {\n const sumValue = russia_years.filter(bar => bar.year === year).reduce((sum, item) => sum + +item.value, 0);\n return { year, type_drink: \"Все\", value: sumValue }\n })\n\n return [...bars, ...russia_years];\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":41,"value":"regions2021 = FileAttachment(\"Алкогольный виз - regions 2021.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs"},{"id":34,"value":"russia_years = FileAttachment(\"Алкогольный виз - russia_years.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs"},{"id":11,"value":"usedColors = ['#F5E7E4', '#049CB3']","pinned":false,"hidden":false,"mode":"ojs"},{"id":192,"value":"import {vl} from \"@vega/vega-lite-api\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":65,"value":"\n\n","pinned":false,"hidden":false,"mode":"html"}],"files":"$W2f","stdlib":"1","titling":"auto"}