Free Practice Python Institute PCED Exam Questions 2025

You are working with a dataset that has a mix of numerical and textual data. Your job is to synthesize this information into a more digestible form. What technique could you use to handle both types of data effectively for downstream analysis?

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?

Which of the following NumPy methods would you use to apply a function element-wise on a 1-D array, while maintaining the shape of the original array?

You are working on a project that requires real-time data collection from a WebSocket API. Which of the following Python libraries would be most appropriate for this task?

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?