This is driving me nuts.
I have tried many different things, but I just do not understand this csv
library.
I have tried passing various parameters to the writerow method and I am really
getting nowhere fast.
I just want to read from a file, join text to column and write to file.
The writerow section I really do not understand, I copied an example as it
seems to make zero sense when looking at examples or reading documentation.
I thought the csv library would simplify the task but it seems to complicate
it. I do not remember having this problem with sed/awk or perl.
#so far this should read a file
#using dictreader and take a column and join some text onto it
import csv
csvfile= open('StudentListToSort.csv', newline='')
spamreader = csv.DictReader(csvfile,delimiter=',',quotechar='|')
#open a file to write to later
fields = ['user','first','last','password','year']
csvoutput = open('output.csv', 'wb+')
spamwriter = csv.DictWriter(csvoutput,fieldnames=fields, delimiter=' ')
for row in spamreader:
if row['year'] == '40':
username = row['user']
email = "".join([username,'@email.com])
output = row['user'],
row['first'],row['last'],row['password'],row['year']
spamwriter.writerow([spamreader[fields] for fieldnames in fields])
print(output)
_______________________________________________
Tutor maillist - [email protected]
To unsubscribe or change subscription options:
https://mail.python.org/mailman/listinfo/tutor
