Takes a CSV through STDIN and outputs a corresponding Entity-Attribute-Value (EAV) CSV on STDOUT

unpivot.py

#!/usr/bin/python

import sys, csv

def main():
	csvIn = csv.reader(sys.stdin, delimiter=',', quotechar='"')
	csvOut = csv.writer(sys.stdout)
	
	for rowNum, row in enumerate(csvIn):
		if rowNum == 0:
			headers = row
		else:
			for columnNum, cell in enumerate(row):
				if columnNum == 0:
					entity = cell
				elif cell:
					csvOut.writerow([entity, headers[columnNum], cell])

if __name__ == "__main__":
	main()