3 ms·
Yeah if excel was coughing with a few dozen tables I wonder what starts to happen when you process thousands or hundreds of thousands of values. The pivot tabl
by msl09 10y ago
Yeah if excel was coughing with a few dozen tables I wonder what starts to happen when you process thousands or hundreds of thousands of values.
The pivot table got me jealous though.
- vehementi 10y agoYou can do pivot tables in Google sheets
- blahi 10y agoIf you are a masochist .
- em500 10y agoBoth R (https://www.rforexcelusers.com/make-pivottable-in-r/ https://www.rforexcelusers.com/make-pivottable-in-r/) and Python (http://pandas.pydata.org/pandas-docs/stable/reshaping.html#pivot-tables http://pandas.pydata.org/pandas-docs/stable/reshaping.html#p...) can do pivot tables.
- greggyb 10y agoCheck Power Pivot if you just want an Excel interface to lots of data. I posted elsewhere in this thread about it, but the fun demo is to load up a dataset with a largest table of several hundred million rows. This is still quite snappy on a typical desktop machine.