[R] combining numeric vector and column in a data frame

arun smartpink111 at yahoo.com
Wed Jul 11 01:13:11 CEST 2012


Hi Try this:
df1<-read.table(text="
 fileName    type  status
 b              N      alive
 a              T        dead
 d              N      alive
 c              T      dead
 f              N        alive
 e              T        dead
 ",sep="",header=TRUE)
mynumeric.vec<-c(a=2,b=1,c=4,d=9,e=10,f=3)
mynumeric.df<-data.frame(key=names(mynumeric.vec),Val=mynumeric.vec)
 j<-merge(df1,mynumeric.df,by.x="fileName",by.y="key")
 j<-j[,c(1,4,2)]

colnames(j)<-c("fileName","mynumeric.vec","type")
 j
  fileName mynumeric.vec type
1        a             2    T
2        b             1    N
3        c             4    T
4        d             9    N
5        e            10    T
6        f             3    N


A.K.




----- Original Message -----
From: Adrian Johnson <oriolebaltimore at gmail.com>
To: r-help <r-help at r-project.org>
Cc: 
Sent: Tuesday, July 10, 2012 6:38 PM
Subject: [R] combining numeric vector and column in a data frame

Hi:
I am trying to map column names of a matrix to another data frame and
get values in a different column of data frame


I have a matrix m.

> my.numeric vec <- m[1,]

> my.numeric.vec
a     b     c    d   e    f
2     1     4    9   10  3



##  my data frame = df1

> df1

fileName    type   status
b               N       alive
a               T        dead
d               N       alive
c               T       dead
f               N        alive
e              T        dead


I want to combine as.numeric.vec and df1 and create j with correct
filename and type and numeric value

>j

my.numeric.vec    type
a 2   T
b 1  N
c 4  T
d 9  N
e 10 T
f 3  N

How can I combine my.numeric.vec and df1$type

when I try:

df1[df1$fileName %in% names(my.numeric.vec),2]

I get wrong answer.


thanks in advance.

Adrian

______________________________________________
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