[Tex/LaTex] Loading data to fill a table from a csv file with multicolumn header

csvsimpleformattingtables

I'm trying to create a table that looks like this .

Currently I'm doing this …

\begin{table}[ht!]
    \centering
    \begin{tabular}{|l|l|l|l|l|l|l|l|l|l|}
        \hline
        \multicolumn{1}{|c|}{\textbf{Patch}} & \multicolumn{3}{c|}{\textbf{ACES RGB}} & \multicolumn{3}{c|}{\textbf{Display RGB}} & \multicolumn{3}{c|}{\textbf{Display xyY}} \\ \hline
        \textbf{N1} & 1.8233 & 1.8233 & 1.8233 & 0.9243 & 0.8651 & 0.9013 & 0.3217 & 0.3377 & 34.4858 \\ \hline
        \textbf{N2} & 0.2753 & 0.2753 & 0.2753 & 0.5383 & 0.5038 & 0.5249 & 0.3217 & 0.3377 & 8.4552  \\ \hline
        \textbf{N3} & 0.0898 & 0.0898 & 0.0898 & 0.2804 & 0.2625 & 0.2734 & 0.3217 & 0.3377 & 1.5514  \\ \hline
        \textbf{R}  & 0.4689 & 0.1193 & 0.0417 & 0.8046 & 0.2227 & 0.1795 & 0.6413 & 0.3307 & 6.4488  \\ \hline
        \textbf{G}  & 0.339  & 0.8068 & 0.0936 & 0.4335 & 0.8036 & 0.2434 & 0.3046 & 0.624  & 20.8422 \\ \hline
        \textbf{B}  & 0.2162 & 0.133  & 0.8711 & 0.1707 & 0.1503 & 0.8215 & 0.1562 & 0.0692 & 2.3365  \\ \hline
        \textbf{C}  & 0.5187 & 0.9138 & 1.0432 & 0.4332 & 0.8028 & 0.8406 & 0.2269 & 0.3404 & 22.8164 \\ \hline
        \textbf{M}  & 0.58   & 0.2096 & 0.9086 & 0.808  & 0.2134 & 0.8294 & 0.333  & 0.1596 & 8.4349  \\ \hline
        \textbf{Y}  & 0.8237 & 0.9378 & 0.0855 & 0.8654 & 0.8096 & 0.2487 & 0.4338 & 0.5187 & 26.9923 \\ \hline
    \end{tabular}
\end{table}

I have many tables to create that all contain the same number and titled rows and columns (e.g. the bold stuff in the example above is the same for all tables). Unfortunately, building each table is tedious.

I'm trying to figure out how I can use csvsimple to load the variable values in the table from a .csv file, but I can't seem to figure out how to the multicolumn and header rows to work.

I'm thinking each csv file would be formatted like this:

1.8233,1.8233,1.8233,0.9243,0.8651,0.9013,0.3217,0.3377,34.4858
0.2753,0.2753,0.2753,0.5383,0.5038,0.5249,0.3217,0.3377,8.4552
0.0898,0.0898,0.0898,0.2804,0.2625,0.2734,0.3217,0.3377,1.5514
0.4689,0.1193,0.0417,0.8046,0.2227,0.1795,0.6413,0.3307,6.4488
0.339,0.8068,0.0936,0.4335,0.8036,0.2434,0.3046,0.624,20.8422
0.2162,0.133,0.8711,0.1707,0.1503,0.8215,0.1562,0.0692,2.3365
0.5187,0.9138,1.0432,0.4332,0.8028,0.8406,0.2269,0.3404,22.8164
0.58,0.2096,0.9086,0.808,0.2134,0.8294,0.333,0.1596,8.4349
0.8237,0.9378,0.0855,0.8654,0.8096,0.2487,0.4338,0.5187,26.9923

Best Answer

The first solution is with booktabs and without vertical rules (I think the table looks better this way); the second one is like the OP's image.

Edit: I've added a third example which doesn't use siunitx, to show the difference to the OP.

\documentclass{article}
\usepackage{siunitx}
\usepackage{array}
\usepackage{booktabs}
\usepackage{csvsimple}
\usepackage{caption}

\begin{filecontents*}{mydata.csv}
    1.8233,1.8233,1.8233,0.9243,0.8651,0.9013,0.3217,0.3377,34.4858
    0.2753,0.2753,0.2753,0.5383,0.5038,0.5249,0.3217,0.3377,8.4552
    0.0898,0.0898,0.0898,0.2804,0.2625,0.2734,0.3217,0.3377,1.5514
    0.4689,0.1193,0.0417,0.8046,0.2227,0.1795,0.6413,0.3307,6.4488
    0.339,0.8068,0.0936,0.4335,0.8036,0.2434,0.3046,0.624,20.8422
    0.2162,0.133,0.8711,0.1707,0.1503,0.8215,0.1562,0.0692,2.3365
    0.5187,0.9138,1.0432,0.4332,0.8028,0.8406,0.2269,0.3404,22.8164
    0.58,0.2096,0.9086,0.808,0.2134,0.8294,0.333,0.1596,8.4349
    0.8237,0.9378,0.0855,0.8654,0.8096,0.2487,0.4338,0.5187,26.9923 
\end{filecontents*}

\begin{document}
    \begin{table}[ht!]
        \caption{The best}
        \centering\tiny\renewcommand*{\arraystretch}{1.4} 
        \begin{tabular}{>{\bfseries\arraybackslash}c}
            \toprule
            Patch\\\cmidrule(lr){1-1}
            N1\\ N2\\ N3\\ R\\ G\\ B\\ C\\ M\\ Y\\ 
            \bottomrule
        \end{tabular}%
        \csvloop{file=mydata.csv, no head, 
            before reading=\centering%\sisetup{table-number-alignment=center}
            ,
            tabular={c@{}*8{S[table-format=1.4]}S[table-format=2.4]},
            table head=\toprule & \multicolumn{3}{c}{\textbf{ACES RGB}} & \multicolumn{3}{c}{\textbf{Display RGB}} & \multicolumn{3}{c}{\textbf{Display xyY}}\\
            \cmidrule(lr){1-4} \cmidrule(lr){5-7} \cmidrule(lr){8-10}, command=&\csvcoli & \csvcolii & \csvcoliii & \csvcoliv & \csvcolv & \csvcolvi & \csvcolvii & \csvcolviii & \csvcolix, table foot=\bottomrule}
    \end{table}

    \begin{table}[ht!]
        \caption{The not-so-beautiful}
        \centering\tiny\renewcommand*{\arraystretch}{2}
        \begin{tabular}{|>{\bfseries\arraybackslash}c|}
            \hline
            Patch\\\hline
            N1\\\hline N2\\\hline N3\\\hline 
            R\\\hline G\\\hline B\\\hline
            C\\\hline M\\\hline Y\\\hline
        \end{tabular}%
        \csvloop{file=mydata.csv, no head, 
            before reading=\centering%\sisetup{table-number-alignment=center}
            ,
            tabular={c@{}*8{S[table-format=1.4]|}S[table-format=2.4]|},
            table head=\hline & \multicolumn{3}{c|}{\textbf{ACES RGB}} & \multicolumn{3}{c|}{\textbf{Display RGB}} & \multicolumn{3}{c|}{\textbf{Display xyY}}\\
            \hline, 
            command=&\csvcoli & \csvcolii & \csvcoliii & \csvcoliv & \csvcolv & \csvcolvi & \csvcolvii & \csvcolviii & \csvcolix,
            late after line=\\\hline}
    \end{table}

    \begin{table}[ht!]
        \caption{The ugly}
        \centering\tiny\renewcommand*{\arraystretch}{2}
        \begin{tabular}{|>{\bfseries\arraybackslash}c|}
            \hline
            Patch\\\hline
            N1\\\hline N2\\\hline N3\\\hline 
            R\\\hline G\\\hline B\\\hline
            C\\\hline M\\\hline Y\\\hline
        \end{tabular}%
        \csvloop{file=mydata.csv, no head, 
            tabular={*9{l|}},
            table head=\hline \multicolumn{3}{c|}{\textbf{ACES RGB}} & \multicolumn{3}{c|}{\textbf{Display RGB}} & \multicolumn{3}{c|}{\textbf{Display xyY}}\\
            \hline, 
            command=\csvcoli & \csvcolii & \csvcoliii & \csvcoliv & \csvcolv & \csvcolvi & \csvcolvii & \csvcolviii & \csvcolix,
            late after line=\\\hline}
    \end{table}
\end{document}

Related Solutions

[Tex/LaTex] Creating a multi-column table with dynamically wide columns from a CSV file

If you are prepared to use pgfplotstable then this can be done. It contains a construct to divide columns in to equal parts to simulate multicolumn tables, namely select equal part entry of. Dividing in to two columns is achieved with the first column being given style select equal part entry of={0}{2} and the second select equal part entry of={1}{2}.

You set up a tabularx output with the options

 begin table=\begin{tabularx}{\textwidth},
 end table=\end{tabularx}

to \pgfplotstabletypeset, and then the combination

  columns={Name,Number,XXX,Name,Number,XXX},
  display columns/0/.style={select equal part entry of={0}{2},column type=|c},
  display columns/1/.style={select equal part entry of={0}{2}},
  display columns/2/.style={column type=X|},
  display columns/3/.style={select equal part entry of={1}{2},column type=c},
  display columns/4/.style={select equal part entry of={1}{2}},
  display columns/5/.style={column type=X|}

provides the divided columns with the appropriate formatting. The empty XXX columns are generated by

create on use/XXX/.style={create col/set={}}

You need to specify your data as being comma separated and of string type via

col sep=comma,string type

Finally in the example below I have thrown away the headers and added horizontal rules corresponding to your question.

Sample output

\documentclass[a4paper]{article}

\usepackage{lmodern,pgfplotstable,tabularx}
\pgfplotsset{compat=1.12}

\begin{filecontents*}{data.csv}
Name,Number
name1,nr1
name2,nr2
name3,nr3
name4,nr4
name5,nr5
name6,nr6
name7,nr7
name8,nr8
name9,nr9
name10,nr10
name11,nr11
name12,nr12
name13,nr13
name14,nr14
name15,nr15
name16,nr16
name17,nr17
name18,nr18
name19,nr19
name20,nr20
name21,nr21
name22,nr22
name23,nr23
name24,nr24
name25,nr25
name26,nr26
name27,nr27
name28,nr28
name29,nr29
name30,nr30
name31,nr31
name32,nr32
name33,nr33
name34,nr34
name35,nr35
name36,nr36
name37,nr37
name38,nr38
name39,nr39
name40,nr40
name41,nr41
name42,nr42
name43,nr43
name44,nr44
name45,nr45
name46,nr46
name47,nr47
name48,nr48
name49,nr49
name50,nr50
name51,nr51
name52,nr52
name53,nr53
name54,nr54
name55,nr55
name56,nr56
name57,nr57
name58,nr58
name59,nr59
name60,nr60
\end{filecontents*}

\begin{document}

\pgfplotstableset{create on use/XXX/.style={create col/set={}}}%
\noindent
\pgfplotstabletypeset[col sep=comma,string type,
  begin table=\begin{tabularx}{\textwidth},
  end table=\end{tabularx},
  every head row/.style={output empty row,after row=\hline},
  every last row/.style={after row=\hline},
  columns={Name,Number,XXX,Name,Number,XXX},
  display columns/0/.style={select equal part entry of={0}{2},column type=|c},
  display columns/1/.style={select equal part entry of={0}{2}},
  display columns/2/.style={column type=X|},
  display columns/3/.style={select equal part entry of={1}{2},column type=c},
  display columns/4/.style={select equal part entry of={1}{2}},
  display columns/5/.style={column type=X|}
]{data.csv}

\end{document}

[Tex/LaTex] Simple import of data with special characters for table

Your question is quite general and such not easy to answer. But, if I understand you right, you want to use special characters in your table head and you want to read them from your csv file.

The \csvautotabular macro is intended for quick survey only and not for productive tables, since it is quite restricted. \csvreader or \csvloop are indented for normal usage.

To use the first line of a csv file as normal data line, you have to say no head and also to give column count since this first line is not read as pattern. Then, this line can be used as data line.

Still, there is and will be an important restriction: A line is not allowed to start with a backslash \.

Now, here comes an example:

\begin{filecontents*}{test3.csv}
Wei\ss{}b\"ack,\textbf{bold},c
2,2,8
3,6,9
\end{filecontents*}

\documentclass{letter}

\usepackage[utf8]{inputenc}
\usepackage{csvsimple}

\begin{document}

\csvloop{
  file=test3.csv,
  no head,              % no special treatment of first line
  column count=3,       % since no first line is given, tell about column count
  before reading=\begin{tabular}{|l|l|l|}\hline,
  command=\csvlinetotablerow,
  late after line=\\,
  late after first line=\\\hline,
  late after last line=\\\hline,
  after reading=\end{tabular}
}

\end{document}

enter image description here

Best Answer

Related Solutions

[Tex/LaTex] Creating a multi-column table with dynamically wide columns from a CSV file

[Tex/LaTex] Simple import of data with special characters for table

Related Question