100% Free Python Institute PCED Practice Test Questions and Answers 2026

You have a DataFrame named df that has three columns: 'A', 'B', 'C'. The DataFrame has 100 rows. Your task is to create a DataFrame where each column 'A', 'B', 'C' is transformed into 3 columns each: 'A_min', 'A_max', 'A_mean', 'B_min', 'B_max', 'B_mean', 'C_min', 'C_max', 'C_mean'. Which of the following code snippets accomplishes this task?

You are tasked with merging two datasets, df1 and df2, on a common column 'id'. df1 has a column 'value1' and df2 has a column 'value2'. After merging, you need to create a new column called 'total_value' that sums 'value1' and 'value2'. Which of the following code snippets accomplishes this?

You are evaluating a logistic regression model using the ROC curve. Which of the following is true regarding the Area Under the Curve (AUC)?

You have a dataset of a retail company's sales transactions, which includes details like customer ID, transaction amount, transaction date, and store ID. You're tasked with summarizing monthly revenue for each store. What would be the most appropriate data aggregation technique?

You are implementing an ETL pipeline to fetch data from a JSON-based API and load it into a data lake. The API provides a pagination feature that shows 100 records per page. Which of the following Python libraries is most suitable for performing HTTP requests to extract data from this API?