过滤
A
1
=demo.query("select NAME as STATE, ABBR, CAPITAL, POPULATION from STATES")
2
=A1.select(left(STATE,1)=="A")
3
=A1.select@1(POPULATION>6000000)
4 [M,N,W]
5
=A1.select(POPULATION>6000000 && A4.pos(left(STATE,1))>0)

A2中运算结果如下:

A3中运算结果如下:

A5中运算结果如下: