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]]


