11. General data manipulation (Tools, further Pre-treatment)
Tools vs. Edit menu
Both the Edit (see Section 1) and Tools main menus carry out ‘housekeeping’ manipulations on a da...
Average and Sum on data matrices; Average on resemblance matrices
Tools>Average and Sum operate in the same way on data sheets. For example, when (Samples• Average...
Aggregation
So far we have only seen variable information sheets, containing taxonomic (or other) hierarchies...
Check on aggregation files
Use the open aggregation file, Groundfish taxonomy, to show the smaller set of Tools items (Tree,...
Tree menu; Check on datasheets & resemblances; Undefined resemblances
The other Tools menu item for aggregation sheets is distinctive to this case, namely Tools>Tree; ...
Duplicate; Merge (/join) operations
Tools>Duplicate operates in the same way whether the active window is a data array, resemblance m...
(Tasmanian meiofauna)
The nematode and copepod datasheets from 16 samples at a Tasmanian sand-flat (C:\Examples v7\ Tas...
Combined cells in Merge
Occasionally, use of strict label names does not give the this desired outcome, and the default b...
Avoiding strict label matching
The best policy to avoid confusion is to use precise, unique species and sample labels (typically...
Merging non-uniform species lists; (Phuket coral reefs); (Clyde dump-ground study)
Perhaps the greatest benefit of the strict label matching in PRIMER is the ability to Tools>Merge...
Missing data estimation
The subject of missing data has arisen several times already (Sections 1, 3, 5) and the point mad...
EM algorithm assumptions
Tools>Missing is designed to operate only on matrices for which: a) assumptions of multivariate n...
Missing data estimation (Clyde study)
Transformation options for the Clyde environmental matrix, Clyde environment, are discussed in mo...
Ranked variables
The following section (on PCA) will discuss further the choice of particular transformations to a...
Ranked resemblances
Ranking is also a menu option when the active sheet is a resemblance (Tools>Rank distance), but i...
Transposing the datasheet
The Clyde environment sheet has samples as rows and variables as columns. This is the opposite of...
Transform (individual) advanced
Unlike previous versions, in PRIMER 7 the Transform(individual) routine has been moved to a more ...
Expressions combining variables
For an example of an Expression combining two (or more) variables, use the Clyde environmental sh...
Expressions combining worksheets
Similarly, expressions can combine samples, or even factors (or indicators) on those samples (or ...
Average body mass matrix (B/A)
A useful variation of this, but one which needs more care, is to compute average body mass of eac...
Transform on resemblances; Combining resemblances
Transforming resemblances remains in the Tools menu in PRIMER 7, since it is not an option for pr...
Tools menu - other items; Tools Options menu
Tools operations on resemblances which are discussed elsewhere are: a) Dissim and Unravel in Sect...