清空筛选条件
清空筛选条件

How do we eliminated columns in excel file has negative values?

1 次查看（过去 30 天）
ahmed obaid
ahmed obaid 2017-2-8
评论： ahmed obaid 2017-2-9
Dear experiences
i have a data which are stored in an excel file which is consist from thousands of columns, therefore in my data there are some columns completely contain negative values in random order in other words in columns which must be eliminate the complete values in these columns are negative and there is no positive values exist .. i'm thinking to check first value in every column if its negative then eliminate otherwise if >=0 then leave. as in the following image where i need to eliminated columns along with its columns labels..
i would glade thanks any one can find a way to do this process.

请先登录，再回答此问题。

采纳的回答

Guillaume
Guillaume 2017-2-8
To delete at once all the columns for which all the rows are negative:
yourmatrix(:, all(yourmatrix < 0)) = [];
  5 个评论
显示 3更早的评论
Guillaume
Guillaume 2017-2-9
yourtable(:, [false, all(yourtable{:, 2:end} < 0)] = [];
However, better would be to fix the import so that the row labels become row names in the table. To your readtable add the option , 'ReadRowNames', true

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by