Скачать или смотреть Amazon Interview Question- Best Selling Item

Link of the question: https://platform.stratascratch.com/co...

Amazon Interview Question- Best Selling Item

Find the best-selling item for each month (no need to separate months by year). The best-selling item is determined by the highest total sales amount, calculated as: total_paid = unitprice * quantity. Output the month, description of the item, and the total amount paid.

DataFrame
online_retail

Solved using Python Programming Language

Code:

import pandas as pd

df= online_retail
df['Month']=df['invoicedate'].dt.month
df['total_paid_amt']=df['unitprice']*df['quantity']
df=df.groupby(['Month','description'])['total_paid_amt'].sum().reset_index()
df['rank']=df.groupby('Month')['total_paid_amt'].rank(method='dense',ascending=False)

df[df['rank']==1][['Month','description','total_paid_amt']]

#python #amazon #interview #question #best #selling #items #available #stratascratch #platform #groupby #dataframe #retail #rank #dense #ebay

#like #share #subscribe