print all values in a column
7 views (last 30 days)
Show older comments
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
on 1 Sep 2023
Edited: Walter Roberson
on 1 Sep 2023
unique ?
Or more likely in your case, findgroups
Answers (1)
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.
See Also
Categories
Find more on C2000 Microcontroller Blockset in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!