Il 26/01/23 18:04, Robert Garrigos ha scritto:
with some 1.5milion rows, I can not open it with
numbers or libreoffice
to do sum of the column 4.
Which tools do you use to work with such big files?
To sum a column in a CSV I would use visidata:
https://www.visidata.org/docs/join/
I think I've used it with CSVs in the order of 10^7 rows, possibly 10^8.
(Usually to make pivot tables.)
Best,
Federico