DataSetQuery

Programatically query a DataSet

DataSetQuery is a powerful tool for querying data from a DataSet. To use the object, we first create a query by chaining together preset operations from a selection of logical operators such as greater than, less than, equal to. Once the query is constructed, we can then execute it, causing the source dataset to be filtered and copied to a destination dataset. The basic premise is that certain columns or ranges of columns can be extracted from the source based on the values of other columns across all identifiers of a dataset. This is a powerful way to curate statistics and data conditionally. Use the widget below to see how a small subset of the possible operations can be used together to extract specific identifiers and columns of information. The left DataSet is the source which is filtered and then copied to the right DataSet.

DataSet

Identifier
Data
one
1.00
2.00
3.00
4.00
two
2.00
4.00
30.00
40.00
three
0.01
0.02
0.03
0.04

DataSet

Identifier
Data
Last modified: Tue Aug 23 14 by James Bradbury
Edit File on GitHub