Data choosing based on several condition (code improve)

Question

df= df[df.a< 7.8]
df= df[df.a> 7.50]
df= df[df.b> 44.85]

Can this code be written in one line? Or shorter than 3 lines?

It [has already been answered](https://stackoverflow.com/questions/22591174/pandas-multiple-conditions-while-indexing-data-frame-unexpected-behavior) in StackOverflow. — Eduardo Sousa, Sep 04 '19 at 14:07

score 3 · Answer 1 · answered Sep 04 '19 at 14:12

3

I will using query

df.query('a > 7.5 and a < 7.8 and b > 44.85')

answered Sep 04 '19 at 14:12

BENY

317,841
20
164
234

jezrael · Accepted Answer · 2019-09-04T14:13:45.163

1

I believe you need Series.between with chain & for bitwise AND or | for bitwise OR with another condition:

df1 = df[df.a.between(7.5, 7.8, inclusive=False) & (df.b> 44.85)]

Or:

df1 = df[(df.a > 7.5) & (df.a < 7.8) & (df.b> 44.85)]

Sample:

df = pd.DataFrame({
         'a':[7.6,7.5,7.4,7.56,5,7.7],
         'b':[57,48,59,44,42,53],

})

df1 = df[df.a.between(7.5, 7.8, inclusive=False) & (df.b> 44.85)]
print (df1)
     a   b
0  7.6  57
5  7.7  53

edited Sep 04 '19 at 14:13

answered Sep 04 '19 at 14:05

jezrael

822,522
95
1,334
1,252

3

`inclusive=False` is needed. I was slower due to double-checking that. – GZ0 Sep 04 '19 at 14:06

Data choosing based on several condition (code improve)

2 Answers2