[Tex/LaTex] Table csvreader with eleven columns

csvsimpletables

The \csvreader to build a table without a header with eleven columns does not seem to work.

\documentclass{standalone}
\usepackage{array}
\usepackage{longtable}
\usepackage{csvsimple}
\begin{filecontents*}{data.csv}
0.1,0.4,0.7,1.0,1.3,1.6,1.9,2.2,2.5,2.8,3.1,3.4
0.2,1.0,1.8,2.6,3.4,4.2,5.0,5.8,6.6,7.4,8.2,9.0
\end{filecontents*}

\begin{document}
\begin{tabular}{cccccccccccc}
    \hline
    \csvreader[no head,table head=\hline,late after line=\\\hline]{data.csv}{1=\one,2=\two,3=\three,4=\four,5=\five,6=\six,7=\seven,8=\eight,9=\nine,10=\ten,11=\eleven}
    {\thecsvrow & \one & \two & \three & \four & \five & \six & \seven & \eight & \nine & \ten & \ten & \eleven}
\end{tabular}

\end{document}

Raises the following error:

Package pgfkeys Error: I do not know the key '/csv head/11', to which you passed '\eleven ', and I am going to ignore it. Perhaps you misspelled it. ... & \eight & \nine & \ten & \ten & \eleven}

Taking out the eleventh column from the csvreader solves the problem, but is there a solution or a workaround to obtain eleven columns or more?

Best Answer

The csvsimple package assumes at most ten columns, by default, but the number is adjustable by setting the column count key.

\begin{filecontents*}{\jobname.csv}
0.1,0.4,0.7,1.0,1.3,1.6,1.9,2.2,2.5,2.8,3.1,3.4
0.2,1.0,1.8,2.6,3.4,4.2,5.0,5.8,6.6,7.4,8.2,9.0
\end{filecontents*}

\documentclass{standalone}
\usepackage{array}
\usepackage{longtable}
\usepackage{csvsimple}

\begin{document}
\begin{tabular}{cccccccccccc}
\hline
\csvreader[
  column count=11,
  no head,
  table head=\hline,
  late after line=\\\hline
]{\jobname.csv}{
  1=\one, 2=\two, 3=\three, 4=\four,
  5=\five, 6=\six, 7=\seven, 8=\eight,
  9=\nine, 10=\ten, 11=\eleven
}
{\thecsvrow & \one & \two & \three & \four & \five & \six & \seven & \eight & \nine & \ten & \eleven}
\end{tabular}

\end{document}

1. `csvsimple`:

You can simply adjust the table head to start with an \hline:

enter image description here

2. `booktabs`:

However, the booktabs package is usually recommened to produce more professional looking tables. So, I have added a second example that uses this along with the datatool package:

enter image description here

Much thanks to Nicola Talbot, who helped with proper use of booktabs here.

3. `pgfplotstable`:

A solution using pgfplotstable is provided at Bold one cell in table using CSV reader.

Notes:

Not sure why I needed the extra \\ before the \bottomrule which is producing the additional spacing at the bottom. To fix this I added a manual \vspace*{-12pt}, which is more of a hack.
It appears the the csvsimple package was discarding the last row as it did not have a trailing ,.

Code:

\documentclass{article}

\usepackage{datatool}
\usepackage{booktabs}
\usepackage{csvsimple}

% Make csv in question
%\usepackage{filecontents}
\begin{filecontents*}{scientists2.csv}
name,surname,
Albert,Einstein,
Marie,Curie,
Thomas,Edison,
\end{filecontents*}

\begin{document}

\begin{center}
    \csvreader[tabular=|l|l|,
        table head=\hline \textbf{ First Name} & \textbf{Last Name} \\\hline,
        late after line = \\\hline]%
    {scientists2.csv}{name=\name,surname=\surname}%
    {\name & \surname}%
\end{center}


\DTLloaddb{myDB}{scientists2.csv}
%\DTLdisplaydb{myDB}% Useful for debugging.

\begin{center}
\begin{tabular}{ll}\toprule
    \textbf{First Name} & \textbf{Last Name}%
    \DTLforeach*{myDB}{\Name=name,\Surname=surname}{%
        \DTLiffirstrow{\\\cmidrule{1-2}}{\\}%
        \Name & \Surname
    }%
    \\\bottomrule
\end{tabular}
\end{center}
\end{document}

[Tex/LaTex] \csvreader doesn’t show the table

As described in section 2 of the csvsimple manual, the \csvreader macro takes three mandatory arguments, while you've just added one. That is, the general format is

\csvreader[<options>]{<file name>}{<assignments>}{<command list>}

while you've just used

\csvreader[<options>]{<file name>}

(The \csvautotabular macro on the other hand, as seen in Abo Ammar's answer has just one mandatory argument, the file name.)

The arguments:

The first mandatory argument is the filename of the .csv file.
The second argument assigns macros to the content of the various columns. For example, if you had a .csv file that looked like
```
a,b
1,2
3,4
```
then you would use
```
a=\foo,b=\bar
```
in the second mandatory argument, to define the two macros \foo and \bar, referring to the a and b columns respectively.
The third argument is where you define the format of your table rows, using the macros defined in the second argument. For example
```
\bar & \foo
```
to print the b column first, and a column second.

\csvreader also has an optional argument, where you define the column types of your table (e.g. tabular=cc for two centred columns), and any other formatting you need.

A complete example below, using some bits from the example in section 3.4 of the manual. To remove the quotation marks (") from the first column output, I load the xstring package and use \StrDel{\name}{"} instead of \name in the row format. That will delete all occurrences of ".

\documentclass{article}
\usepackage{csvsimple}
\usepackage{xstring} % defines \StrDel
\usepackage{booktabs} % defines \toprule,\midrule,\bottomrule
\begin{document}
\csvreader[
  % set up the columns in the table
  tabular=ccc,
  % define the content of the first row
  table head=\toprule Name & Estimate & $\mathrm{Pr}(>\mid t)$ \\ \midrule,
  % add rule after table
  table foot=\bottomrule
 ]{coefficient.csv}% filename
{""=\name,"Estimate"=\estimate,"Pr(>|t|)"=\Pr}% define macros that refer to the columns you want to use
{\StrDel{\name}{"} & \estimate & \Pr} % format of rows

\end{document}

Best Answer

Related Solutions

[Tex/LaTex] Display top border of table using csvreader

1. csvsimple:

2. booktabs:

3. pgfplotstable: