how to use elements from array to sort data

2 次查看（过去 30 天）
Sumanth
Sumanth 2023-2-27
评论： Stephen23 2023-2-27
numdata = xlsread("res Data.xlsx");
1500 1500 500 1500 500 2500
850 850 200 850 200 1000
2800 2800 1700 2800 1700 5200
500 500 300 500 300 3000
1600 1600 1000 1600 1000 2700
10 9 10 11 10 9
9 9 9 10 9 9
13 11 13 12 13 11
21 18 21 20 21 18
18 18 18 19 18 18
for i = 1:6
Q(i) = numdata(1:5,i);
end
for i = 1:6
F(i) = numdata(6:10,i);
end
Hello I want to store a part of the array with some other name like I want Q1 = 1500 850 2800 500 1600
then Q2 = 1500 850 2800 500 1600 and so on..
and F1 = 10 9 13 21 18 and so on..
i get an error of incompatible size. Please help mein how to handle big data from excel sheets to store data appropriately.
  1 个评论
Dyuman Joshi
Dyuman Joshi 2023-2-27
编辑：Dyuman Joshi 2023-2-27
"I want Q1 = 1500 850 2800 500 1600 then Q2 = 1500 850 2800 500 1600 and so on.. and F1 = 10 9 13 21 18 and so on.."
What you want to do is incredibly inefficient and difficult to work with. Read more here
You already have the data in matrices, you can access them via indexing, in an easy, efficient and clear manner.

请先登录，再进行评论。

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

采纳的回答

Kevin Holly
Kevin Holly 2023-2-27
编辑：Kevin Holly 2023-2-27
Ran in:
numdata = [1500 1500 500 1500 500 2500;
850 850 200 850 200 1000;
2800 2800 1700 2800 1700 5200;
500 500 300 500 300 3000;
1600 1600 1000 1600 1000 2700;
10 9 10 11 10 9;
9 9 9 10 9 9;
13 11 13 12 13 11;
21 18 21 20 21 18;
18 18 18 19 18 18];
for i = 1:6
Q(i,:) = numdata(1:5,i);
end
The variable in this case is a matrix. Is it fine if it is this way in stead of individual variables called Q1,Q2? If this is need,
Q(1,:)
ans = 1×5
1500 850 2800 500 1600
Q(2,:)
ans = 1×5
1500 850 2800 500 1600
If this is needed, then you could use assignin.
assignin('base','Q1',Q(1,:))
Q1
Q1 = 1×5
1500 850 2800 500 1600
for i = 1:6
F(i,:) = numdata(6:10,i);
end
F(1,:)
ans = 1×5
10 9 13 21 18
F(2,:)
ans = 1×5
9 9 11 18 18
If you are dealing with large data and this was just a sample dataset, I would recommend using spreadsheetdatastore and tall arrays.
ssds = spreadsheetDatastore(location,"FileExtensions",[".xlsx",".xls"]) ;
tt = tall(ssds)
  2 个评论
Kevin Holly
Kevin Holly 2023-2-27
编辑：Kevin Holly 2023-2-27
Ran in:
If you want it in a for loop:
numdata = [1500 1500 500 1500 500 2500;
850 850 200 850 200 1000;
2800 2800 1700 2800 1700 5200;
500 500 300 500 300 3000;
1600 1600 1000 1600 1000 2700;
10 9 10 11 10 9;
9 9 9 10 9 9;
13 11 13 12 13 11;
21 18 21 20 21 18;
18 18 18 19 18 18];
for i = 1:6
assignin('base',['Q' num2str(i)],numdata(1:5,i)')
end
Q1
Q1 = 1×5
1500 850 2800 500 1600
Q2
Q2 = 1×5
1500 850 2800 500 1600
Q3
Q3 = 1×5
500 200 1700 300 1000
Q4
Q4 = 1×5
1500 850 2800 500 1600
Q5
Q5 = 1×5
500 200 1700 300 1000
Q6
Q6 = 1×5
2500 1000 5200 3000 2700

请先登录，再进行评论。

更多回答（2 个）

Sulaymon Eshkabilov
Here is the corrected code:
numdata=readmatrix("res Data.xlsx");
Q = numdata(1:5, :)';
F = numdata(6:10, :)';
David Hill
David Hill 2023-2-27
Keep your data stored in matrices that you can index into.
numdata = xlsread("res Data.xlsx");
Q=numdata(1:5,:);
F=numdata(6:10,:);
Q1=Q(:,1);Q2=Q(:,2);%whenever you want them Q(:,n)
  2 个评论
Sumanth
Sumanth 2023-2-27
Can we not write a for loop for putting it From Q1 to Q6??
Stephen23
Stephen23 2023-2-27
"Can we not write a for loop for putting it From Q1 to Q6??"
Sure, if you really want to make accessing your data slow, complex, and inefficient:
https://www.mathworks.com/matlabcentral/answers/304528-tutorial-why-variables-should-not-be-named-dynamically-eval

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Matrices and Arrays 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by