A data analyst is preparing a customer dataset for a promotional campaign analysis. The dataset includes a 'Customer Age' column with values ranging from 18 to 85. The marketing team has requested that the analysis be segmented by specific age groups (e.g., 18-29, 30-45, 46-60, 61+). This approach helps to simplify the model and reduce the impact of minor age variations on the results. Which data cleansing technique is most suitable for converting the continuous 'Customer Age' data into these discrete categorical groups?
The correct answer is Binning. Binning is the process of converting a continuous variable into a categorical one by grouping values into intervals, or 'bins'. In this scenario, the analyst needs to transform the continuous 'Customer Age' column into discrete age group categories, which is the exact function of binning.
Standardization is a technique used to rescale numeric data to have a mean of 0 and a standard deviation of 1, but it does not create categorical groups.
Imputation is used to fill in missing values in a dataset, which is not the problem described.
Parsing is the process of breaking down complex data, such as a date string, into smaller parts, which is not applicable to grouping numerical ages.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is binning in data analysis?
Open an interactive chat with Bash
Why is binning preferable to leaving data continuous in this scenario?
Open an interactive chat with Bash
What are the potential downsides of using binning?
Open an interactive chat with Bash
CompTIA Data+ DA0-002 (V2)
Data Acquisition and Preparation
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99 $11.99
$11.99/mo
Billed monthly, Cancel any time.
$19.99 after promotion ends
3 Month Pass
$44.99 $26.99
$8.99/mo
One time purchase of $26.99, Does not auto-renew.
$44.99 after promotion ends
Save $18!
MOST POPULAR
Annual Pass
$119.99 $71.99
$5.99/mo
One time purchase of $71.99, Does not auto-renew.
$119.99 after promotion ends
Save $48!
BEST DEAL
Lifetime Pass
$189.99 $113.99
One time purchase, Good for life.
Save $76!
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .