Reputation
27,606
Next tag badge:
212/100 score
19/20 answers
Badges
2 58 126
Newest
 Good Answer
Impact
~134k people reached

Jan
9
comment SQL-like computation on Dataset: Aggregate function
@GordonCoale Well spotted. Technically you are correct, but a bug in 10.0.1 causes the query to fail unless Key is explicitly present. The bug is fixed in 10.0.2. I left Key in place just in case. I'll add a note to that effect to the response.
Jan
8
comment Evaluate specific cells in Mathematica
+1. When I tried it in V10.0.2 (Win 7/64) it worked perfectly, evaluating all (and only) tagged cells. NotebookEvaluate is defined to return only the value from the last evaluation, so it is hard to see the failure from just the screenshot since none of the cells have visible side-effects. Does it fail if the evaluated cells contain Print expressions, or the InsertResults -> True option is included?
Jan
8
comment Evaluate specific cells in Mathematica
I can reproduce the problem in V9.0.1 on Win7/64. It evaluates all elements in the notebook, ignoring the EvaluationElements. If the NotebookEvaluate expression is in the target notebook, it loops indefinitely. In V10.0.2 it works properly, even from within the same notebook.
Jan
8
revised SQL-like computation on Dataset: Aggregate function
grammar
Jan
8
answered SQL-like computation on Dataset: Aggregate function
Jan
7
revised What are all the named Mathematica styles?
added the expression needed to autoload this functionality
Jan
7
answered What are all the named Mathematica styles?
Jan
7
awarded  programming
Jan
7
comment Select query with named slot lookups?
@alancalvitti If I run your query against the exhibited input data, I get the same result as my query: the single entry for 00:12:27.9. That is correct since it is the only one between 00:12:15 and 00:38:49. Perhaps your screenshot was taken after using different data?
Jan
6
awarded  Good Answer
Jan
6
comment Select query with named slot lookups?
@alancalvitti Ah yes, my misunderstanding. Does my update help?
Jan
6
revised Select query with named slot lookups?
added the update in response to @alancalvitti's comment
Jan
6
answered Interactively inspecting parts of an object
Jan
6
revised Select query with named slot lookups?
missing word
Jan
6
answered Select query with named slot lookups?
Jan
5
revised How to use Manipulate to cycle through a list of lists over a function
added the code to use a slider in Manipulate
Jan
5
answered How to use Manipulate to cycle through a list of lists over a function
Jan
5
answered How to Insert Multiples Rows in Database (SQL)
Jan
4
comment How to join several list interleaving with some fixed list between?
The exhibited function does not work for the example shown in the question. This is because Riffle interprets a list in the second argument as a cyclic replacement specification. The second argument must be wrapped in a list to work around this interpretation: MyJoin[list_,glue_] := Join @@ Riffle[list, {glue}] or MyJoin = Join @@ Riffle[#, {#2}] &.
Jan
4
awarded  Nice Answer