R语言操作数据
1.把数据放到操作框中
R语言的最大用处就是处理数据,不然学它干嘛,讲了那么多了,现在才是主题。
-
#把数据放到操作框中
-
salary<-c(18700000,14626720,15426545,54659532,5445442101)
-
position<-c("QB","DE","QB","QA","QB")
-
team<-c("Colts","Patriots","Panthers","Bengals","Giants")
-
name.last<-c("Manning","Brady","Pepper","Palmer","Manning")
-
name.first<-c("Peyton","Tom","Julius","Carson","Eli")
-
top.5.salaries<-data.frame(name.last,name.first,team,position,salary)
-
top.5.salaries
输出:
-
name.last name.first team position salary
-
1 Manning Peyton Colts QB 18700000
-
2 Brady Tom Patriots DE 14626720
-
3 Pepper Julius Panthers QB 15426545
-
4 Palmer Carson Bengals QA 54659532
-
5 Manning Eli Giants QB 5445442101
2.图形界面操作
-
top.5.salaries<-edit(top.5.salaries)
执行到这的时候,会出现图形界面
等你编辑完,关闭,你修改的信息就已经保存了。比如我修改了最后一行的position列QBC->QB
-
> top.5.salaries
-
name.last name.first team position salary
-
1 Manning Peyton Colts QB 18700000
-
2 Brady Tom Patriots DE 14626720
-
3 Pepper Julius Panthers QB 15426545
-
4 Palmer Carson Bengals QA 54659532
-
5 Manning Eli Giants QB 5445442101
修改成功。下面的语句也一样能调出图形界面
3.保存数据包到本地
save方法保存数据包到本地
-
save(top.5.salaries,file="D:/R/product/0119/top.5.salaries.RData")
执行后,会在目录下生成一个文件
用一下命令可以再读到RGui中。
-
load("D:/R/product/0119/top.5.salaries.RData")
-
4.读取外部文件
新建top.5.salaries.csv文件,内容如下:
-
ame.last,name.firts,team,position,salary
-
"Manning","Peyton","Colts","QB",18700000
-
"Brady","Tom","Patriots","QB",1245624
-
"Pepper","Julius","Panthers","DE",14137500
-
"Palmer","Carson","Bengals","QB",13980000
-
"Manning","Eli","Giants","QB",12916666
-
top.5.salaries<-read.table("top.5.salaries.csv",header=TRUE,seq=",",quote="\"")
-
top.5.salaries
输出:
-
1 name.last,name.firts,team,position,salary
-
2 Manning,Peyton,Colts,QB,18700000
-
3 Brady,Tom,Patriots,QB,1245624
-
4 Pepper,Julius,Panthers,DE,14137500
-
5 Palmer,Carson,Bengals,QB,13980000
-
6 Manning,Eli,Giants,QB,12916666
你还可以将数据写到本地文件,用write.table函数。
5.数据库中数据
最佳方案是先将数据库中的数据导出到文本文件中,然后再导入到R中。
关于R语言的学习暂时到此为止,以后有时间再提升。