print all values in a column

7 views (last 30 days)
Timothy
Timothy on 1 Sep 2023
Moved: Voss on 1 Sep 2023
Hi,
I have a large dataset with over 4 million rows. I do not know all the values of a particular column. There are 2 that I know, and 1-2 others hidden among the 4 million. How can I find the other values so I can split the datasets by values of that column?
Thanks,
Tim
  2 Comments
Walter Roberson
Walter Roberson on 1 Sep 2023
Edited: Walter Roberson on 1 Sep 2023
Or more likely in your case, findgroups
Timothy
Timothy on 1 Sep 2023
findgroups, I believe - just one "print" of each group, divided by number.

Sign in to comment.

Answers (1)

Walter Roberson
Walter Roberson on 1 Sep 2023
Moved: Voss on 1 Sep 2023
[GroupNumber, GroupValues] = findgroups(YourTable.AppropriateColumnName);
Then all of the entries in GroupNumber that == 1 had AppropriateColumnName value the same as GroupValues(1), and all of the entries in GroupNumber == 2 had AppropriateColumnName value the same as GroupValues(2) and so on.
  1 Comment
Timothy
Timothy on 1 Sep 2023
Moved: Voss on 1 Sep 2023
Thank you! That worked!

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!