In an earlier post, I discussed typical challenges Excel users face when transitioning to Python: This article will explore the unique “gotchas” that arise specifically when integrating Python in Excel. Importing packages Python packages are crucial for streamlined and clear data analysis. Many standard data-related Python packages come pre-installed in ...

The availability of Python integration within Excel has made Python an accessible and valuable skill for many Excel users to consider adding to their toolkit. However, as an open-source programming language, Python operates differently from proprietary spreadsheet software like Excel. This post examines a significant distinction—the use of packages ...

After a pandemic-induced hiatus and move to fully virtual, the Global Excel Summit is BACK in hybrid format this February 2024, live from London, UK. I’m super excited to participate in person at this year’s event. Would you like to join me? Use promocode GEORGE at checkout to get 10% ...

In a previous post I explored some “quick wins” for wrangling and analyzing data in Python that would be otherwise difficult to do in Excel. That post largely avoided data visualization, so this post will be on a similar topic — visualizations that would be difficult to build in regular Excel ...

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 and recommend it to anyone interested in, as the subtitle suggests, learning data science through the lens of sports. ...