#c

c

The cell where for statement is placed

#c

The sequence number of the loop

A

B

C

1

=demo.query("select * from EMPLOYEE")

2

=[]

3

for A1

Loop through A1’s table sequence, during which the current record is skipped if DEPT column value is "Sales", otherwise append the loop number of the current record to A2’s sequence as a value

4

if A3.DEPT=="Sales"

5

next

6

>A2=A2|[#A3]