print all values in a column

7 visualizzazioni (ultimi 30 giorni)
Timothy
Timothy il 1 Set 2023
Spostato: Voss il 1 Set 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 Commenti
Walter Roberson
Walter Roberson il 1 Set 2023
Modificato: Walter Roberson il 1 Set 2023
Or more likely in your case, findgroups
Timothy
Timothy il 1 Set 2023
findgroups, I believe - just one "print" of each group, divided by number.

Accedi per commentare.

Risposte (1)

Walter Roberson
Walter Roberson il 1 Set 2023
Spostato: Voss il 1 Set 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 Commento
Timothy
Timothy il 1 Set 2023
Spostato: Voss il 1 Set 2023
Thank you! That worked!

Accedi per commentare.

Community Treasure Hunt

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

Start Hunting!

Translated by