How do I handle exceptions in Python?

Exception handling in Python seems like a crucial concept, but I'm not entirely sure how to implement it effectively in my code. Could someone provide me with a comprehensive overview of exception handling in Python, including best practices and common pitfalls to avoid? Additionally, are there any advanced techniques or patterns for handling exceptions in more complex scenarios?