3 ms·
These are actually not that hard to do in org-mode, if you are willing to use babel and push the pivot out to something like pandas. :D That said, no, I don't
by taeric 6y ago
These are actually not that hard to do in org-mode, if you are willing to use babel and push the pivot out to something like pandas. :D
That said, no, I don't actually think it is a replacement for spreadsheets. Especially not if you are already fluent in them.
- TeMPOraL 6y agoCome to think of it, someone should write pivot tables for Emacs. Could be an alternate mode for opening CSV files (which then could also be used when editing code snippets in Org Mode). (EDIT: In the meantime, I guess you could shell out to https://www.gnu.org/software/datamash/manual/datamash.html. https://www.gnu.org/software/datamash/manual/datamash.html.)
- kohtatsu 6y agohttps://www.gnu.org/software/datamash/manual/datamash.html https://www.gnu.org/software/datamash/manual/datamash.html Fixed link On the topic of commandline spreadsheets; I'm a huge fan of sc(1), a cute curses-based spreadsheet calculator. https://en.wikipedia.org/wiki/Sc_(spreadsheet_calculator) https://en.wikipedia.org/wiki/Sc_(spreadsheet_calculator)
- taeric 6y agoI'm not sure what you are describing. Note that doing this with python and org is already pretty easy. Or R. No, you don't fully open the csv in org. But, that usually seems a feature. The firehose that is large csv is typically best as a related file.
- TeMPOraL 6y agoI'm thinking of the middle-sized use cases. A table with couple hundred to couple thousand rows. Small enough that you can load it into Emacs without a performance penalty, but too large to pivot by hand. Personal and freelance business budgeting come to mind. However, at this point I'm OK with shelling out to external tool for data wrangling.