The best free (and purchaseable) book out there for novices-to-intermediates is "Automating the Boring Stuff with Python". Not only is it well-written, it captures the main gist of why programming is useful in a variety of life's use cases: https://automatetheboringstuff.com/