#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 its loop number to A2’s sequence as a value.

4

if A3.DEPT=="Sales"

5

next

6

>A2=A2|[#A3]