Exercise

Advanced filtering and analysis

TechCorp wants to identify high-potential employees for leadership development: young employees (under 30) already earning Mid or Senior-level salaries. This requires removing outliers, creating categorical salary grades from numeric data, and then combining multiple filter conditions. These techniques handle real business questions that simple filters can't answer.

The Table, Selection, and StringColumn classes have been imported for you.

Instructions

100 XP

Remove outliers (salary < $40K or > $250K).
Count rows removed after filtering.
Map salaries to "Junior", "Mid", and "Senior" grades.
Filter for "Mid"/"Senior" grades under age 30.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions

Exercise