31:T48e,summaryPrompt = `Consider the following table of praise items, each one representing significant contributions made by community member {user}. Your task is to compile a succinct yet comprehensive summary of {user}'s work and their role within our community. 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 400 characters, arranged in up to 3 paragraphs. Separate each paragraph with a "\n". 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. `32: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.`33:[] 2f:{"title":"OpenAI: Praise Contributor Bio","cells":[{"id":0,"value":"# OpenAI: Praise Contributor Bio\n\nThe bio is generated based on the contributors 100 highest scored praise. \n\nNotes:\n- The default data set is live data from the Token Engineering Commons praise instance (http://tec.givepraise.xyz)\n- **This notebook requires an OpenAI api key to run**\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":1565,"value":"viewof communityUrl = Inputs.text({label: \"Community Url\", value: \"https://praise.tecommons.org\"});","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":1467,"value":"---\n## Prompts","pinned":false,"hidden":false,"mode":"md"},{"id":1736,"value":"$31","pinned":true,"hidden":false,"mode":"ojs"},{"id":1329,"value":"summaryPromptOld = `Below is a table of praise items describing contributions made by community member ${userAccount.name}. Summarize, what kind of work does ${userAccount.name} do for the community? The first column is a score representing the impact of the contribution, the second column describes the contribution. The higher impact score a contribution has the more it impacts your description of ${userAccount.name}. Also comment when in time contributions were made. The older the less impactful a contribution is. Max 400 characters. Paragraphs separated by \"\\n\". Max 3 paragraphs.`","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. 7 labels please.`","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) => queryOpenAi(data, summaryPrompt, openAiKey)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1617,"value":"$32","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(data, labelPrompt, openAiKey);\n const arr = allLabels.split(',');\n\n return `

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

`\n}","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":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 \"@kristofer/praise-data\"","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":"$W33","stdlib":"1","titling":"auto"}