Extract data from structure and change it to Numerical matrix
조회 수: 3 (최근 30일)
이전 댓글 표시
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
채택된 답변
추가 답변 (1개)
Azzi Abdelmalek
2016년 4월 28일
M= 100;
data = cell(1, M);
for k = 1:N
N= sprintf('Data%d.xlsx', k);
data{k} = xlsread(N);
end
댓글 수: 0
참고 항목
카테고리
Help Center 및 File Exchange에서 Printing and Saving에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!