安裝加載

options("repos" = c(CRAN="https://mirrors.tuna.tsinghua.edu.cn/CRAN/")) 
options(BioC_mirror="https://mirrors.ustc.edu.cn/bioc/") 
install.packages("dplyr")
library(dplyr)

dplyr五個(gè)基礎(chǔ)函數(shù)

1.mutate(),新增列

2.select(),按列篩選

3.filter()篩選行

4.arrange(),按某1列或某幾列對(duì)整個(gè)表格進(jìn)行排序

5.summarise()：匯總

dplyr處理關(guān)系數(shù)據(jù)

options(stringsAsFactors = F)

test1 <- data.frame(x = c('b','e','f','x'), 
                    z = c("A","B","C",'D'),
                    stringsAsFactors = F)
test1
##   x z
## 1 b A
## 2 e B
## 3 f C
## 4 x D
test2 <- data.frame(x = c('a','b','c','d','e','f'), 
                    y = c(1,2,3,4,5,6),
                    stringsAsFactors = F)
test2 
##   x y
## 1 a 1
## 2 b 2
## 3 c 3
## 4 d 4
## 5 e 5
## 6 f 6

1.內(nèi)連inner_join,取交集

inner_join(test1, test2, by = "x")
##   x z y
## 1 b A 2
## 2 e B 5
## 3 f C 6

2.左連left_join

3.全連full_join

4.半連接：返回能夠與y表匹配的x表所有記錄semi_join

5.反連接：返回?zé)o法與y表匹配的x表的所記錄anti_join

6.簡(jiǎn)單合并