vertcat for a number and string

Hi All,
I have to metrices...
1)
SpecialName GenericName
1 457
2 555
3 758
Adding the image of my dataset copied over to excel. The column virtual and Product is giving me hard time for now.
2)
SpecialName GenericName
x NA
y NA
z NA
Now you can see both has the same column name but data type is different. The first one is Number and the 2nd one is string (when i see it shows each wrapped in ' ' hence saying it as string)
Now i want to do vertcat of those two. i trie applyign num2str on 1st one but still vertcat does not work. WHat should i do?

4 个评论

I assume these are cell arrays? Are those column titles actually included in the cell array?
it is typed as dataset, yes when i print the dataset it prints the coulmn title if that is what you meant to ask
In that case I'm not too sure, I never even realised dataset existed as a type, although I see it is listed for possible removal in a future release.
If you have R2014a you should probably use the dataset2table function to convert to a table then you can use table operations for concatenation.
I like that answer, Adam. Put it below as an official answer. Tables are available for R2013b and later.

请先登录,再进行评论。

回答(2 个)

[ num2cell(a); b ]
should work if a and b are your two matrices and the first is a standard numeric array and the second is a cell array.

1 个评论

num2cell is not working , i mean it executes but vertcat fails, do you need any more info from me?

请先登录,再进行评论。

Adam
Adam 2014-9-18
编辑:Adam 2014-9-18
If you have R2013b or later you should probably use the dataset2table function to convert to a table then you can use table operations for concatenation.

类别

帮助中心File Exchange 中查找有关 Data Type Conversion 的更多信息

标签

尚未输入任何标签。

提问:

2014-9-18

编辑:

2014-9-18

Community Treasure Hunt

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

Start Hunting!

Translated by