Dear All, I am trying to export my output data from MATLAB into a text file, I attached a sample of the required FORMAT for the output file, and also the code I wrote to form the table, how can I please make it look like the output file I attached? Thank you
Month = {'January';'January';'January';'January';'January';'January';'January';'January';'January';'January'};
Class = [4;5;6;7;8;9;10;11;12;13];
Total = [100;100;100;100;100;100;100;100;100;100;];
Single = [Values_S_C4';Values_S_C5';Values_S_C6';Values_S_C7';Values_S_C8';Values_S_C9';Values_S_C10';Values_S_C11';...
Values_S_C12';Values_S_C13'];
T = table(Month,Class,Total,Single)
writetable(T,'tabledata.txt');
type tabledata.txt

 Akzeptierte Antwort

Guillaume
Guillaume am 4 Apr. 2019

1 Stimme

Assuming that your Values_S_Cx vectors were column vectors so that Single is a numel(Total) x Ncolumns matrix, then:
writetable(T, 'tabledata.txt', 'WriteVariableNames', false);
If using R2019a, you could store your data in a cell array instead of a table, and then use writecell instead.
C = [Month, num2cell([Class, Total, Single])];
writecell(C, 'tabledata.txt');
Note that you should never create numbered or serially named variables such as your Values_S_Cx. They should have been stored straight away as just one variable.

6 Kommentare

MAHMOUD ALZIOUD
MAHMOUD ALZIOUD am 4 Apr. 2019
This is amazing, Thank you very much
MAHMOUD ALZIOUD
MAHMOUD ALZIOUD am 4 Apr. 2019
Just 1 final questiosn, how can I make the zeros in 2 digits, for example 0.00 instead of 0 in the text file
Guillaume
Guillaume am 4 Apr. 2019
That's not supported by writetable or writecell. For that you'll have to use the low level functions such as fprintf.
Peter Perkins
Peter Perkins am 4 Apr. 2019
Just for the record, storing tabular data like that in a cell array is, usually, not a good idea. Memory-wise, it's very inefficient, and will run into issues even for moderately (by today's standards) large data. Usability-wise, it's going to be very clumsy to work with numeric data, such as total, in the cell array.
But kudos for being very up-to-date with writecell!
MAHMOUD ALZIOUD
MAHMOUD ALZIOUD am 4 Apr. 2019
What is your suggestion please?
Peter Perkins
Peter Perkins am 8 Apr. 2019
A table, or a timetable, probably containing a mix of numeric and categroical variables.

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Kategorien

Community Treasure Hunt

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

Start Hunting!

Translated by