我有一个CSV文件,我读作每行的字典列表.我想删除列表中具有EmailAddress”的所有条目.我试过了:
#!/usr/bin/python
import csv
def import_users(location_of_file):
with open(location_of_file, 'r', newline='', encoding='utf-8-sig') as openfile:
reader = csv.DictReader(openfile)
for row in reader:
yield row
def save_csv(data, location):
with open(location, 'w', newline='', encoding='utf-8-sig') as file:
fieldnames = ['EmailAddress', 'GivenName', 'Surname', 'Company', 'Department']
writer = csv.DictWriter(file, fieldnames=fieldnames)
writer.writeheader()
for item in data:
writer.writerow(item)
if __name__ == '__main__':
users = list(import_users('C:\Temp\Example.csv'))
for user in users:
if user['EmailAddress'] == '':
del user
else:
pass
save_csv(users, 'C:\Temp\Output.csv')
但我的结果仍然是没有电子邮件地址的条目.我究竟做错了什么?
不要在刺激他们的同时更改列表项目.
代替
for user in users:
if user['EmailAddress'] == '':
del user
else:
pass
做
users = filter(lambda user: user['EmailAddress'] != '', users)