5 ms·
Does anybody else feel that the vast majority of these things are either available in Google sheets or worth just doing in R? My last consulting project was on
by robterrin 10y ago
Does anybody else feel that the vast majority of these things are either available in Google sheets or worth just doing in R? My last consulting project was on a VaR model built in VBA/SQL with a bunch of Excel sprinkled about and it was horrendous. Not Excel, VBA or SQL's fault, but it felt like a more thoughtful architect would have used better tools.
- msl09 10y agoYeah 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.
- criddell 10y agoI went to Google Sheets and tried it and it was a pretty bad experience compared to what Joel shows in the video. Excel Online worked very well though.