How to compare collapsed measurements across conditions
This guide explains how to aggregate single-cell track data (e.g., computing the time-average of a signal) and compare it across different experimental conditions using Boxplots and Stripplots.
Prerequisites
You have tracked cells and generated measurement tables.
Your experiment has conditions (e.g., different treatments per well) loaded as columns (e.g., derived from
[Labels]inconfig.ini).
Step 1: Open the Table Explorer
Select your experiment or specific position.
Open the Analysis tab.
Click Table Explorer (or access it via the Measurement results).
Step 2: Collapse Tracks
Transform the data from “one row per timepoint” to “one row per track”.
Press
Ctrl+Gor select Table > Collapse tracks… (also the button above the table).In the dialog: * Operation: Select
mean(for time-average),max, or another statistic.Click OK. * Result: The table updates. Rows now represent individual cells (Tracks). New columns like
mean_mean_intensityappear. Columns that are constant per track (likewell_idortreatment) are preserved.
Step 3: Plot by Condition
Press
Ctrl+Ior select Plot > Distributions and statistics… (also the button above the table). The Set 1D plot parameters window opens.Set x to the condition column (categorical, e.g.,
well_name) and y to the measurement column (numerical, e.g.,mean_mean_intensity).(Optional) Use the hue dropdown to subdivide the plot by another category (e.g.,
replicate).
Step 4: Configure the Visualization
Under Representations, click the boxplot card. Click the strip card as well to show the individual data points on top of the boxes. Cards can be combined.
(Optional) Under Statistical Tests, click the cards of the tests to compute between the groups: the KS test p-value and the Cliff’s Delta effect size. Each opens a table of pairwise comparisons (see Table Explorer (Table UI)).
Press set.
Step 5: Export
Click the Save Icon in the plot window to export the figure.
Or press
Ctrl+S(File > Save as…) in the Table Explorer to save the collapsed data table to CSV.