The avatar for @cajazeiraramos
Alexandre R. Cajazeira Ramos
Mestre em Ciência da Computação (UFC / MDCC), Especialista em Gestão de TI (UCAM) e Bacharel em Sistemas de Informação (UFPI / CSHNB). Atualmente é Cientista de Dados na central de jornalismo de dados do O POVO - DATADOC.
Public
Edited
Aug 31, 2024
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
lista_abrangencia
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
downloadPesquisas = DOM.download(
new Blob([d3
.dsvFormat(';')
.format(pesquisas_download)
.trim()], { type: "text/csv" }),
"Agg_DATADOC_OPOVO.csv",
'Pesquisas'
)
//DOM.download(serializeCSV(pesquisas_download), "Agg_DATADOC_OPOVO", 'Pesquisas')
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
medias_simples = {
const gpCandidatos = groupBy(dataset, 'Candidatov2');
var dataSet_medias = []
Object.entries(gpCandidatos).forEach(c=>{
const gpData = groupBy(c[1], 'data');
days.forEach(day => {
if(!gpData[day])
gpData[day] = [];
});
const ordered = Object.keys(gpData)
.sort(ord)
.reduce(
(obj, key) => {
obj[key] = gpData[key];
return obj;
},
{}
);

Object.keys(ordered).forEach(r=>{
if(ordered[r].length > 0){
ordered[r] = [d3.mean(ordered[r].map(d=> d['Pontuação (%)'])),ordered[r].length];
}else{
// Nesta linha, é necessário verificar: Há quantos dias estamos usando o valor do dia anterior? Se isso superar o tempo da média, precisamos zerar...
ordered[r] = ordered[d3.timeDay.offset(new Date(r),-1)]? ordered[d3.timeDay.offset(new Date(r),-1)]:[0,0];
}
});
function ord(a,b) {
return new Date(a) - new Date(b);
}
dataSet_medias.push({'candidato':c[0], 'resultados':Object.entries(ordered)});
})

return dataSet_medias;
}
Insert cell
media_movel = {
var df = [];
Object.values(medias_simples).forEach(d => {
d.resultados.forEach((r,i) => {
const date = new Date(r[0]);
// , day = (date.getTime() - dayExtent[0].getTime()) / (1000 * 3600 * 24);
var mediaMovel = 0;
if(i>mMovel){
// var contPesos = 0, somaMedias = 0;
mediaMovel = media_ponderada(d.resultados.slice(i-mMovel, i).map(p => p[1]));
if(i>= 14 && i < 20){
console.log(i)
console.log(mediaMovel)
console.log(d.resultados.slice(i-mMovel, i).map(p => p[1]));
}
if(mediaMovel)
df.push({'Candidato':d.candidato,'data':date,'Media':r[1][0],'mMovel':mediaMovel});
else
df.push({'Candidato':d.candidato,'data':date,'Media':r[1][0],'mMovel':0});
// df.push({'Candidato':d.candidato,'data':date,'Media':r[1][0],'mMovel':mediaMovel});
}
else{
df.push({'Candidato':d.candidato,'data':date,'Media':r[1][0],'mMovel':r[1][0]});
// df.push({'Candidato':d.candidato,'data':date,'Media':r[1][0],'mMovel':r[1][0]});
}
});
});

return df
};
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Type JavaScript, then Shift-Enter. Ctrl-space for more options. Arrow ↑/↓ to switch modes.

Insert cell
Insert cell
Insert cell
btn_downloadSVG2 = svgDownloadButton(grafico2)
Insert cell
Insert cell
Insert cell
Insert cell
media_movel_download_2T = {
const formatDate = d3.timeFormat("%d/%m/%Y");
var dataset = [];
Object.entries(groupBy(media_movel_2T, 'data'))
.forEach(d=>
{
var dict = {'data':formatDate(new Date(d[0]))}
d[1].forEach(c=>{
dict[c.Candidato] = ""+c.mMovel;
})
dataset.push(dict);
});
return dataset;
}
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
// resultados_aprovacao_avaliacao = gSheetsResultadosBR.filter(d=>d.Cargo == "Presidente" && d.Turno == "")
avaliacao = {
var dataset = gSheetsResultadosBR.filter(d => cenarios_avalicao.indexOf(d['Cenário']) > -1);
dataset.forEach(d => {

d.data =formatTime(data_pesquisa.get(d.Pesquisa));
d['Pontuação (%)'] = +d['Pontuação (%)'];
var string = d.Candidato.toLowerCase();

if(string.includes('ruim') || string.includes('péssima')|| string.includes('péssimo')) {d.Candidatov2 = 'Ruim ou Péssimo'}
else if(string.includes('não sabe') || string.includes('não s')) { d.Candidatov2 = 'Não sabem ou não responderam'}
else if(string.includes('òtimo') ||string.includes('ótimo') || string.includes('bom') || string.includes('ótima') || string.includes('boa') ) { d.Candidatov2 = 'Bom ou Ótimo'}
else { d.Candidatov2 = d.Candidato;}

d.objPesquisa = getPesquisa.get(d['Pesquisa']);
})
return dataset;
}
Insert cell
aprovacao = {
var dataset = gSheetsResultadosBR.filter(d => cenarios_aprovacao.indexOf(d['Cenário']) > -1 && d['Candidato'] != 'Bolsonaro');
dataset.forEach(d => {
d.data =formatTime(data_pesquisa.get(d.Pesquisa));
d['Pontuação (%)'] = +d['Pontuação (%)'];
var string = d.Candidato.toLowerCase();
d.Candidatov2 = classifica_aprovacao(string);
d.objPesquisa = getPesquisa.get(d['Pesquisa']);
})
return dataset.filter(d=> d.objPesquisa);
}
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
// viewof abrangencia = Inputs.select([... new Set(resultados.map(d=> dict_siglas[d.objPesquisa['Âmbito'].toUpperCase()]))], {sort: false, unique: true, label: "Abrangência: "})
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell

One platform to build and deploy the best data apps

Experiment and prototype by building visualizations in live JavaScript notebooks. Collaborate with your team and decide which concepts to build out.
Use Observable Framework to build data apps locally. Use data loaders to build in any language or library, including Python, SQL, and R.
Seamlessly deploy to Observable. Test before you ship, use automatic deploy-on-commit, and ensure your projects are always up-to-date.
Learn more