SciPy Recipes

How to do it...

Run the following code, which demonstrates different ways to select data from a DataFrame:

col = df['item']cols = df[['item', 'inventory']]rows = df[2:4]row_data = df.loc[201024]df1 = df.loc[201024:,['item','unit_price']]

The data selected in each of the commands is displayed as follows:

col:

100024          Pen
201024       Eraser
202034    Sharpener
101122       Pencil

cols:

             item  inventory
100024        Pen         24
201024     Eraser         32
202034  Sharpener         12
101122     Pencil         42

rows:

             item  inventory  unit_price
202034  Sharpener         12       10.39
101122     Pencil         42        0.59

row_data:

item          Eraser
inventory         32
unit_price      1.29
Name: 201024, dtype: object

df1:

             item  unit_price
201024     Eraser        1.29
202034  Sharpener       10.39
101122     Pencil        0.59