Automating a Tableau Public Dashboard

Manually updating Tableau dashboards isn't exactly hard. First you open up Tableau, next you open the workbook you wish to update, lastly you click on data in the toolbar, hover the dataset you wish to update and click refresh. Not hard, but doing it daily, can begin to be a pain and feel like a chore. Luckily! Tableau Public has google sheets as a datasource and allows you to keep the dashboard synced with the sheet daily updates. This will show you how to add a few lines to your pandas workflow to upload your dataframe to google sheets automatically.

more ...

Providence Police Cases & Arrests

April and March have seen a decline in arrests and case logs. Data is from https://data.providenceri.gov/ which sadly only provides the past 60 days for arrests and 180 days for case records. Due to the limited ammount of days I chose to show the data by week instead of monthly.

more ...


RI COVID-19 Emergency Temporary Licenses

3 graphs showing the profession, date issued and state of emergency temporary licenses provided by RIDOH to aid Rhode Island's health system in combating the coronavirus COVID-19 pandemic. The licenses are provided free for 90 days with an optional one-time renewal and has seen a lot of applications from neighboring states of MA and CT.

more ...

COVID-19 Cases by Location

A map showing COVID-19 cases for Rhode Island by city & town. The map shows the rate per 10,000 people to normalize the data by population. Population data used was Census 2017 ACS 5-year estimate. RIDOH surpressed values under 5, so those are shown as 0, City/Town data breakdown started being recorded 3/25.

more ...

Timeline of COVID-19 Cases

Tracking the historical record of data on COID-19 from Rhode Island Dept. of Health. This shows the data by day for positive cases, total tests done (positive + negative), total deaths, self-quarantining and the number of people hospitalized. Hospitalizations wern't recorded till 3/25, first death was 3/28.

more ...

RI Airbnb Rentals 2010-2020

A animated map showing the growth of Airbnb within the state of Rhode Island. Each dot represents a rental property/room on the year-month that they received their first review. There is a large concentration around Providence and Newport and other costal cities.

more ...

Rhode Island COVID-19 Cases

Rhode Island's Dept. of Health started releasing information regarding testing for coronavirus on their website. This information contains the following: Number of Rhode Island COVID-19 positive and presumptive positive cases, number of people who had negative test results at RIDOH's State Health Laboratory, number of pending test results, and approximate number of people who are currently instructed to self-quarantine in Rhode Island.

more ...