Extract data from structure and change it to Numerical matrix
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Ali Kareem
am 28 Apr. 2016
Beantwortet: Azzi Abdelmalek
am 28 Apr. 2016
Hi,
I have 100 .xlsx files. Each file has 100*100 (row*column).I used blow code to read them.
clear;
clc;
M= 100;
data = cell(1, M);
for k = 1:N
N= sprintf('Data%d.xlsx', k);
data{k} = importdata(N);
end
I have couples of questions
- How can I plot each column starting from column number 2 against column number1 for all matrices? I should have 99 plot for each matrix.
- How can I extract data from the structure to do some operation on it? I should have 100 matrices with size (100*100).
I tried below code to extract data, but it isn't working. it is saving only one matrix
for i=1:100
z=data{1,i}.data;
end
I tried this code to make 3D matrix. It will be easier for plotting but when I execute code I got two structures one inside each other and that make extracting data from it difficult
data=zeros(100,100,100)
M= 100;
for k = 1:M
N = sprintf('file%d.xlsx', k);
data(:,:,k)=importdata(N);
end
Thanks
0 Kommentare
Akzeptierte Antwort
Weitere Antworten (1)
Azzi Abdelmalek
am 28 Apr. 2016
M= 100;
data = cell(1, M);
for k = 1:N
N= sprintf('Data%d.xlsx', k);
data{k} = xlsread(N);
end
0 Kommentare
Siehe auch
Kategorien
Mehr zu Printing and Saving finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!