Display value from one table next to a certain name in another table

1 次查看(过去 30 天)
I have a very long data set with two tables that I'm going to give shortened examples of to explain what I'm trying to do. In Table 1 I have the following names:
'AAA'
'BBB'
'CCC'
and the following values corresponding to each of these members:
834240000
9951600
2383500
In another, longer table I have more names, some of which are found in table 1 but not all. For example:
'GGG'
'ZZZ'
'MMM'
'AAA'
'QQQ'
'FFF'
'BBB'
'YYY'
I want to display the value of each name in table 1 next to the matching name in table 2 but I'm having trouble doing that because of the different number of rows. I'd really appreciate some help!

采纳的回答

Iuliu Ardelean
Iuliu Ardelean 2021-1-13
编辑:Iuliu Ardelean 2021-1-13
Hi,
I'm assuming your variables will look like this:
names_1 = ['AAA'; 'BBB'; 'CCC'];
values_1 = [834240000; 9951600; 2383500];
names_2 = ['GGG'; 'ZZZ'; 'MMM'; 'AAA'; 'QQQ'; 'FFF'; 'BBB'; 'YYY'];
values_2 = zeros(length(names_2), 1); % initialize values_2 as column of zeros for now
% find which members in names_2 also appear in names_1 and where they are in names_1
[Lia, Lib] = ismember(names_2, names_1, 'rows')
values_2(Lia) = values_1(Lib(Lib ~= 0)) % assign values accordingly
Lia will look like [0, 0, 0, 1, 0, 0, 1, 0]
and Lib will look like [0, 0, 0, 1, 0, 0, 2, 0]
and values_2 will look like [0, 0, 0, 834240000, 0, 0, 9951600, 0]
Check out ismember if you wish.
Hope this helps.
NOTE: if you run into trouble you could try to substite zeros with
values_2 = nan(length(names_2), 1)

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Annotations 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by