Table with pgfplotstable with inline data incomplete

Question

I am trying to typeset a table with inline data. The file gets compiled fine but the table only has the head row and the last row. There should be at least another row in there but it is not. I am using inline data because my attempt at read said data from an .csv resulted in a similar appearance. Oddly enough there is a longtable further down my document that reads its information from an .csv and it works splendidly. Assumed MWE:

\documentclass[a4]{article}
\usepackage{pgfplotstable}
\usepackage{tabularx}
\begin{document}
\begin{table}[H]
\pgfplotstabletypeset[
col sep=comma,
row sep=\\,
every head row/.style={before row=\hline,after row=\hline},
after row=\hline,
every last row/.style={before row=\hline, after row=\hline},
every first row/.style={before row=\hline, after row=\hline},
precision=6,
display columns/0/.style={column name=\hfill, column type={|l}, string type},
display columns/1/.style={column name=Zeit[s],column type={|c}, numeric type},
display columns/2/.style={column name=Generationen,column type={|c|}, numeric type}
]{
Median,0.2152189999999994,51\\Mittelwert,0.2171573900000003,50.83\\
}
\end{table}
\end{document}

Now, to the best my knowledge this code should produce three columns (it does) and two rows (it does not). I have already tried using examples from the documentation with no effect. So, my question would now be where is my mistake?

Answer 1

pgfplotstable assumes by default that the first row of input contains the header row of the table. You don't have that, both your rows are data rows, so you should add header=false to the pgfplotstabletypeset options.

\documentclass[a4paper]{article} % <-- just a4 wouldn't do anything I think
\usepackage{pgfplotstable}
\begin{document}
\pgfplotstabletypeset[
header=false, % <-- added
col sep=comma,
row sep=\\,
every head row/.style={before row=\hline,after row=\hline},
after row=\hline,
every last row/.style={before row=\hline, after row=\hline},
every first row/.style={before row=\hline, after row=\hline},
precision=6,
display columns/0/.style={column name=\hfill, column type={|l}, string type},
display columns/1/.style={column name=Zeit[s],column type={|c}, numeric type},
display columns/2/.style={column name=Generationen,column type={|c|}, numeric type}
]{
Median,0.2152189999999994,51\\
Mittelwert,0.2171573900000003,50.83\\
}
\end{document}

I'd consider using less lines for the table by the way, e.g.

\documentclass[a4paper]{article} % <-- just a4 wouldn't do anything I think
\usepackage{pgfplotstable}
\usepackage{booktabs}
\begin{document}
\pgfplotstabletypeset[
header=false, % <-- added
col sep=comma,
row sep=\\,
every head row/.style={before row=\toprule,after row=\midrule},
every last row/.style={after row=\bottomrule},
precision=6,
display columns/0/.style={column name=\hfill, column type={l}, string type},
display columns/1/.style={column name=Zeit[s],column type={c}, numeric type},
display columns/2/.style={column name=Generationen,column type={c}, numeric type}
]{
Median,0.2152189999999994,51\\
Mittelwert,0.2171573900000003,50.83\\
}
\end{document}