Write a function get_distance that accepts two character vector inputs representing the names of two cities. The function returns the distance between them as an output argument called distance.
2 次查看(过去 30 天)
显示 更早的评论
function distance = get_distance(x,y)
[~,~,raw] = xlsread('Distances.xlsx');
T = readtable('Distances.xlsx');
texes = table2struct(T);
if (isfield(texes,x)==1 && isfield(texes,y)==1)
distance = -1;
else
index1 = find(strcmp(raw,x));
cell1 = index1(1,1);
index2 = find(strcmp(raw,y));
cell2 = index2(1,1);
distance = raw{cell1, cell2};
end
end
The given output is write,but I can't understand the warning and can't find out the problem. I find no-one with this problem, Please help someone kindly.
0 个评论
回答(2 个)
Vinayak Mohite
2020-6-19
编辑:Vinayak Mohite
2020-6-19
Hi Konkon,
The warning is there because the column headers of the file which is being read contain spaces, leading numbers, or other characters. But variables in MATLAB cannot have them.
You can get your original column header by setting PreserveVariableNames property to true.
T = readtable('Distances.xlsx', "PreserveVariableNames",true)
You are getting a correct answer because this is just a warning and not an error. This warning just to let the user know that his/her data has been modified.
Konkon Das
2020-6-19
2 个评论
Vinayak Mohite
2020-6-24
One can use this property
T = readtable('Distances.xlsx','PreserveVariableNames',true);
only in R2019b or later.
But not using this will only generate a warning. This warning just to let the user know that his/her data has been modified. Hence you are getting the correct output
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Matrix Indexing 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!