Which Macbook to get for my use case?

So I’m not in tech, not even close. I work in finance but I do enjoy coding and have been really learning python. Have used it to automate one of the process at work as well.

I don’t really need a macbook as I do have a work laptop which I use to practice python even though it’s painfully slow. If i was to get one to build projects in the future related to data analysis/engineering or general automation, which one should I get? Hoping to use it for next 5 years at least.