1. Home
  2. Creating Filters and Subsets of Data

Creating Filters and Subsets of Data

When dealing with a large set of data, you often need to be able to select a subset of values to study, either temporarily, or for the remainder of a session.

For columns, one method of creating a subset is to create a copy of a spreadsheet, then remove any rows or columns that are not required. You can also create a column subset by forming a new spreadsheet using only the columns you specify (rather than removing the ones you don’t need).

For rows, you can create restrictions (filters) to temporarily restrict the data displayed in a spreadsheet. When data are restricted in a spreadsheet, the Genstat server ignores any rows that are not included in the restriction. This provides a way of analysing a subset of data without having to make a copy of the data containing just the required rows.

You can also split a spreadsheet into multiple new sheets by specifying the criteria for each subset to be put in its own spreadsheet.

In this section

Filtering/Restricting Overview
Subset by Matching Conditions
Generating a Random Subset
Displaying Excluded Rows
Subset on Update
Restrict by Logical Expression
Restrict to Groups (factor levels)
Restrict by Value
Restrict Selected Rows
Restrict Unselected Rows
Save/Apply a Restriction
Restrict Bookmarked Rows
Restrict to Duplicate Rows (duplicate values)
Restrict to Random Rows
Restrict to Rows Selected from Graph
Restrict Values Equal to the Current Cell
Restrict Values Not Equal to the Current Cell
Exclude Rows with Missing Values
Exclude Rows with all Missing Values
Include Only Rows with Missing Values
Reversing a Restriction
Removing All Restrictions
Setting the Default Colour of Restricted Rows

Updated on February 25, 2019

Was this article helpful?