How can I add new column in a dataset array but not at the end?
4 views (last 30 days)
Show older comments
I have a dataset array [202x89] and another one [150x97]. I want to Concatenate arrays but they must have the same number of variables and All datasets in the bracketed expression must have the same variable names. The new columns that i want to insert in the first dataset i want to be 'NaN'. That's ok but but i want to specify the position of a new column (to use after all the vertcat function). Can you help me please.
Thanks
0 Comments
Accepted Answer
Peter Perkins
on 17 Jan 2012
Alexis, I am niot 100% sure from your description exactly what you are trying to do. I'm going to assume that you want to create a new dataset that is a vertical concatenation of the first dataset and the second. But since the first has fewer variables, you need to create the missing variables, and you'd like to fill them with NaN.
You mention wanting to insert variables in the first dataset. You can only create a new variables at the end. So if you want to insert new variables in the middle, you need to take two steps: create them at the end, and then use subscripting to rearrange. Given this ...
a = dataset(randn(10,1),randn(10,1),'VarNames',{'W' 'X'});
... you can do something like this ...
a(:,{'Y' 'Z'}) = dataset(NaN(10,1),NaN(10,2));
a = a(:,[1 3:4 2])
... to rearrange. But there may not be any need to do this. Concatenation for dataset works by matching up variable names, and it doesn't matter what order they are in. So you can concatenate these two arrays
a = dataset(randn(10,1),randn(10,1),'VarNames',{'X' 'Y'});
b = dataset(randn(10,1),randn(10,1),'VarNames',{'Y' 'X'});
even though the variables are in a different order.
More Answers (1)
David Young
on 17 Jan 2012
To insert a column of NaNs after column c of matrix A, you could use
Anew = [A(:,1:c) NaN(size(A,1),1) A(:, c+1:end)];
To insert k columns of NaNs after column c, use
Anew = [A(:,1:c) NaN(size(A,1),k) A(:, c+1:end)];
2 Comments
David Young
on 18 Jan 2012
You didn't say that dataset is a class of the Statistics Toolbox. I can't help with that.
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!