1 向一个data.frame指定列插入一列新数据
1.1 插入一列到指定位置
y<-1:4data1 <-data.frame(x1=c(1,3,5,7), x2=c(2,4,6,8),x3=c(11,12,13,14),x4=c(15,16,17,18))data2<-cbind(data1[,1:2],y,data1[,3:ncol(data1)])
插到data1末尾
data2<-cbind(data1,y)
插到第一列
data2<-cbind(y,data1)
2 向一个data.frame指定行插入一行新数据
2.1 插入一行到指定位置
data1<- data.frame(x1=runif(10),x2= runif(10),x3= runif(10))row<- c(1, 1, 1)data2<- rbind(data1[1:5,], row, data1[6:nrow(data1), ])
插入到data1末尾
data2<- rbind(data1, row)
插入到data1第一行
data2<- rbind(row, data1)
3 给data frame设置列名
colnames(data2) <- c('row1','row3','row3') 4 创建一个空的data frame，并制定列名（方法有点挫，目前还没找到其他方式）
4.1 创建一个包含一行的，然后用-1取
emptyDF <- data.frame(row1 = c(NA), row2 = c(NA))emptyDF <- emptyDF[-1,]
4.2 通过matrix创建data frame
emptyDF <- data.frame(matrix(c(NA), byrow = TRUE,dimnames = list(day = c(),condition = c("outlook","temperature","humidity","wind")), nrow=0, ncol=4)) 5 创建一个data frame，并查看
trainSet2 <-data.frame( size=c("大","小","大","大","小","小"), weight=c("轻","重","轻","轻","重","轻"), color=c("红","红","红","绿","红","绿"), taste=c("good","good","bad","bad","bad","good")) size weight color taste1 大 轻 红 good2 小 重 红 good3 大 轻 红 bad4 大 轻 绿 bad5 小 重 红 bad6 小 轻 绿 good
6 查看行名
row.names(trainSet2)
7 查看列名
colnames(trainSet2)
8 数据访问
访问第一行
trainSet2[1,]
访问第一列
trainSet2[,1]
trainSet2$size
trainSet2[[1]]
trainSet2[["size"]]
访问多行，例如1,2行
trainSet2[1:2,]
访问多列，例如1,2列
trainSet2[,1:2]
trainSet2[c("size","weight")] 9 添加新列
trainSet2$newc1 <- c(1,2,3,4,5,6)
trainSet2 <- within(trainSet2,{newc2 <- color}) 10 数据查询
10.1 根据条件查询
查询taste为good的所有行
trainSet2[trainSet2$taste == "good",]
查询taste为good的指定行
trainSet2[trainSet2$taste == "good",1]
trainSet2[trainSet2$taste == "good",1:2]
trainSet2[trainSet2$taste == "good",c("size","color")] 也可以用which，跟上面的类似
trainSet2[which(trainSet2$taste == "good"),c("size","color")] 使用subset，会简化查询，可以指定条件，指定选择列
subset(trainSet2,taste == "good" & newc1 < 5,select = c("size","taste")) 11 使用sql查询data frame
对于熟悉sql的是个福音啊
11.1 安装sqldf
install.packages('sqldf') 11.2 引入sqldf
library(sqldf)
11.3 查询示例
result <- sqldf("select * from trainSet2 where size='大'") 11.4 链接合并示例，两个表根据newc1 和 fkey进行链接
trainSet3 <- data.frame(fkey = c(1,2,3,4),newc3=c("a","b","c","d")) resdult <- merge(trainSet2,trainSet3,by.x = "newc1",by.y = "fkey")
newc1 size weight color taste newc2 newc31 1 大 轻 红 good 红 a2 2 小 重 红 good 红 b3 3 大 轻 红 bad 红 c4 4 大 轻 绿 bad 绿 d