Skip to content
ML Academy

SQL and Python

Interview question

  • seniorlevel
  • 12 minsuggested time
  • 2ML engineer, Data scientist

A nightly pandas feature job that used to take 20 minutes now takes 3 hours and occasionally runs out of memory. How do you diagnose and fix it?

Tests: Performance debugging of data code: measuring before optimising, recognising common pandas anti-patterns, memory-aware dtypes and storage formats, and knowing when to move computation elsewhere.

Sign in to practise: answers are saved before model answers are shown.