How to obtain length of number of columns which has data

Question

Damith 2015-3-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/189817-how-to-obtain-length-of-number-of-columns-which-has-data

评论： dpb 2015-3-26

采纳的回答： Image Analyst

Hi,

I need to loop though the columns in " mTot " and select the columns which has data (for example column 1 and 2).

If I do

length(mTot)
ans
51681

But, I need to obtain the answer as 2 (becuase only column 1 and 2 has data). Can somebody suggest me a method?

Thanks in advance.

4 个评论
显示 2更早的评论隐藏 2更早的评论

James Tursa 2015-3-25

sum(~all( mTot == 0, 1 )) ?

dpb 2015-3-25

See below; looping sometimes is the right answer. How have you ensured there's nothing past the first N months and it's not the missing values problem we were discussing in the original thread? Simply iterate over the columns and test for each; if you have somehow got it where they are all contiguous then after the first false result use break to terminate the loop.

请先登录，再进行评论。

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

Answer 1

Image Analyst 2015-3-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/189817-how-to-obtain-length-of-number-of-columns-which-has-data#answer_172747

Sum the columns and look for zero

columnSums = sum(mTot, 1);
% Find column numbers that are not all zeros
colIndexesWithData = find(columnsSums ~= 0);

This can even handle columns with zeros in between other columns, in case that ever happens.

If you want to find the very last column that has data in it, get the last element.

lastColWithData = colIndexesWithData (end);

2 个评论
显示无隐藏无

Image Analyst 2015-3-25

By the way, length is the max of the two dimensions, i.e. the larger of the number of rows or the number of columns.

Damith 2015-3-25

Thanks.

请先登录，再进行评论。

Answer 2

dpb 2015-3-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/189817-how-to-obtain-length-of-number-of-columns-which-has-data#answer_172748

IA has the right idea but coming in from the cold doesn't know the full picture... :)

As I pointed out in the discussion accompanying the code that I wrote from whence the above comes, the NaN initialization option gives you the columns that are missing data or it's simply remove the zero columns from the array (albeit you do need to keep track of which is which since the columns represent month of year and if there's a case where there's a missing other than trailing your index otherwise will be off).

Probably the most generic thing is to simply loop over the full array and check that any(:,colIdx) is True, if so, then write that column, if False skip it. This keeps the indices and the month in synch.