Michelle HoSaving Old Shared Shutterfly PhotosI’ve been on a mission lately to find and archive old photos. Today I found some links to shared Shutterfly photos in an old email account…Oct 16, 20201Oct 16, 20201
Michelle HoComparing Recession Unemployment RatesWhile I was in college in the middle of the Great Recession, I remember seeing a compelling chart made by one of my economics professor…Jun 17, 2020Jun 17, 2020
Michelle HoNatural Language Processing: can a computer solve SAT analogy questions?I use this space to write about mostly geospatial data and maps. Most of the time I just want to share some PostGIS or Python code…Nov 1, 2019Nov 1, 2019
Michelle HoMy notes from preparing for data science job interviewsI spent a month earlier this summer going through interviews for data science positions. Every company does interviewing differently…Oct 7, 2019Oct 7, 2019
Michelle HoPolygon-in-polygon spatial joins in PythonI’ve been trying to aggregate polygons to a grid. There seems to be a lot of examples for doing “point in polygon” aggregations. For my…Jun 16, 20191Jun 16, 20191
Michelle HoFaking DataWhen you’re making a proof of concept for a data tool, it helps to get your hands on some realistic sample data and that data is often…Sep 19, 2018Sep 19, 2018
Michelle HoSnapping Points to Street SegmentsThe NYPD Motor Vehicle Collisions dataset is a record of all motor vehicle collisions in NYC. It captures the location, any injuries or…Jun 26, 20181Jun 26, 20181
Michelle HoMerging together polygons on a common attributeDo you need to combine/merge polygons together into one entity? Then keep reading. This is a simple example, but can be applied to many…May 10, 20182May 10, 20182
Michelle HoWhere Should We Live?It all began when we started thinking “Hey! Let’s move in together!” But where? Obviously, I needed to try using CARTO and a dash of…Apr 12, 2018Apr 12, 2018
Michelle HoAdjacent Geometries with Same Attribute with ST_TouchesReal estate developers sometimes want to find adjacent lots that are owned by the same entity because these lots can potentially be merged…Apr 3, 2018Apr 3, 2018