Learn how to integrate your Python or R data processing tasks into excel — Preamble I love wrangling, munging, and processing data in Python or R. However, my employer does most everything in Excel. I wanted to take my Python or R code and integrate it within my Excel documents. Furthermore, I needed to output the results directly into the Excel workbook. I found I…

A GIS project implemented entirely with Python — Preamble Some background info…I recently signed up to volunteer for Statistics Without Borders, which provide pro bono services in statistics and Data Science. As a Data Analyst/Scientist with a penchant for environmental responsibility social equity, and sustainability, I felt it would make sense to use my skills for social good. This…

A tutorial for those interested in creating a time lapse heat map. — Preamble This article is essentially a tutorial for people interested in utilizing the Folium package to construct a time lapse heat map within the Python/Pandas environment. That said, it does provide interesting insights on station locations and most active hours for utilizing bike shares. …

Using multiple callback inputs to produce dynamic Dash apps — Background I had envisioned a Dash app where one could hover over a choropleth map and trigger changes in the the dashboard, however, I also wanted a dropdown selector, that would trigger the same response. Essentially, I wanted to create an output, that had multiple inputs, and I needed to specify…

How to construct a bivariate choropleth map in Python with GeoPandas — Background For quite some time, I have had an interest in improving the visual impact of dual variable comparisons on a choropleth map. In the past, I constructed choropleth maps layered with graduated symbology, but felt it didn’t adequately explicate the narrative. I recently came across a blog post by Josh…

How to create a dash choropleth map to filter your visualization — Background Think of all the trees in the New York City (NYC) that help sequester carbon so that New Yorkers can breath some semblance of clean air. Without them, we would be screwed, bottom line — NYC Tree Health is important. In 2015 NYC Parks & Recreation organized a large scale…

Mapping US gun violence mass shootings with ipyleaflet in Shiny for Python — Preamble The purpose of this blog is two-fold: To showcase building a choropleth map application in Shiny for Python. To elucidate the location of deaths and injuries resulting from mass shootings within the US. I had been thinking of creating an app on gun violence and mass shootings and figured with…

Use os.walk() and PyPDF2 to automate pdf file splitting from multiple sub-directories with a Python script — Background If you are reading this you know, most office type jobs require repetitive tasks. This is where having a bit of Python knowledge comes in handy. In fact, there is a great book published on this subject by Al Sweigart entitled Automate the Boring Stuff with Python. …

How to build an interactive NYC COVID-19 GIS tracker application with RShiny and Leaflet — Overview NYC Department of Mental Health and Hygiene (DOHMOH) has a fantastic open source COVID-19 database on their publicly accessible Github. The data is cleaned and requires minor wrangling to track salient aspects of the COVID-19 pandemic. For the most part the visuals they provide on NYC.gov …