Evaluate

Basic Examples

Show the order of operations of a
Query
that is constructed of an ascending operator f and an ascending operator g as its arguments:
[◼]
QueryTreeForm
[Query[f,g]]
In[]:=
Out[]//TreeForm=
Show the order of operations of a
Query
that is constructed of (1) a right composition of two descending operators and an ascending operator, (2) the
All
operator, and (3) the ascending operator
i
:
[◼]
QueryTreeForm
[{Select[f]/*GroupBy[g]/*h,All,i}]
In[]:=
Out[]//TreeForm=

Scope

Visualize a
Query
composed of an ascending and a descending operator to aggregate values of a column after filtering the rows:
[◼]
QueryTreeForm
[Query[Select[#b"z"&]/*Total,"a"]]
In[]:=
Out[]//TreeForm=
Visualize the order of operations of a
Query
that applies functions to each column independently :
[◼]
QueryTreeForm
[Query[All,{"a"f,"b"g,"c"h}]]
In[]:=
Out[]//TreeForm=
Visualize a
Query
that constructs a new table by specifying operators that will compute each column :
[◼]
QueryTreeForm
[{All,Key["c"]/*<|"ctotal"Total,"clength"Length|>},ImageSize450]
In[]:=
Out[]//TreeForm=

Options

All the options of
TreeForm
are available to this function:
[◼]
QueryTreeForm
{f,g},ImageSize500,VertexLabelingFalse,EdgeRenderingFunction->
,Thickness[0.05],Arrow[#1,0.1]&,VertexRenderingFunction
,EdgeFormDirective
,Thickness[0.02],Disk[#,0.3],
,Text[Style[#2,FontFamily"Damascus"],#1]&,Background

In[]:=
Out[]//TreeForm=

Applications

QueryTreeForm is useful in thinking through the order of operations in complex queries :

Properties and Relations

QueryTreeForm can be combined with other visualization functions to present additional information:

Possible Issues

Resource Functions that do not format well within TreeForm do not format well in QueryTreeForm either:

Neat Examples

A function which if applied to the Titanic dataset will yield a breakdown of survival by gender and class in an attractive format: