8 ms·

Relevant alternative catering to Vim users: http://visidata.org/ http://visidata.org/

• rabidrat 7y ago
  There is another, more fundamental difference between VisiData and spreadsheet apps like this one: being column-oriented (as opposed to cell-oriented). Cell-oriented spreadsheets are great for one-off calculations and creating a visual workflow that fits onto a single sheet, but when you get into larger datasets, you almost always want to work with columns as first-class entities. Individual cells and arbitrary cell ranges are difficult to work with at scale, with data larger than a couple hundred rows. 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.
  • ricklamers 7y ago
    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!