How is Python used for the backend in software development and web development