write to a pandas dataframe?

[shantanuo]

I was able to use the following line as expected.

conv = Converter()
conv.convert(res["hits"]["hits"], Writer(file="test.xlsx"))

That was nice. But I will prefer to write to a pandas dataframe. Something like this?

conv.convert(res["hits"]["hits"], Writer(df)

I can open excel file using pandas like this...

df = pd.read_excel("test.xlsx", header=list(range(9)), parse_dates=True)

But in this case, I need to find out the number of rows where the header is written. The "conv" object already knows it and can convert into multi-level column header in pandas.