pymysql: formating ouput of query

[buran]

hmm...not sure what that means?

lresult will be a set object, constructed using set comprehension.

instead of using reader object to read from the csv file - better use DictReader (no need to exclude the header row, it's used as fieldnames) - and then read respective column (in my example id, but in your file the header may be different).

you can even iterate over the cursor

lresult = {item[0] for item in c2} # already set object