This is the = command that adds a new column based on a Python expression you provide. You can reference the cells in the current row based on the column name.
It is also possible to create a column based on the output of a shell command.
VisiData is row based, not cell based, so you cannot create expressions that reference data across rows.
Much as I love org-mode tables, I'd say the only axis where an org table is more feature rich is the formula support. Visidata is an amazing multitool for exploring tabular data that supports many data sources. From an ergonomic perspective, visidata wins.
This lacks formulas?
If anyone is interested i can recomment org-mode tables which looks more feature rich than visidata: https://orgmode.org/worg/org-tutorials/org-spreadsheet-intro...
It can do the first example on that page at least.
It calls them derived columns and you can use python to combine and process other columns.
https://www.visidata.org/docs/columns/#derived
This is the = command that adds a new column based on a Python expression you provide. You can reference the cells in the current row based on the column name.
It is also possible to create a column based on the output of a shell command.
VisiData is row based, not cell based, so you cannot create expressions that reference data across rows.
Much as I love org-mode tables, I'd say the only axis where an org table is more feature rich is the formula support. Visidata is an amazing multitool for exploring tabular data that supports many data sources. From an ergonomic perspective, visidata wins.
Previously
2021 (69 points, 6 comments) https://news.ycombinator.com/item?id=28078980
2020 (203 points, 22 comments) https://news.ycombinator.com/item?id=24774947
2018 (195 points, 40 comments) https://news.ycombinator.com/item?id=16515299
This is awesome
not a spreadsheet
... because?
it doesn't allow formulas in cells. everything is a table with rows and columns.