You have a Pandas script that processes data slowly. Walk through how you would diagnose and optimize its performance.

Sample answer preview

Optimizing Pandas performance requires systematic diagnosis before making changes. Here is the approach I would follow. Start with profiling to identify bottlenecks. Use Python profilers like cProfile or line_profiler to see which functions consume the most time.