Comment on page

# Spreadsheet Formulas

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

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 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.

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.

Writing a formula using the MONTH function from Excel.

Last modified 9d ago