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: lists at dewey.myzen.co.uk > Sent: Fri, 18 Sep 2015 09:05:55 +0100 > To: jrkrideau at inbox.com, alfadiallo at mac.com, r-help at 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: alfadiallo at mac.com >>> Sent: Thu, 17 Sep 2015 16:41:46 -0400 >>> To: r-help at 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 at 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 at 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!
Hello Michael and Co. I uploaded the files: http://www.alfadiallo.com/r/r_sample.csv <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 <jrkrideau at 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: lists at dewey.myzen.co.uk >> Sent: Fri, 18 Sep 2015 09:05:55 +0100 >> To: jrkrideau at inbox.com, alfadiallo at mac.com, r-help at 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: alfadiallo at mac.com >>>> Sent: Thu, 17 Sep 2015 16:41:46 -0400 >>>> To: r-help at 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 at 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 at 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 > >[[alternative HTML version deleted]]
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 <jrkrideau at inbox.com >> <mailto:jrkrideau at 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: lists at dewey.myzen.co.uk <mailto:lists at dewey.myzen.co.uk> >>> Sent: Fri, 18 Sep 2015 09:05:55 +0100 >>> To: jrkrideau at inbox.com <mailto:jrkrideau at inbox.com>, >>> alfadiallo at mac.com <mailto:alfadiallo at mac.com>, r-help at r-project.org >>> <mailto:r-help at 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: alfadiallo at mac.com <mailto:alfadiallo at mac.com> >>>>> Sent: Thu, 17 Sep 2015 16:41:46 -0400 >>>>> To: r-help at r-project.org <mailto:r-help at 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 at r-project.org <mailto:R-help at 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 at r-project.org <mailto:R-help at 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