Skip to content

Instantly share code, notes, and snippets.

@RoySegall

RoySegall/duplicates.py

Created October 5, 2019 08:44
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save RoySegall/aabdfffb62626d45c83f292ad81bebe3 to your computer and use it in GitHub Desktop.
Save RoySegall/aabdfffb62626d45c83f292ad81bebe3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
duplicates.py
for sheet_name in mapping:
sheet_keys = {}
for sheet_key in mapping[sheet_name]:
translated = mapping[sheet_name][sheet_key]
if translated in sheet_keys:
print(f"{translated} exists in column {sheet_keys[translated]} and {sheet_key} under sheet {sheet_name}")
sheet_keys[translated] = sheet_key
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment