What kind of join will work to merge these two tables
조회 수: 1 (최근 30일)
이전 댓글 표시
I have table T1
date city vistors
---------------------
January 1 2020 NY 100
January 2 2020 NY 200
January 1 2020 SF 150
January 4 2020 SF 50
I have table T2
city state
----------
NY New York
SF Calfiornia
I want Matlab to create T3
date city vistors state
---------------------
January 1 2020 NY 100 New York
January 2 2020 NY 200 New York
January 1 2020 SF 150 California
January 4 2020 SF 50 California
댓글 수: 2
Image Analyst
2020년 12월 12일
Make it easy for us to help you, not hard. Give us code to create the input tables T1 and T2.
What happens if you just simply try the various flavors of join? Maybe you'll stumble across the right one.
One non-join way is to simply use a for loop and ismember().
채택된 답변
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Loops and Conditional Statements에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!