Replace String with a NaN in table
조회 수: 13 (최근 30일)
이전 댓글 표시
Hey guys!
I am challenged with a table, consisting various numbers and a few "'Bad'" cells. I guess they are strings. My goal now is to replace these "Bads" with NaNs.
How do I achieve that the easiest way?
Best regards, Spacey
채택된 답변
Peter Perkins
2015년 3월 24일
It sounds like you imported a file where some of the columns were mostly numbers, but some strings mixed in. Best to avoid getting into the corner that you're in. You might have been able to explicitly say that the column is numeric. You might have been able to use the TreatAsEmpty parameter to readtable (if that's what you used).
Otherwise, if you have variables in the table that are cell arrays but that you want to be numeric, you might need to do one of a couple different things. In general, you need to put numeric things in all the cells and then concatenate the contents to get a numeric vector, but first you'll need to describe exactly what you have.
댓글 수: 0
추가 답변 (3개)
Konstantinos Sofos
2015년 3월 24일
편집: Konstantinos Sofos
2015년 3월 24일
Hi,
" I guess they are strings" ...you cannot open your table or see in the workspace what type are they?
Do you mean something like the following:
>> A = {'xx',5,6,'''',78,'?..'}
A =
'xx' [5] [6] ''' [78] '?..'
>> idx = cellfun(@(x) ischar(x),A)
idx =
1 0 0 1 0 1
>> A(idx)={NaN}
A =
[NaN] [5] [6] [NaN] [78] [NaN]
>> B = cell2mat(A)
B =
NaN 5 6 NaN 78 NaN
>> whos
Name Size Bytes Class Attributes
A 1x6 408 cell
B 1x6 48 double
댓글 수: 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!