How to access a string array and use the contents as titles within array2table
2 views (last 30 days)
Show older comments
Fede C 2018 London
on 28 Nov 2018
Commented: Fede C 2018 London
on 29 Nov 2018
Meancoh is an 24x6 ordinary array.
meancoh=zeros(TT2,n1);
I've created a 6x1 string array called storehere, that, if accessed, contains the following:
"mean of bootstrapped coherence between X and Y"
"mean of bootstrapped coherence between X and Y"
"mean of bootstrapped coherence between X and Y"
"mean of bootstrapped coherence between X and Y"
"mean of bootstrapped coherence between X and Y"
"mean of bootstrapped coherence between X and Y"
Now, I think I ought to use array2table to assign the 6 rows above to each of the 6 columns of data in meancoh. I've tried but I don't seem to get it right.
Any suggestions?
P.S.
I asked a question relating to a previous problem (i.e. how to create storehere), which I cancelled once I realised I was just missing a bracket. I didn't realise someone had already commented-I saw an email to that effect just after, with a comment from 'the cyclist'. I apologise, as I didn't see someone had already made an effort to answer. The lines below work. I was missing a smooth bracket in the loop.
Now I have a string array called nameVar that contains this:
x y
x v
x z
y v
y z
v z
Fine. Now I need to create 6x1 string array that in which each row says ‘mean of bootstrapped coherence between (:) and (:).
This doesn’t work:
storehere=strings(Nrowscombinations,1);
for kkk=1:length(Nrowscombinations)
storehere(:)=strcat({'mean of bootstrapped coherence between '}, nameVar(kkk,1),{ ' and ' }, nameVar(kkk,2));
end
0 Comments
Accepted Answer
Guillaume
on 28 Nov 2018
I would create your storehere array, this way:
storehere = compose("mean of bootstrapped coherence between %s and %s", nchoosek(["X", "Y", "V", "Z"], 2))
However, there is absolutely no way that you can use these strings as variable names in a table. Table variable names, like all matlab variable names have some restrictions on which characters are allowed. In particular, spaces are not allowed.
You could use matlab.lang.makeValidName to make valid variable names out of your string array. It will remove the spaces, or you could replace the spaces by _:
array2table(meancoh, 'VariableNames', matlab.lang.makeValidName(storehere))
%or
array2table(meancoh, 'VariableNames', strrep(storehere, ' ', '_'))
However, I would recommend that you use shorter variable names altogether.
4 Comments
Guillaume
on 28 Nov 2018
I believe I've shown exactly how to do it in my answer, with the nchoosek(["X", "Y", "V", "Z"], 2)).
It would be the same here:
nameVar = nchoosek(headers, 2); %all done
Note that even if you used your original code, that loop is completely pointless. You could have done:
combinations =nchoosek(1:size(data, 2), 2);
nameVar = headers(combinations);
More Answers (1)
Peter Perkins
on 28 Nov 2018
It's not really clear what you are doing and what went wrong. If your matrix of data has 6 columns, then array2table will accept a 6-element string array or cell array of char rows as the variable names. And you'r problem is how to create those names?
For one thing, the names have to be valid MATLAB identifiers, and unique. I'm gonna suggest that you name the variables "x_y", "x_v", etc., and set the VariableDescriptions property of the table to "mean of bootstrapped coherence between x and y", etc. I imagine something like this
>> namevar = ["x" "y"; "x" "z"; "y" "z"]
namevar =
3×2 string array
"x" "y"
"x" "z"
"y" "z"
>> "mean of bootstrapped coherence between " + namevar(:,1) + " and " + namevar(:,2)
ans =
3×1 string array
"mean of bootstrapped coherence between x and y"
"mean of bootstrapped coherence between x and z"
"mean of bootstrapped coherence between y and z"
is what you need.
See Also
Categories
Find more on Loops and Conditional Statements in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!