Mito Tutorial Ep. 2 - Importing Data
HTML-код
- Опубликовано: 12 сен 2024
- In this video, we have Jake (co-founder of Mito) to show us how you can import data into Mito. Mito can handle any tabular data. If it's in a dataframe, then it's ready for Mito! There are two ways to get data into Mito: (1) passing a dataframe to the Mitosheet and (2) using the in-app import popup.
🌟 Download Kite for FREE www.kite.com/g...
⭕ Step-by-step instructions
1. Passing Dataframes to Mito
Mito displays any dataframe that is passed directly to a mitosheet.sheet(df1, df2). To see an example of displaying a dataframe in a Mitosheet, copy and run the code below in a JupyterLab cell:
import Python packages
import mitosheet
import pandas as pd
create some simple data to display
train_stations = pd.DataFrame({'Zip': [21001, 97321, 49224, 87102, 24910, 22301], 'City': ['Aberdeen', 'Albany', 'Albion', 'Albuquerque', 'Alderson', 'Alexandria'], 'State': ['MD', 'OR', 'MI', 'NM', 'WV', 'VA'], 'Ticket_Office': ['N', 'Y', 'N', 'Y', 'N', 'Y']})
demographics = pd.DataFrame({'Zip': [21001, 97321, 49224, 87102, 24910, 22301], 'Median_Income': [53979.0, 112924.0, 37556.0, 28388.0, 30914.0, 54087.0], 'Mean_Income': [66169.0, 147076.0, 50371.0, 39529.0, 40028.0, 64068.0], 'Pop': [18974.0, 11162.0, 14900.0, 22204.0, 5383.0, 19504.0]})
render the Mitosheet with the data
mitosheet.sheet(train_stations, demographics)
Using Pandas, you can create dataframes by reading csv files, Excel files, or even querying an SQL database. If you have dataframes you want to interact with and manipulate, pass them into a Mitosheet!
2. Using the Import Taskpane
Mito also has a point and click method for importing CSV files. To use it, first upload a CSV file of your choosing to JupyterLab. To upload data to JupyterLab, follow the (very) short tutorial here • JupyterLab Uploading F...
Then, after creating a Mitosheet:
- Click on the import button in the Mito toolbar.
- Select the files you want to import, and Mito will import them into the sheet.
Source: docs.trymito.i...
⭕ Support my work:
🌟 Subscribe to this channel (Coding Professor) / @codingprofessor
🌟 Subscribe to my other channel Data Professor www.youtube.co...
🌟 Join the Newsletter of Data Professor newsletter.data...
🌟 Buy me a coffee www.buymeacoff...
⭕ Recommended Books:
🌟kit.co/datapro...
✅ Python Basics: A Practical Introduction to Python 3 amzn.to/3awdWgm
✅ Learn Python Programming (The no-nonsense, beginner's guide) amzn.to/2RFpSpn
✅ Learn to Program with Minecraft amzn.to/3x2MujZ
✅ Automate the Boring Stuff with Python, 2nd Edition: Practical Programming for Total Beginners amzn.to/2QzkyDs
⭕ Disclaimer:
Recommended books and tools are affiliate links that gives me a portion of sales at no cost to you, which will contribute to the improvement of this channel's contents.
⭕ Stock photos, graphics and videos used on this channel:
✅ Video intro made using Placeit 1.envato.marke...
#python #mito #trymito #codingprofessor
Sir you are doing a ton for us! Thank you soooo much!
It's my pleasure
Sir, me after typing the mitosheet.sheet( ) I don't get any gui beneath it as shown in the video. What to do ?
Hi, make sure to install Mito in a Jupyterlab as detailed here docs.trymito.io/getting-started/installing-mito