Thanks for your quick reply. I had a feeling that would be the case.
Rookie question: if I proceed in this fashion, will it be a problem to use R to create an xyz plot with labels for the unique datapoints? Sent from my iPhone > On Sep 18, 2015, at 11:50 AM, Michael Dewey <li...@dewey.myzen.co.uk> wrote: > > I am afraid I cannot see any quick way to do this although I am sure some of > our data structure experts will be able to. As I see it your lines come in > triples. The first line mostly consists of character data, the second is > predominantly numeric and is values of x, the third is predominantly numeric > and values of y. > > I am not sure what #REF! means. > >> On 18/09/2015 15:25, Alfa Diallo wrote: >> Hello Michael and Co. >> >> I uploaded the files: >> http://www.alfadiallo.com/r/r_sample.csv >> http://www.alfadiallo.com/r/r_sample.xlsx >> <http://www.alfadiallo.com/r/r_sample.csv> >> >> Thanks! >> >> Alfa >> >> >> >>> On Sep 18, 2015, at 7:45 AM, John Kane <jrkrid...@inbox.com >>> <mailto:jrkrid...@inbox.com>> wrote: >>> >>> Thanks Michael, I stupidly assumed that the data was in R and just >>> being sent in .csv form >>> >>> John Kane >>> Kingston ON Canada >>> >>> >>>> -----Original Message----- >>>> From: li...@dewey.myzen.co.uk <mailto:li...@dewey.myzen.co.uk> >>>> Sent: Fri, 18 Sep 2015 09:05:55 +0100 >>>> To: jrkrid...@inbox.com <mailto:jrkrid...@inbox.com>, >>>> alfadia...@mac.com <mailto:alfadia...@mac.com>, r-help@r-project.org >>>> <mailto:r-help@r-project.org> >>>> Subject: Re: [R] best data storage format? >>>> >>>> Dear Alfa >>>> >>>> Although John's advice is excellent if you already have the dataset in R >>>> in your case it seems that is not the case. Since R-help strips off most >>>> attachments you may need to put your .csv file somewhere like Dropbox or >>>> fool R-help into thinking it is a plain text file. >>>> >>>>> On 18/09/2015 00:41, John Kane wrote: >>>>> No data. See dput() (?dput) as the preferred way to send data >>>>> >>>>> John Kane >>>>> Kingston ON Canada >>>>> >>>>> >>>>>> -----Original Message----- >>>>>> From: alfadia...@mac.com <mailto:alfadia...@mac.com> >>>>>> Sent: Thu, 17 Sep 2015 16:41:46 -0400 >>>>>> To: r-help@r-project.org <mailto:r-help@r-project.org> >>>>>> Subject: [R] best data storage format? >>>>>> >>>>>> Hello - >>>>>> >>>>>> I’m working on dataset that will eventually be used in an xyz-plot. >>>>>> >>>>>> I’m having trouble figuring out the best way to store the data (see an >>>>>> attached .csv sheet exported from Excel). Some information on the data: >>>>>> >>>>>> - Columns B - F are labels that describe the z data points >>>>>> - Rows above x and y data pairs show the corresponding labels for the >>>>>> data point. >>>>>> >>>>>> I want to use R to visualize the data and appreciate any feedback on >>>>>> the >>>>>> best mechanism to store/organize the info. I’m new to R and want to >>>>>> start >>>>>> the data assembly on the right foot - thanks for the help and advice! >>>>>> >>>>>> Alfa >>>>>> >>>>>> ______________________________________________ >>>>>> R-help@r-project.org <mailto: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. >>>>> >>>>> ____________________________________________________________ >>>>> Can't remember your password? Do you need a strong and secure password? >>>>> Use Password manager! It stores your passwords & protects your account. >>>>> >>>>> ______________________________________________ >>>>> R-help@r-project.org <mailto: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. >>>> >>>> -- >>>> Michael >>>> http://www.dewey.myzen.co.uk/home.html >>> >>> ____________________________________________________________ >>> FREE 3D EARTH SCREENSAVER - Watch the Earth right on your desktop! >>> Check it out at http://www.inbox.com/earth > > -- > Michael > http://www.dewey.myzen.co.uk/home.html ______________________________________________ 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.