The basic usage guideline of the Scala CSV library
Scala is a modern programming language with powerful functions and rich libraries.CSV (COMMA SEPARATD VALUES) is a common data storage format, which is widely used in data exchange and data import and export.SCALA provides many CSV libraries that can easily handle CSV files.This article will introduce the basic usage of the Scala CSV library and provide Java code examples.
1. Add CSV library dependence
First, you need to add a CSV library to the SCALA project.The commonly used CSV libraries include "OpenCSV" and "Commons-CSV".You can obtain these libraries by adding the following dependencies by adding the following dependencies in the project construction file (such as built.gradle or pom.xml):
For "OpenCSV" library:
scala
libraryDependencies += "com.opencsv" % "opencsv" % "5.5.0"
For "Commons-CSV" library:
scala
libraryDependencies += "org.apache.commons" % "commons-csv" % "1.9"
Make sure the CSV library used corresponds to the version.
2. Read the CSV file
To read the CSV file, you need to use the reader provided in the CSV library.The following is a sample code. Demonstrate how to use the "OpenCSV" library to read the CSV file:
import com.opencsv.CSVReader;
import java.io.FileReader;
import java.io.IOException;
public class CSVReaderExample {
public static void main(String[] args) throws IOException {
String csvFile = "path/to/your/csv/file.csv";
CSVReader reader = new CSVReader(new FileReader(csvFile));
String[] line;
while ((line = reader.readNext()) != null) {
for (String value : line) {
System.out.print(value + " ");
}
System.out.println();
}
reader.close();
}
}
3. Write into CSV files
To write the CSV file, you need to use the WRITER provided in the CSV library.The following is a sample code, how to use the "OpenCSV" library to write into the CSV file:
import com.opencsv.CSVWriter;
import java.io.FileWriter;
import java.io.IOException;
public class CSVWriterExample {
public static void main(String[] args) throws IOException {
String csvFile = "path/to/your/csv/file.csv";
CSVWriter writer = new CSVWriter(new FileWriter(csvFile));
String[] record = {"John Doe", "john.doe@example.com", "New York"};
writer.writeNext(record);
writer.close();
}
}
The above code will create a CSV file called "File.csv" and write a line into the file.
4. Process CSV data
With the CSV library, you can also perform various data operations, such as selecting specific columns, filtering lines, etc.The following is the example code of the "Commons-CSV" library to demonstrate how to choose a specific column data:
import org.apache.commons.csv.CSVFormat;
import org.apache.commons.csv.CSVParser;
import org.apache.commons.csv.CSVRecord;
import java.io.FileReader;
import java.io.IOException;
public class CSVDataProcessingExample {
public static void main(String[] args) throws IOException {
String csvFile = "path/to/your/csv/file.csv";
FileReader fileReader = new FileReader(csvFile);
CSVParser csvParser = new CSVParser(fileReader, CSVFormat.DEFAULT);
for (CSVRecord csvRecord : csvParser) {
String name = csvRecord.get(0);
String email = csvRecord.get(1);
String city = csvRecord.get(2);
System.out.println("Name: " + name + ", Email: " + email + ", City: " + city);
}
csvParser.close();
}
}
The above code will read the CSV file and print the first, second and third values of each row.
Summarize:
This article introduces the basic usage of the Scala CSV library and provides Java example code.You can choose the appropriate CSV library according to the project, and conduct higher -level CSV data processing according to the document and API reference.I wish you a happy encoding when processing CSV data in SCALA!
