Skip to content

Instantly share code, notes, and snippets.

@eshaben
Created June 9, 2022 16:41
Show Gist options
  • Save eshaben/a86348f56c547db92ed42d07b7b3bb2d to your computer and use it in GitHub Desktop.
Save eshaben/a86348f56c547db92ed42d07b7b3bb2d to your computer and use it in GitHub Desktop.
import pandas as pd
data = pd.read_csv('~/Downloads/export-address-token-0xd3dfd3ede74e0dcebc1aa685e151332857efce2d.csv')
receive = data.loc[data['From'] == '0xd3dfd3ede74e0dcebc1aa685e151332857efce2d', 'Value']
send = data.loc[data['To'] == '0xd3dfd3ede74e0dcebc1aa685e151332857efce2d', 'Value']
send_sum = 0
receive_sum = 0
for s in send:
if ',' in s:
s = s.replace(',', '')
send_sum += float(s)
for r in receive:
if ',' in r:
r = r.replace(',', '')
receive_sum += float(r)
print(receive_sum, send_sum)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment