Talk Python To Me

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

6 snips
Nov 30, 2021
Ask episode
AI Snips
Chapters
Transcript
Episode notes
ANECDOTE

Mito Evolved From A GitHub For Excel Project

  • Mito's origin traces to earlier work on versioning and diffing for Excel (a 'GitHub for Excel').
  • After building tools for power Excel users, they pivoted to embedding spreadsheet UX in Jupyter to reach broader data users.
INSIGHT

Mito Turns Visual Iteration Into Reusable Pandas Code

  • Typical Mito workflows start with CSV or DB-loaded DataFrames, then use sheet features (summary stats, filtering, formulas) to iterate visually.
  • Mito converts those interactions into reusable pandas transforms so users stop redoing manual spreadsheet steps monthly.
ADVICE

Generate Library Code Instead Of Recreating Features

  • Generate code that uses established libraries (like plotly) rather than reinventing plotting.
  • Mito outputs plotly code for charts so users can modify visuals with the full external library instead of being locked in.
Get the Snipd Podcast app to discover more snips from this episode
Get the app