[R] about transforming a data.frame

[Sarah Goslee]

LMGTFY: http://stackoverflow.com/questions/11433432/importing-multiple-csv-files-into-r

On Fri, May 29, 2015 at 5:58 PM, Bogdan Tanasa <tanasa at gmail.com> wrote:
> Dear Sarah,
>
> thank you very much, it is very helpful. please may I ask one more question
> about a quick and easy tutorial about the loading multiple files (from a
> folder) in R, and processing one file at a time ?  thanks very much again,
>
> bogdan
>
> On Fri, May 29, 2015 at 2:55 PM, Sarah Goslee <sarah.goslee at gmail.com>
> wrote:
>>
>> I'm still not really clear on what you need (format, etc), but this
>> may help you get started:
>>
>> > with(df, table(CT, row_names))
>>    row_names
>> CT  A1:A2:A3 B10:B11:B12 B4:B5:B6 B7:B8:B9 D10:D11:D12 D4:D5:D6
>> E10:E11:E12
>>   2        0           0        0        1           2        1
>> 1
>>   4        1           1        0        0           0        0
>> 0
>>   5        0           0        1        0           0        0
>> 0
>> > with(df, table(CT, col_names))
>>    col_names
>> CT  B1:B2:B3 D1:D2:D3 F10:F11:F12 G7:G8:G9 H1:H2:H3 H4:H5:H6
>>   2        1        0           1        1        1        1
>>   4        1        1           0        0        0        0
>>   5        1        0           0        0        0        0
>> >
>>
>> On Fri, May 29, 2015 at 4:58 PM, Bogdan Tanasa <tanasa at gmail.com> wrote:
>> > 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
>> >> >
>
>