convert_whole_foods_prices_75.py

#!/usr/bin/env python

import csv
import hashlib
import re
import sys

def slugify(s):
	s = s.lower()
	for c in [' ', '-', '.', '/']:
		s = s.replace(c, '_')
	s = re.sub('\W', '', s)
	s = s.replace('_', ' ')
	s = re.sub('\s+', ' ', s)
	s = s.strip()
	s = s.replace(' ', '-')
	return s

writer = csv.writer(sys.stdout)

chain = sys.argv[2]

with open(sys.argv[1], 'rb') as csvfile:
	reader = csv.reader(csvfile)

	for row in reader:
		if row[0] == 'zipcode':
			continue

		product_id = hashlib.md5('Whole Foods Market##' + row[5]).hexdigest()
		catalogue_id = slugify(chain) + '/1'
		adjust_by = int(hashlib.md5(chain + '##' + product_id).hexdigest()[:2], 16) / 25
		price = float(row[6][1:])

		price = '$%.2f' % (price + price / 100 * adjust_by)

		if hashlib.md5(chain + '##' + product_id).hexdigest() < 'b':
			writer.writerow([chain, catalogue_id, slugify(row[3])+'/'+slugify(row[4]), product_id, price])