aarondia

10 ms·

1. 61.▲
   by aarondia 6y ago

   I'm a big fan of this one too: https://spritesmods.com/?art=veccart&page=5
2. 62.▲
   by aarondia 6y ago

   As a bit of background on Mito, it works by passing the parameters from the frontend spreadsheet to the Python kernel backend, which transpiles the spreadsheet formula into Python/Pandas code [0]. So what we're hoping to do down t
3. 63.▲
   by aarondia 6y ago

   I totally agree that this makes sense for certain types of Excel work -- the data analysis, report generating workflows. You can see my comment above about how we're addressing some of these issues with Mito. However, not sure that the
4. 64.▲
   by aarondia 6y ago

   There's also a workaround in Google Sheets where you can store your data in BigQuery and use the spreadsheet to interact with it.
5. 65.▲
   by aarondia 6y ago

   You're definitely correct that its a nuanced question whether for a given (user, analysis) pair they are better off in Excel or Python/R/etc. Specifically with respect to building intuition for a dataset, however, there is a
6. 66.▲
   by aarondia 6y ago

   Lack of interoperability is an interesting angle, but not one that I've ran into quite as much. I've usually gotten around that by converting to a csv file in the case of data, or screenshotting graphs, etc. Would love to hear a b
7. 67.▲
   by aarondia 6y ago

   I'm less familiar with the R ecosystem, but there are tools in the Python world to go that direction -- https://xlsxwriter.readthedocs.io/
8. 68.▲
   by aarondia 6y ago

   We're still exploring the business model to support the project. Right now, Mito is free to trial, and we're experimenting with a subscription plan somewhere in the range of $10 per month. I'd say about half of our users are
9. 69.▲
   by aarondia 6y ago

   There's a bunch of ways that Mito and Visidata are different. The two largest probably being: 1) Mito is an extension to JupyterLab whereas Visidata is a CLI tool. As a result, Mito is a react frontend that is more of a traditional Exc
10. 70.▲
    by aarondia 6y ago

    Feel free to Twitter DM me @_aaronDR, would love to hear about what you're building + get you set up with Mito :)
11. 71.▲
    by aarondia 6y ago

    That's a good point -- and maybe horrendous was too strong of a word. It's actually been really interesting talking to people who come from the Excel world vs the Python world first. There's a group of people we've ran i
12. 72.▲
    by aarondia 6y ago

    Excel, and more importantly, the spreadsheet is the best way to build intuition for a dataset, hands down. The alternatives, especially when it comes to Python and the default pandas output in a Jupyter Notebook are horrendous. Where Excel
13. 73.▲
    by aarondia 6y ago

    Good catch. There's another more detailed response I just left to a similar comment, but the TLDR is that we do some logging of metadata of the dataframes passed to the tool, and what features are used. If you're interested in usi
14. 74.▲
    by aarondia 6y ago

    Thanks for that callout. We appreciate the perspective and will work on adding more disclosures of where logging does occur, making it easier for the user to opt out, and review what we are logging and how we can reduce it. I think your ana
15. 75.▲
    by aarondia 6y ago

    The merging docs are only trumped in unintuitivenes by the .iloc docs :)
16. 76.▲
    by aarondia 6y ago

    Thanks for both of those tips, and totally understand the concerns that come along with it. Will push a fix right now!
17. 77.▲
    by aarondia 6y ago

    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
18. 78.▲
    by aarondia 6y ago

    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, abo
19. 79.▲
    by aarondia 6y ago

    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 t
20. 80.▲
    by aarondia 6y ago

    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
21. 81.▲
    by aarondia 6y ago

    We are! We started working on it when school moved online due to Covid, and have been working on it full time since graduation.
22. 82.▲
    by aarondia 6y ago

    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 buildi
23. 83.▲
    Show HN: Mito – Write Python/Pandas faster by editing a spreadsheet, in Jupyter(trymito.io)

    101 points by aarondia 6y ago|29 comments