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.

Categories

Find more on Resizing and Reshaping Matrices in Help Center and File Exchange

Products


Release

R2022a

Community Treasure Hunt

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

Start Hunting!