Re: Digest for incanter@googlegroups.com - 1 update in 1 topic

[Avram Aelony]

I haven't tried this, but expect a missing value to be treated in the R tradition, possibly with NA?

see: https://groups.google.com/forum/m/#!topic/incanter/jXYP16E88Vs

Cheers,

Avram

On May 29, 2016, at 12:29 AM, inca...@googlegroups.com wrote:

inca...@googlegroups.com

Google Groups

Topic digest
View all topics

• $where will not filter dataset where col values are zero - 1 Update

$where will not filter dataset where col values are zero

Cold Gin <coldg...@gmail.com>: May 27 04:20PM -0700 Hello. I have two rows in my dataset where the column value (mycol) is 0 when I do (i/view dataset). I have tried all of the following $where variations to retrieve the zero rows, but none of these $where queries will return them:   (i/$ 11 (i/$where {:11 {:eq 0.0}} dataset))   (i/$where {:11 {:eq 0.0}} dataset)   (i/$where {:mycol {:eq 0.0}} dataset)   (i/$where {:mycol {:eq 0}} dataset)   (i/$where {:11 {:$fn #(= % 0)}} dataset)   (i/$where {:11 {:$fn #(nil? % )}} dataset)   (i/$where {:mycol {:eq ""}} dataset)   (i/$where {:mycol {:eq " "}} dataset)   (i/$where {:11 {:$eq 0.0}} dataset)   (i/$where {:11 {:$eq 0}} dataset)   Any insights on how I can filter and bring back only the zero rows? The $where clause does work if I explicitly select by another different column string value in the same row. I need to detect the rows that have zero for the mycol column though.   Thanks.

Back to top

You received this digest because you're subscribed to updates for this group. You can change your settings on the group membership page. To unsubscribe from this group and stop receiving emails from it send an email to incanter+u...@googlegroups.com.