Table utilities / Group and summarise
Your data stays in your browser: files are read and processed on your device, never uploaded to any server, and cleared when you close the page. Free, no sign-in.
Choose one or two grouping columns and tick the statistics you need; each chosen numeric column gets a “column_statistic” output column. If group column 1 is left blank, the first non-numeric column is used.
Mean, median, standard deviation (sample SD, divided by n−1) and the rest use only values that can be read as numbers; NA and blanks are skipped, and “non-missing count” shows how many values each group actually contributed.
You may also pick a text column to report the number of distinct values per group, or to join the distinct values in order of appearance (for example, which clusters make up each cell type).
Groups can be ordered by name or by size; the bar chart shows rows per group or the mean of a chosen column.
Group-wise aggregation (split–apply–combine); missing values are skipped, SD uses n−1 degrees of freedom and the median averages the two middle values, matching default data-frame groupby semantics.
Up to 500,000 rows.
Send us your data and research question and you will receive a written plan within 1 working day: analysis steps, parameter rationale, deliverables and timeline. Quoted per project.