How to effortlessly work with spreadsheets in Python using MITO

In this video, we have Jake from the MITO team to show us the new features of MITO for working with spreadsheets in a Jupyter notebook? Mito generates Python code that corresponds to the edits made in the spreadsheet (via the point and click). Now you can effortlessly analyze tabular data in Python with a few clicks of the mouse.

⭕ Links for this video:

⭕ Time stamps:
0:00 Introduction
0:51 Importing Data
1:27 Merging Datasets
2:15 Pivoting Data
2:49 Sorting Data
3:12 Filtering Data
3:45 Graphing and Statistics
4:02 Functions

⭕ Playlist:
Check out our other videos in the following playlists.

⭕ Recommended Books:

⭕ Stock photos, graphics and videos used on this channel:

⭕ Follow us:

⭕ 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.

#mito #spreadsheet #spreadsheets #exploratorydataanalysis #datawrangling #datascience #dataanalyst #analytics #machinelearning #dataprofessor #bigdata #machinelearning #datamining #bigdata #ai #artificialintelligence #dataanalytics #dataanalysis #dataprofessor #excel #microsoftexcel #msexcel #googlesheets

[ross]

Great video. Would love a detailed video on how you turn your project results into research papers. Cheers, Ross.

[JonathanKarr]

I really like how you used spreadsheets with Python. I hope that your channel continues to grow. It's amazing to see that we have similar passions for teaching others Python on YouTube.

[TinaHuang]

So cool!! Honestly watching your videos is what I do to keep up with the industry 🔥

[WOLF]

Bro, keep it up. Can't thank you enough for sharing your knowledge and quality content.

[MagnoliaBeats]

Cool! It’s kinda like PowerQuery but not trash.

[huaweihonor]

Nice. Would you recommend using this Mito library or raw coding instead ? for a Python/pandas begginer user (advance Excel). Kind regards,

[HenkLeerssen]

Great video. Does this library also work with IDE (without notebook)?

[mitmc]

Thanky you for informative video.
I cannot see the save button in my jupyter lab environment.
Is there any possible reason for this?
My environment is as follows

jupyterlab 3.1.7
jupyterlab-pygments 0.1.2
jupyterlab-server 2.7.1
jupyterlab-widgets 1.0.0

mitoinstaller 0.0.94
mitosheet3 0.3.155
monotonic 1.6

[yosolonopuedo]

This is a very nice app. Thanks for the update! Do you know if it is going to be free or paid when they release it?

[DeepeshChonkar]

Facing issue while installing mitosheet in conda ENV

[mjacfardk]

Thanks for your generous support
Is this extension working on google colab?

[jaimemcqueen]

I can't edit individual cells in a newly created column, I have to either select column "then set cell value" or I have to toggle the "edit entire column" switch off for each cell. Please help.

[greatex]

Hi, just curious to know if I can use it in a big datasets - 1TB? Thanks

[medicalpump]

Python will do this automatically by one line code anyway installing dataframe

[yohaneskeraf]

Hi Sir, or anyone in here, please help me, i got an error alert when start the mitosheet, what i have to do to fix? MitoWidget(analysis_name='UUID-a74f1c31-e679-42b0-9479-dfdc2cbd03e2', code_json='{"imports"; "from mithosheet i...