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.
