Employee salary analysis
You're analyzing employee data for a tech company. The HR department needs to adjust salaries to reflect a 10% raise for all employees. Your task is to transform each salary value and add the results as a new column.
The Tablesaw library has been imported, and employees.csv contains the Name, Department, Salary, and Bonus columns.
Este exercício faz parte do curso
Importing Data in Java
Instruções do exercício
- Apply a transformation to calculate each employee's salary increased by 10%.
- Add the new adjusted salary column to the table.
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
public class EmployeeSalary {
public static void main(String[] args) {
Table employees = Table.read().csv("employees.csv");
// Apply transformation for 10% increase
DoubleColumn adjustedSalary = employees.intColumn("Salary")
.asDoubleColumn()
.____(salary -> salary * ____);
// Add new column to table
employees.____(adjustedSalary.setName("AdjustedSalary"));
System.out.println("Employee Salary Analysis:");
System.out.println(employees.first(5));
}
}