14 Overview
Data Analysis lets you explore a table of measurements with interactive plots, statistical comparisons, and machine learning. Upload a table from Data Extraction or any other source. The app guesses column roles and feature groups and opens a column editor so you can check or adjust them before plotting.
14.1 General Workflow
- Upload your table, check the guessed column roles, and click Use for this upload. A saved profile that matches the headers exactly skips this check.
- Choose an analysis type and method on the left, then select its numerical features.
- Use the categorical and numerical filters to select the observations to analyze. Later controls operate on this filtered dataset.
- Choose groups and visual encodings. In Feature Comparison and 2D Feature Distribution, Collapse by can replace individual observations with one mean per category within each analysis group.
- Adjust the method-specific controls, plot style, and hover over points to inspect observations.
- Export the analysis as a Python script to reproduce or customize it. GMM analyses also offer labeled CSV downloads.
The plots and results update as you change the controls.
14.2 Methods
| Analysis type | Method | Numerical input |
|---|---|---|
| Univariate | Feature Comparison | One feature compared across groups |
| Univariate | Feature Histogram | One feature’s histogram or Gaussian mixture model |
| Bivariate | 2D Feature Distribution | Two features on a scatter plot |
| Bivariate | Phasor Plot | A matching pair of phasor G and S coordinates |
| Multivariate | Dimension Reduction | At least two features projected into two dimensions |
| Multivariate | Classification | One or more features used to predict categorical labels |
Phasor Plot is available after upload only when the table contains a complete G/S pair with the expected phasor column names. All methods use the shared controls below, with additional controls described in their chapters.
14.3 Input
The same uploader handles extraction results and tables from other sources, in both the desktop and hosted apps. It accepts CSV, TSV/TXT with tab, semicolon, or pipe separators, Excel .xlsx/.xlsm, and OpenDocument .ods. Spreadsheet uploads use the first sheet.
A saved profile whose headers match exactly supplies the column roles and groups, and analysis opens directly. Otherwise, the column editor opens with guessed roles and groups and flags doubtful guesses; choose Use for this upload or save a reusable profile. To change them later, click ✏️ Fix Categorical & Numerical features below the upload summary. See the configuration walkthrough.
14.3.1 Requirements
Use a plain table with column headers on the first row, one observation per row, and at least one usable numerical measurement. Categorical columns, a unique row identifier, and a field-of-view column are optional for every upload.
14.3.2 Column roles
Each column has one role. The app suggests roles after upload; adjust them according to what the values mean.
- Row ID identifies an individual observation in hover text, such as a cell or flower. This role is optional and can belong to at most one column. Its values must be nonmissing and unique after conversion to text. Without an assigned Row ID, the app creates row numbers from
1through the number of input rows. See automatic row numbering and changing identifiers. - Categorical supplies labels for filters and visual grouping, such as species, treatment, day, or patient. Numeric codes can be categorical when they represent labels rather than quantities. Field-of-view labels such as
image_namealso use this role. Categories are stored as text. If every nonmissing value in a numeric category column is a whole number, labels use1rather than1.0; missing values becomeN/A. - Numerical supplies measurements for plotting and analysis, such as length, intensity, or lifetime. At least one column with this role must contain usable numbers. Numerical columns can be organized into feature groups, each providing a dropdown in the feature pickers.
- Ignore excludes a column from analysis while recording its header in the profile, so future uploads can still be matched to the complete table structure.
Use the column’s Role dropdown to change how it is used, then click Use for this upload or save the profile. For example, assigning Categorical to a numeric treatment code makes it available as a category filter. Changing a Numerical column to another role removes its feature-group assignment. See the column-review walkthrough.
If a numerical feature is missing from the feature pickers, including Uncategorized Features, first check that its Role is Numerical in the column review. Then inspect its values for stray text such as --. If non-numeric values account for 1% or less of the column’s non-empty values, the app converts the column to numeric, replaces those cells with NaN, and reports their count. Above that threshold, the column remains text and cannot be used as a numerical feature until those values are cleaned, even if most values are numbers.
14.3.3 Warning Messages
Warnings report cleanup such as dropping empty columns or converting a small number of stray non-numeric values to NaN (see feature recognition). Missing measurements can remain in the table. Plot methods use rows with valid values for their selected numerical features; Classification passes the selected rows to the classifier and reports an error if it cannot accept their missing measurements.
14.3.4 Error Messages
Errors block applying column choices or analysis until the input or roles are corrected. Examples include a malformed table, an assigned Row ID containing missing or duplicate values, or no usable Numerical column. Duplicate row identifiers are not silently removed. In the column review, correct the identifier, choose another column, or leave Row ID unassigned to use generated row numbers.





