TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

Show HN: Mito – Write Python/Pandas faster by editing a spreadsheet, in Jupyter

101 点作者 aarondia大约 4 年前

15 条评论

aarondia大约 4 年前
Hi HN! I&#x27;m here with my co-founders (narush + jacobdi) to show you Mito (<a href="https:&#x2F;&#x2F;trymito.io&#x2F;" rel="nofollow">https:&#x2F;&#x2F;trymito.io&#x2F;</a>) — a point-and-click data science Jupyter Lab extension that automatically turns your analysis into Python.<p>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&#x27;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.<p>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 :)<p>You can download Mito by following our always-WIP documentation [0]. We&#x27;d love to hear your first impressions of the tool (especially if you download it) + your experiences in&#x2F;building for the data science&#x2F;analytics community.<p>[0] <a href="https:&#x2F;&#x2F;docs.trymito.io&#x2F;getting-started&#x2F;installing-mito" rel="nofollow">https:&#x2F;&#x2F;docs.trymito.io&#x2F;getting-started&#x2F;installing-mito</a>
评论 #26377888 未加载
samoshay大约 4 年前
Congrats on the launch! Tool seems super useful –– I hate having to memorize&#x2F;wade through all of Pandas docs&#x2F;flags to get something done. Especially indexing and grouping...
评论 #26378726 未加载
kite_and_code大约 4 年前
If you like Mito, here are some other, similar tools that you might like:<p>Open-Source:<p>- dtale: Very similar to Mito. On top of mito, it provides basic data exploration and can also be launched from within VSCode. Also exports pandas code but not inline into a cell.<p>- pandasgui: alternative that does not export code, yet.<p>Not Open-Source:<p>- bamboolib: very similar to Mito e.g. also has code export into a cell. The basic version is free on local Jupyter Notebook and Lab. bamboolib does NOT allow inline writing of Excel-style formulas like ROUND(A1, 2) like Mito does. On top of Mito, it supports more pandas functions e.g. also datetime handling. Data explorations for the whole table and columns. It has a plot creator for creating Plotly graphs. It does not log any user data - neither about feature usage nor about the actual data. It also works in Jupyter Notebook. Enterprise customers love the ability to extend bamboolib with plugins in order to add their own custom plots or data transformations. Also, bamboolib supports data loaders e.g. to load CSV files from a GUI - Mito currently seems only to work when the data already is available in a Dataframe variable. With bamboolib the user does not have to code anything in order to spawn the UI. The user can just type the name of the dataframe. For Mito the user needs to type mitosheet.sheet(df_name). bamboolib is more mature because it is roughly 2,5 years in development and has many enterprise customers like Spotify, Bain &amp; Company, Procter&amp;Gamble and 2 of the top 10 global asset managers.<p>Full disclosure: I am a co-founder of bamboolib
rich_sasha大约 4 年前
When seeing products like this, and people who find it useful, it strikes me how there are apparently many types of &#x27;data users&#x27; in Python. This seems the polar opposite of what I would find useful with data. The point-and-click is very much what I&#x27;m trying to avoid.<p>Not questioning the need for this, rather being continually surprised how diverse the Python userspace is, even within a &quot;field&quot;, like &quot;data science&quot;.
评论 #26386665 未加载
nicolaskruchten大约 4 年前
Very, very cool! I love the code-generation bit, and I&#x27;ve been wanting to add something like it to <a href="https:&#x2F;&#x2F;github.com&#x2F;plotly&#x2F;jupyterlab-chart-editor" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;plotly&#x2F;jupyterlab-chart-editor</a> for a long time! Is this functionality based on something open-source? I&#x27;ve seen <a href="https:&#x2F;&#x2F;github.com&#x2F;mkery&#x2F;JupyterLab-CodeAnalysisDemo" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;mkery&#x2F;JupyterLab-CodeAnalysisDemo</a> ... is this related?
xiphias2大约 4 年前
Please don&#x27;t use span on links on your web page, my mouse cursor didn&#x27;t change, and it was very strange.<p>Maybe I&#x27;m too snobbish, but I don&#x27;t trust a company with my data that doesn&#x27;t know basic HTML (I would install the local version though).<p>Also the github links don&#x27;t work (npmjs and python repositories show that it&#x27;s using BSD license): <a href="https:&#x2F;&#x2F;github.com&#x2F;mito&#x2F;mito" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;mito&#x2F;mito</a>
评论 #26380657 未加载
narush大约 4 年前
Hey HN - Super excited to hear any feedback y&#x27;all have on Mito or our docs. Happy to answer any questions here!
kmckiern大约 4 年前
Super cool, congrats to the team! I can&#x27;t count how many times I&#x27;ve had to open the merging section of the pandas docs. Great library but I find a lot of it unintuitive and hard to commit to memory.
评论 #26381167 未加载
juliechen大约 4 年前
Awesome product, you should be proud! Sent this to some of my data whiz friends &amp;&amp; I know they&#x27;ll appreciate it. I&#x27;m curious - what are the top use cases of Mito amongst your current users?
mizbani大约 4 年前
Congrats on the launch folks - I spend tons of time in spreadsheets and can think of a few use cases for this (handling more regular repetitive tasks and processes). Looks useful
Saurinp大约 4 年前
Heyo! Looks super cool and useful. Are you open souce?
评论 #26380008 未加载
arkani大约 4 年前
Congrats on the launch. The product looks useful.<p>However, I installed the package locally, and I see that importing it causes a request to be sent to segment.io.
评论 #26387435 未加载
benleim大约 4 年前
How did you make the translation part of it?
评论 #26379389 未加载
aodj大约 4 年前
I was really interested in this as an easy way to help people get to grips with the intricacies of Pandas and working with dataframes, but after looking over the source code that&#x27;s published on Pypi I don&#x27;t think I can ever recommend this package to anyone due to the degree of tracking that&#x27;s present in the code.<p>There&#x27;s no mention of the Segment tracking in the docs, and I don&#x27;t see anyway for the user to opt out of it, which I think is an immediate GDPR issue.<p>Given that you are logging metadata about the dataframes in use along with the user email and name of the logged in user, I can&#x27;t see this ever being used in an environment where sensitive data is being processed, since it could potentially leak PII that&#x27;s easily tied to a given company via the email address.<p>This is a great idea, and I think if you can go with the BSD license and provide a way for people to opt out of tracking (or ideally flip it and allow them to opt in) this could be used in any number of industries. As it stands currently I just don&#x27;t think this will ever pass a data audit at any large company which is a real shame.
评论 #26387225 未加载
paluter大约 4 年前
Seems pretty cool. Does this only work in Jupyter?
评论 #26379428 未加载