I am trying to figure out how to make the code below exclude any instances where row[9] has a blank entry. Currently the csv file outputs for every Row, which results in rows with a blank entry for "Dad". I want the output csv file to not include any row where the "Dad" column (row[9]) is blank...
Any help is greatly appreciated!
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])
Use an
if
statement