4m8yprBe

1import io
2import datetime
3import pandas as pd
4import tinys3
5
6
7access_key = ''  
8secret_key = ''
9
10bucket = 'tenjin-to-acquired-prod'
11key = '2019-01-09/1233739175/ironSource/reporting_metrics.csv'
12date_from = datetime.date(2018, 12, 28)
13date_to = datetime.date(2019, 1, 3)
14
15s3 = tinys3.Connection(
16    access_key,
17    secret_key,
18    default_bucket=bucket,
19    tls=True,
20)
21
22with io.BytesIO() as buff:
23    buff.write(s3.get(key=key).content)
24    buff.seek(0)
25    df = pd.read_csv(
26        buff,
27        parse_dates=['date'],
28        na_values=0,
29    )
30
31df = df[(date_from <= df['date']) & (df['date'] <= date_to)]
32spend = df['reported_spend'].sum()
33
34print(spend / 100)