Publications by George Mount
Python in Excel: How to understand how objects work
The concept of objects significantly distinguishes Python from Excel, enhancing its importance in programming. Integrating Python objects into Excel introduces unique behaviors and functionalities, which will be the focal point of this blog post. Download the following to explore this intriguing intersection of Python and Excel.Download the exercis...
7921 sym 14 img 1 tbl
How to create a Pandas DataFrame with Python in Excel (three ways)
Python in Excel provides a user-friendly and data analysis-optimized approach, especially suitable for general analysts beginning with Python. Notably, it defaults to loading all data inputs as Pandas DataFrames, a wise decision considering Excel users’ familiarity with tabular structures. Basic Python, on its own, isn’t inherently tailored for...
4047 sym 6 img
How to insert a Python cell into your Excel worksheet (three ways)
The integration of Python into Excel marks one of the most thrilling advancements for the application in recent times. This feature offers Excel users a multitude of straightforward and rapid benefits.However, as with any Excel feature, the journey to mastering workbooks begins with a single cell. Here are three methods to help you insert your inau...
3136 sym 14 img
How to navigate common pitfalls with using Python in Excel
In an earlier post, I discussed typical challenges Excel users face when transitioning to Python:Python for Excel users: How to avoid common pitfallsThis article will explore the unique “gotchas” that arise specifically when integrating Python in Excel.Importing packagesPython packages are crucial for streamlined and clear data analysis. Many s...
4993 sym 16 img
How to understand the initialization environment in Python for Excel
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...
5064 sym 2 img
Python for Excel users: How to avoid common pitfalls
As an Excel trainer with a focus on data analytics, I have instructed thousands of spreadsheet users in Python. This extensive experience has allowed me to analyze patterns in the learning process.Below are several frequent errors and misconceptions I’ve observed, especially among Excel users, who often approach problems with a distinct mindset a...
7372 sym 2 img
Live from London! Global Excel Summit 2024
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% of all tickets:Please note I am an affiliate of this program ...
2152 sym 2 img
Here are some quick wins for visualizing data with Python in Excel
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 but relatively straightforward in Python, particul...
10565 sym 38 img
Here are some quick wins for using Python in Excel
As a long-time Python enthusiast who has frequently recommended Excel users delve into Python (and even authored a book on the subject), a prevalent question I encountered from hesitant Excel users is:What can I achieve in Python that I can’t in Excel?With the recent integration of Python into Excel, much of the skepticism around learning Python ...
10492 sym 36 img
Review: Football Analytics with Python & R
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.What I particularly love about this title is that it sta...
1297 sym 8 img