pivot — Pivot table data into a wide grouped summary table.
pivot(T, rowvars, colvars, datavar) groups rows by rowvars, expands distinct colvars values into output variables, and summarizes datavar values into the wide result.
Syntax
B = tabularBuiltin(args...)Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
args | Any | Variadic | — | Input values and name-value options. |
Returns
| Name | Type | Description |
|---|---|---|
out | Any | Result value. |
Errors
| Identifier | When | Message |
|---|---|---|
RunMat:table:InvalidArgument | Arguments or table metadata are invalid. | table: invalid argument |
RunMat:table:InvalidIndex | Table indexing is invalid. | table: invalid index |
RunMat:table:InvalidVariable | A table variable name or value is invalid. | table: invalid variable |
RunMat:readtable:IOError | readtable cannot open or read the requested file. | readtable: file read failed |
RunMat:readtable:UnsupportedFileType | readtable receives a file type outside the text or spreadsheet import backends. | readtable: unsupported file type |
How pivot works
- The
"Method"option selects the summary method and defaults to"sum". - Row, column, and data variables use table variable selector semantics.
- Output variable names are made valid and unique after combining column-key labels with data variable names.
Example
Grouped sum
P = pivot(T, 'Group', 'Kind', 'Value')Expected output:
P = wide table with one summary column per Kind valueUsing pivot with coding agents
Open a RunMat example with live inputs, then ask the agent to explain how pivot changes the result.
Run a small pivot example, explain the result, then change one input and compare the output.
Related Table functions
array2table · array2timetable · categorical · cell2table · dictionary · head · iscategorical · isordinal · istable · istimetable · ordinal · rowfilter · struct2table · table2array · table2cell · table2struct · table2timetable · timerange · timetable · timetable2table · uitable · vartype
Open-source implementation
Unlike proprietary runtimes, every RunMat function is open-source. Read exactly how pivot is executed, line by line, in Rust.
- View the source for pivot in Rust on GitHub
- Learn how the RunMat runtime works
- Found a bug? Open an issue with a minimal reproduction.
About RunMat
RunMat is an open-source runtime that executes MATLAB-syntax code blazing on any GPU. It is licensed under the Apache 2.0 license.
- RunMat automatically optimizes your math for GPU execution on Apple, Nvidia, and AMD hardware. No code changes needed. Simulations that took hours now take minutes.
- Start running code in seconds. RunMat runs in the browser, on the desktop, or from the CLI. No license server, no IT ticket.