[R] about data format in R
dulcalma at bigpond.com
Fri Dec 30 23:01:31 CET 2016
Is this the output from Excel?
If so format it in Excel for a date format not a date-time format .
Depending how the dates were inputted into Excel and the Excel setup a date
may not be a date format.
There are no rules with microsoft formatting so beware!
Department of Agronomy and Soil Science
University of New England
Armidale NSW 2351
Email: home: mackay at northnet.com.au
From: R-help [mailto:r-help-bounces at r-project.org] On Behalf Of lily li
Sent: Saturday, 31 December 2016 05:38
To: Rui Barradas
Cc: R mailing list
Subject: Re: [R] about data format in R
Thanks for your reply. When I read in data using my code, the first column
ranges from 0 to 1. So when I use the code you wrote, it shows the error
Error in as.POSIXct.numeric(DF$Date, format = "%m/%d/%Y-%H:%M:%S") :
'origin' must be supplied
On Fri, Dec 30, 2016 at 11:23 AM, Rui Barradas <ruipbarradas at sapo.pt> wrote:
> Have you tried
> df$date <- as.POSIXct(dat$date, format = "%m/%d/%Y-%H:%M:%S")
> Hope this helps,
> Rui Barradas
> Em 30-12-2016 17:40, lily li escreveu:
>> Hi R users,
>> I'm trying to read in data, and then plot time series data. However, I
>> some problems. In my dataset, the first column represents time, and in
>> mm/dd/yyyy-hr:min:sec; For example, 10/01/1995-00:00:00,
>> 10/01/1995-06:00:00, etc.
>> date evap precip intercept
>> 10/01/1995-00:00:00 1.5 2 0.2
>> 10/01/1995-12:00:00 1.7 2.2 0.1
>> 10/02/1995-00:00:00 1.5 1.8 0.3
>> My code is like this
>> file1 = read.table('df', head=T)
>> When I read in data, I found that it read incorrectly. How to format when
>> read in data? Thanks.
>> [[alternative HTML version deleted]]
>> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
>> PLEASE do read the posting guide http://www.R-project.org/posti
>> and provide commented, minimal, self-contained, reproducible code.
[[alternative HTML version deleted]]
R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
More information about the R-help