Covid cases data for Czech Republic - visualisation
First: load CSV data from ministry page
import wget, os
data_url = 'https://onemocneni-aktualne.mzcr.cz/api/v2/covid-19/testy-pcr-antigenni.csv'
out_file = './testy-pcr-antigenni.csv'
if os.path.exists(out_file):
os.remove(out_file)
wget.download(data_url, out=out_file)
Second: load data to Pandas
select * from './testy-pcr-antigenni.csv'
-- wow maybe easier option of loading CSV than pd.read_csv()
idobject
bbf4d44d-4f19-4ff2-80f5-c113b2841c930.1%
124f6c3c-8b0a-42b8-98c9-c501c05128570.1%
1153 others99.8%
datumobject
2020-06-010.1%
2020-06-020.1%
1153 others99.8%
0
bbf4d44d-4f19-4ff2-80f5-c113b2841c93
2020-06-01
1
124f6c3c-8b0a-42b8-98c9-c501c0512857
2020-06-02
2
e67e7856-3a44-4084-8f1c-3687b9aab67b
2020-06-03
3
bbe74eb5-8216-4a23-ab7a-22cd0c9abf24
2020-06-04
4
5e303fe2-fcc1-455c-b1fa-dd1740b1e567
2020-06-05
5
99e6a8f9-d38b-490f-af04-2e5ced9dacb8
2020-06-06
6
850af609-be75-40a3-9e84-3e06263d6155
2020-06-07
7
0621ab4f-20f0-404f-a5e3-89ac9903287e
2020-06-08
8
33284ebc-e065-4ea9-abfe-96cdf9780ed9
2020-06-09
9
2cbb573c-41c4-4111-a9b4-2e7bb48e515d
2020-06-10
Third: enjoy zoomable Plot.ly visualisation!
from datetime import datetime
from IPython.core.display import display, HTML, Markdown, Image
today = datetime.now()
display(Markdown(f'Last run: {today} UTC.'))