Vaccination age 70-79 in Czechia

import pandas as pd

df_vaccines = pd.read_csv('https://onemocneni-aktualne.mzcr.cz/api/v2/covid-19/ockovani.csv') df_vaccines

idobject

datumobject

a3aa4307-e5a4-4801-8478-082424c81f57

2020-12-27

08631678-9759-4215-ba8d-fdaf163a85ab

2020-12-27

61f1a4de-b57e-49ad-8f7a-80f43dd079d1

2020-12-27

5f23647c-b74c-4903-9154-6cd0e56e947a

2020-12-27

6888290e-3029-425e-87e6-77ac2ef91dcb

2020-12-27

fd2b5055-dfe2-48b1-b075-9c0d461a16e2

2020-12-27

264f508e-c1d1-4120-88ce-49056e3e1498

2020-12-27

e4190c4a-8874-41b7-a082-e62a6b547659

2020-12-27

f9bc4971-33ae-4686-a127-9374b8721898

2020-12-27

7a36f73f-dce3-456e-bbed-353b4f52bf46

2020-12-27

SELECT datum, SUM(prvnich_davek) as prvnich_davek FROM df_vaccines WHERE vekova_skupina IN ('70-74', '75-79') -- age group 70-79 AND datum > '2021-03-01' -- date after March 1, 2021 GROUP BY datum ORDER BY datum

datumobject

2021-03-020.1%

2021-03-030.1%

815 others99.8%

prvnich_davekint64

0 - 22485

2021-03-02

4698

2021-03-03

7754

2021-03-04

10246

2021-03-05

9867

2021-03-06

4341

2021-03-07

4218

2021-03-08

12149

2021-03-09

15307

2021-03-10

20279

2021-03-11

22485

SELECT *, -- let's do a cumulative sum of first_shot (prvnich_davek) SUM(prvnich_davek) OVER(ORDER BY datum ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cumulative FROM df_vaccines_sorted

datumobject

2021-03-020.1%

2021-03-030.1%

815 others99.8%

prvnich_davekint64

0 - 22485

2021-03-02

4698

2021-03-03

7754

2021-03-04

10246

2021-03-05

9867

2021-03-06

4341

2021-03-07

4218

2021-03-08

12149

2021-03-09

15307

2021-03-10

20279

2021-03-11

22485