Teaching analytics with modern Excel
openpyxlExcel's popularity is attributed to its user-friendly data formatting and presentation features. Although Python offers distinct advantages for Excel, its raw data output is often unsuitable for …
Continue Reading about How to format a column as percentage in Excel using openpyxl →
pandas, openpyxl and Power QueryIn an earlier post I provided an overview of how to use the pandas and openpyxl packages together to automate the production of Excel workbooks. In that post, I likened pandas as the "Power Query of …
Continue Reading about How to understand the relationship between pandas, openpyxl and Power Query →
I hate the way files are run in a camera. While it was cool to learn for this post that DSCN stands for "Digital Still Capture - Nikon," it means nothing to me! For this post, I will be renaming the …
Continue Reading about Renaming all files in a folder in R →
This post serves as a follow-up on a previous post about scheduled collection of Weather.gov's XML feed in R, which itself was a follow-up to retrieving real-time data from Weather.gov in …
Continue Reading about Downloading 24-Hour Weather Updates in R →
