I need to work with some data and struggling to think today.
I have a list of assignments in a SQL table. I have a separate table with scores for each assignment (linked to a user account). I need to turn this into a table of users and assignments.
My thought right now is to create a list of assignments and use that to create a collection of OrderedDicts with keys entered in the same order as the assignments list. Then I can iterate into table rows. Or is there a better method?
#python
Brian :cupofcoffee: :rss:
npub1rk…cfcdy
2026-02-25 17:05:39 UTC
Author Public Key
npub1rkr8tvf8udyuu5qwnrynpmfuw84gnydptrtgczywjfuu7kya3aesucfcdySeen on
wss://relay.mostr.pubPublished at
2026-02-25 17:05:39 UTCEvent JSON
{
"id": "1ea857d80aaf3173536ad49ce0d341dd23c4aa16fe634662a5d3dbde2403edfe",
"pubkey": "1d8675b127e349ce500e98c930ed3c71ea8991a158d68c088e9279cf589d8f73",
"created_at": 1772039139,
"kind": 1,
"tags": [
[
"t",
"python"
],
[
"proxy",
"https://fosstodon.org/users/brianb/statuses/116132357015590393",
"activitypub"
],
[
"client",
"Mostr",
"31990:6be38f8c63df7dbf84db7ec4a6e6fbbd8d19dca3b980efad18585c46f04b26f9:mostr",
"wss://relay.ditto.pub"
]
],
"content": "I need to work with some data and struggling to think today.\n\nI have a list of assignments in a SQL table. I have a separate table with scores for each assignment (linked to a user account). I need to turn this into a table of users and assignments.\n\nMy thought right now is to create a list of assignments and use that to create a collection of OrderedDicts with keys entered in the same order as the assignments list. Then I can iterate into table rows. Or is there a better method?\n\n#python",
"sig": "39f5a0bf48b3ca7d43d2f233d08cb33743774164d00b15702f18489ed14c0d9cefb1568727a1c461f599bc5ddb9350dd3b615fb9d701044ee76ac8ab31d183f7"
}