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

csvsimpletables

I am using csvreader from the csvsimple package to generate a table in my document. I am struggling to get a top border on the table. Here is the code, including writing the .csv

\documentclass{article}
\usepackage{csvsimple}

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

\begin{document}

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

\end{center}


\end{document}

What argument can I pass (to tabular?) to see the top border? I am using TexWorks to compile. Thanks,

Best Answer

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}

Related Solutions

[Tex/LaTex] Table csvreader with eleven columns

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}

[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

1. csvsimple:

2. booktabs:

3. pgfplotstable: