Both of which are a bit out of date so some things may have been fixed.
It's generally not a great platform for numeric work, but some things can be improved if you know the issues. For examples the last time I checked (a while ago) things like sum/std/mean would not do anything intelligent with large columns/rows leading to accumulation errors if you did it naively, but you can work around stuff like that if you know it is there... but you will end up re implementing which makes it painful
http://biostat.mc.vanderbilt.edu/wiki/pub/Main/TheresaScott/...
Or more formally papers like: https://doi.org/10.1007/s00180-014-0482-5
Both of which are a bit out of date so some things may have been fixed.
It's generally not a great platform for numeric work, but some things can be improved if you know the issues. For examples the last time I checked (a while ago) things like sum/std/mean would not do anything intelligent with large columns/rows leading to accumulation errors if you did it naively, but you can work around stuff like that if you know it is there... but you will end up re implementing which makes it painful