r - data.table is not handling integer64 in by statement -


using fread data.table load integer64 correctly, though have impression by statements not handling int64 correctly. doing someting wrong here, ?

library(data.table); library(bit64); test = data.table(x=c(1,2,3),y=c('x','q','q'),id=as.integer64(c('432706205348805058','432706205348805058','432706205348805059')))  str(test) #the display wrong (but expected) #classes ‘data.table’ , 'data.frame':  3 obs. of  3 variables: # $ x : num  1 2 3 # $ y : chr  "x" "q" "q" # $ id:class 'integer64'  num [1:3] 9.52e-280 9.52e-280 9.52e-280 # - attr(*, ".internal.selfref")=<externalptr>   test # here displayed correctly #   x y                 id #1: 1 x 432706205348805058 #2: 2 q 432706205348805058 #3: 3 q 432706205348805059  txtr) test$id integer64 [1] 432706205348805058 432706205348805058 432706205348805059  txtr) test[,list(count=.n),by=id] #wrrrong                    id count 1: 432706205348805058     3

update: implemented in v1.9.3 (available r-forge), see news :

o bit64::integer64 works in grouping , joins, #5369. james sams highlighting upcs , clayton stanley.
reminder: fread() has been able detect , read integer64 while.

on op's example above:

test[, .n, by=id] #                    id n # 1: 432706205348805058 2 # 2: 432706205348805059 1

integer64 isn't yet implemented data.table operations such setkey or by. implemented in fread (first released cran on 6 march 2013) first step. useful value column example.

i may have confused matters filing bug report relating (the 1 @arun linked to). strictly speaking, isn't bug feature request. think of bug list more 'important things resolve before next release'.

contributions welcome.


Comments

Post a Comment

Popular posts from this blog

Receive udp packets in android gstreamer -

i using eclipse juno in windows 7. doing programming on android 4.2 platform. want receive udp packets in gstreamer application. giving uri udp://127.0.0.1:1234 , sending file vlc player same computer. emulator giving message could not get/set setting from/on resource while in case of rtp, giving message no uri implementer found rtp ideas how receive streaming media in android?
Read more

php - Extract Text from HTTP referer -

i using following code show referer link page on website. how can modify code shows part of link. i.e if website url www.example.com/?s=printing want extract printing. , should happen if format www.example.com/?s=aaa , not if format else www.example.com/printing. code: <?php session_start(); if ( !isset( $_session["origurl"] ) ) $_session["origurl"] = $_server["http_referer"]; echo $_session["origurl"] ?> i figured out , following code works: <?php session_start(); if ( !isset( $_session["origurl"] ) ) $_session["origurl"] = $_server["http_referer"]; $mysearchterm = $_server["http_referer"]; $whatiwant = substr($mysearchterm, strpos($mysearchterm, "=") +1); echo $whatiwant; ?>
Read more

matplotlib - PYTHON: Annotate boxes disapear dependant on range -

Image
i have issue plotting info boxes of data , fit. toy example follows. import numpy np import matplotlib.pyplot plt #works sigma = 0.12 mu = 0.5 #half works sigma = 0.1 mu = 0.3 ##none works #sigma = 0.05 #mu = 0.2 sample = np.random.normal(mu, sigma, 10000) fighs = plt.figure() axhs = fighs.add_subplot(1, 1, 1) n, histbins, patches = axhs.hist(sample,100, histtype='step', normed=1) axhs.annotate("$\mu=%.3f$ \n $\sigma=%.3f$ \n $n=%i$"% (sample.mean(), sample.std(), len(sample)), xytext=(0.8, 0.85), bbox=dict(boxstyle="sawtooth", fc="w"), xy=(0.8, 0.85), textcoords='axes fraction') axhs.plot(histbins, plt.mlab.normpdf(histbins, mu, sigma)) axhs.annotate(" $\mu=%.3f$ \n $\sigma=%.3f$ \n $n=%s$"%(mu,sigma,"--"), xytext=(0.6, 0.85), bbox=dict(boxstyle="round", fc="w"), xy=(0.6, 0.85), textcoords='axes fraction') plt....
Read more