Curious about the function of ~in the following code

Question

pd_selftest = pd_selftest[pd_selftest['SICCD'] != 0]

pd_selftest = pd_selftest[~pd_selftest['SICCD'].isnull()]

I'd like to know what the function of the ~ is in the above code.

`~[True,False,True]` == `[False,True,False]` – Rishabh Kumar Mar 19 '21 at 03:18 — Rishabh Kumar, Mar 19 '21 at 03:18

score 1 · Answer 1 · answered Mar 19 '21 at 03:17

1

That's the bit-wise invert or not operator. So, it returns only those lines where the SICCID column is not null. I would probably use the word not in this case.

answered Mar 19 '21 at 03:17

Tim Roberts

34,376
3
17
24

1

`not` doesn't work for vectors of results, where `~` does; `not` probably wouldn't work in the OP's case. – ShadowRanger Mar 19 '21 at 03:18

Curious about the function of ~in the following code

1 Answers1