about transforming a data.frame

with(df, table(CT, row_names))

with(df, table(CT, col_names))

Hi Sarah,

thank you for your help. I have simplified the example, by reading the
elements in a data frame, eg :

df <- data.frame (row_names = c("B4:B5:B6", "B7:B8:B9", "D4:D5:D6",
"D10:D11:D12", "D10:D11:D12", "E10:E11:E12", "A1:A2:A3", "B10:B11:B12"),
col_names = c
("B1:B2:B3","B1:B2:B3","H4:H5:H6","F10:F11:F12","H1:H2:H3","G7:G8:G9","D1:D2:D3","B1:B2:B3"),
CT = c(5,2,2,2,2,2,4,4) )

I have used the the count() in the plyr package :

count_row_names <- count(df$row_names)
count_col_names <- count(df$col_names)

however, I would need to correlate these UNIQUE ELEMENTS in the columns
"row_names" or "col_names" with the numbers they associate in the  CT
columns, eg :

""B1:B2:B3" associate with "5, 2, 4" (in CT column), or "D10:D11:D12"
associate with "2" (in the CT column).

thank you very much,

bogdan




On Fri, May 29, 2015 at 1:32 PM, Sarah Goslee <sarah.goslee at gmail.com>
wrote:

Hi,

Please use dput() to provide your data, as it can get somewhat mangled
by copy and pasting, especially if you post in HTML (as you are asked
not to do in the posting guide).

What is a unique element? is "B4:B5:B6" an element, or are "B4" and
"B5" each elements? That is, what is the result you expect to obtain
for the sample data you provided?

What code have you tried? I would think table() might be involved, and
possibly strsplit(), but will refrain from putting more time into this
until you provide a reproducible dataset with dput() and some clearer
idea of your intent.

Sarah

On Fri, May 29, 2015 at 4:19 PM, Bogdan Tanasa <tanasa at gmail.com> wrote:

Dear all,

I would appreciate a suggestion on the following : I am working with a
data.frame (below) :

  EXP    CT   row_names   col_names
1   test -5    B4:B5:B6    B1:B2:B3
2   test -2    B7:B8:B9    B1:B2:B3
3   test -2    D4:D5:D6    H4:H5:H6
4   test -2    D10:D11:D12 F10:F11:F12
5   test -2    D10:D11:D12    H1:H2:H3
6   test -2    E10:E11:E12    G7:G8:G9
7   test -4     A1:A2:A3    D1:D2:D3
8   test -4   B10:B11:B12    B1:B2:B3

what would be the easiest way to consider UNIQUE elements in the
ROW_NAMES
or the UNIQUE elements in the COL_NAMES and :

print how many times these UNIQUE ELEMENTS associate with the numbers
-5,
-2, or -4 (these numbers are on the column names CT) ..

thanks,

bogdan