# Mito Spreadsheet

- [Core Concepts](https://docs.trymito.io/how-to/overview-of-the-mitosheet.md): Introduces you to the high-level concepts helpful in understanding how the Mitosheet works.
- [Creating a Mitosheet](https://docs.trymito.io/how-to/creating-a-mitosheet.md): Use Mito to generate Python code, start automating your Excel processes.
- [Open Existing Virtual Environments](https://docs.trymito.io/how-to/creating-a-mitosheet/open-existing-virtual-environments.md): Reopen your existing virtual environments to keep working where you left off.
- [Importing Data](https://docs.trymito.io/how-to/importing-data-to-mito.md)
- [Importing CSV Files](https://docs.trymito.io/how-to/importing-data-to-mito/importing-csv-files.md): How to import a CSV file into Mito.
- [Importing from Excel Files](https://docs.trymito.io/how-to/importing-data-to-mito/importing-from-excel-files.md): How to import a Excel file into Mito.
- [Importing Dataframes](https://docs.trymito.io/how-to/importing-data-to-mito/importing-dataframes.md): How to import dataframes file into Mito.
- [Importing from a remote drive](https://docs.trymito.io/how-to/importing-data-to-mito/importing-from-a-remote-drive.md): How to import CSV and Excel files from a remote file system.
- [Import: Generated UI from any Python Function](https://docs.trymito.io/how-to/importing-data-to-mito/import-generated-ui-from-any-python-function.md): Automatically generate UI's to import data from your enterprise's databases.
- [Importing from other sources](https://docs.trymito.io/how-to/importing-data-to-mito/importing-from-other-sources.md): Import any pandas dataframe into Mito.
- [Graphing](https://docs.trymito.io/how-to/graphing.md): This documentation explains how to create presentation-ready graphs in Mito.
- [Graph Creation](https://docs.trymito.io/how-to/graphing/graph-creation.md): Generate interactive, presentation-ready graphs using Mito's point and click interface.
- [Graph Styling](https://docs.trymito.io/how-to/graphing/graph-styling.md): Set graph titles, axises, colors and more to create presentation-ready graphs.
- [Graph Export](https://docs.trymito.io/how-to/graphing/graph-export.md): Export your graphs as Python code, images or HTML files to share your insights with your peers.
- [Pivoting/Group By](https://docs.trymito.io/how-to/pivot-tables.md): Create Excel-like pivot tables using a spreadsheet interface.
- [Filter](https://docs.trymito.io/how-to/filter-data.md): This documentation will teach you how to filter datasets in Mito.
- [Filter By Condition](https://docs.trymito.io/how-to/filter-data/filter-by-condition.md): Use filter conditions like greater than, contains, starts with and much more to filter and explore your data.
- [Filter By Value](https://docs.trymito.io/how-to/filter-data/filter-by-value.md): View the unique values in your dataset and filter them in/out.
- [Mito AI](https://docs.trymito.io/how-to/mito-ai.md): Mito AI is one of the fastest ways to transform your data. This documentation explains how.
- [Summary Statistics](https://docs.trymito.io/how-to/summary-statistics.md): This documentation will teach you how to access the summary statistics and frequency chart for any data column.
- [Type Changes](https://docs.trymito.io/how-to/type-changes.md): This documentation explains how to change the data type of data and formula columns using Mito's type casting features.
- [Spreadsheet Formulas](https://docs.trymito.io/how-to/interacting-with-your-data.md): Write Excel-like spreadsheet formulas to edit your dataframes using Python.
- [Custom Spreadsheet Functions](https://docs.trymito.io/how-to/interacting-with-your-data/bring-your-own-spreadsheet-functions.md): Create your own spreadsheet functions and share them with your entire organization.
- [Formula Reference](https://docs.trymito.io/how-to/interacting-with-your-data/mito-spreadsheet-formulas.md): Mito supports 75+ of the most common Excel spreadsheet formulas, implemented in Python.
- [Using VLOOKUP](https://docs.trymito.io/how-to/interacting-with-your-data/using-vlookup.md): Joining dataframes using a Python VLOOKUP formula in Mito.
- [Editing Individual Cells](https://docs.trymito.io/how-to/editing-individual-cells.md): Edit your data with the ease of a spreadsheet.
- [Combining Dataframes](https://docs.trymito.io/how-to/combining-dataframes.md): Join datasets together by selecting keys, concatenate dataframes on top of each other, or find unique values between datasets.
- [Merge (horizontal)](https://docs.trymito.io/how-to/combining-dataframes/merging-datasets-together.md): Join the columns of two dataframes together.
- [Concatenate (horizontal)](https://docs.trymito.io/how-to/combining-dataframes/concatenate-dataframes.md): Concatenating dataframes allows you to combine two or more dataframes by stacking their rows on top of each other.
- [Anti-merge (unique)](https://docs.trymito.io/how-to/combining-dataframes/anti-merge-unique.md): Find records unique to one dataframe.
- [Sort Data](https://docs.trymito.io/how-to/sort-data.md): This documentation will teach you how to sort data columns in Mito.
- [Split Text to Columns](https://docs.trymito.io/how-to/split-text-to-columns.md): Split a column into multiple based on a delimiter.
- [Deleting Columns](https://docs.trymito.io/how-to/deleting-columns.md): Remove entire columns from your dataframe just using your keyboard.
- [Deleting Rows](https://docs.trymito.io/how-to/deleting-rows.md): Remove entire rows from your dataframe just using your keyboard.
- [Column Headers](https://docs.trymito.io/how-to/column-headers.md): Column headers identify the specific column within your dataframe. Mito provides a variety of tools for working with column headers directly.
- [Editing Column Headers](https://docs.trymito.io/how-to/column-headers/editing-column-headers.md): Rename your column headers with the ease of a spreadsheet.
- [Promote Row to Header](https://docs.trymito.io/how-to/column-headers/promote-row-to-header.md): Select a row of your dataframe to become the new column headers.
- [Deduplicate](https://docs.trymito.io/how-to/deduplicate.md): Deduplicate repeated entries from your dataframe.
- [Fill NaN Values](https://docs.trymito.io/how-to/fill-nan-values.md): NaN values are one of the most common sources of errors. Use Mito's Fill NaN values taskpane to choose how you handle your missing values.
- [Transpose](https://docs.trymito.io/how-to/transpose.md): Convert your columns into rows, and rows into columns.
- [Reset Index](https://docs.trymito.io/how-to/reset-index.md): Reset your dataframe's Index after sorting, filtering, or importing your data to cleanup your workspace.
- [Unpivot a Dataframe (Melt)](https://docs.trymito.io/how-to/unpivot-a-dataframe-melt.md): Convert a dataframe from wide format to long format.
- [Formatting](https://docs.trymito.io/how-to/formatting.md): Format your dataframe to generate presentation-ready Excel files.
- [Column Formatting](https://docs.trymito.io/how-to/formatting/column-formatting.md): Format numbers as currency, percentage, accounting, scientific notation or more.
- [Dataframe Colors](https://docs.trymito.io/how-to/formatting/dataframe-colors.md): Changing the color and style of the dataframe within Mito.
- [Conditional Formatting](https://docs.trymito.io/how-to/formatting/conditional-formatting.md): Explore or highlight your data by changing the format of specific cells.
- [Exporting Data](https://docs.trymito.io/how-to/exporting-to-csv-and-excel.md): This documentation explains how to get data out of Mito.
- [Download as CSV](https://docs.trymito.io/how-to/exporting-to-csv-and-excel/download-as-csv.md): Export a single dataframe to a CSV file.
- [Download as Excel](https://docs.trymito.io/how-to/exporting-to-csv-and-excel/download-as-excel.md): Export dataframes to an Excel file.
- [Generate code to create Excel and CSV reports](https://docs.trymito.io/how-to/exporting-to-csv-and-excel/generate-code-to-create-excel-and-csv-reports.md): Generate an Excel or CSV file each time you run your code.
- [Using the Generated Code](https://docs.trymito.io/how-to/using-the-generated-code.md): Use Mito generated code to complete your analysis or automate your reports.
- [Turn generated code into functions](https://docs.trymito.io/how-to/using-the-generated-code/turn-generated-code-into-functions.md): Convert the Mito generated code into a Python function to make it even easier to reuse.
- [Changing Imported Data](https://docs.trymito.io/how-to/changing-imported-data.md): Rerun your Mito analysis on new data to refresh a report.
- [Code Snippets](https://docs.trymito.io/how-to/code-snippets.md): This documentation will teach you how to use code snippets and import your own
- [Custom Editors: Autogenerate UI from Any Function](https://docs.trymito.io/how-to/custom-editors-autogenerate-ui-from-any-function.md): Extend Mito with custom dataframe transformations, like proprietary algorithms, calculations, and domain-specific knowledge.
- [Find and Replace](https://docs.trymito.io/how-to/find-and-replace.md): The quickest way to check if values exist in your data, and substitute them with others.
- [Bulk column header edits](https://docs.trymito.io/how-to/bulk-column-header-edits.md): Transform all of the column headers in your dataframe with just one click of a button.
- [Code Options](https://docs.trymito.io/how-to/code-options.md): Customize your Mito generated code by converting it to a function, selecting parameters and more.
- [Scheduling your Automation](https://docs.trymito.io/how-to/scheduling-your-automation.md): Create fully automated processes by scheduling your Python script to run on GitHub
- [Keyboard Shortcuts](https://docs.trymito.io/how-to/keyboard-shortcuts.md): Speed up your Mito workflow with keyboard shortcuts!
- [Upgrading Mito](https://docs.trymito.io/how-to/upgrading-mito.md): We move quick. Upgrade to get the latest and greatest.
- [Enterprise Logging](https://docs.trymito.io/how-to/enterprise-logging.md): Connect Mito to your internal logging servers so you can track Python retention at your firm.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.trymito.io/how-to.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.