Combine 2 datasets and include the duplicates
显示 更早的评论
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
回答（2 个）
ANKUR KUMAR
2021-3-17
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
If it helps you, then it's good. Otherwise, if you can provide the datset (or sufficient variables in a mat file), it owuld help us to help you.
Seth Furman
2021-3-18
0 个投票
Check out innerjoin and outerjoin.
类别
在 帮助中心 和 File Exchange 中查找有关 Tables 的更多信息
2021-3-17
2021-3-18
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
