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?

[Adam]

I assume these are cell arrays? Are those column titles actually included in the cell array?

[Neesha]

it is typed as dataset, yes when i print the dataset it prints the coulmn title if that is what you meant to ask

[Adam]

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.

[Image Analyst]

I like that answer, Adam. Put it below as an official answer. Tables are available for R2013b and later.

Answer 1

[Adam]

[ 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.

[Neesha]

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

Answer 2

[Adam]

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.