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.