4 ms·

You should learn R and dplyr ;)

• dotancohen 4y ago
  Tell us more - in the context of them being replacements for Excel for his use case.
  • steine65 4y ago
    I love R but can't use it at work :( With just the tidyverse library (which includes dplyr), R can be very useful in a data analysis pipeline. It is great for data cleaning and aggregation, especially when a process needs to be done multiple times. It is much faster than excel/power query. I am an accountant in SaaS and spend a lot of my day waiting for excel/powerbi automations to refresh. Similar solutions in R/sql/python would be nearly instant. Also excel/powerbi automations are a bitch to troubleshoot, and are unnecessarily complex. When following tidy principles, a framework designed by the tidyverse dev Hadley Wickham, R code can be very easy to interpret, similar to SQL. Additionally the R community has made libraries for everything, and I consider R a great general purpose language as well.
    • hermitcrab 4y ago
      Note that different flavours of R have very different performance. 'Base R' is quite slow. But R + data.table is blinding fast. Power Query perforamnce is awful, even compared to base R. Some benchmarks of these plus other data wrangling software (including my own product) at: https://www.easydatatransform.com/data_wrangling_etl_tools.html https://www.easydatatransform.com/data_wrangling_etl_tools.h...
  • aquafox 4y ago
    "Manipulating hundreds of thousands of rows" is exactly where R, dplyr and data.table are great at. I do that on a daily basis.