[R] about transforming a data.frame

Sarah Goslee sarah.goslee at gmail.com
Fri May 29 22:32:45 CEST 2015


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.


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
Sarah Goslee

More information about the R-help mailing list