3:30AM the coffee maker begins to gargle. 3:45AM I’m sitting in bed (or at my desk) with a cup of coffee in hand, laptop open, and brain waking up for a two hour working/learning session before I head out for a run. Over the past year and a half I’ve used these morning hours to … [Read more…]
The National Oceanic and Atmospheric Administration (NOAA) regularly publishes data on storm occurrences in the US. They make available annual data dating back to 1950 and it includes time-series, geographic proximity, and financial destruction information as well as storm characteristics (event type, width of tornado, wind gust estimates, etc.). While you could do thousands of … [Read more…]
Encountered what I think is a pretty common excel problem at work today. A colleague showed me an excel spreadsheet that was reading warehouse locations as scientific notation. For example, location 05E03 was being read into excel as 5.00E+03 and if you tried to edit the cell or convert it to text, you’d be given … [Read more…]