[Python] How to parse xls data including merged cells using python pandas

How to parse xls data to this struct, both row and column have merged cells, simply use df.index.to_series().ffill() cannot handle.

{
"time": "time",
"categry": "A",
"variety": "A1",
"specitication": "S1",
"unit": "U1",
"average": 1.25,
"region": "RegionA",
"market": "MarketA",
"price": "1.1",
}




Continue reading...