print all values in a column

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 Kommentare

Walter Roberson
Walter Roberson am 1 Sep. 2023
Bearbeitet: Walter Roberson am 1 Sep. 2023
Or more likely in your case, findgroups
Timothy
Timothy am 1 Sep. 2023
findgroups, I believe - just one "print" of each group, divided by number.

Melden Sie sich an, um zu kommentieren.

Antworten (1)

Walter Roberson
Walter Roberson am 1 Sep. 2023
Verschoben: Voss am 1 Sep. 2023

0 Stimmen

[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 Kommentar

Timothy
Timothy am 1 Sep. 2023
Verschoben: Voss am 1 Sep. 2023
Thank you! That worked!

Melden Sie sich an, um zu kommentieren.

Kategorien

Mehr zu Labels and Annotations finden Sie in Hilfe-Center und File Exchange

Gefragt:

am 1 Sep. 2023

Verschoben:

am 1 Sep. 2023

Community Treasure Hunt

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

Start Hunting!

Translated by