Transaction Hash,Status,Method,Blockno,DateTime (UTC),From,From_Nametag,To,To_Nametag,Amount,Value (USD),Txn Fee

[GypsyS44]

Transaction Hash,Status,Method,Blockno,DateTime (UTC),From,From_Nametag,To,To_Nametag,Amount,Value (USD),Txn Fee
"0xee84420c26c6549529b4e2097c31fcf4c9884f6d346099bc9d6a911819b34c6c","Success","Transfer","23103723","2025-08-09 13:13:35","0xdadb0d80178819f2319190d340ce9a924f783711","BuilderNet","0x388C818CA8B9251b393131C08a736A67ccB19297","Lido: Execution Layer Rewards Vault","0.01285917 ETH","$53.84","0.0000242"
"0x3141c8c5a72adabcf22419352b2d8afa780219810c535539e4db0d8c11f2c100","Success","Transfer","23103723","2025-08-09 13:13:35","0xdadb0d80178819f2319190d340ce9a924f783711","BuilderNet","0x03E8482c2BbF8247361b1D6000f138d9f9CA9CD7","","0.0004324 ETH","$1.81","0.00002298"
"0x4544de0be67142310d64ec0c9f4e21d0c78bd16089833763be4507a8aaf0e27a","Success","Transfer","23103723","2025-08-09 13:13:35","0xdadb0d80178819f2319190d340ce9a924f783711","BuilderNet","0xcf0475d9B0a29975bc5132A3066010eC898d8CaB","","0.00078298 ETH","$3.28","0.00002298"
"0x04917af2956650f43659d4491059846b7b926d0fe8cc128bff8ca1f1f91c2561","Success","Transfer","23103723","2025-08-09 13:13:35","0xdadb0d80178819f2319190d340ce9a924f783711","BuilderNet","0xe7a03a274e4dDE67c63c3859FAc5BdaCFC4fae0f","","0.00281486 ETH","$11.79","0.00002298"
"0xc164ac8ae5959af04c04cc05bc20b42080758c04a3f3adda54ea1a5d143b8232","Success","Transfer","23103723","2025-08-09 13:13:35","0xdadb0d80178819f2319190d340ce9a924f783711","BuilderNet","0xa114791A6a939087048960f48e62fbe817828CD1","","0.00170072 ETH","$7.12","0.00002298"
"0x730268e078e4259db1c65c2f72efadbef0763884afc449568a86ee7d93fc8374","Success","Transfer","23103721","2025-08-09 13:13:11","0xdadb0d80178819f2319190d340ce9a924f783711","BuilderNet","0x48319f97E5Da1233c21c48b80097c0FB7a20Ff86","Fee Recipient: 0x4831...f86","0.02110346 ETH","$88.36","0.00002304"
"0xe5c2e87bf89562f3f1e1c369b30254357530b6a97cf4ffc77af0768e1a21dd80","Success","Transfer","23103721","2025-08-09 13:13:11","0xdadb0d80178819f2319190d340ce9a924f783711","BuilderNet","0xB423b53D9076b325c0248D62eF74b11adC211020","","0.00396855 ETH","$16.62","0.00002189"
"0xde5cb3fcab136f0e934fc1292afeeb2b64e521aff84e525468e7c85da499d5f2","Success","Transfer","23103721","2025-08-09 13:13:11","0xdadb0d80178819f2319190d340ce9a924f783711","BuilderNet","0xcf0475d9B0a29975bc5132A3066010eC898d8CaB","","0.00049846 ETH","$2.09","0.00002189"
"0xf48290ab0839a3b499ee9233c32d0b17ac210d2c18d9120d93c6a59a81c26a9d","Success","Transfer","23103721","2025-08-09 13:13:11","0xdadb0d80178819f2319190d340ce9a924f783711","BuilderNet","0x03E8482c2BbF8247361b1D6000f138d9f9CA9CD7","","0.0005014 ETH","$2.10","0.00002189"
"0x6e68ddf39e419d3e0fed9e4919bd40d434d4191f2dc5bd1e6b8821443f850e65","Success","Transfer","23103720","2025-08-09 13:12:59","0xdadb0d80178819f2319190d340ce9a924f783711","BuilderNet","0x388C818CA8B9251b393131C08a736A67ccB19297","Lido: Execution Layer Rewards Vault","0.02458153 ETH","$102.92","0.00002289"
"0x12d86f79c0bb098dbb62a312dc8e815331faa9e6c4d897b4b29a1fa64659e542","Success","Transfer","23103720","2025-08-09 13:12:59","0xdadb0d80178819f2319190d340ce9a924f783711","BuilderNet","0xB423b53D9076b325c0248D62eF74b11adC211020","","0.00229789 ETH","$9.62","0.00002174"
"0x627cb09d372027de4fb3518b98c05063891fc83d4385862b3d073ae73c5b29e3","Success","Transfer","23103720","2025-08-09 13:12:59","0xdadb0d80178819f2319190d340ce9a924f783711","BuilderNet","0xf70da97812CB96acDF810712Aa562db8dfA3dbEF","Relay: Solver","0.00027616 ETH","$1.16","0.00002174"
"0x5005bb7587437535d261ce7db4ce570422bed0ecd3bd451f7fa6d61cac2d0a4a","Success","Transfer","23103720","2025-08-09 13:12:59","0xdadb0d80178819f2319190d340ce9a924f783711","BuilderNet","0xeDa4C0F725466fF036B03B2AD532904d6A96473E","MEV Merkle","0.00001125 ETH","$0.05","0.00002174"
"0x9442a98b9373392cd2ce826f76a03acb5acce301419386c051fd85ab14056c06","Success","Transfer","23103720","2025-08-09 13:12:59","0xdadb0d80178819f2319190d340ce9a924f783711","BuilderNet","0xcf0475d9B0a29975bc5132A3066010eC898d8CaB","","0.0012019 ETH","$5.03","0.00002174"
"0x692f512e9340e8110bbae5d2a9e2e1679779bfe92873327f60d6b81117e2870d","Success","Transfer","23103720","2025-08-09 13:12:59","0xdadb0d80178819f2319190d340ce9a924f783711","BuilderNet","0x03E8482c2BbF8247361b1D6000f138d9f9CA9CD7","","0.00097963 ETH","$4.10","0.00002174"
"0xc2c76d202e819f1ee9e534f719682f23a06239ef5a0e5fb14ce03c56d030dd48","Success","Transfer","23103718","2025-08-09 13:12:35","0xdadb0d80178819f2319190d340ce9a924f783711","BuilderNet","0xe688b84b23f322a994A53dbF8E15FA82CDB71127","Fee Recipient: 0xe68...127","0.01171872 ETH","$49.07","0.00002142"
"0x95bbc28bf74e383df92fefd0c0cbb8ea5e1f81a960a9b5ea361315110cdcd0bb","Success","Transfer","23103718","2025-08-09 13:12:35","0xdadb0d80178819f2319190d340ce9a924f783711","BuilderNet","0x03E8482c2BbF8247361b1D6000f138d9f9CA9CD7","","0.00051462 ETH","$2.15","0.00002142"
"0x82106d44805883adaf6ebde32a2aceef7b151173e729454e985c4cb13d56011d","Success","Transfer","23103718","2025-08-09 13:12:35","0xdadb0d80178819f2319190d340ce9a924f783711","BuilderNet","0xcf0475d9B0a29975bc5132A3066010eC898d8CaB","","0.00089666 ETH","$3.75","0.00002142"
"0x8ee6ff073d7ef0dfacbbc5af658c4f40ff5caacf5d0adffe0d35d3a942ae5f0b","Success","Transfer","23103718","2025-08-09 13:12:35","0xdadb0d80178819f2319190d340ce9a924f783711","BuilderNet","0x3B932e1BBE73076995faE219f0B05F6546733EDF","","0.00227238 ETH","$9.51","0.00002142"
"0x84f8230cc96bf13e91796bc769da1cffb30c9a2fdd05c6583bdfb5409c027417","Success","Transfer","23103717","2025-08-09 13:12:23","0xdadb0d80178819f2319190d340ce9a924f783711","BuilderNet","0x388C818CA8B9251b393131C08a736A67ccB19297","Lido: Execution Layer Rewards Vault","0.02204229 ETH","$92.29","0.0000225"
"0xcfcad479215dc511c8be657e7daa4626b7a3044ea083eda016fe7a23de800cbf","Success","Transfer","23103717","2025-08-09 13:12:23","0xdadb0d80178819f2319190d340ce9a924f783711","BuilderNet","0x9c1BECd2f442e86A326032eDBb644f38CE8BcE96","","0.0001025 ETH","$0.43","0.00002137"
"0xc87697375ff4d9e43c7a7996a91f19193a655a7d33c2009e73d20e4ea9458690","Success","Transfer","23103717","2025-08-09 13:12:23","0xdadb0d80178819f2319190d340ce9a924f783711","BuilderNet","0xB423b53D9076b325c0248D62eF74b11adC211020","","0.00545777 ETH","$22.85","0.00002137"
"0x3ed042873aa95033c41e1aa9bda939c606354fd6b91e8bbdbf94a534c426d313","Success","Transfer","23103717","2025-08-09 13:12:23","0xdadb0d80178819f2319190d340ce9a924f783711","BuilderNet","0xcf0475d9B0a29975bc5132A3066010eC898d8CaB","","0.00048943 ETH","$2.05","0.00002137"
"0xe7d8608b249421dc59be10ce302d282bff539ae82e6d8d7c5ab3e6da760044fd","Success","Transfer","23103717","2025-08-09 13:12:23","0xdadb0d80178819f2319190d340ce9a924f783711","BuilderNet","0x03E8482c2BbF8247361b1D6000f138d9f9CA9CD7","","0.00114016 ETH","$4.77","0.00002137"
"0xa1edb59d41ed9419af8406aeaa4ae9097095f716999f3f38f1dd8b116247ec5d","Success","Transfer","23103716","2025-08-09 13:12:11","0xdadb0d80178819f2319190d340ce9a924f783711","BuilderNet","0x1135FA96848f34Bff9D003F4c1699AE97418DE29","Fee Recipient: 0x1135...e29","0.02391328 ETH","$100.13","0.00002105"

Originally posted by @GypsyS44 in GypsyS44/skills-github-pages#1

Originally posted by @GypsyS44 in GypsyS44/Hello-button#8

import pandas as pd

Load your data (update filename/path as needed)

file_path = "transactions.xlsx" # or "transactions.csv"
df = pd.read_excel(file_path) # for CSV use pd.read_csv(file_path)

Quick data check

print("First 5 rows:")
print(df.head())

Convert DateTime column to datetime if not already

df['DateTime (UTC)'] = pd.to_datetime(df['DateTime (UTC)'])

Clean 'Amount' column to extract numeric value (assuming ETH values like "0.0123 ETH")

df['Amount_numeric'] = df['Amount'].str.extract(r'([0-9.]+)').astype(float)

Clean 'Txn Fee' column similarly

df['Txn_Fee_numeric'] = df['Txn Fee'].astype(str).str.extract(r'([0-9.]+)').astype(float)

Total number of transactions

total_txns = len(df)
print(f"Total transactions: {total_txns}")

Total amount transferred

total_amount = df['Amount_numeric'].sum()
print(f"Total amount transferred (ETH): {total_amount:.6f}")

Average transaction fee

avg_fee = df['Txn_Fee_numeric'].mean()
print(f"Average transaction fee (ETH): {avg_fee:.8f}")

Group by date to see daily transaction count

df['Date'] = df['DateTime (UTC)'].dt.date
daily_counts = df.groupby('Date').size()
print("\nTransactions per day:")
print(daily_counts)

Save daily counts to CSV

daily_counts.to_csv("daily_transaction_counts.csv")
print("\nDaily transaction counts saved to 'daily_transaction_counts.csv'")