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)
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)