Excel to Pandas Cheat Sheet
Translating Common Excel Functions to Python Pandas Methods.
This is my cheat sheet for commonly used Excel functions roughly translated to their Python Pandas equivalents.
Over the last 3 years I have increasingly found myself booting up a Jupyter Notebook to perform data analysis using Python Pandas rather than relaying on Excel. A few factors play into that:
speed when performing data analysis tasks: what one loses in GUI ability one can often make up for in speed of executing extractions, transformations, filters, calculations, etc.