I'm trying to iterate through a spreadsheet and make a set of all the columns in there while adding the values to their respective set.
storage = [ set() ]*35 #there's 35 columns in the excel sheet
for line in in_file: #iterate through all the lines in the file
t = line.split('\t') #split the line by all the tabs
for i in range(0, len(t)): #iterate through all the tabs of the line
if t[i]: #if the entry isn't empty
storage[i].add(t[i]) #add the ith entry of the to the ith set
if i do this for storage[0].add(t[0])
it works kind of but it adds to ALL the sets in the storage list...why is it doing that? I'm specifying which set I want to add it in. I didn't post what the print out looks like for the sets b/c it's so big but basically every set is the same and has all the entries from the tabs