ArgMin / List Layer
Find the index of the minimum value in each variable-length numeric list. 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 list. Supports lists of different lengths.
Example transformation:
lists | min_index |
---|---|
[4, 2, 5, 3] | 1 |
[1, 3, 1, 4, 2] | 0 |
[-1, -5, -2] | 1 |
[null, 1] | 1 |
[] | null |
Common applications:
- Detecting troughs in variable-length time series
- Finding lowest latencies in network diagnostics
- Identifying bottlenecks in dynamic processes
- Locating minimum stress points in structural analysis
- Finding optimal entry points in trading data
- Quality control with varying sample sizes
Note: Returns first occurrence for ties. Handles numeric lists of any length. Null values are ignored unless all values are null or list is empty, then returns null. Especially useful for analyzing data with irregular sampling or variable measurement counts.
Select
columnThe variable-length numeric list column to analyze. Common input patterns:
- Error measurements: [0.5, 0.2, 0.8, 0.3]
- Network latencies: [10, 5, 15, 8, 12]
- Resource usage: [100, 50, 75]
- Single readings: [0.1]
- Empty state: [] Lists can have different lengths across rows, ideal for varying observation counts
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.