Re: [R] Reshape, melt and cast query

2011-03-10 Thread John Kane
I think we need a sample of the orginal data or reasonable facsimile to get an idea of what you are doing. Have a look at ?dput as a way to provide the data in a handy format. --- On Thu, 3/10/11, Muzna Alvi wrote: > From: Muzna Alvi > Subject: [R] Reshape, melt and cast query > To:

Re: [R] Reshape, melt and cast query

2011-03-10 Thread Muzna Alvi
yes..thats what i was also confused about..but thats what my column is named.. didnt know any other way of doing it. On Thu, Mar 10, 2011 at 9:23 PM, jdnew...@gmail.com < jdnew...@dcn.davis.ca.us> wrote: > I can't see the value of your first melt, which appears to result in a > column filled with

Re: [R] Reshape, melt and cast query

2011-03-10 Thread jdnew...@gmail.com
I can't see the value of your first melt, which appears to result in a column filled with identical values "crop_group". You really should read the posting guide and provide a reproducible example. I suspect that you would benefit from learning how to use the plyr library. -- Sent from my Andro

Re: [R] Reshape, melt and cast query

2011-03-10 Thread Muzna Alvi
thanks for that ista actually i want to break this into maybe three different data sets with each of the 3 kinds of sugarcane... it would be better if i could have this in one data set but if someone could tell me how i can run descriplitive statistics on each of the groups separately.. i would n

Re: [R] Reshape, melt and cast query

2011-03-10 Thread Ista Zahn
Hi Muzna, If I understand your question, it's not really about melting or casting, but about re-ordering. Try this: canefile <- canefile[order(canefile$value), ] see ?"[" and ?order HTH, Ista On Thu, Mar 10, 2011 at 2:20 PM, Muzna Alvi wrote: > I have a dataset that is based on crop output for

[R] Reshape, melt and cast query

2011-03-10 Thread Muzna Alvi
I have a dataset that is based on crop output for a single crop *sugarcane*...but each observation is further subdivided into 3 kinds of sugarcane i have read the file and have also used melt it to sort it on the basis of *crop group* using melt(sugarcane, m=c("Crop_group")) -> canefile this is