Day: July 26, 2025

Show Only ...
Maps - Photos - Videos

Buck Settlement Lean-to

Been years since I've been back to this Lean-to and it's still in beautiful shape, maintained perfectly looking like new. And it's such a beautiful open canopy forest near the Glen Creek. 

Friday July 30, 2021 — Sugar Hill State Forest

Excel is not a data cleaning tool πŸ’Ύ

I keep seeing Facebook posts that have tips and tricks for data cleaning and processing with Microsoft Excel. Honestly I don’t recommend it.

Excel is fine for reviewing outputted data and very light weight data work, but you are much better off to use R and tidyverse or Python and PANDAS for all but the simplest data work. Often storing data is best done using a Parquet but don’t assume most people even know what one is.

Spreadsheets are not databases or for processing data. They’re excellent for reviewing data and transferring it between people in a format nearly anybody can understand but don’t try to get cute with Excel formulas and try to do things in Excel you really should use a data library to process and a database to store in.