28:null 29:["$","title",null,{"children":"Summary Tables (Top 500 Novels) | Melanie Walsh | Observable"}] 2f:Ta81,// A function to summarize a single column SummarizeColumn = (data, col) => { let content, value, format, finiteFormat, el, chart, missing_label, pct_missing, min, max; const notFiniteFormat = d3.format(",.0f"); // Construct content based on type const type = getType(data, col); const col1 = htl.html`${icon_fns[ type ]()}${ col === "" ? "unlabeled" : col }`; switch (type) { // Categorical columns case "ordinal": format = d3.format(",.0f"); // Calculate category percent and count 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] === "" ? "(missing)" : d[0]; obj.count = d[1].count; obj.pct = d[1].pct; return obj; }); // Create the chart const stack_chart = SmallStack(categories, col); // element to return el = htl.html` ${col1}

${stack_chart}

`; value = { column: col, type, min: null, max: null, n_categories: categories.length }; break; // Date columns case "date": // Calculate and format start / end const start = d3.min(data, (d) => +d[col]); const end = d3.max(data, (d) => +d[col]); chart = Histogram(data, col, type); // Element to return el = htl.html` ${col1}

${chart}

`; value = { column: col, type, min: start, max: end, n_categories: null }; break; // Continuous columns default: // Compute values min = d3.min(data, (d) => +d[col]); max = d3.max(data, (d) => +d[col]); chart = Histogram(data, col, type); // Element to return el = htl.html` ${col1}

${chart}

`; value = { column: col, type, min, max, n_categories: null }; break; } el.value = value; el.appendChild(html``); return el; }30:T507,SummaryTable = (dataObj, { label = "Summary" } = {}) => { const data = typeof dataObj.numRows === "function" ? dataObj.objects() : typeof dataObj.toArray === "function" ? dataObj.toArray().map((r) => Object.fromEntries(r)) : dataObj; const sample = data[0] || {}; const cols = data.columns || Object.keys(sample); let value = []; // Create the summary card and track data shape const summaryCard = SummaryCard(data, label); value.n_rows = summaryCard.value.n_rows; value.n_columns = summaryCard.value.n_columns; value.columns = cols; // Compose the element const element = htl.html`

${summaryCard}

${cols.map((d) => { const ele = SummarizeColumn(data, d); value.push(ele.value); // get the value from the element return ele; })}

Column	Snapshot

`; element.value = value; return element; }31:[] 2c:{"id":"55ed9e2bfd814d66","slug":null,"title":"Summary Tables (Top 500 Novels)","thumbnail":"51f913b9e45068ec033631fe2a7a782ca41060dcaae37bb328b28298f519495b","access_level":"public","create_time":"$D2024-07-22T20:02:37.753Z","update_time":"$D2024-07-22T20:06:14.431Z","view_time":null,"first_public_time":"$D2024-07-22T20:02:37.753Z","fork":{"id":"05930c2f8350fb92","slug":null,"title":"Better Summary Tables","owner":{"id":"1be53ef47b72f2b5","login":"juans","name":"Juans"}},"stars":0,"starred":false,"owner":{"type":"team","id":"64cb03831ce357a8","login":"mellymeldubs","name":"Melanie Walsh","avatar_url":"https://avatars-next.observableusercontent.com/b844e0b83b020387c8c7f8e02189c8037f7dda15061c591e49ca2fc69da49fca","tier":"pro_2024"},"version":79,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"6342b8ef5215128d","login":"juan-carlos-garcia","name":"Juan Carlos Garcia","avatar_url":"https://avatars-next.observableusercontent.com/a49028003f6484a6da1b44a5ab05fd1c195861117b90e8316427ac6899bc9a45","tier":null}],"members":[{"type":"individual","id":"6342b8ef5215128d","login":"juan-carlos-garcia","name":"Juan Carlos Garcia","avatar_url":"https://avatars-next.observableusercontent.com/a49028003f6484a6da1b44a5ab05fd1c195861117b90e8316427ac6899bc9a45","tier":null,"role":"editor"},{"type":"team","id":"64cb03831ce357a8","login":"mellymeldubs","name":"Melanie Walsh","avatar_url":"https://avatars-next.observableusercontent.com/b844e0b83b020387c8c7f8e02189c8037f7dda15061c591e49ca2fc69da49fca","tier":"pro_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Summary Tables (Top 500 Novels)","cells":[{"id":0,"value":"# Summary Tables (Top 500 Novels)\n","pinned":false,"hidden":false,"mode":"md"},{"id":6,"value":"aa_poetry_data = d3.csv(\"https://raw.githubusercontent.com/melaniewalsh/responsible-datasets-in-context/main/datasets/aa-periodical-poetry/AAPADA-Periodical-Poetry_1900-1928.csv\", d3.autoType)","pinned":true,"hidden":false,"mode":"ojs"},{"id":4,"value":"formatted_poetry_data = aa_poetry_data.map(d => {\n return Object.fromEntries(\n Object.entries(d).map(([key, value]) => [\n key,\n value === null || value === undefined || value === \"\" ? null : key === \"year\" ? new Date(value, 0, 1) : value\n ])\n );\n});","pinned":true,"hidden":false,"mode":"ojs"},{"id":37,"value":"import { SmallStack, Histogram, SummaryCard, getDateFormat, dateFormat, getType, icon_fns, pct_format } from \"@observablehq/summary-table\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":47,"value":"$2f","pinned":true,"hidden":false,"mode":"ojs"},{"id":35,"value":"$30","pinned":true,"hidden":false,"mode":"ojs"},{"id":41,"value":"viewof new_summary_data = SummaryTable(formatted_poetry_data, {\n label: \"AA Poetry Data\"\n});","pinned":true,"hidden":false,"mode":"ojs"},{"id":44,"value":"null","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}} 2d:"$2c:body"