The interview level was easy to moderate...for Data analyst intern role, basic questions related to python and excel were asked. In python, mainly pandas library was focused on. In Excel, basic functions like SUM, VLOOKUP, pivot tables were asked.
Interview questions [1]
Question 1
A rough dataset was given to me and asked to calculate aggregate % of each entry in another column using python in Google colab. And in Excel, some numerical values were displayed, I had to calculate difference of two values present in adjacent columns and add the final column just near to those columns.
