Re: [R] how to merge commands

2012-02-23 Thread Nino Pierantonio
Thanks Don for your suggestion. I have received the original data in Excel xlsx format so I must work with them unless I want to change file format to thousands of files... I am also saving my output R files in Excel format to make them compatible with the original ones. Everything will be then

Re: [R] how to merge commands

2012-02-22 Thread MacQueen, Don
Are you absolutely certain that the data must be stored in Excel? In the long run I believe you will find it easier if the data is stored in an external database, or some other data repository that does not require you to read so many separate files. Probably the best you can hope for as it is no

[R] how to merge commands

2012-02-21 Thread Nino Pierantonio
Dear all, I am using R to work on huge numbers of telemetry data divided by day. Each file (an xlsx file) contains 2 rows, the first one for sst readings and the second one for chl readings, and 72360 columns, each corresponding to the centre of a cell in my study area. The columns have no he