3 ms·
I would add testing, collaboration, and complex use cases. There's no good way to check if you've made a mistake in the logic of your excel spreadsheet. You ca
by pg_bot 5y ago
I would add testing, collaboration, and complex use cases.
There's no good way to check if you've made a mistake in the logic of your excel spreadsheet. You can easily test your R code.
If you need to work with multiple people excel is a nightmare. It works fine when one person needs to build something for themselves or just to show to someone else. When you get two or more people working together it's like sharing a keyboard with someone else.
Excel can do a lot of things, but there is a limit to what it can do. R or Python is typically what you would reach for when you need to do something beyond what excel is capable of.