Saving and appending for loop results from every run
3 次查看(过去 30 天)
显示 更早的评论
Hi everyone,
I have a dataset with countries and lat/lon columns. I want to measure the distance between the countries. I used the distance function from the mapping toolbox and a for loop to get every single country.
I’m struggling with saving the results from the for loop. I’m overwriting my results. I want to save every run from the for loop as a single column, basically append the results from every run. Does anyone have an efficient/better way to save the results? I would really appreciate your help in advance. I attached the data example and my code
format long g
Data = readtable('Test.xlsx');
for i=1:Data.lat
Distance = deg2sm(distance([Data.lat(i) Data.lon(i)], [Data.lat(1:end) Data.lon(1:end)]));
Data.Distance = Distance
end
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/725234/image.png)
2 个评论
DGM
2021-8-30
编辑:DGM
2021-8-30
You appear to be measuring the distance from each point to all other points. The result won't fit in one column and won't be meaningfully aligned with the corresponding rows.
For example, let's assume you have 10 points. The way you're doing this, you'll have 10x10 = 100 distances. Of course, a lot of those distances will be redundant. There would only be 10!/2!(10-2)! = 45 unique distances. If your table is 10 rows long, where would you put 45 entries?
In the first case, you could add 10 distance columns to the table, each one listing the distance from one country to each country in the table. Whether you want to add a bunch of columns is up to you. Either way, it's not going to meaningfully fit in one column with the existing table length.
采纳的回答
Chunru
2021-8-31
If you want to attach the distance to the Data table you have read, then you can attach the distance vector for each country as follows.
format long g
Data = readtable('Test.xlsx');
for i=1:length(Data.lat)
Distance = deg2sm(distance([Data.lat(i) Data.lon(i)], [Data.lat(1:end) Data.lon(1:end)]));
Data.Distance{i} = Distance;
end
Data
If you want to form a tall vector of distances, or a paired distance matrix you can do the following:
d = [];
for i=1:length(Data.lat)
Distance = deg2sm(distance([Data.lat(i) Data.lon(i)], [Data.lat(1:end) Data.lon(1:end)]));
d = [d; Distance]; % tall vector
%d = [d Distance]; % matrix
end
d
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!