Chris Evans
2016-Sep-12 05:57 UTC
[R] Help with strftime error "character string is not in a standard unambiguous format"
I am trying to read activity data created by Garmin. It outputs dates like this: "Thu, 25 Aug 2016 6:34 PM" The problem that has stumped me is this:> strftime("Thu, 25 Aug 2016 6:34 PM",format="%a, %d %b %Y %I:%M %p")Error in as.POSIXlt.character(x, tz = tz) : character string is not in a standard unambiguous format I _thought_ I had this running OK but that error is catching me now. I think I've read ?strftime and written that format string correctly to match the input but I'm stumped now. Can someone advise me? Many thanks in advance, Chris> sessionInfo()R version 3.3.1 (2016-06-21) Platform: x86_64-w64-mingw32/x64 (64-bit) Running under: Windows 10 x64 (build 10586) locale: [1] LC_COLLATE=English_United Kingdom.1252 [2] LC_CTYPE=English_United Kingdom.1252 [3] LC_MONETARY=English_United Kingdom.1252 [4] LC_NUMERIC=C [5] LC_TIME=English_United Kingdom.1252 attached base packages: [1] stats graphics grDevices utils datasets methods base loaded via a namespace (and not attached): [1] compiler_3.3.1 tools_3.3.1>
peter dalgaard
2016-Sep-12 07:12 UTC
[R] Help with strftime error "character string is not in a standard unambiguous format"
> On 12 Sep 2016, at 07:57 , Chris Evans <chrishold at psyctc.org> wrote: > >> strftime("Thu, 25 Aug 2016 6:34 PM",format="%a, %d %b %Y %I:%M %p")strptime, not strftime... -- Peter Dalgaard, Professor, Center for Statistics, Copenhagen Business School Solbjerg Plads 3, 2000 Frederiksberg, Denmark Phone: (+45)38153501 Office: A 4.23 Email: pd.mes at cbs.dk Priv: PDalgd at gmail.com
jeremiah rounds
2016-Sep-12 07:37 UTC
[R] Help with strftime error "character string is not in a standard unambiguous format"
Not sure what the issue is with the provided code but note:
library(lubridate)
lubridate::dmy_hm("Thu, 25 Aug 2016 6:34 PM")
[1] "2016-08-25 18:34:00 UTC"
Though if you go that route: set the TZ because on the timestamp it is
ambiguous.
On Sun, Sep 11, 2016 at 10:57 PM, Chris Evans <chrishold at psyctc.org>
wrote:
> I am trying to read activity data created by Garmin. It outputs dates like
> this:
>
> "Thu, 25 Aug 2016 6:34 PM"
>
> The problem that has stumped me is this:
>
> > strftime("Thu, 25 Aug 2016 6:34 PM",format="%a, %d %b
%Y %I:%M %p")
> Error in as.POSIXlt.character(x, tz = tz) :
> character string is not in a standard unambiguous format
>
> I _thought_ I had this running OK but that error is catching me now. I
> think I've read ?strftime and written that format string correctly to
match
> the input but I'm stumped now.
>
> Can someone advise me? Many thanks in advance,
>
> Chris
>
>
> > sessionInfo()
> R version 3.3.1 (2016-06-21)
> Platform: x86_64-w64-mingw32/x64 (64-bit)
> Running under: Windows 10 x64 (build 10586)
>
> locale:
> [1] LC_COLLATE=English_United Kingdom.1252
> [2] LC_CTYPE=English_United Kingdom.1252
> [3] LC_MONETARY=English_United Kingdom.1252
> [4] LC_NUMERIC=C
> [5] LC_TIME=English_United Kingdom.1252
>
> attached base packages:
> [1] stats graphics grDevices utils datasets methods base
>
> loaded via a namespace (and not attached):
> [1] compiler_3.3.1 tools_3.3.1
> >
>
> ______________________________________________
> 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]]
Jeff Newmiller
2016-Sep-12 08:00 UTC
[R] Help with strftime error "character string is not in a standard unambiguous format"
Perhaps use the correct function. (Just one little letter off...) -- Sent from my phone. Please excuse my brevity. On September 11, 2016 10:57:39 PM PDT, Chris Evans <chrishold at psyctc.org> wrote:>I am trying to read activity data created by Garmin. It outputs dates >like this: > >"Thu, 25 Aug 2016 6:34 PM" > >The problem that has stumped me is this: > >> strftime("Thu, 25 Aug 2016 6:34 PM",format="%a, %d %b %Y %I:%M %p") >Error in as.POSIXlt.character(x, tz = tz) : > character string is not in a standard unambiguous format > >I _thought_ I had this running OK but that error is catching me now. I >think I've read ?strftime and written that format string correctly to >match the input but I'm stumped now. > >Can someone advise me? Many thanks in advance, > >Chris > > >> sessionInfo() >R version 3.3.1 (2016-06-21) >Platform: x86_64-w64-mingw32/x64 (64-bit) >Running under: Windows 10 x64 (build 10586) > >locale: >[1] LC_COLLATE=English_United Kingdom.1252 >[2] LC_CTYPE=English_United Kingdom.1252 >[3] LC_MONETARY=English_United Kingdom.1252 >[4] LC_NUMERIC=C >[5] LC_TIME=English_United Kingdom.1252 > >attached base packages: >[1] stats graphics grDevices utils datasets methods base > > >loaded via a namespace (and not attached): >[1] compiler_3.3.1 tools_3.3.1 >> > >______________________________________________ >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.
Daniel Nordlund
2016-Sep-12 08:23 UTC
[R] Help with strftime error "character string is not in a standard unambiguous format"
On 9/11/2016 10:57 PM, Chris Evans wrote:> I am trying to read activity data created by Garmin. It outputs dates like this: > > "Thu, 25 Aug 2016 6:34 PM" > > The problem that has stumped me is this: > >> strftime("Thu, 25 Aug 2016 6:34 PM",format="%a, %d %b %Y %I:%M %p") > Error in as.POSIXlt.character(x, tz = tz) : > character string is not in a standard unambiguous format > > I _thought_ I had this running OK but that error is catching me now. I think I've read ?strftime and written that format string correctly to match the input but I'm stumped now. > > Can someone advise me? Many thanks in advance, > > Chris > > >> sessionInfo() > R version 3.3.1 (2016-06-21) > Platform: x86_64-w64-mingw32/x64 (64-bit) > Running under: Windows 10 x64 (build 10586) > > locale: > [1] LC_COLLATE=English_United Kingdom.1252 > [2] LC_CTYPE=English_United Kingdom.1252 > [3] LC_MONETARY=English_United Kingdom.1252 > [4] LC_NUMERIC=C > [5] LC_TIME=English_United Kingdom.1252 > > attached base packages: > [1] stats graphics grDevices utils datasets methods base > > loaded via a namespace (and not attached): > [1] compiler_3.3.1 tools_3.3.1 >> > > ______________________________________________ > 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 have always used strptime() for this task, and > strptime("Thu, 25 Aug 2016 6:34 PM",format="%a, %d %b %Y %I:%M %p") [1] "2016-08-25 18:34:00 PDT" works for me. Hope this is helpful, Dan -- Daniel Nordlund Port Townsend, WA USA
Enrico Schumann
2016-Sep-12 09:05 UTC
[R] Help with strftime error "character string is not in a standard unambiguous format"
On Mon, 12 Sep 2016, Chris Evans <chrishold at psyctc.org> writes:> I am trying to read activity data created by Garmin. It outputs dates like this: > > "Thu, 25 Aug 2016 6:34 PM" > > The problem that has stumped me is this: > >> strftime("Thu, 25 Aug 2016 6:34 PM",format="%a, %d %b %Y %I:%M %p") > Error in as.POSIXlt.character(x, tz = tz) : > character string is not in a standard unambiguous formatDidn't you mean strptime? ^ > strptime("Thu, 25 Aug 2016 6:34 PM",format="%a, %d %b %Y %I:%M %p") ## [1] "2016-08-25 18:34:00 CEST"> I _thought_ I had this running OK but that error is catching me now. > I think I've read ?strftime and written that format string correctly > to match the input but I'm stumped now. > > Can someone advise me? Many thanks in advance, > > Chris > > >> sessionInfo() > R version 3.3.1 (2016-06-21) > Platform: x86_64-w64-mingw32/x64 (64-bit) > Running under: Windows 10 x64 (build 10586) > > locale: > [1] LC_COLLATE=English_United Kingdom.1252 > [2] LC_CTYPE=English_United Kingdom.1252 > [3] LC_MONETARY=English_United Kingdom.1252 > [4] LC_NUMERIC=C > [5] LC_TIME=English_United Kingdom.1252 > > attached base packages: > [1] stats graphics grDevices utils datasets methods base > > loaded via a namespace (and not attached): > [1] compiler_3.3.1 tools_3.3.1 >> > > ______________________________________________ > 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.-- Enrico Schumann Lucerne, Switzerland http://enricoschumann.net
Ismail SEZEN
2016-Sep-12 09:36 UTC
[R] Help with strftime error "character string is not in a standard unambiguous format"
It should be strptime for character vectors.
strptime("Thu, 25 Aug 2016 6:34 PM",format="%a, %d %b %Y %I:%M
%p?)
> On 12 Sep 2016, at 08:57, Chris Evans <chrishold at psyctc.org>
wrote:
>
>> strftime("Thu, 25 Aug 2016 6:34 PM",format="%a, %d %b %Y
%I:%M %p")
[[alternative HTML version deleted]]
Chris Evans
2016-Sep-12 10:33 UTC
[R] Help with strftime error "character string is not in a standard unambiguous format"
OK. I'm an idiot (not for the first time and, sadly, no doubt not for the last). strptime() was all that was needed: just that one pesky character and I can't remember now why I went astray there, but thanks to all who supplied the answer and all who supplied additional useful information. As ever, deeply indebted to the R and R-help communities, Chris> From: "Ismail SEZEN" <sezenismail at gmail.com> > To: "Chris Evans" <chrishold at psyctc.org> > Cc: "r-help" <r-help at r-project.org> > Sent: Monday, 12 September, 2016 10:36:51 > Subject: Re: [R] Help with strftime error "character string is not in a standard > unambiguous format"> It should be strptime for character vectors.> strptime("Thu, 25 Aug 2016 6:34 PM",format="%a, %d %b %Y %I:%M %p?)>> On 12 Sep 2016, at 08:57, Chris Evans < chrishold at psyctc.org > wrote:>>> strftime("Thu, 25 Aug 2016 6:34 PM",format="%a, %d %b %Y %I:%M %p")[[alternative HTML version deleted]]