This is a quick post about the standard library ‘csv’ in python. Absolute bare minimum usage to parse some CSV.
I’ve been using this or my own version of csv to process email lists, inventory histories, etc. Any time a spreadsheet is used, you can easily save it as a csv and load it up in python.
I do a lot of number crunching / processing that’s just too complicated to do easily in a spreadsheet, but data often comes in spreadsheets.
Example of usage in the python shell:
import csv f = open('path/to/my/file', 'r') # open the file reader = csv.reader(f) reader.next() # prints the next ROW, as a list. for row in reader: name = row email = row if email_validation(email): # do some logic to check against an ignore list, or what have you. save_email_or_smth(email, name) f.close() # close the file.