Max (Analytic Filter)
Description
The Max filter is used to calculate the maximum value from the data set.
When used on multiple rows, it returns the per-row maximum (ie. it will return the same number of columns and only one row).
When used on a single row, it returns the overall maximum (ie. it will return a single number).
This is the same as using the Pandas 'max' function on a DataFrame.
Parameters
This filter has no parameters.
Example
<filter type="Max"/>
Calculates the max of the data frame
Before
Index | Col 1 | Col 2 |
---|---|---|
07:00:00 | 20 | 40 |
07:01:00 | 40 | 80 |
After
Index | Col 1 | Col 2 |
---|---|---|
07:01:00 | 40 | 80 |