2b:null 2c:["$","title",null,{"children":"Resumen de apagones (WIP) | José M. Zavala González | Observable"}] 31:T595,{ const dataWidth = width; const marginLeft = 50; const marginRight = 50; const m4_regions_service_total = m4(regions_service_total, dataWidth, 'timestamp', 'totalClientsWithoutService') return Plot.plot({ width: dataWidth + marginLeft + marginRight, marginLeft, marginRight, y: { grid: false, // domain: [0,50000], }, marks: [ Plot.gridY({stroke: "black", strokeOpacity: 0.2}), Plot.line( m4_regions_service_total, { x: 'timestamp', y: 'totalClientsWithoutService', // stroke: 'steelblue', tip: true, // strokeWidth: .8, }), Plot.areaY( m4_regions_service_total, { x: 'timestamp', y1: d => d['totalClientsWithoutService'] >= service_threshold ? 0 : null, y2: d => d['totalClientsWithoutService'] >= service_threshold ? d['totalClientsWithoutService'] : null, // stroke: 'steelblue', fill: 'red', fillOpacity: 0.5, //stroke: 'red', strokeOpacity: 1, tip: false, // strokeWidth: .8, }), Plot.line( m4_regions_service_total, { x: 'timestamp', y: d => d['totalClientsWithoutService'] >= service_threshold ? d['totalClientsWithoutService'] : null, // stroke: 'steelblue', // fill: 'red', fillOpacity: 0.5, stroke: 'red', strokeOpacity: 1, tip: false, // strokeWidth: .8, }), Plot.ruleY([0]), ] }) }32:T46b,{ const dataWidth = width; const marginLeft = 50; const marginRight = 50; return Plot.plot({ width: dataWidth + marginLeft + marginRight, marginLeft, marginRight, marks: [ Plot.rectY(clientes_afectados_por_dia, { x: 'marca_fecha_presentada', y: "total_clientes_afectados", fill: d => (d.total_clientes_afectados >= service_threshold) ? 'red' : 'black', fillOpacity: d => (d.total_clientes_afectados >= service_threshold) ? .5 : 1, tip: true, interval: d3.utcDay}), // Plot.rectY(regionsWithoutService_daily_peak, // { filter: d => (d.type === 'totals') & (d.totalClientsWithoutService >= service_threshold), // x: d => new Date(d.timestamp_date_string), // y: "totalClientsWithoutService", // fill: 'red', fillOpacity: 0.5, // // stroke: 'red', strokeOpacity: 1.0, // tip: true, // interval: d3.utcDay}), Plot.ruleY([0]) ] }) }33:T9a4,{ const dataWidth = width; const marginLeft = 50; const marginRight = 50; const ultima_fecha = aq.from(clientes_afectados_por_dia) .rollup({ 'ultima_fecha': op.max('marca_fecha_presentada') }) .objects()[0]['ultima_fecha'] const xmr_data = xmr_clientes_afectados_por_dia[0] return Plot.plot({ width: dataWidth + marginLeft + marginRight, marginLeft, marginRight, marks: [ Plot.ruleY([0]), Plot.ruleY([100e3]), ver_xmr ? Plot.ruleY([xmr_data['X_mean']], { stroke: 'red', strokeWidth: 3, }) : null, ver_xmr ? Plot.ruleY([xmr_data['LPNL'], xmr_data['UPNL']], { stroke: 'blue', strokeWidth: 3, }) : null, ver_xmr ? Plot.text(['LPNL', 'UPNL', 'X_mean'], { x: d => ultima_fecha, y: d => xmr_data[d], text: d => d3.format(',.0f')(xmr_data[d]), lineAnchor: 'bottom', textAnchor: 'end', dy: -8, fontSize: 14, }) : null, ver_crudo ? Plot.line(clientes_afectados_por_dia_crudo, { x: 'marca_fecha_presentada', y: "total_clientes_afectados", //fill: d => (d.total_clientes_afectados >= service_threshold) ? 'red' : 'black', // fillOpacity: d => (d.total_clientes_afectados >= service_threshold) ? .5 : 1, marker: true, tip: true, stroke: 'red', interval: d3.utcDay}) : null, Plot.line(clientes_afectados_por_dia, { x: 'marca_fecha_presentada', y: "total_clientes_afectados", //fill: d => (d.total_clientes_afectados >= service_threshold) ? 'red' : 'black', // fillOpacity: d => (d.total_clientes_afectados >= service_threshold) ? .5 : 1, marker: true, tip: true, interval: d3.utcDay}), // Plot.rectY(regionsWithoutService_daily_peak, // { filter: d => (d.type === 'totals') & (d.totalClientsWithoutService >= service_threshold), // x: d => new Date(d.timestamp_date_string), // y: "totalClientsWithoutService", // fill: 'red', fillOpacity: 0.5, // // stroke: 'red', strokeOpacity: 1.0, // tip: true, // interval: d3.utcDay}), ] }) }34:T5ae,{ const dataWidth = width; const marginLeft = 50; const marginRight = 50; const ultima_fecha = aq.from(clientes_afectados_por_region_por_dia) .rollup({ 'ultima_fecha': op.max('marca_fecha_presentada') }) .objects()[0]['ultima_fecha'] return Plot.plot({ width: dataWidth + marginLeft + marginRight, marginLeft, marginRight, marks: [ Plot.ruleY([0]), Plot.line(clientes_afectados_por_region_por_dia, { x: 'marca_fecha_presentada', y: "total_clientes_sin_servicio", z: 'region', stroke: 'region', fy: 'region', //fill: d => (d.total_clientes_afectados >= service_threshold) ? 'red' : 'black', // fillOpacity: d => (d.total_clientes_afectados >= service_threshold) ? .5 : 1, marker: true, tip: true, interval: d3.utcDay}), // Plot.rectY(regionsWithoutService_daily_peak, // { filter: d => (d.type === 'totals') & (d.totalClientsWithoutService >= service_threshold), // x: d => new Date(d.timestamp_date_string), // y: "totalClientsWithoutService", // fill: 'red', fillOpacity: 0.5, // // stroke: 'red', strokeOpacity: 1.0, // tip: true, // interval: d3.utcDay}), ] }) }35:T44a,{ if (!historico_toggle) { return null; } return Plot.plot({ marginLeft: 80, y: { // domain: [0,1], // tickFormat: '%' }, marks: [ Plot.ruleY([0]), Plot.lineY(regions_service, { filter: d => (d.type == 'totals') , tip: false, // x: "timestamp", x: d => uniform_date(d.timestamp) , // x: d => d.timestamp.toLocaleString(undefined, { // "hour": "2-digit", // "minute": "2-digit" // }), y:"totalClientsWithoutService", z: 'timestamp_date_string', }), Plot.lineY(regions_service.filter(d => (d.type == 'totals') & (d.timestamp_date_string === latest_timestamp_date_string)), { filter: d => (d.type == 'totals') , tip: true, // x: "timestamp", x: d => uniform_date(d.timestamp) , // x: d => d.timestamp.toLocaleString(undefined, { // "hour": "2-digit", // "minute": "2-digit" // }), y:"totalClientsWithoutService", z: 'timestamp_date_string', stroke: 'blue', strokeWidth: 3, }), // Plot.Tip() ] })}36:Ted9,tabla_regiones = { let thedata = clientes_afectados_por_region_por_dia.filter(d => d.marca_fecha_presentada.getTime() === fecha_picker.getTime()) let totals_data = aq.from(thedata) .rollup({ 'total_clientes_sin_servicio': op.sum('total_clientes_sin_servicio'), 'total_clientes': op.sum('total_clientes'), }) .derive({ 'porcentaje_clientes_sin_servicio': aq.escape(d => d3.format('.2f')(d.total_clientes_sin_servicio / d.total_clientes * 100)), 'region': d => 'Total', 'marca_hora_presentada': d => null, }) .objects()[0] // return totals_data thedata = [...thedata, totals_data] let cols_show = ['region', 'total_clientes_sin_servicio', 'porcentaje_clientes_sin_servicio', 'total_clientes', 'marca_hora_presentada'] let headers = { 'region': 'Región', 'total_clientes_sin_servicio': 'Apagados', 'porcentaje_clientes_sin_servicio': '% Apagados', 'total_clientes': 'Clientes', 'marca_hora_presentada': 'Hora', } let formatters = { 'total_clientes_sin_servicio': d => d3.format(',.0f')(d), 'porcentaje_clientes_sin_servicio': d => `${d}%`, 'total_clientes': d => d3.format(',.0f')(d), 'marca_hora_presentada': d => d ? d3.utcFormat('%-I:%M %p')(d) : null, } let row_classes = { 'Total': 'bold', } let header_classes = { 'region': 'left-align', 'total_clientes_sin_servicio': 'right-align', 'porcentaje_clientes_sin_servicio': 'right-align', 'total_clientes': 'right-align', 'marca_hora_presentada': 'right-align', } let header_styles = { 'region': 'width: 10px;', 'total_clientes_sin_servicio': 'width: 100px;', 'porcentaje_clientes_sin_servicio': 'width: 100px;', 'total_clientes': 'width: 100px;', 'marca_hora_presentada': 'width: 80px;', } let classes = { 'region': 'left-align flex', 'total_clientes_sin_servicio': 'tabular-nums monospace', 'porcentaje_clientes_sin_servicio': 'tabular-nums monospace', 'total_clientes': 'tabular-nums monospace', 'marca_hora_presentada': 'tabular-nums monospace', } return htl.html` ${cols_show.map(c => htl.html``)} ${thedata.map((row) => htl.html` ${cols_show.map((col, icol) => htl.html`` )} ` )}

${headers[c] ?? c}
${icol === 0 ? htl.html`` : null} ${formatters[col] ? formatters[col](row[col]) : row[col]}

` }37:Tf99,daily_observations_chart = { let thedata = clientes_energizados_daychosen; let thedata_max = thedata[d3.maxIndex(thedata, d => d.total_clientes_sin_servicio)]; let themargins = { marginLeft: 10, marginRight: 0, // marginTop: 200, marginTop: 20, marginBottom: 40, } let the_width = chosen_width // Input params for dot_symbol_packing_X let chart_width = the_width - themargins.marginLeft - themargins.marginRight; // let num_points = thedata.length; let num_points = 288; const min_radius = 1; const max_radius = 3; // output const chosen_radius = dot_symbol_packing_X('circle', chart_width, num_points, min_radius, max_radius); // Input for rule width scaling const rule_padding = .95; const min_rule_width = 0; // output const fit_radius = chart_width / (num_points - 1) / 2; const fit_rule_width = fit_radius*2; const padded_rule_width = fit_rule_width * (1 - rule_padding); const chosen_rule_width = Math.max(min_rule_width, Math.min(padded_rule_width, 1)); let theplot = Plot.plot({ caption: `Radius: ${(chosen_radius)} Rule width: ${chosen_rule_width} Chart width: ${chart_width}`, style: "overflow: visible;", ...themargins, // marginLeft: 80, width: the_width, // width: 700, height: 600, // marginTop: 200, x: { domain: [fecha_picker, new Date(fecha_picker.getTime() + 1439*60000)], }, y: { domain: [0,100e3], // ticks: 5, // tickFormat: '%' }, r: {type: 'linear'}, marks: [ Plot.axisX({ fontFamily: 'Inter, sans-serif', }), Plot.axisY({ rotate: -90, textAnchor: 'middle', tickFormat: d => (d/1e3).toString() + ' mil', label: null, fontSize: 12, tickSize: 0, fontFamily: 'Inter, sans-serif', // ticks: 5, ticks: [25e3, 50e3, 75e3, 100e3], }), Plot.gridY({ strokeDasharray: "2", interval: 25e3, stroke: "black", strokeOpacity: 1}), // Plot.areaY( // thedata // , { // tip: false, // x: "marca_hora_presentada", // y1: d => d["total_clientes_sin_servicio"] >= service_threshold ? 0 : null, // y2: d => d["total_clientes_sin_servicio"] >= service_threshold ? d["total_clientes_sin_servicio"] : null, // fill: 'red', fillOpacity: 0.5, // curve: 'step-after' // //stroke: 'red', strokeOpacity: 1, // }), Plot.ruleX(thedata, { x: 'marca_hora_presentada', y: d => d.total_clientes_sin_servicio !== 0 ? d.total_clientes_sin_servicio : null, // strokeWidth: d => .2, strokeWidth: chosen_rule_width, }), Plot.ruleX(thedata, { x: 'marca_hora_presentada', y1: d => d.total_clientes_sin_servicio !== 0 ? Math.max(0, d.total_clientes_sin_servicio - stroke_length) : null, y2: d => d.total_clientes_sin_servicio !== 0 ? d.total_clientes_sin_servicio : null, // strokeWidth: d => .2, strokeWidth: 1, stroke: 'black', strokeLinecap: 'square', }), show_line ? Plot.line( thedata , { tip: false, x: "marca_hora_presentada", y:"total_clientes_sin_servicio", stroke: 'darkblue', strokeWidth: chosen_radius, channels: {noService: "porcentaje_clientes_sin_servicio", hora: 'marca_hora_presentada'}, }) : null, show_dot ? Plot.dot( thedata , { tip: true, x: "marca_hora_presentada", y:"total_clientes_sin_servicio", stroke: null, fill: 'black', r: chosen_radius, channels: {noService: "porcentaje_clientes_sin_servicio", hora: 'marca_hora_presentada'}, }) : null, Plot.text([thedata_max], { x: "marca_hora_presentada", y:"total_clientes_sin_servicio", fill: 'black', text: 'total_clientes_sin_servicio', lineAnchor: 'bottom', dy: -8, fontWeight: 'bold', fontSize: 14, fontFamily: 'B612 Mono', }), Plot.ruleY([0]), // Plot.Tip() ] }) return theplot }38:T401,with clientes_energizados_copy as ( select *, date_trunc('day', marca_hora_presentada) as marca_fecha_presentada, from clientes_energizados ), listado_marca_hora_presentada as ( select unnest(generate_series( (min(marca_fecha_presentada)::VARCHAR || ' 00:00:00')::DATETIME, (max(marca_fecha_presentada)::VARCHAR || ' 23:55:00')::DATETIME, interval 5 minute )) as marca_hora_presentada from clientes_energizados_copy order by marca_hora_presentada ), listado_marca_hora_y_fecha as ( select *, date_trunc('day', marca_hora_presentada) as marca_fecha_presentada, from listado_marca_hora_presentada ) select *, marca_hora_presentada <= max(marca_hora_presentada) filter (marca_hora_accedida is not null) over () as dato_publicado, case when not dato_publicado then false when marca_hora_accedida is not null then true else false end as dato_accedido, from listado_marca_hora_y_fecha left join clientes_energizados_copy using (marca_hora_presentada) order by marca_hora_presentada39:[{"id":"4ca1e7eaa7c8d39cba65033ef5c2f3ca5c9e0e7c253bb5f1a2f30a8527dc06dfbe6a20a1a43240007fef821323075c0fda0e95248e4cf445b0458e40796cca26","href":"https://static.observableusercontent.com/files/4ca1e7eaa7c8d39cba65033ef5c2f3ca5c9e0e7c253bb5f1a2f30a8527dc06dfbe6a20a1a43240007fef821323075c0fda0e95248e4cf445b0458e40796cca26","name":"clientes_energizados_por_region@1.parquet","type":"application/octet-stream","lastModified":1707262286708.335,"size":838270},{"id":"cff2eccf59e0cd12f17342cd796929738dbe1d2354a17300009f861669b33ae549d4dfcf607bb39b11246b6faf10332eca9f1b3dcbed88077d81d184bb4e4208","href":"https://static.observableusercontent.com/files/cff2eccf59e0cd12f17342cd796929738dbe1d2354a17300009f861669b33ae549d4dfcf607bb39b11246b6faf10332eca9f1b3dcbed88077d81d184bb4e4208","name":"clientes_energizados_por_region@2.parquet","type":"application/octet-stream","lastModified":1707301473319.078,"size":849845},{"id":"b64d6ca5b9852c2ce8a6582d3c2dc3582a26e4c9bb08b6718c381936f1bab354019ac57a8289fa190b0909ded1a5254b3394f42d3d83fb25a8e823046ef46e5b","href":"https://static.observableusercontent.com/files/b64d6ca5b9852c2ce8a6582d3c2dc3582a26e4c9bb08b6718c381936f1bab354019ac57a8289fa190b0909ded1a5254b3394f42d3d83fb25a8e823046ef46e5b","name":"clientes_energizados@3.parquet","type":"application/octet-stream","lastModified":1707313325503.47,"size":320002},{"id":"4dbe06a435a4b92039aeb28e21a7de40d29ea908dc47c9b050afe9e287a9e530c68c8281b1ca3094f2c1224c7274ee0339fd13e8379e6420c3e37fa16be2413c","href":"https://static.observableusercontent.com/files/4dbe06a435a4b92039aeb28e21a7de40d29ea908dc47c9b050afe9e287a9e530c68c8281b1ca3094f2c1224c7274ee0339fd13e8379e6420c3e37fa16be2413c","name":"clientes_energizados_por_region@3.parquet","type":"application/octet-stream","lastModified":1707313331787.525,"size":854027},{"id":"668a99904f21c10a6348b5a6a6d93460fff93ace7d9301de7d08c355d45127325f84ec254a702d4bf8fc27f2331d55a74683740ce26ac23d12e8dd1cbb076fbc","href":"https://static.observableusercontent.com/files/668a99904f21c10a6348b5a6a6d93460fff93ace7d9301de7d08c355d45127325f84ec254a702d4bf8fc27f2331d55a74683740ce26ac23d12e8dd1cbb076fbc","name":"image.png","type":"image/png","lastModified":1707487485008.469,"size":781446},{"id":"616701c107222129e4331dfe4e435c34cf48c08cb01c9a4d53f5899a63c24c854740c5fa9468bb3550d0fd3aa2d49b816f20ec7ded98def87d27fbde6b2e208a","href":"https://static.observableusercontent.com/files/616701c107222129e4331dfe4e435c34cf48c08cb01c9a4d53f5899a63c24c854740c5fa9468bb3550d0fd3aa2d49b816f20ec7ded98def87d27fbde6b2e208a","name":"image@1.png","type":"image/png","lastModified":1707487669181.51,"size":2284019},{"id":"d98431188207092a44cfa8723f8139adaccd4fbd90d83f6c091dd5b07a7c25602bdcd2f4446f888a5c1e6f2212b4239a200af030b4bb2d57e4b213b5ebcc9c7e","href":"https://static.observableusercontent.com/files/d98431188207092a44cfa8723f8139adaccd4fbd90d83f6c091dd5b07a7c25602bdcd2f4446f888a5c1e6f2212b4239a200af030b4bb2d57e4b213b5ebcc9c7e","name":"clientes_energizados_por_region.parquet","type":"application/octet-stream","lastModified":1706975890764.824,"size":771823},{"id":"3f720477311cf2ae8470dbe2ed58d9a0b7ec034bc36ce1d93140b13f89bc254a7bc9981abb7236294b1fc81c5696cf956ae73a764a27a17b3e67024d266ec4ab","href":"https://static.observableusercontent.com/files/3f720477311cf2ae8470dbe2ed58d9a0b7ec034bc36ce1d93140b13f89bc254a7bc9981abb7236294b1fc81c5696cf956ae73a764a27a17b3e67024d266ec4ab","name":"clientes_energizados.parquet","type":"application/octet-stream","lastModified":1706987209570.118,"size":293075},{"id":"ee28d23e73ca52b2e61ec0a520012ace2e945930d4a1f967aaae10cfa1aceab247db9d1028977fe7a1fa71568c8665760ccfea3195e7e8a0abccdf492fdff251","href":"https://static.observableusercontent.com/files/ee28d23e73ca52b2e61ec0a520012ace2e945930d4a1f967aaae10cfa1aceab247db9d1028977fe7a1fa71568c8665760ccfea3195e7e8a0abccdf492fdff251","name":"clientes_energizados@1.parquet","type":"application/octet-stream","lastModified":1707262275293.895,"size":315411},{"id":"79dde0b89accceda4543adb06af58d32f8a5ae3a07a766b067c8f923da16ffa9c53505a006391c9060ca05b4507a690f8b7b48860b2085b36f419c06e4128423","href":"https://static.observableusercontent.com/files/79dde0b89accceda4543adb06af58d32f8a5ae3a07a766b067c8f923da16ffa9c53505a006391c9060ca05b4507a690f8b7b48860b2085b36f419c06e4128423","name":"clientes_energizados@2.parquet","type":"application/octet-stream","lastModified":1707301478441.295,"size":318920},{"id":"32adfd8086ca701fc7262c3b14ad529c3fcfd855078b4aaf48175a478abbe5ba42b729c2b326b4f4fd72da37484d0f654a038926f3b01f2b708a0541d58949d4","href":"https://static.observableusercontent.com/files/32adfd8086ca701fc7262c3b14ad529c3fcfd855078b4aaf48175a478abbe5ba42b729c2b326b4f4fd72da37484d0f654a038926f3b01f2b708a0541d58949d4","name":"clientes_energizados@4.parquet","type":"application/octet-stream","lastModified":1707917565783.013,"size":367891},{"id":"859fddd60908fd2ca3ed15ec93b453e6560853ee4691d34cffd016e27ba1331faf5c03631ec23133588b31f870b4f0cdc43164497ca15052c7b166057863d2d6","href":"https://static.observableusercontent.com/files/859fddd60908fd2ca3ed15ec93b453e6560853ee4691d34cffd016e27ba1331faf5c03631ec23133588b31f870b4f0cdc43164497ca15052c7b166057863d2d6","name":"clientes_energizados_por_region@4.parquet","type":"application/octet-stream","lastModified":1707917577411.326,"size":991816}] 2f:{"id":"aa7dac380166d7b5","slug":null,"title":"Resumen de apagones (WIP)","thumbnail":"9e1c137756ee41662a9a012ac6f572fc0ca5cc9fae518feb018d4aaec969af61","access_level":"public","create_time":"$D2024-02-03T15:56:50.350Z","update_time":"$D2024-06-09T15:59:28.006Z","view_time":null,"first_public_time":"$D2024-02-03T15:56:50.350Z","fork":{"id":"3bd1064313a4d2c3","slug":null,"title":"Resumen de apagones (old)","owner":{"id":"247b19faa48b7d89","login":"jzavala-gonzalez","name":"José M. Zavala González"}},"stars":0,"starred":false,"owner":{"type":"team","id":"247b19faa48b7d89","login":"jzavala-gonzalez","name":"José M. Zavala González","avatar_url":"https://avatars-next.observableusercontent.com/c80357963553ac341ea90ed3d79296a72d004aa90d9b89afd76f17e04dcf9277","tier":"starter_2024"},"version":1993,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"2c62f0243f8f45b0","login":"jzavala-gonzalez","name":"José M. Zavala González","avatar_url":"https://avatars-next.observableusercontent.com/c80357963553ac341ea90ed3d79296a72d004aa90d9b89afd76f17e04dcf9277","tier":null}],"members":[{"type":"individual","id":"2c62f0243f8f45b0","login":"jzavala-gonzalez","name":"José M. Zavala González","avatar_url":"https://avatars-next.observableusercontent.com/c80357963553ac341ea90ed3d79296a72d004aa90d9b89afd76f17e04dcf9277","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Resumen de apagones (WIP)","cells":[{"id":0,"value":"# Resumen de apagones (WIP)\npara las últimas 24 horas","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":476,"value":"\nhtl.html`\n\n

Clientes afectados

\n${d3.max(clientes_energizados_dayago, d => d.total_clientes_sin_servicio).toLocaleString()}\n
\n
\n\n

Actualmente

\n${clientes_energizados_dayago.slice(-1)[0].total_clientes_sin_servicio.toLocaleString()} clientes sin servicio\n
\n
\n\n

Mejor momento

\n${d3.min(clientes_energizados_dayago, d => d.total_clientes_sin_servicio).toLocaleString()} clientes sin servicio\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":494,"value":"# Clientes sin servicio\nEn rojo estan los momentos cuando se superaron **${service_threshold.toLocaleString(\"en-US\")} clientes** sin luz","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":65,"value":"{\n\n let thedata = clientes_energizados\n let theplot = Plot.plot({\n marginLeft: 80,\n width,\n y: {\n // domain: [0,1],\n // tickFormat: '%'\n },\n marks: [\n \n \n \n Plot.lineY(\n thedata\n , {\n tip: true,\n x: \"marca_hora_presentada\", y:\"total_clientes_sin_servicio\",\n channels: {noService: \"porcentaje_clientes_sin_servicio\"},\n }),\n\n Plot.areaY(\n thedata\n , {\n tip: false,\n x: \"marca_hora_presentada\",\n y1: d => d[\"total_clientes_sin_servicio\"] >= service_threshold ? 0 : null,\n y2: d => d[\"total_clientes_sin_servicio\"] >= service_threshold ? d[\"total_clientes_sin_servicio\"] : null,\n fill: 'red', fillOpacity: 0.5,\n //stroke: 'red', strokeOpacity: 1,\n }),\n Plot.ruleY([0]),\n // Plot.Tip()\n ]\n})\n\n return theplot\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1294,"value":"{\n\n let thedata = clientes_energizados_daychosen\n let theplot = Plot.plot({\n marginLeft: 80,\n width,\n y: {\n // domain: [0,1],\n // tickFormat: '%'\n },\n marks: [\n \n \n \n Plot.lineY(\n thedata\n , {\n tip: true,\n x: \"marca_hora_presentada\", y:\"total_clientes_sin_servicio\",\n channels: {noService: \"porcentaje_clientes_sin_servicio\", hora: 'marca_hora_presentada'},\n }),\n\n Plot.areaY(\n thedata\n , {\n tip: false,\n x: \"marca_hora_presentada\",\n y1: d => d[\"total_clientes_sin_servicio\"] >= service_threshold ? 0 : null,\n y2: d => d[\"total_clientes_sin_servicio\"] >= service_threshold ? d[\"total_clientes_sin_servicio\"] : null,\n fill: 'red', fillOpacity: 0.5,\n //stroke: 'red', strokeOpacity: 1,\n }),\n Plot.ruleY([0]),\n // Plot.Tip()\n ]\n})\n\n return theplot\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":899,"value":"viewof service_threshold = Inputs.range([1000, 50000], {label: \"Sin luz\", step: 1000, value: 10000})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":845,"value":"## Histórico","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":855,"value":"viewof historico_toggle = Inputs.toggle({label: \"Ver historico:\", value: true})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1070,"value":"{\n const num_obs = regions_service_total.length;\n const num_obs_above_threshold = regions_service_total.filter(d => d.totalClientsWithoutService >= service_threshold).length;\n const pct_obs_above_threshold = num_obs_above_threshold / num_obs;\n \n return htl.html`\nHay ${num_obs_above_threshold.toLocaleString(\"en-US\")} de ${num_obs.toLocaleString(\"en-US\")} observaciones (${pct_obs_above_threshold.toLocaleString(undefined,{style: 'percent', minimumFractionDigits:0})}) con al menos ${service_threshold.toLocaleString(\"en-US\")} clientes tolerando apagones\n`\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":924,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1044,"value":"{\n const num_days = regionsWithoutService_daily_peak_total.length;\n const num_days_above_threshold = regionsWithoutService_daily_peak_total.filter(d => d.totalClientsWithoutService >= service_threshold).length;\n const pct_days_above_threshold = num_days_above_threshold / num_days;\n \n return htl.html`\nHay ${num_days_above_threshold} de ${num_days} dias (${pct_days_above_threshold.toLocaleString(undefined,{style: 'percent', minimumFractionDigits:0})}) con al menos ${service_threshold.toLocaleString(\"en-US\")} clientes tolerando apagones\n`\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1006,"value":"$32","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1257,"value":"viewof ver_crudo = Inputs.toggle({label: \"Ver crudo\", value: false})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1270,"value":"viewof ver_xmr = Inputs.toggle({label: \"Ver XMR\", value: true})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1203,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1925,"value":"{\n let thedata = clientes_afectados_por_dia\n .map(d => Object({\n fecha: d3.utcFormat('%Y-%m-%d')(d.marca_fecha_presentada),\n total_clientes_afectados: d.total_clientes_afectados,\n }))\n\n return aq.from(thedata).view(1000)\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1989,"value":"Plot.plot({\n width,\n marks: [\n Plot.ruleY([0]),\n Plot.lineY(saidi_minutos, {\n x: \"marca_dia_presentada\", y: \"saidi_minutos\", marker: true, tip: true})\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1943,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":886,"value":"viewof region_ver = Inputs.select(['Arecibo', 'Bayamon', 'Caguas','Carolina','Mayaguez','Ponce','San Juan'], {label: \"Elige una region:\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1956,"value":"{\n let thedata = clientes_afectados_por_region_por_dia\n .filter(d => d.region === region_ver)\n .map(d => Object({\n fecha: d3.utcFormat('%Y-%m-%d')(d.marca_fecha_presentada),\n total_clientes_afectados: d.total_clientes_sin_servicio,\n }))\n\n return aq.from(thedata).view(1000)\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1939,"value":"clientes_afectados_por_region_por_dia","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1077,"value":"Plot.plot({\n marginLeft: 50,\n y: {\n domain: [0, 60e3]\n },\n marks: [\n Plot.boxY(\n regions_service_total,\n {\n x: \"timestamp_hour\",\n y: \"totalClientsWithoutService\",\n tip: true,\n }\n )\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":978,"value":"Azul es lo que va de hoy. Lo demás son días anteriores.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":162,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1096,"value":"Plot.plot({\n // height: 640,\n marginLeft: 60,\n y: {\n // domain: [0, 100e3]\n },\n color: {\n legend: true,\n scheme: \"YlGnBu\",\n type: \"symlog\"\n },\n marks: [\n Plot.rect(regions_service_total, Plot.bin({fill: \"count\"}, {\n x: d => uniform_date(d.timestamp),\n // x: 'timestamp_hour', //interval: 1,\n y: \"totalClientsWithoutService\",\n thresholds: 100,\n }))\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":842,"value":"## Por región","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":81,"value":"Plot.plot({\n marginRight: 100,\n width,\n y: {\n // domain: [0,1],\n tickFormat: d => `${d}%`\n },\n marks: [\n Plot.ruleY([0]),\n Plot.lineY(\n clientes_energizados_por_region,\n //.filter(d => (d.marca_hora_presentada >= a_day_ago)),\n {\n tip: true,\n x: \"marca_hora_presentada\",\n y: \"porcentaje_clientes_sin_servicio\",\n fy: 'region',\n stroke: 'region',\n channels: {noService: \"total_clientes_sin_servicio\", },\n }),\n \n // Plot.Tip()\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1296,"value":"Plot.plot({\n marginRight: 100,\n width,\n y: {\n // domain: [0,1],\n tickFormat: d => `${d}%`\n },\n marks: [\n Plot.ruleY([0]),\n Plot.lineY(\n clientes_energizados_por_region_dayago,\n //.filter(d => (d.marca_hora_presentada >= a_day_ago)),\n {\n tip: true,\n x: \"marca_hora_presentada\",\n y: \"porcentaje_clientes_sin_servicio\",\n fy: 'region',\n stroke: 'region',\n channels: {noService: \"total_clientes_sin_servicio\", hora: d => d['marca_hora_presentada'] },\n }),\n \n // Plot.Tip()\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":884,"value":"Plot.plot({\n marginRight: 100,\n width,\n height: 600,\n y: {\n domain: [0,1000],\n // tickFormat: d => `${d}%`\n },\n marks: [\n Plot.ruleY([0]),\n Plot.lineY(\n regions_service.filter(d => (d.timestamp >= a_day_ago) & (d.region_name === region_ver)),\n {\n tip: true,\n x: \"timestamp\",\n // y: \"percentageClientsWithoutService\",\n y: \"totalClientsWithoutService\",\n fy: 'region_name',\n stroke: 'region_name',\n channels: {noService: \"totalClientsWithoutService\", noService2: 'percentageClientsWithoutService'},\n }),\n \n // Plot.Tip()\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1407,"value":" $\"image@1.png\"$ ","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1314,"value":"viewof fecha_picker = Inputs.date({label: \"Fecha\",\n // value: \"2024-02-06\",\n value: d3.timeFormat('%Y-%m-%d')(new Date()),\n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1749,"value":"d3.timeFormat('%Y-%m-%d')(new Date())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1743,"value":"new Date().toDateString()//.slice(0,10)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1322,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1604,"value":"width","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1647,"value":"viewof show_dot = Inputs.toggle({label: \"Dot\", value: true})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1630,"value":"viewof show_line = Inputs.toggle({label: \"Outline\", value: false})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1643,"value":"viewof stroke_length = Inputs.range([0, 5e3], {label: \"Stroke length\", step: 500, value: 1000})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1674,"value":"viewof chosen_width = Inputs.range([0, width], {label: \"Total width\", step: 1, value: width})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1536,"value":"$37","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1576,"value":"fecha_picker","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1879,"value":"{\n let thedata = clientes_energizados_daychosen_filled.filter(d => d.dato_publicado);\n\n const total_obs = thedata.length;\n const num_retrieved_obs = thedata.filter(d => d.dato_accedido).length\n const num_lost_obs = total_obs - num_retrieved_obs;\n const retrieved_pct = num_retrieved_obs/total_obs\n\n return htl.html`\n

Observaciones capturadas: ${num_retrieved_obs} / ${total_obs}\n
(${d3.format('.1%')(retrieved_pct)})

\n\n `\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1752,"value":"Plot.plot({\n marginLeft: 60,\n marginBottom: 40,\n color: {\n legend: true,\n },\n x: {\n label: 'Minuto',\n domain: [0, 5, 10, 15, 20, 25, 30, 35, 40, 45, 50, 55],\n tickSize: 0,\n },\n y: {\n label: 'Hora',\n interval: 1, ticks: 24,\n tickSize: 0,\n domain: [... new Array(24)].map((d,i) => i),\n tickFormat: d => {\n let label = d;\n if (d === 0) {\n label = '12 AM' \n } else if (d === 12) {\n label = '12 PM'\n } else if (d > 12) {\n label = d - 12\n }\n return label;\n },\n },\n marks: [\n Plot.cell(clientes_energizados_daychosen_filled, {\n x: d => d.marca_hora_presentada.getMinutes(),\n y: d => d.marca_hora_presentada.getUTCHours(),\n fill: d => {\n if (!d.dato_publicado) {return '#efefef'} else if (d.marca_hora_accedida !== null)\n {return 'green'} else {\n return '#bb0000'\n }\n //return \n },\n //stroke: 'dato_publicado',\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1718,"value":"clientes_energizados_daychosen[d3.maxIndex(clientes_energizados_daychosen, d => d.total_clientes_sin_servicio)]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1435,"value":"region_colors = Object({\n 'Arecibo': '#ffe1d3',\n 'Bayamon': '#ffb0b6',\n 'Caguas': '#fddafd',\n 'Carolina': '#d9e4fe',\n 'Mayaguez': '#d7eeff',\n 'Ponce': '#fffad3',\n 'San Juan': '#dafed1',\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1703,"value":"estilos = htl.html`\n\n`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1517,"value":"","pinned":true,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":832,"value":"# Apéndice","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1941,"value":"import lz77 from \"lz77\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1594,"value":"function dot_symbol_packing_X(symbol, chart_width, num_points, min_radius, max_radius) {\n\n // Calculations\n const fit_radius = chart_width / (num_points - 1) / 2;\n\n // Outputs\n const chosen_radius = Math.max(min_radius, Math.min(fit_radius, max_radius))\n \n return chosen_radius * symbol_packing_scale_factors[symbol]\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1587,"value":"symbol_packing_scale_factors = Object({\n 'circle': 1, // default. 'r' maps to circle radius\n 'square': 1.1275, // 'r' maps to half a side length, after scaling\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":916,"value":"regions_service","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":926,"value":"regions_service_total = regions_service.filter(d => d.type === 'totals')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1038,"value":"regionsWithoutService_daily_peak_total = regionsWithoutService_daily_peak.filter(d => d.type === 'totals')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":929,"value":"import {m4} from \"@uwdata/m4-scalable-time-series-visualization\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":20,"value":"// regions_service = d3.csvParse(datastring, d => {\n// const dauto = d3.autoType(d);\n// dauto['timestamp_saved'] = new Date(parsePRDate(dauto['timestamp_saved']) ) // idk whats up w this one\n// dauto['timestamp'] = new Date(parsePRDate(dauto['timestamp']) ) // read as PR time (GMT-4). All set (?)\n// dauto['region_name'] = dauto['region_name'] === null ? 'totals' : dauto['region_name']\n// dauto['timestamp_date_string'] = dauto['timestamp'].toLocaleString(undefined, {\n// \"year\": \"numeric\",\n// \"month\": \"2-digit\",\n// \"day\": \"2-digit\",\n// timeZone: 'UTC', // so much pain\n// })\n// return dauto;\n// })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":15,"value":"// datastring = fetch(\"https://raw.githubusercontent.com/jzavala-gonzalez/scraping-luma/main/regionsWithoutService_historical.csv\").then((response) => response.text())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":473,"value":"clientes_energizados_por_region_dayago = clientes_energizados_por_region.filter(d => (d.marca_hora_presentada >= a_day_ago))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1161,"value":"clientes_energizados_dayago = clientes_energizados.filter(d => (d.marca_hora_presentada >= a_day_ago))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1527,"value":"clientes_energizados_daychosen = clientes_energizados.filter(d => d.marca_fecha_presentada.getTime() === fecha_picker.getTime())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1851,"value":"clientes_energizados_daychosen_filled = clientes_energizados_filled.filter(d => d.marca_fecha_presentada.getTime() === fecha_picker.getTime())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1855,"value":"clientes_energizados_filled.filter(d => d.marca_fecha_presentada === null)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1756,"value":"with listado_marca_hora_presentada as (\nselect\n unnest(generate_series(\n (marca_fecha_presentada::VARCHAR || ' 00:00:00')::DATETIME,\n (marca_fecha_presentada::VARCHAR || ' 23:55:00')::DATETIME,\n interval 5 minute\n )) as marca_hora_presentada\nfrom (from clientes_energizados_daychosen limit 1)\n)\n\n\n-- from listado_marca_hora_presentada\n-- left join\n-- clientes_energizados_daychosen\n-- using (marca_hora_presentada)\n-- order by marca_hora_presentada\n\nfrom clientes_energizados_daychosen","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"","database":"var:clientes_energizados_daychosen"},{"id":1975,"value":"select\n unnest(generate_series(\n (marca_fecha_presentada::VARCHAR || ' 00:00:00')::DATETIME,\n (marca_fecha_presentada::VARCHAR || ' 23:55:00')::DATETIME,\n interval 5 minute\n )) as marca_hora_presentada\nfrom (from clientes_energizados_daychosen limit 1)","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"","database":"var:clientes_energizados_daychosen"},{"id":210,"value":"latest_timestamp = d3.max(clientes_afectados_por_dia, d => d.marca_fecha_presentada)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":426,"value":"latest_timestamp_date_string = latest_timestamp.toLocaleString(undefined, {\n \"year\": \"numeric\",\n \"month\": \"2-digit\",\n \"day\": \"2-digit\",\n timeZone: 'UTC', // so much pain\n })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":251,"value":"a_day_ago = new Date(getUTCTime(new Date(Date.now() - ms_per_hour*24)) - ms_per_hour*4)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":407,"value":"ms_per_hour = 3_600_000","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":692,"value":"function range(n) { return Array.from(Array(n).keys()) }","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":264,"value":"function getUTCTime(date) {\n let now_utc = Date.UTC(date.getUTCFullYear(), date.getUTCMonth(),\n date.getUTCDate(), date.getUTCHours(),\n date.getUTCMinutes(), date.getUTCSeconds());\n return now_utc\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":38,"value":"function parseUTCDate(datestring) {\n let date = new Date(datestring);\n return getUTCTime(date);\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":99,"value":"function parsePRDate(datestring) {\n let now_utc = parseUTCDate(datestring);\n return now_utc - 3_600_000*4;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":92,"value":"(parseUTCDate(\"07/21/2023 04:23 AM\"))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":94,"value":"new Date(parseUTCDate(\"07/21/2023 04:23 AM\"))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":101,"value":"new Date(parsePRDate(\"07/21/2023 04:23 AM\"))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":192,"value":"uniform_date(sample_date)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":201,"value":"function uniform_date(date) {\n return new Date(Date.UTC(0, 0,\n 1, date.getUTCHours(),\n date.getUTCMinutes(), date.getUTCSeconds()) + 14_400_000*0)\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":195,"value":"sample_date = regions_service[0].timestamp","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":321,"value":"import {aq, op} from \"@uwdata/arquero\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1157,"value":"select *,\n date_trunc('day', marca_hora_presentada) as marca_fecha_presentada,\nfrom clientes_energizados\n-- order by marca_hora_presentada","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"clientes_energizados","database":"var:dbref"},{"id":1787,"value":"$38","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"clientes_energizados_filled","database":"var:dbref"},{"id":1142,"value":"from clientes_energizados_por_region","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"","database":"var:dbref"},{"id":862,"value":"// dbref = DuckDBClient.of({\n// 'clientes_energizados': FileAttachment(\"clientes_energizados@4.parquet\"),\n// 'clientes_energizados_por_region': FileAttachment(\"clientes_energizados_por_region@4.parquet\"),\n// })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1694,"value":"// dbempty = new DuckDBClient(db_instance)\ndbempty = DuckDBClient.of({})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1696,"value":"dbref = dbempty, (\nawait dbempty.query(`\ncreate or replace table clientes_energizados_por_region as (\n from read_parquet('${bucket_url}/datasets/clientes_energizados_por_region.parquet')\n)\n`)\n),\n(\nawait dbempty.query(`\ncreate or replace table clientes_energizados as (\n from read_parquet('${bucket_url}/datasets/clientes_energizados.parquet')\n)\n`)\n),\ndbempty","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":867,"value":"// loadquery = await dbref.query(`\n// CREATE OR REPLACE TABLE regionsWithoutService AS (\n\n// with initial_table as (\n// SELECT\n// strptime(timestamp_saved, '%m/%d/%Y %I:%M %p') as timestamp_saved,\n// strptime(timestamp, '%m/%d/%Y %I:%M %p') as timestamp,\n// type,\n// region_name,\n// totalClients,\n// totalClientsWithoutService,\n// totalClientsWithService,\n// percentageClientsWithoutService,\n// percentageClientsWithService\n// FROM read_parquet('https://raw.githubusercontent.com/jzavala-gonzalez/scraping-luma/main/regionsWithoutService_historical.parquet')\n// )\n\n// select *,\n// strftime(timestamp, '%m/%d/%Y') as timestamp_date_string,\n// date_part('hour', timestamp) as timestamp_hour,\n// from initial_table\n// )\n// `)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1172,"value":"from clientes_afectados_por_dia","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"clientes_afectados_por_dia","database":"var:datadb"},{"id":1962,"value":"select\n date_trunc('day', marca_hora_presentada) as marca_dia_presentada,\n sum(\"total_clientes_sin_servicio\")::FLOAT as cliente_observaciones_sin_servicio,\n max(total_clientes) as \"total_clientes_suplidos\",\n (cliente_observaciones_sin_servicio / total_clientes_suplidos) as saidi_observaciones,\n round(saidi_observaciones * 5, 2) as saidi_minutos, -- 5 minutos per observacion\nfrom clientes_energizados\n-- where\n-- date_part('year', marca_hora_presentada) = 2024\n-- and date_part('month', marca_hora_presentada) <= 3\ngroup by marca_dia_presentada\norder by marca_dia_presentada","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"saidi_minutos","database":"var:datadb"},{"id":988,"value":"dailyquery = //loadquery,\n(await dbref.query(`\nCREATE OR REPLACE TABLE clientes_afectados_por_dia AS (\n\nwith extra_data as (\nselect *,\n date_trunc('day', marca_hora_presentada) as marca_fecha_presentada,\n ( max(total_clientes_sin_servicio) over (partition by \"marca_fecha_presentada\", \"region\")) as the_worst\nfrom clientes_energizados_por_region\n),\n\nonly_the_worst as (\n\nselect distinct on (marca_fecha_presentada, region) * exclude the_worst\nfrom extra_data\nwhere total_clientes_sin_servicio = the_worst\norder by marca_fecha_presentada, region, marca_hora_presentada -- NOTE: no deberiamos tener duplicados de marca_fecha en caso que mas de una hora presentada tengan el mismo valor\n)\n\nselect\n marca_fecha_presentada,\n -- total_clientes_sin_servicio,\n sum(total_clientes_sin_servicio)::INTEGER as total_clientes_afectados\nfrom only_the_worst\ngroup by marca_fecha_presentada\n)\n`))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1309,"value":"from clientes_afectados_por_region_por_dia","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"clientes_afectados_por_region_por_dia","database":"var:datadb"},{"id":1306,"value":"query_clientes_afectados_por_region_por_dia = //loadquery,\n(await dbref.query(`\nCREATE OR REPLACE TABLE clientes_afectados_por_region_por_dia AS (\n\nwith extra_data as (\nselect *,\n date_trunc('day', marca_hora_presentada) as marca_fecha_presentada,\n ( max(total_clientes_sin_servicio) over (partition by \"marca_fecha_presentada\", \"region\")) as the_worst\nfrom clientes_energizados_por_region\n),\n\nonly_the_worst as (\n\nselect distinct on (marca_fecha_presentada, region) * exclude the_worst\nfrom extra_data\nwhere total_clientes_sin_servicio = the_worst\norder by marca_fecha_presentada, region, marca_hora_presentada -- NOTE: no deberiamos tener duplicados de marca_fecha en caso que mas de una hora presentada tengan el mismo valor\n)\n\nselect\n *\nfrom only_the_worst\n)\n`))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1225,"value":"from xmr_clientes_afectados_por_dia","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"xmr_clientes_afectados_por_dia","database":"var:datadb"},{"id":1222,"value":"xmr_clientes_afectados_por_dia_query = dailyquery,\n(await dbref.query(`\nCREATE OR REPLACE TABLE xmr_clientes_afectados_por_dia AS (\n\nwith sorted_data as (\n select\n marca_fecha_presentada as order_variable,\n total_clientes_afectados as X\n from clientes_afectados_por_dia\n order by order_variable\n),\n\nxmr as (\nselect\n order_variable,\n X,\n abs(X - lag(X) over ()) as mR,\n mean(X) over () as X_mean,\nfrom sorted_data\n)\n\nselect\n *,\n mean(mR) over () as mR_mean,\ncase when (X_mean - 2.66*mR_mean) > 0 THEN (X_mean - 2.66*mR_mean) else 0 end as LPNL,\n X_mean + 2.66*mR_mean as UPNL,\n mR_mean*3.269 as URL,\nfrom xmr\n)\n`))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1213,"value":"from clientes_afectados_por_dia_crudo","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"clientes_afectados_por_dia_crudo","database":"var:datadb"},{"id":1211,"value":"dailyquery_crudo = //loadquery,\n(await dbref.query(`\nCREATE OR REPLACE TABLE clientes_afectados_por_dia_crudo AS (\n\nwith extra_data as (\nselect *,\n date_trunc('day', marca_hora_presentada) as marca_fecha_presentada,\n ( max(total_clientes_sin_servicio) over (partition by \"marca_fecha_presentada\")) as the_worst\nfrom clientes_energizados\n),\n\nonly_the_worst as (\n\nselect distinct on (marca_fecha_presentada) * exclude the_worst\nfrom extra_data\nwhere total_clientes_sin_servicio = the_worst\norder by marca_fecha_presentada, marca_hora_presentada\n)\n\nselect\n marca_fecha_presentada,\n -- total_clientes_sin_servicio,\n sum(total_clientes_sin_servicio)::INTEGER as total_clientes_afectados\nfrom only_the_worst\ngroup by marca_fecha_presentada\n)\n`))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1692,"value":"bucket_url = 'https://numeros-luzpr.com' // smh","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":873,"value":"datadb = dailyquery_crudo, dailyquery, query_clientes_afectados_por_region_por_dia, xmr_clientes_afectados_por_dia_query, dbref","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":876,"value":"select 2 as two;\n-- select *\n-- from clientes_energizados_por_region","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"very_old","database":"var:dbref"},{"id":1665,"value":"clientes_energizados_por_region = dbref.sql`from clientes_energizados_por_region;`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":998,"value":"select *\nfrom regionsWithoutService_daily_peak","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"regionsWithoutService_daily_peak","database":"var:datadb"},{"id":1132,"value":"regions_service[0]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1966,"value":"duckdb = import(\n \"https://cdn.jsdelivr.net/npm/@duckdb/duckdb-wasm@1.28.1-dev106.0/+esm\"\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1968,"value":"bundle = {\n const bundles = duckdb.getJsDelivrBundles()\n const duckdb_bundle = 'Auto';\n if (duckdb_bundle === 'Auto') {\n return duckdb.selectBundle(bundles)\n } else {\n const bun = bundles[duckdb_bundle]\n bun['pthreadWorker'] = null;\n return bun;\n }\n // return bundles['mvp']\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1970,"value":"async function makeDB() {\n const logger = new duckdb.ConsoleLogger();\n const worker = await duckdb.createWorker(bundle.mainWorker);\n const db = new duckdb.AsyncDuckDB(logger, worker);\n await db.instantiate(bundle.mainModule);\n return db\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1972,"value":"db_instance = makeDB()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W39","stdlib":"1","titling":"auto"}} 30:"$2f:body"

Clientes afectados

Actualmente

Mejor momento

Observaciones capturadas: ${num_retrieved_obs} / ${total_obs}\n(${d3.format('.1%')(retrieved_pct)})

Observaciones capturadas: ${num_retrieved_obs} / ${total_obs}\n
(${d3.format('.1%')(retrieved_pct)})