在python中，如何删除特定列为空白的整行？

Question

我试图弄清楚如何使下面的代码排除 row[9] 具有空白条目的任何实例。当前，csv 文件为每一行输出，这会导致行中的“爸爸”条目为空白。我希望输出 csv 文件不包含“爸爸”列（行 [9]）为空的任何行...

任何帮助是极大的赞赏！

def guardiansfather():

with open('hallpass_raw.csv') as csv_file:

    csv_reader = csv.reader(csv_file, delimiter=',')

    with open('outputfiles/guardians_father.csv', mode='w', newline='') as output_file:

        write = csv.writer(output_file, delimiter=',', quoting=csv.QUOTE_MINIMAL)

        for row in csv_reader:

            a = row[0]

            b = row[1]

            c = row[2]

            studentnumber = row[3]

            firstname = row[4]

            middlename = row[5]

            lastname = row[6]

            teacher = row[7]

            idnumber = row[8]

            father = row[9]

            mother = row[10]

            guardianemail = row[11]

            phone = row[12]

            fatheremail = row[13]

            motheremail = row[14]

            guardianphone = row[15]

            schoolname = 'NAME OF SCHOOL'

            relationship = 'Father'

            father_first = father.split(sep=','[0])

            father_last = father.split(sep=', '[1])

            write.writerow([schoolname, studentnumber, father_first, father_last, relationship, phone, fatheremail])

Answer 1

使用if声明def guardiansfather():    with open('hallpass_raw.csv') as csv_file:        csv_reader = csv.reader(csv_file, delimiter=',')        with open('outputfiles/guardians_father.csv', mode='w', newline='') as output_file:            write = csv.writer(output_file, delimiter=',', quoting=csv.QUOTE_MINIMAL)            for row in csv_reader:                a = row[0]                b = row[1]                c = row[2]                studentnumber = row[3]                firstname = row[4]                middlename = row[5]                lastname = row[6]                teacher = row[7]                idnumber = row[8]                father = row[9]                # Skip rows with empty father                if father.strip() == '':                    continue                mother = row[10]                guardianemail = row[11]                phone = row[12]                fatheremail = row[13]                motheremail = row[14]                guardianphone = row[15]                schoolname = 'NAME OF SCHOOL'                relationship = 'Father'                father_first = father.split(sep=','[0])                father_last = father.split(sep=', '[1])                write.writerow([schoolname, studentnumber, father_first, father_last, relationship, phone, fatheremail])