Hello David and Co. - I got the screen shot!
I also downloaded OpenOffice and amended the data based on your recs - here it is: http://www.alfadiallo.com/r/r_sample_20150918.ods Would this be the best course of action? Will R be able to simultaneously plot the shown data despite variability in the number of rows for each xyz grouping? Thanks! Alfa > On Sep 18, 2015, at 1:30 PM, David Winsemius <dwinsem...@comcast.net> wrote: > > > On Sep 17, 2015, at 1:41 PM, Alfa Diallo wrote: > >> 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 > > > You later provided a link to a csv version of that dataset. I loaded it into > an OpenOffice spreadsheet (because my purchased copy of Excel was no longer > functional after a harddisk crash and restore from backup to a different disk > and MS now claims to not have any record of it so refuses to let me > re-register it to the new disk despite having all the original boxes and > fancy security tags.) > > At any rate, I am attaching a png copy of the data in its original version > and in a transposed version what I would suggest is closer to how one might > store your data. Presenting pictures of data is almost always a bad idea on > Rhelp, but this seems the best way to illustrate the current arangement. At > the moment you have a mixture of columnar and row-wise storage. You should > convert to all columnar. This will require copying the "z" values of interest > to new columns after the transpose. You can probably do that in Excel easier > than doing it in R. Then when you have an all-columnar arrangement, just use > read.csv. > > <sprdsht.transpose.png> > > > David Winsemius > Alameda, CA, USA > ______________________________________________ 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.
