A DataFrame has a 'Price' column with values ranging from 10 to 1000. An analyst wants to scale this column to a 0-1 range for a neural network. Which transformation is most appropriate?

Apply log transformation: log(x)

Apply Z-score standardization: (x - mean) / std

Apply rank transformation: assign ranks 1 to n

Apply Min-Max scaling: (x - min) / (max - min)

What is a recommended best practice for column headers in a spreadsheet to ensure readability?

Use short, descriptive names without spaces

Use special characters like @ and #

Python InstitutePCAD - Certified Associate in Data Analytics with Python

Domain 1Objective 4

Data Preparation Techniques PCAD-31 Practice Questions (Page 5)

Part of the Data Acquisition and Pre-Processing domain, which accounts for 29.2% of the PCAD-31 exam. Python Institute does not publish an official question count, but from its 60-minute exam (~25–40 total, ~7–7 in this domain), expect 2–2 from this objective — we provide 27 practice questions to prepare you well beyond it. (estimate)

27questions here

6free pages

6concepts

29.2%of the exam

Questions 21–25

21foundation · easy
Which pandas method is used to remove rows with missing values from a DataFrame?
Select an answer first
22foundation · easy
Which file format is best suited for storing semi-structured data with nested relationships, such as a list of customers where each customer has an array of orders?
Select an answer first
23application · medium
A DataFrame has a 'Price' column with values ranging from 10 to 1000. An analyst wants to scale this column to a 0-1 range for a neural network. Which transformation is most appropriate?
Select an answer first
24foundation · easy
What is a recommended best practice for column headers in a spreadsheet to ensure readability?
Select an answer first
25foundation · easy
Which Python library is commonly used to make HTTP requests to a web API for data extraction?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to PCAD-31

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Python Institute. “PCAD-31” is a trademark of its owner, used for identification only.

Data Preparation Techniques PCAD-31 Practice Questions (Page 5)

Questions 21–25

Which pandas method is used to remove rows with missing values from a DataFrame?

Which file format is best suited for storing semi-structured data with nested relationships, such as a list of customers where each customer has an array of orders?

A DataFrame has a 'Price' column with values ranging from 10 to 1000. An analyst wants to scale this column to a 0-1 range for a neural network. Which transformation is most appropriate?

What is a recommended best practice for column headers in a spreadsheet to ensure readability?

Which Python library is commonly used to make HTTP requests to a web API for data extraction?

Keep studying — Data Acquisition and Pre-Processing