Hi,
dat1 <- read.table(text="X1
1,1
1,2
1,3
2,1
2,2
2,3
3,1
3,2
3,3",sep="",header=TRUE)
dat2 <- setNames(as.data.frame(matrix(dat1[,1],3,3)),paste0("X",1:3))
str(dat2)
#'data.frame': 3 obs. of 3 variables:
# $ X1: Factor w/ 3 levels "1,1","1,2","1,3": 1 2 3
# $ X2: Factor w/ 3 levels "2,1","2,2","2,3": 1 2 3
# $ X3: Factor w/ 3 levels "3,1","3,2","3,3": 1 2 3
dat2New <-
setNames(as.data.frame(matrix(dat1[,1],3,3),stringsAsFactors=FALSE),paste0("X",1:3))
#
str(dat2New)
#'data.frame': 3 obs. of 3 variables:
# $ X1: chr "1,1" "1,2" "1,3"
# $ X2: chr "2,1" "2,2" "2,3"
# $ X3: chr "3,1" "3,2" "3,3"
A.K.
Hello,
For example, my data is in this format (with header):
X1
1,1
1,2
1,3
2,1
2,2
2,3
3,1
3,2
3,3
But I would like for it to be in this format:
X1 X2 X3
1,1 2,1 3,1
1,2 2,2 3,2
1,3 2,3 3,3
I hope this helps make my question clearer. Thank you for your quick reply.
M
On Saturday, January 25, 2014 7:16 PM, arun <smartpink...@yahoo.com> wrote:
Hi,
The question is not clear.
set.seed(45)
spe <- data.frame(Col1=sample(c(1:10,letters[1:2]),400,replace=TRUE))
mat1 <- matrix(spe[,1],nrow=20,ncol=20)
#If you want to replace the non-numeric values with NAs,
mat2 <- matrix(as.numeric(as.character(spe[,1])),nrow=20,ncol=20)
A.K.
Hello,
My data is in a 1 column x 40000 row data frame. I would like
to make it a 200 column x 200 row data frame. When I was using all
numeric values, I used the code below to transform my vector into a
matrix.
spematrix=data.matrix(spe)
matrix = matrix(spe, nrow = 200, ncol=200)
I cannot use this now though because my data contains non-numeric values.
I am new to R and would appreciate any help.
Thanks,
Mary
______________________________________________
R-help@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.
