R help - Sep 2012 - 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]]

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.