BMW Group interview question

How to handle data in pandas