python提取多个文件的存在null速度廓线

import numpy as np
import pandas as pd
import os


headDir=r"C:\Users\yezhaoliang\PythonAIWind\pandasHuaiLaiProfile"
def get_files(path=headDir, rule=".csv"):
    all = []
    for fpathe,dirs,fs in os.walk(path):   # os.walk是获取所有的目录
        for f in fs:
            filename = os.path.join(fpathe,f)
            if filename.endswith(rule):  # 判断是否是"xxx"结尾
                all.append(filename)
    return all

if __name__ == "__main__":
    b = get_files()
    writer=pd.ExcelWriter("Results.xlsx")
    altitudesName=[]
    for i in b:
        them=i.split("\\")
        sheetName=them[them.__len__()-4]+them[them.__len__()-3]+them[them.__len__()-1]
        altitudesName.append(sheetName)
        sd=pd.read_csv(i,skiprows=5)
        ## 去除Null行（注意空格，数字也一样处理)
        sdNotNull = sd[sd.iloc[:, 3] != ' null']
        startZ = sdNotNull.iat[0, 2]  ## the third column at begin sequence you selected
        squeezeZseries = sdNotNull.iloc[0:300, 2] - sdNotNull.iat[0, 2]  ## 减去海拔值
        temp1 = sdNotNull.iloc[0:300, 3]
        temp2 = temp1.astype('str').str.strip()  ##转换成字符串 然后去除左右空格
        squeezeVelocityseries = temp2.astype('float64');
        result = pd.concat([squeezeVelocityseries, squeezeZseries], axis=1)
        result.to_excel(writer,sheet_name=sheetName,index_label=startZ)
    writer.save()
    writer.close()
     #tags=os.path.split(i)
     #print(os.path.join(tags[0],'done',tags[1]))

if __name__ == "__main__":
    b = get_files()
    writer=pd.ExcelWriter("Results-compare-600.xlsx")
    altitudesName=[]
    for i in b:
        them=i.split("\\")
        secondPart=them[them.__len__()-2]
        # sheetName=them[them.__len__()-3]+them[them.__len__()-2]+them[them.__len__()-1]
        sheetName=them[them.__len__()-3]+secondPart[-9:]+them[them.__len__()-1]
        altitudesName.append(sheetName)
        sd=pd.read_csv(i,skiprows=5)
        ## 去除Null行（注意空格，数字也一样处理)
        sdNotNull = sd[sd.iloc[:, 3] != ' null']
        #squeezeZseries = sdNotNull.iloc[0:300, 2] - sdNotNull.iat[0, 2]  ## 减去海拔值
        temp1 = sdNotNull.iloc[0:1000, 3]
        temp2 = temp1.astype('str').str.strip()  ##转换成字符串 然后去除左右空格
        squeezeVelocityseriesPre = temp2.astype('float64');
        squeezeVelocityseriesPreNumpy = squeezeVelocityseriesPre.to_numpy();
        temp3 = sdNotNull.iloc[0:1000,2]
        temp4 = temp3.astype('str').str.strip()
        squeezeZseriesPre = temp4.astype('float64');
        squeezeZseriesPreNumpy = squeezeZseriesPre.to_numpy();
        initialArray=squeezeVelocityseriesPre[squeezeVelocityseriesPre<=0.0].size
        initialZ=squeezeZseriesPreNumpy[initialArray]
        squeezeVelocityseriese = squeezeVelocityseriesPreNumpy[initialArray:initialArray+501]
        squeezeZOriginial = squeezeZseriesPreNumpy[initialArray:initialArray+501]
        squeezeZSeries = squeezeZseriesPreNumpy[initialArray:initialArray+501]-initialZ

        result = pd.DataFrame({
            'Velocity/(m/s)':pd.Series(squeezeVelocityseriese),
            'Z-Z0/(m)':pd.Series(squeezeZSeries),
            'Z/(m)':pd.Series(squeezeZOriginial)})
        result.to_excel(writer,sheet_name=sheetName)
    writer.save()
    writer.close()