Advanced or multi-level indexing for working with higher dimensional data is available both for Series and for DataFrames.
import pandas as pd
import numpy as np
data = pd.Series(np.random.randn(10),
index=[['a', 'a', 'a',
'c', 'c', 'c',
'b', 'b', 'b',
'd'],
[1, 2, 3, 1, 2, 3, 1, 2, 2, 3]])
print(data["a"])
print(data[:, 3])
print(data["a" : "c"])
Ordering is different!
The index needs to be sorted:
data = data.sort_index()
print(data["a" : "c"])