Hacker News new | ask | show | jobs
by jacobdi 1843 days ago
I have been working on this problem for a little while. I don't think the issue is that Excel is inherently worse for data wrangling -- it just isn't scalable or easily traceable. My solution is a spreadsheet extension for Jupyter Notebooks, that lets you transform your data visually and outputs the equivalent Pandas.

Website, for any interested: http://trymito.io/

Automated data prep/transformation is definitely a useful solution, and obviously is going to be a part of most data wrangling tools in the future. I think the danger is a lack of visibility and tracing, something a combo between spreadsheets and pandas provides well -- I think :)

1 comments

Like to suggest adding to the page title on the homepage - maybe even just 'data python spreadsheets jupyter' - when went to bookmark I noticed it only had 'mito' in the name.. so if I go back like 3 weeks from now to my bookmarks or whatever and type spreadsheets jup - maybe your thing would not show up (?)

Maybe I'm wrong - I have yet to do a deep dive on what data firefox indexes when I bookmark things.