Writing formatted CSV files
After cleaning your data, you need to export it for different consumers. The analytics team wants standard CSVs, European systems expect semicolon separators, and a legacy mainframe requires headerless files. Flexible export options ensure your data integrates smoothly across diverse technical environments.
The Table and CsvWriteOptions classes have been imported for you.
This exercise is part of the course
Importing Data in Java
Exercise instructions
- Write the table as a standard CSV.
- Write with a semicolon separator.
- Write without headers for a legacy system.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
public class WriteCSVFiles {
public static void main(String[] args) {
try {
Table employeePerformance = Table.read().csv("employee_performance.csv");
System.out.println("Original data structure:");
System.out.println(employeePerformance.structure());
System.out.println("First 3 rows:");
System.out.println(employeePerformance.first(3));
// Write the table as a standard CSV
employeePerformance.____.csv("employee_performance_standard.csv");
// Write with a semicolon separator
employeePerformance.write().csv(CsvWriteOptions
.____("employee_performance_semicolon.csv")
.____(';')
.build());
// Write without headers for a legacy system
employeePerformance.write().csv(CsvWriteOptions
.builder("employee_performance_noheader.csv")
.____(____)
.build());
System.out.println("\nFiles successfully written to output directory.");
Table readBack = Table.read().csv("employee_performance_standard.csv");
System.out.println("\nVerification - Reading back semicolon-separated file:");
System.out.println(readBack.first(3));
} catch (Exception e) {
System.err.println("Error processing CSV files: " + e.getMessage());
}
}
}