You should check out the Modern Pandas series by Tom Augspurger, it’s well worth reading to get clean modern style code.

https://tomaugspurger.net/posts/modern-1-intro/

also I would recommend looking at videos from matt harrison for polars or pandas, e.g.:

https://www.youtube.com/watch?v=Z9ekw2Ou3s0

Thanks. There's a special place in my heart for any blog that opens with 'Prior Work' :)

I second this blog post. I worked with Tom on a project several years ago and he's brilliant. Started doing python more frequently after that project and I found his blog to be very helpful in finding a good way to conceptualize pandas and python data structures in general.