Slice Pandas DataFrame by Row Slice Pandas DataFrame by Row pandas pandas

Slice Pandas DataFrame by Row


In [36]: dfOut[36]:   A  B  C  Da  0  2  6  0b  6  1  5  2c  0  2  6  0d  9  3  2  2In [37]: rowsOut[37]: ['a', 'c']In [38]: df.drop(rows)Out[38]:   A  B  C  Db  6  1  5  2d  9  3  2  2In [39]: df[~((df.A == 0) & (df.B == 2) & (df.C == 6) & (df.D == 0))]Out[39]:   A  B  C  Db  6  1  5  2d  9  3  2  2In [40]: df.ix[rows]Out[40]:   A  B  C  Da  0  2  6  0c  0  2  6  0In [41]: df[((df.A == 0) & (df.B == 2) & (df.C == 6) & (df.D == 0))]Out[41]:   A  B  C  Da  0  2  6  0c  0  2  6  0


If you already know the index you can use .loc:

In [12]: df = pd.DataFrame({"a": [1,2,3,4,5], "b": [4,5,6,7,8]})In [13]: dfOut[13]:   a  b0  1  41  2  52  3  63  4  74  5  8In [14]: df.loc[[0,2,4]]Out[14]:   a  b0  1  42  3  64  5  8In [15]: df.loc[1:3]Out[15]:   a  b1  2  52  3  63  4  7