3 ms·
A good rule of thumb for using spreadsheets vs. a programming language/database is to only limit the amount of data in the datasheet to what you can perceivably
by minimaxir 10y ago
A good rule of thumb for using spreadsheets vs. a programming language/database is to only limit the amount of data in the datasheet to what you can perceivably scan with panning/scrolling around the spreadsheet, otherwise there will be a lot of inefficiency/performance issues when organizing/analyzing the clump of data, which is bad in the long run.
A fair limit is 1,000 rows in a sheet, which is enough for most utilitarian use cases (e.g. daily-aggregated data for a year), and certainly enough for bespoke models. I would not recommend using spreadsheets for Kaggle competitions, though.