CsvReader reader = new CsvReader("input.csv");
while (reader.next()) {
String name = reader.getString("Name");
int age = reader.getInt("Age");
}
CsvWriter writer = new CsvWriter("output.csv");
writer.writeHeader("Name", "Age");
writer.writeRow("John Doe", 25);
writer.writeRow("Jane Smith", 30);
writer.close();
Filter filter = Filter.and(
Filter.regex("Name", "John.*"),
Filter.or(
Filter.gt("Age", 25),
Filter.eq("Gender", "Female")
)
);
CsvReader reader = new CsvReader("input.csv");
reader.setFilter(filter);
while (reader.next()) {
String name = reader.getString("Name");
int age = reader.getInt("Age");
String gender = reader.getString("Gender");
}
Aggregation aggregation = Aggregation.sum("Age");
aggregation.addGroupBy("Gender");
CsvReader reader = new CsvReader("input.csv");
reader.setAggregation(aggregation);
while (reader.next()) {
int ageSum = reader.getInt("SUM(Age)");
String gender = reader.getString("Gender");
}
Transformation transformation = Transformation.map("Gender")
.when("Male", "M")
.when("Female", "F")
.defaultValue("Unknown");
CsvReader reader = new CsvReader("input.csv");
reader.setTransformation(transformation);
while (reader.next()) {
String name = reader.getString("Name");
int age = reader.getInt("Age");
String gender = reader.getString("Gender");
}
