Blog

You have sales data with columns: date, store_id, product, quantity, revenue. Explain how you would use Pandas to: (1) calculate total revenue per store, (2) find the top 5 best-selling products by quantity, and (3) create a new column showing revenue per unit.

What method would you use to sort a DataFrame by the ‘Price’ column in descending order?

What method would you use to sort a DataFrame by the ‘Price’ column in descending order?

Given a DataFrame df, what does df[df[‘Sales’] > 1000] return?

What does continue do inside a loop?

Given a DataFrame df, what does df[df[‘Sales’] > 1000] return?

Which method would you use to read a CSV file into a Pandas DataFrame?

To select rows by their integer position (e.g., the first 5 rows), you use __.

What is the main difference between a Pandas Series and a DataFrame?

A business analyst needs to analyze customer orders. The data includes order_id, customer_id, order_date, product_category, and order_amount. Explain how you would use Pandas to: (1) find the total spending per customer, (2) identify the most popular product category, and (3) filter orders from the last 30 days. What Pandas methods would you use for each task?