Related Posts
DFW AA lounge WiFi password this month? Thanks!
I am a full time teacher and have an online tutoring platform. I am looking for math teachers for the platform as we are currently at capacity. This is a way to supplement your income doing what you are best at. We do all the leg work, you just show up and shine your light. If interested, email me at aimee.buckley@study.help
Sloan or CBS?
Additional Posts in Data & Analytics Consultants
New to Fishbowl?
unlock all discussions on Fishbowl.
Have you looked into data.table R package? I think it’s far more concise than dplyr but at the expense of some readability
SQLDF works for me? Having a hard time finding a good explainer. A similar action in dplyr seems kind of convoluted and multistepped for one statement of sql code.
You dont necessarily need dplyr for this but once you couple it with map functions, build models or convert items to lists sqldf wont seem so useful. Some of the mutate chains are much easier to construct than in sql statements imho and follow a more logical thought process than sql.
However if sqldf works for you then by all means use it. There is also a monetdb version that is faster fyi
Monetdb version of SQLDF?
I want to “convert” from SQLDF to dplyr bc i feel like I’m not a “real” programmer passing my code thru sql. But it works for what every time i think “okay here’s what i need to do in sql how do i do it in dplyr” and i start looking in stackoverflow and r documentation i end up thinking “this is not worth it i could be done by now."
Dpylr is just a package to make data cleaning easier. If there is an alternate you prefer, then use that instead. I’m not sure what that has to do with being a ‘real’ programmer.
I’ve heard of it. I will look into it. I’m trying to do row-resequencing. Perhaps i can do that in data.table
Data.table <3
Another +1 to data.table. Total game changer.
I’m taking the datacamp class on tidyverse. Will take the course that covers data.table next