Total compensation calculator
The company needs total compensation figures that combine salary and bonus for each employee. Since this calculation requires values from two different columns in the same row, you'll need to iterate through rows rather than transform a single column.
The Tablesaw library has been imported, and employees.csv contains the Salary and Bonus columns.
This exercise is part of the course
Importing Data in Java
Exercise instructions
- Iterate through each row to access both salary and bonus values.
- Calculate total compensation by summing the two values.
- Add the
totalCompcolumn to theemployeestable.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
public class TotalCompensation {
public static void main(String[] args) {
Table employees = Table.read().csv("employees.csv");
// Iterate through each row
DoubleColumn totalComp = DoubleColumn.create("TotalCompensation");
employees.____(row -> {
double salary = row.getInt("Salary");
double bonus = row.getInt("Bonus");
// Sum salary and bonus
totalComp.append(____ + ____);
});
// Add totalComp column
employees.addColumns(____);
System.out.println("Total Compensation Analysis:");
System.out.println(employees.first(5));
}
}