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
SQL
Saved to variable
dfselect * from './testy-pcr-antigenni.csv'
-- wow maybe easier option of loading CSV than pd.read_csv()
idobject
8c7bcfe8-1411-4593-b08f-7facd75df25a0.1%
5d119346-3a7e-4a02-a903-7b22d049f65e0.1%
722 others99.7%
datumobject
2020-06-010.1%
2020-06-020.1%
722 others99.7%
0
8c7bcfe8-1411-4593-b08f-7facd75df25a
2020-06-01
1
5d119346-3a7e-4a02-a903-7b22d049f65e
2020-06-02
2
071e0875-4fde-4864-b1d7-e8784fbb66d2
2020-06-03
3
3552f8ce-94fa-41a8-9b2e-c3402a31cccf
2020-06-04
4
cf89bf3b-cbab-4d32-8c07-3a7a4a1f3675
2020-06-05
5
a898a509-c259-4692-8239-cff3e5f8a62a
2020-06-06
6
e4952504-ca1c-461a-8770-d95939104cb0
2020-06-07
7
1f52e16a-c06e-448d-a529-5eca42879b36
2020-06-08
8
fbace9f7-4b3a-463b-b785-dacd7a03bb52
2020-06-09
9
45f78e3a-5fb6-4282-81fc-53ea059330ae
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.'))