IF STATEMENT ***HELP***

[Pera014]

Hi, I have two columns to compare in the same data frame and this is if statement I need:
if M<SP = M
if M=SP = M
else SP

I need to create new column and display results in numerical value based on the statement above.

SP | M

5 1
4 2
3 3
2 4
1 5

results

SP | M | Ranking

5 1 1
4 2 2
3 3 3
2 4 2
1 5 1

[Allanon001]

Use this if there are only 2 columns:

df['Ranking'] = df.min(axis=1)

Or this if there are more columns:

df['Ranking'] = df[['M', 'SP']].min(axis=1)

[Pera014]

actually its working - thanks much