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.
Este exercício faz parte do curso
Importing Data in Java
Instruções do exercício
- Iterate through each row to access both salary and bonus values.
- Calculate total compensation by summing the two values.
- Add the
totalCompcolumn to theemployeestable.
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
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));
}
}