Data Analysis in Python for Excel Users (ft. Mito)

If you've ever edited a spreadsheet and wondered what the equivalent Python code would be, this video is for you! Mito is a Jupyterlab extension that allows you to quickly and easily generate Pandas data analysis scripts using the Excel functions you already know.

Shoutout to Mito for sponsoring this video!

Video Breakdown:
Intro: 0:00-1:49
Installing Mito: 1:49-2:07
Importing data: 2:07-2:55
Merging data: 2:55-3:58
Pandas code being generated and why it's useful: 3:58-5:01
Filtering and sorting data: 5:01-6:13
Automatic summary stats and graphing: 6:13-6:37
Pivot tables: 6:37-7:07
Incorporating Excel functions: 7:07-7:56
Conclusion: 7:56-8:41

#dataanalysis #excel #python #datascience #jupyterlab #pandas

[ronfrancv]

Will you create your own courses someday?

[nikitakhd]

Really useful content across all videos (literally watched them all one after the other)!

Massively underrated by YouTube algorithms: this video only 2k views in 5 months!

Keep it going and don’t give up -> hard to find concise clear content on where to start if you are looking to switch to data science from economics background as I do. Thanks a lot!

[jek]

Pandas is my go-to every time I want to import excel file. I do not even know there is a package like this existing in the world of Python. Thanks for sharing. This is informative. Do more videos that are related to packages that are not commonly use.
PS: Literally, watching your video during my working hours.

[bensonmuchoki]

You making playing with data so silly and fun! Thank you for introducing me to Mito

[bridget]

Ah, what perfect timing for your video! Not even kidding, today I was actually trying to do some data analytics in Python...BUT then newbie-me quickly got intimidated and decided to force Excel to do VLOOKUP, RIGHT, IF, and Pivot charts several times for some 250K+ record CSV files! 😅 Mito will be a perfect "interpreter" between Excel functionalities and Python code for me! 😃

[gemmaweber]

This is amazing… also I totally winked at the spreadsheet pun 🤣 bc dirty data jokes are totally acceptable lol

[yukithejapanese]

This is great! I didn't know there was a tool to codify your excel work 😃

[bdougie]

I lol’d too many times in the first 30 seconds of this video. Great jokes

[Nedwin]

Horraayy!! This is what I need. Thanks mentor! 🙏

[benliu]

Thanks for sharing this great tool! I believe Mito is valuable for BAs who want to develop their technical skills, while DSs may still prefer Pandas.

[rain]

This is amazing! Thank you for this video!

[vahidparsa]

Awesome! Your videos are very helpful 🙏🏻❤️

[Alex-grix]

What a missed opportunity with the title. Excel in python (pun intended)

[harunbakirci]

what do you think about Rstudio ı have been using R for data science for a long time. what do you sugeest me ? R is suitable for machine learning help me please ?

[enteatenea]

Totally agree one spends time learning pandas and asking again and again the same question that I keep browser from removing last searches so that I find fast what I had

[xqz]

Should I learn R even I am proficient in Pandas?

[rohitpandey]

Can you please provide some free resources to learn mathematics for data science,

[dj-zlkv]

All this nonsense when you could just use R