A Python Coding Interview Question From Amazon

This video will closely examine a difficult data science interview question from Amazon and walk you through a solution in Python. It turns out that after finding just a few simple, yet clever steps, this question becomes easier to solve. If you want to improve your data science skills and are preparing for an interview, this video is for you! By the end of this video, you'll better understand how to solve this type of question and be more prepared for your next data science interview!

______________________________________________________________________

______________________________________________________________________

Timeline:

Intro: (0:00​​​)
Interview Question: (0:22​​)
Framework to solve the problem: (0:57​​​)
Understand your data: (1:18​​​)
Formulate your approach: (3:35​​​)
Code Execution: (5:30​​​)
Edge Cases: (9:40​​​)
Conclusion: (11:32​​)
______________________________________________________________________

About The Platform:

______________________________________________________________________

Contact:

If you have any questions, comments, or feedback, please leave them here!
______________________________________________________________________

#PythonInterviewQuestions

[majubodas]

This example helped me a lot to better understand python pandas and hopefully to get better translating SQL to Python. Many, many thanks!

[jianhongsong]

From step 4 to step 5 when you try to put Q3 sales and Q4 sales side by side, a neater way is to run an “unstack” operation on the inner index, to avoid a reset index operation and merge operation.

[johnalvinm]

"Can only use .dt accessor with datetimelike values" when trying to execute : df = fct_customer_sales[fct_customer_sales.order_date.dt.quarter.isin([3, 4])] Why doesnt it work for me?