On Sep 17, 2012, at 6:27 PM, s.s.m. fauzi wrote: > 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
Answered on SO where this all began. In R-help you are asked not to cross-post. http://stackoverflow.com/questions/12453483/creating-new-table-from-a-big-csv-table/12468243#comment16773052_12468243-- David. > > 1. I have a table (as above) > > 2. What I want to do is, I want to chunk a new table for each row (meaning > that, I will have new table for row t1, new table for row t2, new table for > row t3 and etc) > > 3. To develop new table for each row, there is a condition that need to > meet. The row should be grouped with other row which have the same value > in column > (as in my example, row t1,t2,t4 should be grouped together because value in > column f1 have the same value (which is 1) with the value in f1 for row t2 > and t4, also value in f5 is equal with the value in f5 for row t4, and > value in f11 is equal with the value in f11 for row t2). Output for should > be like this: > > > 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 > > 4. Also as we can see from the above table, t2 also should have another > table because value in f1 in t1 and value f1 in t4 is equal. However, t2 > should not consider t1. Output should be like this: > > f1 f2 f3 f4 f5 f6 f7 f9 f10 f11 > t2 1 0 0 0 0 1 1 1 1 1 > t4 1 0 0 0 1 0 0 0 0 0 > > > > > New table(s) (with row and column header) should be then saved in a new . > csvfile. > > Appreciate help from the expert! > > [[alternative HTML version deleted]] -- David Winsemius, MD Alameda, CA, USA ______________________________________________ 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.
