customer function for ROC

[Tundra.L]

Up

0

Down

here is the coding I did for ROC curve:

threshold=[*range(100,900,100)]
results=pd.DataFrame()
for x in threshold:
    print(x)
    roc=Loan.query('CR_Score>x')
    roc=roc.assign(subject=i)
    roc=roc.groupby('Bad').agg({'Client_ID':'count'})
    results=results.append(roc)
results

the output is

100#this is only number, no 200 etc

.......

UndefinedVariableError: name 'x' is not defined

can you please tell me what’s wrong with my code? thanks

[Datura]

Up

0

Down

I think that, when you use query() function, probably you can only use columns in the Loan data frame. x is an external object, so Python cannot find it.

Try to use other functions to subset data.

[Tundra.L]

Up

0

Down

thank you. I switched to loc() function, now it works. the output is like:

0 8535
1 1954
0 8496
1 1749
.......

• This reply was modified 4 years ago by  Tundra.L.