[Tex/LaTex] Double row heading in pgfplotstable

pgfplotstable

Good day all!
I store tables on CSV files and use pgfplotstable package to call the files. This works fine but I have a challenge. I need to bring the units in bracket (i.e (MeV) and (mb/MeV/sr) e.t.c.) to the next line so that I'll have two lines dedicated to the head row and the width of the coulumns does not get too large. I need someone to help me out! Please find below an excerpt of my latex code. Thanks in advance…

\begin{table}
\caption{\label{tab:knockho3}As in table~\ref{tab:knockho1} but for complementary angles of \mbox{$60^\circ - 120^\circ$}.} 
\centering
\resizebox{\columnwidth}{!}{%
\pgfplotstabletypeset[col sep=comma,
    columns/Energy (MeV)/.style={string type},
    columns/Experiment (mb/MeV/sr)/.style={string type},
    columns/Error (mb/MeV/sr)/.style={string type},
    columns/Simulation (mb/MeV/sr)/.style={string type},
    every head row/.style={
        before row=\toprule,
        after row=\midrule},
    every last row/.style={after row=\bottomrule}
    ]{Tables/knockho3.csv}%
}
\end{table}

Best Answer

Answer the Unanswered....

You can either enforce a line break in the header cells via various boxes or just use another row dedicated for the units. A quick example with made-up data and units(hopefully I got the right ones).

\documentclass{article}
\usepackage{pgfplotstable,booktabs,siunitx,array}
\sisetup{per-mode=symbol}
\pgfplotsset{compat=1.13}

\begin{document}
\begin{table}
\caption{Complementary angles of $60^\circ - 120^\circ$.}
\centering
\pgfplotstabletypeset[%col sep=comma,
    header=false,
    columns={[index]0,[index]1,[index]2,[index]3},
    every col no 0/.style={column name=Energy},
    every col no 1/.style={column name=Experiment},
    every col no 2/.style={column name=Error},
    every col no 3/.style={column name=Simulation},
    every head row/.append style={
        before row=\toprule,
        after row/.add={}{%
        \arraybackslash%
        [\si{\mega\electronvolt}]%
        & {[\si{\milli\barn\per\mega\electronvolt\per\steradian}]}%
        & {[\si{\milli\barn\per\mega\electronvolt\per\steradian}]}%
        & {[\si{\milli\barn\per\mega\electronvolt\per\steradian}]}\\ \midrule
        }
    },
    every last row/.style={after row=\bottomrule}
    ]{
1 2 3 4
5 6 7 8
9 10 11 12
}%

\end{table}
\end{document}

enter image description here

Related Solutions

[Tex/LaTex] Pgfplotstable without headings row

Starting with version 1.6 of PGFPlots (I think), a new key output empty row has become available that suppresses printing of a row. This can be used in your style:

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

\begin{document}
\pgfplotstabletypeset[
    col sep=&, header=false,
    every head row/.style={ 
        output empty row,
        before row={%
            \toprule
            Facteurs & \multicolumn{5}{c}{Niveaux}\\
        }
    },
    every last row/.style={
        after row=\bottomrule
    },
    display columns/0/.style={string type}
]
{%
\pgfutilensuremath{\chi} & 8 & 11 & 14 & &
5 & 8 & 11 & 14 & 45 & 2.456
q & 8 & 11 & 14 & & 3
x & 8 & 11 & 14 & 5612345 & 4
b & 8 & 11 & 14 & & 5
}
\end{document}

If you're using an earlier version and can't / don't want to update, here's a slightly brutish workaround. You can add the code

\makeatletter
\pgfplotsset{
    /pgfplots/table/omit header/.style={%
        /pgfplots/table/typeset cell/.append code={%
            \ifnum\c@pgfplotstable@rowindex=-1
                \pgfkeyslet{/pgfplots/table/@cell content}\pgfutil@empty%
            \fi
        }
    }
}
\makeatother

in your preamble, which makes a style omit header row available. If you use that key in \pgfplotstable, the output routine for each table cell will be amended with a check whether we're in row number -1 (the header row), and if we are, no output is generated.

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


\makeatletter
\pgfplotsset{
    /pgfplots/table/omit header/.style={%
        /pgfplots/table/typeset cell/.append code={%
            \ifnum\c@pgfplotstable@rowindex=-1
                \pgfkeyslet{/pgfplots/table/@cell content}\pgfutil@empty%
            \fi
        }
    }
}
\makeatother

\begin{document}
\pgfplotstabletypeset[
    col sep=&,
    header=false,
    every head row/.style={
        before row={%
            \toprule
            Facteurs & \multicolumn{5}{c}{Niveaux}\\
        }
    },
    every last row/.style={
        after row=\bottomrule
    },
    display columns/0/.style={string type},
    omit header
]
{%
\pgfutilensuremath{\chi} & 8 & 11 & 14 & &
5 & 8 & 11 & 14 & 45 & 2.456
q & 8 & 11 & 14 & & 3
x & 8 & 11 & 14 & 5612345 & 4
b & 8 & 11 & 14 & & 5
}
\end{document}

[Tex/LaTex] pgfplotstable manage strings and values

As Jake noted, it is the notorious CSV regexp problem of finding which space is escaped which is used for delimiters etc. So if you want spaces to be respected then use something else for delimiter. But make sure you add trim cells option otherwise your data and column names become whitespace-sensitive.

For the Greek characters, you can use $\csname #1 \endcsname$ syntax which makes #1 a control sequence, say $\csname alpha \endcsname becomes \alpha. (c)ontrol (s)equence name --> \csname

\documentclass{article}
\usepackage{pgfplotstable}
\usepackage{booktabs}
\pgfplotsset{compat=1.8}


\pgfplotstableread[col sep=semicolon,trim cells]{
a ; b      ;  c     ;  d   ;e      ; f     ;  g
1 ; Item 1 ;  alpha ;  m   ;1      ; 1     ;  10
2 ; Item 2 ;  beta  ;  s   ;1.0    ; 11    ;  20
3 ; Item 3 ;  gamma ;  kg  ;10.0   ; 111   ;  30
4 ; Item 4 ;  omega ;  deg ;10.00  ; 1111  ;  40
5 ; Item 5 ;  xi    ;  \%  ;10.99  ; 11111 ;  50
}\loadTestTable

\begin{document}
\begin{table}
\pgfplotstabletypeset[
    brackets/.style={%
        postproc cell content/.append style={/pgfplots/table/@cell content/.add={\relax[}{]}},
    },
    greek/.style={%
        preproc cell content/.append style={/pgfplots/table/@cell content/.add={$\csname}{\endcsname$}},
    },
    column type=r,
    columns/a/.style={string type},
    columns/b/.style={string type,column type=l},
    columns/c/.style={string type,column type=l},
    columns/d/.style={string type,column type=l},
    columns/c/.append style={greek},
    columns/d/.append style={brackets},
    fixed,
    fixed zerofill,
    precision=2,
    every head row/.style={%
        output empty row,
        before row={%
            \toprule
            No. & Item & Symbol & Unit & Column1 & Column2 & Column3\\
            },
        after row=\midrule,
        },
        every last row/.style={%
            after row=\bottomrule}]{\loadTestTable}
\end{table}
\end{document}

enter image description here

Best Answer

Related Solutions

[Tex/LaTex] Pgfplotstable without headings row

[Tex/LaTex] pgfplotstable manage strings and values

Related Question