Re:Show HN: I built a spreadsheet app with Python to make da...
by ricklamers on Sunday July 28, 2019 @03:12AM
(#20546243)
Interesting perspective about column v.s. cell oriented spreadsheets applications.
Someone has opened an issue on GitHub for something related. I'll be investigating how to get the best of both world with proper integration of Pandas column oriented world view and the ability to directly edit individual cells!
Also, being cell-oriented makes the spreadsheet not immediately interoperable with other data tools like pandas and R/tidyverse. No single tool will handle all use cases, so it's important to keep the data in its highest-potential form, so that other tools can work their magic without having to reorganize the data first.
So I'm glad that Grid Studio is bringing Python to the web, and I hope they consider going one further and integrating a column-oriented architecture. Otherwise using VisiData or pandas directly will still be your best option for working efficiently with larger datasets.