[R] read txt file - date - no space

[Diego Avesani]

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.avesani using 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 <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/posti
>> ng-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/posti
>> ng-guide.html
>>     and provide commented, minimal, self-contained, reproducible code.
>>
>>
>>
>

	[[alternative HTML version deleted]]