First time posting and I have searched for this issue but didn't find where it was previously addressed. I have added a field call "Loans" and it contains hundreds or thousands of numbers including zeros and decimals.
I also have a new field called LoanScore
Compute the mean of Loans and if the item on that row is above the mean assign a "1" to that row in LoanScore.
I am running ArcGIS 10.3.1 and Python 10.3.1 on 64 bit Windows.
Previously, I was able to run this in excel using the statement =if(median(a$2:a$1000)<a2,1,0) and then just filled the whole LoanScore column with that formula [where a2 was the first number in the "Loans" column]
Thank you for any assistance.