How to Keep Rows and Columns headers when applying matrix Operation in matlab?

1 次查看（过去 30 天）

显示更早的评论

ahmed obaid 2017-1-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/319440-how-to-keep-rows-and-columns-headers-when-applying-matrix-operation-in-matlab

评论： Image Analyst 2017-1-8

采纳的回答： Image Analyst

在 MATLAB Online 中打开

dear experienced:

I have dataset stored in matlab, which contain 100+ rows (instances) and 20 columns (features), i have read data used

A= xlsread(filename);

when i need to apply such operation like :

Anorm =normc(A) [ normalized matrix of original matrix A]

then when i write normalized matrix, i would to keep the rows and columns headers as its in original matrix, following image just show an example used to explain my instances names and variable names.

My question: how we can apply such previous functions and keep rows and columns headers of matrix?

example of input .. and output matrix ..

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

Image Analyst 2017-1-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/319440-how-to-keep-rows-and-columns-headers-when-applying-matrix-operation-in-matlab#answer_249724

That is not a dataset variable. num is a double matrix, and txt and raw are cell arrays.

You can transpose any of them. But what does it mean to compute the distance transform of a cell array of strings? Or of a cell array?

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

ahmed obaid 2017-1-8

编辑：ahmed obaid 2017-1-8

excellent, its work very fine .. only one doubt please: is this code normalize vectors in independent way? in other words max value is calculated over all matrix or independent for each vector ?

Image Analyst 2017-1-8

It looks over the entire 2-D matrix and finds the min and max, then sets the min to 0, the max to 1, and everything in between is scaled linearly. It does not find minima and maxima on a row-by-row or column-by-column basis. For that, you'd have to call mat2gray with just one row or column and loop over rows or columns.

请先登录，再进行评论。