Find min and max of non-zero values in a column

Question

I try to get the min and max value (as a float) of a column without the zero values.

I tried:

minValue = df[df['col1']>0.1].min()
maxValue = df['col2'].max()

type minValue --> pandas.core.series.Series
type maxValue --> float

"without the non-zero values" means you only want to look at the zeros. Which sounds wrong. — ramslök
– ramslök, Commented Jun 16, 2022 at 7:50
so, what failed? Can you provide a reproducible input/output example? — mozway
– mozway, Commented Jun 16, 2022 at 7:51
did you display/print minValue? I think it would help you see what the operation currently does — ramslök
– ramslök, Commented Jun 16, 2022 at 7:52
I think you missed to select the column where to calculate the min, try : minValue = df[df['col1']>0.1]['col1'].min() — Andrea
– Andrea, Commented Jun 16, 2022 at 7:52

Thomas Hilger · Accepted Answer · 2022-06-16 07:54:25Z

1

I'd suggest:

minValue = df.col1[df.col1!=0].min()
maxValue = df.col1[df.col2!=0].max()

but you need to adapt to the columns you want to look for non-zero values and from which you want the min/max values.

answered Jun 16, 2022 at 7:54

Thomas Hilger

4873 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ynjxsjmh · Accepted Answer · 2022-06-16 09:32:38Z

1

You can try

minValue = df.loc[df['col1']>0.1, 'col1'].min()

answered Jun 16, 2022 at 9:32

Ynjxsjmh

30.3k7 gold badges43 silver badges64 bronze badges