On Sun, Jan 28, 2018 at 8:36 AM, Geoff Hancock <hancoc...@gmail.com> wrote: > Good day- > I'm in a difficult situation. > I have been asked to help teach students how to clean up a CSV file in > Python. > The job has fallen to me because the teacher of the course is out on > emergency leave and I just found out. > Tomorrow I have to show students how to get a CSV file and write code to > clean and parse it. > > I understand the process--BUT I don't know how to do it! > What I'm looking for is a simple > Step 1 > Step 2 > Step 3 etc > I'm running the latest version of Python and am running on Windows > Can anyone assist? > > Much appreciate the time > JGH
Geoff, I'm not that great a coder but here's where I would start. Assume a file name "gang_draft.csv" that is colon delimited since I'm working on stuff for an RPG session. :) #### file = open('gang_draft.csv', 'r') for line in file: line = line.strip() line_array = line.split(':') print(line_array[1]) #### Where I have print you can do whatever cleanup you like. Then either print specific columns or join them back into a string. Hope that helps start you in the right direction. Others here will likely come up with better solutions. Leam _______________________________________________ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: https://mail.python.org/mailman/listinfo/tutor