Member-only story
How to Write Excel-like Formulas in Python
A short tutorial on how to write Excel-like formulas with the Mito package in Python
Published in
4 min readNov 2, 2021
Many Python users are transitioning from spreadsheets because of a Python package that allows users to use Excel-like syntax. It is a spreadsheet environment for JupyterLab to help you with your Python analysis.
Meet Mito — a Python package that initializes an interactive spreadsheet into your JupyterLab Environment. For each edit you make in the spreadsheet, Mito generates production-ready Python code. It’s also free to use.
By reading this article you’ll learn:
- How to perform basic Excel-like operations in Python
- How to write Excel-like formulas in Python
In case you’ve missed my previous articles about this topic, see Mito — A Spreadsheet that Generates Python.
Excel Syntax in Python
To use Excel syntax, first initialize the Mitosheet using the commands:
