Importing from other sources

Because Mito works seamlessly with Pandas dataframes, with only a bit of custom code, you can get any data you want into a mitosheet.
Importing from a database
Here, we provide some internal links for reading from common databases into Pandas dataframes:
​MySQL​
​Oracle​
​Sqlite​
​PostgresSQL​
etc. Simply google "Reading {database name} into pandas dataframe" to get a tutorial for your database!
After getting the data from your database into a dataframe, simply import the dataframe into Mito.
Importing from a webpage
Pandas provides an easy solution for getting data from a webpage into a pandas dataframe, which you can then pass to Mito. See a tutorial that uses the pd.read_html function here.​
After getting this webpage data into a dataframe, simply import the dataframe into Mito.
Other connections
If you have data from a different data source you're looking to read into Mito, the first step is to get it into a pandas dataframe. Simply google "Reading {data source} into pandas dataframe," and you will most likely find an easy three-step tutorial for doing just this.
Then, after getting the data from your data source into a dataframe, simply import the dataframe into Mito to begin to work with it.
Importing Dataframes
​
​

Last modified 4mo ago