Trying to create new column which is col1/col2, but function explodes because col 1 and 2 are sometimes 0 or NAN. How do I make the function ignore those?
1 次查看(过去 30 天)
显示 更早的评论
Hello, I have a large data table, 1501x15. I'm trying to create a 16th column which is equal to two columns divided by each other. My code so far is: T.col16=T.col14/t.col12. However, the data sometimes contains zeros in both col14 and col 12, or NaNs. So, the function explodes returning "Warning: Rank deficient, rank = 0, tol = NaN." and returns infinite columns of zeros. How do I make the function ignore the rows which make it explode, putting zeros in the resulting column instead?
0 个评论
回答(1 个)
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!