14 Excel-like Functions in Python, Pandas, and Jupyter Notebook
A comprehensive list of tutorials in Python, Pandas, and Jupyter Notebook, explaining how to use 14 of your favorite Excel-like functions
Hello Excel super-user. My name is David, and I work on a Data Science team. I’d like to introduce you to a very popular analysis stack in the great wide world of Data Science: Python, Pandas, and Jupyter notebook.
This blog will guide you through setting up your computer to use this new analysis stack, and then walk through the Pandas/Python-equivalent of your favorite Excel functions, all executed in a Jupyter notebook.
As a former spreadsheet-jockey, I can tell you that getting started with this new data analysis stack is easy, and the GREAT NEWS FOR YOU is that it’s even easier if you’re familiar with Excel.
Let us begin.
Hello, Excel super-user
If you’ve been using Excel for a while, you’re well aware of the most common operations like IF statements, VLOOKUPS, Pivot Tables and others listed below.
