Is there a function available to import row vectors from csv file?

Question

Rajesh Patel 2017-10-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/360475-is-there-a-function-available-to-import-row-vectors-from-csv-file

评论： Image Analyst 2017-10-11

Sample.csv

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Image Analyst 2017-10-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/360475-is-there-a-function-available-to-import-row-vectors-from-csv-file#answer_284962

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Rajesh Patel 2017-10-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/360475-is-there-a-function-available-to-import-row-vectors-from-csv-file#answer_284967

Sample.csv

Sorry, I have attached a sample file (I had to modify to remove confidential information). Vector names are in Column #2.

Thanks

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 3

Image Analyst 2017-10-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/360475-is-there-a-function-available-to-import-row-vectors-from-csv-file#answer_285008

在 MATLAB Online 中打开

sampleData = importdata('sample.csv')

seems to work just fine. Any problem with it? If so, state what they are.

2 个评论
显示无隐藏无

Rajesh Patel 2017-10-11

Sample2.csv

I am sorry, I should have made the sample file exactly as real data file. The real data file has header information. I removed it in order to preserve the confidential information. I have created a new sample file (attached) which is nearly same as structure as the real data file. It seems that importdata is not able to import the data completely. Finally I need vectors with names in "B1:B29". I appreciate your help. Thanks

Image Analyst 2017-10-11

在 MATLAB Online 中打开

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.

请先登录，再进行评论。