[R] read txt file - date - no space

[Diego Avesani]

Dear all,
I move to csv file because originally the date where in csv file.
In addition, due to the fact that, as you told me, read.csv is a special
case of read.table, I prefer start to learn from the simplest one.
After that, I will try also the *.txt format.

with read.csv, something strange happened:

This us now the file:

date,st1,st2,st3,
10/1/1998 0:00,0.6,0,0
10/1/1998 1:00,0.2,0.2,0.2
10/1/1998 2:00,0.6,0.2,0.4
10/1/1998 3:00,0,0,0.6
10/1/1998 4:00,0,0,0
10/1/1998 5:00,0,0,0
10/1/1998 6:00,0,0,0
10/1/1998 7:00,0.2,0,0
10/1/1998 8:00,0.6,0.2,0
10/1/1998 9:00,0.2,0.4,0.4
10/1/1998 10:00,0,0.4,0.2

When I apply:
MyData <- read.csv(file="obs_prec.csv",header=TRUE, sep=",")

this is the results:

10/1/1998 0:00    0.6    0.00    0.0 NA
2        10/1/1998 1:00    0.2    0.20    0.2 NA
3        10/1/1998 2:00    0.6    0.20    0.4 NA
4        10/1/1998 3:00    0.0    0.00    0.6 NA
5        10/1/1998 4:00    0.0    0.00    0.0 NA
6        10/1/1998 5:00    0.0    0.00    0.0 NA
7        10/1/1998 6:00    0.0    0.00    0.0 NA
8        10/1/1998 7:00    0.2    0.00    0.0 NA

I do not understand why.
Something wrong with date?

really really thanks,
I appreciate a lot all your helps.

Diedro


Diego


On 31 July 2018 at 01:25, MacQueen, Don <macqueen1 using llnl.gov> wrote:

> 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.
>
>
>

	[[alternative HTML version deleted]]