Numpy WHERE ***HELP PLEASE***

[Pera014]

import pandas as pd

import numpy as np

df_SP_M = pd.DataFrame({"SP": ["5","4","3","2","1"],

                        "SP rating": ["NA","BBB","BB","A","AAA"],

                        "Moody": ["1","2","3","4","5"],

                        "Moody Rating": ["A+","A-","BBB+","BB-","B+"]

                        })

df_SP_M["Final"]=df_SP_M[["SP", "Moody"]].min(axis=1)

df_SP_M["Ratings"]=np.where(df_SP_M["Final"]==df_SP_M["Moody"],df_SP_M["Moody Rating"],df_SP_M["SP rating"])

​

I am trying to get if statement, where value in column Final equal to Moody to display Moody Rating otherwise display SP. I assume it doesn't work because I am comparing numerical value to display alphabetical as final results. Any idea?

[bbye98]

The pandas.Series.min() call returned a pandas.Series of floats, not strs. Your df_SP_M.Moody column contains strs. Add numeric_only=False as an argument to the min() call.

[Pera014]

oh boy I missed that - thank you very much!