Enable Javascript in your browser and then refresh this page, for a much enhanced experience.
First solution in Clear category for Excel Column Number by PythonLearner
ALPHABET = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"
NUMERICAL_VALUES = {letter: i+1 for i, letter in enumerate(ALPHABET)}
BASE = len(ALPHABET)
def column_number(name: str) -> int:
return sum(NUMERICAL_VALUES[letter]*BASE**(len(name)-i-1) for i, letter in enumerate(name))
print("Example:")
print(column_number("AA"))
assert column_number("A") == 1
assert column_number("Z") == 26
assert column_number("AB") == 28
assert column_number("ZY") == 701
print("The first mission is done! Click 'Check' to earn cool rewards!")
Nov. 18, 2021
Comments:
