I have a cell array of 37x1 cells. each cell is having around 133x7 table. each cell data is one day data. therefore 37 days means 37 days data. i want to export each day (133x7 table) to a new txt file.

i am attaching a snapshot of how da

ta looks like. please help

[Shakir Hussain]

You can try this one

test = cell2mat(cellfun(@transpose,iwant,'uniform',0));

it will transpose you data in simple matrix

or reshape first then convert into matrix

if you have solved with any other way then kindly share here.

Answer 1

[KSSV]

N = 37 ;
% create random data
A = cell(N,1) ;
for i = 1:N
    A{i} = rand(133,7) ;
end

% Method 1, use cellfun 
iwant = cell2mat(cellfun(@mean,A,'un',0)) ;
% method 2, use a loop
iwant = zeros(N,7) ;
for i = 1:N
    iwant(i,:) = mean(A{i}) ;
end

save 'myfile.txt' iwant -ascii

[Neha gupta]

i don't want mean. I simply want each cell table to be exported as new text file.

Answer 2

[Peter Perkins]

I think you'd want to loop over the cell array, and call readtable on each cell's (table) contents.

Answer 3

[Neha gupta]

Thankyou everyone!