清空筛选条件
清空筛选条件

if condition finding same numbers in consecutive rows

3 次查看（过去 30 天）
AA
AA 2015-3-13
编辑： AA 2015-3-14
Hi guys I have a table with 120 rows and 5 columns. I want an if condition: if the table contains at least two consecutive rows in columns 2,3,4 and 5 which have the same number then write similar table, else do nothing.
Thanks for your help
  1 个评论
Jan
Jan 2015-3-13
What exactly is a "table"? On paper, Excel-File, csv-file, matrix in Matlab, a table object? Does "write a similiar table" belong to the problem and if so, what exactly is "similar"?

请先登录，再进行评论。

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

回答（3 个）

Chad Greene
Chad Greene 2015-3-13
You can use diff.
x = [4 5 2 17 17 3 4 2 2 4];
ConsecutiveNumbersStartAt = find(diff(x)==0)
Jim Hokanson
Jim Hokanson 2015-3-13
编辑：Jim Hokanson 2015-3-13
sum the differences, but make sure to take the absolute value so that you don't get positives and negatives that cancel out
find(sum(abs(diff(x,1,1)))==0)
Chad Greene
Chad Greene 2015-3-13
You can use the index outputs of unique with the 'rows' option. That'll give you indices of all the unique rows. Then the redundant rows are what's left over.
  1 个评论
AA
AA 2015-3-14
编辑：AA 2015-3-14
I tried it but it is not what i wanted. Consider the following numbers
2 7 6 7 4 3 7 8 8
5 7 7 7 4 5 7 8 3
3 3 3 3 3 3 3 3 3
I want to find the last row where all the values across all columns are the same, i.e. lots of 3s. Plz help

请先登录，再进行评论。

类别

在 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