Look what touched down in my mailbox today... 🏈 _Football Analytics with Python & R_ by Eric Eager and Richard Erickson. I had the pleasure to be a tech reviewer for this book …
Continue Reading about Review: Football Analytics with Python & R →
Using Python with Excel (LinkedIn Learning & Madecraft)
I’m excited to share that “pandas Analytics for Excel users,” a course I produced with Madecraft, is now available on LinkedIn Learning. View the course with a one-month free trial …
Continue Reading about Using Python with Excel (LinkedIn Learning & Madecraft) →
Pandas analytics for Excel users (LinkedIn Learning & Madecraft)
I'm excited to share that "pandas Analytics for Excel users," a course I produced with Madecraft, is now available on LinkedIn Learning. Also be sure to check your local library, …
Continue Reading about Pandas analytics for Excel users (LinkedIn Learning & Madecraft) →
How to format a column as percentage in Excel using openpyxl
Excel'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 →
How to automatically adjust Excel column widths in openpyxl
Excel's popularity stems from its user-friendly data formatting and presentation capabilities. Take, for example, the nuisance of narrow columns. Resolving this issue in Excel is as simple as …
Continue Reading about How to automatically adjust Excel column widths in openpyxl →
How to understand the relationship between pandas, openpyxl and Power Query
In 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 →