Hi:
I am requesting help on matrix mapping.
I have a matrix that is 5000 rows x 3000 columns in R env.
Matrix:
A B C D E
S1 0.01 0.2 -0.3 0.8 -1
S2 -2 1.4 2.3 3.1 -2
S3 -4 -3 -2 0.4 2.1
I have another excel sheet, which when I import will have two columns..
ColMap element
A Apple
A Arcade
A Almira
B Boy
B Balloon
B Bat
C Cat
.....
I want to create another matrix with elements as column names and map
ColMap values onto elements.
new matrix:
Apple Arcade Almira Boy Ballon ....
S1 0.01 0.01 0.01 0.2 0.2
S2 -2 -2 -2 1.4 1.4....
S3 -4 -4 -4 -3 -3 ..
I have no idea how I could do this in R. would any one help please.
Thanks
[[alternative HTML version deleted]]
______________________________________________
[email protected] 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.
