Analytics Case

You have sales data indexed by month. How would you calculate the cumulative sales for each month using pandas? And how would you do the same using SQL? What are the advantages and disadvantages of each approach?

Data Scientist

Apple

Deloitte

Did you come across this question in an interview?

Loading step...
  • You have sales data indexed by month. How would you calculate the cumulative sales for each month using pandas? And how would you do the same using SQL? What are the advantages and disadvantages of each approach?
Try Our AI Interviewer

Prepare for success with realistic, role-specific interview simulations.

Try AI Interview Now

Interview question asked to Data Scientists interviewing at Apple and Deloitte: You have sales data indexed by month. How would you calculate the cumulative sales for each month using pandas? And how would you do the same using SQL? What are the advantages and disadvantages of each approach?.