#343: Do Excel things, get notebook Python code with Mito

Talk Python To Me

Michael Kennedy

Technology

4.8 • 635 Ratings

🗓️ 30 November 2021

⏱️ 66 minutes

🔗️ Recording | iTunes | RSS

🧾️ Download transcript

Summary

Here's a question: What's the most common way to explore data? Would you say pandas and matplotlib? Maybe you went more general and said Jupyter notebooks. How about Excel, or Google Sheets, or Numbers, or some other spreadsheet app? Yeah, my bet is on Excel. And while it has many drawbacks, it makes exploring tabular data very accessible to many people, most of whom aren't even developers or data scientists. On this episode, we're talking about a tool called Mito. This is an add-in for Jupyter notebooks that injects an Excel-like interface into the notebook. You pass it data via a pandas dataframe (or some other source) and then you can explore it as if you're using Excel. The cool thing is though, just below that, it's writing the pandas code you'd need to do to actually accomplish that outcome in code.

Transcript

Click on a timestamp to play from that location

0:00.0	Here's a question. What's the most common way to explore data? Would you say pandas and
0:05.8	map plot lib? Maybe you went a little broader and more general and said Jupiter notebooks.
0:11.6	How about Excel or Google Sheets or numbers or some other spreadsheet app? Yeah, my bet is on
0:16.6	Excel. And while it has many drawbacks, it makes exploring tabular data very accessible to many
0:23.1	people, most of whom aren't even developers or data scientists. On this episode, we're talking about a
0:29.2	tool called Mido. This is an add-in for Jupyter notebooks that injects an Excel-like interface
0:35.6	right into the notebook. You pass it data via a Pandas data frame or some other source,
0:41.3	and then you can explore it as if you're using Excel.
0:44.3	The cool thing is though, just below that in another cell,
0:47.3	it's writing the Pandas code.
0:49.3	You need to actually accomplish that outcome in code.
0:52.3	I think this will make Pandas and Python data exploration way more accessible to many more people.
0:58.0	If you've been intimidated by Pandas or know someone who has, this could be what you're looking
1:02.3	for.
1:03.4	This is Talk Python to Me, episode 343, recorded November 8th, 2021.
1:21.6	Thank you. November 8th, 2021. Welcome to Talk Python, a weekly podcast on Python.
1:25.0	This is your host, Michael Kennedy.
1:26.8	Follow me on Twitter where I'm at
1:28.2	M.Kennedy and keep up with a show and listen to past episodes at talk python.fm. And follow the show on
1:33.9	Twitter via at Talk Python. We've started streaming most of our episodes live on YouTube.
1:39.7	Subscribe to our YouTube channel over at TalkPython.fm slash YouTube to get notified about upcoming shows and be part of that
1:46.4	episode. This episode is brought to you by Shortcut and Linode, and the transcripts are sponsored by
	...

Please login to see the full transcript.

Previous episode | Next episode

Disclaimer: The podcast and artwork embedded on this page are from Michael Kennedy, and are the property of its owner and not affiliated with or endorsed by Tapesearch.

Generated transcripts are the property of Michael Kennedy and are distributed freely under the Fair Use doctrine. Transcripts generated by Tapesearch are not guaranteed to be accurate.