Multiple conditions in Pandas

Question

This is the Table I am working with

I need to access the data points with 'Duration'>70 and 'End Terminal'==10 Hence I tried

kj[kj['Duration']>70] 
kj[kj['End Terminal'] == 10]

above commands are working fine separately but when I club them as:

kj[kj['End Terminal'] == 10] & kj[kj['Duration']>70]

there is an error, hence how to use both conditions in one statement in Pandas-Python

Put separate conditions in brackets kj[ (cond1) & (cond2) ] – Sergey Bushmanov Jul 10 '17 at 11:33 — Sergey Bushmanov, Jul 10 '17 at 11:33

score 6 · Answer 1 · edited Jul 10 '17 at 12:28

6

This should do the trick:

kj[(kj['End Terminal'] == 10) & (kj['Duration']>70)]

edited Jul 10 '17 at 12:28

cs95

answered Jul 10 '17 at 11:32

gold_cy

I removed the typo,and this worked : kj[(kj['End Terminal'] == 10) & (kj['Duration']>70)] – Alen Jul 10 '17 at 11:45

1 Answers1