import pandas as pd
import numpy as np
df = pd.DataFrame(np.random.randn(6, 4), columns=list('abcd'))
df
a b c d
0 -0.026429 -1.957159 1.365762 0.799437
1 -0.115957 1.386499 -0.760147 0.579012
2 0.572344 1.551177 1.249986 -1.579039
3 1.976746 0.443745 0.284829 0.198566
4 1.359592 1.155362 0.419426 -0.781024
5 0.532487 -1.206691 -1.895836 -0.604478
df[df.d > 0]
a b c d
0 -0.026429 -1.957159 1.365762 0.799437
1 -0.115957 1.386499 -0.760147 0.579012
3 1.976746 0.443745 0.284829 0.198566
df[(df.d>0)&(df.c<0)]
a b c d
1 -0.115957 1.386499 -0.760147 0.579012
df[['a','b']][(df.d > 0)|(df.c < 0)]
a b
0 -0.026429 -1.957159
1 -0.115957 1.386499
3 1.976746 0.443745
5 0.532487 -1.206691