Load a csv containing string

csv
read_csv

asked 2017-01-18 01:55:27 -0600

damiya14
36 ●1 ●6

I have a csv file that contains file paths.

eg:

col1  |         col2
 1    | 173/d234c34a87ffb7.jpg
 1    | 173/de9f04d2497222.jpg

I want to read this file and store it in opencv. How can i do it? I have tried the code below but it only reads col1 correct.

CvMLData cvml;
    cvml.read_csv("/home/damiya/test/compcars/sv_data/CSV/asd.csv");
    cvml.set_response_idx(0);
    const CvMat* vs = cvml.get_values();
    cout << "Rows: " << vs->rows << " Cols: " << vs->cols << endl;
    for(int i = 0; i < vs->rows; i++ )
    {
        cout << vs->data.fl[i*vs->cols] << "\n";

    }

edit retag flag offensive close merge delete

add a comment

1 answer

Sort by » oldest newest most voted

answered 2017-01-18 02:33:09 -0600

berak
32993 ●7 ●81 ●312

updated 2017-01-18 02:40:00 -0600

even if you're using some outdated opencv2.4 version, try to avoid c-based datastructures, like CvMat , IplImage, CvMlData , and such.

then, while CvMlData can be used for numerical data, it won't work with strings at all.

try with vector<string> , and something manual:

vector<string> names;
vector<int> ids;
int id;
char sep;
string name;

ifstream csv("asd.csv");
getline(csv, name); // skip header line
while(csv.good() && (csv >> id >> sep >> name)) {
    ids.push_back(id);
    names.push_back(name);
}