Mito
Search…
Mito
Mito Docs
Getting Started
Installing Mito
Core Concepts
Feature Reference
Creating a Mitosheet
Importing Data
Importing CSV Files
Importing Excel Files
Importing Dataframes
Importing from a remote drive
Importing from other sources
Graphing
Pivoting/Group By
Filter out Rows
Summary Statistics
Type Changes
Spreadsheet Formulas
Editing Individual Cells
Combining Dataframes
Sort Data
Split Text to Columns
Deleting Columns
Deleting Rows
Column Headers
Deduplicate
Fill NaN Values
Transpose
Unpivot (Melt) a Dataframe
Formatting
Exporting Data
Using the Generated Code
View in Mito Button
Upgrading Mito
How To
Pass a dataframe into Mito
Create a line chart of time series data
Delete Columns with Missing Values
Exploratory Data Analysis
Create a Bar Chart
Split a column on delimiter
Misc
Videos
Release Notes
FAQ
Terms of Service
Privacy Policy
Powered By GitBook
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.
​
​
Previous
Importing from a remote drive
Next - Feature Reference
Graphing
Last modified 16d ago
Copy link
Outline
Importing from a database
Importing from a webpage
Other connections