Edit your data directly. Mito now allows you to edit any data in the raw dataset that you import to Mito. Just double click on the cell and edit the value that appears. Intelligent type handling will make sure your edits make sense in the context of your data.
Filter unique values. By clicking on any column header, and then clicking on the Values tab, you can now see, search, and sort a list of all the unique values in a specific column. Toggle the values to filter them out easily!
Support for parsing number representations like Mil, Bil, etc.
No column header changes. Mito now supports all common string and number columns, which means it plays much better with your other Python scripts. No need to figure out how Mito has changed your column headers!
Fix minor bugs in passing strings to the mitosheet.sheet function directly, where seperators were not correctly detected.
Export Graph Code. You can now quickly create graphs in Mito and copy + paste the generated code. This gives you the flexibility to fully customize your graphs using Plotly.
Mito now saves the last graph that you generated for each sheet, making it easy to look at the graph, edit your data, and then reexamine the graph without having to create it from scratch.
We now support more date formats!
The Summary Statistics Graphs now display NaN values, making it easier to identify lossy data.
New Types of Merges. Added different types of merges to the merge modal. Users can do a
lookup style joins!
Added a redo button and a reset analysis button to make it easier to do exploratory data anlaysis with the tool.
Various improvements to the pivot taskpane to make it more dynamic.
Create new sheet button added to the footer of Mito.
Moves the save analysis and download dataframe modals to taskpanes.
Continues to update the remaining old-Mito-styled components to the new style.
New and Improved Mito. Mito is now dramatically prettier and easier to use. We've taken the past few weeks to standardize and improve our spacing, colors, text, and interactive elements throughout the tool. The initial feedback is very positive: Mito is much more pleasant to look at, and to use! Try out the new redesign today by updating.
Pivot table editing. Switching to a pivot table that has already been created will allow you to edit the existing configuration of that pivot table. This makes data slicing dramatically more dynamic - and makes your analyses go that much faster!
Security improvements that give users more control over logging.
In-app feedback improvements. Ask users a larger variety of questions over multiple usages.
Text Button implementation to standardize all buttons across Mito.
Automatic parenthesis closing for formula. Mito has your back! If you forget to add closing parenthesises to your formula, Mito will add them for you.
Automatically open the import sidebar when Mito has no data.
Let users double click on a file inside the import file browser to import a file.
Don't display hidden folders on Windows in the file explorer.
Import File Browser. The Mito import sidebar is now easier to use than ever. You can navigate through your file system to import files.
EXP sheet function is now available. It calculates raising
e to the power of the passed series.
Mito can now be imported using any name. Mito no longer requires the import statement to read
import mitosheet. For example, you can now use
import mitosheet as ms.
The in-app feedback prompt displays less frequently.
The FILLNAN function performs faster.
Auto-documenting code. The Mito generated code is dramatically cleaner and more informative. Each section of generated code is commented to make it easier for you to understand and communicate exactly how your code edits your data.
Graphing v2.1. Better automatic zoom on graphs, as well as more natural defaults for bar chart graphs.
Improve in-app feedback mechanisms to be less annoying and more helpful.
Improve upgrade prompt to include instructions on how to upgrade.
Fixes a bug in the display of the column summary stats graph that made it to big.
In-place type editing v2. Better handling of date formats, better display of icons, and better display of floating point values.
Graphing v2.0. Allows you to toggle graph types and add mulitple columns to each graph for more advanced analysis.
Boolean filtering. Now, you can filter columns with boolean values in them to True or False :)
Fixes a small bug causing bad behavior when viewing steps for certain step types.
Fixes a bug in the display of the sorting buttons.
Fixes a bug in the FILLNAN function where it would fill the referenced column in some cases.
In place type editing. Using the control panel, users can change the type of their data columns.
The type of each series is displayed in the column header.
Adds "is not exactly" filter condition for string columns.
Fixes bug with displaying the datetimes in the sheet.
Mito graphing v2 is out. Using the Graphing Sidebar, users can create scatter plots to visualize the relationship between two columns in their dataest, and use the interactive graph to dig down into their data.
Adds "is not exactly" filter condition for string columns.
Filter speedup. Filtering large datasets is now dramatically faster in all analyses, and will no longer slow down the sheet.
Remove the confirmation modal that popup when you deleted columns.
Mito now supports graphing relationships between columns. Through the Graphing Sidebar, users can create scatter plots to visualize the relationship between two columns in their dataest.
Mito is now available for JupyterLab 3.0. To use Mito for JupyterLab 3.0, follow the install instructions in the documentation. We will continue to support Mito for JupyterLab 2.0.
NOTE: if you want to upgrade from JupyterLab 2.0, you can find upgrade instructions here.
Better errors when you import a directory instead of a file.
Redirect to upgrade correctly when the upgrade popup appears.
Adds a small delay to filter messages so that tons of filter messages don't queue while the user is typing, resulting in much faster filtering in most cases.
Fix a minor bug with column renames occuring to the original dataframes.
Adds a variety of more tours to the tool, which allows users to get a better understanding of the actions they want to perform.
Adds in-app feedback, which is accessible through the documentation, and will help you better communicate how you want to improve the tool!
Suppress the JupyterLab context menu within Mito, to avoid confusing users with confusing messages.
Remove invalid licensing.
Dramatically improve signup flow and privacy communication.
Add working version of the first tour of the tool, showing you how to pivot. More coming soon!
Import data by passing a file path to mitosheet.sheet() or through the import taskpane.
Instructions on how to import data when Mito contains no data.
Make the cell editor larger.
Stop merge from operating with less than two sheets.
Import overhaul! Importing is now live updating, and presents better error messages in the case that you do not have CSV files in the correct location.
Fixed formatting bugs with the fullscreen label.
The column suggestions displayed while writing a formula is now case insensitive, making it easier to find your columns when you have lots!
The formula bar lets the user copy and paste the formula, which is particularly helpful for copying and pasting values into your Python scripts.
The formula bar better supports large inputs. It no longer wraps the text, and instead lets you scroll to see your formulas.
Added sheet functions KURT, STDEV, VAR and SKEW. Use them to calculate common statistical properties in your mitosheet formulas.
When writing formulas in the sheet, column suggestions are now case insensitive.
Added support for date deltas. You can now subtract two datetime column and see the result in the Mito frontend!
You can now keep the column summary statistics tab open while navigating through your data. This should make data exploration easier!
Added labels to the Mito toolbar buttons, so its easier to discover Mito's functionality.
Fix bugs with inserting multiple columns before setting formulas.
Fix bugs with changing the selected column during formula editing.
Note, do not install this release as it contains bugs in formula editing.
Added internationalization. Mito now supports all languages!
Added the POWER function.
Minor generated code optimizations.
Mito now correctly refreshes cells after certain types of formula changes.
Adding a new column now adds the column directly to the right of the selected column.
Added the median and sum to the column summary statistics.
The selected column is now highlighted!
The column header cell can be used to select a column.
Added support for Big5 Chinese character encoding.
Deleting a column will now select the column in its place.
Switching sheets now correctly updates the selected column.
Major improvements to replaying an analysis! Click the replay analysis button to see that your analyses have moved to the taskpane, where you can:
See a list of all your saved analyses
Click an analysis to see the list of steps it contains
Rename your analyses
Delete analyses you no longer need
Fix major bug where multiple filters being applied and edited could delete portions of your analysis. We highly recommend updating to fix this bug.
Adds the MIN and MAX function. They, unsurprisingly, take the minimum and maximum of the inputs.
Dramatically reduces the memory required for most common operations in Mito.
Stopped clicking on a different row from generating an OFFSET function, as it is most likely backwards compatible behavior.
Fixed a bug where the Mitosheet crashes when your deleting certain tabs.
Step rewinding! Open the Step History list in the upper right of the toolbar, and then click on a specific step to see the sheet at that step. This allows you to more easily audit what edits you have made to your data.
Dramatically reduce memory required to interact with large datasets in Mito, fixing some MemoryErrors experienced by users.
Added a basic Step History, allowing you to see all historical steps you've taken in your analysis.
Added the CORR function, allowing you to compute the correlation between two columns
Graph downloading! After opening the column control panel and navigating the summary stats tab, you can click on the download icon to download a graph.
Fixed graph labels getting cut off when they got too long.
Added filter groups! Using filter groups, you can nest sets of filter conditions together, which allows you to more easily express complex filtering criteria.
Added support for the Russian alphabet
Display column dtype in the column control panel
Allow users to select mulitple rows at once
Throw a better error message if a user tries to pass a filename to a mitosheet.sheet call
Visualize your data by using graphs in Mito!
To visualize a distribution of your data, click the Filter icon in the column header, and then in the column control panel that opens, navigate to the Summary Stats tab. A graph that displays a distribution of your data will be displayed.
Scrolling down in this tab will show you summary statistics for your column, allowing you to understand the distribution further.
As this is an early feature, graphing currently is limited in size and scope. If you're trying to visualize bigger datasets or use create graphs for presentation - shoot us a message! We'd be happy to help you get going.
Added signup and demo booking for local installation.
Added upgrade reminders to local installation.
Fixed download so that the entire sheet is now downloaded when there are >2k rows.
Fixed a minor bug in column renaming that make it impossible to use your mouse to select the column header.