Hi, Attached a data file that I am working on. I want to replace N/A cells with -999. I also want to find empty cells (they appear as "" and NaN values or in the data file depending on the type of the column and replace them with -998. How can I identify these codes and replace them in a table? your help is greatly appreciated

finding and replacing problematic cells in a table

조회 수: 3 (최근 30일)

이전 댓글 표시

Wesso 2021년 1월 1일

0
링크

이 질문에 대한 바로 가기 링크

https://kr.mathworks.com/matlabcentral/answers/706563-finding-and-replacing-problematic-cells-in-a-table

답변: Cris LaPierre 2021년 1월 1일

matlab.zip

Hi,

Attached a data file that I am working on. I want to replace N/A cells with -999. I also want to find empty cells (they appear as "" and NaN values or <undefined> in the data file depending on the type of the column and replace them with -998. How can I identify these codes and replace them in a table? your help is greatly appreciated