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 <macque...@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-boun...@r-project.org on behalf of drjimle...@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.aves...@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@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@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]]
______________________________________________
R-help@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.
