0

Using solution from post : https://stackoverflow.com/questions/29284929/rejecting-zero-values-when-creating-a-list-of-minimum-values-python-field-calc

My goal is to populate my "least" column with the minimum value of 4 "time" columns and to exclude zeroes when calculating.The "least" column format is double and my "time" column format is long integer.

This code seems to work for others but not for my table, I've spent a whole day on this and can't find the culprit.

Here is my pre-logic script code:

def my_min(time, time_1):
  lst = [time, time_1]
  return min([x for x in lst if x !=0])

Image: field calculator results

Improve this question
5
  • 1
    Please post code samples as text, not screenshots.
    – Dan C
    Commented Apr 23, 2018 at 18:54
  • Why? is the image not clear? are you trying to copy and paste the code?
    – ckohler4692
    Commented Apr 23, 2018 at 18:56
  • 1
    If anyone is inclined to troubleshoot your code, they are much more likely to do so if they can just copy and paste it rather than re-typing it.
    – Dan C
    Commented Apr 23, 2018 at 19:08
  • One of the rows has probably value 0 for four fields. Thus, list comprehension creates an empty list.
    – Kadir Şahbaz
    Commented Apr 23, 2018 at 19:15
  • Thank you all for the help! An addition of code needs to be implemented to handle when my time values in the same row are all 0. Sounds like that is what the min() function is choking on
    – ckohler4692
    Commented Apr 23, 2018 at 19:46

1 Answer 1

Reset to default
1

You're getting the error on cases where all your fields equal 0. The function min() expects at least one value, and it throws an error when min([]). Use an if statement to check if the length of your list > 0, else return 0, or some other value.

Improve this answer
0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.