Dear all, I have found the error, my fault. Sorry. There was an extra come in the headers line. Thanks again.
If I can I would like to ask you another questions about the imported data. I would like to compute the daily average of the different date. Basically I have hourly data, I would like to ave the daily mean of them. Is there some special commands? Thanks a lot. Diego On 31 July 2018 at 10:40, Diego Avesani <diego.aves...@gmail.com> wrote: > 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/posti >> ng-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/posti >> ng-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.