Delete Tables and Plots - Delete If Sample Size Lower Than Specified Value

From Q
Jump to navigation Jump to search

Deletes any tables from your project that have a sample size smaller than a specified value. This QScript deletes any tables from your project that have a sample size smaller than a specified value.

Technical details

This QScript:

  • Asks you to specify a minimum sample size to keep.
  • Asks you to select which tables you would like to check.
  • Deletes any tables from your selection where the largest value of Base n in the cells of the table is less than the minimum value.

How to apply this QScript

  • Start typing the name of the QScript into the Search features and data box in the top right of the Q window.
  • Click on the QScript when it appears in the QScripts and Rules section of the search results.

OR

  • Select Automate > Browse Online Library.
  • Select this QScript from the list.

Customizing the QScript

This QScript is written in JavaScript and can be customized by copying and modifying the JavaScript.

Customizing QScripts in Q4.11 and more recent versions

  • Start typing the name of the QScript into the Search features and data box in the top right of the Q window.
  • Hover your mouse over the QScript when it appears in the QScripts and Rules section of the search results.
  • Press Edit a Copy (bottom-left corner of the preview).
  • Modify the JavaScript (see QScripts for more detail on this).
  • Either:
    • Run the QScript, by pressing the blue triangle button.
    • Save the QScript and run it at a later time, using Automate > Run QScript (Macro) from File.

Customizing QScripts in older versions

  • Copy the JavaScript shown on this page.
  • Create a new text file, giving it a file extension of .QScript. See here for more information about how to do this.
  • Modify the JavaScript (see QScripts for more detail on this).
  • Run the file using Automate > Run QScript (Macro) from File.

JavaScript

// Whenever a table's sample size is so small it's not worth looking at, delete the table.
// The sample size used for the comparison is the largest value of Base n on the table.

includeWeb('JavaScript Utilities');
includeWeb('QScript Table Functions');
includeWeb('QScript Selection Functions');
includeWeb('QScript Utility Functions');
includeWeb('QScript Functions for Sort and Delete');

deleteWithSmallSample();

See also