Low Code Python with Mito
Mito is an open source python package that allows the users to generate Python by editing a spreadsheet. You call Mito into your Python environment, and each edit you make in the Mitosheet will generate the equivalent Python in the code cell below.
Here are the install commands for Mito:
python -m pip install mitoinstaller
python -m mitoinstaller install
Then open Jupyter Lab and call the Mitosheet
The full instructions can be found in the documentation.
Graphing in Mito
Mito provides an interactive environment for configuring your visualizations. Before you create your charts, you can use the full spreadsheet interface to clean and wrangle your data. These features include, pivoting, merging, filtering, sorting, spreadsheet functions and more!
Mito is built using the Plotly graphing library. Plotly is the best Python package for building interactive visualizations. When paired with Mito, you can access the power of Plotly without needing to write the code yourself. As you create your chart in Mito, the Plotly code will automatically generate in the code cell below. All you have to do is click “Copy Graph Code” and paste it into any code cell.
The diagram below shows where you can open the graphing menu inside Mito and what the graphing interface looks like. The button to copy the graph code is at the bottom of the screen.
Below is the auto-generated code that Mito creates from the graph above:
# Import plotly and create a figure
import plotly.graph_objects as go
fig = go.Figure()# Add the histogram traces to the figure
for column_header in ['Style']:
fig.add_trace(go.Histogram(x=ramen_ratings[column_header], name=str(column_header)))# Update the layout
# See Plotly documentation for customizations: https://plotly.com/python/reference/histogram/
Data Analysis in Mito
Mito is all about making Python more accessible. Many new, intermediate, and advanced users spend much of their time looking at documentation to get the correct syntax — Mito eliminates this. All you need to do is complete the task in the spreadsheet and Mito will write the code for you.
Mito also allows the user to see their data in real time, at every point in their analysis — no need to be constantly printing out the DataFrame.
Mito’s functionality includes:
- Pivoting Tables
- Importing and Exporting Excel Files
- Filtering and Sorting
- Spreadsheet Formulas
- Summary Statistics
- Filling Null Values
- and more!
Mito is open source and you can give it a star on Github here!