how to extract all rows with samen "Key" from matrix

3 visualizzazioni (ultimi 30 giorni)
Hi all, I am trying to extract from a Large Matrix with almost 70000 elements all rows with the SOURCE_KEY (column 3 of the matrix) '1BY6WEcLGh8j5v7' so that only the values to the matching KEY remain.
Does anyone have any ideas?

Risposte (1)

patrick1704
patrick1704 il 29 Giu 2022
Your SOURCE_KEY column is a categorical. Thus, you just have to do something like this:
reducedData = Electricity(Electricity.SOURCE_KEY == categorical({'1BY6WEcLGh8j5v7'}), :)

Prodotti

Community Treasure Hunt

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

Start Hunting!

Translated by