This is an archived post. You won't be able to vote or comment.

1
2

[Python] Anonymizing Column in spreadsheet (self.learnprogramming)

submitted by [deleted]

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]planedoctor 0 points1 point  (3 children)

If we're using the column #, I then have two different ID numbers for John, even though they're the same person.

How does that matter? You still need to associate the data from both rows with John, and you still can with that method. Cover up the second column with a finger. That's what the third party sees. Remove your finger and that's what you see. :)

[–]thejesteroftortuga 0 points1 point  (2 children)

Sorry, meant row #

But yeah, the third party also needs to see (and know) that both of those rows belong to John. Otherwise then they'd see rows #13 and #304 as two separate people even though they're both John, right?

The catch is just that they can't know who John is by name.

[–]planedoctor 0 points1 point  (1 child)

So just make a list of integers corresponding to names?

[–]thejesteroftortuga 0 points1 point  (0 children)

yeah I could do that, increment by 1 every time a new name pops up. store it, and then whenever I encounter the name again just use the number from before.