[R] read txt file - date - no space

[MacQueen, Don]

Or, without removing the first line
  dadf <- read.table("xxx.txt", stringsAsFactors=FALSE, skip=1)

Another alternative,
   dadf$datetime <- as.POSIXct(paste(dadf$V1,dadf$V2))
since the dates appear to be in the default format.
(I generally prefer to work with datetimes in POSIXct class rather than POSIXlt class)

-Don

--
Don MacQueen
Lawrence Livermore National Laboratory
7000 East Ave., L-627
Livermore, CA 94550
925-423-1062
Lab cell 925-724-7509
 
 

On 7/30/18, 4:03 PM, "R-help on behalf of Jim Lemon" <r-help-bounces using r-project.org on behalf of drjimlemon using gmail.com> wrote:

    Hi Diego,
    You may have to do some conversion as you have three fields in the
    first line using the default space separator and five fields in
    subsequent lines. If the first line doesn't contain any important data
    you can just delete it or replace it with a meaningful header line
    with five fields and save the file under another name.
    
    It looks as thought you have date-time as two fields. If so, you can
    just read the first field if you only want the date:
    
    # assume you have removed the first line
    dadf<-read.table("xxx.txt",stringsAsFactors=FALSE
    dadf$date<-as.Date(dadf$V1,format="%Y-%m-%d")
    
    If you want the date/time:
    
    dadf$datetime<-strptime(paste(dadf$V1,dadf$V2),format="%Y-%m-%d %H:%M:%S")
    
    Jim
    
    On Tue, Jul 31, 2018 at 12:29 AM, Diego Avesani <diego.avesani using gmail.com> wrote:
    > Dear all,
    >
    > I am dealing with the reading of a *.txt file.
    > The txt file the following shape:
    >
    > 103001930 103001580 103001530
    > 1998-10-01 00:00:00 0.6 0 0
    > 1998-10-01 01:00:00 0.2 0.2 0.2
    > 1998-10-01 02:00:00 0.6 0.2 0.4
    > 1998-10-01 03:00:00 0 0 0.6
    > 1998-10-01 04:00:00 0 0 0
    > 1998-10-01 05:00:00 0 0 0
    > 1998-10-01 06:00:00 0 0 0
    > 1998-10-01 07:00:00 0.2 0 0
    >
    > If it is possible I have a coupe of questions, which will sound stupid but
    > they are important to me in order to understand ho R deal with file or date.
    >
    > 1) Do I have to convert it to a *csv file?
    > 2) Can a deal with space and not ","
    > 3) How can I read date?
    >
    > thanks a lot to all of you,
    > Thanks
    >
    >
    > Diego
    >
    >         [[alternative HTML version deleted]]
    >
    > ______________________________________________
    > R-help using 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.
    
    ______________________________________________
    R-help using 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.