32:T4c8,summaryPrompt = ` Write a succinct yet comprehensive summary of {user}'s work and their role within our community. Consider the following table of praise items, each one representing significant contributions made by community member {user}. The first column represents the date when the contribution was acknowledged, while the second column assigns a score to that contribution based on its impact. The third column provides a brief description of the contribution itself. As you compose your summary, please note the following guidelines: - Prioritize contributions based on their impact score—the higher the score, the greater its influence on your depiction of {user}'s role. - Bear in mind the timeline of these contributions. While all contributions are important, recent ones should carry more weight in your summary. - Your summary should be no more than 600 characters, arranged in up to 3 paragraphs. Separate each paragraph with a "\n". - Do not mention praise, praising or the individual impact scores. The goal here is not just to list {user}'s accomplishments but to paint a vivid picture of their work and their key areas of contribution within our community. Let's bring their story to life. `33:T54f,summaryPlaceholder = `Juankbell#7458 is a valuable member of the community who contributes in multiple ways. They are particularly impactful in their work on Gravity and conflict management. Juankbell#7458 has conducted the 2nd Graviton training, led Gravity and created a container for people to connect and strengthen their personal relationships. They have also contributed to the TEC material to represent TEC in the Introduction to Token Engineering in Spanish. Juankbell#7458 has also led the Gravity working group and contributed to the Praise audit. They have provided insights into the Rewards System research initiative and helped with voting, tweet planning, and posting. Moreover, Juankbell#7458 has organized and led Graviton training and presented an Introduction to Token Engineering session in Spanish. They have also greatly influenced the community's work on conflict resolution and strengthened the social layers in the DAO ecosystem. Overall, Juankbell#7458 is a dedicated member who has taken on significant leadership roles within the community and has made significant contributions towards helping others grow and benefit. They have not only shared their expertise and insights but have also provided support and guidance to other members. Juankbell#7458's work has made a significant impact on the community and continues to do so.`34:[] 30:{"title":"Praise/OpenAI: Generating Contributor Bios on Praise Data","cells":[{"id":0,"value":"# Praise/OpenAI: Generating Contributor Bios on Praise Data\n\n[Praise](https://givepraise.xyz) uses AI to take community intelligence to the next level. The Praise contribution graph contains information about who did what, when and to what impact. In this example, we let OpenAI process the data to generate a bio of the user based on actual contributions. \n\nNotes:\n- The bio uses the contributors 100 highest scored praise. \n- The default data set is live data from the Token Engineering Commons praise instance (http://praise.tecommons.org)\n- This notebook requires an OpenAI api key to run\n- **Fork this notebook! What other AI based analysis can we do on the Praise data?**\n\nMore info about Praise: https://givepraise.xyz","pinned":false,"hidden":false,"mode":"md"},{"id":1464,"value":"viewof openAiKey = Inputs.text({label: \"OpenAI API Key\"}); ","pinned":false,"hidden":false,"mode":"ojs"},{"id":1766,"value":"viewof openAiModel = Inputs.select(models, {\n label: \"OpenAI model\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1565,"value":"viewof communityUrl = Inputs.text({\n label: \"Community Url\",\n placeholder: \"Select community or enter API url\",\n datalist: communities.map((c) => c.url)\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":603,"value":"viewof userAccount = Inputs.select([{name: \"No account selected\"}].concat(userAccounts), {label: \"User\", format: p => p.name, value: \"621f79ce95a79aa51435b223\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1657,"value":"viewof reloadButton = Inputs.button(\"Reload\", {value: null, reduce: () => new Date().toISOString().substr(0,10)})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1654,"value":"db === \"loading\" ? md`Loading database…` : db ? md`✅ Database loaded` : md`🛑 Database not loaded`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1671,"value":"openAiKey ? md`✅ OpenAI API Key`: md`🛑 OpenAI API Key`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1334,"value":"---\n## ${(userAccount.name === \"No account selected\" || !openAiKey) ? \"Juankbell#7485\" : userAccount.name}\n${summary || summaryPlaceholder}","pinned":false,"hidden":false,"mode":"md"},{"id":1387,"value":"html`

${labels ? html`${labels}` : html`${labelsPlaceholder}`}

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":911,"value":"## Summary","pinned":false,"hidden":false,"mode":"md"},{"id":1614,"value":"summary = {\n yield \"Loading summary…\";\n yield generateSummary(topPraiseCsv)\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1419,"value":"generateSummary = async (data) =>\n queryOpenAi(\n data,\n summaryPrompt.replace(\"{user}\", userAccount.name),\n openAiModel,\n openAiKey\n )","pinned":false,"hidden":false,"mode":"ojs"},{"id":1736,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":1617,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":1626,"value":"## Labels","pinned":false,"hidden":false,"mode":"md"},{"id":1629,"value":"labels = {\n yield \"Loading labels…\"\n yield generateLabels(topPraiseCsv)\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1360,"value":"generateLabels = async (data) => {\n if (!openAiKey) return undefined;\n const allLabels = await queryOpenAi(\n data,\n labelPrompt,\n openAiModel,\n openAiKey\n );\n const arr = allLabels.split(\",\");\n\n return `

\n ${arr.map(\n (label) => `\n ${toTitleCase(label.trim())}\n `\n )}\n

`;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1782,"value":"function toTitleCase(str) {\n return str\n .toLowerCase()\n .split(' ')\n .map(word => word.charAt(0).toUpperCase() + word.slice(1))\n .join(' ');\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1350,"value":"labelPrompt = `Below is a table of praise items describing contributions made by a community member. The first column is a score representing the impact of the contribution, the second column describes the contribution. Create a comma separated list of labels that describe the most impactful work this contributor does for the community. The higher impact score a contribution has the more it impacts your description. A label can consist of at max two words. max 7 labels please.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1634,"value":"labelsPlaceholder = '

TEC introduction Param proposals Graviton training Gravity leadership Conflict resolution Transparency of funding Community stewardship'","pinned":false,"hidden":false,"mode":"ojs"},{"id":1641,"value":"## Praise","pinned":false,"hidden":false,"mode":"md"},{"id":1310,"value":"transformToCsv = () => {\n return 'score, reason\\n' + praiseArray.map(item => `${item.createdAt}, ${item.score}, ${item.reason}`).join('\\n')\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1314,"value":"topPraiseCsv = transformToCsv()","pinned":false,"hidden":false,"mode":"ojs"},{"id":1236,"value":"praiseArray = topPraise.map(item => ({createdAt: item.createdAt.toISOString().split('T')[0], score: Math.floor(item.score), reason: item.reason}))","pinned":false,"hidden":true,"mode":"ojs"},{"id":1224,"value":"SELECT \n createdAt,\n score,\n reason,\n FROM praise \n WHERE receiver = ${userAccount._id ? userAccount._id : '621f79ce95a79aa51435b223'}\n ORDER BY score desc\n LIMIT 100","pinned":false,"hidden":true,"mode":"sql","output":"topPraise","database":"var:db"},{"id":1646,"value":"## User Accounts","pinned":false,"hidden":false,"mode":"md"},{"id":1554,"value":"SELECT * FROM useraccounts ORDER BY _id","pinned":false,"hidden":true,"mode":"sql","output":"userAccounts","database":"var:db"},{"id":1788,"value":"## Communities","pinned":false,"hidden":false,"mode":"md"},{"id":1790,"value":"import { communities } from \"@praise/praise-sample-data-and-common-functions\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":1648,"value":"## Database","pinned":false,"hidden":false,"mode":"md"},{"id":1548,"value":" db = {\n const url = communityUrl;\n console.log(`${url}/api/users/export/parquet`);\n yield \"loading\";\n yield DuckDBClient.of({\n users: getRemoteFile(`${url}/api/users/export/parquet`),\n userAccounts: getRemoteFile(`${url}/api/useraccounts/export/parquet`),\n praise: getRemoteFile(`${url}/api/praise/export/parquet?startDate=1970-01-01&endDate=2030-01-01`),\n })\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1660,"value":"function getRemoteFile(url) {\n reloadButton;\n const baseURL = new URL(url);\n return {\n file: {\n name: baseURL.pathname + \".parquet\",\n url: function () {\n return url;\n }\n }\n };\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1602,"value":"## OpenAI","pinned":false,"hidden":false,"mode":"md"},{"id":1724,"value":"import { queryOpenAi } from \"@praise/praise-sample-data-and-common-functions\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":1810,"value":"import { models } from \"@praise/praise-sample-data-and-common-functions\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":1471,"value":"## Styles","pinned":false,"hidden":false,"mode":"md"},{"id":1405,"value":"html``","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W34","stdlib":"1","titling":"auto"}