how do i export indiviudal cells of an array into seperate csv files with horizontal merging ?

2 次查看（过去 30 天）
manav chawla
manav chawla 2022-6-30
回答： Pratyush Swain 2023-9-3
Ran in:
numfiles = 20;
mydata = cell(1, numfiles);
m=1;
for k = 1:numfiles
myfilename = sprintf('sample%d.txt', k);
mydata{k} = importdata(myfilename);
x{k} = mydata{k}(:,1);
x{k} = x{k}/1000;
y{k} = mydata{k}(:,2);
for i = 1:length(mydata{k})
if (y{k}(i) >= 250 )
c(m,1)=x{k}(i);
c(m,2)=y{k}(i);
else
c(m,1)=x{k}(i);
c(m,2)=0;
end
m = m+1;
end
output{k}=c;
w{k} = output{k}(:,1);
q{k} = output{k}(:,2);
[f{k},X_f{k}]=fourier(w{k},q{k},'sinus');
o{k}=100*(abs(mean(X_f{k}(:),'all')));
e{k} = {w{k},q{k},f{k},X_f{k},o{k}};
writecell(e{k},'tremorsdatabase%d.csv',k);%% this doesnt work
m=1;
end
Error using importdata
Unable to open file.
So here I am trying to export my values into a single array E,
E will contain five values per cell
for example e{1} = { time(20000x1) , amplitude(20000 x 1 ), frequency(1 x 10000) , fourier complex frequency(1 x 10000) , mean frequency(1x1)
}
i need every exported csv file to contain one e{1}
is there anyway i can do it ?
  1 个评论
manav chawla
manav chawla 2022-6-30
my total size of e = 40, hence e{1} = 1x 5 array with all the values mentioned. e{all} = 40 (1 x 5) arrays with sub arrays of 5 values each.
value 1 size = 20000 x 1
value 2 size = 20000 x 1
value 3 = 1 x 10000
value 4 = 1 x 10000
value 5 = 1 x 1
i want for example e{1} to be stored in one csv file, e{2} in another csv file within the loop

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

Pratyush Swain
Pratyush Swain 2023-9-3
Hey manav,
I understand you want to export individual cell values of a cell array. Please verify the values passed into the cell array.Another workaround could be testing on some dummy data before using the actual file data.
For further reference you can refer to saving cell array to file.
Hope this helps.

类别

在 Help Center 和 File Exchange 中查找有关 Software Development Tools 的更多信息

标签

产品


版本

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by