Is there a function available to import row vectors from csv file?
3 views (last 30 days)
Show older comments
I have csv files where the data is row wise. so the vector names are in first column and data is along the row. Is there are function available to import the data in matlab. The row vector sometime can be characters or numeric data. Any help would be appreciated. Thanks
Now I have attached sample data file also
0 Comments
Answers (3)
Image Analyst
on 9 Oct 2017
You forgot to attach the file. Failing that, all I can suggest is to try importdata() (which is pretty flexible in what it can understand), or textscan().
0 Comments
Image Analyst
on 10 Oct 2017
sampleData = importdata('sample.csv')
seems to work just fine. Any problem with it? If so, state what they are.
2 Comments
Image Analyst
on 11 Oct 2017
importdata has a 'headerlinesIn' option where you can tell it to skip 20 lines, if there is a known number of header lines in the image. However there is a problem that you have lines like
-1,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
that follow the data, and that causes it to throw an error. You might have to write a custom function that either (1) reads your code with fgetl() and textscan() to parse and convert lines of text as you go down line-by-line, or (2) read the file line-by-ling and write only the "good" data lines to a file called 'delete_me.csv' which you can then read with importdata() and delete after it's read in and you don't need it anymore.
See Also
Categories
Find more on Text Files in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!