4 ms·
There is no reason to use R when Excel can do the jobs. It is when Excel can’t handle the task at hand, R shines. I am well familiar with R, but for simple dat
by akg_67 5y ago
There is no reason to use R when Excel can do the jobs. It is when Excel can’t handle the task at hand, R shines.
I am well familiar with R, but for simple data manipulation, quick chart, pivot table, usually resort to a spreadsheet program. I maintain my Options Trading Journal in spreadsheet where I record all the Options trade I made, positions I hold, P&L, etc. I just can’t imagine doing that in R.
R starts with CSV, Excel ends with CSV.
- lordnacho 5y agoHow do you store your surface?
- jstx1 5y ago> There is no reason to use R when Excel can do the jobs. It is when Excel can’t handle the task at hand, R shines. I think the problem is more nuanced because Excel can do a lot. There is a large set of use cases and tasks that are possible in Excel but your team would be a lot more efficient and productive using a programming language instead. The trick is to recognise those tradeoffs and it it's not as simple as sticking to Excel as long as things are still possible there.
- sweezyjeezy 5y agoMost data scientists I work with just sneer at Excel. Using a programming language is often using a sledgehammer to crack an egg though - sometimes you just want to look at the data in the csv, and I still see people doing this in R/Jupyter - just open it in a spreadsheet, trust me - the UI is better.
- sweezyjeezy 5y ago100% this - I encourage junior data scientists to get more familiar with Excel when they start - R/python are definitely more flexible, but if Excel can sort you out it's always the quickest way.