// Função para resumir uma única coluna SummarizeColumn = (data, col) => { let content, value, format, finiteFormat, el, chart, missing_label, pct_missing, min, max, median, mean, sd; const notFiniteFormat = d3.format(",.0f"); // Construir conteúdo com base no tipo const type = getType(data, col); const col1 = htl.html`${icon_fns[ type ]()}${ col === "" ? "sem rótulo" : col }`; switch (type) { // Colunas categóricas case "ordinal": format = d3.format(",.0f"); // Calcular percentagem e contagem da categoria const categories = d3 .rollups( data, (v) => ({ count: v.length, pct: v.length / data.length || 1 }), (d) => d[col] ) .sort((a, b) => b[1].count - a[1].count) .map((d) => { let obj = {}; obj[col] = d[0] === null || d[0] === "" ? "(ausente)" : d[0]; obj.count = d[1].count; obj.pct = d[1].pct; return obj; }); // Calcular percentagem ausente pct_missing = data.filter((d) => d[col] === null || d[col] === "").length / data.length; // Criar o gráfico const stack_chart = SmallStack(categories, col); // Elemento a ser retornado el = htl.html` ${col1}

${stack_chart}

${pct_format(pct_missing)} - - - `; value = { column: col, type, min: null, max: null, mean: null, median: null, sd: null, missing: pct_missing, n_categories: categories.length }; break; // Colunas de data case "data": // Calcular e formatar início / fim const start = d3.min(data, (d) => +d[col]); const end = d3.max(data, (d) => +d[col]); mean = d3.mean(data, (d) => +d[col]); median = d3.median(data, (d) => +d[col]); sd = d3.deviation(data, (d) => +d[col]); // Calcular percentagem ausente pct_missing = data.filter((d) => d[col] === null || d[col] === "").length / data.length; chart = Histogram(data, col, type); // Elemento a ser retornado el = htl.html` ${col1}

${chart}

${pct_format(pct_missing)} - - - `; value = { column: col, type, min: start, max: end, mean: null, median: null, sd: null, missing: pct_missing, n_categories: null }; break; // Colunas contínuas default: // Calcular valores min = d3.min(data, (d) => +d[col]); max = d3.max(data, (d) => +d[col]); mean = d3.mean(data, (d) => +d[col]); median = d3.median(data, (d) => +d[col]); sd = d3.deviation(data, (d) => +d[col]); if (Number.isFinite(sd)) { finiteFormat = d3.format(",." + d3.precisionFixed(sd / 10) + "f"); format = (x) => Number.isFinite(x) ? finiteFormat(x) : notFiniteFormat(x); } else { format = notFiniteFormat; } pct_missing = data.filter((d) => d[col] === null || isNaN(d[col])).length / data.length; chart = Histogram(data, col, type); // Elemento a ser retornado el = htl.html` ${col1}

${chart}

${pct_format(pct_missing)} ${format(mean)} ${format(median)} ${format(sd)} `; value = { column: col, type, min, max, mean, median, sd, missing: pct_missing, n_categories: null }; break; } el.value = value; el.appendChild(html``); return el; }