Sum first 12 rows of a dataset

Ignition
1

I’m trying to sum the first 12 rows of a dataset. Currently I have a total of all the rows.

pds=system.dataset.toPyDataSet(data)
total = 0

for row in pds:
total += row[2]

print (total)

How do I only sum the first 12 (assuming there are more than 12)?

2

Might be an even easier route, but could use a while loop instead of a for loop. That will let you specify the number of iterations versus using the full row quantity.

https://www.w3schools.com/python/python_while_loops.asp

3

Yeah, I’m not sure how to apply a count while iterating though the “rows in pds:”

4

total = sum([row[2] for row in pds[:12]])

6 Likes
5

Ahh, I was trying to add the limit to row. Awesome thanks