1 / 4

Programming in R

Programming in R. SQL in R. Running SQL in R. In this session I will show you how to: Run basic SQL commands within R. Running SQL in R. A few points about SQL: SQL stands for “Structured Query Language”

yael-perry
Download Presentation

Programming in R

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Programming in R SQL in R

  2. Running SQL in R In this session I will show you how to: • Run basic SQL commands within R

  3. Running SQL in R A few points about SQL: • SQL stands for “Structured Query Language” • SQL is used for querying data and creating tables for analysis – its is not really an analytical language. • To run SQL in R, we run the sqldf() function in the sqldf package. • When we write SQL code in R, we are writing SQL – not R. So some of the references will be different.

  4. Running SQL in R The main SQL statements and clauses that will be covered in this set of notes include: • SELECT • FROM • LIMIT • AS • WHERE • LIKE • GROUP BY • HAVING • INNER JOIN • OUTER JOIN

More Related