代ç ï¼
#coding=utf-8import pandas as pd #导å
¥pandas模åinputfile = 'C:/Users/DELL/Desktop/heart.xls'outputfile = 'C:/Users/DELL/Desktop/hearted.xls'#å建æºæ件åç®æ æ件路å¾def FillNa(input,output):data = pd.read_excel(input, header=None, as_index=False) #读åexcelæ件data0 = data.iloc[1:-1] #è¿è¡æ°æ®å¤çï¼åªä½å¯ä¾æä½æ°æ®data1 = data.fillna(data0.mean()) #填补空缺å¼data1.to_excel(output, header=None, index=False) #导åºç®æ æ件FillNa(inputfile,outputfile)
温馨提示:答案为网友推荐,仅供参考