Free Python Institute PCED-30-01 Exam Questions

You need to collect data from an Excel file with multiple sheets. One of the sheets is named "Sales" and another is named "Inventory". You want to load the "Sales" sheet into a DataFrame named df_sales and the "Inventory" sheet into a DataFrame named df_inventory. Which of the following code snippets accomplishes this?

Consider the Python code snippet below:numbers = [1, 2, 3, 4, 5]filtered_numbers = list(filter(lambda x: x % 2 == 1, numbers))result = len(filtered_numbers)What will be the value of result after executing the code?

You are working with a logistic regression model for a binary classification problem. You notice that the training error is significantly lower than the validation error. What could you do to improve the model's performance on the validation set?

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?

You have a DataFrame df that contains duplicate rows. Your task is to remove duplicates based on two columns: 'A' and 'B'. What is the correct line of code to remove such duplicates while keeping the first occurrence?