On Wed, 18 Jul 2018, David Winsemius wrote:> It's not so much as factors but rather in a form that paste() will coerce > to character so you cna get the automatic formatDavid, Now I understand.> Maybe you need to add a format string. It might force some of your pasted > date+time values to NA but at least you would be able to identify the > original values and perhaps fix errors.Thinking about the data I realize that rather than separate date and time columns what's needed is a datetime string. I'll add the format string in the morning and work on this.> You really should include a large snapshot of data that will allow > reproducibility.I'll certainly do this. With hourly and half-hourly data from 1989-June 2018 (but missing all of 1992) there are more than 400K rows in the raw data file. If you would suggest how many would be an acceptably large number I'll be happy to put that on a 'cloud' sharing site and provide the URL to it. Best regards, Rich
On Wed, 18 Jul 2018, Rich Shepard wrote:> If you would suggest how many would be an acceptably large number I'll be > happy to put that on a 'cloud' sharing site and provide the URL to it.I put a zipped data file at this URL: <http://www.fileconvoy.com/dfl.php?id=g61a366bb8947de43100009863935141c96f82092d4> It will stay there for 5 days. Rich
On Thu, 19 Jul 2018, Rich Shepard wrote:> I put a zipped data file at this URL: > <http://www.fileconvoy.com/dfl.php?id=g61a366bb8947de43100009863935141c96f82092d4>Since then I reformatted the file to two fields: date-time and elevation. If anyone wants a copy send me a message off the list and I'll respond with the modified file attached. Because time zone doesn't matter for a single location I'm looking at how to use chron(). I've downloaded the PDF from CRAN and am trying to apply it correctly so the dataframe contains two columns: date-time and elevation. Will probably be asking for help in correctly using chron(). Rich