How I can get get Null values in table using pgfplotstable?

Question

I am creating a table using pgfplotstable in LaTeX. But the problem is, I want first column of table blank. But we never leave any values, table should be balanced in pgfplotstable.I define "nan" to keep column blank. But did not work. What I should do?

pgfexample.tex

\documentclass{book}
\usepackage{pgfplotstable,booktabs}

\begin{document}
 \begin{table}[h!]
 \pgfplotstabletypeset[
  col sep = comma,
  every head row/.style={before row=\toprule,after row=\midrule},
  every last row/.style={after row=\bottomrule},
  columns/S/.style={column name={$\leq$}}
  columns/A/.style={string type,column name={$\sigma$}},
 ]
{LSDtable.csv}
\end{table}
\end{document}

LSDtable.csv

#LmitStateDesign table's data
S,A,B,C,D
nan,0.00375,360.53,0.0025,344.45
nan,0.0037,360.01,0.00245,343.42

I want first column of table blank. Suggest me something to solve problem.

read the create on use key in the manual. – percusse Jun 26 '16 at 19:17 — percusse, Jun 26 '16 at 19:17

score 1 · Accepted Answer · edited Apr 13 '17 at 12:36

1

You could just leave them blank in your csv-file. To be able to write math inside a tabular, or any non-math-environment, you need to put your math inside $math$ for inline math, and \[math\] for display math. You were really on the right track here, as you have written $\sigma$ elsewhere. Using $-signs works here too, but it is advisable in LaTeX to use $math$ and \[math\].

For more information see Are $ and $ preferable to dollar signs for math mode?

Output

Code

\documentclass{book}
\usepackage{pgfplotstable,booktabs}
\usepackage{filecontents}

\begin{filecontents*}{LSDtable.csv}
#LmitStateDesign table's data
S,A,B,C,D
\(\leq\),0.00375,360.53,0.0025,344.45
,0.0037,360.01,0.00245,343.42
\end{filecontents*}
\begin{document}

 \begin{table}[h!]
 \pgfplotstabletypeset[
  col sep = comma,
  every head row/.style={before row=\toprule,after row=\midrule},
  every last row/.style={after row=\bottomrule},
  columns/S/.style={string type,column name={}},
  columns/A/.style={string type,column name={$\sigma$}},
 ]
{LSDtable.csv}
\end{table}
\end{document}

edited Apr 13 '17 at 12:36

Community

1

answered Jun 26 '16 at 18:00

Runar

6,082

Sir, But I want to print \sigma in place of column A and \leq in place of S. – Manpreet Dhiman Jun 27 '16 at 15:39
sorry, not sure why I removed that part. I've updated my answer. – Runar Jun 27 '16 at 15:43
Sir, I want LaTeX symbol in table data. I want 1st column header blank (not 'S') and \leq symbol parallel to 0.00375 value. I am unable to do this using pgfplotstable. Suggest me good tutorial or help me. – Manpreet Dhiman Jun 27 '16 at 15:56
@ManpreetDhiman that was not in your first question, but really, no problem. See new answer. – Runar Jun 27 '16 at 16:05
Thanku so much, Runar. You solved m problem. IS parenthesis compulsary, when we want to define latex symbol in .csv? – Manpreet Dhiman Jun 27 '16 at 16:10
@ManpreetDhiman see updated answer – Runar Jun 27 '16 at 16:26
Let us continue this discussion in chat. – Manpreet Dhiman Jun 27 '16 at 16:28

How I can get get Null values in table using pgfplotstable?

1 Answers1