"R sqldf()"의 두 판 사이의 차이

2021년 10월 3일 (일) 03:06 기준 최신판

1 개요[ | ]

R sqldf()

SQL 쿼리를 수행하는 R 함수

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

summary(CO2)

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

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

@@ 1번째 줄: / 1번째 줄: @@
 ==개요==
 ;R sqldf()
+* SQL 쿼리를 수행하는 R 함수
-<source lang='r'>
+<syntaxhighlight lang='r' notebook hideerr>
 library(sqldf)
+sqldf("select * from BOD where Time > 4")
+</syntaxhighlight>
+<syntaxhighlight lang='r' notebook>
 summary(CO2)
-##     Plant             Type         Treatment       conc          uptake
+</syntaxhighlight>
-## Qn1    : 7   Quebec     :42   nonchilled:42   Min.   :  95   Min.   : 7.70
+<syntaxhighlight lang='r' notebook>
-## Qn2    : 7   Mississippi:42   chilled   :42   1st Qu.: 175   1st Qu.:17.90
-## Qn3    : 7                                    Median : 350   Median :28.30
-## Qc1    : 7                                    Mean   : 435   Mean   :27.21
-## Qc3    : 7                                    3rd Qu.: 675   3rd Qu.:37.12
-## Qc2    : 7                                    Max.   :1000   Max.   :45.50
-## (Other):42
 sqldf("SELECT * FROM CO2 WHERE Plant LIKE 'Qn%' LIMIT 10")
-##    Plant   Type  Treatment conc uptake
+</syntaxhighlight>
-## 1    Qn1 Quebec nonchilled   95   16.0
-## 2    Qn1 Quebec nonchilled  175   30.4
-## 3    Qn1 Quebec nonchilled  250   34.8
-## 4    Qn1 Quebec nonchilled  350   37.2
-## 5    Qn1 Quebec nonchilled  500   35.3
-## 6    Qn1 Quebec nonchilled  675   39.2
-## 7    Qn1 Quebec nonchilled 1000   39.7
-## 8    Qn2 Quebec nonchilled   95   13.6
-## 9    Qn2 Quebec nonchilled  175   27.3
-## 10   Qn2 Quebec nonchilled  250   37.1
-</source>
 ==같이 보기==
-* [[같이보기]]
+* [[R head()]] - LIMIT
-* [[같이보기]]
+* [[R subset()]] - SELECT
-* [[같이보기]]
+* [[R grepl()]] - WHERE
-* [[같이보기]]
+* [[R %in%]] - IN
+* [[R rbind()]] - UNION
+* [[SQL]]
 ==참고==