Counting outcomes of names

1 view (last 30 days)
Ruben Moreno
Ruben Moreno on 12 May 2022
Commented: Ruben Moreno on 12 May 2022
Hi, i have a collumn of names of investors in a large dataset and im trying to extract the occurance of every investor. A large quanitity have a combination of investors, meaning there are several names in one cell, so they would only be counted once if i were to count them alone. Is there any way to count all names, even in combination with others?

Accepted Answer

Matt J
Matt J on 12 May 2022
Edited: Matt J on 12 May 2022
Something like this, perhaps?
investors=["Sam";"Joe";"Sam and Joe"]
investors = 3×1 string array
"Sam" "Joe" "Sam and Joe"
contains(investors,"Sam")
ans = 3×1 logical array
1 0 1
  8 Comments
Ruben Moreno
Ruben Moreno on 12 May 2022
Nvm, i fixed it. It worked now, Wow. thank you very much!

Sign in to comment.

More Answers (1)

Stephen23
Stephen23 on 12 May 2022
Edited: Stephen23 on 12 May 2022
str = ["Sam";"Joe";"TPG, Sam, Joe";"TPG, Joe"]
str = 4×1 string array
"Sam" "Joe" "TPG, Sam, Joe" "TPG, Joe"
spl = regexp(str,',','split');
[uni,~,idx] = unique(strtrim([spl{:}]));
cnt = histcounts(idx);
[uni;cnt]
ans = 2×3 string array
"Joe" "Sam" "TPG" "3" "2" "2"
  1 Comment
Ruben Moreno
Ruben Moreno on 12 May 2022
i figured the problem out. But i have a follow up question, I want to use the information i gained. Count of every investors frequency. to add a indication for experience in the original dataset. Creating a dummy for investors observations > 100 and 0 for the rest.

Sign in to comment.

Products


Release

R2022a

Community Treasure Hunt

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

Start Hunting!