Hi John, thanks for clarifications, yes, of course, the dput() output is the following :
dput(dataframe_matches_ddCT) structure(list(FIGURE = structure(c(1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L), .Label = "test", class = "factor"), ddCT = c(-5.4595, -2.7467, -2.7467, -2.7467, -2.7467, -2.7467, -4.5927, -4.5927), row_names = structure(c(1L, 2L, 3L, 4L, 4L, 5L, 6L, 7L), .Label = c("B4:B5:B6", "B7:B8:B9", "D4:D5:D6", "D10:D11:D12", "E10:E11:E12", "A1:A2:A3", "B10:B11:B12" ), class = "factor"), col_names = structure(c(1L, 1L, 2L, 3L, 4L, 5L, 6L, 1L), .Label = c("B1:B2:B3", "H4:H5:H6", "F10:F11:F12", "H1:H2:H3", "G7:G8:G9", "D1:D2:D3"), class = "factor"), CTaverage_MATRIX_SUBSTRACTIONS = c(-5.4595413208, -2.74678293866667, -2.74099286393334, -2.74331347146666, -2.74805959066667, -2.755259196, -4.59402211506667, -4.5927206675)), .Names = c("FIGURE", "ddCT", "row_names", "col_names", "CTaverage_MATRIX_SUBSTRACTIONS" ), row.names = c(NA, 8L), class = "data.frame") thanks again for your input, -- bogdan On Fri, May 29, 2015 at 2:11 PM, John Kane <jrkrid...@inbox.com> wrote: > Bogdan, the request was for data in dput() format. > > Type ?dput for more information. > > Do dput(myfile) copy the ouput and paste into the email > > You should get something like: > structure(list(c1 = structure(c(1L, 1L, 1L, 1L, 1L, 1L, 2L, 2L, > 2L, 3L, 3L, 3L, 3L, 3L, 3L, 3L, 3L, 4L, 4L, 4L, 4L, 5L, 5L, 5L, > 5L, 6L, 6L, 6L, 6L, 7L, 7L, 7L, 7L, 7L, 7L, 7L, 7L, 7L, 8L, 8L, > 8L, 8L, 9L, 9L, 9L, 9L, 9L, 10L, 10L, 10L), .Label = c("(0.509,0.614]", > "(0.614,0.718]", "(0.718,0.822]", "(0.822,0.926]", "(0.926,1.03]", > "(1.03,1.13]", "(1.13,1.24]", "(1.24,1.34]", "(1.34,1.45]", "(1.45,1.55]" > ), class = "factor"), s1 = c(0.51, 0.52, 0.58, 0.58, 0.59, 0.6, > 0.63, 0.65, 0.68, 0.74, 0.74, 0.75, 0.77, 0.77, 0.77, 0.78, 0.79, > 0.84, 0.84, 0.85, 0.87, 0.93, 0.93, 0.95, 0.99, 1.04, 1.09, 1.11, > 1.13, 1.14, 1.14, 1.14, 1.17, 1.18, 1.19, 1.22, 1.22, 1.23, 1.28, > 1.29, 1.3, 1.32, 1.37, 1.38, 1.38, 1.4, 1.43, 1.47, 1.52, 1.55 > )), .Names = c("c1", "s1"), row.names = c(NA, -50L), class = "data.frame") > > Data in duput() format is the preferred way to get data in R-help since it > provides a perfect copy of what you have on your machine. Any other way of > providing data risks the recipients reading it into R differently than it > is on your machine. > > John Kane > Kingston ON Canada > > > > -----Original Message----- > > From: tan...@gmail.com > > Sent: Fri, 29 May 2015 13:58:20 -0700 > > To: sarah.gos...@gmail.com > > Subject: Re: [R] about transforming a data.frame > > > > 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.gos...@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 <tan...@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 > >> http://www.functionaldiversity.org > >> > > > > [[alternative HTML version deleted]] > > > > ______________________________________________ > > R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see > > 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. > > ____________________________________________________________ > FREE ONLINE PHOTOSHARING - Share your photos online with your friends and > family! > Visit http://www.inbox.com/photosharing to find out more! > > > [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see 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.