40:null 41:["$","title",null,{"children":"Итоговый проект | Alisa Zhabina | Observable"}] 47:T51e,Plot.plot({ caption:`Рисунок 7`, width: 1200, height: 700, color: { legend: true, range:["#44d9b6", "#bb2649", "#98ff98"] }, x: {label: 'Год →'}, y: {grid: true, label: 'Средний показатель уровня грамотности ↑'}, marginLeft: 50, marginBottom: 50, marks: [ Plot.dot(date.filter(x => x.Country == 'Uzbekistan'), Plot.groupX({y: "mean"}, {x: "Year", y: "Literacy rate", fill: "Country"})), Plot.line(date.filter(x => x.Country == 'Uzbekistan'), Plot.groupX({y: "mean"}, {x: "Year", y: "Literacy rate", stroke: "Country", curve: "catmull-rom"})), Plot.dot(date.filter(x => x.Region == 'Europe and Northern America'), Plot.groupX({y: "mean"}, {x: "Year", y: "Literacy rate", fill: "Region"})), Plot.line(date.filter(x => x.Region == 'Europe and Northern America'), Plot.groupX({y: "mean"}, {x: "Year", y: "Literacy rate", stroke: "Region", curve: "catmull-rom"})), Plot.dot(date.filter(x => x.Region == 'Central and Southern Asia'), Plot.groupX({y: "mean"}, {x: "Year", y: "Literacy rate", fill: "Region"})), Plot.line(date.filter(x => x.Region == 'Central and Southern Asia'), Plot.groupX({y: "mean"}, {x: "Year", y: "Literacy rate", stroke: "Region", curve: "catmull-rom"})), Plot.ruleY([0]) ], grid: true })48:[{"id":"ae50ec9d7d175319fc2a0abb333d6a045c49e8c41f83fcf4a12cc221de04a0bf875f106ee8c9093cdf263c0a28ab229be53eaeb18b7d95549e3813afab91d922","href":"https://static.observableusercontent.com/files/ae50ec9d7d175319fc2a0abb333d6a045c49e8c41f83fcf4a12cc221de04a0bf875f106ee8c9093cdf263c0a28ab229be53eaeb18b7d95549e3813afab91d922","name":"Literacy rates (no pw2).csv","type":"text/csv","lastModified":1671467083955.034,"size":347000}] 45:{"id":"067e66bc41cc1c88","slug":null,"title":"Итоговый проект","thumbnail":"0680a8abc8cae1dc56237249cac4046d4c32bf6fe1b392ef1717a5861b26b05e","access_level":"public","create_time":"$D2022-12-19T16:24:16.928Z","update_time":"$D2022-12-20T10:09:39.458Z","view_time":null,"first_public_time":"$D2022-12-19T16:24:16.928Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"b7a57b13171470d4","login":"lisa-2308","name":"Alisa Zhabina","avatar_url":"https://avatars-next.observableusercontent.com/82ccc0ced9e426d1dcb206b76a11ed8891f4f00ab2fe04d3c7197e1b5f1f24ed","tier":"starter_2024","bio":"","following":false},"version":369,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"d7e969dea2efe25a","login":"lisa-2308","name":"Alisa Zhabina","avatar_url":"https://avatars-next.observableusercontent.com/82ccc0ced9e426d1dcb206b76a11ed8891f4f00ab2fe04d3c7197e1b5f1f24ed","tier":null,"bio":"","following":false}],"members":[{"type":"individual","id":"d7e969dea2efe25a","login":"lisa-2308","name":"Alisa Zhabina","avatar_url":"https://avatars-next.observableusercontent.com/82ccc0ced9e426d1dcb206b76a11ed8891f4f00ab2fe04d3c7197e1b5f1f24ed","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":2,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Итоговый проект","cells":[{"id":0,"value":"# Итоговый проект ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":207,"value":"Этот набор данных содержит данные об уровне грамотности среди молодежи и взрослого населения в различных регионах и странах. Данные дают представление о том, в каких регионах высокий или низкий уровень грамотности, а также о том, как уровень грамотности менялся с течением времени.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":209,"value":"\n
Region: регион, из которого получены данные.\n
Country: страна, из которой получены данные.\n
Year: год, за который получены данные. \n
Age: возрастная группа, из которой получены данные. \n
Gender: пол опрашивающей группы.\n
Literacy rate: уровень грамотности для данного региона, страны, года, возраста и пола. ( 0 до 1)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":211,"value":"Данные взяты из открыттого источника:\nhttps://www.kaggle.com/datasets/thedevastator/youth-adult-literacy-rates-in-2019","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":6,"value":"viewof table1 = Inputs.table(date)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":265,"value":"На круговой диаграмме представлено количество опрошенных в каждой возрастной группе. В каждой возрастной группе опрошенно примерно одинаковое количество.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":117,"value":"PieChart(data, {\n name: (d) => d.age,\n value: (d) => d.quantity,\n width,\n height: 500,\n startAngle: 0,\n strokeWidth: 0\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":268,"value":"На \"Рисунке 2\" можно заметить, что средний показатель грамотности в возрастной категории 15-24 лидирует. Худший показатель грамотности в возрастной группе 65+.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":8,"value":"Plot.plot({\n marks: [\n Plot.barY(date, Plot.groupX({y: \"mean\"}, {x: \"Age\", y: \"Literacy rate\", fill:\"#bb2649\", sort: {x: \"y\", reverse: true}})),\n Plot.ruleY([0])\n ],\n caption: `Рисунок 2- Средний уровень грамотности по возрастам`,\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":287,"value":"Опираясь на результаты полученные на \"Рисунке 3\", можно сделать вывод:\n
1). В Европе и Северной Америке самый высокий уровень грамотности.\n
2). В Африке к югу от Сахары самое безграмотное население.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":47,"value":"Plot.plot({\n marks: [\n Plot.barX(date.slice(0,12000),Plot.groupY({x: \"mean\"},{x: \"Literacy rate\", y: \"Region\", fill:\"Region\" , sort: {x: \"x\", reverse: true}})),\n Plot.ruleX([0,0.5, 0.9, 0.95, 1])\n ],\n caption: `Рисунок 3 - Средний уровень грамотности по регионам`,\n colors: { legend: true },\n marginLeft: 200\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":352,"value":"Рисунок 4.\n
Столбчатая диаграмма отображающая сколько раз в стране набирался определнный балл уровня грамотности в завсимости от диапозона.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":18,"value":"viewof range_A = Inputs.range([arr_max_min[0], arr_max_min[1]], {label: \"Oт:\", value:arr_max_min[0], step: 0.000001, width: 1200})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":20,"value":"viewof range_B = Inputs.range([range_A, arr_max_min[1]], {label: \"До:\", value: arr_max_min[1]+1, step: 0.000001, width: 1200})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":101,"value":"Plot.plot({\n caption:`Рисунок 4`,\n width :1500,\n height : 1000, \n grid : true,\n x:{tickRotate: -18},\n y:{label: \"↑ Кол-во\",},\n marks: [\n Plot.barY(date.filter((x)=> Number(x[\"Literacy rate\"]) >= range_A && Number(x[\"Literacy rate\"])<= range_B), Plot.groupX({y: \"count\"}, {x: \"Country\", fill: \"#af6f78\" , fillOpacity: 0.4})),\n \n Plot.ruleY([0]),\n ],\n marginLeft: 100})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":301,"value":"Рисунок 5.\n
В зависимости от года столбчатая диаграмма отображает средний уровень грамотности в выбранном регионе.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":155,"value":"viewof filter_date = Scrubber(DataD, {\n delay : 700,\n alternate: true,\n loop: true,\n format: x => x.toLocaleString(\"ru\",{year: 'numeric'})\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":179,"value":"viewof select_m = Inputs.select(new Set(date.map(d => d[\"Region\"]).sort((a,b)=>(a-b))), {label: \"Регион:\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":153,"value":"Plot.plot({\n caption:`Рисунок 5`,\n width: 1200,\n height: 300,\n grid: true, \n marginLeft: 100,\n y:{domain: [0, 1],\n label: 'Средний показатель уровня грамотности ↑'},\n x: {label: 'Год'},\n // color: { legend: true },\n marks: [\n Plot.barY(date.filter((x) => x.Region == select_m ), Plot.groupX({y: \"mean\"},{ x: 'Year', y: 'Literacy rate', fill: '#bb2649', filter: ((d) => d['Year'] <= filter_date)})),\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":309,"value":"Можно сделать выводы:\n
1). В Африке к югу от Сахары самый низкий уровень грамотности был в 2013 году. Это самый низкий показатель за все рассматриваемые года в регионах.\n
2). В Океании после 2010 года произошёл резкий \"прыжок\" среднего показателя уровня гармотности. Показатель увеличился на 0.3 и в последующие года не становился ниже 0.8.\n
3). В Латинской Америке и Северной Африке, и Западной Азии уровень грамотности стабилен ( не ниже 0.8). \n
4). В южной и центральной Азии более безграмотное население, чем в восточной части Азии.\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":317,"value":"Рисунок 6.\n
Данная диаграмма показывает в каких страннах был набран максимальный балл и сколько раз.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":216,"value":"Plot.plot({\n caption:`Рисунок 6`,\n width:800,\n height: 800,\n x:{\n label: \"Страны, в которых был набран максимальный балл\",\n },\n marks: [\n Plot.barX(date.filter( (d)=> d[\"Literacy rate\"] >= 0.99999 && d[\"Literacy rate\"] <=1),{y:\"Country\" , x:\"Literacy rate\" , fill:\"#bb2649\", sort: {y: \"x\", reverse: false}}),\n Plot.ruleX([0, 2, 20], {fill:\"#bb2649\"})],\n colors: { legend: true },\n marginLeft: 300,\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":323,"value":"В Узбекистане 24 раза набирали максимальный балл по уровню грамотности (Регион: Центральная и Южная Азия).\nВ Украине 1 раз и в Сан-Марино 4 раза (Регион: Северная америка и Европа).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":330,"value":"Рисунок 7.\n
Учитывая, что Узбекистан стал лидером по количеству раз набранного максимальный балл, сравним средний показатель уровня грамотности (по годам) в Узбекистане, в Центральнгой и Южной Азии и самом грамотном регионе мира - Европа и Северная Америка.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":248,"value":"$47","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":332,"value":"Можно сделать вывод: уровень грамотности в Узбекистане значительно выше, чем в регионе в котором находится эта страна. Средний уровень грамотности Узбекистна за 2013-2016 превышает показатель Северной Америки и Европы и стремится к 1.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":157,"value":"import {Scrubber} from \"@mbostock/scrubber\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":39,"value":"colors = [\"#bb2649\",\"#44d9b6\",\"#b5a642 \",\"#3a75c4\",\"#00e18b\",\"#98ff98\",\"#574571\",\"#0e2810\",\"#b695bc\",\"#466c4b\",\"#ffa074\",\"#9a719f\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"date=FileAttachment(\"Literacy rates (no pw2).csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":115,"value":"s = d3.group(date, d => d.Age)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":73,"value":"`названия столбцов:[${date.columns}]\\n количество объектов: ${date.length}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"function max_min() {\n var arr =date.map( (x)=> Number(x[\"Literacy rate\"])).sort((a,b)=>(a-b));\n return [arr[0], arr[arr.length-1]];\n} ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":119,"value":"data = d3.csvParse(`age,quantity\n\"Меньше 15\", 1260\n\"15-24\",1239\n\"25-64\",1239\n\"65+\",1217\n`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":122,"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":137,"value":"import {vl} from \"@vega/vega-lite-api\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":16,"value":"arr_max_min = max_min()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":160,"value":"DataD = new Set(date.map(d => d[\"Year\"]).sort((a,b)=>(a-b)))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W48","stdlib":"1"}} 46:"$45:body"