Spreadsheet Formulas

Write Excel-like spreadsheet formulas to edit your dataframes using Python.

Why Spreadsheet Formulas

The ability to write formulas to manipulate columns of data is a hallmark of any good spreadsheet tool. They allow you to create unique data transformations that are not easily captured in other point and click interfaces.

Mito Spreadsheet Formulas are different

Mito spreadsheet formulas work differently from Excel formulas in three keys ways:

1. Mito formulas can self-reference. For example, if you want to convert the column Name to Uppercase, you can write the formula =UPPER(Name) in the Name column itself. Not having to use helper columns helps you keep your dataframes clean.

2. Mito formulas do not automatically refresh. If the data that a column formula references changes, simply resubmit the column in order to recalculate it on the most up to date data.

3. By default, formulas apply to the entire column. If you enter a formula in a column, then it will autofill for all cells in that column.

Writing Spreadsheet Formulas

You can either write a spreadsheet formula in the formula bar or directly in the cells of the column you're looking to edit.

To write a spreadsheet formula in the formula bar:

1. Click on a cell in the column you want to set the formula of.

2. Double click on the formula bar to open it.

3. Make sure that Edit entire column is set to On.

4. Write the formula and press enter to submit the formula.

You can also write a spreadsheet formula by double clicking on a cell in a specific column that you want to edit. The editing process is the same otherwise.

You can see a full list of the Mito Spreadsheet Formulas here. You can also learn how to add your own functions to the Mito spreadsheet here.

Writing a formula using the MONTH function from Excel.