I want to Import the attached csv with following Code: >> d = dbload('data_US.csv');
If I then check for the variable d, it shows correctly 13 fields, but each of the fields contains only NaN's
Thank you very much
Best Answer
There is a function called csvread that should load the file.
If your file has headers (or anything other than numbers), the command won't work. To get around this, set it to have an offset of one row (and no column offset).
data=csvread('data_US.csv') or data=csvread('data_US.csv',1,0)
You can also select a more specific range of data if you need to, so check out the documentation if that's something you want to do.
Both readtable and readmatrix will handle this file without issue. I would have thought that importdata would delegate to readtable so I'm surprise it didn't work for you.
readtable will label the columns according to the header.
Best Answer