import numpy as np
import pandas as pd
cols = pd.MultiIndex.from_tuples([(x,y) for x in ['A','B','C','D'] for y in ['O','I']])
df_test_2 = pd.DataFrame(np.random.randn(2,8), index=['n','m'], columns=cols);
df_test_2 = df_test_2.div(df_test_2['C'], level=1);
coords = [('AA','one'),('AA','six'),('BB','one'),('BB','two'),('BB','six')]
index = pd.MultiIndex.from_tuples(coords)
df_test = pd.DataFrame([11,22,33,44,55], index = index, names=['MyData']);df_test