Combine 2 datasets and include the duplicates

Question

Sarah Aldridge 2021-3-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/775847-combine-2-datasets-and-include-the-duplicates

回答： Seth Furman 2021-3-18

I have two datasets, the first is a list of postcodes gathered from a survey, the second is a matrix that cross-references all postcodes with the areas they are in. I want to generate a column listing the areas that the survey postcodes represents.

The part I am having trouble with is that in some cases, one postcode can correspod to mutiple areas, in these situations I want to include both areas in the new column.

I've tried joining the tables, but the standard Join command seems to have issues with there being duplicate values

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

ANKUR KUMAR 2021-3-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/775847-combine-2-datasets-and-include-the-duplicates#answer_650617

在 MATLAB Online 中打开

clc
clear
postcodes=randi(20,50,1);
areas=randi(10,50,5);
area_unique=unique(areas);
for ii=1:length(area_unique)
    [xx,yy]= find(areas==area_unique(ii));
    postcode_ref{ii}=unique(xx)';
end