[R] Matching

vpas vic.pascow at gmail.com
Mon Dec 22 17:03:09 CET 2008


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.



More information about the R-help mailing list