Matching

Lines1 <- "names,values

Lines2 <- "names

DF1 <- read.csv(textConnection(Lines1))
DF2 <- read.csv(textConnection(Lines2))
merge(DF1, DF2)

I understand this is an easy question, and have been playing around with grep
and the match function, but was hoping for a little incite:

I have one .csv with the following data:

names values
A        1
B        2
C        3
D        4


The second .csv is:

names
A
C


I am hoping to match all of the rows that appear in the second .csv, making
a new file that would look like this:

names values
A        1
C        3


Here is what I have so far:

my.data <- read.csv("rows.csv",sep=",")
my.selection <- read.csv("select.csv",sep=",")
matched <- match(my.data[,1], my.selection[,1])
my.data <- my.data[matched]
write.table(as.matrix(my.data), "select_RESULTS.txt")

Unfortunately, this is throwing errors in row numbers...

--
View this message in context: http://www.nabble.com/Matching-tp21130173p21130173.html
Sent from the R help mailing list archive at Nabble.com.