2e:null 2f:["$","title",null,{"children":"Touching tips with | palimpsest | Observable"}] 34:[{"id":"902bb435222c89ca97227d45af4c50a058460c58eced145faeb5ab4855f526d9c0e0eaa9851ac687600a301a8d0c1845925c9cbedf48afe78bf3cda9dd2792d9","href":"https://static.observableusercontent.com/files/902bb435222c89ca97227d45af4c50a058460c58eced145faeb5ab4855f526d9c0e0eaa9851ac687600a301a8d0c1845925c9cbedf48afe78bf3cda9dd2792d9","name":"2022_replies.json","type":"application/json","lastModified":1670925222163.729,"size":32473752}] 32:{"id":"8bb71fe5a02a1d2d","slug":"touching-tips","title":"Touching tips with","thumbnail":"c4dec59fd705427bacf48fcc2c7c4da99f15a807c3847a76db8c6bc9dbe1e5c5","access_level":"public","create_time":"$D2022-12-12T09:37:55.483Z","update_time":"$D2023-11-21T08:13:19.523Z","view_time":null,"first_public_time":"$D2022-12-12T09:37:55.483Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"5a0b9ab3ecb02e40","login":"palimpsest","name":"palimpsest","avatar_url":"https://avatars-next.observableusercontent.com/1a685fbd1b98ef5b1d2558da08b6e55946d4df957c4746fbf934c42c2984240a","tier":"starter_2024"},"version":552,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"5ee139d907a161d7","login":"palimpsest","name":"palimpsest","avatar_url":"https://avatars-next.observableusercontent.com/1a685fbd1b98ef5b1d2558da08b6e55946d4df957c4746fbf934c42c2984240a","tier":null}],"members":[{"type":"individual","id":"5ee139d907a161d7","login":"palimpsest","name":"palimpsest","avatar_url":"https://avatars-next.observableusercontent.com/1a685fbd1b98ef5b1d2558da08b6e55946d4df957c4746fbf934c42c2984240a","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":{"id":"23525257808122c2","slug":"where-the-fun-is","title":"Where the Fun IS","owner":{"id":"5a0b9ab3ecb02e40","login":"palimpsest","name":"palimpsest"}},"type":"notebook","body":{"title":"Touching tips with","cells":[{"id":0,"value":"# Touching tips with \n# ${username}\n---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":17,"value":"viewof username = Inputs.text({label:\"Type username\", placeholder: \"username\", datalist:users, value:\"grafician\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":530,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":518,"value":"♥ **Who loves ${username}**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":208,"value":"**${buddyByComments[0]}** *touched tips* **${buddyByComments[1]}** times in **${username}**'s posts.\n\n**${buddyByTopic[0]}** *touched tips* with **${buddyByTopic[1]}** of **${username}**'s ${userPosts.length} posts.\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":407,"value":"
\n♥ **Whom ${username} loves**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":405,"value":"**${username}** *touched tips* **${userBuddyByComments[1]}** times in **${userBuddyByComments[0]}**'s posts.\n\n**${username}** *touched tips* with **${userBuddyByTopic[1]}** of **${userBuddyByTopic[0]}**'s ${buddyByTopicPostCount} posts.\n\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":498,"value":"
\n♥ **In the trenches**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":500,"value":"**${username}** & **${trenchBuddy[0]}** *touched tips* **${trenchBuddy[1]}** times in all posts.\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":193,"value":"---\n## ${username}'s posts rundown","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":93,"value":"Inputs.table(userPosts.map(v => {return {date:new Date(v.date).toISOString().split('T')[0], reply:\"\"+v.id, topic:v.topic, sidenotes:v.notesQt, score:v.score}}) )","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":169,"value":"---\n### ${username}'s buddy count ###\n
\nNumber of ${username}'s posts commented by buddies.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":160,"value":"Inputs.table(buddyCommentedPostsCount.map(v => {return {buddy:v[0], count:v[1]}}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":183,"value":"
\nNumber of comments by buddies in ${username}'s posts.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":185,"value":"Inputs.table(buddyTotalCommentsCount.map(v => {return {buddy:v[0], count:v[1]}}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":395,"value":"
\nNumber of buddies' posts commented by ${username}.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":393,"value":"Inputs.table(userBuddyByTopicCount.map(v => {return {buddy:v[0], count:v[1]}}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":397,"value":"
\nNumber of comments by ${username} in buddies' posts.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":390,"value":"Inputs.table(userBuddyByCommentsCount.map(v => {return {buddy:v[0], count:v[1]}}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":493,"value":"
\nNumber of posts where ${username} & buddies commented on.
\nTakes all posts into account.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":491,"value":"Inputs.table(trenchBuddiesCount.map(v => {return {buddy:v[0], count:v[1]}}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":351,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":197,"value":"## Data wrangling\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":205,"value":"buddyByComments = buddyTotalCommentsCount.find(v => v[0] != username)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":174,"value":"buddyTotalCommentsCount = Object.entries(buddyTotalComments\n.map(v => {return v.notes})\n.flat()\n.reduce(function (acc, curr) {\n return acc[curr] ? ++acc[curr] : acc[curr] = 1, acc\n}, [])\n).sort((a,b) => b[1] - a[1])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":179,"value":"buddyTotalComments = userPosts.filter(v => {\n if(!v.hasOwnProperty('notesArray')) return false\n return true\n})\n .map(v => {\n return {id:v.id, notes:v.notesArray}\n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":345,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":200,"value":"buddyByTopic = buddyCommentedPostsCount.find(v => v[0] != username)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":139,"value":"buddyCommentedPostsCount = Object.entries(buddyCommentedPosts\n.map(v => {return v.notes})\n.flat()\n.reduce(function (acc, curr) {\n return acc[curr] ? ++acc[curr] : acc[curr] = 1, acc\n}, [])\n).sort((a,b) => b[1] - a[1])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":123,"value":"buddyCommentedPosts = userPosts.filter(v => {\n if(!v.hasOwnProperty('notesArray')) return false\n return true\n})\n .map(v => {\n return {id:v.id, notes:[... new Set(v.notesArray)]}\n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":334,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":306,"value":"buddyByTopicPostCount = getTotalPostsByUser(userBuddyByTopic[0])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":327,"value":"userBuddyByTopic = userBuddyByTopicCount.find(v => v[0] != username)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":330,"value":"userBuddyByTopicCount = Object.entries(\nuserNotes.map(v => v.user)\n .reduce((acc, val) => {\n return acc[val] ? ++acc[val] : acc[val] = 1, acc\n }, [])\n).sort((a,b) => b[1] - a[1])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":347,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":272,"value":"userBuddyByComments = userBuddyByCommentsCount.find(v => v[0] != username)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":269,"value":"userBuddyByCommentsCount = Object.entries(\nuserNotes.map(v => { \n return {user:v.user, count:v.notes.filter(u => u == username).length}\n})\n.reduce((acc, val) => {\n return acc[val.user] ? acc[val.user]+= val.count : acc[val.user] = val.count, acc\n}, [])\n).sort((a,b) => b[1] - a[1])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":356,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":535,"value":"trenchBuddy = trenchBuddiesCount.find(v => v[0] != username)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":470,"value":"trenchBuddiesCount = Object.entries(\n trenchBuddies.reduce((a,v) => {\n // count every buddy\n for(let i=0; i b[1] - a[1])\n\n ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":453,"value":"trenchBuddies = userNotes\n// get unique buddies\n.map(v => {\n return {id:v.id, buds: [... new Set(v.notes)]}\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":436,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":114,"value":"## Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":72,"value":"users = [...new Set(allReplies.map(v => v.user).sort())]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":80,"value":"topics = [...new Set(allReplies.map(v => v.topic).sort())]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":237,"value":"userNotes =allReplies.filter(v => {\n if(!v.hasOwnProperty('notesArray')) return false\n return v.notesArray.find(i => { return i == username}) !== undefined\n})\n.map(v => { \n return {id:v.id, user:v.user, notes:v.notesArray, topic:v.topic}\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":90,"value":"userPosts = allReplies.filter(v => v.user == username)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":44,"value":"allReplies = Object.values(data)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":304,"value":"getTotalPostsByUser = (user) => {\n return allReplies.filter(v => v.user == user).length\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":66,"value":"## Imports","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":439,"value":"data = FileAttachment(\"2022_replies.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W34","stdlib":"1","titling":"auto"}} 33:"$32:body"