How do you remove a value from a table based on its value
18 views (last 30 days)
Show older comments
Daniel Gaggini
on 7 May 2023
Commented: Daniel Gaggini
on 8 May 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 Comments
VBBV
on 8 May 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) = []
Accepted Answer
the cyclist
on 7 May 2023
Edited: the cyclist
on 7 May 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 Comments
the cyclist
on 7 May 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.
More Answers (0)
See Also
Categories
Find more on Logical 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!