45:["$","title",null,{"children":"Evolución de la confianza empresarial en el Perú | Victor Fuentes | Observable"}] 4d:T6a9,chart = Plot.plot({ marks: [ Plot.barY( output_expectativas.filter( (d) => (d.sector == filtros.SectoresSeleccionados) & (d.fecha >= filtros.fecha_inicio) & (d.fecha <= filtros.fecha_fin) & (d.horizonte == filtros.horizonte_sel) ), { x: "fecha", y: "valor", z: "sector", fill: "valor" } ), Plot.lineY( output_expectativas.filter( (d) => (d.sector == filtros.SectoresSeleccionados) & (d.fecha >= filtros.fecha_inicio) & (d.fecha <= filtros.fecha_fin) & (d.horizonte == filtros.horizonte_sel) ), { x: "fecha", y: "valor", z: "sector", stroke: "transparent", tip: true, title: (d) => pe_locale.utcFormat("%b %Y")(d.fecha) + ":\n" + d3.format(".1f")(d.valor) } ), Plot.ruleY([50], {stroke: "#262626", strokeDasharray:"4"}) ], color: { ticks: [25, 40, 50, 60, 75], domain: [20, 80], type: "diverging-pow", scheme: "rdylbu", legend: true, pivot: 50, label: "Índice (0, 100)" }, x: { label: null, tickFormat: d3.utcFormat("%Y"), interval: d3.utcMonth, ticks: [ new Date("2002-01-01"), new Date("2004-01-01"), new Date("2006-01-01"), new Date("2008-01-01"), new Date("2010-01-01"), new Date("2012-01-01"), new Date("2014-01-01"), new Date("2016-01-01"), new Date("2018-01-01"), new Date("2020-01-01"), new Date("2022-01-01"), new Date("2023-01-01") ] }, y: { grid: true, label: "↑ Optimismo" }, height: 400, width: 800 })4e:T8e0,chart_faceted = Plot.plot({ marginLeft: 50, marginTop: 50, facet: { data: output_filtrado, x: d=> d.horizonte, y: "sector", columns: true }, fy: { axis: 'both', domain: ["General","Minería e hidrocarburos", "Manufactura","Comercio", "Servicios"], tickRotate: -90, tickPadding: 30, label: null, labelAnchor: "center", lineWidth: 10 }, fx: { inset:-10, label: null, domain: [3,12], tickFormat: (d) => 'Expectativas a ' + d+ ' meses', tickSize: 0, tickPadding: 30, }, marks: [ Plot.axisY({ anchor: "left", labelAnchor: "top", tickSize: 0, tickPadding: 5, }), Plot.axisY({ anchor: "right", labelAnchor: "top", tickSize: 0, tickPadding: 5, }), Plot.axisX({ anchor: "top", label: null, tickFormat: d3.utcFormat("%b-%Y"), interval: d3.utcMonth, ticks: [ new Date("2020-01-01"), new Date("2021-01-01"), new Date("2022-01-01"), new Date("2023-01-01") ] }), Plot.axisX({ anchor: "bottom", label: null, tickFormat: d3.utcFormat("%b-%Y"), interval: d3.utcMonth, ticks: [ new Date("2020-01-01"), new Date("2021-01-01"), new Date("2022-01-01"), new Date("2023-01-01") ] }), Plot.barY( output_filtrado, { x: "fecha", y: "valor", z: "sector", fill: "valor", title: (d) => pe_locale.utcFormat("%b %Y")(d.fecha) + ":\n" + d3.format(".1f")(d.valor), } ), Plot.lineY( output_filtrado, { x: "fecha", y: "valor", z: "sector", stroke: "transparent", tip: true, title: (d) => pe_locale.utcFormat("%b %Y")(d.fecha) + ":\n" + d3.format(".1f")(d.valor), } ), Plot.ruleY([50], {stroke: "#262626", strokeDasharray:"4"}), ], color: { ticks: [25, 40, 50, 60, 75], domain: [20, 80], type: "diverging-pow", scheme: "rdylbu", legend: true, pivot: 50, label: "Índice (0, 100)" }, y: { grid: true, label: null }, height:500 })4f:T521,chart_cell_horizontal = Plot.plot({ insetLeft: 10, marginLeft: 100, facet: { data: output_filtrado, y: (d) => d.horizonte, columns: true }, fy: { label: null, domain: [3, 12], tickFormat: (d) => "Expec. a\n" + d + " meses", tickSize: 0, tickPadding: 0 }, marks: [ Plot.cell(output_filtrado, { x: "fecha", y: "sector", fill: "valor", title: (d) => pe_locale.utcFormat("%b %Y")(d.fecha) + ":\n" + d3.format(".1f")(d.valor) }) ], color: { ticks: [25, 40, 50, 60, 75], domain: [20, 80], type: "diverging-pow", scheme: "rdylbu", legend: true, pivot: 50, label: "Índice (0, 100)" }, marginLeft: 100, x: { label: null, tickFormat: d3.utcFormat("%b-%Y"), interval: d3.utcMonth, ticks: [ new Date("2019-07-01"), new Date("2020-01-01"), new Date("2020-07-01"), new Date("2021-01-01"), new Date("2021-07-01"), new Date("2022-01-01"), new Date("2022-07-01"), new Date("2023-01-01") ] }, y: { grid: true, label: null, domain: [ "General", "Minería e hidrocarburos", "Manufactura", "Comercio", "Servicios" ], tickSize: 0, tickPadding: -5 }, width: 800 })50:T7ac,chart_cell = Plot.plot({ marginBottom: 110, marginTop: 115, marginLeft: 50, facet: { data: output_filtrado, x: d=> d.horizonte, columns: true }, fx: { label: null, domain: [3,12], tickFormat: (d) => 'Expectativas a ' + d+ ' meses', tickSize: 0, tickPadding: 105, }, marks: [ Plot.axisX({ anchor: "bottom", labelAnchor: "center", domain: ["General","Minería e hidrocarburos", "Manufactura","Comercio", "Servicios"], tickSize: 0, tickPadding: -5, tickRotate: -90, label: null }), Plot.axisX({ anchor: "top", labelAnchor: "center", domain: ["General","Minería e hidrocarburos", "Manufactura","Comercio", "Servicios"], tickSize: 0, tickPadding: -5, tickRotate: -90, label: null }), Plot.cell(output_filtrado, { x: "sector", y: "fecha", fill: "valor", title: (d) => pe_locale.utcFormat("%b %Y")(d.fecha) + ":\n" + d3.format(".1f")(d.valor), })], color: { ticks: [25, 40, 50, 60, 75], domain: [20, 80], type: "diverging-pow", scheme: "rdylbu", legend: true, pivot: 50, label: "Índice (0, 100)" }, y: { label: null, tickFormat: d3.utcFormat("%b-%Y"), interval: d3.utcMonth, ticks: [ new Date("2019-01-01"), new Date("2019-07-01"), new Date("2020-01-01"), new Date("2020-07-01"), new Date("2021-01-01"), new Date("2021-07-01"), new Date("2022-01-01"), new Date("2022-07-01"), new Date("2023-01-01") ] }, // x: { // grid: true, // label: null, // domain: ["General","Minería e hidrocarburos", "Manufactura","Comercio", "Servicios"], // tickSize: 0, // tickRotate: -90 // }, height: 900, width: 400 })51:[] 49:{"id":"4443e5c5d25dbf26","slug":"confianza-empresarial-peru","title":"Evolución de la confianza empresarial en el Perú","thumbnail":"904022cad54f55759ee181d978489ac1aab69d813521281cbdf93478d6a5d0ec","access_level":"public","create_time":"$D2022-10-19T05:47:49.177Z","update_time":"$D2024-04-22T00:26:12.727Z","view_time":null,"first_public_time":"$D2022-10-19T06:29:46.224Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"29a4dfa992066803","login":"vfuentesc","name":"Victor Fuentes","avatar_url":"https://avatars-next.observableusercontent.com/1d1eef43546c42d5f4083ce7815440acf431e2e8a9a8eaf7113fcde29e34826e","tier":"starter_2024","bio":"Gerente Central de Economía, IPE","followed_by_you":false,"follows_you":false},"version":975,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"7e69cc332aa690cb","login":"vfuentesc","name":"Victor Fuentes","avatar_url":"https://avatars-next.observableusercontent.com/ea82c90a64af21d1a51a98787faf2a737de8ac4d0a996468c8025a9adb671a2f","tier":null,"bio":"Gerente Central de Economía, IPE","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"7e69cc332aa690cb","login":"vfuentesc","name":"Victor Fuentes","avatar_url":"https://avatars-next.observableusercontent.com/ea82c90a64af21d1a51a98787faf2a737de8ac4d0a996468c8025a9adb671a2f","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Evolución de la confianza empresarial en el Perú","cells":[{"id":0,"value":"# Evolución de la confianza empresarial en el Perú\n\nEl [Banco Central de Reserva del Perú (BCRP)](https://www.bcrp.gob.pe/estadisticas.html) provee información sobre las expectativas empresariales. Para su construcción se utiliza la siguiente fórmula _Índice = (M – P + 1) * 50_. Donde _M_ representa el porcentaje empresas que señalaron mejor y _P_ representa el porcentaje de empresas que señalaron peor.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":376,"value":"---\n## Perú: Expectativas sobre la economía a ${filtros.horizonte_sel} meses - ${filtros.SectoresSeleccionados}, ${pe_locale.utcFormat(\"%Y\")(filtros.fecha_inicio)}-${pe_locale.utcFormat(\"%Y\")(filtros.fecha_fin)}\n_(en índice, tramo optimista mayor a 50)_","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":412,"value":"viewof filtros = {\n let minfecha = d3.min([...new Set(output_expectativas.map((d) => d.fecha))]);\n let maxfecha = d3.max([...new Set(output_expectativas.map((d) => d.fecha))]);\n let sectores = [\"General\",\"Minería e hidrocarburos\", \"Manufactura\",\"Comercio\", \"Servicios\"];\n let horizonte = new Map([[\"3 meses\", 3], [\"12 meses\", 12]])\n \n return Inputs.form(\n {\n SectoresSeleccionados: Inputs.select(sectores, {\n label: \"Sector\",\n multiple: false,\n value: \"comercio\"\n }),\n horizonte_sel: Inputs.radio(horizonte, { label: \"Horizonte\", value: 3 }),\n fecha_inicio: Inputs.date({ label: \"Inicio\", value: minfecha }),\n fecha_fin: Inputs.date({ label: \"Fin\", value: maxfecha })\n },\n { template }\n );\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":599,"value":"$4d","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":535,"value":"

Fuente: BCRP.

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":392,"value":"output_expectativas = d3.csv(\n \"https://raw.githubusercontent.com/vfuentesc/IPE_DataViz/main/Expectativas/output_expectativas.csv\",\n d3.autoType\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":633,"value":"output_filtrado = output_expectativas.filter(\n (d) => (d.fecha >= new Date(\"2019-01-01\"))\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":285,"value":"pe_ES = ({\n \"decimal\": \".\",\n \"thousands\": \",\",\n \"grouping\": [3],\n \"currency\": [\"S/\", \"\"],\n \"dateTime\": \"%a %b %e %X %Y\",\n \"date\": \"%d/%m/%Y\",\n \"time\": \"%H:%M:%S\",\n \"periods\": [\"AM\", \"PM\"],\n \"days\": [\"Domingo\", \"Lunes\", \"Martes\", \"Miércoles\", \"Jueves\", \"Viernes\", \"Sábado\"],\n \"shortDays\": [\"Dom\", \"Lun\", \"Mar\", \"Mi\", \"Jue\", \"Vie\", \"Sab\"],\n \"months\": [\"Enero\", \"Febrero\", \"Marzo\", \"Abril\", \"Mayo\", \"Junio\", \"Julio\", \"Agosto\", \"Septiembre\", \"Octubre\", \"Noviembre\", \"Diciembre\"],\n \"shortMonths\": [\"Ene\", \"Feb\", \"Mar\", \"Abr\", \"May\", \"Jun\", \"Jul\", \"Ago\", \"Sep\", \"Oct\", \"Nov\", \"Dic\"]\n });","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":288,"value":"pe_locale = d3.timeFormatLocale(pe_ES);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":420,"value":"template = (inputs) =>\n htl.html`

${Object.values(inputs)}

\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W51","stdlib":"1"}} 44:null