how to find an empty row in a table

Question

tiwwexx 2019-6-21

评论： Gabor 2021-3-4

Hello, I'm trying to get rid of a certain row in a single column table that only has a []. for example if I have a table.

column 1

row1 | 'hey' |

row2 | 'hey' |

row3 | [ ] |

how can I get it to be

column 1

row1 | 'hey' |

row2 | 'hey' |

I have a code that works but for larger tables it's extreemely slow.

yee = "original table";
yee1=table;
for n=1:numel(yee)
    if isa(yee{n},'char')
        bus=yee(n);
        yee1 = [yee1 ; bus];
    end
end

I feel like there's a lot more efficient ways to do this. Thanks for any help!

Answer 1

Matt J 2019-6-21

编辑：Matt J 2019-6-21

loc=cellfun('isempty', yourTable{:,'column1'} );
yourTable(loc,:)=[]

Gabor 2021-3-4

编辑：Gabor 2021-3-4

It is a table and a column contains numbers instead of strings and this is the error I get:

Error using cellfun

cellfun works only on cells.

Gabor 2021-3-4

For me it works if I convert the table to cell and I use the column number in the script:

yourTable2=table2cell(yourTable);

loc=cellfun('isempty', yourTable2{:,1} );

I hope it helps someone.

Answer 2

Guillaume 2019-6-21

Even simpler, and probably faster, use the table tools (rather than cell array tools):

yourtable = rmmissing(yourtable)

Matt J 2019-6-21

编辑：Matt J 2019-6-21

Unfortunately, rmmising doesn't seem to recognize the empty matrix [] as a missing data marker, so the table would have to be reformatted.