duckdb: ( df1.assign(col1=df1.agg(list,1)).sql .select("*,col1.list_sort('desc').list_position(Bob)-1 col2") )