Coronavirus Canada

The Canada COVID19 dataset consists of two files and extracted from the Public Health Canada website (https://www.canada.ca/en/public-health/services/diseases/2019-novel-coronavirus-infection.html) which contains the COVID-19 outbreak updates from all provinces and territories.
Statistics Canada - Population data by province: https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1710000901.

The dataset consists of the following attributes: pruid, prname, prnameFR, date, numconf, numprob, numdeaths ,numtotal ,untested , numrecover, percentrecover, ratetested, umtoday, percentoday. The following columns are dropped from dataframe: percentoday, numprob, prnameFR, and pruid,

In addition, the mortality rate and P_code were added to the dataframe. Few columns have null values in the early days due to no data collection at the national level. Therefore, those values are filled with '0' values. Correlation test is performed to understand the relationship between confirmed, death, and total cases and such variables are positively correlated.