2d:null 2e:["$","title",null,{"children":"Telegram Analysis | Giacomo Nanni | Observable"}] 33:[{"id":"d595003dbd7854998abdbbb7c81b8ed9930dced4df67d41027c8ce59aff0f4ee53e323e0f62d37b65aaaf01d7ed0139269caacd479e408c9893588cc7c217579","href":"https://static.observableusercontent.com/files/d595003dbd7854998abdbbb7c81b8ed9930dced4df67d41027c8ce59aff0f4ee53e323e0f62d37b65aaaf01d7ed0139269caacd479e408c9893588cc7c217579","name":"devicebuy_messages_annotated.csv","type":"text/csv","lastModified":1749630920095.859,"size":265322},{"id":"63652d18b13566fb19218210ba1266d2c77f1ac452150472a6ee0cb95db02dc0456cd26a11024e2355d54bafbaac7be053e499a3419df66fd4b4329dfb4b8f9c","href":"https://static.observableusercontent.com/files/63652d18b13566fb19218210ba1266d2c77f1ac452150472a6ee0cb95db02dc0456cd26a11024e2355d54bafbaac7be053e499a3419df66fd4b4329dfb4b8f9c","name":"devicebuy_messages_annotated_clustered.csv","type":"text/csv","lastModified":1749636173539.721,"size":278868},{"id":"866c75e477680386529a303c065fecd920cc5c519e854742db3aa5ed4394ac69998f2f952e751b26f992ba7053e7a573df72b17ab07871ed5d9737ef2de3ab64","href":"https://static.observableusercontent.com/files/866c75e477680386529a303c065fecd920cc5c519e854742db3aa5ed4394ac69998f2f952e751b26f992ba7053e7a573df72b17ab07871ed5d9737ef2de3ab64","name":"devicebuy_messages_annotated_clustered@2.csv","type":"text/csv","lastModified":1749637410738.06,"size":279626},{"id":"973135b4c1ea4d5050a86d6800ce7d6b9793952f3fa3b47b499579ffcbc6e7b8f222d1f203c9e0ee7dd1c80f2c657b256d7267880f29946a03e331534d5e34f8","href":"https://static.observableusercontent.com/files/973135b4c1ea4d5050a86d6800ce7d6b9793952f3fa3b47b499579ffcbc6e7b8f222d1f203c9e0ee7dd1c80f2c657b256d7267880f29946a03e331534d5e34f8","name":"devicebuy_messages_annotated_clustered@3.csv","type":"text/csv","lastModified":1749647680531.449,"size":277911},{"id":"fd17b7a05459eaf5b869f539a3a22eb5d8a2afb3c473d08beab8e2ccc34b23e1d6d9a421808de87132e372018341a371b6ad175c6443e8f39d75b8dfe026c3d9","href":"https://static.observableusercontent.com/files/fd17b7a05459eaf5b869f539a3a22eb5d8a2afb3c473d08beab8e2ccc34b23e1d6d9a421808de87132e372018341a371b6ad175c6443e8f39d75b8dfe026c3d9","name":"devicebuy_messages_annotated_clustered@4.csv","type":"text/csv","lastModified":1749647973164.559,"size":415401},{"id":"529c0bf6868baa51a998b6d1c066b3b0c26f19d79f6ee49826558102ba704d9f6000ab922e434fc794e49b76dd32d4961e411aed914fab5e245a05faa0c417c8","href":"https://static.observableusercontent.com/files/529c0bf6868baa51a998b6d1c066b3b0c26f19d79f6ee49826558102ba704d9f6000ab922e434fc794e49b76dd32d4961e411aed914fab5e245a05faa0c417c8","name":"devicebuy_messages_annotated_cluster0_cluster1.csv","type":"text/csv","lastModified":1749650529150.077,"size":290969},{"id":"7564e9f32520ffd33aa6d65e1cdbf4999256fe84a4fa3274b2312cbeb4e4d59124e1e01086126a86d3fb902a051b7a3141f24e3bf0032dc3ae329f7725ae3ac2","href":"https://static.observableusercontent.com/files/7564e9f32520ffd33aa6d65e1cdbf4999256fe84a4fa3274b2312cbeb4e4d59124e1e01086126a86d3fb902a051b7a3141f24e3bf0032dc3ae329f7725ae3ac2","name":"devicebuy_messages_annotated_cluster0_cluster1@1.csv","type":"text/csv","lastModified":1749650580425.76,"size":290960}] 31:{"id":"aad6036e08c4d0f0","slug":"telegram-analysis","title":"Telegram Analysis","thumbnail":"50eb237e406be53b9b97c2992cf14d1a1e4a25500771b332733f7ac07a9e2250","access_level":"public","create_time":"$D2025-06-11T08:33:46.283Z","update_time":"$D2025-06-24T11:54:04.371Z","view_time":null,"first_public_time":"$D2025-06-11T08:34:05.769Z","has_unpublished_edits":null,"fork":false,"stars":1,"starred":false,"owner":{"type":"team","id":"5129c2957f22f1f2","login":"sinanatra","name":"Giacomo Nanni","avatar_url":"https://avatars-next.observableusercontent.com/780b6bc6dd2a5bbb19911ff3ee47ff844b4e25436b3bd6a0cde359479c6b4dd9","tier":"starter_2024"},"version":207,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"c9e695131ad6aff8","login":"sinanatra","name":"Giacomo Nanni","avatar_url":"https://avatars-next.observableusercontent.com/780b6bc6dd2a5bbb19911ff3ee47ff844b4e25436b3bd6a0cde359479c6b4dd9","tier":null}],"members":[{"type":"team","id":"5129c2957f22f1f2","login":"sinanatra","name":"Giacomo Nanni","avatar_url":"https://avatars-next.observableusercontent.com/780b6bc6dd2a5bbb19911ff3ee47ff844b4e25436b3bd6a0cde359479c6b4dd9","tier":"starter_2024","role":"editor"},{"type":"individual","id":"c9e695131ad6aff8","login":"sinanatra","name":"Giacomo Nanni","avatar_url":"https://avatars-next.observableusercontent.com/780b6bc6dd2a5bbb19911ff3ee47ff844b4e25436b3bd6a0cde359479c6b4dd9","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":{"id":"ced46d613caaebaf","slug":"airwars","title":"Airwars","owner":{"id":"5129c2957f22f1f2","login":"sinanatra","name":"Giacomo Nanni"}},"type":"notebook","body":{"title":"Telegram Analysis","cells":[{"id":0,"value":"# Telegram Analysis","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":103,"value":"This prototype take processed Telegram chat data of products sold from Europe to Russia. It uses Ollama to cluster product categories into 10–30 broader groups and visualizes the distribution of these clusters.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":110,"value":"Click on a category and scroll down to see the products that are included in that category.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":25,"value":"viewof tile = Inputs.select(\n new Map([\n [\"binary\", d3.treemapBinary],\n [\"squarify\", d3.treemapSquarify],\n [\"slice-dice\", d3.treemapSliceDice],\n [\"slice\", d3.treemapSlice],\n [\"dice\", d3.treemapDice]\n ]),\n {label: \"Tiling method\", value: d3.treemapSquarify}\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":173,"value":"---\n## Cluster 1","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":20,"value":"viewof chart = {\n const svg = Treemap(treeData_2, {\n value: (d) => d.value,\n group: (d) => d.name,\n label: (d) => d.name,\n tile,\n width: 1152,\n height: 500,\n padding: 1\n });\n\n svg.querySelectorAll(\"rect\").forEach((rect) => {\n rect.style.cursor = \"pointer\";\n });\n\n svg.addEventListener(\"click\", (event) => {\n const leaf = event.target.__data__;\n if (leaf) {\n mutable selectedCategory = leaf.data.name;\n }\n });\n\n return svg;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":82,"value":"details = {\n if (!selectedCategory) {\n return html`Click on a category above to see its products…`;\n }\n const items = data.filter((d) => d.category_cluster1 === selectedCategory);\n return html`\n

Products in “${selectedCategory}” (${items.length})

\n ${items.map(\n (item) => html`\n

\n ${item.product_name}
\n ${item.media_url} \n

\n `\n )}\n

\n `;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":171,"value":"---\n## Cluster 2","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":165,"value":"viewof chart1 = {\n const svg = Treemap(treeData_1, {\n value: (d) => d.value,\n group: (d) => d.name,\n label: (d) => d.name,\n tile,\n width: 1152,\n height: 500,\n padding: 1\n });\n\n svg.querySelectorAll(\"rect\").forEach((rect) => {\n rect.style.cursor = \"pointer\";\n });\n\n svg.addEventListener(\"click\", (event) => {\n const leaf = event.target.__data__;\n if (leaf) {\n mutable selectedCategory = leaf.data.name;\n }\n });\n\n return svg;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":167,"value":"details1 = {\n if (!selectedCategory) {\n return html`Click on a category above to see its products…`;\n }\n const items = data.filter((d) => d.category_cluster0 === selectedCategory);\n return html`\n

Products in “${selectedCategory}” (${items.length})

\n ${items.map(\n (item) => html`\n

\n ${item.product_name}
\n ${item.media_url} \n

\n `\n )}\n

${\n d.product_name || \"View Link\"\n } – ${d.category_cluster1}

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":68,"value":"---\n## Parsing","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":17,"value":"data = {\n let datum = await FileAttachment(\n \"devicebuy_messages_annotated_cluster0_cluster1@1.csv\"\n ).csv();\n\n datum.forEach((d) => {\n d.category_cluster0 = d.category_cluster0?.trim() || \"unnamed\";\n d.category_cluster1 = d.category_cluster1?.trim() || \"unnamed\";\n });\n\n return datum;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":34,"value":"counts_1 = {\n const rollup = d3.rollup(\n data, \n v => v.length, \n d => d.category_cluster0\n )\n return Array.from(rollup, ([name, value]) => ({name, value}))\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":157,"value":"counts_2 = {\n const rollup = d3.rollup(\n data, \n v => v.length, \n d => d.category_cluster1\n )\n return Array.from(rollup, ([name, value]) => ({name, value}))\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":37,"value":"treeData_1 = {\n return {\n name: \"All Categories\",\n children: counts_1\n };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":160,"value":"treeData_2 = {\n return {\n name: \"All Categories\",\n children: counts_2\n };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":73,"value":"mutable selectedCategory = null","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":63,"value":"---\n## Imports","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":5,"value":"import {Treemap} from \"@d3/treemap-component\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W33","stdlib":"1","titling":"auto"}} 32:"$31:body"