Can I add units to the table?

Can I add units to the variables in the table? I have searched for information and I could not find anything, it can only be done in numbers ...please help

[Matthew Anderson]

Agree, super annoying that when you put units into a table - they aren't displayed.

[Lorenzo Chiaverini]

Idem, it would be great if they were displayed as you showed

Answer 1

[Raj]

"Can I add units to the variables in the table?" Yes you can. You can specify units for each variable in the table by modifying the table property,

% |VariableUnits|. 

Specify the variable units as a cell array of character vectors.

Something like this:

table (W,T,Pe,P)
T.Properties.VariableUnits = {'Rad/S','NM','N','N'}; % what I could make out from your picture. Please correct if wrong.

Or Do you want the units to get displayed on your table? Please be clear.

[Diego Guarachi]

END=[Qt Ht Hbt Wt Tt Pet Pt Nt NPSHdt];

names={'QCau','Hpump','Hsystem','W','T','Pe','P','N','NPSHd'};
T = array2table(END,'VariableNames',names);
T.Properties.VariableUnits = {'m3/s','m','m','rad/s','N*m','W','W','%','m'};
disp(T)

Should I implement it like that? It did not work..

[Raj]

That's what i asked. The units have got defined. They don't get displayed by default here. If you open the table in workspace, the first row will have a drop down option where you will be able to see the units for each variable as you have defined. Or try using

summary(T)

You'll be able to see the defined units.

[Shan Alan David]

I have a similar question to this. I am trying to print the units next to the values in the table.

[Walter Roberson]

table() objects are not designed for display purposes. There is no facility to format the entries in custom ways, and there is no facility to display units along side the entries.

[Andreas Lobinger]

Is there a facility to deal with multiline VariableNames? Then one could do Units in the second line manually. Or, what actually is the infrastructure to display tables?

[Walter Roberson]

>> t = table((1:5).', 'VariableNames', {sprintf('Depth\n[mm]')})

t =

5×1 table

Depth↵[mm]

__________

1

2

3

4

5

That ↵ character is literally what is output: the code specifically searches for newline characters and replaces them with that, and it specifically replaces carriage return characters with ←

The "actually" infrastructure to display tables is the code in toolbox/matlab/datatypes/tabular/@tabular/disp.m . In R2020b look at line 75:

    % Replace LF with "knuckle" tab with "arrow", and CR with "backarrow".
    % This also truncates long lines, but is irrelevant here.
    % Replaces hyperlinks with no display text with ''.
    for iv = 1:numel(varNames)
        varNames(iv) = matlab.internal.display.truncateLine(varNames(iv),10000);
    end

The truncateLine call is the one that does the replacement.

Is there a facility to deal with multiline VariableNames: Yes, the facility explicitly converts them to not be multi-line.

[Andreas Lobinger]

I see - and thanks for the long explaination. Can you provide a "why" here? I'd assume a lot of researchers want to put units in tables - and adding to the variable name eats up screen space, so a second line looks like the natural solution.

[Walter Roberson]

table() are not designed for presentation purposes. Report Generator has facilities for better output of tables.

That said, it would seem to me to be a small thing to add the units or the Variable Description information (which might be the original names of the variables.) It could even be made into properties as to whether to display them or not. I don't know why Mathworks has not done this.

table() could also benefit from a per-variable format specification... among other things.

Answer 2

[KSSV]

It is not allowed...may be you can use something like this:

varNames = {'Name', 'Age_in_Years'} ; 
varTypes = {'string','double'};
s = {'Tom' ; 'Dick' ; 'Hary'} ; 
a = [20 ;21; 24] ;
T = table(s,a) ;
T.Properties.VariableNames = varNames