Matlab: How to convert matrix columns to a numeric cell array?

12 次查看（过去 30 天）
Renu Kadolkar
Renu Kadolkar 2020-3-5
回答： Srivardhan Gadila 2020-3-13
I have a matrix of size (105201,3).
The structure looks something like:
10100 1119 32
10100 1121 49
10100 2361 120
10100 2362 143
10100 2373 142
I want to convert it to a cell array such that I can perform the following:
emptyIndex = cellfun('isempty',cellArray); %# Find indices of empty cells
cellArray(emptyIndex) = {0}; %# Fill empty cells with 0
employmentOut = cell2mat(cellArray); %# Convert the cell array
The output matrix should have the first 2 columns as categorical values and 3rd as corresponding values:
`1119 1121....
10100 32 49
....
  2 个评论
Bob Thompson
Bob Thompson 2020-3-5
How can you have a matrix of doubles with empty values? Are they NaN? It shouldn't be necessary to convert the array into a cell array to find the nan values.
No matter what, you can convert the array into cells will mat2cell.
Adam Danz
Adam Danz 2020-3-6
To echo what Bob Nbob stated, matrices can have NaN values but not empty or missing values. To replace NaNs with 0s,
M(isnan(M)) = 0;

请先登录，再进行评论。

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

回答（1 个）

Srivardhan Gadila
Srivardhan Gadila 2020-3-13
A matrix can't have an empty value. The whole array itself should be empty.
Therefore from the above mentioned code, the value of emptyIndex would be empty.
If you are having any NaN, inf then find them using isnan & isinf functions.
You can refer to:
  1. How to write the matrix with blank element?
  2. Assign empty value(s) to matrix elements (to delete those elements) fails
  3. empty
  4. Empty Arrays

类别

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

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by