Re: [R] unique mismatch in R and Excel

2013-12-25 Thread Barry Rowlingson
We answered this on StackOverflow already. Excel was doing case-insensitive duplicate matching. http://stackoverflow.com/questions/20759346/counting-unique-values-in-r-and-excel/20759523#20759523 Barry On Tue, Dec 24, 2013 at 5:43 PM, David Winsemius wrote: > > On Dec 24, 2013, at 1:08 AM, Kous

Re: [R] unique mismatch in R and Excel

2013-12-24 Thread David Winsemius
On Dec 24, 2013, at 1:08 AM, Koushik Saha wrote: > i have a wired problem. i want to count the unique entry in a certain > column.Here i have attached my csv file. Files named with extension .csv do not typically make it through the R-help mail server. > > i am doing this to get the unique en

Re: [R] unique mismatch in R and Excel

2013-12-24 Thread Duncan Murdoch
On 13-12-24 4:08 AM, Koushik Saha wrote: i have a wired problem. i want to count the unique entry in a certain column.Here i have attached my csv file. i am doing this to get the unique entries in the column. dat<-read.csv("C:/Project/Gawk-scripts/Book1.csv") names(dat)<-c("user_name") unique(d

[R] unique mismatch in R and Excel

2013-12-24 Thread Koushik Saha
i have a wired problem. i want to count the unique entry in a certain column.Here i have attached my csv file. i am doing this to get the unique entries in the column. dat<-read.csv("C:/Project/Gawk-scripts/Book1.csv") names(dat)<-c("user_name") unique(dat$user_name) results says i have 170 uniq