列处理——寻找并处理非法值

#input is a list named legislators, the first two elements looks like this:
#[[‘Bassett‘, ‘Richard‘, ‘1745-04-02‘, ‘M‘, ‘sen‘, ‘DE‘, ‘Anti-Administration‘], [‘Bland‘, ‘Theodorick‘, ‘1742-03-21‘, ‘‘, ‘rep‘, ‘VA‘, ‘‘]]
#Bassett Richard is the name
#1745-04-02 is bithdate
#M is gender

genders_list = []
for rows in legislators:
    genders_list.append(rows[3])

# Converting to a set, so we get the unique values
unique_genders = set(genders_list)
# We can‘t index sets, so we need to convert back into a list first.
unique_genders_list = list(unique_genders)
print(unique_genders_list)
# 输出为[‘‘, ‘M‘, ‘F‘]

for row in legislators:
    if row[3]==‘‘:
        row[3]=‘M‘