Thanks, that seems to work.
On Fri, Nov 15, 2013 at 10:26 PM, arun kirshna [via R] < ml-node+s789695n4680556...@n4.nabble.com> wrote: > Hi, > > Try: > var1 <- load("reshape_data.frame.RData") > ##It is better not to name the objects with function names. > dat1 <- data > reshape1 <- reshape > names(dat1)[grep("X\\d+",names(dat1))] <- > gsub("[[:alpha:]]","X_",names(dat1)[grep("X\\d+",names(dat1))]) > res1 <- reshape(dat1,direction="long",varying=7:ncol(dat1),sep="_") > res2 <- res1[with(res1,order(Yr,Seas,Flt.Svy,Gender,Part,NSAMP)),-9] > row.names(res2) <- 1:nrow(res2) > colnames(res2) <- colnames(reshape1) > all.equal(res2,reshape1) > #[1] TRUE > > A.K. > > > Some advice on transforming my data would be appreciated. Attached is > an .Rdata image with my examples (reshape_data.frame.Rdata). Within the > image are 2 objects: > > 1) The "data" object contains an example of my original data > format. The columns "X20" : "X50" are histogram bins, and the rows > beneath are the number of observations (ie. counts) within those bins. > The other columns; "Yr", "Seas", "Flt.Svy", "Gender", "Part", "NSAMP" > are observation associated with each bin count. > > 2) The "reshape" object is the format I need to transform the "data" > object into. > > I think the reshape() function is designed for this, and my > "data" object is in wide format, and my "resphape" object would be in > long format. If indeed reshape() is the best way to do this, I'm > looking for help in calling the function to transform my data. > > Many thanks, > > Tim > > ______________________________________________ > [hidden email] <http://user/SendEmail.jtp?type=node&node=4680556&i=0>mailing > list > 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. > > > ------------------------------ > If you reply to this email, your message will be added to the discussion > below: > http://r.789695.n4.nabble.com/reshape-data-frame-tp4680539p4680556.html > To unsubscribe from reshape data frame, click > here<http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4680539&code=dHNpcHBlbEBnbWFpbC5jb218NDY4MDUzOXwxMTExOTI5MjI=> > . > NAML<http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> > -- View this message in context: http://r.789695.n4.nabble.com/reshape-data-frame-tp4680539p4680707.html Sent from the R help mailing list archive at Nabble.com. [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list 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.