Need syntax sugar for dataframe row selection

[halleygithub]

Current dataframe row selection by columns is wordy , 'rowsl()' method is need to make it looks simple.

def _rowsl(df, selection_str):
#syntax sugar to simplify column selection:

df.rowsl('col_1>0.5 & col_2<40') act as

df[(df['col_1']>0.5) & (df['col_2']<40)]

#not_implement_yet
#rst = parsing_and_ filtering
return rst

DataFrame.rowsl = _rowsl

[changhiskhan]

Note you can simplify the syntax by using attribute column access: df[(df.col_1 > 0.5) & (df.col_2 < 40)]

[halleygithub]

accept, but df['col_1 > 0.5 & col_2 < 40'] might looks simple

[dsm054]

I think the currently-pending query syntax addresses this issue:

>>> df = pd.DataFrame({"col_1": [0.1, 0.2, 0.7, 0.8], "col_2": [10, 50, 20, 60]})
>>> df
   col_1  col_2
0    0.1     10
1    0.2     50
2    0.7     20
3    0.8     60

[4 rows x 2 columns]
>>> df.query("col_1 > 0.5 & col_2 < 40")
   col_1  col_2
2    0.7     20

[1 rows x 2 columns]

[jreback]

closed by #4164