#This program works with a dictionary of stock information

import csv

#read the source data
#sourcedata = csv.reader(open('Testdata.csv', 'rb'))

with open('Testdataout.csv', mode='w') as csvfile:
#writer = csv.writer(file, delimiter=',', quotechar='"', quoting=csv.QUOTE_MINIMAL)

	with open('Testdata.csv', newline='') as csvfile2:
		reader = csv.DictReader(csvfile2)
		fieldnames = ['Name', 'SIS Login ID', 'Exercise 1', 'Exercise 2', 'Exercise 3', 'Exercise 4', 'Exercise 5', 'Quiz 1']
		writer = csv.DictWriter(csvfile, fieldnames=fieldnames)
		for row in reader:
			writer.writerow({'Name': row['Name'], 'SIS Login ID': row['SIS Login ID'], 'Exercise 1': row['Exercise 1'], 'Exercise 2': row['Exercise 2'], 'Exercise 3': row['Exercise 3'], 'Exercise 4': row['Exercise 4'], 'Exercise 5': row['Exercise 5'], 'Quiz 1': row['Quiz 1']})
			print(row['Name'], row['SIS Login ID'])

print('Done.')