Core Concepts

Introduces you to the high-level concepts helpful in understanding how the Mitosheet works.

The mito spreadsheet in a notebook

Mito is a spreadsheet that exists inside of a Jupyter Notebook, and helps you do Python data analytics. You can use Mito to explore and edit data like you would in Excel or Python.

A Mito spreadsheet inside of a JupyterLab notebook.

Pandas dataframes and the Mito Spreadsheet

Pandas is the most popular data analysis and manipulation tool in Python. It is based around the core concept of a "dataframe," which is a rectangular table of data with columns and rows.

Normally, you would write pandas code directly to manipulate your data, but by using Mito, you can explore and manipulate your dataframes in the mitosheet, directly within your notebook. Every tab inside of your Mitosheet represents a different Pandas dataframe.

Click the Add Column button in Mito? A column gets added to your dataframe. Pivot your data to create aggregate statistics? A new, tab with an aggregated dataframe is created.

Generating Pandas Code

For each edit you make to the Mitosheet, Mito generates pandas code below that corresponds to this edit, and puts this code directly below the mitosheet in the next code cell.

Code generated by Mito: importing a CSV file and adding a column.

Rerunning an analysis

When you run mitosheet.sheet(), Mito will automatically generate a unique ID to store the set of edits make to this mitosheet. This ID will appear as an automatically generated analysis_to_replay parameter to the mitosheet.sheet() function call.

As long as you pass this analysis_to_replay parameter to the mitosheet.sheet() call, Mito will attempt to replay that analysis to the mitosheet. Replaying an analysis means applying the same edits that you did in Mito again.

Since Mito will try and apply the same edits when an analysis_to_replay parameter is passed, differently structured datasets might make these edits invalid and Mito will error. For example, if you change the location of the file that you imported in an analysis, and then attempt to replay this analysis, it will fail (as it can no longer find the file to import).

If you want to start a fresh mitosheet, simply make a new mitosheet.sheet() call in a new code cell.