Hey, maybe my experience will be relevant since I'm also not a programmer.
I decided what I wanted to exactly do with python. I started by going through the basics with a free youtube course like
.
I wanted to do simple things like renaming files in mac, scripts to move files based in specific folders based on the file extension, organising data in excel sheets, etc.
This made me understand it better than just going through a youtube video and copy-pasting code. That's not learning. Be prepared to spend 10+ hours on stack overflow for a simple thing though, that's the fun part 🙂
I don't have any 'end goal', I just think of things that can be automated and try to write (and mainly struggle) to write python scripts for it.