473,419 Members | 1,828 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,419 software developers and data experts.

Reliance on dbplyr vs SQL?

3 2Bits
Hello! I’m a sophomore in college whose dabbled into a couple languages in data science, two of them being R and python. I like both and I use them quite often, and lately I’ve been learning SQL because, well, it’s good to know for internships and something which seems to be sought after. However, As a big fan of the tidyverse, I’ve come across dbplyr, a wrapper for dplyr for manipulating databases with R, and creating queries with the standard dplyr syntax. The result is the same as if you were using SQL. I’m wondering what your guys thoughts are for any of you who have used dbplyr, and how it is received by people who use SQL. Is it something which is not used as much? Or is it not worth knowing? It seems like an “easy” way of writing traditional sql queries. Any thoughts/opinions would be great, thanks.
Jan 13 '21 #1
2 3984
Niheel
2,460 Expert Mod 2GB
it's a good way to abstract SQL away from data science work

if your focus is DS, then definitely double down on it
https://github.com/rstudio/cheatshee...sformation.pdf
https://cloud.r-project.org/web/pack...lyr/dbplyr.pdf
Jan 13 '21 #2
RonWesley
3 2Bits
my issue has been solved
Jan 16 '21 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

11
by: Alan Zhong | last post by:
hi, from PHP or JSP users' mind, what's the weakness with ASP.NET? any opinions are appreciated. side question: is it true that ASP.NET can only be used with IIS? is IIS a huge trouble maker? will...
1
by: Abdullah Kauchali | last post by:
Hi folks, (Need comments if you have done something like this before. Any response would be greatly appreciated.) We've recently been prototyping the idea of completely avoiding the server...
0
by: Marion Slaughter | last post by:
----FA48570F00BB51C Content-Type: text/html; charset="iso-35B2-E" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head>...
0
by: Michael Fork | last post by:
Note: I pasted the code the attachments as plain text after the message (I wasn't able to post it with an attachment...) Attached are the XSL and XML files that I am having problems with. I am...
5
by: Dr John Stockton | last post by:
ISTM that RegExps deserve a FAQ entry, with links to more detailed sources. An important question, probably not treated by many otherwise worthwhile sources, must be on feature detection of the...
25
by: Steven T. Hatton | last post by:
Dinkumware to Develop STL for C++/CLI http://www.dinkumware.com/ Microsoft is dramatically overhauling the managed extensions they added to C++ for the .NET environment. The result is a new...
4
by: Darrel | last post by:
I'm creating a table that contains multiple records pulled out of the database. I'm building the table myself and passing it to the page since the table needs to be fairly customized (ie, a...
0
by: shamirza | last post by:
· When was .NET announced? Bill Gates delivered a keynote at Forum 2000, held June 22, 2000, outlining the .NET 'vision'. The July 2000 PDC had a number of sessions on .NET technology, and...
1
by: Careers | last post by:
WALK IN INTERVIEW AT RELIANCE COMMUNICATIONS http://www.careersengine.com/jobs/walk_in_interview_at_reliance_communications.php?cat_id=1&id=84
1
by: SoumendraMishra | last post by:
I need how to log in Yahoo finance through VB.NET code to fetch the real time stock market data here I am posting some code through which I am download data from yahoo but this is not real time data...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.