Post-import data checks

Check the orientation

After import, make sure you have specified the orientation correctly by examining the labels on the columns and rows of the data frame. For example, after importing the Fal environmental data from Excel (see the previous page), you can see that the columns are 'Samples' (a periwinkle-coloured strip across the top) and rows are 'Variables' (an olive green-coloured strip along the left margin).

9._Fal_Env_success.png

If you happen to get this the wrong way around (e.g., if your variables are actually columns instead of rows), this can easily be changed (swapped around) by choosing Edit > Properties and toggling the radio button for 'Samples as' to either '$\bullet$Columns' or '$\bullet$Rows', whichever is appropriate.

Check the properties, factors and indicators

To be sure that the import has been fully successful, including all data points, factors and indicators that may have been included in your original Excel file, you can see additional information attached to your data matrix by clicking on your imported dataset in PRIMER, and doing the following:

12._Click_on_Edit....png

10._Fal_env_excel_Properties.png

10._Fal_env_excel_Factors2.png

11._Fal_env_excel_Indicators.png

Run PRIMER's data-checking tool

As an additional option, you can run PRIMER's internal data-checking tool to find and identify certain other features that might be present in your data, including:

To run this routine, start by clicking on your datasheet, then click on Tools > Check...:

16._Tools_check_all.png

For the Fal environmental data, none of these features occurred (see below), and we are ready to proceed with subsequent analyses.

15._Tools_check_output.png


Revision #14
Created 12 February 2024 01:23:19 by Marti
Updated 26 March 2024 00:31:17 by Marti