Fetching data from a CSV file and storing it into a 2D array - Java

Question

I have a csv file saved with the name - "public/csvFiles/pushup.csv", where I have converted a 2D matrix into csv format. Now I want to make a static method in a manager class, where in I will make a 2D array by fetching data from that csv file. So I want to know how to do that. How to make a 2D array from the data present in the csv file?

I have made my csv file in the following format :

comma separated values, after every comma, means new column
every new line means new row

Use a CSV parser library, like OpenCSV or Apache Commons CSV. — Olivier Grégoire
– Olivier Grégoire, Commented Dec 4, 2017 at 14:14
Questions asking for homework help must include a summary of the work you've done so far to solve the problem, and a description of the difficulty you are having solving it (help center, How to Ask). Also show some research effort before posting a question, thanks. — Zabuzard
– Zabuzard, Commented Dec 4, 2017 at 15:46

Toby Speight · Accepted Answer · 2017-12-04 16:45:48Z

-1

If I get you right - the first dimension of an array is structure reflecting lines. Second dimension - rows of CSV file.

So I propose to create a structure reflecting row. Names must be meaningful. But the idea is:

RowClss {
    String row;
    String row 2;
    // etc
}

Then in the loop, you can read the file and fill the array:

String[x][y] rows = new String[x][y];

for(ont i = 0; i < file.size; i++) {
    // read line from file and parse it here
    for(j = 0; j < numOfColumns;j++) {
        rows[j][i] = new String(valueOfCurrentCollumn);
    }
}

edited Dec 4, 2017 at 16:45

Toby Speight

32.1k58 gold badges82 silver badges117 bronze badges

answered Dec 4, 2017 at 14:07

Mykola Bova

425 bronze badges

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

2 Comments

klutt Over a year ago

Use comments to ask for clarifications. Until you have high enough reputation, focus on questions you can answer without asking for clarification.

Mykola Bova Over a year ago

Thank you. Get it.

Collectives™ on Stack Overflow

Fetching data from a CSV file and storing it into a 2D array - Java

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related