Skip to content

Instantly share code, notes, and snippets.

@nicovalencia
Last active March 3, 2025 23:29
Show Gist options
  • Save nicovalencia/f08b76e85eb0a11f9a0f6a82e0b24527 to your computer and use it in GitHub Desktop.
Save nicovalencia/f08b76e85eb0a11f9a0f6a82e0b24527 to your computer and use it in GitHub Desktop.
Indie LCA Accounts Receivable Prompt
I am attaching a list of USDC crypto transactions. Please follow the tasks to normalize the data, then create the report:
Tasks:
- remove all rows where the "to" column is not equal to "0x72a78d4da171fbf382af0c3dae94949e1459852f"
- remove all rows where the "TokenName" column is not equal to "USDC"
- we are focused on the "TokenValue" column, which is the amount of USDC transferred in each transaction
- the "TokenValue" has commas, and will need to be converted from a string to a number
Report:
1. I would like a visual graphic showing the cumulative transaction from each sender "From" address
2. I would like a table of the sum of each sender "From" address showing the total amount of USDC sent
3. I would like a table for each sender "From" address that lists all of their transactions with dates
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment