[R] Loading data into R

arun smartpink111 at yahoo.com
Sat Jan 26 21:11:38 CET 2013


Hi,
myData[]<-lapply(myData,as.character)
 as.matrix(myData)
#     V1  V2   V3  V4  V5 
#[1,] "a" "b"  "c" "d" "f"
#[2,] "2" "4"  ""  ""  "7"
#[3,] ""  ""   ""  ""  "" 
#[4,] ""  "34" ""  "4" "" 
#[5,] "2" ""   "4" ""  "4"


str(as.matrix(myData))
# chr [1:5, 1:5] "a" "2" "" "" "2" "b" "4" "" "34" "" ...
 #- attr(*, "dimnames")=List of 2
  #..$ : NULL
  #..$ : chr [1:5] "V1" "V2" "V3" "V4" ...
A.K.



----- Original Message -----
From: Christofer Bogaso <bogaso.christofer at gmail.com>
To: r-help <r-help at r-project.org>
Cc: 
Sent: Saturday, January 26, 2013 3:00 PM
Subject: [R] Loading data into R

Hello again,

I generally use Clipboard to load data into R from Excel using the
read.delim() function. In most cases, my data after loading looks like
below:

myData <- structure(list(V1 = structure(c(3L, 2L, 1L, 1L, 2L), .Label = c("",
"2", "a"), class = "factor"), V2 = structure(c(4L, 3L, 1L, 2L,
1L), .Label = c("", "34", "4", "b"), class = "factor"), V3 = structure(c(3L,
1L, 1L, 1L, 2L), .Label = c("", "4", "c"), class = "factor"),
    V4 = structure(c(3L, 1L, 1L, 2L, 1L), .Label = c("", "4",
    "d"), class = "factor"), V5 = structure(c(4L, 3L, 1L, 1L,
    2L), .Label = c("", "4", "7", "f"), class = "factor")), .Names = c("V1",
"V2", "V3", "V4", "V5"), class = "data.frame", row.names = c(NA,
-5L))


> myData
  V1 V2 V3 V4 V5
1  a  b  c  d  f
2  2  4        7
3
4    34     4
5  2     4     4


Now I want to put this data in a Matrix class with all elements are
character. So tried this :

> as.character(myData)
[1] "c(3, 2, 1, 1, 2)" "c(4, 3, 1, 2, 1)" "c(3, 1, 1, 1, 2)" "c(3, 1,
1, 2, 1)" "c(4, 3, 1, 1, 2)"


This looks funny and does not conform the original data. Can somebody
point me what would be right way to put it into Matrix?

Thanks and regards,

______________________________________________
R-help at r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.




More information about the R-help mailing list