How Can I Append Multiple Lined Header to a CSV File?

25 visualizaciones (últimos 30 días)
Ted Baker
Ted Baker el 16 de Nov. de 2020
Comentada: Peter Perkins el 18 de Nov. de 2020
I am looking to create a csv file with the date/time, variable names, and a table of data - something like:
Date, 01/11/20
A, B
1, 4
2, 5
3, 7
I've created a 2x2 cell for the header, and have an array of doubles containing the data. However, I cannot understand the error message I receive when trying to use the following code. What do I need to change in the code to make this work?
savetofile = 'test.csv';
date = datetime(now,'ConvertFrom','datenum');
data = [1 4; 2 5; 3 7];
data = array2table(data);
headerlines = {'Date:', date;
' A', 'B'};
fid = fopen(savetofile, 'wt');
for l = 1:numel(headerlines)
fprintf(fid,'%s\n', headerlines{l});
end
fprintf(fid, '%f; %f\n', data{:});
fclose(fid);
The error message I get is:
Subscripting into a table using one subscript (as in t(i)) or three or more subscripts (as in t(i,j,k)) is not supported. Always specify a row subscript and a variable subscript, as in t(rows,vars).
What am I doing wrong the subscripting?

Respuesta aceptada

Ameer Hamza
Ameer Hamza el 16 de Nov. de 2020
Editada: Ameer Hamza el 16 de Nov. de 2020
The indexing of table using data{:} is incorrect. This shows all the ways a table can be indexed: https://www.mathworks.com/help/matlab/matlab_prog/access-data-in-a-table.html. However, writecell() will be a more robust solution.
savetofile = 'test.csv';
date = datetime(now,'ConvertFrom','datenum');
data = [1 4; 2 5; 3 7];
data = num2cell(data);
headerlines = {'Date:', date;
' A', 'B'};
C = [headerlines; data];
writecell(C, savetofile)
  5 comentarios
Ameer Hamza
Ameer Hamza el 16 de Nov. de 2020
I am glad to be of help!
Peter Perkins
Peter Perkins el 18 de Nov. de 2020
Ted, creating a cell array is going to use a lot of memory if your data are even moderately large, and using cell arrays for numeric adata is just a bad habit that you want to stay away from. Nothing wrong with using a table. Write your header to the file, then append to it using writetable. If you have a recent version of MATLAB, use writematrix.
Also, use date = datetime('now') instead of convert from datetime.

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Dates and Time en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by