[Tex/LaTex] Multi line header for pgfplotstable

formattingpgfplotstabletables

I have a dataset in csv file format that I'm loading into pgfplotstable. I can't change the format of the original csv, and being financial data it has a column of item names and two or three explanatory data points at the top of the table. e.g.

\documentclass{article}
\usepackage{array,datatool,pgfplotstable}
  \begin{filecontents}{sample.csv}
    item,2008,2009,2010,2011
     ,Actual,Actual,Forecast,Forecast
     ,GBP,GBP,GBP,GBP
     ,('000),('000),('000),('000) rounded
    Area 1 OP, 1000000,1500000,1750000,250000
    Area 2 OP, 400000,500000, 450000,-50000
    Area 51 OP, 300000,375000,390000,15000
    No P, 1250000, 1000000, 950000, 50000
    Residuals, 800000, 80000, 90000, 10000
  \end{filecontents}

\pgfplotstableread[col sep=comma]{sample.csv}\mystuff

I'm stumped at the next stage which is to typeset \mystuff so I have comma separators and can add a row that sums the 'Area' columns. At the moment to display the table I have to do something like

\begin{document}

\pgfplotstableread[col sep=comma,header=false]{sample.csv}\mystuff

\pgfplotstabletypeset[
  columns/0/.style={string type},
  columns/1/.style={string type},
  columns/2/.style={string type},
  columns/3/.style={string type},
  columns/4/.style={string type}]\mystuff

\end{document}

How do I tag the top three rows as string and the rest of the last four columns as integer type so I can format and transform them?

Best Answer

As pgfplotstable does not yet support multiline headers, you need to format the cells on these rows specially. I couldn't get the row styles to do this for me, so ended up formatting each individual cell:

\documentclass{article}
\usepackage{array,datatool,pgfplotstable}
\pgfplotsset{compat=1.6}
  \begin{filecontents}{sample.csv}
    item,2008,2009,2010,2011
     ,Actual,Actual,Forecast,Forecast
     ,GBP,GBP,GBP,GBP
     ,('000),('000),('000),('000) rounded
    Area 1 OP, 1000000,1500000,1750000,250000
    Area 2 OP, 400000,500000, 450000,-50000
    Area 51 OP, 300000,375000,390000,15000
    No P, 1250000, 1000000, 950000, 50000
    Residuals, 800000, 80000, 90000, 10000
  \end{filecontents}

\pgfplotstableread[col sep=comma]{sample.csv}\mystuff

\begin{document}

\pgfplotstabletypeset[
fixed,
display columns/0/.style={string type},
every row 0 column 1/.style={string type},
every row 0 column 2/.style={string type},
every row 0 column 3/.style={string type},
every row 0 column 4/.style={string type},
every row 1 column 1/.style={string type},
every row 1 column 2/.style={string type},
every row 1 column 3/.style={string type},
every row 1 column 4/.style={string type},
every row 2 column 1/.style={string type},
every row 2 column 2/.style={string type},
every row 2 column 3/.style={string type},
every row 2 column 4/.style={string type}]\mystuff

\end{document}

Sample output

Note that I have specified fixed for the default cell formatting. Your original attempt could have just been styled with a singel string type rather than specifying this for each individual column.

Related Solutions

[Tex/LaTex] Multiple Multi columns with pgfplotstable

Perhaps this will get you closer to what you want.

The general syntax for the \multicolumn command is

\multicolumn{<number of columns to span>}{<alignment>}{<content>}

You do not specify which columns it spans, just the number of columns to span. As such, the total number of columns spanned and otherwise used needs to be consistent throughout the table. So, because you wanted 14 columns, you need all of the 2s and other columns to add up to 14.

Note that the code below results in a very Overfull hbox and runs off the page- there are a few ugly ways to fix this, such as changing the font size, or perhaps putting it in a resizebox, but perhaps the best way would be to chop the table into 2; of course, that's up to you.

\documentclass{article}

\usepackage{geometry}
\usepackage{booktabs}
\usepackage{pgfplotstable}

\begin{document}

\noindent\pgfplotstabletypeset[
 every head row/.style={%
     before row={\toprule%
   NM  & NM 
       &\multicolumn{2}{c}{32-2 LS}
       &\multicolumn{2}{c}{128-4 LS}
       &\multicolumn{2}{c}{256-8 LS}
       &\multicolumn{2}{c}{32-4}
       &\multicolumn{2}{c}{128-4}
       &\multicolumn{2}{c}{256-8}\\\midrule},
    },
  every last row/.style={after row=\bottomrule},
  string type,
]
{
%sample data
bur26a   26 94.6513 0.9995 145.6622 0.9999 202.7375 1.0000 1.4381 0.9707 2.0208 0.9770 2.9439 0.9786
chr25a   25 84.5684 0.8296 131.5305 0.8881 183.0491 0.9012 1.4192 0.3110 1.9670 0.3369 2.8968 0.3530
}

\end{document}

Following the comments, and the updated MWE in the comments

\documentclass{article}
\usepackage{pgfplotstable}
\usepackage{booktabs}
\usepackage[paperwidth=50cm,paperheight=5cm]{geometry}

\begin{document}

\noindent\pgfplotstabletypeset[
 every head row/.style={%
     before row={\toprule%
     & 
     & \multicolumn{2}{c}{time avg}
     & \multicolumn{2}{c}{quality avg}
     & \multicolumn{2}{c}{quality avg}
     & \multicolumn{2}{c}{quality avg}
     & \multicolumn{2}{c}{quality avg}
     & \multicolumn{2}{c}{quality avg}\\
   NM  & NM 
       &\multicolumn{2}{c}{32-2 LS}
       &\multicolumn{2}{c}{128-4 LS}
       &\multicolumn{2}{c}{256-8 LS}
       &\multicolumn{2}{c}{32-4}
       &\multicolumn{2}{c}{128-4}
       &\multicolumn{2}{c}{256-8}\\\midrule},
    },
  every last row/.style={after row=\bottomrule},
  string type,
]
{
%sample data
bur26a   26 94.6513 0.9995 145.6622 0.9999 202.7375 1.0000 1.4381 0.9707 2.0208 0.9770 2.9439 0.9786
chr25a   25 84.5684 0.8296 131.5305 0.8881 183.0491 0.9012 1.4192 0.3110 1.9670 0.3369 2.8968 0.3530
}

\end{document}

[Tex/LaTex] Pgfplotstable header in bold

I know this post is old but I just figured this out and was too excited not to share...

Pertaining to your first question about bold headers I can offer the following. Before typesetting the table, specify bold font in the column type using

column type={>{\fontseries{bx}\selectfont}c} %see sec 2.6 for defining column types

This should set all entries in your table to bold font. To leave only the headers bold, you can then post-process every cell's content using

postproc cell content/.append style={ % see sec 3.2
/pgfplots/table/@cell content/.add={\fontseries{\seriesdefault}\selectfont}{}}

This works because the second block of code does not apply to header cells, so we can first set everything bold, then reset the other (non-header) cells to normal font. See the sections in comments in the pgfplotstable manual for more information.

Here is a MWE

\documentclass{article}
\usepackage{pgfplotstable}

\begin{document}

\pgfplotstableset{% set global options
format=inline,
string type,
col sep={&}, row sep={\\},
column type={>{\fontseries{bx}\selectfont\centering\arraybackslash}c},
every head row/.style={after row=\hline},
postproc cell content/.append style={
/pgfplots/table/@cell content/.add={\fontseries{\seriesdefault}\selectfont}{}}
}

\pgfplotstabletypeset{% The input table
H1&H2&H3 \\
data1&data2&data3 \\
moredata1&moredata2&moredata3 \\
}

\end{document}

MWE

EDIT:

Here is the code embedded in your formatted table. I commented out the every col no <index>/.style and replaced that block simply with column type={<options>}. This allows you to specify column type for every column. Since you wanted a different specification for the first and last columns, you must manually specify those.

\documentclass{article}
\usepackage{pgfplotstable}
\usepackage{booktabs,colortbl}
\begin{document}
\def\tableborder{1.5pt}

% global settings
\pgfplotstableset{
after row={\hline},
every head row/.style={
before row={
\rowcolor{lightgray}
\noalign{\hrule height \tableborder}
},
after row={
\hline
},
},
every last row/.style={
after row=\noalign{\hrule height \tableborder}
},
col sep = &,
row sep=\\,
% column type/.add={}{\vrule width \tableborder},
%every col no 1/.style={ column type/.add={|}{} },
%every col no 2/.style={ column type/.add={|}{} },
%every col no 3/.style={ column type/.add={|}{} },
%every col no 4/.style={ column type/.add={|}{} },
%every col no 5/.style={ column type/.add={|}{} },
column type={|>{\fontseries{bx}\selectfont}c},
every first column/.style={
column type={!{\vrule width \tableborder}>{\fontseries{bx}\selectfont}c} % removed /.add so you can replace the format rather than append to it.
},
every last column/.style={
column type/.add={}{!{\vrule width \tableborder}}
},
string type,
postproc cell content/.append style={
/pgfplots/table/@cell content/.add={\fontseries{\seriesdefault}\selectfont}{}
}
}


\pgfplotstabletypeset{
person & singEnglish & singGaeilge & pluralEnglish & pluralGaeilge\\
1st & at me & agam & at us & againn\\
2st & at you & agat & at you & agaibh\\
3st & at him & aige & at them & acu\\
& at her & aici & &\\
}
\end{document}

mwe_table_edit

Best Answer

Related Solutions

[Tex/LaTex] Multiple Multi columns with pgfplotstable

[Tex/LaTex] Pgfplotstable header in bold

Related Question