Learn practical skills, build real-world projects, and advance your career

Data Analysis of Texas Covid Count Data

Before starting the Data Analysis with Python: Zero to Pandas Course, I created a cloropleth map of Texas using the publicly available covid case count data from the Texas Department of State Health Services.

This notebook is a continuation of analysing that data from the State of Texas.

Download the Files

We are downloading the latest Covid-19 data from the Texas Department of State Health Services and the latest population estimate from the Texas Demographic Center

from urllib.request import urlretrieve

urlretrieve('https://dshs.texas.gov/coronavirus/TexasCOVID19CaseCountData.xlsx', 
            'TexasCOVID19CaseCountData.xlsx')
urlretrieve('https://demographics.texas.gov/Resources/TPEPP/Estimates/2018/2018_txpopest_county.csv', 
            'Texas2018PopulationEstimate.csv')

Install and import numpy and pandas, install xlrd for reading Excel files with pandas