R sqldf()

1 개요

R sqldf()

• SQL 쿼리를 수행하는 R 함수

R

Reload

Copy

library(sqldf)
sqldf("select * from BOD where Time > 4")

Loading

Copy

summary(CO2)

Loading

Copy

sqldf("SELECT * FROM CO2 WHERE Plant LIKE 'Qn%' LIMIT 10")

Loading

2 같이 보기

• R head() - LIMIT
• R subset() - SELECT
• R grepl() - WHERE
• R %in% - IN
• R rbind() - UNION
• SQL

3 참고

• https://www.rdocumentation.org/packages/sqldf/versions/0.4-11/topics/sqldf