25:["$","title",null,{"children":"Notion CSV trial(s), bottom up! | Andy Davies | Observable"}] 49:T9e3,cards = html`

${Array.from( new Set( [ ...A, ...B, ...C, ...D, ...E, ...F, ...G, ...H, ...I, ...J, ...K, ...L, ...M, ...N, ...O, ...P, ...Q, ...R, ...S, ...T, ...U, ...V, ...W, ...X, ...Y, ...Z, ...Colon, ...Asterix ].map((content) => content.Name[0]) ) ).map((firstLetter) => { const combinedCategoryItems = [ ...A, ...B, ...C, ...D, ...E, ...F, ...G, ...H, ...I, ...J, ...K, ...L, ...M, ...N, ...O, ...P, ...Q, ...R, ...S, ...T, ...U, ...V, ...W, ...X, ...Y, ...Z, ...Colon, ...Asterix ].filter((content) => content.Name[0] === firstLetter); const categoryCount = combinedCategoryItems.length; return html`

${firstLetter}

${categoryCount}

${combinedCategoryItems.map((content) => { const name = content.Name; return html`

${name}

Description:
${content.Description}

Related:
${content.Related}

Reference:
${content.Reference}

Usage:
${content.Usage}

Tags:
${content.Tags}

Personal opinion:
${content.Personal_opinion}

`; })}

`4a:[{"id":"1d3e680094d42f0bba15450bac2951dcc2de82492605f62a579b6b01fb354f5159adbda84a968b92c040f920ed72bd0e7a32e8ff6824175b6dd173ddffded28f","href":"https://static.observableusercontent.com/files/1d3e680094d42f0bba15450bac2951dcc2de82492605f62a579b6b01fb354f5159adbda84a968b92c040f920ed72bd0e7a32e8ff6824175b6dd173ddffded28f","name":"WTFDTM.csv","type":"text/csv","lastModified":1704993806712.209,"size":1787039},{"id":"e67dc95438d3a7415b64782875a808373ff75bb3160b7d35712da93c1b18b25ab08728790ecfad40e619f08ec990252c3b5a37d838793f074ae4a367f4dc398e","href":"https://static.observableusercontent.com/files/e67dc95438d3a7415b64782875a808373ff75bb3160b7d35712da93c1b18b25ab08728790ecfad40e619f08ec990252c3b5a37d838793f074ae4a367f4dc398e","name":"WTFDTM@1.csv","type":"text/csv","lastModified":1705427340597.838,"size":1787015}] 29:{"id":"b24e2e8c9eb27aaa","slug":null,"title":"Notion CSV trial(s), bottom up!","thumbnail":"49e3b8e7b5c25c76853ac31b4ed41e895e2facb91573182f4e68e995d0ccb899","access_level":"public","create_time":"$D2024-01-08T15:58:21.421Z","update_time":"$D2025-04-03T16:11:34.500Z","view_time":null,"first_public_time":"$D2024-01-08T15:58:21.421Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"ff6f10ce2cc05ede","login":"ad74","name":"Andy Davies","avatar_url":"https://avatars-next.observableusercontent.com/4cbd41df0d22ef61a5470015674cb36d9ca2d62733e3286dc467d0cd6cae7b05","tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":848,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"2eda63c2d220ee4b","login":"ad74","name":"Andy Davies","avatar_url":"https://avatars-next.observableusercontent.com/4cbd41df0d22ef61a5470015674cb36d9ca2d62733e3286dc467d0cd6cae7b05","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"2eda63c2d220ee4b","login":"ad74","name":"Andy Davies","avatar_url":"https://avatars-next.observableusercontent.com/4cbd41df0d22ef61a5470015674cb36d9ca2d62733e3286dc467d0cd6cae7b05","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Notion CSV trial(s), bottom up!","cells":[{"id":0,"value":"# Notion CSV trial(s), bottom up!","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":256,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":253,"value":"#### Get html for each letter ... try and categorise & use 'details' html for open / close","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":459,"value":"$49","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":564,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":322,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":775,"value":"#### Random 10 words from wtfdtm data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":781,"value":"viewof randomWords = {\n const amountDropdown = html``;\n\n function generateRandomWords() {\n const words = wtfdtm.map((d) => d.Name); // Assuming your CSV has a column named 'word'\n const selectedAmount = +amountDropdown.value;\n const randomList = [];\n for (let i = 0; i < selectedAmount; i++) {\n const randomIndex = Math.floor(Math.random() * words.length);\n randomList.push(words[randomIndex]);\n }\n return randomList;\n }\n\n const container = html`

\n ${amountDropdown}\n \n

`;\n\n // Add event listener to the button\n container.querySelector(\"button\").onclick = () => {\n const wordList = generateRandomWords();\n container.querySelector(\"ul\").innerHTML = wordList\n .map((Name) => `

${Name}

`)\n .join(\"\");\n };\n\n return container;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":779,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":264,"value":"#### Break into seperate letter, number & special characters to be used by HTML","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":737,"value":"A = groupedMap.get(\"A\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":746,"value":"B = groupedMap.get(\"B\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":748,"value":"C = groupedMap.get(\"C\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":751,"value":"D = groupedMap.get(\"D\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":753,"value":"E = groupedMap.get(\"E\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":755,"value":"F = groupedMap.get(\"F\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":773,"value":"G = groupedMap.get(\"G\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":757,"value":"H = groupedMap.get(\"H\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":759,"value":"I = groupedMap.get(\"I\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":761,"value":"J = groupedMap.get(\"J\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":763,"value":"K = groupedMap.get(\"K\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":765,"value":"L = groupedMap.get(\"L\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":767,"value":"M = groupedMap.get(\"M\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":769,"value":"N = groupedMap.get(\"N\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":771,"value":"O = groupedMap.get(\"O\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":733,"value":"P = groupedMap.get(\"P\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":400,"value":"Q = groupedMap.get(\"Q\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":414,"value":"R = groupedMap.get(\"R\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":609,"value":"S = groupedMap.get(\"S\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":617,"value":"T = groupedMap.get(\"T\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":619,"value":"U = groupedMap.get(\"U\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":623,"value":"V = groupedMap.get(\"V\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":625,"value":"W = groupedMap.get(\"W\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":627,"value":"X = groupedMap.get(\"X\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":634,"value":"\nY = groupedMap.get(\"Y\") ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":636,"value":"Z = groupedMap.get(\"Z\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":638,"value":"Colon = groupedMap.get(\":\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":641,"value":"Asterix = groupedMap.get(\"*\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":28,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":120,"value":"#### Group all special characters as 'others'","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":204,"value":"othersArr = Array.from(othersMap, ([key, value]) => ({ key, value }))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":181,"value":"othersMap = new Map(\n Array.from(splitTwo).filter(([key, value]) => key !== \"charNum\")\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":236,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":238,"value":"#### Split out (indexOf) special characters, numbers & characters","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":143,"value":"splitTwo = d3.group(indexCombinedMap, function (d) {\n const firstChar = d[0];\n return /^[a-zA-Z0-9]/.test(firstChar) ? \"charNum\" : \"others\";\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":240,"value":"splitThree = d3.group(indexCombinedMap, function (d) {\n const firstChar = d[0];\n if (/^[a-zA-Z]/.test(firstChar)) {\n return \"Letters\";\n } else if (/^[0-9]/.test(firstChar)) {\n return \"Numbers\";\n } else {\n return \"Others\";\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":118,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":179,"value":"#### Combine upper and lower case initial letters","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":328,"value":"indexCombinedArr = Array.from(indexCombinedMap, ([key, value]) => ({\n key,\n value\n}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":220,"value":"indexCombinedMap = d3.group(wtfdtm, (d) => d.Name[0].toUpperCase())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":201,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":93,"value":"#### Group all by initial character","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":335,"value":"groupedData = Array.from(\n d3.group(wtfdtm, (d) => d.Name.charAt(0).toUpperCase()),\n ([key, values]) => ({ key, values })\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":212,"value":"groupedArr = Array.from(groupedMap, ([key, value]) => ({ key, value }))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":107,"value":"groupedMap = d3.group(wtfdtm, (d) => d.Name[0])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":16,"value":"

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":395,"value":"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":60,"value":"wtfdtm = await FileAttachment(\"WTFDTM@1.csv\").csv({typed: \"auto\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"wtfdtm","database":"$undefined"}],"files":"$W4a","stdlib":"1"}} 24:null