How can I delete data from a variable in a table?

68 次查看（过去 30 天）
Waleed Nowayti
Waleed Nowayti 2021-7-23
评论： Waleed Nowayti 2021-8-3
How can I delete data from a variable in a table: For example,
I want to delete all rows that has 'Not Collected' under SampledDate.
  4 个评论
显示 2更早的评论
Waleed Nowayti
Waleed Nowayti 2021-7-26
Sorry for the incomplete information. I meant to say I want to delete the whole rows. Any row contains Not Collected under 'SampledData', I need the code to delete it!
Waleed Nowayti
Waleed Nowayti 2021-8-3
This is what I did Rik, and it is working for me!
W = table2cell(TEST);
IndexW = find(contains(W(:,7), 'Not Collected'));
% I used (:,7) to locate the column instead of using its name!
TEST(IndexW,:)=[];

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Sulaymon Eshkabilov
In fact, it is not viable to delete only rows as dpb stated.
Otherwise, if you'd like to remove all elements of specific rows, that can be done relatively easy, e.g.:
TAB(TAB.SampledDate=='Not Collected', :)=[];
  8 个评论
显示 6更早的评论
Stephen23
Stephen23 2021-8-3
Ran in:
"In general, what is the different between these two ways?"
One checks if the table data contains the required text, the other checks if the table data is the same as that text.
"Why is it giving the same output and will they be different outputs if they are used in a different code?"
Just like any functions, they will give different outputs depending on the input data:
A = 'cat in hat';
B = 'hat';
contains(A,B)
ans = logical
1
strcmp(A,B)
ans = logical
0
Only you (as your code's author) can decide which one suits your needs best.
Waleed Nowayti
Waleed Nowayti 2021-8-3
That is amazing! I see the difference and your example is just straight to the point. Thank you so much for explaining!

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by