In MultiIndex dataframe:
import pandas as pd a = [['a', 'b', 2, 3], ['c', 'b', 5, 6], ['a','c', 8, 9]] df = pd.DataFrame(a, columns=['I1', 'I2', 'v1', 'v2']) df = df.groupby(['I1', 'I2']).first()
I want to insert a row ex
at top and keep the first level of MultiIndex hidden. The expected result is
I tried concat
:
data_ex = {'v1':[99], 'v2': [98]} df_ex = pd.DataFrame(data_ex, index = [('ex','ex')]) pd.concat([df_ex, df])
However it become
I also tried first concat without index, then groupby multiply index. But pandas will automatically sort by MultiIndex. As a result, ex row cannot be set at top.
Advertisement
Answer
You need pass the correct index format
df_ex = pd.DataFrame(data_ex, index = pd.MultiIndex.from_tuples([('ex','ex')],names=["I1", "I2"])) pd.concat([df_ex, df]) Out[783]: v1 v2 I1 I2 ex ex 99 98 a b 2 3 c 8 9 c b 5 6