🥰 StrataScratch PythonPandas Easy I - 1 Solved

02119 Most Lucrative Products

# Import your libraries
import pandas as pd

# Start writing code
online_orders.head()

online_orders = online_orders[online_orders['date_sold'].between('2022-01-01','2022-06-30')]

online_orders['total_revenue'] = online_orders['cost_in_dollars'] * online_orders['units_sold']

online_orders.groupby('product_id')['total_revenue'].sum().reset_index(name='revenue').sort_values('revenue',ascending=False).head(5)

 

🥠product 별 revenue 최댓값 5개 정보 출력.

(1) between할 때 일자까지 정확하게 filtering 필수

(2) reset_index()안에 name 정확히 기입하고, 그 name에 맞게 sort_values()안에 기입

---