3 ms·
Although the reasons aren’t quite known, MS Excel doesn’t have a good reputation among data analysts. Just stopped there : + not working on linux, paying on Ma
by t_fatus 10y ago
Although the reasons aren’t quite known, MS Excel doesn’t have a good reputation among data analysts.
Just stopped there :
+ not working on linux, paying on MacOS and Windows
+ proprietary format: hard to get data in / out from other tools (for instance, but not limited to, python lib, R lib, matlab (if some of us still want to use matlab) and all tools built upon those libs)
+ sucks for any real-sized dataset (try to handle 10k+ rows, not even thinking about 1M+ rows)
Those 3 reasons alone mean that you need to pay for a tool which would hardly do the job a team ask for, if only it works on their OSs, and won't be able to share it with other teams.
- CJefferson 10y agoWhile there are good reasons for not using excel, be careful not to dump too fast. Excel's format is publicly available (if a little horrible to read XML), and it imports/exports CSV fine. Yes you do have to pay for it, but I find lots of R extensions don't work well on Windows, so OS-lock isn't a solved problem. You can use Office 365 in the web browser if you want to access from linux. The biggest issue is, as you say, don't try to put 1M+ rows into Excel. I agree. But I've worked with lots of people who have 20-1000 data points, and there Excel is great. I'd love to have an alternative to suggest to people, that scales well with them, but we aren't there yet, and Excel still fills an important niche. Assuming people only use it because they are idiots (not saying you said that, but many do) and not looking at why they use it is what is stopping other tools replacing it.