Reading csv files that have mixed string and numbers, with inconsistent columns and rows

Question

Matt C 2016-8-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/300080-reading-csv-files-that-have-mixed-string-and-numbers-with-inconsistent-columns-and-rows

评论： Matt C 2016-9-1

I’m having difficulty loading a csv file that contains mixed string and number data, with inconsistent columns and rows. Can anyone help me out? Once the data is loaded into individual cells/arrays, I should be good to go. importdata() only seems to capture half of the data, and I haven't had much luck with textscan(), though maybe I am using it improperly. A simplified example of the data I am processing can be found below.

Thanks!

Example .csv file:

Name,Weight,,Notes about Weight

Matt,165,,

Jim,250,,Jim is 60 pounds overweight

John,170,,

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

请先登录，再进行评论。

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

Answer 1

J. Webster 2016-8-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/300080-reading-csv-files-that-have-mixed-string-and-numbers-with-inconsistent-columns-and-rows#answer_232178

在 MATLAB Online 中打开

I think the way I'd approach this is with something like the following.

fid = fopen('myfile.csv');
myline = fgetl(fid);
while ischar(myline)
    C = strsplit(myline,',')
    % C now contains a cell array for each line, maybe you can work with that?
    myline = fgetl(fid);
end
fclose(fid);