Reading csv files that have mixed string and numbers, with inconsistent columns and rows
조회 수: 15 (최근 30일)
이전 댓글 표시
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
채택된 답변
J. Webster
2016년 8월 18일
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);
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Data Import and Export에 대해 자세히 알아보기
제품
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!