Reading writing CSV

i'll let the code speak

	import csv
	some_dict = {}
	filename = "Export_192013_2.csv"
	def cherrypick(row):
	return {"entry": row[15], "date": row[1], "time": row[2], "plasma": row[3] }
	def rewrite_time(row):
	return row['date'].replace("/","-") + "-" + row['time']
	def reassembled(key):
	row = some_dict[key]
	time_stamp = rewrite_time(row)
	return [key, time_stamp, row['plasma']]
	with open(filename, 'r', newline='') as csvfile:
	ofile = csv.reader(csvfile, delimiter=',')
	# ofile.__next__() # for skipping lines before reading
	for row in ofile:
	some_dict[row[15]] = cherrypick(row)
	csv_params = { "delimiter": ',',
	"quotechar":'"',
	"quoting": csv.QUOTE_ALL,
	"lineterminator": "\n"}
	with open('cleaneds4.csv', 'w', newline='') as csvfile:
	o_writer = csv.writer(csvfile, **csv_params)
	o_writer.writerow(["id", "date_time", "plasma"])
	for key in sorted(some_dict.keys(), key=int):
	o_writer.writerow(reassembled(key))

view raw csv rewrite2.py hosted with ❤ by GitHub