News for hackers. Stuff that matters.
Re:Org Mode – Organize Your Life in Plain Text by taeric on Monday May 25, 2020 @10:20AM (#23301385)
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.

Re:Org Mode – Organize Your Life in Plain Text by TeMPOraL on Monday May 25, 2020 @12:39PM (#23302622)
Come 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.)

Re:Org Mode – Organize Your Life in Plain Text by kohtatsu on Monday May 25, 2020 @01:53PM (#23303167)
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)

Re:Org Mode – Organize Your Life in Plain Text by taeric on Monday May 25, 2020 @03:28PM (#23304080)
I'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.
Re:Org Mode – Organize Your Life in Plain Text by TeMPOraL on Monday May 25, 2020 @05:10PM (#23305023)
I'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.

Re:Org Mode – Organize Your Life in Plain Text by taeric on Monday May 25, 2020 @07:19PM (#23305899)
That is still easy with pandas/babel. Just set the table as an input for the snippet, and then you can output a pivoted table. (That make sense?)
Re:Org Mode – Organize Your Life in Plain Text by TeMPOraL on Tuesday May 26, 2020 @01:23AM (#23307691)
Yes, it does, and is probably the best option for most people.