How do you remove a value from a table based on its value
18 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Daniel Gaggini
el 7 de Mayo de 2023
Comentada: Daniel Gaggini
el 8 de Mayo de 2023
I am trying to remove the columns from the tollowing Combined table if they have a Value of 1.
I am a trying to find a method that deletes the colunn based on its value rather than deleting the column based on its heading, as it value may change to a 1 or 0 depending on the data set.
This is what I currently have but I am recieving the following error. If anyone has any advice that would be great!
Value = ([0,0,1,1,0])
Heading = (["Radius", "Speed", "Type", "Location", "ID"])
Combined = array2table([Value; Heading])
Combined(Combined(1,:)>0,:) = []
2 comentarios
VBBV
el 8 de Mayo de 2023
% first approach & simpler
Value = ([0,0,1,1,0]);
idx = Value > 0;
Heading = (["Radius", "Speed", "Type", "Location", "ID"]);
Combined = array2table([Value; Heading]);
Combined(:,idx) = []
% second approach using additional functions
Value = ([0,0,1,1,0]);
Heading = (["Radius", "Speed", "Type", "Location", "ID"]);
Combined = array2table([Value; Heading]);
idx = str2double(table2array(Combined(1,:))) > 0
Combined(:,idx) = []
Respuesta aceptada
the cyclist
el 7 de Mayo de 2023
Editada: the cyclist
el 7 de Mayo de 2023
One can do what you ask as follows:
Value = ([0,0,1,1,0]);
Heading = (["Radius", "Speed", "Type", "Location", "ID"]);
Combined = array2table([Value; Heading]);
Combined(:,Combined{1,:} == "1") = []
In your simple example, MATLAB had to convert the numeric values 0 and 1 to the strings "0" and "1", to store them in the same column with other strings.
2 comentarios
the cyclist
el 7 de Mayo de 2023
Also, I can't shake the feeling that you are storing your data in a table in a very unconventional way, and therefore will experience many of these awkward operations. I suggest learning about the tidy format.
Más respuestas (0)
Ver también
Categorías
Más información sobre Logical en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!