Efficiently importing data into a table based on a matching column value

Question

Sean Bradley 2022-7-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1763895-efficiently-importing-data-into-a-table-based-on-a-matching-column-value

回答： Sulaymon Eshkabilov 2022-7-19

I have two large data tables. Each table has a column with a unique code representing the same event analyzed by two different pieces of software. Not all codes are present on both tables.

What I want to do is find rows in which the event in Table A matches the event code in Table B, and put other data from those matching rows alongside the data in tableA.

On a smaller scale, I've used something in the form of:

for q = 1:height(tableA)
    for r = 1:height(tableB)
        if tableA.frame(q) == tableB.frame(r)
            tableA.data(q) = tableB.data(r);
        end
    end
end

Searching and replacing row-by-row is far too inefficient to use at scale and I'm sure there must be a better way, but since the tables are different sizes and each contains codes that aren't present on the other, I'm not sure how to do this via indexing in MATLAB.