AI & Python #18: AI Enthusiasts Should Move from Excel to Python. Here's How

A guide on Python libraries Pandas and Numpy.

We’re continuing with out Behind AI series. I’ve just added a tab to the Artificial Corner site where you can follow all the editions of this series. Click here to see it.

As someone who has been working with Excel for many years, I know that the idea of learning things you can already do in Excel/VBA in a completely new environment like Python doesn’t sound so exciting.

However, in 2024 there are many reasons why Excel users should learn Python. Here are the top two reasons:

• Python is officially being integrated into Excel

• Python is the language of choice for learning AI and Machine Learning

I created a useful and simple guide I wish I had when I switched from Excel to Python. In this guide, we’ll use Python’s Pandas and Numpy libraries to replace Excel functions (IF, SUM, VLOOKUP, etc), pivot tables, and charts.