For advising
require(xlsx)
list.files()
lang = read.xlsx2( "language Placement Results 2014Fall.xlsx", 1,
colClasses=c("character", "character", "character", "character", "character") )
for(i in 1:5) {
lang[,i] = as.character(lang[,i])
}
tb = read.xlsx2( "qin-FYE-2014-worksheets.xlsx", 1 )
for(i in 1:4) {
tb[,i] = as.character(tb[,i])
}
tb$SCID %in% lang$SCID
tb$Language = lang$Language[match(tb$SCID, lang$SCID)]
tb$placement = lang$placement[match(tb$SCID, lang$SCID)]
This site is to serve as my note-book and to effectively communicate with my students and collaborators. Every now and then, a blog may be of interest to other researchers or teachers. Views in this blog are my own. All rights of research results and findings on this blog are reserved. See also http://youtube.com/c/hongqin @hongqin
Showing posts with label Excel. Show all posts
Showing posts with label Excel. Show all posts
Tuesday, August 12, 2014
Wednesday, July 9, 2014
R excel
require(xlsx)
kino = read.xlsx("data/kinetochore_list.xls", 1)
names(kino)= c("id", "ORF", "name", "desc", "alias", "genelen")
kino = read.xlsx("data/kinetochore_list.xls", 1)
names(kino)= c("id", "ORF", "name", "desc", "alias", "genelen")
Subscribe to:
Posts (Atom)