Pandas logical operator & does not work but 'and' works

Question

I am having problem with logical operators in pandas. If I try :

list1=['x','y']
if st1=='A' & str2 not in list1: #do stuff

I get:

unsupported operand type(s) for &: 'str' and 'bool'", u'occurred at index 0

But this works: Why?

if st1=='A' and str2 not in list1: #do stuff

All I did was change & to and.

You probably want `st1 == 'A' not the `=` – ALollz Nov 27 '18 at 15:29 — ALollz, Nov 27 '18 at 15:29
Sorry that is what i did...error still persists. – Victor Nov 27 '18 at 15:40 — Victor, Nov 27 '18 at 15:40

Toby Petty · Answer 1 · 2018-11-27T15:59:44.530

3

& and and are not the same thing in Python - & is a bitwise operator, and is a logical operator. See previous answers here and here, and Wikipedia page on bitwise operations.

In pandas you can use & for logical operations when selecting subsets of DataFrames, e.g.:

df = pd.DataFrame(data={"col1":[1,2,3], "col2":[2,3,4]})
df[(df["col1"]>1) & (df["col2"]<4)] # Selects second row based on boolean criteria

edited Nov 27 '18 at 15:59

answered Nov 27 '18 at 15:50

Toby Petty

4,431
1
17
29

Pandas logical operator & does not work but 'and' works

1 Answers1