AI Transformations

Mito AI allows you to edit a spreadsheet with just plain text prompts.
Mito AI is currently in open beta. As such, we collect additional usage data, including dataframe names, column names, and some values in the dataframe. By using Mito AI, you are agreeing to our privacy policy as well as OpenAI's privacy policy.

Setting up your OPENAI_API_KEY

To start using Mito AI, first, create an OpenAI key:
  1. 1.
    Sign up for an account
  2. 3.
    Create a new key by clicking Create new secret key.
  3. 4.
    In the first code cell of your Jupyter Notebook, add the following code. Make sure to replace "sk-..." with your Open AI API key!
import os
# Replace the sk- with your secret key from step 3
os.environ['OPENAI_API_KEY'] = "sk-..."
You are now ready to use Mito AI! Simply rerender your Mito sheet, and click the AI button in the toolbar.

Using Mito AI

  1. 1.
    Open the AI taskpane by clicking the AI button in the toolbar.
  2. 2.
    In the Prompt section, type the edit you want to make to your data. For example: "filter out rows with null values." Then click Generate Code.
  3. 3.
    Mito AI will generate code that attempts to make this edit. Read the code that has been generated to confim it is correct, and then click Execute Code.
  4. 4.
    After the code executes, scroll down to the Results section to see the effect of the generated code on your data.