Combine 2 datasets and include the duplicates

조회 수: 4 (최근 30일)
Sarah Aldridge
Sarah Aldridge 2021년 3월 17일
답변: 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

답변 (2개)

ANKUR KUMAR
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
Seth Furman 2021년 3월 18일

카테고리

Help CenterFile Exchange에서 Tables에 대해 자세히 알아보기

태그

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by