vkvashistha/CSVReader

CSV Reader for Java

CSVReader for Java

Read CSV or TSV files into DataFrame and perform common operations such as sort and filter.

Usage

For example, let's say we have Data.csv with following content:-

Country,Age,Salary,Purchased
France,44,72000,No
Spain,27,48000,Yes
Germany,30,54000,No
Spain,38,61000,No
Germany,40,,Yes
France,35,58000,Yes
Spain,,52000,No
France,48,79000,Yes
Germany,50,83000,No
France,37,67000,Yes

Following code snippet loads csv content:-

DataFrame dataFrame = CSVReader.readCSV("Data.csv");

Following code snippet filter out rows where Age and Salary columns having null/empty string, select rows where Purchased column value is "Yes". Then finally sort it by Age.

DataFrame filteredDataframe = dataFrame
                .filter("Age", false, "")
                .filter("Salary", false, "")
                .filter("Purchased", true, "Yes")
                .sort("Age",true);

API Reference

DataFrame

1. DataFrame DataFrame.filter(String columnName, boolean include, String []values)
2. DataFrame DataFrame.filter(int colIndex, boolean include, String []values)
3. DataFrame DataFrame.sort(String columnName, boolean ascending)
4. DataFrame DataFrame.sort(int colIndex, boolean ascending)
5. Record.Field[] DataFrame.values(String columnName)
6. Record.Field[] DataFrame.values(int colIndex)
7. String[] DataFrame.getColumnNames()
8. int DataFrame.getColumnCount()

CSVReader

1. DataFrame CSVReader.readCSV(String filePath)
2. DataFrame CSVReader.readTSV(String filePath)

Record

1. Record.Field Record.getField(int colIndex)

Record.Field

1. String Record.Field.asString()
2. Integer Record.Field.asInt()
3. Double Record.Field.asNumber()