Howw to prevent the duplication of any value in a column within a CSV file (python)

[Joaquin Alzola]

Just an example. Didn't use the csv but just hope that it helps.

name=[]
name_exist="Dop"

with open("dop.csv") as f:
        for line in f:
                line_split=line.split(',')
                name.append(line_strip[0])
        if name_exist in name:
                print "found name " + name_exist + " Can not append"
        else:
                file = open("dop.csv",'a')
                print "No name found"
                file.write(name_exist)
file.close()

-----Original Message-----
From: Python-list [mailto:python-list-bounces+joaquin.alzola=lebara.com at python.org] On Behalf Of Adam Davis
Sent: 26 April 2016 18:05
To: python-list at python.org
Subject: Re: Howw to prevent the duplication of any value in a column within a CSV file (python)

On Tuesday, 26 April 2016 17:01:41 UTC+1, Adam Davis  wrote:
> I am wondering how to make my code function so it does not allow any of the same values to be entered into a column in my CSV file created through python. So I need to read into the CSV file and check if any names have already been entered. If they have, the user must not be allowed to enter this value.
>
> Thanks in advance!

Here's my section of code:

with open(class_code+".csv", 'a') as csvfile:
        fieldnames = ["Name", "Score 1", "Score 2", "Score 3", "Average"]
        writer = csv.DictWriter(csvfile, fieldnames=fieldnames)
        #writer.writeheader()
        writer.writerow({"Name": name, "Score 1": score1, "Score 2": score2, "Score 3": score3})

It prints when requested as:

Adam,1,0,0,0.3333333333333333
Jake,9,10,6,8.333333333333334
Tom,5,3,3,3.6666666666666665

So basically, if anyone called Adam, Jake or Tom tries the quiz again, it will not let them.
Thanks
--
https://mail.python.org/mailman/listinfo/python-list
This email is confidential and may be subject to privilege. If you are not the intended recipient, please do not copy or disclose its content but contact the sender immediately upon receipt.