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

Given a DataFrame df, what does df > 1000] return?

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?

Which method is used to handle missing values by replacing them with a specified value?

What is the output of list(range(5))?

Which list method removes and returns the last element?

In hypothesis testing, what does a p-value of 0.03 mean when alpha = 0.05?

A company conducted an A/B test comparing two email subject lines. Version A (n=5000) had a 4.2% open rate, Version B (n=5000) had a 4.8% open rate. Explain how you would determine if this difference is statistically significant. What would you conclude if the p-value is 0.12 versus if it is 0.02? Why is statistical significance important for business decisions?

What is the null hypothesis (H₀) in an A/B test comparing two website versions?

Which parameter controls the transparency of plot elements?