Extract first row from cell arrays
显示 更早的评论
Hey all, I have a 1 x 3 cell, which contains tables. In each table there are a lat and lon columns, I want to extract the first row of these columns from each table and store them below each other in an array. I thought about unique function but since there is just an example and my original data has many points with the same latitude and different longitude and vice versa it's not applicable in this case.
BTW here is my try:
for i = 1:numel(test)
lat(i) = test{i}(1,3);
lon(i) = test{i}(1,4);
LATandLON = (lat(i), lon(i))
end
Again since the original data set is really huge and maybe different column's number, I would like to avoid hard coding but I don't know how to do this in this case.
Thank you
采纳的回答
the cyclist
2020-4-11
编辑：the cyclist
2020-4-11
The following will give a 3-element cell array, where each cell has a 360x2 numeric array with the latitude and longitude vectors:
latAndLon = cellfun(@(x)[x.lat x.lon],test,'UniformOutput',false);
This code gives the same result as
for i = 1:numel(test)
latAndLon{i} = [test{i}.lat, test{i}.lon]
end
which might be easier to understand.
6 个评论
BN
2020-4-11
the cyclist
2020-4-11
Ah, I misread some of your question. Is this what you want?
tmp = cellfun(@(x)[x.lat(1) x.lon(1)],test,'UniformOutput',false);
firstLatAndLon = reshape(cell2mat(tmp),3,2)
Note that those could be combined into one statement:
firstLatAndLon = reshape(cell2mat(cellfun(@(x)[x.lat(1) x.lon(1)],test,'UniformOutput',false)),3,2);
BN
2020-4-11
oh thanks actually this part is okay:
tmp = cellfun(@(x)[x.lat(1) x.lon(1)],test,'UniformOutput',false);
And give me this, that is correct:
Now I want an array like this:
But after using this:
firstLatAndLon = reshape(cell2mat(tmp),3,2)
the order of tmp has changing and give me some thins like this:
36.7500 45.0000
45.0000 38.7500
37.7500 45.0000
Thank you.
BN
2020-4-11
the cyclist
2020-4-11
If that's the output you want, I guess it's right. :-)
You could test on a different input to be sure.
BN
2020-4-11
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Logical 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
