Anyone have any familiarity with the SQLDF package in R? I keep using it as a substitute for dplyr when merging and subsetting data frames. Other than more elegant syntax why would i go with dplyr if

like
Posting as :
works at
You are currently posting as works at

Have you looked into data.table R package? I think it’s far more concise than dplyr but at the expense of some readability

like

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

Related Posts

Hi there, I got an offer for an early stage cyber security saas startup in Canada and they offered me 130k base and 10-15% commissions which they estimated at 160-240k additional a year. They only have 1 sales person at the moment and I would be 2nd and they are hiring for 3 more. I’ve always been on a 50:50 model and never done the % of revenue. Average deal size is 40k. I got 12 yoe in enterprise tech sales. No stock options upfront but potentially after the first 3 months. Good deal?

like

What are some agencies that have strong of culturally relevant work/clients? Tired of working with healthcare and trying to make a move into something I’m more interested in or cooler at least

like

Thinking of buying a lake front house and rent it on Airbnb. Does anyone here have experience being a host and guide me thru how to estimate the cash flow and rental stats in the area etc

like

Would you take a job for less salary if it was a less toxic environment than your current situation?

like

Did anyone get a ticket to this and can no longer attend?! Would like to buy it from someone if available.

Post Photo
likehelpful

DFW AA lounge WiFi password this month? Thanks!

like

Is a Mock case prior to first round truly a mock, or are you being scored on how you perform? BCG.

.net vs sitecore can anyone tell me what's the difference between the two in terms of career growth and better job opportunities?

likesmart

What is the Assistant Manager (AM) CTC slab in Delottie India and other Big 4?@

like

Being a believer in the marketplace is tough. Should you be a tyrant? Should you be a doormat? Neither. Be wise. Be prudent. Be honest.

Post Photo
like

After 6 years of temporary contracts and unstable situations, I find my dream job in my dream company. All of a sudden the world goes upside down and I get laid off. I start sending hundreds of applications, with only 2 recruiters getting back to me to say I don’t have experience for the job (this is how it works in Italy). Add a terrible health situation in my family and it seems there’s no light at the end of the tunnel. Ugh. 😞

like

Anyone else notice a trend with the mass amounts of layoffs in tech? Why are all their resumes so jumpy? Not like 2-5 years jumpy, like few months at a time jumpy? But still can land a position with similar tech giants? IMO, lots of these people get hired by their rich friends, stay a few months before someone realized they aren’t qualified and were just a recommendation from a current employee. Then repeat that process over and over until your company is down 50%

@ Industrial Designers: how would you honestly describe how your job reality matches what you thought it was? Also, would you say a related degree is crucial to getting work?

Context: 7 years experience in marketing, looking to retrain and pivot to industrial design. Looking for your takes on how much opportunity, growth, and job satisfaction you experience.

like

What’s the NYC lit lateral market like right now? First year looking to move and not sure if I want to transfer thru my firm or switch.

like

How do i get my students to engage more in live online lessons? Obviously, I can grade them on participation, but are there any other creative ideas to actually get them to WANT to participate?

like

Sloan or CBS?

like

College sophomore looking for summer position. Quantitative finance major. Smart guy. Hard to get summer positions after sophomore year. Suggestions? East coast. Thx. Asking for a friend.

like

Additional Posts in Data & Analytics Consultants

What are some technical skills that I should develop to land a Business Intelligence role in the tech industry? SQL and a data vis tool are a must I’m assuming. What else?

like

Which are the top consulting firms in UK to have great mentorship, learning and development as an entry level business/data analyst

like

If you’re hiring for sr analyst roles , what tradeoff would you be comfortable ? Business acumen and prior knowledge of industry/ function or core data analytics skills ? Need both at end of day but candidates are strong in only one of the two areas. Assume candidates are coachable and willing to learn.

like

DC folks: how’s Clarabridge (company)? Thanks

Hey all. Question regarding Presto SQL and Arrays.

I’m working within a Presto DB and the column contains a nested array. I need to pull out the 3rd item of each array. Does anyone got any info on how to approach this?

like

I’m interested in going back to school for an analytics degree. I have a math & stat undergraduate degree and have been doing data science in my projects. Does anyone have recommendations for...

like

Does anyone know of any companies that have programming assessments as a barrier to entry? Would love to give it a shot as I’m a strong programmer but don’t have any formal schooling/experience

likehelpful

Can someone tell me how log loss values can be used to compare two classification models? I understand the concept of log loss value but I don't quite get how two models can be compared using this metric. Is it as easy as saying, all things equal, one that has a lower log loss value is a better model?

like

Anyone heard of the Math company Analytics start up? They just got $50m funding in January? Good company or not?

like

Has anyone here taken the Nike SQL assessment via HireVue? Wondering what to expect.

like

Interviewing for a data scientist role. They gave me a week for a case study where I’m asked to clean data and then derive data insights (python), and then make a PowerPoint to present my process and results. Any case study samples out there I can reference to? Much thanks!

like

Vibe check - do you also feel often times that you are a wizard who pulls a rabbit out of his hat on each project, with unrealistic timelines, no data, understaffing and lack of clear requirements?

like

Any conda users in here have to install a binary and use conda forge? Need some help installing pdftotext. Throwing a weird message saying “Found conflicts!” Any and all help would be appreciated.

like

I need a new laptop. Not sure what to look for other than a SSD, 16 GB Ram, and an i7 processor. Fine with Apple or Windows. What else should I look for if I want to do a lot of my own kaggle and

Data engineering or data science as your starting career for job security and ease of moving around to different jobs?

like

Wanting to get out of fed space. I am a data scientist with 5YOE. What are good companies to look for in DC area that’d hire someone with gov consulting experience?

like

Interviewing for a deals analytics role at EY- the interview day will include time with a partner, a senior manager, two managers and a 3 hour case study. What should I expect?

I studied for 2 months with a friend and doubled my income to 200k+ the consulting game is a a racket and to that extent big tech is too BUT big but tech and large streaming companies actually pay top dollar for good talent that can code . These suits have been lying to you ALL. Wake up in the morning and studying my friends you do not need these consulting firms they need you! Do not feed into there bs…studying for interviews and get you fare share of this tech wave… I am making more than my Ms

likefunny

Anybody looking for data strategy or technical PM for analytics projects?

likehelpful

Considering a data and analytics role for a data migration project. What kinds of SQL queries will I be expected to know?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal