LoslegenKostenlos loslegen

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.

Diese Übung ist Teil des Kurses

Importing Data in Java

Kurs anzeigen

Anleitung zur Übung

  • Iterate through each row to access both salary and bonus values.
  • Calculate total compensation by summing the two values.
  • Add the totalComp column to the employees table.

Interaktive Übung

Vervollständige den Beispielcode, um diese Übung erfolgreich abzuschließen.

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));
    }
}
Code bearbeiten und ausführen