How to find same values in table and show them in a new table?

Question

Ergün AKGÜN 2019-5-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/461530-how-to-find-same-values-in-table-and-show-them-in-a-new-table

回答： Peter Perkins 2019-5-14

trend.mat

Hi all

I have 50x30 Table name 'TToplam', 1st column contain word (Word2004), 2nd count of the word (Count2004) and this two columns represent a year. There are total 15 years data.

I want to show similarities and diversities of words.

Problem 1: How can i find similar (exactly word have to be all years) words from 1st,3rd,5th....15th column and match them with their counts in a new Table?

Example

Problem 2: How can i find diversities (Unique ones) of words in a new Table?

4 个评论
显示 2更早的评论隐藏 2更早的评论

Image Analyst 2019-5-12

Can you attach the table in a .mat file witht he paper clip icon? This will make it easier for us to try code with it.

Ergün AKGÜN 2019-5-13

Hi Image Analyst

I attached the .mat file

请先登录，再进行评论。

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

Answer 1

Sulaymon Eshkabilov 2019-5-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/461530-how-to-find-same-values-in-table-and-show-them-in-a-new-table#answer_374553

在 MATLAB Online 中打开

One of the possible ways is to write a small function file with fgetl(), ischar(), strfind(), etc., like this one. This can search for specific words in your data file, e.g. MY_table.csv

function W=wordsearch_ALL(myfilename, WordSpell)
% The script reads and searches for keywords.
% e.g.: >> W = wordsearch_ALL('MY_table.csv', 'student') 
fid=fopen(myfilename);
w=0;
wholeline=fgetl(fid);
while  ischar(wholeline)
    match_found=strfind(wholeline, WordSpell);
    num=max(size(match_found));
if num>0
        w=w+num;
        fprintf(1, '%d:%s\n', num, wholeline);
end
    wholeline=fgetl(fid);
end
fclose(fid);

Good luck

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Ergün AKGÜN 2019-5-13

I attached the .mat file, you can review

请先登录，再进行评论。

Answer 2

Peter Perkins 2019-5-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/461530-how-to-find-same-values-in-table-and-show-them-in-a-new-table#answer_374992

Your first question is just an inner join, I think. Perhaps an outer join, you have not explained sufficiently. You'll have to split the one table into 15 tables though.

Not sure I understand what the second question means. Maybe you want to vertically concatenate those 15 tables and cal unique on the (one) Word variable? You'll need to make the (two) variable names match in all 15 to vertcat them.