ArgMin / Array Layer
Find the index of the minimum value in each fixed-length numeric array. Similar to NumPy's argmin() or R's which.min(). Returns a column of indices (0-based) pointing to the first occurrence of the minimum value in each array.
Example transformation (arrays of length 3):
| arrays | min_index |
|---|---|
| [4, 2, 5] | 1 |
| [1, 3, 1] | 0 |
| [-1, -5, 0] | 1 |
| [null, 1, 2] | 1 |
Common applications:
- Finding lowest points
- Locating minimum scores
- Identifying bottlenecks
- Time series trough detection
- Minimum value location tracking
Note: Returns first occurrence for ties. Arrays must have the same fixed length across all rows. Handles numeric arrays only. Null values are ignored unless all values are null, then returns null.
Select
columnThe fixed-length numeric array column to analyze. Common input patterns:
- Errors: [0.5, 0.2, 0.8]
- Distances: [10, 5, 15]
- Performance: [100, 50, 75]
- Latencies: [0.1, 0.3, 0.05] All arrays must have the same length
AsColumn
nameName for the new column. If not provided, the system generates a unique name. If AsColumn matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.