BMW Group Interview Question

How to handle data in pandas