Selecting items using mixed indexing

In the next section, we will see how to select items using mixed indexing.

Getting ready

Run the following code to load NumPy, and pandas, and to initialize a DataFrame object:

import numpy as np
import pandas as pd
df1 = pd.DataFrame([['Pen', 24, 2.39],
                    ['Eraser', 32, 1.29],
                    ['Sharpener', 12, 10.39],
                    ['Pencil', 42, 0.59 ]],
                   index=[100024, 201024, 202034, 101122],
                   columns = ['item', 'inventory', 'unit_price'])

How to do it...

...