Re: [R] Identifying duplicate rows?

2012-09-10 Thread kborgmann
Thanks!! That did the trick!! -- View this message in context: http://r.789695.n4.nabble.com/Identifying-duplicate-rows-tp4642679p4642683.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list https://stat.

[R] Identifying duplicate rows?

2012-09-10 Thread kborgmann
Hi, I am trying to identify duplicate values in a column in a date frame. The duplicated function identifies the duplicate rows in the data frame but it only does this for the second record, not both records. Is there a way to mark both rows in the data frame as TRUE? dfA$dups<-duplicated(dfA$Val

Re: [R] Select rows based on matching conditions and logical operators

2012-07-25 Thread kborgmann
Thanks! which.max did the trick -- View this message in context: http://r.789695.n4.nabble.com/Select-rows-based-on-matching-conditions-and-logical-operators-tp4637809p4637816.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-

[R] Select rows based on matching conditions and logical operators

2012-07-25 Thread kborgmann
Hi, I have a dataset in which I would like to select rows based on matching conditions and return the maximum value of a variable else return one row if duplicate counts exist. My dataset looks like this: PGIDPTIDYear Visit Count 675553121 20091 0 675553121 2009

Re: [R] Select rows based on condition

2012-04-16 Thread kborgmann
Thanks Again!! R was holding a large file in memory so there was not enough memory to execute the function. After reading in the file separately, your code worked perfectly. Thanks! -- View this message in context: http://r.789695.n4.nabble.com/Select-rows-based-on-condition-tp4562919p4563346.htm

Re: [R] Select rows based on condition

2012-04-16 Thread kborgmann
Thanks for the reply! I tried your suggestion, but R stops responding. Perhaps it is due to the size (>6,000 rows) of the dataset I am trying to manipulate?? -- View this message in context: http://r.789695.n4.nabble.com/Select-rows-based-on-condition-tp4562919p4563031.html Sent from the R help m

[R] Select rows based on condition

2012-04-16 Thread kborgmann
Hi, I am relatively new to R and I am trying to figure out how to select rows of my data based on a condition. For example in the dataset below multiple observers recorded data at the same point on the same date and the data was recorded on separate rows, but I only need one of the rows of data.