dear all,
I have two dataframes
dataframe1
ID
a
b
c
dataframe2
ID value
a;W 100
X;c 200
Y;Z 300
I wanted to match the IDs from the two dataframes and record the values into
a new column of dataframe1 at the corresponding rows. This is what I expect:
dataframe1
ID value
a 100
b
c 200
I tried doing it like this:
for (i in seq(1:nrow(dataframe1))) {
dataframe1[i,"value"]<-dataframe2[grep(dataframe1[i,"ID"],
dataframe2$ID),"value"]
}
but I failed. I was able to extracted the values from dataframe2 but not
able to record the values in the corresponding rows of dataframe1.
I would appreciate any suggestions. Thanks in advance.
Jim
--
View this message in context:
http://www.nabble.com/problem-with-recording-numeric-output-into-another-dataframe-tp24850155p24850155.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
[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.
