[Tex/LaTex] Postprocessing pgfplotstable results using siunitx

pgfplotspgfplotstablesiunitx

I am trying to use the \num command from siunitx inside a table made with pgfplotstable, because I need the format given by siunitx with \sisetup{scientific-notation = true} and all the advantages of pgfplotstable. My base code is

\documentclass{article}
\usepackage{pgfplots}
\usepackage{pgfplotstable}
\usepackage{siunitx}
\pgfplotsset{compat=1.8}
\usepackage{booktabs}
\usepackage{colortbl}
\begin{document}
 \sisetup{scientific-notation = true}%

\vspace{3ex}
\pgfplotstabletypeset[col sep=comma,trim cells=true,
% dec sep align=S,
every even row/.style={
before row={\rowcolor[gray]{0.9}}},
every head row/.style={before row=\toprule, after row=\midrule},
 every last row/.style={after row=\bottomrule},
%%
columns/Variable/.style={string type, column name=Quantity},
%
columns/error/.style={numeric type,dec sep align}
]{
Variable,           error,  IS value,   custom units value, 
mass error,         6.124218320291899e-16,  {}, {}  
omega error,        {}, {}, {}
J error,            0.387621076355607,  {}, {}
%Mb error           Indeterminate,  {}, {}, {}
Mbnew error,        0.21146255277063972,    {}, {}
Mp error,           0.21146255277063972,    {}, {}
Ebind error,        0.6604389526233243, {}, {}
}
\end{document}

enter image description here

but when I try to postprocess the numeric data with this

 \sisetup{scientific-notation = true}%

\pgfplotstabletypeset[col sep=comma,trim cells=true,
every even row/.style={
before row={\rowcolor[gray]{0.9}}},
every head row/.style={before row=\toprule, after row=\midrule},
 every last row/.style={after row=\bottomrule},
%%
columns/Variable/.style={string type, column name=Quantity},
%
columns/error/.style={numeric type,%dec sep align,
%preproc cell content/.append style={column type=S},
postproc cell content/.append style={
/pgfplots/table/@cell content/.add={$\num{}{}$}},
%postproc cell content/.append style={
%/pgfplots/table/dec sep align={@}
%},
     %postproc cell content/.append style={dec sep align=true
 %}
%}
    }
]{
Variable,           error,  IS value,   custom units value  
mass error,         6.124218320291899e-16,  {}, {}  
omega error,        {}, {}, {}
J error,            0.387621076355607,  {}, {}
%Mb error,          Indeterminate,  {}, {}, {}
Mbnew error,        0.21146255277063972,    {}, {}
Mp error,           0.01146255277063972,    {}, {}
Ebind error,        0.6604389526233243, {}, {}
}
\num{0.001}
\end{document}

enter image description here

the numbers are clearly not processed by \num{} and I have to comment the dec sep align option to avoid errors. Any idea on how to combine these two tools? The reason to need num{} is that the sci option of pgfplotstable gives ugly 10^0 terms, as can be seen in

 \pgfplotstabletypeset[col sep=comma,trim cells=true,
 every even row/.style={
 before row={\rowcolor[gray]{0.9}}},
 every head row/.style={before row=\toprule, after row=\midrule},
 every last row/.style={after row=\bottomrule},
 %%
 columns/Variable/.style={string type,  column name=Quantity},
 %
 columns/error/.style={numeric type,dec sep align,sci,zerofill
 }
 ]{
 Variable,          error,  IS value,   custom units value  
 mass error,        6.124218320291899e-16,  {}, {}  
 Ebind error,       0.6604389526233243, {}, {}
 Ebind2 error,      1.6604389526233243, {}, {}
 }

enter image description here

and the default numeric format is not able to convert 0.1234 into 1.234, so the numbers are not homogeneously formatted. What I need would look like that the following:
enter image description here

Best Answer

You don't need the siunitx syntax. pgfplotstable also works with the pgfmath module and has a very strong number formatting ability. You can find it pgfplotstable manual for more information and it works well with siunitx. Example,

\documentclass{article}
\usepackage{pgfplotstable,siunitx,booktabs,colortbl}
\begin{document}


\pgfplotstabletypeset[col sep=comma,trim cells=true,
every even row/.style={
before row={\rowcolor[gray]{0.9}}},
every head row/.style={before row=\toprule, after row=\midrule},
every last row/.style={after row=\bottomrule},
columns/Variable/.style={string type, column name=Quantity},
columns/error/.style={numeric type,sci,precision=2,zerofill,dec sep align}
]{
Variable,            error,   IS value,    custom 
mass error,          6.124218320291899e-16,    {},  {}  
omega error,                              ,    {},  {}
J error,             0.387621076355607    ,    {},  {}
Mbnew error,         0.21146255277063972  ,    {},  {}
Mp error,            0.01146255277063972  ,    {},  {}
Ebind error,         0.6604389526233243   ,    {},  {}
}

\end{document}

enter image description here

After the edit, it is NOT the sci but std number format you are looking for. Let me reemphasize that you should not remove zero exponent from scientific notation. Then the example becomes

\documentclass{article}
\usepackage{pgfplotstable,booktabs,colortbl}

\begin{document}

\pgfplotstabletypeset[col sep=comma,trim cells=true,
every even row/.style={before row={\rowcolor[gray]{0.9}}},
every head row/.style={before row=\toprule, after row=\midrule},
every last row/.style={after row=\bottomrule},
columns/Variable/.style={string type, column name=Quantity},
columns/error/.append style={std=0,dec sep align,zerofill},
]{
Variable,            error       ,   IS value,   custom 
mass error,          6.124218320291899e-16,         {},   {}  
omega error,                              ,         {},   {}
J error,             1.387621076355607    ,         {},   {}
Mbnew error,         2.1146255277063972   ,         {},   {}
Mp error,            0.01146255277063972  ,         {},   {}
Ebind error,         0.6604389526233243   ,         {},   {}
}

\end{document}

enter image description here

To be honest, if this is going to be a long and involved table, you would be torturing the reader by omitting the exponent and having the ragged look.

Answer to the updated question

The special class file uses:

\DeclareMathSymbol{\Omega}{\mathalpha}{letters}{"0A}
\DeclareMathSymbol{\varOmega}{\mathalpha}{operators}{"0A}

Then \Omega is italics by default and \varOmega upright. Package siunitx uses \upOmega, if it is available to initialize the symbol for math-ohm, otherwise \Omega is used as \text{$\Omega$}, which results in an italics Ω. Whereas \mathrm{\Omega} would have given an upright Ω.

Since the upright ohm symbol is available as \varOmega, the macro \upOmega can be provided easily for package siunitx:

\documentclass{article}
\DeclareMathSymbol{\Omega}{\mathalpha}{letters}{"0A}% italics
\DeclareMathSymbol{\varOmega}{\mathalpha}{operators}{"0A}% upright
\providecommand*{\upOmega}{\varOmega}% for siunitx
\usepackage[binary-units=true]{siunitx}
\sisetup{locale = DE}

\begin{document}
  \SI{1,09715247}{\micro\ohm}
\end{document}

Answer to the first version of the question

I get an italic \mu. Probably you want to have \micro instead. The \ohm is upright:

\documentclass{article}
\usepackage[binary-units=true]{siunitx}
\sisetup{locale = DE}
\begin{document}
\si{\mu\ohm} vs.\@ \si{\micro\ohm}
\end{document}

[Tex/LaTex] PGFPlotsTable formatting problems

I see that you have suffered a great deal of frustration. And I am the correct person to receive it as I wrote pgfplotstable, so let me try to accept and ease some of the frustration, and try to help you with it.

Since you stated lots of questions, probably originating in your frustration, I would like to address them:

Are styles defined by columns and can be altered cell by cell?

Hm... partially: the vision is to configure a common appearance for an entire column. Cell-by-cell adoptions are almost not supported, except for some relatively crude mechanisms. This is one of the sources of frustration, I guess.
header/row styles does not care about fixed and precision keys, right?

Yes, correct, as row-based "styles allow to configure the final table code after any cell contents have been assigned."

Consequently, row-based styles do not even allow you to configure "use boldface for my cells". They operate on the entire row, no longer on cells.
Is what I ask possible? If so, how do I achieve it?

Yes, see below.
..."And I could not set bold format"

bold face format is something that beats me whenever I work with numerical tables... and that is probably the reason why it beats you as well (namely because I did still did not offer suitable styles).

The boldface styles for math fonts seem to require the following items
- they need to be given inside of the math mode, i.e. inside of $ and $ which makes it difficult to handle within pgfplotstable
- using \bf is relatively simple, but AFAIK it is discouraged
- \mathbf{...} also requires bracing constructs which is also not really simple to add around existing values (or perhaps pgfplotstable is not really helping here).
I should think about better solutions here eventually.
[...] It looks like the function add is called twice on the integer part and then twice on the decimal part of my number (WTH, this explains why my outputs are so difficult to understand). Is it a bug?

I believe it is a bug, yes. I can reproduce lots of problems with the decimal part splitting. In fact, my solution below excludes dec sep align (and also excludes what you wanted to address with it)

Here is what I came up with. Your table has the requirement that it uses column names which should be formatted as numbers on their own (something which needs adoptions as pgfplotstable assumes plain column names).

As mentioned above, I also failed to integrate dec sep align, something that I should look into eventually. Apparently, it fails to split columns correctly somewhere.

\documentclass{standalone}
\usepackage{array}
\usepackage{booktabs}
\usepackage{colortbl}
\usepackage{pgfplotstable}
\begin{document}
\pgfplotstabletypeset[
    col sep=semicolon,
    font=\footnotesize,
    fixed,precision=2,
    %dec sep align,
    fonts by sign={}{\color{red}},
    every first column/.style={
        fixed zerofill, precision=2,
        postproc cell content/.append style={
            @cell content/.add={$\bf}{$}%
        }%
    },
    assign column name/.style={%
        /pgfplots/table/column name={$\bf \pgfmathprintnumber[fixed zerofill,precision=2]{#1}$}%
    },%
    columns/0.xy/.style={%
        assign column name/.code=,
        column name=\textbf{ABC},
    },
    %debug,
]{
0.xy;0.00;0.01;0.02;0.03;0.04;0.05;0.06;0.07;0.08;0.09
0.00;-1.1;-0.5;-0.326;-0.3;-0.2;-0.1;0.0;0.0;0.0;0.1
0.10;0.1;0.1;0.1;0.2;0.2;0.2;0.2;0.2;0.2;0.2
0.20;0.2;0.3;0.3;0.3;0.3;0.3;0.3;0.3;0.3;0.3
0.30;0.3;0.3;0.3;0.3;0.4;0.4;0.4;0.4;0.4;0.4
0.40;0.4;0.4;0.4;0.4;0.4;0.4;0.4;0.4;0.4;0.4
0.50;0.4;0.4;0.5;0.5;0.5;0.5;0.5;0.5;0.5;0.5
0.60;0.5;0.5;0.5;0.5;0.5;0.5;0.5;0.5;0.5;0.5
0.70;0.5;0.6;0.6;0.6;0.6;0.6;0.6;0.6;0.6;0.6
0.80;0.6;0.7;0.7;0.7;0.7;0.7;0.7;0.7;0.8;0.8
0.90;0.8;0.8;0.9;0.9;1.0;1.1;1.2;1.4;1.7;1.9
};
\end{document}

My personal recommendation would be to use fixed zerofill for all columns instead of dec sep align; it results in

Perhaps you are also interested to see your example with row/col rules, feel free to use or to ignore it:

\documentclass{standalone}
\usepackage{array}
\usepackage{booktabs}
\usepackage{colortbl}
\usepackage{pgfplotstable}
\begin{document}
\pgfplotstabletypeset[
    col sep=semicolon,
    font=\footnotesize,
    fixed, precision=2,
    fixed zerofill,
    %dec sep align,
    fonts by sign={}{\color{red}},
    every first column/.style={
        fixed,fixed zerofill, precision=2,
        postproc cell content/.append style={
            %@cell content/.add={$\bf}{$}%
        }%
    },
    assign column name/.style={%
    %   /pgfplots/table/column name={$\pgfmathprintnumber[fixed,fixed zerofill,precision=2]{#1}$}%
    },%
    columns/0.xy/.style={%
        assign column name/.code=,
        column name=ABC,
        column type=c|,
    },
    every head row/.style={
        before row=\toprule,after row=\midrule},
    every last row/.style={
        after row=\bottomrule},
    %debug,
]{
0.xy;0.00;0.01;0.02;0.03;0.04;0.05;0.06;0.07;0.08;0.09
0.00;-1.1;-0.5;-0.326;-0.3;-0.2;-0.1;0.0;0.0;0.0;0.1
0.10;0.1;0.1;0.1;0.2;0.2;0.2;0.2;0.2;0.2;0.2
0.20;0.2;0.3;0.3;0.3;0.3;0.3;0.3;0.3;0.3;0.3
0.30;0.3;0.3;0.3;0.3;0.4;0.4;0.4;0.4;0.4;0.4
0.40;0.4;0.4;0.4;0.4;0.4;0.4;0.4;0.4;0.4;0.4
0.50;0.4;0.4;0.5;0.5;0.5;0.5;0.5;0.5;0.5;0.5
0.60;0.5;0.5;0.5;0.5;0.5;0.5;0.5;0.5;0.5;0.5
0.70;0.5;0.6;0.6;0.6;0.6;0.6;0.6;0.6;0.6;0.6
0.80;0.6;0.7;0.7;0.7;0.7;0.7;0.7;0.7;0.8;0.8
0.90;0.8;0.8;0.9;0.9;1.0;1.1;1.2;1.4;1.7;1.9
};
\end{document}

I think I have showed some effort to solve my problem. I just get no answer to my post even after starting a bounty. Is my request unfeasible?

When I wrote pgfplotstable, I had relatively special requirements in mind for which I tailored it. In addition, I managed to extend the use-cases to get a relatively powerful tool. I fear that you encountered a use-case which has no natural fit into the offered styling/customization rules. So, perhaps we have to state: "it is unfeasible with pgfplotstable unless one has lots of time, expert knowledge, and love for a tool which does not fit right-away".

Best Answer

Related Solutions

[Tex/LaTex] Using siunitx, \ohm results in an italic Omega

Answer to the updated question

Answer to the first version of the question

[Tex/LaTex] PGFPlotsTable formatting problems

Related Question