On Thu, Dec 14, 2017 at 1:58 PM, Berend Hasselman <bhh at xs4all.nl> wrote:> >> On 14 Dec 2017, at 19:36, lily li <chocold12 at gmail.com> wrote: >> >> Hi R users, >> >> I have a question about reading from text files. The file has the structure >> below: >> >> Time Column1 Column2 >> 01.01.2001-12:00:00 > > This line does not contain 3 elements; only one. > You'll have to fix that line. Delete it, prepend it with a comment character of add enough columns.I definitely don't recommend that. Instead, read ?read.table to learn about the "fill" and "header" arguments. df = read.table("DATAM", header = TRUE, fill = TRUE) will probably work. Best, Ista> > > Berend > >> 01.01.2001-24:00:00 12 11 >> 01.02.2001-12:00:00 13 10 >> 01.02.2001-24:00:00 11 12 >> 01.03.2001-12:00:00 15 11 >> 01.03.2001-24:00:00 16 10 >> ... >> >> I just use the simple script to open it: df = read.table('DATAM', head=T). >> >> But it has the error and thus cannot read the file: >> Error in scan(file = file, what = what, sep = sep, quote = quote, dec >> dec, : >> line 1 did not have 3 elements >> >> How to read it with three fixed columns, and how to read the time format in >> the first column correctly? Thanks for your help. >> >> [[alternative HTML version deleted]] >> >> ______________________________________________ >> R-help at 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 at 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.
> On 14 Dec 2017, at 20:01, Ista Zahn <istazahn at gmail.com> wrote: > > On Thu, Dec 14, 2017 at 1:58 PM, Berend Hasselman <bhh at xs4all.nl> wrote: >> >>> On 14 Dec 2017, at 19:36, lily li <chocold12 at gmail.com> wrote: >>> >>> Hi R users, >>> >>> I have a question about reading from text files. The file has the structure >>> below: >>> >>> Time Column1 Column2 >>> 01.01.2001-12:00:00 >> >> This line does not contain 3 elements; only one. >> You'll have to fix that line. Delete it, prepend it with a comment character of add enough columns. > > I definitely don't recommend that. Instead, read > > ?read.table > > to learn about the "fill" and "header" arguments. > > df = read.table("DATAM", header = TRUE, fill = TRUE) > > will probably work. >Yes. I agree. It's much better. I should have experimented some more. Berend> Best, > Ista > > >> >> >> Berend >> >>> 01.01.2001-24:00:00 12 11 >>> 01.02.2001-12:00:00 13 10 >>> 01.02.2001-24:00:00 11 12 >>> 01.03.2001-12:00:00 15 11 >>> 01.03.2001-24:00:00 16 10 >>> ... >>> >>> I just use the simple script to open it: df = read.table('DATAM', head=T). >>> >>> But it has the error and thus cannot read the file: >>> Error in scan(file = file, what = what, sep = sep, quote = quote, dec >>> dec, : >>> line 1 did not have 3 elements >>> >>> How to read it with three fixed columns, and how to read the time format in >>> the first column correctly? Thanks for your help. >>> >>> [[alternative HTML version deleted]] >>> >>> ______________________________________________ >>> R-help at 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 at 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.
In addition to which, I would recommend
df <- read.table("DATAM", header = TRUE, fill = TRUE,
stringsAsFactors=FALSE)
and then converting the Time column to POSIXct date-time values using
as.POSIXct()
specifying the format using formatting codes found in
?strptime
because the times are not in the POSIXct default format.
This example might indicate the idea:
> as.POSIXct('2012-10-12 13:14')
[1] "2012-10-12 13:14:00 PDT"> class(as.POSIXct('2012-10-12 13:14'))
[1] "POSIXct" "POSIXt"
-Don
--
Don MacQueen
Lawrence Livermore National Laboratory
7000 East Ave., L-627
Livermore, CA 94550
925-423-1062
Lab cell 925-724-7509
On 12/14/17, 11:01 AM, "R-help on behalf of Ista Zahn"
<r-help-bounces at r-project.org on behalf of istazahn at gmail.com>
wrote:
On Thu, Dec 14, 2017 at 1:58 PM, Berend Hasselman <bhh at xs4all.nl>
wrote:
>
>> On 14 Dec 2017, at 19:36, lily li <chocold12 at gmail.com>
wrote:
>>
>> Hi R users,
>>
>> I have a question about reading from text files. The file has the
structure
>> below:
>>
>> Time Column1 Column2
>> 01.01.2001-12:00:00
>
> This line does not contain 3 elements; only one.
> You'll have to fix that line. Delete it, prepend it with a comment
character of add enough columns.
I definitely don't recommend that. Instead, read
?read.table
to learn about the "fill" and "header" arguments.
df = read.table("DATAM", header = TRUE, fill = TRUE)
will probably work.
Best,
Ista
>
>
> Berend
>
>> 01.01.2001-24:00:00 12 11
>> 01.02.2001-12:00:00 13 10
>> 01.02.2001-24:00:00 11 12
>> 01.03.2001-12:00:00 15 11
>> 01.03.2001-24:00:00 16 10
>> ...
>>
>> I just use the simple script to open it: df =
read.table('DATAM', head=T).
>>
>> But it has the error and thus cannot read the file:
>> Error in scan(file = file, what = what, sep = sep, quote = quote,
dec >> dec, :
>> line 1 did not have 3 elements
>>
>> How to read it with three fixed columns, and how to read the time
format in
>> the first column correctly? Thanks for your help.
>>
>> [[alternative HTML version deleted]]
>>
>> ______________________________________________
>> R-help at 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 at 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 at 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.
I use the method, df$Time = as.POSIXct(df$Time), but it has the warning message: Error in as.POSIXlt.character(x, tz, ...) : character string is not in a standard unambiguous format On Thu, Dec 14, 2017 at 1:31 PM, MacQueen, Don <macqueen1 at llnl.gov> wrote:> In addition to which, I would recommend > > df <- read.table("DATAM", header = TRUE, fill = TRUE, > stringsAsFactors=FALSE) > > and then converting the Time column to POSIXct date-time values using > as.POSIXct() > specifying the format using formatting codes found in > ?strptime > because the times are not in the POSIXct default format. > > > This example might indicate the idea: > > > as.POSIXct('2012-10-12 13:14') > [1] "2012-10-12 13:14:00 PDT" > > class(as.POSIXct('2012-10-12 13:14')) > [1] "POSIXct" "POSIXt" > > -Don > > -- > Don MacQueen > Lawrence Livermore National Laboratory > 7000 East Ave., L-627 > Livermore, CA 94550 > 925-423-1062 > Lab cell 925-724-7509 > > > > On 12/14/17, 11:01 AM, "R-help on behalf of Ista Zahn" < > r-help-bounces at r-project.org on behalf of istazahn at gmail.com> wrote: > > On Thu, Dec 14, 2017 at 1:58 PM, Berend Hasselman <bhh at xs4all.nl> > wrote: > > > >> On 14 Dec 2017, at 19:36, lily li <chocold12 at gmail.com> wrote: > >> > >> Hi R users, > >> > >> I have a question about reading from text files. The file has the > structure > >> below: > >> > >> Time Column1 Column2 > >> 01.01.2001-12:00:00 > > > > This line does not contain 3 elements; only one. > > You'll have to fix that line. Delete it, prepend it with a comment > character of add enough columns. > > I definitely don't recommend that. Instead, read > > ?read.table > > to learn about the "fill" and "header" arguments. > > df = read.table("DATAM", header = TRUE, fill = TRUE) > > will probably work. > > Best, > Ista > > > > > > > > Berend > > > >> 01.01.2001-24:00:00 12 11 > >> 01.02.2001-12:00:00 13 10 > >> 01.02.2001-24:00:00 11 12 > >> 01.03.2001-12:00:00 15 11 > >> 01.03.2001-24:00:00 16 10 > >> ... > >> > >> I just use the simple script to open it: df = read.table('DATAM', > head=T). > >> > >> But it has the error and thus cannot read the file: > >> Error in scan(file = file, what = what, sep = sep, quote = quote, > dec > >> dec, : > >> line 1 did not have 3 elements > >> > >> How to read it with three fixed columns, and how to read the time > format in > >> the first column correctly? Thanks for your help. > >> > >> [[alternative HTML version deleted]] > >> > >> ______________________________________________ > >> R-help at 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 at 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 at 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]]