Sorting table row variables with number and letters
Hello,
I am trying to sort a table with values which looks something like this as an example below, my actual data has hundreds of rows of data.
And I want to make it look like this:
A = struct2table(data); %Data imported as struct and converted to table (50 x 6)
B = A(2,2:end); %Deletion of extra rows and keeping columns with variable names (1 x 5)
arrayB = table2array(B);
TableB = array2table(arrayB.’); % Transposing so variablenames are in rows (5 x 1)
TableB.Properties.RowNames = B.Properties.VariableNames; %Assigning Variable names to rows
TableC = TableB(:,sort(B.Properties.VariableNames));
After running the code I get the error:
Unrecognized variable name ‘abc_0_xyz’.
I’m stuck at this error since the variable is clearly in the table already so something is probably not right.
I’m thinking I need to remove either "_xyz" or "abc_" for the sort to work or use delimiter both of which I don’t know how or what function to use in my case. It’s my first post so apologies in advance if I missed anything. Any help is greatly appreciated
Thanks,Hello,
I am trying to sort a table with values which looks something like this as an example below, my actual data has hundreds of rows of data.
And I want to make it look like this:
A = struct2table(data); %Data imported as struct and converted to table (50 x 6)
B = A(2,2:end); %Deletion of extra rows and keeping columns with variable names (1 x 5)
arrayB = table2array(B);
TableB = array2table(arrayB.’); % Transposing so variablenames are in rows (5 x 1)
TableB.Properties.RowNames = B.Properties.VariableNames; %Assigning Variable names to rows
TableC = TableB(:,sort(B.Properties.VariableNames));
After running the code I get the error:
Unrecognized variable name ‘abc_0_xyz’.
I’m stuck at this error since the variable is clearly in the table already so something is probably not right.
I’m thinking I need to remove either "_xyz" or "abc_" for the sort to work or use delimiter both of which I don’t know how or what function to use in my case. It’s my first post so apologies in advance if I missed anything. Any help is greatly appreciated
Thanks, Hello,
I am trying to sort a table with values which looks something like this as an example below, my actual data has hundreds of rows of data.
And I want to make it look like this:
A = struct2table(data); %Data imported as struct and converted to table (50 x 6)
B = A(2,2:end); %Deletion of extra rows and keeping columns with variable names (1 x 5)
arrayB = table2array(B);
TableB = array2table(arrayB.’); % Transposing so variablenames are in rows (5 x 1)
TableB.Properties.RowNames = B.Properties.VariableNames; %Assigning Variable names to rows
TableC = TableB(:,sort(B.Properties.VariableNames));
After running the code I get the error:
Unrecognized variable name ‘abc_0_xyz’.
I’m stuck at this error since the variable is clearly in the table already so something is probably not right.
I’m thinking I need to remove either "_xyz" or "abc_" for the sort to work or use delimiter both of which I don’t know how or what function to use in my case. It’s my first post so apologies in advance if I missed anything. Any help is greatly appreciated
Thanks, table data sort MATLAB Answers — New Questions