Vlookup technique in Matlab

Question

Vespi 2016-3-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/273961-vlookup-technique-in-matlab

评论： Walter Roberson 2016-3-17

I have:

Single column array that I converted to table in matlab, which represent RGB values combined in one cell so 255119255 (RRRGGGBBB) -Note: this has 40448352 rows
Imported table with 10 columns. Column 2 defines the object corresponding to the RGB combined value also 255119225 format (column 9) - Note: This has about 60 rows

I would like to find each cell value in table (1) and if there is a match to the value in Table 2, Column 9 I want it to give me the name corresponding to that value (found in Table 2 column 2). If no match then 'NAN'.

Thank you!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Walter Roberson 2016-3-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/273961-vlookup-technique-in-matlab#answer_213929

在 MATLAB Online 中打开

[tf, idx] = ismember(table1.Column1, table2.Column9);
results = repmat({'NaN'}, length(tf), 1);  %did you say 'NaN' or NaN ?
results(tf) = table2.Column2(idx(tf));

You will need to adjust for the appropriate column names.

2 个评论
显示无隐藏无

Vespi 2016-3-17

编辑：Vespi 2016-3-17

在 MATLAB Online 中打开

I wanted NAN in order to represent no match. Ideally I would like to get the nearest value since the RGB combination should represent an object.

I ran the code and cannot figure out the last line

results(tf) = table2.Column2(idx(tf));

I changed it to results(tf) = Object(idx(tf)); Where object is the name of the column from which I want the object values to be given for the corresponding RGB value.