Message-ID: <21130173.post@talk.nabble.com>
Date: 2008-12-22T16:03:09Z
From: vpas
Subject: Matching
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.