OK, new to coding and python. I figure if I have a real live application I will learn quicker. So here is the problem I'm trying to solve. Let me know if you think I am on the right track.
I have an excel spreadsheet with two columns: Division and Email address. There are three possible values for Division: Electrical, Automotive, or Fuses. I want to find all duplicate email addresses. EXCEPT that if one of the dupes is in the Electrical division AND the other is in the Fuses division, that's OK, not classified as a dupe.
So not knowing the terminology yet, here's what I think my approach will be:
sort the excel file by email address first
compare email address x+1 to x
if it matches (dupe), then compare Division(x+1) to Division(x)
if the Divisions match, it is a dupe and send email address to Dupe file
Increment x and loop back
I think my logic is correct, I guess my question is this logic and process suitable for a python program or am I barking up the wrong tree?
I have an excel spreadsheet with two columns: Division and Email address. There are three possible values for Division: Electrical, Automotive, or Fuses. I want to find all duplicate email addresses. EXCEPT that if one of the dupes is in the Electrical division AND the other is in the Fuses division, that's OK, not classified as a dupe.
So not knowing the terminology yet, here's what I think my approach will be:
sort the excel file by email address first
compare email address x+1 to x
if it matches (dupe), then compare Division(x+1) to Division(x)
if the Divisions match, it is a dupe and send email address to Dupe file
Increment x and loop back
I think my logic is correct, I guess my question is this logic and process suitable for a python program or am I barking up the wrong tree?