如果所选列中的值大于列"Col 7"中的值,如何将每个项的第二小值添加到DF中,仅从字典对应的列中并在计算第二小值时具有条件?
import pandas as pd
my_dict={'Item1':['Col1','Col3','Col6'],
'Item2':['Col2','Col4','Col6','Col8'],
'Item3':['Col1','Col3','Col6']
}
df=pd.DataFrame({
'Col0':['Item1','Item2','Item3'],
'Col1':[20,25,28],
'Col2':[89,15,35],
'Col3':[36,30,96],
'Col4':[40,108,13],
'Col5':[55,2,9],
'Col6':[35,38,27],
'Col7':[30,20,39],
})
结果应该是:
df=pd.DataFrame({
'Col0':['Item1','Item2','Item3'],
'Col1':[20,25,28],
'Col2':[89,15,35],
'Col3':[36,30,96],
'Col4':[40,108,13],
'Col5':[55,2,9],
'Col6':[35,38,27],
'Col7':[30,20,39],
'second min':[36,108,'NaN']
})