An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20120918/03f384d5/attachment.pl>
chunk row to new table/file
2 messages · s.s.m. fauzi, David Winsemius
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