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.

Providence's JUMP Bike program provides location data of every bike currently available through the gbfs data feed. Using Python and AWS you can sorta create trip data of the bikes. While the gbfs data is directly from the company, it's not ment to be used for trip data. However currently it is the only data provided for Providence and there is no official trip information publicly available.

This notebook will take a look at how many votes occur each year, when the session ends and how many votes occur in the final days of a session compared to the year as a whole for both the House and Senate.

Its no secret that Rhode Island's legislature leans overwhelmingly in the favor of Democrats. However, I wanted to see just how many bills introduced by Republicans go on to pass both chambers and become law. Also, how often the parties work together on Bi-Partisan bills and how all of these metrics have changed over the years since 2007.

Bills in Rhode Island face a big hurdle, making it out of committee and not being "Held for Further Study". Once a bill is introduced and sent to committee, the first vote it recieves is whether or not it should be "Held for Further Study". A bill held for further study is indefinitely postpone, however can be considered again by the committee.

"The Ripple Effect" is a campaign by RIDOT to highlight the damages caused not only to a drunk driver, but the effects on others due to the poor choices made by a drunk driver. This looks at a few of the metrics stated in the web graphic and checks them against the FARS dataset.

A look at donations made to Gina Raimondo's campaign for Q3 2017.

A look at donations for the 2016 Presidential Election