MATLAB Answers

How to remove rows in table that have empty values

조회 수: 7(최근 30일)
Rizwan Khan
Rizwan Khan 2021년 9월 23일
댓글: Image Analyst 2021년 9월 23일
I have the following tables with two columns
Look at the second last and third last rows, see how the right column has values []
I want to remove all rows within the table that have that value []
My main objectives is to sort the table by the right column, however, i cannot because it errors "Some cells in X contain non-scalar values and cannot be sorted."
So i'm thinking if i can remove all rows of data that have the values [], then i can sort it.
Please inform how I can do this
'A' 52201554
'B' 2130725
'C' 138307808
'AAC' 1220000
'AAC.U' []
'AAC.WS' []
'AAIC' 121888
  댓글 수: 1
Image Analyst
Image Analyst 2021년 9월 23일
Attach a sample table with empty row(s) in a .mat file with the paperclip icon.

댓글을 달려면 로그인하십시오.

답변(1개)

KSSV
KSSV 2021년 9월 23일
Let T be your table.
idx = ismepty(T.(2)) ;
T(idx,:) = [] ;
  댓글 수: 2
Rizwan Khan
Rizwan Khan 2021년 9월 23일
Dear Sir,
Your code did give me an idea.
when i do isempty(cell2mat(T.(2)(5)) i get true
so if i check the data in row 5 column 2 in the table above, by first converting from cell2mat, i get true
But the problem now is, how can i run that across the complete table without using a for loop.
So when i do the code below i get an error "All contents of the input cell array must be of the same data type."
isempty(cell2mat(T.(2)))

댓글을 달려면 로그인하십시오.

제품


릴리스

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by