join tables based on string in one cell in the other
조회 수: 8 (최근 30일)
이전 댓글 표시
I have 2 tables, call them foo and bar. foo has strings in the form "foobar" in column 1. bar has strings in the form 'foobar' in column one.
foo{1,1} = "060514191658"
bar{1,1} = 1×1 cell array {'060514191658'}
foo(1,1) = table CaseID "060514191658"
bar(1,1) = table CaseID '060514191658'
When I try
>> join(foo,bar)
I get:
Error using tabular/join (line 129)
Left and right key variables 'CaseID' and 'CaseID' are not comparable because one is a non-cell.
How do I convert one or another to be able to join on this column.
I've tried every conversion I can think of and still can't get there.
댓글 수: 1
채택된 답변
Eric Tao
2018년 2월 9일
You need to convert strings in foo.var1 to characters, assuming the 1st column name in foo and bar are both 'var1'.
Run:
foo.var1_converted = cellfun(@(x) char(x),foo.var1,'UniformOutput',false);
then you will get a new column 'var1_converted' in foo, which contains the converted characters from strings in column 'var1'.
Then run:
new_tab = join(foo,bar,'leftkeys','var1_converted','rightkeys','var1');
you will get your joined table.
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Data Type Conversion에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!