[HN Gopher] Show HN: Mito - Write Python/Pandas faster by editin...
___________________________________________________________________
Show HN: Mito - Write Python/Pandas faster by editing a
spreadsheet, in Jupyter
Author : aarondia
Score : 67 points
Date : 2021-03-07 17:10 UTC (5 hours ago)
(HTM) web link (trymito.io)
(TXT) w3m dump (trymito.io)
| benleim wrote:
| How did you make the translation part of it?
| aarondia wrote:
| There's two types of translations that occur in Mito, writing
| spreadsheet formulas, and then everything else (merging,
| pivoting, etc.)
|
| For the spreadsheet formula part, we parse the formula in the
| Jupyter Python kernel and convert it to Pandas code. We
| actually found a bit of a trick to make this easier. TLDR: We
| defined Python functions that have the same name as the
| spreadsheet formulas, it helps us avoid building writing a
| formal language grammar + syntax tree. If you're interested in
| reading about it a bit more, we actually have a short blog post
| that you can checkout: https://trymito.io/blog/transpiler
|
| The second type of translation (merging, pivoting, etc) sends a
| message to the backend with the parameters configured from the
| point and click tool. And then executes the equivalent Pandas
| code in the Python kernel and writes the code to the Jupyter
| Cell.
| narush wrote:
| Hey HN - Super excited to hear any feedback y'all have on Mito or
| our docs. Happy to answer any questions here!
| needleballista wrote:
| Looks dope
| paluter wrote:
| Seems pretty cool. Does this only work in Jupyter?
| aarondia wrote:
| Currently, Mito only works in Juptyer Lab version 2.0. We don't
| work in either Jupyter Notebooks, Jupyter Lab 3.0, or Google
| Collab. However, we'd love to expand to those in the future.
|
| Since we only support Jupyter right now, about half of the
| early Mito users are using it locally and the other half are
| using it on a hosted version of Jupyter Lab, which just makes
| it really easy to get setup without worrying about Python
| installations.
| aarondia wrote:
| Hi HN! I'm here with my co-founders (narush + jacobdi) to show
| you Mito (https://trymito.io/) -- a point-and-click data science
| Jupyter Lab extension that automatically turns your analysis into
| Python.
|
| We started building Mito 6 months ago after finishing up
| undergrad engineering + business school (aka Excel School). We
| became comfortable doing data analysis in visual environments,
| but were held back by Excel's 1M row limit + the inability to
| create repeatable processes. Doing analyses in Python was wayyy
| more powerful, but also required tons of trips to Stack Overflow
| + pandas documentation.
|
| After a few months of building, pivoting (our vision) + lots of
| refactoring, Mito now supports writing spreadsheet formulas,
| pivoting (dataframes), merging, saving + applying macros, and the
| tiniest bit of graphing. And it generates the equivalent pandas
| code in real time for all of it :)
|
| You can download Mito by following our always-WIP documentation
| [0]. We'd love to hear your first impressions of the tool
| (especially if you download it) + your experiences in/building
| for the data science/analytics community.
|
| [0] https://docs.trymito.io/getting-started/installing-mito
| mritchie712 wrote:
| Are you working on this full time?
| aarondia wrote:
| We are! We started working on it when school moved online due
| to Covid, and have been working on it full time since
| graduation.
| samoshay wrote:
| Congrats on the launch! Tool seems super useful -- I hate having
| to memorize/wade through all of Pandas docs/flags to get
| something done. Especially indexing and grouping...
| aarondia wrote:
| Thanks -- definitely agree. Grouping/Pivot Tables was one of
| the first feature we added because the earliest users were
| showing us Jupyter Notebooks full of pandas pivot tables. But
| when they had small datasets, they'd always use Excel instead
| because its so much easier using their interface.
| Saurinp wrote:
| Heyo! Looks super cool and useful. Are you open souce?
| aarondia wrote:
| Mito is not currently open source, although it is available
| through PyPI. You can follow our installation instructions
| https://docs.trymito.io/getting-started/installing-mito to get
| setup locally.
|
| Or if you don't have Jupyter already set up on your computer,
| we have a hosted version of Jupyter Lab that you can make an
| account on.
| xiphias2 wrote:
| Please don't use span on links on your web page, my mouse cursor
| didn't change, and it was very strange.
|
| Maybe I'm too snobbish, but I don't trust a company with my data
| that doesn't know basic HTML (I would install the local version
| though).
|
| Also the github links don't work (npmjs and python repositories
| show that it's using BSD license): https://github.com/mito/mito
___________________________________________________________________
(page generated 2021-03-07 23:02 UTC)