1. Learn
    2. /
  2. Courses
    3. /
  3. Importing Data in Java
Connected

Exercise

Data cleaning and enhancement

TechCorp is migrating to a new HR system. The dataset needs cleaning: remove low-salary outliers that indicate data entry errors, drop columns the new system won't use, and add a calculated bonus field. Data cleaning typically takes 80% of analysis time—these skills are essential.

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

Instructions

100 XP
  • Remove employees with salaries below $40,000.
  • Remove the "JobTitle" column.
  • Add the PerformanceBonus column (5% of salary).