s.s.m. fauzi
2012-Sep-17 02:30 UTC
[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]]
arun
2012-Sep-17 02:38 UTC
[R] How to filter information from a big .csv table into a new table
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 <ssmfone at gmail.com> To: r-help at 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 at 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.