Performing SQL queries within R using sqldf package

This video shows how to run SQL code within R, with explanations of the different types of data joins and covers subsetting data and summary calculations.

The code and the files for this example can be found at:

[worldwide_wes]

11 years later I found this to be a great tutorial!

[nhidinh]

wow, wow, wow. This is the best Tutorial I have about R & SQL. You are the best. Please post some more.

[anusrivstv]

thanku soo much ...it was very helpful

[culu]

Well, simply a big and sincere thank you for this great and useful video.

[markmcc]

thanks very much for this, really clear and understandable, cheers!

[guillaumelombard]

Amazing tutorial, thanks for the easy step by step process

[adz]

Great Tutorial and well explained, thanks Randy!

[mayarinlopez]

Hola, excelente vídeo, gracias por compartirlo. Saludos desde Venezuela.


Hi, excellent video, thanks for sharing. Greetings from Venezuela.

[adityapathania]

Just an add on, try to keep a zoom in as we cannot see what’s written some people do while watching itself

[Shappiro_dj]

Thanks for this tutorial Randy. Can we go as far as creating table using sqldf package in R? I mean creating tables using sql query functions while using sqldf package in R?

[abbybaby]

Hello Randy, thanks for this video. Very nice. Is there a way we can update rows using sqldf package?

[atiaspire]

How can we use sqldf in a function()
Please provide information on that

[giri]

@all Can anyone able to assist me on SAuth () connecting with R programming. I used Randy's code from GitHub but no luck. Could you please assist in this instance. Thanks in advance