How to show only the same variable

1 次查看（过去 30 天）

显示更早的评论

Alikouider 2021-12-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1608765-how-to-show-only-the-same-variable

评论： Alikouider 2021-12-12

采纳的回答： Walter Roberson

Hello,

I have a .mat file as following

Name adress company

BOB london BIM

Alfred Paris BOB

John BOB CEF

I would like to display only the duplicate variable in or order to create this new .mat file

Name adress company

BOB

If someone have an idea to create the adapted code?

Thanks in advance

5 个评论
显示 3更早的评论隐藏 3更早的评论

Image Analyst 2021-12-12

You accepted Walter's answer, so we assume everything is working perfectly now.

Alikouider 2021-12-12

I accepted walter's code

But chunru's code is more adapted to what I was looking for

walter's code is more complicated to adapt for the moment

so I focused on chunru's code and i saw that the duplication of the entries didn't work

dup = mode(Tcv); % duplicated entries (using mode)

this function doesn't seem to work

the same names (not variables) are randomly put in the table

I should keep the names which are the same and that appear in more than one variable.

Thanks for your understanding

请先登录，再进行评论。

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

采纳的回答

Walter Roberson 2021-12-11

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1608765-how-to-show-only-the-same-variable#answer_852860

在 MATLAB Online 中打开

common_values = intersect(intersect(Name, adress), company);
N = length(Name);
NName = strings(N, 1);
mask = ismember(Name, common_values);
NName(mask) = Name(mask);
Nadress = strings(N, 1);
mask = ismember(adress, common_values);
Nadress(mask) = adress(mask);
Ncompany = strings(N, 1);
mask = ismember(company, common_values);
Ncompany(mask) = company(mask);
output = table(Nname, Nadress, Ncompany, 'VariableNames', {'Name', 'adress', 'company'});

8 个评论
显示 6更早的评论隐藏 6更早的评论

Walter Roberson 2021-12-12

在 MATLAB Online 中打开

A = readtable('DataFilter.xlsx','TextType','string');
names_by_var = varfun(@unique, A, 'OutputFormat', 'cell');
[G, ID] = findgroups(categorical({names_by_var{:}}));
counts = accumarray(G, 1);
names_with_dups = ID(counts>1);
is_dup = varfun(@(V) ismember(categorical(V), names_with_dups), A, 'OutputFormat', 'uniform');
Aarray = table2array(A);
B = strings(size(Aarray));
B(is_dup) = Aarray(is_dup);