Live data from Hacker News

Mito – Excel-like interface for Pandas dataframes in Jupyter notebook

trymito.io

61–70 of 101 posts

Re: Mito – Excel-like interface for Pandas dataframes in Jupyter notebook

#61
post #33

Earlier quoted context omitted.

I would caution against this approach in general (unless you’re working with unusually uniform data from a deterministic source — in my world that is rarely the case). Summary statistics are useful but taken in isolation they can mislead. One loses the ability to get a feel for interesting non-aggregated phenomenon. I find it’s important to actually “touch” the raw data even if only in a buffered, random sampling sor…

If you want to use open-source Python-based visualizations instead of Tableau, the following tools allow the creation of custom plots - including the ability to export the underlying code. - bamboolib (proprietary license - acquired by Databricks in order to run within the Databricks notebooks) - mito (GPL license) - dtale (MIT license)

If you can write visualisations in Python itself, I am a big fan of Altair's syntax (https://github.com/altair-viz/altair), which is based on vega-lite. A while back, I wrote a brief guide and comparison of the main plotting libraries: https://datapane.com/reports/87NNEJ7/the-ultimate-guide-to-p...

One benefit of having them in actual code is that you can programmatically automate the creation of things like dashboards and reports. For instance, schedule a script to share an interactive plot every Monday morning, or build a live dashboard that updates every 10m. This opens up a lot of possibilities that would be impossible in a traditional drag-and-drop tool.

Re: Mito – Excel-like interface for Pandas dataframes in Jupyter notebook

#62
To the founders of mito, regarding the mito GPL license:

What is your take on that regarding usage inside cloud provider's notebooks like AWS, GCP, Azure, Databricks?

Is it allowed or not allowed by the license? And who should/can control the usage since users can install any kind of Python library in those environments.

And, separately from the maybe ambiguous legal answer: What is your personal intention with the license?

Disclosure: I am employed by Databricks.

Re: Mito – Excel-like interface for Pandas dataframes in Jupyter notebook

#63

Earlier quoted context omitted.

If you are a large company trying to migrate to Python, you might also want to have a look at bamboolib.com which was acquired by Databricks. bamboolib is very similar to mito (hard to tell who was first). The advantage is that it runs within Databricks which gives you the ability to scale to any amount of data easily and Databricks has many (and growing) security certifications e.g. HIPAA compliance. bamboolib can b…

bamboolib appears to be closed-source. You're at their mercy.

bamboolib co-founder here:

It's correct that bamboolib is (still) closed-source (which might be subject to change but I don't make promises).

It's also correct that customers can extend the bamboolib UI in various ways via plugins that they can author themselves. That empowers them to build bamboolib into the kind of tool that they want.

Also, all the code is always exported and thus, there is at least no "code lockin".

Regarding being "at their mercy", I can say that there are many customers who are happy by the service that we provide.

Re: Mito – Excel-like interface for Pandas dataframes in Jupyter notebook

#64

Earlier quoted context omitted.

Thanks for that feedback. Mito's approach to telemetry is that we never log any of your data or metadata about your data. We don't track things like the size, shape, or content of your data. We do collect info about app usage, things like which buttons users click. This allows us to focus development time on improving the features that are used most often. That being said, it's important to us that there is a way to…

Just to be very clear, the way to be "totally telemetry-less" is to pay you?

Yes

Re: Mito – Excel-like interface for Pandas dataframes in Jupyter notebook

#65
post #6

Looks neat - pandas is very powerful and it makes it more approachable for non-programmers. However paid product like this - I probably wouldn't make the switch to this and then have the company go belly up leaving users stranded. Too much risk. Hope for the best though - pandas is pretty fantastic.

You might want to check out a tool Vizier: https://vizierdb.info (I'm one of the devs). Direct interaction with notebooks state (e.g., dataframes as spreadsheets) is one of the central ideas, and it's fully open source.

This looks cool :)

Re: Mito – Excel-like interface for Pandas dataframes in Jupyter notebook

#66
post #61

Earlier quoted context omitted.

If you want to use open-source Python-based visualizations instead of Tableau, the following tools allow the creation of custom plots - including the ability to export the underlying code. - bamboolib (proprietary license - acquired by Databricks in order to run within the Databricks notebooks) - mito (GPL license) - dtale (MIT license)

If you can write visualisations in Python itself, I am a big fan of Altair's syntax ( https://github.com/altair-viz/altair ), which is based on vega-lite. A while back, I wrote a brief guide and comparison of the main plotting libraries: https://datapane.com/reports/87NNEJ7/the-ultimate-guide-to-p... One benefit of having them in actual code is that you can programmatically automate the creation of things like dashbo…

Thanks for mentioning Altair. I am personally also a big fan.

I am one of the co-founders of bamboolib and we are actively thinking about adding support for altair to the Plot Creator (instead of just relying on Plotly).

Since we are talking other viz options in Python, there are of course also matplotlib, seaborn, plotly, and more.

Re: Mito – Excel-like interface for Pandas dataframes in Jupyter notebook

#67

To the founders of mito, regarding the mito GPL license: What is your take on that regarding usage inside cloud provider's notebooks like AWS, GCP, Azure, Databricks? Is it allowed or not allowed by the license? And who should/can control the usage since users can install any kind of Python library in those environments. And, separately from the maybe ambiguous legal answer: What is your personal intention with the l…

Hiya kite_and_code - thanks for the question + good to see you here :)

Our understanding of our license is evolving - we're first time open source devs, and as I'm sure you know it can be a tricky process. That being said: we totally support Mito users using Mito from notebooks hosted in the cloud!

Currently, we have quite a few users using Mito in notebooks hosted through AWS, GCP, etc. We’re aiming to be good stewards of open source software, and want to see Mito exist where ever it is solving users problems!

We’ve had lots of folks in lots of environments request Mito, and are actively working on prioritizing supporting those other environments. We added classic Notebook support last month (funnily, I thought it’d take weeks to support, and it took 2 days lol) - and are looking into VS Code, Streamlit, Dash, and more!

EDIT: due to comment below, I edited this comment for clarity that we 100% support users using Mito from notebooks in the cloud!

Re: Mito – Excel-like interface for Pandas dataframes in Jupyter notebook

#68
post #67

To the founders of mito, regarding the mito GPL license: What is your take on that regarding usage inside cloud provider's notebooks like AWS, GCP, Azure, Databricks? Is it allowed or not allowed by the license? And who should/can control the usage since users can install any kind of Python library in those environments. And, separately from the maybe ambiguous legal answer: What is your personal intention with the l…

Hiya kite_and_code - thanks for the question + good to see you here :) Our understanding of our license is evolving - we're first time open source devs, and as I'm sure you know it can be a tricky process. That being said: we totally support Mito users using Mito from notebooks hosted in the cloud! Currently, we have quite a few users using Mito in notebooks hosted through AWS, GCP, etc. We’re aiming to be good stewa…

I can totally relate that finding a suitable open-source business model is a fuzzy journey.

Nevertheless, from the user perspective I would love to hear a more clear answer - at least for e.g. the next 6-12 months.

Currently, it seems like you are tolerating usage inside the cloud providers without taking a clear stance. I think this creates fear, uncertainty, doubt and slows down mito adoption within the cloud.

I would appreciate a clear statement in the near future around your thinking on how mito should be made available in those environments. After all, the clouds are an environment to where more and more users are migrating to. Or at least use it in parallel to local setups.

I can understand if you don't want to answer on the spot in case you don't have a clear stance yet. In this case, please take your time and let us know when you made your decision.

Really love what you're doing and the innovation that you are pushing for! <3

Re: Mito – Excel-like interface for Pandas dataframes in Jupyter notebook

#70

Earlier quoted context omitted.

A good example of what you are warning against is Anscombe’s quartet https://en.wikipedia.org/wiki/Anscombe's_quartet

Histograms and Boxplots (and IQRs) don't lie tho...

Boxplots don't lie, but they can mislead as any summary statistic, data viz or model can. https://blog.bioturing.com/wp-content/uploads/2018/11/BoxVio...

Misleading histograms depend totally on the bin-width tho.

Post reply on HN