逗号分隔的文本文件
From Excel
最好的方法是把Excel文件转成逗号分隔的文本文件然后用上面的方法读取。在windows系统下,你可以使用RODBC包来读取Excel,第一行包含变量名
From SPSS
From SAS
From Stata
From systat
看大家还有什么补充吗? 分享一下经验吧
<br />
# first row contains variable names, comma is separator <br />
# assign the variable id to row names <br />
# note the / instead of \ on mswindows systems <br />
mydata <- read.table("c:/mydata.csv", header=TRUE, <br />
sep=",", row.names="id") <br />
From Excel
最好的方法是把Excel文件转成逗号分隔的文本文件然后用上面的方法读取。在windows系统下,你可以使用RODBC包来读取Excel,第一行包含变量名
<br />
# first row contains variable names <br />
# we will read in workSheet mysheet <br />
library(RODBC) <br />
channel <- odbcConnectExcel("c:/myexel.xls") <br />
mydata <- sqlFetch(channel, "mysheet") <br />
odbcClose(channel) <br />
From SPSS
<br />
# 先把SPSS的数据转化成por格式,下面是SPSS的代码<br />
get file='c:\mydata.sav'. <br />
export outfile='c:\mydata.por'. <br />
<br />
# 在R里用下面的命令<br />
library(Hmisc) <br />
mydata <- spss.get("c:/mydata.por", use.value.labels=TRUE) <br />
# last option converts value labels to R factors <br />
From SAS
<br />
# 先在SAS中把数据转成xpt格式<br />
libname out xport 'c:\mydata.xpt'; <br />
data out.mydata; <br />
set sasuser.mydata; <br />
run; <br />
<br />
# 在R中读取<br />
library(Hmisc) <br />
mydata <- sasxport.get("c:/mydata.xpt") <br />
# character variables are converted to R factors <br />
From Stata
<br />
# input Stata file <br />
library(foreign) <br />
mydata <- read.dta("c:/mydata.dta") <br />
From systat
<br />
# input Systat file <br />
library(foreign) <br />
mydata <- read.systat("c:/mydata.dta") <br />
看大家还有什么补充吗? 分享一下经验吧