How to deal with repeated data in a column of a table
2 次查看(过去 30 天)
显示 更早的评论
Hey,
I'm currently trying to process a table. What I want is to extract a sequence from a column of it. Before I used unique but apparently the result wasn't what I intended for.
An example of the table could be like below. I want to extract [22 24 22] for vid 59. However, unique only gave me [22 24], which is not what I want. So, I hope I've explained my question well. Appreciate your advice on this!!
![TableC.PNG](https://www.mathworks.com/matlabcentral/answers/uploaded_files/245705/TableC.png)
0 个评论
采纳的回答
Cyrus Tirband
2019-10-30
编辑:Cyrus Tirband
2019-10-30
It sounds like you're looking to remove repeating elements that are adjecent. If that is the case, you can test your array for differences between each element and remove the parts where the difference is 0.
If your array is named A, then:
A(diff(A)==0) = []
8 个评论
Cyrus Tirband
2019-11-12
编辑:Cyrus Tirband
2019-11-12
Hi Qiao,
You can use a similar approach. In this case, you have two requirements for the elements that you want to remove. Not only must the finite difference diff(A) be equal to zero (no repeating elements), the second finite difference, diff(diff(A)) must also be equal to zero (no change in slope). So, and(diff(A) ==0, diff(diff(A)) == 0) is the set that must be removed. Using de morgan's law this can be written a bit more succinctly as ~or(diff(A), diff(diff(A))).
Of course, you always want the first index to be included, so you need to enter that one manually as a 1, since diff(diff(A)) will be one index shorter.
In code:
A = [22; 22; 22; 24; 24; 24; 22; 22; 22];
A(~or(diff(A),[1; diff(diff(A))])) = []
A =
22
22
24
24
22
22
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!