Excel & Stock

Hello CheckiO users! 🙂

More and more coding puzzles are coming in Polygon Station, but we share two more today.

Challenge yourself with our missions

Excel Column Number - Given a string that represents the column title as appears in an Excel sheet, return its corresponding column number.

assert column_number("A") == 1
assert column_number("Z") == 26
assert column_number("AB") == 28
assert column_number("ZY") == 701

Stock Profit - You are a broker with a single chance to buy stock and sell stock. Having an array of prices, pick the best time to buy stock and sell stock to maximize the profit.

assert stock_profit([2, 3, 4, 5]) == 3
assert stock_profit([3, 1, 3, 4, 5, 1]) == 4
assert stock_profit([4, 3, 2, 1]) == 0
assert stock_profit([6, 2, 1, 2, 3, 2, 3, 4, 5, 4]) == 4
assert stock_profit([1, 1, 1, 2, 1, 1, 1]) == 1
assert stock_profit([4, 3, 2, 1, 2, 1, 2, 1]) == 1
assert stock_profit([1, 1, 1, 1]) == 0

💡 3 Highlights from the Python world:

How to create a computer virus in Python - Is it technically possible to write a virus using Python

An oral history of Bank Python - Bank Python implementations are effectively proprietary forks of the entire Python ecosystem which are in use at many (but not all) of the biggest investment banks.

A Complete 26 Week Course to Learn Python for Data Science in 2022 - I divided this curriculum into 4 main sections. I believe the best way to learn something is by doing, so besides leaving links to video tutorials and guides, I included exercises and projects in each section to help you master Python for data science.

Our congratulations to the winner of November 2021 - amvasiliev80 - you are totally Awesome and we are very glad to have you here with us! 👏🏼

The users who’ve made the TOP 3 this month are Alex_4444D, HiKaGe, and Izabela.You are doing great, guys! Keep on coding! 👏🏼