ColumnMin
Gets the minimum value of one or more columns. Furthermore, can get the minimum while being grouped by another column or category, perform a rolling minimum or sliding window minimum, can get the minimum for only rows that meet a condition, and can add the result to the dataframe as a new column
Options
columns: Specifies columns to calculate minimum values
where: Specifies a condition for the calculation
group: Groups the data before performing the operation
rolling: Specifies the rolling window overwhich to perform the calculation
addToDataframe: Indicates whether to add the result to the dataframe
Examples
Example 1 - Get Minimum of a Single Column
When exploring a dataset, it is often useful to determine the smallest value in a specific column. In this case, we calculate the minimum value of WindGustSpeed to see the lowest recorded wind gust in the dataset.
#> ColumnMin WindGustSpeed --print
AFLEFT
weatherDfMin = weatherDf['WindGustSpeed'].min()
print(weatherDfMin) #)2 AFRIGHTExample 2 - Get Minimum of Multiple Columns
Instead of inspecting a single column, we can compute the minimum values for several columns at once. This example retrieves the smallest values for Humidity3pm, Humidity9am, and Temp3pm, giving a quick snapshot of their respective ranges.
#> ColumnMin Humidity3pm Humidity9am Temp3pm --print
AFLEFT
weatherDfMin = weatherDf [ [Humidity3pm, Humidity9am, 'Temp3pm'] ].min()
print(weatherDfMin) #)4 AFRIGHT