Clear Filters
Clear Filters

I have 135987 * 69 table. I want to convert all negative values to NaN. Any Suggestions?

6 views (last 30 days)
Devansh Patel
Devansh Patel on 9 Jul 2018
Answered: Guillaume on 9 Jul 2018
I have 135987 * 69 table. I want to convert all negative values to NaN. Any Suggestions?

Sign in to answer this question.

Answers (1)

Guillaume
Guillaume on 9 Jul 2018
tablecontent = yourtable{:, :};
tablecontent(tablecontent < 0) = NaN;
yourtable{:, :} = tablecontent;
This assumes that every variable in the table is numeric and scalar.

Categories

Find more on Tables in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!