python读取合并单元格并拆分合并单元格写出

import pandas as pd

data = pd.read_excel(r'C:/Users/14369/Desktop/博文markdown版/测试数据结果.xls')
data.columns

data.fillna(method='ffill',inplace=True)
data.to_excel(r'C:/Users/14369/Desktop/博文markdown版/测试数据结果2.xls',index=False)