Create a Mito for Streamlit App
A Quickstart guide to creating your first Streamlit app with the Mito Spreadsheet.
Last updated
Was this helpful?
A Quickstart guide to creating your first Streamlit app with the Mito Spreadsheet.
Last updated
Was this helpful?
The easiest way to create your first Streamlit application with Mito is to try things yourself. Streamlit has an awesome developer story, so for each edit you make to your code, you can just refresh the page and see your new changes.
In this guide, we're going to use Mito for Streamlit to create an interactive app that allows users to explore Tesla stock data. We'll do some basic data cleaning, and then perform an analysis that computes the traded volume in the most recent month.
First, create a new Python script. Let's call it stock_data.py
Open stock_data.py in your favorite IDE or text editor, then add these lines:
Let's make the page wide, and set a title:
Now, run your Streamlit app from the command line:
The Streamlit app should open in a new tab in your web-browser. Check out that awesome title!
Now, let's use the Mito spreadsheet to display
You'll see a few buttons in the upper-right corner of your app asking if you'd like to rerun the app. Choose Always rerun, and you'll see your changes automatically each time you save the stock_data.py file.
When your app refreshes, you will see the Mito spreadsheet with Tesla stock data. Scroll around like you would in any other spreadsheet!
The return value of the spreadsheet is each of the tabs of the spreadsheet, as well as the code that corresponds to the edits you make in the spreadsheet. Let's display both:
Take a closer look at this dataset. It looks like the first row has an invalid date. Let's remove it from our analysis by right clicking on the row label 0 and then clicking Delete Rows.
Turn the Date column into a datetime. Click the Filter icon next to the Date header, and in the taskpane that opens, use the Dtype dropdown to select datetime.
Pause here and check out the dataframes displayed below the Mitosheet. Note that each
Turn the Volume column into a float. Click the Filter icon next to the Volume header, and in the taskpane that opens, use the Dtype dropdown to select float.
We're now ready to use more of Mito's advanced functionality. Let's create a pivot table that allows us to understand how the traded volume has changed over time.
Click the Pivot button in the Mito toolbar.
Add Date to the Rows section. Group date by year-month, so we can understand volume changes on a monthly lee.
Add Volume to the Values section. Select an aggregation type of sum.
If you cannot select sum for Volume, you may have forgotten to change Volume to a float. See step 4 in the section above.
This pivot table now displayes the total of traded volume per month. If you scroll below, you will see that this pivot table is returned from the Mito spreadsheet, and the code to generate this pivot table is returned as well.
That's it, you made your first app with Mito for Streamlit. Here's our finished script:
After you’ve built an app using Mito for Streamlit, it's time to share it! To show it off to the world you can use Streamlit Community Cloud to deploy, manage, and share your app for free.
It works in 3 simple steps:
Put your app in a public GitHub repo (and make sure it has a requirements.txt!)
Click 'Deploy an app' and then paste in your GitHub URL
See the rest of our documentation to see what other functionality is available in Mito, or continue to our to get ideas for how to use Mito in your Streamlit applications.
Sign into
That's it! You now have a publicly deployed app that you can share with the world. Click to learn more about .