print all values in a column
    4 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 Workspace Variables and MAT Files 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!
