How to read special csv file by column

Question

I have a problem, I must to read a CSV file like:

csv structure

I want to get a list by column:

listKey1 = {value1, value11, value111, value1111}.

listKey2 = {value2, value22, value222}

....

Help me solve it!!! Please…

Possible duplicate of Java - parse CSV into Arrays based on columns — madsroskar
– madsroskar, Commented Dec 19, 2017 at 14:21

Jeronimo Backes · Accepted Answer · 2017-12-21 08:05:52Z

1

That's very easy to accomplish with univocity-parsers:

CsvParserSettings parserSettings = new CsvParserSettings();
ColumnProcessor columnProcessor = new ColumnProcessor();
parserSettings.setProcessor(columnProcessor);

CsvParser parser = new CsvParser(parserSettings);
parser.parse(new File("/path/to/your.csv), "UTF-8"); //all rows are submitted to the processor created above.

Map<String, List<String>> columnValues = columnProcessor.getColumnValuesAsMapOfNames();

Hope it helps.

Disclaimer: I'm the author of this library. It's open source and free (apache 2.0 license)

answered Dec 21, 2017 at 8:05

Jeronimo Backes

6,2992 gold badges27 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to read special csv file by column

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related