Find 2nd lowest value in Python

[jamescooper]

This generates the minimum value; how would I go about calculating the 2nd lowest value?

import pandas as pd
ct_mean = pd.crosstab(df['Check-In'], df['Date Captured'],
values=df['Current price'], aggfunc='min')

Many thanks.

 

[Cubist]

This defaults to the 1st min if the 2nd min does not exist.

Book1
	A	B	C	D	E	F	G	H
1	Check-In	Date Captured	Current price		DataFrame	Date Captured	1/1/2024	1/2/2024
2	A	1/1/2024	10			Check-In
3	A	1/1/2024	20			A	20	nan
4	B	1/1/2024	30			B	30	nan
5	C	1/2/2024	5			C	nan	15
6	C	1/2/2024	15
Sheet1

Cell Formulas
Range	Formula
E1	E1	=PY(import pandas as pd df = xl("A1:C6", headers=True) ct_mean = pd.crosstab( df['Check-In'], df['Date Captured'], values=df['Current price'], aggfunc=lambda x: x.nsmallest(2).iloc[-1] if len(x) > 1 else x.min() )
F1:H5	F1	=E1.arrayPreview
Dynamic array formulas.

 

[jamescooper]

Thanks, can't quite get it to work; I push E1 to be an array, but also my data is:

df=xl("Data", headers=True)

 

[Cubist]

Is Data a named range or a table object?

 

[jamescooper]

It is the connection to Power Query.

 

[Cubist]

Can you show what's the error and the formula you've entered?