How Do i Sort rows in tables based on unique rows dictionary ?
조회 수: 3 (최근 30일)
이전 댓글 표시
Dear experiences..
i have two tables.... A and B, where table A involves 4 columns as follow :
Table A:-
Id index con_name class
1 200 greed 1
2 301 rfg 3
3 505 rft 3
4 401 oil 1
etc..
Table B:-
con_name Var1 Var2 .......... VarN
rft ............................
greed ............................
rfg ............................
conr ...........................
oil ...........................
- So ,my requirements as follow:
- i need to build dictionary table includes only (con_name) that exist in both tables A and B.. then
- remove con_name rows from Table A that not exist in dictionary table
- remove con_name rows from Table B that not exist in dictionary table
- sort con_name rows in table A and B in similar order.. where the result of table A and B shows that con_name in similar order.
i would thanks any one can help me in these requirements. thanks
댓글 수: 0
채택된 답변
Andrei Bobrov
2017년 6월 8일
[l0,iB] = ismember(A.con_name,B.con_name);
dictionary_table = A{l0,3};
A_new = A(l0,:);
B_new = B(iB(l0),:);
[~,ii] = ismember(A_new.con_name,B_new.con_name):
B_new = B_new(ii,:);
댓글 수: 0
추가 답변 (1개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Tables에 대해 자세히 알아보기
제품
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!