How do you remove a value from a table based on its value
显示 更早的评论
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 个评论
% 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) = []
Daniel Gaggini
2023-5-8
采纳的回答
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 个评论
the cyclist
2023-5-7
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.
Daniel Gaggini
2023-5-8
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Resizing and Reshaping Matrices 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
