Last active
March 3, 2025 23:29
-
-
Save nicovalencia/f08b76e85eb0a11f9a0f6a82e0b24527 to your computer and use it in GitHub Desktop.
Indie LCA Accounts Receivable Prompt
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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