Error creating R data.table with date-time POSIXlt -


problem creating data.table date-time column:

> mdt <- data.table(id=1:3, d=strptime(c("06:02:36", "06:02:48", "07:03:12"), "%h:%m:%s")) > class(mdt) [1] "data.table" "data.frame" > print(mdt) error in `rownames<-`(`*tmp*`, value = paste(format(rn, right = true),  :    length of 'dimnames' [1] not equal array extent  enter frame number, or 0 exit     1: print(list(id = 1:3, d = list(sec = c(36, 48, 12), min = c(2, 2, 3), hour = c(6, 6, 7), mday = c(31, 2: print.data.table(list(id = 1:3, d = list(sec = c(36, 48, 12), min = c(2, 2, 3), hour = c(6, 6, 7), m 3: `rownames<-`(`*tmp*`, value = paste(format(rn, right = true), ":", sep = ""))

create data.frame , convert data.table works!

> mdf <- data.frame(id=1:3, d=strptime(c("06:02:36", "06:02:48", "07:03:12"), "%h:%m:%s")) > print(mdf)   id                   d 1  1 2014-01-31 06:02:36 2  2 2014-01-31 06:02:48 3  3 2014-01-31 07:03:12 > mdt <- as.data.table(mdf) > print(mdt)    id                   d 1:  1 2014-01-31 06:02:36 2:  2 2014-01-31 06:02:48 3:  3 2014-01-31 07:03:12 > class(mdt) [1] "data.table" "data.frame"

am missing or bug? if bug, report it?

note use r version 3.0.0 , see warnings re. packages built version 3.0.2. can problem? should upgrade r itself? else seems working though.

formatting response blue magister's comment (thanks much), data.table not support posixlt data types performance reason -- see cast string idatetime suggested possible duplicate.

so way go cast time itime (type provided data.table) or date-time (or date only) posixct, depending upon whether date info important or not:

> mdt <- data.table(id=1:3, d=as.itime(strptime(c("06:02:36", "06:02:48", "07:03:12"), "%h:%m:%s"))) > print(mdt)    id        d 1:  1 06:02:36 2:  2 06:02:48 3:  3 07:03:12 > mdt <- data.table(id=1:3, d=as.posixct(strptime(c("06:02:36", "06:02:48", "07:03:12"), "%h:%m:%s"))) > print(mdt)    id                   d 1:  1 2014-01-31 06:02:36 2:  2 2014-01-31 06:02:48 3:  3 2014-01-31 07:03:12

as note in case can benefit it, wanted create date & time input data date & time in separate fields. found useful learn (see ?itime) 1 can add time itime date-time posixct , date-time posixct follows:

> mdt <- as.posixct("2014-01-31") + as.itime("06:02:36") > print(mdt) [1] "2014-01-31 06:02:36 est" > class(mdt) [1] "posixct" "posixt"

-

Comments

Post a Comment

Popular posts from this blog

php - regexp cyrillic filename not matches -

i take list of files php glob(."*.pdf") . files have cyrillic names. example: ООО «Рога и копыта» then load company names database , try find them in file names: preg_match("/$firm_name/ui", $file_name, $match); i have problem: firms if $firm_name visually similar $file_name , preg_match says there no match. mb_detect_encoding both variables return utf-8. there problem in file name, or maybe there encoding or something, can not understand, ask help. upd: $file_name='ООО «Рога и копыта»'; preg_match("/... .Рога и копыта./ui", $file_name, $match); as result, ОО «Рога и копыта» , 1 О missing
Read more

c# - OpenXML hanging while writing elements -

Image
i have program pulls data database, caches file , exports data multiple formats (excel, excel 2003, csv). i'm using openxml sdk 2.0 excel work. these export processes run in parallel (using parallel.foreach ), , amount of data can pretty large - e.g. csvs 800mb. during these larger exports, i've noticed writing of xml documents hang. instance, if have 8 exporting in parallel, @ point "pause". hang around same point: //this.writer openxmlwriter created worksheetpart. this.writer.writeelement(new cell() { cellvalue = new cellvalue(value), datatype = cellvalues.string }); when happens, pause debugger (vs2013 in case) , notice threads blocking around same portion of code - bit deeper in openxml sdk - stem call openxmlwriter.writeelement . i dug through source using justdecompile didn't find answers. appears there intermediary stream in use writing isolated storage , is, reason, blocking. underlying stream each of these filestream . here screenshot ...
Read more

sql - Select Query has unexpected multiple records (MS Access) -

i may tired, can't seem figure out happening. have 2 queries. query 1 has 10 fields. query 2 has 5 fields. fields 1 through 3 same in both queries. trying write select query , simple add field 5 query2 query1 result should query1 additional field (query2.field5). i join first 3 fields both queries , choose select records in query1 , in query2 match. don't know sql, use query designer. expect same number of records have query 1 instead have 3 times or more. can tell me doing wrong. tried reversing joins still seem same records. thanks in advance. here query: the fields in common divisionname , supplierid = vendorid , commodityname . select [part revenue exposed query p1].divisionname, [part revenue exposed query p1].commodityname, [part revenue exposed query p1].suppliername, [part revenue exposed query p1].partnumber, [part revenue exposed query p1].partdescription, [part revenue exposed query p1].bucode, ...
Read more