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.
Cet exercice fait partie du cours
Importing Data in Java
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.
Exercice interactif pratique
Essayez cet exercice en complétant cet exemple de 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));
}
}