Reading csv files that have mixed string and numbers, with inconsistent columns and rows
15 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Matt C
el 18 de Ag. de 2016
Comentada: Matt C
el 1 de Sept. de 2016
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 comentarios
Respuesta aceptada
J. Webster
el 18 de Ag. de 2016
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);
Más respuestas (0)
Ver también
Categorías
Más información sobre Data Import and Export en Help Center y File Exchange.
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!