Hi, I guess this is what you are looking for: dat1<-read.table(text=" f1 f2 f3 f4 f5 f6 f7 f9 f10 f11 t1 1 0 1 0 1 0 0 0 0 1 t2 1 0 0 0 0 1 1 1 1 1 t3 0 0 0 0 0 0 0 0 0 0 t4 1 0 0 0 1 0 0 0 0 0 t5 0 0 0 0 0 0 0 0 0 0 t6 0 0 0 0 0 0 0 0 0 0 ",sep="",header=TRUE)
dat1[dat1$f1==1,] # f1 f2 f3 f4 f5 f6 f7 f9 f10 f11 #t1 1 0 1 0 1 0 0 0 0 1 #t2 1 0 0 0 0 1 1 1 1 1 #t4 1 0 0 0 1 0 0 0 0 0 A.K. ________________________________ From: s.s.m. fauzi <ssmf...@gmail.com> To: r-help@r-project.org Sent: Sunday, September 16, 2012 10:30 PM Subject: [R] How to filter information from a big .csv table into a new table Hi, I have big .csv file. I would like to filter that file into a new table. For example, I have .csv file as below: f1 f2 f3 f4 f5 f6 f7 f9 f10 f11 t1 1 0 1 0 1 0 0 0 0 1 t2 1 0 0 0 0 1 1 1 1 1 t3 0 0 0 0 0 0 0 0 0 0 t4 1 0 0 0 1 0 0 0 0 0 t5 0 0 0 0 0 0 0 0 0 0 t6 0 0 0 0 0 0 0 0 0 0 I want to filter the table above to another table as below. It will only show an information which have a dependency. As you can see below, t1 has a dependency with t2 and t4, because f1 has a same value (value 1) with t2 and t4. Also, f5 has a same value with f5 in t4. Also, f10 has a same value with f10 in t2. f1 f2 f3 f4 f5 f6 f7 f9 f10 f11 t1 1 0 1 0 1 0 0 0 0 1 t2 1 0 0 0 0 1 1 1 1 1 t4 1 0 0 0 1 0 0 0 0 0 New table (with row and column header) should be then saved in a new . csvfile. [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
